SAP ABAP Class CL_RSR_NET_GRID (Output Table Creation for Excel)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-ET (Application Component) End User Technology
     ⤷ RSR_EXCEL_RUNTIME (Package) Excel Runtime Objects

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_RSR_GRID	Grid	20030328

Properties

Class	CL_RSR_NET_GRID
Short Description	Output Table Creation for Excel
Super Class	CL_RSR_GRID	Grid
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSR_EXCEL_RUNTIME	Excel Runtime Objects
Created	20030328	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	RRX1	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	RS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_RSR_NET_GRID has no interface implemented.

Friends

Class CL_RSR_NET_GRID has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	C_LF	Static Attribute	Private	☐	Type reference (TYPE)	STRING		Line feed	20030328
2	C_LF_QDEF_DEFAULT	Static Attribute	Private	☐	Type reference (TYPE)	STRING		Line feed	20030328
3	C_S_CELLTYPE_ATTR	Static Attribute	Private	☐	Type reference (TYPE)	RSR_XLS_DCELLTYPE	'A'	Cell Type for Attribute Cells	20030331
4	C_S_CELLTYPE_CAPATRKEY	Constant	Private	☐	Type reference (TYPE)	RSR_XLS_DCELLTYPE	'ACK'	Data Cell Type	20040905
5	C_S_CELLTYPE_CAPATRTEXT	Constant	Private	☐	Type reference (TYPE)	RSR_XLS_DCELLTYPE	'ACT'	Data Cell Type	20040905
6	C_S_CELLTYPE_CAPKEY	Constant	Private	☐	Type reference (TYPE)	RSR_XLS_DCELLTYPE	'HK'	Data Cell Type	20040830
7	C_S_CELLTYPE_CAPTEXT	Constant	Private	☐	Type reference (TYPE)	RSR_XLS_DCELLTYPE	'HT'	Data Cell Type	20040830
8	C_S_CELLTYPE_CHARKEY	Constant	Private	☐	Type reference (TYPE)	RSR_XLS_DCELLTYPE	'CK'	Data Cell Type	20040830
9	C_S_CELLTYPE_CHARTEXT	Constant	Private	☐	Type reference (TYPE)	RSR_XLS_DCELLTYPE	'CT'	Data Cell Type	20040830
10	C_S_CELLTYPE_DATA	Static Attribute	Private	☐	Type reference (TYPE)	RSR_XLS_DCELLTYPE	'D'	Cell Type for Data Cells	20030331
11	C_S_CELLTYPE_EMPTY	Constant	Private	☐	Type reference (TYPE)	RSR_XLS_DCELLTYPE	'EMT'	Data Cell Type	20041110
12	C_S_CELLTYPE_ERRO	Static Attribute	Private	☐	Type reference (TYPE)	RSR_XLS_DCELLTYPE	'E'	Cell Type for Error Cells	20030331
13	C_S_CELLTYPE_FORM	Static Attribute	Private	☐	Type reference (TYPE)	RSR_XLS_DCELLTYPE	'F'	Cell Type for Format. Cells	20030331
14	C_S_CELLTYPE_STRU	Static Attribute	Private	☐	Type reference (TYPE)	RSR_XLS_DCELLTYPE	'S'	Cell Type for Structure Cells	20030331
15	C_TEXT_PREFIX	Constant	Public	☐	Type reference (TYPE)	CHAR1	''''	Prefix so that Excel Displays a Line as Text	20030328
16	N_EDITABLE	Instance attribute	Public	☑	Type reference (TYPE)	RRNOINPUT			20031024
17	N_MAX_X	Instance attribute	Public	☑	Type reference (TYPE)	RRX_RANGES-X1		Column coordinate	20030328
18	N_MAX_Y	Instance attribute	Public	☑	Type reference (TYPE)	RRX_RANGES-Y1		Row Coordinates	20030328
19	N_T_GRID	Instance attribute	Public	☑	Type reference (TYPE)	RRX_T_XLS_GRID		Cells	20030328
20	N_T_RANGES	Instance attribute	Public	☑	Type reference (TYPE)	RRX1_T_RANGES		Formats	20030328
21	N_T_SYMBOLS	Instance attribute	Public	☑	Type reference (TYPE)	RSR_XLS_T_SYMBOLS		Symbols	20030328
22	N_T_TEXT	Instance attribute	Public	☑	Type reference (TYPE)	RRX_T_TEXT		Texts / URLs	20030328
23	O_TH_DOC_COORDINATE	Instance attribute	Protected	☐	Type reference (TYPE)	RSR_TH_CELL_COORDINATE		Document Coordinates	20030328
24	P_FORMATTED_VALUES	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL		Display Formatted Values	20030328
25	P_LF_QDEF	Instance attribute	Private	☐	Type reference (TYPE)	STRING		Line Feed Display Of Query Definition	20030328
26	P_MAX_X	Instance attribute	Private	☐	Type reference (TYPE)	I		Maximum Number of Columns	20030328
27	P_NOMULTTXT	Instance attribute	Private	☐	Type reference (TYPE)	RRXNOMULTTXT		Query: Suppression of Repitition Texts	20030328
28	P_NOSTYLES	Instance attribute	Private	☐	Type reference (TYPE)	RRXNOSTYLES		Use Formats	20030328
29	P_NOZERO	Instance attribute	Private	☐	Type reference (TYPE)	RRXNOZERO		Suppress zeros	20030328
30	P_POSITION	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL		KeyFigure axis position	20111121
31	P_R_VIEW	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_RSR_XLS_VIEW		Web Reporting Data Provider Query View	20060324
32	P_SIGNPRSNT	Instance attribute	Private	☐	Type reference (TYPE)	RRXSIGNPRSNT		Display of +/- Signs	20030328
33	P_S_DATA	Instance attribute	Private	☐	Type reference (TYPE)	RRX1_S_DAT_N		Last Data Cell for VB Format Optimization	20030328
34	P_S_RANGE_INT	Instance attribute	Private	☐	Type reference (TYPE)	TP_S_RANGES_INT		Range Optimization	20030328
35	P_S_SESSION_PRPTYS	Static Attribute	Private	☐	Type reference (TYPE)	RRX1_S_SESSION_PRPTYS		Session Settings	20030328
36	P_S_SPECIAL_CELL	Static Attribute	Private	☐	Type reference (TYPE)	TP_S_SPECIAL_CELL			20030328
37	P_TH_CEL_INT	Instance attribute	Private	☐	See coding				20041116
38	P_TH_CHAVL_EXT	Instance attribute	Private	☐	Type reference (TYPE)	T_TH_CHAVL			20060201
39	P_TXTID_COUNTER	Instance attribute	Private	☐	Type reference (TYPE)	I		Counter for Text ID	20030328
40	P_T_RANGE_INT	Instance attribute	Private	☐	Type reference (TYPE)	TP_T_RANGES_INT		Internal Ranges	20030328
41	P_USER_DECIMAL_CHARACTER	Static Attribute	Private	☐	Type reference (TYPE)	CHAR1		Decimal Places in the User Settings	20030328
42	P_VBFORMAT	Instance attribute	Private	☐	Type reference (TYPE)	RRX1_S_RANGES-VBFORMAT		Last VB Format for Optimization	20030328
43	P_ZEROPRSNT	Instance attribute	Private	☐	Type reference (TYPE)	RRX1_ZEROPRSNT		Zero Representation	20030328
44	P_ZEROTEXT	Instance attribute	Private	☐	Type reference (TYPE)	RRX1_ZEROTEXT		Zero Text	20030328

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_RANGE	Instance method	Private	Method	Write Optimized Entry in the Range	20030328
2	APPEND_TEXT	Instance method	Private	Method	Include text	20030328
3	CLASS_CONSTRUCTOR	Static method	Public	Constructor	Class Constructor	20030328
4	CONSTRUCTOR	Instance method	Public	Constructor		20060324
5	FILL_GRID	Instance method	Public	Method	Fill Output Tables	20030328
6	FILL_HASH_CEL_INT	Instance method	Private	Method	Fills the hash table for the cel int	20041116
7	FILL_RANGES	Instance method	Private	Method	Fill Ranges	20030328
8	GET_DATA_CELL_CONTENT	Instance method	Private	Method	Content for Data Cell	20030328
9	GET_DATA_CELL_TEXT	Instance method	Private	Method	Cell Text for Data Cells	20030328
10	IN_EX_CONVERT	Static method	Private	Method	Convert Internal Display into External	20030328
11	LEVEL_MERGE	Instance method	Private	Method	Merge Levels	20030328
12	MERGE_RANGES	Instance method	Private	Method	Merge Ranges	20030328
13	MOST_COMMON_FORMATS	Instance method	Private	Method	Most Frequently Used Formats	20030328
14	NOTIFY_SESSION_SETTINGS	Static method	Public	Method	Excel Session Settings (Date Format, ...)	20030328
15	SET_LIST_PROPERTIES	Instance method	Private	Method	Set Properties of List like 0 Suppression, ...	20030328
16	VBFORMAT_GET	Instance method	Private	Method	VB Format for Data Cell	20030328
17	VBFORMAT_GET_STATIC	Static method	Public	Method	VB Format for Data Cell	20030328

Events

Class CL_RSR_NET_GRID has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TP_S_FORMAT	Private	See coding			20030328	BEGIN OF tp_S_FORMAT, CONTENT TYPE RRX1_S_RANGES-CONTENT, VBFORMAT TYPE RRX1_S_RANGES-VBFORMAT, END OF tp_S_FORMAT
2	TP_S_RANGES_INT	Private	See coding			20030328	BEGIN OF tp_S_RANGES_INT, X1 TYPE RRX1_S_RANGES-X1, Y1 TYPE RRX1_S_RANGES-Y1, X2 TYPE RRX1_S_RANGES-X2, Y2 TYPE RRX1_S_RANGES-Y2, FORMAT TYPE tp_S_FORMAT, LEVEL TYPE I, AREA TYPE I, END OF tp_S_RANGES_INT
3	TP_S_SPECIAL_CELL	Private	See coding			20030328	BEGIN OF tp_s_special_cell, ERROR TYPE RRX1_S_PRPTYS-VALUE, DIFF0 TYPE RRX1_S_PRPTYS-VALUE, NOTEXIST TYPE RRX1_S_PRPTYS-VALUE, MIXCUR TYPE RRX1_S_PRPTYS-VALUE, NO_AUTHorization TYPE RRX1_S_PRPTYS-VALUE, show_mix_cur_val type RRX1_S_PRPTYS-VALUE, END OF tp_s_special_cell
4	TP_T_RANGES_INT	Private	See coding			20030328	tp_T_RANGES_INT TYPE standard table of tp_s_ranges_int

Method Signatures

Method ADD_RANGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_RANGE	Call by reference	☑	Type reference (TYPE)	RRX1_S_RANGES		Range-Eintrag	20030328

Method ADD_RANGE on class CL_RSR_NET_GRID has no exception.

Method APPEND_TEXT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_ID	Value transfer	☐	Type reference (TYPE)	RRX_TXTID		Text-ID	20030328
2	Exporting	E_INDEX	Call by reference	☐	Type reference (TYPE)	RRX_TXTID		Index des Texts	20030328
3	Importing	I_TEXT	Call by reference	☐	Type reference (TYPE)	STRING		Text	20030328

Method APPEND_TEXT on class CL_RSR_NET_GRID has no exception.

Method CLASS_CONSTRUCTOR Signature

Method CLASS_CONSTRUCTOR on class CL_RSR_NET_GRID has no parameter.
Method CLASS_CONSTRUCTOR on class CL_RSR_NET_GRID has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_VIEW	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSR_XLS_VIEW			20060324

Method CONSTRUCTOR on class CL_RSR_NET_GRID has no exception.

Method FILL_GRID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORMATTED_VALUES	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Formatierte Werte anzeigen	20030328
2	Importing	I_FROM_COLUMN	Call by reference	☐	Type reference (TYPE)	I	0	Anfangsspalte (Daten)	20030328
3	Importing	I_FROM_ROW	Call by reference	☐	Type reference (TYPE)	I	0	Anfangszeile (Daten)	20030328
4	Importing	I_MAX_COLS	Call by reference	☐	Type reference (TYPE)	I	0	Maximale Anzahl von Spalten	20030328
5	Importing	I_TO_COLUMN	Call by reference	☐	Type reference (TYPE)	I	0	Endspalte (Daten)	20030328
6	Importing	I_TO_ROW	Call by reference	☐	Type reference (TYPE)	I	0	Endzeile (Daten)	20030328
7	Importing	I_WITH_CAPTION_COLUMNS	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Spaltenüberschriften erzeugen	20030328
8	Importing	I_WITH_CAPTION_ROWS	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Zeilenüberschriften erzeugen	20030328
9	Importing	I_WITH_DATA	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Werte ins Grid füllen	20030328

#	Exception	Resumable	Description	Created on
1	X_MESSAGE	☐	X-Message	20030328

Method FILL_HASH_CEL_INT Signature

Method FILL_HASH_CEL_INT on class CL_RSR_NET_GRID has no parameter.
Method FILL_HASH_CEL_INT on class CL_RSR_NET_GRID has no exception.

Method FILL_RANGES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_AREA_OPTIMIZATION	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Bereiche optimieren (nicht beim Hierarchie-Aufriss)	20030328

#	Exception	Resumable	Description	Created on
1	X_MESSAGE	☐	X-Message	20030328

Method GET_DATA_CELL_CONTENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_DATA	Call by reference	☐	Type reference (TYPE)	RRX1_S_DAT_N		Daten	20030328
2	Returning	R_CONTENT	Value transfer	☐	Type reference (TYPE)	RRX1_S_GRID-CONTENT		Content	20030328

Method GET_DATA_CELL_CONTENT on class CL_RSR_NET_GRID has no exception.

Method GET_DATA_CELL_TEXT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_DATA	Call by reference	☐	Type reference (TYPE)	RRX1_S_DAT_N		Daten	20030328
2	Returning	R_TEXT	Value transfer	☐	Type reference (TYPE)	RRX1_S_GRID-DATA		Text	20030328

#	Exception	Resumable	Description	Created on
1	X_MESSAGE	☐	X-Message	20030328

Method IN_EX_CONVERT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_DATA	Call by reference	☐	Type reference (TYPE)	RRXDATA		Daten	20030328
2	Importing	I_INTTP	Call by reference	☐	Type reference (TYPE)	INTTYPE		Typ	20030328
3	Importing	I_VALUE	Call by reference	☐	Type reference (TYPE)	RSROA_DF		Wert	20030328

#	Exception	Resumable	Description	Created on
1	X_MESSAGE	☐	X-Message	20030328

Method LEVEL_MERGE Signature

Method LEVEL_MERGE on class CL_RSR_NET_GRID has no parameter.
Method LEVEL_MERGE on class CL_RSR_NET_GRID has no exception.

Method MERGE_RANGES Signature

Method MERGE_RANGES on class CL_RSR_NET_GRID has no parameter.
Method MERGE_RANGES on class CL_RSR_NET_GRID has no exception.

Method MOST_COMMON_FORMATS Signature

Method MOST_COMMON_FORMATS on class CL_RSR_NET_GRID has no parameter.
Method MOST_COMMON_FORMATS on class CL_RSR_NET_GRID has no exception.

Method NOTIFY_SESSION_SETTINGS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_SESSION_SETTINGS	Call by reference	☐	Type reference (TYPE)	RRX1_S_SESSION_PRPTYS		Einstellungen (Datumsformat, ...) der Excel Session	20030328

Method NOTIFY_SESSION_SETTINGS on class CL_RSR_NET_GRID has no exception.

Method SET_LIST_PROPERTIES Signature

Method SET_LIST_PROPERTIES on class CL_RSR_NET_GRID has no parameter.
Method SET_LIST_PROPERTIES on class CL_RSR_NET_GRID has no exception.

Method VBFORMAT_GET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_DATA	Call by reference	☐	Type reference (TYPE)	RRX1_S_DAT_N		Daten	20030328
2	Returning	R_VBFORMAT	Value transfer	☐	Type reference (TYPE)	RRX1_S_RANGES-VBFORMAT		VB-Format	20030328

Method VBFORMAT_GET on class CL_RSR_NET_GRID has no exception.

Method VBFORMAT_GET_STATIC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_REQUEST	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSR_REQUEST		Datenanforderung vom OLAP-Prozessor	20030328
2	Importing	I_SIGNPRSNT	Call by reference	☐	Type reference (TYPE)	RRXSIGNPRSNT	RRX1_C_SIGNPRSNT-BEFORE	Vorzeichendarstellung	20030328
3	Importing	I_S_DATA	Call by reference	☐	Type reference (TYPE)	RRX1_S_DAT_N		Daten	20030328
4	Importing	I_ZEROPRSNT	Call by reference	☐	Type reference (TYPE)	RRX1_ZEROPRSNT	RRX1_C_ZEROPRSNT-DISPLAY	Nulldarstellung	20030328
5	Returning	R_VBFORMAT	Value transfer	☐	Type reference (TYPE)	RRX1_S_RANGES-VBFORMAT		VB-Format	20030328

Method VBFORMAT_GET_STATIC on class CL_RSR_NET_GRID has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	400