Posted 3 November 2020, 10:14 pm ESTi am using license version in angular v10. Is there a way to add sum footer in excel sheet for column base on condition. Also that row should always be visible(sticky) (during scrolling).It would be good if you provide some demo or example.
how to add footer row for sum of column base on condition
Posted by: jekin.desai on 3 November 2020, 10:14 pm EST
Replied 4 November 2020, 9:00 pm ESTImportant is, if is apply filter on that column or change the cell value then SUM should be updated.
Is there a way to apply formula to cell for an entire column like SUM(A1:A5) without specifying column alphabet name 'A', else i have to dynamically generate alphabet of specific column to apply formula
Replied 4 November 2020, 9:23 pm ESTHi Jekin,
You may use the frozenTrailingRowCount() method to freeze rows at the bottom. We are sorry but formulas in SJS works like MS Excel so you need to use the column letter in the formula, to get the column letter from its index, you may use the CalcEngine.rangeToFormula() method. Please refer to the following sample which demonstrates the required functionality:
Replied 4 November 2020, 9:28 pm ESTWhat about on applying filter on column,the SUM() should change, right now it is not.
Replied 4 November 2020, 10:28 pm ESTok, Thank you!