Excel Formula


Excel Formula is a direct subtype of Data
aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa aaaaaaaa
with functions Excel Formula Functions, keys Excel Formula keys and example object ExForm

TYPE INCLUSION RELATIONSHIPS

Data

Excel Formula

</defs>

AVAILABLE FUNCTIONS

Build Extra Data

Build Price Info

Create

</defs>

AVAILABLE CREATE FUNCTION KEYS

Comment

Input Ranges

</defs>

TYPICAL OBJECTS OF TYPE Excel Formula

ExForm

</defs>

This type represents a pair consisting of an object of type Excel Ranges and a piece of text that serves as an explaining comment to the Excel Ranges object.
In effect it represents the input ranges to any spreadsheet-based Deriscope formula as well as an Excel comment associated with that formula.
It is very simple to create and export an object of type Excel Formula using the Deriscope wizard:
You only need to select the cell containing the Deriscope formula that you want to export and then click on Go -> Export Excel Formula to Text File
If an Excel Comment is already inserted in the selected cell then the exported Excel Formula object will include that comment as well.

The so produced Excel Formula object can be then used to recreate the Excel formula in spreadsheet simply by clicking on Go -> Load Excel Formula from Text File or one of its variations.