Formulas EXCEL like functionality

Formulas EXCEL like functionality

Posted by: sergey_chizhik on 25 January 2022, 5:09 am EST

• 

  sergey_chizhik

  • Post Options:
  • Link
    Copy

  Posted 25 January 2022, 5:09 am EST

  Hi Support,
  
  Do we have some way to insert formulas like in the attached video?

  If we selected a formula from the list and the next click in the other cell should past cell name into formula expression.

  Answer from should be like:

  • we support that feature and example how to enable
  • we don’t support that behavior

  Best regards,
  
  Serhi

• 

  sergey_chizhik

  • Post Options:
  • Link
    Copy

  Posted 25 January 2022, 5:10 am EST

  example.zip

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 27 January 2022, 10:11 am EST

  Hello,

  Yes, we have another product named SpreadJS which provides most of the Excel features. Your requirement to add excel-like formula can be fulfilled by the product. You can verify it from the below-shared link:

  SpreadJS designer: https://www.grapecity.com/spreadjs/designer/index.html

  Please refer to the following links for more information on spreadJs:

  https://www.grapecity.com/en/spreadjs#

  SpreadJS demo: https://www.grapecity.com/spreadjs/demos/

  SpreadJS Doc: https://www.grapecity.com/spreadjs/docs/v14/online/overview.html

  If you have any further queries related to SpreadJs, please report at the following URLs:
  
  SpreadJs Forum: https://www.grapecity.com/en/forums/spread-sheets

  Regards

• 

  sergey_chizhik

  • Post Options:
  • Link
    Copy

  Posted 28 January 2022, 4:55 am EST

  Hi support,
  
  thanks for that information, really helpful, however, we have some question.
  
  Does Component One Enterprise developer license provide use of spreadjs or spread.net?

  Regards,
  
  Serhii

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 1 February 2022, 3:26 am EST

  Hello,

  No, you would be required to purchase a separate license for SpreadJs or Spread.net. You can contact the sales team on us.sales@grapecity.com to purchase the licenses.

  You can refer to the below links for reference:

  Spread.net: https://www.grapecity.com/spreadnet/pricing
  
  Spread.net Demo: https://www.grapecity.com/spreadnet/demos

  SpreadJs: https://www.grapecity.com/spreadjs/pricing
  
  SpreadJs Demo: https://www.grapecity.com/spreadjs/demos/

  Regards