sc/source/ui/dbgui/scuiimoptdlg.cxx

   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 #undef SC_DLLIMPLEMENTATION
  21
  22 #include <scuiimoptdlg.hxx>
  23 #include <scresid.hxx>
  24 #include <strings.hrc>
  25 #include <strings.hxx>
  26 #include <officecfg/Office/Calc.hxx>
  27 #include <osl/thread.h>
  28 #include <rtl/tencinfo.h>
  29 #include <imoptdlg.hxx>
  30 #include <svx/txencbox.hxx>
  31 #include <o3tl/string_view.hxx>
  32 #include <utility>
  33
  34 // ScDelimiterTable
  35
  36 class ScDelimiterTable
  37 {
  38 public:
  39     explicit ScDelimiterTable( OUString aDelTab )
  40             :   theDelTab (std::move( aDelTab )),
  41                 nDelIdx   ( 0 )
  42             {}
  43
  44     sal_uInt16  GetCode( std::u16string_view rDelimiter ) const;
  45     OUString  GetDelimiter( sal_Unicode nCode ) const;
  46
  47     OUString  FirstDel()  { nDelIdx = 0; return theDelTab.getToken( 0, cSep, nDelIdx ); }
  48     OUString  NextDel()   { return theDelTab.getToken( 1, cSep, nDelIdx ); }
  49
  50 private:
  51     const OUString      theDelTab;
  52     static constexpr sal_Unicode cSep {'\t'};
  53     sal_Int32           nDelIdx;
  54 };
  55
  56 sal_uInt16 ScDelimiterTable::GetCode( std::u16string_view rDel ) const
  57 {
  58     if (!theDelTab.isEmpty())
  59     {
  60         sal_Int32 nIdx {0};
  61
  62         // Check even tokens: start from 0 and then skip 1 token at each iteration
  63         if (rDel != o3tl::getToken(theDelTab, 0, cSep, nIdx ))
  64             while (nIdx>0 && rDel != o3tl::getToken(theDelTab, 1, cSep, nIdx ));
  65
  66         if (nIdx>0)
  67             return static_cast<sal_Unicode>(o3tl::toInt32(o3tl::getToken(theDelTab, 0, cSep, nIdx )));
  68     }
  69
  70     return 0;
  71 }
  72
  73 OUString ScDelimiterTable::GetDelimiter( sal_Unicode nCode ) const
  74 {
  75     if (!theDelTab.isEmpty())
  76     {
  77         sal_Int32 nIdx {0};
  78         // Check odd tokens: start from 1 and then skip 1 token at each iteration
  79         do
  80         {
  81             sal_Int32 nPrevIdx {nIdx};
  82             if (nCode == static_cast<sal_Unicode>(o3tl::toInt32(o3tl::getToken(theDelTab, 1, cSep, nIdx ))))
  83                 return theDelTab.getToken( 0, cSep, nPrevIdx );
  84         }
  85         while (nIdx>0);
  86     }
  87
  88     return OUString();
  89 }
  90
  91 void ScImportOptionsDlg::FillFromTextEncodingTable(bool bExcludeImportSubsets, sal_uInt32 nExcludeInfoFlags)
  92 {
  93     if (m_bIsAsciiImport)
  94         m_xLbCharset->FillFromTextEncodingTable(bExcludeImportSubsets, nExcludeInfoFlags);
  95     else
  96         m_xTvCharset->FillFromTextEncodingTable(bExcludeImportSubsets, nExcludeInfoFlags);
  97 }
  98
  99 void ScImportOptionsDlg::FillFromDbTextEncodingMap(bool bExcludeImportSubsets, sal_uInt32 nExcludeInfoFlags)
 100 {
 101     if (m_bIsAsciiImport)
 102         m_xLbCharset->FillFromDbTextEncodingMap(bExcludeImportSubsets, nExcludeInfoFlags);
 103     else
 104         m_xTvCharset->FillFromDbTextEncodingMap(bExcludeImportSubsets, nExcludeInfoFlags);
 105 }
 106
 107 // ScImportOptionsDlg
 108 ScImportOptionsDlg::ScImportOptionsDlg(weld::Window* pParent, bool bAscii,
 109                                        const ScImportOptions*  pOptions,
 110                                        const OUString* pStrTitle,
 111                                        bool bMultiByte, bool bOnlyDbtoolsEncodings,
 112                                        bool bImport)
 113     : GenericDialogController(pParent, "modules/scalc/ui/imoptdialog.ui", "ImOptDialog")
 114     , m_bIsAsciiImport(bAscii)
 115     , m_xFieldFrame(m_xBuilder->weld_frame("fieldframe"))
 116     , m_xFtCharset(m_xBuilder->weld_label("charsetft"))
 117     , m_xEncGrid(m_xBuilder->weld_widget("grid2"))
 118     , m_xFtFieldSep(m_xBuilder->weld_label("fieldft"))
 119     , m_xEdFieldSep(m_xBuilder->weld_combo_box("field"))
 120     , m_xFtTextSep(m_xBuilder->weld_label("textft"))
 121     , m_xEdTextSep(m_xBuilder->weld_combo_box("text"))
 122     , m_xCbShown(m_xBuilder->weld_check_button("asshown"))
 123     , m_xCbFormulas(m_xBuilder->weld_check_button("formulas"))
 124     , m_xCbQuoteAll(m_xBuilder->weld_check_button("quoteall"))
 125     , m_xCbFixed(m_xBuilder->weld_check_button("fixedwidth"))
 126     , m_xLbCharset(new SvxTextEncodingBox(m_xBuilder->weld_combo_box("charsetdropdown")))
 127     , m_xTvCharset(new SvxTextEncodingTreeView(m_xBuilder->weld_tree_view("charsetlist")))
 128 {
 129     if (bAscii)
 130     {
 131         m_xDialog->set_help_id(m_xDialog->get_help_id() + "?config=NonTextImport");
 132         m_xLbCharset->show();
 133         m_xTvCharset->hide();
 134     }
 135     else
 136     {
 137         m_xTvCharset->set_size_request(-1, m_xTvCharset->get_height_rows(6));
 138         m_xEncGrid->set_vexpand(true);
 139         m_xLbCharset->hide();
 140         m_xTvCharset->show();
 141     }
 142
 143     OUString sFieldSep(SCSTR_FIELDSEP);
 144     sFieldSep = sFieldSep.replaceFirst( "%TAB",   ScResId(SCSTR_FIELDSEP_TAB) );
 145     sFieldSep = sFieldSep.replaceFirst( "%SPACE", ScResId(SCSTR_FIELDSEP_SPACE) );
 146
 147     // not possible in the Ctor initializer (MSC cannot do that):
 148     pFieldSepTab.reset( new ScDelimiterTable(sFieldSep) );
 149     pTextSepTab.reset( new ScDelimiterTable(SCSTR_TEXTSEP) );
 150
 151     OUString aStr = pFieldSepTab->FirstDel();
 152
 153     while (!aStr.isEmpty())
 154     {
 155         m_xEdFieldSep->append_text(aStr);
 156         aStr = pFieldSepTab->NextDel();
 157     }
 158
 159     aStr = pTextSepTab->FirstDel();
 160
 161     while (!aStr.isEmpty())
 162     {
 163         m_xEdTextSep->append_text(aStr);
 164         aStr = pTextSepTab->NextDel();
 165     }
 166
 167     m_xEdFieldSep->set_active(0);
 168     m_xEdTextSep->set_active(0);
 169
 170     if ( bOnlyDbtoolsEncodings )
 171     {
 172         // Even dBase export allows multibyte now
 173         if ( bMultiByte )
 174             FillFromDbTextEncodingMap( bImport );
 175         else
 176             FillFromDbTextEncodingMap( bImport, RTL_TEXTENCODING_INFO_MULTIBYTE );
 177     }
 178     else if ( !bAscii )
 179     {   //!TODO: Unicode would need work in each filter
 180         if ( bMultiByte )
 181             FillFromTextEncodingTable( bImport, RTL_TEXTENCODING_INFO_UNICODE );
 182         else
 183             FillFromTextEncodingTable( bImport, RTL_TEXTENCODING_INFO_UNICODE |
 184                 RTL_TEXTENCODING_INFO_MULTIBYTE );
 185     }
 186     else
 187     {
 188         if ( pOptions )
 189         {
 190             sal_Unicode nCode = pOptions->nFieldSepCode;
 191             aStr  = pFieldSepTab->GetDelimiter( nCode );
 192
 193             if ( aStr.isEmpty() )
 194                 m_xEdFieldSep->set_entry_text(OUString(nCode));
 195             else
 196                 m_xEdFieldSep->set_entry_text(aStr);
 197
 198             nCode = pOptions->nTextSepCode;
 199             aStr  = pTextSepTab->GetDelimiter( nCode );
 200
 201             if ( aStr.isEmpty() )
 202                 m_xEdTextSep->set_entry_text(OUString(nCode));
 203             else
 204                 m_xEdTextSep->set_entry_text(aStr);
 205         }
 206         // all encodings allowed, even Unicode
 207         FillFromTextEncodingTable( bImport );
 208     }
 209
 210     if( bAscii )
 211     {
 212         sal_Int32 nCharSet = officecfg::Office::Calc::Dialogs::CSVExport::CharSet::get();
 213         OUString strFieldSeparator = officecfg::Office::Calc::Dialogs::CSVExport::FieldSeparator::get();
 214         OUString strTextSeparator = officecfg::Office::Calc::Dialogs::CSVExport::TextSeparator::get();
 215         bool bSaveTrueCellContent = officecfg::Office::Calc::Dialogs::CSVExport::SaveTrueCellContent::get();
 216         bool bSaveCellFormulas = officecfg::Office::Calc::Dialogs::CSVExport::SaveCellFormulas::get();
 217         bool bQuoteAllTextCells = officecfg::Office::Calc::Dialogs::CSVExport::QuoteAllTextCells::get();
 218         bool bFixedWidth = officecfg::Office::Calc::Dialogs::CSVExport::FixedWidth::get();
 219
 220         m_xCbFixed->show();
 221         m_xCbFixed->connect_toggled(LINK(this, ScImportOptionsDlg, FixedWidthHdl));
 222         m_xCbFixed->set_active( bFixedWidth );
 223         FixedWidthHdl(*m_xCbFixed);
 224         m_xCbShown->show();
 225         m_xCbShown->set_active( bSaveTrueCellContent );
 226         m_xCbQuoteAll->show();
 227         m_xCbQuoteAll->set_active( bQuoteAllTextCells );
 228         m_xCbFormulas->show();
 229         // default option for "save formulas" no longer taken from view shell but from persisted dialog settings
 230         m_xCbFormulas->set_active( bSaveCellFormulas );
 231         // if no charset, text separator or field separator exist, keep the values from dialog initialization
 232         if (strFieldSeparator.getLength() > 0)
 233             m_xEdFieldSep->set_entry_text(strFieldSeparator);
 234         if (strTextSeparator.getLength() > 0)
 235             m_xEdTextSep->set_entry_text(strTextSeparator);
 236         if (nCharSet < 0 || nCharSet == RTL_TEXTENCODING_DONTKNOW )
 237             m_xLbCharset->SelectTextEncoding(pOptions ? pOptions->eCharSet : osl_getThreadTextEncoding());
 238         else
 239             m_xLbCharset->SelectTextEncoding(nCharSet);
 240     }
 241     else
 242     {
 243         m_xFieldFrame->set_label(m_xFtCharset->get_label());
 244         m_xFtFieldSep->hide();
 245         m_xFtTextSep->hide();
 246         m_xFtCharset->hide();
 247         m_xEdFieldSep->hide();
 248         m_xEdTextSep->hide();
 249         m_xCbFixed->hide();
 250         m_xCbShown->hide();
 251         m_xCbQuoteAll->hide();
 252         m_xCbFormulas->hide();
 253         m_xTvCharset->grab_focus();
 254         m_xTvCharset->connect_row_activated(LINK(this, ScImportOptionsDlg, DoubleClickHdl));
 255         m_xTvCharset->SelectTextEncoding(pOptions ? pOptions->eCharSet : osl_getThreadTextEncoding());
 256     }
 257
 258     // optional title:
 259     if (pStrTitle)
 260         m_xDialog->set_title(*pStrTitle);
 261 }
 262
 263 ScImportOptionsDlg::~ScImportOptionsDlg()
 264 {
 265 }
 266
 267 void ScImportOptionsDlg::GetImportOptions( ScImportOptions& rOptions ) const
 268 {
 269     auto nEncoding = m_bIsAsciiImport ? m_xLbCharset->GetSelectTextEncoding() : m_xTvCharset->GetSelectTextEncoding();
 270     rOptions.SetTextEncoding(nEncoding);
 271
 272     if (m_xCbFixed->get_visible())
 273     {
 274         rOptions.nFieldSepCode = GetCodeFromCombo( *m_xEdFieldSep );
 275         rOptions.nTextSepCode  = GetCodeFromCombo( *m_xEdTextSep );
 276         rOptions.bFixedWidth = m_xCbFixed->get_active();
 277         rOptions.bSaveAsShown = m_xCbShown->get_active();
 278         rOptions.bQuoteAllText = m_xCbQuoteAll->get_active();
 279         rOptions.bSaveFormulas = m_xCbFormulas->get_active();
 280     }
 281 }
 282
 283 sal_uInt16 ScImportOptionsDlg::GetCodeFromCombo(const weld::ComboBox& rEd) const
 284 {
 285     ScDelimiterTable* pTab;
 286     OUString  aStr( rEd.get_active_text() );
 287     sal_uInt16  nCode;
 288
 289     if (&rEd == m_xEdTextSep.get())
 290         pTab = pTextSepTab.get();
 291     else
 292         pTab = pFieldSepTab.get();
 293
 294     if ( aStr.isEmpty() )
 295     {
 296         nCode = 0;          // no separator
 297     }
 298     else
 299     {
 300         nCode = pTab->GetCode( aStr );
 301
 302         if ( nCode == 0 )
 303             nCode = static_cast<sal_uInt16>(aStr[0]);
 304     }
 305
 306     return nCode;
 307 }
 308
 309 IMPL_LINK_NOARG(ScImportOptionsDlg, FixedWidthHdl, weld::Toggleable&, void)
 310 {
 311     bool bEnable = !m_xCbFixed->get_active();
 312     m_xFtFieldSep->set_sensitive( bEnable );
 313     m_xEdFieldSep->set_sensitive( bEnable );
 314     m_xFtTextSep->set_sensitive( bEnable );
 315     m_xEdTextSep->set_sensitive( bEnable );
 316     m_xCbShown->set_sensitive( bEnable );
 317     m_xCbQuoteAll->set_sensitive( bEnable );
 318 }
 319
 320 IMPL_LINK_NOARG(ScImportOptionsDlg, DoubleClickHdl, weld::TreeView&, bool)
 321 {
 322     m_xDialog->response(RET_OK);
 323     return true;
 324 }
 325
 326 void ScImportOptionsDlg::SaveImportOptions() const
 327 {
 328     std::shared_ptr < comphelper::ConfigurationChanges > batch(comphelper::ConfigurationChanges::create());
 329     auto nEncoding = m_bIsAsciiImport ? m_xLbCharset->GetSelectTextEncoding() : m_xTvCharset->GetSelectTextEncoding();
 330     officecfg::Office::Calc::Dialogs::CSVExport::CharSet::set(nEncoding, batch);
 331     officecfg::Office::Calc::Dialogs::CSVExport::FieldSeparator::set(m_xEdFieldSep->get_active_text(), batch);
 332     officecfg::Office::Calc::Dialogs::CSVExport::TextSeparator::set(m_xEdTextSep->get_active_text(), batch);
 333     officecfg::Office::Calc::Dialogs::CSVExport::FixedWidth::set(m_xCbFixed->get_active(), batch);
 334     officecfg::Office::Calc::Dialogs::CSVExport::SaveCellFormulas::set(m_xCbFormulas->get_active(), batch);
 335     officecfg::Office::Calc::Dialogs::CSVExport::SaveTrueCellContent::set(m_xCbShown->get_active(), batch);
 336     officecfg::Office::Calc::Dialogs::CSVExport::QuoteAllTextCells::set(m_xCbQuoteAll->get_active(), batch);
 337     batch->commit();
 338 }
 339
 340 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */