Incorrect cell value when generating Excel using write_file and digits with data type "s"

[GoennerJens]

Cells are filled with digits and data type char using set_cell. Incorrect values are displayed in the cell during generation.

[sandraros]

abap2xlsx permits to write numbers as numbers instead of text.
Could you indicate how to reproduce this issue?

[GoennerJens]

The following error occurs in the method ZCL_EXCEL_WRITER_2007->CREATE_CL_SHAREDSTRINGS: lt_cell_value is sorted by call_value and then adjacent duplicates are deleted. However, if there are now two cells with the same cell value but one with data type ‘s’ and one with an initial data type, it is possible that only the cell with the initial data type remains in lt_cell_data. In the following loop, however, only cells with data type ‘s’ are considered. This means that the string is not written to shared_strings.
A quick fix for me was to include a ‘DELETE lt_cell_data WHERE data_type <> “s”’ However, I can also imagine better solutions here.

[sandraros]

Thank you. We need first to reproduce the bug before fixing the code. Could you indicate how to reproduce this issue?

[sandraros]

What I was asking for, is a minimal reproducible example e.g. see one in this other issue

Thank you.