https://bugs.documentfoundation.org/show_bug.cgi?id=152723
--- Comment #7 from Mike Kaganski <[email protected]> --- The issue is inside LibreOffice, because: 1. libnumbertext language data [1] has a distinctive feature for Spanish (choose "es" in "Load" selector on that page, and examine the "regex" data in '# decimals' section). For 'de', for example, both '.' and ',' are handled together, showing 'Komma'; but for 'es', they are handled separately, showing 'punto' and 'coma', respectively. 2. NUMBERTEXT function from extension takes the number formatted using the cell locale, which gives the correct separator, resulting in correct output. 3. In internal case, it seems, the number is formatted using the default formatter, and relies on the libnumbertext library to process decimal point. But here, as we see, it fails. Two options: 1. Split 'es' into 'es-Country1', 'es-Country2', etc., to allow each variant have own unified handling of both dot and comma. This should be in libnumbertext, but is not desirable IMO, because it would produce mostly duplicating data, put additional load on that project, which doesn't enjoy much volunteer attention. 2. In LibreOffice, change the code that passes the number string to libnumbertext, and at least replace the dot with the current locale decimal separator. This is much easier, and IMO is superior solution. [1] https://numbertext.github.io/Soros.html -- You are receiving this mail because: You are the assignee for the bug.
