| Summary: | Formulas incorrect after inserting rows. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | dlw <dtree> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | ign_christian, miguelangelrv |
| Priority: | medium | ||
| Version: | 3.5.7.2 release | ||
| Hardware: | x86 (IA32) | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | A Librecalc spreadsheet with example of problem. | ||
Hi Dlw, please notice following notes so problem could be triaged: - your Linux distro? - step by step procedure to reproduce problem - what is expected/unexpected? - using latest stable release, because you shouldn't report a bug against unsupported release (3.5) After providing the requested info, please set the bug back to "NEW". (In reply to comment #1) > Hi Dlw, please notice following notes so problem could be triaged: > - your Linux distro? Ubuntu 12.04LTS > - step by step procedure to reproduce problem Copy row 3. Insert multiple rows 4,5,6. Paste copied row 3 into 4,5,6. See attached spreadsheet 'test1.ods'. > - what is expected/unexpected? Expected - All formulas to be correct. Unexpected - Formula in row 7 refers back to formula in row 4. Formulas after row 7 are correct. > - using latest stable release, because you shouldn't report a bug against > unsupported release (3.5) Does this mean do NOT report bugs from version 3.5.7.2? Hi dlw, I think it is a misunderstanding, the operation works fine. When you insert in rows 4;5;6 the references to row 3 never change what is right, row 3 has not been moved, so dependents cells do not change. Insert rows is like move the rest of cells down, in this case formula in B4 is moved to B7, and their formula does not change. There are easy ways to get what you want, e.g. enter in B2: =IF(A2="";"";OFFSET(A2;-1;1)+A2) copy down. Now do what you have explain. Works right for me. Maybe I am missing something but not a bug. Please if you are not agree, reopen it and explain why. By the way, even you can report against an outdated version, the bug fix only will be against versions in production. All versions here: http://downloadarchive.documentfoundation.org/libreoffice/old/ Thank you. Someone on the forum said to report it as a bug. My first bug report by the way. Thanks again, dlw -- The problem is not the gun, the problem is the person pulling the trigger. On Wed, Sep 25, 2013, at 03:51 PM, [1]bugzilla-daemon@freedesktop.org wrote: [2]mariosv changed [3]bug 69781 What Removed Added Status NEEDINFO RESOLVED Resolution --- NOTABUG CC mariosv@miguelangel.mobi [4]Comment # 4 on [5]bug 69781 from [6]mariosv Hi dlw, I think it is a misunderstanding, the operation works fine. When you insert in rows 4;5;6 the references to row 3 never change what is right, row 3 has not been moved, so dependents cells do not change. Insert rows is like move the rest of cells down, in this case formula in B4 is moved to B7, and their formula does not change. There are easy ways to get what you want, e.g. enter in B2: =IF(A2="";"";OFFSET(A2;-1;1)+A2) copy down. Now do what you have explain. Works right for me. Maybe I am missing something but not a bug. Please if you are not agree, reopen it and explain why. By the way, even you can report against an outdated version, the bug fix only will be against versions in production. All versions here: [7]http://downloadarchive.documentfoundation.org/libreoffice/old/ __________________________________________________________________ You are receiving this mail because: * You reported the bug. References 1. mailto:bugzilla-daemon@freedesktop.org 2. mailto:mariosv@miguelangel.mobi 3. https://bugs.freedesktop.org/show_bug.cgi?id=69781 4. https://bugs.freedesktop.org/show_bug.cgi?id=69781#c4 5. https://bugs.freedesktop.org/show_bug.cgi?id=69781 6. mailto:mariosv@miguelangel.mobi 7. http://downloadarchive.documentfoundation.org/libreoffice/old/ Dlw, please don't reply directly from email. Use link to this bug instead to replying. > Someone on the forum said to report it as a bug. Could you please post link to the forum in this bug report? You could use PPA to upgrade that is recommended for Ubuntu based distro: https://launchpad.net/~libreoffice/+archive/ppa Short hint: http://askubuntu.com/questions/16695/how-do-i-install-the-latest-version-of-libreoffice Anyway I could produce same behavior using LO 4.0.5.2 (Win7 32bit). I'll try to explain the steps with more detail: 1. Copy row 3 2. Mark all rows 4,5,6 > right-click > Insert Rows > right-click > Paste 3. See that cell B7 =IF(A7="";"";B3+A7) and cell B8 =IF(A8="";"";B7+A8) -> there were inconsistency since "B3" looks like locked in cell B7, but that's not happen in cell B8 & cell B9 @Dlw, could you confirm that was procedure you were using to reproduce? Forgive me for replying via email. My user name and password do not work when trying to login. I only have one username and two passwords and neither work. The method used below is correct. I downloaded 4.1 and it doesn't work there either. The method you sent works great. =IF(A2="";"";OFFSET(A2;-1;1)+A2) If I can not continue to log in I will create a new user. Thanks, dlw Link to my post: [1]http://en.libreofficeforum.org/node/6727 -- The problem is not the gun, the problem is the person pulling the trigger. On Wed, Sep 25, 2013, at 07:27 PM, [2]bugzilla-daemon@freedesktop.org wrote: [3]ign_christian changed [4]bug 69781 What Removed Added OS Linux (All) All CC ign_christian@yahoo.com [5]Comment # 6 on [6]bug 69781 from [7]ign_christian Dlw, please don't reply directly from email. Use link to this bug instead to replying. > Someone on the forum said to report it as a bug. Could you please post link to the forum in this bug report? You could use PPA to upgrade that is recommended for Ubuntu based distro: [8]https://launchpad.net/~libreoffice/+archive/ppa Short hint: [9]http://askubuntu.com/questions/16695/how-do-i-install-the-latest-version-of-l ibreoffice Anyway I could produce same behavior using LO 4.0.5.2 (Win7 32bit). I'll try to explain the steps with more detail: 1. Copy row 3 2. Mark all rows 4,5,6 > right-click > Insert Rows > right-click > Paste 3. See that cell B7 =IF(A7="";"";B3+A7) and cell B8 =IF(A8="";"";B7+A8) -> there were inconsistency since "B3" looks like locked in cell B7, but that's not happen in cell B8 & cell B9 @Dlw, could you confirm that was procedure you were using to reproduce? __________________________________________________________________ You are receiving this mail because: * You reported the bug. References 1. http://en.libreofficeforum.org/node/6727 2. mailto:bugzilla-daemon@freedesktop.org 3. mailto:ign_christian@yahoo.com 4. https://bugs.freedesktop.org/show_bug.cgi?id=69781 5. https://bugs.freedesktop.org/show_bug.cgi?id=69781#c6 6. https://bugs.freedesktop.org/show_bug.cgi?id=69781 7. mailto:ign_christian@yahoo.com 8. https://launchpad.net/~libreoffice/+archive/ppa 9. http://askubuntu.com/questions/16695/how-do-i-install-the-latest-version-of-libreoffice |
Created attachment 86495 [details] A Librecalc spreadsheet with example of problem. When copying and inserting rows then pasting the copied row, the formulas do not come out right. See attached spreadsheet.