address.hxx File Reference

#include <rtl/ustrbuf.hxx>
#include <rtl/strbuf.hxx>
#include <array>
#include <limits>
#include <ostream>
#include "scdllapi.h"
#include "types.hxx"
#include <formula/grammar.hxx>
#include <o3tl/typed_flags_set.hxx>
#include <o3tl/underlyingenumvalue.hxx>

Include dependency graph for address.hxx:

This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Classes
struct	o3tl::typed_flags< ScRefFlags >
class	ScAddress
struct	ScAddress::Details
struct	ScAddress::ExternalInfo
struct	ScAddressHashFunctor
class	ScRange
class	ScRangePair
class	ScRefAddress

Namespaces
namespace	com
namespace	com::sun
namespace	com::sun::star
namespace	com::sun::star::sheet
namespace	com::sun::star::uno
namespace	o3tl

Macros
#define	BCA_BRDCST_ALWAYS   ScAddress( 0, SCROW_MAX, 0 )
#define	BCA_LISTEN_ALWAYS   ScRange( BCA_BRDCST_ALWAYS, BCA_BRDCST_ALWAYS )

Typedefs
typedef size_t	SCSIZE
	size_t typedef to be able to find places where code was changed from USHORT to size_t and is used to read/write from/to streams. More...

Enumerations
enum class	ScRefFlags : sal_uInt16 {   ZERO = 0x0000 ,   COL_ABS = 0x0001 ,   ROW_ABS = 0x0002 ,   TAB_ABS = 0x0004 ,   TAB_3D = 0x0008 ,   COL2_ABS = 0x0010 ,   ROW2_ABS = 0x0020 ,   TAB2_ABS = 0x0040 ,   TAB2_3D = 0x0080 ,   ROW_VALID = 0x0100 ,   COL_VALID = 0x0200 ,   TAB_VALID = 0x0400 ,   BITS ,   FORCE_DOC = 0x0800 ,   ROW2_VALID = 0x1000 ,   COL2_VALID = 0x2000 ,   TAB2_VALID = 0x4000 ,   VALID = 0x8000 ,   TAB_ABS_3D = TAB_ABS | TAB_3D ,   ADDR_ABS = VALID | COL_ABS | ROW_ABS | TAB_ABS ,   RANGE_ABS = ADDR_ABS | COL2_ABS | ROW2_ABS | TAB2_ABS ,   ADDR_ABS_3D = ADDR_ABS | TAB_3D ,   RANGE_ABS_3D = RANGE_ABS | TAB_3D }

Functions
constexpr OUStringLiteral	MAXROW_STRING (u"1048575")
constexpr OUStringLiteral	MAXCOL_STRING (u"XFD")
constexpr OUStringLiteral	MAXROW_JUMBO_STRING (u"16777215")
constexpr OUStringLiteral	MAXCOL_JUMBO_STRING (u"XFD")
bool	ValidCol (SCCOL nCol, SCCOL nMaxCol)
bool	ValidRow (SCROW nRow, SCROW nMaxRow)
bool	ValidTab (SCTAB nTab)
bool	ValidTab (SCTAB nTab, SCTAB nMaxTab)
bool	ValidColRow (SCCOL nCol, SCROW nRow, SCCOL nMaxCol, SCROW nMaxRow)
bool	ValidColRowTab (SCCOL nCol, SCROW nRow, SCTAB nTab, SCCOL nMaxCol, SCROW nMaxRow)
SCCOL	SanitizeCol (SCCOL nCol, SCCOL nMaxCol)
SCROW	SanitizeRow (SCROW nRow, SCROW nMaxRow)
SCTAB	SanitizeTab (SCTAB nTab)
template<typename T >
void	PutInOrder (T &nStart, T &nEnd)
void	applyStartToEndFlags (ScRefFlags &target, const ScRefFlags source)
void	applyStartToEndFlags (ScRefFlags &target)
template<typename charT , typename traits >
std::basic_ostream< charT, traits > &	operator<< (std::basic_ostream< charT, traits > &stream, const ScAddress &rAddress)
bool	ValidAddress (const ScAddress &rAddress, SCCOL nMaxCol, SCROW nMaxRow)
template<typename charT , typename traits >
std::basic_ostream< charT, traits > &	operator<< (std::basic_ostream< charT, traits > &stream, const ScRange &rRange)
bool	ValidRange (const ScRange &rRange, SCCOL nMaxCol, SCROW nMaxRow)
bool	ConvertSingleRef (const ScDocument &pDocument, const OUString &rRefString, SCTAB nDefTab, ScRefAddress &rRefAddress, const ScAddress::Details &rDetails, ScAddress::ExternalInfo *pExtInfo=nullptr)
bool	ConvertDoubleRef (const ScDocument &rDocument, const OUString &rRefString, SCTAB nDefTab, ScRefAddress &rStartRefAddress, ScRefAddress &rEndRefAddress, const ScAddress::Details &rDetails, ScAddress::ExternalInfo *pExtInfo=nullptr)
SC_DLLPUBLIC void	ScColToAlpha (OUStringBuffer &rBuffer, SCCOL nCol)
	append alpha representation of column to buffer More...
void	ScColToAlpha (OUString &rStr, SCCOL nCol)
OUString	ScColToAlpha (SCCOL nCol)
bool	AlphaToCol (const ScDocument &rDoc, SCCOL &rCol, std::u16string_view rStr)
	get column number of A..IV... string More...

