To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87196 Issue #|87196 Summary|string '+' numbers do not compute in MS vba Component|scripting Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|kr Reported by|pflin
------- Additional comments from [EMAIL PROTECTED] Tue Mar 18 14:13:33 +0000 2008 ------- the following in MS VBA will generate a runtime error dim a As String a = "abc" dim b as integer dim c as integer c = a + b ' will fail in openoffice the line above ( in vba mode ) will NOT generate an error different scenarios also show some strangeness in ooo-basic e.g. dim d as double d = 10.2 dim p as String p = "10" dim c as double c = p + d msgbox c will yield 0 if d is 10.1 the result will be 10.11 if d is 10 then the result will be 1010 compare the results with mso really it seems the root cause is that ooo-basic tries with some combinations to create do append strings ( as a result of the + ) and the tries to reconvert these back to numbers again ( to satisfy c as double ) but mso seems to just have a simple algorithm if either p or d is a number then the '+' operation will alway try and convert the string to a number and then do arithmetic --------------------------------------------------------------------- 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]
