[Libreoffice-bugs] [Bug 119343] New: EDITING: copied and pasted cells containing formulas are not recalcuated (2)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119343

            Bug ID: 119343
           Summary: EDITING: copied and pasted cells containing formulas
                    are not recalcuated (2)
           Product: LibreOffice
           Version: 6.1.0.3 release
          Hardware: All
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: tagishsimon at gmail.com

Created attachment 144263
  --> https://bugs.documentfoundation.org/attachment.cgi?id=144263&action=edit
Calc spreadsheet showing formula calculation error in columns M and N

Note 1: First, I note https://bugs.documentfoundation.org/show_bug.cgi?id=67489
- an old fixed problem similar to this one, at least to the extent they share a
title.

Note 2: I'm getting an error trying to upload my attachment; 

I attach a spreadsheet in which the calculations of formulii on columns M and N
are manifestly wrong.

In both columns, the formulas are just trying to fetch a single value from a
cell on the same row - e.g. =+J2

The method to create the issue was
1. In cell M2, enter a formula +J2
2. CMD-C to copy the formula 
3. Select many cells in the M column
4. CMD-V to paste the formula

Expected result:
- The formula copies and calculates values

Actual results
- The formula copies, but the values displayed for all cells in a column is
that which would be correct for the final row of the column - in the attached
example, M295 is correct and gives its values to M2-M294. N108 is correct and
gives its value to N2-N107, which are incorrect.

You can try this at home:
- If you open the file
- CMD-C the formula at the bottom of the list (e.g. M295)
- CMD-V the formula to the next cell down (e.g. into M296)
then the values for the entire column change to those for M295.

-- 
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/20180818/2d2c19b9/attachment-0001.html>