Ask Your Question
0

Calc paste special 'shift'

asked 2012-10-14 08:48:06 +0200

DWilksch gravatar image DWilksch
1 1

updated 2013-03-26 21:51:14 +0200

manj_k gravatar image manj_k
5782 4 33 50

Could someone please explain why the 'Shift Down' option in the 'Paste Special' menu of Calc is greyed out when I try to cut and insert a row of cells. It is not greyed out when I try the same option with 'Copy'.

This complicates any attempt to move cell contents around in a spreadsheet. I am coming from the Excel world and the functionality I am trying to duplicate is the 'Insert Cut Cells' option.

delete close flag offensive retag edit

Comments

Please, can you inform what is your OS and LibreOffice version?, and can you explain step by step?. I cannot see this issue with 3.5.7.2 or 3.6.3.1 in Win7x64

mariosv ( 2012-10-14 18:29:09 +0200 )edit

Ok, I can see now, is when a row(s) or column(s) is(are) cut, seems a bug because the option is inverted, right with rows and down with column. There is a reported bug: https://bugs.freedesktop.org/show_bug.cgi?id=42265

mariosv ( 2012-10-17 04:19:13 +0200 )edit

mariosv, the bug report you link to describes the problem I am having. I am currently using 3.6.2.2 on Win 7 x64. Thank you for following this up.

DWilksch ( 2012-10-21 06:46:50 +0200 )edit

fdo#42265 has current status RESOLVE DUPLICATE of fdo#56098

fdo#56098 has current status REOPENED

qubit ( 2013-02-01 03:18:32 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2013-03-02 06:42:16 +0200

qubit gravatar image qubit flag of United States
5721 3 48 41

TODO: Resolve Question as BUG FILED.

link delete flag offensive edit

Comments

Bug 56098 - UI: 'Paste Special - Shift Cells' options availability not logical

Status: RESOLVED FIXED · target:4.1.0

manj_k ( 2013-03-26 21:50:09 +0200 )edit
0

answered 2012-10-17 00:41:20 +0200

edwardsmarkf gravatar image edwardsmarkf
1

same problem... does anybody have an answer?

Version 3.6.1.2 (Build ID: e29a214) on win-7

link delete flag offensive edit
0

answered 2012-10-15 05:39:24 +0200

ROSt52 gravatar image ROSt52 flag of Japan
1906 30 33

Iam using LO 3.5.6.2 on XP/SP3 and do not observe any problem with PasteSpecial/ShiftDown. I tested single cells, arrays and entire rows (single and multi). What is your LO version?

link delete flag offensive edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

Asked: 2012-10-14 08:48:06 +0200

Seen: 228 times

Last updated: Mar 02