diff options
Diffstat (limited to 'sc/source/ui/dbgui/imoptdlg.cxx')
| -rw-r--r-- | sc/source/ui/dbgui/imoptdlg.cxx | 135 |
1 files changed, 135 insertions, 0 deletions
diff --git a/sc/source/ui/dbgui/imoptdlg.cxx b/sc/source/ui/dbgui/imoptdlg.cxx new file mode 100644 index 000000000..b285c6ae9 --- /dev/null +++ b/sc/source/ui/dbgui/imoptdlg.cxx @@ -0,0 +1,135 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + */ + +#include <imoptdlg.hxx> +#include <asciiopt.hxx> +#include <comphelper/string.hxx> +#include <unotools/charclass.hxx> +#include <osl/thread.h> +#include <o3tl/string_view.hxx> +#include <global.hxx> + +const char pStrFix[] = "FIX"; + +// The option string can no longer contain a semicolon (because of pick list), +// therefore, starting with version 336 comma instead + +ScImportOptions::ScImportOptions( std::u16string_view rStr ) +{ + // Use the same string format as ScAsciiOptions, + // because the import options string is passed here when a CSV file is loaded and saved again. + // The old format is still supported because it might be used in macros. + + bFixedWidth = false; + nFieldSepCode = 0; + nTextSepCode = 0; + eCharSet = RTL_TEXTENCODING_DONTKNOW; + bSaveAsShown = true; // "true" if not in string (after CSV import) + bQuoteAllText = false; + bSaveNumberAsSuch = true; + bSaveFormulas = false; + bRemoveSpace = false; + nSheetToExport = 0; + bEvaluateFormulas = true; // true if not present at all, for compatibility + sal_Int32 nTokenCount = comphelper::string::getTokenCount(rStr, ','); + if ( nTokenCount < 3 ) + return; + + sal_Int32 nIdx{ 0 }; + // first 3 tokens: common + OUString aToken( o3tl::getToken(rStr, 0, ',', nIdx ) ); + if( aToken.equalsIgnoreAsciiCase( pStrFix ) ) + bFixedWidth = true; + else + nFieldSepCode = ScAsciiOptions::GetWeightedFieldSep( aToken, true); + nTextSepCode = static_cast<sal_Unicode>(o3tl::toInt32(o3tl::getToken(rStr, 0, ',', nIdx))); + aStrFont = o3tl::getToken(rStr, 0, ',', nIdx); + eCharSet = ScGlobal::GetCharsetValue(aStrFont); + + if ( nTokenCount == 4 ) + { + // compatibility with old options string: "Save as shown" as 4th token, numeric + bSaveAsShown = o3tl::toInt32(o3tl::getToken(rStr, 0, ',', nIdx)) != 0; + bQuoteAllText = true; // use old default then + } + else + { + // look at the same positions as in ScAsciiOptions + if ( nTokenCount >= 7 ) + bQuoteAllText = o3tl::getToken(rStr, 3, ',', nIdx) == u"true"; // 7th token + if ( nTokenCount >= 8 ) + bSaveNumberAsSuch = o3tl::getToken(rStr, 0, ',', nIdx) == u"true"; + if ( nTokenCount >= 9 ) + bSaveAsShown = o3tl::getToken(rStr, 0, ',', nIdx) == u"true"; + if ( nTokenCount >= 10 ) + bSaveFormulas = o3tl::getToken(rStr, 0, ',', nIdx) == u"true"; + if ( nTokenCount >= 11 ) + bRemoveSpace = o3tl::getToken(rStr, 0, ',', nIdx) == u"true"; + if ( nTokenCount >= 12 ) + { + const OUString aTok(o3tl::getToken(rStr,0, ',', nIdx)); + if (aTok == "-1") + nSheetToExport = -1; // all + else if (aTok.isEmpty() || CharClass::isAsciiNumeric(aTok)) + nSheetToExport = aTok.toInt32(); + else + nSheetToExport = -23; // invalid, force error + } + if ( nTokenCount >= 13 ) + // If present, defaults to "false". + bEvaluateFormulas = o3tl::getToken(rStr, 0, ',', nIdx) == u"true"; + } +} + +OUString ScImportOptions::BuildString() const +{ + OUString aResult; + + if( bFixedWidth ) + aResult += pStrFix; + else + aResult += OUString::number(nFieldSepCode); + aResult += "," + OUString::number(nTextSepCode) + "," + aStrFont + + // use the same string format as ScAsciiOptions: + ",1,,0," + // first row, no column info, default language + OUString::boolean( bQuoteAllText ) + // same as "quoted field as text" in ScAsciiOptions + "," + + OUString::boolean( bSaveNumberAsSuch ) + // "save number as such": not in ScAsciiOptions + "," + + OUString::boolean( bSaveAsShown ) + // "save as shown": not in ScAsciiOptions + "," + + OUString::boolean( bSaveFormulas ) + // "save formulas": not in ScAsciiOptions + "," + + OUString::boolean( bRemoveSpace ) + // same as "Remove space" in ScAsciiOptions + "," + + OUString::number(nSheetToExport) + // Only available for command line --convert-to + "," + + OUString::boolean( bEvaluateFormulas ) ; // same as "Evaluate formulas" in ScAsciiOptions + + return aResult; +} + +void ScImportOptions::SetTextEncoding( rtl_TextEncoding nEnc ) +{ + eCharSet = (nEnc == RTL_TEXTENCODING_DONTKNOW ? + osl_getThreadTextEncoding() : nEnc); + aStrFont = ScGlobal::GetCharsetString( nEnc ); +} + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |