| View previous topic :: View next topic |
| Author |
Message |
CoreInsanity
General User
Joined: 19 Aug 2007
Posts: 7
|
 Posted: Sun Aug 19, 2007 7:48 am Post subject: How do I force something to open in Calc? |
 |
|
I am trying to open a tab-delimited file in calc, however, I can not get it to open. Whenever I try to open it, calc proceeds to open Writer and sticks it in that. If I click and drag the file into calc, it inserts a picture-like object of part of the file with an anchor-link looking icon and resize points.
Excel has no problem opening it as tab-delimited, however, excel removes a key component of the file, the names have quotations (" ") around them, and it removes them hence breaking the program I am modding this file for.
Thanks.
Edit: Quote from one of my posts below:
| Quote: |
Currently, I have tried the following (Mostly before I made this post):
1) Opening it directly in calc: I have tried doing file -> open, or just open in the calc program itself, and calc opens writer and throws it in there.
2) Telling windows to always use calc to open this program, and using open-with to tell it to open with calc, however, it yet again gets thrown into Writer when open-office is loading it.
3) Renaming it to .csv, and re-doing all of the above with the new extension.
|
Last edited by CoreInsanity on Sun Aug 19, 2007 11:00 am; edited 1 time in total |
|
| Back to top |
|
 |
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Sun Aug 19, 2007 8:48 am Post subject: |
|
|
| Make a copy but name it as a .csv file extension. |
|
| Back to top |
|
|
CoreInsanity
General User
Joined: 19 Aug 2007
Posts: 7
|
| Posted: Sun Aug 19, 2007 9:23 am Post subject: |
|
|
| RickRandom wrote: | | Make a copy but name it as a .csv file extension. |
Tried this, it still opened it in writer (Forgot to mention that in the first post I think).
lol, my bad, ill try csv - I keep getting the extension csv mixed up with the store cvs...
edit: Ok, tried csv, and it still opened it in writer. |
|
| Back to top |
|
|
thomasjk
Super User
Joined: 16 Dec 2005
Posts: 2310
|
| Posted: Sun Aug 19, 2007 10:25 am Post subject: |
|
|
| Right click and Select Open with Choose Program and Select scalc. Then tell it to always use this program. |
|
| Back to top |
|
|
CoreInsanity
General User
Joined: 19 Aug 2007
Posts: 7
|
| Posted: Sun Aug 19, 2007 10:35 am Post subject: |
|
|
| thomasjk wrote: | | Right click and Select Open with Choose Program and Select scalc. Then tell it to always use this program. |
Tried this too, however, when it opens it with calc, calc itself opens writer and sticks it in that. So its not windows doing, i even went in and changed the program associated with the file extensions .def and .csv to calc, and it does the same thing (Opens calc then sticks the file in writer and closes calc). |
|
| Back to top |
|
|
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Sun Aug 19, 2007 10:49 am Post subject: |
|
|
If you're using Windows XP, it often doesn't let you see the file extension, so although you think you've renamed it filename.csv, it may actually be filename.csv.txt so perhaps it's still a txt file.
If you're not certain that it's really a .csv file, change the folder options in Explorer to see the file extension, or open the file in Notepad then Save As and explicitly name it as a .csv file.
There also seems to be a "feature" that OO remembers which application was last used for that file. (Difficult to be certain of this observation.)
As thomasjk says, right-click on a csv file in Explorer, Open With, and choose OpenOffice. For me, it opens in Calc. |
|
| Back to top |
|
|
CoreInsanity
General User
Joined: 19 Aug 2007
Posts: 7
|
| Posted: Sun Aug 19, 2007 10:59 am Post subject: |
|
|
| RickRandom wrote: | If you're using Windows XP, it often doesn't let you see the file extension, so although you think you've renamed it filename.csv, it may actually be filename.csv.txt so perhaps it's still a txt file.
If you're not certain that it's really a .csv file, change the folder options in Explorer to see the file extension, or open the file in Notepad then Save As and explicitly name it as a .csv file.
There also seems to be a "feature" that OO remembers which application was last used for that file. (Difficult to be certain of this observation.)
As thomasjk says, right-click on a csv file in Explorer, Open With, and choose OpenOffice. For me, it opens in Calc. |
Aye, making it show extensions is the first thing I do after I reformat  So I can confirm 100% it is not a .txt or the original extension .def.
Yes, windows can remember the last program used, however I have tried telling windows to open it with calc - but as I said, it opens writer though.
Currently, I have tried the following (Mostly before I made this post):
1) Opening it directly in calc: I have tried doing file -> open, or just open in the calc program itself, and calc opens writer and throws it in there.
2) Telling windows to always use calc to open this program, and using open-with to tell it to open with calc, however, it yet again gets thrown into Writer when open-office is loading it.
3) Renaming it to .csv, and re-doing all of the above with the new extension.
(Also posting the above list in my first post, so new people to read it can see and we dont end up getting repeat advice in here).
It seems to be an issue with open office.
Thanks for the replies so far. |
|
| Back to top |
|
|
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Sun Aug 19, 2007 11:21 am Post subject: |
|
|
Sorry, didn't realise that you already knew more than me 
I can't offer any cunning plan at the moment... |
|
| Back to top |
|
|
CoreInsanity
General User
Joined: 19 Aug 2007
Posts: 7
|
| Posted: Sun Aug 19, 2007 11:33 am Post subject: |
|
|
| RickRandom wrote: | Sorry, didn't realise that you already knew more than me
I can't offer any cunning plan at the moment... |
Nothing to be sorry about Sorry if I sounded a bit rude in that, bit annoyed (Been trying to get this to work between OO and excel for the last few days.)
And Ill look for that setting in OO, just realized you meant open-office (Bit tired) to see if its forcing it to open it in writer due to that.
Also have some one I know looking into why excel removes the " " around text.
edit: Ok, i have it working - I copied and pasted the contents into calc. |
|
| Back to top |
|
|
thomasjk
Super User
Joined: 16 Dec 2005
Posts: 2310
|
| Posted: Sun Aug 19, 2007 12:27 pm Post subject: |
|
|
| Quote: | | Excel has no problem opening it as tab-delimited, however, excel removes a key component of the file, the names have quotations (" ") around them, and it removes them hence breaking the program I am modding this file for. |
I created a Tab delimited file from my email address book. I then followed my earlier suggestion and was able to open it with Calc. It seems as if the " " are what is the difference. My tab delimited files had no quotes whereas yours does and this causes an issue. I'm not sure why you have quotes in a tab delimited file. The file seems to be a combination of CSV and Tab delimited. |
|
| Back to top |
|
|
Hagar Delest
Super User
Joined: 06 Feb 2006
Posts: 5167
Location: France
|
| Posted: Sun Aug 19, 2007 12:40 pm Post subject: |
|
|
To import a non Calc file (.ods) in Calc, you have to open it through the menu Insert>Sheet from file IIRC.
Thanks to add '[Solved]' in your first post title (edit button) if your issue has been fixed.
_________________
Now on the EN user community forum |
|
| Back to top |
|
|
CoreInsanity
General User
Joined: 19 Aug 2007
Posts: 7
|
| Posted: Sun Aug 19, 2007 12:42 pm Post subject: |
|
|
| thomasjk wrote: | | Quote: | | Excel has no problem opening it as tab-delimited, however, excel removes a key component of the file, the names have quotations (" ") around them, and it removes them hence breaking the program I am modding this file for. |
I created a Tab delimited file from my email address book. I then followed my earlier suggestion and was able to open it with Calc. It seems as if the " " are what is the difference. My tab delimited files had no quotes whereas yours does and this causes an issue. I'm not sure why you have quotes in a tab delimited file. The file seems to be a combination of CSV and Tab delimited. |
As I explained earlyer (Perhaps not very well), the quotes are needed by the program im modding the file for. Quotes around a word (string) in programming [depending on the language] declares that word as a string object, hence removing the quotes makes the game screw up (It hits that, expects a string [and as just pointed out, strings have " " or ' ' around them to declare them as such] and gets messed up because the quotes are gone.)
The problem is, the quotes are at the start and end of a cell, and it sees the quotes as a text delimiter. Changing the text delimiter field to blank (nothing filled in at all) in the "Text Import" window when pasting the contents of one of the files seems to fix that problem (On Open Office).
However, I still can not just tell it to open a file directly.
And yea, I think this is confusing the program some.
| Hagar de l'Est wrote: | To import a non Calc file (.ods) in Calc, you have to open it through the menu Insert>Sheet from file IIRC.
Thanks to add '[Solved]' in your first post title (edit button) if your issue has been fixed. |
Will test this and change it to [solved] if fixed. Thanks
edit: This does not work either  when I select the file it will not add it to the list of files. |
|
| Back to top |
|
|
Hagar Delest
Super User
Joined: 06 Feb 2006
Posts: 5167
Location: France
|
| Posted: Sun Aug 19, 2007 12:50 pm Post subject: |
|
|
Can you upload a sample of your tab delimited file on a file sharing web site (like mediafire.com) ? If there is any sensitive data, replace by dummy text.
_________________
Now on the EN user community forum |
|
| Back to top |
|
|
Hagar Delest
Super User
Joined: 06 Feb 2006
Posts: 5167
Location: France
|
| Posted: Sun Aug 19, 2007 1:01 pm Post subject: |
|
|
| CoreInsanity wrote: | | However, I still can not just tell it to open a file directly. |
If I follow you, you managed to import the file as you wished but you want to do it without going through the import menu and text delimiter modification, right ? Perhaps it's possible with a macro. You can try to record it.
_________________
Now on the EN user community forum |
|
| Back to top |
|
|
CoreInsanity
General User
Joined: 19 Aug 2007
Posts: 7
|
| Posted: Sun Aug 19, 2007 1:13 pm Post subject: |
|
|
First off, a sample:
basically something like:
| Quote: |
entry 192 "name" 1 9 2 2.1 2 2 5 | "name"
entry 125 "name" 1 9 2 2.1 2 2 5 | "name"
entry 161 "name" 1 9 2 2.1 2 2 5 | "name"
entry 123 "name" 1 9 2 2.1 2 2 5 | "name"
|
(all values are faked, as are how many columns [actually many more than that, but it only has 2 of the name ones that its breaking]).
it removes the " " from the name. Entry dosnt need them, nor did it have them. However, this is only on excel, it does not do this for OO when setting the text delimiter to " " (Blank).
As for the second post:
Some what, I dont mind telling it how to import it with the text import, I would just like to be able to do like open->(select the file) and it opens and asks that, rather than copy-> paste the contents.
Thanks. |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
