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 { XclRootData::gaDefPassword };
252  return ScfApiHelper::QueryEncryptionDataForMedium( mrData.mrMedium, rVerifier, &aDefaultPasswords );
253 }
254 
256 {
258  return xRootStrg.is() && xRootStrg->IsContained( EXC_STORAGE_VBA_PROJECT );
259 }
260 
261 tools::SvRef<SotStorage> XclRoot::OpenStorage( tools::SvRef<SotStorage> const & xStrg, const OUString& rStrgName ) const
262 {
263  return mrData.mbExport ?
264  ScfTools::OpenStorageWrite( xStrg, rStrgName ) :
265  ScfTools::OpenStorageRead( xStrg, rStrgName );
266 }
267 
268 tools::SvRef<SotStorage> XclRoot::OpenStorage( const OUString& rStrgName ) const
269 {
270  return OpenStorage( GetRootStorage(), rStrgName );
271 }
272 
273 tools::SvRef<SotStorageStream> XclRoot::OpenStream( tools::SvRef<SotStorage> const & xStrg, const OUString& rStrmName ) const
274 {
275  return mrData.mbExport ?
276  ScfTools::OpenStorageStreamWrite( xStrg, rStrmName ) :
277  ScfTools::OpenStorageStreamRead( xStrg, rStrmName );
278 }
279 
280 tools::SvRef<SotStorageStream> XclRoot::OpenStream( const OUString& rStrmName ) const
281 {
282  return OpenStream( GetRootStorage(), rStrmName );
283 }
284 
286 {
287  return mrData.mrDoc;
288 }
289 
291 {
292  return GetDoc().GetDocumentShell();
293 }
294 
296 {
297  SfxObjectShell* pDocShell = GetDocShell();
298  return pDocShell ? comphelper::getFromUnoTunnel<ScModelObj>( pDocShell->GetModel() ) : nullptr;
299 }
300 
302 {
303  return GetDoc().GetRefDevice();
304 }
305 
307 {
308  return *GetDoc().GetStyleSheetPool();
309 }
310 
312 {
313  return *GetDoc().GetRangeName();
314 }
315 
317 {
318  return ((nScTab >= 0) && GetDoc().GetDrawLayer()) ?
319  GetDoc().GetDrawLayer()->GetPage( static_cast< sal_uInt16 >( nScTab ) ) : nullptr;
320 }
321 
323 {
324  return *GetDoc().GetFormatTable();
325 }
326 
328 {
329  return GetFormatter().GetNullDate();
330 }
331 
332 sal_uInt16 XclRoot::GetBaseYear() const
333 {
334  // return 1904 for 1904-01-01, and 1900 for 1899-12-30
335  return (GetNullDate().GetYear() == 1904) ? 1904 : 1900;
336 }
337 
338 const DateTime theOurCompatNullDate( Date( 30, 12, 1899 ));
339 const DateTime theExcelCutOverDate( Date( 1, 3, 1900 ));
340 
341 double XclRoot::GetDoubleFromDateTime( const DateTime& rDateTime ) const
342 {
343  double fValue = rDateTime - GetNullDate();
344  // adjust dates before 1900-03-01 to get correct time values in the range [0.0,1.0)
345  /* XXX: this is only used when reading BIFF, otherwise we'd have to check
346  * for dateCompatibility==true as mentioned below. */
347  if( rDateTime < theExcelCutOverDate && GetNullDate() == theOurCompatNullDate )
348  fValue -= 1.0;
349  return fValue;
350 }
351 
353 {
354  DateTime aDateTime = GetNullDate() + fValue;
355  // adjust dates before 1900-03-01 to get correct time values
356  /* FIXME: correction should only be done when writing BIFF or OOXML
357  * transitional with dateCompatibility==true (or absent for default true),
358  * but not if strict ISO/IEC 29500 which does not have the Excel error
359  * compatibility and the null date is the same 1899-12-30 as ours. */
360  if( aDateTime < theExcelCutOverDate && GetNullDate() == theOurCompatNullDate )
361  aDateTime.AddDays(1);
362  return aDateTime;
363 }
364 
366 {
367  if( !mrData.mxEditEngine )
368  {
369  mrData.mxEditEngine = std::make_shared<ScEditEngineDefaulter>( GetDoc().GetEnginePool() );
371  rEE.SetRefMapMode(MapMode(MapUnit::Map100thMM));
372  rEE.SetEditTextObjectPool( GetDoc().GetEditPool() );
373  rEE.SetUpdateLayout( false );
374  rEE.EnableUndo( false );
375  rEE.SetControlWord( rEE.GetControlWord() & ~EEControlBits::ALLOWBIGOBJS );
376  }
377  return *mrData.mxEditEngine;
378 }
379 
381 {
382  if( !mrData.mxHFEditEngine )
383  {
384  mrData.mxHFEditEngine = std::make_shared<ScHeaderEditEngine>( EditEngine::CreatePool().get() );
386  rEE.SetRefMapMode(MapMode(MapUnit::MapTwip)); // headers/footers use twips as default metric
387  rEE.SetUpdateLayout( false );
388  rEE.EnableUndo( false );
389  rEE.SetControlWord( rEE.GetControlWord() & ~EEControlBits::ALLOWBIGOBJS );
390 
391  // set Calc header/footer defaults
392  auto pEditSet = std::make_unique<SfxItemSet>( rEE.GetEmptyItemSet() );
394  ScPatternAttr::FillToEditItemSet( *pEditSet, aItemSet );
395  // FillToEditItemSet() adjusts font height to 1/100th mm, we need twips
396  pEditSet->Put( aItemSet.Get( ATTR_FONT_HEIGHT ).CloneSetWhich(EE_CHAR_FONTHEIGHT) );
397  pEditSet->Put( aItemSet.Get( ATTR_CJK_FONT_HEIGHT ).CloneSetWhich(EE_CHAR_FONTHEIGHT_CJK) );
398  pEditSet->Put( aItemSet.Get( ATTR_CTL_FONT_HEIGHT ).CloneSetWhich(EE_CHAR_FONTHEIGHT_CTL) );
399  rEE.SetDefaults( std::move(pEditSet) ); // takes ownership
400  }
401  return *mrData.mxHFEditEngine;
402 }
403 
405 {
406  if( !mrData.mxDrawEditEng )
407  {
408  mrData.mxDrawEditEng = std::make_shared<EditEngine>( &GetDoc().GetDrawLayer()->GetItemPool() );
410  rEE.SetRefMapMode(MapMode(MapUnit::Map100thMM));
411  rEE.SetUpdateLayout( false );
412  rEE.EnableUndo( false );
413  rEE.SetControlWord( rEE.GetControlWord() & ~EEControlBits::ALLOWBIGOBJS );
414  }
415  return *mrData.mxDrawEditEng;
416 }
417 
419 {
420  return *mrData.mxFontPropSetHlp;
421 }
422 
424 {
425  return *mrData.mxChPropSetHlp;
426 }
427 
429 {
430  return *mrData.mxExtDocOpt;
431 }
432 
434 {
435  return *mrData.mxTracer;
436 }
437 
438 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
void SetFamily(FontFamily)
XclFontPropSetHelper & GetFontPropSetHelper() const
Returns the property set helper for fonts.
Definition: xlroot.cxx:418
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:404
#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:311
This class wraps an MSFilterTracer to create trace logs for import/export filters.
Definition: xltracer.hxx:50
SCROW Row() const
Definition: address.hxx:261
constexpr OUStringLiteral EXC_STORAGE_VBA_PROJECT
Definition: xlconst.hxx:80
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:285
bool IsContained(const OUString &rEleName) const
SvNumberFormatter & GetFormatter() const
Returns the number formatter of the Calc document.
Definition: xlroot.cxx:322
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:261
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
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:327
XclChPropSetHelper & GetChartPropSetHelper() const
Returns the property set helper for the chart filters.
Definition: xlroot.cxx:423
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:306
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:380
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:1064
ScAddress maXclMaxPos
Highest Calc cell position.
Definition: xlroot.hxx:90
SC_DLLPUBLIC SvNumberFormatter * GetFormatTable() const
Definition: documen2.cxx:442
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:352
ScExtDocOptions & GetExtDocOptions() const
Returns the extended document options.
Definition: xlroot.cxx:428
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:341
ScModelObj * GetDocModelObj() const
Returns the object model of the Calc document.
Definition: xlroot.cxx:295
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:255
sal_uInt16 GetBaseYear() const
Returns the base year depending on the current null date (1900 or 1904).
Definition: xlroot.cxx:332
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:453
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:301
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:433
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:849
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:365
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:637
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:6080
const SCROW EXC_MAXROW3
Definition: xlconst.hxx:53
virtual ~XclRoot()
Definition: xlroot.cxx:186
SfxObjectShell * GetDocumentShell() const
Definition: document.hxx:1063
#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:290
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:273
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:316
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