• Cell date format

    By Miroslav Navratil 8 years ago

    I might miss something but I can't figure out how to set the cell data format to Date when creating Excel sheet. Obviously there is property for that in Column Definition/Cell Style but I do not know what to put there .. no options offered.
    Could somebody kindly advise me? Thanks.

    • By Lena Troxler 8 years ago

      Hi Miroslav,

      You can set property 'dataFormat' in the cellStyle to the dataFormat you like:

        <wgpoi:cellStyle
        dataFormat="dd/mm/yyyy">
  </wgpoi:cellStyle>

      Hope this helps.