CAFE 10.2.5 flew view and Excel array formulas

[hittony]

Hello,

I discovered that any array formulas in the data area of a CAFE flex view will be automatically converted to a non-array one after the view is refreshed. Is there some trick to keep those array formulas ?

Thanks a lot

Build: 10.2.5220.51
Excel 2010

[rksharmatm1]

Hello, Try Options--> cognos analysis --> preserver user formulas. Thanks.

[hittony]

Not only the array formulas, but also the format determing the number of decimals can be erased by a refresh, I have to use ROUND() instead

Hello, Try Options--> cognos analysis --> preserver user formulas. Thanks.

Not working, thanks anyway

[hittony]

If ROUND() can help to define a decimal format from an Excel calculation within a flex view, how to define a percentage style