diff options
Diffstat (limited to 'sc/source/filter/excel/xeextlst.cxx')
-rw-r--r-- | sc/source/filter/excel/xeextlst.cxx | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/sc/source/filter/excel/xeextlst.cxx b/sc/source/filter/excel/xeextlst.cxx index a1732197501e..610f25a1d894 100644 --- a/sc/source/filter/excel/xeextlst.cxx +++ b/sc/source/filter/excel/xeextlst.cxx @@ -174,16 +174,16 @@ OString GetFixedFormula(ScConditionMode eMode, const ScAddress& rAddress, const OString aPos = aBuffer.makeStringAndClear(); switch (eMode) { - case ScConditionMode::BeginsWith: - return OString("LEFT(" + aPos + ",LEN(" + rText + "))=\"" + rText + "\""); - case ScConditionMode::EndsWith: - return OString("RIGHT(" + aPos + ",LEN(" + rText + "))=\"" + rText + "\""); - case ScConditionMode::ContainsText: - return OString("NOT(ISERROR(SEARCH(" + rText + "," + aPos + ")))"); - case ScConditionMode::NotContainsText: - return OString("ISERROR(SEARCH(" + rText + "," + aPos + "))"); - default: - break; + case ScConditionMode::BeginsWith: + return OString("LEFT(" + aPos + ",LEN(" + rText + "))=" + rText); + case ScConditionMode::EndsWith: + return OString("RIGHT(" + aPos + ",LEN(" + rText + "))=" + rText); + case ScConditionMode::ContainsText: + return OString(OString::Concat("NOT(ISERROR(SEARCH(") + rText + "," + aPos + ")))"); + case ScConditionMode::NotContainsText: + return OString(OString::Concat("ISERROR(SEARCH(") + rText + "," + aPos + "))"); + default: + break; } return ""; |