Order + filter with formatted data

Describe the bug

i need to transform the data to show to the user.

Eg from YYYY-MM-DD to DD/MM/YYYY,
from usd 10.99 to usd 10,99.

Anyway, to order i need to use de original data ( a date or decimal number), to filter i need to use the transformed data or both.
dont exist a property in the row with columnId to return the transformed data (row.original, row.getValue and row.renderValue just return the original data).

i tried to pass the transformed data thru accessorFn: row => formatDate(row.field), but with this approach, i lose the original data in order function, and ordering with transformatted data gives me a wrong ordenation.

how to solve this problem?

Your minimal, reproducible example

https://codesandbox.io/s/nice-ishizaka-s2n6mw?file=/src/App.tsx

Steps to reproduce

create a row
{
header: "name",
accessorKey: "nameKey",
cell: ({getValue}) => formatDate(getValue())
},
// this option i lose the formatted data to filter
or
{
header: "name",
id: 'nameKey',
accessorFn: row => formatDate(row.date),
},
// this option i lose the original data to order

const formatDate = (date: string | Date, format?: string) => {

// console.log("date", date)
format = format || 'dd/MM/yyyy';

return dateFormat(toDate(date), format);

};

Expected behavior

order by original data and filter by transformed data

How often does this bug happen?

Every time

Screenshots or Videos

No response

Platform

all Operating System and Browsers

react-table version

8.9.3

TypeScript version

5.2.2

Additional context

No response

Terms & Code of Conduct

• I agree to follow this project's Code of Conduct
• I understand that if my bug cannot be reliable reproduced in a debuggable environment, it will probably not be fixed and this issue may even be closed.

Start with the linked CodeSandbox and compare the column definitions using cell, accessorFn, getValue, and the sorting and filtering behavior in react-table 8.9.3. Trace how the original and formatted values are exposed for each operation, then verify that the reproduced case can order by the original date or number while filtering by its formatted display value.