https://issues.apache.org/ooo/show_bug.cgi?id=122886

            Bug ID: 122886
        Issue Type: DEFECT
           Summary: Named range: sheet ok in earlier versions shows #NAME
                    on loading in AOO 4
           Product: Calc
           Version: AOO 4.0.0
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: code
          Assignee: [email protected]
          Reporter: [email protected]
                CC: [email protected]

Created attachment 81195
  --> https://issues.apache.org/ooo/attachment.cgi?id=81195&action=edit
sample document showing problem

I have a sheet using named ranges or expressions that worked properly in AOO
3.4.1 and earlier, but produces a #NAME error when loaded in AOO 4.

Steps to reproduce:

1) Open the attached Calc document

   O2 should show 1.0, instead shows #NAME

2) Insert > Names > Define

3) Select CMAX

4) Click "Modify" (no actual change); click OK

   O2 now shows correct value

5) File > Save

6) File > Reload

   O2 again shows #NAME

This seems to have something to do with the saved file, as I can manually
reproduce the same inputs and formulas in a new sheet and everything works
correctly.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

Reply via email to