Can't open csv file as OpenOffice.org spreadsheet

Discuss the spreadsheet application

Can't open csv file as OpenOffice.org spreadsheet

Postby rankine » Sun Sep 19, 2010 3:13 pm

hi there,
cluless novice here who can't get started.
would be grateful for some clues / help

trying to dowload a csv file into open office spreadsheet
the default option in the popup for the dowload is given as microsoft excel
i browse to change it to openoffice3.2
a open office pop up named 'filter selection' opens
huge list...
i pick the 'Text CSV' option
the pop up for that option opens to ask me to okay it as tab delimited
i do and get an error message - 'general input/ output error'
i've tried a few other options fro the 'filter selection' list. same story...
when i go back to my dowloads window and click onto the file again it comes up in a folder as a microsoft excel file!
i can open this and it's dowloaded succesfully as an excel file even though i asked for it to be dowloaded in open office

thanks in advance for assistance
best,
rankine
open office 3.2
windows
rankine
 
Posts: 8
Joined: Sat Sep 18, 2010 3:27 pm

Re: can't open csv file as openoffice spreadsheet

Postby FJCC » Sun Sep 19, 2010 3:48 pm

Let's worry later about opening the file in OpenOffice.org directly from the web. Try these steps:
1. Save the file on your computer. It will likely have the icon of an Excel file because Excel claims csv files. You can ignore that. It will not have changed the file's format.
2. Start OOo and open a blank Calc file
3. Choose the menu Insert -> Sheet From File
4. Select the Text CSV file type and choose your file.
5. The input filter will appear. Set it up so the file looks right.
6. Click the Ok on the final dialog
Does that method work?
AOO 3.4 or 4.0 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 3678
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby rankine » Sun Sep 19, 2010 5:18 pm

hi,
thanks for your help!

so, to save it i had to open it and it opened as an excel file.
i then followed the steps you set out and managed to save it as an open office spreadsheet file. though i didn't play around with it too much and the formatting is a bit odd.
the thing is i want to be able to dowload direct to open office because i only have a trial copy of excel on this computer, which is not going to let me use it without a key beyond a number of 'hits', and which i want to avoid paying for, hence dowloading office in the first place!

thanks for any further thoughts,
best,
billymac
open office 3.2
windows
rankine
 
Posts: 8
Joined: Sat Sep 18, 2010 3:27 pm

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby therabi » Sun Sep 19, 2010 5:38 pm

rankine wrote:hi,
thanks for your help!

so, to save it i had to open it and it opened as an excel file.
i then followed the steps you set out and managed to save it as an open office spreadsheet file. though i didn't play around with it too much and the formatting is a bit odd.
the thing is i want to be able to dowload direct to open office because i only have a trial copy of excel on this computer, which is not going to let me use it without a key beyond a number of 'hits', and which i want to avoid paying for, hence dowloading office in the first place!

thanks for any further thoughts,
best,
billymac


You are saying "download". How are you downloading the csv file? When downloading from the internet you should have the option to open or save a file. Do you not have the option?
OpenOffice.org v3.3, LibO v3.32 on Ubuntu 10.10 and Win7
User avatar
therabi
Volunteer
 
Posts: 763
Joined: Wed Sep 01, 2010 10:01 pm
Location: USA

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby rankine » Sun Sep 19, 2010 5:59 pm

ok, so saved it as open office file in my dowloads folder
opened office spreadsheet and went to 'insert sheet from file'
picked out the file and got the 'filter selection' box
...again clicked on 'text sv' and got error message
open office 3.2
windows
rankine
 
Posts: 8
Joined: Sat Sep 18, 2010 3:27 pm

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby floris v » Sun Sep 19, 2010 6:46 pm

Don't save it as an OpenOffice.org file, just save it as it is, then open it with Calc. Don't make things harder for yourself than they already are.
MS Windows Vista - AOO 4.0.1 - LibreOffice 4.1.0.4.
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 3029
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby rankine » Mon Sep 20, 2010 6:35 pm

sorry, i don't understand, surely i've got to open / save it with a particular application. how can i save it 'as it is'?
'as it is' would be the default option in the dialogue box - excel
hase any one had to deal with the 'filter selection' box?
open office 3.2
windows
rankine
 
Posts: 8
Joined: Sat Sep 18, 2010 3:27 pm

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby rankine » Mon Sep 20, 2010 6:38 pm

does the fact that the file is zipped change anything?
open office 3.2
windows
rankine
 
Posts: 8
Joined: Sat Sep 18, 2010 3:27 pm

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby floris v » Mon Sep 20, 2010 7:05 pm

That's exactly what I sort of thought. First unzip it, then open the unzipped file. I don't know of any program that will open files in a zip file if you tell it to open the zip file. It's the same with chocolates: you remove the wrapper before you eat them.
MS Windows Vista - AOO 4.0.1 - LibreOffice 4.1.0.4.
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 3029
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby rankine » Mon Sep 20, 2010 7:13 pm

ok,
sorry for the preposterous cluelessness, but i guess...how do i do that?
like i'm not getting a dialogue box asking me if i want to unzip the file.
with default excel option i don't seem to need to unzip it
with openoffice i'm being asked to pick a 'filter selection' - is this the application asking me how to unzip?
but as stated above, i get error message when i choose a selection
open office 3.2
windows
rankine
 
Posts: 8
Joined: Sat Sep 18, 2010 3:27 pm

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby floris v » Mon Sep 20, 2010 7:21 pm

Is it okay for you to upload that original file here or somewhere else, or to post a link to the original? We seem to have a huge communication problem here. Or post the file name - with extension, that's the part after the period. And just to be sure, make sure that in your Windows Explorer folder options you have turned Hide extensions of known file types off.
MS Windows Vista - AOO 4.0.1 - LibreOffice 4.1.0.4.
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 3029
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby rankine » Mon Sep 20, 2010 7:52 pm

the file name is billymac-inventory-20100919-0537.zip
open office 3.2
windows
rankine
 
Posts: 8
Joined: Sat Sep 18, 2010 3:27 pm

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby floris v » Mon Sep 20, 2010 7:59 pm

Okay, that settles it, then it's a zip file. Zip files are compressed so they take less space. Only special software can handle such files. You didn't say what version of Windows you have, but if the icon of the file looks like a yellow folder with a zipper across it, you can double click it in Windows explorer top open it. You can then drag the file(s) inside it to another location. When you've done that, you should be able to open that/those file(s). If you have a really old version of Windows, you'll have to download a program to extract the files, like Winzip or 7-Zip, unless you already have that.
MS Windows Vista - AOO 4.0.1 - LibreOffice 4.1.0.4.
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 3029
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby rankine » Mon Sep 20, 2010 8:17 pm

the file has an openoffice icon and if i double click it the aforementioned 'filter selection' box opens...
open office 3.2
windows
rankine
 
Posts: 8
Joined: Sat Sep 18, 2010 3:27 pm

Re: Can't open csv file as OpenOffice.org spreadsheet

Postby floris v » Mon Sep 20, 2010 8:40 pm

That's normal for csv, you might have used another character as a column separator, for instance. Just make sure that you have a real csv file now - you can open it with Notepad and then it should look normal. There should be a preview of the structure at the bottom of the dialog box - make sure that you select the correct separator, but that should be a comma.
MS Windows Vista - AOO 4.0.1 - LibreOffice 4.1.0.4.
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 3029
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests