ConditionalFormatting causing HIGH overhead

I have a process that builds a rather large spreadsheet. About 30,000 rows, roughly 300 columns. (don't knock me, I'm the developer, I tried to convince the user it was ludicrous, but what do I k...

Id #15633 | Release: None | Updated: Jul 19 at 3:41 PM by briankitt | Created: Jul 19 at 3:40 PM by briankitt

A bug when copying a worksheet (ExcelWorksheet) from one document to another

I try to copy a worksheet from one Excel document to another one and encountered a problem. I found an error in the method 'Worksheets.Add' Here is the code: private static byte[] CombineXlses(p...

Id #15632 | Release: None | Updated: Jul 17 at 8:38 AM by ahmadinurov | Created: Jul 17 at 8:38 AM by ahmadinurov

Formula which includes cell ref like "A:B" cannot copy correctly.

// with cell1.Formula == "VLOOKUP(C1, A:B, 2)" // do cell1.Copy(cell2) // then cell2.Formula == "VLOOKUP(C2, #REF!, 2)" It is probrem of ExcelCellBase::UpdateFormulaReferences() or ExcelAddressBas...

Id #15631 | Release: None | Updated: Jul 16 at 10:24 AM by narazaka | Created: Jul 16 at 10:24 AM by narazaka

NRE when getting ExcelRange.Text from custom formatted cells

See attached example file. It can read Value but when trying to get Text throws NRE.

Id #15630 | Release: None | Updated: Jul 5 at 8:35 PM by N1ghtblade | Created: Jul 5 at 8:35 PM by N1ghtblade

Corrupt file when image added.

Without changing anything Excel now claims that the XLSX files created by EPPlus are corrupted as soon as an image has been added. This happened in Excel 2007 and Excel 2016 on two different machin...

Id #15629 | Release: None | Updated: Jul 4 at 3:27 PM by needfulthing | Created: Jul 4 at 2:54 PM by needfulthing

Exception in ExcelFontXml.GetHeightByName

Exception occurred for missing key in OfficeOpenXml.Style.XmlAccess.ExcelFontXml.GetHeightByName(string name, float size). This occurred when processing an Excel file generated using SSRS that co...

Id #15628 | Release: None | Updated: Jun 21 at 4:32 PM by zbapoc | Created: Jun 21 at 4:31 PM by zbapoc

Column width cannot be set

I am attempting to size the width of columns as displayed in the example below. The do not always adhere to the width selected. Originally I thought this issue began with trying to set the column w...

Id #15627 | Release: None | Updated: Jun 13 at 3:54 PM by AOkMort | Created: Jun 13 at 3:54 PM by AOkMort

workSheet.Dimension.End.Column throws null reference for empty worksheets

When trying to find the last column in a empty worksheet using... var lastColumn = sheet.Dimension.End.Column; ...a null reference error occurs (none of sheet, .Dimension or .End are null) as c...

Id #15626 | Release: None | Updated: Jun 13 at 6:19 AM by Growler | Created: Jun 13 at 6:19 AM by Growler

Alignment and wrapping error while opening file in LibreOffice

I create XLSX file using the newest version of EPPLus. Some of columns are aligned to the left (default). That file opened in the OpenOffice Calc and in the MS Excel saves the formating. The same f...

Id #15625 | Release: None | Updated: Jun 1 at 11:46 AM by WieslawS | Created: Jun 1 at 11:46 AM by WieslawS

When a version for .NET Core too

We are moving on .NET Core, and like many others the migration issues is not about if our custom code can migrate on .NET Core, but if the third part library already have a version working on .Net ...

Id #15624 | Release: None | Updated: Jul 15 at 3:35 PM by dfinke | Created: May 25 at 9:45 AM by michaelsogos