Google Spreadsheets
I got invited into the limited test for google spreadsheets, and from what I've initially seen, I'm impressed.
Strengths:
UI: I like the fact they use tabs versus buttons to access formulas,
formatting, and sorting. Even though it's more basic, it seems cleaner.
Formatting: The choose format button makes changing the format of the cell, column, or row easier to select. (I like anything that saves me from mouse clicks)
Sorting: This seems to do what excel doesn't. From a standard installation of Excel, if you want to sort a column of data, the safest way to sort is to highlight the whole sheet -- If you don't, excel will only sort column that you selected, and will screw up any other corresponding data, if it exists. If I choose a column to sort in google spreadsheets, it will sort all of the corresponding data on the sheet, not just the column (quite a nice fix -- post seems to relate to the below, so I included it).
2PM Back from Site Visit
Sales guy: How'd the trip go?
IT guy: Went pretty well. Almost had to send your branch manager home though.
Sales guy: Ha, why?
IT guy: After we loaded up all the inventory in an Excel spreadsheet, he kept sorting it wrong. He'd sort just one column. It would scramble the whole thing up and we'd have to delete it and start all over. He did that three times before I banned him from Excel.
Sales guy: You banned him?
IT guy: I banned him.
Exporting: You can export to both excel, and .csv, from the basic sheet I created, it did it's job, no formatting issues, and the formulas remained intact.
Collaboration: Being able to invite users to spreadsheets is a nice touch for group collaborations, in some cases, especially the edit option. I've never been a fan of netmeeting.
Web Based Office Functionality: It's nice for those that don't want to have to shell some cash for an office suite, and for those that want an alternative to Open Office.
Weaknesses:
I really haven't seen any (or specifically looked for them) -- if I find something I'll modify my post.
Strengths:
UI: I like the fact they use tabs versus buttons to access formulas,
formatting, and sorting. Even though it's more basic, it seems cleaner.
Formatting: The choose format button makes changing the format of the cell, column, or row easier to select. (I like anything that saves me from mouse clicks)
Sorting: This seems to do what excel doesn't. From a standard installation of Excel, if you want to sort a column of data, the safest way to sort is to highlight the whole sheet -- If you don't, excel will only sort column that you selected, and will screw up any other corresponding data, if it exists. If I choose a column to sort in google spreadsheets, it will sort all of the corresponding data on the sheet, not just the column (quite a nice fix -- post seems to relate to the below, so I included it).
2PM Back from Site Visit
Sales guy: How'd the trip go?
IT guy: Went pretty well. Almost had to send your branch manager home though.
Sales guy: Ha, why?
IT guy: After we loaded up all the inventory in an Excel spreadsheet, he kept sorting it wrong. He'd sort just one column. It would scramble the whole thing up and we'd have to delete it and start all over. He did that three times before I banned him from Excel.
Sales guy: You banned him?
IT guy: I banned him.
8220 England Street
Charlotte, North Carolina
Exporting: You can export to both excel, and .csv, from the basic sheet I created, it did it's job, no formatting issues, and the formulas remained intact.
Collaboration: Being able to invite users to spreadsheets is a nice touch for group collaborations, in some cases, especially the edit option. I've never been a fan of netmeeting.
Web Based Office Functionality: It's nice for those that don't want to have to shell some cash for an office suite, and for those that want an alternative to Open Office.
Weaknesses:
I really haven't seen any (or specifically looked for them) -- if I find something I'll modify my post.