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/viewsettings.hxx"
25cdf0e10cSrcweir
26cdf0e10cSrcweir #include <com/sun/star/awt/Point.hpp>
27cdf0e10cSrcweir #include <com/sun/star/awt/Size.hpp>
28cdf0e10cSrcweir #include <com/sun/star/beans/PropertyValue.hpp>
29cdf0e10cSrcweir #include <com/sun/star/container/XIndexContainer.hpp>
30cdf0e10cSrcweir #include <com/sun/star/container/XNameContainer.hpp>
31cdf0e10cSrcweir #include <com/sun/star/document/XViewDataSupplier.hpp>
32cdf0e10cSrcweir #include <comphelper/mediadescriptor.hxx>
33cdf0e10cSrcweir #include "oox/core/filterbase.hxx"
34cdf0e10cSrcweir #include "oox/helper/attributelist.hxx"
35cdf0e10cSrcweir #include "oox/helper/containerhelper.hxx"
36cdf0e10cSrcweir #include "oox/helper/propertymap.hxx"
37cdf0e10cSrcweir #include "oox/helper/propertyset.hxx"
38cdf0e10cSrcweir #include "oox/xls/addressconverter.hxx"
39cdf0e10cSrcweir #include "oox/xls/biffinputstream.hxx"
40cdf0e10cSrcweir #include "oox/xls/unitconverter.hxx"
41cdf0e10cSrcweir #include "oox/xls/workbooksettings.hxx"
42cdf0e10cSrcweir #include "oox/xls/worksheetbuffer.hxx"
43cdf0e10cSrcweir
44cdf0e10cSrcweir namespace oox {
45cdf0e10cSrcweir namespace xls {
46cdf0e10cSrcweir
47cdf0e10cSrcweir // ============================================================================
48cdf0e10cSrcweir
49cdf0e10cSrcweir using namespace ::com::sun::star::awt;
50cdf0e10cSrcweir using namespace ::com::sun::star::container;
51cdf0e10cSrcweir using namespace ::com::sun::star::document;
52cdf0e10cSrcweir using namespace ::com::sun::star::table;
53cdf0e10cSrcweir using namespace ::com::sun::star::uno;
54cdf0e10cSrcweir
55cdf0e10cSrcweir using ::oox::core::FilterBase;
56cdf0e10cSrcweir using ::rtl::OUString;
57cdf0e10cSrcweir
58cdf0e10cSrcweir // ============================================================================
59cdf0e10cSrcweir
60cdf0e10cSrcweir namespace {
61cdf0e10cSrcweir
62cdf0e10cSrcweir const sal_Int32 OOX_BOOKVIEW_TABBARRATIO_DEF = 600; /// Default tabbar ratio.
63cdf0e10cSrcweir const sal_Int32 OOX_SHEETVIEW_NORMALZOOM_DEF = 100; /// Default zoom for normal view.
64cdf0e10cSrcweir const sal_Int32 OOX_SHEETVIEW_SHEETLAYZOOM_DEF = 60; /// Default zoom for pagebreak preview.
65cdf0e10cSrcweir const sal_Int32 OOX_SHEETVIEW_PAGELAYZOOM_DEF = 100; /// Default zoom for page layout view.
66cdf0e10cSrcweir
67cdf0e10cSrcweir const sal_uInt8 BIFF12_PANE_FROZEN = 0x01;
68cdf0e10cSrcweir const sal_uInt8 BIFF12_PANE_FROZENNOSPLIT = 0x02;
69cdf0e10cSrcweir
70cdf0e10cSrcweir const sal_uInt16 BIFF12_SHEETVIEW_WINPROTECTED = 0x0001;
71cdf0e10cSrcweir const sal_uInt16 BIFF12_SHEETVIEW_SHOWFORMULAS = 0x0002;
72cdf0e10cSrcweir const sal_uInt16 BIFF12_SHEETVIEW_SHOWGRID = 0x0004;
73cdf0e10cSrcweir const sal_uInt16 BIFF12_SHEETVIEW_SHOWHEADINGS = 0x0008;
74cdf0e10cSrcweir const sal_uInt16 BIFF12_SHEETVIEW_SHOWZEROS = 0x0010;
75cdf0e10cSrcweir const sal_uInt16 BIFF12_SHEETVIEW_RIGHTTOLEFT = 0x0020;
76cdf0e10cSrcweir const sal_uInt16 BIFF12_SHEETVIEW_SELECTED = 0x0040;
77cdf0e10cSrcweir const sal_uInt16 BIFF12_SHEETVIEW_SHOWRULER = 0x0080;
78cdf0e10cSrcweir const sal_uInt16 BIFF12_SHEETVIEW_SHOWOUTLINE = 0x0100;
79cdf0e10cSrcweir const sal_uInt16 BIFF12_SHEETVIEW_DEFGRIDCOLOR = 0x0200;
80cdf0e10cSrcweir const sal_uInt16 BIFF12_SHEETVIEW_SHOWWHITESPACE = 0x0400;
81cdf0e10cSrcweir
82cdf0e10cSrcweir const sal_uInt16 BIFF12_CHARTSHEETVIEW_SELECTED = 0x0001;
83cdf0e10cSrcweir const sal_uInt16 BIFF12_CHARTSHEETVIEW_ZOOMTOFIT = 0x0002;
84cdf0e10cSrcweir
85cdf0e10cSrcweir const sal_uInt8 BIFF12_WBVIEW_HIDDEN = 0x01;
86cdf0e10cSrcweir const sal_uInt8 BIFF12_WBVIEW_MINIMIZED = 0x02;
87cdf0e10cSrcweir const sal_uInt8 BIFF12_WBVIEW_SHOWHORSCROLL = 0x08;
88cdf0e10cSrcweir const sal_uInt8 BIFF12_WBVIEW_SHOWVERSCROLL = 0x10;
89cdf0e10cSrcweir const sal_uInt8 BIFF12_WBVIEW_SHOWTABBAR = 0x20;
90cdf0e10cSrcweir const sal_uInt8 BIFF12_WBVIEW_AUTOFILTERGROUP = 0x40;
91cdf0e10cSrcweir
92cdf0e10cSrcweir const sal_uInt8 BIFF_PANE_BOTTOMRIGHT = 0; /// Bottom-right pane.
93cdf0e10cSrcweir const sal_uInt8 BIFF_PANE_TOPRIGHT = 1; /// Right, or top-right pane.
94cdf0e10cSrcweir const sal_uInt8 BIFF_PANE_BOTTOMLEFT = 2; /// Bottom, or bottom-left pane.
95cdf0e10cSrcweir const sal_uInt8 BIFF_PANE_TOPLEFT = 3; /// Single, top, left, or top-left pane.
96cdf0e10cSrcweir
97cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW1_HIDDEN = 0x0001;
98cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW1_MINIMIZED = 0x0002;
99cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW1_SHOWHORSCROLL = 0x0008;
100cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW1_SHOWVERSCROLL = 0x0010;
101cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW1_SHOWTABBAR = 0x0020;
102cdf0e10cSrcweir
103cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW2_SHOWFORMULAS = 0x0001;
104cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW2_SHOWGRID = 0x0002;
105cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW2_SHOWHEADINGS = 0x0004;
106cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW2_FROZEN = 0x0008;
107cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW2_SHOWZEROS = 0x0010;
108cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW2_DEFGRIDCOLOR = 0x0020;
109cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW2_RIGHTTOLEFT = 0x0040;
110cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW2_SHOWOUTLINE = 0x0080;
111cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW2_FROZENNOSPLIT = 0x0100;
112cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW2_SELECTED = 0x0200;
113cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW2_DISPLAYED = 0x0400;
114cdf0e10cSrcweir const sal_uInt16 BIFF_WINDOW2_PAGEBREAKMODE = 0x0800;
115cdf0e10cSrcweir
116cdf0e10cSrcweir // Attention: view settings in Calc do not use com.sun.star.view.DocumentZoomType!
117cdf0e10cSrcweir const sal_Int16 API_ZOOMTYPE_PERCENT = 0; /// Zoom value in percent.
118cdf0e10cSrcweir
119cdf0e10cSrcweir const sal_Int32 API_ZOOMVALUE_MIN = 20; /// Minimum zoom in Calc.
120cdf0e10cSrcweir const sal_Int32 API_ZOOMVALUE_MAX = 400; /// Maximum zoom in Calc.
121cdf0e10cSrcweir
122cdf0e10cSrcweir // no predefined constants for split mode
123cdf0e10cSrcweir const sal_Int16 API_SPLITMODE_NONE = 0; /// No splits in window.
124cdf0e10cSrcweir const sal_Int16 API_SPLITMODE_SPLIT = 1; /// Window is split.
125cdf0e10cSrcweir const sal_Int16 API_SPLITMODE_FREEZE = 2; /// Window has frozen panes.
126cdf0e10cSrcweir
127cdf0e10cSrcweir // no predefined constants for pane idetifiers
128cdf0e10cSrcweir const sal_Int16 API_SPLITPANE_TOPLEFT = 0; /// Top-left, or top pane.
129cdf0e10cSrcweir const sal_Int16 API_SPLITPANE_TOPRIGHT = 1; /// Top-right pane.
130cdf0e10cSrcweir const sal_Int16 API_SPLITPANE_BOTTOMLEFT = 2; /// Bottom-left, bottom, left, or single pane.
131cdf0e10cSrcweir const sal_Int16 API_SPLITPANE_BOTTOMRIGHT = 3; /// Bottom-right, or right pane.
132cdf0e10cSrcweir
133cdf0e10cSrcweir // ----------------------------------------------------------------------------
134cdf0e10cSrcweir
135cdf0e10cSrcweir /** Returns the OOXML pane identifier from the passed BIFF pane id. */
lclGetOoxPaneId(sal_Int32 nBiffPaneId,sal_Int32 nDefaultPaneId)136cdf0e10cSrcweir sal_Int32 lclGetOoxPaneId( sal_Int32 nBiffPaneId, sal_Int32 nDefaultPaneId )
137cdf0e10cSrcweir {
138cdf0e10cSrcweir static const sal_Int32 spnPaneIds[] = { XML_bottomRight, XML_topRight, XML_bottomLeft, XML_topLeft };
139cdf0e10cSrcweir return STATIC_ARRAY_SELECT( spnPaneIds, nBiffPaneId, nDefaultPaneId );
140cdf0e10cSrcweir }
141cdf0e10cSrcweir
142cdf0e10cSrcweir } // namespace
143cdf0e10cSrcweir
144cdf0e10cSrcweir // ============================================================================
145cdf0e10cSrcweir
PaneSelectionModel()146cdf0e10cSrcweir PaneSelectionModel::PaneSelectionModel() :
147cdf0e10cSrcweir mnActiveCellId( 0 )
148cdf0e10cSrcweir {
149cdf0e10cSrcweir }
150cdf0e10cSrcweir
151cdf0e10cSrcweir // ----------------------------------------------------------------------------
152cdf0e10cSrcweir
SheetViewModel()153cdf0e10cSrcweir SheetViewModel::SheetViewModel() :
154cdf0e10cSrcweir mnWorkbookViewId( 0 ),
155cdf0e10cSrcweir mnViewType( XML_normal ),
156cdf0e10cSrcweir mnActivePaneId( XML_topLeft ),
157cdf0e10cSrcweir mnPaneState( XML_split ),
158cdf0e10cSrcweir mfSplitX( 0.0 ),
159cdf0e10cSrcweir mfSplitY( 0.0 ),
160cdf0e10cSrcweir mnCurrentZoom( 0 ),
161cdf0e10cSrcweir mnNormalZoom( 0 ),
162cdf0e10cSrcweir mnSheetLayoutZoom( 0 ),
163cdf0e10cSrcweir mnPageLayoutZoom( 0 ),
164cdf0e10cSrcweir mbSelected( false ),
165cdf0e10cSrcweir mbRightToLeft( false ),
166cdf0e10cSrcweir mbDefGridColor( true ),
167cdf0e10cSrcweir mbShowFormulas( false ),
168cdf0e10cSrcweir mbShowGrid( true ),
169cdf0e10cSrcweir mbShowHeadings( true ),
170cdf0e10cSrcweir mbShowZeros( true ),
171cdf0e10cSrcweir mbShowOutline( true ),
172cdf0e10cSrcweir mbZoomToFit( false )
173cdf0e10cSrcweir {
174cdf0e10cSrcweir maGridColor.setIndexed( OOX_COLOR_WINDOWTEXT );
175cdf0e10cSrcweir }
176cdf0e10cSrcweir
isPageBreakPreview() const177cdf0e10cSrcweir bool SheetViewModel::isPageBreakPreview() const
178cdf0e10cSrcweir {
179cdf0e10cSrcweir return mnViewType == XML_pageBreakPreview;
180cdf0e10cSrcweir }
181cdf0e10cSrcweir
getNormalZoom() const182cdf0e10cSrcweir sal_Int32 SheetViewModel::getNormalZoom() const
183cdf0e10cSrcweir {
184cdf0e10cSrcweir const sal_Int32& rnZoom = isPageBreakPreview() ? mnNormalZoom : mnCurrentZoom;
185cdf0e10cSrcweir sal_Int32 nZoom = (rnZoom > 0) ? rnZoom : OOX_SHEETVIEW_NORMALZOOM_DEF;
186cdf0e10cSrcweir return getLimitedValue< sal_Int32 >( nZoom, API_ZOOMVALUE_MIN, API_ZOOMVALUE_MAX );
187cdf0e10cSrcweir }
188cdf0e10cSrcweir
getPageBreakZoom() const189cdf0e10cSrcweir sal_Int32 SheetViewModel::getPageBreakZoom() const
190cdf0e10cSrcweir {
191cdf0e10cSrcweir const sal_Int32& rnZoom = isPageBreakPreview() ? mnCurrentZoom : mnSheetLayoutZoom;
192cdf0e10cSrcweir sal_Int32 nZoom = (rnZoom > 0) ? rnZoom : OOX_SHEETVIEW_SHEETLAYZOOM_DEF;
193cdf0e10cSrcweir return getLimitedValue< sal_Int32 >( nZoom, API_ZOOMVALUE_MIN, API_ZOOMVALUE_MAX );
194cdf0e10cSrcweir }
195cdf0e10cSrcweir
getGridColor(const FilterBase & rFilter) const196cdf0e10cSrcweir sal_Int32 SheetViewModel::getGridColor( const FilterBase& rFilter ) const
197cdf0e10cSrcweir {
198cdf0e10cSrcweir return mbDefGridColor ? API_RGB_TRANSPARENT : maGridColor.getColor( rFilter.getGraphicHelper() );
199cdf0e10cSrcweir }
200cdf0e10cSrcweir
getPaneSelection(sal_Int32 nPaneId) const201cdf0e10cSrcweir const PaneSelectionModel* SheetViewModel::getPaneSelection( sal_Int32 nPaneId ) const
202cdf0e10cSrcweir {
203cdf0e10cSrcweir return maPaneSelMap.get( nPaneId ).get();
204cdf0e10cSrcweir }
205cdf0e10cSrcweir
getActiveSelection() const206cdf0e10cSrcweir const PaneSelectionModel* SheetViewModel::getActiveSelection() const
207cdf0e10cSrcweir {
208cdf0e10cSrcweir return getPaneSelection( mnActivePaneId );
209cdf0e10cSrcweir }
210cdf0e10cSrcweir
createPaneSelection(sal_Int32 nPaneId)211cdf0e10cSrcweir PaneSelectionModel& SheetViewModel::createPaneSelection( sal_Int32 nPaneId )
212cdf0e10cSrcweir {
213cdf0e10cSrcweir PaneSelectionModelMap::mapped_type& rxPaneSel = maPaneSelMap[ nPaneId ];
214cdf0e10cSrcweir if( !rxPaneSel )
215cdf0e10cSrcweir rxPaneSel.reset( new PaneSelectionModel );
216cdf0e10cSrcweir return *rxPaneSel;
217cdf0e10cSrcweir }
218cdf0e10cSrcweir
219cdf0e10cSrcweir // ----------------------------------------------------------------------------
220cdf0e10cSrcweir
SheetViewSettings(const WorksheetHelper & rHelper)221cdf0e10cSrcweir SheetViewSettings::SheetViewSettings( const WorksheetHelper& rHelper ) :
222cdf0e10cSrcweir WorksheetHelper( rHelper )
223cdf0e10cSrcweir {
224cdf0e10cSrcweir }
225cdf0e10cSrcweir
importSheetView(const AttributeList & rAttribs)226cdf0e10cSrcweir void SheetViewSettings::importSheetView( const AttributeList& rAttribs )
227cdf0e10cSrcweir {
228cdf0e10cSrcweir SheetViewModel& rModel = *createSheetView();
229cdf0e10cSrcweir rModel.maGridColor.setIndexed( rAttribs.getInteger( XML_colorId, OOX_COLOR_WINDOWTEXT ) );
230cdf0e10cSrcweir rModel.maFirstPos = getAddressConverter().createValidCellAddress( rAttribs.getString( XML_topLeftCell, OUString() ), getSheetIndex(), false );
231cdf0e10cSrcweir rModel.mnWorkbookViewId = rAttribs.getToken( XML_workbookViewId, 0 );
232cdf0e10cSrcweir rModel.mnViewType = rAttribs.getToken( XML_view, XML_normal );
233cdf0e10cSrcweir rModel.mnCurrentZoom = rAttribs.getInteger( XML_zoomScale, 100 );
234cdf0e10cSrcweir rModel.mnNormalZoom = rAttribs.getInteger( XML_zoomScaleNormal, 0 );
235cdf0e10cSrcweir rModel.mnSheetLayoutZoom = rAttribs.getInteger( XML_zoomScaleSheetLayoutView, 0 );
236cdf0e10cSrcweir rModel.mnPageLayoutZoom = rAttribs.getInteger( XML_zoomScalePageLayoutView, 0 );
237cdf0e10cSrcweir rModel.mbSelected = rAttribs.getBool( XML_tabSelected, false );
238cdf0e10cSrcweir rModel.mbRightToLeft = rAttribs.getBool( XML_rightToLeft, false );
239cdf0e10cSrcweir rModel.mbDefGridColor = rAttribs.getBool( XML_defaultGridColor, true );
240cdf0e10cSrcweir rModel.mbShowFormulas = rAttribs.getBool( XML_showFormulas, false );
241cdf0e10cSrcweir rModel.mbShowGrid = rAttribs.getBool( XML_showGridLines, true );
242cdf0e10cSrcweir rModel.mbShowHeadings = rAttribs.getBool( XML_showRowColHeaders, true );
243cdf0e10cSrcweir rModel.mbShowZeros = rAttribs.getBool( XML_showZeros, true );
244cdf0e10cSrcweir rModel.mbShowOutline = rAttribs.getBool( XML_showOutlineSymbols, true );
245cdf0e10cSrcweir }
246cdf0e10cSrcweir
importPane(const AttributeList & rAttribs)247cdf0e10cSrcweir void SheetViewSettings::importPane( const AttributeList& rAttribs )
248cdf0e10cSrcweir {
249cdf0e10cSrcweir OSL_ENSURE( !maSheetViews.empty(), "SheetViewSettings::importPane - missing sheet view model" );
250cdf0e10cSrcweir if( !maSheetViews.empty() )
251cdf0e10cSrcweir {
252cdf0e10cSrcweir SheetViewModel& rModel = *maSheetViews.back();
253cdf0e10cSrcweir rModel.maSecondPos = getAddressConverter().createValidCellAddress( rAttribs.getString( XML_topLeftCell, OUString() ), getSheetIndex(), false );
254cdf0e10cSrcweir rModel.mnActivePaneId = rAttribs.getToken( XML_activePane, XML_topLeft );
255cdf0e10cSrcweir rModel.mnPaneState = rAttribs.getToken( XML_state, XML_split );
256cdf0e10cSrcweir rModel.mfSplitX = rAttribs.getDouble( XML_xSplit, 0.0 );
257cdf0e10cSrcweir rModel.mfSplitY = rAttribs.getDouble( XML_ySplit, 0.0 );
258cdf0e10cSrcweir }
259cdf0e10cSrcweir }
260cdf0e10cSrcweir
importSelection(const AttributeList & rAttribs)261cdf0e10cSrcweir void SheetViewSettings::importSelection( const AttributeList& rAttribs )
262cdf0e10cSrcweir {
263cdf0e10cSrcweir OSL_ENSURE( !maSheetViews.empty(), "SheetViewSettings::importSelection - missing sheet view model" );
264cdf0e10cSrcweir if( !maSheetViews.empty() )
265cdf0e10cSrcweir {
266cdf0e10cSrcweir // pane this selection belongs to
267cdf0e10cSrcweir sal_Int32 nPaneId = rAttribs.getToken( XML_pane, XML_topLeft );
268cdf0e10cSrcweir PaneSelectionModel& rSelData = maSheetViews.back()->createPaneSelection( nPaneId );
269cdf0e10cSrcweir // cursor position
270cdf0e10cSrcweir rSelData.maActiveCell = getAddressConverter().createValidCellAddress( rAttribs.getString( XML_activeCell, OUString() ), getSheetIndex(), false );
271cdf0e10cSrcweir rSelData.mnActiveCellId = rAttribs.getInteger( XML_activeCellId, 0 );
272cdf0e10cSrcweir // selection
273cdf0e10cSrcweir rSelData.maSelection.clear();
274cdf0e10cSrcweir getAddressConverter().convertToCellRangeList( rSelData.maSelection, rAttribs.getString( XML_sqref, OUString() ), getSheetIndex(), false );
275cdf0e10cSrcweir }
276cdf0e10cSrcweir }
277cdf0e10cSrcweir
importChartSheetView(const AttributeList & rAttribs)278cdf0e10cSrcweir void SheetViewSettings::importChartSheetView( const AttributeList& rAttribs )
279cdf0e10cSrcweir {
280cdf0e10cSrcweir SheetViewModel& rModel = *createSheetView();
281cdf0e10cSrcweir rModel.mnWorkbookViewId = rAttribs.getToken( XML_workbookViewId, 0 );
282cdf0e10cSrcweir rModel.mnCurrentZoom = rAttribs.getInteger( XML_zoomScale, 100 );
283cdf0e10cSrcweir rModel.mbSelected = rAttribs.getBool( XML_tabSelected, false );
284cdf0e10cSrcweir rModel.mbZoomToFit = rAttribs.getBool( XML_zoomToFit, false );
285cdf0e10cSrcweir }
286cdf0e10cSrcweir
importSheetView(SequenceInputStream & rStrm)287cdf0e10cSrcweir void SheetViewSettings::importSheetView( SequenceInputStream& rStrm )
288cdf0e10cSrcweir {
289cdf0e10cSrcweir SheetViewModel& rModel = *createSheetView();
290cdf0e10cSrcweir sal_uInt16 nFlags;
291cdf0e10cSrcweir sal_Int32 nViewType;
292cdf0e10cSrcweir BinAddress aFirstPos;
293cdf0e10cSrcweir rStrm >> nFlags >> nViewType >> aFirstPos;
294cdf0e10cSrcweir rModel.maGridColor.importColorId( rStrm );
295cdf0e10cSrcweir rModel.mnCurrentZoom = rStrm.readuInt16();
296cdf0e10cSrcweir rModel.mnNormalZoom = rStrm.readuInt16();
297cdf0e10cSrcweir rModel.mnSheetLayoutZoom = rStrm.readuInt16();
298cdf0e10cSrcweir rModel.mnPageLayoutZoom = rStrm.readuInt16();
299cdf0e10cSrcweir rStrm >> rModel.mnWorkbookViewId;
300cdf0e10cSrcweir
301cdf0e10cSrcweir rModel.maFirstPos = getAddressConverter().createValidCellAddress( aFirstPos, getSheetIndex(), false );
302cdf0e10cSrcweir static const sal_Int32 spnViewTypes[] = { XML_normal, XML_pageBreakPreview, XML_pageLayout };
303cdf0e10cSrcweir rModel.mnViewType = STATIC_ARRAY_SELECT( spnViewTypes, nViewType, XML_normal );
304cdf0e10cSrcweir rModel.mbSelected = getFlag( nFlags, BIFF12_SHEETVIEW_SELECTED );
305cdf0e10cSrcweir rModel.mbRightToLeft = getFlag( nFlags, BIFF12_SHEETVIEW_RIGHTTOLEFT );
306cdf0e10cSrcweir rModel.mbDefGridColor = getFlag( nFlags, BIFF12_SHEETVIEW_DEFGRIDCOLOR );
307cdf0e10cSrcweir rModel.mbShowFormulas = getFlag( nFlags, BIFF12_SHEETVIEW_SHOWFORMULAS );
308cdf0e10cSrcweir rModel.mbShowGrid = getFlag( nFlags, BIFF12_SHEETVIEW_SHOWGRID );
309cdf0e10cSrcweir rModel.mbShowHeadings = getFlag( nFlags, BIFF12_SHEETVIEW_SHOWHEADINGS );
310cdf0e10cSrcweir rModel.mbShowZeros = getFlag( nFlags, BIFF12_SHEETVIEW_SHOWZEROS );
311cdf0e10cSrcweir rModel.mbShowOutline = getFlag( nFlags, BIFF12_SHEETVIEW_SHOWOUTLINE );
312cdf0e10cSrcweir }
313cdf0e10cSrcweir
importPane(SequenceInputStream & rStrm)314cdf0e10cSrcweir void SheetViewSettings::importPane( SequenceInputStream& rStrm )
315cdf0e10cSrcweir {
316cdf0e10cSrcweir OSL_ENSURE( !maSheetViews.empty(), "SheetViewSettings::importPane - missing sheet view model" );
317cdf0e10cSrcweir if( !maSheetViews.empty() )
318cdf0e10cSrcweir {
319cdf0e10cSrcweir SheetViewModel& rModel = *maSheetViews.back();
320cdf0e10cSrcweir
321cdf0e10cSrcweir BinAddress aSecondPos;
322cdf0e10cSrcweir sal_Int32 nActivePaneId;
323cdf0e10cSrcweir sal_uInt8 nFlags;
324cdf0e10cSrcweir rStrm >> rModel.mfSplitX >> rModel.mfSplitY >> aSecondPos >> nActivePaneId >> nFlags;
325cdf0e10cSrcweir
326cdf0e10cSrcweir rModel.maSecondPos = getAddressConverter().createValidCellAddress( aSecondPos, getSheetIndex(), false );
327cdf0e10cSrcweir rModel.mnActivePaneId = lclGetOoxPaneId( nActivePaneId, XML_topLeft );
328cdf0e10cSrcweir rModel.mnPaneState = getFlagValue( nFlags, BIFF12_PANE_FROZEN, getFlagValue( nFlags, BIFF12_PANE_FROZENNOSPLIT, XML_frozen, XML_frozenSplit ), XML_split );
329cdf0e10cSrcweir }
330cdf0e10cSrcweir }
331cdf0e10cSrcweir
importSelection(SequenceInputStream & rStrm)332cdf0e10cSrcweir void SheetViewSettings::importSelection( SequenceInputStream& rStrm )
333cdf0e10cSrcweir {
334cdf0e10cSrcweir OSL_ENSURE( !maSheetViews.empty(), "SheetViewSettings::importSelection - missing sheet view model" );
335cdf0e10cSrcweir if( !maSheetViews.empty() )
336cdf0e10cSrcweir {
337cdf0e10cSrcweir // pane this selection belongs to
338cdf0e10cSrcweir sal_Int32 nPaneId = rStrm.readInt32();
339cdf0e10cSrcweir PaneSelectionModel& rPaneSel = maSheetViews.back()->createPaneSelection( lclGetOoxPaneId( nPaneId, -1 ) );
340cdf0e10cSrcweir // cursor position
341cdf0e10cSrcweir BinAddress aActiveCell;
342cdf0e10cSrcweir rStrm >> aActiveCell >> rPaneSel.mnActiveCellId;
343cdf0e10cSrcweir rPaneSel.maActiveCell = getAddressConverter().createValidCellAddress( aActiveCell, getSheetIndex(), false );
344cdf0e10cSrcweir // selection
345cdf0e10cSrcweir BinRangeList aSelection;
346cdf0e10cSrcweir rStrm >> aSelection;
347cdf0e10cSrcweir rPaneSel.maSelection.clear();
348cdf0e10cSrcweir getAddressConverter().convertToCellRangeList( rPaneSel.maSelection, aSelection, getSheetIndex(), false );
349cdf0e10cSrcweir }
350cdf0e10cSrcweir }
351cdf0e10cSrcweir
importChartSheetView(SequenceInputStream & rStrm)352cdf0e10cSrcweir void SheetViewSettings::importChartSheetView( SequenceInputStream& rStrm )
353cdf0e10cSrcweir {
354cdf0e10cSrcweir SheetViewModel& rModel = *createSheetView();
355cdf0e10cSrcweir sal_uInt16 nFlags;
356cdf0e10cSrcweir rStrm >> nFlags >> rModel.mnCurrentZoom >> rModel.mnWorkbookViewId;
357cdf0e10cSrcweir
358cdf0e10cSrcweir rModel.mbSelected = getFlag( nFlags, BIFF12_CHARTSHEETVIEW_SELECTED );
359cdf0e10cSrcweir rModel.mbZoomToFit = getFlag( nFlags, BIFF12_CHARTSHEETVIEW_ZOOMTOFIT );
360cdf0e10cSrcweir }
361cdf0e10cSrcweir
importWindow2(BiffInputStream & rStrm)362cdf0e10cSrcweir void SheetViewSettings::importWindow2( BiffInputStream& rStrm )
363cdf0e10cSrcweir {
364cdf0e10cSrcweir OSL_ENSURE( maSheetViews.empty(), "SheetViewSettings::importWindow2 - multiple WINDOW2 records" );
365cdf0e10cSrcweir SheetViewModel& rModel = *createSheetView();
366cdf0e10cSrcweir if( getBiff() == BIFF2 )
367cdf0e10cSrcweir {
368cdf0e10cSrcweir rModel.mbShowFormulas = rStrm.readuInt8() != 0;
369cdf0e10cSrcweir rModel.mbShowGrid = rStrm.readuInt8() != 0;
370cdf0e10cSrcweir rModel.mbShowHeadings = rStrm.readuInt8() != 0;
371cdf0e10cSrcweir rModel.mnPaneState = (rStrm.readuInt8() == 0) ? XML_split : XML_frozen;
372cdf0e10cSrcweir rModel.mbShowZeros = rStrm.readuInt8() != 0;
373cdf0e10cSrcweir BinAddress aFirstPos;
374cdf0e10cSrcweir rStrm >> aFirstPos;
375cdf0e10cSrcweir rModel.maFirstPos = getAddressConverter().createValidCellAddress( aFirstPos, getSheetIndex(), false );
376cdf0e10cSrcweir rModel.mbDefGridColor = rStrm.readuInt8() != 0;
377cdf0e10cSrcweir rModel.maGridColor.importColorRgb( rStrm );
378cdf0e10cSrcweir }
379cdf0e10cSrcweir else
380cdf0e10cSrcweir {
381cdf0e10cSrcweir sal_uInt16 nFlags;
382cdf0e10cSrcweir BinAddress aFirstPos;
383cdf0e10cSrcweir rStrm >> nFlags >> aFirstPos;
384cdf0e10cSrcweir
385cdf0e10cSrcweir rModel.maFirstPos = getAddressConverter().createValidCellAddress( aFirstPos, getSheetIndex(), false );
386cdf0e10cSrcweir rModel.mnPaneState = getFlagValue( nFlags, BIFF_WINDOW2_FROZEN, getFlagValue( nFlags, BIFF_WINDOW2_FROZENNOSPLIT, XML_frozen, XML_frozenSplit ), XML_split );
387cdf0e10cSrcweir rModel.mbSelected = getFlag( nFlags, BIFF_WINDOW2_SELECTED );
388cdf0e10cSrcweir rModel.mbRightToLeft = getFlag( nFlags, BIFF_WINDOW2_RIGHTTOLEFT );
389cdf0e10cSrcweir rModel.mbDefGridColor = getFlag( nFlags, BIFF_WINDOW2_DEFGRIDCOLOR );
390cdf0e10cSrcweir rModel.mbShowFormulas = getFlag( nFlags, BIFF_WINDOW2_SHOWFORMULAS );
391cdf0e10cSrcweir rModel.mbShowGrid = getFlag( nFlags, BIFF_WINDOW2_SHOWGRID );
392cdf0e10cSrcweir rModel.mbShowHeadings = getFlag( nFlags, BIFF_WINDOW2_SHOWHEADINGS );
393cdf0e10cSrcweir rModel.mbShowZeros = getFlag( nFlags, BIFF_WINDOW2_SHOWZEROS );
394cdf0e10cSrcweir rModel.mbShowOutline = getFlag( nFlags, BIFF_WINDOW2_SHOWOUTLINE );
395cdf0e10cSrcweir
396cdf0e10cSrcweir if( getBiff() == BIFF8 )
397cdf0e10cSrcweir {
398cdf0e10cSrcweir rModel.mnViewType = getFlagValue( nFlags, BIFF_WINDOW2_PAGEBREAKMODE, XML_pageBreakPreview, XML_normal );
399cdf0e10cSrcweir
400cdf0e10cSrcweir rModel.maGridColor.importColorId( rStrm );
401cdf0e10cSrcweir // zoom data not included in chart sheets
402cdf0e10cSrcweir if( (getSheetType() != SHEETTYPE_CHARTSHEET) && (rStrm.getRemaining() >= 6) )
403cdf0e10cSrcweir {
404cdf0e10cSrcweir rStrm.skip( 2 );
405cdf0e10cSrcweir sal_uInt16 nPageZoom, nNormalZoom;
406cdf0e10cSrcweir rStrm >> nPageZoom >> nNormalZoom;
407cdf0e10cSrcweir rModel.mnSheetLayoutZoom = nPageZoom;
408cdf0e10cSrcweir rModel.mnNormalZoom = nNormalZoom;
409cdf0e10cSrcweir }
410cdf0e10cSrcweir }
411cdf0e10cSrcweir else
412cdf0e10cSrcweir {
413cdf0e10cSrcweir rModel.maGridColor.importColorRgb( rStrm );
414cdf0e10cSrcweir }
415cdf0e10cSrcweir }
416cdf0e10cSrcweir }
417cdf0e10cSrcweir
importPane(BiffInputStream & rStrm)418cdf0e10cSrcweir void SheetViewSettings::importPane( BiffInputStream& rStrm )
419cdf0e10cSrcweir {
420cdf0e10cSrcweir OSL_ENSURE( !maSheetViews.empty(), "SheetViewSettings::importPane - missing leading WINDOW2 record" );
421cdf0e10cSrcweir if( !maSheetViews.empty() )
422cdf0e10cSrcweir {
423cdf0e10cSrcweir sal_uInt8 nActivePaneId;
424cdf0e10cSrcweir sal_uInt16 nSplitX, nSplitY;
425cdf0e10cSrcweir BinAddress aSecondPos;
426cdf0e10cSrcweir rStrm >> nSplitX >> nSplitY >> aSecondPos >> nActivePaneId;
427cdf0e10cSrcweir
428cdf0e10cSrcweir SheetViewModel& rModel = *maSheetViews.back();
429cdf0e10cSrcweir rModel.mfSplitX = nSplitX;
430cdf0e10cSrcweir rModel.mfSplitY = nSplitY;
431cdf0e10cSrcweir rModel.maSecondPos = getAddressConverter().createValidCellAddress( aSecondPos, getSheetIndex(), false );
432cdf0e10cSrcweir rModel.mnActivePaneId = lclGetOoxPaneId( nActivePaneId, XML_topLeft );
433cdf0e10cSrcweir }
434cdf0e10cSrcweir }
435cdf0e10cSrcweir
importScl(BiffInputStream & rStrm)436cdf0e10cSrcweir void SheetViewSettings::importScl( BiffInputStream& rStrm )
437cdf0e10cSrcweir {
438cdf0e10cSrcweir OSL_ENSURE( !maSheetViews.empty(), "SheetViewSettings::importScl - missing leading WINDOW2 record" );
439cdf0e10cSrcweir if( !maSheetViews.empty() )
440cdf0e10cSrcweir {
441cdf0e10cSrcweir sal_uInt16 nNum, nDenom;
442cdf0e10cSrcweir rStrm >> nNum >> nDenom;
443cdf0e10cSrcweir OSL_ENSURE( nDenom > 0, "SheetViewSettings::importScl - invalid denominator" );
444cdf0e10cSrcweir if( nDenom > 0 )
445cdf0e10cSrcweir maSheetViews.back()->mnCurrentZoom = getLimitedValue< sal_Int32, sal_uInt16 >( (nNum * 100) / nDenom, 10, 400 );
446cdf0e10cSrcweir }
447cdf0e10cSrcweir }
448cdf0e10cSrcweir
importSelection(BiffInputStream & rStrm)449cdf0e10cSrcweir void SheetViewSettings::importSelection( BiffInputStream& rStrm )
450cdf0e10cSrcweir {
451cdf0e10cSrcweir OSL_ENSURE( !maSheetViews.empty(), "SheetViewSettings::importPane - missing leading WINDOW2 record" );
452cdf0e10cSrcweir if( !maSheetViews.empty() )
453cdf0e10cSrcweir {
454cdf0e10cSrcweir // pane this selection belongs to
455cdf0e10cSrcweir sal_uInt8 nPaneId = rStrm.readuInt8();
456cdf0e10cSrcweir PaneSelectionModel& rPaneSel = maSheetViews.back()->createPaneSelection( lclGetOoxPaneId( nPaneId, -1 ) );
457cdf0e10cSrcweir // cursor position
458cdf0e10cSrcweir BinAddress aActiveCell;
459cdf0e10cSrcweir sal_uInt16 nActiveCellId;
460cdf0e10cSrcweir rStrm >> aActiveCell >> nActiveCellId;
461cdf0e10cSrcweir rPaneSel.maActiveCell = getAddressConverter().createValidCellAddress( aActiveCell, getSheetIndex(), false );
462cdf0e10cSrcweir rPaneSel.mnActiveCellId = nActiveCellId;
463cdf0e10cSrcweir // selection
464cdf0e10cSrcweir rPaneSel.maSelection.clear();
465cdf0e10cSrcweir BinRangeList aSelection;
466cdf0e10cSrcweir aSelection.read( rStrm, false );
467cdf0e10cSrcweir getAddressConverter().convertToCellRangeList( rPaneSel.maSelection, aSelection, getSheetIndex(), false );
468cdf0e10cSrcweir }
469cdf0e10cSrcweir }
470cdf0e10cSrcweir
finalizeImport()471cdf0e10cSrcweir void SheetViewSettings::finalizeImport()
472cdf0e10cSrcweir {
473cdf0e10cSrcweir // force creation of sheet view model to get the Excel defaults
474cdf0e10cSrcweir SheetViewModelRef xModel = maSheetViews.empty() ? createSheetView() : maSheetViews.front();
475cdf0e10cSrcweir
476cdf0e10cSrcweir // #i59590# #158194# special handling for chart sheets (Excel ignores some settings in chart sheets)
477cdf0e10cSrcweir if( getSheetType() == SHEETTYPE_CHARTSHEET )
478cdf0e10cSrcweir {
479cdf0e10cSrcweir xModel->maPaneSelMap.clear();
480cdf0e10cSrcweir xModel->maFirstPos = xModel->maSecondPos = CellAddress( getSheetIndex(), 0, 0 );
481cdf0e10cSrcweir xModel->mnViewType = XML_normal;
482cdf0e10cSrcweir xModel->mnActivePaneId = XML_topLeft;
483cdf0e10cSrcweir xModel->mnPaneState = XML_split;
484cdf0e10cSrcweir xModel->mfSplitX = xModel->mfSplitY = 0.0;
485cdf0e10cSrcweir xModel->mbRightToLeft = false;
486cdf0e10cSrcweir xModel->mbDefGridColor = true;
487cdf0e10cSrcweir xModel->mbShowFormulas = false;
488cdf0e10cSrcweir xModel->mbShowGrid = true;
489cdf0e10cSrcweir xModel->mbShowHeadings = true;
490cdf0e10cSrcweir xModel->mbShowZeros = true;
491cdf0e10cSrcweir xModel->mbShowOutline = true;
492cdf0e10cSrcweir }
493cdf0e10cSrcweir
494cdf0e10cSrcweir // sheet selected (active sheet must be selected)
495cdf0e10cSrcweir bool bSelected = xModel->mbSelected || (getSheetIndex() == getViewSettings().getActiveCalcSheet());
496cdf0e10cSrcweir
497cdf0e10cSrcweir // visible area and current cursor position (selection not supported via API)
498cdf0e10cSrcweir CellAddress aFirstPos = xModel->maFirstPos;
499cdf0e10cSrcweir const PaneSelectionModel* pPaneSel = xModel->getActiveSelection();
500cdf0e10cSrcweir CellAddress aCursor = pPaneSel ? pPaneSel->maActiveCell : aFirstPos;
501cdf0e10cSrcweir
502cdf0e10cSrcweir // freeze/split position default
503cdf0e10cSrcweir sal_Int16 nHSplitMode = API_SPLITMODE_NONE;
504cdf0e10cSrcweir sal_Int16 nVSplitMode = API_SPLITMODE_NONE;
505cdf0e10cSrcweir sal_Int32 nHSplitPos = 0;
506cdf0e10cSrcweir sal_Int32 nVSplitPos = 0;
507cdf0e10cSrcweir // active pane default
508cdf0e10cSrcweir sal_Int16 nActivePane = API_SPLITPANE_BOTTOMLEFT;
509cdf0e10cSrcweir
510cdf0e10cSrcweir // freeze/split position
511cdf0e10cSrcweir if( (xModel->mnPaneState == XML_frozen) || (xModel->mnPaneState == XML_frozenSplit) )
512cdf0e10cSrcweir {
513cdf0e10cSrcweir /* Frozen panes: handle split position as row/column positions.
514cdf0e10cSrcweir #i35812# Excel uses number of visible rows/columns in the
515cdf0e10cSrcweir frozen area (rows/columns scolled outside are not incuded),
516cdf0e10cSrcweir Calc uses absolute position of first unfrozen row/column. */
517cdf0e10cSrcweir const CellAddress& rMaxApiPos = getAddressConverter().getMaxApiAddress();
518cdf0e10cSrcweir if( (xModel->mfSplitX >= 1.0) && (xModel->maFirstPos.Column + xModel->mfSplitX <= rMaxApiPos.Column) )
519cdf0e10cSrcweir nHSplitPos = static_cast< sal_Int32 >( xModel->maFirstPos.Column + xModel->mfSplitX );
520cdf0e10cSrcweir nHSplitMode = (nHSplitPos > 0) ? API_SPLITMODE_FREEZE : API_SPLITMODE_NONE;
521cdf0e10cSrcweir if( (xModel->mfSplitY >= 1.0) && (xModel->maFirstPos.Row + xModel->mfSplitY <= rMaxApiPos.Row) )
522cdf0e10cSrcweir nVSplitPos = static_cast< sal_Int32 >( xModel->maFirstPos.Row + xModel->mfSplitY );
523cdf0e10cSrcweir nVSplitMode = (nVSplitPos > 0) ? API_SPLITMODE_FREEZE : API_SPLITMODE_NONE;
524cdf0e10cSrcweir }
525cdf0e10cSrcweir else if( xModel->mnPaneState == XML_split )
526cdf0e10cSrcweir {
527cdf0e10cSrcweir // split window: view settings API uses twips...
528cdf0e10cSrcweir nHSplitPos = getLimitedValue< sal_Int32, double >( xModel->mfSplitX + 0.5, 0, SAL_MAX_INT32 );
529cdf0e10cSrcweir nHSplitMode = (nHSplitPos > 0) ? API_SPLITMODE_SPLIT : API_SPLITMODE_NONE;
530cdf0e10cSrcweir nVSplitPos = getLimitedValue< sal_Int32, double >( xModel->mfSplitY + 0.5, 0, SAL_MAX_INT32 );
531cdf0e10cSrcweir nVSplitMode = (nVSplitPos > 0) ? API_SPLITMODE_SPLIT : API_SPLITMODE_NONE;
532cdf0e10cSrcweir }
533cdf0e10cSrcweir
534cdf0e10cSrcweir // active pane
535cdf0e10cSrcweir switch( xModel->mnActivePaneId )
536cdf0e10cSrcweir {
537cdf0e10cSrcweir // no horizontal split -> always use left panes
538cdf0e10cSrcweir // no vertical split -> always use *bottom* panes
539cdf0e10cSrcweir case XML_topLeft:
540cdf0e10cSrcweir nActivePane = (nVSplitMode == API_SPLITMODE_NONE) ? API_SPLITPANE_BOTTOMLEFT : API_SPLITPANE_TOPLEFT;
541cdf0e10cSrcweir break;
542cdf0e10cSrcweir case XML_topRight:
543cdf0e10cSrcweir nActivePane = (nHSplitMode == API_SPLITMODE_NONE) ?
544cdf0e10cSrcweir ((nVSplitMode == API_SPLITMODE_NONE) ? API_SPLITPANE_BOTTOMLEFT : API_SPLITPANE_TOPLEFT) :
545cdf0e10cSrcweir ((nVSplitMode == API_SPLITMODE_NONE) ? API_SPLITPANE_BOTTOMRIGHT : API_SPLITPANE_TOPRIGHT);
546cdf0e10cSrcweir break;
547cdf0e10cSrcweir case XML_bottomLeft:
548cdf0e10cSrcweir nActivePane = API_SPLITPANE_BOTTOMLEFT;
549cdf0e10cSrcweir break;
550cdf0e10cSrcweir case XML_bottomRight:
551cdf0e10cSrcweir nActivePane = (nHSplitMode == API_SPLITMODE_NONE) ? API_SPLITPANE_BOTTOMLEFT : API_SPLITPANE_BOTTOMRIGHT;
552cdf0e10cSrcweir break;
553cdf0e10cSrcweir }
554cdf0e10cSrcweir
555cdf0e10cSrcweir // write the sheet view settings into the property sequence
556cdf0e10cSrcweir PropertyMap aPropMap;
557cdf0e10cSrcweir aPropMap[ PROP_TableSelected ] <<= bSelected;
558cdf0e10cSrcweir aPropMap[ PROP_CursorPositionX ] <<= aCursor.Column;
559cdf0e10cSrcweir aPropMap[ PROP_CursorPositionY ] <<= aCursor.Row;
560cdf0e10cSrcweir aPropMap[ PROP_HorizontalSplitMode ] <<= nHSplitMode;
561cdf0e10cSrcweir aPropMap[ PROP_VerticalSplitMode ] <<= nVSplitMode;
562cdf0e10cSrcweir aPropMap[ PROP_HorizontalSplitPositionTwips ] <<= nHSplitPos;
563cdf0e10cSrcweir aPropMap[ PROP_VerticalSplitPositionTwips ] <<= nVSplitPos;
564cdf0e10cSrcweir aPropMap[ PROP_ActiveSplitRange ] <<= nActivePane;
565cdf0e10cSrcweir aPropMap[ PROP_PositionLeft ] <<= aFirstPos.Column;
566cdf0e10cSrcweir aPropMap[ PROP_PositionTop ] <<= aFirstPos.Row;
567cdf0e10cSrcweir aPropMap[ PROP_PositionRight ] <<= xModel->maSecondPos.Column;
568cdf0e10cSrcweir aPropMap[ PROP_PositionBottom ] <<= ((nVSplitPos > 0) ? xModel->maSecondPos.Row : xModel->maFirstPos.Row);
569cdf0e10cSrcweir aPropMap[ PROP_ZoomType ] <<= API_ZOOMTYPE_PERCENT;
570cdf0e10cSrcweir aPropMap[ PROP_ZoomValue ] <<= static_cast< sal_Int16 >( xModel->getNormalZoom() );
571cdf0e10cSrcweir aPropMap[ PROP_PageViewZoomValue ] <<= static_cast< sal_Int16 >( xModel->getPageBreakZoom() );
572cdf0e10cSrcweir aPropMap[ PROP_GridColor ] <<= xModel->getGridColor( getBaseFilter() );
573cdf0e10cSrcweir aPropMap[ PROP_ShowPageBreakPreview ] <<= xModel->isPageBreakPreview();
574cdf0e10cSrcweir aPropMap[ PROP_ShowFormulas ] <<= xModel->mbShowFormulas;
575cdf0e10cSrcweir aPropMap[ PROP_ShowGrid ] <<= xModel->mbShowGrid;
576cdf0e10cSrcweir aPropMap[ PROP_HasColumnRowHeaders ] <<= xModel->mbShowHeadings;
577cdf0e10cSrcweir aPropMap[ PROP_ShowZeroValues ] <<= xModel->mbShowZeros;
578cdf0e10cSrcweir aPropMap[ PROP_IsOutlineSymbolsSet ] <<= xModel->mbShowOutline;
579cdf0e10cSrcweir
580cdf0e10cSrcweir // store sheet view settings in global view settings object
581cdf0e10cSrcweir getViewSettings().setSheetViewSettings( getSheetIndex(), xModel, Any( aPropMap.makePropertyValueSequence() ) );
582cdf0e10cSrcweir }
583cdf0e10cSrcweir
isSheetRightToLeft() const584cdf0e10cSrcweir bool SheetViewSettings::isSheetRightToLeft() const
585cdf0e10cSrcweir {
586cdf0e10cSrcweir return !maSheetViews.empty() && maSheetViews.front()->mbRightToLeft;
587cdf0e10cSrcweir }
588cdf0e10cSrcweir
589cdf0e10cSrcweir // private --------------------------------------------------------------------
590cdf0e10cSrcweir
createSheetView()591cdf0e10cSrcweir SheetViewModelRef SheetViewSettings::createSheetView()
592cdf0e10cSrcweir {
593cdf0e10cSrcweir SheetViewModelRef xModel( new SheetViewModel );
594cdf0e10cSrcweir maSheetViews.push_back( xModel );
595cdf0e10cSrcweir return xModel;
596cdf0e10cSrcweir }
597cdf0e10cSrcweir
598cdf0e10cSrcweir // ============================================================================
599cdf0e10cSrcweir
WorkbookViewModel()600cdf0e10cSrcweir WorkbookViewModel::WorkbookViewModel() :
601cdf0e10cSrcweir mnWinX( 0 ),
602cdf0e10cSrcweir mnWinY( 0 ),
603cdf0e10cSrcweir mnWinWidth( 0 ),
604cdf0e10cSrcweir mnWinHeight( 0 ),
605cdf0e10cSrcweir mnActiveSheet( 0 ),
606cdf0e10cSrcweir mnFirstVisSheet( 0 ),
607cdf0e10cSrcweir mnTabBarWidth( OOX_BOOKVIEW_TABBARRATIO_DEF ),
608cdf0e10cSrcweir mnVisibility( XML_visible ),
609cdf0e10cSrcweir mbShowTabBar( true ),
610cdf0e10cSrcweir mbShowHorScroll( true ),
611cdf0e10cSrcweir mbShowVerScroll( true ),
612cdf0e10cSrcweir mbMinimized( false )
613cdf0e10cSrcweir {
614cdf0e10cSrcweir }
615cdf0e10cSrcweir
616cdf0e10cSrcweir // ----------------------------------------------------------------------------
617cdf0e10cSrcweir
ViewSettings(const WorkbookHelper & rHelper)618cdf0e10cSrcweir ViewSettings::ViewSettings( const WorkbookHelper& rHelper ) :
619cdf0e10cSrcweir WorkbookHelper( rHelper ),
620cdf0e10cSrcweir mbValidOleSize( false )
621cdf0e10cSrcweir {
622cdf0e10cSrcweir }
623cdf0e10cSrcweir
importWorkbookView(const AttributeList & rAttribs)624cdf0e10cSrcweir void ViewSettings::importWorkbookView( const AttributeList& rAttribs )
625cdf0e10cSrcweir {
626cdf0e10cSrcweir WorkbookViewModel& rModel = createWorkbookView();
627cdf0e10cSrcweir rModel.mnWinX = rAttribs.getInteger( XML_xWindow, 0 );
628cdf0e10cSrcweir rModel.mnWinY = rAttribs.getInteger( XML_yWindow, 0 );
629cdf0e10cSrcweir rModel.mnWinWidth = rAttribs.getInteger( XML_windowWidth, 0 );
630cdf0e10cSrcweir rModel.mnWinHeight = rAttribs.getInteger( XML_windowHeight, 0 );
631cdf0e10cSrcweir rModel.mnActiveSheet = rAttribs.getInteger( XML_activeTab, 0 );
632cdf0e10cSrcweir rModel.mnFirstVisSheet = rAttribs.getInteger( XML_firstSheet, 0 );
633cdf0e10cSrcweir rModel.mnTabBarWidth = rAttribs.getInteger( XML_tabRatio, 600 );
634cdf0e10cSrcweir rModel.mnVisibility = rAttribs.getToken( XML_visibility, XML_visible );
635cdf0e10cSrcweir rModel.mbShowTabBar = rAttribs.getBool( XML_showSheetTabs, true );
636cdf0e10cSrcweir rModel.mbShowHorScroll = rAttribs.getBool( XML_showHorizontalScroll, true );
637cdf0e10cSrcweir rModel.mbShowVerScroll = rAttribs.getBool( XML_showVerticalScroll, true );
638cdf0e10cSrcweir rModel.mbMinimized = rAttribs.getBool( XML_minimized, false );
639cdf0e10cSrcweir }
640cdf0e10cSrcweir
importOleSize(const AttributeList & rAttribs)641cdf0e10cSrcweir void ViewSettings::importOleSize( const AttributeList& rAttribs )
642cdf0e10cSrcweir {
643cdf0e10cSrcweir OUString aRange = rAttribs.getString( XML_ref, OUString() );
644cdf0e10cSrcweir mbValidOleSize = getAddressConverter().convertToCellRange( maOleSize, aRange, 0, true, false );
645cdf0e10cSrcweir }
646cdf0e10cSrcweir
importWorkbookView(SequenceInputStream & rStrm)647cdf0e10cSrcweir void ViewSettings::importWorkbookView( SequenceInputStream& rStrm )
648cdf0e10cSrcweir {
649cdf0e10cSrcweir WorkbookViewModel& rModel = createWorkbookView();
650cdf0e10cSrcweir sal_uInt8 nFlags;
651cdf0e10cSrcweir rStrm >> rModel.mnWinX >> rModel.mnWinY >> rModel.mnWinWidth >> rModel.mnWinHeight >> rModel.mnTabBarWidth >> rModel.mnFirstVisSheet >> rModel.mnActiveSheet >> nFlags;
652cdf0e10cSrcweir rModel.mnVisibility = getFlagValue( nFlags, BIFF12_WBVIEW_HIDDEN, XML_hidden, XML_visible );
653cdf0e10cSrcweir rModel.mbShowTabBar = getFlag( nFlags, BIFF12_WBVIEW_SHOWTABBAR );
654cdf0e10cSrcweir rModel.mbShowHorScroll = getFlag( nFlags, BIFF12_WBVIEW_SHOWHORSCROLL );
655cdf0e10cSrcweir rModel.mbShowVerScroll = getFlag( nFlags, BIFF12_WBVIEW_SHOWVERSCROLL );
656cdf0e10cSrcweir rModel.mbMinimized = getFlag( nFlags, BIFF12_WBVIEW_MINIMIZED );
657cdf0e10cSrcweir }
658cdf0e10cSrcweir
importOleSize(SequenceInputStream & rStrm)659cdf0e10cSrcweir void ViewSettings::importOleSize( SequenceInputStream& rStrm )
660cdf0e10cSrcweir {
661cdf0e10cSrcweir BinRange aBinRange;
662cdf0e10cSrcweir rStrm >> aBinRange;
663cdf0e10cSrcweir mbValidOleSize = getAddressConverter().convertToCellRange( maOleSize, aBinRange, 0, true, false );
664cdf0e10cSrcweir }
665cdf0e10cSrcweir
importWindow1(BiffInputStream & rStrm)666cdf0e10cSrcweir void ViewSettings::importWindow1( BiffInputStream& rStrm )
667cdf0e10cSrcweir {
668cdf0e10cSrcweir sal_uInt16 nWinX, nWinY, nWinWidth, nWinHeight;
669cdf0e10cSrcweir rStrm >> nWinX >> nWinY >> nWinWidth >> nWinHeight;
670cdf0e10cSrcweir
671cdf0e10cSrcweir // WINDOW1 record occures in every sheet in BIFF4W
672cdf0e10cSrcweir OSL_ENSURE( maBookViews.empty() || ((getBiff() == BIFF4) && isWorkbookFile()),
673cdf0e10cSrcweir "ViewSettings::importWindow1 - multiple WINDOW1 records" );
674cdf0e10cSrcweir WorkbookViewModel& rModel = createWorkbookView();
675cdf0e10cSrcweir rModel.mnWinX = nWinX;
676cdf0e10cSrcweir rModel.mnWinY = nWinY;
677cdf0e10cSrcweir rModel.mnWinWidth = nWinWidth;
678cdf0e10cSrcweir rModel.mnWinHeight = nWinHeight;
679cdf0e10cSrcweir
680cdf0e10cSrcweir if( getBiff() <= BIFF4 )
681cdf0e10cSrcweir {
682cdf0e10cSrcweir sal_uInt8 nHidden;
683cdf0e10cSrcweir rStrm >> nHidden;
684cdf0e10cSrcweir rModel.mnVisibility = (nHidden == 0) ? XML_visible : XML_hidden;
685cdf0e10cSrcweir }
686cdf0e10cSrcweir else
687cdf0e10cSrcweir {
688cdf0e10cSrcweir sal_uInt16 nFlags, nActiveTab, nFirstVisTab, nSelectCnt, nTabBarWidth;
689cdf0e10cSrcweir rStrm >> nFlags >> nActiveTab >> nFirstVisTab >> nSelectCnt >> nTabBarWidth;
690cdf0e10cSrcweir
691cdf0e10cSrcweir rModel.mnActiveSheet = nActiveTab;
692cdf0e10cSrcweir rModel.mnFirstVisSheet = nFirstVisTab;
693cdf0e10cSrcweir rModel.mnTabBarWidth = nTabBarWidth;
694cdf0e10cSrcweir rModel.mnVisibility = getFlagValue( nFlags, BIFF_WINDOW1_HIDDEN, XML_hidden, XML_visible );
695cdf0e10cSrcweir rModel.mbMinimized = getFlag( nFlags, BIFF_WINDOW1_MINIMIZED );
696cdf0e10cSrcweir rModel.mbShowHorScroll = getFlag( nFlags, BIFF_WINDOW1_SHOWHORSCROLL );
697cdf0e10cSrcweir rModel.mbShowVerScroll = getFlag( nFlags, BIFF_WINDOW1_SHOWVERSCROLL );
698cdf0e10cSrcweir rModel.mbShowTabBar = getFlag( nFlags, BIFF_WINDOW1_SHOWTABBAR );
699cdf0e10cSrcweir }
700cdf0e10cSrcweir }
701cdf0e10cSrcweir
importOleSize(BiffInputStream & rStrm)702cdf0e10cSrcweir void ViewSettings::importOleSize( BiffInputStream& rStrm )
703cdf0e10cSrcweir {
704cdf0e10cSrcweir rStrm.skip( 2 );
705cdf0e10cSrcweir BinRange aBinRange;
706cdf0e10cSrcweir aBinRange.read( rStrm, false );
707cdf0e10cSrcweir mbValidOleSize = getAddressConverter().convertToCellRange( maOleSize, aBinRange, 0, true, false );
708cdf0e10cSrcweir }
709cdf0e10cSrcweir
setSheetViewSettings(sal_Int16 nSheet,const SheetViewModelRef & rxSheetView,const Any & rProperties)710cdf0e10cSrcweir void ViewSettings::setSheetViewSettings( sal_Int16 nSheet, const SheetViewModelRef& rxSheetView, const Any& rProperties )
711cdf0e10cSrcweir {
712cdf0e10cSrcweir maSheetViews[ nSheet ] = rxSheetView;
713cdf0e10cSrcweir maSheetProps[ nSheet ] = rProperties;
714cdf0e10cSrcweir }
715cdf0e10cSrcweir
setSheetUsedArea(const CellRangeAddress & rUsedArea)716cdf0e10cSrcweir void ViewSettings::setSheetUsedArea( const CellRangeAddress& rUsedArea )
717cdf0e10cSrcweir {
718cdf0e10cSrcweir maSheetUsedAreas[ rUsedArea.Sheet ] = rUsedArea;
719cdf0e10cSrcweir }
720cdf0e10cSrcweir
finalizeImport()721cdf0e10cSrcweir void ViewSettings::finalizeImport()
722cdf0e10cSrcweir {
723cdf0e10cSrcweir const WorksheetBuffer& rWorksheets = getWorksheets();
724cdf0e10cSrcweir if( rWorksheets.getWorksheetCount() <= 0 ) return;
725cdf0e10cSrcweir
726cdf0e10cSrcweir // force creation of workbook view model to get the Excel defaults
727cdf0e10cSrcweir const WorkbookViewModel& rModel = maBookViews.empty() ? createWorkbookView() : *maBookViews.front();
728cdf0e10cSrcweir
729cdf0e10cSrcweir // show object mode is part of workbook settings
730cdf0e10cSrcweir sal_Int16 nShowMode = getWorkbookSettings().getApiShowObjectMode();
731cdf0e10cSrcweir
732cdf0e10cSrcweir // view settings for all sheets
733cdf0e10cSrcweir Reference< XNameContainer > xSheetsNC = ContainerHelper::createNameContainer( getBaseFilter().getComponentContext() );
734cdf0e10cSrcweir if( !xSheetsNC.is() ) return;
735cdf0e10cSrcweir for( SheetPropertiesMap::const_iterator aIt = maSheetProps.begin(), aEnd = maSheetProps.end(); aIt != aEnd; ++aIt )
736cdf0e10cSrcweir ContainerHelper::insertByName( xSheetsNC, rWorksheets.getCalcSheetName( aIt->first ), aIt->second );
737cdf0e10cSrcweir
738cdf0e10cSrcweir // use active sheet to set sheet properties that are document-global in Calc
739cdf0e10cSrcweir sal_Int16 nActiveSheet = getActiveCalcSheet();
740cdf0e10cSrcweir SheetViewModelRef& rxActiveSheetView = maSheetViews[ nActiveSheet ];
741cdf0e10cSrcweir OSL_ENSURE( rxActiveSheetView.get(), "ViewSettings::finalizeImport - missing active sheet view settings" );
742cdf0e10cSrcweir if( !rxActiveSheetView )
743cdf0e10cSrcweir rxActiveSheetView.reset( new SheetViewModel );
744cdf0e10cSrcweir
745cdf0e10cSrcweir Reference< XIndexContainer > xContainer = ContainerHelper::createIndexContainer( getBaseFilter().getComponentContext() );
746cdf0e10cSrcweir if( xContainer.is() ) try
747cdf0e10cSrcweir {
748cdf0e10cSrcweir PropertyMap aPropMap;
749cdf0e10cSrcweir aPropMap[ PROP_Tables ] <<= xSheetsNC;
750cdf0e10cSrcweir aPropMap[ PROP_ActiveTable ] <<= rWorksheets.getCalcSheetName( nActiveSheet );
751cdf0e10cSrcweir aPropMap[ PROP_HasHorizontalScrollBar ] <<= rModel.mbShowHorScroll;
752cdf0e10cSrcweir aPropMap[ PROP_HasVerticalScrollBar ] <<= rModel.mbShowVerScroll;
753cdf0e10cSrcweir aPropMap[ PROP_HasSheetTabs ] <<= rModel.mbShowTabBar;
754cdf0e10cSrcweir aPropMap[ PROP_RelativeHorizontalTabbarWidth ] <<= double( rModel.mnTabBarWidth / 1000.0 );
755cdf0e10cSrcweir aPropMap[ PROP_ShowObjects ] <<= nShowMode;
756cdf0e10cSrcweir aPropMap[ PROP_ShowCharts ] <<= nShowMode;
757cdf0e10cSrcweir aPropMap[ PROP_ShowDrawing ] <<= nShowMode;
758cdf0e10cSrcweir aPropMap[ PROP_GridColor ] <<= rxActiveSheetView->getGridColor( getBaseFilter() );
759cdf0e10cSrcweir aPropMap[ PROP_ShowPageBreakPreview ] <<= rxActiveSheetView->isPageBreakPreview();
760cdf0e10cSrcweir aPropMap[ PROP_ShowFormulas ] <<= rxActiveSheetView->mbShowFormulas;
761cdf0e10cSrcweir aPropMap[ PROP_ShowGrid ] <<= rxActiveSheetView->mbShowGrid;
762cdf0e10cSrcweir aPropMap[ PROP_HasColumnRowHeaders ] <<= rxActiveSheetView->mbShowHeadings;
763cdf0e10cSrcweir aPropMap[ PROP_ShowZeroValues ] <<= rxActiveSheetView->mbShowZeros;
764cdf0e10cSrcweir aPropMap[ PROP_IsOutlineSymbolsSet ] <<= rxActiveSheetView->mbShowOutline;
765cdf0e10cSrcweir
766cdf0e10cSrcweir xContainer->insertByIndex( 0, Any( aPropMap.makePropertyValueSequence() ) );
767cdf0e10cSrcweir Reference< XIndexAccess > xIAccess( xContainer, UNO_QUERY_THROW );
768cdf0e10cSrcweir Reference< XViewDataSupplier > xViewDataSuppl( getDocument(), UNO_QUERY_THROW );
769cdf0e10cSrcweir xViewDataSuppl->setViewData( xIAccess );
770cdf0e10cSrcweir }
771cdf0e10cSrcweir catch( Exception& )
772cdf0e10cSrcweir {
773cdf0e10cSrcweir OSL_ENSURE( false, "ViewSettings::finalizeImport - cannot create document view settings" );
774cdf0e10cSrcweir }
775cdf0e10cSrcweir
776cdf0e10cSrcweir /* Set visible area to be used if this document is an embedded OLE object.
777cdf0e10cSrcweir #i44077# If a new OLE object is inserted from file, there is no OLESIZE
778cdf0e10cSrcweir record in the Excel file. In this case, use the used area calculated
779cdf0e10cSrcweir from file contents (used cells and drawing objects). */
780cdf0e10cSrcweir maOleSize.Sheet = nActiveSheet;
781cdf0e10cSrcweir const CellRangeAddress* pVisibleArea = mbValidOleSize ?
782cdf0e10cSrcweir &maOleSize : ContainerHelper::getMapElement( maSheetUsedAreas, nActiveSheet );
783cdf0e10cSrcweir if( pVisibleArea )
784cdf0e10cSrcweir {
785cdf0e10cSrcweir // calculate the visible area in units of 1/100 mm
786cdf0e10cSrcweir PropertySet aRangeProp( getCellRangeFromDoc( *pVisibleArea ) );
787cdf0e10cSrcweir Point aPos;
788cdf0e10cSrcweir Size aSize;
789cdf0e10cSrcweir if( aRangeProp.getProperty( aPos, PROP_Position ) && aRangeProp.getProperty( aSize, PROP_Size ) )
790cdf0e10cSrcweir {
791cdf0e10cSrcweir // set the visible area as sequence of long at the media descriptor
792cdf0e10cSrcweir Sequence< sal_Int32 > aWinExtent( 4 );
793cdf0e10cSrcweir aWinExtent[ 0 ] = aPos.X;
794cdf0e10cSrcweir aWinExtent[ 1 ] = aPos.Y;
795cdf0e10cSrcweir aWinExtent[ 2 ] = aPos.X + aSize.Width;
796cdf0e10cSrcweir aWinExtent[ 3 ] = aPos.Y + aSize.Height;
797cdf0e10cSrcweir getBaseFilter().getMediaDescriptor()[ CREATE_OUSTRING( "WinExtent" ) ] <<= aWinExtent;
798cdf0e10cSrcweir }
799cdf0e10cSrcweir }
800cdf0e10cSrcweir }
801cdf0e10cSrcweir
getActiveCalcSheet() const802cdf0e10cSrcweir sal_Int16 ViewSettings::getActiveCalcSheet() const
803cdf0e10cSrcweir {
804cdf0e10cSrcweir return maBookViews.empty() ? 0 : ::std::max< sal_Int16 >( getWorksheets().getCalcSheetIndex( maBookViews.front()->mnActiveSheet ), 0 );
805cdf0e10cSrcweir }
806cdf0e10cSrcweir
807cdf0e10cSrcweir // private --------------------------------------------------------------------
808cdf0e10cSrcweir
createWorkbookView()809cdf0e10cSrcweir WorkbookViewModel& ViewSettings::createWorkbookView()
810cdf0e10cSrcweir {
811cdf0e10cSrcweir WorkbookViewModelRef xModel( new WorkbookViewModel );
812cdf0e10cSrcweir maBookViews.push_back( xModel );
813cdf0e10cSrcweir return *xModel;
814cdf0e10cSrcweir }
815cdf0e10cSrcweir
816cdf0e10cSrcweir // ============================================================================
817cdf0e10cSrcweir
818cdf0e10cSrcweir } // namespace xls
819cdf0e10cSrcweir } // namespace oox
820