Name Manager culture issue

Name Manager culture issue

Posted by: grapecity on 29 September 2023, 2:20 am EST

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 29 September 2023, 2:20 am EST - Updated 29 September 2023, 2:31 am EST

  Hello,

  I am using the SpreadJS designer component for React and have an issue about the culture in the Name Manager.

  I actually have a culture issue. A formula work in English Canada culture but doesn’t work in French Canada. The issue in the “,” in not change in “;” in the name manager but correctly handled in the cell

  Please refer to the attached pic

  Here a formula in a cell with culture set up in english - Canada (en-CA)
  
  The , has a separator.
  
  

  

  842×36 2.7 KB

  Here a formula in a cell with culture set up in french - Canada (fr-CA)
  
  The ; as a separator.
  
  

  

  837×31 2.62 KB

  The culture for the formula is correctly handle in the cell. We can see the change from ",’ to “;”.

  For the name manager, this is a little bit different.
  
  Here a formula in the name manager with culture set up in english - Canada (en-CA)
  
  The , has a separator.
  
  

  

  1076×27 2.19 KB

  Here a formula in the name manager with culture set up in french - Canada (fr-CA)
  
  The , has a separator (need to be a ; (semicolon)).
  
  

  

  1057×27 6.21 KB

  In this case, the formula is not changed as in the case of formulas in cells.
  
  The “,” (comma) remains and is not replaced by the “;” (semicolon).

  Is there a way to handle this case correctly in the name manager?

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 2 October 2023, 11:30 pm EST

  Hello,

  As I can understand, you are saying that “;”(semi-colon) is not used as a list separator in the formulas in the name manager of the designer component when the culture is “fr-CA”.

  We are able to replicate this issue on our end. Hence, we have escalated this issue to the dev team for further investigation. The internal tracking ID for this issue is: SJS-20436. Please be rest assured that we will keep you updated on the progress of the issue.

  Regards,
  
  Chandan

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 3 October 2023, 3:18 am EST

  Hi Chandan,

  Thanks for your answer.

  I wanted to know if you have a resolution deadline to give us and if the issue will be resolved quickly?

  If not, do you have a workaround while waiting for the issue to be fixed?

  Best regards.

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 3 October 2023, 11:46 pm EST

  Hello,

  Currently, there is no ETA for this issue. We will continue to update you on the progress of the issue.

  As a workaround, you can override the “nameManager” command. When the name manager option is clicked in the designer ribbon, the “nameManager” command is executed which opens the name manager.

  When the name manager is opened, you can get the Workbook and Worksheet instance used in the name manager to show the names and accordingly change the formula string shown for different names.

  Please refer to the attached sample for more understanding.

  sample: https://jscodemine.grapecity.com/share/SNE3hH1VnEOVPn8zhkuJVg/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.jsx"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.jsx"}

  Please let us know if the issue still persists.

  References:

  GC.Spread.Sheets.Designer.getCommand(): https://www.grapecity.com/spreadjs/api/designer/modules/GC.Spread.Sheets.Designer#getcommand
  
  NameManager command: https://www.grapecity.com/spreadjs/api/designer/classes/GC.Spread.Sheets.Designer.CommandNames#namemanager

  Regards