qSIListview - how to convert numbers to text when exporting to Excel? - SharePoint Customization - SharePoint for All - Dell Community

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

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

This question has been answered by kenny.wu-quest

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!

Laurinda Chi

Verified Answer
  • Hi Laurinda,

     

    This is the bug of qSIListView, #420983.

     

    As an workaround, please use export to PDF function.

     

    Kenny.

All Replies
  • Hi Laurinda,

     

    This is the bug of qSIListView, #420983.

     

    As an workaround, please use export to PDF function.

     

    Kenny.