Saving after saved by libreOffice

If I open a xlsx file with LibreOffice, and save it, and then if I try to edit and save it by code using ClosedXML, it will give an error when saving.

Id #9347 | Release: None | Updated: Jul 17 at 3:07 AM by xnasorcerer | Created: Jul 17 at 3:07 AM by xnasorcerer

CustomFormat at Row

hi. When you save the Excel read that you specify font and fill in the entire worksheet, Font specification and fill the empty cell is disabled. sample code private static void Main(string[] a...

Id #9346 | Release: None | Updated: Jul 15 at 11:01 AM by daigoto | Created: Jul 15 at 11:01 AM by daigoto

Variable Datatype

I am using vb.net as my language and I am having a difficulty determining the correct datatype for some of the examples given, especially the variable for data with ranges. From what I am seeing is...

Id #9341 | Release: None | Updated: Jul 9 at 8:17 PM by MDeLeon | Created: Jul 3 at 2:32 PM by 2keicy7

Style.Font.FontColor incorrectly determined

Hi, In attachment a small excel file: the font color for cells C6, C7, C8, C9 is black (as can be verified by vba). However ClosedXML returns the color Silver for these cells. Code snippet: ...

Id #9340 | Release: None | Updated: Jul 2 at 8:02 PM by MDeLeon | Created: Jul 2 at 2:13 PM by RobbieDeSutter

cell.DataType = cellValues.Date does not work!! Using built-in NumberFormatId=15 displays only the day part of entire date.

i am trying to export a datatable to excel ..for columns with int datatype changing cell.DataType= cellvalues.Numbers works . but cell.DataType= cellvalues.Date does not work. Plus using custom f...

Id #9339 | Release: None | Updated: Jul 9 at 8:20 PM by MDeLeon | Created: Jul 2 at 1:50 PM by ShivaniK

Cannot change the category from "General" to "Numbers" in format cells while exporting from datatable to Excel

While exporting from Datatble to excel ..even though the generated spreadsheet contains numbers as right -aligned the category in Format cells is set to "General" and not "Numbers". I have checked...

Id #9338 | Release: None | Updated: Jul 2 at 4:42 PM by MDeLeon | Created: Jul 2 at 1:38 PM by ShivaniK

Named Reference Conaining Table or Formula Produces Ranges Exception

If I have defined a name that refers to a table range or formula, the ranges property produces an "Invalid Operation Exception" For example Name -> ProductionNightDay RefersTo -> ProductionTab...

Id #9334 | Release: None | Updated: Jul 1 at 5:33 PM by MDeLeon | Created: Jun 25 at 7:30 PM by nlacoff

Problem inserting Conditional Formulas

Hi, I finding issues in inserting conditional formulas in closed xml. For Example: If I want to insert following formula into excel sheet =IF(A1 > 0, Yes, No) It appears as =IF(A1 > 0 ; Ye...

Id #9332 | Release: None | Updated: Jun 24 at 8:34 PM by MDeLeon | Created: Jun 19 at 2:16 PM by manjunathg88

.save() method aborting with ArgumentNullException

This app has been working fine for many weeks, updating the same file, but something has apparently confusing ClosedXML. I've tried both versions 0.69.2 and 0.71.2. System.ArgumentNullException ...

Id #9327 | Release: None | Updated: Jun 4 at 2:24 AM by MDeLeon | Created: Jun 4 at 2:02 AM by timhoffmann

richText.Bold returns false if entire cell text is bold...

Individual words are detected but if the entire string is bold, false is returned. Am I missing something?

Id #9322 | Release: None | Updated: May 16 at 7:47 PM by MDeLeon | Created: May 16 at 2:03 PM by michaelMcCarver