[Libreoffice-commits] core.git: sc/source

Julien Nabet (via logerrit) logerrit at kemper.freedesktop.org
Mon Oct 5 20:48:52 UTC 2020


 sc/source/filter/excel/xecontent.cxx |    2 ++
 1 file changed, 2 insertions(+)

New commits:
commit f90500754fac014638214b5e061832b2c518aab6
Author:     Julien Nabet <serval2412 at yahoo.fr>
AuthorDate: Sun Oct 4 13:54:00 2020 +0200
Commit:     Eike Rathke <erack at redhat.com>
CommitDate: Mon Oct 5 22:48:07 2020 +0200

    Related tdf#137167: reference Excel pb on limitation for data validity formula
    
    Change-Id: I6910b761dc99c7a58c7fc1f84c4606ad8dbd729c
    Reviewed-on: https://gerrit.libreoffice.org/c/core/+/103913
    Tested-by: Jenkins
    Reviewed-by: Eike Rathke <erack at redhat.com>

diff --git a/sc/source/filter/excel/xecontent.cxx b/sc/source/filter/excel/xecontent.cxx
index d73683deadd1..eaa14d7e580e 100644
--- a/sc/source/filter/excel/xecontent.cxx
+++ b/sc/source/filter/excel/xecontent.cxx
@@ -1750,6 +1750,8 @@ XclExpDV::XclExpDV( const XclExpRoot& rRoot, sal_uLong nScHandle ) :
                     ::set_flag( mnFlags, EXC_DV_STRINGLIST );
 
                     // maximum length allowed in Excel is 255 characters, and don't end with an empty token
+                    // It should be 8192 but Excel doesn't accept it for unknown reason
+                    // See also https://bugs.documentfoundation.org/show_bug.cgi?id=137167#c2 for more details
                     sal_uInt32 nLen = sFormulaBuf.getLength();
                     if( nLen > 256 )  // 255 + beginning quote mark
                     {


More information about the Libreoffice-commits mailing list