if i create a column A (does not matter if it contains a value or is empty), and I define it to Transform Value, eg {columnB.value}, everything works fine - Column A shows the rewritten value taken from column B.
Now i enable responsive column and initially hide column A on mobile hpones and tablets. Now, when I load on a mobile device, the value is not transformed, I am shown the roiginal value auf column A.
This is only the case, when the table is initially loaded in it's collapsed state. When I load the table with a display size greater than by responsive breakpoint, and scale the window down, the value transformation is correctly carried over to the collapsed column.
Further info on the use case we encountered this in:
Source: Google Spreadsheet
Tablet Breakpoint: 5000px (also tested with default 1024px) - we need some tables to always be collapsed and rendered in the <ul> list.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
Thank you for reporting this bug. I am able to reproduce it only for our "non server side" tables.
The issue does not happen on Manual Tables ( which always use our server-side processing) or for MySQL Tables with enabled server-side processing.
But i can catch the bug on a Google Sheet linked Table, which does not have our server-side processing feature.
This is how it renders correctly for collapsed Table Load for server-side Tables :
Compared to the same type of data, on a Google Sheet linked Table, in this case when the Table loads in a 'collapsed' state, as you said - then we can catch this bug, the transformed values are not rendering.
For linked, non server-side tables, as you said - it only loads the 'default cell values' without transforming them.
Our developers isolated the bug, and they'll add it to their queue for fixing.
They will do their best to build a fix as soon as possible.
We don't have an ETA on when the fix will be available, but please keep a lookout on our wpDataTables changeLog.
It will be stated there during updates which bug fixes have been implemented at each update.
-
For the time being, the only way to avoid this bug until we add a fix, as a 'temporary workaround' is if you can switch to imported Tables.
Once the table is created, it is no longer linked to the source file, so changing data in the table will not show up in Excel or Google Spreadsheet, and vice-versa.
Hi there,
if i create a column A (does not matter if it contains a value or is empty), and I define it to Transform Value, eg {columnB.value}, everything works fine - Column A shows the rewritten value taken from column B.
Example:
Data Source: Column A: abc | Column B: def
Visible Table: Column A: abc | Column B: abc
Now i enable responsive column and initially hide column A on mobile hpones and tablets. Now, when I load on a mobile device, the value is not transformed, I am shown the roiginal value auf column A.
Data Source: Column A: abc | Column B: def
Visible Table: Column A: abc | Column B: def
This is only the case, when the table is initially loaded in it's collapsed state. When I load the table with a display size greater than by responsive breakpoint, and scale the window down, the value transformation is correctly carried over to the collapsed column.
Further info on the use case we encountered this in:
Source: Google Spreadsheet
Tablet Breakpoint: 5000px (also tested with default 1024px) - we need some tables to always be collapsed and rendered in the <ul> list.
Thanks and BR,
Florian
Hi Florian,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
Thank you for reporting this bug. I am able to reproduce it only for our "non server side" tables.
The issue does not happen on Manual Tables ( which always use our server-side processing) or for MySQL Tables with enabled server-side processing.
But i can catch the bug on a Google Sheet linked Table, which does not have our server-side processing feature.
This is how it renders correctly for collapsed Table Load for server-side Tables :
Compared to the same type of data, on a Google Sheet linked Table, in this case when the Table loads in a 'collapsed' state, as you said - then we can catch this bug, the transformed values are not rendering.
For linked, non server-side tables, as you said - it only loads the 'default cell values' without transforming them.
Our developers isolated the bug, and they'll add it to their queue for fixing.
They will do their best to build a fix as soon as possible.
We don't have an ETA on when the fix will be available, but please keep a lookout on our wpDataTables changeLog.
It will be stated there during updates which bug fixes have been implemented at each update.
-
For the time being, the only way to avoid this bug until we add a fix, as a 'temporary workaround' is if you can switch to imported Tables.
If you import the file, the plugin reads the source file and creates a manual table.
Once the table is created, it is no longer linked to the source file, so changing data in the table will not show up in Excel or Google Spreadsheet, and vice-versa.
This table will be editable in our Plugin.
If you need quicker editing, you can either switch to the Excel-like view,
and then select and copy the range of cells you want to paste from the source file, and paste it in the Excel-like view,
or you can Update manual tables from source files (CSV, Excel or Google sheet) with three options :
Let me know if that helps.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables