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] Tue Mar 3 13:25:49 +0000 2009 ------- Any cell that contains a formula such as =MID(A1;2;999) to trim off the leading £ or $ symbol will behave like this, treated as zero in a calculation. If you're opening an Excel sheet that does this, you'll have to either change it to =VALUE(MID(A1;2;999)), or =MID(A1;2;999)+0. I have a spreadsheet that brings in values from another sheet that I import from a text file that is scraped from a web page, and sums them up with proper numeric cells, and the text values were not being added in. I had to add +0 to all the formulas to make them work in OOo. This goes back to my prior suggestion - if =MID(X;Y;J)+1 works, why doesn't it work when the +1 is in another cell? --------------------------------------------------------------------- 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]
