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
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	(	weld::Window *	pWindow,
		std::shared_ptr< ScDocument >	pDoc,
		const ScDocument *	pDocument
	)

Definition at line 745 of file dataproviderdlg.cxx.

References Create(), sc::DataProviderFactory::getDataProviders(), ScDocument::GetDBCollection(), ScDBCollection::getNamedDBs(), ScDataTableView::GetOptimalSize(), Size::Height(), i, ScDataTableView::Init(), 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(), vcl::Window::Show(), and Size::Width().

ScDataProviderDlg::~ScDataProviderDlg ( )

overridevirtual

Definition at line 813 of file dataproviderdlg.cxx.

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

Member Function Documentation

void ScDataProviderDlg::aggregateFunction

(

)

Definition at line 954 of file dataproviderdlg.cxx.

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

void ScDataProviderDlg::applyAndQuit

(

)

void ScDataProviderDlg::cancelAndQuit

(

)

void ScDataProviderDlg::dateTimeTransformation

(

)

Definition at line 972 of file dataproviderdlg.cxx.

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

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

private

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

private

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

private

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

private

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

private

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

private

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

private

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

private

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

private

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

private

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

private

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

private

void ScDataProviderDlg::deleteColumn

(

)

Definition at line 918 of file dataproviderdlg.cxx.

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

void ScDataProviderDlg::deletefromList

(

sal_uInt32

nIndex

)

Definition at line 1030 of file dataproviderdlg.cxx.

References maControls, and mnIndex.

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

void ScDataProviderDlg::deleteRowTransformation

(

)

Definition at line 984 of file dataproviderdlg.cxx.

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

void ScDataProviderDlg::findReplaceTransformation

(

)

Definition at line 978 of file dataproviderdlg.cxx.

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

sc::ExternalDataSource ScDataProviderDlg::getDataSource

(

ScDocument *

pDoc

)

Definition at line 887 of file dataproviderdlg.cxx.

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

Referenced by import().

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

Definition at line 1008 of file dataproviderdlg.cxx.

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

Referenced by ScCellShell::ExecuteDB().

void ScDataProviderDlg::isValid

(

)

Definition at line 898 of file dataproviderdlg.cxx.

References mxEditURL, mxProviderList, and updateApplyBtn().

Referenced by ScDataProviderDlg().

void ScDataProviderDlg::mergeColumns

(

)

Definition at line 933 of file dataproviderdlg.cxx.

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

void ScDataProviderDlg::numberTransformation

(

)

Definition at line 960 of file dataproviderdlg.cxx.

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

void ScDataProviderDlg::replaceNullTransformation

(

)

Definition at line 966 of file dataproviderdlg.cxx.

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

void ScDataProviderDlg::sortTransformation

(

)

Definition at line 948 of file dataproviderdlg.cxx.

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

void ScDataProviderDlg::splitColumn

(

)

Definition at line 924 of file dataproviderdlg.cxx.

References deletefromList(), ScDataTableView::getColRange(), maControls, mnIndex, mxTable, and mxTransformationList.

void ScDataProviderDlg::swapRowsTransformation

(

)

Definition at line 990 of file dataproviderdlg.cxx.

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

void ScDataProviderDlg::textTransformation

(

)

Definition at line 942 of file dataproviderdlg.cxx.

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

void ScDataProviderDlg::updateApplyBtn

(

bool

bValidConfig

)

Definition at line 905 of file dataproviderdlg.cxx.

References msApplyTooltip, and mxApplyBtn.

Referenced by isValid().

Member Data Documentation

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

private

Definition at line 31 of file dataproviderdlg.hxx.

Referenced by ~ScDataProviderDlg().

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().

Idle ScDataProviderDlg::maIdle

private

Definition at line 52 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

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().

OUString ScDataProviderDlg::msAddTransformationToolTip

private

Definition at line 48 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

OUString ScDataProviderDlg::msApplyTooltip

private

Definition at line 47 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg(), and updateApplyBtn().

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

private

Definition at line 37 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

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

private

Definition at line 44 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg(), and updateApplyBtn().

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

private

Definition at line 30 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

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

private

Definition at line 45 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

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

private

Definition at line 36 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

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

private

Definition at line 34 of file dataproviderdlg.hxx.

Referenced by import(), and ScDataProviderDlg().

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(), swapRowsTransformation(), and textTransformation().

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

private

Definition at line 43 of file dataproviderdlg.hxx.

Referenced by getDataSource(), and ScDataProviderDlg().

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

private

Definition at line 42 of file dataproviderdlg.hxx.

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

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

private

Definition at line 33 of file dataproviderdlg.hxx.

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

private

Definition at line 35 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

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

private

Definition at line 41 of file dataproviderdlg.hxx.

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

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

private

Definition at line 38 of file dataproviderdlg.hxx.

VclPtr<ScDataTableView> ScDataProviderDlg::mxTable

private

Definition at line 32 of file dataproviderdlg.hxx.

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

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

private

Definition at line 40 of file dataproviderdlg.hxx.

Referenced by ScDataProviderDlg().

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().

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