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.
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.
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.”
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.
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.
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.