https://bugs.documentfoundation.org/show_bug.cgi?id=115078
V Stuart Foote <vstuart.fo...@utsa.edu> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Automatically insert a |Automatically insert a
|decimal point like in Excel |decimal point like in Excel
|2016 |
--- Comment #9 from V Stuart Foote <vstuart.fo...@utsa.edu> ---
Excel has had this data _input_ aid since Office 2000.
It is a specialized numeric formatting conversion feature to convert integer
constant _input_ to floating point positionally. Setting a positive shift moves
the resulting decimal place left (numbers gets smaller), a negative moves the
decimal place right (numbers get larger).
Scale of resulting number is not fixed, but depends on the amount of the shift
set for the option (a range of 300 to -300) but also the length, in digits, of
the integer value entered.
So, with a shift value of 2:
input => becomes
1 => 0.01
12 => 0.12
123 => 1.23
1234 => 12.34
and with a shift value of -2:
1 => 100
12 => 1200
123 => 12300
1234 => 123400
Again this is an aid for specialized numeric input. Handy for inputting a long
list of numbers via keypad, but does not affect numbers already present on the
sheet.
Certainly not a core requirement, but probably worth implementing for those
that would use this feature. But that sounds more like an Extension to me.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
