https://bugs.documentfoundation.org/show_bug.cgi?id=89166
A (Andy) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |[email protected] Ever confirmed|0 |1 --- Comment #1 from A (Andy) <[email protected]> --- Only issue 1 is for me reproducible with LO 4.4.0.3, Win 8.1, therefore it is maybe a Linux only issue? Issue 1: =IF(C3>0, B3/C3, "No Report") -> confirmed, this is a mistake in the Calc User Guide, it should be ";" instead of "," Sources: - http://www.libreoffice.org/get-help/documentation/ -> LibreOffice 4.0 - 4.1 User Guides -> Calc Guide 4.1 (spreadsheets) -> Page 195 and 415 - http://de.libreoffice.org/get-help/documentation/ -> Handbuch "Calc" (Tabellenkalkulation) -> Kapitel 07 – Formeln und Funktionen -> Page 8 and Anhang B – Calc Funktionen -> Page 33 Issue 2: =IF(3=3; B3/C3) if B3 and C3 are empty it returns "#DIV/0!" and if the cells contain numbers, then there are correctly calculated -> for me not reproducible with LO 4.4.0.3, Win 8.1 Issue 3: =IF(3=3; "10") correct, the result is Text, to have a Number you need to write =IF(3=3; 10) -> for me not reproducible with LO 4.4.0.3, Win 8.1 Issue 4: =IF(3=3; 3) it returns "3" as expected -> for me not reproducible with LO 4.4.0.3, Win 8.1 -- 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