Variables
const SCROW	SCROW_MAX = ::std::numeric_limits<SCROW>::max()
const SCCOL	SCCOL_MAX = ::std::numeric_limits<SCCOL>::max()
const SCTAB	SCTAB_MAX = ::std::numeric_limits<SCTAB>::max()
const SCCOLROW	SCCOLROW_MAX = ::std::numeric_limits<SCCOLROW>::max()
const SCSIZE	SCSIZE_MAX = ::std::numeric_limits<SCSIZE>::max()
const SCROW	MAXROWCOUNT = 1048576
const SCCOL	MAXCOLCOUNT = 16384
const SCCOL	INITIALCOLCOUNT = 1
const SCTAB	MAXTABCOUNT = 10000
	limiting to 10000 for now, problem with 32 bit builds for now More...
const SCROW	MAXROW = MAXROWCOUNT - 1
const SCCOL	MAXCOL = MAXCOLCOUNT - 1
const SCTAB	MAXTAB = MAXTABCOUNT - 1
const SCCOLROW	MAXCOLROW = MAXROW
const SCROW	MAXROWCOUNT_JUMBO = 16 * 1024 * 1024
const SCCOL	MAXCOLCOUNT_JUMBO = 16384
const SCROW	MAXROW_JUMBO = MAXROWCOUNT_JUMBO - 1
const SCCOL	MAXCOL_JUMBO = MAXCOLCOUNT_JUMBO - 1
const SCROW	MAXTILEDROW = MAXROW
const SCTAB	MAXINITTAB = 1024
const SCTAB	MININITTAB = 1
const SCTAB	SC_TAB_APPEND = SCTAB_MAX
const SCTAB	TABLEID_DOC = SCTAB_MAX
const SCROW	SCROWS32K = 32000
const SCCOL	SCCOL_REPEAT_NONE = SCCOL_MAX
const SCROW	SCROW_REPEAT_NONE = SCROW_MAX
const SCCOL	SC_TABSTART_NONE = SCCOL_MAX
const SCROW	MAXROW_30 = 8191

Macro Definition Documentation

BCA_BRDCST_ALWAYS

#define BCA_BRDCST_ALWAYS   ScAddress( 0, SCROW_MAX, 0 )

Definition at line 944 of file address.hxx.

BCA_LISTEN_ALWAYS

#define BCA_LISTEN_ALWAYS   ScRange( BCA_BRDCST_ALWAYS, BCA_BRDCST_ALWAYS )

Definition at line 945 of file address.hxx.

Typedef Documentation

SCSIZE

typedef size_t SCSIZE

size_t typedef to be able to find places where code was changed from USHORT to size_t and is used to read/write from/to streams.

Definition at line 48 of file address.hxx.

Enumeration Type Documentation

ScRefFlags

enum class ScRefFlags : sal_uInt16

strong

Enumerator
ZERO
COL_ABS
ROW_ABS
TAB_ABS
TAB_3D
COL2_ABS
ROW2_ABS
TAB2_ABS
TAB2_3D
ROW_VALID
COL_VALID
TAB_VALID
BITS
FORCE_DOC
ROW2_VALID
COL2_VALID
TAB2_VALID
VALID
TAB_ABS_3D
ADDR_ABS
RANGE_ABS
ADDR_ABS_3D
RANGE_ABS_3D

Definition at line 157 of file address.hxx.

Function Documentation

AlphaToCol()

bool AlphaToCol	(	const ScDocument &	rDoc,
		SCCOL &	rCol,
		std::u16string_view	rStr
	)

get column number of A..IV... string

Definition at line 2509 of file address.cxx.

References ScDocument::MaxCol(), nPos, ScGlobal::ToUpperAlpha(), and ScDocument::ValidCol().

Referenced by ScTableColumnsObj::GetObjectByName_Impl(), ScTableColumnsObj::hasByName(), and lcl_CheckOne_OOO().

applyStartToEndFlags() [1/2]

void applyStartToEndFlags ( ScRefFlags &  target )

inline

Definition at line 200 of file address.hxx.

References o3tl::to_underlying().

applyStartToEndFlags() [2/2]

void applyStartToEndFlags ( ScRefFlags &  target, const ScRefFlags  source  )

inline

Definition at line 196 of file address.hxx.

References o3tl::to_underlying().

Referenced by ScInputHandler::InitRangeFinder(), lcl_ScRange_Parse_OOo(), lcl_ScRange_Parse_XL_A1(), lcl_ScRange_Parse_XL_R1C1(), ScInputHandler::NotifyChange(), and ScRangeList::Parse().

ConvertDoubleRef()

bool ConvertDoubleRef	(	const ScDocument &	rDocument,
		const OUString &	rRefString,
		SCTAB	nDefTab,
		ScRefAddress &	rStartRefAddress,
		ScRefAddress &	rEndRefAddress,
		const ScAddress::Details &	rDetails,
		ScAddress::ExternalInfo *	pExtInfo = nullptr
	)

Definition at line 1511 of file address.cxx.

References ScRange::aEnd, ScRange::aStart, COL2_ABS, COL_ABS, ScGlobal::FindUnquoted(), ScRange::Parse(), ROW2_ABS, ROW_ABS, SC_COMPILER_FILE_TAB_SEP, ScAddress::ScAddress(), ScRefAddress::Set(), TAB2_ABS, TAB_ABS, VALID, and ZERO.

Referenced by ScRangeUtil::IsAbsArea(), lcl_Parse(), ScRangeUtil::MakeArea(), ScInterpreter::ScIndirect(), and ScPivotLayoutDialog::UpdateSourceRange().

ConvertSingleRef()

bool ConvertSingleRef	(	const ScDocument &	pDocument,
		const OUString &	rRefString,
		SCTAB	nDefTab,
		ScRefAddress &	rRefAddress,
		const ScAddress::Details &	rDetails,
		ScAddress::ExternalInfo *	pExtInfo = nullptr
	)

Definition at line 1489 of file address.cxx.

