https://bugs.freedesktop.org/show_bug.cgi?id=86059

--- Comment #7 from m.a.riosv <[email protected]> ---
@senya, as the COUNTIF() seems in your file don't use regular expressions in
the conditions, I think it's easy replace it with other simple formula.

Please test replacing all COUNTIF and COUNTIFS in this way:

October15.C46: =COUNTIFS(AU$6:AU$39;"<=8")
with
October15.C46: =SUMPRODUCT(AU$6:AU$39<=8)

October15.D46: =COUNTIFS(AY$6:AY$39;"<=8";BA$6:BA$39;">=9")
with
October15.D46: =SUMPRODUCT(AY$6:AY$39<=8;BA$6:BA$39>=9)

Also you cand disable Menu/Tools/Cells/Autocalculate, and do it manually with
[F9] or more secure with [Shift]+[Ctrl]+[F9]

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to