Issue 89867 - PROBLEM IMPORTING FUNCTION GETPIVOTDATA FROM EXCEL
Summary: PROBLEM IMPORTING FUNCTION GETPIVOTDATA FROM EXCEL
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2008-05-23 17:20 UTC by danros66
Modified: 2013-01-29 21:51 UTC (History)
2 users (show)

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


Attachments
example of conversion error (17.50 KB, application/vnd.ms-excel)
2008-05-23 17:22 UTC, danros66
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description danros66 2008-05-23 17:20:42 UTC
When in pivot table a item in a field is empty, if is present a pivot function
that takes a value insite pivot, the conversion of this function isn't correct.
The syntax for this Excel function is (italian version):			
=INFO.DATI.TAB.PIVOT("AMOUNT";$G$1;"OFFICE";"B";"YEAR";2006;"VOICE";)
it is converted as:
=GETPIVOTDATA("AMOUNT";$G$1;"OFFICE";"B";"YEAR";2006;"VOICE")

The conversion should put "" (2 contiguous quotes) to indicate empty value 
because CALC function use this method to rappresent it.

For example I write the correct conversion that CALC should do:
						
=GETPIVOTDATA("AMOUNT";$G$1;"OFFICE";"B";"YEAR";2006;"VOICE";"")
Comment 1 danros66 2008-05-23 17:22:09 UTC
Created attachment 53891 [details]
example of conversion error
Comment 2 Regina Henschel 2008-10-15 22:06:10 UTC
I can reproduce it as described.