https://bugs.freedesktop.org/show_bug.cgi?id=78235
Priority: medium
Bug ID: 78235
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Editing: formula error when inserting new column to
left
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: kabu...@vodafone.co.nz
Hardware: All
Status: UNCONFIRMED
Version: 4.2.3.3 release
Component: Spreadsheet
Product: LibreOffice
I have a col of numbers (say in B1 to B6), which is summed at the bottom - B7
is SUM(B1:B6). Cells in formula are relative. I insert two cols to left of B. I
would expect the formula to change to SUM(D1:D6) - but it doesn't. It becomes
SUM(B1:D6)
If I make the cell refs absolute - SUM($B$1:$B$6) and insert the new cols, I
get SUM($B$1:$D$6).
This is contrary to the guidance given in the Help file (absolute addresses in
spreadsheets) - "After having inserted a new column A, the formula =SUM(A1:B2)
will be automatically updated to =SUM(B1:C2)."
This behavior occurs in both column insert and cell insert.
The key is that the column containing the data must be included in the
selection - that is, to insert two cols to left of col B, I am selecting A and
B then going Insert Left. If I just select A and insert a single col, the data
moves to col C and the formula correctly transforms to SUM(C1:C6). I've tried
this with data in col G and cols inserted left (including G), with the same
error.
I have replicated the issue on another machine running Win7 64, and with a
completely clean install of 4.2.3.3 on a system running XP that has never had
LO loaded. I also replicated the problem on a reversion to 4.2.0.4.
Similar to Bug 71014.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
