#include <validat.hxx>

Inheritance diagram for ScValidationData:

Collaboration diagram for ScValidationData:

Classes
struct	CustomValidationPrivateAccess

Public Member Functions
	ScValidationData (ScValidationMode eMode, ScConditionMode eOper, const OUString &rExpr1, const OUString &rExpr2, ScDocument &rDocument, const ScAddress &rPos, const OUString &rExprNmsp1=EMPTY_OUSTRING, const OUString &rExprNmsp2=EMPTY_OUSTRING, formula::FormulaGrammar::Grammar eGrammar1=formula::FormulaGrammar::GRAM_DEFAULT, formula::FormulaGrammar::Grammar eGrammar2=formula::FormulaGrammar::GRAM_DEFAULT)

	ScValidationData (ScValidationMode eMode, ScConditionMode eOper, const ScTokenArray pArr1, const ScTokenArray pArr2, ScDocument &rDocument, const ScAddress &rPos)

	ScValidationData (const ScValidationData &r)

	ScValidationData (ScDocument &rDocument, const ScValidationData &r)

virtual	~ScValidationData () override

ScValidationData *	Clone () const

ScValidationData *	Clone (ScDocument *pNew) const override

void	ResetInput ()

void	ResetError ()

void	SetInput (const OUString &rTitle, const OUString &rMsg)

void	SetError (const OUString &rTitle, const OUString &rMsg, ScValidErrorStyle eStyle)

bool	GetInput (OUString &rTitle, OUString &rMsg) const

bool	GetErrMsg (OUString &rTitle, OUString &rMsg, ScValidErrorStyle &rStyle) const

bool	HasErrMsg () const

ScValidationMode	GetDataMode () const

sal_Int16	GetListType () const

void	SetListType (sal_Int16 nListType)

bool	HasSelectionList () const
	Returns true, if the validation cell will show a selection list. More...

bool	FillSelectionList (std::vector< ScTypedStrData > &rStrings, const ScAddress &rPos) const
	Tries to fill the passed collection with list validation entries. More...

bool	IsDataValid (const OUString &rTest, const ScPatternAttr &rPattern, const ScAddress &rPos) const

bool	IsDataValidCustom (const OUString &rTest, const ScPatternAttr &rPattern, const ScAddress &rPos, const CustomValidationPrivateAccess &) const

bool	IsDataValid (ScRefCellValue &rCell, const ScAddress &rPos) const

bool	DoError (weld::Window *pParent, const OUString &rInput, const ScAddress &rPos) const

void	DoCalcError (ScFormulaCell *pCell) const

bool	IsEmpty () const

sal_uInt32	GetKey () const

void	SetKey (sal_uInt32 nNew)

bool	EqualEntries (const ScValidationData &r) const

bool	operator< (const ScValidationData &r) const

Public Member Functions inherited from ScConditionEntry
	ScConditionEntry (ScConditionMode eOper, const OUString &rExpr1, const OUString &rExpr2, ScDocument &rDocument, const ScAddress &rPos, const OUString &rExprNmsp1, const OUString &rExprNmsp2, formula::FormulaGrammar::Grammar eGrammar1, formula::FormulaGrammar::Grammar eGrammar2, Type eType=Type::Condition)

	ScConditionEntry (ScConditionMode eOper, const ScTokenArray pArr1, const ScTokenArray pArr2, ScDocument &rDocument, const ScAddress &rPos)

	ScConditionEntry (const ScConditionEntry &r)

	ScConditionEntry (ScDocument &rDocument, const ScConditionEntry &r)

virtual	~ScConditionEntry () override

bool	IsEqual (const ScFormatEntry &r, bool bIgnoreSrcPos) const override

virtual void	SetParent (ScConditionalFormat *pNew) override

bool	IsCellValid (ScRefCellValue &rCell, const ScAddress &rPos) const

ScConditionMode	GetOperation () const

void	SetOperation (ScConditionMode eMode)

bool	IsIgnoreBlank () const

void	SetIgnoreBlank (bool bSet)

const OUString &	GetSrcString () const

const ScAddress &	GetSrcPos () const

ScAddress	GetValidSrcPos () const
	Return a position that's adjusted to allow textual representation of expressions if possible. More...

void	SetSrcString (const OUString &rNew)

void	SetFormula1 (const ScTokenArray &rArray)

void	SetFormula2 (const ScTokenArray &rArray)