References COL_ABS, ScGlobal::FindUnquoted(), ScAddress::Parse(), ROW_ABS, SC_COMPILER_FILE_TAB_SEP, ScRefAddress::Set(), TAB_ABS, VALID, and ZERO.

Referenced by IMPL_LINK(), ScRangeUtil::IsAbsPos(), ScRangeUtil::IsAbsTabArea(), lcl_Parse(), and ScInterpreter::ScIndirect().

MAXCOL_JUMBO_STRING()

constexpr OUStringLiteral MAXCOL_JUMBO_STRING ( u"XFD"  )

inlineconstexpr

Referenced by ScSheetLimits::MaxColAsString().

MAXCOL_STRING()

constexpr OUStringLiteral MAXCOL_STRING ( u"XFD"  )

inlineconstexpr

Referenced by ScSheetLimits::MaxColAsString().

MAXROW_JUMBO_STRING()

constexpr OUStringLiteral MAXROW_JUMBO_STRING ( u"16777215"  )

inlineconstexpr

Referenced by ScSheetLimits::MaxRowAsString().

MAXROW_STRING()

constexpr OUStringLiteral MAXROW_STRING ( u"1048575"  )

inlineconstexpr

Referenced by ScSheetLimits::MaxRowAsString().

operator<<() [1/2]

template<typename charT , typename traits >

std::basic_ostream< charT, traits > & operator<< ( std::basic_ostream< charT, traits > &  stream, const ScAddress &  rAddress  )

inline

Definition at line 206 of file address.hxx.

References SAL_WARN_UNUSED.

operator<<() [2/2]

template<typename charT , typename traits >

std::basic_ostream< charT, traits > & operator<< ( std::basic_ostream< charT, traits > &  stream, const ScRange &  rRange  )

inline

Definition at line 494 of file address.hxx.

References SAL_WARN_UNUSED.

PutInOrder()

template<typename T >

void PutInOrder ( T &  nStart, T &  nEnd  )

inline

Definition at line 150 of file address.hxx.

Referenced by ScConsData::AddData(), ScTable::ApplyBlockFrame(), ScTable::ApplyPatternArea(), ScTable::ApplyStyleArea(), ScDocument::AutoFormat(), ScDocument::CanInsertCol(), ScDocument::CanInsertRow(), sc::FormulaGroupAreaListener::collectFormulaCells(), ScDocument::CopyTabToClip(), ScTable::CreateQueryParam(), ScTabViewShell::CreateRefDialogController(), ScDocument::DeleteArea(), ScDocument::DeleteAreaTab(), ScDocument::DeleteCol(), ScDocument::DeleteRow(), ScInterpreter::DoubleRefToVars(), ScGridWindow::Draw(), ScOutputData::DrawOneChange(), ScOutputData::DrawRefMark(), ScDocument::ExtendMerge(), ScDocument::ExtendOverlapped(), ScDocument::Fill(), ScTable::FillAuto(), ScTable::FillFormulaVertical(), ScOutputData::FillReferenceMark(), ScTable::FillSeries(), ScDocument::GetAutoFormatData(), ScDocument::GetEmptyLinesInBlock(), ScMultiSel::GetNextMarked(), ScGridWindow::GetRectsAnyFor(), ScInputHandler::GetReferenceMark(), ScMarkData::GetSelectionCover(), ScCellIterator::init(), ScTpUserLists::Init(), ScDocument::InsertCol(), ScDocument::InsertMatrixFormula(), ScDocument::InsertRow(), ScDocument::InsertTableOp(), lcl_AddRanges(), ScTable::MergeBlockFrame(), ScDataTableView::MouseButtonUp(), ScTabView::PaintArea(), ScInterpreter::ScConcat_MS(), ScHorizontalValueIterator::ScHorizontalValueIterator(), ScRange::ScRange(), ScInterpreter::ScTextJoin_MS(), ScUpdateRect::ScUpdateRect(), ScHeaderControl::SetMark(), ScMarkData::SetMultiMarkArea(), ScUpdateRect::SetNew(), ScTabView::ShowRefTip(), ScTable::ShrinkToUsedDataArea(), ScDocument::UndoToDocument(), ScTabViewShell::UpdateInputHandler(), ScInputHandler::UpdateLokReferenceMarks(), and ScTabView::UpdateRef().

SanitizeCol()

SCCOL SanitizeCol ( SCCOL  nCol, SCCOL  nMaxCol  )

inline

Definition at line 133 of file address.hxx.

References MAXCOL, and MAXCOL_JUMBO.

Referenced by ScDocument::SanitizeCol(), and ScSheetLimits::SanitizeCol().

SanitizeRow()

SCROW SanitizeRow ( SCROW  nRow, SCROW  nMaxRow  )

inline

Definition at line 139 of file address.hxx.

References MAXROW, and MAXROW_JUMBO.

Referenced by ScDocument::SanitizeRow(), and ScSheetLimits::SanitizeRow().

SanitizeTab()

SCTAB SanitizeTab ( SCTAB  nTab )

inline

Definition at line 145 of file address.hxx.

References MAXTAB.

Referenced by ImportLotus::NamedSheet(), OP_ApplyPatternArea123(), PutFormString(), and SetFormat().

ScColToAlpha() [1/3]

void ScColToAlpha ( OUString &  rStr, SCCOL  nCol  )

inline

Definition at line 961 of file address.hxx.

References aBuf, and ScColToAlpha().

ScColToAlpha() [2/3]

SC_DLLPUBLIC void ScColToAlpha	(	OUStringBuffer &	rBuffer,
		SCCOL	nCol
	)

append alpha representation of column to buffer

Definition at line 1884 of file address.cxx.

References lcl_ScColToAlpha(), and ScAddress::nCol.

