Excel Client:Constants and Return Values

When a formula contains an errors (incorrect parameters or syntax, etc.) or when a problem occurs during processing or evaluating a report created in Microsoft Excel, the functions integrated in the CoPlanner Excel Client will return constants that can be helpful for correcting the error.

The following table contains a list of the constants integrated in the CoPlanner Excel Client.

Constant	Significance
N/A	Stands for “Not available”. May be found in the Login data of the Info dialogue. This constant is returned when there is no connection to the CoPlanner server.
N/P	Stands for “Not possible”. When it is not possible to write to the database based on a CellRead formula, this constant is returned to inform the user that the values that were entered have not been written into the database.
N/C	Stands for “Not connected”. This constant is returned by CellRead formulas when F9 (Refresh) was pressed while there is no connection (no login) to the CoPlanner server.
NaN	Stands for “Number not available”. This is returned every time F9 is pressed to refresh CellRead formulas in the first step. If this constant remains in a cell after the formula was refreshed, an error has occurred that prevented the value from being loaded from the CoPlanner server.
C.n.F.	Stands for “Cube not found”. This is returned by CellRead functions when the specified object (parameter 2) is not present in the model.
M.n.F.	Stands for “Measure not found”. This is returned by CellRead functions when the specified measure (parameter 2) is not present in the model.
D.n.F.	Stands for “Dimension not found”. This is returned by CellRead functions when the specified dimension (one of the slicers) is not present in the model or when there is no link to the selected object (parameter 1).
P.n.F.	Stands for “Plan not found”. This is returned by CellRead functions when the specified plan (an element of one of the slicers) is not present. Example: CellRead(…;”Plan:=ABC”;…). The same constant is returned by the ElemSelect function to notify the user that the selected plan is not present.
A.n.F.	Stands for “Attribute not found”. This constant is returned by the function ElemAttribut when the desired attribute is not present in the dimension. Example: ElemAttribut(“Produkte”;“Rennräder”;“Motorisierungsdetails”).
F.n.F.	Stands for “Filter not found”. This is returned by the CellRead function when a filter is specified that is not valid for the object. Example: CellRead(“Umsatzerloese”;“Umsatz”;“BAB-Struktur:=BAB-Struktur”;.)
E.n.F.	Stands for “Element not found”. This constant is returned by CellRead functions when the specified dimension element (an element of one of the slicers) is not an element of the dimension. Example: CellRead(…;”Zeit:=Aktivseite”;…).