Bug 123156

Summary:	Calc: When wrong or large number is converted to date, it should give #ERROR and not wrong date
Product:	LibreOffice	Reporter:	monsieurcloug
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	enhancement	CC:	buzea.bogdan, erack, oliver.brinzing
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108252

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.