Error on Max Digits for calculated (formula) cell

Posted by: toshiwo on 10 September 2017, 10:59 am EST

  • Posted 10 September 2017, 10:59 am EST

    Hi,
    I'm having this issue, when I calculate the values of formulas i get an error:
    STACK TRACE IS:
    en GrapeCity.CalcEngine.CalcService.Recalculate(Int32 maxCalcCount, Boolean forceRecalculateAll)
    en GrapeCity.Windows.SpreadSheet.Data.Worksheet.d1(Boolean A_0)
    en GrapeCity.Windows.SpreadSheet.Data.Worksheet.ResumeCalcService()
    en GeCOWebSL.Modulos.Presupuesto.ProyectarForm.FillProyLst()
    ERROR MESSAGE (Translated from Spanish) IS:
    Rounding digits must be between 0 and 15, inclusive. Parameter name: digits
    (Original message is)
    Los dígitos de redondeo deben estar entre 0 y 15, ambos incluidos. Nombre del parámetro: digits

    While investigating I came to the conclusion that the cell Property "Value" cannot be more than 15 digits in lenght.

    My question is how do I prevent this error?
    Is there a way to intercept the error and, for example, round the value so that I have 15 digits?

    Thanks.
  • Replied 10 September 2017, 10:59 am EST

    Hi,
    I ran the same project you sent and I did got the same error. (see picture attached)

    In any case I'm using the Silverlight version of the spreadsheet.

    I'm sending you another example I made in silverlight.
    When you press the button below it reenables the CalcService and gives you the error.

    I wonder if there is a way to intercept the validation of the formula evaluation, in order to do something before the error is triggered, in my case I just need to round that value to 15 digits, because it happens also with numbers like 0,03020343543543534535, with long decimal digits.

    Is there any newer version of the spreadsheet libraries? I'm using 9.40.20153.0
    Or maybe I need a newer version of the .NET framework?

    Thans for any help you can give me.

  • Replied 10 September 2017, 10:59 am EST

    Hello,

    Unfortunately, we are unable to replicate the issue at our end with the given information.

    We created a sample application for the same but we are unable to replicate the issue.

    We request you to send across a sample application or modify our application and send it back so that we can investigate the issue further.

    We are sorry further investigation of the issue is not possible with the provided information. We request you to send across additional information if you wish to continue the investigation.

    Thanks,
    Reeva
    2016/03/Wpf_formula.zip
  • Replied 10 September 2017, 10:59 am EST

    I am evaluating the product for a Silverlight project we are developing, I cannot change to WinForms, as my projects is almost finished. As you can see from the screenshot I provided in Silverlight this DOES generate an error, yet I don't know how to fix it, that's why I landed on the support forum.

    If this doesn't work we will need to find another product.
    I hope that a fix, or workaround can be found.

    Cheers.
  • Replied 10 September 2017, 10:59 am EST

    Hi,

    I tried basic code as shown in the image and it seemed to work okay. Your project appears to have exceeded the limit. You might try a small, test project without the Spread Silverlight dlls.

    -Gina



  • Replied 10 September 2017, 10:59 am EST

    Hello,

    We are able to replicate the issue in Spanish Environment and hence we are escalating the same to the concerned team for the fix.

    Tracking id for your issue is:- 147940.

    We will update you once we hear anything from them.

    Thanks,
    Reeva
  • Replied 10 September 2017, 10:59 am EST

    Hi,

    Can you create a small test project that uses the Spread Silverlight dlls, but does not include the actual dlls in the zip file? This makes the zip file much smaller since we already have the dlls. The version you listed is current.

    -Gina
  • Replied 10 September 2017, 10:59 am EST

    Ok,
    sorry I didn't realize that the project i made didn't upload.
    I'm sending it again.
    2016/03/SpreadSheetFormulaLimit.rar
  • Replied 10 September 2017, 10:59 am EST

    Hi,

    I tried running the sample from Visual Studio 2015 and I tried the aspx page in IE. I did not get an error. Are there any special steps we need to use (besides clicking the button at the bottom)? I am not sure if language settings could be an issue. My workstation is set to English (US). I will also ask Reeva to try this.

    Thanks, Gina

  • Replied 10 September 2017, 10:59 am EST

    Hi,
    yes, if I try with the language set to EN-US it does not give me the error, in the sample, in my app it does anyways.
    We work with spanish (Ecuador) language ES-EC or ES-ES.
  • Replied 10 September 2017, 10:59 am EST

    I managed to make it work in my application, setting the app language to en-US.
    Yet I would like to work with spanish language, as US number representation is confusing for our customers.
  • Replied 10 September 2017, 10:59 am EST

    Hello,

    You can try using this workaround and see if it helps. i.e. you can first set the current thread to invariant culture before resuming calc service and then switch back to current culture after resuming calc service.

    Hope it helps.

    Thanks,
    Reeva
  • Replied 10 September 2017, 10:59 am EST

    Hello,
    Thanks for your reply.
    Could you please inform us when you have an estimated date for that fix ?

    In the meantime, do you have any workaround we could use ? (We cannot ask every users to change Culture settings and the way they input numbers)

    We need to fix this rapidly, because downgrading is not an option to us.

    Thanks for update

    Regards


  • Replied 10 September 2017, 10:59 am EST

    Thanks,
    I hope this can be solved asap.
  • Replied 10 September 2017, 10:59 am EST

    Hello,

    We will update you as soon as we will hear from our concerned team.

    Thanks,
    Reeva
  • Replied 10 September 2017, 10:59 am EST

    Hello,
    Some of our users are facing the same issue but with Greek Culture, they use same number formatting as Ecuador ( dot as thousand separator and comma as decimal separtor) .
    Could you please inform us about the progress on this issue ?

    Product version : 9.40.201601

    Thanks

    BR


  • Replied 10 September 2017, 10:59 am EST

    Hello,

    Unfortunately, we don't have any workaround for your issue and also ETA for your issue has not been decided yet.

    I have asked for progress on the bug reported and I will notify you as soon we hear anything from our developers.

    We regret the delay.

    Thanks,
    Reeva
  • Replied 10 September 2017, 10:59 am EST

    Hello,

    We could observe the issue with Greek culture as well and we have updated our bug as well. Unfortunately, we haven't heard back from our developers yet. We have asked for an urgent update on the same at high priority.

    We will update you once we hear anything from them.

    We regret the inconvenience.

    Thanks,
    Reeva
  • Replied 10 September 2017, 10:59 am EST

    Hello,

    Since this workaround doesn't work for you. Hence, you can request the hot fix build fixing your issue from spread.support@grapecity.com with your license key to confirm active subscription status.

    If your subscription would be active, we would then provide you with a hotfix of the same.

    Thanks,
    Reeva
  • Replied 10 September 2017, 10:59 am EST

    Hello,
    Happy new year!

    Unfortunately, we can't use this workaround, because the problem occurs in formula calculation.
    So we aren't able to disable Calc Serivce before it triggers.

    By the way, the same issue exists with French Culture (And I think other Cultures with 'non-dot' decimal separator).

    Thanks for update

    Regards
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels