ClosedXML does not preserve style

So this is my code using (var document = new XLWorkbook(root + outFolder + copied)) { var sheet = document.Worksheets.First(); var allRows = sheet.Rows(); ...

Id #9454 | Release: None | Updated: Fri at 3:52 PM by hartez | Created: Thu at 10:21 AM by gummz00

Hide does not hide Worksheet

Can someone explain why the code below does not actually hide the worksheet? workbook.Worksheet("Saber Tooth Audit Legend").Hide(); workbook.Worksheet("Saber Tooth Audit Legend").Visibil...

Id #9453 | Release: None | Updated: Jul 17 at 12:19 AM by marklane123 | Created: Jul 17 at 12:19 AM by marklane123

Apply subscript formatting to part of a string.

Is there a way to apply subscript formatting to part of a string in a cell when using ClosedXML? For example, I need a string similar to "valPEAK", where the "PEAK" would be subscripted. These stri...

Id #9452 | Release: None | Updated: Jul 15 at 3:34 PM by slockwood87 | Created: Jul 15 at 3:34 PM by slockwood87

COUNTIF allowed syntaxes

At the moment, the only way to successfully use the COUNTIF function seems to be the one using a syntax like COUNTIF(A1:A8,"=3") Where A1:A8 contains numbers. If the contents are strings, or if...

Id #9451 | Release: None | Updated: Jul 15 at 3:17 PM by RedGlow82 | Created: Jul 15 at 3:17 PM by RedGlow82

String/integer comparison

Excel accepts expressions like: IF(3="","a","b") Where the comparison obviously returns false. ClosedXML tries to convert the empty string to an integer, fails, and cause an exception. In attach...

Id #9450 | Release: None | Updated: Jul 15 at 2:24 PM by RedGlow82 | Created: Jul 15 at 2:24 PM by RedGlow82

COUNTA not skipping empty cells

The function COUNTA should count the number of non-empty cells in the given range: https://support.office.com/en-us/article/COUNTA-function-7dc98875-d5c1-46f1-9a82-53f3219e2509 The current implem...

Id #9449 | Release: None | Updated: Jul 15 at 1:07 PM by RedGlow82 | Created: Jul 15 at 1:07 PM by RedGlow82

Function cross-sheet reference with spaces

When a formula requires a cross-sheet cell reference, the usual syntax is something like: IF(Sheet2!A1>Sheet2!A2,"bigger","smaller") But when the sheet name has spaces, the sheet names must be wra...

Id #9448 | Release: None | Updated: Jul 15 at 11:21 AM by RedGlow82 | Created: Jul 15 at 11:21 AM by RedGlow82

.SaveAs(MemoryStream ms) does not progress when saving two .xlsm files (each about 7MB) at the same time

Hi, I wonder if anyone has any idea about the issue stated in the title. To reproduce the issue, I created a console project and below is the code in my Program.cs file: using System; using System...

Id #9447 | Release: None | Updated: Jul 6 at 6:57 PM by NiFang | Created: Jul 6 at 4:18 PM by NiFang

XLWorkbook_Load does not load NamedRanges in specific sheets

When loading an existing workbook that contains named ranges, ranges are only applied at the Workbook level even if the range is for a specific Worksheet. The crux of the problem is the "LoadDefine...

Id #9446 | Release: None | Updated: Jul 6 at 2:28 PM by mklaber | Created: Jul 6 at 2:14 PM by mklaber

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