internal SLConditionalFormatting2010 Clone()
{
var cf = new SLConditionalFormatting2010();
int i;
cf.Rules = new List <SLConditionalFormattingRule2010>();
for (i = 0; i < Rules.Count; ++i)
{
cf.Rules.Add(Rules[i].Clone());
}
cf.ReferenceSequence = new List <SLCellPointRange>();
SLCellPointRange cpr;
for (i = 0; i < ReferenceSequence.Count; ++i)
{
cpr = new SLCellPointRange(ReferenceSequence[i].StartRowIndex, ReferenceSequence[i].StartColumnIndex,
ReferenceSequence[i].EndRowIndex, ReferenceSequence[i].EndColumnIndex);
cf.ReferenceSequence.Add(cpr);
}
cf.Pivot = Pivot;
return(cf);
}
private void SetAllNull()
{
Reference = new SLCellPointRange(1, 1, 1, 1);
FirstHeaderRow = 1;
FirstDataRow = 1;
FirstDataColumn = 1;
RowPageCount = 0;
ColumnsPerPage = 0;
}
private Record rowToRecord(SLCellPointRange cpr, DataRetriever dataRetriever)
{
//Int64 claimNum = dataRetriever.getClaimNum(cpr.StartRowIndex);
String claimDesc = dataRetriever.getDescription(cpr.StartRowIndex);
DateTime claimDate = dataRetriever.getClaimDate(cpr.StartRowIndex);
String name = dataRetriever.getName(cpr.StartRowIndex);
String[] nameTokens = parser.parseName(name);
int recordID = dataRetriever.getRowID(cpr);
Record r = new Record(recordID, nameTokens[0], nameTokens[1], nameTokens[2], claimDate, claimDesc);
//r.nGrams = parser.parseNGrams(r.getFullName(), 3);
//r.nGrams = parser.parseRecordNGrams(r, 3);
return(r);
}
public int getRowID(SLCellPointRange cpr)
{
return(cpr.StartRowIndex);
}
private void SetAllNull()
{
IsNewPivotTable = true;
DataRange = new SLCellPointRange(-1, -1, -1, -1);
IsDataSourceTable = false;
SheetTableName = string.Empty;
// Excel 2013 uses 5 for attributes createdVersion and updatedVersion
// and 3 for attribute minRefreshableVersion.
// I don't know what earlier versions of Excel use because I've uninstalled
// the earlier versions of Excel 2007 and 2010...
// These three attributes are application dependent, which means technically they're
// dependent on SpreadsheetLight.
// For the sake of simplicity, I'm going to set all three attributes to the value of 3,
// so Excel (whatever version) can handle it without being insufferable.
Name = "";
CacheId = 0;
DataOnRows = false;
DataPosition = null;
AutoFormatId = null;
ApplyNumberFormats = null;
ApplyBorderFormats = null;
ApplyFontFormats = null;
ApplyPatternFormats = null;
ApplyAlignmentFormats = null;
ApplyWidthHeightFormats = null;
DataCaption = "";
GrandTotalCaption = "";
ErrorCaption = "";
ShowError = false;
MissingCaption = "";
ShowMissing = true;
PageStyle = "";
PivotTableStyleName = "";
VacatedStyle = "";
Tag = "";
UpdatedVersion = 3; // supposed to default 0. See above.
MinRefreshableVersion = 3; // supposed to default 0. See above.
AsteriskTotals = false;
ShowItems = true;
EditData = false;
DisableFieldList = false;
ShowCalculatedMembers = true;
VisualTotals = true;
ShowMultipleLabel = true;
ShowDataDropDown = true;
ShowDrill = true;
PrintDrill = false;
ShowMemberPropertyTips = true;
ShowDataTips = true;
EnableWizard = true;
EnableDrill = true;
EnableFieldProperties = true;
PreserveFormatting = true;
UseAutoFormatting = false;
PageWrap = 0;
PageOverThenDown = false;
SubtotalHiddenItems = false;
RowGrandTotals = true;
ColumnGrandTotals = true;
FieldPrintTitles = false;
ItemPrintTitles = false;
MergeItem = false;
ShowDropZones = true;
CreatedVersion = 3; // supposed to default 0. See above.
Indent = 1;
ShowEmptyRow = false;
ShowEmptyColumn = false;
ShowHeaders = true;
Compact = true;
Outline = false;
OutlineData = false;
CompactData = true;
Published = false;
GridDropZones = false;
StopImmersiveUi = true;
MultipleFieldFilters = true;
ChartFormat = 0;
RowHeaderCaption = "";
ColumnHeaderCaption = "";
FieldListSortAscending = false;
CustomListSort = true;
}
