Loading CSV files using LoadFromText does not evaluate Excel formulas contained in the CSV files. Not even simple ones like simple booleans (TRUE, FALSE).
See also this SO posting: https://stacko...
Id #15424 | Release:
| Updated: Wed at 12:10 PM by rubicon_dominik | Created: Wed at 12:10 PM by rubicon_dominik
After running this code:
static void Main(string args)
using (var pck = new ExcelPackage())
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Sheet1");
Id #15423 | Release:
| Updated: Mon at 6:20 PM by dmiser | Created: Mon at 6:20 PM by dmiser
I have noticed that when I display or set the values for a column width there is a 0.71 value difference from what gets displayed in the Excel UI.
So if the Excel UI says that a column has a widt...
Id #15422 | Release:
| Updated: Feb 5 at 9:59 PM by nickdmax | Created: Feb 5 at 9:58 PM by nickdmax
There is an issue with saving a workbook which contains a Pivot Table based on a Named Range.
Please find attached three workbooks which suffer from this issue. To replicate the issue, just open o...
Id #15421 | Release:
| Updated: Feb 5 at 1:56 PM by lolsoft | Created: Feb 5 at 1:56 PM by lolsoft
The method "Remove" for DataValidations of a WorkSheet is not working and is throwing an exception that node is not a child node.
I think the issue is that following code:
Id #15420 | Release:
| Updated: Feb 5 at 8:47 AM by ZTHawk | Created: Feb 5 at 8:47 AM by ZTHawk
I have a sheet contains 2 column No and Name. Name has comment in each cell
I insert new column between 2 cols above. Everything is perfect, all data, styles moved but comment not :(
Id #15419 | Release:
| Updated: Feb 3 at 3:54 AM by dieuchinhlu | Created: Feb 3 at 3:53 AM by dieuchinhlu
I am trying to open the attached xlsx with EPPlus like so:
Dim iFile As New FileInfo(xlsxFilePath)
pkg2 = New OfficeOpenXml.ExcelPackage(iFile)
It doesn't fail, but after it executes pkg2.Workbook...
Id #15418 | Release:
| Updated: Feb 2 at 8:07 PM by jturk9 | Created: Feb 2 at 5:15 PM by jturk9
When i try to open .xlsx file i'm getting fallowing error
Can not open the package. Package is an OLE compound document. If this is an encrypted package, please supply the password
Id #15417 | Release:
| Updated: Feb 2 at 11:39 AM by rambabuk1222 | Created: Feb 2 at 11:39 AM by rambabuk1222
Generating the following excel file cause Excel to ignore the formula. The excel file generated with EPPlus contains a formula summing elements if a condition is met. I'm using EPPlus 4.0.5 install...
Id #15416 | Release:
| Updated: Feb 1 at 8:58 AM by ancailliau | Created: Feb 1 at 8:58 AM by ancailliau
Spend a couple of minutes on it but could not find why PageIndex.MinIndex would throw a "object reference not set to an instance of an object" exception.
To (succesfully) work around it I added ...
Id #15415 | Release:
| Updated: Jan 29 at 12:28 PM by knippers | Created: Jan 29 at 12:28 PM by knippers