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:
| Updated: Fri at 1:36 PM by Daniel01Heden | Created: Fri at 1:36 PM by Daniel01Heden
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:
| Updated: Apr 12 at 4:39 PM by ianthomas_uk | Created: Apr 12 at 3:02 PM by ianthomas_uk
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:
| Updated: Apr 5 at 8:01 PM by ricardok1 | Created: Apr 4 at 10:31 AM by andresperezzabala
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:
| Updated: Apr 3 at 1:24 PM by vojtek11 | Created: Apr 3 at 1:24 PM by vojtek11
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:
| Updated: Mar 30 at 1:21 PM by LozzaDude | Created: Mar 30 at 1:21 PM by LozzaDude
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.
Id #15601 | Release:
| Updated: Mar 30 at 11:52 AM by naginraychura | Created: Mar 30 at 11:52 AM by naginraychura
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?
Id #15600 | Release:
| Updated: Mar 29 at 4:02 PM by mo7 | Created: Mar 29 at 4:02 PM by mo7
Please add the option to save in XLSB and old XLS format.
Id #15599 | Release:
| Updated: Apr 2 at 6:56 PM by richardtallent | Created: Mar 28 at 7:49 AM by ashikiqbal
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:
| Updated: Mar 24 at 4:22 PM by tslagter | Created: Mar 24 at 4:22 PM by tslagter
** 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:
| Updated: Mar 22 at 2:21 PM by roysoliver | Created: Mar 22 at 1:37 PM by roysoliver