The tab page "Criteria" from the Validation dialog. More...

#include <validate.hxx>

Inheritance diagram for ScTPValidationValue:

Collaboration diagram for ScTPValidationValue:

Public Member Functions
	ScTPValidationValue (weld::Container pPage, weld::DialogController pController, const SfxItemSet &rArgSet)

virtual	~ScTPValidationValue () override

virtual bool	FillItemSet (SfxItemSet *rArgSet) override

virtual void	Reset (const SfxItemSet *rArgSet) override

void	SetupRefDlg ()

void	RemoveRefDlg (bool bRestoreModal)

Public Member Functions inherited from ScRefHandlerCaller
virtual	~ScRefHandlerCaller ()

Public Member Functions inherited from SfxTabPage
void	SetDialogController (SfxOkDialogController *pDialog)

virtual	~SfxTabPage () override

void	set_visible (bool bVisible)

const SfxItemSet &	GetItemSet () const

virtual bool	FillItemSet (SfxItemSet *)

virtual void	Reset (const SfxItemSet *)

virtual bool	DeferResetToFirstActivation ()

bool	HasExchangeSupport () const

void	SetExchangeSupport ()

virtual void	ActivatePage (const SfxItemSet &)

virtual DeactivateRC	DeactivatePage (SfxItemSet *pSet)

void	SetUserData (const OUString &rString)

const OUString &	GetUserData () const

virtual void	FillUserData ()

virtual bool	IsReadOnly () const

virtual void	PageCreated (const SfxAllItemSet &aSet)

virtual void	ChangesApplied ()

void	SetFrame (const css::uno::Reference< css::frame::XFrame > &xFrame)

css::uno::Reference< css::frame::XFrame >	GetFrame () const

const SfxItemSet *	GetDialogExampleSet () const

OUString	GetHelpId () const

OUString	GetConfigId () const

bool	IsVisible () const

weld::Window *	GetFrameWeld () const

std::unordered_map< OUString, css::uno::Any > &	getAdditionalProperties ()

Static Public Member Functions
static std::unique_ptr< SfxTabPage >	Create (weld::Container pPage, weld::DialogController pController, const SfxItemSet *rArgSet)

static const WhichRangesContainer &	GetRanges ()

Static Public Member Functions inherited from SfxTabPage
static const SfxPoolItem *	GetItem (const SfxItemSet &rSet, sal_uInt16 nSlot, bool bDeep=true)

static const T *	GetItem (const SfxItemSet &rSet, TypedWhichId< T > nSlot, bool bDeep=true)

Private Member Functions
void	Init ()

OUString	GetFirstFormula () const

OUString	GetSecondFormula () const

void	SetFirstFormula (const OUString &rFmlaStr)

void	SetSecondFormula (const OUString &rFmlaStr)

	DECL_LINK (SelectHdl, weld::ComboBox &, void)

	DECL_LINK (CheckHdl, weld::Toggleable &, void)

	DECL_LINK (EditSetFocusHdl, formula::RefEdit &, void)
	List separator in formulas. More...

	DECL_LINK (KillEditFocusHdl, formula::RefEdit &, void)

	DECL_LINK (KillButtonFocusHdl, formula::RefButton &, void)

	DECL_LINK (ClickHdl, formula::RefButton &, void)

void	SetReferenceHdl (const ScRange &, const ScDocument &)

void	SetActiveHdl ()

void	RefInputStartPreHdl (formula::RefEdit pEdit, const formula::RefButton pButton)

void	RefInputDonePostHdl ()

ScValidationDlg *	GetValidationDlg ()

Private Attributes
OUString	maStrMin

OUString	maStrMax

OUString	maStrValue

OUString	maStrFormula

OUString	maStrRange

OUString	maStrList

sal_Unicode	mcFmlaSep

formula::RefEdit *	m_pRefEdit

std::unique_ptr< weld::ComboBox >	m_xLbAllow

std::unique_ptr< weld::CheckButton >	m_xCbAllow

std::unique_ptr< weld::CheckButton >	m_xCbShow
	Allow blank cells. More...

std::unique_ptr< weld::CheckButton >	m_xCbSort
	Show selection list in cell. More...

std::unique_ptr< weld::Label >	m_xFtValue
	Sort selection list in cell. More...

std::unique_ptr< weld::ComboBox >	m_xLbValue

