Define name not work in SpreadJS

Define name not work in SpreadJS

Posted by: thanh.minh.le on 24 March 2023, 5:30 am EST

• 

  thanh.minh.le

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 March 2023, 5:30 am EST

  Hi,
  
  Currently I’m having a problem with the Define Name feature. When I set Define Name for a cell by right-clicking on that cell and selecting Define Name and then entering a name for it. Then when I choose that cell again, the Name Box does not show the name that I have set.
  
  So I want to ask if is there any event or option related to this issue?
  
  Regards,
  
  Thanh

• 

  thanh.minh.le

  • Post Options:
  • Link
    Copy

  Posted 27 March 2023, 4:36 am EST

  FYI: We are using SpreadJS 14.0.4

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 27 March 2023, 11:10 pm EST

  Hello Thanh,

  Please note that when you click on “Define Name…” option from the context menu, it is meant to add a new name. That is why, the new name dialog box does not contain other name which may be already available on the selected cell range.

  If you want to see the already available name on a cell range, you may open the edit name dialog box from the name manager in the formula tab. This is the same behavior as compared to Microsoft Excel.

  Regards,

  Ankit

• 

  thanh.minh.le

  • Post Options:
  • Link
    Copy

  Posted 27 March 2023, 11:14 pm EST - Updated 27 March 2023, 11:19 pm EST

  Hi, thanks for your reply. May I ask if SpreadJS v 14.0.4 support shows the name I have set here
  
  

  

  1175×842 27.4 KB

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 28 March 2023, 5:11 am EST

  Hello,

  Thanks for providing us with an image that shows the issue. We were able to replicate the issue on our end in SpreadJS v14.0.4. However, we would like to inform you that this issue has been fixed in SpreadJS v14.2.0 and all SpreadJS versions after v14.2.0.

  You can update your current SpreadJS version(v14.0.4) to v14.2.0 to resolve this issue.

  Please let us know if you still face any issues.

  Regards,

  Avinash