https://bugs.documentfoundation.org/show_bug.cgi?id=154240
Bug ID: 154240
Summary: Formula Calculations does not work with Autofilter
Product: LibreOffice
Version: 7.5.1.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a list of item that start with 1 and the cells below have the formula of
the one previous plus 1. This does not work with Autofilter when a filter has
been applied. For example the cell with the original 1 is in the 5th row, the
ones before are broken. The value should be based on the original order and
not the filtered order.
Thank you,
Steps to Reproduce:
1.Make a acending number list for example 1 in the first cell and the next one
below being =A1+1
2.Make an autofilter
3.Select a filter that changes the order of the rows.
Actual Results:
Cell values are based on the displayed cell order
Expected Results:
Cell values should be the original values before the auto filter is applied so
that each item number stays the same as before it is filtered.
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.
