internal virtual void CopyTo(TXlsxPivotList <K, T> Target, TWorkbookGlobals Globals)
{
for (int i = 0; i < FList.Count; i++)
{
// Target.FList.Add(FList[i].Clone());
}
}
internal static string AsString(TParsedTokenList Tokens, int CellRow, int CellCol,
ICellList CellList, TWorkbookGlobals Globals, int MaxStringConstantLen, bool WritingXlsx, bool SkipEqual)
{
string StartFormula = fts(TFormulaToken.fmStartFormula); //Formulas do not always begin with "=". Array formulas begin with "{", and they override this var to empty.
TFormulaStack ParsedStack = new TFormulaStack();
bool R1C1 = false;
if (Globals != null && !WritingXlsx)
{
R1C1 = Globals.Workbook.FormulaReferenceStyle == TReferenceStyle.R1C1;
}
Tokens.ResetPositionToStart();
while (!Tokens.Eof())
{
TBaseParsedToken Token = Tokens.ForwardPop();
ptg BaseToken = Token.GetBaseId;
Evaluate(Token, R1C1, CellRow, CellCol, BaseToken, Tokens, CellList, Globals, ParsedStack, ref StartFormula, MaxStringConstantLen, WritingXlsx);
} //while
if (WritingXlsx || SkipEqual)
{
StartFormula = String.Empty;
}
if (ParsedStack.Count == 0)
{
return(String.Empty); //StartFormula + TFormulaMessages.ErrString(TFlxFormulaErrorValue.ErrRef); This is needed for deleted named ranges.
}
return(StartFormula + ParsedStack.Pop());
}
internal TRowHeightCalc(TWorkbookGlobals aWg)
{
Wg = aWg;
gr = new TGraphicCanvas();
InitXF();
}
internal TColWidthCalc(TWorkbookGlobals aWg)
{
Wg = aWg;
gr = new TGraphicCanvas();
InitXF();
}
private static string GetName(int NameIndex, int ExternSheet, TWorkbookGlobals Globals, bool WritingXlsx)
{
if (Globals == null)
{
return(" <Name> ");
}
return(Globals.References.GetName(ExternSheet, NameIndex - 1, Globals, WritingXlsx));
}
private static string GetSheetName(int ExternSheet, TWorkbookGlobals Globals, bool WritingXlsx)
{
if (ExternSheet == 0xFFFF)
{
return(TFormulaMessages.ErrString(TFlxFormulaErrorValue.ErrRef));
}
return(Globals.References.GetSheetName(ExternSheet, Globals, WritingXlsx));
}
internal static void CheckInternalNames(int OptionFlags, TWorkbookGlobals Globals)
{
//If a name is added and it is internal, we can't trust the ordering and need to delete the country record.
if ((OptionFlags & 0x20) != 0)
{
Globals.DeleteCountry();
}
}
internal TColInfoList(TWorkbookGlobals aWorkbookGlobals, bool aAllowStandardWidth)
{
FWorkbookGlobals = aWorkbookGlobals;
FColumns = new TColInfo[(int)Math.Ceiling((FlxConsts.Max_Columns + 2) / (double)Buckets)][];
DefColWidthChars = 8; //Defcolwidthchars is a required record.
DefColWidthChars256 = -1;
AllowStandardWidth = aAllowStandardWidth;
}
internal TWorkbook(ExcelFile aXls, TFileProps aFileProps)
{
FGlobals = new TWorkbookGlobals(aXls);
FSheets = new TSheetList();
#if (FRAMEWORK30)
FileProps = aFileProps;
#endif
}
private static string ConvertInternalFunctionName(TWorkbookGlobals Globals, string InternalName)
{
TUserDefinedFunctionContainer fn = Globals.Workbook.GetUserDefinedFunction(InternalName);
if (fn != null)
{
return(fn.Function.Name);
}
return(InternalName);
}
internal static string AsString(TParsedTokenList Tokens, int CellRow, int CellCol, ICellList CellList)
{
TWorkbookGlobals Globals = null;
if (CellList != null)
{
Globals = CellList.Globals;
}
return(AsString(Tokens, CellRow, CellCol, CellList, Globals, -1, false));
}
private static string GetNameX(TNameXToken Token, TWorkbookGlobals Globals, bool WritingXlsx)
{
if (Globals == null)
{
return(" <Name> ");
}
int ExternSheetIndex = Token.FExternSheet; //This index is *not* used to get the sheet. We use the externname instead.
string Sheet = Globals.References.GetSheetFromName(ExternSheetIndex, Token.NameIndex - 1, Globals);
int SupBook = Globals.References.GetSupBook(ExternSheetIndex);
string ExternalString = Globals.References.GetSheetName(SupBook, Sheet, Globals, WritingXlsx);
return(ExternalString + GetName(Token.NameIndex, ExternSheetIndex, Globals, WritingXlsx));
}
internal void MergeFromPxlGlobals(TWorkbookGlobals SourceGlobals)
{
sBOF = SourceGlobals.sBOF;
FSST = SourceGlobals.FSST;
FReferences = SourceGlobals.FReferences;
FBoundSheets = SourceGlobals.FBoundSheets;
//Pxl doesn't have styles.
CellXF.MergeFromPxlXF(SourceGlobals.CellXF, Fonts.Count - 1, this, SourceGlobals); //-1 because fonts[0] will be merged
FFonts.MergeFromPxlFont(SourceGlobals.Fonts);
//Formats are added in FXF.Merge
FNames = SourceGlobals.FNames;
Window1 = SourceGlobals.Window1;
CodePage = SourceGlobals.CodePage;
Country = SourceGlobals.Country;
}
internal int AddName(TXlsNamedRange Range, TWorkbookGlobals Globals, TCellList CellList)
{
int aCount = Count;
bool IsInternal;
bool ValidName = TXlsNamedRange.IsValidRangeName(Range.Name, out IsInternal);
if (IsInternal)
{
Range.OptionFlags |= 0x020;
}
for (int i = 0; i < aCount; i++)
{
//Documentation is wrong. We need the sheet index (1 based) not the externsheetindex
/*int rSheet=-1;
* if (this[i].RangeSheet>=0)
* {
* rSheet = GetSheet(this[i].RangeSheet);
* }
*/
int rSheet = this[i].RangeSheet;
if (
(rSheet == Range.NameSheetIndex) &&
(String.Equals(this[i].Name, Range.Name, StringComparison.CurrentCultureIgnoreCase))
)
{
this[i] = new TNameRecord(Range, Globals, CellList); //We have to be careful not to change name ordering, or formulas would point to wrong ranges.
//If we found it, then it *is* a valid name
return(i);
}
}
if (!ValidName)
{
XlsMessages.ThrowException(XlsErr.ErrInvalidNameForARange, Convert.ToString(Range.Name));
}
Add(new TNameRecord(Range, Globals, CellList));
CheckInternalNames(Range.OptionFlags, Globals);
return(Count - 1);
}
internal void ReplaceName(int Index, TXlsNamedRange Range, TWorkbookGlobals Globals, TCellList CellList)
{
bool IsInternal;
bool ValidName = TXlsNamedRange.IsValidRangeName(Range.Name, out IsInternal);
if (!ValidName)
{
XlsMessages.ThrowException(XlsErr.ErrInvalidNameForARange, Convert.ToString(Range.Name));
}
if (Index < 0 || Index >= Count)
{
XlsMessages.ThrowException(XlsErr.ErrXlsIndexOutBounds, Index, "Index", 0, Count - 1);
}
if (IsInternal)
{
Range.OptionFlags |= 0x020;
}
this[Index] = new TNameRecord(Range, Globals, CellList); //We have to be careful not to change name ordering, or formulas would point to wrong ranges.
CheckInternalNames(Range.OptionFlags, Globals);
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.HeaderImages.LoadFromStream(WorkbookLoader.RecordLoader, this, false);
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.BookExt = this;
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.DConn.Add(this);
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.BoundSheets.AddTabIdFromFile(this);
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.RealTimeData.Add(this);
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.UserBView.Add(this);
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.RecalcId = this;
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.OleObjectSize = this;
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
//Do nothing, should be ignored
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.Excel9File = this;
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.ObNoMacros = this;
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.CodeNameRecord = this;
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.Palette = this;
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
Globals.ClrtClient = this;
}
internal override void LoadIntoWorkbook(TWorkbookGlobals Globals, TWorkbookLoader WorkbookLoader)
{
base.LoadIntoWorkbook(Globals, WorkbookLoader);
Globals.LoadingInterfaceHdr = false;
}
