Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Automatic column label may change to row label if data layout changes. | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | tab <tab> | ||||
Component: | editing | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues, ooo | ||||
Version: | OOo 3.3 | ||||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
tab
2011-02-01 03:24:16 UTC
Created attachment 75736 [details]
file with bad (?) formula
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. |