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

            Bug ID: 99938
           Summary: Calc uses 100% CPU and leaks memory when calculating
                    moving average of full column
           Product: LibreOffice
           Version: 5.1.3.2 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 125159
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125159&action=edit
CSV file used to reproduce the problem

When calculating a moving average for the attached CSV file, libreoffice uses
100% CPU, and uses increasing amounts of memory until I kill it.

Steps to reproduce:

1) Open the attached CSV file
2) Select both columns
3) Data -> Statistics -> Moving Average
   - Input range should be `$scores2.$A$1:$B$1048576`
   - Results To should be `$C$1`
   - Grouped by columns
   - Interval 20

Clicking OK will then cause 100% CPU usage on one core, and gradually more
memory usage. It managed to take 10 minutes on my machine and use 2GB of RAM
before I killed it.

If I select only the 142 rows of data then it calculates it almost instantly.

Expected behaviour:

The average should ignore the empty rows, and give a result as swiftly as just
selecting the top 142.

Libreoffice Version: LibreOffice 5.1.3.2 10m0(Build:2)
Operating System: Arch Linux
Kernel: Linux 4.5.4-1-ARCH x86_64

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to