AccuWork issue records take up multiple rows after importing html into

0 Likes

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

Comment List
Related
Recommended