5 ms·
You're right about Excel. It is the corporate behemoth that may never be slayed. I'm thinking of getting a Mac, but can the Mac version of Excel do keyboard sh
by dereg 15y ago
You're right about Excel. It is the corporate behemoth that may never be slayed.
I'm thinking of getting a Mac, but can the Mac version of Excel do keyboard shortcuts like on Windows? (E.g. "alt, o, h, r" to rename a sheet, or "alt, i, w" to insert a sheet). From my experience, it doesn't. Losing shortcuts would put a heavy drag on my productivity.
- 2arrs2ells 15y agoExcel is 99% of the reason I run virtualized windows.
- pstephens 15y agoExcel's basic math errors are 99% of the reason I do my stats with python.
- Volpe 15y agoCare to elaborate?
- tedunangst 15y agohttp://blogs.office.com/b/microsoft-excel/archive/2007/09/25/calculation-issue-update.aspx http://blogs.office.com/b/microsoft-excel/archive/2007/09/25...
- SoftwareMaven 15y agoThat's not a math error, that's a display error. I'm no fan of Office, but that would not be a reason to fear Excel's ability to calculate correctly.
- nitrogen 15y agoDuring the whole OOXML debacle, there were many examples discovered of ambiguous or flat-out wrong behavior in various versions of Excel over the years, the kind of wrong behavior that could easily have altered the outcome of financial transactions that were managed using spreadsheets. You can probably find some if you hunt for them on Groklaw. I seem to remember one related to a date basis parameter, so that might be a good first keyword set to try.
- chokma 15y agoRob Weir has pointed out a lot of OOXML-problems over the years: http://www.robweir.com/blog/2007/07/formula-for-failure.html http://www.robweir.com/blog/2007/07/formula-for-failure.html http://www.robweir.com/blog/2008/05/fractured-yearfrac-and-discounted-disc.html http://www.robweir.com/blog/2008/05/fractured-yearfrac-and-d...
- pbhjpbhj 15y ago1 + 1 = 3 Not a maths error, only a display error.
- binarycheese 15y agoExcel only adds up to about 6 decimals. I worked on a project of an Endowment Fund (billions) and Excel was flat out wrong when computing billions over decades. The worst part is: Excel is the Dogma. If your results do not match with Excel, make it.
- tedunangst 15y agoI was guessing that's what pstephens was referring to, but he hasn't elaborated.
- SoftwareMaven 15y agoBest of both(ish) worlds: use python in LibreOffice.
- lancewiggs 15y agoNo - Mac Excel cannot do the old Windows shortcuts. It was the reason I held out for years, but once the useless ribbon turned up on Windows the shortcuts became a sloppy reverse compatibility addition. When Visual Basic arrived back on the Mac there was no reason to keep windows excel.
- 6ren 15y agoIt's interesting, because Visicalc was originally dominant. And then Lotus 1-2-3 was dominant. And now Excel is. Each could read the format of the previous one, but improved features/performance. The switchover appears to be related to platform changing, to IBM-PC, to GUIs. Which is how it usually goes. One would expect an Excel-slayer to emerge from a platform that replaces Windows - such as the web or the iPad (or some new GPU/many-core architecture that gives us speed equivalent to extrapolated clock rate increases if they hadn't stopped at 3GHz about 10 years ago), if it somehow invades the enterprise. i.e. a Windows-slayer. http://dssresources.com/history/sshistory.html http://dssresources.com/history/sshistory.html --- http://en.wikipedia.org/wiki/Spreadsheet#History http://en.wikipedia.org/wiki/Spreadsheet#History
- alastairpat 15y agoI'm not sure what you do with Excel, but another major downside for the Mac version is it doesn't have statistical analysis like its Windows counterpart does. Not a big issue unless you're doing psychological research or work in finance.