Uploaded image for project: 'Xporter for Jira Cloud'
  1. Xporter for Jira Cloud
  2. XPORTERCLOUD-2287

Wiki markup fails to properly export Tables into XLSX format reports if the table contains Bulletpoints.

    XporterXMLWordPrintable

Details

    • Bug
    • Status: Open
    • Medium
    • Resolution: Unresolved
    • Xporter Cloud v2.1
    • None
    • Templates
    • None
    • UNCOVERED

    Description

      Description{}

      Wiki markup fails to properly export Tables into XLSM format reports if the table contains Bullet-points. ** 

       

      If the template mapping ${wiki:Description} is used to export a Description field with a Table inside into an Excel (XLSX) template report, and the Description Table in question have bullet points, the resulting report table in Excel will not be format properly and will overwrite the surrounding columns and rows.

      If no bullet-points are present within the table, the
      **

       

      Pre-conditions

      • Have an available Excel format template that contains a wiki markup field. For example: ${wiki:Description}

      How to reproduce

      The following steps will be to reproduce the problem for a Test Issue with a Description field containing a wiki Table. However, the problem can be reproduced for any Issue Type and Wiki field. 

      • Upload into Xporter the Testing Template mentioned above.
      • Create a Test Issue.
      • Modify the Description field to include a Table.
        • You can use the following example:
      Header 1 Header 2 Header 3
      Item 1.1 Item 2.1
      • ok
      • nok
      • not ok
      Item 1.2 Item 2.2  
      Sample Text Lorem Ipsum Lorem ipsum dolor sit amet. Quo galisum consequatur vel quisquam tempore in rerum dignissimos et accusamus autem ut optio magni. At sequi rerum in quis reprehenderit aut error aspernatur aut similique sequi.
      Nam rerum error qui quaerat voluptatem a iste tempore est quas doloribus. Ad minima sequi et facilis architecto sit enim similique in error quam et animi accusamus et veniam nesciunt est dolorem internos.
      • Generate a report using the Testing template we previously uploaded into Xporter.

      Actual result/Attachments

       

      • If the Bullet-points are included:
        • The resulting table report in Excel will not follow the correct format, nor show the Bullet-points
        • Instead, new cells will be created for each bullet-point item, overlapping adjacent cells
        • Example:
      • If the Bullet-points are not present:
        • The table report will be generated correctly, showing the Description tables within the corresponding Columns and Rows.
        • Example:

       

      Expected result

      The report must generate the wiki table inside the desire column and rows without interfering with the rest of the Excel sheet cells, regardless of there being bullet points or not.

       

       

       

      Attachments

        Activity

          People

            rmbr Rui Rodrigues
            victor.sanchez Victor Puente Sanchez
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: