/* -*- 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 #include #include #include #include #include #include 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 bIncludeBOM = false; 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(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"; if (nTokenCount >= 14) bIncludeBOM = 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 "," + OUString::boolean(bIncludeBOM) ; // same as "Include BOM" 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: */