Excel pivot chart based on Excel range will lose data when inserting rows or columns.

See attached workbook. If InsertRows or InsertColumns is called on the worksheet and saved, all of the series data is removed from the chart when it is next opened.

Id #15485 | Release: None | Updated: Jun 30 at 9:17 AM by gabry90 | Created: Jun 30 at 12:02 AM by maxa

Lost data Name

Hi, new merged version 28/06/2016 have an issue with named range. After inserting new 58 rows the named ranged "'example_page'!$A$11" becomes "A69" instead "'example_page'!$A$69" (as it was befo...

Id #15484 | Release: None | Updated: Jun 29 at 4:41 PM by gabry90 | Created: Jun 29 at 4:41 PM by gabry90

Error: Duplicated Named Ranges

Hi. Duplicated Named Ranges contains file not loading, throw "same key" exception. Thanks.

Id #15483 | Release: None | Updated: Jun 26 at 11:01 PM by alpsaral | Created: Jun 26 at 10:54 PM by alpsaral

Corrupted file when i merge cells twice

Excel think what file is corrupted when i merge cells twice using OfficeOpenXml; namespace testMerge { class Program { static string appPath = AppDomain.CurrentDomain.BaseDirectory; stati...

Id #15482 | Release: None | Updated: Jun 27 at 6:17 AM by JanKallman | Created: Jun 22 at 9:23 PM by antonioinet

Corrupted file when loading a template file

This one is a bit hard to reproduce exactly, or even describe accurately. Anyway: 1) loading an .xlsx file created in MS Office 2016 Excel and subsequently saving it (regardless of changing it i...

Id #15481 | Release: None | Updated: Jun 23 at 2:56 PM by ceh | Created: Jun 22 at 8:48 AM by ceh

Date comparison in SUMIF functions does not work

If I use a SUMIF function and my comparison column is a column of dates. If I try a < or > comparison and reference another date to compare against, EPPlus does not sum any of the values. I'm ass...

Id #15480 | Release: None | Updated: Jun 20 at 6:35 PM by fhilton | Created: Jun 20 at 6:35 PM by fhilton

PatternColor.SetColor

Hi Color specified in Fill.PatternColor.SetColor is not applied unless Fill.BackgroundColor.SetColor is also called. This works fine once you figure it out but a big painful before. Thanks,...

Id #15479 | Release: None | Updated: Jun 17 at 6:33 PM by PatrickCBrown | Created: Jun 17 at 6:33 PM by PatrickCBrown

No worksheets read from XLSX

I have been using EPPLUS several times, but now I'm getting an issue when opening an Excel file: I can open the package and get the workbook, but then EPPLUS does not see any worksheet in it. Yet t...

Id #15478 | Release: None | Updated: Jun 27 at 7:18 PM by kjpyatt | Created: Jun 17 at 1:19 PM by Mathetes

Move project to github ?

I think its about time for this project to be moved to github for better community traction. What do you think ?

Id #15477 | Release: None | Updated: Jun 21 at 5:24 AM by jafin | Created: Jun 12 at 12:11 PM by cemremengu

ExcelConditionalFormattingTwoColorScale and ExcelConditionalFormattingThreeColorScale properties are not saved.

The properties on ExcelConditionalFormattingTwoColorScale and ExcelConditionalFormattingThreeColorScale objects are never serialized back into the XML structure. Property get and set methods should...

Id #15475 | Release: None | Updated: Jun 8 at 9:59 PM by emdelaney | Created: Jun 8 at 9:59 PM by emdelaney