void OnEditedCellChanged(object sender, CellChangedEventArgs e)
{
if ((_excel != null) && string.Equals(e.PropertyName, "Value"))
{
CellRange range = FixRange(Worksheet, ClearRange);
int row = e.Row - range.Row;
int column = e.Column - range.Column;
ulong num3 = CopyMoveHelper.ConvertToKey(row, column);
if (_cachedValues.ContainsKey(num3))
{
CellValueEntry entry = _cachedValues[num3];
if (entry.Value is string)
{
if (!string.IsNullOrEmpty((string)(entry.Value as string)))
{
_excel.RaiseValueChanged(e.Row, e.Column);
}
}
else if (entry.Value != null)
{
_excel.RaiseValueChanged(e.Row, e.Column);
}
}
}
}
public bool Undo(object parameter)
{
if (Worksheet != null)
{
bool flag = false;
if ((_cachedTables != null) && (_cachedTables.Count > 0))
{
foreach (SheetTable table in _cachedTables)
{
CellRange range = table.Range;
int row = range.Row;
int column = range.Column;
int rowCount = range.RowCount;
int columnCount = range.ColumnCount;
if (!table.ShowHeader)
{
row--;
rowCount++;
}
if (table.ShowFooter)
{
rowCount--;
}
SheetTable table2 = Worksheet.AddTable(table.Name, row, column, rowCount, columnCount, table.Style);
table2.BandedColumns = table.BandedColumns;
table2.BandedRows = table.BandedRows;
table2.HighlightFirstColumn = table.HighlightFirstColumn;
table2.HighlightLastColumn = table.HighlightLastColumn;
table2.ShowFooter = table.ShowFooter;
table2.ShowHeader = table.ShowHeader;
}
}
CellRange range2 = FixRange(Worksheet, ClearRange);
if (((_cachedValues != null) && (range2.ColumnCount > 0)) && (range2.RowCount > 0))
{
try
{
_excel = parameter as Excel;
Worksheet.CellChanged += new EventHandler <CellChangedEventArgs>(OnEditedCellChanged);
int num5 = range2.RowCount;
int num6 = range2.ColumnCount;
for (int i = 0; i < num5; i++)
{
for (int j = 0; j < num6; j++)
{
int num9 = range2.Row + i;
int num10 = range2.Column + j;
ulong num11 = CopyMoveHelper.ConvertToKey(i, j);
if (_cachedValues.ContainsKey(num11))
{
CellValueEntry entry = _cachedValues[num11];
if (entry.IsFormula)
{
Worksheet.SetFormula(num9, num10, (string)(entry.Value as string));
}
else
{
Worksheet.SetFormula(num9, num10, null);
Worksheet.SetValue(num9, num10, entry.Value);
}
}
else
{
Worksheet.SetFormula(num9, num10, null);
Worksheet.SetValue(num9, num10, null);
}
}
}
foreach (KeyValuePair <CellRange, string> pair in _arrayFormulas)
{
Worksheet.SetArrayFormula(pair.Key.Row, pair.Key.Column, pair.Key.RowCount, pair.Key.ColumnCount, pair.Value);
}
flag = true;
}
finally
{
Worksheet.CellChanged -= new EventHandler <CellChangedEventArgs>(OnEditedCellChanged);
_excel = null;
}
}
if (((_cachedFilteredColumns != null) && (_cachedFilteredColumns.Count > 0)) && (Worksheet.RowFilter != null))
{
foreach (int num12 in _cachedFilteredColumns)
{
Worksheet.RowFilter.Filter(num12);
}
}
if (flag)
{
RefreshUI(parameter);
return(true);
}
}
return(false);
}
public void SaveState()
{
if (Worksheet != null)
{
_cachedTables = new List <SheetTable>();
SheetTable[] tables = Worksheet.GetTables();
if ((tables != null) && (tables.Length > 0))
{
foreach (SheetTable table in tables)
{
if (ClearRange.Contains(table.Range))
{
_cachedTables.Add(table);
}
}
}
_cachedFilteredColumns = new List <int>();
RowFilterBase rowFilter = Worksheet.RowFilter;
if (((rowFilter != null) && (rowFilter.Range != null)) && rowFilter.IsFiltered)
{
int row = rowFilter.Range.Row;
int rowCount = rowFilter.Range.RowCount;
if (rowFilter.ShowFilterButton)
{
row = rowFilter.Range.Row - 1;
rowCount = rowFilter.Range.RowCount + 1;
if (row < 0)
{
row = -1;
rowCount = -1;
}
}
if (ClearRange.Contains(row, rowFilter.Range.Column, rowCount, rowFilter.Range.ColumnCount))
{
int num3 = (rowFilter.Range.Column < 0) ? 0 : rowFilter.Range.Column;
int num4 = (rowFilter.Range.Column < 0) ? Worksheet.ColumnCount : rowFilter.Range.ColumnCount;
for (int i = 0; i < num4; i++)
{
if (rowFilter.IsColumnFiltered(num3 + i))
{
_cachedFilteredColumns.Add(num3 + i);
}
}
}
}
CellRange range = FixRange(Worksheet, ClearRange);
if ((range.ColumnCount > 0) && (range.RowCount > 0))
{
List <CellRange> list = new List <CellRange>();
List <string> list2 = new List <string>();
object[,] objArray = Worksheet.FindFormulas(range.Row, range.Column, range.RowCount, range.ColumnCount);
for (int j = 0; j < objArray.GetLength(0); j++)
{
CellRange range2 = objArray[j, 0] as CellRange;
string str = (string)(objArray[j, 1] as string);
Match match = new Regex(@"^\s*{\s*(.*?)}\s*$").Match(str);
if (((match.Success && (range2.Row >= range.Row)) && ((range2.Column >= range.Column) && ((range2.Row + range2.RowCount) <= (range.Row + range.RowCount)))) && ((range2.Column + range2.ColumnCount) <= (range.Column + range.ColumnCount)))
{
_arrayFormulas[range2] = match.Groups[1].Value;
list.Add(range2);
list2.Add(str);
}
}
_cachedValues = new Dictionary <ulong, CellValueEntry>();
for (int k = 0; k < range.RowCount; k++)
{
for (int m = 0; m < range.ColumnCount; m++)
{
int num9 = range.Row + k;
int column = range.Column + m;
bool flag = false;
foreach (CellRange range3 in list)
{
if (range3.Contains(num9, column))
{
column = (range3.Column + range3.ColumnCount) - 1;
flag = true;
break;
}
}
if (!flag)
{
string formula = Worksheet.GetFormula(num9, column);
if (!string.IsNullOrEmpty(formula))
{
_cachedValues.Add(CopyMoveHelper.ConvertToKey(k, m), new CellValueEntry(formula, true));
}
else
{
object obj2 = Worksheet.GetValue(num9, column);
if (obj2 != null)
{
_cachedValues.Add(CopyMoveHelper.ConvertToKey(k, m), new CellValueEntry(obj2, false));
}
}
}
}
}
}
}
}