Issue 116740 - Automatic column label may change to row label if data layout changes.
Summary: Automatic column label may change to row label if data layout changes.
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-02-01 03:24 UTC by tab
Modified: 2013-01-29 21:44 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

file with bad (?) formula (8.07 KB, text/plain)
2011-02-01 03:25 UTC, tab
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description tab 2011-02-01 03:24:16 UTC
In BadValu.ods, the formula in cell B3 gives a VALUE error. Why?
Now, do this:
0: put anything, eg, 'h' in cell A2;
1: select cell B3, hit f2 to edit it;
2: delete and reinsert any character, such as 'r' or '3';
3: hit Enter: no more error!

But, if you omit either step 0 or 2, the error remains.
Comment 1 tab 2011-02-01 03:25:54 UTC
Created attachment 75736 [details]
file with bad (?) formula
Comment 2 ooo 2011-02-10 19:14:47 UTC
The document uses the automatic column and row labels feature. Initially the
'Rr' is evaluated as a column label in A1, where the position dependent
intersection of the formula in B3 with column A results in A3 as referenced
value for the calculation, and numerical operation with the text value "a" leads
to an error. With a textual value in A2 the 'Rr' is evaluated as a row label and
with a change of the formula in B3 the intersection is with Row 1 and uses B1 as
referenced value, the operation is with the numeric value 18 and no error.

This would need to add yet more obscure heuristics, the automatic labels can be
a source of nuisance in such non-deterministic situations. Automatic labels are
a deprecated feature.

Use defined labels instead, Insert->Names->Labels.