1. Help center
  2. Community
  3. Community - Users Help
Answered

Missing options that complete operation

Avatar
Sudipt Roy
Follow
0

I inputted data to run an operation. But there are missing cells (options, missing values etc.). For example:  If I want to do the normality test after entering input, it supposed to show 'Options' and 'Missing Value'. Those two options don't appear.

What should I do?

Comments

2 comments
Sort by Date Votes
  • Official comment
    Avatar
    Mohamad

    Hello Sundipt,

    The option should have enabled, so I am wondering whether your input data is malformed. Send us your spreadsheet to look at (support@numxl.com)

     

     

    Comment actions Permalink
  • Avatar
    Mohamad

    Thank you for sending the spreadsheet. The problem is caused by the RC cells reference style. As a workaround, go to File tab, then Options. In the Option dialog, select the "formula" on the left, and uncheck the R1C1 reference style. (see attachment)

    Our engineers will look into this issue tomorrow, but for now, you should be good.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post