Ask Your Question

get libreoffice to remember last used border format

asked 2020-04-07 09:40:15 +0200

dejayajay gravatar image

Is it possible to get LibreOffice Calc to remember the last selected Border format? EI when selecting Borders from the icon menu bar. This would be helpful IE time saving.

If not, can 'the team' incorporate this into a future release?

edit retag flag offensive close merge delete



I do not clearly understand what you want, but anyway if you miss something, you should submit a request at Bugzilla. Otherwise, it will never be implemented.

gabix gravatar imagegabix ( 2020-04-07 09:46:30 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-04-07 10:46:49 +0200

Lupp gravatar image

updated 2020-04-07 10:50:48 +0200

LibreOffice remebers the last action. You can repeat it. The shortcut is Ctrl+Shift+Y by default. Changing the selection is not an action in this sense.
Therefore you can change the selection interim and repeat the previous setting of attributes for the new selection in addition (if applicable). Calc does it mostly in a reasonably smart way if the new range has different dimensions.

In Calc you can also copy (Ctrl+C) the range you applied settings to, select a different range, and then call Paste Special... (Ctrl+Shift+V). You are prompted for a selection of Content/Property types. Choose Formats only - OK. Done! (The above mentioned "smartness" is reduced when going this way.)

Basically: Calc isn't Excel. The recommended way to apply attributes to cells is to avoid it. ?? Yes. You should better define named cell styles and assign them to ranges wherever possible. Only rare exceptions should justify direct setting of cell attributes. (The PivotTable-tool does e.g.)

Of course, we need to accept hat there aren't yet CellRange styles - and that most likely such a thing never will be. The experiments concerning quasi-styles for TextTable in Writer aren' too ecouraging, imo. However, the design of a complete table for a prettyprint sheet should be seen as unique anyway.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-04-07 09:40:15 +0200

Seen: 25 times

Last updated: Apr 07