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

File upload problem: UTF-8 encoding not honored when form has multipart/form-data

The problem that I was facing was something like this. I was using Apache Commons File Upload library to upload and download some file.

I had a form in which user can upload a file and another field 'name' in which she can give any name to the file being loaded.


When I submitted the form, the file was uploaded fine but the value in name field was garbled. I followed all the possible suggestions I found:

<%@page pageEncoding="UTF-8"%> set. <%@page contentType="text/html;charset=UTF-8"%gt; set after the first directive. <meta equiv="Content-Type" content="text/html;charset=UTF-8"> in the head. enctype="multipart/form-data" attribute in the form. accept-charset="UTF-8" attribute in the form.
in the Servlet:
before doing any operations on request object: request.setCharacterEncoding("UTF-8"); For accessing the value

FileItem item = (FileItem) iter.next();

if (item.isFormField()) {

//For regular…

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.)

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%2FIaudXIqAxyz4O6VU%2FIob8RHmf…