TinyButStrong - the PHP Template Engine
Categories > OpenTBS with XLSX >

Number format & Sum in Excel

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs

By: Max
Date: 2016-02-25
Time: 18:00

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
By: Skrol29
Date: 2016-02-26
Time: 01:01

Re: Number format & Sum in Excel

Hello,

What do you mean by « i create a field with format '0,00' » ?
By: Max
Date: 2016-02-26
Time: 09:50

Re: Number format & Sum in Excel

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.
By: Max
Date: 2016-02-26
Time: 10:45

Re: Number format & Sum in Excel

OK i found the right way : [row.mynumber;ope=tbs:num]
Why isn't ope=tbs:num in the manual ?
By: Skrol29
Date: 2016-03-01
Time: 00:55

Re: Number format & Sum in Excel

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