/dev/null/kevin

Creating something from nothing, or maybe the other way around
All | Chuisms | Computers | Entertainment | Games | Hockey | Humor | Kids | Life | Music | SciFi | Television
20080623 Monday June 23, 2008
Google Docs FAIL! Computers

While uploading a spreadsheet to Google Docs I got this error:

We were unable to upload this document because of this error:

conversion request did not return an error or a new document

This error message comes from the converter we're using, and hopefully tells you what you need to know to fix the problem.

That's one of the worst error messages I've ever seen.  I'm surprised they didn't draw it on a blue background.  The fact that they suggest that it could actually be helpful is just insulting.

In spite of that error message, I was able to track down the legal thing I was doing and remove it.

On to actually using the spreadsheet.  I updated a few numbers and then tried to resort some rows.

FAIL.

I cannot sort by number.  I can only sort A-Z or Z-A.  Are you kidding me?  Do they really expect that people won't use numbers in a spread sheet?

I also cannot sort just a range of rows, unless I only want them sorted by column A.  The only was to sort by any other column is to sort the entire sheet.  Yes, I can freeze some of the top rows, but if there are any rows I don't want sorted, I am SOL.

It just might be possible to do these things, but I can't figure it out.  Maybe it's just a UI fail, but I don't think so.


Tags:
June 23, 2008 09:26 AM PDT Permalink | Comments [2] | del.icio.us technorati slashdot digg reddit facebook stumbleupon

Comments:

From what I can tell, with Google Docs there are no multicolumn sorts and no sorts by ranges. I believe the same is true of Zoho.

I've found that the A->Z, Z->A does treat numbers properly though. If I start with:

1
10
2

it will get sorted A->Z as:

1
2
10

and sorted Z->A as:

10
2
1

You have to want to sort the whole sheet though.

Posted by Eric on June 25, 2008 at 10:48 AM PDT #

Did one other check in Zoho and it does let you highlight a range and sort by the first column (same A->Z, Z->A pick but works for dates and numbers) without affecting the rest of the sheet. Still a pain though.

Posted by Eric on June 25, 2008 at 11:35 AM PDT #

Post a Comment:

Comments are closed for this entry.
Weblog | Archive of all entries.


Creative Commons License © Kevin Chu, Some Rights Reserved.   This work is licensed under a Creative Commons License.   Sun Microsystems Trademarks are in effect.
All opinons are mine! Mine! Mine! Mine!  Sun Microsystems has nothing to do with them.