<quote who="Timothy Murphy">
> I had to edit a rather large Excel file.
> Following excellent (no pun intended) advice from ILUG,
> I converted the file under Windows to CSV format,
> and edited that under Linux.
> This solved the problem completely.
> When I transferred the file back to Windows
> it came up perfectly in Excel,
> though the formatting commands (centering columns, etc)
> were lost, but they were easily re-installed.
>> However, I tried editing the .xls file in OpenOffice under Linux,
> and was really quite disappointed with the result.
> In fact I didn't trust the program, and so gave up using it.
>> For example, when I edited one line in the Excel file,
> another line was also affected, at least in the display.
> And the little text-window at the top
> where one can make changes in cells
> was displaced downwards, so I could only see the tops of letters.
>> Finally, when I tried to save the file
> I was told it could not be saved in Excel format,
> but only in some special OpenOffice format.
> This didn't really concern me, as I had decided by then
> that I didn't trust the Excel output.
>> Sad ...
Open Office < > MS Office only seems to work well with simple documents. I
ran into similar issues last year with spreadsheets using formulae.
--
Mr.Michele Neylon
Blacknight Solutions
Hosting, Co-location & Email solutions
http://www.blacknight.ie/
Tel. +353 59 9137101
--
Email scanned by Blacknight for viruses and dangerous content.
Visit http://www.blacknight.ie for more information
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!