ExcelRangeBase.Text property does not return correctly formatted text

The attached xlsx has one cell with formatting 00.00.00.000.0 and content 202100083, and shows "02.02.10.008.3" (without quotes) in Excel 2013. When this file is opened with EPPlus and the A1 cel...

Id #15041 | Release: None | Updated: Jul 31 at 7:30 PM by wrummler | Created: Jul 31 at 5:33 AM by wrummler

DisplayRSquaredValue and DisplayEquation for Trendlines

First, let me thank you for all of your work. EPPlus version : 4.0 Beta 2 Excel 2013 version : 15.0.4420.1017 I found a small issue when setting either (or both) DisplayRSquaredValue and Disp...

Id #15040 | Release: None | Updated: Jul 29 at 8:52 AM by eagle47 | Created: Jul 29 at 8:52 AM by eagle47

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: Jul 23 at 6:58 AM by vamsibora | Created: Jul 22 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: Jul 22 at 6:54 AM by PhilipLGarrett | Created: Jul 22 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 31 at 5:59 PM by mobombo | 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