Excel Column Width in XLSX

P

Pusting

Joined
Sep 15, 2017
Messages
2
Reaction score
0
So I set the column's width to 15 using "MS Excel 2016" -> "Home" -> "Format" -> "Column Width...".
It's using the default standard font character unit and I'm using the default font Calibri 11.

But I noticed that internally, inside the XLSX file itself, in the "\xl\worksheets\sheet1.xml", MS Excel has stored this value as ~15.711.
My question is why, why is it different?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - (re-) Set a Table Style 2
Unable to set the desired column width for a table with merged cells 0
Unable to set the desired column width for a table with merged cells 0
XLSX cell width - in twips? 7
Column widths in Excel 2013 16
Excel column width question again 14
how can we change units of column width to pixels? 0
Default Column Width - Excel2007 0

Top