To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=96928
Issue #|96928
Summary|[regression] Edate misbehaves in oCell.setFormula ("=E
|DATE(1; 1)")
Component|Spreadsheet
Version|OOo 3.0
Platform|PC
URL|
OS/Version|Windows, all
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|ui
Assigned to|spreadsheet
Reported by|kpalagin
------- Additional comments from [EMAIL PROTECTED] Fri Dec 5 07:21:49 +0000
2008 -------
1. Open attached file, run the only macro in it - you get #NAME in A1. Note
that setFormula ("=SIN(0)") produces expected result.
2. File-Save, File - Reload - you get 32 in A1.
dim oSheet as object
dim oCell as object
oSheet = ThisComponent.CurrentController.getActiveSheet()
oCell = oSheet.GetCellByPosition(0, 0)
oCell.setFormula ("=EDATE(1; 1)")
oCell = oSheet.GetCellByPosition(0, 1)
oCell.setFormula ("=SIN(0)")
---------------------------------------------------------------------
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]
