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
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"
Decimal places should be easily modified with up/down arrow like other formats such as number, percent, currency
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
@@ -963,6 +963,7 @@ void SvxNumberFormatTabPage::UpdateOptions_Impl( bool bCheckCatChange /*= sal_Fa
+ case CAT_SCIENTIFIC:
@@ -982,7 +983,6 @@ void SvxNumberFormatTabPage::UpdateOptions_Impl( bool bCheckCatChange /*= sal_Fa
- case CAT_SCIENTIFIC:
Just synchronizing state of bugtracker with the fact that "Assigned to" isn't empty.
For sidebar, I think this part should be changed:
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.
fixed the problem