## Steps to reproduce * user language : FR * create a new spreadsheet and edit it * in A1, type =SOMME(A2) * in A2, type =SUM(A3) ## Actual behaviour * the formula =SOMME(A2) returns #NAME? * the formula =SUM(A2) returns 0 ## Expected behaviour Because the user language is FR (french), * the formula =SOMME(A2) should return 0 * the formula =SUM(A2) should return #NAME? It's quite impossible for a not english native user to know the formula names in english and even to understand the existing formulas in a existing document. ## General server configuration **Operating system:** Linux 3.10.0-693.5.2.el7.x86_64 #1 SMP Fri Oct 20 20:32:50 UTC 2017 x86_64 **Webserver:** Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips mod_fcgid/2.3.9 PHP/7.1.11 (apache2handler) **Database:** mysql 5.5.56 **PHP version:** 7.1.11 Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, session, standard, apache2handler, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, iconv, intl, json, ldap, exif, mcrypt, mysqlnd, PDO, apcu, posix, shmop, SimpleXML, sockets, sqlite3, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlwriter, xsl, mysqli, pdo_mysql, pdo_sqlite, wddx, xmlreader, apc, smbclient, zip, Phar, libsmbclient, Zend OPcache **LibreOffice Online version:** Collabora Online 2.1.5 **Nextcloud version:** 12.0.4 - 12.0.4.3
Confirmed. It may not be trivial to fix, as the locale configuration used in core is complex. LOOLWSD master.. (git hash: 9c6e1cc4) LOKit LibreOfficeDev 6.1.0.0.alpha0 (git hash: a0e136d)
Hello It seems to be fixed in Collabora Online 4.0.4. Is it normal ? :-) Philippe
Thinking back, it probably got fixed by this commit, thanks to Ashod Nakashian: https://cgit.freedesktop.org/libreoffice/core/commit/?id=d92715c797c290e16b04ebc957d908288f997439 Which got into master as the following: https://cgit.freedesktop.org/libreoffice/core/commit/?id=5ede6b3bca9d174c77d16a1bc182ab83eb963398 We can certainly consider it fixed.