summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sc/source/core/tool/formulaopt.cxx4
1 files changed, 4 insertions, 0 deletions
diff --git a/sc/source/core/tool/formulaopt.cxx b/sc/source/core/tool/formulaopt.cxx
index 7bb264bace36..166429f9ad09 100644
--- a/sc/source/core/tool/formulaopt.cxx
+++ b/sc/source/core/tool/formulaopt.cxx
@@ -365,6 +365,9 @@ void ScFormulaCfg::UpdateFromProperties( const Sequence<OUString>& aNames )
case 2: // Excel R1C1
eConv = formula::FormulaGrammar::CONV_XL_R1C1;
break;
+ case 3: // Calc A1 | Excel A1
+ eConv = formula::FormulaGrammar::CONV_A1_XL_A1;
+ break;
default:
;
}
@@ -548,6 +551,7 @@ void ScFormulaCfg::ImplCommit()
case ::formula::FormulaGrammar::CONV_OOO: nVal = 0; break;
case ::formula::FormulaGrammar::CONV_XL_A1: nVal = 1; break;
case ::formula::FormulaGrammar::CONV_XL_R1C1: nVal = 2; break;
+ case ::formula::FormulaGrammar::CONV_A1_XL_A1: nVal = 3; break;
default: break;
}
pValues[nProp] <<= nVal;