Hello,
how to keep the cell format after calling Cell[x, y].AsBlank: = true; in current version XLSRW ?
In version XLSRW 4 remained formatting preserved.
Thank PMal
Preserve cell formating
Re: Preserve cell formating
Hello
If a cell has formatting, it is a blank cell. The formatting is stored in the cell so you don't has to add a blank cell.
If a cell has formatting, it is a blank cell. The formatting is stored in the cell so you don't has to add a blank cell.
Lars Arvidsson, Axolot Data
Re: Preserve cell formating
Hello,
Thanks for answer, but maybe we did not understand.
I have a cell with some formatting(color,font...) and a value ('XYZ').
How clear cell VALUE ('XYZ') without losing formatting?
In previous version xlsrw 4 I use AsBlank:= true, cell is cleared and formatting preserved.
In version xlsrw 5 is cell cleared and formatting lost.
Thanks for answer, but maybe we did not understand.
I have a cell with some formatting(color,font...) and a value ('XYZ').
How clear cell VALUE ('XYZ') without losing formatting?
In previous version xlsrw 4 I use AsBlank:= true, cell is cleared and formatting preserved.
In version xlsrw 5 is cell cleared and formatting lost.
Re: Preserve cell formating
Hello
OK, I understand. Will fix this in the next update.
OK, I understand. Will fix this in the next update.
Lars Arvidsson, Axolot Data