Uploaded September 2021 | Updated September 2026, 2 weeks ago
In this episode of #UI5erslive, we reinforce our team by two developers from our controls teams. Tereza Chobanova demonstrates the most important #UI5TmeRelated elements to deliver a user-friendly, efficient application UI and shares some tips and best practices working with these controls.
Then Sebastian Bender brings some latest features with him and talks about configuration and formatting options to export spreadsheets (#UI5SpreadsheetExport). In addition Stefan Beck gives some updates on the #UI5 version 1.90.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Video Chapters:
00:00 Welcome
01:33 Latest News around UI5 1.90
04:28 Demo: Showcasing features in time-related controls
18:22 Spreadsheet Export in SAPUI5 - Goals
21:54 Spreadsheet Export in SAPUI5 - Workflow
25:16 Spreadsheet Export in SAPUI5 - Samples and Documentation
31:15 Spreadsheet Export in SAPUI5 - Supported Types
34:14 Spreadsheet Export in SAPUI5 - Formatting Options
35:16 Questions & Answers
35:28 Open Sourcing Spreadsheet Export
36:12 Multiple Sheet Support, Cell Locking and Data Validation in Spreadsheet Export
38:20 Smooth Scrolling in #UI5GridTable
41:00 Final words
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Resources:
What's New in SAPUI5 1.90: ui5.sap.com/#/topic/b47520229109430cba291b5290848c08
Date/Time Related Controls Documentation:
openui5.hana.ondemand.com/#/topic/e1ddc69c01474faf830a522db8c9238a
Spreadsheet Documentation:
Overview: ui5.sap.com/#/topic/2691788a08fc43f7bf269ea7c6336caf
Spreadsheet Export Configuration: ui5.sap.com/#/topic/7e12e6b9154a4607be9d6072c72d609c
Data Types for Spreadsheet Export: ui5.sap.com/#/topic/283217d8f187401c8045723abc27e5e0
Spreadsheet API Reference:
ui5.sap.com/#/api/sap.ui.export.Spreadsheet
Spreadsheet Samples:
Smart Table with Spreadsheet Export: ui5.sap.com/#/entity/sap.ui.comp.smarttable.SmartTable/sample/sap.ui.comp.sample.smarttable.mtable
Spreadsheet Export with Column Formatting: ui5.sap.com/#/entity/sap.ui.export.Spreadsheet/sample/sap.ui.export.sample.formatting
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Music: klinik FX
In this episode of #UI5erslive, we reinforce our team by two developers from our controls teams. Tereza Chobanova demonstrates the most important #UI5TmeRelated elements to deliver a user-friendly, efficient application UI and shares some tips and best practices working with these controls.
Then Sebastian Bender brings some latest features with him and talks about configuration and formatting options to export spreadsheets (#UI5SpreadsheetExport). In addition Stefan Beck gives some updates on the #UI5 version 1.90.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Video Chapters:
00:00 Welcome
01:33 Latest News around UI5 1.90
04:28 Demo: Showcasing features in time-related controls
18:22 Spreadsheet Export in SAPUI5 - Goals
21:54 Spreadsheet Export in SAPUI5 - Workflow
25:16 Spreadsheet Export in SAPUI5 - Samples and Documentation
31:15 Spreadsheet Export in SAPUI5 - Supported Types
34:14 Spreadsheet Export in SAPUI5 - Formatting Options
35:16 Questions & Answers
35:28 Open Sourcing Spreadsheet Export
36:12 Multiple Sheet Support, Cell Locking and Data Validation in Spreadsheet Export
38:20 Smooth Scrolling in #UI5GridTable
41:00 Final words
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Resources:
What's New in SAPUI5 1.90: ui5.sap.com/#/topic/b47520229109430cba291b5290848c08
Date/Time Related Controls Documentation:
openui5.hana.ondemand.com/#/topic/e1ddc69c01474faf830a522db8c9238a
Spreadsheet Documentation:
Overview: ui5.sap.com/#/topic/2691788a08fc43f7bf269ea7c6336caf
Spreadsheet Export Configuration: ui5.sap.com/#/topic/7e12e6b9154a4607be9d6072c72d609c
Data Types for Spreadsheet Export: ui5.sap.com/#/topic/283217d8f187401c8045723abc27e5e0
Spreadsheet API Reference:
ui5.sap.com/#/api/sap.ui.export.Spreadsheet
Spreadsheet Samples:
Smart Table with Spreadsheet Export: ui5.sap.com/#/entity/sap.ui.comp.smarttable.SmartTable/sample/sap.ui.comp.sample.smarttable.mtable
Spreadsheet Export with Column Formatting: ui5.sap.com/#/entity/sap.ui.export.Spreadsheet/sample/sap.ui.export.sample.formatting
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Music: klinik FX





, and Tobias Sorn, from the UI5 development team.
Now that it was officially announced that wdi5 becomes the legitimate successor of UIVeri5, we want to talk with Volker about what is currently happening in the project and the roadmap planning for #wdi5.
Tobias is in charge of two new features or rather changes in the #UI5 framework, which were delivered with UI5 version 1.99. The first one concerns the parsing of numbers and its change to strict parsing. Tobias will tell you what this means and how this affects your UI5 app. As his second topic, Tobias will introduce the new configuration option to set timezones.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Video Chapters:
00:00 Welcome
01:51 #UI5conONAIR2022 (https://openui5.org/ui5con/germany2022/)
03:53 The State of JS Survey (https://2021.stateofjs.com/en-US/libraries/front-end-frameworks)
04:56 Introduction to wdi5
06:00 Demo: Sample test with wdi5
08:16 Debugging wdi5 tests at runtime and run your app in a test-driven development mode
09:02 Demo: Debugging wdi5 tests at runtime
10:32 Demo: Run wdi5 in a test-driven development mode
11:37 The way forward for wdi5
12:49 wdi5 compared to UIVeri5
13:50 Number and Dates (https://openui5.hana.ondemand.com/entity/sap.ui.core.mvc.XMLView/sample/sap.ui.core.sample.ViewTemplate.types)
14:18 Number Parsing: Decimal Separator Issue when switching between locales or languages (https://en.wikipedia.org/wiki/Decimal_separator)
15:05 Changes in Behavior in Number Parsing as of UI5 1.99 (and 1.96.6)
21:44 New (experimental) feature as of UI5 1.99: Set Timezone (https://openui5.hana.ondemand.com/api/sap.ui.core.Configuration#methods/setTimezone)
25:00 New (experimental) OData Type as of UI5 1.99: Date Time with Timezone
26:15 Demo: #getDateTimeWithTimezoneInstance() (https://openui5.hana.ondemand.com/api/sap.ui.core.format.DateFormat#methods/sap.ui.core.format.DateFormat.getDateTimeWithTimezoneInstance + https://openui5.hana.ondemand.com/api/sap.ui.core.format.DateFormat.DateTimeWithTimezone)
28:21 Referring to #SAPUI5 Long-Term Support Versions on CDN without Specifying a Concret Patch Level
33:51 New Feature in #Easy-UI5 Generator 3.3.0
34:33 npm init wrapper for Easy-UI5 (https://blogs.sap.com/2022/03/10/easy-ui5-getting-started-even-easier/)
35:52 Demo: Using option npm init with Easy-UI5
36:35 Demo: Using option easy-ui5 binary
36:52 Demo: Using option npx with Easy-UI5
38:01 Final Words
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Resources:
wdi5 Documentation: https://js-soft.github.io/wdi5/#/
wdi5 Roadmap: https://github.com/orgs/js-soft/projects/1/views/4
SAPUI5 Version Overview: https://ui5.sap.com/versionoverview.html
Blog Post about Patch-Level Independing Bootstrap: https://blogs.sap.com/2022/04/14/sapui5-patch-level-independent-bootstrap/
npm-init wrapper for Easy-UI5: https://www.npmjs.com/package/create-easy-ui5
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Music: klinik FX UI5ers live #16: wdi5, Strict Number Parsing, Set Timezone, Evergreen URL, Easy-UI5](https://i.ytimg.com/vi/iZ5P2BfkWo0/mqdefault.jpg)




