Difference between revisions of "Settings File Customisation"
(Created page with "XLCubed Excel Edition keeps all of its settings in a configuration file stored in the user's Application Data folder. This can be found here: %appdata%\XLCubed Ltd\XLCubed Ex...") |
(→Admin controlled) |
||
(10 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | + | FluenceXL Excel Edition keeps all of its settings in a configuration file stored in the user's Application Data folder. This can be found here: | |
%appdata%\XLCubed Ltd\XLCubed Excel Edition\settings.xml | %appdata%\XLCubed Ltd\XLCubed Excel Edition\settings.xml | ||
Line 5: | Line 5: | ||
C:\Users\USERNAME\AppData\Roaming\XLCubed Ltd\XLCubed Excel Edition\settings.xml | C:\Users\USERNAME\AppData\Roaming\XLCubed Ltd\XLCubed Excel Edition\settings.xml | ||
− | In order to customise the file for distribution to other users, you can open the | + | In order to customise the file for distribution to other users, you can open the FluenceXL add-in in Excel and change any settings that you desire, for example: |
* Grid defaults | * Grid defaults | ||
* Connections | * Connections | ||
* Favourite Grids | * Favourite Grids | ||
− | * | + | * FluenceXL Web server addresses |
− | * [[ | + | * [[FluenceXL Options]] |
When you close Excel, the file will be updated, and can then be sent to other users, or including in a custom installation script. | When you close Excel, the file will be updated, and can then be sent to other users, or including in a custom installation script. | ||
+ | |||
+ | =Admin controlled= | ||
+ | |||
+ | From Version 10.0.149 there are two additional files that can be added to the installation folder as part of a scripted corporate deployment. | ||
+ | |||
+ | For FluenceXL: C:\Program Files (x86)\Fluence Technologies Inc\FluenceXL | ||
+ | |||
+ | For AnaplanXL: C:\Program Files (x86)\Anaplan\Anaplan XL Reporting | ||
+ | |||
+ | * defaults.xml - will setup the default settings, the user can override them | ||
+ | * settings.xml - will force these settings, users can not change them | ||
+ | |||
+ | The format of the file is the same as the %appdata% version, you only need to include the settings you want to change/set. This is particularly important for the forced settings; only include those settings that you want to force onto the users. | ||
+ | |||
+ | |||
==See Also== | ==See Also== | ||
− | * [[ | + | * [[FluenceXL Silent Installation]] |
− | * [[ | + | * [[FluenceXL MSI Installation]] |
[[Category: Installation]] | [[Category: Installation]] |
Latest revision as of 18:52, 21 November 2024
FluenceXL Excel Edition keeps all of its settings in a configuration file stored in the user's Application Data folder. This can be found here:
%appdata%\XLCubed Ltd\XLCubed Excel Edition\settings.xml
For a typical Windows installation, this will translate to:
C:\Users\USERNAME\AppData\Roaming\XLCubed Ltd\XLCubed Excel Edition\settings.xml
In order to customise the file for distribution to other users, you can open the FluenceXL add-in in Excel and change any settings that you desire, for example:
- Grid defaults
- Connections
- Favourite Grids
- FluenceXL Web server addresses
- FluenceXL Options
When you close Excel, the file will be updated, and can then be sent to other users, or including in a custom installation script.
Admin controlled
From Version 10.0.149 there are two additional files that can be added to the installation folder as part of a scripted corporate deployment.
For FluenceXL: C:\Program Files (x86)\Fluence Technologies Inc\FluenceXL
For AnaplanXL: C:\Program Files (x86)\Anaplan\Anaplan XL Reporting
- defaults.xml - will setup the default settings, the user can override them
- settings.xml - will force these settings, users can not change them
The format of the file is the same as the %appdata% version, you only need to include the settings you want to change/set. This is particularly important for the forced settings; only include those settings that you want to force onto the users.