https://bugs.documentfoundation.org/show_bug.cgi?id=55071
Luke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID Severity|major |minor --- Comment #6 from Luke <[email protected]> --- Tools > Options > LO Calc > Formula > Detail calculation setting Custom : "Excel A1" Causes Calc to generate the same results as Excel in Column J. J7:J26 give results, while the rest are #Value In the second example, SeatGeek Excel Challenge.xls: =STDEV('Raw Data'!C2:C252/MID('Raw Data'!A2:A252,10,4)) Calc also gives the same results as Excel, #DIV/0! -- 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
