Archive > Technical discussions

A Few Problems

<< < (2/3) > >>

EHM-0654 Jean:
Really obvious suggestion re: MS Office documents is download and use OpenOffice to open them ;) Writer for Word docs, Calc for Excel sheets, etc.

http://www.openoffice.org

(Murray Crane, the online flying coordinator, using the account I built for my Mum :))

EHM-1465 Dominic:
Guys,

I've been trying to use the Timetable downloader for a project I'm working on but for some reason it doesn't open properly in OpenOffice Calc...

It opens (after a long pause) instead in "OpenOffice Writer/Web" in the form of a text based table. This makes it very difficult to search and sort properly!

Anybody got any ideas why this might be happening?

EHM-1703 Philip:
You could try opening it as a CSV file. That may help, let me know. i guess Murray is the best as I think he also uses open office.

EHM-1465 Dominic:
Sorry Phil, no idea what you mean..! How do I open it as a CSV??

EHM-2029 Sotiris:
Hi Dom,

well, I'm not using your office suite as I am currently stuck with M$ Office.
To open a .csv (comma separated values; will explain later) file you use excel.
File-> Open As (if available, otherwise just plain open).

Then you should get a big list with all the info for each flight in one continuous line.
That's where the comma separated values kick in. Each field is separated from the next by a designated character, sometimes a comma or a semicolon, or quotes or something.
In order to tell EXCEL that after each appearance of the designated character a new column starts so that then you will have a separate column for each field you need to:
Data -> Text to Columns

Then tick the option 'delimited' and choose the character used to 'delimit' the fields. (In EHM's case it's the semicolon ; )

Click OK and it should now look like a 'normal' spreadsheet.

Sorry, if it's a bit long but that's how you open a delimited (csv) file.

Navigation

[0] Message Index

[#] Next page

[*] Previous page