https://bugs.documentfoundation.org/show_bug.cgi?id=159027
Bug ID: 159027
Summary: Writer table formulas calculated incorrectly in merged
cells when table splits over pages
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Description:
If a Writer table splits over multiple pages, and a cell is merged that crosses
the page boundary, a formula in the merged cell that involves cells not on the
current page only calculates using the cells on the same page as the merged
cell.
Steps to Reproduce:
1. Insert a new line. (Not part of the bug, just helps demonstrate it later
on.)
2. Create a table with 2 columns and 100 rows.
3. Insert the number 1 into every cell of the first column.
4. Merge all of the cells in the second column into a single cell (e.g., select
the entire column and hit F4 or right-click | Merge cells).
5. In the merged cell, insert the formula =SUM(<A1:A100>).
6. Notice that 50 is displayed.
7. Above the table, insert another new line (i.e., force another row to the
following page).
8. Recalculate the table. Notice that 49 is displayed.
Actual Results:
Only the cells on the current page are included in the calculation.
Expected Results:
All cells in the specified range should be included in the calculation.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
