sc/source/core/tool/interpr1.cxx | 14 +++++++++++++-
1 file changed, 13 insertions(+), 1 deletion(-)
New commits:
commit 0d6f974b97597744119db9dc3d193aeeb8f9d3fa
Author: Eike Rathke <er...@redhat.com>
Date: Fri Nov 11 22:32:42 2016 +0100
Resolves: tdf#93415 use proper sheet separator in ADDRESS A1 notation
So that it matches what INDIRECT can digest in the current
configuration, as that is the primary use case.
The actual separator used depends on "Reference syntax for string
reference" and "Formula syntax" configured in Tools Options.
Change-Id: Iff91be7afdb9601a87b547dd3a7d3f4d994caf5d
diff --git a/sc/source/core/tool/interpr1.cxx b/sc/source/core/tool/interpr1.cxx
index c3d5c55..9a02b62 100644
--- a/sc/source/core/tool/interpr1.cxx
+++ b/sc/source/core/tool/interpr1.cxx
@@ -7365,6 +7365,17 @@ void ScInterpreter::ScAddressFunc()
FormulaGrammar::AddressConvention eConv = FormulaGrammar::CONV_OOO;
// default
if( nParamCount >= 4 && 0.0 == ::rtl::math::approxFloor(
GetDoubleWithDefault( 1.0)))
eConv = FormulaGrammar::CONV_XL_R1C1;
+ else
+ {
+ // If A1 syntax is requested then the actual sheet separator and format
+ // convention depends on the syntax configured for INDIRECT to match
+ // that, and if it is unspecified then the document's address syntax.
+ FormulaGrammar::AddressConvention eForceConv =
maCalcConfig.meStringRefAddressSyntax;
+ if (eForceConv == FormulaGrammar::CONV_UNSPECIFIED)
+ eForceConv = pDok->GetAddressConvention();
+ if (eForceConv == FormulaGrammar::CONV_XL_A1 || eForceConv ==
FormulaGrammar::CONV_XL_R1C1)
+ eConv = FormulaGrammar::CONV_XL_A1; // for anything Excel use
Excel A1
+ }
ScRefFlags nFlags = ScRefFlags::COL_ABS | ScRefFlags::ROW_ABS; //
default
if( nParamCount >= 3 )
@@ -7433,7 +7444,8 @@ void ScInterpreter::ScAddressFunc()
ScCompiler::CheckTabQuotes( sTabStr, eConv);
if (!aDoc.isEmpty())
sTabStr = aDoc + sTabStr;
- sTabStr += eConv == FormulaGrammar::CONV_XL_R1C1 ? OUString("!") :
OUString(".");
+ sTabStr += (eConv == FormulaGrammar::CONV_XL_R1C1 || eConv ==
FormulaGrammar::CONV_XL_A1) ?
+ OUString("!") : OUString(".");
sTabStr += aRefStr;
PushString( sTabStr );
}
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
