Number format & Sum in Excel

Hello,

I don't find the right way to create number fields that can be summed within excel.
For exemple, when i create a field with format '0,00' i am told by excel that the field is text. When i use format '0.00' i can't use the sum function (decimal spearator must be a , ).

Did anyone face this problem ?

Thanks

Hello,

What do you mean by « i create a field with format '0,00' » ?

Hi

I put in a cell [row.mynumber;frm='0,00']
When excel is renderd i am told that "the number in the field is at text format or starts with a quote.
After searching in the xml i noticed that , even if i use the numeric format, the tag contains "inlineString".
So, i surely am doing something the wrong way in formatting the cell in numeric.

OK i found the right way : [row.mynumber;ope=tbs:num]
Why isn't ope=tbs:num in the manual ?

Yes it is :
  http://www.tinybutstrong.com/opentbs.php?doc#cells