ScDataProviderDlg Class Reference

#include <dataproviderdlg.hxx>

Inheritance diagram for ScDataProviderDlg:

Collaboration diagram for ScDataProviderDlg:

Public Member Functions
	ScDataProviderDlg (weld::Window *pWindow, std::shared_ptr< ScDocument > pDoc, const ScDocument *pDocument)
virtual	~ScDataProviderDlg () override
void	applyAndQuit ()
void	cancelAndQuit ()
void	deleteColumn ()
void	splitColumn ()
void	mergeColumns ()
void	textTransformation ()
void	sortTransformation ()
void	aggregateFunction ()
void	numberTransformation ()
void	deletefromList (sal_uInt32 nIndex)
void	replaceNullTransformation ()
void	dateTimeTransformation ()
void	findReplaceTransformation ()
void	deleteRowTransformation ()
void	swapRowsTransformation ()
void	updateApplyBtn (bool bValidConfig)
void	isValid ()
sc::ExternalDataSource	getDataSource (ScDocument *pDoc)
void	import (ScDocument &rDoc, bool bInternal=false)
Public Member Functions inherited from weld::GenericDialogController
	GenericDialogController (weld::Widget *pParent, const OUString &rUIFile, const OString &rDialogId, bool bMobile=false)
virtual Dialog *	getDialog () override
virtual	~GenericDialogController () COVERITY_NOEXCEPT_FALSE override
Public Member Functions inherited from weld::DialogController
virtual Dialog *	getDialog ()=0
const Dialog *	getConstDialog () const
virtual short	run ()
void	set_title (const OUString &rTitle)
OUString	get_title () const
void	set_help_id (const OString &rHelpId)
OString	get_help_id () const
void	response (int nResponse)
virtual	~DialogController () COVERITY_NOEXCEPT_FALSE

Private Member Functions
	DECL_LINK (StartMenuHdl, const OString &, void)
	DECL_LINK (ColumnMenuHdl, const weld::ComboBox &, void)
	DECL_LINK (ScrollToEnd, Timer *, void)
	DECL_LINK (ApplyQuitHdl, weld::Button &, void)
	DECL_LINK (CancelQuitHdl, weld::Button &, void)
	DECL_LINK (TransformationListHdl, weld::Button &, void)
	DECL_LINK (ProviderSelectHdl, weld::ComboBox &, void)
	DECL_LINK (TransformationSelectHdl, weld::ComboBox &, void)
	DECL_LINK (IDEditHdl, weld::Entry &, void)
	DECL_LINK (URLEditHdl, weld::Entry &, void)
	DECL_LINK (ApplyBtnHdl, weld::Button &, void)
	DECL_LINK (BrowseBtnHdl, weld::Button &, void)

Private Attributes
std::shared_ptr< ScDocument >	mxDoc
std::unique_ptr< weld::Container >	mxBox
css::uno::Reference< css::awt::XWindow >	m_xTableParent
VclPtr< ScDataTableView >	mxTable
std::unique_ptr< weld::Container >	mxList
std::unique_ptr< weld::ComboBox >	mxDBRanges
std::unique_ptr< weld::Button >	mxOKBtn
std::unique_ptr< weld::Button >	mxCancelBtn
std::unique_ptr< weld::Button >	mxAddTransformationBtn
std::unique_ptr< weld::ScrolledWindow >	mxScroll
std::unique_ptr< weld::Container >	mxTransformationList
std::unique_ptr< weld::ComboBox >	mxTransformationBox
std::unique_ptr< weld::ComboBox >	mxProviderList
std::unique_ptr< weld::Entry >	mxEditURL
std::unique_ptr< weld::Entry >	mxEditID
std::unique_ptr< weld::Button >	mxApplyBtn
std::unique_ptr< weld::Button >	mxBrowseBtn
OUString	msApplyTooltip
OUString	msAddTransformationToolTip
std::vector< std::unique_ptr< ScDataTransformationBaseControl > >	maControls
Idle	maIdle
sal_uInt32	mnIndex
ScDBData *	pDBData

Additional Inherited Members
Static Public Member Functions inherited from weld::DialogController
static bool	runAsync (const std::shared_ptr< DialogController > &rController, const std::function< void(sal_Int32)> &)
Protected Attributes inherited from weld::GenericDialogController
std::unique_ptr< weld::Builder >	m_xBuilder
std::shared_ptr< weld::Dialog >	m_xDialog

Detailed Description

Definition at line 26 of file dataproviderdlg.hxx.

