Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using Open Office 3.01 on OS X. When I select an entire column of data by clicking its header, and the copy that to the clipboard, Open Office appears to copy all 65,537 cells to the clipboard. If I paste the data into a text editor, I'll get a file with 65,537 lines. This behavior is inconsistent with other spread sheet programs I've used.

Is there any way to change this behavior so it only copies down the the last cell with data in it? That is, if I have a column with 1034 rows, I'd like to be able to click a column header, selct copy, and have only the 1034 cells of data in the clipboard, not 65,537 cells of data.

I realize I could manually select just the data I wanted to. I'm not interested in that. I'm interested in getting open office to behave like the other spread sheet programs I use.

share|improve this question
up vote 5 down vote accepted

Try this:

  1. Select the first cell in the column.
  2. Type Ctrl+Shift+Down-Arrow

That will select only the cells with values in the column; at least in Excel.

share|improve this answer
Works in OOCalc, too. – CarlF Oct 28 '09 at 14:42
+1 for close, and better than nothing. One the Mac version of open office Cmd+Shift+Downarrow will select down to the last item if all the cells are filled, but it does some weird skipping around if there are empty cells. – Alan Storm Oct 29 '09 at 2:11

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .