Provide display options for columnType about active-table HOT 6 OPEN

Love working with the system by the way much easier to use than tanstack tables. Especially for working with simple row data.

from active-table.

Hi @jeffreygaggino.

The changeTextFunc property already serves as a post-processor/cleanup function.

I don't think I fully understand the problem that you are describing, could you elaborate on how does it make it difficult to send data to the server? Or could you perhaps illustrate the step by step process that is causing the difficulty.

Thanks!

from active-table.

Front end wise I want to show 12% to the user. At least from my understanding with using the table it seems like I've got to change the actual data to "12%". I would rather want to keep the data to be 0.12 and show to the user "12%". So have a function that doesn't mutate the original value of 0.12 but allows regex / text transformations to display 0.12 as "12%". When they edit it reverts back to the "real" value of 0.12

from active-table.

Here's a couple of images to illustrate this:
Editing:

Display when not editing:

from active-table.

Hey @jeffreygaggino.

Active Table's internal code has been built to only work with actual values from the table cells, hence it is unable to handle pseudo data. For your case, you will unfortunately have to either maintain some sort of an alternative table in your app's state with the help of onCellUpdate or onDataUpdate events where you can postprocess the changed data to your liking or you can alternatively preprocess the data before it goes to your server.

In regards to the two images above, I can see the value is turned into a percentage - except the percentage is processed incorrectly. You will need to upgrade the changeTextFunc function for better processing, e.g (raw JavaScript):

changeTextFunc: (cellText) => {
  if (/^\d*\.?\d+%$/.test(cellText)) {
    return cellText;
  }
  return `${(Number(cellText.replace(/[^0-9.]+/g, '')) * 100).toFixed(2)}%`;
}

This code can be further enhanced for better percentage processing.

from active-table.

Hi,

From what I understand changeTextFunc is only called when the cell value actually changes. Exposing "cell-focus" and "cell-blur" events might allow two way conversion.

from active-table.