search

jspreadsheet / pro

Jspreadsheet Pro | The javascript spreadsheet
https://jspreadsheet.com/
15 stars 1 forks source link

rectifying insertion of some empty row or dummy row #66

Closed RajendraMalya closed 3 years ago

RajendraMalya commented 3 years ago

Is it possible to identify the insertion of any row which is empty or has some specific values without traversing the whole table data.

kind of having flag while inserting such kind of row, so that we can get/set any data whenever we want in that row by using that flag,

any suggestions ?

hodeware commented 3 years ago

You have onbeforeinsertrow and oninsertrow that be used.

hodeware commented 3 years ago

onbeforeinsertrow, if you return false... that will block a new row to be added.

RajendraMalya commented 3 years ago

onbeforeinsertrow, if you return false... that will block a new row to be added.

thats fine. But i need to understand where my new row is inserted... like after which row it is inserted. Because i might be keep adding rows.

in one shot i need to get all inserted rows.

ex: Given data: [1,2,3,4,6,7,9]

if i inserted 5,8 then [1,2,5,3,4,6,7,8,9]

Now in need to understand in which position i have inserted 5 and 8.

hodeware commented 3 years ago

You can find those informations on your event as below: https://jspreadsheet.com/v7/docs/events

onbeforeinsertrow | onbeforeinsertrow(DOMElement el, Number rowNumber, Number numOfRows, Boolean insertBefore)Before a new row is inserted. You can cancel the insert event by returning false. -- | -- oninsertrow | oninsertrow(DOMElement el, Number rowNumber, Number numOfRows, Boolean insertBefore)After a new row is inserted.