Google spreadsheet annoyance

[undyingking]

It seems to be impossible to build a selection from a non-contiguous block, eg. I want to make a chart from the data that would in Excel be a1:a6,c1:c6, but Google just interprets that as a1:c6. Which is a bit of a pain. Surely that's not too abstruse a requirement? I can understand them not letting me build a non-contiguous selection by using ctrl-click as in Excel, but not to be able even to type one seems a bit harsh.

I would like to be able to use Google Docs generally for more stuff, but it often seems that once you get beyond the very simplest of operations, it's still somewhat lacking.

[Poll #1674584]

Comments

[undyingking.livejournal.com]

Mm, that is very much my view of Office too. I use Excel more intensively than the other components, because I don't own a corresponding professional tool in that area.

I'm happy for advanced functions in general not to be included in Google Docs, but I suppose I don't consider selecting cells that aren't en bloc as being an advanced function -- compared with some of the other stuff that they have decided to include.

[bateleur.livejournal.com]

The reason I consider it an advanced feature is because if you want some function of a set of non-contiguous columns you can always, if necessary, build that function up in stages by using intermediate cells. (Which in this case leaves you with something very similar to sea_of_flame's suggested workaround.)

That said, it does seem like the kind of thing it would make sense for Docs to include on the basis that it's a relatively simple feature to implement which will be invisible to anyone not trying to use it, but very welcome for users accustomed to Excel.