on 2015 Jun 03 8:29 AM
Hi Experts,
how can i disabled the EPMFormatting? i wanted to format my reports manually, especially the color of data fields.
i disabled the formatting into sheet options and edit reports.
please see the attachment.
Thanks and Best Regards,
Marlon
Hi Marlon,
As format is already applied to cells it is possible by using simple excel format painter.
Or
Use epmcopyrange function to remove colors from data grid.
=EPMCopyRange("000",TRUE,D1)
hope this will solve your problem
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
P.S
Once formatting done using copyrange function then remove copyrange function or disable it
Hi,
is this applicable change the view? for example i change the time from 2015 to 2016? because when i did the formatting manually, my data field were cleared every time i change the view.
Regards,
Marlon Manalo
Use static report approach - then manual formatting will work!
Vadim
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.