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.