Red Hat Bugzilla – Bug 133043
Regression: date fields contain ####, works fine on 1.1.0
Last modified: 2007-11-30 17:10:49 EST
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):
Steps to Reproduce:
1. open the attached document in Openoffice Calc
2. note date fields are filled with #####
dates formatted in the MM/DD/YYYY format
Created attachment 104055 [details]
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.