Problem opening workbook containing Table with no headers

Hi, I am receiving Object Reference exception when trying to instantiate an existing workbook having a table with removed Header Row. Using latest production ClosedXML.

Id #9400 | Release: None | Updated: Wed at 9:32 AM by aalw | Created: Dec 16 at 12:07 PM by aalw

Generate binary identical file for same input

Currently when I generate a workbook with a sheet and save it as .xlsx and then use the same code again I get two files with different content. I would like to get exactly the same file, so I can ...

Id #9399 | Release: None | Updated: Dec 10 at 11:17 AM by fhoeben | Created: Dec 10 at 11:01 AM by fhoeben

System.Runtime.InteropServices.ExternalException while Adding DataTable to WorkSheet

Hi, Somehow while converting DataTable to WorkSheet, I am getting this exception. Not sure what exactly is causing this. A first chance exception of type 'System.Runtime.InteropServices.ExternalE...

Id #9398 | Release: None | Updated: Dec 4 at 6:07 PM by che86 | Created: Dec 4 at 6:07 PM by che86

Can not create more than 1 Pivot Table in WorkBook.

I can easily create two Worksheets, and I can easily add a Pivot Table to one of the worksheets. But if you try to add a second Pivot Table to the second Worksheet, you end up with a corrupted exc...

Id #9397 | Release: None | Updated: Dec 3 at 12:50 AM by jahndohse | Created: Dec 3 at 12:50 AM by jahndohse

Cell.Value throw FormatException

It will throw the format exception when get the cell value which set the cell format is percent. And I try to get the cell value like this code. ClosedXML.Excel.XLWorkbook wb = new ClosedXML.Exce...

Id #9396 | Release: None | Updated: Dec 1 at 2:44 AM by cooper360 | Created: Dec 1 at 2:44 AM by cooper360

Conditional Formatting not applying to Pivot Table

I'm creating a pivot table in ClosedXML, then trying to apply conditional formatting to it. When I open the sheet however, the conditional format applies to everywhere but the pivot table; see atta...

Id #9394 | Release: None | Updated: Nov 25 at 9:34 AM by philellwood | Created: Nov 25 at 9:34 AM by philellwood

Cross-worksheet Cell and Range hyperlinks should work

The XLHyperlink constructor currently converts a Cell or Range into an address string without the sheet name. This means that cross-worksheet hyperlinks don't work correctly. If I create a hyperl...

Id #9392 | Release: None | Updated: Nov 17 at 11:05 PM by taoyue | Created: Nov 17 at 11:05 PM by taoyue

'System.IO.IsolatedStorage.IsolatedStorageException' occurred in System.Xml.dll

I'm trying to create a COM component using ClosedXML. It's working perfectly until I go to save the file. Everything works fine when I run a COM test under .NET, but when I connect it to VB6 it p...

Id #9391 | Release: None | Updated: Nov 17 at 2:17 PM by danhall | Created: Nov 17 at 2:17 PM by danhall

CopyTo one to another workbook style error

System.Collections.Generic.KeyNotFoundException mscorlib.dll!System.Collections.Generic.Dictionary<int,System.__Canon>.this[int].get(int key) + 0x8a ClosedXML.dll!ClosedXML.Excel.XLWorkbook.GetS...

Id #9389 | Release: None | Updated: Dec 1 at 2:47 AM by cooper360 | Created: Nov 12 at 2:17 AM by edisonwsk

Error when compiling the webForms and AnyCPU application

An error is generated when you run the attachment of WebForm. Not so when you run a winForm There are the two simple applications that can prove.

Id #9388 | Release: None | Updated: Nov 11 at 8:46 PM by el_topo_48 | Created: Nov 11 at 8:43 PM by el_topo_48