To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49828 Issue #:|49828 Summary:|Unable to import text files into Calc Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|open-import Assigned to:|spreadsheet Reported by:|chrishk
------- Additional comments from [EMAIL PROTECTED] Tue May 24 23:30:14 -0700 2005 ------- I have made some comments in issue 34078, but I feel that these comments might be overlooked as the issue is not a DEFECT issue. Here are the comments I made on issue 34078: <Comments> Hi all, I have been an OpenOffice user for a while, and started with version 1.1.4. I have downloaded the latest beta build (OpenOffice.org 1.9.100) and must say that I am very impressed with the product. In my line of work, I continually deal with files received from different sources which needs to be imported into our system. The data comes in various formats and have to be "re-worked" to get it into a format suitable to import into our system. The files we receive come in a variety of formats including Fixed-width or a various other delimited type files. Calc is absolutely perfect for this. However, I am unable to import any text file properly into Calc anymore since I started using the new version. I searched all issues I could find and decided to post to this issue. I tried everything to open the files but nothing works - I tried using the OpenOffice dialogs, default system dialogs and even various options - nothing seems to work... I will attempt to list all my methods: 1. File -> "Open" Select file and File Type as "Text CSV (*.csv; *.txt)" Select the "Open" button RESULT: This imports the file into Writer 2. Insert -> "Sheet..." Select "From File" option Select "Browse" button Select file and File Type as "Text CSV (*.csv; *.txt)" Select the "Insert" button 1.1.4 RESULT: Sheet 1 appears in the box next to the "Browse" button and the import dialog pops up. With this, I could still import the file. 1.9.100 RESULT: System seems to think/freeze for a few seconds and then returns to "Insert -> Sheet..." dialog. Nothing happens after this. You are free to close the dialog - the system did not freeze, but no import dialog popped up either. 3. Insert -> "Sheet From File..." Select file and File Type as "Text CSV (*.csv; *.txt)" Select the "Insert" button RESULT: System seems to think/freeze for a few seconds and then returns to "Insert -> Sheet..." dialog. Nothing happens after this. You are free to close the dialog - the system did not freeze, but no import dialog popped up either. (Same as 2.) 4. Insert -> "Link to External Data..." Select the "..." button Select file and File Type as "Text CSV (*.csv; *.txt)" Select the "Insert" button RESULT: System seems to think/freeze for a few seconds and then returns to Insert -> "Link to External Data..." dialog. It did not carry the value of the file that was chosen, but this is a seperate issue... Type the fully pathed name of the file into the dialog and press the Enter key RESULT: System seems to think/freeze for a few seconds and then remains on the Insert -> "Link to External Data..." dialog. This is unfortunately a real problem as this is much needed functionality that used to worked. In my humble opinion, I believe that this warrants a priorty larger than a P3. Could this PLEASE be sorted out for the latest stable version of OpenOffice (v2) as I am already a fan of the new look-and-feel OpenOffice and would not want to be left behind on OpenOffice.org. 1.1.4. By the way, before I forget, I tested the said version on a Windows XP Home Edition platform. Thanks to all the contributors for a great product! </Comments> In addition to this, I have downloaded then latest build/release (1.9.104) and re-tested the functionality. The results remain the same. Any idea if this will be sorted for the final build of OpenOffice.org 2.0? --------------------------------------------------------------------- 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]