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: ---
Attachments:
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

Steps:
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)

Issue:
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.