Hello, I try to get an algorithm to calculate the right calue for the columnwidth. I want to make the columnwidth in excel to 45 or 22, but when I use setColumnWidth( 0, 45*256) it's not displayed 45 in excel (a bit less). With 22 it's working when I use 22*265. In the documentation it says 1/256th of a characters length. I don't want to try hundreds of numbers.
Greetings, Hans
