[Libreoffice-bugs] [Bug 143809] New: 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

            Bug ID: 143809
           Summary: Err:502 in cells referencing named expressions after
                    save-and-reload
           Product: LibreOffice
           Version: 7.2.0.2 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com
                CC: erack at redhat.com

Created attachment 174182
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174182&action=edit
Sample spreadsheet with named expressions

The attached document contains some named expressions. The cells that refer to
those expressions (Billing.A1:A2, Tickets.D1:D2) show Err:502 now; but when the
named expressions were entered initially, the formulas worked.

The document-scope named expressions are:

> INF:       (2^53-1)*2^(1024-53)
> LAST_ROW:  MATCH(INF;$Tickets.$A:$A)
> DURATIONS: $Tickets.$A$2:INDEX($Tickets.$A:$A;LAST_ROW)
> IDS:       $Tickets.$B$2:INDEX($Tickets.$B:$B;LAST_ROW)

Even as simple formula as =SUM(DURATIONS) produces an error.

-- 
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/998309ad/attachment.htm>