sc/source/core/tool/compiler.cxx | 2 ++ 1 file changed, 2 insertions(+)
New commits: commit a04fecfdd2de8db0244bbcef1bf7daca5b7a3e83 Author: Karthik Godha <[email protected]> AuthorDate: Mon Feb 16 12:04:54 2026 +0530 Commit: Michael Stahl <[email protected]> CommitDate: Mon Feb 16 13:00:33 2026 +0100 XLSX: Single cell R1C1 address in defined name R1C1 style single cell reference is not handled in SanitizeDefinedName bug-document: forum-mso-en4-31668.xls Change-Id: I53ca52065e45029b7293248eb6996736044fccde Reviewed-on: https://gerrit.libreoffice.org/c/core/+/199445 Tested-by: Jenkins CollaboraOffice <[email protected]> Reviewed-by: Michael Stahl <[email protected]> diff --git a/sc/source/core/tool/compiler.cxx b/sc/source/core/tool/compiler.cxx index af3c0df1b573..0f9bf9f7e0b5 100644 --- a/sc/source/core/tool/compiler.cxx +++ b/sc/source/core/tool/compiler.cxx @@ -5439,6 +5439,8 @@ OUString ScCompiler::SanitizeDefinedName(const OUString& rStr, const ScDocument& // Name can't be a valid cell reference if ((ScAddress().Parse(sName, rDoc, ::formula::FormulaGrammar::CONV_XL_A1) != ScRefFlags::ZERO) || (ScRange().Parse(sName, rDoc, ::formula::FormulaGrammar::CONV_XL_R1C1) + != ScRefFlags::ZERO) + || (ScAddress().Parse(sName, rDoc, ::formula::FormulaGrammar::CONV_XL_R1C1) != ScRefFlags::ZERO)) bValidName = false;