Referenced by ScAccessiblePreviewHeaderCell::createAccessibleName(), ScFilterDlg::FillFieldLists(), ScPivotFilterDlg::FillFieldLists(), ScTabPageSortFields::FillFieldLists(), ScTpSubTotalGroup::FillListBoxes(), ScTableColumnsObj::getElementNames(), ScColBar::GetEntryText(), ScTableColumnObj::getName(), ScChangeAction::GetRefString(), IMPL_LINK_NOARG(), ScPrintFunc::PrintColHdr(), ScColToAlpha(), SCNAV_COLLETTERS(), and ScTabView::ScrollHdl().

ScColToAlpha() [3/3]

OUString ScColToAlpha ( SCCOL  nCol )

inline

Definition at line 968 of file address.hxx.

References aBuf, and ScColToAlpha().

ValidAddress()

bool ValidAddress ( const ScAddress &  rAddress, SCCOL  nMaxCol, SCROW  nMaxRow  )

inline

Definition at line 488 of file address.hxx.

References ScAddress::Col(), ScAddress::Row(), ScAddress::Tab(), ValidCol(), ValidRow(), and ValidTab().

Referenced by ScDocument::ValidAddress(), ScSheetLimits::ValidAddress(), and ValidRange().

ValidCol()

bool ValidCol ( SCCOL  nCol, SCCOL  nMaxCol  )

inline

Definition at line 99 of file address.hxx.

References MAXCOL, and MAXCOL_JUMBO.

Referenced by ScTable::GetOriginalWidth(), XclImpColRowSettings::HideCol(), XclImpColRowSettings::SetDefaultXF(), ValidAddress(), ScDocument::ValidCol(), ScSheetLimits::ValidCol(), ValidColRow(), ValidColRowTab(), and ScEEImport::WriteToDocument().

ValidColRow()

bool ValidColRow ( SCCOL  nCol, SCROW  nRow, SCCOL  nMaxCol, SCROW  nMaxRow  )

inline

Definition at line 121 of file address.hxx.

References MAXROW, MAXROW_JUMBO, ValidCol(), and ValidRow().

Referenced by ImportExcel::Array25(), ImportExcel::Array34(), ImportExcel::TableOp(), ScDocument::ValidColRow(), and ScSheetLimits::ValidColRow().

ValidColRowTab()

bool ValidColRowTab ( SCCOL  nCol, SCROW  nRow, SCTAB  nTab, SCCOL  nMaxCol, SCROW  nMaxRow  )

inline

Definition at line 127 of file address.hxx.

References MAXROW, MAXROW_JUMBO, ValidCol(), ValidRow(), and ValidTab().

Referenced by ScDocument::ValidColRowTab(), and ScSheetLimits::ValidColRowTab().

ValidRange()

bool ValidRange ( const ScRange &  rRange, SCCOL  nMaxCol, SCROW  nMaxRow  )

inline

Definition at line 786 of file address.hxx.

References ScRange::aEnd, ScRange::aStart, and ValidAddress().

Referenced by ScDocument::ValidRange(), and ScSheetLimits::ValidRange().

ValidRow()

bool ValidRow ( SCROW  nRow, SCROW  nMaxRow  )

inline

Definition at line 105 of file address.hxx.

References MAXROW, and MAXROW_JUMBO.

Referenced by ScColumn::AttachFormulaCells(), ScColumn::CollectFormulaCells(), ScColumn::CollectListeners(), ScColumn::ConvertFormulaToValue(), ScColumn::CopyCellValuesFrom(), ScColumn::DeleteSparkline(), ScColumn::DetachFormulaCells(), ScColumn::EndListeningIntersectedGroup(), ScColumn::EnsureFormulaCellResults(), ScColumn::ForgetNoteCaptions(), ScColumn::GetBlockMatrixEdges(), ScColumn::GetColumnIterator(), ScColumn::GetFormulaCellBlockAddress(), ScTable::GetOriginalHeight(), ScColumn::GetRangeScriptType(), ScColumn::GetScriptType(), ScColumn::HasFormulaCell(), ScDPCache::InitFromDoc(), ScColumn::InterpretCellsIfNeeded(), ScColumn::InterpretDirtyCells(), ScColumn::IsFormulaDirty(), ScColumn::MoveTo(), ScColumn::ReleaseNote(), ImportExcel::Row25(), ScColumn::SetError(), ScColumn::SetFormulaCells(), XclImpColRowSettings::SetHeight(), XclImpColRowSettings::SetManualRowHeight(), ScColumn::SetRawString(), XclImpColRowSettings::SetRowSettings(), ScColumn::SetScriptType(), ScColumn::SetString(), ScColumn::SetValue(), ScColumn::SetValues(), ScColumn::StartListening(), ScColumn::TransferCellValuesTo(), ScColumn::UpdateScriptTypes(), ValidAddress(), ValidColRow(), ValidColRowTab(), ScDocument::ValidRow(), and ScSheetLimits::ValidRow().

ValidTab() [1/2]

bool ValidTab ( SCTAB  nTab )

inline

Definition at line 111 of file address.hxx.

References MAXTAB.

