To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=23078
------- Additional comments from ericinterplas...@openoffice.org Mon Aug 23 14:15:10 +0000 2010 ------- mba wrote: "- every text file is a "delimited" file, because they all contains line ends, spaces, commas etc. So finding out which combination of delimiters qualifies for Calc preference *is* guess work." What's so evil about a little guess work? I have to program IF statements all the time. If a file (say, .tab, .csv, .xls, .txt) is explicitly associated with calc, calc is already doing some guess work to determine the file is not a valid Excel file, nor any other spreadsheet type file, but a text file instead. Therefor the Text Importer dialog comes up. Right now, a tab delimited .CSV mismatch is what I'm having to use. The problem is that I keep having to tell my users to select the TAB checkbox as the delimiter because the Comma checkbox is always preselected. OOo is getting better - Writer doesn't always win anymore but the Comma delimiter checkbox does to winning now. What's wrong with calc inspecting the first two lines for three EXTREMELY common delimiter scenarios in the real business world: 1. test for TAB chars and pre-select the Tab checkbox, 2. test for Comma+Quoted chars and pre-select that checkbox, 3. test for Comma chars and select that checkbox, 4. test for XML, 5. Otherwise select fixed width and let that be the winner. I'll try not reply back till 2017. Sincerely though, thanks for you hard work OOo team! --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org