Description: With LibO4.5.0, it is now possible to check "Thousands separator" in Format > Cells > Numbers with scientific format. However, thousands separator is quite useless in case of scientific format. A new feature in LibO 4.5.0 is engineering notation bug 30716. So it could be a good idea to replace the function of the checkbox. Steps to reproduce (with LibO 4.5.0.0+): 1. Format > Cells > Numbers > Format: Scientific 2. Check "Thousands separator" Actual behavior: Format is changed to #,##0.00E+00 (as expected) LibO interpret this format as an engineering like format and set exponent as a multiple of 4, which is quite useless in most cases. Expected behavior: Text of checkbox could be changed in "Engineering notation", and checking it would change format as ##0.00E+00. Format should be kept as a scientific format to be able to add/remove decimal digits. Same applied to Sidebar > Properties > Number format
Laurent Balland-Poirier committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f630f9598f2e328cbe37aff5af0e93c027a94de5 tdf#90258 Toggle Thousand Separator with Engineering Notation It will be available in 5.0.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.
Resolution is not yet completed. The same behavior is expected for Sidebar: https://gerrit.libreoffice.org/15609/
Laurent Balland-Poirier committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=feb336a2a286ff1fc4f584c1ee4ab2148ac596ad tdf#90258 Sidebar: toggle Thousand/Engineering It will be available in 5.0.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.