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]
