Issue In Handsontable

Tags: #<Tag:0x00007efc6151a2c0>
#1

Hi,

I am trying to use handsontable but getting issue in reference js provided by you in free pro version as by adding row to handsontable by using alter insert_row method row is added but formula for the respective cell in bellowed as it is total of the column was not updated after insert event. & also want to use functionality for hiding rows, disabling the rows,want to format cells as $ for the currency value but seem’s its not working properly in given version don’t know why. Please help in this regard as soon as possible or give us a stable version which provide all this functionality in one go.

Thank’s

#2

Hi @pavan.bhavsar

I’d be happy to help.

Please provide your Handsontable settings (ideally in the JSFiddle) if the situation I’ve described is not the same as you got.

As I understand you’re using columnSummary and you get false results while using the insert_row option?

I’ve made a demo: http://jsfiddle.net/wg6q673h/
In which when we add the ‘row above’ by clicking the selected row

we get the summary calculations shifted and an extra calculations in the new row

In this case at the first glance it might look like a bug but after looking into settings

 columnSummary: [
      {
        destinationRow: 4,
        destinationColumn: 1,
        type: 'min'
      },
      {
        destinationRow: 0,
        destinationColumn: 3,
        reversedRowCoords: true,
        type: 'max'
      },
      {
        destinationRow: 4,
        destinationColumn: 5,
        type: 'sum',
        forceNumeric: true
      }
    ]

we will see that the calculations made in column with indexes 1 and 5 have a fixed row destination at 4 row and the max formula is added to the last row which is dynamically set via this settings:

destinationRow: 0,
reversedRowCoords: true,
#3