sc/source/ui/unoobj/filtuno.cxx

   1 /*************************************************************************
   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: filtuno.cxx,v $
  10  * $Revision: 1.14 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_sc.hxx"
  33
  34
  35
  36 #include <com/sun/star/ui/dialogs/ExecutableDialogResults.hpp>
  37 #include <tools/urlobj.hxx>
  38 #include <vcl/msgbox.hxx>
  39 #include <unotools/ucbstreamhelper.hxx>
  40
  41 #include "editutil.hxx"
  42 #include "filtuno.hxx"
  43 #include "miscuno.hxx"
  44 #include "unoguard.hxx"
  45 #include "scdll.hxx"
  46 #include "imoptdlg.hxx"
  47 #include "asciiopt.hxx"
  48 #include "docsh.hxx"
  49 #include "globstr.hrc"
  50
  51
  52 #include "sc.hrc" //CHINA001
  53 #include "scabstdlg.hxx" //CHINA001
  54 #include "i18npool/lang.h"
  55
  56 #include <memory>
  57
  58 using namespace ::com::sun::star;
  59 using ::rtl::OUStringBuffer;
  60
  61 //------------------------------------------------------------------------
  62
  63 #define SCFILTEROPTIONSOBJ_SERVICE              "com.sun.star.ui.dialogs.FilterOptionsDialog"
  64 #define SCFILTEROPTIONSOBJ_IMPLNAME             "com.sun.star.comp.Calc.FilterOptionsDialog"
  65
  66 SC_SIMPLE_SERVICE_INFO( ScFilterOptionsObj, SCFILTEROPTIONSOBJ_IMPLNAME, SCFILTEROPTIONSOBJ_SERVICE )
  67
  68 #define SC_UNONAME_FILENAME         "URL"
  69 #define SC_UNONAME_FILTERNAME           "FilterName"
  70 #define SC_UNONAME_FILTEROPTIONS        "FilterOptions"
  71 #define SC_UNONAME_INPUTSTREAM          "InputStream"
  72
  73 //------------------------------------------------------------------------
  74
  75 ScFilterOptionsObj::ScFilterOptionsObj() :
  76     bExport( sal_False )
  77 {
  78 }
  79
  80 ScFilterOptionsObj::~ScFilterOptionsObj()
  81 {
  82 }
  83
  84 // stuff for exService_...
  85
  86 uno::Reference<uno::XInterface> SAL_CALL ScFilterOptionsObj_CreateInstance(
  87                         const uno::Reference<lang::XMultiServiceFactory>& )
  88 {
  89     ScUnoGuard aGuard;
  90     ScDLL::Init();
  91     return (::cppu::OWeakObject*) new ScFilterOptionsObj;
  92 }
  93
  94 rtl::OUString ScFilterOptionsObj::getImplementationName_Static()
  95 {
  96     return rtl::OUString::createFromAscii( SCFILTEROPTIONSOBJ_IMPLNAME );
  97 }
  98
  99 uno::Sequence<rtl::OUString> ScFilterOptionsObj::getSupportedServiceNames_Static()
 100 {
 101     uno::Sequence<rtl::OUString> aRet(1);
 102     rtl::OUString* pArray = aRet.getArray();
 103     pArray[0] = rtl::OUString::createFromAscii( SCFILTEROPTIONSOBJ_SERVICE );
 104     return aRet;
 105 }
 106
 107 // XPropertyAccess
 108
 109 uno::Sequence<beans::PropertyValue> SAL_CALL ScFilterOptionsObj::getPropertyValues() throw(uno::RuntimeException)
 110 {
 111     uno::Sequence<beans::PropertyValue> aRet(1);
 112     beans::PropertyValue* pArray = aRet.getArray();
 113
 114     pArray[0].Name = rtl::OUString::createFromAscii( SC_UNONAME_FILTEROPTIONS );
 115     pArray[0].Value <<= aFilterOptions;
 116
 117     return aRet;
 118 }
 119
 120 void SAL_CALL ScFilterOptionsObj::setPropertyValues( const uno::Sequence<beans::PropertyValue>& aProps )
 121                     throw(beans::UnknownPropertyException, beans::PropertyVetoException,
 122                             lang::IllegalArgumentException, lang::WrappedTargetException, uno::RuntimeException)
 123 {
 124     const beans::PropertyValue* pPropArray = aProps.getConstArray();
 125     long nPropCount = aProps.getLength();
 126     for (long i = 0; i < nPropCount; i++)
 127     {
 128         const beans::PropertyValue& rProp = pPropArray[i];
 129         String aPropName(rProp.Name);
 130
 131         if ( aPropName.EqualsAscii( SC_UNONAME_FILENAME ) )
 132             rProp.Value >>= aFileName;
 133         else if ( aPropName.EqualsAscii( SC_UNONAME_FILTERNAME ) )
 134             rProp.Value >>= aFilterName;
 135         else if ( aPropName.EqualsAscii( SC_UNONAME_FILTEROPTIONS ) )
 136             rProp.Value >>= aFilterOptions;
 137         else if ( aPropName.EqualsAscii( SC_UNONAME_INPUTSTREAM ) )
 138             rProp.Value >>= xInputStream;
 139     }
 140 }
 141
 142 // XExecutableDialog
 143
 144 void SAL_CALL ScFilterOptionsObj::setTitle( const ::rtl::OUString& /* aTitle */ ) throw(uno::RuntimeException)
 145 {
 146     // not used
 147 }
 148
 149 sal_Int16 SAL_CALL ScFilterOptionsObj::execute() throw(uno::RuntimeException)
 150 {
 151     sal_Int16 nRet = ui::dialogs::ExecutableDialogResults::CANCEL;
 152
 153     String aFilterString( aFilterName );
 154
 155     ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
 156     DBG_ASSERT(pFact, "ScAbstractFactory create fail!");
 157
 158     if ( !bExport && aFilterString == ScDocShell::GetAsciiFilterName() )
 159     {
 160         //      ascii import is special...
 161
 162         INetURLObject aURL( aFileName );
 163         String aExt(aURL.getExtension());
 164         String aPrivDatName(aURL.getName());
 165         sal_Unicode cAsciiDel;
 166         if (aExt.EqualsIgnoreCaseAscii("CSV"))
 167             cAsciiDel = ',';
 168         else
 169             cAsciiDel = '\t';
 170
 171         SvStream* pInStream = NULL;
 172         if ( xInputStream.is() )
 173             pInStream = utl::UcbStreamHelper::CreateStream( xInputStream );
 174
 175         //CHINA001 ScImportAsciiDlg* pDlg = new ScImportAsciiDlg( NULL, aPrivDatName, pInStream, cAsciiDel );
 176         AbstractScImportAsciiDlg* pDlg = pFact->CreateScImportAsciiDlg( NULL, aPrivDatName, pInStream, RID_SCDLG_ASCII, cAsciiDel);
 177         DBG_ASSERT(pDlg, "Dialog create fail!");//CHINA001
 178         if ( pDlg->Execute() == RET_OK )
 179         {
 180             ScAsciiOptions aOptions;
 181             pDlg->GetOptions( aOptions );
 182             aFilterOptions = aOptions.WriteToString();
 183             nRet = ui::dialogs::ExecutableDialogResults::OK;
 184         }
 185         delete pDlg;
 186         delete pInStream;
 187     }
 188     else if ( aFilterString == ScDocShell::GetWebQueryFilterName() || aFilterString == ScDocShell::GetHtmlFilterName() )
 189     {
 190         // HTML import.
 191         ::std::auto_ptr<AbstractScTextImportOptionsDlg> pDlg(
 192             pFact->CreateScTextImportOptionsDlg(NULL, RID_SCDLG_TEXT_IMPORT_OPTIONS));
 193
 194         if (pDlg->Execute() == RET_OK)
 195         {
 196             LanguageType eLang = pDlg->GetLanguageType();
 197             OUStringBuffer aBuf;
 198
 199             aBuf.append(String::CreateFromInt32(static_cast<sal_Int32>(eLang)));
 200             aBuf.append(sal_Unicode(' '));
 201             aBuf.append(pDlg->IsDateConversionSet() ? sal_Unicode('1') : sal_Unicode('0'));
 202             aFilterOptions = aBuf.makeStringAndClear();
 203             nRet = ui::dialogs::ExecutableDialogResults::OK;
 204         }
 205     }
 206     else
 207     {
 208         sal_Bool bMultiByte = sal_True;
 209         sal_Bool bDBEnc     = sal_False;
 210         sal_Bool bAscii     = sal_False;
 211
 212         sal_Unicode cStrDel = '"';
 213         sal_Unicode cAsciiDel = ';';
 214         rtl_TextEncoding eEncoding = RTL_TEXTENCODING_DONTKNOW;
 215
 216         String aTitle;
 217
 218         if ( aFilterString == ScDocShell::GetAsciiFilterName() )
 219         {
 220             //  ascii export (import is handled above)
 221
 222             INetURLObject aURL( aFileName );
 223             String aExt(aURL.getExtension());
 224             if (aExt.EqualsIgnoreCaseAscii("CSV"))
 225                 cAsciiDel = ',';
 226             else
 227                 cAsciiDel = '\t';
 228
 229             aTitle = ScGlobal::GetRscString( STR_EXPORT_ASCII );
 230             bAscii = sal_True;
 231         }
 232         else if ( aFilterString == ScDocShell::GetLotusFilterName() )
 233         {
 234             //  lotus is only imported
 235             DBG_ASSERT( !bExport, "Filter Options for Lotus Export is not implemented" );
 236
 237             aTitle = ScGlobal::GetRscString( STR_IMPORT_LOTUS );
 238             eEncoding = RTL_TEXTENCODING_IBM_437;
 239         }
 240         else if ( aFilterString == ScDocShell::GetDBaseFilterName() )
 241         {
 242             if ( bExport )
 243             {
 244                 //      dBase export
 245                 aTitle = ScGlobal::GetRscString( STR_EXPORT_DBF );
 246             }
 247             else
 248             {
 249                 //      dBase import
 250                 aTitle = ScGlobal::GetRscString( STR_IMPORT_DBF );
 251             }
 252             // common for dBase import/export
 253             eEncoding = RTL_TEXTENCODING_IBM_850;
 254             bDBEnc = sal_True;
 255         }
 256         else if ( aFilterString == ScDocShell::GetDifFilterName() )
 257         {
 258             if ( bExport )
 259             {
 260                 //      DIF export
 261                 aTitle = ScGlobal::GetRscString( STR_EXPORT_DIF );
 262             }
 263             else
 264             {
 265                 //      DIF import
 266                 aTitle = ScGlobal::GetRscString( STR_IMPORT_DIF );
 267             }
 268             // common for DIF import/export
 269             eEncoding = RTL_TEXTENCODING_MS_1252;
 270         }
 271
 272         ScImportOptions aOptions( cAsciiDel, cStrDel, eEncoding);
 273 //CHINA001              ScImportOptionsDlg* pDlg = new ScImportOptionsDlg( NULL, bAscii,
 274 //CHINA001              &aOptions, &aTitle, bMultiByte, bDBEnc,
 275 //CHINA001              !bExport );
 276 //CHINA001
 277
 278         AbstractScImportOptionsDlg* pDlg = pFact->CreateScImportOptionsDlg( NULL, RID_SCDLG_IMPORTOPT,
 279                                                                             bAscii, &aOptions, &aTitle, bMultiByte, bDBEnc,
 280                                                                             !bExport);
 281         DBG_ASSERT(pDlg, "Dialog create fail!");//CHINA001
 282         if ( pDlg->Execute() == RET_OK )
 283         {
 284             pDlg->GetImportOptions( aOptions );
 285             if ( bAscii )
 286                 aFilterOptions = aOptions.BuildString();
 287             else
 288                 aFilterOptions = aOptions.aStrFont;
 289             nRet = ui::dialogs::ExecutableDialogResults::OK;
 290         }
 291         delete pDlg;
 292     }
 293
 294     xInputStream.clear();       // don't hold the stream longer than necessary
 295
 296     return nRet;
 297 }
 298
 299 // XImporter
 300
 301 void SAL_CALL ScFilterOptionsObj::setTargetDocument( const uno::Reference<lang::XComponent>& /* xDoc */ )
 302                             throw(lang::IllegalArgumentException, uno::RuntimeException)
 303 {
 304     bExport = sal_False;
 305 }
 306
 307 // XExporter
 308
 309 void SAL_CALL ScFilterOptionsObj::setSourceDocument( const uno::Reference<lang::XComponent>& /* xDoc */ )
 310                             throw(lang::IllegalArgumentException, uno::RuntimeException)
 311 {
 312     bExport = sal_True;
 313 }
 314