Page 1 of 1

XLSReadWriteII 5 - NumberFormat

Posted: Fri Dec 14, 2012 2:49 pm
by d3nton
Hello.

How do I change the NumberFormat for only one cell or for a specific row?
If I am using e.g.
XLS[0].Columns[0].Style.numfmt.value := '0%'
it changes then numberformat for the whole sheet.

I also tried
XLS[0].Cell[0,1].numberFormat := '0%'
in order to change the numberformat for Cell[0,1].
This also changes the numberformat for the whole ExcelSheet.

Sincerely
d3nton

Re: XLSReadWriteII 5 - NumberFormat

Posted: Fri Dec 21, 2012 1:24 pm
by larsa
Hello

This will be fixed in the next update.