Description of problem: The attached document opens fine in 1.1.0-16 (fc1). In FC3T1, many of the date fields simply contain hash marks (####). The document also opens fine in Excel XP, but in Excel the fields in question aren't recognized as Date fields, but as Text fields with 'custom' MM/DD/YYYY formatting. I don't know how the document was created but it was probably originally made on Excel 97. Version-Release number of selected component (if applicable): openoffice.org-1.1.1-6.i386.rpm How reproducible: 100% Steps to Reproduce: 1. open the attached document in Openoffice Calc 2. note date fields are filled with ##### Actual results: hash marks Expected results: dates formatted in the MM/DD/YYYY format
Created attachment 104055 [details] Test document
Oh, I forgot, this seems to have only begun to happen when the document in question was exported from OO.o in .xls format. I've recreated the problem by saving other documents (that worked fine before) from OO.o as .xls type.
Doh! The "bug" seems to be that the column widths aren't wide enough. When the columns are expanded, the correct dates appear.
Yeah, its not a bug with date per-se, but what happens when the column isn't wide enough for the text. The font substitution matters here, so the available fonts determine what happens. The font is "Arial" which isn't available, so the closest one is used, and its too wide. There's nothing we can really do about that.