[Libreoffice-bugs] [Bug 112337] New: Pivot table: empty / blank item is not imported from XLS

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112337

            Bug ID: 112337
           Summary: Pivot table: empty / blank item is not imported from
                    XLS
           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:
Both in MSO and LO pivot table fields can have empty items which means the
source range has an empty cell for one of the source columns. In MSO it's
identified ba the name "(blank)", while LO it is called "(empty)". If I save a
pivot table with an empty field item into an XLS file in Excel, it is not
imported to Calc

Steps to Reproduce:
1. Open attached file
2. Check the row field's member (open the popup button on cell A4)

Actual Results:  
Empty item is missing

Expected Results:
Empty item 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/60.0.3112.113 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/20170911/10e448af/attachment.html>