List of str is incorrectly prepped using json.dumps on newer Python version

[melvinkcx]

If you have a list of strings as value, the XLSXListField incorrectly preps it using json.dumps().

I believe this is not an intended behaviour, judging from the code comments.

This probably has to do with the fact that str is also an Iterable in newer versions of Python.

One potential solution that I found is:

https://stackoverflow.com/a/44328500/10955067

---

Workaround

Use xlsx_custom_mappings:

xlsx_custom_mappings = {
        col: lambda value: ", ".join(map(str, value))
        for col in [
            "col_1", "col_2", "col_3
        ]
    }

[rptmat57]

good catch

[melvinkcx]

Thanks for the quick fix! Would it be possible to get it released soon?

[FlipperPA]

@melvinkcx @rptmat57 I can actually get this published today, since I'm at the Wagtail Space sprints.

[FlipperPA]

@rptmat57 @melvinkcx I've published as version 2.4.1 with a few bug fixes and... a long overdue upgrade to pyproject.toml!

[melvinkcx]

Thanks for the quick action, much appreciated!