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 fdservi...@openoffice.org Tue Mar 3 16:21:34 +0000 2009 ------- >philhibbs says: >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. Since MID() is a string manipulation formula, it will result in a string, which you would need to convert to a value, if that is what you want as a result. >If you're opening an Excel sheet that does this, you'll have to either change >it to=VALUE(MID(A1;2;999)) Exactly right >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, I do this all the time, even with text extracted from a pdf file, and it works fine (can't do that with excel!). I find this subject very interesting, can you post an example of the text file that you are trying to import? --------------------------------------------------------------------- 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