After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 656043 - incorrect formatting of # ???/???
incorrect formatting of # ???/???
Status: RESOLVED FIXED
Product: libgoffice
Classification: Other
Component: General
0.8.x
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2011-08-05 17:10 UTC by Andreas J. Guelzow
Modified: 2011-08-25 07:46 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Andreas J. Guelzow 2011-08-05 17:10:31 UTC 
Using the # ???/??? format on 0.003 format this as
0 3/1000
this has 2 problems:
(1) For fractions # should not be shown if the integer part is 0 (Note that ???/??? means to never show integer parts)
(2) The denominator should not have 4 digits when only 3 are asked for!
Comment 1 Andreas J. Guelzow 2011-08-05 17:13:10 UTC 
Note that apparently Excel yields  1/333
Comment 2 Andreas J. Guelzow 2011-08-08 16:36:50 UTC 
Part (2) is fixed.

Re part (1) note that a whole integer flagged by # should not be shown unless the fractional part is omitted since the numerator is 0, ie. with format
# ?/2

0   -> 0
0.1 -> 0
0.3 -> 1/2  currently incorrectly as 0 1/2

Of course the format 0 ?/2 should always show an integer part.
Comment 3 Andreas J. Guelzow 2011-08-23 18:20:19 UTC 
Note that the scientific format #E+00 correctly drops the mantissa if it is 1!
Comment 4 Andreas J. Guelzow 2011-08-25 07:46:50 UTC 
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.