Bug 128125 - Literal dates not processed (?parsed) logically.
Summary: Literal dates not processed (?parsed) logically.
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.7.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-10-13 22:24 UTC by jack.deans
Modified: 2019-10-13 22:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description jack.deans 2019-10-13 22:24:28 UTC 
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
Comment 1 m_a_riosv 2019-10-13 22:59:32 UTC 
The last four, (= before) are interpreted as operations, with result equal or similar to 0,0000412745584.

Dates are kept by spreadsheets as numbers where the integer part are days, being date base for zero is 30 Dec 1899.