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)
Version:
(earliest affected)
3.6.3.2 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
: 90745 (view as bug list)
Depends on:
Blocks: Cell-Formula
  Show dependency tree / graph
 
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:

Attachments
Add an attachment (proposed patch, testcase, etc.)

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 4.0.2.2 (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 https://bugs.documentfoundation.org/show_bug.cgi?id=90745#c7