Oracle APEX 5.0 multiple spaces show as single space in IR

Question

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.

Answer 1

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: