11 Replies Latest reply: May 31, 2012 11:51 AM by Bob Sacamano RSS

    Include hidden column in csv export

    Bob Sacamano
      Greetings APEX Experts,

      APEX 4.1 user. I have a tabular report with a hidden column ('Show Column' = NO under 'Column Definition' in 'Column Attributes'). However, I want this column included in the csv export. I searched the forum and discovered the PL/SQL Expression: 'APEX_APPLICATION.G_EXCEL_FORMAT = TRUE' can be added to the Conditional Display to make this work. But it doesn't work for me. I tried various combinations of 'Show Column' = YES and NO along with APEX_APPLICATION.G_EXCEL_FORMAT = TRUE and FALSE. I also tried HTMLDB_APPLICATION.G_EXCEL_FORMAT = TRUE and FALSE. No success. Does anyone have any ideas?

      Thanks
      David