Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

  • kmbilal
    replied
    Sure thanks will check and update once available.

    Leave a comment:


  • Isomorphic
    replied
    We've made changes that will be available for download in nightly builds since June 12 (tomorrow). Your setup should work fine, i.e. exported Excel will use client timezone. Let us know please how it worked for you.

    Leave a comment:


  • kmbilal
    replied
    any update we can get for this ?

    Leave a comment:


  • kmbilal
    replied
    We have tried to use exportTZ in our request for exportData functionality for export as ooxml or xls format,but it still using server time zone for formatting datetime field in exported excel file

    This is how we are using exportTZ

    //export opts

    exportOpts = {
    exportAs : "xls",
    exportDisplay : "download",
    exportFilename : EXPORT_FILENAME + ".xls",
    message : "Excel (Compatiblity)",
    exportTZ : "client"
    }

    //passing options to exportData method

    _gridObject.exportData(exportOpts)


    //This is how we declared our fields inside datasource



    <fields>


    <field name="inspectionDate" type="datetime" title="Inspection Date" defaultDisplay="true" dateFormatter="toUSShortDateTime"
    />
    <field name="createDate" type="datetime" title="System Date" defaultDisplay="true" dateFormatter="toUSShortDateTime"
    />
    </fields>

    Let us know if we need to change anything else

    We are using SmartClient Ajax RIA system
    Version v12.1p_2021-05-18/PowerEdition Deployment (2021-05-18)
    Last edited by kmbilal; 7 Jun 2021, 14:36.

    Leave a comment:


  • Isomorphic
    replied
    Yes, exportTZ.

    Leave a comment:


  • kmbilal
    replied
    Thanks for the Information. Also how to set the Timezone info while using exportData() that will be helpful.This is on exporting Grid xls.
    i believe i can use exportTZ ?
    Last edited by kmbilal; 4 Jun 2021, 09:21.

    Leave a comment:


  • Isomorphic
    replied
    See DataSourceField.exportFormat (and also just "format").

    Leave a comment:


  • ExportData: how to set decimal format for float values

    While exporting using exportData we like to export float with 2 decimal point.How can we set that is there any setting available for this in ds etc.
    also overall how we can set these setting is there any specific place to specify the formats for date , decimal etc
    Note: we are using Java in the server side
Working...
X