Apache OpenOffice (AOO) Bugzilla – Issue 98174
range names display "#NAME?" in formula bar
Last modified: 2013-08-07 15:14:39 UTC
Found in DEV300_m39: File > Open (any .ods with named ranges) Select a cell with a formula that uses a named range Press F2 to edit The formula is displayed in the formula bar and on the canvas with all range names shown as "#NAME?". The names are defined correctly (the Name Bar works), and the formula works correctly, and name completion on typing works, it's just the formula display that's wrong. Running m39 under Fedora Linux 9; en_US.
The error is also with a new document. If you enter the formula newly, you can use the named range and get the correct result. If you leave the cell and then click on the cell again, the input line shows #NAME? If you save and reload the document the cells, now containing #NAME?, will result in Err:520. It has been OK in m37.
can confirm - imho this is a P1 issue, cause calc is not usable ... i also noticed if one loads an oo calc doc (for example created with oo 3.0.1 rc2) oo3.1m39 will display formulas in english, like =ROUND(100*#NAME?;2) instead of =RUNDEN(100*XXX;2) #NAME? was a named range ...
Also confirm in DEV300m39 but FWIW it is not happening in OOO300m15.
I can confirm this. Every range name displays as #NAME? if used within a cell. This is at least a P2 ja->er: please take a look at it
OJ is the rep. Dev.
Fixed in cws dba31h. Merge conflict was not correctly resolved.
Fixed in cws dba31h. Please verify. Thanks.
verified in internal build cws_dba31h
OOo310m7 issue 98174 fixed ,but i am not sure if it is OK or NOT in the formula bar always show "=".
Issue 98174 not fixed.Please verify in formula bar appears "="
@oksana_hitekschool: With "formula bar", are you referring to the input line? I tried OOO310m7 Linux, there's nothing wrong, the correct formula expression is displayed.
Issue 98174 Closed.
Verified in OOo310m8 on WinXP and Fedora. E.g. Cells D5 and D6 are defined as ranges, 1 in D5 and 2 in D6, then just input =Sum(ranges) in any cell, such as c1, get the summary 3 of the range which named as ranges. Closing. Li Meiying