Wrong Value of Option Data Type when Exported to Excel

CHADELCHADEL Member Posts: 16
Hello. I tried exporting a page to Microsoft Excel with an option field but it gets the wrong value. I don't know if it is a NAV issue or an Excel issue. Kindly suggest. Thank you.


  • SanderDkSanderDk Member Posts: 362
    What kind of value are you expecting and what kind of value are you getting?
    For help, do not use PM, but use forum instead, perhaps other people have the same question, or better answers.
  • CHADELCHADEL Member Posts: 16
    For example I have options: option1, option2, option3. If the value in the page is option2, what is exported to Excel is option1, if the value in the page is option3, what is exported to Excel is option2.
  • Wisa123Wisa123 Member Posts: 291
    Hard to diagnose without seeing the application.
    You probably checked this, but an easy way to make this to happen is if you mix up the order on OptionString/OptionCaption.
    Austrian NAV/BC Dev
Sign In or Register to comment.