XLSReadWriteII 5 - NumberFormat
Posted: Fri Dec 14, 2012 2:49 pm
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
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