XLSReadWriteII 5 - NumberFormat

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

XLSReadWriteII 5 - NumberFormat

Post 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
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: XLSReadWriteII 5 - NumberFormat

Post by larsa »

Hello

This will be fixed in the next update.
Lars Arvidsson, Axolot Data
Post Reply