[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

Scito  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |i...@scito.ch
   |desktop.org |
 Status|NEW |ASSIGNED

--- Comment #20 from Scito  ---
I've found the problem. Working on a solution.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

Scito  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=74
   ||899

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

--- Comment #19 from Scito  ---
Confirmed

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 4f7bc49bce261f1cf206d25f0299fd080a9f5d28
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: x11
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

Timur  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||7348

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

--- Comment #18 from Andy  ---
yes it's still there and it is an especially embarassing problem when data
management in a spreadsheet goes berserk. 
Of course the specific actions that make the bug emerge are rare, but once a
user happens to meet it, trust in all computations will be severely tarnished,
and anguish will set in... often reason enough to move to other software...
Please anyone who could fix this, help!

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

--- Comment #17 from Timur  ---
Repro 6.4+

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

himajin100...@gmail.com changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=44
   ||383

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

--- Comment #16 from QA Administrators  ---
Dear alexjironkin,

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 with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

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) from
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:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

Timur  changed:

   What|Removed |Added

 CC|gti...@gmail.com|

--- Comment #15 from Timur  ---
Repro in 6.2+.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

--- Comment #14 from QA Administrators  ---
** 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 with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

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) from
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:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

m.a.riosv  changed:

   What|Removed |Added

 CC||silva...@katamail.com

--- Comment #13 from m.a.riosv  ---
*** Bug 104731 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

--- Comment #12 from Ralf  ---
(In reply to QA Administrators from comment #11)

The bug is still present (LibreOffice 5.2.3.3, 32-bit version, Windows 10).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

--- Comment #11 from QA Administrators  ---
** 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.1.6 or 5.2.3  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 helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug-20161108

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

Timur  changed:

   What|Removed |Added

 CC||gti...@gmail.com
   Hardware|x86-64 (AMD64)  |All
 OS|Linux (All) |All

-- 
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 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

--- Comment #10 from Timur  ---
Created attachment 119968
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119968=edit
example sheet

-- 
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 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

--- Comment #8 from satp...@gmail.com ---
I have also hit this bug using libreoffice-calc 1:4.2.8-0ubuntu2 on Ubuntu
1:4.2.8-0ubuntu2 on x86_64.

-- 
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 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=68976

satp...@gmail.com changed:

   What|Removed |Added

 CC||satp...@gmail.com

--- Comment #9 from satp...@gmail.com ---
(In reply to satphil from comment #8)
 I have also hit this bug using libreoffice-calc 1:4.2.8-0ubuntu2 on Ubuntu
 1:4.2.8-0ubuntu2 on x86_64.

Sorry, should have read: on Ubuntu 14.04.2 LTS, Trusty Tahr on x86_64.

-- 
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 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=68976

--- Comment #7 from Bryan Quigley gquigs+b...@gmail.com ---
Another example reproducer -
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491

-- 
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 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=68976

Jean-Baptiste Faure jbfa...@libreoffice.org changed:

   What|Removed |Added

 CC||jbfa...@libreoffice.org

--- Comment #6 from Jean-Baptiste Faure jbfa...@libreoffice.org ---
Hi Peter,

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

Best regards. JBF

-- 
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 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=68976

--- Comment #5 from peterthevicar peter...@gmail.com ---
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.

-- 
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 68976] Formulas change after cut and paste special action with Transpose

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=68976

Cor Nouws c...@nouenoff.nl changed:

   What|Removed |Added

   Priority|high|medium
 CC||c...@nouenoff.nl
Summary|Formulas change after cut   |Formulas change after cut
   |and paste action|and paste special action
   ||with Transpose
Version|3.5 all versions|Inherited From OOo

--- Comment #4 from Cor Nouws c...@nouenoff.nl ---
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

-- 
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