1*ca5ec200SAndrew Rist /**************************************************************
2cdf0e10cSrcweir *
3*ca5ec200SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one
4*ca5ec200SAndrew Rist * or more contributor license agreements. See the NOTICE file
5*ca5ec200SAndrew Rist * distributed with this work for additional information
6*ca5ec200SAndrew Rist * regarding copyright ownership. The ASF licenses this file
7*ca5ec200SAndrew Rist * to you under the Apache License, Version 2.0 (the
8*ca5ec200SAndrew Rist * "License"); you may not use this file except in compliance
9*ca5ec200SAndrew Rist * with the License. You may obtain a copy of the License at
10*ca5ec200SAndrew Rist *
11*ca5ec200SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0
12*ca5ec200SAndrew Rist *
13*ca5ec200SAndrew Rist * Unless required by applicable law or agreed to in writing,
14*ca5ec200SAndrew Rist * software distributed under the License is distributed on an
15*ca5ec200SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*ca5ec200SAndrew Rist * KIND, either express or implied. See the License for the
17*ca5ec200SAndrew Rist * specific language governing permissions and limitations
18*ca5ec200SAndrew Rist * under the License.
19*ca5ec200SAndrew Rist *
20*ca5ec200SAndrew Rist *************************************************************/
21*ca5ec200SAndrew Rist
22*ca5ec200SAndrew Rist
23cdf0e10cSrcweir
24cdf0e10cSrcweir #include "oox/xls/worksheetsettings.hxx"
25cdf0e10cSrcweir
26cdf0e10cSrcweir #include <com/sun/star/util/XProtectable.hpp>
27cdf0e10cSrcweir #include "oox/core/filterbase.hxx"
28cdf0e10cSrcweir #include "oox/helper/attributelist.hxx"
29cdf0e10cSrcweir #include "oox/xls/biffinputstream.hxx"
30cdf0e10cSrcweir #include "oox/xls/pagesettings.hxx"
31cdf0e10cSrcweir #include "oox/xls/workbooksettings.hxx"
32cdf0e10cSrcweir
33cdf0e10cSrcweir namespace oox {
34cdf0e10cSrcweir namespace xls {
35cdf0e10cSrcweir
36cdf0e10cSrcweir // ============================================================================
37cdf0e10cSrcweir
38cdf0e10cSrcweir using namespace ::com::sun::star::beans;
39cdf0e10cSrcweir using namespace ::com::sun::star::uno;
40cdf0e10cSrcweir using namespace ::com::sun::star::util;
41cdf0e10cSrcweir
42cdf0e10cSrcweir using ::oox::core::CodecHelper;
43cdf0e10cSrcweir using ::rtl::OUString;
44cdf0e10cSrcweir
45cdf0e10cSrcweir // ============================================================================
46cdf0e10cSrcweir
47cdf0e10cSrcweir namespace {
48cdf0e10cSrcweir
49cdf0e10cSrcweir const sal_uInt8 BIFF12_SHEETPR_FILTERMODE = 0x01;
50cdf0e10cSrcweir const sal_uInt8 BIFF12_SHEETPR_EVAL_CF = 0x02;
51cdf0e10cSrcweir
52cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETEXT_NOTABCOLOR = 0x7F;
53cdf0e10cSrcweir
54cdf0e10cSrcweir const sal_uInt16 BIFF_SHEETPR_DIALOGSHEET = 0x0010;
55cdf0e10cSrcweir const sal_uInt16 BIFF_SHEETPR_APPLYSTYLES = 0x0020;
56cdf0e10cSrcweir const sal_uInt16 BIFF_SHEETPR_SYMBOLSBELOW = 0x0040;
57cdf0e10cSrcweir const sal_uInt16 BIFF_SHEETPR_SYMBOLSRIGHT = 0x0080;
58cdf0e10cSrcweir const sal_uInt16 BIFF_SHEETPR_FITTOPAGES = 0x0100;
59cdf0e10cSrcweir const sal_uInt16 BIFF_SHEETPR_SKIPEXT = 0x0200; // BIFF3-BIFF4
60cdf0e10cSrcweir
61cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_OBJECTS = 0x00000001;
62cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_SCENARIOS = 0x00000002;
63cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_FORMAT_CELLS = 0x00000004;
64cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_FORMAT_COLUMNS = 0x00000008;
65cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_FORMAT_ROWS = 0x00000010;
66cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_INSERT_COLUMNS = 0x00000020;
67cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_INSERT_ROWS = 0x00000040;
68cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_INSERT_HLINKS = 0x00000080;
69cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_DELETE_COLUMNS = 0x00000100;
70cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_DELETE_ROWS = 0x00000200;
71cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_SELECT_LOCKED = 0x00000400;
72cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_SORT = 0x00000800;
73cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_AUTOFILTER = 0x00001000;
74cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_PIVOTTABLES = 0x00002000;
75cdf0e10cSrcweir const sal_uInt32 BIFF_SHEETPROT_SELECT_UNLOCKED = 0x00004000;
76cdf0e10cSrcweir
77cdf0e10cSrcweir } // namespace
78cdf0e10cSrcweir
79cdf0e10cSrcweir // ============================================================================
80cdf0e10cSrcweir
SheetSettingsModel()81cdf0e10cSrcweir SheetSettingsModel::SheetSettingsModel() :
82cdf0e10cSrcweir mbFilterMode( false ),
83cdf0e10cSrcweir mbApplyStyles( false ),
84cdf0e10cSrcweir mbSummaryBelow( true ),
85cdf0e10cSrcweir mbSummaryRight( true )
86cdf0e10cSrcweir {
87cdf0e10cSrcweir }
88cdf0e10cSrcweir
89cdf0e10cSrcweir // ============================================================================
90cdf0e10cSrcweir
SheetProtectionModel()91cdf0e10cSrcweir SheetProtectionModel::SheetProtectionModel() :
92cdf0e10cSrcweir mnPasswordHash( 0 ),
93cdf0e10cSrcweir mbSheet( false ),
94cdf0e10cSrcweir mbObjects( false ),
95cdf0e10cSrcweir mbScenarios( false ),
96cdf0e10cSrcweir mbFormatCells( true ),
97cdf0e10cSrcweir mbFormatColumns( true ),
98cdf0e10cSrcweir mbFormatRows( true ),
99cdf0e10cSrcweir mbInsertColumns( true ),
100cdf0e10cSrcweir mbInsertRows( true ),
101cdf0e10cSrcweir mbInsertHyperlinks( true ),
102cdf0e10cSrcweir mbDeleteColumns( true ),
103cdf0e10cSrcweir mbDeleteRows( true ),
104cdf0e10cSrcweir mbSelectLocked( false ),
105cdf0e10cSrcweir mbSort( true ),
106cdf0e10cSrcweir mbAutoFilter( true ),
107cdf0e10cSrcweir mbPivotTables( true ),
108cdf0e10cSrcweir mbSelectUnlocked( false )
109cdf0e10cSrcweir {
110cdf0e10cSrcweir }
111cdf0e10cSrcweir
112cdf0e10cSrcweir // ============================================================================
113cdf0e10cSrcweir
WorksheetSettings(const WorksheetHelper & rHelper)114cdf0e10cSrcweir WorksheetSettings::WorksheetSettings( const WorksheetHelper& rHelper ) :
115cdf0e10cSrcweir WorksheetHelper( rHelper ),
116cdf0e10cSrcweir maPhoneticSett( rHelper )
117cdf0e10cSrcweir {
118cdf0e10cSrcweir }
119cdf0e10cSrcweir
importSheetPr(const AttributeList & rAttribs)120cdf0e10cSrcweir void WorksheetSettings::importSheetPr( const AttributeList& rAttribs )
121cdf0e10cSrcweir {
122cdf0e10cSrcweir maSheetSettings.maCodeName = rAttribs.getString( XML_codeName, OUString() );
123cdf0e10cSrcweir maSheetSettings.mbFilterMode = rAttribs.getBool( XML_filterMode, false );
124cdf0e10cSrcweir }
125cdf0e10cSrcweir
importChartSheetPr(const AttributeList & rAttribs)126cdf0e10cSrcweir void WorksheetSettings::importChartSheetPr( const AttributeList& rAttribs )
127cdf0e10cSrcweir {
128cdf0e10cSrcweir maSheetSettings.maCodeName = rAttribs.getString( XML_codeName, OUString() );
129cdf0e10cSrcweir }
130cdf0e10cSrcweir
importTabColor(const AttributeList & rAttribs)131cdf0e10cSrcweir void WorksheetSettings::importTabColor( const AttributeList& rAttribs )
132cdf0e10cSrcweir {
133cdf0e10cSrcweir maSheetSettings.maTabColor.importColor( rAttribs );
134cdf0e10cSrcweir }
135cdf0e10cSrcweir
importOutlinePr(const AttributeList & rAttribs)136cdf0e10cSrcweir void WorksheetSettings::importOutlinePr( const AttributeList& rAttribs )
137cdf0e10cSrcweir {
138cdf0e10cSrcweir maSheetSettings.mbApplyStyles = rAttribs.getBool( XML_applyStyles, false );
139cdf0e10cSrcweir maSheetSettings.mbSummaryBelow = rAttribs.getBool( XML_summaryBelow, true );
140cdf0e10cSrcweir maSheetSettings.mbSummaryRight = rAttribs.getBool( XML_summaryRight, true );
141cdf0e10cSrcweir }
142cdf0e10cSrcweir
importSheetProtection(const AttributeList & rAttribs)143cdf0e10cSrcweir void WorksheetSettings::importSheetProtection( const AttributeList& rAttribs )
144cdf0e10cSrcweir {
145cdf0e10cSrcweir maSheetProt.mnPasswordHash = CodecHelper::getPasswordHash( rAttribs, XML_password );
146cdf0e10cSrcweir maSheetProt.mbSheet = rAttribs.getBool( XML_sheet, false );
147cdf0e10cSrcweir maSheetProt.mbObjects = rAttribs.getBool( XML_objects, false );
148cdf0e10cSrcweir maSheetProt.mbScenarios = rAttribs.getBool( XML_scenarios, false );
149cdf0e10cSrcweir maSheetProt.mbFormatCells = rAttribs.getBool( XML_formatCells, true );
150cdf0e10cSrcweir maSheetProt.mbFormatColumns = rAttribs.getBool( XML_formatColumns, true );
151cdf0e10cSrcweir maSheetProt.mbFormatRows = rAttribs.getBool( XML_formatRows, true );
152cdf0e10cSrcweir maSheetProt.mbInsertColumns = rAttribs.getBool( XML_insertColumns, true );
153cdf0e10cSrcweir maSheetProt.mbInsertRows = rAttribs.getBool( XML_insertRows, true );
154cdf0e10cSrcweir maSheetProt.mbInsertHyperlinks = rAttribs.getBool( XML_insertHyperlinks, true );
155cdf0e10cSrcweir maSheetProt.mbDeleteColumns = rAttribs.getBool( XML_deleteColumns, true );
156cdf0e10cSrcweir maSheetProt.mbDeleteRows = rAttribs.getBool( XML_deleteRows, true );
157cdf0e10cSrcweir maSheetProt.mbSelectLocked = rAttribs.getBool( XML_selectLockedCells, false );
158cdf0e10cSrcweir maSheetProt.mbSort = rAttribs.getBool( XML_sort, true );
159cdf0e10cSrcweir maSheetProt.mbAutoFilter = rAttribs.getBool( XML_autoFilter, true );
160cdf0e10cSrcweir maSheetProt.mbPivotTables = rAttribs.getBool( XML_pivotTables, true );
161cdf0e10cSrcweir maSheetProt.mbSelectUnlocked = rAttribs.getBool( XML_selectUnlockedCells, false );
162cdf0e10cSrcweir }
163cdf0e10cSrcweir
importChartProtection(const AttributeList & rAttribs)164cdf0e10cSrcweir void WorksheetSettings::importChartProtection( const AttributeList& rAttribs )
165cdf0e10cSrcweir {
166cdf0e10cSrcweir maSheetProt.mnPasswordHash = CodecHelper::getPasswordHash( rAttribs, XML_password );
167cdf0e10cSrcweir maSheetProt.mbSheet = rAttribs.getBool( XML_content, false );
168cdf0e10cSrcweir maSheetProt.mbObjects = rAttribs.getBool( XML_objects, false );
169cdf0e10cSrcweir }
170cdf0e10cSrcweir
importPhoneticPr(const AttributeList & rAttribs)171cdf0e10cSrcweir void WorksheetSettings::importPhoneticPr( const AttributeList& rAttribs )
172cdf0e10cSrcweir {
173cdf0e10cSrcweir maPhoneticSett.importPhoneticPr( rAttribs );
174cdf0e10cSrcweir }
175cdf0e10cSrcweir
importSheetPr(SequenceInputStream & rStrm)176cdf0e10cSrcweir void WorksheetSettings::importSheetPr( SequenceInputStream& rStrm )
177cdf0e10cSrcweir {
178cdf0e10cSrcweir sal_uInt16 nFlags1;
179cdf0e10cSrcweir sal_uInt8 nFlags2;
180cdf0e10cSrcweir rStrm >> nFlags1 >> nFlags2 >> maSheetSettings.maTabColor;
181cdf0e10cSrcweir rStrm.skip( 8 ); // sync anchor cell
182cdf0e10cSrcweir rStrm >> maSheetSettings.maCodeName;
183cdf0e10cSrcweir // sheet settings
184cdf0e10cSrcweir maSheetSettings.mbFilterMode = getFlag( nFlags2, BIFF12_SHEETPR_FILTERMODE );
185cdf0e10cSrcweir // outline settings, equal flags in all BIFFs
186cdf0e10cSrcweir maSheetSettings.mbApplyStyles = getFlag( nFlags1, BIFF_SHEETPR_APPLYSTYLES );
187cdf0e10cSrcweir maSheetSettings.mbSummaryRight = getFlag( nFlags1, BIFF_SHEETPR_SYMBOLSRIGHT );
188cdf0e10cSrcweir maSheetSettings.mbSummaryBelow = getFlag( nFlags1, BIFF_SHEETPR_SYMBOLSBELOW );
189cdf0e10cSrcweir /* Fit printout to width/height - for whatever reason, this flag is still
190cdf0e10cSrcweir stored separated from the page settings */
191cdf0e10cSrcweir getPageSettings().setFitToPagesMode( getFlag( nFlags1, BIFF_SHEETPR_FITTOPAGES ) );
192cdf0e10cSrcweir }
193cdf0e10cSrcweir
importChartSheetPr(SequenceInputStream & rStrm)194cdf0e10cSrcweir void WorksheetSettings::importChartSheetPr( SequenceInputStream& rStrm )
195cdf0e10cSrcweir {
196cdf0e10cSrcweir rStrm.skip( 2 ); // flags, contains only the 'published' flag
197cdf0e10cSrcweir rStrm >> maSheetSettings.maTabColor >> maSheetSettings.maCodeName;
198cdf0e10cSrcweir }
199cdf0e10cSrcweir
importSheetProtection(SequenceInputStream & rStrm)200cdf0e10cSrcweir void WorksheetSettings::importSheetProtection( SequenceInputStream& rStrm )
201cdf0e10cSrcweir {
202cdf0e10cSrcweir rStrm >> maSheetProt.mnPasswordHash;
203cdf0e10cSrcweir // no flags field for all these boolean flags?!?
204cdf0e10cSrcweir maSheetProt.mbSheet = rStrm.readInt32() != 0;
205cdf0e10cSrcweir maSheetProt.mbObjects = rStrm.readInt32() != 0;
206cdf0e10cSrcweir maSheetProt.mbScenarios = rStrm.readInt32() != 0;
207cdf0e10cSrcweir maSheetProt.mbFormatCells = rStrm.readInt32() != 0;
208cdf0e10cSrcweir maSheetProt.mbFormatColumns = rStrm.readInt32() != 0;
209cdf0e10cSrcweir maSheetProt.mbFormatRows = rStrm.readInt32() != 0;
210cdf0e10cSrcweir maSheetProt.mbInsertColumns = rStrm.readInt32() != 0;
211cdf0e10cSrcweir maSheetProt.mbInsertRows = rStrm.readInt32() != 0;
212cdf0e10cSrcweir maSheetProt.mbInsertHyperlinks = rStrm.readInt32() != 0;
213cdf0e10cSrcweir maSheetProt.mbDeleteColumns = rStrm.readInt32() != 0;
214cdf0e10cSrcweir maSheetProt.mbDeleteRows = rStrm.readInt32() != 0;
215cdf0e10cSrcweir maSheetProt.mbSelectLocked = rStrm.readInt32() != 0;
216cdf0e10cSrcweir maSheetProt.mbSort = rStrm.readInt32() != 0;
217cdf0e10cSrcweir maSheetProt.mbAutoFilter = rStrm.readInt32() != 0;
218cdf0e10cSrcweir maSheetProt.mbPivotTables = rStrm.readInt32() != 0;
219cdf0e10cSrcweir maSheetProt.mbSelectUnlocked = rStrm.readInt32() != 0;
220cdf0e10cSrcweir }
221cdf0e10cSrcweir
importChartProtection(SequenceInputStream & rStrm)222cdf0e10cSrcweir void WorksheetSettings::importChartProtection( SequenceInputStream& rStrm )
223cdf0e10cSrcweir {
224cdf0e10cSrcweir rStrm >> maSheetProt.mnPasswordHash;
225cdf0e10cSrcweir // no flags field for all these boolean flags?!?
226cdf0e10cSrcweir maSheetProt.mbSheet = rStrm.readInt32() != 0;
227cdf0e10cSrcweir maSheetProt.mbObjects = rStrm.readInt32() != 0;
228cdf0e10cSrcweir }
229cdf0e10cSrcweir
importPhoneticPr(SequenceInputStream & rStrm)230cdf0e10cSrcweir void WorksheetSettings::importPhoneticPr( SequenceInputStream& rStrm )
231cdf0e10cSrcweir {
232cdf0e10cSrcweir maPhoneticSett.importPhoneticPr( rStrm );
233cdf0e10cSrcweir }
234cdf0e10cSrcweir
importSheetExt(BiffInputStream & rStrm)235cdf0e10cSrcweir void WorksheetSettings::importSheetExt( BiffInputStream& rStrm )
236cdf0e10cSrcweir {
237cdf0e10cSrcweir rStrm.skip( 16 );
238cdf0e10cSrcweir sal_uInt32 nFlags;
239cdf0e10cSrcweir rStrm >> nFlags;
240cdf0e10cSrcweir sal_uInt8 nColorIdx = extractValue< sal_uInt8 >( nFlags, 0, 7 );
241cdf0e10cSrcweir if( nColorIdx != BIFF_SHEETEXT_NOTABCOLOR )
242cdf0e10cSrcweir maSheetSettings.maTabColor.setPaletteClr( nColorIdx );
243cdf0e10cSrcweir }
244cdf0e10cSrcweir
importSheetPr(BiffInputStream & rStrm)245cdf0e10cSrcweir void WorksheetSettings::importSheetPr( BiffInputStream& rStrm )
246cdf0e10cSrcweir {
247cdf0e10cSrcweir sal_uInt16 nFlags;
248cdf0e10cSrcweir rStrm >> nFlags;
249cdf0e10cSrcweir // worksheet vs. dialogsheet
250cdf0e10cSrcweir if( getFlag( nFlags, BIFF_SHEETPR_DIALOGSHEET ) )
251cdf0e10cSrcweir {
252cdf0e10cSrcweir OSL_ENSURE( getSheetType() == SHEETTYPE_WORKSHEET, "WorksheetSettings::importSheetPr - unexpected sheet type" );
253cdf0e10cSrcweir setSheetType( SHEETTYPE_DIALOGSHEET );
254cdf0e10cSrcweir }
255cdf0e10cSrcweir // outline settings
256cdf0e10cSrcweir maSheetSettings.mbApplyStyles = getFlag( nFlags, BIFF_SHEETPR_APPLYSTYLES );
257cdf0e10cSrcweir maSheetSettings.mbSummaryRight = getFlag( nFlags, BIFF_SHEETPR_SYMBOLSRIGHT );
258cdf0e10cSrcweir maSheetSettings.mbSummaryBelow = getFlag( nFlags, BIFF_SHEETPR_SYMBOLSBELOW );
259cdf0e10cSrcweir // fit printout to width/height
260cdf0e10cSrcweir getPageSettings().setFitToPagesMode( getFlag( nFlags, BIFF_SHEETPR_FITTOPAGES ) );
261cdf0e10cSrcweir // save external linked values, in BIFF5-BIFF8 moved to BOOKBOOK record
262cdf0e10cSrcweir if( getBiff() <= BIFF4 )
263cdf0e10cSrcweir getWorkbookSettings().setSaveExtLinkValues( !getFlag( nFlags, BIFF_SHEETPR_SKIPEXT ) );
264cdf0e10cSrcweir }
265cdf0e10cSrcweir
importProtect(BiffInputStream & rStrm)266cdf0e10cSrcweir void WorksheetSettings::importProtect( BiffInputStream& rStrm )
267cdf0e10cSrcweir {
268cdf0e10cSrcweir maSheetProt.mbSheet = rStrm.readuInt16() != 0;
269cdf0e10cSrcweir }
270cdf0e10cSrcweir
importObjectProtect(BiffInputStream & rStrm)271cdf0e10cSrcweir void WorksheetSettings::importObjectProtect( BiffInputStream& rStrm )
272cdf0e10cSrcweir {
273cdf0e10cSrcweir maSheetProt.mbObjects = rStrm.readuInt16() != 0;
274cdf0e10cSrcweir }
275cdf0e10cSrcweir
importScenProtect(BiffInputStream & rStrm)276cdf0e10cSrcweir void WorksheetSettings::importScenProtect( BiffInputStream& rStrm )
277cdf0e10cSrcweir {
278cdf0e10cSrcweir maSheetProt.mbScenarios = rStrm.readuInt16() != 0;
279cdf0e10cSrcweir }
280cdf0e10cSrcweir
importPassword(BiffInputStream & rStrm)281cdf0e10cSrcweir void WorksheetSettings::importPassword( BiffInputStream& rStrm )
282cdf0e10cSrcweir {
283cdf0e10cSrcweir rStrm >> maSheetProt.mnPasswordHash;
284cdf0e10cSrcweir }
285cdf0e10cSrcweir
importSheetProtection(BiffInputStream & rStrm)286cdf0e10cSrcweir void WorksheetSettings::importSheetProtection( BiffInputStream& rStrm )
287cdf0e10cSrcweir {
288cdf0e10cSrcweir sal_uInt32 nFlags = rStrm.readuInt32();
289cdf0e10cSrcweir // set flag means protection is disabled
290cdf0e10cSrcweir maSheetProt.mbObjects = !getFlag( nFlags, BIFF_SHEETPROT_OBJECTS );
291cdf0e10cSrcweir maSheetProt.mbScenarios = !getFlag( nFlags, BIFF_SHEETPROT_SCENARIOS );
292cdf0e10cSrcweir maSheetProt.mbFormatCells = !getFlag( nFlags, BIFF_SHEETPROT_FORMAT_CELLS );
293cdf0e10cSrcweir maSheetProt.mbFormatColumns = !getFlag( nFlags, BIFF_SHEETPROT_FORMAT_COLUMNS );
294cdf0e10cSrcweir maSheetProt.mbFormatRows = !getFlag( nFlags, BIFF_SHEETPROT_FORMAT_ROWS );
295cdf0e10cSrcweir maSheetProt.mbInsertColumns = !getFlag( nFlags, BIFF_SHEETPROT_INSERT_COLUMNS );
296cdf0e10cSrcweir maSheetProt.mbInsertRows = !getFlag( nFlags, BIFF_SHEETPROT_INSERT_ROWS );
297cdf0e10cSrcweir maSheetProt.mbInsertHyperlinks = !getFlag( nFlags, BIFF_SHEETPROT_INSERT_HLINKS );
298cdf0e10cSrcweir maSheetProt.mbDeleteColumns = !getFlag( nFlags, BIFF_SHEETPROT_DELETE_COLUMNS );
299cdf0e10cSrcweir maSheetProt.mbDeleteRows = !getFlag( nFlags, BIFF_SHEETPROT_DELETE_ROWS );
300cdf0e10cSrcweir maSheetProt.mbSelectLocked = !getFlag( nFlags, BIFF_SHEETPROT_SELECT_LOCKED );
301cdf0e10cSrcweir maSheetProt.mbSort = !getFlag( nFlags, BIFF_SHEETPROT_SORT );
302cdf0e10cSrcweir maSheetProt.mbAutoFilter = !getFlag( nFlags, BIFF_SHEETPROT_AUTOFILTER );
303cdf0e10cSrcweir maSheetProt.mbPivotTables = !getFlag( nFlags, BIFF_SHEETPROT_PIVOTTABLES );
304cdf0e10cSrcweir maSheetProt.mbSelectUnlocked = !getFlag( nFlags, BIFF_SHEETPROT_SELECT_UNLOCKED );
305cdf0e10cSrcweir }
306cdf0e10cSrcweir
importCodeName(BiffInputStream & rStrm)307cdf0e10cSrcweir void WorksheetSettings::importCodeName( BiffInputStream& rStrm )
308cdf0e10cSrcweir {
309cdf0e10cSrcweir maSheetSettings.maCodeName = rStrm.readUniString();
310cdf0e10cSrcweir }
311cdf0e10cSrcweir
importPhoneticPr(BiffInputStream & rStrm)312cdf0e10cSrcweir void WorksheetSettings::importPhoneticPr( BiffInputStream& rStrm )
313cdf0e10cSrcweir {
314cdf0e10cSrcweir maPhoneticSett.importPhoneticPr( rStrm );
315cdf0e10cSrcweir }
316cdf0e10cSrcweir
finalizeImport()317cdf0e10cSrcweir void WorksheetSettings::finalizeImport()
318cdf0e10cSrcweir {
319cdf0e10cSrcweir // sheet protection
320cdf0e10cSrcweir if( maSheetProt.mbSheet ) try
321cdf0e10cSrcweir {
322cdf0e10cSrcweir Reference< XProtectable > xProtectable( getSheet(), UNO_QUERY_THROW );
323cdf0e10cSrcweir xProtectable->protect( OUString() );
324cdf0e10cSrcweir }
325cdf0e10cSrcweir catch( Exception& )
326cdf0e10cSrcweir {
327cdf0e10cSrcweir }
328cdf0e10cSrcweir
329cdf0e10cSrcweir // VBA code name
330cdf0e10cSrcweir PropertySet aPropSet( getSheet() );
331cdf0e10cSrcweir aPropSet.setProperty( PROP_CodeName, maSheetSettings.maCodeName );
332cdf0e10cSrcweir
333cdf0e10cSrcweir // sheet tab color
334cdf0e10cSrcweir if( !maSheetSettings.maTabColor.isAuto() )
335cdf0e10cSrcweir {
336cdf0e10cSrcweir sal_Int32 nColor = maSheetSettings.maTabColor.getColor( getBaseFilter().getGraphicHelper() );
337cdf0e10cSrcweir aPropSet.setProperty( PROP_TabColor, nColor );
338cdf0e10cSrcweir }
339cdf0e10cSrcweir }
340cdf0e10cSrcweir
341cdf0e10cSrcweir // ============================================================================
342cdf0e10cSrcweir
343cdf0e10cSrcweir } // namespace xls
344cdf0e10cSrcweir } // namespace oox
345