[Libreoffice-bugs] [Bug 140634] New: calc: date values: problems with change from julian to gregorian calendar, fill functions fail

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140634
           Summary: calc: date values: problems with change from julian to
                    gregorian calendar, fill functions fail
           Product: LibreOffice
           Version: 4.1.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

Description:
with some calculations - fill - which go back into the time of the Julian
calendar calc is making mistakes,  

simple sample:  

B3: '1583-31-12' without the quotes,
B4: '1582-31-12' without the quotes,
fill down with either the small black square lower right corner or 'sheet -
fill cells - fill series ... down - date - year - increment -1' will produce
bullshit (1583-01-01) in the cells below, even trashing the value in B4, 

(it's really not 'the big thing', but this gives hope that the LO community
will solve it quickly ... )

playing around with dates for 
https://ask.libreoffice.org/en/question/294810/arithmetics-with-dates-and-times/?comment=294958#post-id-294958
and 
https://ask.libreoffice.org/en/question/294810/arithmetics-with-dates-and-times/?comment=294958#post-id-294958 

i stumbled about this fail, 

assumed cause: year 1582 is missing 10 days in october reg. change julian ->
gregorian calendar, calculations crossing that border are less trivial than
with other dates, calc has! values for those days (besides they are negative),
calc can! calculate forward fills day by day across that border, but fails as a
calculation with month or years hits the year 1582, 

didn't investigate further if more things affected, didn't investigate versions
prior 4.1.6.2 but assume 'inherited', didn't investigate linux but assume
'all', 

partly 'Translated with www.DeepL.com/Translator (free version)', thus may have
weaknesses in wording, logic and numbers :-(

Steps to Reproduce:
1. see above description


Actual Results:
1583-01-01

Expected Results:
meaningful dates


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 62dff2844b0bf1d1bcb8eb4d6db529ef4a31bee4
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc:

-- 
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/20210224/b6dfec9b/attachment.htm>