[Libreoffice-bugs] [Bug 138993] New: Remove commas in numbers

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138993
           Summary: Remove commas in numbers
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jg at jguk.org

Hello
Using en_GB Calc I need to manually remove commas when pasting numbers from
bank statements. Could Calc handle this automatically?

eg

= 1,947.68 - 1000

Err:509

Calc knows we use the decimal . to separate decimals and comma to indicate
thousands. Can Calc understand what is typed? It could simply remove the comma
when it accepts the number.

If I paste 1,947.68 directly into a cell, Calc does interpret and remove the
comma.

-- 
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/20201217/dbf6c340/attachment.htm>