Issue 120779 - [From Symphony]open .xlsx file, the item filter setting will be lost in Pivot table, if the items are in date format.
Summary: [From Symphony]open .xlsx file, the item filter setting will be lost in Pivot...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.0.0-dev
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-31 08:25 UTC by Shan Zhu
Modified: 2012-08-31 08:28 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
.xlsx sample file, Pivot table has items in Date format (13.40 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-08-31 08:25 UTC, Shan Zhu 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.