https://bugs.freedesktop.org/show_bug.cgi?id=48312
Eike Rathke <er...@redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |er...@redhat.com
--- Comment #13 from Eike Rathke <er...@redhat.com> ---
Problem is due to the massive amount of OFFSET() functions used that need to be
recalculated on every change. It looks as if at least in the range Splits.AD:BQ
the calls like
OFFSET($G745,0,MATCH(AD$1,$G745:$AB745,0))
could be replaced by HLOOKUP if the result rows were not organized the way they
are. Currently they are paired keys/values in one row for keys of 5:00, 10:00,
... 60:00; splitting keys and values into two rows each instead would allow to
use, for example HLOOKUP($G745,$G745:$AB746,2,0)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
