Set the column width in the code to open the displayed column width different

QtExcel / QXlsx

Excel file(*.xlsx) reader/writer library using Qt 5 or 6. Descendant of QtXlsxWriter.

https://qtexcel.github.io/QXlsx/

MIT License

1.16k stars 359 forks source link

Set the column width in the code to open the displayed column width different #329

Open fwren opened 7 months ago

fwren commented 7 months ago

I use

QXlsx::Document document;
document.setColumnWidth(1, 100);

in the code

But the width displayed in the file is around 700, is this coincidence?

fwren commented 3 weeks ago

I seem to realize that the default unit for setting the width in .xlsx files seems to be the character width, which is different from what I think the actual width is. Could this be the cause of the situation?