[Libreoffice-bugs] [Bug 107267] New: During a sub-total calculation or sum, the data set is not computed well.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 107267
           Summary: During a sub-total calculation or sum, the data set is
                    not computed well.
           Product: LibreOffice
           Version: 5.3.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: naeilzoueidi at ubuntu.com

Description:
Working on a spreadsheet with Libreoffice Calc. After, I wanted to calculate
the  max, min and average it doesn't show in the end no lines indicates the
max, average and min of the set of values.

On the other hand, it shows only the field/label total in the end of the
spreadsheet file and affected the Max value to it.

I will attach the file I work on, so the steps mentioned below to reproduce the
same behavior as I have; containing the names of cells existing already in my
spreadsheet not the default ones.

Steps to Reproduce:
1. Select cell A1 
2. Click in the menu "Data" -> "Subtotals"
= 1st group =
3. Group by "Person Number", select "shipping time" and use the Max function.
= 2nd group =
4.
5. Group by "Person Number", select "shipping time" and use the Min function.
= 3rd group =
6. Group by "Person Number", select "shipping time" and use the Average
function.
7. Then OK.

Actual Results:  
The fields max, min and average specified for the set of values does not exist.
There is only "Total" which have the value of Max function.

Expected Results:
Showing the cells in the end of spreadsheet Max,Min and Average to all the set
of values and calculate well the value of total.


Reproducible: Always

User Profile Reset: Yes

Additional Info:
Tested on: Archlinux, Ubuntu and Windows.
Version: 5.3.0.3 release.


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:51.0) Gecko/20100101
Firefox/51.0

-- 
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/20170419/f861c880/attachment.html>