OUString	GetExpression (const ScAddress &rCursor, sal_uInt16 nPos, sal_uInt32 nNumFmt=0, const formula::FormulaGrammar::Grammar eGrammar=formula::FormulaGrammar::GRAM_DEFAULT) const

std::unique_ptr< ScTokenArray >	CreateFlatCopiedTokenArray (sal_uInt16 nPos) const
	Create a flat copy using ScTokenArray copy-ctor with shared tokens. More...

void	CompileAll ()
	Delete formula cells, so we re-compile at the next IsValid. More...

void	CompileXML ()

virtual void	UpdateReference (sc::RefUpdateContext &rCxt) override

virtual void	UpdateInsertTab (sc::RefUpdateInsertTabContext &rCxt) override

virtual void	UpdateDeleteTab (sc::RefUpdateDeleteTabContext &rCxt) override

virtual void	UpdateMoveTab (sc::RefUpdateMoveTabContext &rCxt) override

bool	MarkUsedExternalReferences () const

virtual Type	GetType () const override

virtual void	endRendering () override

virtual void	startRendering () override

bool	NeedsRepaint () const

void	CalcAll ()

Public Member Functions inherited from ScFormatEntry
	ScFormatEntry (ScDocument *pDoc)

virtual	~ScFormatEntry ()

bool	operator== (const ScFormatEntry &) const

Private Member Functions
bool	DoMacro (const ScAddress &rPos, const OUString &rInput, ScFormulaCell pCell, weld::Window pParent) const

bool	DoScript (const ScAddress &rPos, const OUString &rInput, ScFormulaCell pCell, weld::Window pParent) const

bool	GetSelectionFromFormula (std::vector< ScTypedStrData > *pStrings, ScRefCellValue &rCell, const ScAddress &rPos, const ScTokenArray &rTokArr, int &rMatch) const
	Tries to fill the passed collection with list validation entries. More...

bool	IsEqualToTokenArray (ScRefCellValue &rCell, const ScAddress &rPos, const ScTokenArray &rTokArr) const
	Tests, if pCell is equal to what the passed token array represents. More...

bool	IsListValid (ScRefCellValue &rCell, const ScAddress &rPos) const
	Tests, if contents of pCell occur in cell range referenced by own formula, or in a string list. More...

bool	IsDataValidTextLen (const OUString &rTest, const ScAddress &rPos, ScValidationDataIsNumeric *pDataNumeric) const
	Tests, if string or numeric data has valid text length. More...

Private Attributes
sal_uInt32	nKey

ScValidationMode	eDataMode

bool	bShowInput

bool	bShowError

ScValidErrorStyle	eErrorStyle

sal_Int16	mnListType

OUString	aInputTitle

OUString	aInputMessage

OUString	aErrorTitle

OUString	aErrorMessage

Additional Inherited Members
Public Types inherited from ScFormatEntry
enum	Type { Type::Condition, Type::ExtCondition, Type::Colorscale, Type::Databar, Type::Iconset, Type::Date }

Static Public Member Functions inherited from ScConditionEntry
static ScConditionMode	GetModeFromApi (css::sheet::ConditionOperator nOperator)

Protected Member Functions inherited from ScConditionEntry
virtual void	DataChanged () const

ScDocument *	GetDocument () const

Protected Attributes inherited from ScConditionEntry
ScConditionalFormat *	pCondFormat

Protected Attributes inherited from ScFormatEntry
ScDocument *	mpDoc

Detailed Description

Definition at line 60 of file validat.hxx.

Constructor & Destructor Documentation

ScValidationData::ScValidationData	(	ScValidationMode	eMode,
		ScConditionMode	eOper,
		const OUString &	rExpr1,
		const OUString &	rExpr2,
		ScDocument &	rDocument,
		const ScAddress &	rPos,
		const OUString &	rExprNmsp1 = `EMPTY_OUSTRING`,
		const OUString &	rExprNmsp2 = `EMPTY_OUSTRING`,
		formula::FormulaGrammar::Grammar	eGrammar1 = `formula::FormulaGrammar::GRAM_DEFAULT`,
		formula::FormulaGrammar::Grammar	eGrammar2 = `formula::FormulaGrammar::GRAM_DEFAULT`
	)

Definition at line 63 of file validat.cxx.

References sheet.

ScValidationData::ScValidationData	(	ScValidationMode	eMode,
		ScConditionMode	eOper,
		const ScTokenArray *	pArr1,
		const ScTokenArray *	pArr2,
		ScDocument &	rDocument,
		const ScAddress &	rPos
	)

