1*b1cdbd2cSJim Jagielski /**************************************************************
2*b1cdbd2cSJim Jagielski *
3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file
5*b1cdbd2cSJim Jagielski * distributed with this work for additional information
6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file
7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at
10*b1cdbd2cSJim Jagielski *
11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0
12*b1cdbd2cSJim Jagielski *
13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the
17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
18*b1cdbd2cSJim Jagielski * under the License.
19*b1cdbd2cSJim Jagielski *
20*b1cdbd2cSJim Jagielski *************************************************************/
21*b1cdbd2cSJim Jagielski
22*b1cdbd2cSJim Jagielski
23*b1cdbd2cSJim Jagielski
24*b1cdbd2cSJim Jagielski #include "oox/xls/workbookfragment.hxx"
25*b1cdbd2cSJim Jagielski
26*b1cdbd2cSJim Jagielski #include <com/sun/star/table/CellAddress.hpp>
27*b1cdbd2cSJim Jagielski #include "oox/core/filterbase.hxx"
28*b1cdbd2cSJim Jagielski #include "oox/drawingml/themefragmenthandler.hxx"
29*b1cdbd2cSJim Jagielski #include "oox/helper/attributelist.hxx"
30*b1cdbd2cSJim Jagielski #include "oox/helper/progressbar.hxx"
31*b1cdbd2cSJim Jagielski #include "oox/helper/propertyset.hxx"
32*b1cdbd2cSJim Jagielski #include "oox/ole/olestorage.hxx"
33*b1cdbd2cSJim Jagielski #include "oox/xls/biffinputstream.hxx"
34*b1cdbd2cSJim Jagielski #include "oox/xls/chartsheetfragment.hxx"
35*b1cdbd2cSJim Jagielski #include "oox/xls/connectionsfragment.hxx"
36*b1cdbd2cSJim Jagielski #include "oox/xls/externallinkbuffer.hxx"
37*b1cdbd2cSJim Jagielski #include "oox/xls/externallinkfragment.hxx"
38*b1cdbd2cSJim Jagielski #include "oox/xls/pivotcachebuffer.hxx"
39*b1cdbd2cSJim Jagielski #include "oox/xls/sharedstringsbuffer.hxx"
40*b1cdbd2cSJim Jagielski #include "oox/xls/sharedstringsfragment.hxx"
41*b1cdbd2cSJim Jagielski #include "oox/xls/stylesfragment.hxx"
42*b1cdbd2cSJim Jagielski #include "oox/xls/tablebuffer.hxx"
43*b1cdbd2cSJim Jagielski #include "oox/xls/themebuffer.hxx"
44*b1cdbd2cSJim Jagielski #include "oox/xls/viewsettings.hxx"
45*b1cdbd2cSJim Jagielski #include "oox/xls/workbooksettings.hxx"
46*b1cdbd2cSJim Jagielski #include "oox/xls/worksheetbuffer.hxx"
47*b1cdbd2cSJim Jagielski #include "oox/xls/worksheetfragment.hxx"
48*b1cdbd2cSJim Jagielski
49*b1cdbd2cSJim Jagielski namespace oox {
50*b1cdbd2cSJim Jagielski namespace xls {
51*b1cdbd2cSJim Jagielski
52*b1cdbd2cSJim Jagielski // ============================================================================
53*b1cdbd2cSJim Jagielski
54*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::io;
55*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::table;
56*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::uno;
57*b1cdbd2cSJim Jagielski using namespace ::oox::core;
58*b1cdbd2cSJim Jagielski
59*b1cdbd2cSJim Jagielski using ::oox::drawingml::ThemeFragmentHandler;
60*b1cdbd2cSJim Jagielski using ::rtl::OUString;
61*b1cdbd2cSJim Jagielski
62*b1cdbd2cSJim Jagielski // ============================================================================
63*b1cdbd2cSJim Jagielski
64*b1cdbd2cSJim Jagielski namespace {
65*b1cdbd2cSJim Jagielski
66*b1cdbd2cSJim Jagielski const double PROGRESS_LENGTH_GLOBALS = 0.1; /// 10% of progress bar for globals import.
67*b1cdbd2cSJim Jagielski
68*b1cdbd2cSJim Jagielski } // namespace
69*b1cdbd2cSJim Jagielski
70*b1cdbd2cSJim Jagielski // ============================================================================
71*b1cdbd2cSJim Jagielski
WorkbookFragment(const WorkbookHelper & rHelper,const OUString & rFragmentPath)72*b1cdbd2cSJim Jagielski WorkbookFragment::WorkbookFragment( const WorkbookHelper& rHelper, const OUString& rFragmentPath ) :
73*b1cdbd2cSJim Jagielski WorkbookFragmentBase( rHelper, rFragmentPath )
74*b1cdbd2cSJim Jagielski {
75*b1cdbd2cSJim Jagielski }
76*b1cdbd2cSJim Jagielski
onCreateContext(sal_Int32 nElement,const AttributeList & rAttribs)77*b1cdbd2cSJim Jagielski ContextHandlerRef WorkbookFragment::onCreateContext( sal_Int32 nElement, const AttributeList& rAttribs )
78*b1cdbd2cSJim Jagielski {
79*b1cdbd2cSJim Jagielski switch( getCurrentElement() )
80*b1cdbd2cSJim Jagielski {
81*b1cdbd2cSJim Jagielski case XML_ROOT_CONTEXT:
82*b1cdbd2cSJim Jagielski if( nElement == XLS_TOKEN( workbook ) ) return this;
83*b1cdbd2cSJim Jagielski break;
84*b1cdbd2cSJim Jagielski
85*b1cdbd2cSJim Jagielski case XLS_TOKEN( workbook ):
86*b1cdbd2cSJim Jagielski switch( nElement )
87*b1cdbd2cSJim Jagielski {
88*b1cdbd2cSJim Jagielski case XLS_TOKEN( sheets ):
89*b1cdbd2cSJim Jagielski case XLS_TOKEN( bookViews ):
90*b1cdbd2cSJim Jagielski case XLS_TOKEN( externalReferences ):
91*b1cdbd2cSJim Jagielski case XLS_TOKEN( definedNames ):
92*b1cdbd2cSJim Jagielski case XLS_TOKEN( pivotCaches ): return this;
93*b1cdbd2cSJim Jagielski
94*b1cdbd2cSJim Jagielski case XLS_TOKEN( fileSharing ): getWorkbookSettings().importFileSharing( rAttribs ); break;
95*b1cdbd2cSJim Jagielski case XLS_TOKEN( workbookPr ): getWorkbookSettings().importWorkbookPr( rAttribs ); break;
96*b1cdbd2cSJim Jagielski case XLS_TOKEN( calcPr ): getWorkbookSettings().importCalcPr( rAttribs ); break;
97*b1cdbd2cSJim Jagielski case XLS_TOKEN( oleSize ): getViewSettings().importOleSize( rAttribs ); break;
98*b1cdbd2cSJim Jagielski }
99*b1cdbd2cSJim Jagielski break;
100*b1cdbd2cSJim Jagielski
101*b1cdbd2cSJim Jagielski case XLS_TOKEN( sheets ):
102*b1cdbd2cSJim Jagielski if( nElement == XLS_TOKEN( sheet ) ) getWorksheets().importSheet( rAttribs );
103*b1cdbd2cSJim Jagielski break;
104*b1cdbd2cSJim Jagielski case XLS_TOKEN( bookViews ):
105*b1cdbd2cSJim Jagielski if( nElement == XLS_TOKEN( workbookView ) ) getViewSettings().importWorkbookView( rAttribs );
106*b1cdbd2cSJim Jagielski break;
107*b1cdbd2cSJim Jagielski case XLS_TOKEN( externalReferences ):
108*b1cdbd2cSJim Jagielski if( nElement == XLS_TOKEN( externalReference ) ) importExternalReference( rAttribs );
109*b1cdbd2cSJim Jagielski break;
110*b1cdbd2cSJim Jagielski case XLS_TOKEN( definedNames ):
111*b1cdbd2cSJim Jagielski if( nElement == XLS_TOKEN( definedName ) ) { importDefinedName( rAttribs ); return this; } // collect formula
112*b1cdbd2cSJim Jagielski break;
113*b1cdbd2cSJim Jagielski case XLS_TOKEN( pivotCaches ):
114*b1cdbd2cSJim Jagielski if( nElement == XLS_TOKEN( pivotCache ) ) importPivotCache( rAttribs );
115*b1cdbd2cSJim Jagielski break;
116*b1cdbd2cSJim Jagielski }
117*b1cdbd2cSJim Jagielski return 0;
118*b1cdbd2cSJim Jagielski }
119*b1cdbd2cSJim Jagielski
onCharacters(const OUString & rChars)120*b1cdbd2cSJim Jagielski void WorkbookFragment::onCharacters( const OUString& rChars )
121*b1cdbd2cSJim Jagielski {
122*b1cdbd2cSJim Jagielski if( isCurrentElement( XLS_TOKEN( definedName ) ) && mxCurrName.get() )
123*b1cdbd2cSJim Jagielski mxCurrName->setFormula( rChars );
124*b1cdbd2cSJim Jagielski }
125*b1cdbd2cSJim Jagielski
onCreateRecordContext(sal_Int32 nRecId,SequenceInputStream & rStrm)126*b1cdbd2cSJim Jagielski ContextHandlerRef WorkbookFragment::onCreateRecordContext( sal_Int32 nRecId, SequenceInputStream& rStrm )
127*b1cdbd2cSJim Jagielski {
128*b1cdbd2cSJim Jagielski switch( getCurrentElement() )
129*b1cdbd2cSJim Jagielski {
130*b1cdbd2cSJim Jagielski case XML_ROOT_CONTEXT:
131*b1cdbd2cSJim Jagielski if( nRecId == BIFF12_ID_WORKBOOK ) return this;
132*b1cdbd2cSJim Jagielski break;
133*b1cdbd2cSJim Jagielski
134*b1cdbd2cSJim Jagielski case BIFF12_ID_WORKBOOK:
135*b1cdbd2cSJim Jagielski switch( nRecId )
136*b1cdbd2cSJim Jagielski {
137*b1cdbd2cSJim Jagielski case BIFF12_ID_SHEETS:
138*b1cdbd2cSJim Jagielski case BIFF12_ID_BOOKVIEWS:
139*b1cdbd2cSJim Jagielski case BIFF12_ID_EXTERNALREFS:
140*b1cdbd2cSJim Jagielski case BIFF12_ID_PIVOTCACHES: return this;
141*b1cdbd2cSJim Jagielski
142*b1cdbd2cSJim Jagielski case BIFF12_ID_FILESHARING: getWorkbookSettings().importFileSharing( rStrm ); break;
143*b1cdbd2cSJim Jagielski case BIFF12_ID_WORKBOOKPR: getWorkbookSettings().importWorkbookPr( rStrm ); break;
144*b1cdbd2cSJim Jagielski case BIFF12_ID_CALCPR: getWorkbookSettings().importCalcPr( rStrm ); break;
145*b1cdbd2cSJim Jagielski case BIFF12_ID_OLESIZE: getViewSettings().importOleSize( rStrm ); break;
146*b1cdbd2cSJim Jagielski case BIFF12_ID_DEFINEDNAME: getDefinedNames().importDefinedName( rStrm ); break;
147*b1cdbd2cSJim Jagielski }
148*b1cdbd2cSJim Jagielski break;
149*b1cdbd2cSJim Jagielski
150*b1cdbd2cSJim Jagielski case BIFF12_ID_SHEETS:
151*b1cdbd2cSJim Jagielski if( nRecId == BIFF12_ID_SHEET ) getWorksheets().importSheet( rStrm );
152*b1cdbd2cSJim Jagielski break;
153*b1cdbd2cSJim Jagielski case BIFF12_ID_BOOKVIEWS:
154*b1cdbd2cSJim Jagielski if( nRecId == BIFF12_ID_WORKBOOKVIEW ) getViewSettings().importWorkbookView( rStrm );
155*b1cdbd2cSJim Jagielski break;
156*b1cdbd2cSJim Jagielski
157*b1cdbd2cSJim Jagielski case BIFF12_ID_EXTERNALREFS:
158*b1cdbd2cSJim Jagielski switch( nRecId )
159*b1cdbd2cSJim Jagielski {
160*b1cdbd2cSJim Jagielski case BIFF12_ID_EXTERNALREF: importExternalRef( rStrm ); break;
161*b1cdbd2cSJim Jagielski case BIFF12_ID_EXTERNALSELF: getExternalLinks().importExternalSelf( rStrm ); break;
162*b1cdbd2cSJim Jagielski case BIFF12_ID_EXTERNALSAME: getExternalLinks().importExternalSame( rStrm ); break;
163*b1cdbd2cSJim Jagielski case BIFF12_ID_EXTERNALADDIN: getExternalLinks().importExternalAddin( rStrm ); break;
164*b1cdbd2cSJim Jagielski case BIFF12_ID_EXTERNALSHEETS: getExternalLinks().importExternalSheets( rStrm ); break;
165*b1cdbd2cSJim Jagielski }
166*b1cdbd2cSJim Jagielski break;
167*b1cdbd2cSJim Jagielski
168*b1cdbd2cSJim Jagielski case BIFF12_ID_PIVOTCACHES:
169*b1cdbd2cSJim Jagielski if( nRecId == BIFF12_ID_PIVOTCACHE ) importPivotCache( rStrm );
170*b1cdbd2cSJim Jagielski }
171*b1cdbd2cSJim Jagielski return 0;
172*b1cdbd2cSJim Jagielski }
173*b1cdbd2cSJim Jagielski
getRecordInfos() const174*b1cdbd2cSJim Jagielski const RecordInfo* WorkbookFragment::getRecordInfos() const
175*b1cdbd2cSJim Jagielski {
176*b1cdbd2cSJim Jagielski static const RecordInfo spRecInfos[] =
177*b1cdbd2cSJim Jagielski {
178*b1cdbd2cSJim Jagielski { BIFF12_ID_BOOKVIEWS, BIFF12_ID_BOOKVIEWS + 1 },
179*b1cdbd2cSJim Jagielski { BIFF12_ID_EXTERNALREFS, BIFF12_ID_EXTERNALREFS + 1 },
180*b1cdbd2cSJim Jagielski { BIFF12_ID_FUNCTIONGROUPS, BIFF12_ID_FUNCTIONGROUPS + 2 },
181*b1cdbd2cSJim Jagielski { BIFF12_ID_PIVOTCACHE, BIFF12_ID_PIVOTCACHE + 1 },
182*b1cdbd2cSJim Jagielski { BIFF12_ID_PIVOTCACHES, BIFF12_ID_PIVOTCACHES + 1 },
183*b1cdbd2cSJim Jagielski { BIFF12_ID_SHEETS, BIFF12_ID_SHEETS + 1 },
184*b1cdbd2cSJim Jagielski { BIFF12_ID_WORKBOOK, BIFF12_ID_WORKBOOK + 1 },
185*b1cdbd2cSJim Jagielski { -1, -1 }
186*b1cdbd2cSJim Jagielski };
187*b1cdbd2cSJim Jagielski return spRecInfos;
188*b1cdbd2cSJim Jagielski }
189*b1cdbd2cSJim Jagielski
finalizeImport()190*b1cdbd2cSJim Jagielski void WorkbookFragment::finalizeImport()
191*b1cdbd2cSJim Jagielski {
192*b1cdbd2cSJim Jagielski ISegmentProgressBarRef xGlobalSegment = getProgressBar().createSegment( PROGRESS_LENGTH_GLOBALS );
193*b1cdbd2cSJim Jagielski
194*b1cdbd2cSJim Jagielski // read the theme substream
195*b1cdbd2cSJim Jagielski OUString aThemeFragmentPath = getFragmentPathFromFirstType( CREATE_OFFICEDOC_RELATION_TYPE( "theme" ) );
196*b1cdbd2cSJim Jagielski if( aThemeFragmentPath.getLength() > 0 )
197*b1cdbd2cSJim Jagielski importOoxFragment( new ThemeFragmentHandler( getFilter(), aThemeFragmentPath, getTheme() ) );
198*b1cdbd2cSJim Jagielski xGlobalSegment->setPosition( 0.25 );
199*b1cdbd2cSJim Jagielski
200*b1cdbd2cSJim Jagielski // read the styles substream (requires finalized theme buffer)
201*b1cdbd2cSJim Jagielski OUString aStylesFragmentPath = getFragmentPathFromFirstType( CREATE_OFFICEDOC_RELATION_TYPE( "styles" ) );
202*b1cdbd2cSJim Jagielski if( aStylesFragmentPath.getLength() > 0 )
203*b1cdbd2cSJim Jagielski importOoxFragment( new StylesFragment( *this, aStylesFragmentPath ) );
204*b1cdbd2cSJim Jagielski xGlobalSegment->setPosition( 0.5 );
205*b1cdbd2cSJim Jagielski
206*b1cdbd2cSJim Jagielski // read the shared string table substream (requires finalized styles buffer)
207*b1cdbd2cSJim Jagielski OUString aSstFragmentPath = getFragmentPathFromFirstType( CREATE_OFFICEDOC_RELATION_TYPE( "sharedStrings" ) );
208*b1cdbd2cSJim Jagielski if( aSstFragmentPath.getLength() > 0 )
209*b1cdbd2cSJim Jagielski importOoxFragment( new SharedStringsFragment( *this, aSstFragmentPath ) );
210*b1cdbd2cSJim Jagielski xGlobalSegment->setPosition( 0.75 );
211*b1cdbd2cSJim Jagielski
212*b1cdbd2cSJim Jagielski // read the connections substream
213*b1cdbd2cSJim Jagielski OUString aConnFragmentPath = getFragmentPathFromFirstType( CREATE_OFFICEDOC_RELATION_TYPE( "connections" ) );
214*b1cdbd2cSJim Jagielski if( aConnFragmentPath.getLength() > 0 )
215*b1cdbd2cSJim Jagielski importOoxFragment( new ConnectionsFragment( *this, aConnFragmentPath ) );
216*b1cdbd2cSJim Jagielski xGlobalSegment->setPosition( 1.0 );
217*b1cdbd2cSJim Jagielski
218*b1cdbd2cSJim Jagielski /* Create fragments for all sheets, before importing them. Needed to do
219*b1cdbd2cSJim Jagielski some preprocessing in the fragment constructors, e.g. loading the table
220*b1cdbd2cSJim Jagielski fragments for all sheets that are needed before the cell formulas are
221*b1cdbd2cSJim Jagielski loaded. Additionally, the instances of the WorkbookGlobals structures
222*b1cdbd2cSJim Jagielski have to be stored for every sheet. */
223*b1cdbd2cSJim Jagielski typedef ::std::pair< WorksheetGlobalsRef, FragmentHandlerRef > SheetFragmentHandler;
224*b1cdbd2cSJim Jagielski typedef ::std::vector< SheetFragmentHandler > SheetFragmentVector;
225*b1cdbd2cSJim Jagielski SheetFragmentVector aSheetFragments;
226*b1cdbd2cSJim Jagielski WorksheetBuffer& rWorksheets = getWorksheets();
227*b1cdbd2cSJim Jagielski sal_Int32 nWorksheetCount = rWorksheets.getWorksheetCount();
228*b1cdbd2cSJim Jagielski for( sal_Int32 nWorksheet = 0; nWorksheet < nWorksheetCount; ++nWorksheet )
229*b1cdbd2cSJim Jagielski {
230*b1cdbd2cSJim Jagielski sal_Int16 nCalcSheet = rWorksheets.getCalcSheetIndex( nWorksheet );
231*b1cdbd2cSJim Jagielski const Relation* pRelation = getRelations().getRelationFromRelId( rWorksheets.getWorksheetRelId( nWorksheet ) );
232*b1cdbd2cSJim Jagielski if( (nCalcSheet >= 0) && pRelation )
233*b1cdbd2cSJim Jagielski {
234*b1cdbd2cSJim Jagielski // get fragment path of the sheet
235*b1cdbd2cSJim Jagielski OUString aFragmentPath = getFragmentPathFromRelation( *pRelation );
236*b1cdbd2cSJim Jagielski OSL_ENSURE( aFragmentPath.getLength() > 0, "WorkbookFragment::finalizeImport - cannot access sheet fragment" );
237*b1cdbd2cSJim Jagielski if( aFragmentPath.getLength() > 0 )
238*b1cdbd2cSJim Jagielski {
239*b1cdbd2cSJim Jagielski double fSegmentLength = getProgressBar().getFreeLength() / (nWorksheetCount - nWorksheet);
240*b1cdbd2cSJim Jagielski ISegmentProgressBarRef xSheetSegment = getProgressBar().createSegment( fSegmentLength );
241*b1cdbd2cSJim Jagielski
242*b1cdbd2cSJim Jagielski // get the sheet type according to the relations type
243*b1cdbd2cSJim Jagielski WorksheetType eSheetType = SHEETTYPE_EMPTYSHEET;
244*b1cdbd2cSJim Jagielski if( pRelation->maType == CREATE_OFFICEDOC_RELATION_TYPE( "worksheet" ) )
245*b1cdbd2cSJim Jagielski eSheetType = SHEETTYPE_WORKSHEET;
246*b1cdbd2cSJim Jagielski else if( pRelation->maType == CREATE_OFFICEDOC_RELATION_TYPE( "chartsheet" ) )
247*b1cdbd2cSJim Jagielski eSheetType = SHEETTYPE_CHARTSHEET;
248*b1cdbd2cSJim Jagielski else if( (pRelation->maType == CREATE_MSOFFICE_RELATION_TYPE( "xlMacrosheet" )) ||
249*b1cdbd2cSJim Jagielski (pRelation->maType == CREATE_MSOFFICE_RELATION_TYPE( "xlIntlMacrosheet" )) )
250*b1cdbd2cSJim Jagielski eSheetType = SHEETTYPE_MACROSHEET;
251*b1cdbd2cSJim Jagielski else if( pRelation->maType == CREATE_OFFICEDOC_RELATION_TYPE( "dialogsheet" ) )
252*b1cdbd2cSJim Jagielski eSheetType = SHEETTYPE_DIALOGSHEET;
253*b1cdbd2cSJim Jagielski OSL_ENSURE( eSheetType != SHEETTYPE_EMPTYSHEET, "WorkbookFragment::finalizeImport - unknown sheet type" );
254*b1cdbd2cSJim Jagielski if( eSheetType != SHEETTYPE_EMPTYSHEET )
255*b1cdbd2cSJim Jagielski {
256*b1cdbd2cSJim Jagielski // create the WorksheetGlobals object
257*b1cdbd2cSJim Jagielski WorksheetGlobalsRef xSheetGlob = WorksheetHelper::constructGlobals( *this, xSheetSegment, eSheetType, nCalcSheet );
258*b1cdbd2cSJim Jagielski OSL_ENSURE( xSheetGlob.get(), "WorkbookFragment::finalizeImport - missing sheet in document" );
259*b1cdbd2cSJim Jagielski if( xSheetGlob.get() )
260*b1cdbd2cSJim Jagielski {
261*b1cdbd2cSJim Jagielski // create the sheet fragment handler
262*b1cdbd2cSJim Jagielski ::rtl::Reference< WorksheetFragmentBase > xFragment;
263*b1cdbd2cSJim Jagielski switch( eSheetType )
264*b1cdbd2cSJim Jagielski {
265*b1cdbd2cSJim Jagielski case SHEETTYPE_WORKSHEET:
266*b1cdbd2cSJim Jagielski case SHEETTYPE_MACROSHEET:
267*b1cdbd2cSJim Jagielski case SHEETTYPE_DIALOGSHEET:
268*b1cdbd2cSJim Jagielski xFragment.set( new WorksheetFragment( *xSheetGlob, aFragmentPath ) );
269*b1cdbd2cSJim Jagielski break;
270*b1cdbd2cSJim Jagielski case SHEETTYPE_CHARTSHEET:
271*b1cdbd2cSJim Jagielski xFragment.set( new ChartsheetFragment( *xSheetGlob, aFragmentPath ) );
272*b1cdbd2cSJim Jagielski break;
273*b1cdbd2cSJim Jagielski default:
274*b1cdbd2cSJim Jagielski OSL_ENSURE( false, "WorkbookFragment::finalizeImport - unexpected sheet type" );
275*b1cdbd2cSJim Jagielski }
276*b1cdbd2cSJim Jagielski
277*b1cdbd2cSJim Jagielski // insert the fragment into the map
278*b1cdbd2cSJim Jagielski if( xFragment.is() )
279*b1cdbd2cSJim Jagielski aSheetFragments.push_back( SheetFragmentHandler( xSheetGlob, xFragment.get() ) );
280*b1cdbd2cSJim Jagielski }
281*b1cdbd2cSJim Jagielski }
282*b1cdbd2cSJim Jagielski }
283*b1cdbd2cSJim Jagielski }
284*b1cdbd2cSJim Jagielski }
285*b1cdbd2cSJim Jagielski
286*b1cdbd2cSJim Jagielski // create all defined names and database ranges
287*b1cdbd2cSJim Jagielski getDefinedNames().finalizeImport();
288*b1cdbd2cSJim Jagielski getTables().finalizeImport();
289*b1cdbd2cSJim Jagielski
290*b1cdbd2cSJim Jagielski // load all worksheets
291*b1cdbd2cSJim Jagielski for( SheetFragmentVector::iterator aIt = aSheetFragments.begin(), aEnd = aSheetFragments.end(); aIt != aEnd; ++aIt )
292*b1cdbd2cSJim Jagielski {
293*b1cdbd2cSJim Jagielski // import the sheet fragment
294*b1cdbd2cSJim Jagielski importOoxFragment( aIt->second );
295*b1cdbd2cSJim Jagielski // delete fragment object and WorkbookGlobals object, will free all allocated sheet buffers
296*b1cdbd2cSJim Jagielski aIt->second.clear();
297*b1cdbd2cSJim Jagielski aIt->first.reset();
298*b1cdbd2cSJim Jagielski }
299*b1cdbd2cSJim Jagielski
300*b1cdbd2cSJim Jagielski // open the VBA project storage
301*b1cdbd2cSJim Jagielski OUString aVbaFragmentPath = getFragmentPathFromFirstType( CREATE_MSOFFICE_RELATION_TYPE( "vbaProject" ) );
302*b1cdbd2cSJim Jagielski if( aVbaFragmentPath.getLength() > 0 )
303*b1cdbd2cSJim Jagielski {
304*b1cdbd2cSJim Jagielski Reference< XInputStream > xInStrm = getBaseFilter().openInputStream( aVbaFragmentPath );
305*b1cdbd2cSJim Jagielski if( xInStrm.is() )
306*b1cdbd2cSJim Jagielski setVbaProjectStorage( StorageRef( new ::oox::ole::OleStorage( getBaseFilter().getComponentContext(), xInStrm, false ) ) );
307*b1cdbd2cSJim Jagielski }
308*b1cdbd2cSJim Jagielski
309*b1cdbd2cSJim Jagielski // final conversions, e.g. calculation settings and view settings
310*b1cdbd2cSJim Jagielski finalizeWorkbookImport();
311*b1cdbd2cSJim Jagielski }
312*b1cdbd2cSJim Jagielski
313*b1cdbd2cSJim Jagielski // private --------------------------------------------------------------------
314*b1cdbd2cSJim Jagielski
importExternalReference(const AttributeList & rAttribs)315*b1cdbd2cSJim Jagielski void WorkbookFragment::importExternalReference( const AttributeList& rAttribs )
316*b1cdbd2cSJim Jagielski {
317*b1cdbd2cSJim Jagielski if( ExternalLink* pExtLink = getExternalLinks().importExternalReference( rAttribs ).get() )
318*b1cdbd2cSJim Jagielski importExternalLinkFragment( *pExtLink );
319*b1cdbd2cSJim Jagielski }
320*b1cdbd2cSJim Jagielski
importDefinedName(const AttributeList & rAttribs)321*b1cdbd2cSJim Jagielski void WorkbookFragment::importDefinedName( const AttributeList& rAttribs )
322*b1cdbd2cSJim Jagielski {
323*b1cdbd2cSJim Jagielski mxCurrName = getDefinedNames().importDefinedName( rAttribs );
324*b1cdbd2cSJim Jagielski }
325*b1cdbd2cSJim Jagielski
importPivotCache(const AttributeList & rAttribs)326*b1cdbd2cSJim Jagielski void WorkbookFragment::importPivotCache( const AttributeList& rAttribs )
327*b1cdbd2cSJim Jagielski {
328*b1cdbd2cSJim Jagielski sal_Int32 nCacheId = rAttribs.getInteger( XML_cacheId, -1 );
329*b1cdbd2cSJim Jagielski OUString aRelId = rAttribs.getString( R_TOKEN( id ), OUString() );
330*b1cdbd2cSJim Jagielski importPivotCacheDefFragment( aRelId, nCacheId );
331*b1cdbd2cSJim Jagielski }
332*b1cdbd2cSJim Jagielski
importExternalRef(SequenceInputStream & rStrm)333*b1cdbd2cSJim Jagielski void WorkbookFragment::importExternalRef( SequenceInputStream& rStrm )
334*b1cdbd2cSJim Jagielski {
335*b1cdbd2cSJim Jagielski if( ExternalLink* pExtLink = getExternalLinks().importExternalRef( rStrm ).get() )
336*b1cdbd2cSJim Jagielski importExternalLinkFragment( *pExtLink );
337*b1cdbd2cSJim Jagielski }
338*b1cdbd2cSJim Jagielski
importPivotCache(SequenceInputStream & rStrm)339*b1cdbd2cSJim Jagielski void WorkbookFragment::importPivotCache( SequenceInputStream& rStrm )
340*b1cdbd2cSJim Jagielski {
341*b1cdbd2cSJim Jagielski sal_Int32 nCacheId = rStrm.readInt32();
342*b1cdbd2cSJim Jagielski OUString aRelId = BiffHelper::readString( rStrm );
343*b1cdbd2cSJim Jagielski importPivotCacheDefFragment( aRelId, nCacheId );
344*b1cdbd2cSJim Jagielski }
345*b1cdbd2cSJim Jagielski
importExternalLinkFragment(ExternalLink & rExtLink)346*b1cdbd2cSJim Jagielski void WorkbookFragment::importExternalLinkFragment( ExternalLink& rExtLink )
347*b1cdbd2cSJim Jagielski {
348*b1cdbd2cSJim Jagielski OUString aFragmentPath = getFragmentPathFromRelId( rExtLink.getRelId() );
349*b1cdbd2cSJim Jagielski if( aFragmentPath.getLength() > 0 )
350*b1cdbd2cSJim Jagielski importOoxFragment( new ExternalLinkFragment( *this, aFragmentPath, rExtLink ) );
351*b1cdbd2cSJim Jagielski }
352*b1cdbd2cSJim Jagielski
importPivotCacheDefFragment(const OUString & rRelId,sal_Int32 nCacheId)353*b1cdbd2cSJim Jagielski void WorkbookFragment::importPivotCacheDefFragment( const OUString& rRelId, sal_Int32 nCacheId )
354*b1cdbd2cSJim Jagielski {
355*b1cdbd2cSJim Jagielski // pivot caches will be imported on demand, here we just store the fragment path in the buffer
356*b1cdbd2cSJim Jagielski getPivotCaches().registerPivotCacheFragment( nCacheId, getFragmentPathFromRelId( rRelId ) );
357*b1cdbd2cSJim Jagielski }
358*b1cdbd2cSJim Jagielski
359*b1cdbd2cSJim Jagielski // ============================================================================
360*b1cdbd2cSJim Jagielski
BiffWorkbookFragment(const WorkbookHelper & rHelper,const OUString & rStrmName)361*b1cdbd2cSJim Jagielski BiffWorkbookFragment::BiffWorkbookFragment( const WorkbookHelper& rHelper, const OUString& rStrmName ) :
362*b1cdbd2cSJim Jagielski BiffWorkbookFragmentBase( rHelper, rStrmName )
363*b1cdbd2cSJim Jagielski {
364*b1cdbd2cSJim Jagielski }
365*b1cdbd2cSJim Jagielski
importFragment()366*b1cdbd2cSJim Jagielski bool BiffWorkbookFragment::importFragment()
367*b1cdbd2cSJim Jagielski {
368*b1cdbd2cSJim Jagielski bool bRet = false;
369*b1cdbd2cSJim Jagielski
370*b1cdbd2cSJim Jagielski BiffFragmentType eFragment = startFragment( getBiff() );
371*b1cdbd2cSJim Jagielski switch( eFragment )
372*b1cdbd2cSJim Jagielski {
373*b1cdbd2cSJim Jagielski case BIFF_FRAGMENT_GLOBALS:
374*b1cdbd2cSJim Jagielski {
375*b1cdbd2cSJim Jagielski BiffInputStream& rStrm = getInputStream();
376*b1cdbd2cSJim Jagielski // import workbook globals fragment and create sheets in document
377*b1cdbd2cSJim Jagielski ISegmentProgressBarRef xGlobalsProgress = getProgressBar().createSegment( PROGRESS_LENGTH_GLOBALS );
378*b1cdbd2cSJim Jagielski bRet = importGlobalsFragment( *xGlobalsProgress );
379*b1cdbd2cSJim Jagielski // load sheet fragments (do not return false in bRet on missing/broken sheets)
380*b1cdbd2cSJim Jagielski WorksheetBuffer& rWorksheets = getWorksheets();
381*b1cdbd2cSJim Jagielski bool bNextSheet = bRet;
382*b1cdbd2cSJim Jagielski for( sal_Int32 nWorksheet = 0, nWorksheetCount = rWorksheets.getWorksheetCount(); bNextSheet && (nWorksheet < nWorksheetCount); ++nWorksheet )
383*b1cdbd2cSJim Jagielski {
384*b1cdbd2cSJim Jagielski // calculate progress size for the sheet
385*b1cdbd2cSJim Jagielski double fSegmentLength = getProgressBar().getFreeLength() / (nWorksheetCount - nWorksheet);
386*b1cdbd2cSJim Jagielski ISegmentProgressBarRef xSheetProgress = getProgressBar().createSegment( fSegmentLength );
387*b1cdbd2cSJim Jagielski /* Try to start a new sheet fragment. The SHEET records point to the
388*b1cdbd2cSJim Jagielski first record of the sheet fragment which is usually a BOF record. */
389*b1cdbd2cSJim Jagielski BiffFragmentType eSheetFragment = BIFF_FRAGMENT_UNKNOWN;
390*b1cdbd2cSJim Jagielski sal_Int64 nRecHandle = rWorksheets.getBiffRecordHandle( nWorksheet );
391*b1cdbd2cSJim Jagielski if( rStrm.startRecordByHandle( nRecHandle ) )
392*b1cdbd2cSJim Jagielski {
393*b1cdbd2cSJim Jagielski /* #i109800# Stream may point to any record of the sheet fragment.
394*b1cdbd2cSJim Jagielski Check the record identifier before calling startFragment(). */
395*b1cdbd2cSJim Jagielski bool bIsBofRec = BiffHelper::isBofRecord( rStrm );
396*b1cdbd2cSJim Jagielski /* Rewind the record. If it is the BOF record, it will be read in
397*b1cdbd2cSJim Jagielski startFragment(). In every case, stream will point before the
398*b1cdbd2cSJim Jagielski first available non-BOF record. */
399*b1cdbd2cSJim Jagielski rStrm.rewindRecord();
400*b1cdbd2cSJim Jagielski // if the BOF record is missing, a regular worksheet will be assumed
401*b1cdbd2cSJim Jagielski eSheetFragment = bIsBofRec ? startFragment( getBiff() ) : BIFF_FRAGMENT_WORKSHEET;
402*b1cdbd2cSJim Jagielski }
403*b1cdbd2cSJim Jagielski sal_Int16 nCalcSheet = rWorksheets.getCalcSheetIndex( nWorksheet );
404*b1cdbd2cSJim Jagielski bNextSheet = importSheetFragment( *xSheetProgress, eSheetFragment, nCalcSheet );
405*b1cdbd2cSJim Jagielski }
406*b1cdbd2cSJim Jagielski }
407*b1cdbd2cSJim Jagielski break;
408*b1cdbd2cSJim Jagielski
409*b1cdbd2cSJim Jagielski case BIFF_FRAGMENT_WORKSPACE:
410*b1cdbd2cSJim Jagielski {
411*b1cdbd2cSJim Jagielski bRet = importWorkspaceFragment();
412*b1cdbd2cSJim Jagielski // sheets are embedded in workspace fragment, nothing to do here
413*b1cdbd2cSJim Jagielski }
414*b1cdbd2cSJim Jagielski break;
415*b1cdbd2cSJim Jagielski
416*b1cdbd2cSJim Jagielski case BIFF_FRAGMENT_WORKSHEET:
417*b1cdbd2cSJim Jagielski case BIFF_FRAGMENT_CHARTSHEET:
418*b1cdbd2cSJim Jagielski case BIFF_FRAGMENT_MACROSHEET:
419*b1cdbd2cSJim Jagielski {
420*b1cdbd2cSJim Jagielski /* Single sheet without globals
421*b1cdbd2cSJim Jagielski - #i62752# possible in all BIFF versions
422*b1cdbd2cSJim Jagielski - do not return false in bRet on missing/broken sheets. */
423*b1cdbd2cSJim Jagielski getWorksheets().initializeSingleSheet();
424*b1cdbd2cSJim Jagielski importSheetFragment( getProgressBar(), eFragment, 0 );
425*b1cdbd2cSJim Jagielski // success, even if stream is broken
426*b1cdbd2cSJim Jagielski bRet = true;
427*b1cdbd2cSJim Jagielski }
428*b1cdbd2cSJim Jagielski break;
429*b1cdbd2cSJim Jagielski
430*b1cdbd2cSJim Jagielski default:;
431*b1cdbd2cSJim Jagielski }
432*b1cdbd2cSJim Jagielski
433*b1cdbd2cSJim Jagielski // final conversions, e.g. calculation settings and view settings
434*b1cdbd2cSJim Jagielski if( bRet )
435*b1cdbd2cSJim Jagielski finalizeWorkbookImport();
436*b1cdbd2cSJim Jagielski
437*b1cdbd2cSJim Jagielski return bRet;
438*b1cdbd2cSJim Jagielski }
439*b1cdbd2cSJim Jagielski
importWorkspaceFragment()440*b1cdbd2cSJim Jagielski bool BiffWorkbookFragment::importWorkspaceFragment()
441*b1cdbd2cSJim Jagielski {
442*b1cdbd2cSJim Jagielski // enable workbook mode, has not been set yet in BIFF4 workspace files
443*b1cdbd2cSJim Jagielski setIsWorkbookFile();
444*b1cdbd2cSJim Jagielski
445*b1cdbd2cSJim Jagielski WorksheetBuffer& rWorksheets = getWorksheets();
446*b1cdbd2cSJim Jagielski bool bRet = true;
447*b1cdbd2cSJim Jagielski
448*b1cdbd2cSJim Jagielski // import the workspace globals
449*b1cdbd2cSJim Jagielski ISegmentProgressBarRef xGlobalsProgress = getProgressBar().createSegment( PROGRESS_LENGTH_GLOBALS );
450*b1cdbd2cSJim Jagielski bool bLoop = true;
451*b1cdbd2cSJim Jagielski BiffInputStream& rStrm = getInputStream();
452*b1cdbd2cSJim Jagielski while( bRet && bLoop && rStrm.startNextRecord() && (rStrm.getRecId() != BIFF_ID_EOF) )
453*b1cdbd2cSJim Jagielski {
454*b1cdbd2cSJim Jagielski switch( rStrm.getRecId() )
455*b1cdbd2cSJim Jagielski {
456*b1cdbd2cSJim Jagielski case BIFF_ID_SHEET: rWorksheets.importSheet( rStrm ); break;
457*b1cdbd2cSJim Jagielski case BIFF_ID_CODEPAGE: setCodePage( rStrm.readuInt16() ); break;
458*b1cdbd2cSJim Jagielski case BIFF_ID_FILEPASS: bRet = getCodecHelper().importFilePass( rStrm ); break;
459*b1cdbd2cSJim Jagielski case BIFF_ID_SHEETHEADER: rStrm.rewindRecord(); bLoop = false; break;
460*b1cdbd2cSJim Jagielski }
461*b1cdbd2cSJim Jagielski }
462*b1cdbd2cSJim Jagielski xGlobalsProgress->setPosition( 1.0 );
463*b1cdbd2cSJim Jagielski
464*b1cdbd2cSJim Jagielski // load sheet fragments (do not return false in bRet on missing/broken sheets)
465*b1cdbd2cSJim Jagielski bool bNextSheet = bRet;
466*b1cdbd2cSJim Jagielski for( sal_Int32 nWorksheet = 0, nWorksheetCount = rWorksheets.getWorksheetCount(); bNextSheet && (nWorksheet < nWorksheetCount); ++nWorksheet )
467*b1cdbd2cSJim Jagielski {
468*b1cdbd2cSJim Jagielski // try to start a new sheet fragment (with leading SHEETHEADER record)
469*b1cdbd2cSJim Jagielski bNextSheet = rStrm.startNextRecord() && (rStrm.getRecId() == BIFF_ID_SHEETHEADER);
470*b1cdbd2cSJim Jagielski if( bNextSheet )
471*b1cdbd2cSJim Jagielski {
472*b1cdbd2cSJim Jagielski double fSegmentLength = getProgressBar().getFreeLength() / (nWorksheetCount - nWorksheet);
473*b1cdbd2cSJim Jagielski ISegmentProgressBarRef xSheetProgress = getProgressBar().createSegment( fSegmentLength );
474*b1cdbd2cSJim Jagielski /* Read current sheet name (sheet substreams may not be in the
475*b1cdbd2cSJim Jagielski same order as SHEET records are). */
476*b1cdbd2cSJim Jagielski rStrm.skip( 4 );
477*b1cdbd2cSJim Jagielski OUString aSheetName = rStrm.readByteStringUC( false, getTextEncoding() );
478*b1cdbd2cSJim Jagielski sal_Int16 nCurrSheet = rWorksheets.getCalcSheetIndex( aSheetName );
479*b1cdbd2cSJim Jagielski // load the sheet fragment records
480*b1cdbd2cSJim Jagielski BiffFragmentType eSheetFragment = startFragment( getBiff() );
481*b1cdbd2cSJim Jagielski bNextSheet = importSheetFragment( *xSheetProgress, eSheetFragment, nCurrSheet );
482*b1cdbd2cSJim Jagielski // do not return false in bRet on missing/broken sheets
483*b1cdbd2cSJim Jagielski }
484*b1cdbd2cSJim Jagielski }
485*b1cdbd2cSJim Jagielski
486*b1cdbd2cSJim Jagielski return bRet;
487*b1cdbd2cSJim Jagielski }
488*b1cdbd2cSJim Jagielski
importGlobalsFragment(ISegmentProgressBar & rProgressBar)489*b1cdbd2cSJim Jagielski bool BiffWorkbookFragment::importGlobalsFragment( ISegmentProgressBar& rProgressBar )
490*b1cdbd2cSJim Jagielski {
491*b1cdbd2cSJim Jagielski WorkbookSettings& rWorkbookSett = getWorkbookSettings();
492*b1cdbd2cSJim Jagielski ViewSettings& rViewSett = getViewSettings();
493*b1cdbd2cSJim Jagielski SharedStringsBuffer& rSharedStrings = getSharedStrings();
494*b1cdbd2cSJim Jagielski StylesBuffer& rStyles = getStyles();
495*b1cdbd2cSJim Jagielski WorksheetBuffer& rWorksheets = getWorksheets();
496*b1cdbd2cSJim Jagielski PivotCacheBuffer& rPivotCaches = getPivotCaches();
497*b1cdbd2cSJim Jagielski bool bHasVbaProject = false;
498*b1cdbd2cSJim Jagielski bool bEmptyVbaProject = false;
499*b1cdbd2cSJim Jagielski
500*b1cdbd2cSJim Jagielski // collect records that need to be loaded in a second pass
501*b1cdbd2cSJim Jagielski typedef ::std::vector< sal_Int64 > RecordHandleVec;
502*b1cdbd2cSJim Jagielski RecordHandleVec aExtLinkRecs;
503*b1cdbd2cSJim Jagielski
504*b1cdbd2cSJim Jagielski bool bRet = true;
505*b1cdbd2cSJim Jagielski bool bLoop = true;
506*b1cdbd2cSJim Jagielski BiffInputStream& rStrm = getInputStream();
507*b1cdbd2cSJim Jagielski while( bRet && bLoop && rStrm.startNextRecord() )
508*b1cdbd2cSJim Jagielski {
509*b1cdbd2cSJim Jagielski sal_uInt16 nRecId = rStrm.getRecId();
510*b1cdbd2cSJim Jagielski bool bExtLinkRec = false;
511*b1cdbd2cSJim Jagielski
512*b1cdbd2cSJim Jagielski /* #i56376# BIFF5-BIFF8: If an EOF record for globals is missing,
513*b1cdbd2cSJim Jagielski simulate it. The issue is about a document where the sheet fragment
514*b1cdbd2cSJim Jagielski starts directly after the EXTSST record, without terminating the
515*b1cdbd2cSJim Jagielski globals fragment with an EOF record. */
516*b1cdbd2cSJim Jagielski if( BiffHelper::isBofRecord( rStrm ) || (nRecId == BIFF_ID_EOF) )
517*b1cdbd2cSJim Jagielski {
518*b1cdbd2cSJim Jagielski bLoop = false;
519*b1cdbd2cSJim Jagielski }
520*b1cdbd2cSJim Jagielski else switch( nRecId )
521*b1cdbd2cSJim Jagielski {
522*b1cdbd2cSJim Jagielski // records in all BIFF versions
523*b1cdbd2cSJim Jagielski case BIFF_ID_CODEPAGE: setCodePage( rStrm.readuInt16() ); break;
524*b1cdbd2cSJim Jagielski case BIFF_ID_DATEMODE: rWorkbookSett.importDateMode( rStrm ); break;
525*b1cdbd2cSJim Jagielski case BIFF_ID_FILEPASS: bRet = getCodecHelper().importFilePass( rStrm ); break;
526*b1cdbd2cSJim Jagielski case BIFF_ID_PRECISION: rWorkbookSett.importPrecision( rStrm ); break;
527*b1cdbd2cSJim Jagielski case BIFF_ID_WINDOW1: rViewSett.importWindow1( rStrm ); break;
528*b1cdbd2cSJim Jagielski
529*b1cdbd2cSJim Jagielski // BIFF specific records
530*b1cdbd2cSJim Jagielski default: switch( getBiff() )
531*b1cdbd2cSJim Jagielski {
532*b1cdbd2cSJim Jagielski case BIFF2: switch( nRecId )
533*b1cdbd2cSJim Jagielski {
534*b1cdbd2cSJim Jagielski case BIFF2_ID_DEFINEDNAME: bExtLinkRec = true; break;
535*b1cdbd2cSJim Jagielski case BIFF2_ID_EXTERNALNAME: bExtLinkRec = true; break;
536*b1cdbd2cSJim Jagielski case BIFF_ID_EXTERNSHEET: bExtLinkRec = true; break;
537*b1cdbd2cSJim Jagielski case BIFF2_ID_FONT: rStyles.importFont( rStrm ); break;
538*b1cdbd2cSJim Jagielski case BIFF_ID_FONTCOLOR: rStyles.importFontColor( rStrm ); break;
539*b1cdbd2cSJim Jagielski case BIFF2_ID_FORMAT: rStyles.importFormat( rStrm ); break;
540*b1cdbd2cSJim Jagielski case BIFF2_ID_XF: rStyles.importXf( rStrm ); break;
541*b1cdbd2cSJim Jagielski }
542*b1cdbd2cSJim Jagielski break;
543*b1cdbd2cSJim Jagielski
544*b1cdbd2cSJim Jagielski case BIFF3: switch( nRecId )
545*b1cdbd2cSJim Jagielski {
546*b1cdbd2cSJim Jagielski case BIFF_ID_CRN: bExtLinkRec = true; break;
547*b1cdbd2cSJim Jagielski case BIFF3_ID_DEFINEDNAME: bExtLinkRec = true; break;
548*b1cdbd2cSJim Jagielski case BIFF3_ID_EXTERNALNAME: bExtLinkRec = true; break;
549*b1cdbd2cSJim Jagielski case BIFF_ID_EXTERNSHEET: bExtLinkRec = true; break;
550*b1cdbd2cSJim Jagielski case BIFF_ID_FILESHARING: rWorkbookSett.importFileSharing( rStrm ); break;
551*b1cdbd2cSJim Jagielski case BIFF3_ID_FONT: rStyles.importFont( rStrm ); break;
552*b1cdbd2cSJim Jagielski case BIFF2_ID_FORMAT: rStyles.importFormat( rStrm ); break;
553*b1cdbd2cSJim Jagielski case BIFF_ID_HIDEOBJ: rWorkbookSett.importHideObj( rStrm ); break;
554*b1cdbd2cSJim Jagielski case BIFF_ID_PALETTE: rStyles.importPalette( rStrm ); break;
555*b1cdbd2cSJim Jagielski case BIFF_ID_STYLE: rStyles.importStyle( rStrm ); break;
556*b1cdbd2cSJim Jagielski case BIFF_ID_XCT: bExtLinkRec = true; break;
557*b1cdbd2cSJim Jagielski case BIFF3_ID_XF: rStyles.importXf( rStrm ); break;
558*b1cdbd2cSJim Jagielski }
559*b1cdbd2cSJim Jagielski break;
560*b1cdbd2cSJim Jagielski
561*b1cdbd2cSJim Jagielski case BIFF4: switch( nRecId )
562*b1cdbd2cSJim Jagielski {
563*b1cdbd2cSJim Jagielski case BIFF_ID_CRN: bExtLinkRec = true; break;
564*b1cdbd2cSJim Jagielski case BIFF3_ID_DEFINEDNAME: bExtLinkRec = true; break;
565*b1cdbd2cSJim Jagielski case BIFF3_ID_EXTERNALNAME: bExtLinkRec = true; break;
566*b1cdbd2cSJim Jagielski case BIFF_ID_EXTERNSHEET: bExtLinkRec = true; break;
567*b1cdbd2cSJim Jagielski case BIFF_ID_FILESHARING: rWorkbookSett.importFileSharing( rStrm ); break;
568*b1cdbd2cSJim Jagielski case BIFF3_ID_FONT: rStyles.importFont( rStrm ); break;
569*b1cdbd2cSJim Jagielski case BIFF4_ID_FORMAT: rStyles.importFormat( rStrm ); break;
570*b1cdbd2cSJim Jagielski case BIFF_ID_HIDEOBJ: rWorkbookSett.importHideObj( rStrm ); break;
571*b1cdbd2cSJim Jagielski case BIFF_ID_PALETTE: rStyles.importPalette( rStrm ); break;
572*b1cdbd2cSJim Jagielski case BIFF_ID_STYLE: rStyles.importStyle( rStrm ); break;
573*b1cdbd2cSJim Jagielski case BIFF_ID_XCT: bExtLinkRec = true; break;
574*b1cdbd2cSJim Jagielski case BIFF4_ID_XF: rStyles.importXf( rStrm ); break;
575*b1cdbd2cSJim Jagielski }
576*b1cdbd2cSJim Jagielski break;
577*b1cdbd2cSJim Jagielski
578*b1cdbd2cSJim Jagielski case BIFF5: switch( nRecId )
579*b1cdbd2cSJim Jagielski {
580*b1cdbd2cSJim Jagielski case BIFF_ID_BOOKBOOL: rWorkbookSett.importBookBool( rStrm ); break;
581*b1cdbd2cSJim Jagielski case BIFF_ID_CRN: bExtLinkRec = true; break;
582*b1cdbd2cSJim Jagielski case BIFF5_ID_DEFINEDNAME: bExtLinkRec = true; break;
583*b1cdbd2cSJim Jagielski case BIFF5_ID_EXTERNALNAME: bExtLinkRec = true; break;
584*b1cdbd2cSJim Jagielski case BIFF_ID_EXTERNSHEET: bExtLinkRec = true; break;
585*b1cdbd2cSJim Jagielski case BIFF_ID_FILESHARING: rWorkbookSett.importFileSharing( rStrm ); break;
586*b1cdbd2cSJim Jagielski case BIFF5_ID_FONT: rStyles.importFont( rStrm ); break;
587*b1cdbd2cSJim Jagielski case BIFF4_ID_FORMAT: rStyles.importFormat( rStrm ); break;
588*b1cdbd2cSJim Jagielski case BIFF_ID_HIDEOBJ: rWorkbookSett.importHideObj( rStrm ); break;
589*b1cdbd2cSJim Jagielski case BIFF_ID_OLESIZE: rViewSett.importOleSize( rStrm ); break;
590*b1cdbd2cSJim Jagielski case BIFF_ID_PALETTE: rStyles.importPalette( rStrm ); break;
591*b1cdbd2cSJim Jagielski case BIFF_ID_PIVOTCACHE: rPivotCaches.importPivotCacheRef( rStrm ); break;
592*b1cdbd2cSJim Jagielski case BIFF_ID_SHEET: rWorksheets.importSheet( rStrm ); break;
593*b1cdbd2cSJim Jagielski case BIFF_ID_STYLE: rStyles.importStyle( rStrm ); break;
594*b1cdbd2cSJim Jagielski case BIFF_ID_XCT: bExtLinkRec = true; break;
595*b1cdbd2cSJim Jagielski case BIFF5_ID_XF: rStyles.importXf( rStrm ); break;
596*b1cdbd2cSJim Jagielski }
597*b1cdbd2cSJim Jagielski break;
598*b1cdbd2cSJim Jagielski
599*b1cdbd2cSJim Jagielski case BIFF8: switch( nRecId )
600*b1cdbd2cSJim Jagielski {
601*b1cdbd2cSJim Jagielski case BIFF_ID_BOOKBOOL: rWorkbookSett.importBookBool( rStrm ); break;
602*b1cdbd2cSJim Jagielski case BIFF_ID_CODENAME: rWorkbookSett.importCodeName( rStrm ); break;
603*b1cdbd2cSJim Jagielski case BIFF_ID_CRN: bExtLinkRec = true; break;
604*b1cdbd2cSJim Jagielski case BIFF5_ID_DEFINEDNAME: bExtLinkRec = true; break;
605*b1cdbd2cSJim Jagielski case BIFF_ID_EXTERNALBOOK: bExtLinkRec = true; break;
606*b1cdbd2cSJim Jagielski case BIFF5_ID_EXTERNALNAME: bExtLinkRec = true; break;
607*b1cdbd2cSJim Jagielski case BIFF_ID_EXTERNSHEET: bExtLinkRec = true; break;
608*b1cdbd2cSJim Jagielski case BIFF_ID_FILESHARING: rWorkbookSett.importFileSharing( rStrm ); break;
609*b1cdbd2cSJim Jagielski case BIFF5_ID_FONT: rStyles.importFont( rStrm ); break;
610*b1cdbd2cSJim Jagielski case BIFF4_ID_FORMAT: rStyles.importFormat( rStrm ); break;
611*b1cdbd2cSJim Jagielski case BIFF_ID_HIDEOBJ: rWorkbookSett.importHideObj( rStrm ); break;
612*b1cdbd2cSJim Jagielski case BIFF_ID_OLESIZE: rViewSett.importOleSize( rStrm ); break;
613*b1cdbd2cSJim Jagielski case BIFF_ID_PALETTE: rStyles.importPalette( rStrm ); break;
614*b1cdbd2cSJim Jagielski case BIFF_ID_PIVOTCACHE: rPivotCaches.importPivotCacheRef( rStrm ); break;
615*b1cdbd2cSJim Jagielski case BIFF_ID_SHEET: rWorksheets.importSheet( rStrm ); break;
616*b1cdbd2cSJim Jagielski case BIFF_ID_SST: rSharedStrings.importSst( rStrm ); break;
617*b1cdbd2cSJim Jagielski case BIFF_ID_STYLE: rStyles.importStyle( rStrm ); break;
618*b1cdbd2cSJim Jagielski case BIFF_ID_USESELFS: rWorkbookSett.importUsesElfs( rStrm ); break;
619*b1cdbd2cSJim Jagielski case BIFF_ID_VBAPROJECT: bHasVbaProject = true; break;
620*b1cdbd2cSJim Jagielski case BIFF_ID_VBAPROJECTEMPTY: bEmptyVbaProject = true; break;
621*b1cdbd2cSJim Jagielski case BIFF_ID_XCT: bExtLinkRec = true; break;
622*b1cdbd2cSJim Jagielski case BIFF5_ID_XF: rStyles.importXf( rStrm ); break;
623*b1cdbd2cSJim Jagielski }
624*b1cdbd2cSJim Jagielski break;
625*b1cdbd2cSJim Jagielski
626*b1cdbd2cSJim Jagielski case BIFF_UNKNOWN: break;
627*b1cdbd2cSJim Jagielski }
628*b1cdbd2cSJim Jagielski }
629*b1cdbd2cSJim Jagielski
630*b1cdbd2cSJim Jagielski if( bExtLinkRec )
631*b1cdbd2cSJim Jagielski aExtLinkRecs.push_back( rStrm.getRecHandle() );
632*b1cdbd2cSJim Jagielski }
633*b1cdbd2cSJim Jagielski
634*b1cdbd2cSJim Jagielski // finalize global buffers
635*b1cdbd2cSJim Jagielski rProgressBar.setPosition( 0.5 );
636*b1cdbd2cSJim Jagielski if( bRet )
637*b1cdbd2cSJim Jagielski {
638*b1cdbd2cSJim Jagielski rSharedStrings.finalizeImport();
639*b1cdbd2cSJim Jagielski rStyles.finalizeImport();
640*b1cdbd2cSJim Jagielski }
641*b1cdbd2cSJim Jagielski
642*b1cdbd2cSJim Jagielski /* Import external link data (EXTERNSHEET, EXTERNALNAME, DEFINEDNAME)
643*b1cdbd2cSJim Jagielski which need existing internal sheets (SHEET records). The SHEET records
644*b1cdbd2cSJim Jagielski may follow the external links records in some BIFF versions. */
645*b1cdbd2cSJim Jagielski if( bRet && !aExtLinkRecs.empty() )
646*b1cdbd2cSJim Jagielski {
647*b1cdbd2cSJim Jagielski // remember current stream position (the EOF record)
648*b1cdbd2cSJim Jagielski sal_Int64 nEofHandle = rStrm.getRecHandle();
649*b1cdbd2cSJim Jagielski // context handler implementing import of external link records
650*b1cdbd2cSJim Jagielski BiffExternalSheetDataContext aSheetContext( *this, true );
651*b1cdbd2cSJim Jagielski // import all records by using their cached record handle
652*b1cdbd2cSJim Jagielski for( RecordHandleVec::const_iterator aIt = aExtLinkRecs.begin(), aEnd = aExtLinkRecs.end(); (aIt != aEnd) && rStrm.startRecordByHandle( *aIt ); ++aIt )
653*b1cdbd2cSJim Jagielski aSheetContext.importRecord( rStrm );
654*b1cdbd2cSJim Jagielski // finalize global buffers
655*b1cdbd2cSJim Jagielski getDefinedNames().finalizeImport();
656*b1cdbd2cSJim Jagielski // seek back to the EOF record of the workbook globals fragment
657*b1cdbd2cSJim Jagielski bRet = rStrm.startRecordByHandle( nEofHandle );
658*b1cdbd2cSJim Jagielski }
659*b1cdbd2cSJim Jagielski
660*b1cdbd2cSJim Jagielski // open the VBA project storage
661*b1cdbd2cSJim Jagielski if( bHasVbaProject && !bEmptyVbaProject )
662*b1cdbd2cSJim Jagielski setVbaProjectStorage( getBaseFilter().openSubStorage( CREATE_OUSTRING( "_VBA_PROJECT_CUR" ), false ) );
663*b1cdbd2cSJim Jagielski
664*b1cdbd2cSJim Jagielski // #i56376# missing EOF - rewind before worksheet BOF record (see above)
665*b1cdbd2cSJim Jagielski if( bRet && BiffHelper::isBofRecord( rStrm ) )
666*b1cdbd2cSJim Jagielski rStrm.rewindRecord();
667*b1cdbd2cSJim Jagielski
668*b1cdbd2cSJim Jagielski rProgressBar.setPosition( 1.0 );
669*b1cdbd2cSJim Jagielski return bRet;
670*b1cdbd2cSJim Jagielski }
671*b1cdbd2cSJim Jagielski
importSheetFragment(ISegmentProgressBar & rProgressBar,BiffFragmentType eFragment,sal_Int16 nCalcSheet)672*b1cdbd2cSJim Jagielski bool BiffWorkbookFragment::importSheetFragment( ISegmentProgressBar& rProgressBar, BiffFragmentType eFragment, sal_Int16 nCalcSheet )
673*b1cdbd2cSJim Jagielski {
674*b1cdbd2cSJim Jagielski // no Calc sheet - skip the fragment
675*b1cdbd2cSJim Jagielski if( nCalcSheet < 0 )
676*b1cdbd2cSJim Jagielski return skipFragment();
677*b1cdbd2cSJim Jagielski
678*b1cdbd2cSJim Jagielski // find the sheet type for this fragment
679*b1cdbd2cSJim Jagielski WorksheetType eSheetType = SHEETTYPE_EMPTYSHEET;
680*b1cdbd2cSJim Jagielski switch( eFragment )
681*b1cdbd2cSJim Jagielski {
682*b1cdbd2cSJim Jagielski case BIFF_FRAGMENT_WORKSHEET: eSheetType = SHEETTYPE_WORKSHEET; break;
683*b1cdbd2cSJim Jagielski case BIFF_FRAGMENT_CHARTSHEET: eSheetType = SHEETTYPE_CHARTSHEET; break;
684*b1cdbd2cSJim Jagielski case BIFF_FRAGMENT_MACROSHEET: eSheetType = SHEETTYPE_MACROSHEET; break;
685*b1cdbd2cSJim Jagielski case BIFF_FRAGMENT_MODULESHEET: eSheetType = SHEETTYPE_MODULESHEET; break;
686*b1cdbd2cSJim Jagielski case BIFF_FRAGMENT_EMPTYSHEET: eSheetType = SHEETTYPE_EMPTYSHEET; break;
687*b1cdbd2cSJim Jagielski default: return false;
688*b1cdbd2cSJim Jagielski }
689*b1cdbd2cSJim Jagielski
690*b1cdbd2cSJim Jagielski /* #i11183# Clear buffers that are used per-sheet, e.g. external links in
691*b1cdbd2cSJim Jagielski BIFF4W and BIFF5 files, or defined names in BIFF4W files. */
692*b1cdbd2cSJim Jagielski createBuffersPerSheet( nCalcSheet );
693*b1cdbd2cSJim Jagielski
694*b1cdbd2cSJim Jagielski // preprocess some records
695*b1cdbd2cSJim Jagielski BiffInputStream& rStrm = getInputStream();
696*b1cdbd2cSJim Jagielski switch( getBiff() )
697*b1cdbd2cSJim Jagielski {
698*b1cdbd2cSJim Jagielski // load the workbook globals fragment records in BIFF2-BIFF4
699*b1cdbd2cSJim Jagielski case BIFF2:
700*b1cdbd2cSJim Jagielski case BIFF3:
701*b1cdbd2cSJim Jagielski case BIFF4:
702*b1cdbd2cSJim Jagielski {
703*b1cdbd2cSJim Jagielski // remember current record to seek back below
704*b1cdbd2cSJim Jagielski sal_Int64 nRecHandle = rStrm.getRecHandle();
705*b1cdbd2cSJim Jagielski // import the global records
706*b1cdbd2cSJim Jagielski ISegmentProgressBarRef xGlobalsProgress = rProgressBar.createSegment( PROGRESS_LENGTH_GLOBALS );
707*b1cdbd2cSJim Jagielski importGlobalsFragment( *xGlobalsProgress );
708*b1cdbd2cSJim Jagielski // rewind stream to fragment BOF record
709*b1cdbd2cSJim Jagielski rStrm.startRecordByHandle( nRecHandle );
710*b1cdbd2cSJim Jagielski }
711*b1cdbd2cSJim Jagielski break;
712*b1cdbd2cSJim Jagielski
713*b1cdbd2cSJim Jagielski // load the external link records for this sheet in BIFF5
714*b1cdbd2cSJim Jagielski case BIFF5:
715*b1cdbd2cSJim Jagielski {
716*b1cdbd2cSJim Jagielski // remember current record to seek back below
717*b1cdbd2cSJim Jagielski sal_Int64 nRecHandle = rStrm.getRecHandle();
718*b1cdbd2cSJim Jagielski // fragment implementing import of external link records
719*b1cdbd2cSJim Jagielski BiffExternalLinkFragment( *this ).importFragment();
720*b1cdbd2cSJim Jagielski // rewind stream to fragment BOF record
721*b1cdbd2cSJim Jagielski rStrm.startRecordByHandle( nRecHandle );
722*b1cdbd2cSJim Jagielski }
723*b1cdbd2cSJim Jagielski break;
724*b1cdbd2cSJim Jagielski
725*b1cdbd2cSJim Jagielski case BIFF8:
726*b1cdbd2cSJim Jagielski break;
727*b1cdbd2cSJim Jagielski
728*b1cdbd2cSJim Jagielski case BIFF_UNKNOWN:
729*b1cdbd2cSJim Jagielski break;
730*b1cdbd2cSJim Jagielski }
731*b1cdbd2cSJim Jagielski
732*b1cdbd2cSJim Jagielski // create the WorksheetGlobals object
733*b1cdbd2cSJim Jagielski ISegmentProgressBarRef xSheetProgress = rProgressBar.createSegment( rProgressBar.getFreeLength() );
734*b1cdbd2cSJim Jagielski WorksheetGlobalsRef xSheetGlob = WorksheetHelper::constructGlobals( *this, xSheetProgress, eSheetType, nCalcSheet );
735*b1cdbd2cSJim Jagielski OSL_ENSURE( xSheetGlob.get(), "BiffWorkbookFragment::importSheetFragment - missing sheet in document" );
736*b1cdbd2cSJim Jagielski if( !xSheetGlob.get() )
737*b1cdbd2cSJim Jagielski return false;
738*b1cdbd2cSJim Jagielski
739*b1cdbd2cSJim Jagielski // create the worksheet fragment
740*b1cdbd2cSJim Jagielski ::boost::shared_ptr< BiffWorksheetFragmentBase > xFragment;
741*b1cdbd2cSJim Jagielski switch( eSheetType )
742*b1cdbd2cSJim Jagielski {
743*b1cdbd2cSJim Jagielski case SHEETTYPE_WORKSHEET:
744*b1cdbd2cSJim Jagielski case SHEETTYPE_MACROSHEET:
745*b1cdbd2cSJim Jagielski case SHEETTYPE_DIALOGSHEET:
746*b1cdbd2cSJim Jagielski xFragment.reset( new BiffWorksheetFragment( *xSheetGlob, *this ) );
747*b1cdbd2cSJim Jagielski break;
748*b1cdbd2cSJim Jagielski case SHEETTYPE_CHARTSHEET:
749*b1cdbd2cSJim Jagielski xFragment.reset( new BiffChartsheetFragment( *xSheetGlob, *this ) );
750*b1cdbd2cSJim Jagielski break;
751*b1cdbd2cSJim Jagielski case SHEETTYPE_MODULESHEET:
752*b1cdbd2cSJim Jagielski case SHEETTYPE_EMPTYSHEET:
753*b1cdbd2cSJim Jagielski xFragment.reset( new BiffSkipWorksheetFragment( *xSheetGlob, *this ) );
754*b1cdbd2cSJim Jagielski break;
755*b1cdbd2cSJim Jagielski }
756*b1cdbd2cSJim Jagielski // load the sheet fragment records
757*b1cdbd2cSJim Jagielski return xFragment.get() && xFragment->importFragment();
758*b1cdbd2cSJim Jagielski }
759*b1cdbd2cSJim Jagielski
760*b1cdbd2cSJim Jagielski // ============================================================================
761*b1cdbd2cSJim Jagielski
762*b1cdbd2cSJim Jagielski } // namespace xls
763*b1cdbd2cSJim Jagielski } // namespace oox
764