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: http://opengrok.libreoffice.org/xref/core/include/svx/flagsdef.hxx#74 Default value for preview string is unique whatever the category: http://opengrok.libreoffice.org/xref/core/svx/source/items/numfmtsh.cxx#34
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": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9724eaa94e1f1e58dbbba2ecad4287245e0f0bf0 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: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.