Imports validation data. More...
#include <xicontent.hxx>
Classes | |
| struct | DVItem |
Public Member Functions | |
| XclImpValidationManager (const XclImpRoot &rRoot) | |
| void | ReadDV (XclImpStream &rStrm) |
| Reads a DV record and inserts validation data into the document. More... | |
| void | Apply () |
Static Public Member Functions | |
| static void | ReadDval (XclImpStream &rStrm) |
| Reads a DVAL record and sets marks the dropdown arrow control to be ignored. More... | |
Private Attributes | |
| std::vector< std::unique_ptr< DVItem > > | maDVItems |
Additional Inherited Members | |
 Protected Member Functions inherited from XclImpRoot | |
| XclImpRoot (XclImpRootData &rImpRootData) | |
| const XclImpRoot & | GetRoot () const |
| Returns this root instance - for code readability in derived classes. More... | |
| XclImpRoot & | GetRoot () |
| void | SetCodePage (sal_uInt16 nCodePage) |
| Sets a code page read from a CODEPAGE record for byte string import. More... | |
| void | InitializeTable (SCTAB nScTab) |
| Is called when import filter starts importing a single sheet (all BIFF versions). More... | |
| void | FinalizeTable () |
| Is called when import filter stops importing a single sheet (all BIFF versions). More... | |
| XclImpAddressConverter & | GetAddressConverter () const |
| Returns the address converter. More... | |
| XclImpFormulaCompiler & | GetFormulaCompiler () const |
| Returns the formula converter. More... | |
| ExcelToSc & | GetOldFmlaConverter () const |
| Returns the old formula converter. More... | |
| XclImpSst & | GetSst () const |
| Returns the shared string table. More... | |
| XclImpPalette & | GetPalette () const |
| Returns the color buffer. More... | |
| XclImpFontBuffer & | GetFontBuffer () const |
| Returns the font buffer. More... | |
| XclImpNumFmtBuffer & | GetNumFmtBuffer () const |
| Returns the number format buffer. More... | |
| XclImpXFBuffer & | GetXFBuffer () const |
| Returns the cell formatting attributes buffer. More... | |
| XclImpXFRangeBuffer & | GetXFRangeBuffer () const |
| Returns the buffer of XF index ranges for a sheet. More... | |
| ScRangeListTabs & | GetPrintAreaBuffer () const |
| Returns the buffer that contains all print areas in the document. More... | |
| ScRangeListTabs & | GetTitleAreaBuffer () const |
| Returns the buffer that contains all print titles in the document. More... | |
| XclImpTabInfo & | GetTabInfo () const |
| Returns the buffer that contains the sheet creation order. More... | |
| XclImpNameManager & | GetNameManager () const |
| Returns the buffer that contains internal defined names. More... | |
| XclImpLinkManager & | GetLinkManager () const |
| Returns the link manager. More... | |
| XclImpObjectManager & | GetObjectManager () const |
| Returns the drawing object manager. More... | |
| XclImpSheetDrawing & | GetCurrSheetDrawing () const |
| Returns the drawing container of the current sheet. More... | |
| XclImpCondFormatManager & | GetCondFormatManager () const |
| Returns the conditional formatting manager. More... | |
| XclImpValidationManager & | GetValidationManager () const |
| XclImpAutoFilterBuffer & | GetFilterManager () const |
| Returns the filter manager. More... | |
| XclImpWebQueryBuffer & | GetWebQueryBuffer () const |
| Returns the web query buffer. More... | |
| XclImpPivotTableManager & | GetPivotTableManager () const |
| Returns the pivot table manager. More... | |
| XclImpSheetProtectBuffer & | GetSheetProtectBuffer () const |
| Returns the sheet protection options of the current sheet. More... | |
| XclImpDocProtectBuffer & | GetDocProtectBuffer () const |
| Returns the document protection options. More... | |
| XclImpPageSettings & | GetPageSettings () const |
| Returns the page settings of the current sheet. More... | |
| XclImpDocViewSettings & | GetDocViewSettings () const |
| Returns the view settings of the entire document. More... | |
| XclImpTabViewSettings & | GetTabViewSettings () const |
| Returns the view settings of the current sheet. More... | |
| bool | HasBasic () const |
| Returns true, if the document contains a VB project. More... | |
| void | SetHasBasic () |
| Called to indicate that the document contains a VB project. More... | |
| void | ReadCodeName (XclImpStream &rStrm, bool bGlobals) |
| Reads the CODENAME record and inserts the codename into the document. More... | |
| ScDocumentImport & | GetDocImport () |
| Protected Member Functions inherited from XclRoot | |
| XclRoot (XclRootData &rRootData) | |
| XclRoot (const XclRoot &rRoot) | |
| virtual | ~XclRoot () |
| XclRoot & | operator= (const XclRoot &rRoot) |
| RootData & | GetOldRoot () const |
| Returns old RootData struct. More... | |
| XclBiff | GetBiff () const |
| Returns the current BIFF version of the importer/exporter. More... | |
| XclOutput | GetOutput () const |
| Returns the current output format of the importer/exporter. More... | |
| bool | IsImport () const |
| Returns true, if currently a document is imported. More... | |
| rtl_TextEncoding | GetTextEncoding () const |
| Returns the text encoding to import/export byte strings. More... | |
| LanguageType | GetSysLanguage () const |
| Returns the system language, i.e. More... | |
| LanguageType | GetDocLanguage () const |
| Returns the document language. More... | |
| LanguageType | GetUILanguage () const |
| Returns the UI language. More... | |
| sal_Int16 | GetDefApiScript () const |
| Returns the default script type, e.g. More... | |
| tools::Long | GetCharWidth () const |
| Returns the width of the '0' character (default font) for the current printer (twips). More... | |
| tools::Long | GetSpaceWidth () const |
| bool | IsInGlobals () const |
| Returns the current Calc sheet index. More... | |
| SCTAB | GetCurrScTab () const |
| Returns the current Calc sheet index. More... | |
| sal_Int32 | GetHmmFromPixelX (double fPixelX) const |
| Calculates the width of the passed number of pixels in 1/100 mm. More... | |
| sal_Int32 | GetHmmFromPixelY (double fPixelY) const |
| Calculates the height of the passed number of pixels in 1/100 mm. More... | |
| SfxMedium & | GetMedium () const |
| Returns the medium to import from. More... | |
| const OUString & | GetDocUrl () const |
| Returns the document URL of the imported/exported file. More... | |
| const OUString & | GetBasePath () const |
| Returns the base path of the imported/exported file. More... | |
| const OUString & | GetUserName () const |
| Returns the current user name. More... | |
| css::uno::Sequence< css::beans::NamedValue > | RequestEncryptionData (::comphelper::IDocPasswordVerifier &rVerifier) const |
| Requests and verifies a password from the medium or the user. More... | |
| const tools::SvRef< SotStorage > & | GetRootStorage () const |
| Returns the OLE2 root storage of the imported/exported file. More... | |
| bool | HasVbaStorage () const |
| Returns true, if the document contains a VBA storage. More... | |
| tools::SvRef< SotStorage > | OpenStorage (tools::SvRef< SotStorage > const &xStrg, const OUString &rStrgName) const |
| Tries to open a storage as child of the specified storage for reading or writing. More... | |
| tools::SvRef< SotStorage > | OpenStorage (const OUString &rStrgName) const |
| Tries to open a storage as child of the root storage for reading or writing. More... | |
| tools::SvRef< SotStorageStream > | OpenStream (tools::SvRef< SotStorage > const &xStrg, const OUString &rStrmName) const |
| Tries to open a new stream in the specified storage for reading or writing. More... | |
| tools::SvRef< SotStorageStream > | OpenStream (const OUString &rStrmName) const |
| Tries to open a new stream in the root storage for reading or writing. More... | |
| ScDocument & | GetDoc () const |
| Returns reference to the destination document (import) or source document (export). More... | |
| SfxObjectShell * | GetDocShell () const |
| Returns the object shell of the Calc document. More... | |
| ScModelObj * | GetDocModelObj () const |
| Returns the object model of the Calc document. More... | |
| OutputDevice * | GetPrinter () const |
| Returns pointer to the printer of the Calc document. More... | |
| ScStyleSheetPool & | GetStyleSheetPool () const |
| Returns the style sheet pool of the Calc document. More... | |
| ScRangeName & | GetNamedRanges () const |
| Returns the defined names container of the Calc document. More... | |
| SdrPage * | GetSdrPage (SCTAB nScTab) const |
| Returns the drawing layer page of the passed sheet, if present. More... | |
| SvNumberFormatter & | GetFormatter () const |
| Returns the number formatter of the Calc document. More... | |
| DateTime | GetNullDate () const |
| Returns the null date of the current number formatter. More... | |
| sal_uInt16 | GetBaseYear () const |
| Returns the base year depending on the current null date (1900 or 1904). More... | |
| double | GetDoubleFromDateTime (const DateTime &rDateTime) const |
| Converts a date/time value to a floating-point value. More... | |
| DateTime | GetDateTimeFromDouble (double fValue) const |
| Converts a floating-point value to a date/time value. More... | |
| ScEditEngineDefaulter & | GetEditEngine () const |
| Returns the edit engine for import/export of rich strings etc. More... | |
| ScHeaderEditEngine & | GetHFEditEngine () const |
| Returns the edit engine for import/export of headers/footers. More... | |
| EditEngine & | GetDrawEditEngine () const |
| Returns the edit engine for import/export of drawing text boxes. More... | |
| XclFontPropSetHelper & | GetFontPropSetHelper () const |
| Returns the property set helper for fonts. More... | |
| XclChPropSetHelper & | GetChartPropSetHelper () const |
| Returns the property set helper for the chart filters. More... | |
| ScExtDocOptions & | GetExtDocOptions () const |
| Returns the extended document options. More... | |
| XclTracer & | GetTracer () const |
| Returns the filter tracer. More... | |
| const ScAddress & | GetScMaxPos () const |
| Returns the highest possible cell address in a Calc document. More... | |
| const ScAddress & | GetXclMaxPos () const |
| Returns the highest possible cell address in an Excel document (using current BIFF version). More... | |
| const ScAddress & | GetMaxPos () const |
| Returns the highest possible cell address valid in Calc and Excel (using current BIFF version). More... | |
| void | SetDocLanguage (LanguageType eLang) |
| Sets the document language. More... | |
| void | SetUILanguage (LanguageType eLang) |
| Sets the UI language, i.e. More... | |
| void | SetTextEncoding (rtl_TextEncoding eTextEnc) |
| Sets the text encoding to import/export byte strings. More... | |
| void | SetCharWidth (const XclFontData &rFontData) |
| Sets the width of the '0' - '9' digit character as well as the ' ' space char (using the default font) for the current printer (twips). More... | |
| void | SetCurrScTab (SCTAB nScTab) |
| Sets the current Calc sheet index. More... | |
| void | IncCurrScTab () |
| Increases the current Calc sheet index by 1. More... | |
| Static Protected Member Functions inherited from XclImpRoot | |
| static OUString | GetScAddInName (const OUString &rXclName) |
| Returns the Calc add-in function name for an Excel function name. More... | |
| Static Protected Member Functions inherited from XclRoot | |
| static OUString | GetDefaultPassword () |
| Returns the default password used for stream encryption. More... | |
Detailed Description
Imports validation data.
Definition at line 168 of file xicontent.hxx.
Constructor & Destructor Documentation
◆ XclImpValidationManager()
|
explicit |
Definition at line 745 of file xicontent.cxx.
Member Function Documentation
◆ Apply()
| void XclImpValidationManager::Apply | ( | ) |
Definition at line 933 of file xicontent.cxx.
References ScDocument::AddValidationEntry(), ScRange::aEnd, ScDocument::ApplyPatternAreaTab(), ScRange::aStart, ATTR_VALIDDATA(), ScAddress::Col(), XclRoot::GetDoc(), ScPatternAttr::GetItemSet(), ScDocument::GetPool(), XclImpRoot::GetRoot(), i, utl::ConfigManager::IsFuzzing(), maDVItems, XclImpValidationManager::DVItem::maRanges, XclImpValidationManager::DVItem::maValidData, nHandle, SfxItemSet::Put(), ScAddress::Row(), SAL_WARN, ScRangeList::size(), and ScAddress::Tab().
Referenced by ImportExcel8::EndSheet().
◆ ReadDV()
| void XclImpValidationManager::ReadDV | ( | XclImpStream & | rStrm | ) |
Reads a DV record and inserts validation data into the document.
Definition at line 765 of file xicontent.cxx.
References ScRange::aStart, Between, ScRangeList::Combine(), ExcelToSc::Convert(), XclImpAddressConverter::ConvertRangeList(), XclTokenArrayHelper::ConvertStringToList(), Direct, ScRangeList::empty(), EqGreater, EqLess, Equal, EXC_BIFF8, EXC_DV_COND_BETWEEN, EXC_DV_COND_EQGREATER, EXC_DV_COND_EQLESS, EXC_DV_COND_EQUAL, EXC_DV_COND_GREATER, EXC_DV_COND_LESS, EXC_DV_COND_MASK, EXC_DV_COND_NOTBETWEEN, EXC_DV_COND_NOTEQUAL, EXC_DV_ERROR_INFO, EXC_DV_ERROR_MASK, EXC_DV_ERROR_WARNING, EXC_DV_IGNOREBLANK, EXC_DV_MODE_ANY, EXC_DV_MODE_CUSTOM, EXC_DV_MODE_DATE, EXC_DV_MODE_DECIMAL, EXC_DV_MODE_LIST, EXC_DV_MODE_MASK, EXC_DV_MODE_TEXTLEN, EXC_DV_MODE_TIME, EXC_DV_MODE_WHOLE, EXC_DV_SHOWERROR, EXC_DV_SHOWPROMPT, EXC_DV_STRINGLIST, EXC_DV_SUPPRESSDROPDOWN, ScRangeList::front(), FT_CondFormat, get_flag(), get_flagvalue(), XclImpRoot::GetAddressConverter(), XclRoot::GetBiff(), XclRoot::GetCurrScTab(), XclRoot::GetDoc(), XclImpRoot::GetOldFmlaConverter(), ScDocument::GetSharedStringPool(), XclRoot::GetTracer(), Greater, Less, maDVItems, XclImpValidationManager::DVItem::maValidData, NotBetween, NotEqual, OSL_ENSURE_BIFF, ExcelConverterBase::Reset(), ScValidationData::ResetError(), ScValidationData::ResetInput(), rStrm, SC_VALERR_INFO, SC_VALERR_STOP, SC_VALERR_WARNING, SC_VALID_ANY, SC_VALID_CUSTOM, SC_VALID_DATE, SC_VALID_DECIMAL, SC_VALID_LIST, SC_VALID_TEXTLEN, SC_VALID_TIME, SC_VALID_WHOLE, ScValidationData::SetError(), ScConditionEntry::SetIgnoreBlank(), ScValidationData::SetInput(), ScValidationData::SetListType(), and XclTracer::TraceDVType().
Referenced by ImportExcel8::Read().
◆ ReadDval()
|
static |
Reads a DVAL record and sets marks the dropdown arrow control to be ignored.
Definition at line 750 of file xicontent.cxx.
References EXC_BIFF8, EXC_DVAL_NOOBJ, XclRoot::GetBiff(), XclImpRoot::GetCurrSheetDrawing(), OSL_ENSURE_BIFF, rStrm, and XclImpDrawing::SetSkipObj().
Referenced by ImportExcel8::Read().
Member Data Documentation
◆ maDVItems
|
private |
Definition at line 188 of file xicontent.hxx.
The documentation for this class was generated from the following files:
