What's New?

Excel Export date fields in UTC timezone after update to Ext.Net 5.2

  1. #1
    Jul 12, 2021, 1:22 PM

    Excel Export date fields in UTC timezone after update to Ext.Net 5.2

    Hi,

    we have a GridPanel where we export the grid content to an excel sheet:
                case "xls":
                this.Response.ContentType = "application/vnd.ms-excel";
                this.Response.AddHeader("Content-Disposition", "attachment; filename=submittedData.xls");
                XslCompiledTransform xtExcel = new XslCompiledTransform();
                xtExcel.Load(Server.MapPath("Excel.xsl"));
                xtExcel.Transform(xml, null, Response.OutputStream);

                break;
    With Ext.Net Version 3.1, the date fields where exported in local time zone, as they are displayed in the grid.
    After we changed to Ext.Net Version 5.2, the dates are now converted to UTC time zone.

    Is it possible in Ext.Net Version 5.2, that date fields are exported in local time zone, as in Ext.Net Version 3.1?

    Thanks,
    Arthur
  2. #2
    Jul 13, 2021, 1:45 AM
    Hello Arthur!

    Have you verified it is really Ext.NET's behavior that changed, and not the XLS engine you are using? Can you provide a test case compatible with the way you generate, view, and submit the grid so we can see what's different between the two versions?

    If the date is getting converted until it makes it to code behind you can probably add the date column to this example and we will be able to tell how to avoid or circumvent that behavior:
    - Grid Panel > Selection Models > Submitting Values

    We don't need the xtExcel dependency; if the problem is with Ext.NET we should be able to just Ext.Toast(<dateValueHere>) and tell the difference.

    Looking forward to your follow-up!
  3. #3
    Jul 28, 2021, 12:20 PM
    Hi,

    we've tried the Excel export with following examples:

    https://examples5.ext.net/#/GridPane...Data_PostBack/

    https://examples3.ext.net/#/GridPane...Data_PostBack/

    Here we could see the same behaviour as in our own application:
    With Ext.Net Version 3.1, the date values were exported as they are displayed in the grid.
    With Ext.Net Version 5.2, the date values were exported with conversion to UTC time zone.

    Can you explain why the behaviour is different with these two Ext.Net Versions?

    Thanks,
    Arthur
  4. #4
    Jul 28, 2021, 5:35 PM
    Hello Arthur!

    Thanks for making it very clear where the problem sits! This is a breaking change introduced by Ext JS. We delayed this breaking change as much as we could in Ext.NET 4. In fact, latest v4 behaves like v3's date-time wise. But unfortunately with Ext.NET 5 release we needed to let it go and adopt Sencha's breaking change.

    To that specific issue you could revert the behavior with the following change to the same example's head HTML block:

    <head runat="server">
    <title>Export Data from GridPanel into XML, Excel or CSV using a full PostBack - Ext.NET Examples</title>
    <link href="/resources/css/examples.css" rel="stylesheet" />

    <script type="text/javascript">
        Date.prototype.toJSON = function () {
            var ejs_encoded = Ext.JSON.encodeDate(this);
            return ejs_encoded.substring(1, ejs_encoded.length - 1);
        }
    </script>

    <ext:ResourcePlaceHolder runat="server" />

    <script>
        var saveData = function () {
            App.Hidden1.setValue(Ext.encode(App.GridPanel1.getRowsValues({selectedOnly : false})));
        };
    </script>
</head>
    This will replace browser's JSON encoder back with Ext JS's which doesn't do this time zone implicit conversion. The ext:ResourcePlaceHolder ensures Ext JS scripts are run after the modification is in effect. And then you'd get the previous versions' behavior.

    More details in issue #1765. Unfortunately we don't have a more definitive fix at hand.

    No matter what solution is devised, the shift must be solved client-side, as the server can't reliably tell which time zone a given client submitting data is in. Well, you can always pass the time zone offset (in minutes) and deduce it from server side too: new Date().getTimezoneOffset(). This should reliably tell how "far" the submitted date and times are from actual values.

    Hope this helps!
    Fabrício Murta
    Developer & Support Expert
    Ext.NETASP.NET UI Component framework
    RetypeDocumentation website generator
    MojeeLightning fast Emoji library for .NET
    Ext.NET Examples|Ext.NET API Docs|ExtJS API Docs|Twitter

Similar Threads

  1. Razor pages - EXT.net v7 - Export to excel Issue
    By Geovision in forum 7.x Classic Help
    Replies: 1
    Last Post: Jan 08, 2021, 5:23 PM
  2. [CLOSED] Export data to excel in EXT NET MVC
    By pvera in forum 5.x Legacy Premium Help
    Replies: 5
    Last Post: Mar 13, 2020, 2:39 AM
  3. [CLOSED] close Ext.Net Window after export to excel
    By PriceRightHTML5team in forum 2.x Legacy Premium Help
    Replies: 1
    Last Post: Sep 04, 2013, 12:06 PM
  4. export data from grid panel to excel not working model fields
    By Binai in forum 1.x Help
    Replies: 0
    Last Post: Jan 08, 2013, 5:18 AM
  5. Excel export , column header and Null date field
    By springrider in forum 1.x Help
    Replies: 1
    Last Post: Oct 13, 2011, 5:12 PM

Tags for this Thread

Posting Permissions