Issue 105800 - wrong SUM range calulated if merged cells in SUM lines breaks across page
Summary: wrong SUM range calulated if merged cells in SUM lines breaks across page
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOO310m19
Hardware: PC Windows, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-10-11 04:59 UTC by polym
Modified: 2017-05-20 11:15 UTC (History)
2 users (show)

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


Attachments
sample of the issue. (10.22 KB, text/plain)
2009-10-11 05:00 UTC, polym
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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".