[Libreoffice-bugs] [Bug 139510] 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

--- Comment #4 from Colin <that.man.colin at gmail.com> ---
My apologies Mike,
I have finally realised that what appeared to be the correct return of the
month number was simply because I was "pre-loading" the result I expected into
the formula and that it simply performed the HLOOKUP() on a foregone
conclusion.
Formatting the date cell to simply display the month allowed me to mislead
myself into believing the HLOOKUP was on the month descriptor instead of the
preloaded month number.

-- 
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/070ad89c/attachment.htm>