To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116383 Issue #|116383 Summary|Inconsistent treatment of zero-length string Component|Spreadsheet Version|OOo 3.2.1 Platform|PC URL| OS/Version|Windows 7 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|sjmachin
------- Additional comments from [email protected] Sun Jan 9 22:14:57 +0000 2011 ------- (a) Importing an Excel XLSX or XLS file that contains a zero-length string: If cell is a zero-length string result of a formula (simplest example: =""), it works OK: COUNTA(cell) -> 1, ISBLANK(cell) -> FALSE, ISTEXT(cell) -> TRUE. However if cell is not the result of a formula (e.g. entered manually in Excel UI by typing '<Enter> or by copy a formula and Paste Special without formula), it treats it like a blank/empty cell: COUNTA(cell) -> 0, ISBLANK(cell) -> TRUE, ISTEXT(cell) -> FALSE. (b) There appears to be no way of manually entering a non-formula zero-length string through the Calc UI: (b1) Typing '<Enter> results in a 1-length string containing the apostrophe. (b2) Copy a cell with ="" formula and Paste Special (no formula) results in a blank/empty 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]
