Apache OpenOffice (AOO) Bugzilla – Issue 68203
GETPIVOTDATA does not handle empty argument when import excel file
Last modified: 2006-08-07 13:25:53 UTC
An excel file w/ GETPIVOTDATA("Importe";$B$64;"Parte";;"Tipo Aplicación";"A") is translated w/o the 4th argument and OOcalc fail to evaluate correct translation GETPIVOTDATA("Importe";$B$64;"Parte";"";"Tipo Aplicación";"A")
I don't see this as a defect. In Calc empty parameters within the parameter list of functions aren't allowed at all. This feature is handled in http://www.openoffice.org/issues/show_bug.cgi?id=3879 On the other hand the GETPIVOTDATA() function isn't implemented. Resolving this issue as duplicate. *** This issue has been marked as a duplicate of 3879 ***
and closing issue...