Issue 105800

Summary: wrong SUM range calulated if merged cells in SUM lines breaks across page
Product: Writer Reporter: polym <amen76>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, rainerbielefeld_ooo_qa
Version: OOO310m19Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Windows, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
sample of the issue. none

Description polym 2009-10-11 04:59:49 UTC
if a table is very large that it extend to the next page, and two( or more)
cells in the two pages of the first column are merged, the function sum in the
first row (or including the first row) will get wrong result.

for example:
table:
A    1    2    3    4
B    4    4    4    12(=sum<B2:D2>)

but if cell A and B is merged into one, and a page break between the two rows,

table:
A    1    2    3    4
(next page)
B    4    4    4    18(=sum<B1:D2>, but the function is sum<B2:D2>!)

the attatchment is a sample of the issue.
Comment 1 polym 2009-10-11 05:00:39 UTC
Created attachment 65292 [details]
sample of the issue.
Comment 2 Rainer Bielefeld 2009-10-11 12:37:43 UTC
Reproducible with "Ooo 3.1.1 WIN XP DE-multilingual version German UI activated
[OOO310m19 (Build 9420)]"!
Same with "Ooo Dev 3.2.0 multilingual version German UI WIN XP: [DEV300m60
(Build 9425)]" and "2.4.1  Multilingual version English UI WIN XP:
[680m17(Build9310)]"

In Sample file "error calculation.odt" in table under "heading" Cell A and Cell
B are merged:" You see result "18" in bottom right cell, what is wrong.
If you nsert some lindfeeds (<Enter>) above heading, so that complete table will
be on second page, result in bottom right cell will change to correct result
"12" if you click into any cell in table.
Comment 3 michael.ruess 2009-10-19 11:16:42 UTC
MRU->OS: see attached document, the table in the middle. When you move the table
to next page, calculation is correct, but when you have it braking from one page
to another, the calculation will be wrong.
Comment 4 Marcus 2017-05-20 11:15:38 UTC
Reset assigne to the default "issues@openoffice.apache.org".