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

m.a.riosv <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]
                   |                            |rg
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #1 from m.a.riosv <[email protected]> ---
In the formula is used the value 112 to set up a year with DATE(), that it's
forbidden in LibreOffice.
Year is an integer between 1583 and 9957 or between 0 and 99. (first link)
Year is a non-negative integer value or a reference to a cell containing that
value, which is the year to be used. Values in the range 0 to 99 are converted
to four-digit years in accordance with the Year (Two Digits) setting on the
Tools ▸ Options ▸ LibreOffice ▸ General dialog. (second link)

Please take a look on the help for DATE()
https://help.libreoffice.org/7.6/en-US/text/scalc/01/func_date.html?DbPAR=CALC#bm_id3155511
some more explanations on:
https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATE


There is not a bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to