UI5 Spreadsheet Export Configuration Value Map

[#1]

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]

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

[rabiaakbulut]

field is char with one length