Constructor & Destructor Documentation

ScDataProviderDlg()

ScDataProviderDlg::ScDataProviderDlg	(	weld::Window *	pWindow,
		std::shared_ptr< ScDocument >	pDoc,
		const ScDocument *	pDocument
	)

Definition at line 773 of file dataproviderdlg.cxx.

References Create(), sc::DataProviderFactory::getDataProviders(), ScDocument::GetDBCollection(), ScDBCollection::getNamedDBs(), Size::Height(), i, isValid(), LINK, maIdle, mnIndex, msAddTransformationToolTip, msApplyTooltip, mxAddTransformationBtn, mxApplyBtn, mxBox, mxBrowseBtn, mxCancelBtn, mxDBRanges, mxDoc, mxEditID, mxEditURL, mxOKBtn, mxProviderList, mxTable, mxTransformationBox, pDBData, SAL_WARN_IF, Timer::SetInvokeHandler(), Task::SetPriority(), and Size::Width().

~ScDataProviderDlg()

ScDataProviderDlg::~ScDataProviderDlg ( )

overridevirtual

Definition at line 841 of file dataproviderdlg.cxx.

References VclPtr< class reference_type >::disposeAndClear(), m_xTableParent, and mxTable.

Member Function Documentation

aggregateFunction()

void ScDataProviderDlg::aggregateFunction

(

)

Definition at line 979 of file dataproviderdlg.cxx.

References deletefromList(), maControls, mnIndex, mxDoc, and mxTransformationList.

applyAndQuit()

void ScDataProviderDlg::applyAndQuit

(

)

cancelAndQuit()

void ScDataProviderDlg::cancelAndQuit

(

)

dateTimeTransformation()

void ScDataProviderDlg::dateTimeTransformation

(

)

Definition at line 997 of file dataproviderdlg.cxx.

References deletefromList(), maControls, mnIndex, mxDoc, and mxTransformationList.

DECL_LINK() [1/12]

ScDataProviderDlg::DECL_LINK ( ApplyBtnHdl  , weld::Button &  , void    )

private

DECL_LINK() [2/12]

ScDataProviderDlg::DECL_LINK ( ApplyQuitHdl  , weld::Button &  , void    )

private

DECL_LINK() [3/12]

ScDataProviderDlg::DECL_LINK ( BrowseBtnHdl  , weld::Button &  , void    )

private

DECL_LINK() [4/12]

ScDataProviderDlg::DECL_LINK ( CancelQuitHdl  , weld::Button &  , void    )

private

DECL_LINK() [5/12]

ScDataProviderDlg::DECL_LINK ( ColumnMenuHdl  , const weld::ComboBox &  , void    )

private

DECL_LINK() [6/12]

ScDataProviderDlg::DECL_LINK ( IDEditHdl  , weld::Entry &  , void    )

private

DECL_LINK() [7/12]

ScDataProviderDlg::DECL_LINK ( ProviderSelectHdl  , weld::ComboBox &  , void    )

private

DECL_LINK() [8/12]

ScDataProviderDlg::DECL_LINK ( ScrollToEnd  , Timer *  , void    )

private

DECL_LINK() [9/12]

ScDataProviderDlg::DECL_LINK ( StartMenuHdl  , const OString &  , void    )

private

DECL_LINK() [10/12]

ScDataProviderDlg::DECL_LINK ( TransformationListHdl  , weld::Button &  , void    )

private

DECL_LINK() [11/12]

ScDataProviderDlg::DECL_LINK ( TransformationSelectHdl  , weld::ComboBox &  , void    )

private

DECL_LINK() [12/12]

ScDataProviderDlg::DECL_LINK ( URLEditHdl  , weld::Entry &  , void    )

private

deleteColumn()

void ScDataProviderDlg::deleteColumn

(

)

Definition at line 946 of file dataproviderdlg.cxx.

References deletefromList(), maControls, mnIndex, mxDoc, and mxTransformationList.

deletefromList()

void ScDataProviderDlg::deletefromList

(

sal_uInt32

nIndex

)

Definition at line 1055 of file dataproviderdlg.cxx.

References maControls, mnIndex, and nIndex.

Referenced by aggregateFunction(), dateTimeTransformation(), deleteColumn(), deleteRowTransformation(), findReplaceTransformation(), mergeColumns(), numberTransformation(), replaceNullTransformation(), sortTransformation(), splitColumn(), swapRowsTransformation(), and textTransformation().

