IXLColumn.AdjustToContents doesn't work correctly on a HighDPI display

When using a HighDPI display, IXLColumn.AdjustToContents doesn't work as expected; it makes the columns too long, probably by the same percentage as currentDPI / 96. The problem is probably aroun...

Id #9371 | Release: None | Updated: Sep 29 at 7:59 PM by MDeLeon | Created: Sep 29 at 7:16 PM by agarwal6

Unable to create mutex (Exception from HRESULT 0x80131464) - SaveAs into MemoryStream

Hi, I would like to know if you have any idea with the following issue, basically we are opening an excel file (xlsm) and doing some changes on it (cell colors, adding values to some cells.. etc...

Id #9368 | Release: None | Updated: Sep 17 at 3:34 PM by MDeLeon | Created: Sep 11 at 8:14 PM by LucasNET2

bug with localized conditional formatting

I have encountered an issue with conditional formatting when my PC's region and language settings are set to something other than English (specifically, French or Italian). When I create my spreads...

Id #9361 | Release: None | Updated: Aug 14 at 5:19 PM by MDeLeon | Created: Aug 11 at 9:40 PM by TheonMartin

Table Corrupt File (Table in package starts at table2.xml)

When copying a template excel file to the new location and generating rows from data and then opening the file. I get this message: screenshots <?xml version="1.0" encoding="UTF-8" standalone="...

Id #9360 | Release: None | Updated: Aug 8 at 6:07 PM by vbjay | Created: Aug 8 at 5:32 PM by vbjay

trying to save data to a database

I'm trying to save data to a database; excel was generated with ClosedXML. The value of a cell through ClosedXML is not read. But I can not read a DataTable I want to generate for OleDb. I need...

Id #9352 | Release: None | Updated: Jul 29 at 2:10 PM by el_topo_48 | Created: Jul 29 at 2:10 PM by el_topo_48

ClosedXML_v0.73.0.0 (.net 3.5)-worksheet.Columns().AdjustToContents(1) does not work for headers

var workbook = new XLWorkbook(); var worksheet = workbook.Worksheets.Add(dt,"Sample Sheet"); worksheet.Columns().AdjustToContents(1); In case headers in first row are longer than values, this c...

Id #9351 | Release: None | Updated: Jul 29 at 12:26 PM by deimos1986 | Created: Jul 29 at 12:26 PM by deimos1986

How to Add Image In Header Using ClosedXML

Error At AddImage(imagePath,XLHFOccurrence.FirstPage); Error : The method or operation is not implemented. var workbook = new XLWorkbook(); var worksheet = workbook.Worksheets.Add("Covering ...

Id #9350 | Release: None | Updated: Jul 29 at 9:04 AM by metalrose | Created: Jul 28 at 8:04 AM by swapnilmalap

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