Saving a Xlsx with Conditional formatting

Saving a xlsx with conditional formatting that a gradient with colors picked from the Theme Color selection throws an exception "cannot convert theme color to Color". Changing said colors to one f...

Id #9385 | Release: None | Updated: Wed at 12:04 PM by Meoiswa | Created: Tue at 7:47 PM by Meoiswa

Failed to create a very large file

Failed to create a very large file When I have more than 100000 rows gives me the following error Row = 183 706 - System.OutOfMemoryException: An unhandled exception of type 'System.OutOfMemo...

Id #9384 | Release: None | Updated: Tue at 3:23 PM by lesta | Created: Mon at 12:17 AM by el_topo_48

Changing a Column Header's text

I am trying to change the text of cells in the first row of the spreadsheet, essentially the column header. This example is just changing the first cell in row 1. Dim l_sValue As String l_sValue ...

Id #9383 | Release: None | Updated: Wed at 4:52 PM by MDeLeon | Created: Oct 21 at 6:26 PM by JoelPettit

Addition of PX as a knownUnit in XLWorkSheet_Load.cs

I came across an Excel file (I think from 2003 originally and re-saved as MS Office 2013 XLSX) which hit the GetPtValue private method in the XLWorksheet_Load.cs file and the string was "62px". As ...

Id #9382 | Release: None | Updated: Oct 20 at 3:35 PM by stackedactor | Created: Oct 20 at 3:35 PM by stackedactor

font for arabic/persian language

Hi im trying to set font for Persian language but it seems it dose not work when i download my excel file , the cell that i set the font is not changed but when i click on it the font name has...

Id #9380 | Release: None | Updated: Oct 20 at 12:03 PM by logicbloke | Created: Oct 16 at 11:11 AM by pouya_samie

Worksheet.PivotTables is always empty

My .xlsx file contains a Pivot Table. But I can't get access to it via Worksheet.PivotTables property. This is my sample code: using (var excel = new XLWorkbook(sourceFile, XLEventTracking.Enable...

Id #9378 | Release: None | Updated: Oct 15 at 4:15 PM by lionsoft | Created: Oct 15 at 4:15 PM by lionsoft

Date/Number Formatting Issue using Worksheets.Add

I am using the workbook.worksheets.add method with a data table that I get from an Oracle DB using ODP.NET, but numbers and dates are always formatted as text. I end up running methods to fix this...

Id #9377 | Release: None | Updated: Oct 15 at 1:14 PM by prashingkar | Created: Oct 14 at 4:27 PM by bobbeid

Cell with Accounting Format produces crash during String Table creation

Se attached Excel document. It is currently being filled by manual data entry, which is a lot of work. The purpose of the application I am developing is to "clone" the "item 1" worksheet 'n' times ...

Id #9376 | Release: None | Updated: Oct 12 at 1:12 AM by TravisBanger | Created: Oct 12 at 12:07 AM by TravisBanger

Freezing first row causes scroll wheel to no longer work.

When I freeze the first row, the scroll wheel no longer works. This is because the active pane is still set to the default of TopLeft (or TopRight, not sure which). So the scroll wheel is trying to...

Id #9374 | Release: None | Updated: Oct 14 at 4:49 PM by slockwood87 | Created: Oct 8 at 8:15 PM by slockwood87

SetDataType(XLCellValues.Text) for setting Text with numbers does not work

Thanks for the amazing library. Really appreciate it. I am using ClosedXML 0.75.0 I looked at the following documentation on how text with numbers can correctly show up in Excel without the err...

Id #9372 | Release: None | Updated: Oct 2 at 9:02 PM by prashingkar | Created: Oct 2 at 8:55 PM by prashingkar