AccuWork issue records take up multiple rows after importing html into


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.

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.

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.

<!-- table br {mso-data-placement:same-cell;} -->

For more information contact AccuRev Support

Comment List