To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=49828
User matthiasbasler changed the following:
What |Old value |New value
================================================================================
CC|'abdul' |'abdul,matthiasbasler'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sun Jun 19 03:05:32 -0700
2005 -------
Hi chrishk
I can't reproduce your problem. I heavily import CSV and other ascii file and I
was able to import you "TestFile1" without any problem on the first try.
What I did:
- Open OOo Calc (not Writer!)
- Selecte File->Load
- Select your File
- After that, change file type to Text CSV
(Your file is not shown any more because it doesn't have a valid extension.
But that doesn't matter. Just be sure the filename is still entered. )
- Click OK
- The CSV import dialog opens, you can select the format (e.g. "#" delimited)
and OOO will load the file just fine.
Tested with WinXP and OOo1.0.9.
Now to the second file. This one is indeed not accepted, presumably because of
the null characters (which are probably not allowed in CSV files). What you can
do is:
- Load this file into OOo. It will come up in OOo Writer, no matter what you do.
- Save the file as text file with a .csv extension (in order not to overwrite
the original one). This will create a text file with the null characters
removed.
- Open OOo Calc and import the new file there as described above.
Hope that helps.
Please note also:
1.
What causes you all this trouble is that your file has no extension. I would
strongly recomment giving ascii tables the ".csv" extension. This way they are
readily recognized by OOo Calc (and other software) and treated as such. Also,
your approach 3 ("Sheet From File...") will likely work then. (It does for me.)
2.
I'll close this issue. If you believe that OOo not accepting text files with
null characters as "CSV files" is a bug, please open a new bug report (priority
4 I'd say) specifically for this.
Matthias Basler
---------------------------------------------------------------------
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]
