Cybersecurity
DevOps Cloud
IT Operations Cloud
PROBLEM:
After exporting query results from AccuWork and importing the html file into Excel, some records may be spread across multiple spreadsheet rows, instead of each issue popuplating a single row. If you try to sort on a column (for example: severity) excel complains.
CAUSE:
When AccuWork generates the html file it will use a <br> tag for line breaks. The <br> tag is what?s causing the new row to be created in Excel.
RESOLUTION:
Excel can be told to suppress the new row creation and preserve the line break within the same cell using a simple style-sheet code snippet. You?ll just need to cut & paste the following style-sheet code at the beginning of the html file before importing.
<head>
<style>
<!-- table br {mso-data-placement:same-cell;} -->
</style>
</head>
For more information contact AccuRev Support