Invalid URL Exception

Hi! I have a problem, if I try to open an XLSX file with EPPlus. The File was created with Microsoft Office 2010. My code is: foreach (string fajl in fajlok) { ...

Id #14858 | Release: None | Updated: May 16 at 4:00 PM by abdaizs | Created: May 16 at 2:45 PM by abdaizs

Slight issue with AutoFitColumns

I just found this library, and am amazed at how easy it is to work with. Thanks! I did notice one slight issue though. I found ws.Cells.AutoFitColumns(); to try and Auto Fit the columns (I know,...

Id #14857 | Release: None | Updated: May 15 at 7:19 PM by krillgar | Created: May 15 at 7:19 PM by krillgar

Adding comments gives XmlException.

Opening XLSX with Excel and saving it resolves the file issue but when I run my program it somehow brokes the excel file again on the second time. It's weird. So this error comes in third time when...

Id #14856 | Release: None | Updated: May 14 at 12:27 PM by tuomaslaa | Created: May 14 at 12:27 PM by tuomaslaa

Is there a way to pass DataTable while creating CHART in a Worksheet?

Is there a functionality to pass a DataTable, to Create Chart or Multiple Charts in a single Worksheet ? If yes , please guide me. If no, please let me know a workaround for the same, if possibl...

Id #14855 | Release: None | Updated: May 13 at 2:16 PM by vips3483 | Created: May 13 at 2:16 PM by vips3483

Character values - issue

While assigning a character value to a cell, EPPlus puts a value 0 to the cell. The workaround we have opted for is to check for the type of the value and then convert character value to string an...

Id #14854 | Release: None | Updated: May 13 at 11:27 AM by punitganshani | Created: May 13 at 11:27 AM by punitganshani

Excel cannot open file because directory _rels is missing

When I make an excel-sheet with EPPlus, using a template, Excel 2010 cannot open the file because of corrupted data. I made the same sheet in Excel and compared it to the sheet generated by EPPlus...

Id #14853 | Release: None | Updated: May 7 at 12:12 PM by amfasis | Created: May 7 at 11:35 AM by amfasis

Error Save when [state="veryHidden" r:id=""] is in workbook.xml

Hello, I found a issue that an exception would be thrown out when save a Excel if there is state="veryHidden" r:id="" in workbook.xml. Because r:id is empty. here is the workbook.xml: <?xml versi...

Id #14852 | Release: None | Updated: May 7 at 6:47 AM by chenliang0571n | Created: May 7 at 3:18 AM by chenliang0571n

Modifying a chart in Excel 2013 disables saving the file

I create an excel file using EPPlus library, containing a chart (XYScatter). The file works great, and I can modify cells. However if I modify the chart, for example changing its style, the file ca...

Id #14851 | Release: None | Updated: May 1 at 11:01 PM by liorshapira | Created: May 1 at 11:01 PM by liorshapira

EncryptionInfo format changed

Hello, I found here the EPPlus 3.1 is NOT able to open a decrypted Excel 2010. OutOfMemory Exception will be throw up. according to my debug, the error throw from this line: byte[] text = new b...

Id #14850 | Release: None | Updated: May 1 at 8:30 PM by JanKallman | Created: Apr 30 at 5:37 AM by chenliang0571n

Texts ended with newline are not correct shown in Excel

First, EPPlus is a great library, we love it. Texts that ended with a newline like “Text with two following new lines\r\n\r\n” the newline is missing in Excel or LibreOffice. When a character fo...

Id #14849 | Release: None | Updated: Apr 26 at 11:17 AM by SvenJust | Created: Apr 26 at 11:17 AM by SvenJust