Extended Functions

This group is used to download and upload workbooks to the server. It is also possible to insert navigation tags into worksheets.

Insert Function

Inserts a Taurec function in the active worksheet.

There are two types of functions, workspace (WS) and database (DB).

Workspace Functions

Workspace functions are starting with TRC_WS_. TRC means Taurec and WS means workspace. These functions are used to get and set data from a workspace.

• Trc_Ws_GetConsValue
• Trc_Ws_SetConsValue
• Trc_Ws_FilterText
• Trc_Ws_ItemByName
• Trc_Ws_ItemByNumber
• Trc_Ws_ItemCount
• Trc_Ws_TreeItemByName
• Trc_Ws_TreeItemByNumber
• Trc_Ws_TreeItemCount

Database Functions

Database functions are starting with TRC_DB_. TRC meens Taurec and DB meens database. This functions are used to get and set data directly of a database.

• Trc_Db_GetTableValue
• Trc_Db_SetTableValue
• Trc_Db_ItemByName
• Trc_Db_TreeItemByName

Exchange

The extended functions can only be used with the Taurec addin. Sometimes it is necessary to share files with someone who not uses the Taurec addin. Therefore, it is necessary to convert cells with extended functions into values.

Convert Function to Value

Converts cells with extended functions into values.

Different areas can be converted.

Area	Descriptions
All Workbooks	Converts all opened workbooks.
Active Workbook	Converts the active workbook.
Active Sheet	Converts the active sheet.
Active Seelction	Converts the selected cells.

Before convert:

After convert:

Save Function to Formula

When this option is active, the formulas are written into the comment. Later, the comments can be restored back into formulas.

Restore Function from Comment

Restores the formulas from the comment.

Different areas can be restored.

Area	Descriptions
All Workbooks	Restore all opened workbooks.
Active Workbook	Restore the active workbook.
Active Sheet	Restore the active sheet.
Active Seelction	Restore the selected cells.