23 #include <com/sun/star/sheet/XSpreadsheet.hpp>
28 #include <oox/token/properties.hxx>
29 #include <oox/token/tokens.hxx>
32 #include <document.hxx>
42 const sal_uInt8 BIFF12_SHEETPR_FILTERMODE = 0x01;
44 const sal_uInt16 BIFF_SHEETPR_APPLYSTYLES = 0x0020;
45 const sal_uInt16 BIFF_SHEETPR_SYMBOLSBELOW = 0x0040;
46 const sal_uInt16 BIFF_SHEETPR_SYMBOLSRIGHT = 0x0080;
47 const sal_uInt16 BIFF_SHEETPR_FITTOPAGES = 0x0100;
52 mbFilterMode( false ),
53 mbApplyStyles( false ),
54 mbSummaryBelow( true ),
55 mbSummaryRight( true )
65 mbFormatCells( true ),
66 mbFormatColumns( true ),
68 mbInsertColumns( true ),
70 mbInsertHyperlinks( true ),
71 mbDeleteColumns( true ),
73 mbSelectLocked( false ),
76 mbPivotTables( true ),
77 mbSelectUnlocked( false )
83 maPhoneticSett( rHelper )
153 OUString aRefs( rAttribs.
getString( XML_sqref, OUString()));
154 if (!aRefs.isEmpty())
156 std::unique_ptr<ScRangeList> xRangeList(
new ScRangeList());
158 if (!xRangeList->empty())
254 Sequence<sal_Int8> aPass{
bool mbInsertHyperlinks
True = insert rows locked.
OptValue< bool > getBool(sal_Int32 nAttrToken) const
sal_uInt32 mnSpinCount
Salt value to be prepended to the password, base-64 encoded.
bool mbSheet
Hash value from sheet protection password. (unrelated to the above)
ScRangeListRef maRangeList
SC_DLLPUBLIC void SetTabProtection(SCTAB nTab, const ScTableProtection *pProtect)
sheet protection state container
SheetSettingsModel maSheetSettings
OUString maSaltValue
base64 encoded hash value
virtual void setPasswordHash(const css::uno::Sequence< sal_Int8 > &aPassword, ScPasswordHash eHash, ScPasswordHash eHash2=PASSHASH_UNSPECIFIED) override
ScDocument & getScDocument()
bool mbSummaryRight
True = row outline symbols below group.
OptValue< OUString > getString(sal_Int32 nAttrToken) const
OOX_DLLPUBLIC sal_uInt16 getPasswordHash(const AttributeList &rAttribs, sal_Int32 nElement)
void importOutlinePr(const AttributeList &rAttribs)
Imports outline settings from the outlinePr element.
bool mbSelectUnlocked
True = pivot tables locked.
void importPhoneticPr(const AttributeList &rAttribs)
Imports phonetic settings from the phoneticPr element.
OUString maHashValue
"SHA-512", ...
bool mbDeleteColumns
True = insert hyperlinks locked.
void setOption(Option eOption, bool bEnabled)
bool mbAutoFilter
True = sorting locked.
virtual void setProtected(bool bProtected) override
void importProtectedRange(const AttributeList &rAttribs)
Imports enhanced protection settings from the protectedRange element.
::oox::core::FilterBase & getBaseFilter() const
Returns the base filter object (base class of all filters).
OUString maSaltValue
Hash value computed by the algorithm, base-64 encoded.
bool mbDeleteRows
True = delete columns locked.
bool mbFormatColumns
True = format cells locked.
OUString maSecurityDescriptorXML
OptValue< sal_uInt32 > getUnsigned(sal_Int32 nAttrToken) const
bool getFlag(Type nBitField, Type nMask)
::std::vector< ScEnhancedProtection > maEnhancedProtections
True = select unlocked cells locked.
bool mbObjects
True = sheet protection enabled, locked cells are protected.
void importColor(const AttributeList &rAttribs)
Imports the color from the passed attribute list.
bool mbInsertColumns
True = format rows locked.
bool mbSummaryBelow
True = automatic styles when creating outlines.
::Color getColor(const GraphicHelper &rGraphicHelper,::Color nPhClr=API_RGB_TRANSPARENT) const
void importSheetPr(const AttributeList &rAttribs)
Imports sheet settings from the sheetPr element.
bool mbFormatRows
True = format columns locked.
OUString maHashValue
Algorithm name, "SHA-512", "SHA-1", ...
void convertToCellRangeList(ScRangeList &orRanges, const OUString &rString, sal_Int16 nSheet, bool bTrackOverflow)
Tries to convert the passed string to a cell range list.
bool mbSort
True = select locked cells locked.
Container for the Excel EnhancedProtection feature.
bool mbPivotTables
True = autofilters locked.
SheetSettingsModel()
True = column outline symbols right of group.
sal_uInt16 mnPasswordHash
Spin count, iterations to run algorithm.
void importChartSheetPr(const AttributeList &rAttribs)
Imports chart sheet settings from the sheetPr element.
bool mbFormatCells
True = scenarios locked.
bool mbApplyStyles
True = sheet contains active filter.
PhoneticSettings maPhoneticSett
OptValue< sal_Int32 > getIntegerHex(sal_Int32 nAttrToken) const
void importPhoneticPr(const AttributeList &rAttribs)
Imports phonetic settings from the phoneticPr element.
const css::uno::Reference< css::sheet::XSpreadsheet > & getSheet() const
Returns the XSpreadsheet interface of the current sheet.
void setEnhancedProtection(const ::std::vector< ScEnhancedProtection > &rProt)
bool mbFilterMode
Sheet tab color.
sal_uInt32 mnPasswordVerifier
SCTAB getSheetIndex() const
Returns the index of the current sheet.
bool mbInsertRows
True = insert columns locked.
Color maTabColor
VBA module codename.
void importChartProtection(const AttributeList &rAttribs)
Imports protection settings from the sheetProtection element of a chart sheet.
void finalizeImport()
Converts the imported worksheet settings.
WorksheetSettings(const WorksheetHelper &rHelper)
bool mbScenarios
True = objects locked.
void setFitToPagesMode(bool bFitToPages)
Sets whether percentual scaling or fit to width/height scaling is used.
bool mbSelectLocked
True = delete rows locked.
void importTabColor(const AttributeList &rAttribs)
Imports the sheet tab color from the tabColor element.
ScOoxPasswordHash maPasswordHash
sal_uInt32 mnSpinCount
base64 encoded salt value
SheetProtectionModel maSheetProt
void importSheetProtection(const AttributeList &rAttribs)
Imports protection settings from the sheetProtection element.
bool setProperty(sal_Int32 nPropId, const Type &rValue)
PageSettings & getPageSettings() const
Returns the page/print settings for this sheet.
AddressConverter & getAddressConverter() const
Returns the converter for string to cell address/range conversion.
bool isAuto() const
Returns true, if the color is set to automatic.