https://bugs.documentfoundation.org/show_bug.cgi?id=92370
Bug ID: 92370
Summary: Copy-paste of formula that results in #DIV/0! bug
causes wrong result
Product: LibreOffice
Version: 4.4.3.2 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Entering a cell function that results in a #DIV/0! and then copying that cell
many times causes resulting formulas to show up correctly but not result in
#DIV/0! even if that is the correct value if the calculation source cell is
empty.
Note: Copying it only few times causes correct result.
Steps to reproduce:
-Take a empty spreadsheet.
-Enter a cell resulting in #DIV/0! in a cell.
Example: type =10/b1 into cell c1
-See that the formula and result are as expected.
Example: The formula in c1 is 10/b1 and that the cell value shows #DIV/0!
-Copy the cell with the formula
Example copy c1
-Select the cell below.
Example c2
-Go down many times with page down while holding shift to select many cells.
Note: If I go down only 2-3 times this does not happen, need to go more. In
my tries I went down all the way to cells 110 or 122 or similar to get this bug
to happen.
-Paste
-Note that the pasted cells contain the correct formula but wrong result.
Example all the cells c2-c122 contain formulas like =10/b2 to =10/b122 but
the values are 10, not #DIV/0! as expected.
-Enter different values in the referenced cells and see that the calculation
changes to be correct for any number not if the cell is empty.
Example: enter 2 in b2 and see c2 change to 5, enter 10 and see c2 change to
1, enter 0 and get #DIV/0!. But press del to delete the cell contents in b2 and
see the value change back to 10 not #DIV/0!.
-Check same in the original formula and see that it gives #DIV/0! as expected.
Example enter the same values in b1 and see same results, except that after
the deletion the result in c1 is #DIV/0!, not 10.
As noted above if I only copy the cell to smaller number of cells it works as
original. Say from c1 to c2-c87 the effect is as in c1, that is as example an
empty b2 results in #DIV/0! in c1.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
