Bug 695318

Summary:	Pivot table created with excel shows different values in Calc
Product:	[Fedora] Fedora	Reporter:	japa-fi <cn6uw7d02>
Component:	openoffice.org	Assignee:	Eike Rathke <erack>
Status:	CLOSED INSUFFICIENT_DATA	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	14	CC:	caolanm, cn6uw7d02
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2011-10-21 14:13:13 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description japa-fi 2011-04-11 11:38:27 UTC

Description of problem:
Complicated excel sheet with lots of data. A pivot table created with Excel, the output (sum figures etc) from the pivot are displayed as they left excel.
If one "refresh" the pilot table, totally different figures are shown.
If one has "getpivotdata" function referring to the pivot, one gets the recalculated values, not the ones visible on the sheet (though this is not a bug, just adding to confusion).

Example:
Pivot calculated by excel shows total sum of 10 000. 
When doing refresh with Oo, the sum changes to something else (say for example 9000).
Even without doing refresh, "getpivotdata" function referring to that pivot will return 9000.
Above numbers are arbitary, picked for illustration purposes only.


Version-Release number of selected component (if applicable):
openoffice.org-calc-3.3.0-20.2.fc14.x86_64
and 
openoffice.org-calc-3.3.0-20.5.fc14.i686

File created with Ms Excel 2003 (11.8324.8324) sp3


How reproducible:
Always

Steps to Reproduce:
1.
2.
3.
  
Actual results:


Expected results:


Additional info:

Comment 1 japa-fi 2011-04-12 08:31:50 UTC

Creating a separate OpenOffice datapivot with same fields and selection criteria as the excel pivot results to correct figures. 

Still working on data obfuscation to be able to submit a sample file.

So as summary:
-Open excel file with Pivot in it. Pivot total shows 10000.
- Press Refresh (or use getpivotdata), pivot total updates to incorrect result (eg 9000)
- Create Oo Datapilot over the same data, same selection and grouping criteria as with the Pivot -> datapilot shows correct result (eg 10000)


Ps. I would rate this bug as critical: spreadsheet calculating incorrectly is not a nice thing.

Comment 2 Caolan McNamara 2011-10-21 14:05:47 UTC

caolanm->erathke: This problem ring any bells with you ?, there's no example attached unfortunately

Comment 3 Caolan McNamara 2011-10-21 14:13:13 UTC

feel free to reopen this bug if you can attach something we can reproduce this with