[sc-issues] [Issue 34078] Enhancement of CSV import , i.e. with fixed format files (no field delim itter) leading and trailing spaces should be a utomatically eliminated like in Excel. Also op ening
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=34078 --- Additional comments from [EMAIL PROTECTED] Tue Mar 21 10:29:49 -0800 2006 --- I think there's a problem with the way this bug has been written up... there are two things involved: 1/ how spaces are handled and 2/ opening a .txt file in oocalc should suddenly start oowriter for that file. I've just spent a *very* frustrating afternoon analysing data. It wasn't frustrating because of the quality of the data but the way that I had to go File -> Open then select the file I wanted then scroll down a *long* list of formats to find csv/txt *every* time I opened a file. Guess what... the novelty of that sure wore off pretty quickly. As much as I hate to admit it... it would have been easier and faster with M$Excel where I could have just done a drag+drop onto excel and it would have opened the file in excel and *not* in word just because it was a .txt file. So... ooo devs: how do we go about convincing you that this "feature" is a huge PITA? - 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]
[sc-issues] [Issue 34078] Enhancement of CSV import , i.e. with fixed format files (no field delim itter) leading and trailing spaces should be a utomatically eliminated like in Excel. Also op ening
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=34078 --- Additional comments from [EMAIL PROTECTED] Sun Dec 4 02:31:20 -0800 2005 --- is there a solution to this problem yet? - 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]
[sc-issues] [Issue 34078] Enhancement of CSV import , i.e. with fixed format files (no field delim itter) leading and trailing spaces should be a utomatically eliminated like in Excel. Also op ening a .TXT file in Calc should not automatic ally bring up Writer.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=34078 --- Additional comments from [EMAIL PROTECTED] Tue Jul 26 20:07:37 -0700 2005 --- bug 4925 oops :) - 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]
[sc-issues] [Issue 34078] Enhancement of CSV import , i.e. with fixed format files (no field delim itter) leading and trailing spaces should be a utomatically eliminated like in Excel. Also op ening a .TXT file in Calc should not automatic ally bring up Writer.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=34078 --- Additional comments from [EMAIL PROTECTED] Tue Jul 26 20:06:29 -0700 2005 --- I urge you all to vote on bug 4929. This is a BUG that has had no attention in 3 years. - 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]
[sc-issues] [Issue 34078] Enhancement of CSV import , i.e. with fixed format files (no field delim itter) leading and trailing spaces should be a utomatically eliminated like in Excel. Also op ening a .TXT file in Calc should not automatic ally bring up Writer.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=34078 User stuartprescott changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=27360) tab delimited | |text file that is openned | |by oocalc in writer --- Additional comments from [EMAIL PROTECTED] Mon Jun 20 22:10:44 -0700 2005 --- Created an attachment (id=27360) tab delimited text file that is openned by oocalc in writer - 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]
[sc-issues] [Issue 34078] Enhancement of CSV import , i.e. with fixed format files (no field delim itter) leading and trailing spaces should be a utomatically eliminated like in Excel. Also op ening a .TXT file in Calc should not automatic ally bring up Writer.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=34078 --- Additional comments from [EMAIL PROTECTED] Mon Jun 20 22:09:14 -0700 2005 --- I think this issue is less about whether OOo *can* import a TXT file or not than it is a design issue that OOo ignores the current state of the application in deciding *how* to import it. For example (under OOo 1.1.3 (Debian Sarge)): The simple attachment will open in OOo Calc if and only if I select "Tab Delimited" as the import filter, even though I am already editing OOo Calc. If that import option is not selected, it opens it in Writer. But if I have to import 100 tab-delimited files like this, I don't want to have to scroll all the way down to the "tab delimited" entry (which is helpfully called "Text CSV"... h?) for *every* file. It would be much nicer for OOo to say "I'm currently running Calc, so I'll open this new file in Calc if possible". Even just a persistent checkbox in the open dialogue box to enable this feature would be wonderful... (you could be more clever than that and use a regexp against the file to see if it looks like CSV or TSV, but allowing *easy* override of these default behaviours is important) This is a big barrier to me doing anything serious with Calc (well, that and the graphing component is hopeless, see http://www.openoffice.org/issues/show_bug.cgi?id=3997 for more on that!). Until I can easily import lots of data files from scientific instruments (and then graph them!) Calc will only be a toy for me. (This is perhaps an associated issue... if I run "oocalc testcase.txt" where the file is tab delimited, it opens in Writer not Calc...) - 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]
[sc-issues] [Issue 34078] Enhancement of CSV import , i.e. with fixed format files (no field delim itter) leading and trailing spaces should be a utomatically eliminated like in Excel. Also op ening a .TXT file in Calc should not automatic ally bring up Writer.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=34078 --- Additional comments from [EMAIL PROTECTED] Mon Jun 20 22:08:55 -0700 2005 --- I think this issue is less about whether OOo *can* import a TXT file or not than it is a design issue that OOo ignores the current state of the application in deciding *how* to import it. For example (under OOo 1.1.3 (Debian Sarge)): The simple attachment will open in OOo Calc if and only if I select "Tab Delimited" as the import filter, even though I am already editing OOo Calc. If that import option is not selected, it opens it in Writer. But if I have to import 100 tab-delimited files like this, I don't want to have to scroll all the way down to the "tab delimited" entry (which is helpfully called "Text CSV"... h?) for *every* file. It would be much nicer for OOo to say "I'm currently running Calc, so I'll open this new file in Calc if possible". Even just a persistent checkbox in the open dialogue box to enable this feature would be wonderful... (you could be more clever than that and use a regexp against the file to see if it looks like CSV or TSV, but allowing *easy* override of these default behaviours is important) This is a big barrier to me doing anything serious with Calc (well, that and the graphing component is hopeless, see http://www.openoffice.org/issues/show_bug.cgi?id=3997 for more on that!). Until I can easily import lots of data files from scientific instruments (and then graph them!) Calc will only be a toy for me. - 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]