Bug 154157 - Allow Calc to automatically enter decimal points in currency values
Summary: Allow Calc to automatically enter decimal points in currency values
Status: RESOLVED DUPLICATE of bug 115078
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: needsUXEval
Depends on:
Reported: 2023-03-13 12:42 UTC by Chuck Davis
Modified: 2023-03-15 10:49 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 Chuck Davis 2023-03-13 12:42:37 UTC
Those of us in the financial world use 10 key devices normally.  A 10 key device works with money formats and automatically formats input for currency values by placing a decimal point, comma or whatever the locale uses in their money format.  Having to place the decimal in a value is very clumsy.  It would be very handy for those of us in the financial world to have the spreadsheet automatically insert the decimal into the value we enter.  Excel has the feature but it's very clumsy because it does it to the whole sheet.  We need to be able to format a column, row or range so that values entered become financially formatted without entering the decimal point or comma.  Usually sheets with financial data have a mixture of numeric and currency data so formatting a range would be very desirable. 

Steps to Reproduce:
1.Set a format
2.Enter data

Actual Results:

Expected Results:

Reproducible: Always

User Profile Reset: No

Additional Info:
10 key users will have a difficult time adopting LibreOffice.
Comment 1 Chuck Davis 2023-03-13 12:43:55 UTC
I see from Google users have requested this feature numerous time with no results.
Comment 2 Rafael Lima 2023-03-14 14:40:05 UTC
This seems an interesting feature. Let's hear from the UX team.
Comment 3 Heiko Tietze 2023-03-15 10:49:17 UTC

*** This bug has been marked as a duplicate of bug 115078 ***