https://bugs.freedesktop.org/show_bug.cgi?id=84652
m.a.riosv <mari...@miguelangel.mobi> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |NEW
Version|4.3.2.2 release |Inherited From OOo
--- Comment #3 from m.a.riosv <mari...@miguelangel.mobi> ---
First thanks for your persistence, I think indeed there is a bug.
(In reply to suradetj from comment #2)
.....
> I believe this is a bug. Since in previous versions, the cut and paste
> should also adapt to relative address parts of the formula.
Cut&Paste doesn't use relative/absolute address, it's must adapt addresses in
cells with references to the moved range.
......
> 1. Put 1 to 5 on Cell C2:G2
......
> 6. The name AnotherTotal is now B10 and the formula is now sum(C10:G10) the
> value is 15 (The cut and paste on the same sheet now adapt to the relative
> address parts of the formula.
This case works because the whole referenced cells are moved, C2:G2 is in
B2:G2.
What's the bug?:
C5: =SUM(D5:ZV5) (value 100)
1. Select cells C5:S5
2. Cut and paste the cells to C10
C10: =SUM(D5:ZV5) (value 0) NOT Ok
It must be: =SUM(D10:ZV5)
The beginning of the SUM() address "D5" is inside the moved range, so it should
be adapted as D10.
The end of the SUM() address "ZV5" is outside the moved range, so it must not
change as it's happen.
The bug is inherited from OpenOffice, the same happens with AOO 4.1.1
Works fine with Lotus 123.
"References to a range are not properly updated if it's not moved the whole
referenced range."
To reproduce in a new spredsheet:
A1: =SUM(B1:D1) Cut&Paste B1 to B2
A1: =SUM(B1:D1) not Ok it must be =SUM(B2:D1)
A1: =SUM(B1:D1) Cut&Paste D1 to D2
A1: =SUM(B1:D1) not Ok it must be =SUM(B1:D2)
A1: =SUM(B1:D1) Cut&Paste B1:D1 to B2
A1: =SUM(B2:D2) Ok
Please @suradetj change the title for one relative to the real bug, the cell
names have nothing to do.
--
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
