To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76510 Issue #|76510 Summary|(api, calc, de/german) inserting formulas into cells w |ith decimal values failed Component|Spreadsheet Version|OOo 2.2 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|programming Assigned to|spreadsheet Reported by|mroe
------- Additional comments from [EMAIL PROTECTED] Thu Apr 19 11:02:33 +0000 2007 ------- On a german OOo it gives a error if you want to insert formulas with decimal values in it into a cell. So it isn't possible to read a value from one cell and insert a formula with this value into any cell. Try the following code at a new calc document with a german locale setting: Sub TestValue Dim oCell As Object Dim dValue As Double oCell = ThisComponent.getCurrentSelection() dValue = 3.45 print "Value: " & dValue 'de: 3,45 'en: 3.45 oCell.setValue( dValue ) print "Value: " & oCell.getValue() 'de: 3,45 'en: 3.45 print "String: " & oCell.getString() 'de: 3,45 'en: 3.45 oCell.setFormula( "=" & dValue ) print "Value: " & oCell.getValue() 'de: 0 'en: 3.45 print "String: " & oCell.getString() 'de: #NAME? 'en: 3.45 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]
