I use Calc for work. Some numbers I insert from some documents or other software use dots as decimal separator. However in my language we use comma as a decimal separator.
Is is possible to configure so that Calc recognizes both symbols as decimal separators, and preferrably also switches the dots into commas when used as decimal separators?
Every time I’m forced to manually adjust the imported values. It’s a big waste of time, and I can’t change to a language that uses dots as decimal separators, because those are the exception here and not the rule (the majority but not all documents and programs use commas). This mixup of differing standards is a real annoyance, and having a way to deal with this permanently would be nice.