Negative number with comma

Negative number with comma

Posted by: chander.pal on 4 October 2023, 3:58 am EST

• 

  chander.pal

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 October 2023, 3:58 am EST - Updated 5 October 2023, 1:40 am EST

  Hi,
  
  while i enter negative number like -1,000 it gives me #VALUE! on spreadjs, but in my case when i type comma(,) it prints semicolon( ; ) in numeric column and still gives me #VALUE!. we are using spreadjs 16.2. (i think it is considering as formula when we start writing with - minus)

  Anything you can help me on this ASAP.

  

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 5 October 2023, 3:06 am EST

  Hi,

  We are able to replicate the issue on our end when the value “-1,000” is entered and gives a “#VALUE!” error. Hence, we have escalated this issue to the dev team for further investigation. The internal tracking ID for this issue is: SJS-20439. We will keep you updated on the progress of the issue.

  As a workaround, you can add an event listener to the UserFormulaEntered event and get the entered formula. You can modify the entered formula(if it gives a #VALUE! error) and set it again in the sheet.

  Please refer to the attached sample for more understanding.

  sample: https://jscodemine.grapecity.com/share/M00-_qKIRke07tvHTQ7Evw/?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"%2Fsrc%2Fapp.js"}

  Referring to the other question, when you press/type comma(“,”) then a semicolon(“;”) is entered.

  We are not able to replicate this behavior on our end. It may be because you are using a different culture in your SpreadJS. If you are also facing an issue related to this, please let us know. Also, provide us with a minimal sample that replicates the issue. You may modify the attached sample and share it with us.

  References:

  UserFormulaEntered event: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Events#userformulaentered

  Regards,
  
  Chandan

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 14 November 2023, 6:38 am EST

  Hi,

  The mentioned issue has been fixed in SpreadJS v16.2.6. You may download the SpreadJS v16.2.6(latest) from the below link.

  Download link: http://cdn.mescius.com/spreadjs/16.2.6/Files/SpreadJS.Release.16.2.6.zip

  Regards