Referenced by ScDocument::AddCondFormat(), ScViewData::AddPixelsWhile(), ScDocument::AddPrintRange(), ScDocumentImport::appendSheet(), ScDocument::AppendTabOnLoad(), ScDocument::ApplyAttr(), ScDocument::ApplyFlagsTab(), ScDocument::ApplyPattern(), ScDocument::ApplyPatternAreaTab(), ScDocument::ApplyStyle(), ScDocument::ApplyStyleAreaTab(), ScDocument::ClearPrintRanges(), ScDocument::ColFiltered(), ScDocument::ColHidden(), ScDocument::CompareDocument(), ExcelToSc::Convert(), ExcelToSc8::Convert(), ScDocument::CopyScenario(), ScDocument::CopyTab(), ScDocument::CopyTabProtection(), ScDocument::CopyToDocument(), ScDocument::CountNonFilteredRows(), ScDocument::CountVisibleRows(), ScDocument::CreateSparkline(), ScDocument::DeleteAreaTab(), ScDocument::DeleteConditionalFormat(), ScDocument::DeleteSelectionTab(), ScDocument::DeleteTab(), ScDocument::DeleteTabs(), ScViewData::DeriveLOKFreezeIfNeeded(), ScDocument::DoAutoOutline(), ScDocument::DoSubTotals(), ScDocument::EndListeningCell(), ScDocShell::Execute(), ScXMLExport::ExportCellTextAutoStyles(), ScDocument::ExtendHidden(), ScDocument::ExtendMerge(), ScDocument::ExtendOverlapped(), ScDocument::ExtendPrintArea(), ScModelObj::FillRenderMarkData(), ScDocument::FillTab(), ScDocument::FillTabMarked(), ScDocument::FindAreaPos(), ScDocument::FindMaxRotCol(), ScCellIterator::first(), ScRangeListTabs::First(), ScDocument::FirstNonFilteredRow(), ScDocument::FirstVisibleRow(), ExcelToSc::GetAbsRefs(), ExcelToSc8::GetAbsRefs(), ScDocument::GetAllColBreaks(), ScDocument::GetAllRowBreaks(), ScDocument::GetAnonymousDBData(), ScDocument::GetAttr(), ScDocument::GetAutoFormatData(), ScDocument::GetCellArea(), ScDocument::GetCellType(), ScDocument::GetCodeName(), ScDocument::GetColFlags(), ScDocument::GetColOffset(), ScDocument::GetColWidth(), ScDocument::GetCommonWidth(), ScDocument::GetCondFormList(), ScDocument::GetCopyTabName(), ScViewData::GetCurXForTab(), ScViewData::GetCurYForTab(), ScDocument::GetDataArea(), ScDocument::GetDataAreaSubrange(), ScDocument::GetDataEntries(), ScDocument::GetDataStart(), ScDocument::GetEmptyLinesInBlock(), ScDocument::GetFilterEntries(), ScDocument::GetFilterEntriesArea(), ScDocument::GetFilterSelCount(), ScDocument::GetFormula(), ScDocument::GetHashCode(), ScDocument::GetHiddenRowCount(), ScDocument::GetInputString(), ScDocument::GetLastChangedColFlagsWidth(), ScDocument::GetLastChangedRowFlagsWidth(), ScDocument::GetLastFlaggedRow(), ScDocument::GetLinkDoc(), ScDocument::GetLinkFlt(), ScDocument::GetLinkMode(), ScDocument::GetLinkOpt(), ScDocument::GetLinkRefreshDelay(), ScDocument::GetLinkTab(), ScViewData::GetLOKHeightHelper(), ScViewData::GetLOKWidthHelper(), ScDocument::GetMaxNumberStringLen(), ScDocument::GetMaxStringLen(), ScDocument::GetMMRect(), ScDocument::GetMostUsedPattern(), ScDocument::GetName(), ScDocument::GetNeededSize(), ScDocument::GetNextDifferentChangedColFlagsWidth(), ScDocument::GetNextDifferentChangedRowFlagsWidth(), ScDocument::GetNextMarkedCell(), ScDocument::GetNextPos(), ScDocument::GetNextSpellingCell(), ScDocument::GetNote(), ScDocument::GetNumberFormat(), ScDocument::GetOptimalColWidth(), ScDocument::GetOriginalHeight(), ScDocument::GetOriginalWidth(), ScDocument::GetOutlineTable(), ScDocument::GetPageSize(), ScDocument::GetPageStyle(), ScDocument::GetPatternCount(), ScViewData::GetPosFromPixel(), ScViewData::GetPosX(), ScViewData::GetPosY(), ScDocument::GetPrintArea(), ScDocument::GetPrintAreaHor(), ScDocument::GetPrintAreaVer(), ScDocument::GetPrintRange(), ScDocument::GetPrintRangeCount(), ScDocument::GetRangeName(), ScDocument::GetRepeatColRange(), ScDocument::GetRepeatRowRange(), ScDocument::GetRowBreakData(), ScDocument::GetRowBreakIterator(), ScDocument::GetRowFlags(), ScDocument::GetRowHeight(), ScDocument::GetRowOffset(), ScDocument::GetScaledRowHeight(), ScDocument::GetScenarioData(), ScDocument::GetScenarioFlags(), ScDocument::GetScenarioRanges(), ScDocument::GetScriptType(), ScViewData::GetScrPos(), ScDocument::GetSheetEvents(), ScDocument::GetSparkline(), ScDocument::GetStyle(), ScDocument::GetTabBgColor(), ScDocument::GetTableArea(), ScDocument::GetTabProtection(), ScDocument::GetTextWidth(), ScDocument::GetUpperCellString(), ScDocument::HasCalcNotification(), ScDocument::HasColBreak(), ScDocument::HasColHeader(), ScDocument::HasData(), ScDocument::HasFilteredRows(), ScDocument::HasHiddenRows(), ScDocument::HasManualBreaks(), ScDocument::HasRowBreak(), ScDocument::HasRowHeader(), ScDocument::HasScenarioRange(), ScDocument::HasStringData(), ScDocument::HasTable(), ScDocument::HasValueData(), ScDocument::IdleCalcTextWidth(), ScCellIterator::init(), ScDocument::InsertTab(), ScDocument::InsertTabs(), ScDocument::InvalidatePageBreaks(), ScDocument::IsActiveScenario(), ScDocument::IsBlockEditable(), ScDocument::IsBlockEmpty(), ScTable::IsColRowTabValid(), ScDocument::IsDefaultTabBgColor(), ScDocument::IsEmptyData(), ScDocument::IsLayoutRTL(), ScDocument::IsLinked(), ScDocument::IsManualRowHeight(), ScDocument::IsPendingRowHeights(), ScDocument::IsPrintEntireSheet(), ScDocument::IsScenario(), ScDocument::IsStreamValid(), ScDocument::IsTabProtected(), ScDocument::IsVisible(), ScDocument::LastNonFilteredRow(), ScDocument::LastVisibleRow(), ScDocument::LimitChartArea(), ScDocument::LimitRangeToAvailableSheets(), ScDocument::LockTable(), ScDocument::MakeTable(), ScDocument::MarkScenario(), ScPreview::MouseButtonUp(), ScDocument::MoveTab(), ScDrawView::Notify(), OP_SheetName123(), ScDocument::PageStyleModified(), ScDocShell::PageStyleModified(), ScDocument::PrepareQuery(), ScDocument::Query(), ScDocument::RemoveColBreak(), ScDocument::RemoveFlagsTab(), ScDocument::RemoveManualBreaks(), ScDocument::RemoveRowBreak(), ScDocument::RemoveSubTotals(), ScDocument::RenameTab(), ScDocument::ReservePatternCount(), ScDocument::RowFiltered(), ScDocument::RowHidden(), ScAttrRectIterator::ScAttrRectIterator(), ScDocAttrIterator::ScDocAttrIterator(), ScHorizontalValueIterator::ScHorizontalValueIterator(), ScValueIterator::ScValueIterator(), ScDocument::SearchAndReplace(), sc::ColumnSpanSet::set(), ScDocument::SetActiveScenario(), ScSingleRefData::SetAddress(), ScDocument::SetAnonymousDBData(), ScDocument::SetCalcNotification(), ScDocument::SetCodeName(), ScDocument::SetColBreak(), ScDocument::SetColHidden(), ScDocument::SetColWidth(), ScDocument::SetColWidthOnly(), ScDocument::SetCondFormList(), ScViewData::SetCurXForTab(), ScViewData::SetCurYForTab(), ScDocument::SetDrawPageSize(), ScDocument::SetError(), ScDocument::SetLayoutRTL(), ScDocument::SetLink(), ScViewData::SetLOKSheetFreezeIndex(), ScDocument::SetManualHeight(), ScDocument::SetNote(), ScDocument::SetOutlineTable(), ScDocument::SetPageSize(), ScDocument::SetPageStyle(), ScDocument::SetPattern(), ScDocument::SetPendingRowHeights(), ScDocument::SetPrintEntireSheet(), ScDocument::SetRangeName(), ScDocument::SetRepeatArea(), ScDocument::SetRepeatColRange(), ScDocument::SetRepeatRowRange(), ScDocument::SetRowBreak(), ScDocument::SetRowFiltered(), ScDocument::SetRowFlags(), ScDocument::SetRowHeight(), ScDocument::SetRowHeightOnly(), ScDocument::SetRowHeightRange(), ScDocument::SetRowHidden(), ScDocument::SetScenario(), ScDocument::SetScenarioData(), ScDocument::SetScriptType(), ScDocument::SetSheetEvents(), ScDocument::SetStreamValid(), ScDocument::SetTabBgColor(), ScDocument::SetTabNameOnLoad(), ScViewData::SetTabNo(), ScTabView::SetTabNo(), ScDocument::SetTabProtection(), ScDocument::SetVisible(), ScDocument::ShowCol(), ScDocument::ShowRow(), ScDocument::ShowRows(), ScDocument::ShrinkToDataArea(), ScDocument::ShrinkToUsedDataArea(), ScInterpreter::SingleRefToVars(), ScDocument::Solver(), ScDocument::Sort(), ScDocument::StartListeningCell(), ScDocument::StripHidden(), ScDocument::TableExists(), ScDocument::TestCopyScenario(), ScDocument::TestRemoveSubTotals(), ScSingleRefData::toAbs(), ScDocument::TransferTab(), ScDocument::UndoToDocument(), ScDocument::UnlockTable(), ScDocRowHeightUpdater::update(), ScDocRowHeightUpdater::updateAll(), ScViewData::UpdateFixX(), ScViewData::UpdateFixY(), ScDocument::UpdateOutlineCol(), ScDocument::UpdateOutlineRow(), ScDocument::UpdatePageBreaks(), ScDocShell::UseScenario(), ValidAddress(), and ValidColRowTab().

