[Libreoffice-bugs] [Bug 146608] Unpredictable CInt(), CLng() results when given erroneous date literals
https://bugs.documentfoundation.org/show_bug.cgi?id=146608 Buovjaga changed: What|Removed |Added Ever confirmed|0 |1 CC||ilmari.lauhakangas@libreoff ||ice.org Status|UNCONFIRMED |NEW --- Comment #3 from Buovjaga --- I get a warning dialog with 1964 015.09.1989 Setting to NEW. Arch Linux 64-bit Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 705b2924a14841883b4a8cac549f7af326d7a185 CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Jumbo Built on 8 December 2022 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146608] Unpredictable CInt(), CLng() results when given erroneous date literals
https://bugs.documentfoundation.org/show_bug.cgi?id=146608 himajin100...@gmail.com changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=93 ||727 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146608] Unpredictable CInt(), CLng() results when given erroneous date literals
https://bugs.documentfoundation.org/show_bug.cgi?id=146608
Alain Romedenne changed:
What|Removed |Added
Summary|CInt conversion of date |Unpredictable CInt(),
|literals raises Error |CLng() results when given
||erroneous date literals
--- Comment #2 from Alain Romedenne ---
Ignore above comments and consider the following Basic routine:
Sub Date2Integer()
Const DAY_ONE = #1899-12-30# ' = 1
MAX_DATE = DateAdd("d", DAY_ONE, 2^15-2) ' #1989-09-16#
Print CInt(#1989-09-16) , CInt(#09/16/1989) , MAX_DATE ' 1964 , 0 ,
#1989-09-16#
Print CInt(#1989-09-16#), CInt(#09/16/1989#) ' 32767 , 32767
Print CLng(#1989-09-16) , CLng(#09/16/1989) , MAX_DATE ' 1964 , 0 ,
#1989-09-16#
End Sub
- Erroneous date literals should raise Error #5 at runtime
OR BETTER
- Be trapped at compile time
When provided with valid date literals CInt() returns a valid 1-32667 number,
otherwise raises an overflow when dates are above MAX_DATE.
Note: DateAdd() intercepts such invalid date syntax with Error #5
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146608] Unpredictable CInt(), CLng() results when given erroneous date literals
https://bugs.documentfoundation.org/show_bug.cgi?id=146608 Alain Romedenne changed: What|Removed |Added Blocks||127592 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=127592 [Bug 127592] [META] LibreOffice Basic incl."Option Compatible" modules -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146608] Unpredictable CInt(), CLng() results when given erroneous date literals
https://bugs.documentfoundation.org/show_bug.cgi?id=146608 Alain Romedenne changed: What|Removed |Added Version|7.2.0.4 release |Inherited From OOo -- You are receiving this mail because: You are the assignee for the bug.
