Testing Google Spreadsheet

I signed up for the test run of Google Spreadsheet in the morning, and I just got my invitation. So I decided to play around with it. I logged in and I was presented with a blank spreadsheet. Cool.

I started typing some numbers, and the ajax interface seemed quite responsive. Unfortunately you can’t just select a sequence of numbers and drag it to have it repeated, or expanded like in MS excel. But, hey – it’s a web app and MS probably has a patent on that little cell handle thing.

Typing the Spreadsheet

Your file is automatically saved as you type kinda like in Gmail. There is a nice save button on the toolbar if you want to make sure your stuff is saved before you log off or something. If you try to navigate away from the edited page, Google will pop up a dialog to warn you. Basic stuff, that was already implemented in Gmail.

If you navigate away, and then reopen Google spreadsheet it will restore the last auto-save from the previous session.

When you want to open a file, all your saved stuff will be displayed in a nice list as shown here:

Saving

Strangely enough, the list cannot be ordered, or searched. Yes, you read this correctly. Google Spreadsheet does not have a search feature. Either that, or I simply can’t find one. This is really odd. I bet that they are working on it though. I can’t imagine this thing being released without a search feature.

Next thing I tried were the formulas. They work just like in Excel. As you can see on this next screenshot, quite a few excel functions are supported, including conditionals such as if, or boolean operators like not.

Formulas

In other words, most spreadsheets can be seamlessly imported into Google, and their formulas will still work.

Errors are handled nicely, with a little Ajax fade, and a polite error message. I got this one when I tried to center text in the cell that I was currently editing. Apparently that cannot be done.

Errors

You need to click on another cell, then go back and highlight it to apply formating. Eh… I think it would be nicer to simply gray-out some of these buttons when you are editing a cell, but this works too.

I haven’t had a chance to fully evaluate the mult-user feature because I just don’t know anyone else who got the invitation. I will have to hunt someone else down, or apply with a different email address to check this stuff out. But it seems to be a grand idea to allow several people to collaborate on the spreadsheet. It’s nice to see that they put the Writely technology up to a good use.

I decided it was time to fiddle around with some real data. I couldn’t find any useful spreadsheets on my hard drive, so I downloaded some statistical data about Affirmative Action from some .gov website. I simply typed random string in google, and specified filetype:xls – and this was my first result. So the choice was purely random.

Uploading was a tad slow, and Firefox offered to kill the running script as it was bogging down my performance. I let it run, and few seconds later the spreadsheet loaded. It was a relatively big file, but not as big as some of the files used in accounting firms (that have 30+ sheets). This was just a single sheet workbook with maybe 10 pages of actual data. Here is a screenshot of the loaded file:

Real Life Spreadsheet

The site got a tad slow, and scrolling became jumpy at times. But it was still working ok. I also noticed that Firefox ate almost all of my memory. This may be unrelated, as there are known memory leaks in the browser. It was open since yesterday evening, so it’s possible that it was just slowly chewing up my RAM all night and Google Spreadsheet had nothing to do with it. Or maybe it did. I don’t know…

My main complaint is that some of the formating has vanished (mainly the cell borders), and the § symbol simply failed to render. Why is that? Is it really that hard to support cell borders, and properly render ANSI characters?

Last feature I decided to check before writing this, was the download. I made some minor changes to that big file, saved it and downloaded it back. Then I plugged it into excel for comparison. The top spreadsheet is the original, and the bottom one is the Google edited one.

Before and After

If you want to compete with Office you MUST be compatible. OO.org is almost there, but it still gets formating wrong sometimes. Google Spreadsheet failed miserably at retaining original files formating. All the borders were gone. To tell you the truth, I was expecting more from them. This was a big letdown.

And it is a big problem! If someone sends you a spreadsheet, and you load it into google for a quick edit you may destroy all the formating. This a huge usability issue, and it needs to be addressed if Google wants people to treat their application seriously.

But, if you want to generate a simple spreadsheet quickly, Google might be a place to go.

Now they just need a catchy name that starts with G. You know, like gmail, and gcal and gmaps… Gspreadsheet just does not roll of the tongue that easily…

Here is the rundown on my highly scientific Monkey Grading System (as usual, start at 3 bananas):