ValidTab() [2/2]

bool ValidTab ( SCTAB  nTab, SCTAB  nMaxTab  )

inline

Definition at line 116 of file address.hxx.

Variable Documentation

INITIALCOLCOUNT

const SCCOL INITIALCOLCOUNT = 1

Definition at line 64 of file address.hxx.

MAXCOL

const SCCOL MAXCOL = MAXCOLCOUNT - 1

Definition at line 69 of file address.hxx.

Referenced by ScInputHandler::CancelHandler(), ScSheetLimits::CreateDefault(), ScExternalRefCache::getCellRangeData(), ScDPTableData::GetMembersCount(), ScSheetLimits::MaxColAsString(), MaxDocRange(), SanitizeCol(), ScExternalRefCache::Table::setWholeTableCached(), ScOutlineTable::TestInsertCol(), and ValidCol().

MAXCOL_JUMBO

const SCCOL MAXCOL_JUMBO = MAXCOLCOUNT_JUMBO - 1

Definition at line 75 of file address.hxx.

Referenced by ScSheetLimits::CreateDefault(), SanitizeCol(), and ValidCol().

MAXCOLCOUNT

const SCCOL MAXCOLCOUNT = 16384

Definition at line 63 of file address.hxx.

Referenced by ScInterpreter::CreateCellArr(), ScInterpreter::CreateDoubleArr(), ScDPSource::CreateRes_Impl(), ScInterpreter::CreateStringArr(), ScCsvGrid::FillColumnDataFix(), and ScOrcusSheet::get_sheet_size().

