Footer descriptions: selection & string

Footer descriptions: selection & string

Posted by: fsegui on 19 December 2021, 5:55 pm EST

• 

  fsegui

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 19 December 2021, 5:55 pm EST

  Hi,
  
  I’m trying to make footer descriptions for twe cases:

  • update footers based on rows selected (and not on all rows visible)
  • make sum on a specific column that is string typed (not double typed). in this case, I only want to make the sum of all numeric values
    
    Is this possible? Maybe with the ownerdraw cell event?
    
    Thanks
• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 20 December 2021, 7:13 am EST

  Hi,

  You can add an empty footer row in the grid and use the SelChange event of the C1FlexGrid to calculate the aggregates based on only Selected rows. Then, you use the OwnerDrawCell event to set the e.Text property for the footer row cells according to the calculated aggregates. You can manually perform the calculations for the string column containing the numeric values.
  
  Kindly refer to the attached sample showing the same.

  Please let us know if you need any other information.
  
  Regards,
  
  Avnish

  CustomFooters_FG.zip

• 

  fsegui

  • Post Options:
  • Link
    Copy

  Posted 20 December 2021, 10:18 am EST

  Hi Avnish,

  Perfect!
  
  Works fine.

  Thanks