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

[bugzilla-daemon]

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

--- Comment #31 from Brian McKee  ---
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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #30 from Robert Gonzalez MX  ---
Created attachment 154452
  --> https://bugs.documentfoundation.org/attachment.cgi?id=154452=edit
Descriptions, screenshots and steps

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #29 from Robert Gonzalez MX  ---
Hi there.

I have made a writer file with screenshots and descriptions. I made new tests
with LO 6.3.1.2 and found that maybe if the “Result” and “Result2” cell styles
where reincorporated, to the default initial styles when a new spreadsheet is
created, the issue will resolve or reduce its presence.

Descriptions and test steps are in the writer file.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #28 from Timur  ---
Robert, thank you for following your bug report. 
But please make it simple for testers and explain clearly: what is experienced
and expected result. 
You say "The result of the subtotals doesn't have the formatting" but I see
formatting on screenshots. 
Please write on screenshots and maybe make some manually as you expect (in
other color to be seen). 
Please then test with new profile (you may rename "user" folder down in
%AppData%\LibreOffice\).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

 Attachment #125575|0   |1
is obsolete||

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

 Attachment #112797|0   |1
is obsolete||

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #27 from Robert Gonzalez MX  ---
Hi.
I have tested this bug with Version: 6.3.1.2
Build ID: b79626edf0065ac373bd1df5c28bd630b4424273
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde5; 
Locale: es-MX (es_MX.UTF-8); UI-Language: en-US
Calc: threaded

In the first test file I sent "Bug subtotals test1.ods", still the subtotals
doesn't display the format correctly. It has the "Result" cell style, that has
the bold and italics font display, but in the numbers it has the standard
format.

In the second test file "2018 04 29 Test subtotals.ods", the subtotals display
correctly, with bold, italics and currency. But reviewing the numbers category,
in the "Result" cell style, it has the standard format as well. So I think the
currency format is in some way inherited from the format of the data cells.
In this file the subtotals seems to work as expected.

In the third test file "2018 04 29 New subtotals test.ods", that was created
new with version 6.1, the subtotals are displayed with the currency format, but
not the bold and italic format. And also the "Result" and "Result2" cell styles
were not created.

Creating a new calc file with LO 6.1.3.2 doesn't create this cell styles also.

Also I tested with the UI in Spanish and English, with the same results,
because there were some problems with the cell styles when the UI changed in
English/Spanish.

Maybe if the "Result" and "Result2" cell styles where reincorporated, to the
default initial styles when a new spreadsheet is created, the issue will
resolve or reduce its presence. As I see it in the 2nd and 3rd test file.

In the 1st test file maybe I messed up with the "Result" style doing my
testings.

I Hope this is helpful.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #26 from QA Administrators  ---
Dear Robert Gonzalez MX,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||9509

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #25 from Robert Gonzalez MX  ---
When opening the file created with LO 6.1 apha1 in LO 6.0.3.2 x64 all the cells
including the ones created by the Data - Subtotals have the default style and
the subtotals results have the correct style, but they don't have the bold
italics highlight.

Redoing the Data - Subtotals procedure, displays the message "Delete data? yes
o no". Answering yes refresh the subtotals losing the formatting. But the bold
italics highlight is not made, and the "Result" and Result2" styles are not
created either.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #24 from Robert Gonzalez MX  ---
Created attachment 141765
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141765=edit
Test file created with LO 6.1 apha1

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #23 from Robert Gonzalez MX  ---
Created attachment 141764
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141764=edit
Test file with previous versions

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #22 from Robert Gonzalez MX  ---
Hi.

Tested with Version: 6.1.0.0.alpha1 (x64)
Build ID: cb47f0d320994e001bc38dc2ee9b7d957b15e6ab
CPU threads: 8; OS: Windows 10.0; UI render: GL; 
Locale: es-MX (es_MX); Calc: CL

I have made two tests, using Data - Subtotals, which is the case for this bug,
and another test using the function subtotals.

What I find out using Data - Subtotals is that in the new rows inserted by the
grouping, the cell style used for this is "Result" and is used in all the cells
with the subtotal results.
But if I apply manually the cell style "Result2" to one of the subtotals
results, the correct formatting is applied.

These styles are not present in a new spreadsheet, so I guess that they are
created when the Data - Subtotals procedure is executed.

