Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

Suppose you are researching on a topic and have found something with a tabular form, now you would like to save that in your spreadsheet application to see that when offline, so you fired up OpenOffice Calc or MS Excel and pasted that table.

Now I don't know about MS Excel, but when I pasted in LibreOffice Calc then I seen something like as shown in the screenshot.

Uneven Row Size

As you can see the width of column A B and C can be resized because they are only 3 in numbers, but its hard to edit the height of 1, 2, 3, 4 etc.

Question

Any other way to resize the heights of 1, 2, 3, 4 than doing manually?

share|improve this question
    
can you upload a stripped down copy of the libreoffice file in question to sendspace? i think i have a solution, but i need to test it –  hbdgaf May 17 '12 at 3:19
    

2 Answers 2

up vote 4 down vote accepted

Open the file.

Ctl+a to select all.

Either:
A
Format -> Row -> Optimal Height
OK

B
Format -> Row -> Height
Set a height.
You could find the desired height by doing this same thing on the largest row and checking the value

share|improve this answer
    
It works the way I wanted, Thanks! –  Santosh Kumar May 17 '12 at 4:11

LibreOffice Calc will automatically resize the height. In your case all the results were just enough for a single line.

You might need to wrap around a column. In order to do this.

Basing from your screenshot.

  1. Resize column B in such that it has smaller width (desired width).
  2. Set your selection tool to the column header (column B). You should select the entire column.
  3. Right click it and format cells.
  4. Go to Format Cells -> Alignment -> check wrap text automatically.

There you go. All entries that are wider enough to the desire width will be automatically wrapped. Once wrapped the LibreOffice Calc will automatically adjust it's height.

Added: If row height needs to be of the same height.

If you want to make your row height of the same height.

  1. Select the rows (header, the one that has number).

enter image description here

  1. Put your selection in between the separator of each row number.

enter image description here

  1. Drag it and set the desired height.

enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.