internal SLWorksheet(List <Color> ThemeColors, List <Color> IndexedColors, double ThemeDefaultColumnWidth,
long ThemeDefaultColumnWidthInEMU, int MaxDigitWidth, List <double> ColumnStepSize,
double CalculatedDefaultRowHeight)
{
ForceCustomRowColumnDimensionsSplitting = false;
ActiveCell = new SLCellPoint(1, 1);
SheetViews = new List <SLSheetView>();
IsDoubleColumnWidth = false;
SheetFormatProperties = new SLSheetFormatProperties(ThemeDefaultColumnWidth, ThemeDefaultColumnWidthInEMU,
MaxDigitWidth, ColumnStepSize, CalculatedDefaultRowHeight);
RowProperties = new Dictionary <int, SLRowProperties>();
ColumnProperties = new Dictionary <int, SLColumnProperties>();
Cells = new Dictionary <SLCellPoint, SLCell>();
HasSheetProtection = false;
SheetProtection = new SLSheetProtection();
HasAutoFilter = false;
AutoFilter = new SLAutoFilter();
MergeCells = new List <SLMergeCell>();
ConditionalFormattings = new List <SLConditionalFormatting>();
ConditionalFormattings2010 = new List <SLConditionalFormatting2010>();
DataValidations = new List <SLDataValidation>();
DataValidationDisablePrompts = false;
DataValidationXWindow = null;
DataValidationYWindow = null;
Hyperlinks = new List <SLHyperlink>();
PageSettings = new SLPageSettings(ThemeColors, IndexedColors);
RowBreaks = new Dictionary <int, SLBreak>();
ColumnBreaks = new Dictionary <int, SLBreak>();
DrawingId = string.Empty;
NextWorksheetDrawingId = 2;
Pictures = new List <SLPicture>();
Charts = new List <SLChart>();
InitializeBackgroundPictureStuff();
LegacyDrawingId = string.Empty;
Authors = new List <string>();
Comments = new Dictionary <SLCellPoint, SLComment>();
Tables = new List <SLTable>();
SparklineGroups = new List <SLSparklineGroup>();
}
private void SetAllNull()
{
AutoFilter = new SLAutoFilter();
Field = 0;
MemberPropertyFieldId = null;
Type = PivotFilterValues.Unknown;
EvaluationOrder = 0;
Id = 0;
MeasureHierarchy = null;
MeasureField = null;
Name = "";
Description = "";
StringValue1 = "";
StringValue2 = "";
}
internal void SetAllNull()
{
IsNewTable = true;
RelationshipID = string.Empty;
AutoFilter = new SLAutoFilter();
HasAutoFilter = false;
SortState = new SLSortState();
HasSortState = false;
TableColumns = new List <SLTableColumn>();
TableNames = new HashSet <string>();
TableStyleInfo = new SLTableStyleInfo();
HasTableStyleInfo = false;
Id = 0;
Name = null;
sDisplayName = string.Empty;
Comment = null;
StartRowIndex = 1;
StartColumnIndex = 1;
EndRowIndex = 1;
EndColumnIndex = 1;
TableType = TableValues.Worksheet;
HasTableType = false;
HeaderRowCount = 1;
InsertRow = null;
InsertRowShift = null;
TotalsRowCount = 0;
TotalsRowShown = null;
Published = null;
HeaderRowFormatId = null;
DataFormatId = null;
TotalsRowFormatId = null;
HeaderRowBorderFormatId = null;
BorderFormatId = null;
TotalsRowBorderFormatId = null;
HeaderRowCellStyle = null;
DataCellStyle = null;
TotalsRowCellStyle = null;
ConnectionId = null;
}
