Cell becomes empty after switching sheets while editing a formula

Cell becomes empty after switching sheets while editing a formula

Posted by: sebastian on 16 May 2022, 8:40 am EST

• 

  sebastian

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 May 2022, 8:40 am EST

  See this codesandbox for reproduction:

  https://codesandbox.io/s/spreadjs-sheet-referencing-bug-v06sqx?file=/src/App.js

  Steps to reproduce:

  1. Make sure you have at least 2 sheets
  2. Add some values to both sheets to reference them in a formula
  3. Start creating a formula in one sheet (```
     
     =SUM(

  4. Take one value from the current sheet and one from another; don’t close the formula yet
  5. Go back to the original sheet (the one you’re editing the formula in) and [b]observe the active cell is empty, and does not have the blue outline[/b]. 
  The value in the address bar is visible however. The formula can still be closed by hitting enter.

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 16 May 2022, 12:38 pm EST

  Hi Sebastian,

  We were able to replicate the issue at our end with the SpreadJS Version 14.2.5(as the version in the shared sample). However, this issue has been fixed in the latest version of SpreadJS. Please upgrade to the latest version(V15.0.7).

  SpreadJS Designer(V15.0.7): https://www.grapecity.com/spreadjs/designer/index.html

  Regards

  Ankit

• 

  sebastian

  • Post Options:
  • Link
    Copy

  Posted 16 May 2022, 3:42 pm EST

  Trying to upgrade.

  Facing the issue, where

  spreadJSInstance.commandManager()

  returns undefined in v15, in contrast to the command manager object in v14.

  Am I doing something wrong?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 17 May 2022, 12:08 am EST

  Hi Sebastian,

  We were unable to replicate the issue at our end. We tested with the latest version of SpreadJS(V15.0.7) and it seems to be working fine at our end. There might be some issue with your current programming logic.

  For example, you can refer to the following sample that we have used for testing: https://jscodemine.grapecity.com/share/9iTLvtPDL0_FQNxe0wGlsw/

  If the issue still persists for you, we request you to please share a working sample and the steps you are performing so that we can investigate it at our end and assist you accordingly.

  Regards

  Ankit

• 

  sebastian

  • Post Options:
  • Link
    Copy

  Posted 17 May 2022, 6:42 am EST

  Thank you, the license key turned out to be an issue