LibreOffice Module sc (master)  1
xlroot.cxx
Go to the documentation of this file.
1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 /*
3  * This file is part of the LibreOffice project.
4  *
5  * This Source Code Form is subject to the terms of the Mozilla Public
6  * License, v. 2.0. If a copy of the MPL was not distributed with this
7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8  *
9  * This file incorporates work covered by the following license notice:
10  *
11  * Licensed to the Apache Software Foundation (ASF) under one or more
12  * contributor license agreements. See the NOTICE file distributed
13  * with this work for additional information regarding copyright
14  * ownership. The ASF licenses this file to you under the Apache
15  * License, Version 2.0 (the "License"); you may not use this file
16  * except in compliance with the License. You may obtain a copy of
17  * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18  */
19 
20 #include <memory>
21 #include <xlroot.hxx>
22 #include <sal/log.hxx>
23 #include <com/sun/star/awt/XDevice.hpp>
24 #include <com/sun/star/frame/Desktop.hpp>
25 #include <com/sun/star/frame/XFrame.hpp>
26 #include <com/sun/star/i18n/ScriptType.hpp>
29 #include <sot/storage.hxx>
30 #include <vcl/svapp.hxx>
31 #include <svl/numformat.hxx>
32 #include <svl/stritem.hxx>
33 #include <svl/languageoptions.hxx>
34 #include <sfx2/objsh.hxx>
35 #include <sfx2/docfile.hxx>
36 #include <sfx2/sfxsids.hrc>
37 #include <vcl/font.hxx>
38 #include <vcl/settings.hxx>
39 #include <tools/diagnose_ex.h>
40 
41 #include <editeng/editstat.hxx>
42 #include <scitems.hxx>
43 #include <editeng/eeitem.hxx>
44 #include <editeng/fhgtitem.hxx>
45 #include <document.hxx>
46 #include <docpool.hxx>
47 #include <docuno.hxx>
48 #include <editutil.hxx>
49 #include <drwlayer.hxx>
50 #include <scextopt.hxx>
51 #include <patattr.hxx>
52 #include <fapihelper.hxx>
53 #include <xlconst.hxx>
54 #include <xlstyle.hxx>
55 #include <xlchart.hxx>
56 #include <xltracer.hxx>
57 #include <xltools.hxx>
58 #include <unotools/configmgr.hxx>
59 #include <unotools/useroptions.hxx>
60 #include <root.hxx>
61 
62 namespace ApiScriptType = ::com::sun::star::i18n::ScriptType;
63 
64 using ::com::sun::star::uno::Exception;
65 using ::com::sun::star::uno::Reference;
66 using ::com::sun::star::uno::UNO_QUERY_THROW;
67 using ::com::sun::star::uno::UNO_SET_THROW;
68 using ::com::sun::star::awt::XDevice;
69 using ::com::sun::star::awt::DeviceInfo;
70 using ::com::sun::star::frame::XFrame;
71 
72 using namespace ::com::sun::star;
73 
74 // Global data ================================================================
75 
76 #ifdef DBG_UTIL
78 {
79  OSL_ENSURE( mnObjCnt == 0, "XclDebugObjCounter::~XclDebugObjCounter - wrong root object count" );
80 }
81 #endif
82 
84  tools::SvRef<SotStorage> const & xRootStrg, ScDocument& rDoc, rtl_TextEncoding eTextEnc, bool bExport ) :
85  meBiff( eBiff ),
86  meOutput( EXC_OUTPUT_BINARY ),
87  mrMedium( rMedium ),
88  mxRootStrg( xRootStrg ),
89  mrDoc( rDoc ),
90  meTextEnc( eTextEnc ),
91  meSysLang( Application::GetSettings().GetLanguageTag().getLanguageType() ),
92  meDocLang( Application::GetSettings().GetLanguageTag().getLanguageType() ),
93  meUILang( Application::GetSettings().GetUILanguageTag().getLanguageType() ),
94  mnDefApiScript( ApiScriptType::LATIN ),
95  maScMaxPos( mrDoc.MaxCol(), mrDoc.MaxRow(), MAXTAB ),
96  maXclMaxPos( EXC_MAXCOL2, EXC_MAXROW2, EXC_MAXTAB2 ),
97  maMaxPos( EXC_MAXCOL2, EXC_MAXROW2, EXC_MAXTAB2 ),
98  mxFontPropSetHlp( std::make_shared<XclFontPropSetHelper>() ),
99  mxChPropSetHlp( std::make_shared<XclChPropSetHelper>() ),
100  mxRD( std::make_shared<RootData>() ),
101  mfScreenPixelX( 50.0 ),
102  mfScreenPixelY( 50.0 ),
103  mnCharWidth( 110 ),
104  mnSpaceWidth(45),
105  mnScTab( 0 ),
106  mbExport( bExport )
107 {
109  maUserName = SvtUserOptions().GetLastName();
110  if (maUserName.isEmpty())
111  maUserName = "Calc";
112 
114  {
115  case SvtScriptType::LATIN: mnDefApiScript = ApiScriptType::LATIN; break;
116  case SvtScriptType::ASIAN: mnDefApiScript = ApiScriptType::ASIAN; break;
117  case SvtScriptType::COMPLEX: mnDefApiScript = ApiScriptType::COMPLEX; break;
118  default: SAL_WARN( "sc", "XclRootData::XclRootData - unknown script type" );
119  }
120 
121  // maximum cell position
122  switch( meBiff )
123  {
129  default: DBG_ERROR_BIFF();
130  }
131  maMaxPos.SetCol( ::std::min( maScMaxPos.Col(), maXclMaxPos.Col() ) );
132  maMaxPos.SetRow( ::std::min( maScMaxPos.Row(), maXclMaxPos.Row() ) );
133  maMaxPos.SetTab( ::std::min( maScMaxPos.Tab(), maXclMaxPos.Tab() ) );
134 
135  // document URL and path
136  if( const SfxItemSet* pItemSet = mrMedium.GetItemSet() )
137  if( const SfxStringItem* pItem = pItemSet->GetItem<SfxStringItem>( SID_FILE_NAME ) )
138  maDocUrl = pItem->GetValue();
139  maBasePath = maDocUrl.copy( 0, maDocUrl.lastIndexOf( '/' ) + 1 );
140 
141  // extended document options - always own object, try to copy existing data from document
142  if( const ScExtDocOptions* pOldDocOpt = mrDoc.GetExtDocOptions() )
143  mxExtDocOpt = std::make_shared<ScExtDocOptions>( *pOldDocOpt );
144  else
145  mxExtDocOpt = std::make_shared<ScExtDocOptions>();
146 
147  // screen pixel size
148  try
149  {
150  Reference< frame::XDesktop2 > xFramesSupp = frame::Desktop::create( ::comphelper::getProcessComponentContext() );
151  Reference< XFrame > xFrame( xFramesSupp->getActiveFrame(), UNO_SET_THROW );
152  Reference< XDevice > xDevice( xFrame->getContainerWindow(), UNO_QUERY_THROW );
153  DeviceInfo aDeviceInfo = xDevice->getInfo();
154  mfScreenPixelX = (aDeviceInfo.PixelPerMeterX > 0) ? (100000.0 / aDeviceInfo.PixelPerMeterX) : 50.0;
155  mfScreenPixelY = (aDeviceInfo.PixelPerMeterY > 0) ? (100000.0 / aDeviceInfo.PixelPerMeterY) : 50.0;
156  }
157  catch( const Exception&)
158  {
159  TOOLS_WARN_EXCEPTION( "sc", "XclRootData::XclRootData - cannot get output device info");
160  }
161 }
162 
164 {
165 }
166 
168  mrData( rRootData )
169 {
170 #if defined(DBG_UTIL) && OSL_DEBUG_LEVEL > 0
171  ++mrData.mnObjCnt;
172 #endif
173 
174  // filter tracer
175  mrData.mxTracer = std::make_shared<XclTracer>( GetDocUrl() );
176 }
177 
178 XclRoot::XclRoot( const XclRoot& rRoot ) :
179  mrData( rRoot.mrData )
180 {
181 #if defined(DBG_UTIL) && OSL_DEBUG_LEVEL > 0
182  ++mrData.mnObjCnt;
183 #endif
184 }
185 
187 {
188 #if defined(DBG_UTIL) && OSL_DEBUG_LEVEL > 0
189  --mrData.mnObjCnt;
190 #endif
191 }
192 
194 {
195  (void)rRoot; // avoid compiler warning
196  // allowed for assignment in derived classes - but test if the same root data is used
197  OSL_ENSURE( &mrData == &rRoot.mrData, "XclRoot::operator= - incompatible root data" );
198  return *this;
199 }
200 
201 void XclRoot::SetTextEncoding( rtl_TextEncoding eTextEnc )
202 {
203  if( eTextEnc != RTL_TEXTENCODING_DONTKNOW )
204  mrData.meTextEnc = eTextEnc;
205 }
206 
207 void XclRoot::SetCharWidth( const XclFontData& rFontData )
208 {
209  mrData.mnCharWidth = 0;
210  if( OutputDevice* pPrinter = GetPrinter() )
211  {
212  vcl::Font aFont( rFontData.maName, Size( 0, rFontData.mnHeight ) );
213  aFont.SetFamily( rFontData.GetScFamily( GetTextEncoding() ) );
214  aFont.SetCharSet( rFontData.GetFontEncoding() );
215  aFont.SetWeight( rFontData.GetScWeight() );
216  pPrinter->SetFont( aFont );
217  // Usually digits have the same width, but in some fonts they don't ...
218  // Match the import in sc/source/filter/oox/unitconverter.cxx
219  // UnitConverter::finalizeImport()
220  for (sal_Unicode cChar = '0'; cChar <= '9'; ++cChar)
221  mrData.mnCharWidth = std::max( pPrinter->GetTextWidth( OUString(cChar)), mrData.mnCharWidth);
222 
223  // Set the width of space ' ' character.
224  mrData.mnSpaceWidth = pPrinter->GetTextWidth(OUString(' '));
225  }
226  if( mrData.mnCharWidth <= 0 )
227  {
228  // #i48717# Win98 with HP LaserJet returns 0
229  SAL_WARN( "sc", "XclRoot::SetCharWidth - invalid character width (no printer?)" );
230  mrData.mnCharWidth = 11 * rFontData.mnHeight / 20;
231  }
232  if (mrData.mnSpaceWidth <= 0)
233  {
234  SAL_WARN( "sc", "XclRoot::SetCharWidth - invalid character width (no printer?)" );
235  mrData.mnSpaceWidth = 45;
236  }
237 }
238 
239 sal_Int32 XclRoot::GetHmmFromPixelX( double fPixelX ) const
240 {
241  return static_cast< sal_Int32 >( fPixelX * mrData.mfScreenPixelX + 0.5 );
242 }
243 
244 sal_Int32 XclRoot::GetHmmFromPixelY( double fPixelY ) const
245 {
246  return static_cast< sal_Int32 >( fPixelY * mrData.mfScreenPixelY + 0.5 );
247 }
248 
249 uno::Sequence< beans::NamedValue > XclRoot::RequestEncryptionData( ::comphelper::IDocPasswordVerifier& rVerifier ) const
250 {
251  ::std::vector< OUString > aDefaultPasswords;
252  aDefaultPasswords.push_back( XclRootData::gaDefPassword );
253  return ScfApiHelper::QueryEncryptionDataForMedium( mrData.mrMedium, rVerifier, &aDefaultPasswords );
254 }
255 
257 {
259  return xRootStrg.is() && xRootStrg->IsContained( EXC_STORAGE_VBA_PROJECT );
260 }
261 
262 tools::SvRef<SotStorage> XclRoot::OpenStorage( tools::SvRef<SotStorage> const & xStrg, const OUString& rStrgName ) const
263 {
264  return mrData.mbExport ?
265  ScfTools::OpenStorageWrite( xStrg, rStrgName ) :
266  ScfTools::OpenStorageRead( xStrg, rStrgName );
267 }
268 
269 tools::SvRef<SotStorage> XclRoot::OpenStorage( const OUString& rStrgName ) const
270 {
271  return OpenStorage( GetRootStorage(), rStrgName );
272 }
273 
274 tools::SvRef<SotStorageStream> XclRoot::OpenStream( tools::SvRef<SotStorage> const & xStrg, const OUString& rStrmName ) const
275 {
276  return mrData.mbExport ?
277  ScfTools::OpenStorageStreamWrite( xStrg, rStrmName ) :
278  ScfTools::OpenStorageStreamRead( xStrg, rStrmName );
279 }
280 
281 tools::SvRef<SotStorageStream> XclRoot::OpenStream( const OUString& rStrmName ) const
282 {
283  return OpenStream( GetRootStorage(), rStrmName );
284 }
285 
287 {
288  return mrData.mrDoc;
289 }
290 
292 {
293  return GetDoc().GetDocumentShell();
294 }
295 
297 {
298  SfxObjectShell* pDocShell = GetDocShell();
299  return pDocShell ? comphelper::getFromUnoTunnel<ScModelObj>( pDocShell->GetModel() ) : nullptr;
300 }
301 
303 {
304  return GetDoc().GetRefDevice();
305 }
306 
308 {
309  return *GetDoc().GetStyleSheetPool();
310 }
311 
313 {
314  return *GetDoc().GetRangeName();
315 }
316 
318 {
319  return ((nScTab >= 0) && GetDoc().GetDrawLayer()) ?
320  GetDoc().GetDrawLayer()->GetPage( static_cast< sal_uInt16 >( nScTab ) ) : nullptr;
321 }
322 
324 {
325  return *GetDoc().GetFormatTable();
326 }
327 
329 {
330  return GetFormatter().GetNullDate();
331 }
332 
333 sal_uInt16 XclRoot::GetBaseYear() const
334 {
335  // return 1904 for 1904-01-01, and 1900 for 1899-12-30
336  return (GetNullDate().GetYear() == 1904) ? 1904 : 1900;
337 }
338 
339 const DateTime theOurCompatNullDate( Date( 30, 12, 1899 ));
340 const DateTime theExcelCutOverDate( Date( 1, 3, 1900 ));
341 
342 double XclRoot::GetDoubleFromDateTime( const DateTime& rDateTime ) const
343 {
344  double fValue = rDateTime - GetNullDate();
345  // adjust dates before 1900-03-01 to get correct time values in the range [0.0,1.0)
346  /* XXX: this is only used when reading BIFF, otherwise we'd have to check
347  * for dateCompatibility==true as mentioned below. */
348  if( rDateTime < theExcelCutOverDate && GetNullDate() == theOurCompatNullDate )
349  fValue -= 1.0;
350  return fValue;
351 }
352 
354 {
355  DateTime aDateTime = GetNullDate() + fValue;
356  // adjust dates before 1900-03-01 to get correct time values
357  /* FIXME: correction should only be done when writing BIFF or OOXML
358  * transitional with dateCompatibility==true (or absent for default true),
359  * but not if strict ISO/IEC 29500 which does not have the Excel error
360  * compatibility and the null date is the same 1899-12-30 as ours. */
361  if( aDateTime < theExcelCutOverDate && GetNullDate() == theOurCompatNullDate )
362  aDateTime.AddDays(1);
363  return aDateTime;
364 }
365 
367 {
368  if( !mrData.mxEditEngine )
369  {
370  mrData.mxEditEngine = std::make_shared<ScEditEngineDefaulter>( GetDoc().GetEnginePool() );
372  rEE.SetRefMapMode(MapMode(MapUnit::Map100thMM));
373  rEE.SetEditTextObjectPool( GetDoc().GetEditPool() );
374  rEE.SetUpdateLayout( false );
375  rEE.EnableUndo( false );
376  rEE.SetControlWord( rEE.GetControlWord() & ~EEControlBits::ALLOWBIGOBJS );
377  }
378  return *mrData.mxEditEngine;
379 }
380 
382 {
383  if( !mrData.mxHFEditEngine )
384  {
385  mrData.mxHFEditEngine = std::make_shared<ScHeaderEditEngine>( EditEngine::CreatePool().get() );
387  rEE.SetRefMapMode(MapMode(MapUnit::MapTwip)); // headers/footers use twips as default metric
388  rEE.SetUpdateLayout( false );
389  rEE.EnableUndo( false );
390  rEE.SetControlWord( rEE.GetControlWord() & ~EEControlBits::ALLOWBIGOBJS );
391 
392  // set Calc header/footer defaults
393  auto pEditSet = std::make_unique<SfxItemSet>( rEE.GetEmptyItemSet() );
395  ScPatternAttr::FillToEditItemSet( *pEditSet, aItemSet );
396  // FillToEditItemSet() adjusts font height to 1/100th mm, we need twips
397  pEditSet->Put( aItemSet.Get( ATTR_FONT_HEIGHT ).CloneSetWhich(EE_CHAR_FONTHEIGHT) );
398  pEditSet->Put( aItemSet.Get( ATTR_CJK_FONT_HEIGHT ).CloneSetWhich(EE_CHAR_FONTHEIGHT_CJK) );
399  pEditSet->Put( aItemSet.Get( ATTR_CTL_FONT_HEIGHT ).CloneSetWhich(EE_CHAR_FONTHEIGHT_CTL) );
400  rEE.SetDefaults( std::move(pEditSet) ); // takes ownership
401  }
402  return *mrData.mxHFEditEngine;
403 }
404 
406 {
407  if( !mrData.mxDrawEditEng )
408  {
409  mrData.mxDrawEditEng = std::make_shared<EditEngine>( &GetDoc().GetDrawLayer()->GetItemPool() );
411  rEE.SetRefMapMode(MapMode(MapUnit::Map100thMM));
412  rEE.SetUpdateLayout( false );
413  rEE.EnableUndo( false );
414  rEE.SetControlWord( rEE.GetControlWord() & ~EEControlBits::ALLOWBIGOBJS );
415  }
416  return *mrData.mxDrawEditEng;
417 }
418 
420 {
421  return *mrData.mxFontPropSetHlp;
422 }
423 
425 {
426  return *mrData.mxChPropSetHlp;
427 }
428 
430 {
431  return *mrData.mxExtDocOpt;
432 }
433 
435 {
436  return *mrData.mxTracer;
437 }
438 
439 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
void SetFamily(FontFamily)
XclFontPropSetHelper & GetFontPropSetHelper() const
Returns the property set helper for fonts.
Definition: xlroot.cxx:419
const SCTAB EXC_MAXTAB3
Definition: xlconst.hxx:54
bool is() const
tools::Long mnSpaceWidth
Width of '0' in default font (twips).
Definition: xlroot.hxx:107
sal_Int32 mnObjCnt
Definition: xlroot.hxx:43
EditEngine & GetDrawEditEngine() const
Returns the edit engine for import/export of drawing text boxes.
Definition: xlroot.cxx:405
#define DBG_ERROR_BIFF()
Definition: xltools.hxx:33
rtl_TextEncoding GetTextEncoding() const
Returns the text encoding to import/export byte strings.
Definition: xlroot.hxx:147
XclBiff
An enumeration for all Excel file format types (BIFF types).
Definition: xlconst.hxx:29
const bool mbExport
Current Calc sheet index.
Definition: xlroot.hxx:109
ScRangeName & GetNamedRanges() const
Returns the defined names container of the Calc document.
Definition: xlroot.cxx:312
This class wraps an MSFilterTracer to create trace logs for import/export filters.
Definition: xltracer.hxx:50
SCROW Row() const
Definition: address.hxx:261
const SCCOL EXC_MAXCOL4
Definition: xlconst.hxx:56
void SetCharWidth(const XclFontData &rFontData)
Sets the width of the '0' - '9' digit character as well as the ' ' space char (using the default font...
Definition: xlroot.cxx:207
XclRootData(XclBiff eBiff, SfxMedium &rMedium, tools::SvRef< SotStorage > const &xRootStrg, ScDocument &rDoc, rtl_TextEncoding eTextEnc, bool bExport)
false = Import, true = Export.
Definition: xlroot.cxx:83
const SCCOL EXC_MAXCOL2
Definition: xlconst.hxx:48
Reference< XFrame > xFrame
static tools::SvRef< SotStorageStream > OpenStorageStreamWrite(tools::SvRef< SotStorage > const &xStrg, const OUString &rStrmName)
Creates and opens a stream with the specified name in the passed storage (read/write).
Definition: ftools.cxx:188
SC_DLLPUBLIC ScRangeName * GetRangeName(SCTAB nTab) const
Definition: documen3.cxx:168
This struct helps reading and writing Excel fonts.
Definition: xlstyle.hxx:285
virtual ~XclRootData()
Definition: xlroot.cxx:163
css::uno::Reference< css::frame::XModel3 > GetModel() const
XclFontPropSetHlpRef mxFontPropSetHlp
Edit engine for text boxes.
Definition: xlroot.hxx:97
OUString maDocUrl
The source or destination document.
Definition: xlroot.hxx:80
void SetWeight(FontWeight)
const SCCOL EXC_MAXCOL5
Definition: xlconst.hxx:60
Stores global buffers and data needed elsewhere in the Excel filters.
Definition: xlroot.hxx:61
sal_uInt16 mnHeight
Font color.
Definition: xlstyle.hxx:290
Extended options held by an ScDocument containing additional settings for filters.
Definition: scextopt.hxx:76
rtl_TextEncoding GetFontEncoding() const
Returns the font text encoding.
Definition: xlstyle.cxx:249
sal_Int32 GetHmmFromPixelX(double fPixelX) const
Calculates the width of the passed number of pixels in 1/100 mm.
Definition: xlroot.cxx:239
void SetCharSet(rtl_TextEncoding)
std::shared_ptr< T > make_shared(Args &&...args)
ScDocument & GetDoc() const
Returns reference to the destination document (import) or source document (export).
Definition: xlroot.cxx:286
bool IsContained(const OUString &rEleName) const
SvNumberFormatter & GetFormatter() const
Returns the number formatter of the Calc document.
Definition: xlroot.cxx:323
static void FillToEditItemSet(SfxItemSet &rEditSet, const SfxItemSet &rSrcSet, const SfxItemSet *pCondSet=nullptr)
Converts all Calc items contained in rSrcSet to edit engine items and puts them into rEditSet...
Definition: patattr.cxx:552
static tools::SvRef< SotStorage > OpenStorageWrite(tools::SvRef< SotStorage > const &xStrg, const OUString &rStrgName)
Creates and opens a storage with the specified name in the passed storage (read/write).
Definition: ftools.cxx:172
const SCTAB EXC_MAXTAB8
Definition: xlconst.hxx:66
tools::SvRef< SotStorage > OpenStorage(tools::SvRef< SotStorage > const &xStrg, const OUString &rStrgName) const
Tries to open a storage as child of the specified storage for reading or writing. ...
Definition: xlroot.cxx:262
EEControlBits
ScHeaderEERef mxHFEditEngine
Edit engine for rich strings etc.
Definition: xlroot.hxx:94
constexpr TypedWhichId< SvxFontHeightItem > EE_CHAR_FONTHEIGHT(EE_CHAR_START+2)
const SCTAB EXC_MAXTAB4
Definition: xlconst.hxx:58
static rtl::Reference< SfxItemPool > CreatePool()
sal_uInt16 sal_Unicode
#define EXC_STORAGE_VBA_PROJECT
Definition: xlconst.hxx:80
const DateTime theExcelCutOverDate(Date(1, 3, 1900))
XclChPropSetHlpRef mxChPropSetHlp
Property set helper for fonts.
Definition: xlroot.hxx:98
ObjectFormatterData & mrData
Helper class for usage of property sets.
Definition: xlstyle.hxx:402
DateTime GetNullDate() const
Returns the null date of the current number formatter.
Definition: xlroot.cxx:328
XclChPropSetHelper & GetChartPropSetHelper() const
Returns the property set helper for the chart filters.
Definition: xlroot.cxx:424
const SCROW EXC_MAXROW2
Definition: xlconst.hxx:49
MS Excel 4.0.
Definition: xlconst.hxx:34
ScStyleSheetPool & GetStyleSheetPool() const
Returns the style sheet pool of the Calc document.
Definition: xlroot.cxx:307
static css::uno::Sequence< css::beans::NamedValue > QueryEncryptionDataForMedium(SfxMedium &rMedium,::comphelper::IDocPasswordVerifier &rVerifier, const ::std::vector< OUString > *pDefaultPasswords)
Opens a password dialog and returns the encryption data.
Definition: fapihelper.cxx:102
const OUString & GetDocUrl() const
Returns the document URL of the imported/exported file.
Definition: xlroot.hxx:172
static bool IsFuzzing()
SCTAB Tab() const
Definition: address.hxx:270
sal_Int16 mnDefApiScript
UI language (import: from file, export: from system).
Definition: xlroot.hxx:88
void SetRow(SCROW nRowP)
Definition: address.hxx:274
void SetCol(SCCOL nColP)
Definition: address.hxx:278
const tools::SvRef< SotStorage > & GetRootStorage() const
Returns the OLE2 root storage of the imported/exported file.
Definition: xlroot.hxx:186
ScHeaderEditEngine & GetHFEditEngine() const
Returns the edit engine for import/export of headers/footers.
Definition: xlroot.cxx:381
const SCTAB EXC_MAXTAB5
Definition: xlconst.hxx:62
static tools::SvRef< SotStorage > OpenStorageRead(tools::SvRef< SotStorage > const &xStrg, const OUString &rStrgName)
Tries to open an existing storage with the specified name in the passed storage (read-only).
Definition: ftools.cxx:164
const SCTAB EXC_MAXTAB2
Definition: xlconst.hxx:50
FontWeight GetScWeight() const
Returns the Calc font weight.
Definition: xlstyle.cxx:260
void SetTab(SCTAB nTabP)
Definition: address.hxx:282
SC_DLLPUBLIC ScDrawLayer * GetDrawLayer()
Definition: document.hxx:1058
ScAddress maXclMaxPos
Highest Calc cell position.
Definition: xlroot.hxx:90
SC_DLLPUBLIC SvNumberFormatter * GetFormatTable() const
Definition: documen2.cxx:441
MS Excel 5.0, MS Excel 7.0 (95)
Definition: xlconst.hxx:35
#define TOOLS_WARN_EXCEPTION(area, stream)
constexpr TypedWhichId< SvxFontHeightItem > ATTR_CJK_FONT_HEIGHT(112)
DateTime GetDateTimeFromDouble(double fValue) const
Converts a floating-point value to a date/time value.
Definition: xlroot.cxx:353
ScExtDocOptions & GetExtDocOptions() const
Returns the extended document options.
Definition: xlroot.cxx:429
ScDocument & mrDoc
The root OLE storage of imported/exported file.
Definition: xlroot.hxx:79
void Set(SCCOL nCol, SCROW nRow, SCTAB nTab)
Definition: address.hxx:405
const SCCOL EXC_MAXCOL3
Definition: xlconst.hxx:52
double GetDoubleFromDateTime(const DateTime &rDateTime) const
Converts a date/time value to a floating-point value.
Definition: xlroot.cxx:342
ScModelObj * GetDocModelObj() const
Returns the object model of the Calc document.
Definition: xlroot.cxx:296
rtl_TextEncoding meTextEnc
The default password used for stream encryption.
Definition: xlroot.hxx:84
bool HasVbaStorage() const
Returns true, if the document contains a VBA storage.
Definition: xlroot.cxx:256
sal_uInt16 GetBaseYear() const
Returns the base year depending on the current null date (1900 or 1904).
Definition: xlroot.cxx:333
double mfScreenPixelY
Width of a screen pixel (1/100 mm).
Definition: xlroot.hxx:105
const SdrPage * GetPage(sal_uInt16 nPgNum) const
SC_DLLPUBLIC SfxItemPool * GetEnginePool() const
Definition: documen2.cxx:452
const SCROW EXC_MAXROW8
Definition: xlconst.hxx:65
sal_Int32 GetHmmFromPixelY(double fPixelY) const
Calculates the height of the passed number of pixels in 1/100 mm.
Definition: xlroot.cxx:244
css::uno::Sequence< css::beans::NamedValue > RequestEncryptionData(::comphelper::IDocPasswordVerifier &rVerifier) const
Requests and verifies a password from the medium or the user.
Definition: xlroot.cxx:249
const SCROW EXC_MAXROW4
Definition: xlconst.hxx:57
Helper class for usage of property sets.
Definition: xlchart.hxx:1309
MS Excel 3.0.
Definition: xlconst.hxx:33
SfxItemSet * GetItemSet() const
void AddDays(sal_Int32 nAddDays)
XclRoot(XclRootData &rRootData)
Definition: xlroot.cxx:167
void SetTextEncoding(rtl_TextEncoding eTextEnc)
Sets the text encoding to import/export byte strings.
Definition: xlroot.cxx:201
OutputDevice * GetPrinter() const
Returns pointer to the printer of the Calc document.
Definition: xlroot.cxx:302
const SCTAB MAXTAB
Definition: address.hxx:70
constexpr TypedWhichId< SvxFontHeightItem > ATTR_CTL_FONT_HEIGHT(117)
XclTracerRef mxTracer
Extended document options.
Definition: xlroot.hxx:101
static tools::SvRef< SotStorageStream > OpenStorageStreamRead(tools::SvRef< SotStorage > const &xStrg, const OUString &rStrmName)
Tries to open an existing stream with the specified name in the passed storage (read-only).
Definition: ftools.cxx:180
SCCOL Col() const
Definition: address.hxx:266
XclTracer & GetTracer() const
Returns the filter tracer.
Definition: xlroot.cxx:434
SfxMedium & mrMedium
Current Output format.
Definition: xlroot.hxx:77
XclRootData & mrData
Definition: xlroot.hxx:266
bool mbExport
static SC_DLLPUBLIC SvtScriptType GetDefaultScriptType()
Definition: global.cxx:852
SC_DLLPUBLIC OutputDevice * GetRefDevice()
Definition: documen8.cxx:200
ScEditEngineDefaulter & GetEditEngine() const
Returns the edit engine for import/export of rich strings etc.
Definition: xlroot.cxx:366
constexpr TypedWhichId< SvxFontHeightItem > EE_CHAR_FONTHEIGHT_CTL(EE_CHAR_START+20)
const SCROW EXC_MAXROW5
Definition: xlconst.hxx:61
ScEEDefaulterRef mxEditEngine
Highest position valid in Calc and Excel.
Definition: xlroot.hxx:93
ScExtDocOptions * GetExtDocOptions()
Definition: document.hxx:631
Reference< XComponentContext > getProcessComponentContext()
tools::Long mnCharWidth
Height of a screen pixel (1/100 mm).
Definition: xlroot.hxx:106
ScAddress maMaxPos
Highest Excel cell position.
Definition: xlroot.hxx:91
FontFamily GetScFamily(rtl_TextEncoding eDefTextEnc) const
Returns the Calc font family.
Definition: xlstyle.cxx:229
SC_DLLPUBLIC ScStyleSheetPool * GetStyleSheetPool() const
Definition: document.cxx:6092
const SCROW EXC_MAXROW3
Definition: xlconst.hxx:53
virtual ~XclRoot()
Definition: xlroot.cxx:186
SfxObjectShell * GetDocumentShell() const
Definition: document.hxx:1057
#define SAL_WARN(area, stream)
constexpr TypedWhichId< SvxFontHeightItem > EE_CHAR_FONTHEIGHT_CJK(EE_CHAR_START+19)
const SfxItemPool & GetItemPool() const
OUString maBasePath
Document URL of imported/exported file.
Definition: xlroot.hxx:81
const SCCOL EXC_MAXCOL8
Definition: xlconst.hxx:64
SfxObjectShell * GetDocShell() const
Returns the object shell of the Calc document.
Definition: xlroot.cxx:291
const DateTime theOurCompatNullDate(Date(30, 12, 1899))
MS Excel 2.1.
Definition: xlconst.hxx:32
tools::SvRef< SotStorageStream > OpenStream(tools::SvRef< SotStorage > const &xStrg, const OUString &rStrmName) const
Tries to open a new stream in the specified storage for reading or writing.
Definition: xlroot.cxx:274
const Date & GetNullDate() const
XclRoot & operator=(const XclRoot &rRoot)
Definition: xlroot.cxx:193
XclBiff meBiff
Definition: xlroot.hxx:75
Access to global data for a filter object (imported or exported document) from other classes...
Definition: xlroot.hxx:127
constexpr TypedWhichId< SvxFontHeightItem > ATTR_FONT_HEIGHT(101)
EditEngineRef mxDrawEditEng
Edit engine for header/footer.
Definition: xlroot.hxx:95
static constexpr OUStringLiteral gaDefPassword
Current user name.
Definition: xlroot.hxx:83
ScAddress maScMaxPos
Default script type for blank cells (API constant).
Definition: xlroot.hxx:89
OUString maUserName
Base path of imported/exported file (path of maDocUrl).
Definition: xlroot.hxx:82
SdrPage * GetSdrPage(SCTAB nScTab) const
Returns the drawing layer page of the passed sheet, if present.
Definition: xlroot.cxx:317
sal_Int16 SCTAB
Definition: types.hxx:22
double mfScreenPixelX
Old RootData struct. Will be removed.
Definition: xlroot.hxx:104
ScExtDocOptRef mxExtDocOpt
Property set helper for chart filter.
Definition: xlroot.hxx:100
OUString maName
Definition: xlstyle.hxx:287
typedef void(CALLTYPE *GetFuncDataPtr)(sal_uInt16 &nNo