Improve performance

Hi There is room for performance improvements in ClosedXML. To create a performance base line I updated the sandbox example in the branch https://closedxml.codeplex.com/SourceControl/network/for...

Id #9425 | Release: None | Updated: Sun at 9:20 PM by AlbinSunnanbo | Created: Feb 26 at 8:14 PM by AlbinSunnanbo

get column name from index

To get the name of a column based on it's index, I added the following function to XlWorksheet. This will return "A3" for columnindex=1 and rowindex=3 -> the columnindex is 1-based public static...

Id #9424 | Release: None | Updated: Feb 25 at 12:44 PM by d4e666 | Created: Feb 25 at 12:44 PM by d4e666

Export empty DataTable ignores DataColumn Caption

In the current implementation, when exporting a DataTable to excel via InsertTable method, if a DataColumn.Caption is not null or whitespace then the DataColumn.Caption string is taken into account...

Id #9423 | Release: None | Updated: Feb 25 at 12:36 PM by nannez | Created: Feb 25 at 10:01 AM by vittoso

While Writing to Excel file its throwing an error "'.', hexadecimal value 0x00, is an invalid character."

Hi All, While Writing to Excel File using the ClosedXML facing an issue. Above is the error mentioned into caption which I am getting. Have attached the Excel File which I am trying to Write by...

Id #9421 | Release: None | Updated: Sun at 11:38 AM by monmaru | Created: Feb 12 at 9:15 AM by samirmsoni

When trying to retrieve value of a formula, ClosedXML throws 'Identifier Expected' Exception

I am using ClosedXML 0.76.0 to build my application, which handles Excel files. At one moment, I populate an Excel file with formulas. So far, so good. The user then gets this file and fills in...

Id #9419 | Release: None | Updated: Feb 2 at 3:16 PM by neuron_upheaval | Created: Feb 2 at 1:05 PM by neuron_upheaval

Deleting row from table resizes table incorrectly

I am greatly enjoying ClosedXml but have run into an issue when deleting a row from a table. The issue seems to be that while the row indeed is deleted, the last (undeleted) row of the table ends...

Id #9418 | Release: None | Updated: Jan 30 at 12:24 AM by HenrikN | Created: Jan 30 at 12:24 AM by HenrikN

Problem opening created spreadsheet in open office

I haved used this example to create a spreadsheet. The resulting spreadsheet will open fine in the Microsoft Execel Previewer but gets a general i/o error when I try to open it in OpenOffice Calc. ...

Id #9417 | Release: None | Updated: Jan 19 at 10:34 PM by otlarkin | Created: Jan 19 at 10:34 PM by otlarkin

WorkBook opening exception with message "Identifier expected"

When I trying to open workbook I catch exception. Code: var doc = new XLWorkbook(workBookFileName); StackTrace: в ClosedXML.Excel.CalcEngine.CalcEngine.Throw(String msg) в ClosedXML.Excel....

Id #9416 | Release: None | Updated: Jan 19 at 7:07 AM by Luckyman | Created: Jan 19 at 7:07 AM by Luckyman

Comment.Delete() crashes workbook

Hi! I'm troubled by a simple problem. Sometimes, workbook including comments is crashed by deleting comment. In order to ascertain reproducibility conditions, I prepared simple program. cla...

Id #9415 | Release: None | Updated: Jan 16 at 5:27 AM by kussy | Created: Jan 16 at 5:27 AM by kussy

Page break crashes workbook in saving.

Hi! Thank you for good library. I'm troubled by a simple problem. Sometimes, workbook is crashed in saving. In order to ascertain reproducibility conditions, I prepared simple program. it only...

Id #9414 | Release: None | Updated: Jan 15 at 7:12 AM by kussy | Created: Jan 15 at 7:12 AM by kussy