Issue 68203 - GETPIVOTDATA does not handle empty argument when import excel file
Summary: GETPIVOTDATA does not handle empty argument when import excel file
Status: CLOSED DUPLICATE of issue 3879
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-08-07 00:44 UTC by mrsoto
Modified: 2006-08-07 13:25 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description mrsoto 2006-08-07 00:44:38 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")
Comment 1 Joost Andrae 2006-08-07 13:25:30 UTC
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 ***
Comment 2 Joost Andrae 2006-08-07 13:25:53 UTC
and closing issue...