deleteRowTransformation()

void ScDataProviderDlg::deleteRowTransformation

(

)

Definition at line 1009 of file dataproviderdlg.cxx.

References deletefromList(), maControls, mnIndex, mxDoc, and mxTransformationList.

findReplaceTransformation()

void ScDataProviderDlg::findReplaceTransformation

(

)

Definition at line 1003 of file dataproviderdlg.cxx.

References deletefromList(), maControls, mnIndex, mxDoc, and mxTransformationList.

getDataSource()

sc::ExternalDataSource ScDataProviderDlg::getDataSource

(

ScDocument *

pDoc

)

Definition at line 915 of file dataproviderdlg.cxx.

References aURL, mxEditID, mxEditURL, mxProviderList, and sc::ExternalDataSource::setID().

Referenced by import().

import()

void ScDataProviderDlg::import	(	ScDocument &	rDoc,
		bool	bInternal = false
	)

Definition at line 1033 of file dataproviderdlg.cxx.

References sc::ExternalDataSource::AddDataTransformation(), getDataSource(), ScDocument::GetDBCollection(), sc::ExternalDataSource::getDBName(), ScDocument::GetExternalDataMapper(), ScDBData::GetName(), ScDataTransformationBaseControl::getTransformation(), i, sc::ExternalDataMapper::insertDataSource(), maControls, mxDBRanges, mxTable, pDBData, sc::ExternalDataSource::refresh(), and sc::ExternalDataSource::setDBData().

Referenced by ScCellShell::ExecuteDB().

isValid()

void ScDataProviderDlg::isValid

(

)

Definition at line 926 of file dataproviderdlg.cxx.

References mxEditURL, mxProviderList, and updateApplyBtn().

Referenced by ScDataProviderDlg().

mergeColumns()

void ScDataProviderDlg::mergeColumns

(

)

Definition at line 958 of file dataproviderdlg.cxx.

References deletefromList(), maControls, mnIndex, mxDoc, mxTable, and mxTransformationList.

numberTransformation()

void ScDataProviderDlg::numberTransformation

(

)

Definition at line 985 of file dataproviderdlg.cxx.

References deletefromList(), maControls, mnIndex, mxDoc, and mxTransformationList.

replaceNullTransformation()

void ScDataProviderDlg::replaceNullTransformation

(

)

Definition at line 991 of file dataproviderdlg.cxx.

References deletefromList(), maControls, mnIndex, mxDoc, and mxTransformationList.

sortTransformation()

void ScDataProviderDlg::sortTransformation

(

)

Definition at line 973 of file dataproviderdlg.cxx.

References deletefromList(), maControls, mnIndex, mxDoc, and mxTransformationList.

splitColumn()

void ScDataProviderDlg::splitColumn

(

)

Definition at line 952 of file dataproviderdlg.cxx.

References deletefromList(), maControls, mnIndex, mxDoc, and mxTransformationList.

swapRowsTransformation()

void ScDataProviderDlg::swapRowsTransformation

(

)

Definition at line 1015 of file dataproviderdlg.cxx.

References deletefromList(), maControls, mnIndex, mxDoc, and mxTransformationList.

textTransformation()

void ScDataProviderDlg::textTransformation

(

)

Definition at line 967 of file dataproviderdlg.cxx.

References deletefromList(), maControls, mnIndex, mxDoc, and mxTransformationList.

updateApplyBtn()

void ScDataProviderDlg::updateApplyBtn

(

bool

bValidConfig

)

Definition at line 933 of file dataproviderdlg.cxx.

References msApplyTooltip, and mxApplyBtn.

Referenced by isValid().

Member Data Documentation

m_xTableParent

css::uno::Reference<css::awt::XWindow> ScDataProviderDlg::m_xTableParent

private

Definition at line 31 of file dataproviderdlg.hxx.

Referenced by ~ScDataProviderDlg().

maControls

std::vector<std::unique_ptr<ScDataTransformationBaseControl> > ScDataProviderDlg::maControls

private

Definition at line 50 of file dataproviderdlg.hxx.

Referenced by aggregateFunction(), dateTimeTransformation(), deleteColumn(), deletefromList(), deleteRowTransformation(), findReplaceTransformation(), import(), mergeColumns(), numberTransformation(), replaceNullTransformation(), sortTransformation(), splitColumn(), swapRowsTransformation(), and textTransformation().

maIdle

Idle ScDataProviderDlg::maIdle

private

Definition at line 52 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

mnIndex

