This is a migrated thread and some comments may be shown as answers.

Problem with merged cells in excel

5 Answers 1107 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Max
Top achievements
Rank 1
Max asked on 19 Apr 2017, 07:53 AM
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.

5 Answers, 1 is accepted

Sort by
0
Katia
Telerik team
answered on 19 Apr 2017, 01:55 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Vlad
Top achievements
Rank 1
answered on 27 Mar 2019, 03:33 PM

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

0
Vlad
Top achievements
Rank 1
answered on 27 Mar 2019, 06:12 PM
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.
0
Vlad
Top achievements
Rank 1
answered on 28 Mar 2019, 05:02 PM

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

 

0
Silviya
Telerik team
answered on 02 Apr 2019, 01:20 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Report Designer (standalone)
Asked by
Max
Top achievements
Rank 1
Answers by
Katia
Telerik team
Vlad
Top achievements
Rank 1
Silviya
Telerik team
Share this question
or