[Libreoffice-bugs] [Bug 137312] New: 7.0.1.2 Calculation error on block formulas
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Wed Oct 7 14:18:09 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=137312
Bug ID: 137312
Summary: 7.0.1.2 Calculation error on block formulas
Product: LibreOffice
Version: 7.0.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: rlammers at emailenquete.nl
Description:
A sumproduct-formula gives the correct result when adjacent cells do not
contain the same formula. If the formula is copied to a range, the result is
wrong. Copying cell by cell gives correct results. Recalculation does not have
any effect unless a cell in a range with correct results is active: then
recalculation results in the wrong results (for that range). This is not the
case when a "lonely" cell containing the formula is selected, then the result
stays correct.
When the input-range is limited to 112 rows the problem disappears.
Steps to Reproduce:
1.Open attached sheet
2.Compare formulas in cells D3, E3, I3 and K3
3.Press F9 (no Change), Press shft-ctrl-F9 (col I shows wrong results)
4.Delete rows 115 and below (All cells have correct results)
Actual Results:
1313360
Expected Results:
2191946 is the correct result for the cells in row 3
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Calculate correctly? Problem is probably some memory overflow when a formula is
in a block of the same formulas (multiple identical formulas may be in the same
memory space resulting in an overflow when the range is larger than abt 100
cells)
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201007/b4512c0c/attachment-0001.htm>
More information about the Libreoffice-bugs
mailing list