https://bugs.documentfoundation.org/show_bug.cgi?id=170527
Bug ID: 170527
Summary: Calc Pivot Tables isn't as good as MS Excel's
PowerPivot; and it should
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Calc Pivot Tables isn't as good as MS Excel's PowerPivot, and it could be and
should be. Or even better.
- The main feature that makes Excel's PowerPivot so good is the option to make
very quick analyses on related data; eg. 2 separate tables in teh same
worksheet that have a 1-many relation. In excel one can make a pivot table on
those 2 tables in 5 minutes. Calc doesn't have a PowerPivot-comparison, so I
have to use a Python Jupiter-notebook with Pandas to do the same analysis and
it takes me about an hour.
Steps to Reproduce:
I don't know. I'm a user, not a programmer.
Actual Results:
I use PowerPivot on an almost daily basis, so I can't get rid of Microsoft. And
I want to...
Expected Results:
A feature in LibreOffice that equals or just plainly beats the usability and
range of PowerPivot. (NB. I am impression that MS plugged the feature to work
with related datasources is integrated into most or all of the Office-apps.)
Reproducible: Always
User Profile Reset: No
Additional Info:
none
--
You are receiving this mail because:
You are the assignee for the bug.