private void _btnReplaceAll_Click(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(_comboFind.Text))
{
return;
}
if (!_comboReplace.Items.Contains(_comboReplace.Text))
{
_comboReplace.Items.Add(_comboReplace.Text);
}
_dataGrid.Items.Clear();
List <FindResult> results = _owner.FindAll(_comboFind.Text, _option);
foreach (FindResult result in results)
{
if (result.Sheet.IsProtected)
{
continue;
}
var grid = result.Sheet.Grid;
if (result.Sheet != _owner.Sheets.SelectedSheet)
{
_owner.Sheets.SelectedSheet = result.Sheet;
}
grid = _owner;
foreach (CellRange cellRange in result.Cells)
{
Replace(cellRange);
string original = null;
if (grid[cellRange.Row, cellRange.Column] != null)
{
original = grid[cellRange.Row, cellRange.Column].ToString();
}
if (!String.IsNullOrEmpty(original))
{
CustomFindResult customResult = new CustomFindResult(result.Sheet.SheetName, _owner.GetAddress(cellRange, false), original, cellRange);
_dataGrid.Items.Add(customResult);
}
}
}
}
private void _btnFindAll_Click(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(_comboFind.Text))
{
return;
}
if (!_comboFind.Items.Contains(_comboFind.Text))
{
_comboFind.Items.Add(_comboFind.Text);
}
_dataGrid.Items.Clear();
List <FindResult> results = _owner.FindAll(_comboFind.Text, _option);
foreach (FindResult result in results)
{
var grid = result.Sheet.Grid;
if (result.Sheet == _owner.Sheets.SelectedSheet)
{
grid = _owner;
}
foreach (CellRange cellRange in result.Cells)
{
string original = null;
if (grid[cellRange.Row, cellRange.Column] != null)
{
original = grid[cellRange.Row, cellRange.Column].ToString();
}
if (!String.IsNullOrEmpty(original))
{
CustomFindResult customResult = new CustomFindResult(result.Sheet.SheetName, _owner.GetAddress(cellRange, false), original, cellRange);
_dataGrid.Items.Add(customResult);
}
}
}
// To show the datagrid.
if (_dataGrid.Items.Count > 0)
{
Height = Height < 350 ? 350 : Height;
}
}