public override object ConvertTo(ITypeDescriptorContext context, CultureInfo culture, object value, Type destinationType)
{
var columnIndex = XlsUtil.ColumnRefToIndex(value); // zero-based
return(columnIndex.HasValue && columnIndex >= 0 && columnIndex < 16384
? XlsUtil.GetColumnRefString(value)
: "");
}
private async void SetCellRangeLnk_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
var range = _grid.CurrentWorksheet.SelectionRange;
if (range.IsEmpty)
{
return;
}
_setCellRangeLnk.Enabled = false;
_sheetOptions.FirstRowNumber = range.Row + 1;
_sheetOptions.LastRowNumber = range.EndRow + 1;
if (_sheetOptions.LastRowNumber == MAX_SHEET_ROWS)
{
_sheetOptions.LastRowNumber = null;
}
_sheetOptions.FirstColumnLetter = XlsUtil.GetColumnRefString(range.Col + 1);
_sheetOptions.LastColumnLetter = XlsUtil.GetColumnRefString(range.EndCol + 1);
_propGrid.Refresh();
await LoadColumns();
_setCellRangeLnk.Enabled = true;
}
public override object ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, object value)
{
var str = XlsUtil.GetColumnRefString(value);
return((str?.Any() ?? false) ? str : null);
}
