To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71322 Issue #|71322 Summary|Cells containing zero-length strings are saved a blank | cells (XLS export) Component|Spreadsheet Version|OOo 2.0.4 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|raner
------- Additional comments from [EMAIL PROTECTED] Tue Nov 7 15:55:21 -0800 2006 ------- Spreadsheet cells that contain zero-length strings (i.e., "") are apparently turned into blank cells when an Excel spreadsheet is slightly edited and then saved again as an XLS file (Excel 97/2000/XP format). The application that I am working on relies on the fact that cells of type string containing 0 characters and blank cells are distinguishable (which they are, in the XLS file format). When editing a spreadsheet in OpenOffice, all string cells that contain no characters are converted into cells of type blank, which falsifies the information from the original spreadsheet. I have been facing this problem with OpenOffice 1.1.4, for which this problem already was reported as issue 50737. I upgraded to version 2.0.4, in which the problem still persists, which the addition that now even the complete row gets removed if all cells contained zero-length strings (which causes even more trouble for my application at hand). If anyone knows any ways to work around this problem, please let me know. Thanks, Mirko Raner Parasoft Corporation San Diego, CA --------------------------------------------------------------------- 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]
