Ask Your Question
0

cutting and copying multiple table rows

asked 2014-05-22 16:05:45 +0200

Peceny gravatar image

updated 2015-08-29 10:03:34 +0200

Alex Kemp gravatar image

With my LibreOffice Writer 3.5.7.2 in Ubuntu 12.04 I have not found, how to cut several table rows at once and paste them into the same table. Is it possible? Do I need a higher version? Thanks!

edit retag flag offensive close merge delete

Comments

Hi, I'm on 4.2.4.2 on WIN8. I also cannot do it in CALC but I did learn a nice trick from it.

You can have multiple selections (wih CTRL and mouse) and then colour the cells or bold them all etc. You cannot copy and paste. It sells me I can only do that with a single selection. Also, I cannot name the range for a similar reason (the range needs to be rectangular).

But the cool thing is that I can enter a value in one of the selected cells and when I press TAB it will move only within the multi selection.

As soon as you click elsewhere, it will unselect the multiple ranges.

You can also use the menu while having multiple selections.

Pretty cool but still not solving your cutting and pasting issue.

CEAuke gravatar imageCEAuke ( 2014-05-22 16:25:58 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2015-01-16 20:37:35 +0200

LogicDaemon gravatar image

My way of doing this:

  • mark rows you need to copy / cut / whatever in unused column. Use any character, I'm usually using 1 for easy counting, but some prefer * due to visual style
  • add autofilter (Data → Filter → AutoFilter) for column with marks. To make sure autofilter covers all rows, last row must be marked when adding it, or alternatively add autofilter for whole range which contains data.
  • filter only marked rows (choose "not empty" in filter droplist)

Now you free to copy or clear them. Though you can't cut directly, you can copy & clear (Del) instead.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2014-05-22 16:05:45 +0200

Seen: 2,825 times

Last updated: Jan 16 '15