How to delete the default tablestyle and autofilter in Closed XML

Hii, I'm creating '.xlsx' file using ClosedXML. The code which i used is given below: Here dsreport is a Dataset having multiple sheets. using (XLWorkbook wb = new XLWorkbook()) { ...

Id #9445 | Release: None | Updated: Jun 20 at 9:38 AM by Suvarnni | Created: Jun 20 at 9:38 AM by Suvarnni

Date value as text in excel file

I am trying to set a text value to one of my columns. Text value is 2015/06/03 15:15 Below is the code, that I use to set this column excelWorkSheet.Cell(j + 1, k).SetDataType(XLCellValues.Tex...

Id #9444 | Release: None | Updated: Jun 3 at 4:02 PM by jineshv | Created: Jun 3 at 4:02 PM by jineshv

SetRowsToRepeatAtTop for OpenOffice, LibreOffice

Document created with using SetRowsToRepeatAtTop function does not repeat rows for OpenOffice or LibreOffice.

Id #9443 | Release: None | Updated: Jun 1 at 2:30 PM by kDanil | Created: Jun 1 at 2:24 PM by kDanil

Using SUMIF results in a "Syntax error." exception

Using SUMIF(A1:A10,">0") results in a "Syntax error." exception. Code ends up in the ParseAtom() method with the _token.Type of TKTYPE.COMPARE, which is unsupported at that moment.

Id #9442 | Release: None | Updated: Jun 26 at 10:56 AM by Blaaznar | Created: Jun 1 at 11:53 AM by Blaaznar

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: May 26 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