Replied 6 February 2019, 9:28 am EST
Thanks for the reply. The solution you provide only works for the first time grid populated, but our grid is an editable grid, when we change a cell in the column, the total value is not getting updated.
The use case we have, as you can see from the image below, we have a debit column, the user can type a value into a cell or press a button, when the user press a button we will bring up another modal, and once modal is closed, we show a text 'source from cube' in the cell. That is why the debit column is mixed number and text. also the cell can be empty, and if the cell is empty, I notice the spreadview grid give the value as '', is also a string.
So we are looking for a solution to display total number to sum up the cells has number and skip the cells has text in the column, and the total number will be updated whenever the cell in this column is edited.