jspreadsheet / pro

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

Bottom rows now showing #330

Closed ryouchi84 closed 2 months ago

ryouchi84 commented 3 months ago

Hi,

During our testing phase we encountered a strange behavioral issue from the jspreadsheet grid. We noticed that the last 3 lines of the grid are not displaying and there is an empty grey space between the end of the displayed table and the bottom on the view port.

x

The lines tagged Total Cover TY, Total Cover Plan and Total Cover LY were not showing regardless of how much I was scrolling down. AT the moment we fudged it a little by adding 3 blank lines at the bottom of the sheet but there is also the gray area which is not hiding anything (inspecting the code, I saw that the table is offset to a top of -95px to -115px based on scroll).

The code table build looks like this:

jspreadsheet(Builder.divElement, { allowDeleteWorksheet: false, allowRenameWorksheet: false, allowMoveWorksheet: false, worksheets: [ { minDimensions: [Builder.metaData.columns.length, Builder.metaData.rows.length], worksheetName: "WSSI", tableOverflow: true, tableWidth: windowWidth, tableHeight: windowHeight } ], onbeforechange: EffectEngine.events.onBeforeChange, onbeforepaste: EffectEngine.events.onBeforePaste, oncopy: EffectEngine.events.onCopy, onselection: EffectEngine.events.onSelection, onundo: EffectEngine.events.onUndo, contextMenu: Builder.contextMenu.getMenu });

And is has a freeze panes applied to it: 2 columns on the left and 3 rows from the top.

hodeware commented 3 months ago

Can you kindly share a codesandbox and steps to replicate the issue.

hodeware commented 2 months ago

If you need further assistence, please send a message to support@jspreadsheet.com with more information.