Changed Member default format issue on protected report

[Former Member]

Hello,

I have an issue about an option of the formatting sheet (changed member default format). It works on my report only when it's unprotected. After protecting it with EPM function, it doesn't work (see picture enclosed).

I am using version 10.0 SP23.

Someone already met this issue ?

Thanks for your answer !

[former_member186338 · Accepted solution]

Hi Eduard,

Just tested, it's working. You have to properly set lock on the required cells!

At least:

Hierarchy Level Formatting

Priority set to column

Yellow data - EPM Unlocked

Both Headers - Locked

Dimension member/property formatting

Priority set to column

Result after worksheet protection:

Vadim

[former_member186338 · Accepted solution]

P.S. Same result with workbook protection!

[Former Member · Accepted solution]

Indeed, it works if USE=ALL on my report.

If USE = FONTCOLORINDEX it doesn't work...

Is it the same for you ?

[former_member186338 · Accepted solution]

Yes, I can confirm that without USE=ALL it will not work!

Possible workaround - use ALL and format this cell the same color as other data entry cells... Not perfect but...

Vadim

[Former Member · Accepted solution]

Strange isn'it ? should normally works.... do you think it's a bug ?

[former_member186338 · Accepted solution]

Yes, it's a bug! Contact SAP support...

[Former Member · Accepted solution]

I will,

thanks for your help

[Former Member]

Hi Edouard,

how did you protect the sheet?

BR,

Arnold

[Former Member]

Hi Arnold,

I protect it with EPM function :

Options > Sheet Options > Protection > Protect Workbook

Edouard

[Former Member]

Hi Edouard,

as Vadim says, that should work unless you have a conflict on your formatting sheet.

BR,
Arnold