Cannot open xlsx with comments generated by LibreOffice

first post: MDC_Produmex wrote: Hello, I'm experiencing an odd issue with ClosedXML: I cannot ope...

latest post: MDC_Produmex wrote: Hello, Apologies for the late answer. I could reproduce a similar...

Validation of cell using fixed List of values

first post: marc80 wrote: In Excel I can do something like this: In ClosedXML I did not f...

latest post: MP28 wrote: After experiencing a similar issue and after much unsuccessful Goog...

Invalid character

first post: simonxy wrote: When i try to save file from dataset: DataSet exportData = new Data...

latest post: Carlos_Cuenta wrote: Thanks a lot MDeLeon, that link help me to fix the code.

XLSB files cannot be read

first post: LucasNET2 wrote: Hi, first I would like to thank for this software, its amazing. I d...

latest post: MDeLeon wrote: ClosedXML doesn't handle .xlsb files because it's essentially a wra...

Does ClosedXML resolve OpenXML's package issue when writing excel files greater than 10MB?

first post: MichaelMcCoy wrote: Hi, When writing an excel file greater than 10MB in size on a web...

latest post: MDeLeon wrote: ClosedXML doesn't use FeedData so you should be in the clear. That ...

Empty cells value on header

first post: DamienDuff wrote: I have a problem where clearing or simply inserting an empty value ...

latest post: MDeLeon wrote: You can't have a table with an empty header/column. Excel doesn't a...

Applyiing password in excel file using closedXml

first post: hasham123 wrote: Hi, I have a requirement where i have to write data to excelwork...

Bijective base-26

first post: jeremyjee wrote: Hi, FWIW, i've written a much less featured xlsx reader/writer for ...

latest post: MDeLeon wrote: Ran another test and GetColumnNumberFromLetter is actually an order...

Possible to Group Columns in Pivot Table

first post: achapin wrote: I've successfully used ClosedXML to generate a pivot table, but the...

latest post: achapin wrote: Eh, it finally occurred to me I could just add a field to the table...

Protecting sheet

first post: pradeep1310 wrote: Hello team, I am trying to protect a sheet with the password and ...