asked 2012-03-08 16:34:54 +0200

Xpider
21 ● 3

updated 2013-01-26 07:49:50 +0200

5693 ● 3 ● 48 ● 41

I have a difficult question, that i cant see how i may solve it. In a simple way, imagine that you have a column whit 32 lines, but not every lines on it are full.

The question is, how automaticaly (whit a funcion) i may select and copy only the lines whit data to another sheet?

Many thanks to you all that will try to help me on this.

delete close flag offensive retag edit

3 Answers

Sort by » oldest newest most voted

answered 2013-03-14 05:25:44 +0200

ROSt52

1744 ● 30 ● 30

Use autofilter and filter for Non Empty cells, then you select and copy the "full" cells.

Reading also Help: Only Copy Visible Cells is recommended

link delete flag offensive edit

Comments

Link: https://help.libreoffice.org/Calc/Only_Copy_Visible_Cells

qubit ( 2013-03-14 11:20:04 +0200 )edit

answered 2012-03-09 17:30:35 +0200

jofilho

503 ● 2 ● 10

Automatically? Only through macro.

link delete flag offensive edit

Comments

@Xpider -- are you waiting for actual macro code here? Are you still interested in an answer? Let us know..

qubit ( 2013-03-13 04:51:55 +0200 )edit

answered 2013-03-14 22:21:52 +0200

mariosv

4629 ● 20 ● 45

Using standard filter (Menu/Data/Filter/Standard), you can select a destination range for the filtered data.

image description

link delete flag offensive edit

Resources

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

2 followers

Stats

Asked: 2012-03-08 16:34:54 +0200

Seen: 184 times

Last updated: Mar 14

Select only full cells on a column

3 Answers

Comments

Comments

Resources

Donate

Question tools

Stats

Related questions