To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98611 Issue #|98611 Summary|Insert sheet from file: Considers file suffix rather t |han content Component|Spreadsheet Version|OOo 2.2.1 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|porg
------- Additional comments from [email protected] Thu Jan 29 15:10:50 +0000 2009 ------- It seems that for content recognition of delimiter seperated values the content doesn't matter to the import routine. OOo seems to rather only consider the file-suffix. I have tried the same content packed into different files with different suffixes. --- Part before suffix = Indicates content and used delimiter. Suffix = Just copied the same file and added different suffixes. contacts-semicolon contacts-semicolon.csv -> SUCCESS contacts-semicolon.dsv contacts-semicolon.tsv contacts-semicolon.txt contacts-tab contacts-tab.csv -> SUCCESS contacts-tab.dsv contacts-tab.tsv contacts-tab.txt --- Only when the file ends in ".csv" the routine works correctly, it asks the user for how to interpret the content (which charset, which delimiter, column datatype setting, etc). The other endings "tsv,dsv,txt" or none seem to get ignored, before content analysis even starts. I was using NeoOffice 2.2.5 Patch 6, and I am not sure the OOo equivalent, hence filed it under 2.2.1 --------------------------------------------------------------------- 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]
