Top

ErrNum

Comments

8 comments

  • Official comment
    Avatar
    Kaspar Löhn

    Hello Davide.

    Please remove all external links from your spreadsheet. These cannot be used and lead to errors.
    Once they are removed and you have replaced the spreadsheet (UPDATE SOURCE FILE) the app should run without problems.

    Best,

    Kaspar

    Comment actions Permalink
  • Avatar
    Davide Pratelli

    Hi Kaspar 

    i already answered you but didn't ear you back.

    i delated all external links from the file and uploaded again but issue is still there. how should i do now?

    thanks

    0
    Comment actions Permalink
  • Avatar
    Davide Pratelli

    hello there!!!

    is there anybody for this point? i didn't ear nobody till days. is there anything you can do to solve this issue?

    thank you!!

    0
    Comment actions Permalink
  • Avatar
    Damian Roller (Edited )

    Dear Davide.

     

    Thank you for your patience. Please understand that the community is still under construction and unfortunately we can not always serve every user in this intensity. Excel offers many possibilities and especially with such intensive and individual calculation models it is difficult to find the error.

     

    The error ErrNum is displayed if a formula or function contains invalid numeric values. 

     

    There are scenarios where this is caused, for example, by numbers being formatted as text and used for calculation. While Excel compensates for this, our system is not yet able to do so in all cases. We support a substantial majority of Excel functions (over 400) but not yet all subtleties.

     

    Often the error also appears in connection with date or time values that the user wants to have in a certain format and uses in the function "DD", "YYYY" or "MM". These are always region specific formats (in Germany one would use "TT", "JJJJ" and "MM"). Try to avoid these. Since you removed links to external files, this problem should be solved.

     

    I hope that it will works to get your app to calculate. Feel free to set it to public and share the link here. Also please compare the behavior of the app on your mobile phone and the web version here: https://www.openasapp.net/portal#!/client/myApps

    0
    Comment actions Permalink
  • Avatar
    Davide Pratelli

    Hi Damian and thank you for your reply.

    unfortunatelly i just checked and the results cell is already setted as Number.

    i don't know if it is a problem of function but as i said initially i have two terms in this equation identical one to other but the one with positive term below cubic root is calculated (and showed correctly if i put it on my phone) the one with negative term below cubic root give me an ErrNum error. excel show me corrctly the value so i think there is something in your ambient to correct, somthing to translate differently. maybe you never ever done something with negative term on cubic root so you never seen before this issue. what i can provide you fo check the situation?

    thank you again

    0
    Comment actions Permalink
  • Avatar
    Davide Pratelli

    hi all

    i didn't receive any new support about this issue and the problem still there. someone could control. i already tried all your previous answer but they didn't work. thanks in advance!!

     

    0
    Comment actions Permalink
  • Avatar
    Davide Pratelli

    hi everybody 

    sorry but the issue to my app is still there and nobody try to fix it. i can't fix. all you suggested simply don't work. do you check the issue i forwarded almost one time? thanks

     

    0
    Comment actions Permalink
  • Avatar
    Damian Roller

    Dear Davide, 

    we understand that the process is unsatisfactory for you. But please understand that we cannot examine every Excel in detail, as there are countless configuration options, functions and formulas. As a staring point we wrote an article how different formats are treated: https://support.openasapp.com/hc/en-us/articles/360016492239 I hope it will better understand the framework, it's advantages and its downsides. 

    We have made an evaluation of your file that we can send you here:

    I hope it will provide some insights.

    0
    Comment actions Permalink

Please sign in to leave a comment.