<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING, subtotals don't apply formatting"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=88793#c31">Comment # 31</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING, subtotals don't apply formatting"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=88793">bug 88793</a>
from <span class="vcard"><a class="email" href="mailto:bmckee@muskokaauto.com" title="Brian McKee <bmckee@muskokaauto.com>"> <span class="fn">Brian McKee</span></a>
</span></b>
<pre>I can confirm this issue is present in 6.0.6
If you create the missing Result style BEFORE you insert subtotals, it works.
Here's a different simple way to demonstrate.
Step One
Create any table of random stuff. e.g.
| Title | Head 1 | Head 2 |
| A | 1 | 2 |
| A | 1 | 2 |
| B | 1 | 2 |
| B | 1 | 2 |
| C | 1 | 2 |
| C | 1 | 2 |
Step Two
Format → Spreadsheet Theme
Pick any of them, like say Autumn Leaves
Step Three
Data → Subtotals
Group By Title, Sum Head 1 and Head 2
Observe the formatting on the 'Result' lines - it will have a grey background.
Now, open a new spreadsheet and do Step One, then Step *Three*, then Step *Two*
See how the Result lines don't have any formatting this time?
Alternatively, you can create a new style called 'Result', and as long as you
do that BEFORE you insert subtotals, it works as expected....
WORKAROUND
As a workaround, I created a blank spreadsheet, and in that spreadsheet created
a style called 'Result' that had the formatting I wanted.
I then saved that spreadsheet as an .odt, and chose that spreadsheet as my
default template. (see
<a href="https://documentation.libreoffice.org/assets/Uploads/Documentation/en/GS5.2/HTML/GS5203-StylesAndTemplates.html#__RefHeading__7025_1080284074">https://documentation.libreoffice.org/assets/Uploads/Documentation/en/GS5.2/HTML/GS5203-StylesAndTemplates.html#__RefHeading__7025_1080284074</a>)</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>