To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=97038
Issue #|97038
Summary|Regression of Basic function DateSerial
Component|scripting
Version|OOO300m9
Platform|PC
URL|
OS/Version|Windows XP
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|kr
Reported by|bmarcelly
------- Additional comments from [EMAIL PROTECTED] Mon Dec 8 20:33:47 +0000
2008 -------
Run this Basic macro :
Sub Main
Dim v
v = DateSerial(0,1,1)
Msgbox ("Date : " & v)
MsgBox ("Value : " & CDbl(v))
End Sub
Result in 1.1.5, 2.4.2, 3.0 (300m9) :
Date = 01/01/1900
Value = 2
Result in DEV300m37 :
Date = 01/01/2000
Value = 36526
In DEV300m37 a year in 2 digits seems interpreted as declared in Tools >
Options >
OpenOffice.org > General.
Before this version it was always interpreted as 19xx. This change may cause
problems
in existing macros. If this was introduced for VBA compatibility, the change
should
be only working with Option VBASupport 1.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
