[Libreoffice-bugs] [Bug 134032] Formula cell used in macro with function EOMONTH() or FIN:MOIS() giving #NAME?
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Tue Jun 16 10:59:07 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=134032
Mike Kaganski <mikekaganski at hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |erack at redhat.com,
| |olivier.hallot at libreoffice.
| |org
--- Comment #3 from Mike Kaganski <mikekaganski at hotmail.com> ---
It's best if you provide the spreadsheet with the macro that shows the problem.
However, the problem with EOMONTH is likely because it's actually an add-in
function, and thus its internal name (that is used when assigning/reading
cell's formula using get/setFormula()) is
"com.sun.star.sheet.addin.Analysis.getEomonth".
To test, put EOMONTH formula in A1, and call this:
> sub getFormula
> oCell = ThisComponent.Sheets(0).getCellByPosition(0,0)
> msgBox oCell.getFormula()
> end sub
It's OK that it needs you to use the locale-independent name like that
"com.sun.star.sheet.addin.Analysis.getEomonth" instead of user-visible
"EOMONTH" in setFormula; the problem is that the function is not mentioned as
add-in function in help [1], [2].
[1] https://help.libreoffice.org/6.4/en-US/text/scalc/01/04060111.html
[2] https://help.libreoffice.org/6.4/en-US/text/scalc/01/func_eomonth.html
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200616/582c3c17/attachment.htm>
More information about the Libreoffice-bugs
mailing list