https://bugs.freedesktop.org/show_bug.cgi?id=55071
jimg <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from jimg <[email protected]> --- another example: was reviewing an "[excel challenge][1]" and found an question that I can obtain an answer with excel 2003+ but not in LibreOffice Calc 3.5.4.2. I'm interested in why the solution doesn't work in Calc but does in Excel. For question 6: =STDEV('Raw Data'!C2:C252/MID('Raw Data'!A2:A252,10,4)) And yes, I understand that it is a CSE formula and entered in the formula with ctrl+shift+enter in both excel and calc. Excel returns a result, Calc returns #DIV/0!. Saving / reloading the file in xls or ODS has no effect in Calc - and Calc is configured for cells to auto calculate (Tools > Cell Contents > AutoCalculate on) so that isn't the culprit. Also tried (Tools > Options > LO Calc > Formula = ExcelA1) and edited (add space then remove space) & saved (shift-ctrl-enter) without any change. Any ideas why? [1]: http://cl.ly/1g1N0a2b0b0P0M182d07 -- 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
