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]

Is that 'in the cloud' hosted? I'm happy to use Excel on my own desktop, but I use Google Docs for things that I want to be easily shareable-collaboratable.

[rotwang.livejournal.com]

Ah, I see - no, not so much. That would be more in the LotusLive space and I think that is only for pay.