Command Reference : Working with Tables and Spreadsheets : Customizing Spreadsheet Views
Customizing Spreadsheet Views
Several of the table procs for customizing table display may also be used for customizing spreadsheet views of objects. You may use Series::setformat, Series::setindent, Series::setjust, and Series::setwidth to modify the spreadsheet view of a series. Similar procs are available for other objects with table views (e.g., alpha, group, and matrix objects).
Suppose, for example, that you wish to set the format of the spreadsheet view for series SER1. Then the commands:
ser1.setformat f.5
ser1.setjust right center
ser1.setindent 3
ser1.setwidth 10
sets the spreadsheet display format for SER1 and then displays the view.
Similarly, you may set the characteristics for a matrix object using the commands:
mat1.setformat f.6
mat1.setwidth 8
For group spreadsheet formatting, you must specify a column range specification. For example:
group1.setformat(2) (f.7)
group1.setwidth(2) 10
group1.setindent(b) 6
set the formats for the second series in the group, then displays the spreadsheet view.
group1.setwidth(@all) 10
sets the width for all columns in the group spreadsheet to 10.
Note that the group specified formats are used only to display series in the group and are not exported to the underlying series. Thus, if MYSER is the second series in GROUP1, the spreadsheet view of MYSER will use the original series settings, not those specified using the group procs.