Download it now!
Bug 100413 - UI: default preview value in number format is different from formats list
Summary: UI: default preview value in number format is different from formats list
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Laurent BP
Whiteboard: target:5.3.0
Depends on:
Reported: 2016-06-15 20:03 UTC by Laurent BP
Modified: 2016-10-25 18:54 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Laurent BP 2016-06-15 20:03:41 UTC
Description: In Format > Cells > Numbers UI dialog, a preview string is displayed according to the format chosen and cell's value. If an empty cell is selected, a default value is displayed. But this value is different from the one in format list and then create some inconsistency.

Steps to reproduce:
1. Select an empty cell
2. Format > Cells > Numbers

Actual behavior:
With Number category
  - Preview string is: 1234.56789
  - Format list uses a different value: -1234.1234
Other categories reflect more inconvenient inconsistency. For instance, for Fraction, format list is difficult to understand (quarter format (new format in master LibO 5.3) displays no fraction).

Expected behavior:
Default values should be the same in preview string and format list. They should be chosen to reflect format specificity.

Entry points:
Default values for format list is defined here:
Default value for preview string is unique whatever the category:
Comment 1 Laurent BP 2016-06-24 14:54:40 UTC
As an extension, with LibO 5.2, there is a new bug: new fraction formats (quarter and 100th) are not explicit in UI number format dialog:
Format > Cells > Numbers, Category: Fraction
In format list, format for quarter displays "1234" and do not show any quarter.
Comment 2 Commit Notification 2016-06-29 09:46:57 UTC
Laurent Balland-Poirier committed a patch related to this issue.
It has been pushed to "master":

tdf#100413 Use same default values for preview string and format list

It will be available in 5.3.0.

The patch should be included in the daily builds available at in the next 24-48 hours. More
information about daily builds can be found at:

Affected users are encouraged to test the fix and report feedback.