Bad Custom Name Tracking - Pasting to new sheet from A1

Bad Custom Name Tracking - Pasting to new sheet from A1

Posted by: emcpoland on 10 November 2025, 10:57 pm EST

• 

  emcpoland

  • Post Options:
  • Link
    Copy

  Posted 10 November 2025, 10:57 pm EST

  There is a bug in the latest SpreadJS (v18.2.4). Which if you add a custom name to the top left region of a sheet, then cut and paste it into another sheet not in the same position it returns the row/col as negated.

  This only occurs when cutting from A1 in one sheet to another sheet (not A1, as -0 == 0).

  Ive provided a video of it. There was a similar issue that was corrected in v17.0.1 which occurred when pasting from A1, and then back to A1. In which case the row/col doubled. This appears to have been corrected by checking if the transform/move was a custom name inside of _getOriginRange, and skipping the adjustment code.

  In a similar vein I resolved this issue that I am reporting, by making adjustments to

  adjustCellExpressionOnMove 

  . There is a check for

  isNameID

  . However in this case it is not set, instead the property is attached as a different name. So I simply made a check for both and it appears to be working well.

• 

  emcpoland

  • Post Options:
  • Link
    Copy

  Posted 10 November 2025, 11:01 pm EST

  I have attached a video and a example html file.

  BadCustomNameTracking.zip

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 11 November 2025, 2:13 am EST

  Hi Emmet,

  Apologies for the inconvenience caused.

  We can replicate the behavior you mentioned on our end. We have escalated this matter with the concerned development team and will update you as soon as we get any information from their end.

  Internal Tracking ID: SJS-32248

  Kind Regards,
  
  Chirag