https://bugs.documentfoundation.org/show_bug.cgi?id=72039
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |WORKSFORME --- Comment #13 from Stéphane Guillou (stragu) <[email protected]> --- (In reply to Stéphane Guillou (stragu) from comment #12) > Created attachment 184622 [details] > Test document updated with results of LO 7.4 on Ubuntu > > Still the case, in 7.4.4.2 and beyond: I take that back. Testing again from a new document, trying to reproduce Harald's example, I get the same percent formatting for both English (USA) and German (Germany). Steps: 1. Open Writer 2. Tools > Options > Language Settings > Formats > Local setting: set to English (USA) (and make sure the decimal separator is the same as locale setting) 3. Tools > Options > LibreOffice Writer > Table > Input in Tables: turn "Number recognition" on (and keep "Number format recognition" off) 4. Insert a table with 11 rows and 2 columns 5. Input these values in a column: 0.1 0.12 0.123 0.1234 1.1 1.12 1.123 1.1234 0,1 0,123 0,1234 Most number should be recognised automatically, and 2 decimal places displayed only. "0,123" is recognised as 123, because of the thousands separator. 6. Copy whole column into second column 7. Select the second column, got to Table > Number format. It should be "Text" by default. Change it to Percent, using the default -12.95% Result: 10.00% 12.00% 12.30% 12.34% 110.00% 112.00% 112.30% 112.34% 0,1 12300.00% 0,1234 Repeat the whole thing for the German (Germany) locale, in a new table, with the following number sequence so the results are ordered in the same way as English: 0,1 0,12 0,123 0,1234 1,1 1,12 1,123 1,1234 0.1 0.123 0.1234 Result is the same: 10,00 % 12,00 % 12,30 % 12,34 % 110,00 % 112,00 % 112,30 % 112,34 % 0.1 12300,00 % 0.1234 Version: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d04c197b436094844abfa5fb7c12e095165d2bca CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: de-DE (en_AU.UTF-8); UI: en-US Calc: threaded Resolved as "Works for me", but please let me know if I am missing something in my steps. -- You are receiving this mail because: You are the assignee for the bug.
