Created attachment 173959 [details] correction proposal for bad French long number writing Hi, Version: 7.1.5.2 / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 2; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded When using table in writer and adding long number (more than 3 digits), it is not possible to adjust them following the local case : For example, in French : 1000 becomes 1 000 10000 becomes 10 000 The correction is well proposed and when you get it, the change of case (by clicking on an other case) removes the correction. It exists the same problem with dot number (0.001, more than 3 digits of course). I add a screen copy for indicating that the correction is really well proposed, but I can't formalized all the steps without creating a movie :) Thanks, PK
In order to insert 1 000 000, you have to write: 1 Ctrl+Shift+Space 000 Ctrl+Shift+Space 000 This way the numbers elements stays toghether and forma single element and is formatted as you wanted.
Thanks for your (very) fast answer. First, your proposal runs with the natural integer (but I have done it few times before the tables accepts the figures : the auto-correction removes again... And once, it has be accepted! But for the real (the 0.00x1 format), this solution doesn't run. The worst is that the table does not accept this figure: it replace it by 0 all the time (from 0.01 and obviously with the comma character, that the one used in French for real numbers). Thanks, PK
Please, could you describe step by step how to reproduce the problem ? I see nothing about thousand separator in AutoCorrection options. In the table toolbar in Writer there is buttons to format numbers. There you can choose to use a thousand separator. Tested in Version: 7.1.6.0.0+ / LibreOffice Community Build ID: 319dc6a20a9a8c84cffc583eefbc94636bf9fee8 CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Ubuntu_20.04_x86-64 Calc: threaded Status has been set to NEEDINFO, please set it back to UNCONFIRMED once requested information has been provided. Best regards. JBF
Hi, In writer, insert table with column. Then add long format number, like 10000. The number is underline and a menu proposes a correction (like 10 000). It is OK. When you choose a relative number, like 0,0001, the number disappears and you get only the 0. Correction: this bug exists only after a long format number: First column : add a long format number and correct. Second column : add a real... and rests only 0. Second line : possible to add real, but without formatage. Seems very strange :( Version: 7.1.5.2 / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 2; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded thanks, PK
I can't reproduce your problem. Please could you attach your test file ? Best regards. JBF
Created attachment 174192 [details] table with french figure normalisation
Sorry, my comments wents out... The first 0 does not work (if I set 0,001, it becomes 0) The 1000 has no proposition to be corrected. Thanks, PK
There is no bug there, only a wrong choice of number formatting. The number format "standard" has 0 decimal. If you change for a custom format with at least 3 decimal, the number in the cell B1 looks correct. For column A, the numbers are formatted as text, not as numbers. Best regards. JBF
The shame on me... I 'd never thought about format :( For my excuse, the table seems proposes random format for each case (because I did not anything about it, only add rows...). Thank you and excuse me for the lost time!
(In reply to patrice.karatchentzeff from comment #9) > The shame on me... I 'd never thought about format :( > > For my excuse, the table seems proposes random format for each case (because > I did not anything about it, only add rows...). > > Thank you and excuse me for the lost time! No problem. :-) Best regards. JBF