Tuesday, May 4, 2010

Microsoft Office Viewer applications

It's been a couple months now that I've been going without Microsoft Office or Open Office.  I'm creating all my documents in Google Documents.  The biggest problem, at first, was viewing Microsoft Office documents that other people sent  to me.  I would have to upload them to Google Documents in order to view them.

But then I learned about the free Viewer applications provided by Microsoft for Microsoft Office documents.  There is a free PowerPoint Viewer, free Word Viewer, and free Excel Viewer.  These applications make it very easy to open an Office document that someone sends you without having to buy Office yourself.  The PowerPoint viewer and the Word Viewer especially are great, I've had no problems with them.

I have had problems with the Excel Viewer.  First, it does not open comma separated value (CSV) files.  I do a lot of database work with exports of database tables to CSV.  So for CSV files, I still have to upload them to Google Docs to view them.  Also, Excel Viewer does not read HTML files that are saved as .xls files.  This probably isn't common for most people, but again, for my work we sometimes export a table to a text file as HTML text wrapped in the HTML
tags.  When these files have a .xls extension, Excel opens them fine.  Excel Viewer does not.  And Google Docs doesn't like those files either.  So to get those in to a spreadsheet, I have to:
1) Open the file in a browser
2) Highlight and copy the HTML table
3) Paste into a Google spreadsheet

However, if the file is very large, Google will not let me paste it into the spreadsheet.  It gives me an error like, "You can not paste that much data from the clipboard" (and sometimes it just fails with no error).  So then I have to take these additional steps:

3) (instead of 3 above) Paste the copied table into Notepad, which gives me a tab delimited data file
4) Save that text file temporarily
5) Import the tab delimited file into a Google spreadsheet using the spreadsheet's Import... menu item

So those are some ways to work around Excel Viewer's limitations and survive without installing Microsoft Office or Open Office.  Unfortunately, Google spreadsheets also lack some key features, like Print Preview.  So because of the various spreadsheet issues, I still may break down and install Open Office, we'll see.

0 comments:

Post a Comment