- SAP Managed Tags:
SAP Fiori provides a modern, intelligent, and consistent user experience for SAP solutions. The technologies & tools of SAP Fiori, such as SAPUI5 and SAP Fiori elements, offer extensive capabilities for building, extending and running SAP's business applications. When using SAP Fiori, you'll tap into a whole world of generic features of SAP's technologies, that make your life easier. From Joule, SAP’s AI Copilot down to clever copy & paste capabilities, you'll be amazed at how you survived without them.
Advanced Copy & Paste and cell selection
SAPUI5 1.124 improves copy & paste operations in tables, letting business users work even more in a natural way with improved productivity. See these common scenarios:
1. Copy data from a table
Copy data from a table by selecting rows or a group of cells ('lasso select') and paste to a MS Excel sheet or other applications. Play with the sample application Table - CellSelector, CopyProvider and remember using the CTRL / command⌘ key to select editable fields.
Picture 1: Row selection
2. Paste data to a table
Paste tabular data from some source to a table in an SAPUI5 application. This typically initiates a handling of new entries, depending on the application. Use the sample application Cell Selection, Copy & Paste to test. In this context see Streamlining data entry: Exploring the new 'Paste' feature in Fiori Elements V4 tables.
3. Copy a set of values from a table to another field such as a filter field
Use sample app Smart (Responsive) Table with Criticality to try this.
4. Handling split cells with multiple values
In the pictures above you see a column with combined product name and its ID. To handle this, the MS Excel export offers a 'Split cells with multiple values' option. You can achieve a similar behavior for copying data by using 'Paste Special… -> As Unicode Text' when pasting into MS Excel. (See details in Copying and Pasting from External Applications to Tables and CopyProvider.extractDataHandler.)
For application developers
To enable the Copy and Cell Selection features for a table in your custom application, see the details in:
Please note: While these features are built into the Smart Table as well as the Responsive Table and Grid Table control, the availability in individual applications might depend on whether the application enabled the feature. This is the case for applications based on SAP Fiori elements and many other SAPUI5 apps.
In this context, please see details on the Spreadsheet Export. Also note that the Responsive Table received a comprehensive update of its keyboard handling.
2 Comments