Definition at line 80 of file validat.cxx.

References sheet.

ScValidationData::ScValidationData ( const ScValidationData & r )

Definition at line 93 of file validat.cxx.

ScValidationData::ScValidationData	(	ScDocument &	rDocument,
		const ScValidationData &	r
	)

Definition at line 109 of file validat.cxx.

ScValidationData::~ScValidationData ( )

overridevirtual

Definition at line 125 of file validat.cxx.

Member Function Documentation

ScValidationData* ScValidationData::Clone ( ) const

inline

Definition at line 97 of file validat.hxx.

References ScConditionEntry::GetDocument().

Referenced by ScDocument::AddValidationEntry().

ScValidationData* ScValidationData::Clone ( ScDocument * pNew ) const

inlineoverridevirtual

Reimplemented from ScConditionEntry.

Definition at line 99 of file validat.hxx.

void ScValidationData::DoCalcError ( ScFormulaCell * pCell ) const

Definition at line 372 of file validat.cxx.

References ScFormulaCell::aPos, DoMacro(), eErrorStyle, EMPTY_OUSTRING, and SC_VALERR_MACRO.

Referenced by ScFormulaCell::InterpretTail().

bool ScValidationData::DoError	(	weld::Window *	pParent,
		const OUString &	rInput,
		const ScAddress &	rPos
	)		const

Definition at line 380 of file validat.cxx.

References aErrorMessage, aErrorTitle, Application::CreateMessageDialog(), SfxViewShell::Current(), DoMacro(), eErrorStyle, eType, comphelper::LibreOfficeKit::isActive(), SfxViewShell::isLOKMobilePhone(), RET_CANCEL, RET_OK, SC_VALERR_INFO, SC_VALERR_MACRO, SC_VALERR_STOP, SC_VALERR_WARNING, and ScResId().

Referenced by ScInputHandler::EnterHandler().

bool ScValidationData::DoMacro	(	const ScAddress &	rPos,
		const OUString &	rInput,
		ScFormulaCell *	pCell,
		weld::Window *	pParent
	)		const

private

Definition at line 268 of file validat.cxx.

References aErrorTitle, SfxObjectShell::CallBasic(), Application::CreateMessageDialog(), DoScript(), ERRCODE_NONE, StarBASIC::Find(), ScAddress::Format(), SbxArray::Get(), tools::SvRef< T >::get(), ScDocument::GetAddressConvention(), SfxObjectShell::GetBasic(), SbxValue::GetBool(), ScConditionEntry::GetDocument(), ScDocument::GetDocumentShell(), SbxVariable::GetName(), SfxShell::GetName(), SbxVariable::GetParent(), svl::SharedString::getString(), ScFormulaCell::GetString(), SbxVariable::GetType(), ScFormulaCell::GetValue(), ScDocument::IsInLinkUpdate(), ScFormulaCell::IsValue(), SfxApplication::IsXScriptURL(), ScDocument::LockTable(), nValue, pObject, SbxValue::PutDouble(), SbxValue::PutString(), ScResId(), ScDocument::SetInLinkUpdate(), SfxGetpApp(), ScAddress::Tab(), TAB_3D, ScDocument::UnlockTable(), and VALID.

Referenced by DoCalcError(), and DoError().

bool ScValidationData::DoScript	(	const ScAddress &	rPos,
		const OUString &	rInput,
		ScFormulaCell *	pCell,
		weld::Window *	pParent
	)		const

private

bool ScValidationData::EqualEntries ( const ScValidationData & r ) const

Definition at line 135 of file validat.cxx.

References aErrorMessage, aErrorTitle, aInputMessage, aInputTitle, bShowError, bShowInput, eDataMode, eErrorStyle, mnListType, and ScFormatEntry::operator==().

Referenced by ScDocument::AddValidationEntry(), and IsEmpty().

bool ScValidationData::FillSelectionList	(	std::vector< ScTypedStrData > &	rStrings,
		const ScAddress &	rPos
	)		const

Tries to fill the passed collection with list validation entries.

Fills the list only, if this is a list validation and IsShowList() is enabled.

Parameters

rStrings (out-param) The string list to fill with list validation entries.

Returns: true = rStrings has been filled with at least one entry.

Definition at line 909 of file validat.cxx.

