Last year I've used Google Apps Script to automate a spreadsheet, it worked very well and that spreadsheet is still used inside my company. It's not very complex, all together maybe 200 lines of code, with tests. But, I'm not sure if I would do it again. Development style is not enjoyable, coding inside textarea with syntax highlighting is simply not good enough. I would prefer to use my text editor and some way to d…
NOTE: this is NOT a troll. I know a great tool for the job. It works fine with source control and allows documents to be diffed and merged. The editor is 100% offline as is the product or it can be 100% online at will. No need to push changes to server - just replicate/copy. If you fancy collaboration tools you can use use extensive ones on a subscription basis. It's got a well documented SDK and an interface that yo…
But for two things:
Excel for Mac - $129 (http://www.amazon.com/dp/B003YCOJBC)
Excel for Win - $121 (http://www.amazon.com/dp/B0039L2XG6)
And you need a Windows box or Mac with Excel installed. I personally have access to dozens of machines, literally none of which have Excel. All of them have a web browser, and thus access to Google Spreadsheets and Google Apps Script for free. To me, and many others, that makes all the difference in the world.