Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|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-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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.