https://bugs.documentfoundation.org/show_bug.cgi?id=97835
Bug ID: 97835
Summary: FORMATTING: Spurious decimal point in user defined
numeric format
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
If I use the ''General'' format I have:
2
1.5
1.75
1.333
If I don't want more than 2 decimal places I can use a user defined
format such as ''#.##''. I get:
2
1.5
1.75
1.33
Good. Now, suppose the numbers have a unit. Let's take metres rather
than money. The user defined format ''General" m"'' gives:
2 m
1.5 m
1.75 m
1.333 m
OK, but I don't want more than 2 decimal places so I try ''#.##" m"'':
2. m
1.5 m
1.75 m
1.33 m
Oh, sugar plum fairies and all that ! Now the first exemplar is wrong:
it is clearly inconsistent with other formats and I can't see how the
user defined format can be read as "leave in the decimal point when it
clearly isn't necessary for understanding the value displayed."
If there is an alternative way for getting the right result, please let
me know. Otherwise, please fix.
If you decide to fix this bug, as I sincerely hope, be careful you don't
inadvertently also fix bug 90684.
That bug that describes odd behaviour of an undocumented use of ? to alter
how a number is displayed and cannot be fixed for reasons of sideways
compatibility with equally brain-dead implementations elsewhere.
This bug attempts to use quotes to include text in a format without altering
how the number is displayed as documented on the help pages. Clearly
a different issue although the two may share a root cause.
Oh, and yes, it is present in 5.1.0 but has been present since at least 3.5.7.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