std::unique_ptr< weld::Label >	m_xFtMin

std::unique_ptr< weld::Widget >	m_xMinGrid

std::unique_ptr< formula::RefEdit >	m_xEdMin

std::unique_ptr< weld::TextView >	m_xEdList

std::unique_ptr< weld::Label >	m_xFtMax
	Entries for explicit list. More...

std::unique_ptr< formula::RefEdit >	m_xEdMax

std::unique_ptr< weld::Label >	m_xFtHint

std::unique_ptr< formula::RefButton >	m_xBtnRef
	Hint text for cell range validity. More...

std::unique_ptr< weld::Container >	m_xRefGrid

weld::Container *	m_pRefEditParent

weld::Container *	m_pBtnRefParent

Static Private Attributes
static const WhichRangesContainer	pValueRanges

Additional Inherited Members
Protected Member Functions inherited from SfxTabPage
	SfxTabPage (weld::Container pPage, weld::DialogController pController, const OUString &rUIXMLDescription, const OUString &rID, const SfxItemSet *rAttrSet)

sal_uInt16	GetWhich (sal_uInt16 nSlot, bool bDeep=true) const

TypedWhichId< T >	GetWhich (TypedWhichId< T > nSlot, bool bDeep=true) const

const SfxPoolItem *	GetOldItem (const SfxItemSet &rSet, sal_uInt16 nSlot, bool bDeep=true)

const T *	GetOldItem (const SfxItemSet &rSet, TypedWhichId< T > nSlot, bool bDeep=true)

SfxOkDialogController *	GetDialogController () const

Detailed Description

The tab page "Criteria" from the Validation dialog.

Definition at line 76 of file validate.hxx.

Constructor & Destructor Documentation

◆ ScTPValidationValue()

ScTPValidationValue::ScTPValidationValue	(	weld::Container *	pPage,
		weld::DialogController *	pController,
		const SfxItemSet &	rArgSet
	)

explicit

Definition at line 350 of file validate.cxx.

References get(), formula::FormulaCompiler::GetNativeSymbol(), Size::Height(), Init(), LINK, m_xBtnRef, m_xContainer, m_xEdList, m_xEdMax, m_xEdMin, m_xFtMax, m_xFtMin, mcFmlaSep, ocSep, and Size::Width().

◆ ~ScTPValidationValue()

ScTPValidationValue::~ScTPValidationValue ( )

overridevirtual

Definition at line 400 of file validate.cxx.

References m_xBtnRef, m_xEdMax, and m_xEdMin.

Member Function Documentation

◆ Create()

std::unique_ptr< SfxTabPage > ScTPValidationValue::Create	(	weld::Container *	pPage,
		weld::DialogController *	pController,
		const SfxItemSet *	rArgSet
	)

static

Definition at line 427 of file validate.cxx.

Referenced by ScValidationDlg::ScValidationDlg().

◆ DECL_LINK() [1/6]

ScTPValidationValue::DECL_LINK	(	CheckHdl	,
		weld::Toggleable &	,
		void
	)

private

◆ DECL_LINK() [2/6]

ScTPValidationValue::DECL_LINK	(	ClickHdl	,
		formula::RefButton &	,
		void
	)

private

◆ DECL_LINK() [3/6]

ScTPValidationValue::DECL_LINK	(	EditSetFocusHdl	,
		formula::RefEdit &	,
		void
	)

private

List separator in formulas.

◆ DECL_LINK() [4/6]

ScTPValidationValue::DECL_LINK	(	KillButtonFocusHdl	,
		formula::RefButton &	,
		void
	)

private

◆ DECL_LINK() [5/6]

ScTPValidationValue::DECL_LINK	(	KillEditFocusHdl	,
		formula::RefEdit &	,
		void
	)

private

◆ DECL_LINK() [6/6]

ScTPValidationValue::DECL_LINK	(	SelectHdl	,
		weld::ComboBox &	,
		void
	)

private

◆ FillItemSet()

bool ScTPValidationValue::FillItemSet ( SfxItemSet * rArgSet )

overridevirtual

Reimplemented from SfxTabPage.

Definition at line 471 of file validate.cxx.

References Direct, GetFirstFormula(), GetSecondFormula(), m_xCbAllow, m_xCbShow, m_xCbSort, m_xLbAllow, m_xLbValue, SfxItemSet::Put(), and SC_VALIDDLG_ALLOW_CUSTOM.

