Page 1 of 1
Preserve cell formating
Posted: Wed Sep 23, 2015 9:55 am
by pmal
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
Re: Preserve cell formating
Posted: Thu Sep 24, 2015 8:00 am
by larsa
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.
Re: Preserve cell formating
Posted: Fri Sep 25, 2015 7:52 am
by pmal
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.
Re: Preserve cell formating
Posted: Mon Sep 28, 2015 9:36 am
by larsa
Hello
OK, I understand. Will fix this in the next update.
Re: Preserve cell formating
Posted: Tue Sep 29, 2015 8:00 am
by pmal
Thanks!