To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=88071 Issue #|88071 Summary|text data corrupted on reopen when saved as HTML: lead |ing zeroes are lost Component|Spreadsheet Version|OOo 2.4.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|jes
------- Additional comments from [EMAIL PROTECTED] Wed Apr 9 00:59:06 +0000 2008 ------- Leading zeroes are wrongly removed when a spreadsheet containing numeric data in text format is saved as HTML and then opened again. This happens in spite of the fact that the HTML file contains the correct data and cell format, and the sheet that results from opening the file preserves the text cell format. Steps to reproduce: 1) File > New > Spreadsheet 2) Cell A1: Format > Cells > Numbers > Category: Text, Format: @ 3) Enter in A1: 00123 4) File > Save > Name: "text123", File type: HTML Document (OOo Calc) (.html) 5) File > Close 6) File > Open > Name: "text123.html", File type: HTML Document (OOo Calc) Note that cell A1 has the correct text format, but the incorrect value of '123'. The leading zeroes have been lost. In the saved HTML file, the cell is represented by this code: <TD WIDTH=93 HEIGHT=17 ALIGN=LEFT SDNUM="1033;0;@">00123</TD> Note that the correct number format and cell value are saved in the HTML file. However, when the file is opened and read into Calc the leading zeroes are removed regardless. Loading "text123.html" into a browser (Firefox), the value is displayed correctly, and it can be copied to the clipboard and pasted into Calc, correctly preserving the leading zeroes in this case. While it is not likely that many people need to save a spreadsheet in this way. This defect means that there is no simple file format for storing formatted data that can be loaded dependably into Calc. HTML would otherwise be a good option for software that needs to generate data to be loaded into Calc for further analysis. Alternative interchange formats either have no formatting support (e.g. CSV), or are far more difficult to generate (.xls, ODF). Data stored as RTF appears to incur the same loss of leading zeroes when opened in Calc. --------------------------------------------------------------------- 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]
