private void SetAllNull()
{
Pane = new SLPane();
Selections = new List <SLSelection>();
PivotSelections = new List <PivotSelection>();
WindowProtection = false;
ShowFormulas = false;
ShowGridLines = true;
ShowRowColHeaders = true;
ShowZeros = true;
RightToLeft = false;
TabSelected = false;
ShowRuler = true;
ShowOutlineSymbols = true;
DefaultGridColor = true;
ShowWhiteSpace = true;
View = SheetViewValues.Normal;
TopLeftCell = string.Empty;
ColorId = 64;
iZoomScale = 100;
iZoomScaleNormal = 0;
iZoomScaleSheetLayoutView = 0;
iZoomScalePageLayoutView = 0;
WorkbookViewId = 0;
}
internal SLPane Clone()
{
var p = new SLPane();
p.HorizontalSplit = HorizontalSplit;
p.VerticalSplit = VerticalSplit;
p.TopLeftCell = TopLeftCell;
p.ActivePane = ActivePane;
p.State = State;
return(p);
}
internal void FromSheetView(SheetView sv)
{
SetAllNull();
if (sv.WindowProtection != null)
{
WindowProtection = sv.WindowProtection.Value;
}
if (sv.ShowFormulas != null)
{
ShowFormulas = sv.ShowFormulas.Value;
}
if (sv.ShowGridLines != null)
{
ShowGridLines = sv.ShowGridLines.Value;
}
if (sv.ShowRowColHeaders != null)
{
ShowRowColHeaders = sv.ShowRowColHeaders.Value;
}
if (sv.ShowZeros != null)
{
ShowZeros = sv.ShowZeros.Value;
}
if (sv.RightToLeft != null)
{
RightToLeft = sv.RightToLeft.Value;
}
if (sv.TabSelected != null)
{
TabSelected = sv.TabSelected.Value;
}
if (sv.ShowRuler != null)
{
ShowRuler = sv.ShowRuler.Value;
}
if (sv.ShowOutlineSymbols != null)
{
ShowOutlineSymbols = sv.ShowOutlineSymbols.Value;
}
if (sv.DefaultGridColor != null)
{
DefaultGridColor = sv.DefaultGridColor.Value;
}
if (sv.ShowWhiteSpace != null)
{
ShowWhiteSpace = sv.ShowWhiteSpace.Value;
}
if (sv.View != null)
{
View = sv.View.Value;
}
if (sv.TopLeftCell != null)
{
TopLeftCell = sv.TopLeftCell.Value;
}
if (sv.ColorId != null)
{
ColorId = sv.ColorId.Value;
}
if (sv.ZoomScale != null)
{
ZoomScale = sv.ZoomScale.Value;
}
if (sv.ZoomScaleNormal != null)
{
ZoomScaleNormal = sv.ZoomScaleNormal.Value;
}
if (sv.ZoomScaleSheetLayoutView != null)
{
ZoomScaleSheetLayoutView = sv.ZoomScaleSheetLayoutView.Value;
}
if (sv.ZoomScalePageLayoutView != null)
{
ZoomScalePageLayoutView = sv.ZoomScalePageLayoutView.Value;
}
// required attribute but we'll use 0 as the default in case something terrible happens.
if (sv.WorkbookViewId != null)
{
WorkbookViewId = sv.WorkbookViewId.Value;
}
else
{
WorkbookViewId = 0;
}
using (var oxr = OpenXmlReader.Create(sv))
{
SLSelection sel;
while (oxr.Read())
{
if (oxr.ElementType == typeof(Pane))
{
Pane = new SLPane();
Pane.FromPane((Pane)oxr.LoadCurrentElement());
}
else if (oxr.ElementType == typeof(Selection))
{
sel = new SLSelection();
sel.FromSelection((Selection)oxr.LoadCurrentElement());
Selections.Add(sel);
}
else if (oxr.ElementType == typeof(PivotSelection))
{
PivotSelections.Add((PivotSelection)oxr.LoadCurrentElement().CloneNode(true));
}
}
}
}