Issue 62491 - data pilot mis-groups data with page fields
Summary: data pilot mis-groups data with page fields
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 680m156
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-02-23 17:44 UTC by jodygoldberg
Modified: 2013-07-30 02:17 UTC (History)
2 users (show)

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

Attachments
sample file that loses pivot data on refresh (13.00 KB, application/vnd.ms-excel)
2006-02-23 17:45 UTC, jodygoldberg 		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 jodygoldberg 2006-02-23 17:44:50 UTC 
Refreshing the attached xls clears the displayed data.
Comment 1 jodygoldberg 2006-02-23 17:45:32 UTC 
Created attachment 34415 [details]
sample file that loses pivot data on refresh
Comment 2 frank 2006-03-08 14:31:48 UTC 
Hi,

doesn't seem to be a bug as Excel act's in the same way.

Frank
Comment 3 frank 2006-03-08 14:32:01 UTC 
closed invalid
Comment 4 jodygoldberg 2006-03-09 04:14:54 UTC 
We're clearly looking at different versions of XL.
Office XP is what created that file and it does not lose the content on refresh.

What version of XL are you testing with and what does it do for you ?
Comment 5 frank 2006-03-09 13:05:35 UTC 
used Excel 2003 and 2000 both does exactly the same as Calc. It depends on the
column E. It is named data on the source sheet but data2 in the pivot table.

Frank
Comment 6 frank 2006-03-09 13:05:51 UTC 
closed invalid
Comment 7 jodygoldberg 2006-03-09 16:04:55 UTC 
There is clearly more going on here than meets the eye.
I've just replicated this test using Office 2k, XP, and 2003 and all 3 are able
to display the content of the sheet on refresh.  It's unclear (at least to me)
when XL starts numbering fields internally.

Please stop closing this report.  I'm working on fixing it and need a place
holder for the eventual patch.
Comment 8 frank 2006-03-10 08:40:07 UTC 
So you've requested it, you get it.
Comment 9 Rob Weir 2013-07-30 02:17:05 UTC 
Reset assignee on issues not touched by assignee in more than 2000 days.