Weird bug - cells doesn't get calculated

Posted by: itmaor on 18 November 2017, 6:46 am EST

    • Post Options:
    • Link

    Posted 18 November 2017, 6:46 am EST

    I think I came across a weird bug. See example in https://jsfiddle.net/xspg07f7/17/

    In one sheet, [A2] = [A1]+1. In another sheet, [A1]=Sheet1!A2 and [A2]=Sheet1!A1.

    It’s very important to use the same cells in both sheets, A1 and A2 in my example. And it’s important that A2 will point to A1 of the first sheet and A1 to A2 in the first sheet (not A1 to A1).

    Bottom line, when you change [A1] in the first sheet, [A2] doesn’t change and doesn’t get re-calculated even though it’s equal to [A1]+1

  • Posted 19 November 2017, 9:12 pm EST

    Hello,

    I am not able to replicate this issue with the online demo and neither with designer. Please refer to the attached video and let me know if I am missing something.

    Thanks,

    Deepak Sharma

  • Posted 19 November 2017, 11:06 pm EST

    Thanks Deepak, but I don’t see the video attached…

  • Posted 20 November 2017, 5:24 pm EST

    Hello,

    Sorry for missing that one. Here is the attachment.

    Thanks,

    Deepak Sharma

  • Posted 20 November 2017, 5:30 pm EST

  • Posted 20 November 2017, 10:31 pm EST

    Deepak, I understand that it works in the designer, I’m not sure what the differences are between the Designer and the library itself, but when you open the JSFiddle link I sent and update cell [A1], does [A2] change? it doesn’t change when I try though it should.

  • Posted 21 November 2017, 10:59 pm EST

    Hello,

    This is not the designer but the online demo sample here:

    https://www.grapecity.com/en/demos/spread/JS/ExcelMobileSample/

    Please test the issue with this online demo and let me know if you can still recreate this behavior.

    Thanks,

    Deepak Sharma

  • Posted 22 November 2017, 7:29 am EST

    I was not able to reproduce the bug with the online demo sample, but this doesn’t mean it doesn’t exist. It only means it doesn’t exist there. Like I said, I don’t know how the actual library differs from the online sample, but the actual JS library has a bug.

    Would you agree? Am I missing something?

  • Posted 22 November 2017, 10:07 pm EST

    Hello,

    It looks like a bug in Spread 10.1.1, however I am not able to replicate this issue with latest build of Spread.Sheets 10.3.2. Please download the latest build from our website and test the attached sample with the same.

    Thanks,

    Deepak SharmaSpreadJSFormulaAcrossSheet.zip

  • Posted 25 November 2017, 6:17 pm EST

    Thank you!

Need extra support?

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

Learn More

Forum Channels