Issue 72530 - adapting sum formula in TextTable when inserting/deleting rows
Summary: adapting sum formula in TextTable when inserting/deleting rows
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability
: 109510 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-12-13 11:49 UTC by eberlein
Modified: 2017-05-20 11:22 UTC (History)
1 user (show)

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

Attachments
showing inconsistency (6.79 KB, application/vnd.oasis.opendocument.text)
2006-12-13 13:03 UTC, michael.ruess 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description eberlein 2006-12-13 11:49:40 UTC 
See thread
http://sw.openoffice.org/servlets/BrowseList?list=dev&by=thread&from=1606451

If in a TextTable the cell formula in b4 is sum<b1:b3>, adding a row after b2
will expand the formula to sum<b1:b4>.
Adding a row after b3 will not expand the formula.
Deleting the row (b3 belongs to) will cause an error in the formula.

This behavior should be changed like MS Word does in the sum(above) field.
Comment 1 michael.ruess 2006-12-13 13:03:19 UTC 
Created attachment 41397 [details]
showing inconsistency
Comment 2 michael.ruess 2006-12-13 13:24:36 UTC 
This is similar to issue 58307, but this also refers to adding rows in a table.
The sum formula should be adapted, at least this would cover the expectations of
the user.
Comment 3 joesch 2006-12-14 12:15:43 UTC 
I think sum(above) has not the right funktion. When the values are:

A1: 3
A2: 1
A3: 
A4: 2

then sum(above) (in A5) has the result 2 (and not 6!).

The right formula in this situation is sum(A1:A4) (in MS Word).

I think sum<b1:b4> (in OOo-Writer) works in main correctly. 
When the formula is sum(A1:A4) and i adding a row after A4, there a two(!) 
capabilities:

1. before ein insert the new row i mark the cell A4 (or the row 4), then i can 
insert a new row and the formula is change correctly

2. before ein insert the new row i mark the cell A5 (or the row 5), then the 
formula is not change when i isert a new row, but this *is* correct, because 
the range in the original-formula is *from* A1 *to* A4, and not from A1 to 'a 
little bit after the cell-border of A4' (in other words: the (virtuell) cell-
boder between A4 and A5 is not a component of the range A1:A4)

From this point of view, I think this issue is a issue for a new Feature and 
not a description of a bug.
Please dont *change* this Funktion to the behavior sum(above), only you can add 
a *new* feature in the sense of sum(above).


Not correct is only the described behavior when i delete the row 4.
Comment 4 michael.ruess 2010-02-22 15:16:16 UTC 
*** Issue 109510 has been marked as a duplicate of this issue. ***
Comment 5 Marcus 2017-05-20 11:22:07 UTC 
Reset assigne to the default "issues@openoffice.apache.org".