Grand Totals not visible when data is big

posted on June 17th, 2022

Closed

Ronaldo C asked on June 17, 2022

Hello Flexmonster Team,
I have the following problem:
When having a lot of data in the table, it's a bit difficult to see the grand totals, since we have to scroll a lot of rows/columns.
I feel like this can be solved by putting the grand totals in the top or left, but I notice a lot of threads already ask for such feature as well.
So my question is basically:

Any plans to add the feature?
Do you have any other solution that can help alleviate the problem?

Many thanks,
Ronaldo

6 answers

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ June 17, 2022

Hello, Ronaldo,

Thank you for reaching out to us.

Currently, we do not have plans to introduce this feature. It is because of the current complex architecture responsible for rendering the grid.
We recommend using one of the following workarounds:

Using the scrollToColumn and scrollToRow API calls provided by Flexmonster to scroll to the Grand Totals. Please check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/rju23gza/9/
Alternatively, you can implement your own Totals Row outside the component using the getData API call. It allows retrieving data from the grid and is usually used to integrate with third-party charting libraries. You can use it to retrieve desired grand totals. You can check the following sample illustrating getting grand totals: https://jsfiddle.net/flexmonster/dj0b97y1/

Feel free to contact us if other questions arise.

Kind regards,
Nadia

Public

Ronaldo C ⋅ June 20, 2022

Hello Nadia,
Thanks for the answers.
Unfortunately, I notice that the workaround for scrollToColumn and scrollToRow work in Chrome but doesn't work properly in Firefox. Can you have a check on it and see what's going on?
Regards,
Ronaldo

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ June 21, 2022

Hello,

Thank you for reporting the issue.

We will take a look at the described behavior and provide a fix with our minor release with the ETA July 11th.

You are welcome to write to us in case further questions arise.

Kind regards,
Nadia

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ July 11, 2022

Hello, Ronaldo,

We are glad to announce that the issue with scrollToRow and scrollToColumn methods when scrolling to max values in Firefox was fixed.

This fix is included in the 2.9.29 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-29/

You are welcome to update the component. Here is our guide on upgrading to the latest version: https://www.flexmonster.com/doc/updating-to-the-latest-version/

Please tell us if the fix works. Looking forward to your response.

Kind regards,
Nadia

Public

Ronaldo C ⋅ July 12, 2022

Hello,

Thanks for the update, it seems to work much better now. Unfortunately, I've just noticed that when I initially load the JSFiddle here: https://jsfiddle.net/flexmonster/rju23gza/9/, I would need to do several clicks on the "Checkout column's grand totals", for it to properly scroll to the furthest right of the table. Then after I already do this once, the button would work properly. (happen in both Firefox and Chrome)
Can you check that again?

Thanks,
Ronaldo

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ July 13, 2022

Hello, Ronaldo,

Thank you for the response.

The reason for such behavior of the scrollToColumn() API call is the difference between the column's width. We recommend adding a CSS rule that will make all cells' widths the same:

.fm-row .fm-cell:not(.fm-sheet-header) {
  width: 100px !important;
}

You are welcome to check the described approach in the following JSFiddle: https://jsfiddle.net/flexmonster/6hqmcnvk/

We hope it helps. You are welcome to write to us in case further questions arise.

Kind regards,
Nadia

This question is now closed