<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - CALC MONTH(TODAY)) producing incorrect Descriptor which is exacerbated by adding the value of a reference cell"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139510">139510</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>CALC MONTH(TODAY)) producing incorrect Descriptor which is exacerbated by adding the value of a reference cell
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>that.man.colin@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Sample Sheet attached.
The simple formula =MONTH(TODAY()) with the cell formatted to display the name
of the month produces the descriptor "Dec" even though the correct month is
currently "Jan"
If the descriptor is used as the key for an HLOOKUP on the adjacent table it
returns the correct month descriptor
If the formula is modified to =MONTH(TODAY())+ B1 [preceding cell value] the
effect is unchanged until a value is actually placed in B1 - then the addition
of 1 to the formula causes the descriptor to change to the correct descriptor
for current month and returns the expected result from the HLOOKUP
However, if the value of B1 is changed to any other number then the descriptor
remains at that for the current month and the HLOOKUP returns the correct
descriptor.
Steps to Reproduce:
1 Observe the formula in C1 of the attached sheet
2 It's currently January 2021 so verify the expected result to be "Jan"
3 Observe the result. I'm not convinced it's supposed to be "Dec"
4 Observe the results in C2 & C3 which reflect the correct HLOOKUP return
5 Key a value of 1 into B1
6 Observe the result
C1's "Dec" has changed to "Jan"
The correct HLOOKUP is reflected in C2 & C3
7 Key values between 2 & 11 into B1
8 Observe the result
"Jan" is unchanged in C1
The correct HLOOKUP is reflected in C2 & C3
9 Key 9 Jan 2021 into C1 - which overwrites the formula with 09/01/20211
10 Observe the results in C2 & C3
NOTE: C6 & C7 are simply to confirm the interpretation of TODAY() & MONTH()
Actual Results:
Unless I'm misinterpreting the anticipated results the displayed month
descriptor is not the current month
Expected Results:
Return the current month's descriptor
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded</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>