https://bugs.documentfoundation.org/show_bug.cgi?id=128110
Bug ID: 128110
Summary: #REF! error in running total formula after delete of
row
Product: LibreOffice
Version: 6.1.2.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ajbarth...@gmail.com
Description:
A simple spreadsheet with running total formula in col B. Beginning on row 2,
col A contains numbers and col B has formula to take previous row total (B) and
add current number in cell (A). Deleting a row results in #REF! error in col B
cell of said row and below.
Steps to Reproduce:
1. Place formula =B1+A2 into cell B2.
2. Copy formula from B2 down for several rows such that cell B3 contains
formula =B2+A3, etc.
3. Place values into cells in col A.
4. Col B cells have running total.
5. Now delete row 3 for example.
6. Afterward cell B3 shows #REF!
7. Select cell B3 and formula bar correctly showns as =B2+A3 and correctly
color highlights reference cells of formula
Actual Results:
10 10
38 #REF!
90 #REF!
Expected Results:
Expect cells with #REF! to correctly recalculate as formula cell references are
dynamic (relative) and thus still valid.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 6.3.2.2 (x64)
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU threads: 2; OS: Windows 10.0; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
--
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
