To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75433 Issue #|75433 Summary|Numeric field interpreted as alpha after import Component|Spreadsheet Version|1.0.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|billmichaelson
------- Additional comments from [EMAIL PROTECTED] Thu Mar 15 17:21:55 +0000 2007 ------- Importing an Excel (.xls) file containing cells with values that are comprised of leading blanks, a dollar sign, then numeric digits - the values are interpreted as non-numeric strings and dependent calculations become zero. Examination of such a cell in OO Calc shows a leading apostrophe (not present in the orignal .xls), thus enforcing the alpha determination. However, keying in the value (leading blanks, dollar sign, digits) caused the value to be treated as a numeric and the spreadsheet behaves as desired, which is to say it behaves as it does when read by Excel. And so it seems that the leading apostrophe is inserted only upon import from the .xls. This doesn't seem to be reasonable behavior because it doesn't match the interpretation which results from key-in of the same value. And practically speaking, it causes a compatibility problem with Excel. --------------------------------------------------------------------- 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]
