Created attachment 107311 [details] Sample of bug Reproduce 1. Select cells C5:S5 2. Cut and paste the cells to another location The first cell (was named Total) displays 0. Temporary workaround. 1. Undo the paste 2. Redo the paste This behavior was not there in version 4.3.1
With Cut&Paste 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.
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.
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.
I have slightly different opinion on the result. I think that partial move should result to error instead. I also test this behavior on Excel 2003, Excel 2013, and Google Spreadsheet, Quattro Pro X7, WPS Office (KingSoft Office). The behaviors are 1. References to a range are not properly updated if it's not moved the whole referenced range (Current behavior of LibreOffice and Apache OpenOffice). Software with this behavior are - Excel 2003 - Excel 2013 - Google Spreadsheet - WPS Office 2. References are updated to cover the original range and the moved range (As indicated as a bug). Software with this behavior are - Quattro Pro X7 - Lotus 123 (As indicated above) 3. My proposal is The move should cause error in the referring cell as the range are now changed.
This may be the same problem: in cell C1 enter 1 in cell C2 enter =$C$1+C1 select cell C2 Copy select range C3:C40 Paste select range C21:C40 Cut select any cell in any other column Paste
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT - Update the version field - Reply via email (please reply directly on the bug tracker) - Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16
If not the entire range a formula expression references is moved (Cut&Paste) then the reference is not adjusted to a new position, i.e. moving only C5:S5 the reference D5:ZV5 in C5 stays D5:ZV5. This is normal behaviour implemented by all major spreadsheet applications, as also comment 4 indicates.