[Libreoffice-bugs] [Bug 133168] New: LibreOffice Calc cannot process big data (~300k lines) pivot table

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133168

            Bug ID: 133168
           Summary: LibreOffice Calc cannot process big data (~300k lines)
                    pivot table
           Product: LibreOffice
           Version: 7.0.0.0.alpha1+ Master
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: gisseh at gmail.com

Description:
I have a database of about 300 thousand rows with sales information (date,
product, price, invoices etc.) in which I use excel Pivot Tables to search and
use in daily basis. When trying to creat it in Calc draging the Date to column,
it gives the error "Error creating Pivot Table" and that's it. 
The date column is formated as date.

Besides that I'd like to give some feedback on pivot tables looking forward to
some improvements on the tool, where is the correct place to write it?

Steps to Reproduce:
1. Try to insert a pivot table with multiple dates (e.g. more then 1000
different dates)
2. Insert Pivot Table trying to drag date to columns
3.

Actual Results:
"Error creating Pivot Table"

Expected Results:
I expected Calc to segment the dates into Years/Quarters/Month, and not to try
to show all single dates as columns.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.0.0.alpha1
Build ID: 6a03b2a54143a9bc0c6d4c7f1...
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Calc: threaded

This happens on 6.x versions as well

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200519/5e607fbb/attachment.htm>