MAXCOLCOUNT_JUMBO

const SCCOL MAXCOLCOUNT_JUMBO = 16384

Definition at line 73 of file address.hxx.

Referenced by ScInterpreter::CreateCellArr(), ScInterpreter::CreateDoubleArr(), ScInterpreter::CreateStringArr(), and sc::FormulaGroupContext::ColKey::Hash::operator()().

MAXCOLROW

const SCCOLROW MAXCOLROW = MAXROW

Definition at line 71 of file address.hxx.

MAXINITTAB

const SCTAB MAXINITTAB = 1024

Definition at line 81 of file address.hxx.

Referenced by ScTpDefaultsOptions::CheckNumSheets().

MAXROW

const SCROW MAXROW = MAXROWCOUNT - 1

Definition at line 68 of file address.hxx.

Referenced by ScSheetLimits::CreateDefault(), ScExternalRefCache::getCellRangeData(), ScDPFilteredCache::isRowActive(), MaxDocRange(), ScSheetLimits::MaxRowAsString(), SanitizeRow(), ScExternalRefCache::Table::setWholeTableCached(), ScOutlineTable::TestInsertRow(), ValidColRow(), ValidColRowTab(), and ValidRow().

MAXROW_30

const SCROW MAXROW_30 = 8191

Definition at line 97 of file address.hxx.

Referenced by ImportExcel::TableOp(), and ScViewData::WriteUserData().

MAXROW_JUMBO

const SCROW MAXROW_JUMBO = MAXROWCOUNT_JUMBO - 1

Definition at line 74 of file address.hxx.

Referenced by ScSheetLimits::CreateDefault(), SanitizeRow(), ValidColRow(), ValidColRowTab(), and ValidRow().

MAXROWCOUNT

const SCROW MAXROWCOUNT = 1048576

Definition at line 62 of file address.hxx.

Referenced by ScOrcusSheet::get_sheet_size(), and GetElementsMax().

MAXROWCOUNT_JUMBO

const SCROW MAXROWCOUNT_JUMBO = 16 * 1024 * 1024

Definition at line 72 of file address.hxx.

MAXTAB

const SCTAB MAXTAB = MAXTABCOUNT - 1

Definition at line 70 of file address.hxx.

Referenced by ScLabelRangesObj::addNew(), ScRangeListTabs::Append(), ScChangeTrack::AppendContentsIfInRefDoc(), ExcScenario::Apply(), ScDocument::CompareDocument(), ScChangeTrack::ConfigurationChanged(), ScDocument::CopyBlockFromClip(), ScDocument::CopyTab(), ScViewData::CopyTab(), ScChart2DataProvider::createDataSource(), ScXMLBodyContext::createFastChildContext(), ScDocument::CreateValidTabName(), ScDocFunc::DeleteCells(), ScViewFunc::DeleteMulti(), ScDocument::DeleteTab(), ScDocument::DeleteTabs(), ScUndoImportTab::DoChange(), ScUndoMoveTab::DoChange(), ScUndoFillTable::DoChange(), ScUndoModifyStyle::DoChange(), ScCellShell::Execute(), ScTabViewShell::ExecuteTable(), ExcTable::FillAsTableBinary(), ExcTable::FillAsTableXml(), ScTabViewShell::GetStateTable(), ScDocument::HasNotes(), ScViewFunc::HideTable(), IMPL_LINK_NOARG(), ScViewFunc::ImportTables(), ScCellIterator::init(), ScInsertTableDlg::Init_Impl(), ScDocFunc::InsertCells(), ScDetectiveFunc::InsertSuccLevel(), ScDocument::InsertTab(), ScViewFunc::InsertTableLink(), ScDocument::InsertTabs(), ScDocument::InvalidateTextWidth(), ScRangeUtil::IsAbsArea(), ScRangeUtil::IsAbsPos(), ScDocumentImportImpl::isValid(), ScDocDefaultsObj::ItemsChanged(), lcl_InvalidateReference(), ScDocShell::LoadStyles(), ScDocShell::LoadStylesArgs(), ScBigAddress::MakeAddress(), ScDBFunc::MakePivotTable(), ScLabelRangeObj::Modify_Impl(), ScDBDocFunc::ModifyAllDBData(), ScDocument::ModifyStyleSheet(), ScAddress::Move(), ScViewFunc::MoveTable(), ScDocShell::PageStyleModified(), ScDocShell::PostPaintExtras(), ScDocShell::PostPaintGridAll(), ScUndoCopyTab::Redo(), ScAreaLink::Refresh(), ScTableLink::Refresh(), ScDocShell::ReloadTabLinks(), ScLabelRangesObj::removeByIndex(), ScStyleFamilyObj::removeByName(), ScViewFunc::RemoveStyleSheetInUse(), SanitizeTab(), ScHorizontalValueIterator::ScHorizontalValueIterator(), ScSingleRefData::SetAddress(), ScStyleObj::setAllPropertiesToDefault(), ScDocFunc::SetLayoutRTL(), ScXMLChangeTrackingImportHelper::SetNewCell(), ScStyleSheet::SetParent(), ScStyleObj::setParentStyle(), ScDocShell::SetPrinter(), ScStyleObj::setPropertyValue_Impl(), ScDocFunc::SetTableVisible(), ScPivotLayoutDialog::SetupDestination(), ScDocShell::SetVisAreaOrSize(), ScViewFunc::ShowTable(), ScSingleRefData::TabValid(), ScUndoReplace::Undo(), ScUndoDeleteTab::Undo(), ScUndoCopyTab::Undo(), ScUndoMakeScenario::Undo(), ScDocument::UndoToDocument(), ScTable::UpdateDeleteTab(), ScTable::UpdateInsertTab(), ScTable::UpdateMoveTab(), ScViewFunc::UpdateStyleSheetInUse(), ScDocument::UpdateTranspose(), ScDocShell::UseScenario(), and ValidTab().

