Problem with merged cells in excel

6 posts, 0 answers
  1. Max
    Max avatar
    2 posts
    Member since:
    Dec 2016

    Posted 19 Apr 2017 Link to this post

    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.
  2. Katia
    Admin
    Katia avatar
    693 posts

    Posted 19 Apr 2017 Link to this post

    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
  3. Vlad
    Vlad avatar
    4 posts
    Member since:
    Dec 2018

    Posted 27 Mar Link to this post

    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

  4. Vlad
    Vlad avatar
    4 posts
    Member since:
    Dec 2018

    Posted 27 Mar in reply to Vlad Link to this post

    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.
  5. Vlad
    Vlad avatar
    4 posts
    Member since:
    Dec 2018

    Posted 28 Mar Link to this post

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

     

  6. Silviya
    Admin
    Silviya avatar
    399 posts

    Posted 02 Apr Link to this post

    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
Back to Top