[Libreoffice-bugs] [Bug 112893] New: Pivot table: filtering of error item is not imported from XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: zolnaitamas2000 at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171005/3a4cc5e2/attachment.html>