Apache OpenOffice (AOO) Bugzilla – Issue 31472
spreadsheet data is formatted as number when it's text
Last modified: 2006-05-31 14:29:06 UTC
Attached spreadsheet has 2 colums: Street and Number. If used as datasource, the street numbers with letters in them aren't displayed. I've formatted all cells as Text, and then the Column Format was set to Text too in data view. (F4 key in word processor) Notes 1. Don't know if it affects all databases or just Calc spreadsheets source 2. Might be related to http://www.openoffice.org/issues/show_bug.cgi?id=24671 http://www.openoffice.org/issues/show_bug.cgi?id=4122
Created attachment 16461 [details] street listing
mine
clu->mandreiana: the behavior is completely right - not a bug - spreadsheet is a really primitive format defined: 1. the first row is the title 2. the second define the format (the format you put in calc document has nothing to do with that - it is only valid in calc, spreadsheet databases do not follow that) -> so if you want to have text as format, the second row has to contain a text p.s. to otransfer the format from calc document would be a feature enhancement (you can write an enhancement - i would vote for this)
close
mandreiana->clu: I see now. I'll reopen this and change Issue Type and summary, rather than filling another. Note: Although I'm the reporter, I can't change Issue Type and summary. Would you please do it? Thank you
Created attachment 17915 [details] Example of what Excel creates when importing
Created attachment 17916 [details] Example of what OOo 1.1.2 does with the .cvs file
... I'm sorry. Those attachments were for another bug report, and I can't see an obvious way for me to remove them from this one. Please disregard them (or delete them if you can) as they are completely irrelevant to this issue.
I will check this, soon! Rainer
Changed issue type to Enhancement per clu's explanations
clu->mandreiana: this here get really confusing - please do not reopen bugs instead of writing new ones (one bug one issue) - please write a new issue, if you have a 'new' bug/enhancement etc. - please read: http://qa.openoffice.org/issue_handling/basic_rules.html thx
close again