◆ GetFirstFormula()

OUString ScTPValidationValue::GetFirstFormula ( ) const

private

Definition at line 492 of file validate.cxx.

References m_xEdList, m_xEdMin, m_xLbAllow, mcFmlaSep, and SC_VALIDDLG_ALLOW_LIST.

Referenced by FillItemSet().

◆ GetRanges()

static const WhichRangesContainer & ScTPValidationValue::GetRanges ( )

inlinestatic

Definition at line 84 of file validate.hxx.

References pValueRanges.

Referenced by ScCellShell::ExecuteDB().

◆ GetSecondFormula()

OUString ScTPValidationValue::GetSecondFormula ( ) const

private

Definition at line 502 of file validate.cxx.

References m_xEdMax.

Referenced by FillItemSet().

◆ GetValidationDlg()

ScValidationDlg * ScTPValidationValue::GetValidationDlg ( )

private

Definition at line 531 of file validate.cxx.

References SfxTabPage::GetDialogController().

Referenced by RefInputDonePostHdl(), RefInputStartPreHdl(), RemoveRefDlg(), SetActiveHdl(), SetReferenceHdl(), and SetupRefDlg().

◆ Init()

void ScTPValidationValue::Init ( void )

private

Definition at line 407 of file validate.cxx.

References LINK, m_xBtnRef, m_xCbShow, m_xEdMax, m_xEdMin, m_xLbAllow, m_xLbValue, SC_VALIDDLG_ALLOW_ANY, and SC_VALIDDLG_DATA_EQUAL.

Referenced by ScTPValidationValue().

◆ RefInputDonePostHdl()

void ScTPValidationValue::RefInputDonePostHdl ( )

private

Definition at line 177 of file validate.cxx.

References ScViewData::GetRefTabNo(), ScViewData::GetTabNo(), GetValidationDlg(), ScViewData::GetViewShell(), formula::RefEdit::GetWidget(), formula::RefEdit::GrabFocus(), weld::Widget::has_focus(), weld::Widget::hide(), m_pBtnRefParent, m_pRefEdit, m_pRefEditParent, m_xBtnRef, m_xRefGrid, weld::Container::move(), and ScTabView::SetTabNo().

Referenced by SetupRefDlg().

◆ RefInputStartPreHdl()

void ScTPValidationValue::RefInputStartPreHdl	(	formula::RefEdit *	pEdit,
		const formula::RefButton *	pButton
	)

private

Definition at line 150 of file validate.cxx.

References ScValidationDlg::get_refinput_shrink_parent(), GetValidationDlg(), formula::RefEdit::GetWidget(), m_pBtnRefParent, m_pRefEdit, m_pRefEditParent, m_xBtnRef, m_xRefGrid, and weld::Widget::show().

Referenced by SetupRefDlg().

◆ RemoveRefDlg()

void ScTPValidationValue::RemoveRefDlg ( bool bRestoreModal )

Definition at line 573 of file validate.cxx.

References GetValidationDlg(), m_pRefEdit, m_xBtnRef, ScValidationDlg::RemoveRefDlg(), ScRefHandlerHelper::SetHandler(), formula::RefEdit::SetReferences(), ScRefHandlerHelper::SetRefInputDonePostHdl(), ScRefHandlerHelper::SetRefInputStartPreHdl(), ScRefHandlerHelper::SetSetActHdl(), and ScRefHandlerHelper::SetSetRefHdl().

◆ Reset()

void ScTPValidationValue::Reset ( const SfxItemSet * rArgSet )

overridevirtual

Reimplemented from SfxTabPage.

Definition at line 432 of file validate.cxx.

References SfxItemSet::GetItemIfSet(), m_xCbAllow, m_xCbShow, m_xCbSort, m_xLbAllow, m_xLbValue, SC_VALIDDLG_ALLOW_ANY, SC_VALIDDLG_DATA_EQUAL, SetFirstFormula(), and SetSecondFormula().

◆ SetActiveHdl()

void ScTPValidationValue::SetActiveHdl ( )

private

Definition at line 139 of file validate.cxx.

References GetValidationDlg(), formula::RefEdit::GrabFocus(), and m_pRefEdit.

Referenced by SetupRefDlg().

◆ SetFirstFormula()

