[Libreoffice-bugs] [Bug 118843] New: calc incorrectly handles cells with a REF error

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118843
           Summary: calc incorrectly handles cells with a REF error
           Product: LibreOffice
           Version: 6.0.5.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mike.giftrise at btinternet.com

Created attachment 143645
  --> https://bugs.documentfoundation.org/attachment.cgi?id=143645&action=edit
Simple sheet with start conditions for producing error

I created the following simple sheet sheet
In 2 columns, A and D, enter the numbers 1 to 20 
In cell B 20 enter =SUM(A10:A19)
In cell C20 enter =SUM(D10:D19)
See attached sheet.

Save the sheet, Close Calc and then reopen the sheet.

Select cells B20:C20 
Copy and select range b1:c20 and paste. ie copy the formulas of the 2 selected
cells upwards to the top of the sheet.

As you would expect some cells show a REF error due to formulas referencing
cells before row 1.

Now insert a column between columns A and B.
Select column B, right click in column header and insert col left.  
(I also tried shift cells right)

All of the cells in columns B and C now have a REF error. 
In column C the value displayed is #REF!.
In Col B #REF! is displayed in the formula but cells still show a numeric value

-- 
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/20180719/44d74464/attachment.html>