March 5th, 2004


userinfo senji
2004/03/05 16:08:00 - OpenIrritation
Bah.

Part of testing for this bit of work I'm doing on at the moment involves opening a 50-odd column tab-delimited text file into a spreadsheet (where it's easier to read).

I have Openoffice, this should be easy. Is it f***?

File -> Open
Select the file I want
Choose ("Text CSV") from the 'File type' box, which now hides the file I wanted, but still leaves its name in the filename box.
Click Open

If you miss the "Text CSV" bit then it opens it in the Word Processor instead, the stupid application. And there's no "open in spreadsheet" functionality - it has to think that the file is a spreadsheet to be able to do that.

Grrr...
Current Mood: [mood icon] splenetic

< | 5 glosses | comment | > )

userinfo edith_the_hutt
[userpic]
2004/03/05 08:23:00
Rename the file extension. This is really where OpenOffice falls over and is tempting me to buy some decent software to do process data (or at least I will if I need to do data processing beyond this year). Depending on what you want to do I could probably do some minor bits of processing on the software we have here in the department specifically for data analysis.
reply | thread )
userinfo senji
[userpic]
2004/03/05 08:24:44
Since I only ever need to open each file once, changing the file extension doesn't provide much of a help :(.
reply | parent | thread )
userinfo arnhem
[userpic]
2004/03/05 09:44:05
use gnumeric?
reply | thread )
userinfo edith_the_hutt
[userpic]
2004/03/05 10:01:10
There's always IGOR if you want decent data analysis. It does pretty graphs too.
reply | thread )
userinfo senji
[userpic]
2004/03/05 10:02:31
I've finished with the irritating thing now... :-/
reply | parent | thread )

< | 5 glosses | comment | > )

OpenIrritation - Squaring the circle...

> log in
> recent entries
> fiends
> archive
> toothywiki page
> profile
> new entry
> recent comments


> go to top