Escape Hyperlink's location to prevent errors when sheet names contain special characters like '&'

Tested in version 4.0.0 beta 2. Provided a solution as part of this post. While updating hyperlinks in a WorkSheet, the location is not encoded. This causes an error when trying to load the updat...

Id #15039 | Release: None | Updated: Wed at 6:58 AM by vamsibora | Created: Tue at 7:40 PM by vamsibora

NullRefenceException in ExcelRangeBase constructor

A null reference exception occurs on release 4.0 Beta 2 when loading a spreadsheet containing a Defined Name with a value of "1". This may be the same as issue #12868. I am reporting it because the...

Id #15038 | Release: None | Updated: Tue at 6:54 AM by PhilipLGarrett | Created: Tue at 6:54 AM by PhilipLGarrett

SSRS 2012 generated Excel files are not readable in EPPlus

Hi, I am experiencing an issue with EPPlus reading worksheets from an SSRS generated excel file(*.xlsx), basically export to Excel. Exception Message - "Unexpected XML declaration. The XML decl...

Id #15037 | Release: None | Updated: Jul 17 at 8:47 PM by celtic | Created: Jul 17 at 8:47 PM by celtic

Can't open some xlsx files

I receive from some people strange xlsx file, that I could not open with EPPlus. After investigation I found, that some files in xlsx archive with wrong case. For example: "SharedStrings.xml", ins...

Id #15036 | Release: None | Updated: Jul 17 at 10:18 AM by RoninDev | Created: Jul 17 at 6:21 AM by RoninDev

ConditionalFormat Styles: Incorrect count.

When generating a workbook with conditional formatting the Styles.xml file has an incorrect count againsst the dxfs node. The following code is missing from the UpateXML method on the ExcelStyles...

Id #15035 | Release: None | Updated: Jul 14 at 3:30 PM by willcosl | Created: Jul 14 at 3:30 PM by willcosl

ExcelTableColumn.DataCellStyleName issue

Thanks for the great work. This library is really good. I found an issue when setting ExcelTableColumn.DataCellStyleName property. If the table has only one row, the style is not applied. Checki...

Id #15034 | Release: None | Updated: Jul 14 at 3:22 PM by bangosanti | Created: Jul 14 at 3:22 PM by bangosanti

Out of Memory Exception

I get an out of memory exception when loading a worksheet for a large xlsm file (>90MB). There is plenty of available memory on the server when I get the exception. Is there any configuration setti...

Id #15033 | Release: None | Updated: Jul 11 at 3:50 PM by samg123 | Created: Jul 10 at 10:10 PM by samg123

Generate Chart, Apply Style in Excel, Save, Fail

This problem exists in both the 3.1 and 4.0 code base. To reproduce the error, Run the sample application. Open sample5.xlsx Select the Pie Chart Select the CHART TOOLS tab Select any predefined...

Id #15032 | Release: None | Updated: Jul 8 at 7:01 PM by CarlGo | Created: Jul 8 at 7:01 PM by CarlGo

TimeSpan greather than 24 hours

Hello guys, I request permission to expose a problem. When i try to add an value of TimeSpan greather than 24 hours, exists an problem to converto to OADate, in internals of EPPlus. Conversi...

Id #15031 | Release: None | Updated: Jul 7 at 9:14 PM by JanjaoHaastari | Created: Jul 7 at 9:10 PM by JanjaoHaastari

Unable to edit existing comments in excel.

Unable to edit existing comments in excel. In my excel when I am trying to update existing comments (code provided below) .when I try to open the excel I get following message “Excel found unreada...

Id #15030 | Release: None | Updated: Jul 7 at 2:09 AM by zestxjest | Created: Jul 2 at 7:47 PM by preetam96