Merge thows exception after DeleteRow, with fix

The attached sample demonstrates the problem with Mergin cells after deleting rows. The problem is in ExcelWorksheet.cs function: internal void Clear(ExcelAddressBase Destination) My fix recomen...

Id #15606 | Release: None | Updated: Fri at 1:36 PM by Daniel01Heden | Created: Fri at 1:36 PM by Daniel01Heden

Cannot re-save due to Formula Length Longer than 8192 characters

I've created a spreadsheet using EPPlus. It opens fine (I use Excel 2016), but when I try to save it I get the error message: "One or more formulas in this workbook are longer than the allowed li...

Id #15605 | Release: None | Updated: Apr 12 at 4:39 PM by ianthomas_uk | Created: Apr 12 at 3:02 PM by ianthomas_uk

Excel corrupts after open and save a xlsx document with a pivot table

When I open an existing .xlsx document with a pivot table and then save it, it courrupts. It gives me error saying the file is corrupt. After repairing the file, Excel lists the following issues:...

Id #15604 | Release: None | Updated: Apr 5 at 8:01 PM by ricardok1 | Created: Apr 4 at 10:31 AM by andresperezzabala

References damaged after save

Attached xlsx file is very simple. in Sheet1 there are two values (cell A2 = 1, cell A3 = 1). In Sheet2 there is a sum of referenced values ("=SUM(Sheet1!A2:Sheet1:A3"). After update via EPPlus, I ...

Id #15603 | Release: None | Updated: Apr 3 at 1:24 PM by vojtek11 | Created: Apr 3 at 1:24 PM by vojtek11

Error saving when pivot table uses named range that has workbook scope

When I save a spreadsheet that has a pivot table that uses a named range that has workbook scope I get an error in ExcelWorksheet.savePivotTables(). var ws = Workbook.Worksheets[pt.CacheDefinition....

Id #15602 | Release: None | Updated: Mar 30 at 1:21 PM by LozzaDude | Created: Mar 30 at 1:21 PM by LozzaDude

System.Collections.Generic.KeyNotFoundException

We have found the issue "System.Collections.Generic.KeyNotFoundException" issue's solution. This exception were thrown when someone try to upload blank value when email(hyperlink) is expected. I...

Id #15601 | Release: None | Updated: Mar 30 at 11:52 AM by naginraychura | Created: Mar 30 at 11:52 AM by naginraychura

Hide view ruler

Hi, I'm able to hide the headers / gridlines (ws.View.ShowHeaders = false;), but I can't find a way to hide the ruler. Is there a function that supports that? Thanks !

Id #15600 | Release: None | Updated: Mar 29 at 4:02 PM by mo7 | Created: Mar 29 at 4:02 PM by mo7

Save as XLSB and XLS Format

Please add the option to save in XLSB and old XLS format.

Id #15599 | Release: None | Updated: Apr 2 at 6:56 PM by richardtallent | Created: Mar 28 at 7:49 AM by ashikiqbal

Merged cells are not read from worksheet

I have a file where the merged cells were not being recognized in two of the worksheets. It looks like EPPlus makes some assumptions about the order of the elements in order to quickly read throu...

Id #15598 | Release: None | Updated: Mar 24 at 4:22 PM by tslagter | Created: Mar 24 at 4:22 PM by tslagter

EPPlus IIS Application Pool Identity: NetworkService

** Security Issue ** When the IIS Application Pool Identity is set to NetworkService, EPPlus 4.1 throws System.IO.IsolatedStorageException: Unable to create mutex. (Exception from HRESULT: 0x8013...

Id #15597 | Release: None | Updated: Mar 22 at 2:21 PM by roysoliver | Created: Mar 22 at 1:37 PM by roysoliver