insert row and update formula reference

When there are rows with links to other worksheet in formula, the updated formula is wrong. This because in UpdateFormulaReferences is made a.AddRow( without a preliminary search of internal or ext...

Id #15335 | Release: None | Updated: Fri at 4:42 PM by benjinato | Created: Fri at 4:42 PM by benjinato

WORKDAY formula with negative number of days added

I have a formula to find the date two workdays ago. =WORKDAY(TODAY(); -2) For today (2015-08-27) it returns 2015-08-25 in Excel But when i calculate with EPPLUS it returns 2015-08-27 It return...

Id #15334 | Release: None | Updated: Thu at 12:13 PM by claus_erik | Created: Thu at 12:13 PM by claus_erik

Renaming a sheet does not update cross-sheet references (sample code + steps to reproduce)

Renaming a worksheet does not appear to update cell references to the renamed sheet. In the code below (a modified version of the "Sample 1" EPPlus sample code), the reference in cell C4 to Inv...

Id #15333 | Release: None | Updated: Wed at 2:38 PM by zippy1981 | Created: Mon at 10:56 PM by emdelaney

Out Of Memory

Hi I have a excel file with one sheet that has 50 columns and 200 000 records. When I try to load this on a 32 bit machine, it gives OutOfMemory exception either while loading or during saving. ...

Id #15332 | Release: None | Updated: Wed at 2:47 PM by zippy1981 | Created: Aug 20 at 6:37 AM by sanketpattekar

ExcelRangeBase constructor issues

The following values are hard coded in ExcelRangBase at constuction time internal protected string _ws; protected ExcelWorksheet _worksheet; internal ExcelWorkbook _workbook = null; If a worksh...

Id #15331 | Release: None | Updated: Aug 18 at 10:49 PM by zippy1981 | Created: Aug 18 at 10:49 PM by zippy1981

Remove StyleTest.cs or readd to the test csproj?

This file is not attached to the visual studio project. Should it be removed?

Id #15330 | Release: None | Updated: Aug 18 at 6:02 PM by zippy1981 | Created: Aug 18 at 6:02 PM by zippy1981

InsertColumn(int, int, int) only copies style from first cell in v4.0.4

Hello, the method InsertColumn(int, int, int) only copies style (background-color, border etc) from first cell. That means, that if you insert a new column, the colors from the first cell are app...

Id #15329 | Release: None | Updated: Aug 21 at 6:41 AM by Akul | Created: Aug 18 at 1:12 PM by Kasjan

issue with format column while reading XLSX file using epplus

Hello, I am reading the XLSX file using epplus . Everything works fine but if the excel column is having the format like "#,##0.00;(#,##0.00)" then it is reading the value wrongly. Assume that th...

Id #15328 | Release: None | Updated: Aug 17 at 12:00 PM by neoravi1978 | Created: Aug 17 at 12:00 PM by neoravi1978

Worksheet cannot be opened due to bug in Worksheet.CreateXml

There's a bug in Worksheet.CreateXml. It fails to open a perfectly fine Excel file. I unpacked the file and validated sheet1.xml; it's valid. Excel opens the file without error. Exception info:...

Id #15327 | Release: None | Updated: Aug 14 at 5:51 PM by xor88 | Created: Aug 14 at 5:23 PM by xor88

Format Pivot RowField

I'm generating a pivot table for an invoice where the Unit Price is one of the RowFields on which I subtotal quantities and extended amounts. I can find no way to format the RowField as Currency.

Id #15326 | Release: None | Updated: Aug 13 at 8:29 PM by wtfinc | Created: Aug 13 at 8:29 PM by wtfinc