MAXTABCOUNT

const SCTAB MAXTABCOUNT = 10000

limiting to 10000 for now, problem with 32 bit builds for now

Definition at line 66 of file address.hxx.

Referenced by XclImpPivotCache::ReadPivotCacheStream().

MAXTILEDROW

const SCROW MAXTILEDROW = MAXROW

Definition at line 77 of file address.hxx.

Referenced by ScTabView::getSheetGeometryData(), ScGridWindow::HandleMouseButtonDown(), ScTabView::MoveCursorAbs(), ScGridWindow::PaintTile(), ScTabView::SetCursor(), ScPositionHelper::setDocument(), and ScViewData::SetMaxTiledRow().

MININITTAB

const SCTAB MININITTAB = 1

Definition at line 82 of file address.hxx.

Referenced by ScTpDefaultsOptions::CheckNumSheets().

SC_TAB_APPEND

const SCTAB SC_TAB_APPEND = SCTAB_MAX

Definition at line 90 of file address.hxx.

Referenced by ScViewFunc::AppendTable(), ScDocument::CopyTab(), ScViewData::CopyTab(), XclExpChangeTrack::CreateTempChangeTrack(), ScTabViewShell::ExecuteTable(), IMPL_LINK_NOARG(), ScDocument::InsertTab(), ScDocument::InsertTabs(), ScDocument::LinkExternalTab(), ScDocShell::MergeSharedDocument(), ScDocument::MoveTab(), ScViewData::MoveTab(), ScViewFunc::MoveTable(), and ScDocShell::MoveTable().

SC_TABSTART_NONE

const SCCOL SC_TABSTART_NONE = SCCOL_MAX

Definition at line 95 of file address.hxx.

Referenced by ScTabView::CursorPosChanged(), ScTabView::FindNextUnprot(), ScTable::GetNextPos(), ScTabView::MoveCursorEnter(), and ScViewData::ScViewData().

SCCOL_MAX

const SCCOL SCCOL_MAX = ::std::numeric_limits<SCCOL>::max()

Definition at line 56 of file address.hxx.

Referenced by ScSubTotalDescriptorBase::addNew(), ScHTMLLayoutParser::Adjust(), ScHTMLLayoutParser::Colonize(), ScHTMLTable::RecalcDocPos(), ScDataAreaExtras::resetArea(), ScFormatFilterPluginImpl::ScImportDif(), ScRedlinData::ScRedlinData(), ScSubTotalFieldObj::setSubTotalColumns(), and ScGridWindow::UpdateDragRect().

SCCOL_REPEAT_NONE

const SCCOL SCCOL_REPEAT_NONE = SCCOL_MAX

Definition at line 93 of file address.hxx.

Referenced by ScPrintFunc::InitParam(), and ScTable::UpdatePageBreaks().

SCCOLROW_MAX

const SCCOLROW SCCOLROW_MAX = ::std::numeric_limits<SCCOLROW>::max()

Definition at line 58 of file address.hxx.

SCROW_MAX

const SCROW SCROW_MAX = ::std::numeric_limits<SCROW>::max()

Definition at line 55 of file address.hxx.

Referenced by ScHTMLLayoutParser::Colonize(), XclImpColRowSettings::ConvertHiddenFlags(), ScDocument::FindOrder(), ScHTMLTable::RecalcDocPos(), ScDataAreaExtras::resetArea(), ScRedlinData::ScRedlinData(), ScGridWindow::UpdateDragRect(), and ScEEImport::WriteToDocument().

SCROW_REPEAT_NONE

const SCROW SCROW_REPEAT_NONE = SCROW_MAX

Definition at line 94 of file address.hxx.

Referenced by ScPrintFunc::InitParam(), and ScTable::UpdatePageBreaks().

SCROWS32K

const SCROW SCROWS32K = 32000

Definition at line 92 of file address.hxx.

SCSIZE_MAX

const SCSIZE SCSIZE_MAX = ::std::numeric_limits<SCSIZE>::max()

Definition at line 59 of file address.hxx.

Referenced by ScInterpreter::CalculateLookup(), ScTable::CreateExcelQuery(), ScDBData::GetFilterSelCount(), ScCellShell::GetState(), and lcl_LUP_solve().

SCTAB_MAX

const SCTAB SCTAB_MAX = ::std::numeric_limits<SCTAB>::max()

Definition at line 57 of file address.hxx.

Referenced by ScTokenArray::AdjustReferenceOnDeletedTab(), ScRangeListTabs::Append(), ScQueryParam::Clear(), ScMyNotEmptyCellsIterator::Clear(), ScDocument::CompareDocument(), ScTable::CreateExcelQuery(), ScTable::CreateStarQuery(), oox::xls::SheetDataBuffer::finalizeImport(), XclImpName::IsGlobal(), ScRedlinData::ScRedlinData(), ScDocShell::UseScenario(), ScXMLExportDataPilot::WriteDPFilter(), and XclImpName::XclImpName().

TABLEID_DOC

const SCTAB TABLEID_DOC = SCTAB_MAX

Definition at line 91 of file address.hxx.

Referenced by ScTabViewShell::Execute(), ScModelObj::protect(), ScDocFunc::Protect(), ScViewFunc::ProtectDoc(), ScViewFunc::ProtectSheet(), ScModelObj::unprotect(), ScViewFunc::Unprotect(), and ScDocFunc::Unprotect().