Grid Formatting and Exporting Issues

[Dimitrios Tsarouchis]

Hello, 

I have a grid in my Server blazor application and i use Greek regional settings (comma as decimal separator and dot as thousand separator)

A) I have an integer column on my grid and I set format as number:

<GridColumn Field=@nameof(PassengersNumber.Cnt) HeaderText="Number" TextAlign="Syncfusion.Blazor.Grids.TextAlign.Right" Width="140" AllowEditing="false" Visible="true" Format="N0" Type="ColumnType.Number"></GridColumn>

On Grid rows value is displayed properly (with dot as thousand separator) but in summaries is displayed with comma).

B) I have also a double column. I set format as C2:

<GridColumn Field=@nameof(PassengersNumber.Gross) HeaderText="Amount" TextAlign="Syncfusion.Blazor.Grids.TextAlign.Right" Width="140" AllowEditing="false" Visible="true" Format="C2"></GridColumn>

When I am exporting my grid to excel, format to this column is not displaying properly. Thousand separators are missing and decimal digits are 5 instead of 2.

C) I have a DateTime field and i want to display on the column of grid only the time in 24 hours format and only if  time is not set to 00:00. With template column i can achieve this:

<GridColumn Field=@nameof(PassengersNumber.DelayTime) HeaderText="Delay Time" TextAlign="Syncfusion.Blazor.Grids.TextAlign.Center" Width="140" AllowEditing="false" Visible="true">

                <Template>

                    @{

                        var a = context as PassengersNumber;

                        if (a.DelayTime == new DateTime(1900, 1, 1))

                        {

                            <span></span>

                        }

                        else

                        {

                            <span>@a.DelayTime.ToString("HH:mm")</span>

                        }

                    }

                </Template>

            </GridColumn>

But when i am exporting grid to excel the result is not the same:

If I use below approach i have not the expected results:

<GridColumn Field=@nameof(PassengersNumber.TripTime) HeaderText="Delay Time" TextAlign="Syncfusion.Blazor.Grids.TextAlign.Center" Width="140" AllowEditing="false" Visible="true" CustomFormat="@(new { type = "time", skeleton = "Hm" })" Type="ColumnType.DateTime"></GridColumn>

In Angular Grid if i use the below approach (like the above i used in Blazor), the result is that I expect on my grid and excel export:

<e-column field='TripTime' headerText='Delay type='time' [format]='formatOptions' enableGroupByFormat='true' textAlign='Center' width=80></e-column>

this.formatOptions = { skeleton: 'Hm', type: 'time' }

D) On exported excel summaries are not included:

I have attached a test project

Attachment: TestBlazor_Sf_7d643a55.7z

[Renjith Singh Rajendran]

Hi Dimitrios, 

Greetings from Syncfusion support. 

Query 1 && Query 2 : A) On Grid rows value is displayed properly (with dot as thousand separator) but in summaries is displayed with comma). && B) When I am exporting my grid to excel, format to this column is not displaying properly. 

We are currently validating the reported problems from our side, we will update you further details on June 10, 2020. Until then we appreciate your patience. 

Query 3: C) I have a DateTime field and i want to display on the column of grid only the time in 24 hours format and only if  time is not set to 00:00. 

Based on your requirement, we suggest you to use the Format property of Grid. We are attaching the modified sample for your reference. Please download the sample form the link below, 

Sample : https://www.syncfusion.com/downloads/support/directtrac/general/ze/TestBlazor_Sf-2115169560 

Please refer and use as like the code below, 

 

<GridColumn Field=@nameof(PassengersNumber.DelayTime) HeaderText="Delay Time" Format="HH:mm" ... AllowEditing="false" Visible="true"></GridColumn> 

And we would like to inform you that, we have deprecated the CustomFormat property of Grid Column in our latest versions and you can use Format property of GridColumn to apply date format in C# standard. So it is suggested to use the Format property instead of CustomFormat to apply date format in C# standard. Please find the latest Nuget package and release notes regarding the changes we have implemented in our Grid.  

Release Notes: https://blazor.syncfusion.com/documentation/release-notes/17.4.39/?type=all#grid 

And also currently we don’t have support for export the template cell columns. So please use the above suggested Format property to achieve this requirement. We have considered this “Provide template cell exporting support for Excel Export” as an feature and added this feature request to our database. We are always trying to make our products better and feature requests like yours are a key part of our product growth efforts. We have planned to implement this in any of our upcoming releases. 

 

We are closing this incident for now. You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.  

Feedback : https://www.syncfusion.com/feedback/14366/provide-template-cell-exporting-support-for-excel-export 

Query 4 : D) On exported excel summaries are not included: 

We have considered it as a bug and logged defect report for the same. Thank you for taking the time to report this issue “Grid Aggregates are not getting exported in Blazor ” and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle ) and including the defect fix in our upcoming 2020 Volume 2 release which is expected to be rolled out in the Month end of June 2020.   

 

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.  

Feedback : https://www.syncfusion.com/feedback/12821/grid-aggregates-are-not-getting-exported-in-blazor  

Please get back to us if you need further assistance. 

Regards, 

Renjith Singh Rajendran 

[Renjith Singh Rajendran]

Hi Dimitrios, 

Query 1 && Query 2 : A) On Grid rows value is displayed properly (with dot as thousand separator) but in summaries is displayed with comma). && B) When I am exporting my grid to excel, format to this column is not displaying properly. 

We have considered these case scenarios from our side. And this behavior will be resolved in our upcoming Volume 2, 2020 release which is expected to be rolled out by the end of June 2020. Until then we appreciate your patience. 

Please get back to us if you need further assistance. 

Regards, 

Renjith Singh Rajendran