https://bugs.documentfoundation.org/show_bug.cgi?id=95440
Bug ID: 95440
Summary: Strange recalculation formulas
Product: LibreOffice
Version: 5.0.2.1 rc
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 120104
--> https://bugs.documentfoundation.org/attachment.cgi?id=120104&action=edit
see to cell K2 (with origin formula) and K3 (changed formula)
Maybe similar to Bug 94924
I have a csv file, that I open in LO and I copy a head of the table (with
formulas) from other table by clipboard. At the end I 'spread' the formulas by
mouse over the all rows of data. Formulas are recalculated during spreading.
It's OK.
But after some update of LO (maybe 4.4? or 5.0?) recalculation is not properly
provided and I must edit the inserted formula between spreading. After some
testing I found, that I can solve the problem by swapping two adding parts of
formula:
Original formula:
=IF(OR(F2="A";F2="B";F2="D");$Y2;IF(F2="C";3,8;IF(OR(F2="E";F2="G");0,2;IF(OR(F2="M";F2="H";F2="K";F2="F";F2="S";F2="R";F2="Z");2;IF(F2="X";1;IF(F2="Y";5;IF(
OR(F2="N";F2="O";F2="T";F2="U");10;IF(OR(F2="J";F2="P");6;IF(OR(F2="L";F2="V");8;0)))))))))+IF(J2>1;(J2-1)*0,75;0)
Changed formula:
=IF(J3>1;(J3-1)*0,75;0)+IF(OR(F3="A";F3="B";F3="D");$Y3;IF(F3="C";3,8;IF(OR(F3="E";F3="G");0,2;IF(OR(F3="M";F3="H";F3="K";F3="F";F3="S";F3="R";F3="Z");2;IF(F3="X";1;IF(F3="Y";5;IF(
OR(F3="N";F3="O";F3="T";F3="U");10;IF(OR(F3="J";F3="P");6;IF(OR(F3="L";F3="V");8;0)))))))))
I was alerted, that correct use of function OR is
=OR(F3="A";F3="B";F3="D")=1
but this does not solve this problem. It can be solved by ctrl-shift-F9.
See you to attached file.
--
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
