To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=85646
Issue #|85646
Summary|not correct result when macro write the single value t
|o cell and after read the one
Component|Spreadsheet
Version|OOo 2.3.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|programming
Assigned to|spreadsheet
Reported by|mindauga
------- Additional comments from [EMAIL PROTECTED] Mon Jan 28 16:27:23 +0000
2008 -------
Running next macro I get not correct result (see comments in macro):
Sub test
dim value as single
'must be single - with double the problem dissapears
sheet=thiscomponent.sheets(0)
value = 12.51
'value - any number with decimal part except *****.0 and *****.5
'(for example 12.0 and 12.5 are not valid)
print value
'I get 12.51 - it's OK
sheet.getcellbyposition(0,0).value = value
print sheet.getcellbyposition(0,0).value
'must be 12.51 but I get 12.5100002288818
End sub
---------------------------------------------------------------------
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]
