conditional formats fail to work properly when automatic re-calculation
is switched off. Worse than not working at all some formats are
applied to fields in a seemlingly random way.

Manual re-calc (f9) brings back some of the conditional formats with
no inappropriate display but doesn't handle all applicable conditional
formats correctly.

Scenario:

20k+ line spreadsheet (4MB). One data column has conditional formatting
applied to display orange background colour where flag in reference
column (set either TRUE/FALSE) is TRUE. This conditional format failed
to work at all after re-loading spreadsheet file or after manual
re-calculation.

Another column has two conditional format conditions applied to each
cell. The first applies background colour red if reference column value
is TRUE (value either 1 or 0). The second applies background colour
green if cell value is greater than a reference threshold.

The first condition never works at all unless automatic recalculation
is on. The second condition is applied in a fairly random manner when
file is loaded with no automatic recalculation i.e. the format *is*
applied to some cells, some cells match the criteria others do not.
F9 results in correctly applying the conditional formats but only
for the second condition (correctly does *not* apply the second
format when the first condition is met - but doesn't apply correct
format for first condition). On loading file with auto recalc OFF
the cells with incorrectly applied formats flicker continuously down
to a row where beyond which there is no more flickering (approx
250 rows affected). Flickering does not disappear even after extended wait.

Formula references were made completely relative. Incidentally, Shift-F4
working on these references would be a useful enhancement (not a big deal
though - although remapping the reference afer column insertion would be
a more useful enhancement still - column insertion breaks conditional formats).
Switching automatic recalculation on makes everything work properly (apart
from comments about enhancements above - don't have time to submit more
than one issue).