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@lists.freedesktop.org
Reporter: mike.giftr...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
