[Missing information about "Spit cells into multiple values" feature on excel export]

[as-copilot]

Issue description

Hi Colleagues,

There is no information in the documentation on how to hide/disable “Spit cells into multiple values checkbox” in an app developed using Fiori Elements V4 or how to set the column headers for split columns in the exported excel.

The problem is when this checkbox is marked, the label headers for split columns in the exported excel are not localized. If there is a way to influence the column header for split columns. That solution is also appreciated.

Thanks in advance!

Feedback Type (Optional)

clarity

Page Title on SAP Help Portal (prefilled)

Using the Export Feature

Page URL on SAP Help Portal (prefilled)

https://github.com/SAP-docs/sapui5/blob/main/docs/06_SAP_Fiori_Elements/using-the-export-feature-4bab6f2.md

[KvM2]

Hi @as-copilot , thanks for your contribution . We appreciate it and will look into this.

[AdrianaRojas33]

Hi @as-copilot,

Currently Fiori Elements v4 allows to disable/enable the export functionality on a table, but not only customize the 'split cells into multiple values checkbox' option.
Using the split cells with multiple values option, the exported spreadsheet has a dedicated column per value (property). If one column contains multiple values in a cell (for example, amount and currency/unit), this results in two separate columns in the spreadsheet using as column header the labels of the values (properties) from the model.

Property labels could be localized using the label annotations: https://github.com/SAP-docs/sapui5/blob/main/docs/06_SAP_Fiori_Elements/localization-of-ui-texts-b8cb649.md#overriding-texts-from-annotations

Best Regards,
Adriana

[as-copilot]

Hi @AdrianaRojas33 ,

Thanks for your reply.

How can one localize the property labels, that are split from a custom column ?
We have a custom column that has two values(name and description). Is there a way to localize the split column headers: name and description.

Thanks!

[AdrianaRojas33]

Hi @as-copilot,

You can change the label annotation on the properties (name and description) wit the corresponding localized value. You will find below an example using CAP CDS annotations, also available on the provided doc.

Best Regards,
Adriana

[as-copilot]

@AdrianaRojas33
Maybe I misunderstand, but a custom column definition is only in the manifest.json and not defined in the CAP CDS annotations file. And if there is no entry for the custom column in annotation file, how can I assign it a label annotation? I do not find any reference to this in the document.

To explain things a bit better, the custom column is defined as following in our manifest :

"NameColumn": {
"header": "{i18n>name}",
"properties": [
"name",
"description"
],
"template": "sap.ui.view.NameColumn",
"importance": "High"
},

How can one localize the column headers for the split columns(name and description) of the above custom column ?

[AdrianaRojas33]

Hi @as-copilot, I noticed you closed this incident, were you able to modify the label of the properties directly on your model or with local annotations?
Custom column are created in the manifest but the properties referenced into the custom column belong to the properties of your model.
Best Regards,
Adriana