| Summary: | cells display numbers as "0%" percent value although the correct percent value is shown in the cell editor | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Jérôme <jerome.bouat> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | ilmari.lauhakangas, jerome.bouat, miguelangelrv |
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | the files which is saved with the wrong cells formatting | ||
|
Description
Jérôme
2018-05-25 19:34:28 UTC
Created attachment 142281 [details]
the files which is saved with the wrong cells formatting
Confirmed on windows 7 x64 with Version: 6.0.4.2 (x64) Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf CPU threads: 3; OS: Windows 6.1; UI render: default; and LibreOffice 3.3.4 OOO330m19 (Build:401) tag libreoffice-3.3.4.1 In 'format cells' (0%), the format code is set as '0,%' If you leave the comma off, making '0%' the cells work again. The format code is '0.%', so the dot is dividing the value with 1000 what implies low values are showed as '0%'. Thousands Separator Depending on your language setting, you can use a comma, a period or a blank as a thousands separator. You can also use the separator to reduce the size of the number that is displayed by a multiple of 1000 for each separator. The examples below use comma as thousands separator: Number Format Format Code 15000 as 15,000 #,### 16000 as 16 #, Ok, that's the wrong format. However, why LibreOffice choose this format when saving this "xlsx" file ? Maybe I have to specify more what occured : 1. I received a "xlsx" file with percent cells which appeared properly and I open it with LibreOffice 5.2 with french localization over Microsoft Windows 7. 2. I edited the file without any change on the cell format which had percent. 3. LibreOffice saved this modified file with the "xlsx" file format. 4. When I open this file again with LibreOffice, then the cells have a strange appearence. (In reply to m.a.riosv from comment #3) > The format code is '0.%', so the dot is dividing the value with 1000 what > implies low values are showed as '0%'. > > Thousands Separator > Depending on your language setting, you can use a comma, a period or a blank > as a thousands separator. You can also use the separator to reduce the size It's set as 'default - english usa'. The format code which the cells have in this example file is set as '0,%', but the other format codes uses the period instead of the comma. '0.0%' and '0.00%'. These work. Strangly if you set 100000% (with '0,%'), in the cell it's shown as 100 instead of 100,000. (In reply to Jérôme from comment #4) > Ok, that's the wrong format. However, why LibreOffice choose this format > when saving this "xlsx" file ? > > Maybe I have to specify more what occured : > 1. I received a "xlsx" file with percent cells which appeared properly and I > open it with LibreOffice 5.2 with french localization over Microsoft Windows Do you have the original file, not saved in LibreOffice yet? I couldn't reproduce this bug. I will try to reproduce this bug when I will get a 6 version installed on my Windows 7 host (in a few months). |