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:
| Updated: Jul 17 at 3:07 AM by xnasorcerer | Created: Jul 17 at 3:07 AM by xnasorcerer
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.
private static void Main(string a...
Id #9346 | Release:
| Updated: Jul 15 at 11:01 AM by daigoto | Created: Jul 15 at 11:01 AM by daigoto
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:
| Updated: Jul 9 at 8:17 PM by MDeLeon | Created: Jul 3 at 2:32 PM by 2keicy7
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.
Id #9340 | Release:
| Updated: Jul 2 at 8:02 PM by MDeLeon | Created: Jul 2 at 2:13 PM by RobbieDeSutter
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:
| Updated: Jul 9 at 8:20 PM by MDeLeon | Created: Jul 2 at 1:50 PM by ShivaniK
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:
| Updated: Jul 2 at 4:42 PM by MDeLeon | Created: Jul 2 at 1:38 PM by ShivaniK
If I have defined a name that refers to a table range or formula, the ranges property produces an "Invalid Operation Exception"
Name -> ProductionNightDay
RefersTo -> ProductionTab...
Id #9334 | Release:
| Updated: Jul 1 at 5:33 PM by MDeLeon | Created: Jun 25 at 7:30 PM by nlacoff
I finding issues in inserting conditional formulas in closed xml.
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:
| Updated: Jun 24 at 8:34 PM by MDeLeon | Created: Jun 19 at 2:16 PM by manjunathg88
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.
Id #9327 | Release:
| Updated: Jun 4 at 2:24 AM by MDeLeon | Created: Jun 4 at 2:02 AM by timhoffmann
Individual words are detected but if the entire string is bold, false is returned. Am I missing something?
Id #9322 | Release:
| Updated: May 16 at 7:47 PM by MDeLeon | Created: May 16 at 2:03 PM by michaelMcCarver