We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Spreadsheet Hide/Unhide column bug when merged cells exist

Using spreadsheets that have horizontally merged cells, causes column hide/unhide to give unexpected results.

Consider this example, with A1:F1, A2:B2, and C2:F2 as three merged cells..

As expected, hiding column B gives...

But unhiding column B, gives...

After resetting to the initial state, hiding column C gives...  

notice the text "RIGHT" is not visible like it would be in Excel.

4 Replies

SP Sangeetha Priya Murugan Syncfusion Team April 3, 2023 01:14 PM UTC

Hi John,

We can replicate your reported issue in our end. And we will update you the further details on April 5th, 2023. We appreciate your patience until then.

VR Vasanth Ravi Syncfusion Team April 4, 2023 03:03 AM UTC

Hi John,

We have confirmed the issue as " Hide/UnHide merge applied columns shows wrong results for borders and text" and logged a bug report and it will be available in our upcoming April-19, 2023 patch release. You can track the status of the issue via the feedback link below.

Feedback link for tracking purpose https://www.syncfusion.com/feedback/42617/hide-unhide-merge-applied-columns-shows-wrong-results-for-borders-and-text

You will be informed regarding this once the fix is published.

Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works re prioritization.”

VR Vasanth Ravi Syncfusion Team April 27, 2023 04:51 AM UTC

Hi John,

The weekly patch release scheduled has been called off due to the 2023 Volume 1 SP release, which is planned for the upcoming week. We will include the fix in the upcoming Volume 1 SP release scheduled for first week of May. We will let you know once the fix is published. Appreciate your patience until then.


Vasanth R

VR Vasanth Ravi Syncfusion Team May 4, 2023 10:56 AM UTC

Hi John,

We are glad to announce that our Essential Studio 2023 Volume 1 SP release v21.2.3 is rolled out and the fix for the reported issue "Hide/Unhide merge applied columns shows wrong results for borders and text" is available for download under the following link.


Feedback Link: https://www.syncfusion.com/feedback/42617/hide-unhide-merge-applied-columns-shows-wrong-results-for-borders-and-text

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.


Vasanth R

Live Chat Icon For mobile
Up arrow icon