https://bugs.freedesktop.org/show_bug.cgi?id=77927
Priority: medium
Bug ID: 77927
Assignee: [email protected]
Summary: Make Pivot Table much faster: Data fields should be at
column, rather than at row
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.3.0.0.alpha0+ Master
Component: Libreoffice
Product: LibreOffice
Created attachment 97954
--> https://bugs.freedesktop.org/attachment.cgi?id=97954&action=edit
a ods file which shows how pivot should be like to make it much faster and
useful
Just see my attached 10000-row example. Try to add one more data field, you
will see that calc takes a long time to draw the data.
Currently when you insert a pivot table, data fields are placed at rows. This
makes pivot table freeze and useless in large spreadsheet files which contain a
large amount of rows.
For example, for a pivot table with 10000 rows in the row field, when you add 2
data fields you get 20000 rows, when add 3 data field you get 30000 rows....
The most importantly, "data fields at rows" is not good for data analysis. I
guess very few people like this layout. The good layout of pivot table should
be like this:
http://excelshortcuts.org/wp-content/uploads/2013/10/Pivot-tables.jpg
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
