[Libreoffice-bugs] [Bug 130531] When opening the Amazon KDP print royalty calculator the desktop becomes unresponsive

[bugzilla-daemon at bugs.documentfoundation.org]

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

raal <raal at post.cz> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |filter:xlsx

--- Comment #4 from raal <raal at post.cz> ---
(In reply to izoprene from comment #2)
> I uninstalled the default Libreoffice 6.0.7.3 and installed version 6.4.0.3
> via a snap package.
> 
> The file opens and is usable, but when I enter values into fields 1, 2, 3 &
> 4, upon entering a value in field 4 my CPU usage goes very high, Libreoffice
> almost hangs (OS asks to quit process), but eventually the four lower fields
> are populated with the calculated values. From that point on, the
> spreadsheet is reasonably responsive.
> 
> Strange how it's taking so long?
> 
> System monitor screenshot: https://imgur.com/traRrPg

I can confirm this behaviour, high CPU usage for few seconds, but formulas are
complicated. It contains two hidden sheets. 
Printing cost:
=iferror(ROUNDUP(IF($E$11="";0;sumifs($'Lookup Tables'.$G$1:$G$1048576;$'Lookup
Tables'.$C$1:$C$1048576;$E$8;$'Lookup Tables'.$D$1:$D$1048576;$C$3;$'Lookup
Tables'.$E$1:$E$1048576;"<="&$E$9;$'Lookup
Tables'.$F$1:$F$1048576;">="&$E$9)+(sumifs($'Lookup
Tables'.$H$1:$H$1048576;$'Lookup Tables'.$C$1:$C$1048576;$E$8;$'Lookup
Tables'.$D$1:$D$1048576;$C$3;$'Lookup
Tables'.$E$1:$E$1048576;"<="&$E$9;$'Lookup
Tables'.$F$1:$F$1048576;">="&$E$9)*$E$9));2);0)

It would be interesting compare with excel

-- 
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/20200209/aafd0d68/attachment.htm>