Author Topic: Excel Grid Height changes When Scrolling Horizontally  (Read 1634 times)

arky

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 14
    • View Profile
Excel Grid Height changes When Scrolling Horizontally
« on: November 08, 2017, 04:26:01 pm »
Version 4.0.1

Importing a Spreadsheet. I would like it to fit the content of the spreadsheet  with no extra rows or columns.
I can do this and looks fine. Column 2 wraps to multiple lines in each cell. All other columns are one line of text.

Problems is when I scroll right, the moment column 2 is no longer visible the height of the grid collapses to the one line fields.
Very abrupt. Can it be set to remember the max height and keep it on scrolling horizontally.
I thought maybe {flex: one:true} would help but no luck.

I've attached the sample xlsx demonstrating the problem in your Excel spreadsheet demo page.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6265
    • View Profile
Re: Excel Grid Height changes When Scrolling Horizontally
« Reply #1 on: November 08, 2017, 11:40:53 pm »
Yes that happens when virtualX: true

it can be avoided by using virtualX: false if you have less number of columns.