Conditional format doesn't work properly

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
jsfkcz
Posts: 29
Joined: Thu Sep 11, 2014 8:29 am

Conditional format doesn't work properly

Post by jsfkcz »

Hello,
I made template with B2 cell uses conditional format.
The conditional format has formula =B2=1 and if there is value "1", it sets line at the top of cell's border.
Image

I opened the template as a source and wrote some text to the cell D1 only.
At the result file the top line of border has been disapeared.
Image
(I think that the open template and save it by XLSRW causes the same.)

I tried to analyze xml sources of template and result.
The problem is probably at \xl\styles.xml . If I take the styles.xml from template and put it to the result file, everything looks fine again.

The template and result are at http://www.genet.cz/kohout/xlsrw/xlsrw_ ... with_1.zip for download.
I tested it under XLSRW 5.20.70 . Template has been created with Excel 2007.

Josef Kohout
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Conditional format doesn't work properly

Post by larsa »

Hello

There will be an update by the beginning of next week that fixes this.
Lars Arvidsson, Axolot Data
Post Reply