[Libreoffice-bugs] [Bug 130265] New: Implement "Automatically insert a decimal point" feature as seen in Excel

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130265

            Bug ID: 130265
           Summary: Implement "Automatically insert a decimal point"
                    feature as seen in Excel
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: cknapp at protonmail.com

Description:
MS Excel has a feature called "Automatically Insert a decimal point" that
allows you to insert a decimal point of an entered value. 

For example: input value into cell: 12345  and you have the program set to
insert a decimal, two places from the right end. So after inputting that value
and pressing ENTER, the software will change it to: 123.45.

This is useful in accounting environments where you want to enter the the value
and it will ALWAYS have a decimal two from the right side. This is 1 less
keystroke per cell when entering data. 

It is important that the actual value is changed (divided by 100 when decimal
is selected to be 2 places from the right side, 1000 if 3 places, etc.) and not
simply changing what is DISPLAYED. Since this will be used for math
functions/accounting.

(see additional information for examples and other resource material)

Steps to Reproduce:
1.Input 12300 into cell
2. Press ENTER key

Actual Results:
12300

Expected Results:
123.00


Reproducible: Always


User Profile Reset: No



Additional Info:
I have inquired about this feature in the libreoffice forums, here:
https://ask.libreoffice.org/en/question/222592/calc-insert-decimal-two-digits-from-end-of-number/

Microsoft support article that describes this feature that they have:
https://support.office.com/en-us/article/advanced-options-33244b32-fe79-4579-91a6-48b3be0377c4

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200129/729c7193/attachment-0001.htm>