Hello all,
I'm using OpenOffice 2.0, running on XP.
This problem is a bit weird: I set a column with conditional formatting to
change color
when a cirteria is met and it works just fine until I save it and reopen it.
The conditional formatting is still in place but a piece of code disappears as
follows:
working : MATCH('Tech Summary'.$A37;$Inventory.$C$46:$C$550;1)-MATCH('Tech
Summary'.$A37;$Inventory.$C$46:$C$550;0)+1<>'Tech Summary'.N37
after save: MATCH('Tech Summary'.$A37;;1)-MATCH('Tech
Summary'.$A37;;0)+1<>'Tech Summary'.N37
notice that: $Inventory.$C$46:$C$550 is missing twice when reloaded.
Anyone seen this before and is there a fix?
Thank you in advance for your help
Rene