https://bugs.documentfoundation.org/show_bug.cgi?id=112893
Bug ID: 112893
Summary: Pivot table: filtering of error item is not imported
from XLSX
Product: LibreOffice
Version: 6.0.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
A pivot field items can be calculated values (e.g. formulas) and as such it can
be an errornous formula (e.g. div by zero). This error values are displayed as
error strings in the pivot table. In the attached test document the row field
("b") is filtered on the "#DIV/0!" item, but LO Calc does not import this
filtering.
Steps to Reproduce:
1. Open attached test document in Calc
2. Check the row field ("b") items, "#DIV/0!" should be hidden (filtered out)
Actual Results:
Filtering is not imported.
Expected Results:
Filtering should be imported.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/61.0.3163.100 Safari/537.36
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
