[Libreoffice-bugs] [Bug 139510] New: CALC MONTH(TODAY)) producing incorrect Descriptor which is exacerbated by adding the value of a reference cell

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139510
           Summary: CALC MONTH(TODAY)) producing incorrect Descriptor
                    which is exacerbated by adding the value of a
                    reference cell
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

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

-- 
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/20210109/dd4ff6bb/attachment-0001.htm>