Create style with multi-cell *In-between-borders* not possible?

[s-light1]

seems multi-cell - in-between-cell-borders are not possible to save as style definitions:

steps

• create 2x2 cells with this border format:
  
  
• close Format Cells dialog with OK
• make sure your selection is started in the top right of the 2x2 area. (visible by the selection border
  
• menu: Styles - + New Style from Selection - enter name test2x2

expected result

cell style is the same as before the style creation

actual result

only the style from the focus single cell gets saved.

thoughts

• are there any other options to save such a more complex setup?
• and even more complex setups as tables with heading / footing cells?!

with a short search i did not find a bug regarding this.

[Hrbrgr]

Please provide a sample file.
You can upload the file here. Thank you.

---

And please name your operating system and LibreOffice version. Thanks.

[PKG]

Try AutoFormat

[s-light1]

thanks @PKG
i have tested this and it works.
so this could be an option!

only thing i don*t like is that the Auto-Format thing uses ONLY direct-formatting and is not style-based…
(i tried with creating a auto-format from a style-only based example…)

so i would have to be very careful to what include in the auto-format and how i would add other formats used only sometimes (for example for single cells)…

i just experimented a little bit more with this…
for me it has not enough features / good enough magic
it only can handle first and last row/column - in-between formats are ignored…
libreoffice_test__autoformat.ods (12.6 KB)

so i will use my style based workarounds and use a full Template file… i think that works for me good for now

[s-light1]

here is a test case:
original

result

file:
libreoffice_test__multicell-style.ods (9.3 KB)

---

LibreOffice:

Version: 7.1.7.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 16; 
OS: Linux 5.11; 
UI render: default; VCL: kf5
Locale: de-DE (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.1.7-0ubuntu0.21.04.1
Calc: threaded

OS

Operating System: Kubuntu 21.04
KDE Plasma Version: 5.21.4
KDE Frameworks Version: 5.80.0
Qt Version: 5.15.2
Kernel Version: 5.11.0-50-generic
OS Type: 64-bit
Graphics Platform: X11
Processors: 16 × Intel® Core™ i9-9980HK CPU @ 2.40GHz
Memory: 31,2 GiB of RAM
Graphics Processor: Mesa Intel® UHD Graphics 630

[EarnestAl]

I think it is a Cell style, not a cells style so cannot be done this way.

The AutoFormat looks like a macro that formats existing cells. If I subsequently insert a row in the middle the coloured rows get out of step. Creating your own macro might be the only way forward for one step formatting of a selection.

Workaround for your example is to format the cell with green all round, save it as a style and apply the style to a selection. A Thick Box Border or Outside Borders can be added in the Sidebar > Properties > Cell Appearance and still retain the between-cell green borders. Adding rows or columns through the selection retains the overall formatting appearance.