So why not optimize for quick and simple operations that casual users do all the time? It would seem that spreadsheets are for manipulating tables of data, and it seems that there are many more small tables in the universe than large tables. In OpenOffice the only way I found was to copy the data out of column, add a new column, and paste the data into the new column. In google docs I just drag a column left or right where I want it. The sort rows feature is under “Data -> Sort” and brings up a popup to configure the sort. (Sort the selected column regardless of other data). In OpenOffice, there is a prominent A-Z icon in the toolbar which does something stupid. In google docs, when you hover over a column header, you get a pull down arrow that lets you choose A-Z or Z-A. (Addition: Even after using Window->Freeze, when sorting you still have to check the hidden box “Range contains column headers”)Ģ) sort rows by the value in a chosen column. In google, I don’t even remember doing it, I think it just happened automatically somehow. In OpenOffice, this is a “Window” option, and you find it under “Window -> Freeze”. So here are the first few things I tried to do that were not as simple as they need to be: After 30 minuets of trying to work with my very simple data, I realized I’d spent 28 minutes trying to figure out how to do basic operations that I took for granted in google spreadsheets. I’ve used OpenOffice on and off for years and years without ever becoming a power user. A few days ago I tried to use OpenOffice for a fairly simple sheet. Recently I’ve been using google docs spreadsheets because they were online and editable from different locations easily. I use spreadsheets every now and then for pretty trivial things.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |