Issue 118434 - DataPilot shows wrong date on Row field
Summary: DataPilot shows wrong date on Row field
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: version58
Hardware: PC Windows, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-08-27 19:56 UTC by davidjorjani
Modified: 2017-05-12 12:10 UTC (History)
3 users (show)

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

Sample file showing the bug (30.37 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-08-27 19:58 UTC, davidjorjani
no flags Details

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