[Libreoffice-bugs] [Bug 117808] cells display numbers as "0%" percent value although the correct percent value is shown in the cell editor

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117808

Jérôme  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #7 from Jérôme  ---
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).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117808] cells display numbers as "0%" percent value although the correct percent value is shown in the cell editor

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117808

Buovjaga  changed:

   What|Removed |Added

 Ever confirmed|0   |1
 CC||todven...@suomi24.fi
 Status|UNCONFIRMED |NEEDINFO

--- Comment #6 from Buovjaga  ---
(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?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117808] cells display numbers as "0%" percent value although the correct percent value is shown in the cell editor

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117808

--- Comment #5 from MM  ---
(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 10% (with '0,%'), in the cell it's shown as 100 instead
of 100,000.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117808] cells display numbers as "0%" percent value although the correct percent value is shown in the cell editor

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117808

Jérôme  changed:

   What|Removed |Added

 Status|RESOLVED|UNCONFIRMED
 Resolution|NOTABUG |---
 Ever confirmed|1   |0

--- Comment #4 from Jérôme  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117808] cells display numbers as "0%" percent value although the correct percent value is shown in the cell editor

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117808

m.a.riosv  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 CC||miguelangelrv@libreoffice.o
   ||rg
 Resolution|--- |NOTABUG

--- Comment #3 from m.a.riosv  ---
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
#,

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117808] cells display numbers as "0%" percent value although the correct percent value is shown in the cell editor

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117808

MM  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
Version|5.2 all versions|Inherited From OOo
 Ever confirmed|0   |1
 OS|Windows (All)   |All

--- Comment #2 from MM  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117808] cells display numbers as "0%" percent value although the correct percent value is shown in the cell editor

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117808

Jérôme  changed:

   What|Removed |Added

 CC||jerome.bo...@wanadoo.fr

--- Comment #1 from Jérôme  ---
Created attachment 142281
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142281=edit
the files which is saved with the wrong cells formatting

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs