← Back to team overview

desktop-packages team mailing list archive

[Bug 1388491] Re: [upstream] calc: "Cut" and "Paste special" -> "Transpose" effects other cells

 

Launchpad has imported 8 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=68976.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.

------------------------------------------------------------------------
On 2013-09-05T11:03:04+00:00 Leshiy wrote:

I was working with the spreadsheets and noticed this little gem. The
value in the formula with the anchored cells (e.g. $A$1) are updated
when i cut and paste in unrelated rows.

Steps to reproduce:
Enter value 1234 in cell A1
Enter values 5,2,3 in cells A3, A4 and A5 respectively
Enter formula ($A$1-ABS(A3))*-1 in cell B3
Drag the formula to fill other 2 cells

Now you have values -1229, -1232 and -1231 in cells B3, B4 and B5

Enter values 2, 3, 4 in cells A7, B7 and C7
Select these cells and cut them.
Click on A7 cell
Paste special: Number and Transpose checked, Operations: None, Shift Cells: Don't shift
Values in cells B3, B4 and B5 change to 2, 0 and 1 respectively
Formulas are updated to ($A$7-ABS(A9))*-1, ($A$7-ABS(A4))*-1, ($A$7-ABS(A5))*-1 in those cells.

I am running opensuse 12.1 and official repository and Build ID:
350m1(Build:413)

This also happens on Windows OS

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/0

------------------------------------------------------------------------
On 2013-09-09T04:22:47+00:00 Jmadero-dev wrote:

Thank you for reporting this issue! I have been able to confirm the issue on:
Version 4.0.4 
Platform: Bodhi Linux 2.2 x64
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
As I've been able to confirm this problem on an earlier release I am changing the version number as version is the earliest version that we can confirm the bug, we use comments to say that the bug exists in newer versions as well.

Marking as:

New (confirmed)
Major - loss (change) of data
High - default seems appropriate

Indeed - quite the gem ;) Thanks for catching this

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link:
https://wiki.documentfoundation.org/QA/BugTriage

There are also other ways to get involved including with marketing, UX,
documentation, and of course developing -  http://www.libreoffice.org
/get-help/mailing-lists/.

Lastly, good bug reports help tremendously in making the process go
smoother, please always provide reproducible steps (even if it seems
easy) and attach any and all relevant material

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/1

------------------------------------------------------------------------
On 2013-10-30T16:30:30+00:00 Ralfs-mail-address wrote:

I suggest the interim solution to disable "Paste Special" after cutting
cells.

The advantage is obvious: Loss or change of data are avoided. I
experienced the consequences of this bug in a complex spreadsheet. The
changes of links can be difficult to detect and to fix again.

I do not see substantial disadvantages of disabling "Paste Special"
after cutting cells because formula links are not shifted as expected
after cutting and inserting with "Paste Special". I reported this
unexpected behaviour with bug 71058 "EDITING: Cut and paste special does
not shift formula links as expected". If cells are cut and then pasted
normally (i.e. with "Paste" instead of "Paste Special"), all formula
links to these cells point to the new cell positions after pasting the
cells. This expected shift of formula links does not occur with the
command "Paste Special". Formula links still point to the old positions
of the moved cells. Therefore, "Cut" and "Paste Special" leads to the
same result as "Copy" and "Paste Special" with subsequent deletion of
the old cells. Thus disabling "Paste Special" after cutting cells does
not lead to a loss of functionality. It can be replaced in the workflow
by "Copy" and "Paste Special" with subsequent deletion of the old cells.
A loss of functionality occurs only if bug 71058 can be fixed by
aligning the behaviour of "Paste Special" with "Paste" after cutting
cells. MS Excel 2007 does not offer the full set of "Paste Special"
options after cutting cells either. I do not have access to later Excel
versions.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/2

------------------------------------------------------------------------
On 2013-10-30T19:20:45+00:00 Ralfs-mail-address wrote:

