![\"A](\"https:\/\/mindfusion.dev\/blog\/wp-content\/uploads\/2017\/10\/wpf-spreadsheet-korean.png\")
<\/a>A spreadsheet in Korean<\/p><\/div>\n
I. General Settings<\/strong><\/p>\n We create a new WPF project in Visual Studio<\/a> and name it \u201cBudgetAllocation\u201d. You can drag and drop the WorkbookView<\/a> control from the Toolbox if you have installed the Spreadsheet for WPF component<\/a> or the WPF Pack.<\/a> Another option is to add the required dll-s manually:<\/p>\n In the XAML tag we add a mapping to the Spreadsheet control:<\/p>\n Then, in the XAML file we create an instance of the MindFusion.Spreadsheet.Wpf.WorkbookView that holds a MindFusion.Spreadsheet.Wpf.Workbook:<\/p>\n <ss:WorkbookView x:Name=”workbookView”> The next step is to add a new Worksheet to the Workbook and make it the active sheet:<\/p>\n With that we have completed the general settings for the project and is time to pay attention to the localization.<\/p>\n II. Localization<\/strong><\/p>\n Spreadsheet for WPF can be localized to support different language through external XML files and the Locale<\/a> property of the Workbook class. In our sample we will use Korean. First, let\u2019s tell the control that we want to type in Korean:<\/p>\n We need to change the default Font for the spreadsheet to one that does support Korean, we\u2019ve chosen Malgun Gothic:<\/p>\n The next step is to localize the UI of all forms that might appear when the user interacts with the spreadsheet. That happens through an XML file that we load and assign to the workbook:<\/p>\n The component provides ready to be used UI localization files for 6 of the most common languages in the world. In our case we use the file for Korean. You will find those files in a subfolder called Localization on your hard driver, in the installation folder of the control.<\/p>\n Once we\u2019ve finished localizing the spreadsheet it\u2019s time to add some data:<\/p>\n III. Data<\/strong><\/p>\n Specifying data for each cell is very easy, it is made through the Data property of the Cell instance:<\/p>\n A cell can contain a formula, and it is specified this way:<\/p>\n IV. Appearance<\/strong><\/p>\n The different cells and cell ranges in our spreadsheet have different formats and we set them through the Style<\/a> property:<\/p>\n You can style a range of cells as well:<\/p>\n Cells can be merged:<\/p>\n Cells that render numbers can be formatted according to your needs:<\/p>\n For some cells we use conditional formatting \u2013 that means we style them differently based on their data value:<\/p>\n In this case we raise alert by painting red those cells whose value is less than 35 in cells that have column index 1 to 4 and row index 5.<\/p>\n V. Context Menu<\/strong><\/p>\n We add a context menu to the Workbook control in XAML this way:<\/p>\n <ss:WorkbookView.ContextMenu> The ContextMenu has 3 items that allow the user to delete or insert cells as well to rename the worksheet. Let\u2019s look at the event handler of the Click event:<\/p>\n We recognize the menu item that was clicked based on its index. After that we show the appropriate form. The InsertCellsForm<\/a>, DeleteCellsForm<\/a> and WorksheetRenameForm<\/a> are all found in the MindFusion.Spreadsheet.Wpf.StandardForms namespace and we have to add a reference to the MindFusion.Spreadsheet.Wpf.StandardForms.dll. Once we do that, since we\u2019ve set the localization info to point to a Korean file, those forms also show in Korean:<\/p>\n Spreadsheet UI in Korean<\/p><\/div>\n With that our sample is ready. You can download the full source code together with the localization file and the necessary component libraries from here:<\/p>\n Download Spreadsheet Localization Sample in WPF<\/a><\/p>\n About Spreadsheet for WPF:<\/em> A native WPF component that allows developer to add to their applications functionality similar to those of Microsoft Excel. The diverse features of the component include smart API, rich styling options, support for numerous import\/export formats, custom DB functions, formula and charts. Find out more about MindFusion Spreadsheet for WPF here.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" In this blog post we will demonstrate how to customize the spreadsheet control so users can input in another language. We build a budget table whose data is in Korean. We will also use the latest localization capabilities of the … Continue reading \n
xmlns:ss=\"http:\/\/mindfusion.dev\/spreadsheet\/wpf\"\n<\/pre>\n
\n<ss:Workbook x:Name=”workbook” \/>
\n<\/ss:WorkbookView><\/p>\n \nvar activeSheet = workbook.Worksheets.Add();\nworkbookView.ActiveWorksheet = activeSheet;\nactiveSheet.BeginInit();\n......\nactiveSheet.EndInit();\n<\/pre>\n
workbook.Locale = new CultureInfo(\"ko-KR\"); \n<\/pre>\n
var globalStyle = activeSheet.CellRanges[0, 0, activeSheet.Columns.Count - 1, activeSheet.Rows.Count - 1].Style;\nglobalStyle.FontName = \"Malgun Gothic\";\n<\/pre>\n
var file = @\"..\/..\/Localization\/Localization.KR.xml\";\n if (file != null && File.Exists(file))\n workbook.SetLocalizationInfo(file);\n<\/pre>\n
activeSheet.Cells[\"A2\"].Data = \"\ube44\uc728\ub85c\uc11c\uc758 \uc790\uae08 \ubd84\ubc30\";\n<\/pre>\n
activeSheet.Cells[\"F4\"].Data = \"=SUM(B4:E4)\";\n<\/pre>\n
activeSheet.Cells[\"A3\"].Style.FontBold = true;\nactiveSheet.Cells[\"A3\"].Style.Background = new SolidColorBrush(Color.FromRgb(240, 240, 240));\nactiveSheet.Cells[\"A3\"].Style.BorderBottomBrush = new SolidColorBrush(Color.FromRgb(220, 220, 220));\nactiveSheet.Cells[\"A3\"].Style.BorderRightBrush = new SolidColorBrush(Color.FromRgb(220, 220, 220));\n<\/pre>\n
var heading = activeSheet.CellRanges[\"A2:G2\"];\n\nvar headingStyle = heading.Style;\nheadingStyle.FontBold = true;\nheadingStyle.VerticalAlignment = MindFusion.Spreadsheet.Wpf.VerticalAlignment.Middle;\n....\n<\/pre>\n
heading.Merge();\n<\/pre>\n
var salesStyle = activeSheet.CellRanges[1, 5, 4, 5].Style;\nsalesStyle.FontBold = true;\nsalesStyle.Format = \"#,##0.00;(#,##0.00)\";\n<\/pre>\n
\/\/ Set a conditional format\nvar format1 = salesStyle.ConditionalFormats.Add();\nformat1.Type = ConditionalFormatType.CellValue;\nformat1.Operator = ComparisonOperator.LessThan;\nformat1.First = \"35\";\nformat1.Style.Background = new SolidColorBrush(Color.FromArgb(255, 255, 120, 85));\nformat1.Style.Background.Freeze();\n<\/pre>\n
\n<ContextMenu MenuItem.Click=”ContextMenu_Click”>
\n<MenuItem Header=”Delete Cells Form…” \/>
\n<MenuItem Header=”Insert Cells Form…” \/>
\n<MenuItem Header=”Worksheet Rename Form…” \/>
\n<\/ContextMenu>
\n<\/ss:WorkbookView.ContextMenu><\/p>\n\/\/handle clicks on the context menu\nprivate void ContextMenu_Click(object sender, RoutedEventArgs e)\n {\n var menu = sender as ContextMenu;\n var index = menu.Items.IndexOf(e.OriginalSource);\n\n switch (index)\n {\n case 0:\n {\n new DeleteCellsForm(workbook).ShowDialog();\n break;\n }\n case 1:\n {\n new InsertCellsForm(workbook).ShowDialog();\n break;\n }\n case 2:\n {\n new WorksheetRenameForm(workbook, \"New name\").ShowDialog();\n break;\n }\n }\n }\n<\/pre>\n![\"Spreadsheet](\"https:\/\/mindfusion.dev\/blog\/wp-content\/uploads\/2017\/10\/insert-cells-form.png\")
<\/a>