Re:LibreOffice 4.4 review – Finally, it rocks
by jayfehr on Tuesday February 17, 2015 @02:03PM
(#9064263)
I agree with those points. My comments are in regards to Macros. Why is VBA better for a sales manager? Why not use VB.Net, Python or C#? There is nothing inherently better about VBA.
My issues with Excel come from the perspective of modifying these ad-hoc apps (many business run off these for a long time as they grow). Yes, there are other great features, but for me, for growth, Calc is taking a better approach.
Re:LibreOffice 4.4 review – Finally, it rocks
by shamney on Tuesday February 17, 2015 @05:50PM
(#9065694)
what were you not able to accomplish with vba? you can use c# with excel as well. http://exceldna.codeplex.com
He wants his pivot tables, KPIs and Solver and some macros. He wants point-and-click ETL. If it's a department/cross-department model, do it in SQL Server, or whatever else you use. You can use your IT kung-fu there. This is about what libre office lacks. Excel has power and flexibility and remains easy to use for non-programmers.