WjFlexSheet.applyCellsStyle CellRange - not working without a full refresh

WjFlexSheet.applyCellsStyle CellRange - not working without a full refresh

Posted by: radu.moldovean on 12 November 2017, 10:49 pm EST

• 

  radu.moldovean

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 November 2017, 10:49 pm EST

  Hi,

  I have a question regarding WjFlexSheet.applyCellsStyle.

  When I am using ‘applyCellsStyle’ with the ‘cells?: CellRange’ parameter, the styles are not applied unless I am calling the refreshCells method.

  But if I am not using the ‘cells?: CellRange’ parameter (leaving it empty) and using the current selection then the style changes are applied without using the refreshCells() method.

  I don’t want to refresh the whole grid every time I change the styles for some cells, it has a huge performance impact on the application. Can somebody tell me what is the proper way to change the style for a custom cell range without having to refresh the whole grid?

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 13 November 2017, 8:31 pm EST

  Hi,
  
  Thank you for notifying this.
  
  We have forwarded this issue to the concerned team for further investigation with tracking id 296957.

  We will let you know as we get any update on this.

  ~Manish

• 

  radu.moldovean

  • Post Options:
  • Link
    Copy

  Posted 16 November 2017, 11:36 pm EST

  Hi Manish,

  Thank you for your response. Is there an issue tracker where I can follow 296957?

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 19 November 2017, 9:04 pm EST

  Hi,
  
  The id provided is an internal tracking id that is used to track the issue by support team.

  ~Manish

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 5 January 2018, 11:13 pm EST

  HI,

  There may be some cases where we would like to invoke the ‘applyCellsStyle’ method serveral time to apply different styles for different cells.

  If the FlexSheet is refreshed every time the the ‘applyCellsStyle’ method is invoked, it will cause a huge performance impact for FlexSheet.

  So ‘applyCellsStyle’ method call with CellRange won’t refresh the FlexSheet.

  If you wants to the FlexSheet refreshed after the ‘applyCellsStyle’ method call, user may push the apply cells style processing between FlexSheet.beginUpdate and FlexSheet.endUpdate.

  The code snippet as following:

  flexSheet.beginUpdate();
  
  flexSheet.applyCellsStyle(...);
  
  ...
  
  flexSheet.applyCellsStyle(...);
  
  flexSheet.endUpdate();
  
  

  Please check the attached sample.

  ~ManishFlexSheetApplyCellStyle.zip