Bug 130265 - Implement "Automatically insert a decimal point" feature as seen in Excel
Summary: Implement "Automatically insert a decimal point" feature as seen in Excel
Status: RESOLVED DUPLICATE of bug 115078
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: needsUXEval
Depends on:
Reported: 2020-01-29 18:25 UTC by cknapp
Modified: 2020-02-19 19:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description cknapp 2020-01-29 18:25:57 UTC
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:

Expected Results:

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
Comment 1 Kevin Suo 2020-02-08 07:12:54 UTC
(In reply to cknapp from comment #0)

I strongly AGAINST this feature. I am an accounting professional and I use LibreOffice Calc everyday. Typing in numbers in that way is really really a bad habit, and make your mind massed up. Typing 12345 is 12345, and if you want to type in 123.45, you'd better type in the "." manually.

I understand that in some ERP software (such as UFIDA, Kingdee etc, not sure whether it is the same in SAP?) it allows you to type in the Debit/Credit amount without typing the ".", but I do not see any speedup of input in that way -- that is really a matter of habit, stick into the right habbit would make everyone's life easier.

If you really need this feature, someone interested in this can develop an Extension for that purpose.

If no one else is in support if this, this should be closed as RESOLVED WONTFIX.
Comment 2 Kevin Suo 2020-02-08 07:14:51 UTC
(In reply to Kevin Suo from comment #1)

Just to clarify, in ERP software it allows you to type in the numbers without typing the ".". That was purely for the purpose of inputting accounting voucher entries.
Comment 3 cknapp 2020-02-08 13:54:51 UTC
I can see what your saying, but it's a feature present in excel. So I guess it depends on how important it is to have parity with MS excel.

No one will force you to use this feature. Just like no one will force you to use scientific notation number formatting.
Comment 4 Kevin Suo 2020-02-08 14:36:44 UTC
Let's put "needsUXEval" keyword then.
Comment 5 cknapp 2020-02-08 15:13:49 UTC
Sounds good.

For the time being, do you know of any extensions that do this? I searched and didn't find anything like this.
Comment 6 Kevin Suo 2020-02-08 16:12:21 UTC
(In reply to cknapp from comment #5)

> do you know of any extensions that do this?
I am pretty sure there is no such extension at this moment.
Comment 7 Heiko Tietze 2020-02-19 14:13:56 UTC
The duplicate request in bug 115078 has been rejected. The inbuilt methods are sufficient and automatic conversion is dangerous.

*** This bug has been marked as a duplicate of bug 115078 ***
Comment 8 cknapp 2020-02-19 19:40:54 UTC
I see this has been ignored. And after following the initial bug report that's being discussed here: https://bugs.documentfoundation.org/show_bug.cgi?id=115078#c14 It appears that the decision is to ignore this feature as some involved with this software development see this as not used by many and therefore not worth implementing. 

Yet by their own admission, this has been a feature in Excel since 2000. So they have carried this "useless" feature for 20 years without reason? Surely more than a handful would find this useful. 

Oh well, I personally believe that Microsoft is trending towards offering office on linux (maybe as a snap) in the near future. And I guess at that point all of us that want this feature can use Excel who is willing to invest money into their product for EVERYONE'S needs. Very disappointing. 

If Microsoft gets in the game of open source, these kinds of great projects like Libre Office are going to die, if this is the attitude that's carried forward (broad general assumptions about features being value added or not) by such projects. 

I'm not upset, just disappointed that a feature request (that has been repeatedly requested) to progress this project to feature parity with it's competitor, excel, is being discarded simply because the designers don't think "enough" people will use the feature. Or simply because they don't understand the use case. 

There is a reason MS has invested money in maintaining this feature for 20 years in their product, you'd think that at the very least would be a clue that it IS indeed value added.