Oracle Smart View for Office 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:
Zoom in on a page dimension
Pivot a dimension from the POV to a row or column
Drag and drop a dimension from the POV to the worksheet
Pivot a row dimension to a column dimension
Switch the location of a row dimension to another row
Switch the location of a column dimension to another column
Change member aliases using the Change Alias Table command
With Oracle Essbase or Oracle Analytics Cloud - Essbase 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.