testautomation/chart2/optional/ch2_losa_ods_to_xls.bas

   1 'encoding UTF-8  Do not remove or change this line!
   2 '**************************************************************************
   3 '* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4 '*
   5 '* Copyright 2008 by Sun Microsystems, Inc.
   6 '*
   7 '* OpenOffice.org - a multi-platform office productivity suite
   8 '*
   9 '* $RCSfile: ch2_losa_ods_to_xls.bas,v $
  10 '*
  11 '* $Revision: 1.2 $
  12 '*
  13 '* last change: $Author: obo $ $Date: 2008-07-22 10:35:03 $
  14 '*
  15 '* This file is part of OpenOffice.org.
  16 '*
  17 '* OpenOffice.org is free software: you can redistribute it and/or modify
  18 '* it under the terms of the GNU Lesser General Public License version 3
  19 '* only, as published by the Free Software Foundation.
  20 '*
  21 '* OpenOffice.org is distributed in the hope that it will be useful,
  22 '* but WITHOUT ANY WARRANTY; without even the implied warranty of
  23 '* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  24 '* GNU Lesser General Public License version 3 for more details
  25 '* (a copy is included in the LICENSE file that accompanied this code).
  26 '*
  27 '* You should have received a copy of the GNU Lesser General Public License
  28 '* version 3 along with OpenOffice.org.  If not, see
  29 '* <http://www.openoffice.org/license.html>
  30 '* for a copy of the LGPLv3 License.
  31 '*
  32 '/************************************************************************
  33 '*
  34 '* owner : oliver.craemer@sun.com
  35 '*
  36 '* short description : Load/Save test for chart files - Input: ODS, Output: XLS
  37 '*
  38 '\************************************************************************
  39
  40 Global gsFileFormat as String
  41 Global gsDirectoryInSourcePath as String
  42 Global gsOutputFileCustomExtension as String
  43
  44 sub main
  45     gsFileFormat = "MS Excel 97"
  46
  47     'Important for determination of input file source path
  48     '-> gtesttoolpath & "chart2\optional\input\" & gsDirectoryInSourcePath &"\"
  49     gsDirectoryInSourcePath = "ods"
  50
  51     'Custom output file extension. Can be different to result from hGetFilternameExtension.
  52     'e.g. "_excel95.xls"
  53     gsOutputFileCustomExtension = ".xls"
  54
  55     Printlog "--------------------------------------------------"
  56     Printlog "---       Load charts in ODS - SaveAS XLS      ---"
  57     Printlog "--------------------------------------------------"
  58
  59     use "chart2/optional/includes/loadsave/ch2_losa.inc"
  60     use "chart2/tools/ch_tools_common.inc"
  61
  62     Call hStatusIn("Chart2", "ch2_losa_ods_to_xls.bas")
  63         Call subLoSaFromTo
  64     Call hStatusOut
  65 end sub
  66 '
  67 '-------------------------------------------------------------------------
  68 '
  69 sub LoadIncludeFiles
  70     use "global\system\includes\master.inc"
  71     use "global\system\includes\gvariabl.inc"
  72     gApplication   = "CALC"
  73     Call GetUseFiles
  74 end sub