Incorrect address check in ExcelChartSerie.cs?

3.0->4.0RC In the set statement of the HeaderAddress accessor (ExcelChartSerie.cs, lines 132-135) there is an address check that throws an exception when a range is supplied. This check seems t...

Id #15102 | Release: None | Updated: Today at 11:55 AM by Cursorkeys | Created: Today at 11:55 AM by Cursorkeys

Writing Excel to PDF while in memory

Hello Friends, I would like to convert excel file created by EPPlus into PDF while the excel file is still in memory. I would appreciate if someone can help me do so. There are plenty of libra...

Id #15101 | Release: None | Updated: Today at 11:28 AM by Omerzoi | Created: Today at 11:28 AM by Omerzoi

[4.0 RC1] Using indexer against Cells property did not return all expected cells

In some excel document I invoked Cells["B105:G105"]. The expected result is the following enumeration of cells: B105 C105 D105 E105 F105 G105 But the actual result did not contain E105 cell. Se...

Id #15100 | Release: None | Updated: Today at 10:16 AM by Deilan | Created: Today at 3:30 AM by Deilan

worksheet.names("myname") doesn't work

Hello Friends, I spent so much time to work on referring to worksheet.names("mynamedrange") but it doesn't work. I can find my namedrange with workbook.names("mynamedrange") but not in worksheet....

Id #15099 | Release: None | Updated: Today at 10:18 AM by Omerzoi | Created: Sun at 10:05 PM by Omerzoi

Copy WorkSheet with PivotTable

ExcelWorksheets.Add(string Name, ExcelWorksheet Copy) fails if the Workbook contains a PivotTable. In 3.1.3 the message is: "Cannot add part for the specified URI because it is already in the pac...

Id #15097 | Release: None | Updated: Fri at 1:27 PM by bifel | Created: Fri at 1:24 PM by bifel

AutoFitColumns - ColumnMax can not span over existing column

Hi, i've been getting this error with the version 4 of 11 november : ColumnMax can not span over existing column 12. Une exception de type System.Exception a été levée. at OfficeOpenXml.Ex...

Id #15096 | Release: None | Updated: Thu at 3:14 PM by alphab2 | Created: Thu at 3:14 PM by alphab2

Worksheets.Add(string Name, ExcelWorkSheet Copy) creates referenced duplicate of CodeModule

The "Worksheets.Add(string Name, ExcelWorkSheet Copy)" function copies the "CodeModule" by reference. Tested with an "ExcelPackage" created from an existing file containing a "CodeModule" in the ...

Id #15095 | Release: None | Updated: Fri at 7:18 AM by JanKallman | Created: Thu at 1:24 PM by qed

More useful error when cannot find indexed worksheet EPP 4.0 RC

Version: EPP 4.0 RC. When querying for a worksheet with an invalid index position the current error is unhelpful. It would be nice if the error explained the problem. Eample: using (var excelFi...

Id #15094 | Release: None | Updated: Fri at 7:18 AM by JanKallman | Created: Thu at 2:19 AM by jafin

an item with the same key has already been added

I used below code but i got an error "an item with the same key has already been added". Please suggest the solution using (var p = new ExcelPackage(new FileInfo(ExcelFilePath))) { ...

Id #15093 | Release: None | Updated: Nov 17 at 9:26 AM by Sidnaik03 | Created: Nov 17 at 9:26 AM by Sidnaik03

[4.0 RC1] Cell.Value sometimes returns "&" instead of "&"

In some cases Value property of a Cell object returns string, that contains "&amp ;" (without space between 'amp' and ';') instead of valid "&".

Id #15092 | Release: None | Updated: Fri at 7:18 AM by JanKallman | Created: Nov 17 at 12:16 AM by Deilan