Hi, Tim

Thanks for reaching out to us

1.

Regarding "freezing" column  or row, or "sticky" functionality, 

- Sorry to disappoint you but unfortunately something like this is not possible to achieve with the plugin built-in features at the moment or some simple CSS.

Our developers will work to add it as a built-in feature, but i can't say an ETA on it.

You can suggest this as a built-in feature on this link https://wpdatatables.com/documentation/feature-suggestion/ and our developers would place it on their "TO-DO" list.

As more customers request a feature, it gets pushed quicker on the list. We always strive to make our product better and deliver the most value to our end users, so we carefully review each suggestion

-

At this time, it can only be made with custom solutions.

Here is a workaround suggestion from our customer that managed to achieve a similar solution :

"I actually created a fixed header and column using the translation of x and y (no absolute or fixed position used), very similar to the fixed header provided by weihs5  on this site, and here's one solution, take a look:

First of all, you gotta set the z-index for each component below:

jQuery("#table td").css({"z-index": "-1", "position": "relative"});
jQuery("table tr td:first-child").css({'z-index': '1', 'position': 'relative'});
jQuery("table th:first-child").css({ 'z-index':'2','position':'relative'});

Then you gotta add a listener on scroll like this:

jQuery('document').scroll(function () {   scrollBlock();
});

If your table is set to be scrollable, then you might want to add this in as well:

jQuery('.wdtscroll').scroll(function () { scrollBlock();
});

And here's the scrollBlock() part, it is ugly though, but it works for me though. (noted: the numbers work for my theme, if it is not working correctly on yours, then try to adjust the number until it fits.)

function scrollBlock(){  var table = document.querySelector('table');
var top = table.getBoundingClientRect().top;
top = document.body.className.search('admin') > 0 ? top - 32 : top + 3; // this value can change            var left = table.getBoundingClientRect().left;            if(left >= 20){ // before scrolling left (before transforming)                                if(top >= 0){ // before reaching header bar                    jQuery("#table_1 thead th").css("transform", "translateY(0px)");                     translate(jQuery("table th:nth-child(1)"), 0, 0);                     translate(jQuery("table td:nth-child(1)"), 0, 0);                                    } else{ // after reaching header bar                     jQuery("#table_1 thead th").css("transform", "translateY( " + (-top) + "px)");                     translate(jQuery("table th:nth-child(1)"), 0, -top);                     translate(jQuery("table td:nth-child(1)"), 0, 0);                 }            } else { // after scrolling left                                if(top >= 0){                    jQuery("#table_1 thead th").css("transform", "translateY(0px)");                    translate(jQuery("table th:nth-child(1)"), -left + 46, 0);                    translate(jQuery("table td:nth-child(1)"), -left + 46, 0);                                    } else{                     jQuery("#table_1 thead th").css("transform", "translateY( " + (-top) + "px)");                     translate(jQuery("table th:nth-child(1)"), -left + 46, -top);                     translate(jQuery("table td:nth-child(1)"), -left + 46, 0);                     }                }            }
function translate(element, x, y) {
var translation = "translate(" + x + "px," + y + "px)"
element.css({      "transform": translation,       "-ms-transform": translation,          "-webkit-transform": translation,     "-o-transform": translation,      "-moz-transform": translation,   });
}

It is kind of messy, you definitely can't copy and paste and expect it to work for you. You need to spend some time to figure it out. Hope this helps everyone!"

So hopefully this can help you out.

2.

cell colour conditional formatting based on the content of another cell in the same row (hidden from the user)

-

I believe we have the solution for that. I can not see a "Next Weeks Team" column on the table from that page; but seems that i understand what you mean.

For example, you can try to set a conditional rule on the column, like this:

in this dummy table, i set for the column "first name", if it contains string "aleks", make the row red color:

-

 Can you please check out more details on our Conditional Formatting explained here.

Let me know how that sounds, and if you have any questions.

-

Just wanted to point out that we have a sandbox/Demo site (https://sandbox.wpdatatables.com/), that you can use to try out some of the plugin's features;

and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out,
we will assist along the way,
and if it doesn't fit your needs you can request and receive a refund in that period.

Hi, Tim

Sorry for so much waiting time.

-

Thank you for clarifying, i definitely misunderstood the first time.

I have been testing this out, and unfortunately at this time, we don't have a built-in solution to achieve what you described.

These are all the available functionalities for conditional formatting that we currently have, as shown on the screenshot.

We can only set a condition from one cell of a column, if a condition is met,

 to affect it's cell, or its column, or an entire row;

The developers might add this functionality in the future, but as mentioned earlier, we can't say an ETA on new features that they haven't started working on yet.

You can suggest this conditional formatting feature on the same page, and i will make sure to bring their attention to it.

I forgot to add, you can also follow our changeLog page, where we always state new features/fixes at each update.

-

If you need a custom solution for something like this at this time,

we can only suggest reaching out to teams that do quality custom solutions, such as WP Kraken, but we don't know their pricing.

Let me know if i have perhaps misunderstood the intended goal again, and if you have any questions. Thanks

Hi, Tim

Apologies, i also want to thank you for working on a better solution on the first point - the sticky header functionality;

you can certainly add your workaround as part of the description as a feature suggestion - and i am sure our developers will find use to work on implementing it in the future.

We appreciate suggestions to improve the plugin or any feedback with the highest value. Thank you