XML configuration of footer

Suite and Optimus Suite 5
#1

How do I configure the footer in the XML?
Does it do in the afterInit XML block?
I have dynamic columns being created so I need to add #cspan to the footer based on column count.

        string footerStr = #cspan,#cspan,#cspan,#cspan,Totals:,#stat_total,#stat_total,#stat_total";
        
        footerStr = "#cspan," + footerStr; // added on a loop

        footerStr = " " + footerStr; 
        xmlString.Append("<call command=\"attachFooter\"><param>");
        xmlString.Append(footerStr);
        xmlString.Append("</param></call>");

Thanks in advance!

#2

I figured it out - forgot the comma after the non breaking space…

afterInit…

#3

How do I add a dollar sigh ($) if fornt of a #stat_total ??

#4

If a column total in the footer is a whole number, how can I force a 2 digit decimal still for currency formatting?

#5

You need to have the column with edn/ron excell type so setNumberFormat() can be used.
Otherwise you will have to create your own custom shortcut for your footer

#6

Ok so the column above the footer #stat_total cell is the ‘price’ type.

I just want to continue the ‘price’ cell type into the footer, how do I set the cell type of the footer in combination to the #stat_total I guess is the question??

#7

Unfortunately you will have to create your own custom shortcut for a footer or calculate the sum manually like in the following example:
dhtmlx.com/docs/products/dht … ooter.html