Google Docs Spreadsheet – Better access control needed

I use Google docs to maintain many documentations for a non-profit organization and this has been a very useful, money & time saving application. In my view, following three features will immediately enhance what is already a excellent collaborative product.  These are low-hanging fruits.

  • User access control at worksheet level to view
  • Copying more than 1000 (one thousand cells) at a time
  • Multi-column sorting

In our non-profit organization we have multiple chapters controlling their own documents/ spreadsheets and some times there are situations where I would like to have a single spreadsheet but each work sheet is visible only to a particular chapter or member. For example, a common spreadsheet with 50 worksheets (one for each US state) should appropriately be visible to these chapters.  A California chapter can view California worksheet only and not others.

Currently, I can control the editing access through “Protect Sheet” but not the viewing. See below.

Google, could you please extend the feature to control the viewing along with editing?

Another feature that would be very useful would be copy more than 1000 cells at a time from one spreadsheet to another.   If a worksheet has 20 columns and 250 rows and if one likes to duplicate this data with copy and paste (^C & ^V), she would need 5 attempts :(.

Google, could you remove this limitation?

And finally, sorting by more than one column.  Currently one can sort by a selected (single) column only. Though, this is not a major hindrance but by providing multi-column sorting feature I can avoid bringing data to Excel when I need to sort the data in multiple ways.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s