Question Re: UI5 Spreadsheet Export Configuration Value Map in Technology Q&A

UI5 Spreadsheet Export Configuration Value Map

rabiaakbulut — Sat, 21 Oct 2023 19:09:28 GMT

Hi All,

I'm exporting ui5 table data to excel. I want to use value map attribute for gender formatting (1 for male, 2 for female) but it's not working.

Here is my code and excel result;

My code not working but same code in the link working. What is the difference?

(https://ui5.sap.com//#/entity/sap.ui.export.Spreadsheet/sample/sap.ui.export.sample.formatting/code)

AlexNecula30 — Mon, 23 Oct 2023 04:37:42 GMT

Just a thought, check how these IDs are returned from the service. Maybe they are actually returned with some leading 0s?

rabiaakbulut — Mon, 23 Oct 2023 06:35:54 GMT

field is char with one length

junwu — Mon, 23 Oct 2023 14:08:41 GMT

how about put "1" "2" in your value mapping?