[Libreoffice-bugs] [Bug 134032] Formula cell used in macro with function EOMONTH() or FIN:MOIS() giving #NAME?

[bugzilla-daemon at bugs.documentfoundation.org]

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>