Preserve cell formating

[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

[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.

[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.

[larsa]

Hello

OK, I understand. Will fix this in the next update.

[pmal]

Thanks!