Oracle APEX 5.0 multiple spaces show as single space in IR

user_2213292 0
Viewed 186

I have an interactive report against a database table. One column contains multiple spaces in the middle of the string. The report is masking the multiple spaces and showing as only a single space. I want to show the exact table column value on the report.

I tried changing the column attributes from "Display as Text (escape special characters)" to "Standard Report Column" and nothing changed. I don't see any other APEX column attributes that will force the spaces to show. Any suggestions.

enter image description here

oracle-apex-5 oracle-apex oracle
1 Answers

Column properties:

  • navigate to "file name" column's property palette (right hand side of the screen)
  • scroll down to static ID and name it somehow (for example, col_with_spaces)

Page properties:

  • go to page's property palette

  • scroll down to CSS and put this into the Inline CSS:

    .a-IRR-table tr td[headers*="col_with_spaces"]
{
    white-space: pre;
}

  • run the page; result:

user_90979060
Related