Bug with conditional formatting when inserting/deleting rows

krilbe · Post by **krilbe** » Mon Feb 25, 2008 2:43 pm

Hi,

Not thoroughly tested yet, but it seems that there's a problem when inserting/deleting a row above a row with conditional formatting or deleting a row that contains conditional formatting.

Version: 3.01.05.

Rough steps (untested):
1. Sheet with conditional formatting in one cell, formula based condition with a formula like "=isempty(C12)" where C12 is the cell itself.
2. Insert row before that formatted one.
3. The conditional formatting is lost.

At a later stage, such a row is deleted, and suddenly the conditional formatting seems to have been applied to the entire sheet.

Hopefully you can find the bug, if there is one, based on this. I'll post more details as soon as I can, hopefully with a tiny test project.

Kjell

Post by **larsa** » Tue Mar 04, 2008 7:38 am

Hello

I will check this.

Lars Arvidsson

krilbe · Post by **krilbe** » Tue Mar 04, 2008 8:15 am

As soon as I find time, I'll try to narrow it down to a simple test case. I've seen problems in various situations when inserting/deleting rows - that formatting is lost, moved or otherwise destroyed or mangled.

Maybe this part of XLSReadWriteII needs a major overhaul?

Kjell