Note: This feature is only available for server and private cloud licenses.

The SpreadsheetWEB Control Panel comes with English language support and Pagos branding. However, you can edit the language files on your server installation to customize the text fields displayed throughout the Control Panel. This means that you can configure the system labels on a user or global-level, for the purpose of localization, re-branding, or re-wording any fields as you would like.

By default, the available language files can be found under the C:\PSWTemp\LanguageFiles directory on the server. We recommend creating a copy of the main language file (language.english.json) and applying any changes to the copy since the original file will reset to the default values when you receive a software update.

Open the copy of the language.english.json file with your favorite text editor (we recommend using Notepad++). Change the language code inside the JSON file however you’d like. Note that you should only change the parameters next to the “Value” fields. You must also change the “Code” parameter to something other than “en”.

For example, the first row could be “Code”: “de”. You must also change the middle of the file name to something other than “english”. For example, the name of the new file could be “language.de.json”. Only language files with names that follow this formatting will be picked up for processing by the system.

control panel language tutorial

The easiest way to find a specific label or message is by searching for that specific message in the JSON file. Once you’re done, save the file and copy it into the language directory (C:\PSWTemp\LanguageFiles, by default) on the server.

Next, reset IIS to cache the new language file into the system. Once the system is back up, you should see the new language code added to the LanguageList parameter. You can access this field by logging in as the “SystemAdmin” user, and following Tools > Administration > Control Panel.

control panel language tutorial

You can set a language on a global level or user level. Setting a global language will show the language contents for all users under your license, whereas user level selection will only apply to that specific user. To set the new language setting on a global level, replace the code under LanguageDefault with the string you’ve entered in the language file as “Code”. For example, you set the code to “de”, you can enter “de” into this field. Save your changes and reset IIS again so that the system can get the new caching information. To set the language settings for an individual user, go to the edit user screen from Tools > Users and edit a user.

control panel language tutorial

Unauthenticated users accessing the system will see the language set in the LanguageDefault. However, the User-level language settings will override the global language set by the LanguageDefault parameter once the user has authenticated. For example, if you set the global language to “de”, and assign a user “en”, the landing page will be in “de” for this user, but the user will see “en” language labels once logged into the system.

When you receive a software update, you need to click the Update Language Files button found under Administration > Operations. This process will read the system code for the new version and overwrite the existing “en” language file to push the latest labels into the software. This will cause any changes to the “en” file to be lost. When you receive an update, you must also make the same changes in the new “en” file, or merge the changes from your old language file.