(In reply to comment #2)

I received a comment to bug 71058. The comment implies that my suggested
interim solution has disadvantages, because "Cut" and "Paste Special"
behaves as expected unless "Transpose" is selected. Therefore, disabling
"Paste Special" completely after cutting cells would disable expected
behaviour as well. Alternatively, only the "Transpose" option in "Paste
Special" could be disabled as interim solution. However, such a quick
fix lacks charm admittedly. Maybe there is no convincing interim
solution.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/3

------------------------------------------------------------------------
On 2013-10-30T23:01:41+00:00 Cno wrote:

This is a bug.
and an old one...

I clarified the summary - quite essential to mention Paste special and
Transpose to help people seeing the issue :)

thanks,
Cor

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/4

------------------------------------------------------------------------
On 2014-09-25T17:18:28+00:00 peterthevicar wrote:

Tell me if I should open a separate bug for this, but it looks to me
that formulae are changed when you simply do Cut / Paste (recorded in
the undo history as Cut / Move) so this is a more serious problem than
it may seem on first sight of the title.

I fell foul of this when moving some data around in a simple 'row total'
sheet with a protected column of formulae. "Imagine my surprise" when
cut / pasting some of the data changed the formulae in unpredictable (by
me) ways!

Here's how counter-intuitive it is (no need to protect the formulae for
this)

1) create a simple 'row sum' table as follows

1  2  =A1+B1
3  4  =A2+B2

2) This displays as expected:

1  2  3
3  4  7

3) Select cells A2 and B2 and cut, gives what you'd expect:

1  2  3
      0

4) Click on A1 and paste

3  4  7
      7

And C2 now has =A1+A2 - NOT what I expected!

I guess this sort of spreadsheet is fairly common and it really had me
confused. I can only move my input values around using select, copy,
paste, select, delete instead of the obvious select, cut, paste.

This seems to be a problem arising from assuming that every cut and
paste is a move whereas it is often, and more obviously, just a cut and
paste! Surely to get a move you should ask for it via Paste Special?

Note that exactly the same table in Writer gives the expected result:

3  4  7
      0

and leaves the formula in B3 alone.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/5

------------------------------------------------------------------------
On 2014-10-04T21:03:48+00:00 JBF wrote:

Hi Peter,

Please, open a new bug report. What you describe is another problem.

Best regards. JBF

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/6

------------------------------------------------------------------------
On 2014-12-04T20:02:43+00:00 Gquigs+bugs wrote:

Another example reproducer -
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/10


** Changed in: df-libreoffice
       Status: Unknown => Confirmed

** Changed in: df-libreoffice
   Importance: Unknown => High

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1388491

Title:
  [upstream] calc: "Cut" and "Paste special" -> "Transpose" effects
  other cells

Status in LibreOffice Productivity Suite:
  Confirmed
Status in libreoffice package in Ubuntu:
  Triaged

Bug description:
  Step to reproduce:
  1. Open the attached ods file.
  2. Select I12 to L16 and cut this region (Ctrl+X). (This bug doesn't occur with copy)
  3. Select I5 and open Paste Special dialog (Shift+Ctrl+V).
  4. Enable "Transpose" option and Click "OK"

  Then, values of some cells in C9 to E10, which are not related to
  blank cells are changed:

  C9: =C3/SUM(C$3:C$6) -> K7/SUM(C$3:C$6)
  D9: =D3/SUM(D$3:D$6) -> L7/SUM(D$3:D6)
  E9: =E3/SUM(E$3:E$6) -> M7/SUM(E$3:E$6)
  C10: =C4/SUM(C$3:C$6) -> K8/SUM(C$3:C$6)
  D10:  =D4/SUM(D$3:D$6) -> L8/SUM(D$3:D6)
  E10: =E4/SUM(E$3:E$6) -> M8/SUM(E$3:E$6)

  My environment is Ubuntu 14.04 LibreOffice 4.2.6.3

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions


References