Pivot Table Freeze Columns or Rows - "Freeze Pane"

[DavidJHassan]

I would like the ability to freeze a row or column from moving when I scroll down or over on the pivot table chart.

If you have a large pivot table that involves scrolling in either direction you can easily lose track of which row or column you are looking at.

By freezing the column or row on scrolling we do not have that issue.

This feature is called "Freeze Pane" in MS Excel.

[issue-label-bot]

Issue-Label Bot is automatically applying the label #enhancement to this issue, with a confidence of 0.76. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[vrnvorona]

why is it close without any response?

[saghatelian]

This would be a great feature. Hope someone will add it.

[LeoDiep]

This is a very useful feature, for large table. Please add it

[LeoDiep]

any update on this, please?

[Nimit-Shah]

Any update please?

[LeoDiep]

any update on this, please?

[cstoff6]

Any update on this? I would like to implement this feature.

[dokster8]

Still need this feature.

[Nimit-Shah]

Hi Dimitri, Yes I still need this feature. On any kind of table being built. Both columns and rows. Not sure how many else need this but it will be helpful.

…

On Thu, 9 Nov, 2023, 3:15 pm Dmitriy Greshnov, ***@***.***> wrote: Still need this feature. — Reply to this email directly, view it on GitHub <#8238 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AM3SPYW5BJ6IUB3N6XVP7F3YDSQ5DAVCNFSM4IXQOIC2U5DIOJSWCZC7NNSXTN2JONZXKZKDN5WW2ZLOOQ5TCOBQGM2DSMJTGA2Q> . You are receiving this because you commented.Message ID: ***@***.***>

[LeoDiep]

the pivot table v2 can freeze the top rows already, but we really need columns freezed as well for large long tables.
I don't think this is too difficult to implement, am I correct?

[jatin5251]

yes we need this feature

[ashishjaingithub]

Any update on this?

[rusackas]

Hey folks. The thread was closed by a bot, four years ago, because the issue was ignored by the community for 30 days.

At this point, it wouldn't be allowed as an Issue, since it's not a bug. For feature requests, we advise people to open a GitHub Discussion and/or open a PR.

In this thread, there are a lot of folks suggesting that it's easy or that they'd like to contribute it. Please do! We're more than happy to review PRs, and would love to bring more contributors into the fold here.

[LeoDiep]

Hey folks. The thread was closed by a bot, four years ago, because the issue was ignored by the community for 30 days.

At this point, it wouldn't be allowed as an Issue, since it's not a bug. For feature requests, we advise people to open a GitHub Discussion and/or open a PR.

In this thread, there are a lot of folks suggesting that it's easy or that they'd like to contribute it. Please do! We're more than happy to review PRs, and would love to bring more contributors into the fold here.

Hi, I did raise a discussion months ago. Please help us here to make this function reality.
#23404