Options Spreadsheet

Last modified: Feb 25, 2019
More about Features

This spreadsheet will be populated when a feature is selected in either the Features spreadsheet or the Feature View. The following is a summary of the columns in the Options Spreadsheet and how they are used to work with options. For more information on working with spreadsheets, see the Spreadsheets page, and for general information on options see the Options page.


Every option requires an identi er that is unique to the feature that owns it. This is the code by which the option is referenced by the feature. New options can be created by entering a code into an empty cell. And likewise, deleting a code from this column will remove an option from the feature. In order to maintain the uniqueness of the option codes, any time the user enters a code that is not unique, the creator will add characters to make the code unique, before submitting the change to the catalogue. Any leading/trailing spaces will be highlighted in yellow to prevent unwanted space.

It is possible to re-sequence options code by right clicking on the code header -> reorder ascending or reorder descending. Note that once you reordered the option code sequence of a published catalogue, loading old drawing will have issue, use with caution.


Code Range Min.

Forming the minimum of an option dimension range.

Code Range Max.

Forming the maximum of an option dimension range.

Code Range Inc.

The increment step of the option dimension range.


These columns allow for human-readable descriptions of the option. Note that there will be a Description column for every language that is enabled in the catalogue. This is the text that will be used to describe the option when the feature is presented to a user.


These columns are used to set the upcharge or discount on an option. Note that there will be a Price column for every base price list in the catalogue. This value will be used in calculating a product’s final price, when the option is selected.

Price Codes

These columns are used to set option price codes for the option. Note that there will be a Price Codes column for every base pricelist in the catalogue. This is how a product will reference the option to set it’s option price.
To set price codes, click the button on the right side of the cell. A small popup will appear with a text field, and a list of existing option price codes. To enter a new option price code, type the code into the text field, and press the Enter key. To enable or disable option price codes, select them in the list. Option price codes on the option will have a check mark next their code in the list.

Leadtime Program

This column is used to set the leadtime program for an option. To assign a program, click the button on the right side of the cell. A popup will appear with a list of all leadtime programs on the catalogue. Select a program from the list to assign it to the option. To remove a program from an option, either select “<None>” from the popup list, or select the cell and press Delete. For more information on leadtime programs, see the Leadtime Programs page.

SKU Selection

This column is used to set the SKU selection flag on the option. The flag can be set and unset by selecting the check box in the field. Note that if the feature that owns the option has the SKU selection flag set, it will override this setting.


This column is used to mark the option as an undefined option. It can be set and reset in the same manner as the SKU selection field.

Material Applications

This column is a reference column and is used to indicate the surface id(s) and material(s) linked to the option.


This column is a reference column and is used to indicate the symbol(s) linked to the option.


This column is used to set sub features on the option. Click the button on the right side of the cell to display a popup listing all available features on the catalogue. Note that if the current catalog is set to use vendors, this list will be filtered to only include features on the same vendor as the feature that owns the option. Also, features that could create a feature loop will be filtered from this list.
To add or remove a sub feature from the option, select or deselect it from the popup list. To further filter the list of features, enter text into the field at the top of the popup. Only features with a code that contain the typed text will be displayed.

External Reference Keys

This column is is a reference column and is used to indicate the external reference keys of an option. The external reference key is used to match the key from one option to that of a external reference, meaning the external reference only shows up when the option with matching key is selected.

Leave a Reply