like below fixes the issue You can't do this with one custom format. What you can do is make a macro that does the input for you and modifies each cell format as it puts the value into it. You can use the Macro Recorder to get a handle on where to start with this.
it fixes the issue I am trying to take a 10 digit phone number (1234567890) that is returned from the database and format it to render on the view page as (123) 546-7890. , you could use the substring function:
'(' + substr(first three digits) + ')' + substr(middle three digits) + '-' + substr(last four)
Formatting column number in a dynamyc view panel in a xpage
To fix this issue Here's a code snippet from a getValueAsString() method from an ExtendedViewColumnConverter class that handles number formatting based on the user locale. The code assumes that the variable currentLocale contains the user locale. currentLocale is an instance of java.util.Locale.Locale and I assume that you have logik that handles this e.g. as part of a user bean. If not, then one way of getting the current locale is to do this: