To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87614 Issue #|87614 Summary|Calc .ods with unicode extension B characters open err |or in windows (with workaround) Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|stephenlee
------- Additional comments from [EMAIL PROTECTED] Sun Mar 30 16:25:52 +0000 2008 ------- Hello Calc with unicode extension B characters save error - Suspect Calc confuses newlines "\n" with some of the characters. Attached Files: 585char.xls - original file with 585 unicode ext B characters in xls format. Only 1 column, each cell contains one character. Total 580 chars. (Note: Calc saves and open correctly in .xls format) 585char_remove1st20char.xls - original file with 565 unicode ext B characters (585 of the original but removed the first 20 chars) 585char.ods - 585char.xls opened by Calc and save as 585char.ods (see 580charerr.jpg) 585char_remove1st20char.ods - 585char_remove1st20char.xls opened by Calc and save as 585char_remove1st20char.ods (see 585char_remove1st20charerr.jpg) 585char_crlf.ods - 585char.ods converted to carriage return + newline "\r\n" format. 585char_remove1st20char_crlf.ods - 585char_remove1st20char.ods converted to carriage return + newline "\r\n" format. Descriptions of testing: When I saved a .xls file to ods format and re-opened it again, I found format error discovered in the file in sub-document content at 585,7 (row,col) I thought only the specific chars cause error, so cut and paste the characters and saved the problematic char alone in a new .ods. It opens correctly. When I removed the first 20 characters (clear the first 20 cells) in the file and saved again, the error shifted to 2487,7 (row,col). The problem seemed to happen at random position. So I suspected Calc confused newlines "\n" with some of the characters in windows environment. My workaround: 1. Rename the .ods file to .zip 2. unzip all the .xml inside 3. open all the .xml file with an editor, re-save them by changing the return method from newline "\n" to carriage return + newline "\r\n" 4. compress them back to the the zip file and rename it back to .ods 5. Now the file can be opened correctly. Result: Using the workaround, I open and save the file correctly even after some complex calculations. (but have to use every time you save) Thankyou Stephen --------------------------------------------------------------------- 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]