Follow these instructions to translate a spreadsheet to another language while you convert it to a web calculator with SpreadsheetConverter.
The SpreadsheetConverter add-in is currently only available in English, but you can use it to convert spreadsheets in any left-to-right language including Greek and Russian.
The converted web pages contain small amounts of standard texts generated by the converter, e.g. warning messages and button labels. You can translate all these using the text customization feature.
To create an online spreadsheet that is completely in a non-English language, e.g. Swedish, you need to do the following with the original spreadsheet in Excel, before you convert it:
- Translate the spreadsheet’s file name to Swedish.
- Translate the tab names in the spreadsheet to Swedish.
- Translate the text in all the cells of all the worksheets to Swedish. This includes the cells occupied by certain SpreadsheetConverter widgets, e.g. the Action buttons which take their label from the cell they’re in, or the File Attachment widget which takes its text prompt from its cell. Note that some texts may have external requirements, e.g. an e-mail message subject, a survey response or a hidden flag that the recipient expects to be in English at all times.
- Translate the text in the SpreadsheetConverter widget settings, e.g. the text for each Dropdown menu.
- Customize the standard texts used by the application using the Customize texts settings for the spreadsheet, replacing each English text with its Swedish translation.
- Translate the Page title in the Workbook settings to Swedish.
- Ensure that all links point to pages in the same language. Example: If the original English calculator has a link to http://www.example.com/en/calc_help.htm, you need to translate this page as http://www.example.com/sv/calc_help.htm and change the links in the Swedish calculator to point to this page instead.
- Ensure that any web pages used for the After successful submit, After failed submit and After cancel in the wizard options in the Submit settings are translated into Swedish and properly linked to from any Swedish form or calculator.
- Ensure that forms submitted in Swedish are properly processed after submission, e.g. that they are sent to the correct e-mail address or stored properly in a database of responses in Swedish.
- Ensure that the visitor tracking settings are adjusted for the language. You probably want to maintain separate visitor and conversion statistics for each language, and so you should use different settings for your visitor tracking, website statistics, conversion counters, advertising metrics etc.