• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

Nitro Query excel export number formatting

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Nitro Query excel export number formatting

    Hi,
    In the latest version of Valence the Nitro Query now exports to excel with different style for numeric columns with 2 decimal positions. It used to have 2 decimals after the point but now numeric columns with 2 decimal places look as attached (see Value column). How do we revert to the previous format for munerics with 2 decimal place (i.e. dollar amounts)?
    Excelstyle.png

  • #2
    You can select "Legacy Excel" on the widget download section from within configure.

    What formatting option do you have selected for the column or if you have custom formatting can you supply it?

    legacyExcel.png

    Thanks

    Comment


    • #3
      We found the issue where it was supplying Excel with an incorrect number format and this will be fixed in our next updated. Thanks for letting us know.

      Comment


      • #4
        We have released an update to 5.2+ and it fixes the issue you reported.

        Thanks

        Comment

        Working...
        X