[Libreoffice-bugs] [Bug 128125] New: Literal dates not processed (?parsed) logically.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 128125
           Summary: Literal dates not processed (?parsed) logically.
           Product: LibreOffice
           Version: 6.2.7.1 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jack.deans at cantab.net

I do not know if any earlier version of calc behaved differently.  My windows
is localised for UK.  I encountered the problem while performing simple
arithmetic with dates. I have simplified what I was doing to just entering the
same date several ways and recording what is displayed in a selected format. I
note that changing the date does not change the value displayed.  If the syntax
is deemed at fault an error should be displayed - not an unexplained constant
value.

value entered   value displayed
1/2/2019        1 Feb 2019
=A1             1 Feb 2019   (A1 is as in line above)
=1/2/2019       30 Dec 1899
= 1/2/2019      30 Dec 1899
=(1/2/2019)     30 Dec 1899
=21/12/2018     30 Dec 1899

-- 
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/20191013/acb34a82/attachment.html>