Table
The CopyProvider's options on a responsive table: several fields per column with a text/html template, sparse copying, cells or full rows - paste the result below to see what the clipboard holds. Needs UI5 1.119+.
Z2UI5_CL_SMP_APP_539
Learn
Table
UI5 1.119
frontend action
The facts
- Repository
- abap2UI5/samples
- Class
Z2UI5_CL_SMP_APP_539- Source file
z2ui5_cl_smp_app_539.clas.abap↗- Category
- Table
- Learning path
- Show many rows
- Minimum UI5
- 1.119
- In the playground
- runs in the browser, with no system and nothing installed
- Marked
(A)— Performs a frontend action: client->follow_up_action( ), or drag and drop
Keywords: clipboard, copy, cellselector, copyprovider, copysparse, copypreference, template, spreadsheet, control_by_id
Controls it builds
- sap.m.Button
- sap.m.Column
- sap.m.ColumnListItem
- sap.m.Label
- sap.m.MessageStrip
- sap.m.ObjectIdentifier
- sap.m.ObjectNumber
- sap.m.OverflowToolbar
- sap.m.OverflowToolbarButton
- sap.m.Page
- sap.m.SegmentedButton
- sap.m.SegmentedButtonItem
- sap.m.Shell
- sap.m.Switch
- sap.m.Table
- sap.m.Text
- sap.m.TextArea
- sap.m.Title
- sap.m.ToolbarSpacer
- sap.m.VBox
- sap.m.plugins.CellSelector
- sap.m.plugins.CopyProvider
- sap.ui.core.mvc.View
Read out of the builder chain by the abap2UI5 linter, not from the category this sample is filed under — which is what makes “which samples build one of these” a question the catalogue can answer at all.
Libraries
Run it here
The sample running, in this page — the app on its own, with no editor over it.
Switch to Playground with this code
Nothing is installed and nothing is sent anywhere: the ABAP is compiled to JavaScript in this browser and runs against abap2UI5 itself.
The ABAP
z2ui5_cl_smp_app_539.clas.abap — 223 lines
Click a number to link to a line — shift-click for a range.
Read it on GitHub ↗
" @keywords clipboard copy cellselector copyprovider copysparse copypreference template spreadsheet control_by_id
" @summary The CopyProvider's options on a responsive table: several fields per column with a text/html template, sparse copying, cells or full rows - paste the result below to see what the clipboard holds. Needs UI5 1.119+.
CLASS z2ui5_cl_smp_app_539 DEFINITION PUBLIC.
PUBLIC SECTION.
INTERFACES z2ui5_if_app.
TYPES:
BEGIN OF ty_s_product,
product_id TYPE string,
name TYPE string,
supplier TYPE string,
quantity TYPE string,
uom TYPE string,
price TYPE string,
currency TYPE string,
END OF ty_s_product.
DATA t_products TYPE STANDARD TABLE OF ty_s_product WITH EMPTY KEY.
" the CopyProvider's options, bound - a change needs no roundtrip
DATA copy_sparse TYPE abap_bool.
DATA copy_preference TYPE string.
" whatever the user pastes into the text area
DATA clipboard_text TYPE string.
PROTECTED SECTION.
DATA client TYPE REF TO z2ui5_if_client.
METHODS on_init.
METHODS on_event.
METHODS view_display.
PRIVATE SECTION.
ENDCLASS.
CLASS z2ui5_cl_smp_app_539 IMPLEMENTATION.
METHOD z2ui5_if_app~main.
me->client = client.
IF client->check_on_init( ).
on_init( ).
ELSEIF client->check_on_navigated( ).
view_display( ).
ELSEIF client->check_on_event( `INSPECT` ).
on_event( ).
ENDIF.
ENDMETHOD.
METHOD on_init.
copy_preference = `Cells`.
t_products = VALUE #(
( product_id = `HT-1000` name = `Notebook Basic 15` supplier = `Very Best Screens` quantity = `10` uom = `PC` price = `956.00` currency = `EUR` )
( product_id = `HT-1001` name = `Notebook Basic 17` supplier = `Very Best Screens` quantity = `20` uom = `PC` price = `1249.00` currency = `EUR` )
( product_id = `HT-1007` name = `ITelO Vault` supplier = `Technocom` quantity = `15` uom = `PC` price = `299.00` currency = `EUR` )
( product_id = `HT-1010` name = `Notebook Professional 15` supplier = `Very Best Screens` quantity = `16` uom = `PC` price = `1999.00` currency = `EUR` )
( product_id = `HT-1063` name = `Ergonomic Keyboard` supplier = `Titanium` quantity = `50` uom = `PC` price = `14.00` currency = `EUR` )
( product_id = `HT-1070` name = `Photo Scan` supplier = `Red Point Stores` quantity = `8` uom = `PC` price = `129.00` currency = `EUR` ) ).
view_display( ).
ENDMETHOD.
METHOD on_event.
" the clipboard's text format is a spreadsheet's: a tab between two
" cells, a line break between two rows
SPLIT clipboard_text AT cl_abap_char_utilities=>newline INTO TABLE DATA(t_line).
DELETE t_line WHERE table_line IS INITIAL.
DATA(cells) = 0.
LOOP AT t_line INTO DATA(line).
SPLIT line AT cl_abap_char_utilities=>horizontal_tab INTO TABLE DATA(t_cell).
cells = cells + lines( t_cell ).
ENDLOOP.
client->message_toast_display( |{ lines( t_line ) } row(s) with { cells } cell(s) arrived in the backend| ).
ENDMETHOD.
METHOD view_display.
DATA(view) = z2ui5_cl_ui5_view_builder=>factory(
)->ele( n = `View` ns = `mvc`
)->a( n = `displayBlock` v = `true`
)->a( n = `height` v = `100%`
)->a( n = `xmlns` v = `sap.m`
)->a( n = `xmlns:mvc` v = `sap.ui.core.mvc`
)->a( n = `xmlns:core` v = `sap.ui.core`
)->a( n = `xmlns:plugins` v = `sap.m.plugins`
)->a( n = `xmlns:app` v = `http://schemas.sap.com/sapui5/extension/sap.ui.core.CustomData/1`
" the CopyProvider's extractData callback ships with the framework
)->a( n = `core:require` v = `{Clipboard: 'z2ui5/model/clipboard'}` ).
DATA(page) = view->ele( `Shell`
)->ele( `Page`
)->a( n = `title` v = `abap2UI5 - Table - Copy Options of the CopyProvider (UI5 1.119+)`
)->a( n = `showNavButton` b = client->check_app_prev_stack( )
)->a( n = `navButtonPress` v = client->_event_nav_app_leave( ) ).
page->tag( `MessageStrip`
)->a( n = `text` v = `Select rows or drag over cells, press Copy and paste into the text area below. Each ` &&
`column copies the fields its app:bindings names, one clipboard cell each - app:template is the ` &&
`formatted variant a spreadsheet shows. Sparse keeps the gaps between selected rows, Full copies ` &&
`whole rows. Needs UI5 1.119 or newer.`
)->a( n = `type` v = `Information`
)->a( n = `showIcon` b = abap_true
)->a( n = `class` v = `sapUiSmallMargin` ).
DATA(table) = page->ele( `Table`
)->a( n = `id` v = `products`
)->a( n = `mode` v = `MultiSelect`
)->a( n = `items` v = client->_bind( t_products )
)->a( n = `class` v = `sapUiSmallMargin` ).
table->ele( `dependents`
)->tag( n = `CellSelector` ns = `plugins`
)->tag( n = `CopyProvider` ns = `plugins`
)->a( n = `id` v = `copyProvider`
)->a( n = `extractData` v = `Clipboard.extractData`
)->a( n = `copySparse` v = client->_bind( copy_sparse )
)->a( n = `copyPreference` v = client->_bind( copy_preference ) ).
table->ele( `headerToolbar`
)->ele( `OverflowToolbar`
)->tag( `Title`
)->a( n = `text` v = `Products`
)->tag( `ToolbarSpacer`
)->tag( `Label`
)->a( n = `text` v = `Sparse`
)->tag( `Switch`
)->a( n = `state` v = client->_bind( copy_sparse )
)->ele( `SegmentedButton`
)->a( n = `selectedKey` v = client->_bind( copy_preference )
)->ele( `items`
)->tag( `SegmentedButtonItem`
)->a( n = `key` v = `Cells`
)->a( n = `text` v = `Cells`
)->tag( `SegmentedButtonItem`
)->a( n = `key` v = `Full`
)->a( n = `text` v = `Full Rows`
)->end(
)->end(
" the copy has to run inside the click - the browser only lets a
" user gesture write the clipboard - so no roundtrip: a frontend
" action calls copySelectionData on the plugin directly
)->tag( `OverflowToolbarButton`
)->a( n = `icon` v = `sap-icon://copy`
)->a( n = `text` v = `Copy`
)->a( n = `tooltip` v = `Copy`
)->a( n = `press` v = client->follow_up_action( val = client->cs_event-control_by_id
t_arg = VALUE #( ( `copyProvider` ) ( `copySelectionData` ) ( `X` ) ) ) ).
" several fields per column: app:bindings lists them, app:template is
" the formatted text/html variant (a formatMessage pattern)
table->ele( `columns`
)->ele( `Column`
)->a( n = `app:bindings` v = `NAME,PRODUCT_ID`
)->a( n = `app:template` v = `\{0\} (\{1\})`
)->tag( `Text`
)->a( n = `text` v = `Product`
)->end(
)->ele( `Column`
)->a( n = `app:bindings` v = `SUPPLIER`
)->tag( `Text`
)->a( n = `text` v = `Supplier`
)->end(
)->ele( `Column`
)->a( n = `hAlign` v = `End`
)->a( n = `app:bindings` v = `QUANTITY,UOM`
)->a( n = `app:template` v = `\{0\} \{1\}`
)->tag( `Text`
)->a( n = `text` v = `Quantity`
)->end(
)->ele( `Column`
)->a( n = `hAlign` v = `End`
)->a( n = `app:bindings` v = `PRICE,CURRENCY`
)->a( n = `app:template` v = `\{0\} \{1\}`
)->tag( `Text`
)->a( n = `text` v = `Price` ).
table->ele( `items`
)->ele( `ColumnListItem`
)->ele( `cells`
)->tag( `ObjectIdentifier`
)->a( n = `title` v = `{NAME}`
)->a( n = `text` v = `{PRODUCT_ID}`
)->tag( `Text`
)->a( n = `text` v = `{SUPPLIER}`
)->tag( `ObjectNumber`
)->a( n = `number` v = `{QUANTITY}`
)->a( n = `unit` v = `{UOM}`
)->tag( `ObjectNumber`
)->a( n = `number` v = `{PRICE}`
)->a( n = `unit` v = `{CURRENCY}` ).
DATA(inspect) = page->ele( `VBox`
)->a( n = `class` v = `sapUiSmallMargin` ).
inspect->tag( `TextArea`
)->a( n = `value` v = client->_bind( clipboard_text )
)->a( n = `rows` v = `6`
)->a( n = `width` v = `100%`
)->a( n = `placeholder` v = `Paste here (Ctrl+V) to see what the clipboard holds` ).
inspect->tag( `Button`
)->a( n = `text` v = `Send to the Backend`
)->a( n = `icon` v = `sap-icon://upload`
)->a( n = `press` v = client->_event( `INSPECT` ) ).
client->view_display( view->stringify( ) ).
ENDMETHOD.
ENDCLASS.
More in Table
- Table — Drag and Drop Rows
- Table — Editable Cells, Add and Delete Rows
- Table — Filter Rows in the Backend
- Table — Large Table with Growing and ScrollContainer
- Table — Live Search over a Large Table
- Table — Refused Cell Values (t_model_skipped)
- Table — Search in the Backend (SearchField)
- Table — Selection Modes: Single and Multi Select
On this page