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: May 29 at 8:06 AM by michaelsogos | Created: May 25 at 9:45 AM by michaelsogos

Adding filters in RowFields

Hi all, I wrote here because I have a lot time trying to add a filter in RowFields. I made an example test and this is what I got: This is what I need: Example data: This is what ...

Id #15623 | Release: None | Updated: May 24 at 7:59 AM by Alemax | Created: May 24 at 7:59 AM by Alemax

Applying formula to selected range of non-contiguous cells

I'm able to use the following code to apply a formula to a range of selected cells. Worksheet.Select(new ExcelAddress("T2:T10")); Worksheet.SelectedRange.Formula = "=if(A2=\"\",\"empty\",\"not empt...

Id #15622 | Release: None | Updated: Jun 1 at 12:14 AM by aesalazar | Created: May 24 at 1:32 AM by 3milio

InsertRow with Copy not worked with merged cells

There is row pattern B2:F2 Cell B2 = "Text" Cell C2 = "Text" Cell D2:E2 is merged = "Text" Cell F2 = "Text" If this is done without "method IinsertRow", it works correctly and the row templa...

Id #15621 | Release: None | Updated: May 23 at 6:08 PM by evgnib123 | Created: May 20 at 8:52 PM by evgnib123

Password protected documents

Hey guys! First of all - great library! Recently I had to create a password protected spreadsheet and right now I am just passing the password to the save method like this package.Save("pass...

Id #15620 | Release: None | Updated: May 15 at 3:35 PM by DZhelev | Created: May 15 at 3:35 PM by DZhelev

[Solved]:Set cell value with named cell/range instead of coordinates

I would like to be able to set cell values with named cells/ranges instead of coordinates: ws.Range("profits").Value = 66; Also see https://stackoverflow.com/questions/43910827/how-to-set-valu...

Id #15619 | Release: None | Updated: May 11 at 12:25 PM by eis | Created: May 11 at 9:16 AM by eis