[Libreoffice-bugs] [Bug 128661] New: By reopening a Calc file, the formulas referring to external named areas end up with #NAME

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 128661
           Summary: By reopening a Calc file, the formulas referring to
                    external named areas end up with #NAME
           Product: LibreOffice
           Version: 6.2.8.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: hardt68-register at yahoo.fr

Description:
A spreadsheet with reference to external areas, ONLY NAMED areas, will not
display the result of the formulas once the file is reopened. Even if it did
display propery by the previous closing. All cells containing a reference to
the external names areas will display "#NAME ?" as the figures are recalculated
at the file opening.

F9 and Ctrl-Shift-F9 have no effect.

To have a cell recalculated properly it needs to be modified (Replace all "="
with "=" will do the job).

WORKAROUND !
In a sheet with thousands of references to an external named area, it's just
enough to have one reference to the same area HARD CODED (not NAMED) to recover
all the references, including the names one (any reference to the external
spreadsheet may be sufficient).

Steps to Reproduce:
See description

Actual Results:
#NAME ?

Expected Results:
a calculated value


Reproducible: Always


User Profile Reset: No



Additional Info:
See description

-- 
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/20191108/c5e02f54/attachment.html>