Sheet: moving columns messes up sort/filter display

[jgeekmz]

Describe the bug

Sheet with several columns with sort and filter options. When you add movable option for rows and columns. On one column you do not have sort and filter. So when switch the place on this one with other column with filter and sort the header is moved, but the sort and filter options stayed on the same place as before. I guess this behaviour is bug.

Stack Overflow: https://stackoverflow.com/questions/73248207/primefaces-sheet-component-movable-columns

Reproducer

<pe:sheet id="sheet" widgetVar="sheetWidget" value="#{vertragspreiseForm.lazyModel.getPreiseList()}" var="row"
        rowKey="#{row.pflegeartId}"
        height="400"
        resizableRows="true"
        resizableCols="true"
        fixedCols="2"
        showColumnHeaders="true"
        movableCols="true" movableRows="true">

Expected behavior

When you move a column i expect to move with sort and filter optons as well.

PrimeFaces Extensions version

7.0.3

JSF implementation

No response

JSF version

2.0

Browser(s)

Chrome

[melloware]

Updated with Stack overflow info. My guess is these features were just never tested together as movable columns was added way after sorting/filtering.

[VsevolodGolovanov]

In a cellSelect listener sheet.getSelectedColumn() also reports wrong column index.

pe:sheet widget should do hot.toPhysicalColumn(col), because moving columns changes their visual indexes (which is what most of HOT's API uses).

[melloware]

PR?