Sorting does not work in protected sheet

Sorting does not work in protected sheet

Posted by: trankhanhngan00 on 16 April 2024, 12:55 am EST

• 

  trankhanhngan00

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 April 2024, 12:55 am EST - Updated 16 April 2024, 1:00 am EST

  Hi team,

  I face this problem when using Spreadjs Designer: After protecting a sheet (allow sorting), sorting does not work, both from filter buttons or from ribbons.
  
  Could you help me with that?
  
  Thank you!
  
  

  

  1585×741 87 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 17 April 2024, 3:00 am EST

  Hi Ngan,

  The mentioned behavior is expected and aligns with the Microsoft Excel’s behavior. Try performing the same operation in Microsoft Excel and you will get the same result.

  Please consider the following two points:

  1. When the sheet is protected, the filter dialog won’t open if you set the “allowSort” to true (i.e, check the “Sort” option). The filter dialog won’t open both for Locked Cells and also for Unlocked cells.

  2.You could perform the sorting only on the Unlocked Cells, both from the Context Menu and also from the Ribbon Tab.

  These two behaviors aligns with Microsoft Excel.

  I have created a sample for you so that you could understand better. Refer to the following sample: https://jscodemine.mescius.io/share/fDWPdbCZWUOZg03N8XxFww/?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["%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  I hope that clarifies your query. Let me know if you still have any doubts. You could also refer to the following docs on understanding Locked and Unlocked Cells: https://developer.mescius.com/spreadjs/docs/features/worksheet/celllock#enablenbspprotection-optionsnbspin-a-locked-worksheet

  Regards,

  Ankit

• 

  trankhanhngan00

  • Post Options:
  • Link
    Copy

  Posted 17 April 2024, 3:37 am EST

  Hi Ankit,
  
  Thanks for your explaination!