[Libreoffice-bugs] [Bug 88793] EDITING, subtotals don't apply formatting

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=88793

--- Comment #31 from Brian McKee <bmckee at muskokaauto.com> ---
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
https://documentation.libreoffice.org/assets/Uploads/Documentation/en/GS5.2/HTML/GS5203-StylesAndTemplates.html#__RefHeading__7025_1080284074)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200708/1fab1efe/attachment.htm>