Setting Don't Work

[ariopax]

Hi

I use some setting for JQPivot in design time.But don't apply anything.
and then
I use below code for setting

Code: Select all

        IWCGJQPivot.JQPivotUIOptions.AutoSize:= True;
        IWCGJQPivot.JQPivotType:= jqptPivotUI;
        IWCGJQPivot.FileName:= 'data/MyPivot.json';
        IWCGJQPivot.JQPivotUIOptions.Rows.Add('F1');
        IWCGJQPivot.JQPivotUIOptions.Cols.Add('F2');
        IWCGJQPivot.JQPivotUIOptions.Vals.Add('F3');
        IWCGJQPivot.JQPivotUIOptions.RendererName := jqprHeatmap;
        IWCGJQPivot.JQPivotUIOptions.AggregatorName := jqpaIntSum;


But don't apply Below Code.

Code: Select all

        IWCGJQPivot.JQPivotUIOptions.Vals.Add('F3');
        IWCGJQPivot.JQPivotUIOptions.RendererName := jqprHeatmap;
        IWCGJQPivot.JQPivotUIOptions.AggregatorName := jqpaIntSum;


What I do for apply change?

Best Regards.

[Alexander Bulei]

Hi ariopax,

Can you send us the simple testcase please? T.I.A
P.S: And don't forget the json file

Best Regards.

[ariopax]

Hi

This is my testcase.
Please create Data folder in wwwroot for json file.
Please copy pivot.fa.js to wwwroot\jq\pivottable for setting Farsi(Persian Language).
And I have a question.
How to set my sort for cols?
For example i want set cols from One To Six.


Best Regards.

[aftabgardan2006]

hi Ario

Open you'r file pivot.fa.js and then remove frFmt = nf({
thousandsSep: " ",
decimalSep: ","
});
Best Regards.

[ariopax]

Hi aftabgardan2006


My Problem Solved.Thanks.
And in this file pivot.fa.js ,on aggregators function ,i put sum aggregator in first line "مجموع": tpl.sum(frFmt),then IWCGJQPivot.JQPivotUIOptions.AggregatorName := jqpaIntSum; command worked.



Best Regards.

[Alexander Bulei]

Hi ariopax,

It was a issue with jquery plugin and fixed in beta build (which I will upload in few hours).

Thanks.

Best Regards.