Smartview Formatting Issue

Summary

Smartview formats formulas as text

Content

We are having some issues with formatting in Smartview.

1. When linking a cell to a member, the cell format always switches to "text format" (i.e. "=E7"). The only way to fix this issue is to change the indentation in Smartview Options to "None". Even when manually switching the format in excel to "Number" and refresh, the format switches back to  "text format". Is there a way to prevent this from happening? I don't want to constantly switch Indentation from "Subitems" to "none".

2. In the past, when an alias (i.e. Busarea) changed, and you refresh while leaving the old alias unchanged, the number changed to "0". Now, however, the original amount stays, which can cause unintended variances.