Issue 118434

Summary: DataPilot shows wrong date on Row field
Product: Calc Reporter: davidjorjani
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: elish, issues, oooforum
Version: version58   
Target Milestone: ---   
Hardware: PC   
OS: Windows, all   
Issue Type: DEFECT Latest Confirmation in: 4.1.3
Developer Difficulty: ---
Description Flags
Sample file showing the bug none

Description davidjorjani 2011-08-27 19:56:53 UTC
The DataPilot sheet is showing the same year for items from multiple years.

I created a spreadsheet to track purchases made. My source data includes a column for the date, vendor name, and amount of each purchase. I also created a year column with a formula to grab the year from the date column because I wanted to use the year as my page field in the DataPilot sheet.

Depending on the formatting of the date category in my source data, the DataPilot sheet displays different values for the date of each purchase.

In the attached file, on the "A - Source" sheet, the first column shows the month and day but does not show the year. The year is there, but I have chosen not to show it here because I have a year column and it would look silly with the year listed twice. However, on the "A - DataPilot" sheet, you will notice that the dates for the purchases from Vendor A all show 2011, even though the DataPilot is correctly organizing these as 2009 purchases.

On the "B - Source" sheet, the first column shows the day, month, and year, and then the year column shows the year again. This time, the "B - DataPilot" sheet shows the correct year of each purchase from Vendor A.

Build 2011-08-27 on Windows Vista
Comment 1 davidjorjani 2011-08-27 19:58:03 UTC
Created attachment 76773 [details]
Sample file showing the bug
Comment 2 Oliver-Rainer Wittmann 2012-06-13 12:16:56 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 3 Edwin Sharp 2013-09-21 18:33:24 UTC
As given in description.

Rev. 1523756 Win 7