its a bit of a hack, but in the ready event you can modify the table:
google.visualization.events.addListener(Table, 'ready',function () {
$TableTarget.find('.google-visualization-table-td-bool:contains("✗")').
css('color', 'red');
$TableTarget.find('.google-visualization-table-td-bool:contains("✔")').
css('color', 'green');
});
On Tuesday, January 31, 2017 at 3:35:33 AM UTC-8, Ryan wrote:
> Hello,
>
>
> I have linked my google charts table to my google sheets and on my google
> sheet I have this:
>
>
> <https://lh3.googleusercontent.com/-KiyMq2jeaY0/WJB1FoRz-vI/AAAAAAAAACQ/qKOMaEk2-rYou2hH0vTnM5nPlEukxTNwACEw/s1600/Screenshot%2B%25283%2529.png>
>
> It is achieved with conditional formatting.
>
>
> When I display my table in google charts it changes my true and false to
> ticks and crosses, this means that it is recognised as boolean.
>
>
> <https://lh3.googleusercontent.com/-XG7xpxJNN0w/WJB2YZM21bI/AAAAAAAAACc/7iHBdMUEnBIbcTjIR_TbhsGZ1XW4lnG2gCLcB/s1600/Screenshot%2B%25284%2529.png>
>
>
>
> Is there a way I can apply a formatter to these values to match the
> behaviour above. I have tried this:
>
> var boolFormat = new google.visualization.ColorFormat();
> boolFormat.addRange(false, "", 'black', '#ff8787');
> boolFormat.addRange(true, "", 'black', '#98d381');
> boolFormat.format(data, 3);
>
>
> But it doesn't work and I can't think of any other ways to achieve this.
>
> Any help is greatly appreciated.
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/5ec06051-9455-487c-ad9b-524abf082e40%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
