asked on January 11, 2022
Hello team,
i have a problem about this topic -> https://www.flexmonster.com/question/ho-to-programmatically-set-layout-form/
Is there an alternative solution? Because i need to disable the switching from classic to compact layout.
Best regards,
Massimo
⋅ January 11, 2022
Hello, Massimo,
Thank you for writing to us.
At the moment, the way Flexmonster handles not enough space for the scrollable content hasn't changed: when there are too many expanded columns, Flexmonster switches to a more compact layout in order to fit and display the grid values.
Our team provided several suggestions on how you could prevent the default behavior in the mentioned Support Ticket.
Could you please explain in a bit more detail which problem you are currently facing?
Looking forward to your reply.
Kind regards,
Vera
⋅ January 11, 2022
Hello Vera,
the problem we're facing at the moment is that, in some use cases, we need to use the Flexmonster Pivot to show data in time-buckets.
In such cases, the best view for our customers is the Excel-like one where hierarchy columns are fixed to the left side and time-bucket columns are displayed to the right with a scroll when necessary. This behaviour is required to be fixed, independently from the space available for the scrollable content.
⋅ January 13, 2022
Hello, Massimo,
Thank you for providing further details on your use case.
We understand that it is important for you to remain in classic layout. This request has been added to our customers' wishlist. However, changing the current behavior would require significant changes in the existing grid architecture; therefore, it is unlikely to change in the near future. Still, we will keep you updated on the matter.
Previously, our team prepared a JSFiddle example of how you could prevent the switch to compact layout: https://jsfiddle.net/flexmonster/mzvfq63p/. This example is the only implemented solution that we have at the moment, and it seems to be working well in most scenarios. Could you please let us know why the provided solution doesn't work for you? Perhaps there is a way to adjust the workaround so that it covers all of the requirements.
Thank you, and looking forward to your answer.
Kind regards,
Vera
⋅ January 24, 2022
Thank you for your reply,
i attached an image with our product, the second grid is your solution of the problem, as said above the best view for our customers is classic layout grid where hierarchy columns are fixed to the left side but is not possible with your solution because the user can scroll all the table.
Kind regards,
Massimo
⋅ January 24, 2022
Hello, Massimo,
Thank you for your response.
The component switches to a more compact layout when there is not enough space to display the measures. Currently, this is how Flexmonster ensures that the frozen area doesn't take up all of the available space and so that the grid remains accessible (see more details on the scrollable content).
At the moment, the only available solution to prevent the layout switch while at the same time keeping the values accessible to users is the solution with the scrollable container.
As an idea, you could switch to the scrollable solution that we've previously provided only when there is not enough space for the component to display all of the frozen columns side-by-side. This way, when there is enough space for the grid values, the columns will remain "frozen" side-by-side without the additional scrollbar. On the other hand, when there are too many frozen columns to show at once, you could enable the suggested solution with the scrollable container, therefore, preventing the switch to the compact layout while keeping the grid values accessible and readable to your users.
As mentioned in our earlier response, your request has been added to our customers' wishlist. We will notify you once our team provides a built-in way to handle such cases.
We will keep in touch!
Kind regards,
Vera
