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

--- Comment #9 from Eike Rathke <er...@redhat.com> ---
I tried in 5.1.1 and loading the document consumes about additional ~800MB
memory. Loading in master dbgutil build indeed consumes 5-6GB

Apart from that, was the document designed to make things specifically slow?
Almost every cell with content has a formula of a value and a STYLE() function.
Why not apply a cell style instead and use a value instead of a formula?

Also, the document contains more than 4500 conditional styles of which most are
identical. For example there's a whole list of conditional styles applied to
single cells on sheet 'RI - Juin 2014', which likely could be combined to a
cell range instead.

If done for all sheets, combining conditional formats to ranges and replacing
formulas of value+STYLE() with value cells and assign the style, that would
probably significantly reduce memory footprint.

The Windows 32-bit version likely wasn't able to allocate the required memory
hence gave up.

I'm inclined to close this as worksforme. Future versions maybe could detect
the conditional style repeats and combine them into ranges.

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

Reply via email to