<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:ming.v.hua@qq.com" title="Ming Hua <ming.v.hua@qq.com>"> <span class="fn">Ming Hua</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - La fonction de calc NB.MOIS erreur"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138313">bug 138313</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>ming.v.hua@qq.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - La fonction de calc NB.MOIS erreur"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138313#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - La fonction de calc NB.MOIS erreur"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138313">bug 138313</a>
from <span class="vcard"><a class="email" href="mailto:ming.v.hua@qq.com" title="Ming Hua <ming.v.hua@qq.com>"> <span class="fn">Ming Hua</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=167399" name="attach_167399" title="Sample file with the two MONTHS() formulas, in English locale">attachment 167399</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=167399&action=edit" title="Sample file with the two MONTHS() formulas, in English locale">[details]</a></span>
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.
<a href="https://help.libreoffice.org/latest/en-US/text/scalc/01/04060111.html?DbPAR=CALC#bm_id3152898">https://help.libreoffice.org/latest/en-US/text/scalc/01/04060111.html?DbPAR=CALC#bm_id3152898</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>