help with Summary

[Miguel Angel]

Good afternoon friends.

I would like to know, how it is possible to export the grid to an excel file and that the totals have currency format, the rest of the table goes well except the totals.

<div id="GridTWrapper" class="col-md-12 grid-container" style="display:none">

    <ej-grid id="GridT" allow-resizing="true" allow-multiple-exporting="true"  toolbar-click="toolbarClick1" is-responsive="true" allow-grouping="true"

             locale="@(System.Globalization.CultureInfo.CurrentCulture.Name.ToString())">

        <e-group-settings caption-format="{{:key}}" show-drop-area="false" grouped-columns="GroupedCols"></e-group-settings>

        <e-toolbar-settings show-toolbar="true" toolbar-items=@(new List<string>() {"excelExport" })></e-toolbar-settings>

        <e-columns>

            <e-column field="ProductAndRate" header-text="@Localizer["Product"].Value" text-align="Left" width="200" template-id="#ppTemplateDetails"></e-column>

            <e-column field="PClass" header-text="ProductClass" visible="false"></e-column>

            <e-column field="PreviousBalance" header-text="@Localizer["Previous Balance"].Value" text-align="Right" format="{0:N2}"></e-column>

            <e-column field="BoughtAmount" header-text="@Localizer["Bought Amount"].Value" text-align="Right" format="{0:N2}"></e-column>

            <e-column field="CalculatedValuation" header-text="@Localizer["Valuation Amount"].Value" text-align="Right" format="{0:N2}"></e-column>

            <e-column field="PaidRevenueAmount" header-text="@Localizer["Paid Amount"].Value" text-align="Right" format="{0:N2}"></e-column>

            <e-column field="OtherIncome" header-text="@Localizer["Other Income"].Value" text-align="Right" format="{0:N2}"></e-column>

            <e-column field="SoldAmount" header-text="@Localizer["Sold Amount"].Value" text-align="Right" format="{0:N2}"></e-column>

            <e-column field="BalanceAmount" header-text="@Localizer["Final Balance"].Value" text-align="Right" format="{0:N2}"></e-column>

            <e-column field="XIRR_value" header-text="@Localizer["TIR"].Value" text-align="Right" format="{0:P2}"></e-column>

        </e-columns>

        <e-summary-rows>

            <e-summary-row title="Total" show-total-summary="true" show-caption-summary="true">

                <e-summary-columns>

                    <e-summary-column summary-type="Sum" format="{0:N2}" display-column="PreviousBalance" datamember="PreviousBalance" />

                    <e-summary-column summary-type="Sum" format="{0:N2}" display-column="BoughtAmount" datamember="BoughtAmount" />

                    <e-summary-column summary-type="Sum" format="{0:N2}" display-column="CalculatedValuation" datamember="CalculatedValuation" />

                    <e-summary-column summary-type="Sum" format="{0:N2}" display-column="PaidRevenueAmount" datamember="PaidRevenueAmount" />

                    <e-summary-column summary-type="Sum" format="{0:N2}" display-column="OtherIncome" datamember="OtherIncome" />

                    <e-summary-column summary-type="Sum" format="{0:N2}" display-column="SoldAmount" datamember="SoldAmount" />

                    <e-summary-column summary-type="Sum" format="{0:N2}" display-column="BalanceAmount" datamember="BalanceAmount" />

                </e-summary-columns>

            </e-summary-row>

        </e-summary-rows>

    </ej-grid>

[Vignesh Natarajan]

Hi Miguel, 

Thanks for contacting Syncfusion support. We are happy to assist you. 

We are able to reproduce the reported issue at our end. We have confirmed this “Format is not applied for summary value when we use Number formatting” is a defect and logged a defect report. The fix will be included in our 2018 Volume 4 Service Pack 1 release which is scheduled to be rolled out in the month of February 2019. 

  

Until then, we appreciate your patience. 

  

Regards, 

Vignesh Natarajan. 

 

[Miguel Angel]

My friend thanks for helping, I´ll wait, there isn't problem.

[Vignesh Natarajan]

Hi Miguel, 

 

Thanks for the update.  

 

You may also check our website periodically to know about our release schedule.  

  

Regards, 

Vignesh Natarajan