References aStr, ScConditionEntry::CreateFlatCopiedTokenArray(), ScConditionEntry::GetDocument(), ScDocument::GetFormatTable(), GetSelectionFromFormula(), HasSelectionList(), SvNumberFormatter::IsNumberFormat(), ScTypedStrData::Standard, and ScTypedStrData::Value.

Referenced by ScDocument::GetDataEntries().

ScValidationMode ScValidationData::GetDataMode ( ) const

inline

Definition at line 114 of file validat.hxx.

Referenced by ScInputHandler::EnterHandler(), ScCellShell::ExecuteDB(), ScDocument::HasValidationData(), IsDataValidCustom(), and ScTableValidationObj::ScTableValidationObj().

bool ScValidationData::GetErrMsg	(	OUString &	rTitle,
		OUString &	rMsg,
		ScValidErrorStyle &	rStyle
	)		const

Definition at line 177 of file validat.cxx.

References aErrorMessage, aErrorTitle, bShowError, and eErrorStyle.

Referenced by ScCellShell::ExecuteDB(), and ScTableValidationObj::ScTableValidationObj().

bool ScValidationData::GetInput	(	OUString &	rTitle,
		OUString &	rMsg
	)		const

inline

Definition at line 108 of file validat.hxx.

Referenced by ScCellShell::ExecuteDB(), ScTableValidationObj::ScTableValidationObj(), and ScTabView::TestHintWindow().

sal_uInt32 ScValidationData::GetKey ( ) const

inline

Definition at line 160 of file validat.hxx.

Referenced by ScDocument::AddValidationEntry().

sal_Int16 ScValidationData::GetListType ( ) const

inline

Definition at line 116 of file validat.hxx.

Referenced by ScCellShell::ExecuteDB(), ScDocument::GetDataEntries(), ScGridWindow::LaunchDataSelectMenu(), and ScTableValidationObj::ScTableValidationObj().

bool ScValidationData::GetSelectionFromFormula	(	std::vector< ScTypedStrData > *	pStrings,
		ScRefCellValue &	rCell,
		const ScAddress &	rPos,
		const ScTokenArray &	rTokArr,
		int &	rMatch
	)		const

private

Tries to fill the passed collection with list validation entries.

Fills the list only if it is non-NULL,

Parameters

pStrings	(out-param) Optionally NULL, string list to fill with list validation entries.
pCell	can be NULL if it is not necessary to which element in the list is selected.
rPos	the base address for relative references.
rTokArr	Formula token array.
rMatch	(out-param) the index of the first item that matched, -1 if nothing matched.

Returns: true = Cell range found, rRange is valid, or an error entry stuffed into the list if pCell==NULL.

Definition at line 717 of file validat.cxx.

Referenced by FillSelectionList(), and IsListValid().

bool ScValidationData::HasErrMsg ( ) const

inline

Definition at line 112 of file validat.hxx.

Referenced by ScInputHandler::EnterHandler().

bool ScValidationData::HasSelectionList ( ) const

Returns true, if the validation cell will show a selection list.

Use this instead of GetListType() which returns the raw property regardless of the validation type.

Definition at line 712 of file validat.cxx.

References eDataMode, mnListType, and SC_VALID_LIST.

Referenced by FillSelectionList(), ScDocument::HasSelectionData(), ScAccessibleCell::IsDropdown(), and ScTabView::TestHintWindow().

bool ScValidationData::IsDataValid	(	const OUString &	rTest,
		const ScPatternAttr &	rPattern,
		const ScAddress &	rPos
	)		const

Definition at line 527 of file validat.cxx.

References eDataMode, ScConditionEntry::GetDocument(), ScDocument::GetFormatTable(), ScPatternAttr::GetNumberFormat(), ScDocument::GetSharedStringPool(), svl::SharedStringPool::intern(), IsDataValidTextLen(), ScConditionEntry::IsIgnoreBlank(), SvNumberFormatter::IsNumberFormat(), ScFormatEntry::mpDoc, SC_VALID_ANY, and SC_VALID_TEXTLEN.

Referenced by ScInputHandler::EnterHandler(), ScOutputData::FindChanged(), ScFormulaCell::InterpretTail(), ScDetectiveFunc::MarkInvalid(), and ScDocFunc::SetNormalString().

bool ScValidationData::IsDataValid	(	ScRefCellValue &	rCell,
		const ScAddress &	rPos
	)		const

bool ScValidationData::IsDataValidCustom	(	const OUString &	rTest,
		const ScPatternAttr &	rPattern,
		const ScAddress &	rPos,
		const CustomValidationPrivateAccess &
	)		const