Skip to main content

Google Spreadsheets : Spread Across Network

Microsoft may not yet be losing sleep over Google's seemingly real WebOffice threat, as yet (and I think some of the things they are saying may be correct as well,combined with present user behavior) but are they really being arrogant or online Productivity Applications (MS Office or Open Office like applications such as PowerPoint or Excel or Calendar) a fad which eventually will pass?

Well leaving that debate to MS and Google, I decided to use Google Spreadsheets. Again you have to sign up and wait for the invite: "First Come,First Served".

I had read earlier that Spreadsheets will affect Excel usage heavily. Can't predict that as yet,but if your use is limited to entering/importing data (.xls and .csv supported) and performing mathematical,financial or statistical formulae on it and you don't need to advanced stuff like creating macros (in short use it like a basic spreadsheet only!) then you are in familiar territory. So apart from allowing importing and exporting data in .xls and .csv formats and preserving formatting done in MS Excel, (i.e. all the text and background colors, as well as fonts are preserved), Google Spreadsheets lets you do almost everything (exceptions as mentioned above) that Excel does.

The formula library is extensive and almost all the functions of Excel are available,but Excel has categorized them, which is not the case here.
Some of the Excel Shortcuts do not work. Insertion of rows and columns is farely basic and I enjoyed doing most of the actions. Google has always earned an honorable mention in UI department and it shows.
'Autosave' introduced with Google Homepage are here also, so your data is saved periodically as you are working on it.
Extra worksheets too can be added.
But these are not the guiding factors for deciding use of Google Spreadsheets.

Since this is an online application, your data is online and available from any where. Add to this the feature that you can invite other people for editing or viewing your file simultaneously. So if you have to share a file with someone else, then rather than updating the file and sending it by mail, it would be better if both of you can access the file simultaneously and decide the edits, through an inbuilt real-time chat! And it is so easy, you don't have to be a geek to do this.

This is the single reason, I believe Google is betting their buck.

The site is Web 2.0 enabled, which is obvious since Google has provided AJAX support to almost all its new applications (Gmail, Calendar, Maps, Google Homepages) and shown its intentions of promoting AJAX with AJAX Search API. (Demo of AJAX Search API).

There are some issues which spoil the party however. The default spreadsheet size is very small (only 20x100) but since rows and columns can be added, you can manage. But a large Excel file can not be imported! Also some of the test files, which I uploaded, were not imported properly and only a part of sheet (having the data ofcourse) appeared.

But I am hopeful that Google will sort out these issues very soon. True, that they have made mockery of 'Beta' (Gmail is still in beta!) but let's trust them. Try it out.

Comments

Popular posts from this blog

How I converted a table in an email to a graph on a website? Hint: Azure Functions and Logic App

This mini-project started as a necessity.  I get an email like this everyday, which gives daily numbers for different metrics. The problem with such an email is that it is difficult to keep track of or gauge the rate of growth of these metrics. If you want to know how what the previous day's numbers were you need to go to the previous day's email.  The better option any day is to have a graph that shows the values of the metrics every day. Something like this: With this goal I set out to make this system but with as less coding and expenses as possible.  First obvious step in the process was to get hold of the email and extract its text. The easiest way to do this is to use Azure Logic App.  Here is what my logic app looks like: When any new email arrives in my Outlook 365 account, with a subject that contains "System usage Stats as on", it passes the body of the email to an Azure function named 'EmailTextCleanerFunction' (code below), whose job is to clean an...

Changing Eclipse Workspace Directory

Recently I moved my entire Eclipse installation directory but the workspace was still getting created in the older location only. And worst there was no option to select the Workspace directory in the Window->Options->Workspace menu. To change the workspace location in Eclipse do this. Goto ECLIPSE_HOME\configuration\.settings directory, edit the org.eclipse.ui.ide.prefs file and change the RECENT_WORKSPACES value to the desired location. If you want that Eclipse prompts you to select workspace when you start it, change the SHOW_WORKSPACE_SELECTION_DIALOG value to true. And you are done!

Hands on review: Yahoo! Mail app for Windows 8

Before you start mocking me for using Yahoo! Mail, let me explain that this is NOT my primary mail account and I use Gmail and Outlook.com for my daily use. Yes, this Yahoo! account was once my daily haunt but that was during college days and those days are long gone. I don't use Yahoo! Mail much but still there are some group subscriptions and I just log in once in a while to see what's happening in those forgotten groups. And due to this reason, I have always kept track of changes in Yahoo! Mail and the fact is that you can blame them for everything but not really lack of trying. Though most of those tries just ended up cluttering the UI and adding somewhat needless features. However, now we hear that new CEO Marissa Mayer is focusing once again on the mail and first major product to come out is Yahoo! Mail app for Windows 8. So how is it? The Login screen is pretty neat and purple background with an envelope watermark is very pleasing, very Yahoo!. However why ...