Spreadsheet objects are used to retrieve data from the database and store it in a spreadsheet file.
When a spreadsheet is run from the browser, depending on the browser and the operating system, the spreadsheet can open in the browser or can launch an outside helper application, such as Microsoft Excel, in which to display the spreadsheet. For example, some versions of Microsoft Internet Explorer on Microsoft Windows may open the spreadsheet in the browser, however, it is likely that newer versions will open in Microsoft Excel (as this is a security patch from Microsoft).
Modifying Blocks on Spreadsheets
Spreadsheet Generation for Query Results
In the Explorer Tree, expand and select the Group Information object in which you wish to create a spreadsheet.
There are options in creating a spreadsheet at this point.
Right-click on the Group to which you wish to add a spreadsheet, hold your cursor over the Create option, and when the sub-menu is displayed, left-click on the Entity option.
Left-click on the [Wizard] 
button in the Main Toolbar.
Left-click on the File Menu. Left-click on the New option. Left-click on the Wizard option.
Press Alt+W on the keyboard.
The Creating an Entity screen will be displayed.
Select the Spreadsheet entity type by left-clicking on the Spreadsheet radio button.
Click on the Next button on the bottom right of the screen.
In the Entity Name field, enter the desired name for the spreadsheet.
In the Datasource pop-list, select
the desired datasource or (use default).
Selecting (use default) will allow the spreadsheet to be used with
any datasource, and data brought in will be determined by the user's datasource.
In the Based On pop-list,select the template on which the new spreadsheet will be based. Any mutable blocks assigned to the spreadsheet selected will be copied to the new spreadsheet.
In the Default Mode pop-list, select the view type that will be displayed by default for this spreadsheet. Choices include Run Report and Parameter Form.
Click on the Next button on the bottom right of the screen.
The Adding New Block screen will be displayed.
See the Adding Blocks to Spreadsheets section for the next steps.
In the Explorer Tree, expand the Group Information object and select the spreadsheet that you wish to modify.
Display the spreadsheet properties.
These will either be displayed in Alphabetical
or Logically, depending on the setting of the [Sort Alphabetically/Logically]
button. The following instructions are assuming
that the properties are sorted logically.
In the Name property, the name that you entered when creating the spreadsheet will be displayed. It can be changed, if desired.
In the Description property, enter a user-defined description for this spreadsheet . The default is the type of object followed by the template name. (i.e. Spreadsheet:NEW)
In the Datasource pop-list, the
datasource that you selected when creating the spreadsheet will be displayed.
It can be changed, if desired.
If set to (default), the default for the user's log in will be used
when this spreadsheet is displayed.
In the Allow Anonymous pop-list, select true if anonymous users should have access to this spreadsheet . Select false if anonymous users should not have access to this spreadsheet.
The Inherits From pop-list displays the template from which this spreadsheet was created, grayed out. This value cannot be changed here.
In the Default Mode pop-list, select the view type that will be displayed by default for this spreadsheet. Choices include Run Report and Parameter Form.
In the Parameter Screen Width property, enter the width in pixels for the parameter form created for this spreadsheet.
In the Parameter Screen Height property, enter the height in pixels for the parameter form created for this spreadsheet.
In the Required Roles property,
select the roles that are required to run the entity. When
running this entity, the user must have at least one of the roles entered
here, or the entity will not run, and the user will be returned to the
log in screen.
When you click on this field, a pop-up will be displayed with the available
roles in the left side of the pop-up and the roles assigned to the entity
on the right side.
To assign a role to the entity, select the desired role on the left
side, and then click on the >> button to move it to the right side.
To unassign a role, select the desired role on the right side and then
click on the << button to move it to the left side.
When all desired roles have been assigned, click on the Apply button.
The Invalid Access Redirects To property will be displayed to allow
you to define the entity that should be displayed for the user if the
user does not have one of the required roles entered here.
In the Required Globals property,
list the global variables that are required to be set in order for the
entity to run properly, separated by a line break. If
the entity is run, and some or all of these globals are missing, the entity
will not be run. The format is GLOBAL or, if desired,
GLOBAL = VALUE.
For example, if the global variables ORG_UNIT_ID and EMPNO must be
set for the page to run correctly, you would enter
ORG_UNIT_ID
EMPNO
If the global variable ORG_UNIT_ID needed to have the value 100, but
it didn't matter what the EMPNO value needed to be, you would enter
ORG_UNIT_ID = 100
EMPNO
In the Accessed via property, enter the entity from which this spreadsheet is generated. This is an optional property. For example, if the spreadsheet has certain conditions that must be met on a screen entity before it can be run, the name of the spreadsheet entity should be entered here. This prevents the spreadsheet from being improperly accessed.
In the Invalid Access Redirects
To property, enter the entity to which the user will be redirected if
this spreadsheet is improperly accessed. This property
is only displayed when the Accessed via property or Required Roles property
is entered.
If a user accesses this spreadsheet from an entity other than the one
entered in the Accessed via property, instead of opening the spreadsheet,
the entity entered in this property will be opened.
If a user that does not have one of the required roles accesses the
entity, instead of opening the spreadsheet, the entity defined here is
opened.
In the Results Disposition property, only Return to Caller can be selected.
The Created on property displays the date and time on which the spreadsheet was created and cannot be changed.
The Modified on property displays the date and time on which the spreadsheet was last changed and cannot be modified.
When all changes have been made,
press the [Save] 
button in the Main Toolbar.
Xephr is a registered trademark of NDS Systems, LC.
Microsoft Internet Explorer, Microsoft Windows, and Microsoft Excel are registered trademarks of Microsoft Corporation.
Copyright