Need to apply thick border formatting for rows derived by local member Formula.

[former_member432740]

Hi All,

i need to apply thick border formatting for rows derived by local member Formula, can any one please help

[former_member186338 · Accepted solution]

But what is the issue??? Just a basic formatting using formatting sheet:

Format the cell for Data for Local member Default format with thick border.

The result:

Nothing strange!

P.S. ACCTYPE is a column with local member.

[former_member432740 · Accepted solution]

Thanks a lot....

[former_member432740 · Accepted solution]

Hi,

How can i fix Column width(or dynamically as per Text size)

, can you please help

[former_member186338 · Accepted solution]

Sorry, but not clear what do you want! Please provide some sample.

[former_member432740 · Accepted solution]

In the above Pic-2 Column B, this needs to fix Column width based on text/character size in the cells.

[former_member186338 · Accepted solution]

Strange idea!

In EPM "Sheet Options" you have:

Can be switched on/off

Other way - only complex VBA code.

[former_member432740 · Accepted solution]

Hi,

I used this option but it does not apply this format.

[former_member186338 · Accepted solution]

What do you mean?

With this option switched on and with reduced header of column B you can see:

Column width was adjusted correctly.

[former_member432740 · Accepted solution]

I have done as you said in the report, but the formatting doesn't apply.

i cannot upload the pic(setting i appplied) as don't have permissions in lappy, some restrictions to upload pic

Any other setting am i missing, not sure.

[former_member186338 · Accepted solution]

Sorry, but it's working 100%, no issues!

Try to reproduce my report.

And without your pictures I can't help you.

[former_member432740 · Accepted solution]

Thanks a lot for your quick help everytime.

[former_member186338]

First correct the tag! Primary tag has to be:

EPM Add-In for Excel

Then I will try to help you.

[former_member432740]

done as you said

[former_member186338]

And what is the result?