https://bugs.documentfoundation.org/show_bug.cgi?id=134032
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected],
| |olivier.hallot@libreoffice.
| |org
--- Comment #3 from Mike Kaganski <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
