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 to upload to Google Cloud Storage buckets using CURL

Signed URLs are pretty nifty feature given by Google Cloud Platform to let anyone access your cloud storage (bucket or any file in the bucket) without need to sign in. Official documentation gives step by step details as to how to read/write to the bucket using gsutil or through a program. This article will tell you how to upload a file to the bucket using curl so that any client which doesn't have cloud SDK installed can do this using a simple script. This command creates a signed PUT URL for your bucket. gsutil signurl -c 'text/plain' -m PUT serviceAccount.json gs://test_bucket_location Here is my URL: https://storage.googleapis.com/test_sl?GoogleAccessId=my-project-id@appspot.gserviceaccount.com&Expires=1490266627&Signature=UfKBNHWtjLKSBEcUQUKDeQtSQV6YCleE9hGG%2BCxVEjDOmkDxwkC%2BPtEg63pjDBHyKhVOnhspP1%2FAVSr%2B%2Fty8Ps7MSQ0lM2YHkbPeqjTiUcAfsbdcuXUMbe3p8FysRUFMe2dSikehBJWtbYtjb%2BNCw3L09c7fLFyAoJafIcnoIz7iJGP%2Br6gAUkSnZXgbVjr6wjN%2FIaudXIqA

Running Apache Beam pipeline using Spark Runner on a local standalone Spark Cluster

The best thing about Apache Beam ( B atch + Str eam ) is that multiple runners can be plugged in and same pipeline can be run using Spark, Flink or Google Cloud Dataflow. If you are a beginner like me and want to run a simple pipeline using Spark Runner then whole setup may be tad daunting. Start with Beam's WordCount examples  which help you quickstart with running pipelines using different types of runners. There are code snippets for running the same pipeline using different types of runners but here the code is running on your local system using Spark libraries which is good for testing and debugging pipeline. If you want to run the pipeline on a Spark cluster you need to do a little more work! Let's start by setting up a simple standalone single-node cluster on our local machine. Extending the cluster is as easy as running a command on another machine, which you want to add to cluster. Start with the obvious: install spark on your machine! (Remember to have Java a

java.lang.IllegalArgumentException: Malformed \uxxxx encoding

I was getting this exception during build while running ant. Googling didn't help much and I was flummoxed because the same code was running fine till now. My code reads a text file and does some operations on the basis of values read. It was only when I saw the text files I understood the error. I had copied the text in wordpad and saved it as .txt file. Wordpad had put lot of formatting information before and after the content. Also there was "\par" after every line, which was giving this error. So moral of the story: if you get this exception check your properties file (or any other file that your code might be reading.)