Set the column to date format in Spreadbuilder

Set the column to date format in Spreadbuilder

Posted by: pikyan.lee on 29 November 2022, 5:56 pm EST

• 

  pikyan.lee

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 November 2022, 5:56 pm EST

  I’m using Active Reports 15.3.2 . Is there a way to set the column to date format in spreadbuilder? By default, the value is set to string format. I have columns in the spreadsheet which the user would need to filter the data with the date filter option within excel. I have tried using the function ‘NumberFormat’, but it does not have effect.

                              .Cell(i, 11).NumberFormat = "mm/dd/yyyy hh:ss"
                              .Cell(i, 14).NumberFormat = "d-mmm-yy"
                              .Cell(i, 16).NumberFormat = "mm/dd/yyyy"

  ExcelColumnDateFormat.zip

  Thanks

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 1 December 2022, 6:51 am EST

  Hello Cheery,

  I was able to replicate this issue at my end and I have escalated this issue to the development team to get their insights on this. [AR-29837]

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 16 December 2022, 1:19 am EST

  Hi Cherry,

  I have discussed this issue with the development team. This is a limitation of Spread Builder. I have also created an enhancement/feature request for the same. I will let you know once I have an update on this.[AR-29889]

  Regards,
  
  Akshay

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 17 January 2023, 12:36 am EST

  Hi Cherry,

  As mentioned by the development team SpreadBuilder is a low level free tool it’s main purpose is to be used in XlsExport. It seems if you want to have the date filter for date values then it is suggested to use the XlsExport instead of SpreadBuilder.