To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658
------- Additional comments from [EMAIL PROTECTED] Wed Nov 2 07:15:57 -0800 2005 ------- >I'll never get it why people think that treating this the Excel >way, 0 in SUM(B2:B3) but 1 in B2+B3, is a better thing to do. I don't think that anyone is specifically arguing that that is better, it is an equally bad state of affairs, and I was unaware of this behaviour before today. I guess it comes down to the fact that Excel is already entrenched. The little-green-triangle is in some respects a good development (although it is obviously a hack to work around legacy behaviour without introducing incompatability), although it annoys me when I import a file containing telephone numbers and thousands of green triangles appear, and I can't just get rid of them all. Can anyone explain what is going on in my example - the calculation fails because, at some point in the past, I had typed in '1 and then overtyped it with 1 again. Both B3 cells are formatted as text, but one works and the other doesn't. I just went back to Excel and tried calculating using cells that contain =MID(x,y,z) and this also works if I set the formula to A+B, but not for sum(A:B), and this rings a bell from back when I had to do that. I think I had another column set to =A+1 and summed that. In summary, Excel sucks as well, but I already knew that. --------------------------------------------------------------------- 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]