[Libreoffice-bugs] [Bug 129358] New: CALC: Inserting or deleting cells above a referenced range results incorrect adjustments to the range witin functions.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129358
           Summary: CALC: Inserting or deleting cells above a referenced
                    range results incorrect adjustments to the range witin
                    functions.
           Product: LibreOffice
           Version: 6.2.8.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: nslehcim at gmail.com

Description:
Error Type One:  inserting one row above referenced range results in one bad
function range.

Error Type Two:  inserting multiple rows  above referenced range results in all
bad function ranges.

The following functions will result in these two errors:
'insert entire rows above' 
'insert entire rows below'
'shift cells down' above referenced range
'shift cells up' above referenced range

The following functions will not result in these errors:
'shift cells down' above cells containing function
'shift cells up' above cells containing function
'delete entire rows'
'shift cells right'
'insert or delete column'  


Steps to Reproduce:
Error Type One: inserting one row above referenced range
1. Copy formula =sum(A1:A4) to first ten cells in column B.
2. Highlight entire row 1 by right click on 1 label then 'insert rows above'.

Error Type Two:  inserting multiple rows above referenced range
Copy formula =sum(A1:A4) to first ten cells in column B.
Highlight cel1s A1:B2 then right click then 'insert' 'shift cells down' ok.


Actual Results:
Error Type One Result: function in B2 is wrong =sum(A1:A5) 
Note: function in B3 is correct =sum(A3:A6) with the rest cells correct.

Error Type Two Result: function in B2 is wrong =sum(A1:A6) 
Note: function in B3 is wrong =sum(A1:A7) with the rest cells wrong


Expected Results:
Type One: function in B2 correct =sum(A2:A5)

Type Two: function in B2 correct =sum(A3:A6) 
function in B3 correct=(A4:A7) ect.



Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Libre office is an amazing open source accomplishment and I commend everyone
who has worked on this collabertive effort. This problem did not exist in older
versions of calc. I did not catch this error in my calculations for more than
six months and it has cost me financially. I always used the older tested
business version. Moving referenced ranges a is such a basic, core feature,
central to any spreadsheet program, it seems crazy that I might be the first
person to discover an error this serious. I can no longer trust the code and
will return to commercial software.  Maybe try again in the future with better
bug testing.

-- 
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/20191213/191d88b6/attachment.htm>