[Libreoffice-bugs] [Bug 143809] Err:502 in cells referencing named expressions after save-and-reload

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
It looks related to INF. Replacing its reference in LAST_ROW by its expression,
like this:

> LAST_ROW:  MATCH((2^53-1)*2^(1024-53);$Tickets.$A:$A)

fixes the problem. It turned out that I made a mistake while preparing the
example, moving IFERROR's last argument out of the argument list - that's
unrelated; the correct formula in Billing.A1 / Tickets.D1 is

> =SUMPRODUCT(IFERROR(CEILING.MATH(DURATIONS;300);0))

and in Billing.A2 / Tickets.D2 is

> =SUMPRODUCT(IFERROR(CEILING(SUMIFS(DURATIONS;IDS;IDS);300)/COUNTIFS(IDS;IDS);0))

Why could INF cause this? There's no built-in function named so.

-- 
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/20210810/0ce94628/attachment.htm>