LoadFromText does not evaluate formulas

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: None | Updated: Wed at 12:10 PM by rubicon_dominik | Created: Wed at 12:10 PM by rubicon_dominik

Export blank cell from CSV import causing issues

After running this code: class Program { static void Main(string[] args) { using (var pck = new ExcelPackage()) { ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Sheet1"); ...

Id #15423 | Release: None | Updated: Mon at 6:20 PM by dmiser | Created: Mon at 6:20 PM by dmiser

Width off by 0.71 from Excel UI

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: None | Updated: Feb 5 at 9:59 PM by nickdmax | Created: Feb 5 at 9:58 PM by nickdmax

Pivot Table based on a Named Range

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: None | Updated: Feb 5 at 1:56 PM by lolsoft | Created: Feb 5 at 1:56 PM by lolsoft

DataValidations "Remove" not working and not clearing count

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: TopNode.RemoveChild(((E...

Id #15420 | Release: None | Updated: Feb 5 at 8:47 AM by ZTHawk | Created: Feb 5 at 8:47 AM by ZTHawk

When insert new column - Comments are not moved

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: None | Updated: Feb 3 at 3:54 AM by dieuchinhlu | Created: Feb 3 at 3:53 AM by dieuchinhlu

EPPlus not opening my xlsx

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: None | Updated: Feb 2 at 8:07 PM by jturk9 | Created: Feb 2 at 5:15 PM by jturk9

Can not open the package.

Hi, 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 Fallo...

Id #15417 | Release: None | Updated: Feb 2 at 11:39 AM by rambabuk1222 | Created: Feb 2 at 11:39 AM by rambabuk1222

Array formula in EPPLUS

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: None | Updated: Feb 1 at 8:58 AM by ancailliau | Created: Feb 1 at 8:58 AM by ancailliau

PageIndex.MinIndex is throwing NullReference exception

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: None | Updated: Jan 29 at 12:28 PM by knippers | Created: Jan 29 at 12:28 PM by knippers