Autosize columns version 5 not correct

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
rjvanvliet
Posts: 17
Joined: Fri Feb 01, 2013 8:24 pm

Autosize columns version 5 not correct

Post by rjvanvliet »

The auto sizing of columns is not working correct in version 5. Anybody found a solution?
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Autosize columns version 5 not correct

Post by larsa »

Hello

Do you have a sample on this? What values are there in the cells?
Lars Arvidsson, Axolot Data
pl00
Posts: 11
Joined: Sat Feb 09, 2013 8:44 pm

Re: Autosize columns version 5 not correct

Post 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.
rjvanvliet
Posts: 17
Joined: Fri Feb 01, 2013 8:24 pm

Re: Autosize columns version 5 not correct

Post by rjvanvliet »

Lars I sent you mine excel-file.
Post Reply