1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 24 // MARKER(update_precomp.py): autogen include statement, do not remove 25 #include "precompiled_sc.hxx" 26 27 28 29 #include "imoptdlg.hxx" 30 #include "scresid.hxx" 31 #include "imoptdlg.hrc" 32 #include <rtl/tencinfo.h> 33 34 static const sal_Char pStrFix[] = "FIX"; 35 36 //------------------------------------------------------------------------ 37 // Der Options-String darf kein Semikolon mehr enthalten (wegen Pickliste) 38 // darum ab Version 336 Komma stattdessen 39 40 41 ScImportOptions::ScImportOptions( const String& rStr ) 42 { 43 // Use the same string format as ScAsciiOptions, 44 // because the import options string is passed here when a CSV file is loaded and saved again. 45 // The old format is still supported because it might be used in macros. 46 47 bFixedWidth = sal_False; 48 nFieldSepCode = 0; 49 nTextSepCode = 0; 50 eCharSet = RTL_TEXTENCODING_DONTKNOW; 51 bSaveAsShown = sal_True; // "true" if not in string (after CSV import) 52 bQuoteAllText = sal_False; 53 xub_StrLen nTokenCount = rStr.GetTokenCount(','); 54 if ( nTokenCount >= 3 ) 55 { 56 // first 3 tokens: common 57 String aToken( rStr.GetToken( 0, ',' ) ); 58 if( aToken.EqualsIgnoreCaseAscii( pStrFix ) ) 59 bFixedWidth = sal_True; 60 else 61 nFieldSepCode = (sal_Unicode) aToken.ToInt32(); 62 nTextSepCode = (sal_Unicode) rStr.GetToken(1,',').ToInt32(); 63 aStrFont = rStr.GetToken(2,','); 64 eCharSet = ScGlobal::GetCharsetValue(aStrFont); 65 66 if ( nTokenCount == 4 ) 67 { 68 // compatibility with old options string: "Save as shown" as 4th token, numeric 69 bSaveAsShown = (rStr.GetToken( 3, ',' ).ToInt32() ? sal_True : sal_False); 70 bQuoteAllText = sal_True; // use old default then 71 } 72 else 73 { 74 // look at the same positions as in ScAsciiOptions 75 if ( nTokenCount >= 7 ) 76 bQuoteAllText = rStr.GetToken(6, ',').EqualsAscii("true"); 77 if ( nTokenCount >= 9 ) 78 bSaveAsShown = rStr.GetToken(8, ',').EqualsAscii("true"); 79 } 80 } 81 } 82 83 //------------------------------------------------------------------------ 84 85 String ScImportOptions::BuildString() const 86 { 87 String aResult; 88 89 if( bFixedWidth ) 90 aResult.AppendAscii( pStrFix ); 91 else 92 aResult += String::CreateFromInt32(nFieldSepCode); 93 aResult += ','; 94 aResult += String::CreateFromInt32(nTextSepCode); 95 aResult += ','; 96 aResult += aStrFont; 97 // use the same string format as ScAsciiOptions: 98 aResult.AppendAscii( ",1,,0," ); // first row, no column info, default language 99 aResult.AppendAscii(bQuoteAllText ? "true" : "false"); // same as "quoted field as text" in ScAsciiOptions 100 aResult.AppendAscii( ",true," ); // "detect special numbers" 101 aResult.AppendAscii(bSaveAsShown ? "true" : "false"); // "save as shown": not in ScAsciiOptions 102 103 return aResult; 104 } 105 106 //------------------------------------------------------------------------ 107 108 void ScImportOptions::SetTextEncoding( rtl_TextEncoding nEnc ) 109 { 110 eCharSet = (nEnc == RTL_TEXTENCODING_DONTKNOW ? 111 gsl_getSystemTextEncoding() : nEnc); 112 aStrFont = ScGlobal::GetCharsetString( nEnc ); 113 } 114