https://bugs.freedesktop.org/show_bug.cgi?id=88737
--- Comment #1 from Winfried Donkers <[email protected]> --- Created attachment 112710 --> https://bugs.freedesktop.org/attachment.cgi?id=112710&action=edit test file with additions I don't know if this is a Calc-bug. The OpenFormula definition of SQRT says that the argument is a number and so does the Excel function description. In the attachments, the argument is not a number, but a range. Were the range B2:F2, it would have worked in Calc, but the range includes the cells where the results are stored. This is IMHO an incorrect function call. If I enter in cell B8: "=SQRT(B2:F3)<Ctrl-Shift-Enter>", I get expected correct results in row 8 and expected error messages in row 9 (I would even expect an error in B9). The results in B3:F3 are IMHO not right: the input is a 2-row array and the output should be a 2-row array as well. -- 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
