https://bugs.documentfoundation.org/show_bug.cgi?id=100759
--- Comment #3 from Eike Rathke <er...@redhat.com> ---
Please don't confuse a blank argument with references to blank cells, a
reference always results in an argument, reference to empty cell usually in 0
in numeric context.
An entirely omitted parameter (e.g. FOO taking two parameters given only FOO(a)
one parameter) is different from a present parameter but omitted argument (i.e.
left blank), e.g. FOO(a,) is given two parameters but with an omitted argument
for the second.
Many functions in Excel can have a present parameter with omitted argument even
if the parameter is required and the omitted argument is usually (not always)
substituted with 0, for example POWER(1,) results in 1
This function here (FVSCHEDULE) and quite some can not..
My assumption now is that those are the functions which for early Excel
versions were implemented in Add-In packs. But as said, that's just a guess for
now.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
