Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > Report formatting issue w...
It seems that when importing requirements from Excel (SpiraImportTemplate2010) there is some hidden formatting that apperas only in the Requirements report, and “Remove Format” button is disabled in Spira for the requirement.
How i get requirements in the report:
A Contratada DEVE fazer um workshop de repasse de tecnologia sobre estrutura e organização do código fonte e uso da solução desenvolvida.
RQ:2232
Testando criação de requisito, ao invés de importar no Excel.
Exmplanation:
RQ:2232 was created directly in Spira. Format in the report looks good.
RQ:2231 was created by import via Excel, but after this was edited in Spira, just to cause another SAVE, no real change. Note: The “Remove Format” button was disabled in the requirement in Spira.
RQ:2229 and 2230 were created by import via Excel. There seems to be a formatting issue because there is no space between “RequirementId” and “Description” but the “Remove Format” button is also disabled in the requirement in Spira.
My report code:
<xsl:template match="/RequirementData">
<xsl:for-each select="Requirement">
<div>
<xsl:attribute name="style">
margin-left: <xsl:value-of select="string-length(IndentLevel)*3"/>px;
</xsl:attribute>
<xsl:if test="IsSummary='True'">
<div class="Title2">
<xsl:value-of select="Name"/> - RQ:<xsl:value-of select="RequirementId"/>
</div>
<div class="Description">
<xsl:value-of select="Description" disable-output-escaping="yes"/>
<br />
</xsl:if>
<xsl:if test="IsSummary='False'">
padding-left: <xsl:value-of select="string-length(IndentLevel)*3"/>px;
<!-- <div class="Title3">
RQ:<xsl:value-of select="RequirementId"/>
</div> -->
<p></p>
<b>RQ:<xsl:value-of select="RequirementId"/></b>
Hi Renato
Please can you submit a support ticket for this: https://www.inflectra.com/Support/Ticket/List.aspx
Regards
David
When importing requirements from Excel, it's possible to encounter formatting issues in the report generated. Here are some potential causes and solutions:
Formatting inconsistencies: If the formatting of the requirements in Excel is inconsistent (e.g., different fonts, sizes, or colors), this can cause issues when importing the data into the report. To fix this, make sure that all requirements in the Excel file are formatted consistently.
Missing data: If the Excel file contains missing data for certain requirements, this can cause issues when generating the report. Check the Excel file to ensure that all requirements have complete information.
Improper data types: Ensure that the data types in the Excel file are compatible with the report generation tool. For example, if a column is intended to contain numeric data, make sure that all values in that column are numbers.
Character encoding issues: If the Excel file contains non-standard characters or character encoding issues, this can cause issues when generating the report. Make sure that the character encoding in the Excel file matches the encoding expected by the report generation tool.
Software compatibility issues: Different software tools may have different requirements for importing data from Excel. Make sure that the report generation tool is compatible with the version of Excel being used, and that any necessary plugins or add-ons are installed.
Column width issues: Ensure that the column widths in Excel are wide enough to accommodate the data being imported. If the columns are too narrow, the data may be truncated or lost during the import process.
By addressing these potential issues, you should be able to import requirements from Excel and app development company generate a report without formatting issues.
And if you have any questions, please email or call us at +1 (202) 558-6885
