Using XFBR in CubeView for Cell Format
Hi all,
I'm looking for a possibility to dynamically create a Cell Format via an XFBR Rule. Unfortunately it doesn't seem to work, but also does not give an error message. Could someone please let me know, whether and how it is possible?
The script is e.g. returning something like "|!MyFormatParameter!|" in the easiest case.
Thanks in advance
Markus
Hi Markus: you can definitely use XFBR strings in the cell format. Try a super basic format to ensure you have syntax, spelling, etc. correct (something like TextColor = Red). Also, XFBR's in the conditional portion of cell formatting get picky. If that is where things aren't working, we'll need a bit more detail on what you are trying to accomplish.
Just for reference, here are a few ways to do parameterized formatting:
- Use parameters as options for the cell format. Example: Scale = |!Select_Scale!| (which can be a delimited list or other param)
- Use a literal value parameter with nested parameters of options. Example: |!DefaultFormatting!| is a literal string of formatting options. It can include additional parameters within it that will be evaluated, like the scale option above.
- Use XFBR as options for the cell format. Same concept as the select scale but with the right-hand side as an XFBR string rather than parameter.
- Use XFBR which returns a literal string of the formatting options.