Comma delimeter formatting gives invalid *.ods spreadsheet number

[Netrieb]

Formatting formula number({{value}}, ",") to set a custom decimal delimiter in Bonsai's Spreadsheet Export (*.ods) gives a number unusable in Libre Office Calc (the number is not treated as a number, for example you cannot use it for SUM operation...).

Export Settings:

The exported *.ods file:
test_01.ods

Additional info:

• there is no issue when I use number(12345, ",") instead of the number({{value}}, ",")
• if you change a locale in Libre Office to Czech or German, the very same *.ods file shows an extra single quote character:
  
  How to change the locale in Libre Office:
  

Tested on:

• bonsai_py311-0.8.1-alpha250103-linux-x64
• stable version bonsai 0.8 was also affected
• Blender 4.3.2
• Kubuntu 24.04
• Libre Office 24.2.7.2

[Moult]

This is expected because number formats the original integer/float as a string. So naturally once you format it, it becomes a string (and that ' quote character at the beginning shows it is a string) and cannot be used for summing.

If you want to keep it as a number (so that you can do fancy calcs in your spreadsheet app) but also have fancy formatting, apply the formatting in the spreadsheet app itself. For example:

Then you can enable Preserve existing which will preserve existing formatting rules in your ODS.