Apache OpenOffice (AOO) Bugzilla – Issue 89867
PROBLEM IMPORTING FUNCTION GETPIVOTDATA FROM EXCEL
Last modified: 2013-01-29 21:51:19 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";"")
Created attachment 53891 [details] example of conversion error
I can reproduce it as described.