https://communities.bentley.com/products/pipe_stress_analysis/w/pipe_stress_analysis__wiki/18879/selection-types-different-message-occurs-when-copy-pasting-to-autopipe
Develop a permanent solution for this bug since 2015.
Copy and pasting rows from Excel should work flawlessly with no extra steps.
