[Libreoffice-bugs] [Bug 125254] Performance: A spreadsheet opens too slow on 64 bit OS and causes crash on 32 bit OS

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from Eike Rathke <erack at redhat.com> ---
In column G up to G5000 there are formulas like

=IF($D5000="","",SUMPRODUCT(($A$2:$A$5000)=$D5000,$B$2:$B$5000))

Starting from G5001 for the rest of the entire (!) column there are formulas
like

=IF($E5001="","",SUMPRODUCT(('file:///media/u/Seagate Expansion
Drive/files/Delivery Driving/Damgoode
Pies/Damgoode_Spreadsheet_Preliminary005.ods'#$DG_DailyLog.$A$2:$A$5000)=$E5001,'file:///media/u/Seagate
Expansion Drive/files/Delivery Driving/Damgoode
Pies/Damgoode_Spreadsheet_Preliminary005.ods'#$DG_DailyLog.$AB$2:$AB$5000))

The data is only up to row 151 anyway..

If a 32 build crashes it's probably simply because it's out of memory.

-- 
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/20190514/2f928570/attachment.html>