Bug 123156 - Calc: When wrong or large number is converted to date, it should give #ERROR and not wrong date
Summary: Calc: When wrong or large number is converted to date, it should give #ERROR ...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency tree / graph
 
Reported: 2019-02-03 23:58 UTC by monsieurcloug
Modified: 2023-05-07 18:44 UTC (History)
3 users (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 monsieurcloug 2019-02-03 23:58:29 UTC 
Description:
By exemple when I convert 12321321321 to date, that number become 20/12/-3741. This date is invalid but calc don't raise a error !


Steps to Reproduce:
1.Enter a big number by exemple 12321321321
2.convert cell to date
3.

Actual Results:
My cell contains 20/12/-3741

Expected Results:
#ERROR


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Oliver Brinzing 2019-02-05 18:05:35 UTC 
(In reply to monsieurcloug from comment #0)
> My cell contains 20/12/-3741

already reproducible with OOo, but i don't think this is a bug.

@erack: could you help please?
Comment 2 Timur 2019-02-06 17:32:38 UTC 
I'll confirm but as Enhancement.
Comment 3 Eike Rathke 2019-02-08 19:13:57 UTC 
That number as date should not yield that date, it likely wraps around into a negative 32-bit integer when fed to the calendar.
Comment 4 ady 2023-05-07 18:44:26 UTC 
This is no longer repro, since LO 7.3 > WFM.