Describe the bug
When we copy the result of a calc, we got a number with space character between numbers (Eg: "2 365 596")
Steps To Reproduce
Steps to reproduce the behavior:
Expected behavior
Remove spaces when we copy it.
Device and Application Information
I'm just reporting this problem. I don't want to fix it.
This is your friendly Microsoft Issue Bot. I've seen this issue come in and have gone to tell a human about it.
Thanks for the detailed bug report! @rudyhuyn, can you help confirm the desired behavior here?
@grochocki, yes but it's by design, white space is used as the thousands separator in French (, in US, . in Germany, ...).
We have 3 solutions:

When we copy the result of the calc and paste it again, we get a "Entrée invalide" error, the number isn't parsed as the same way it's dislayed.
When we copy the result of the calc and paste it again, we get a "Entrée invalide" error, the number isn't parsed as the same way it's dislayed.
This certainly makes things worse.
We have 3 solutions...
I can imagine use cases for both copying the value with and without separators. A possible fourth option here might be to functionally support both copying _value_ (i.e., "1234.567") and copying _display value_ (i.e., "1,234.567" or "1 234.567" etc.). I imagine copying value would be the default, with copying the display value could be added to the context menu.
(Note: the shortcut Ctrl+C already removes thousands separators, the issue is only when we select the text and copy/paste).
5th solution: we use a regex to automatically remove spacing characters before a group of 3 digits (or more, depending on grouping settings) when a text is pasted and only when the local thousands separator is " "
@maxou44, Je suis français (pas loin de Nantes), je vais personnellement me charger de corriger ce soucis dans les prochaines 24 heures.
@rudyhuyn Amazing! Thanks ☺️
Edit: If you are near Nantes, I'll paid you a bier for this fix ;)