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: Thu at 8:46 PM by metms | 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

Cross-Site Scripting (Insufficient Entropy (CWE ID 331) issues in ColsedXml.dll

We are using ColsedXml.dll In our application. We are mandated by our organization to scan our code in Veracode Site for security scan. While running the scan we got "Cross site scripting flaws in...

Id #9386 | Release: None | Updated: Nov 8 at 5:13 AM by NickNack2020 | Created: Nov 4 at 10:32 AM by Guna_Revopt

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: Oct 29 at 1:04 PM by Meoiswa | Created: Oct 28 at 8: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: Nov 9 at 5:11 PM by el_topo_48 | Created: Oct 27 at 1: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: Oct 29 at 5:52 PM by MDeLeon | Created: Oct 21 at 7: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 4:35 PM by stackedactor | Created: Oct 20 at 4: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 1:03 PM by logicbloke | Created: Oct 16 at 12:11 PM by pouya_samie