To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=102874
User es changed the following:
What |Old value |New value
================================================================================
CC|'' |'mba'
--------------------------------------------------------------------------------
Assigned to|writerneedsconfirm |requirements
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Target milestone|--- |OOo Later
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Wed Jun 17 15:37:22 +0000
2009 -------
- Provided table:
A1 5
A2 10
A3 SUM(A1:A2)=15
- Set Edit - Changes - Record
- Make sure Edit - Changes - View is ON
- Replace "5" in A1 by "12"
-> A1 now looks like this: 512 (where "5" is marked as deleted and "12" as
inserted) ->OK
- Now press F9 to update the table
-> A3 switches is to 522 as sum of 512+10
Which looks like a bug is a general redlining concept problematic: mixing up
"View information" (a content which used to be there) and text content.
The SUM() function is blind to such "fine" distinctions "Text is visible but
shouldn't be considered, actually it's bot there" and sees the whole written
text.
The same can be achieved when a text modified while change tracking is ON, is
the source of a reference:
<ref_source>This is a text<ref_source>
<ref>This is a text</ref>
Will appear as:
This is a
This is a
When change tracking View is OFF
and as:
This is a _text_ ("_" stands for "deletion")
This is a text
When change tracking View is OFF.
So re-qualifying as ENHANCEMENT because changing this behavior supposes to
remake completely the concept of change tracking.
@anieden: to avoid such confusions in table, you'd better work with Change
tracking - View OFF.
@MBA: What do you think?
---------------------------------------------------------------------
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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]