Skip to Main Content
Feature Request FR-4295
Product Area Page Components
Status OPEN

1 Voters

The APEX grid can define more than 100 columns of highlighted Excel background colors in batches under the same conditions.

gberp Public · Feb 27 2025

Idea Summary
The APEX grid can define more than 100 columns of highlighted Excel background colors in batches under the same conditions.

Use Case
A lot of business needs to output Excel needs to highlight the background color, there are dozens of columns or more than a hundred, the conditions are the same, such as last year and this year according to the periodic statistics of the material is negative columns show red background color.  Since it is a low code platform, it is low code in the end, silly.

Preferred Solution (Optional)
Calling apex_data_export requires a lot of code, which does not comply with the low code principle.

This idea is open.

Comments

Comments

  • menno.hoogendijk APEX Team OP 11 days ago

    Hi @gberp ,

    Are you asking if we can make it simpler in the APEX_DATA_EXPORT API to define highlights?

    Something like this?

    apex_data_export.add_highlight(
        p_highlights          => l_highlights,
        p_condition.          => 'PRICE < 0',
        p_display_column      => 'PRICE',
        p_text_color          => 'red' );
  • gberp OP 6 days ago

    If you have one hundred columns or more, you will kill people. To display and output excel in the page, the background color is also displayed.

  • menno.hoogendijk APEX Team OP 4 days ago

    It seems my response above is not the solution to your idea. Could you share how you would like us to implement your idea?