Forum Discussion

STDN's avatar
STDN
New Contributor III
2 years ago

Cube View Formatting

Hi All,   I have created a Cube view which has  negative values in few cells with parenthesis format in OneStream, when i try to export the repot to an Excel am not getting the same format in Excel...
Cube View
Excel Add In
STDN's avatar
STDN
New Contributor III

Hi Mike,

 

I tried the same thing but still am not able to see the same thing in Excel report after export, do i need to changes/enable any settings?

 

 

Thanks in Advance.

MikeG's avatar
MikeG
Contributor III
2 years ago

Do you have it on the Cell Format on the main Cube View properties tab?  The order of operations for what Cell Format wins is 1) Cube View Properties, 2) Column Cell Format, 3) Row Cell Format, 4) Column - Row Overrides, 5) Row - Column Overrides.  Do you have other Cell Formatting anywhere else in the CV?  That syntax works.