Missing single quotes while creating CustomNames

Missing single quotes while creating CustomNames

Posted by: rlescano on 8 January 2018, 1:34 am EST

• 

  rlescano

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 January 2018, 1:34 am EST

  Hello,
  
  When creating a CustomName in a sheet with exclamation mark as a name I have to escape the name of the sheet in single quotes and the CustomName is correctly being added.
  
  But the problem is that when I use the function:
  
  function expressionToFormula(context: Object, expression: GC.Spread.CalcEngine.Expression, baseRow?: number, baseColumn?: number, useR1C1?: boolean): string;
  
  
  
  the formula returned is missing the single quotes.
  
  

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 10 January 2018, 1:21 am EST

  Hello,

  I tested this issue with SpreadJS v11.0 and found getExpression() working correctly with single quotes. Please refer to the attached image and sample app.

  Thanks,
  
  Deepak SharmaSpreadExpressionFromFormula.zip