Show TOC

Function documentationGetOnly Range Locate this document in the navigation structure

 

You define a GetOnly range when you want a group of values in an input schedule to only retrieve (not send) values. The cells are designated as read-only.

Features

Use the GetOnly range only in an input schedule. When the workbook is defined as an input schedule in your workbook options, EvDRE assumes its data range to be a send range. Thus, all cells within this range are read-write cells.

Note Note

EvDRE sends only cells in the send range that have changed value since the last refresh action. This includes values calculated by Excel formulas, allowing the users to define Excel-based logic calculations. The values are sent up to the last decimal place, even if a rounding format is applied. Text values are not sent.

End of the note.

A GetOnly range gives the specified cells the ability to only retrieve data. When the workbook is defined as a report in your workbook options, EvDRE assumes its data range to be a get range, and all cells within this range are read-only cells. Thus, the system ignores the GetOnly range.

Activities

To define a GetOnly range, from Interface for Excel, open the EvDRE report or input schedule you are building. In the GetOnlyRange row of the Key range parameter table, enter a range of cells in which you want to allow only retrievals.

Note Note

You can send cells with zero values in the following ways:

  • Enter zero (0) and then send the cells.

  • Erase the values in the cells and then send the cells.

End of the note.