Spreadsheet - Localization

  • Home
  • Undo
  • Redo
  • Paste
  • Cut
  • Copy
  • Format
    • Automatic
    • Number
    • Percent
    • Financial
    • Currency
    • Date
    • Time
    • Date time
    • Duration
    • More formats...
  • Filter
  • Data Validation
  • Cut
  • Copy
  • Paste
  • Hide
  • Delete
  • Hide
  • Delete

Demo Configurator



Isolate this demo as a stand-alone application
  • About this demo
  • C#
  • VB

RadSpreadsheet provides a mechanism for quick and easy localization. All button labels and messages in the control area are obtained from the resource files located in the WebSite's App_GlobalResources directory, so that the language can be switched with a single property (Culture).
e.g. <telerik:RadSpreadsheet ID="RadSpreadsheet1" runat="server" Culture="en-US" />

Developers can also localize the component for languages, which are not provided with the RadSpreadsheet distribution by modifying the provided resx file.

Additionally, each of the localization strings can be modified at runtime using the Localization property. This prevents the need to create a new localization file to change a single string.

  • DefaultVB.aspx
  • DefaultVB.aspx.vb
<%@ Page Language="VB" AutoEventWireup="true" CodeFile="DefaultVB.aspx.vb"  Inherits="Spreadsheet.Examples.Localization.DefaultVB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns='http://www.w3.org/1999/xhtml'>
<head runat="server">
    <title>Telerik ASP.NET Example</title>
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
    <div class="demo-container no-bg">
        <telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1" >
            <toolbar>
                <telerik:SpreadsheetToolbarTab Text="Home">
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="Undo" ShowLabel="true" />
                        <telerik:SpreadsheetTool Name="Redo" ShowLabel="true" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="Paste" ShowLabel="true" />
                        <telerik:SpreadsheetTool Name="Cut" ShowLabel="true" />
                        <telerik:SpreadsheetTool Name="Copy" ShowLabel="true" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="Format" ShowLabel="true" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="Filter" ShowLabel="true" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="Validation" ShowLabel="true" />
                    </telerik:SpreadsheetToolbarGroup>
                </telerik:SpreadsheetToolbarTab>
            </toolbar>
        </telerik:RadSpreadsheet>
    </div>

    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="ConfigurationPanel1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="ConfigurationPanel1" LoadingPanelID="RadAjaxLoadingPanel1" />
                    <telerik:AjaxUpdatedControl ControlID="RadSpreadsheet1" LoadingPanelID="RadAjaxLoadingPanel1" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>

    <telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanel1" />

    <qsf:ConfiguratorPanel runat="server" ID="ConfigurationPanel1">
        <Views>
            <qsf:View Title="Choose language">
                <qsf:ConfiguratorColumn ID="ConfiguratorColumn1" runat="server" Size="Narrow">

                    <qsf:RadioButtonList ID="radiobuttonlistLanguages" runat="server" RepeatDirection="Vertical"
                        AutoPostBack="True" Style="margin-left: 1em" OnSelectedIndexChanged="radiobuttonlistLanguages_SelectedIndexChanged">
                        <asp:ListItem Value="en-US" Selected="true"><img src="images/us.gif" alt="English" /> English</asp:ListItem>
                        <asp:ListItem Value="fr-FR"><img src="images/french.gif" alt="Francais" /> Francais</asp:ListItem>
                        <asp:ListItem Value="de-DE"><img src="images/german.gif" alt="Deutsch" /> Deutsch</asp:ListItem>
                    </qsf:RadioButtonList>

                </qsf:ConfiguratorColumn>
            </qsf:View>
        </Views>

    </qsf:ConfiguratorPanel>
    </form>
</body>
</html>

Support & Learning Resources

Find Assistance

Help Us Improve

Was this example helpful?