Sync VLOOKUP function/feature with bootstrap modal

Sync VLOOKUP function/feature with bootstrap modal

Posted by: jerome on 17 April 2020, 12:28 pm EST

• 

  jerome

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 17 April 2020, 12:28 pm EST - Updated 3 October 2022, 10:25 am EST

  Hi, I am replicating some features of excel and one of this is the VLOOKUP. I am using modal to imitate the VLOOKUP function of MS Excel. During development (using ReactJs), I ran into some challenges. I wasn’t able to sync the spreadsheet while navigating on modal.

  

  1920×913 194 KB

  

  1920×914 200 KB

  After selecting the VLOOKUP on the dropdown, a modal will popup.

  

  1920×913 206 KB

  Then user will select on spreadsheet which value to set on Lookup_Value (on modal). Here you can see that the 1st selected cell is now out of focus or inactive.

  

  1920×913 211 KB

  

  1920×912 211 KB

  Same here when user is selecting for the Table_Array value.

  

  1920×916 227 KB

  Is there any possible way or workaround that you may suggest to sync the spreadsheet’s VLOOKUP function with bootstrap modal? Your kind assistance would be graciously accepted. Thanks in advance.

• 

  jerome

  • Post Options:
  • Link
    Copy

  Posted 20 April 2020, 9:50 am EST - Updated 3 October 2022, 10:25 am EST

  This VLOOKUP function is what I need to replicate.
  
  

  

  1280×720 163 KB

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 20 April 2020, 10:52 am EST

  Hi Jerome,

  You may use the FormulaTextBox in range select mode to achieve the required functionality. Please refer to the following code snippet and the sample demonstrating the same:

  var rangeValueFormulaBar = new GC.Spread.Sheets.FormulaTextBox.FormulaTextBox(
    document.getElementById("rangeValueFormulaBar"),
    { rangeSelectMode: true }
  );
  rangeValueFormulaBar.workkkbook(WorkBookObj);
  

  https://codesandbox.io/s/stoic-robinson-f4elb?file=/index.html

  API Reference:
  
  • FormulaTextBox class: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.FormulaTextBox.FormulaTextBox.html

  Regards
  
  Sharad

• 

  jerome

  • Post Options:
  • Link
    Copy

  Posted 20 April 2020, 12:24 pm EST

  This exactly what I need. This is great! Will try it first. BTW, can I ask for a new license trial key? We are still in development and only have 1 more day before it expires. Thanks in advance.