Can't edit drop down after creation

Can't edit drop down after creation

Posted by: brian.ploe on 20 February 2024, 4:53 pm EST

• 

  brian.ploe

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 February 2024, 4:53 pm EST - Updated 20 February 2024, 4:58 pm EST

  I am using the installed spreadJS designer and I can’t get a drop down into edit mode.
  
  If you look at the screenshot the app is detecting it as a shape and not a drop down.
  
  The drop down is functional otherwise in that I can open it and select an item.
  
  The drop down was added via the spreadjs editor. Please help!

  

  1469×730 115 KB

• 

  brian.ploe

  • Post Options:
  • Link
    Copy

  Posted 20 February 2024, 5:02 pm EST

  Oh hey, it is a shape after all. And it has a range assigned to it.
  
  I was confused, sorry! All good here! If only I can remember this for next time now.

• 

  brian.ploe

  • Post Options:
  • Link
    Copy

  Posted 20 February 2024, 5:37 pm EST

  I see why I was confused now.
  
  The drop down is added as a “Form Control” in the designer. But once you add it you can only access its properties as a shape. Weird!

  Now to figure out how to extract the current value from it and not just the selected index…

• 

  brian.ploe

  • Post Options:
  • Link
    Copy

  Posted 20 February 2024, 6:37 pm EST

  Can anyone educate me on how the ListBox shape can be used?
  
  All I can get from it is a selected index and not the actual value of the item that is actually selected.
  
  The selected index is the only thing returned whether I use a linked cell or javascript to access the shape.
  
  It seems very limited in use.

  The reason I chose this over a dropdown cell type is that I needed to be able to specify the source cells to populate it in the sheet itself and not using javascript.

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 21 February 2024, 7:54 am EST

  Hi,

  Currently, there is no direct API available to retrieve the selected index value of a listBox form control.
  
  However, you can achieve this by using the “formulaToRanges” method. This method converts cell references to ranges. With these ranges, you can obtain the coordinates of the cells and then use the “getValue” method to retrieve the cell value. Refer below snippet.

  const selectedIndex = args.shape.value();
          const inputRange = GC.Spread.Sheets.CalcEngine.formulaToRanges(args.sheet, args.shape.options().inputRange, 0, 0);
  
          const selectedValue = args.sheet.getValue(inputRange[0].ranges[0].row + selectedIndex - 1, inputRange[0].ranges[0].col);
  
          console.log(selectedValue)

  Sample: https://jscodemine.grapecity.com/share/f-2uaOtJqUStDRLGio1ehA/?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.js"]%2C"ActiveFile"%3A"%2Findex.html"}

  References:

  formulaToRanges: https://developer.mescius.com/spreadjs/api/v16/modules/GC.Spread.Sheets.CalcEngine#formulatoranges

  getValue: https://developer.mescius.com/spreadjs/api/v17/classes/GC.Spread.Sheets.Worksheet#getvalue

  Regards,

  Priyam

• 

  brian.ploe

  • Post Options:
  • Link
    Copy

  Posted 21 February 2024, 11:29 am EST

  That helps, thanks!