To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93204 Issue #|93204 Summary|Excel compatibility issue: RIGHT function in Excel con |verts returned text string to numbers if numbers; OOo |returns only text Component|Spreadsheet Version|OOo 2.4.0 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|open-import Assigned to|spreadsheet Reported by|markedgar
------- Additional comments from [EMAIL PROTECTED] Thu Aug 28 11:57:48 +0000 2008 ------- When reviewing an Excel spreadsheet, it became apparent that a cell with a RIGHT function in it was referring to a cell with text in it, in the form of "TEXT NUMBER". The RIGHT function was used to extract the NUMBER, and paste that as the result. Excel recognizes that NUMBER is a number, and pastes it into the cell as such. OOo only recognizes NUMBER as a textural part of the string, and pastes it into the cell as text, EVEN THOUGH IT DISPLAYS EXACTLY LIKE A NUMBER! Of course subsequent references to that cell do not provide the correct answer if thought of as a number, when it is in fact text. THIS INCOMPATIBILITY NEARLY COST ME MILLIONS OF DOLLARS!! It was only after berating an Excel user for stuffing up his spreadsheet was it pointed out to me that the results I was viewing was not what had been saved in Excel. I opened the same file in Excel, and verified that it was as they say, and that OOo had simply failed to recognize the numbers. I presume LEFT and any other similar functions would perform similarly, and should also be made compatible. --------------------------------------------------------------------- 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]
