Wrong Value of Option Data Type when Exported to Excel

CHADEL
CHADEL Member Posts: 16
in NAV Three Tier
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.

Answers

  • SanderDk
    SanderDk Member Posts: 507
    What kind of value are you expecting and what kind of value are you getting?
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • CHADEL
    CHADEL 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.
  • Wisa123
    Wisa123 Member Posts: 309
    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

Categories