Bug 90258 - UI: Scientific format: replace "Thousands separator" with "Engineering notation"
Summary: UI: Scientific format: replace "Thousands separator" with "Engineering notation"
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.5.0.0.alpha0+ Master
Hardware: Other All
: medium enhancement
Assignee: Laurent BP
QA Contact:
URL:
Whiteboard: target:5.0.0
Keywords:
Depends on:
Blocks:
 
Reported: 2015-03-26 13:59 UTC by Laurent BP
Modified: 2015-05-06 17:54 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Laurent BP 2015-03-26 13:59:21 UTC
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
Comment 1 Commit Notification 2015-05-06 10:46:36 UTC
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.
Comment 2 Laurent BP 2015-05-06 15:28:15 UTC
Resolution is not yet completed. The same behavior is expected for Sidebar:
https://gerrit.libreoffice.org/15609/
Comment 3 Commit Notification 2015-05-06 17:54:47 UTC
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.