https://bugs.documentfoundation.org/show_bug.cgi?id=169373
Bug ID: 169373
Summary: Sum Behaviour is not correct when scrolling + sort
enabled
Product: LibreOffice
Version: 25.8.0.4 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
So I'm doing a financial type spreadsheet. I have an advanced sort on for the
headers and I currently have a sort based on description of transaction. I am
trying to then use the sum equation to get the total between certain dates.
All is well so far. The problem is with the result, because it counts all the
transactions between those dates not just the ones I selected based on the
sort. I had thought about the best way to solve this and I think it should be
with the equation. When a sort is on the sum equation should take this into
consideration for example: I enter "Sum(" then go to select drag over the cells
I want resulting in Sum(G32:G62) when it should input it as Sum(G32,G37,G43,
G50,G57,G62) when I drag to select the cells that appear in a consecutive order
based on the sort but aren't based on the row numbers.
Steps to Reproduce:
1.Financial Spreadsheet with advanced filters on
2.Sort Enabled, for my example based the transaction description
3.Select drag when doing a formula
Actual Results:
The formula being displayed is formatted like this: "A1:A10"
Expected Results:
The formula should respect the sort and display the selected cells more like
this "A1,A4,A5,A6,A8,A10". Possibly take into account the consecutive group:
"A1,A4:A6,A8,A10".
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
--
You are receiving this mail because:
You are the assignee for the bug.
