Line data Source code
1 : /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 : /*
3 : * This file is part of the LibreOffice project.
4 : *
5 : * This Source Code Form is subject to the terms of the Mozilla Public
6 : * License, v. 2.0. If a copy of the MPL was not distributed with this
7 : * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8 : *
9 : * This file incorporates work covered by the following license notice:
10 : *
11 : * Licensed to the Apache Software Foundation (ASF) under one or more
12 : * contributor license agreements. See the NOTICE file distributed
13 : * with this work for additional information regarding copyright
14 : * ownership. The ASF licenses this file to you under the Apache
15 : * License, Version 2.0 (the "License"); you may not use this file
16 : * except in compliance with the License. You may obtain a copy of
17 : * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18 : */
19 :
20 : #include "workbooksettings.hxx"
21 :
22 : #include <com/sun/star/sheet/XCalculatable.hpp>
23 : #include <com/sun/star/util/Date.hpp>
24 : #include <com/sun/star/util/XNumberFormatsSupplier.hpp>
25 : #include <comphelper/mediadescriptor.hxx>
26 : #include "oox/core/filterbase.hxx"
27 : #include "oox/helper/attributelist.hxx"
28 : #include "oox/helper/propertyset.hxx"
29 : #include "oox/core/xmlfilterbase.hxx"
30 : #include "oox/token/properties.hxx"
31 : #include "biffinputstream.hxx"
32 : #include "unitconverter.hxx"
33 :
34 : namespace oox {
35 : namespace xls {
36 :
37 : // ============================================================================
38 :
39 : using namespace ::com::sun::star::beans;
40 : using namespace ::com::sun::star::sheet;
41 : using namespace ::com::sun::star::uno;
42 : using namespace ::com::sun::star::util;
43 :
44 : using ::comphelper::MediaDescriptor;
45 : using ::oox::core::CodecHelper;
46 : using ::rtl::OUString;
47 :
48 : // ============================================================================
49 :
50 : namespace {
51 :
52 : const sal_uInt32 BIFF12_WORKBOOKPR_DATE1904 = 0x00000001;
53 : const sal_uInt32 BIFF12_WORKBOOKPR_STRIPEXT = 0x00000080;
54 :
55 : const sal_uInt16 BIFF12_CALCPR_A1 = 0x0002;
56 : const sal_uInt16 BIFF12_CALCPR_ITERATE = 0x0004;
57 : const sal_uInt16 BIFF12_CALCPR_FULLPRECISION = 0x0008;
58 : const sal_uInt16 BIFF12_CALCPR_CALCCOMPLETED = 0x0010;
59 : const sal_uInt16 BIFF12_CALCPR_CALCONSAVE = 0x0020;
60 : const sal_uInt16 BIFF12_CALCPR_CONCURRENT = 0x0040;
61 : const sal_uInt16 BIFF12_CALCPR_MANUALPROC = 0x0080;
62 :
63 : // no predefined constants for show objects mode
64 : const sal_Int16 API_SHOWMODE_SHOW = 0; /// Show drawing objects.
65 : const sal_Int16 API_SHOWMODE_HIDE = 1; /// Hide drawing objects.
66 : const sal_Int16 API_SHOWMODE_PLACEHOLDER = 2; /// Show placeholders for drawing objects.
67 :
68 : } // namespace
69 :
70 : // ============================================================================
71 :
72 11 : FileSharingModel::FileSharingModel() :
73 : mnPasswordHash( 0 ),
74 11 : mbRecommendReadOnly( false )
75 : {
76 11 : }
77 :
78 : // ============================================================================
79 :
80 11 : WorkbookSettingsModel::WorkbookSettingsModel() :
81 : mnShowObjectMode( XML_all ),
82 : mnUpdateLinksMode( XML_userSet ),
83 : mnDefaultThemeVer( -1 ),
84 : mbDateMode1904( false ),
85 11 : mbSaveExtLinkValues( true )
86 : {
87 11 : }
88 :
89 0 : void WorkbookSettingsModel::setBiffObjectMode( sal_uInt16 nObjMode )
90 : {
91 : static const sal_Int32 spnObjModes[] = { XML_all, XML_placeholders, XML_none };
92 0 : mnShowObjectMode = STATIC_ARRAY_SELECT( spnObjModes, nObjMode, XML_all );
93 0 : }
94 :
95 : // ============================================================================
96 :
97 11 : CalcSettingsModel::CalcSettingsModel() :
98 : mfIterateDelta( 0.001 ),
99 : mnCalcId( -1 ),
100 : mnRefMode( XML_A1 ),
101 : mnCalcMode( XML_auto ),
102 : mnIterateCount( 100 ),
103 : mnProcCount( -1 ),
104 : mbCalcOnSave( true ),
105 : mbCalcCompleted( true ),
106 : mbFullPrecision( true ),
107 : mbIterate( false ),
108 : mbConcurrent( true ),
109 11 : mbUseNlr( false )
110 : {
111 11 : }
112 :
113 : // ============================================================================
114 :
115 11 : WorkbookSettings::WorkbookSettings( const WorkbookHelper& rHelper ) :
116 11 : WorkbookHelper( rHelper )
117 : {
118 11 : }
119 :
120 0 : void WorkbookSettings::importFileSharing( const AttributeList& rAttribs )
121 : {
122 0 : maFileSharing.maUserName = rAttribs.getXString( XML_userName, OUString() );
123 0 : maFileSharing.mnPasswordHash = CodecHelper::getPasswordHash( rAttribs, XML_reservationPassword );
124 0 : maFileSharing.mbRecommendReadOnly = rAttribs.getBool( XML_readOnlyRecommended, false );
125 0 : }
126 :
127 11 : void WorkbookSettings::importWorkbookPr( const AttributeList& rAttribs )
128 : {
129 11 : maBookSettings.maCodeName = rAttribs.getString( XML_codeName, OUString() );
130 11 : maBookSettings.mnShowObjectMode = rAttribs.getToken( XML_showObjects, XML_all );
131 11 : maBookSettings.mnUpdateLinksMode = rAttribs.getToken( XML_updateLinks, XML_userSet );
132 11 : maBookSettings.mnDefaultThemeVer = rAttribs.getInteger( XML_defaultThemeVersion, -1 );
133 11 : maBookSettings.mbSaveExtLinkValues = rAttribs.getBool( XML_saveExternalLinkValues, true );
134 11 : setDateMode( rAttribs.getBool( XML_date1904, false ), rAttribs.getBool( XML_dateCompatibility, true ) );
135 11 : }
136 :
137 11 : void WorkbookSettings::importCalcPr( const AttributeList& rAttribs )
138 : {
139 11 : maCalcSettings.mfIterateDelta = rAttribs.getDouble( XML_iterateDelta, 0.0001 );
140 11 : maCalcSettings.mnCalcId = rAttribs.getInteger( XML_calcId, -1 );
141 11 : maCalcSettings.mnRefMode = rAttribs.getToken( XML_refMode, XML_A1 );
142 11 : maCalcSettings.mnCalcMode = rAttribs.getToken( XML_calcMode, XML_auto );
143 11 : maCalcSettings.mnIterateCount = rAttribs.getInteger( XML_iterateCount, 100 );
144 11 : maCalcSettings.mnProcCount = rAttribs.getInteger( XML_concurrentManualCount, -1 );
145 11 : maCalcSettings.mbCalcOnSave = rAttribs.getBool( XML_calcOnSave, true );
146 11 : maCalcSettings.mbCalcCompleted = rAttribs.getBool( XML_calcCompleted, true );
147 11 : maCalcSettings.mbFullPrecision = rAttribs.getBool( XML_fullPrecision, true );
148 11 : maCalcSettings.mbIterate = rAttribs.getBool( XML_iterate, false );
149 11 : maCalcSettings.mbConcurrent = rAttribs.getBool( XML_concurrentCalc, true );
150 11 : }
151 :
152 0 : void WorkbookSettings::importFileSharing( SequenceInputStream& rStrm )
153 : {
154 0 : maFileSharing.mbRecommendReadOnly = rStrm.readuInt16() != 0;
155 0 : rStrm >> maFileSharing.mnPasswordHash >> maFileSharing.maUserName;
156 0 : }
157 :
158 0 : void WorkbookSettings::importWorkbookPr( SequenceInputStream& rStrm )
159 : {
160 : sal_uInt32 nFlags;
161 0 : rStrm >> nFlags >> maBookSettings.mnDefaultThemeVer >> maBookSettings.maCodeName;
162 0 : maBookSettings.setBiffObjectMode( extractValue< sal_uInt16 >( nFlags, 13, 2 ) );
163 : // set flag means: strip external link values
164 0 : maBookSettings.mbSaveExtLinkValues = !getFlag( nFlags, BIFF12_WORKBOOKPR_STRIPEXT );
165 0 : setDateMode( getFlag( nFlags, BIFF12_WORKBOOKPR_DATE1904 ) );
166 0 : }
167 :
168 0 : void WorkbookSettings::importCalcPr( SequenceInputStream& rStrm )
169 : {
170 : sal_Int32 nCalcMode, nProcCount;
171 : sal_uInt16 nFlags;
172 0 : rStrm >> maCalcSettings.mnCalcId >> nCalcMode >> maCalcSettings.mnIterateCount >> maCalcSettings.mfIterateDelta >> nProcCount >> nFlags;
173 :
174 : static const sal_Int32 spnCalcModes[] = { XML_manual, XML_auto, XML_autoNoTable };
175 0 : maCalcSettings.mnRefMode = getFlagValue( nFlags, BIFF12_CALCPR_A1, XML_A1, XML_R1C1 );
176 0 : maCalcSettings.mnCalcMode = STATIC_ARRAY_SELECT( spnCalcModes, nCalcMode, XML_auto );
177 0 : maCalcSettings.mnProcCount = getFlagValue< sal_Int32 >( nFlags, BIFF12_CALCPR_MANUALPROC, nProcCount, -1 );
178 0 : maCalcSettings.mbCalcOnSave = getFlag( nFlags, BIFF12_CALCPR_CALCONSAVE );
179 0 : maCalcSettings.mbCalcCompleted = getFlag( nFlags, BIFF12_CALCPR_CALCCOMPLETED );
180 0 : maCalcSettings.mbFullPrecision = getFlag( nFlags, BIFF12_CALCPR_FULLPRECISION );
181 0 : maCalcSettings.mbIterate = getFlag( nFlags, BIFF12_CALCPR_ITERATE );
182 0 : maCalcSettings.mbConcurrent = getFlag( nFlags, BIFF12_CALCPR_CONCURRENT );
183 0 : }
184 :
185 11 : void WorkbookSettings::finalizeImport()
186 : {
187 : // default settings
188 11 : PropertySet aPropSet( getDocument() );
189 11 : switch( getFilterType() )
190 : {
191 : case FILTER_OOXML:
192 : case FILTER_BIFF:
193 11 : aPropSet.setProperty( PROP_IgnoreCase, true ); // always in Excel
194 11 : aPropSet.setProperty( PROP_RegularExpressions, false ); // not supported in Excel
195 11 : break;
196 : case FILTER_UNKNOWN:
197 0 : break;
198 : }
199 :
200 : // write protection
201 11 : if( maFileSharing.mbRecommendReadOnly || (maFileSharing.mnPasswordHash != 0) ) try
202 : {
203 0 : getBaseFilter().getMediaDescriptor()[ "ReadOnly" ] <<= true;
204 :
205 0 : Reference< XPropertySet > xDocumentSettings( getBaseFilter().getModelFactory()->createInstance(
206 0 : "com.sun.star.document.Settings" ), UNO_QUERY_THROW );
207 0 : PropertySet aSettingsProp( xDocumentSettings );
208 0 : if( maFileSharing.mbRecommendReadOnly )
209 0 : aSettingsProp.setProperty( PROP_LoadReadonly, true );
210 : // if( maFileSharing.mnPasswordHash != 0 )
211 : // aSettingsProp.setProperty( PROP_ModifyPasswordHash, static_cast< sal_Int32 >( maFileSharing.mnPasswordHash ) );
212 : }
213 0 : catch( Exception& )
214 : {
215 : }
216 :
217 : // calculation settings
218 11 : Date aNullDate = getNullDate();
219 :
220 11 : aPropSet.setProperty( PROP_NullDate, aNullDate );
221 11 : aPropSet.setProperty( PROP_IsIterationEnabled, maCalcSettings.mbIterate );
222 11 : aPropSet.setProperty( PROP_IterationCount, maCalcSettings.mnIterateCount );
223 11 : aPropSet.setProperty( PROP_IterationEpsilon, maCalcSettings.mfIterateDelta );
224 11 : aPropSet.setProperty( PROP_CalcAsShown, !maCalcSettings.mbFullPrecision );
225 11 : aPropSet.setProperty( PROP_LookUpLabels, maCalcSettings.mbUseNlr );
226 :
227 11 : Reference< XNumberFormatsSupplier > xNumFmtsSupp( getDocument(), UNO_QUERY );
228 11 : if( xNumFmtsSupp.is() )
229 : {
230 11 : PropertySet aNumFmtProp( xNumFmtsSupp->getNumberFormatSettings() );
231 11 : aNumFmtProp.setProperty( PROP_NullDate, aNullDate );
232 : }
233 :
234 11 : Reference< XCalculatable > xCalculatable( getDocument(), UNO_QUERY );
235 11 : if( xCalculatable.is() )
236 11 : xCalculatable->enableAutomaticCalculation( (maCalcSettings.mnCalcMode == XML_auto) || (maCalcSettings.mnCalcMode == XML_autoNoTable) );
237 :
238 : // VBA code name
239 11 : aPropSet.setProperty( PROP_CodeName, maBookSettings.maCodeName );
240 11 : }
241 :
242 11 : sal_Int16 WorkbookSettings::getApiShowObjectMode() const
243 : {
244 11 : switch( maBookSettings.mnShowObjectMode )
245 : {
246 11 : case XML_all: return API_SHOWMODE_SHOW;
247 0 : case XML_none: return API_SHOWMODE_HIDE;
248 : // #i80528# placeholders not supported anymore, but this is handled internally in Calc
249 0 : case XML_placeholders: return API_SHOWMODE_PLACEHOLDER;
250 : }
251 0 : return API_SHOWMODE_SHOW;
252 : }
253 :
254 22 : Date WorkbookSettings::getNullDate() const
255 : {
256 22 : static const Date saDate1900 ( 30, 12, 1899 );
257 22 : static const Date saDate1904 ( 1, 1, 1904 );
258 22 : static const Date saDateBackCompatibility1900( 31, 12, 1899 );
259 :
260 22 : if( getOoxFilter().getVersion() == oox::core::ISOIEC_29500_2008 )
261 : {
262 0 : if( !maBookSettings.mbDateCompatibility )
263 0 : return saDate1900;
264 :
265 : return maBookSettings.mbDateMode1904 ? saDate1904 :
266 0 : saDateBackCompatibility1900;
267 : }
268 :
269 22 : return maBookSettings.mbDateMode1904 ? saDate1904 : saDate1900;
270 : }
271 :
272 11 : void WorkbookSettings::setDateMode( bool bDateMode1904, bool bDateCompatibility )
273 : {
274 11 : maBookSettings.mbDateMode1904 = bDateMode1904;
275 11 : maBookSettings.mbDateCompatibility = bDateCompatibility;
276 :
277 11 : getUnitConverter().finalizeNullDate( getNullDate() );
278 11 : }
279 :
280 : // ============================================================================
281 :
282 : } // namespace xls
283 9 : } // namespace oox
284 :
285 : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|