Maybe in this procedure, the style applied to the grouping is "Result" and the
style to apply to the subtotal results should be "Result2".

Actually, creating a new spreadsheet in 6.1, and typing all the test data
again, and performing the Data - Subtotals with the menu, it doesn't create the
"Result" and "Result2" styles. Looking for them in the styles navigator window,
they are not present nor hidden.

When selecting the cells of the typed data, the "default" style is highlighted
in the styles window,  but when a cell in the subtotals row is selected or
clicked, nothing is highlighted in the styles window, and there are no "hidden"
styles.

Also, the subtotals results don't apply the same formatting from the data used.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #21 from Xavier Van Wijmeersch  ---
Created attachment 134845
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134845=edit
without selecting group by group

Did two test one following the description, that one give the zero's in column
B
second test i did not select group by group and the group name is given in
column B

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #20 from Xavier Van Wijmeersch  ---
Created attachment 134844
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134844=edit
selecting the option group by group

this screenshot shows zero's in column B where there need the groupsname

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Arul Michael  changed:

   What|Removed |Added

 Status|ASSIGNED|NEW
   Assignee|arul7...@gmail.com  |libreoffice-b...@lists.free
   ||desktop.org

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
 CC||xiscofa...@libreoffice.org
   Assignee|libreoffice-b...@lists.free |arul7...@gmail.com
   |desktop.org |

--- Comment #16 from Xisco Faulí  ---
Hi Arul,
Please, next time you assign a bug to yourself, remember to change the status
and the assignee.
Regards

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Status|ASSIGNED|NEW

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Arul Michael  changed:

   What|Removed |Added

   Assignee|arul7...@gmail.com  |libreoffice-b...@lists.free
   ||desktop.org

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Arul Michael  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |arul7...@gmail.com
   |desktop.org |

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #9 from Robert Gonzalez MX  ---
Created attachment 125575
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125575=edit
Screenshot

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #8 from Robert Gonzalez MX  ---
Hello.
Just tested this bug with Version: 5.2.0.0.beta1
Build ID: 1e9933ef611c66bcded94b84052543c78cf1c223
CPU Threads: 8; OS Version: Linux 4.1; UI Render: default; 
Locale: es-MX (es_MX.UTF-8)
In OpenSUSE Leap 42.1

Is still reproducible

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Timur gti...@gmail.com changed:

   What|Removed |Added

Version|4.3.5.2 release |4.1.0.4 release

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #6 from m.a.riosv miguelange...@libreoffice.org ---
*** Bug 92233 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Robert Gonzalez MX riggra...@gmail.com changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=92
   ||233

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Robert Gonzalez MX riggra...@gmail.com changed:

   What|Removed |Added

 CC||riggra...@gmail.com

--- Comment #5 from Robert Gonzalez MX riggra...@gmail.com ---
Hi.

Reproducible with Version: 5.0.0.0.beta1
Build ID: 0a16c3dda4150008d9be6f24cbd15ac198d116d3
Locale: es-MX (es_MX) on windows 8

I think the option of formatting should be independent from the pre-sorting.
The option of include formatting is only selectable when the pre-sorting option
is enabled.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Matthew Francis fdb...@neosheffield.co.uk changed:

   What|Removed |Added

   Keywords||bisected
 CC||fdb...@neosheffield.co.uk,
   ||markus.mohrhard@googlemail.
   ||com
   Hardware|Other   |All
 Whiteboard||bibisected
 OS|Windows (All)   |All

--- Comment #4 from Matthew Francis fdb...@neosheffield.co.uk ---
The subtotals lose their formatting as of the below commit.

Adding Cc: to markus.mohrh...@googlemail.com; Could you take a look at this?
Thanks


57efd69c22e2c6f5cb4d057345644b6e07a62d48 is the first bad commit
commit 57efd69c22e2c6f5cb4d057345644b6e07a62d48
Author: Markus Mohrhard markus.mohrh...@googlemail.com
Date:   Fri May 24 22:41:44 2013 +0200

remove inherited number formats, related fdo#60215

Change-Id: I23d5e1b3baeb1499ada1fba1665027bdbe3fbb87

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Cor Nouws c...@nouenoff.nl changed:

   What|Removed |Added

   Keywords||regression
 CC||c...@nouenoff.nl

--- Comment #3 from Cor Nouws c...@nouenoff.nl ---
according to mariosv a regression

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs