To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116740
User er changed the following:
What |Old value |New value
================================================================================
CC|'' |'er'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Platform|Unknown |All
--------------------------------------------------------------------------------
Summary|strange VALUE error |Automatic column label may
| | change to row label if da
| |ta layout changes.
--------------------------------------------------------------------------------
Subcomponent|code |editing
--------------------------------------------------------------------------------
------- Additional comments from e...@openoffice.org Thu Feb 10 19:14:47 +0000
2011 -------
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.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
