Issue 89867

Summary: PROBLEM IMPORTING FUNCTION GETPIVOTDATA FROM EXCEL
Product: Calc Reporter: danros66 <rossetti.danilo>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, rb.henschel
Version: OOo 3.0Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
example of conversion error none

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.