Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interactive grid - Copy across

partlycloudyMay 31 2020 — edited Jun 17 2020

APEX 20.1

Interactive grid has a nice feature in cell selection mode to Copy Down a selected value so you can enter a value in the first row/column and use Excel-like drag-down to copy it to other cells quickly. This is especially handy when column is rendered using a Select list which could have a internal return value that is not known to the user.

My IG has a PIVOT in the query (with a custom save process) that pivots rows to columns so what I need is a Copy *Across* feature. The Selection > Fill feature is close but unlike the Copy Down feature, it asks for a value to fill. This is not helpful because the return value of select list based columns is NOT known to the user.

Any ideas? @"John Snyders-Oracle" Do you have a recipe for this in your cookbook?

Comments
Post Details
Added on May 31 2020
2 comments
1,389 views