<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - During a sub-total calculation or sum, the data set is not computed well."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107267">107267</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>During a sub-total calculation or sum, the data set is not computed well.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>naeilzoueidi@ubuntu.com
</td>
</tr></table>
<p>
<div>
<pre>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</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>