To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58903
------- Additional comments from [EMAIL PROTECTED] Tue Dec 6 08:29:52 -0800 2005 ------- My thanks to rainerbielefeld for such a fast reply to my issue and for identifying Issue 5658 as a related issue. I am not familiar with the issue tracker and clearly did a poor search. He is correct that this issue is closely related to Issue 5658 however Issue 5658 is only a symptom of a larger problem that this issue (58903) raises. One should not be able to add or multiply a numeric variable (cell) to a character string variable and get a numeric value. This is what Calc does. Let A1=5 & A2 = foo, then A1+A2 =5 Similarly let A1= '01234 & A2=5, then A1*A2 = 0 It is not a matter that Excel works differently than Calc. The problem is that Calc permits illegal arithmetic operations. Of course, so does Excel. I pointed out the Excel example to show that this problem does not appear to be simply a Calc problem but a problem in at least one other spreadsheet program. --------------------------------------------------------------------- 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]
