| Docs Help
  AppSource  
Print this pageEntire manual (printable version)
Docs  /  Excel Report Builder  /  Setup

 Excel Functions


2024/01/01 • 2 min. to read
In the Excel Functions Setup page the Excel Functions are set up, which can then be selected in the Formulas of the Excel Evaluations. The page can be opened in the Excel Report Builder Setup via the corresponding action in the Setup group. For more information, see Setup, Excel Report Builder Setup. Via the Download action the setup can be created or updated quickly and easily.

Note

Note that in evaluations the English Excel Function names, commas instead of semicolons and dots as decimal separators must be used. This makes the data independent of the visualization and therefore also independent of language, region and country settings. When a user opens the workbook, the data is automatically displayed in the format he or she has set. The help provided by Microsoft for each function as well as an overview of all functions can be displayed or opened in English and in your display language.

Fields
NameSpecifies the name of the function.
DescriptionSpecifies information about the function.
CategorySpecifies to which category the function belongs.
IDSpecifies the ID assigned to the function by Microsoft. Only if the correct ID is specified, the help for the function can be called.
Language related name fieldsSpecifies the name of the function in the respective language. These fields are displayed when selecting an Excel Function depending on the display language to make it easier to search for a function or the English Excel Function name. When setting up the formula of an evaluation, an action for translating the Excel Functions from another language is also available. The action uses the language related name fields for the translation.

Actions

  • Download

    Via this action the Excel Functions can be downloaded and thus the setup can be created or updated quickly and easily.

  • Import / Export

    Via Import and Export the Excel Functions can be imported from a file or exported to a file.

  • Help

    Opens an external website that displays detailed information about the function in English.

  • Help (Translated)

    Opens an external website that displays detailed information about the function in your display language.

  • Function Overview

    Opens an external website that displays all functions in alphabetical order in English.

  • Function Overview (Translated)

    Opens an external website that displays all functions in alphabetical order in your display language.

See also



Submit feedback for
DE|EN Imprint
◀☰▶
△