Currency formatting is not working on stacked grid while it is working on normal grid.

Hi Team,
I am looking to format the numbers in nl-BE format on the stacked column chart.

I have added the necessary cldr-data inside the wwwroot folder and it is working for normal grid. I can see the currency formatted to € 1.320.858,00 which is what I am looking for.
But the stacked columns grid shows € 4511479,50 as label on the y-axis as well as on the tool tip.




image_4.png



@model StackedGrid

<ejs-chart id="@Model.Name" load="window.onChartLoad" title="@Model.Title" height="700" locale="nl-BE">

    <e-chart-primaryxaxis labelIntersectAction="Rotate45" valueType="Category">

        <e-majorgridlines width="0"></e-majorgridlines>

    </e-chart-primaryxaxis>

    <e-chart-primaryyaxis minimum="0" maximum="@Model.MaximumValue" interval="@Model.Interval" title="Sales" valueType="Double" labelFormat="C2">

        <e-majorticklines width="0"></e-majorticklines>

        <e-linestyle width="0"></e-linestyle>

    </e-chart-primaryyaxis>

    <e-series-collection>

        @foreach (var item in Model.GridValues)

        {

            var dataSource = item.DataSource;

            <e-series dataSource="dataSource" xName="key" yName="value" name="@item.Name" width="2" opacity="1" type="@Syncfusion.EJ2.Charts.ChartSeriesType.StackingColumn"></e-series>

        }

    </e-series-collection>

    <e-chart-tooltipsettings enable="true"></e-chart-tooltipsettings>

    <e-chart-legendsettings toggleVisibility="true"></e-chart-legendsettings>

    <e-chart-chartarea>

        <e-chartarea-border width="0"></e-chartarea-border>

    </e-chart-chartarea>

</ejs-chart>


3 Replies

DG Durga Gopalakrishnan Syncfusion Team April 26, 2022 03:37 PM UTC

Hi Sanju,


Greetings from Syncfusion.


We suggest you to enable useGroupingSepartor as true along with required locale to achieve your requirement. Please check with the below snippet and sample.


<ejs-chart id="container" useGroupingSeparator="true"></ejs-chart>



Sample : https://www.syncfusion.com/downloads/support/directtrac/general/ze/GroupingSepartor1796427586.zip


UG : https://ej2.syncfusion.com/aspnetcore/documentation/chart/numeric-axis#groupingseparator


Please let us know if you have any concerns.


Regards,

Durga Gopalakrishnan.



SD Sanju Dahal April 27, 2022 09:15 AM UTC

Thank you so much!
This was what I was looking for


Thanks
Sanju



DG Durga Gopalakrishnan Syncfusion Team April 28, 2022 06:52 AM UTC

Hi Sanju,


Most welcome. Please get back to us if you need any further assistance. We are always happy in assisting you.


Regards,

Durga Gopalakrishnan


Loader.
Up arrow icon