Issue 120779

Summary: [From Symphony]open .xlsx file, the item filter setting will be lost in Pivot table, if the items are in date format.
Product: Calc Reporter: Shan Zhu <shanzhu33>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: companycy
Version: 4.0.0-dev   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
.xlsx sample file, Pivot table has items in Date format none

Description Shan Zhu 2012-08-31 08:25:01 UTC
Created attachment 79265 [details]
.xlsx sample file, Pivot table has items in Date format

Build info: AOO350m1 build9610

1. Open the .xlsx sample filt attached.
(In this sample file, there is a Pivot table, the items of field "Date" in column area are filtered via the multiple selection panel, items are in date format)

The filter on the Date field will be lost.

PS: If the items in this field are numbers/text, it does not have this problem.
Comment 1 bjcheny 2012-08-31 08:28:57 UTC
The root cause is when the data is date, the filter can't pass correct string over.
Working a solution.