Conditional format doesn't work properly
Posted: Wed Feb 17, 2016 8:50 am
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.
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.
(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
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.
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.
(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