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