tableOverflow:true Editing problems occur

[cuiyushuang]

After setting Horizontal Overflow Hiding, edit the last column and type that the first character is not recognized
Only the second and subsequent characters are recognized

[GBonnaire]

Hi,

After check on v4.6.1 it work fine.

Can you make a jsFiddle with problem ?

[cuiyushuang]

https://bossanova.uk/jspreadsheet/v4/examples/table-overflow
Edit the cell while the cell is not fully displayed (the part that is obscured by the scroll bar). When the first character is entered, the scroll bar will scroll, and the cell is fully displayed, and the first character will be lost

If the occluded cell had been able to scroll completely to the visible area when the cell was first clicked, this problem would not have occurred. Now the scroll bar does not scroll until a character is entered

[GBonnaire]

Hi,

Ok i have reproduct.

In this case, when you start editing cell, scroll position is updated and when position is updated, current cell editor is close. If you type 1 letter, you show this behavior. You have too this behavior for all column not totaly showed.

this behavior is present on scrollControls function.

The problem is, when you have start editor, and user scroll, the editor must close. I think, a solution is call updateScroll on click on cell

[GBonnaire]

Try to add that for test

jspreadsheet(DOMEl, {
    onevent: function(e) {
       if(e=="onselection") {
           var el = arguments[0];
           el.jspreadsheet.updateScroll();
       }
    }
});

[olaviinha]

I'm not sure if this is directly related, but I am also having a problem with the last column and first character when tableOverflow: true. I also have allowInsertColumn: false.

I want tableOverflow: true, but for some reason last column starts to behave strangely. It will update on keydown, rather than having the editor mode until I'm done editing the cell. Thus, it behaves incorrectly as if accepting a single character as value.

Please observe in this vid. Only change is tableOverflow false vs. true:

[GBonnaire]

Could you create JS fiddle with this behavior ?

And indicate your browser ? please

on https://bossanova.uk/jspreadsheet/v4/examples/table-overflow it work fine (Chome navigator)

[olaviinha]

Actually I'm finding it difficult to replicate this myself, and this may be a false alarm. I'm not witnessing this behaviour when I setup similar jspreadsheet table in a standalone html file with nothing else in it. In this example the table is inside a modal. It is likely caused by something else, yet to be figured out what... Strange though that the behaviour is triggered by tableOverflow: true.

[GBonnaire]

tableOverflow change style et some other behavior.

On pro version, is work much better with another system. Try it.

[olaviinha]

FYI: it was caused by custom CSS paddings in .jexcel_content tbody tr td.editor

✅ Works:

.jexcel_content tbody tr td.editor {
  padding-left: 2px;
}

❌ Breaks editor in last column (with tableOverflow: true):

.jexcel_content tbody tr td.editor {
  padding-left: 3px;
}