Page 1 of 1

Autosize columns version 5 not correct

Posted: Mon Mar 04, 2013 7:44 am
by rjvanvliet
The auto sizing of columns is not working correct in version 5. Anybody found a solution?

Re: Autosize columns version 5 not correct

Posted: Mon Mar 04, 2013 5:19 pm
by larsa
Hello

Do you have a sample on this? What values are there in the cells?

Re: Autosize columns version 5 not correct

Posted: Mon Mar 04, 2013 9:07 pm
by pl00
I have come across a couple where a number format is applied.

'"$"#,##0.00 - for currencies. I don't think the $ symbol is included in the calculation

dd mmm yyyy and dd mmm yyyy hh:mm - for dates. These don't appear to contribute to the width in anyway.

Re: Autosize columns version 5 not correct

Posted: Mon Mar 04, 2013 9:09 pm
by rjvanvliet
Lars I sent you mine excel-file.