Description: In Sidebar and UI Format > Cells > Numbers, "Decimal places" is grayed if scientific format is selected Steps to reproduce: 1. Enter a scientific value such as 1e-2 2. View > Sidebar or Format > Cells > Numbers Actual behavior: In Sidebar, Properties > Number format, or in UI Format > Cells > Numbers, Decimal places is grayed. The only way to modify decimal places is to manually type a new format in UI (no solution with Sidebar), such as "0.000E+0" Expected behavior: Decimal places should be easily modified with up/down arrow like other formats such as number, percent, currency
Behavior reproducible. I do not see any reason for current limitation in the scientific format --> status NEW. Best regards. JBF
Bug confirmed with OOo 3.2.1 => I modified version accordingly
LaurentBP: I took a look before realizing you assigned yourself this one. Anyway, if interested, this seems to work: diff --git a/cui/source/tabpages/numfmt.cxx b/cui/source/tabpages/numfmt.cxx index 169f898..57d5861 100644 --- a/cui/source/tabpages/numfmt.cxx +++ b/cui/source/tabpages/numfmt.cxx @@ -963,6 +963,7 @@ void SvxNumberFormatTabPage::UpdateOptions_Impl( bool bCheckCatChange /*= sal_Fa case CAT_NUMBER: case CAT_PERCENT: case CAT_CURRENCY: + case CAT_SCIENTIFIC: m_pFtOptions->Enable(); m_pFtDecimals->Enable(); m_pEdDecimals->Enable(); @@ -982,7 +983,6 @@ void SvxNumberFormatTabPage::UpdateOptions_Impl( bool bCheckCatChange /*= sal_Fa case CAT_DATE: case CAT_TIME: case CAT_BOOLEAN: - case CAT_SCIENTIFIC: case CAT_FRACTION: default: m_pFtOptions->Disable();
Just synchronizing state of bugtracker with the fact that "Assigned to" isn't empty.
For sidebar, I think this part should be changed: http://opengrok.libreoffice.org/xref/core/sc/source/ui/sidebar/NumberFormatPropertyPanel.cxx#217
Thanks Julien for the links. I had found the first one. However it still need some improvement as switching on/off red for negative number corrupt the format. I will try to find a solution in next days, or simply switch off this option if I can't.
FYI: Commit https://gerrit.libreoffice.org/#/c/14293/ fixed the problem
Zdeněk Crhonek committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4374f8b621dbefcb0a78a8005db48eb25675bf3c uitest for bug tdf#88999 It will be available in 6.1.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.
The test exist, set status to Verified.