4 ms·
Good news, Pivot tables were added in v6.2. And there's an extension that provides similar support for PowerQuery. Tables do exist in LO calc.
by greazy 4y ago
Good news, Pivot tables were added in v6.2. And there's an extension that provides similar support for PowerQuery. Tables do exist in LO calc.
- vetinari 4y agoI was talking PowerPivot, not pivot tables. LO Calc pivot tables are at Excel 2003 level. Well, there's a reason why it was redone in 2007. If by extension that provides similar support for PowerQuery you mean QueryConnector, then no. QueryConnector is similar to the MS Query, not to the PowerQuery. And MS Query was Excel built-in, not extension... Tables do not exist in LO calc. Dataranges do (and imported excel files with tables are converted to dataranges). Dataranges do not have functionality like Tables do. You cannot even create above mentioned pivot table from a datarange, only from named range or selection. I even had to google how to create them (the build-in help didn't... help), after I've seen that the import did create something, and not just convert to named ranges as it used to. So much for discoverability. --- This is not to put down LibreOffice Calc or anything. It is about being honest where the weaknesses are, and how to address them. Sweeping problems under the carpet won't address them, and Calc won't become better. Also, Excel is the crown jewel of MS Office. Not Word, not Powerpoint, but Excel. Of course it is best of the best that money can buy and competing with it is not easy. But 15 years? Come on.
- greazy 4y agoYes I see now what you mean. The Power* family of tools is quiet powerful. I'm now reconsidering if I'm a power user of spreadsheets! For these extra features I'll use R as it's more powerful and reproducible.