Am 04.05.20 um 18:12 schrieb WA.TWORSX via AOL:

On 5/3/2020 1:44 AM, Brian Barker wrote:
At 13:04 02/05/2020 -0400, Vince Bonly wrote:
Optimum Row Height-Default
In Calc, where can the default setting be reset/changed?

I don't think it can - but do you need to?

o You can easily select multiple rows using click and Shift+click in the row headers or by dragging down the row headers. Then you can adjust the row height for all those rows in a single step.

o Even more generally, you can select an entire sheet (or even multiple sheets) by clicking in the rectangle at top left, where the row and column headers meet. Again, you can adjust the row height for all those rows at once.


Yes, but first I must drop down to any Row's left margin header area and do a right-click; only after doing that, am I able to add my desired additional space (pitch) and make a change for optimum row height for all rows in the sheet (most of the time, as this sometimes misses a row(s)).

I am not sure what you try to accomplish. Selecting all rows does not help you?

While it is not obvious solution you could change the Style. Press F11, in the Popup you will see a default style. You modify this style and change on the Borders tab you find the distance to the cell space.

You set up the styles you need, and then you mark the complete sheet as described above, select optimal Row hight and it will adjust.


The only exception is if you have merged cells. That will not work as you might expect.


If you want to change the default distance you have to adjust the default style and save the document as your default template.


HTH

Peter


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Reply via email to