ExcelAddress has "" for WorkSheet

The public ExcelAddress(int fromRow, int fromCol, int toRow, int toColumn); constructor causes the non-public WorkSheet prooperty (and _ws variable) to be set to "" instead of null. This causes my...

Id #15503 | Release: None | Updated: Fri at 10:40 PM by Trisped | Created: Fri at 12:58 AM by Trisped

ExcelHeaderFooter.ScaleWithDoc property missing in EPPlus 4.1.0

The ExcelHeaderFooter.ScaleWithDoc property is missing in EPPlus 4.1.0. It is implemented in EPPlus 3. I have implemented this extension method in my code as a workaround: public static void Set...

Id #15502 | Release: None | Updated: Thu at 8:19 AM by moftedal | Created: Thu at 8:17 AM by janfredrik

Arrays are not handled correctly by logical operators and some functions.

It seems that certain functions in EPPlus don't deal with arrays the same way as Excel. In some cases the comparisons return the wrong value, and in others #VALUE errors are returned. See below f...

Id #15501 | Release: None | Updated: Wed at 8:27 PM by maxa | Created: Wed at 7:57 PM by maxa

Shared Formula exceptions configured in Excel are overwritten when splitting Shared Formulas in EP Plus.

In Excel, a shared formula is defined over a range of cells. If one of those cells' formulas is overwritten with some other formula, the original shared formula range remains intact but that cell h...

Id #15500 | Release: None | Updated: Tue at 4:06 PM by zpffpz | Created: Tue at 4:04 PM by zpffpz

Error creating excel from a template with PivotTable

I'm using an excel template which contains a pivottable and what I do is add rows to the data source is a table but in the result generates an error. the data source is a table but the result adds ...

Id #15499 | Release: None | Updated: Tue at 1:38 PM by AngelLittle | Created: Tue at 1:38 PM by AngelLittle

FormulaR1C1 parser messing with formula

Test case: //_ws is some worksheet. var deptColumn = 59; var startRow = 5; var k = 5; var i = 70; var formulaStr = $@"=SUMIF(R5C{deptColumn}:R{i + startRow}C{deptColumn};""="" & RC{deptColum...

Id #15498 | Release: None | Updated: Mon at 12:48 PM by Szer | Created: Mon at 12:48 PM by Szer

Removed Records: Named range from /xl/workbook.xml part (Workbook)

Hello, I am trying to edit an existing xlsx file that contains many pictures, named ranges, worksheets, and formatting. I perform the following code: FileInfo newFile = new FileInfo("C:/test.xlsx"...

Id #15497 | Release: None | Updated: Jul 21 at 12:12 PM by swmal | Created: Jul 20 at 2:08 PM by Dillydill123

Can't save different formulas in the same column of a table

If you create a table and in the same column you use a different formula on different rows, when you save the sheet, the formulas will all reflect the first row's formula. In the attached spreads...

Id #15496 | Release: None | Updated: Jul 19 at 10:25 PM by kilkfoe | Created: Jul 19 at 10:25 PM by kilkfoe

ExcelDrawing.SetPosition(int Row, int RowOffsetPixels, int Column, int ColumnOffsetPixels) Broken with release 4.1.0

Discovered while anchoring an ExcelPicture to a specific row and column. This works fine in 4.0.5 but with release 4.1.0 SetPosition() does not seem to honor the column parameter, instead everythi...

Id #15495 | Release: None | Updated: Jul 21 at 12:28 PM by swmal | Created: Jul 19 at 12:21 PM by ChrisLockwood

Multi-threaded zip compression never used

When I deep dive into saving process to improve performance, I found multi-threaded zip compression is never used. DotNetZip supports multi-threaded compression, and default enabled in ZipFil...

Id #15493 | Release: None | Updated: Jul 16 at 6:37 AM by kazy111 | Created: Jul 16 at 6:33 AM by kazy111