Download it now!
Bug 57210 - : Feature Request:: Better interpretation of formulas including numbers containing commas.
Summary: : Feature Request:: Better interpretation of formulas including numbers conta...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
: 90745 (view as bug list)
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
Reported: 2012-11-16 22:26 UTC by Carlton Hobbs
Modified: 2017-09-16 19:31 UTC (History)
1 user (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 Carlton Hobbs 2012-11-16 22:26:11 UTC
Problem description: :  If I enter a formula in Calc and it includes commas in the numbers, Calc just puts “Err:509” in the cell.  In MS Excel, it brings up a warning and offers to correct it by removing the commas, only requiring clicking “ok”.  

Expected behavior: Calc should have a similar time-saving feature.  The problem is common when copying and pasting lots of comma containing numbers from other sources (i.e. PDFs) into Calc formulas, and an Excel like quick fix option instead of just an error would save much time.
Comment 1 m.a.riosv 2012-11-17 01:42:32 UTC
What are your locale settings?.
Menu/Tools/Options/language settings

Can you attach a file sample with data or a link, to try the copy - paste.
Comment 2 A (Andy) 2013-04-20 09:51:40 UTC
reproducible with LO (Win7 Home, 64bit)
If you have English settings then type in a cell for instance "=9,5*2" and with non-English settings type "=9.5*2".  In these cases you would get an error message ("#REF!"), but no hint message to correct your formula.

marked as enhancement request
Comment 3 Eike Rathke 2016-05-31 15:45:01 UTC
*** Bug 90745 has been marked as a duplicate of this bug. ***
Comment 4 Eike Rathke 2016-05-31 15:46:06 UTC
Some details in