sal_uInt32 ScDataProviderDlg::mnIndex

private

Definition at line 54 of file dataproviderdlg.hxx.

Referenced by aggregateFunction(), dateTimeTransformation(), deleteColumn(), deletefromList(), deleteRowTransformation(), findReplaceTransformation(), mergeColumns(), numberTransformation(), replaceNullTransformation(), sortTransformation(), splitColumn(), swapRowsTransformation(), and textTransformation().

msAddTransformationToolTip

OUString ScDataProviderDlg::msAddTransformationToolTip

private

Definition at line 48 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

msApplyTooltip

OUString ScDataProviderDlg::msApplyTooltip

private

Definition at line 47 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg(), and updateApplyBtn().

mxAddTransformationBtn

std::unique_ptr<weld::Button> ScDataProviderDlg::mxAddTransformationBtn

private

Definition at line 37 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

mxApplyBtn

std::unique_ptr<weld::Button> ScDataProviderDlg::mxApplyBtn

private

Definition at line 44 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg(), and updateApplyBtn().

mxBox

std::unique_ptr<weld::Container> ScDataProviderDlg::mxBox

private

Definition at line 30 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

mxBrowseBtn

std::unique_ptr<weld::Button> ScDataProviderDlg::mxBrowseBtn

private

Definition at line 45 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

mxCancelBtn

std::unique_ptr<weld::Button> ScDataProviderDlg::mxCancelBtn

private

Definition at line 36 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

mxDBRanges

std::unique_ptr<weld::ComboBox> ScDataProviderDlg::mxDBRanges

private

Definition at line 34 of file dataproviderdlg.hxx.

Referenced by import(), and ScDataProviderDlg().

mxDoc

std::shared_ptr<ScDocument> ScDataProviderDlg::mxDoc

private

Definition at line 29 of file dataproviderdlg.hxx.

Referenced by aggregateFunction(), dateTimeTransformation(), deleteColumn(), deleteRowTransformation(), findReplaceTransformation(), mergeColumns(), numberTransformation(), replaceNullTransformation(), ScDataProviderDlg(), sortTransformation(), splitColumn(), swapRowsTransformation(), and textTransformation().

mxEditID

std::unique_ptr<weld::Entry> ScDataProviderDlg::mxEditID

private

Definition at line 43 of file dataproviderdlg.hxx.

Referenced by getDataSource(), and ScDataProviderDlg().

mxEditURL

std::unique_ptr<weld::Entry> ScDataProviderDlg::mxEditURL

private

Definition at line 42 of file dataproviderdlg.hxx.

Referenced by getDataSource(), isValid(), and ScDataProviderDlg().

mxList

std::unique_ptr<weld::Container> ScDataProviderDlg::mxList

private

Definition at line 33 of file dataproviderdlg.hxx.

mxOKBtn

std::unique_ptr<weld::Button> ScDataProviderDlg::mxOKBtn

private

Definition at line 35 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

mxProviderList

std::unique_ptr<weld::ComboBox> ScDataProviderDlg::mxProviderList

private

Definition at line 41 of file dataproviderdlg.hxx.

Referenced by getDataSource(), isValid(), and ScDataProviderDlg().

mxScroll

std::unique_ptr<weld::ScrolledWindow> ScDataProviderDlg::mxScroll

private

Definition at line 38 of file dataproviderdlg.hxx.

mxTable

VclPtr<ScDataTableView> ScDataProviderDlg::mxTable

private

Definition at line 32 of file dataproviderdlg.hxx.

Referenced by import(), mergeColumns(), ScDataProviderDlg(), and ~ScDataProviderDlg().

mxTransformationBox

std::unique_ptr<weld::ComboBox> ScDataProviderDlg::mxTransformationBox

private

Definition at line 40 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

mxTransformationList

std::unique_ptr<weld::Container> ScDataProviderDlg::mxTransformationList

private

Definition at line 39 of file dataproviderdlg.hxx.

Referenced by aggregateFunction(), dateTimeTransformation(), deleteColumn(), deleteRowTransformation(), findReplaceTransformation(), mergeColumns(), numberTransformation(), replaceNullTransformation(), sortTransformation(), splitColumn(), swapRowsTransformation(), and textTransformation().

pDBData

ScDBData* ScDataProviderDlg::pDBData

private

Definition at line 55 of file dataproviderdlg.hxx.

Referenced by import(), and ScDataProviderDlg().

---

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

• dataproviderdlg.hxx
• dataproviderdlg.cxx