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:
| Updated: Fri at 4:42 PM by benjinato | Created: Fri at 4:42 PM by benjinato
I have a formula to find the date two workdays ago.
For today (2015-08-27) it returns 2015-08-25 in Excel
But when i calculate with EPPLUS it returns 2015-08-27
Id #15334 | Release:
| Updated: Thu at 12:13 PM by claus_erik | Created: Thu at 12:13 PM by claus_erik
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:
| Updated: Wed at 2:38 PM by zippy1981 | Created: Mon at 10:56 PM by emdelaney
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:
| Updated: Wed at 2:47 PM by zippy1981 | Created: Aug 20 at 6:37 AM by sanketpattekar
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:
| Updated: Aug 18 at 10:49 PM by zippy1981 | Created: Aug 18 at 10:49 PM by zippy1981
This file is not attached to the visual studio project. Should it be removed?
Id #15330 | Release:
| Updated: Aug 18 at 6:02 PM by zippy1981 | Created: Aug 18 at 6:02 PM by zippy1981
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:
| Updated: Aug 21 at 6:41 AM by Akul | Created: Aug 18 at 1:12 PM by Kasjan
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:
| Updated: Aug 17 at 12:00 PM by neoravi1978 | Created: Aug 17 at 12:00 PM by neoravi1978
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.
Id #15327 | Release:
| Updated: Aug 14 at 5:51 PM by xor88 | Created: Aug 14 at 5:23 PM by xor88
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:
| Updated: Aug 13 at 8:29 PM by wtfinc | Created: Aug 13 at 8:29 PM by wtfinc