You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/08/31 10:25:01 UTC

[Bug 120779] New: [From Symphony]open .xlsx file, the item filter setting will be lost in Pivot table, if the items are in date format.

https://issues.apache.org/ooo/show_bug.cgi?id=120779

          Priority: P3
            Bug ID: 120779
          Assignee: ooo-issues@incubator.apache.org
           Summary: [From Symphony]open .xlsx file, the item filter
                    setting will be lost in Pivot table, if the items are
                    in date format.
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: shanzhu33@gmail.com
          Hardware: All
            Status: CONFIRMED
           Version: AOO350-dev
         Component: open-import
           Product: spreadsheet

Created attachment 79265
  --> https://issues.apache.org/ooo/attachment.cgi?id=79265&action=edit
.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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120779] [From Symphony]open .xlsx file, the item filter setting will be lost in Pivot table, if the items are in date format.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120779

bjcheny <co...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |companycy@gmail.com

--- Comment #1 from bjcheny <co...@gmail.com> ---
The root cause is when the data is date, the filter can't pass correct string
over.
Working a solution.

-- 
You are receiving this mail because:
You are the assignee for the bug.