How to disable resize handles on the highlighted chart data cell range?

How to disable resize handles on the highlighted chart data cell range?

Posted by: asarkar on 26 November 2018, 2:26 pm EST

• 

  asarkar

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 November 2018, 2:26 pm EST - Updated 3 October 2022, 11:03 am EST

  When you click on plotted chart data, the associated cell range of the data is highlighted with colorful selection borders. The problem is that these selections come with resize handles that allow the user to dynamically change the cell range of the chart data that is plotted.

  But when you click on the general chart area, you get the same colorful highlights without the resize handles.

  How can we disable these resize handles but still keep the colorful selection to show the user the associated cell range?

  

  1105×834 50.1 KB

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 27 November 2018, 10:35 am EST

  Hello,

  Could you please provide us more details about your use case, why do you want to disable the resize handles?

  Thanks,
  
  Deepak Sharma

• 

  asarkar

  • Post Options:
  • Link
    Copy

  Posted 27 November 2018, 3:09 pm EST

  When a user does not have access to edit the document rendered by spread.sheets. We must allow the user to see which cell ranges are plotted by the chart but cannot allow them to change the chart itself.

  Note: disabling the ability to interact with parts of the grid would not be a plausible solution as there are features that require selection of cells and floating objects. The features allow the user to see more information on the selection but not edit the selection.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 28 November 2018, 5:47 am EST

  Hello,

  We investigated your issue but we couldn’t find any way to disable resizing of series selection. Even locking cell range didn’t work. Hence, we are escalating your issue to the concerned team for further investigation. We will get back to you as soon as we hear anything from them.

  Tracking id for your issue is #267746

  Thanks,
  
  Reeva

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 28 November 2018, 6:40 am EST

  Hello,

  Our developers have confirmed that we don’t support this feature as of now and we have added it to our product backlog as it needs API changes to control whether the user could change the chart series range or not.

  We may consider this feature in the future version but we don’t have any ETA as of now, neither we have any workaround for the same.

  Thanks,
  
  Reeva