AnsweredAssumed Answered

BOM export to Excel flaw

Question asked by Gary Lucas on Aug 22, 2019
Latest reply on Aug 22, 2019 by Kevin Chandler

In exporting data to Excel I had a column in the BOM very narrow and some of data (text) wrapped down.  When this data was exported SW inserted an invisible character, Carriage Return Linefeed I believe, between the first line of data in the cell and the second.  Excel shows the full line of data in each cell.  However if you edit that cell you suddenly see only what was before the hidden character.  When you edit the cell if you hit delete with the cursor at the end of the first line of data you then see all the data.  I don't think SW should export that hidden character.

Outcomes