private string DumpFormatArgs(object args) { StringBuilder sb = new StringBuilder(); if (args is NumberDataFormatter.NumberFormatArgs) { NumberDataFormatter.NumberFormatArgs nargs = (NumberDataFormatter.NumberFormatArgs)args; sb.AppendLine(string.Format("{0,-20} = {1}", "Decimal Places", nargs.DecimalPlaces)); sb.AppendLine(string.Format("{0,-20} = {1}", "Negative Style", nargs.NegativeStyle.ToString())); sb.AppendLine(string.Format("{0,-20} = {1}", "Use Separator", nargs.UseSeparator)); } else if (args is DateTimeDataFormatter.DateTimeFormatArgs) { DateTimeDataFormatter.DateTimeFormatArgs dargs = (DateTimeDataFormatter.DateTimeFormatArgs)args; sb.AppendLine(string.Format("{0,-20} = {1}", "Format", dargs.Format)); } else if (args is CurrencyDataFormatter.CurrencyFormatArgs) { CurrencyDataFormatter.CurrencyFormatArgs cmargs = (CurrencyDataFormatter.CurrencyFormatArgs)args; sb.AppendLine(string.Format("{0,-20} = {1}", "Culture EnglishName", cmargs.CultureEnglishName)); sb.AppendLine(string.Format("{0,-20} = {1}", "Decimal Places", cmargs.DecimalPlaces)); sb.AppendLine(string.Format("{0,-20} = {1}", "Negative Style", cmargs.NegativeStyle)); sb.AppendLine(string.Format("{0,-20} = {1}", "Prefix Symbol", cmargs.PrefixSymbol)); sb.AppendLine(string.Format("{0,-20} = {1}", "Postfix Symbol", cmargs.PostfixSymbol)); } return(sb.ToString()); }
public FormatPage() { InitializeComponent(); #region Initialize Setting Panels numberNegativeStyleList.Items.Add(new NegativeStyleListItem( NumberDataFormatter.NumberNegativeStyle.Default, (-1234.10f).ToString("###,###.00"), SystemColors.WindowText)); numberNegativeStyleList.Items.Add(new NegativeStyleListItem( NumberDataFormatter.NumberNegativeStyle.Red, (1234.10f).ToString("###,###.00"), Color.Red)); numberNegativeStyleList.Items.Add(new NegativeStyleListItem( NumberDataFormatter.NumberNegativeStyle.Brackets, (1234.10f).ToString("(###,###.00)"), SystemColors.WindowText)); numberNegativeStyleList.Items.Add(new NegativeStyleListItem( NumberDataFormatter.NumberNegativeStyle.RedBrackets, (1234.10f).ToString("(###,###.00)"), Color.Red)); if (numberNegativeStyleList.Items.Count > 0) { numberNegativeStyleList.SelectedIndex = 0; } datetimeFormatList.SelectedIndexChanged += (s, e) => { if (datetimeFormatList.SelectedItem != null) { DatetimeFormatListItem item = (DatetimeFormatListItem)datetimeFormatList.SelectedItem; txtDatetimeFormat.Text = item.Pattern; } }; var currentCulture = Thread.CurrentThread.CurrentCulture; datetimeFormatList.Items.AddRange(new object[] { // culture patterns new DatetimeFormatListItem(true, currentCulture.DateTimeFormat.ShortDatePattern), new DatetimeFormatListItem(true, currentCulture.DateTimeFormat.LongDatePattern), new DatetimeFormatListItem(true, currentCulture.DateTimeFormat.ShortDatePattern + " " + currentCulture.DateTimeFormat.ShortTimePattern), new DatetimeFormatListItem(true, currentCulture.DateTimeFormat.LongDatePattern + " " + currentCulture.DateTimeFormat.LongTimePattern), new DatetimeFormatListItem(true, currentCulture.DateTimeFormat.ShortTimePattern), new DatetimeFormatListItem(true, currentCulture.DateTimeFormat.LongTimePattern), // predefine patterns new DatetimeFormatListItem(false, "yyyy/M/d"), new DatetimeFormatListItem(false, "yyyy/M/d hh:mm"), new DatetimeFormatListItem(false, "M/d"), new DatetimeFormatListItem(false, "hh:mm"), }); datetimeLocationList.SelectedIndexChanged += (s, e) => { var ci = (CultureInfo)datetimeLocationList.SelectedItem; ((DatetimeFormatListItem)(datetimeFormatList.Items[0])).Pattern = ci.DateTimeFormat.ShortDatePattern; ((DatetimeFormatListItem)(datetimeFormatList.Items[1])).Pattern = ci.DateTimeFormat.LongDatePattern; ((DatetimeFormatListItem)(datetimeFormatList.Items[2])).Pattern = ci.DateTimeFormat.ShortDatePattern + " " + ci.DateTimeFormat.ShortTimePattern; ((DatetimeFormatListItem)(datetimeFormatList.Items[3])).Pattern = ci.DateTimeFormat.LongDatePattern + " " + ci.DateTimeFormat.LongTimePattern; ((DatetimeFormatListItem)(datetimeFormatList.Items[4])).Pattern = ci.DateTimeFormat.ShortTimePattern; ((DatetimeFormatListItem)(datetimeFormatList.Items[5])).Pattern = ci.DateTimeFormat.LongTimePattern; DateTime dt = new DateTime(1980, 7, 13); CultureInfo culture = (CultureInfo)datetimeLocationList.SelectedItem; foreach (DatetimeFormatListItem item in datetimeFormatList.Items) { item.Sample = dt.ToString(item.Pattern, culture); } typeof(ListBox).InvokeMember("RefreshItems", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.InvokeMethod, null, datetimeFormatList, new object[] { }); object backup = datetimeFormatList.SelectedItem; if (backup != null) { datetimeFormatList.SelectedItem = null; datetimeFormatList.SelectedItem = backup; } else { datetimeFormatList.SelectedIndex = 0; } }; currencySymbolList.SelectedIndexChanged += (s, e) => { var listItem = (CurrencySymbolListItem)currencySymbolList.SelectedItem; currencyNegativeStyleList.Items.Clear(); currencyNegativeStyleList.Items.Add(new NegativeStyleListItem( NumberDataFormatter.NumberNegativeStyle.Default, /*"-$1,234.10 ###,###.00"*/ (1234.10f).ToString("c", listItem.Culture), SystemColors.WindowText)); currencyNegativeStyleList.Items.Add(new NegativeStyleListItem( NumberDataFormatter.NumberNegativeStyle.Red, /*"$1,234.10"*/ (1234.10f).ToString("c", listItem.Culture), Color.Red)); currencyNegativeStyleList.Items.Add(new NegativeStyleListItem( NumberDataFormatter.NumberNegativeStyle.Brackets, /*"($1,234.10)"*/ "(" + (1234.10f).ToString("c", listItem.Culture) + ")", SystemColors.WindowText)); currencyNegativeStyleList.Items.Add(new NegativeStyleListItem( NumberDataFormatter.NumberNegativeStyle.RedBrackets, /*"($1,234.10)"*/ "(" + (1234.10f).ToString("c", listItem.Culture) + ")", Color.Red)); if (currentFormatArgs != null) { currencyFormatArgs.PrefixSymbol = null; currencyFormatArgs.PostfixSymbol = null; } if (currencyNegativeStyleList.Items.Count > 0) { currencyNegativeStyleList.SelectedIndex = 0; } UpdateSample(); }; var cultures = CultureInfo.GetCultures(CultureTypes.InstalledWin32Cultures).OrderBy(c => c.EnglishName); foreach (CultureInfo info in cultures) { datetimeLocationList.Items.Add(info); if (info.Equals(currentCulture)) { datetimeLocationList.SelectedItem = info; } try { var item = new CurrencySymbolListItem(info); currencySymbolList.Items.Add(item); if (info.Equals(currentCulture)) { currencySymbolList.SelectedItem = item; } } catch { } } // add valid data formatter foreach (var key in Enum.GetValues(typeof(CellDataFormatFlag))) { IDataFormatter formatter; if (DataFormatterManager.Instance.DataFormatters.TryGetValue((CellDataFormatFlag)key, out formatter)) { formatList.Items.Add(key); } } numberFormatArgs = new NumberDataFormatter.NumberFormatArgs { DecimalPlaces = 2, NegativeStyle = NumberDataFormatter.NumberNegativeStyle.Default, UseSeparator = true, }; datetimeFormatArgs = new DateTimeDataFormatter.DateTimeFormatArgs { Format = currentCulture.DateTimeFormat.ShortDatePattern, }; currencyFormatArgs = new CurrencyDataFormatter.CurrencyFormatArgs() { CultureEnglishName = currentCulture.EnglishName, DecimalPlaces = (short)currentCulture.NumberFormat.CurrencyDecimalDigits, NegativeStyle = NumberDataFormatter.NumberNegativeStyle.Default, }; #endregion formatList.SelectedIndexChanged += (sender, e) => { try { currentFormat = (CellDataFormatFlag)Enum.Parse(typeof(CellDataFormatFlag), formatList.Text); } catch { currentFormat = CellDataFormatFlag.General; } Panel newSettingPanel = null; switch (currentFormat) { case CellDataFormatFlag.Number: newSettingPanel = numberPanel; break; case CellDataFormatFlag.DateTime: newSettingPanel = datetimePanel; break; case CellDataFormatFlag.Currency: newSettingPanel = currencyPanel; break; case CellDataFormatFlag.Percent: newSettingPanel = percentPanel; break; } if (newSettingPanel != currentSettingPanel) { if (newSettingPanel != null) { newSettingPanel.Location = new Point(grpSample.Left - 5, grpSample.Bottom + 10); newSettingPanel.Show(); } if (currentSettingPanel != null) { currentSettingPanel.Hide(); } currentSettingPanel = newSettingPanel; } UpdateSample(); }; numberDecimalPlaces.ValueChanged += (s, e) => UpdateSample(); chkNumberUseSeparator.CheckedChanged += (s, e) => UpdateSample(); numberNegativeStyleList.SelectedIndexChanged += (s, e) => UpdateSample(); currencyDecimalPlaces.ValueChanged += (s, e) => UpdateSample(); currencyNegativeStyleList.SelectedIndexChanged += (s, e) => UpdateSample(); percentDecimalPlaces.ValueChanged += (s, e) => UpdateSample(); formatList.DoubleClick += (s, e) => RaiseDone(); numberNegativeStyleList.DoubleClick += (s, e) => RaiseDone(); datetimeFormatList.DoubleClick += (s, e) => RaiseDone(); currencyNegativeStyleList.DoubleClick += (s, e) => RaiseDone(); txtDatetimeFormat.TextChanged += (s, e) => UpdateSample(); }