Problem with merged cells in excel

[Max]

Hi!
I have a problem with merged cells in excel. When I export from Report Designer R1 2017 to excel and turn on filter by selected cell's value in excel. As result it shows only first row of data.

Best Regards, Max.

[Katia]

Hi Max,

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.


Regards,
Katia
Telerik by Progress

[Vlad]

Hi,

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 – 12.2.18.912.

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.

Thank you,

Vlad

[Vlad]

I have found an workaround for it, at least for me. I have also groups in my table. The above issue appears when I add a new column at the beginning of the group (and then merge the above cells), or even if I add it as the 2nd column (so in the middle of the group - using both add left, add right). But it works if I add it at the end of the group (and then merge the above cells). This is very strange.

[Vlad]

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

 

[Silviya]

Hello Vlad,

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.

Best Regards,
Silviya
Progress Telerik