search

jspreadsheet / pro

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

freezeColumns and tableOverflow not working on bootstrap modal #316

Closed Rajnish710 closed 8 months ago

Rajnish710 commented 8 months ago

Dear Sir/Mam, pls. solve our problems which are mentioned below

when we set freezeColumns and tableOverflow to true the spreadsheet does not load and the "Frozen columns cannot be larger than the viewport" error comes and if I do false with this, the spreadsheet loads but does not scroll.

Note: This works properly up to V7.

my code is here below:

<!DOCTYPE html>

testJs

https://github.com/jspreadsheet/pro/assets/72546327/35ef45f1-bcb4-45af-a1dc-8d860fe4ff17

https://github.com/jspreadsheet/pro/assets/72546327/62a979d3-cdb1-4373-9280-3e63c69253f6

paulorodalves commented 8 months ago

You cannot create a spreadsheet with a DOM that is not visible or appended to the DOM. Otherwise, the calculations will return zero, which causes that.

When you open the modal, you call Jspreadsheet to create your spreadsheet.

Rajnish710 commented 8 months ago

But It is working fine up to V7 what could be the problem with the upper version?

Note: I am thinking of getting the enterprise version but can't due to this problem so, please give any solution.

hodeware commented 8 months ago

If you wish to upgrade the solution is adapt your code. Probably you modal has an event 'onload' or 'onopen' you can use that to trigger when JSS is created. This is not so simple because v11 has a huge virtualization that works like this.