Smart View tries to preserve all comments, formulas, and customized report layouts. Some exceptions that may result in unexpected behavior are when the following actions are performed:
In Essbase or Hyperion Enterprise data sources, cutting and pasting from Microsoft Word into an Excel worksheet may cause unexpected behavior because of hidden characters. If this happens, contact your administrator, who can identify the issue through logs.