[Libreoffice-bugs] [Bug 143816] New: Dragging formulae across columns result in persistent wrong data

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 143816
           Summary: Dragging formulae across columns result in persistent
                    wrong data
           Product: LibreOffice
           Version: 7.1.5.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: robert at prino.org

Description:
When dragging a cell to other cells (empty or not makes no difference) to copy
a formula, it seems that not just the formula is dragged, but also the value of
the cell that is dragged, and no amount of recalculating will change this
value. Only overtyping the actual formula, or one character of it will correct
this situation!

NOT THAT THIS IS A VERY SEVERE BUG!

Steps to Reproduce:
1. Open the attached spreadsheet, and select the Naco-CoTy-Naty sheet

2. Note the values in these cells and their formulae:

- G2: 48 / =MAX(G2:G301)
- H2: 19 / =MAX(H2:H301)
- I2: 24 / =MAX(I2:I301)
- J2: 93 / =MAX(J2:J301)

2. Select cell cell G2, and drag it across to cells H2, I2, and J2

3. Note the new values / formulae in these four cells:

- G2: 48 / =MAX(G2:G301)
- H2: 48 / =MAX(H2:H301)
- I2: 48 / =MAX(I2:I301)
- J2: 93 / =MAX(J2:J301)

4: Press F9 until you're blue in the face, and nothing will change the values
of cells H2 & I2

5: Edit cells H2 & I2, by just deleting the closing parentheses of the
formulae, and hey, now the values are recalculated correctly!

Similar thin happens fro draggingR2 across S2/T2/U2, here only S2 is screwed
up!

Actual Results:
See above

Expected Results:
Se above


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.5.2 (x64) / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: threaded

Note: I have not tried to reduce the sheet to something minimal, it happens in
this one!

-- 
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/20210810/0c47d0cf/attachment.htm>