Wikis - Page

AccuWork issue records take up multiple rows after importing html into

MigrationDeletedUser

0 Likes

over 3 years ago

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>

</style>
</head>

For more information contact AccuRev Support

Comment List

Recommended

Menu

AccuRev - Tips & Information

AccuWork issue records take up multiple rows after importing html into

Resources