[Libreoffice-bugs] [Bug 138313] La fonction de calc NB.MOIS erreur

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138313

Ming Hua <ming.v.hua at qq.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ming.v.hua at qq.com

--- Comment #1 from Ming Hua <ming.v.hua at qq.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201119/42c87755/attachment.htm>