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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
