WebPlotDigitizer
WebPlotDigitizer copied to clipboard
Choose decimal separator
On my device the decimal separator in the dataset is comma, not a dot. This is very annoying when exporting a .csv. This probably depends on system locale settings and browser (I used Safari, iOS 13.4, Russian language in system settings).
I'm able to relate to this issue when using a spreadsheet program set up differently than either English variant of the UK, Australia, or US. If this is the case, see if your program may be set up to use a separator different from the globally set locale by the operating system.
Referring for LibreOffice Calc, for example, Tools -> Options opens in the language settings opens a field to disengages this default coupling:
Later, you may mark the still empty spreadsheet in question and define the number format for example in either pattern with comma, or decimal point via Ctrl + 1 (possibly the key-combination in Mac differs from the one in Linux):
Eventually you paste the data from the digitizer into the spreadsheet, then successfully recognized as numbers instead of a text string. (This may imply that instead of a comma, you use a different character [e.g., semi-colon] as the column separator when exporting the data.)
+1 To trust in the automatism unfortunately sometimes goes wrong ...
Please just add a dropdown menu for the decimal separator, similar to:
@CubaLibre84 In similar vein as mentioned in issue #114, a late adjustment of the decimal separator issue may be a string search-and-replace in an editor, or scripted relying on regular expressions. For obvious reasons, the example given there for an installation in Linux, sed -i 's/\./,/g' probe.txt
, assumes a column separator different from ,
in first place.
OK, so please just add this string search-and-replace, as I don't want to use an editor all the time! The user needs control over the format, independent of the system settings. A warning could be added if the decimal separator and the column separator are equal.
I had the same problem! On mac I manage to solve the issue by changing the decimal separator and changed the language of the app to english!
I also have this problem. Please add a dropdown menu in which the user can manually select the decimal separator.