5 Answers, 1 is accepted
Test applying the settings suggested in Design Considerations for Excel Rendering - Merging Cells help article.
The main idea is to make sure left and right edges of all report items (CrossTab item and TextBoxes in the Page Footer in your case) line up with one another.
In Standalone Designer, turn on Turn on snapping to snaplines option to see when the edges are aligned - Standalone Report Designer elements
I hope this will solve the issue.
Telerik by Progress
I'm experiencing somehow the same problem, but I have applied your suggestions and it doesn't work.
Here is the story:
Due to some project/stability related reasons we use version R3 2018 – 188.8.131.522.
I'm using the Designer integrated in VS 2017 Enterprise.
The report was built by another colleague and it was working fine. This uses textboxes and a table where all the fields are mapped. Now I had to add an additional field/column to it. I have done so (only the column without any text) by adding an extra column (in the middle) of the table and I have resized the Details section to fit or even be wider than the table.
The issue is that I still get an extra column when exporting the report to excel. This extra column is merged with the next one for displaying one field of the table.
Please see the screenshots attached.
As a remark, I have applied your fix with success in the past on the same report.
Now I have found another merging issue when exporting to excel.
In my reports I'm using grouping of columns (table groups) and I allow the possibility to collapse/expand a group.
If I export the report expanded it works fine, without merging columns (see attachment 1).
If I export the collapsed report it merges 2 columns (see attachment 2).
Generally, the Reporting engine tries to produce a report layout that is as close as possible to the defined one and to maintain the designed positions of the items. For this purpose, when the report is exported to XLSX some cells are merged.
We reviewed the provided screenshots and we have an assumption that the issue with the merged I and J column occurs because of the "ORR Report" textbox. It seems to us that the textbox has improper right alignment against the table column. Make sure the left and right edges of this textbox line up with the table column. The alignment and applying the same width to report items will usually solve the problem.
If this is not the case, please open a new support ticket and send us the problematic report along with some sample data for further investigation.