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();
}
public void LoadPage()
{
var sheet = this.grid.CurrentWorksheet;
sheet.IterateCells(sheet.SelectionRange, (r, c, cell) =>
{
if (backupFormat == null)
{
sampleCell = cell.Clone();
unvell.ReoGrid.Utility.CellUtility.CopyCellContent(sampleCell, cell);
if (cell != null)
{
originalData = cell.Data;
}
backupFormat = cell.DataFormat;
return(true);
}
else if (backupFormat == cell.DataFormat)
{
return(true);
}
else
{
backupFormat = null;
return(false);
}
});
currentFormat = backupFormat;
backupFormatArgs = null;
if (currentFormat != null)
{
switch (currentFormat)
{
case CellDataFormatFlag.Number:
if (sampleCell.DataFormatArgs is NumberDataFormatter.NumberFormatArgs)
{
NumberDataFormatter.NumberFormatArgs nargs = (NumberDataFormatter.NumberFormatArgs)sampleCell.DataFormatArgs;
numberDecimalPlaces.Value = nargs.DecimalPlaces;
chkNumberUseSeparator.Checked = nargs.UseSeparator;
foreach (NegativeStyleListItem item in numberNegativeStyleList.Items)
{
if (item.NegativeStyle == nargs.NegativeStyle)
{
numberNegativeStyleList.SelectedItem = item;
break;
}
}
backupFormatArgs = nargs;
}
break;
case CellDataFormatFlag.DateTime:
DateTimeDataFormatter.DateTimeFormatArgs dargs = (DateTimeDataFormatter.DateTimeFormatArgs)sampleCell.DataFormatArgs;
txtDatetimeFormat.Text = dargs.Format;
int dfindex = -1;
for (int i = 0; i < datetimeFormatList.Items.Count; i++)
{
DatetimeFormatListItem item = (DatetimeFormatListItem)datetimeFormatList.Items[i];
if (item.Pattern.Equals(dargs.Format, StringComparison.CurrentCultureIgnoreCase))
{
dfindex = i;
break;
}
}
datetimeFormatList.SelectedIndex = dfindex;
backupFormatArgs = dargs;
break;
case CellDataFormatFlag.Currency:
var cargs = (CurrencyDataFormatter.CurrencyFormatArgs)sampleCell.DataFormatArgs;
var cultureName = cargs.CultureEnglishName;
foreach (var currencyCultureItem in currencySymbolList.Items)
{
if (string.Compare(((CurrencySymbolListItem)currencyCultureItem).Culture.EnglishName, cultureName, true) == 0)
{
currencySymbolList.SelectedItem = currencyCultureItem;
break;
}
}
currencyDecimalPlaces.Value = cargs.DecimalPlaces;
int cnindex = (int)cargs.NegativeStyle;
if (cnindex >= 0 && cnindex < currencyNegativeStyleList.Items.Count)
{
currencyNegativeStyleList.SelectedIndex = cnindex;
}
foreach (NegativeStyleListItem item in currencyNegativeStyleList.Items)
{
if (item.NegativeStyle == cargs.NegativeStyle)
{
currencyNegativeStyleList.SelectedItem = item;
break;
}
}
backupFormatArgs = cargs;
break;
case CellDataFormatFlag.Percent:
var pargs = (NumberDataFormatter.NumberFormatArgs)sampleCell.DataFormatArgs;
percentDecimalPlaces.Value = pargs.DecimalPlaces;
backupFormatArgs = pargs;
break;
}
for (int i = 0; i < formatList.Items.Count; i++)
{
var item = formatList.Items[i].ToString();
if (string.Equals(item, currentFormat.ToString(), StringComparison.CurrentCultureIgnoreCase))
{
formatList.SelectedIndex = i;
break;
}
}
}
else
{
formatList.SelectedIndex = 0;
}
backupFormat = currentFormat;
}