Apache OpenOffice (AOO) Bugzilla – Issue 105800
wrong SUM range calulated if merged cells in SUM lines breaks across page
Last modified: 2017-05-20 11:15:38 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.
Created attachment 65292 [details] sample of the issue.
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.
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.
Reset assigne to the default "issues@openoffice.apache.org".