How to Move view of a cell to the specified position that is not in viewport?

How to Move view of a cell to the specified position that is not in viewport?

Posted by: rishmitha.aita on 29 August 2022, 5:24 am EST

• 

  rishmitha.aita

  • Post Options:
  • Link
    Copy

  Posted 29 August 2022, 5:24 am EST

  By using showCell we can only move the view of a cell to the specified position in the “viewport”.
  
  What should we do to move to a cell which is not in the viewport?

• 

  rishmitha.aita

  • Post Options:
  • Link
    Copy

  Posted 30 August 2022, 5:28 am EST

  Hello @Avinash
  
  Thanks for replying.
  
  I have checked showCell now it’s working fine. But the scrollbar is not moving to the activated cell.

  Below is my code.
  
  Ex: let sheet = spread.getActiveSheet()
  
  sheet.setActiveCell(r1,c1)
  
  sheet.showCell(r1,c1,GC.Spread.Sheets.VerticalPosition.top, GC.Spread.Sheets.HorizontalPosition.left)
  
  For this code, the cell pointer is at the given index but the scrollbar is not scrolling to that index, so the active cell is not shown in the viewport.

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 30 August 2022, 6:57 am EST - Updated 3 October 2022, 9:04 am EST

  HI
  
  We are still unable to replciate the issue at our end the scrollbar move whenever we call the showCell method.

  Could you please refer to the following gif and if the issue persists Please share a working sample that replicates the problem so that we could investigate it further and help you accordingly.

  regards,
  
  Avinash

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 30 August 2022, 6:58 am EST - Updated 3 October 2022, 9:04 am EST

  Hi,

  We are sorry but on our end showCell, the method is working fine.

  Could you please refer to the following gif and if the issue persists Please share a working sample that replicates the problem so that we could investigate it further and help you accordingly.

  regards,
  
  Avinash

• 

  rishmitha.aita

  • Post Options:
  • Link
    Copy

  Posted 1 September 2022, 3:50 am EST

  @Avinash Thank you it’s working fine now. I got a problem as the showCell method got overridden by another methos

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 1 September 2022, 5:06 am EST

  Hi,

  Could you please share a sample project that replicates the issue so that we could investigate it further and help you accordingly?

  Regards,
  
  Avinash

• 

  rishmitha.aita

  • Post Options:
  • Link
    Copy

  Posted 1 September 2022, 8:45 am EST

  I mean one showCell method overridden other showCell method

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 2 September 2022, 5:38 am EST

  Hi,

  We are sorry but we are unable to replicate this issue. It would be better if you could provide a sample application that replicates the issue so that we could investigate it further and help you accordingly.

  Regards,
  
  Avinash