[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