To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105039 Issue #|105039 Summary|Scientific numeration wrong displayed Component|Spreadsheet Version|version58 Platform|Unknown URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|aletto
------- Additional comments from ale...@openoffice.org Sun Sep 13 10:33:19 +0000 2009 ------- Referring to this topic: http://www.oooforum.org/forum/viewtopic.phtml?p=340548#340548 it seems that the displaying of scientific numeration in the code of starbasic fails sometimes due to case error. ------------------------------------------------------------------------------- Code Sub Main Dim xSheet As Object, iSheet As Object, iCell As Object Dim v As Double, s As String xSheet = ThisComponent.Sheets(0) v = xSheet.getCellRangeByName("A1").Value s = "=B2 " & -v print s ' value is converted to floating point iSheet = ThisComponent.Sheets(0) iCell = iSheet.getCellRangeByName("C3") iCell.Formula = s ' error #NAME? because E changed to e iCell = iSheet.getCellRangeByName("C4") iCell.FormulaLocal = s ' no error, value converted to fixed point End Sub -------------------------------------------------------------------------------- As reported by the other user there are still possibilities for a work around. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org