More Settings

You can find the following setting options in the Settings section in the Spreadic UI menu.

Add-on Interface Settings

The options below control how you interact with the Spreadic UI.

Pick Column by Typing

Switching this on allows you to choose a column by directly typing out the column name instead of scrolling through the dropdown menu.

Use Label in Add-on

This option controls whether the model / column names shown in the UI are in their original format (i.e. as in a SQL query) or displayed as a more readable label pre-defined by your admin / support team.

Allow SQL Retrieval

If you are familiar with SQL and want to retrieve the original SQL query behind the Spreadic function, you can switch this option on and a RETRIEVE SQL button will become available next to the FETCH DATA button. Hitting that button will generate the SQL query in the cell that you pick.

Include Set

A set is a named collection of columns pre-defined by your admin so that you don't have to select them one by one. Including sets in the dropdown menu allows you to choose such predefined sets directly.

Labels and sets are examples of elements that are very customisable in Spreadic via the use of YAML files. See the link below for a quick reference of how they interact with Spreadic.

Spreadic Semantic YAML References

Output Data Settings

The options below allow you to change the format of the data retrieved by Spreadic.

Show Label in Result

Similar to the use of labels in the UI, this option controls the name format of the rows / columns shown in the table of data loaded into your spreadsheet.

Show Grand Total in Pivot

Switching this on will show the Grand Total row and column in the data generated in Pivot Data mode.

Other Settings

Reset All Settings to Default

This resets all the above settings to their default option.

Clear Internal Cache

Clearing internal cache may be useful in troubleshooting certain errors.