https://bugs.documentfoundation.org/show_bug.cgi?id=138313
Ming Hua <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #1 from Ming Hua <[email protected]> ---
Created attachment 167399
--> https://bugs.documentfoundation.org/attachment.cgi?id=167399&action=edit
Sample file with the two MONTHS() formulas, in English locale
NB.MOIS is the French translation for function MONTHS().
I can reproduce the reported behavior that both formulas returning 24, with
both 6.4.7 and 7.1.0 alpha1+ on Windows 10. I've also attached a sample file
with the two formulas. I don't have access to Excel to test the other part.
Our help documentation [1] only describes the third argument of MONTHS()
vaguely: "Type calculates the type of difference. Possible values include 0
(interval) and 1 (in calendar months)."
So not sure if we mean the same thing with this Type argument as Excel does.
And if we don't, we probably should. The current description "in calendar
months" seems to agree with the result 24 though.
1.
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060111.html?DbPAR=CALC#bm_id3152898
--
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