void ScTPValidationValue::SetFirstFormula ( const OUString & rFmlaStr )

private

Definition at line 507 of file validate.cxx.

References aStringList, m_xEdList, m_xEdMin, m_xLbAllow, mcFmlaSep, SC_VALIDDLG_ALLOW_LIST, and SC_VALIDDLG_ALLOW_RANGE.

Referenced by Reset().

◆ SetReferenceHdl()

void ScTPValidationValue::SetReferenceHdl	(	const ScRange &	rRange,
		const ScDocument &	rDoc
	)

private

Definition at line 125 of file validate.cxx.

References ScRange::aEnd, ScRange::aStart, aStr, ScRange::Format(), ScDocument::GetAddressConvention(), GetValidationDlg(), m_pRefEdit, RANGE_ABS_3D, and formula::RefEdit::SetRefString().

Referenced by SetupRefDlg().

◆ SetSecondFormula()

void ScTPValidationValue::SetSecondFormula ( const OUString & rFmlaStr )

private

Definition at line 526 of file validate.cxx.

References m_xEdMax.

Referenced by Reset().

◆ SetupRefDlg()

void ScTPValidationValue::SetupRefDlg ( )

Member Data Documentation

◆ m_pBtnRefParent

weld::Container* ScTPValidationValue::m_pBtnRefParent

private

Definition at line 133 of file validate.hxx.

Referenced by RefInputDonePostHdl(), and RefInputStartPreHdl().

◆ m_pRefEdit

formula::RefEdit* ScTPValidationValue::m_pRefEdit

private

Definition at line 114 of file validate.hxx.

Referenced by RefInputDonePostHdl(), RefInputStartPreHdl(), RemoveRefDlg(), SetActiveHdl(), SetReferenceHdl(), and SetupRefDlg().

◆ m_pRefEditParent

weld::Container* ScTPValidationValue::m_pRefEditParent

private

Definition at line 132 of file validate.hxx.

Referenced by RefInputDonePostHdl(), and RefInputStartPreHdl().

◆ m_xBtnRef

std::unique_ptr<formula::RefButton> ScTPValidationValue::m_xBtnRef

private

Hint text for cell range validity.

Definition at line 129 of file validate.hxx.

Referenced by Init(), RefInputDonePostHdl(), RefInputStartPreHdl(), RemoveRefDlg(), ScTPValidationValue(), SetupRefDlg(), and ~ScTPValidationValue().

◆ m_xCbAllow

std::unique_ptr<weld::CheckButton> ScTPValidationValue::m_xCbAllow

private

Definition at line 117 of file validate.hxx.

Referenced by FillItemSet(), and Reset().

◆ m_xCbShow

std::unique_ptr<weld::CheckButton> ScTPValidationValue::m_xCbShow

private

Allow blank cells.

Definition at line 118 of file validate.hxx.

Referenced by FillItemSet(), Init(), and Reset().

◆ m_xCbSort

std::unique_ptr<weld::CheckButton> ScTPValidationValue::m_xCbSort

private

Show selection list in cell.

Definition at line 119 of file validate.hxx.

Referenced by FillItemSet(), and Reset().

◆ m_xEdList

std::unique_ptr<weld::TextView> ScTPValidationValue::m_xEdList

private

Definition at line 125 of file validate.hxx.

Referenced by GetFirstFormula(), ScTPValidationValue(), and SetFirstFormula().

◆ m_xEdMax

std::unique_ptr<formula::RefEdit> ScTPValidationValue::m_xEdMax

private

Definition at line 127 of file validate.hxx.

Referenced by GetSecondFormula(), Init(), ScTPValidationValue(), SetSecondFormula(), SetupRefDlg(), and ~ScTPValidationValue().

◆ m_xEdMin

std::unique_ptr<formula::RefEdit> ScTPValidationValue::m_xEdMin

private

Definition at line 124 of file validate.hxx.

Referenced by GetFirstFormula(), Init(), ScTPValidationValue(), SetFirstFormula(), SetupRefDlg(), and ~ScTPValidationValue().

◆ m_xFtHint

std::unique_ptr<weld::Label> ScTPValidationValue::m_xFtHint

private

Definition at line 128 of file validate.hxx.

◆ m_xFtMax

std::unique_ptr<weld::Label> ScTPValidationValue::m_xFtMax

private

Entries for explicit list.

