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
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).
Default values should be the same in preview string and format list. They should be chosen to reflect format specificity.
Default values for format list is defined here:
Default value for preview string is unique whatever the category:
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.
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
http://dev-builds.libreoffice.org/daily/ 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.