[Libreoffice-bugs] [Bug 136537] New: excel formulas get corrupted with Drag & Drop

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 136537
           Summary: excel formulas get corrupted with Drag & Drop
           Product: LibreOffice
           Version: 6.4.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: vicentesolerfraile at hotmail.com

Description:
When a number of cells and moved, their formulas get corrupted.

please follow this simple example:

A1: one
A2: two
A3: total:
B1: 1
B2: 2
B3: SUM(B1:B2)

cell B3 contains 3, which is the sum of 1+2.

Now, select cells A2 to B3, and drag them down by 1 row -> the selection is now
A3 to B4

However, the total, which should be 3, has becomed 1 (wrong!) because the
formula still is SUM(B1:B2) whereas it should be SUM(B1:B3)

I consider this to be a significant error. Could you please check it and amend
it?

Thank you very much for your cooperation

Actual Results:
1

Expected Results:
3


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: es
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Version 6.4.4.2

-- 
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/20200907/e80c4d85/attachment-0001.htm>