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:
(In reply to b. from comment #0) > Description: > with some calculations - fill - which go back into the time of the Julian > calendar calc is making mistakes, > > B3: '1583-31-12' without the quotes, > B4: '1582-31-12' without the quotes, These are not dates at all and conflict with ISO 8601 implicit date acceptance pattern
@Uwe Auer: pardon, typo, try it with: 1583-12-31 1582-12-31
still an issue with: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 6e6e531b564cdc9d5b25287c215cdc5a1fcbb346 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: CL
I'm unable to produce the same behavior in Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded or Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Still repro using Version: 24.2.2.2 (X86_64) / LibreOffice Community Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01 CPU threads: 24; OS: Windows 10.0 Build 22631; UI render: default; VCL: win Locale: en-GB (ru_RU); UI: en-GB Calc: CL threaded