Created attachment 112706 [details] test files Steps to reproduce: - open xls and xlsx file Actual results result of C2:F2 is Error:522 Expected results result of C2:F2 is 1,4142 1,7321 2,0000 2,2361 Printscreen from excel and LO in the test file.
Created attachment 112710 [details] 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.
Winfried, in your document the range references are in normal formula mode and as such are evaluated as position dependent automatic intersections instead of array references. If you put the same formula in A12 you'd get an error because there is no intersection between the formula cell position and the range referenced. Raal's documents contain array formulas, the Err:522 circular reference error we produce is certainly wrong, and I'm quite sure it worked some time ago.. This should not be related to the SQRT() function put probably any function that expects a scalar value parameter (e.g. ABS(), ...) when passed a range in array mode when imported from Excel documents exposes this behavior. I didn't check.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.