Definition at line 126 of file validate.hxx.

Referenced by ScTPValidationValue(), and SetupRefDlg().

◆ m_xFtMin

std::unique_ptr<weld::Label> ScTPValidationValue::m_xFtMin

private

Definition at line 122 of file validate.hxx.

Referenced by ScTPValidationValue(), and SetupRefDlg().

◆ m_xFtValue

std::unique_ptr<weld::Label> ScTPValidationValue::m_xFtValue

private

Sort selection list in cell.

Definition at line 120 of file validate.hxx.

◆ m_xLbAllow

std::unique_ptr<weld::ComboBox> ScTPValidationValue::m_xLbAllow

private

Definition at line 116 of file validate.hxx.

Referenced by FillItemSet(), GetFirstFormula(), Init(), Reset(), and SetFirstFormula().

◆ m_xLbValue

std::unique_ptr<weld::ComboBox> ScTPValidationValue::m_xLbValue

private

Definition at line 121 of file validate.hxx.

Referenced by FillItemSet(), Init(), and Reset().

◆ m_xMinGrid

std::unique_ptr<weld::Widget> ScTPValidationValue::m_xMinGrid

private

Definition at line 123 of file validate.hxx.

◆ m_xRefGrid

std::unique_ptr<weld::Container> ScTPValidationValue::m_xRefGrid

private

Definition at line 130 of file validate.hxx.

Referenced by RefInputDonePostHdl(), and RefInputStartPreHdl().

◆ maStrFormula

OUString ScTPValidationValue::maStrFormula

private

Definition at line 104 of file validate.hxx.

◆ maStrList

OUString ScTPValidationValue::maStrList

private

Definition at line 106 of file validate.hxx.

◆ maStrMax

OUString ScTPValidationValue::maStrMax

private

Definition at line 102 of file validate.hxx.

◆ maStrMin

OUString ScTPValidationValue::maStrMin

private

Definition at line 101 of file validate.hxx.

◆ maStrRange

OUString ScTPValidationValue::maStrRange

private

Definition at line 105 of file validate.hxx.

◆ maStrValue

OUString ScTPValidationValue::maStrValue

private

Definition at line 103 of file validate.hxx.

◆ mcFmlaSep

sal_Unicode ScTPValidationValue::mcFmlaSep

private

Definition at line 107 of file validate.hxx.

Referenced by GetFirstFormula(), ScTPValidationValue(), and SetFirstFormula().

◆ pValueRanges

const WhichRangesContainer ScTPValidationValue::pValueRanges

staticprivate

Definition at line 78 of file validate.hxx.

Referenced by GetRanges().

The documentation for this class was generated from the following files:

Public Member Functions

Static Public Member Functions

Private Member Functions

Private Attributes

Static Private Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ ScTPValidationValue()

◆ ~ScTPValidationValue()

Member Function Documentation

◆ Create()

◆ DECL_LINK() [1/6]

◆ DECL_LINK() [2/6]

◆ DECL_LINK() [3/6]

◆ DECL_LINK() [4/6]

◆ DECL_LINK() [5/6]

◆ DECL_LINK() [6/6]

◆ FillItemSet()

◆ GetFirstFormula()

◆ GetRanges()

◆ GetSecondFormula()

◆ GetValidationDlg()

◆ Init()

◆ RefInputDonePostHdl()

◆ RefInputStartPreHdl()

◆ RemoveRefDlg()

◆ Reset()

◆ SetActiveHdl()

◆ SetFirstFormula()

◆ SetReferenceHdl()

◆ SetSecondFormula()

◆ SetupRefDlg()

Member Data Documentation

◆ m_pBtnRefParent

◆ m_pRefEdit

◆ m_pRefEditParent

◆ m_xBtnRef

◆ m_xCbAllow

◆ m_xCbShow

◆ m_xCbSort

◆ m_xEdList

◆ m_xEdMax

◆ m_xEdMin

◆ m_xFtHint

◆ m_xFtMax

◆ m_xFtMin

◆ m_xFtValue

◆ m_xLbAllow

◆ m_xLbValue

◆ m_xMinGrid

◆ m_xRefGrid

◆ maStrFormula

◆ maStrList

◆ maStrMax

◆ maStrMin

◆ maStrRange

◆ maStrValue

◆ mcFmlaSep

◆ pValueRanges