Formulas not working when rows are filtered AND collapsed

Formulas not working when rows are filtered AND collapsed

Posted by: gabriel.bermudez on 14 February 2018, 10:50 am EST

• 

  gabriel.bermudez

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 February 2018, 10:50 am EST

  When I collapsed a section sheet that has filtered rows the subtotal function at the header of the parent I just collapsed equals a 0. It only happens when the rows are filtered AND collapsed. If they’re collapsed and I remove the filter the subtotal gets fixed. See attachments below. How do I make the formulas work properly?

  The formulas are in the form of SUBTOTAL(9, Range).
  
  

• 

  gabriel.bermudez

  • Post Options:
  • Link
    Copy

  Posted 14 February 2018, 11:03 am EST

  Sorry, this is the correct screenshot of the formula giving a zero as a result when it is collapsed AND filtered.
  
  

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 15 February 2018, 11:40 am EST

  Hello,

  I am not able to replicate this issue when I tried with the online demo:
  
  https://www.grapecity.com/en/demos/spread/JS/InspectorSample/

  Here are the steps that I followed:

  1. Go to Data Sheet
  2. Select the sheet and apply filter to all Columns( from Data tab).
  3. Select rows 3 to 10 and apply grouping
  4. In Column F apply SUm formula in Row 11.
  5. Collapse and apply filter by deselecting multiple values.
  6. The formula does not change the result based on filtering.

  Please refer to the attached image.

  In case the issue still persists, please provide me the steps/sample to debug further.

  Thanks,
  
  Deepak Sharma