Loading...

qSIListview – how to convert numbers to text when exporting to Excel?

qSIListview – how to convert numbers to text when exporting to Excel?

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #4670
      Anonymous
      Anonymous
      Participant

      Hello,

      On the qSIListview, I have a number column formatted as 012345.9999.  When users export to Excel using Action > Export, the leading / trailing zeros are dropped in Excel – i.e., 012345.9999 becomes12345,9999.  This column is defined as varchar(15) data type in SQL, but somehow it got converted to numbers in Excel.

      Please kindly advise if there is a workaround?

      Thank you!

    • #7228
      Anonymous
      Anonymous
      Participant

      Hi ,

      n

       

      n

      This is the bug of qSIListView, #420983.

      n

       

      n

      As an workaround, please use export to PDF function.

      n

       

      n

      n

Viewing 1 reply thread

You must be logged in to reply to this topic.