[Libreoffice-bugs] [Bug 84652] Name cell with formula is not updated after cut and paste
https://bugs.freedesktop.org/show_bug.cgi?id=84652 m.a.riosv mari...@miguelangel.mobi changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED CC||mari...@miguelangel.mobi Resolution|--- |NOTABUG --- Comment #1 from m.a.riosv mari...@miguelangel.mobi --- With CutPaste the formula doesn't change what it's right, moves the range to a new place. Only Copy adapts relative address parts of the formula. Works fine for me with Win7x64 Version: 4.3.2.1 Build ID: f9b3ad49d92181b0a1fe7e76f785a2c2cd0847d3 1. Total is the name of address C5 C5: =SUM(D5:ZV5) (value 100) 2. Select cells C5:S5 3. Cut and paste the cells to C10 4. Total is now the name of address C10 (Ok) C10: =SUM(D5:ZV5) (value 0) (Ok) 5. Select cells C5:S5 6. Copy and paste the cells to C10 7. Total remains as the name of address C5 (Ok) C10: =SUM(D10:ZV10) (value 100) (Ok) Resolved as NOTABUG, please if you are not agree reopen it. -- 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
[Libreoffice-bugs] [Bug 84652] Name cell with formula is not updated after cut and paste
https://bugs.freedesktop.org/show_bug.cgi?id=84652 surad...@gmail.com changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|NOTABUG |--- Ever confirmed|0 |1 --- Comment #2 from surad...@gmail.com --- Thank you very much for quick reply. I believe this is a bug. Since in previous versions, the cut and paste should also adapt to relative address parts of the formula. I also experiment with different cell locations on the same file I attached earlier. 1. Put 1 to 5 on Cell C2:G2 2. Enter the formula sum(C2:G2) in B2 (B2 is now value 15) 3. Assign the name AnotherTotal to B2 4. Select cells B2:G2 5. Cut and paste on cell B10 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. -- 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
[Libreoffice-bugs] [Bug 84652] Name cell with formula is not updated after cut and paste
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. CutPaste 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) CutPaste B1 to B2 A1: =SUM(B1:D1) not Ok it must be =SUM(B2:D1) A1: =SUM(B1:D1) CutPaste D1 to D2 A1: =SUM(B1:D1) not Ok it must be =SUM(B1:D2) A1: =SUM(B1:D1) CutPaste 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
