https://bugs.documentfoundation.org/show_bug.cgi?id=105772
Winfried Donkers <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |ASSIGNED
Assignee|[email protected] |winfrieddonkers@libreoffice
|desktop.org |.org
--- Comment #6 from Winfried Donkers <[email protected]> ---
Those who tried and got Err501 as result probably just copied Raal's formula (I
did at first too).
The formula does not work directly (i.e. produces Err501) unless you change the
argument separator to what your locale uses and remove the * before and after
-1 in argument 'Start'.
Presently, Calc accepts values for argument Start that are 0 or negative and
replaces them with 1 before processing the formula. As this is not compliant
with ODFF1.2 and differs from the behaviour of Excel, with which we aim for as
much interoperability as possible, I will fix it.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
