commit 8c1892cd80a5095b38e88d558f653b27d93b074c
author Czeber László Ádám <czeber.laszloadam@nisz.hu> Fri May 26 10:14:11 2023 +0200
committer László Németh <nemeth@numbertext.org> Tue May 30 15:37:37 2023 +0200
tree 25485ee47f63f6abcc7a45efd5db09d9abfe6a63
parent 20db76c08f870f1f1b4f890d93c0597e2bd36a0a

tdf#152037 XLSX import: fix false alarm data validation error

Fix validation error on valid input by adding missing
SimplifyCompiledFormula() to the implementation of
setFormula1() and setFormula2() of XSheetCondition UNO API,
which used by the XLSX input filter.

Change-Id: I8389227eb5a609c29e8d466cf62420bae36f7927
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/152295
Tested-by: László Németh <nemeth@numbertext.org>
Reviewed-by: László Németh <nemeth@numbertext.org>

sc/source/core/data/conditio.cxx

diff --git a/sc/source/core/data/conditio.cxx b/sc/source/core/data/conditio.cxx
index 1979d8a..b70f957 100644
--- a/sc/source/core/data/conditio.cxx
+++ b/sc/source/core/data/conditio.cxx
@@ -478,6 +478,7 @@ void ScConditionEntry::SetFormula1( const ScTokenArray& rArray )
    if( rArray.GetLen() > 0 )
    {
        pFormula1.reset( new ScTokenArray( rArray ) );
        SimplifyCompiledFormula(pFormula1, nVal1, bIsStr1, aStrVal1);
        bRelRef1 = lcl_HasRelRef( mpDoc, pFormula1.get() );
    }

@@ -490,6 +491,7 @@ void ScConditionEntry::SetFormula2( const ScTokenArray& rArray )
    if( rArray.GetLen() > 0 )
    {
        pFormula2.reset( new ScTokenArray( rArray ) );
        SimplifyCompiledFormula(pFormula2, nVal2, bIsStr2, aStrVal2);
        bRelRef2 = lcl_HasRelRef( mpDoc, pFormula2.get() );
    }