[Libreoffice-bugs] [Bug 134032] New: 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

            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 at lists.freedesktop.org
          Reporter: olivier_musson at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200616/156cec2b/attachment.htm>