https://bugs.documentfoundation.org/show_bug.cgi?id=134032
Bug ID: 134032
Summary: Formula cell used in macro with function EOMONTH() or
FIN:MOIS() giving #NAME?
Product: LibreOffice
Version: 6.4.4.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: olivier_mus...@hotmail.com
Description:
Hi,
I am using a macro with the EOMONTH() function but when the macro is activated
instead of working and giving the END OF MONTH results I get a #NAME?
In the Options - Libreoffice Calc - Formula I have been ticking the box "Use
function name in English".
In my macro I am using the DATE(YEAR()) which is working perfectly well.
To have the result I want at the end of the macro, I need for each calc sheet
to go again in Option - Libreoffice Cal - Formula and tick the box do APPLY and
OK few times. Ticking "Use function in English or not as no impact. What has an
impact is to tick it and do apply or ok whatever the choice is.
I don't know if it is a bug or not or a language problem but it's like the
function EOMONTH() or FIN.MOIS() is misinterpreted whatever the language is. I
tried both functions and each time I re-execute the macro it doesn't work.
Before this function EOMONTH() was hard coded in the calc sheet cell and worked
perfectly.
But now I need it in a macro...
Many thanks in advance for your help.
Regards.
Olivier
My LO environment is configured all in French.
Steps to Reproduce:
1. Create a macro using the function EOMONTH(A1;1)
2. Write a date in A1 with DATE format
3. In A2 cell execute the macro
Actual Results:
#NAME?
Expected Results:
Computed End of the month from cell A1 value
Reproducible: Always
User Profile Reset: Yes
Additional Info:
It seems to be only when I use EOMONTH() or FIN.MOIS() in a macro.
--
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
