ws.PageSetup.Footer.Right.AddText does not work , when read xlsx file.

XLWorkbook wb = new XLWorkbook(templateFullName); IXLWorksheet ws = wb.Worksheet(1); ws.PageSetup.Footer.Right.AddText("created:" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); does not work. X...

Id #9441 | Release: None | Updated: Tue at 6:30 PM by doxakis | Created: May 21 at 6:48 AM by Kenichi_YAMADA

Style.Border.InsideBorder always work at 1st worksheet

ws.Range(row1, col1, row2, col2).Style.Border.InsideBorder = XLBorderStyleValues.Thin; always work at 1st worksheet. ws.Cell(row1, col1).Style.Border.InsideBorder = XLBorderStyleValues.Thin; is s...

Id #9440 | Release: None | Updated: May 21 at 6:24 AM by Kenichi_YAMADA | Created: May 21 at 6:24 AM by Kenichi_YAMADA

ClosedXML doc can't be open using Spire.Xls

I want to open a file created by ClosedXML.Excel and then user Spire.XLS to save it as a PDF. The following code creates a simple Excel file using ClosedXML.Excel. If I try to open the file usin...

Id #9439 | Release: None | Updated: May 20 at 5:30 AM by gaffer1964 | Created: May 20 at 5:30 AM by gaffer1964

Permission problem using ClosedXML with Microsoft NAV

I use ClosedXML to create Excel Workbooks in Microsoft NAV 2013R2. In my development environment everything works without problems. When I try to execute the function in the customer environment I ...

Id #9438 | Release: None | Updated: May 19 at 9:15 AM by rodotto | Created: May 19 at 9:05 AM by rodotto

Loading an XLSX file fails with NullReferenceException

NullReferenceException occurs in XLWorkbook_Load method when opening attached XLSX file: var xl = new XLWorkbook("Bug_118703_WriteMatrixToExcelNullReferenceException.xlsx"); at ClosedXML.Excel.X...

Id #9437 | Release: None | Updated: May 19 at 9:23 AM by borismod | Created: May 19 at 6:58 AM by borismod

Traverse merged cells?

Currently if we use cell.CellRight(), we can traverse the cells as if they were unmerged. This is fine. However, this imposes strict requirements on file structure of my users. If they choose to me...

Id #9436 | Release: None | Updated: May 17 at 12:04 PM by baba147 | Created: May 17 at 12:04 PM by baba147

COUNTIF function

The following code XLWorkbook xw = new XLWorkbook(); IXLWorksheet ws = xw.AddWorksheet("ASheet"); ws.Cell("A1").Value = 2; ws.Cell("A2").Value = 1; ws.Cell("A3").Value = 3; ws.Cell("A4").Value = 1...

Id #9435 | Release: None | Updated: May 7 at 4:29 PM by morca | Created: May 7 at 2:18 PM by morca

Extra empty cells added when inserting comment

When adding a comment to a cell extra empty cells are added in the excel sheet which are not touched by the code. With the following code: var workbook = new XLWorkbook(); var worksheet = workboo...

Id #9434 | Release: None | Updated: May 7 at 12:26 PM by ErwinSteffens | Created: May 7 at 12:26 PM by ErwinSteffens

Errors in Formulas: improve API for graceful handling

A customer-provided Excel document contained a Formula referencing a second file using a formula like ='C:\Temp[A.xlsx]Country'!$A$3 which results in a System.Exception: Identifier expected. at ...

Id #9433 | Release: None | Updated: May 6 at 12:43 PM by sopelt | Created: May 6 at 12:43 PM by sopelt

Auto Height for Rows

Great library but one trouble here - if you like to copy and modify rows often you touch row's height property . Then library sets height as CustomHeight. So it seems the most simple way looks l...

Id #9432 | Release: None | Updated: Apr 30 at 10:32 PM by lvm99 | Created: Apr 30 at 10:32 PM by lvm99