I have page properties that are generated by user macros (e.g., key: creator, value:

is a user macro specified by our admins. The user macro looks like this:

<ac:link>
        <ri:user ri:userkey="$content.getCreator().getKey()"/>
</ac:link>

Note that this is only an example macro, I have more user macros that generate different content stored in values of the the page properties macro. Note also that all keys in the page properties macro are lowercase to avoid the bug CONF-32257.

In the page properties report macro, sorting by a predefined column does not work, the pages are sorted by last modified date as specified in the default behaviour. However, manual sorting by clicking on the respective column after the table has been generated works as expected.

I did not find any workaround to enable automatic sorting in the report with values generated by user macros.