Allow comma , as decimal point upon input or commit

[githubuser181226]

Hi.

In Polish language (and others) a decimal number is written using comma character , to separate the whole from the fraction part.
When using typical Polish keyboard layout (eg. Polish Programmer's) even the decimal point key on the numpad produces a comma instead of the actual period.

However in SQLiteStudio (SQLite in general) only the period is allowed as a decimal separator, because comma is reserved for separating parameters or listed values.

Because of this, when you copy values from a dataview to Libreoffice Calc, the fractions are mis-interpreted, usually as dates (because of the way Polish dates are auto-detected (ie. D.MM resolves as D.MM.YYYY).

Same problem happens the other way around - when copying from a spreadsheet into SQLiteStudio - this causes the program to interpret fractions with commas as text literals instead, ie. you have to manually convert them before they can be used as floats.

I'd like SQLiteStudio to have an optional way to deal with this. Either by replacing every comma character with period on-the-fly when typing in numeric data (and vice versa when copying the data to clipboard) or by converting the numbers with commas to valid SQL numbers with periods upon commit.

Do you think this is feasible?

Thank you.

Edit. Instead of messing around with the input the convertion from period to comma in a decimal value could also be made simply with a separate special copy and paste commandsm, however this would not fix the numpad problem.