+1 banana for ZOMG! I'm editing a spreadsheet in a web browser
+1 banana for multi-user collaborative mode! Very cool.
+1 banana for supporting a large subset of MS Office functions
+1 banana for shiny, awesome AJAX interface
-1 banana for failing to display &sec; character
-2 banana for lack of search feature (WTF?)
-2 banana for poor compatibility with MS Office formating (!!!)
 2 banana TOTAL SCORE

I would say that they still have some work ahead of them. The compatibility issues will have to be addressed if they want the chunk of the home desktop market. And a google product without a search feature is just silly.

Update Wed Jun 7 15:51:15 EDT 2006

I managed to play around with the multiuser features today. Big thanks to ara pehlivanian for sharing her his (sorry!) spreadsheet with me :)

Good part is that you can actually see updates being made by others in real time. Well, not really in real time – but asynchronously thanks to AJAX magic. So there is some delay, but it’s probably as close to real time as you can get with a web interface. And once again, this is the same technology that was used in Gmail chat feature – here it is simply applied to a spreadsheet.

There is also the chat sidebar in which you can talk to other people who work on the same document. Again, nothing new here.

Unfortunately there is no version tracking, or a way to find out who edited which part of the document and when. This is very strange because Writley had this functionality. Why is it not in Google Spreadsheet?

I’m guessing that they are still working on perfecting that feature, and adapting it to a spreadsheet format. It would really make no sense to have this collaborative mode, without any way of tracking the changes.

But I guess it is what it is – an unfinished product in an early beta stage.

This entry was posted in programming and tagged , , . Bookmark the permalink.



10 Responses to Testing Google Spreadsheet

  1. Pingback: Review: Google Spreadsheets | ara pehlivanian—Web Standards, Web Culture, Web Everything.™ UNITED STATES WordPress

  2. Hahahaha, sorry to burst your bubble but I’m a guy ;-)

    Reply  |  Quote
  3. Luke UNITED STATES Mozilla Firefox Ubuntu Linux says:

    Oops, did I say her instead of him? Sorry about that :P I fixed the post.

    Not sure why I assumed you were a woman. Heh, one more example that on the internets you can never tell these things.

    Reply  |  Quote
  4. Heh, no problem. With a name like Ara, what do you expect! :-)

    Reply  |  Quote
  5. Luke UNITED STATES Mozilla Firefox Windows says:

    Yeah, it might have been the name :mrgreen: Where is that name from – like what nationality is that, if you don’t mind me asking?

    Reply  |  Quote
  6. It’s Armenian and it’s actually a very common name in that culture.

    Reply  |  Quote
  7. Luke UNITED STATES Mozilla Firefox Ubuntu Linux says:

    Ah, cool. I’m Polish, and my name is actually spelled Łukasz. But no one can figure out how to pronouce that.

    Fortunately, it is actually a biblical name so Łukasz == Luke. The benefit of hving a name like that, is that you can easily find some sort of native spelling for it in most of the western languages. :)

    Of course the root of Łukasz is łuk which means bow (as in bow and arrow) which kinda suggests that the name itself may have existed beforore christianity was introduced in Europe. Go figure…

    And yes, I do get allot of “I am your fater” jokes.

    Reply  |  Quote
  8. Forex HUNGARY Mozilla Firefox SuSE Linux says:

    Hi guys!

    I’ve a Gmail account so I can use the spreadsheet service of Google Inc. On a Windows XP operation system the usage with Internet Explorer and Firefox browsers are OK. However
    on GNU/Linux (exactly: SuSE Linux 10.3) the working with Firefox is really terrible :( SLOW and I can’t restore my Firefox session :( I don’t understand the Google Inc. why doesn’t like (support) the Konqueror. On a GNU/Linux with KDE the Konqueror is the best browser,
    because it’s in integrated in with the desktop, KDE. Google PLEASE support the Konqueror!!!!.

    Reply  |  Quote
  9. Luke UNITED STATES Mozilla Firefox Ubuntu Linux says:

    Btw, Firefox session saving was never intended to save the state of a website dynamically modified by the AJAX scripts.

    The only way you can save the state of a site that has been updated by javascript is to serialize all the javascript objects. But that’s not enough. By the time you restore the site to it’s previous dynamic state by deserializing stored objects, the front end and the back end are already out of sync.

    So I don’t think any browser on the market right now can actually save state of sites such Google Spreadsheet.

    Reply  |  Quote

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>