exported excel cell coloring based on cell value

exported excel cell coloring based on cell value

geethunimeshgeethunimesh Posts: 25Questions: 9Answers: 0

[https://datatables.net/extensions/buttons/examples/html5/excelCellShading.html]
I followed this link. But it didn't get worked. Please help me to track my issue.

Answers

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin

    I think I've introduced a bug into Buttons by mistake - sorry. I'll post back when I've checked that out.

    Allan

  • HPBHPB Posts: 73Questions: 2Answers: 18

    @allan
    Not a bug, it's a feature.

    In earlier versions of buttons all cells would be rendered as:

    <c t="inlineStr"><is><t>Value</t></is></c>
    

    Now you identify numbers and render them as followed:

    <c s="57"><v>Value</v></c>
    

    The example has $('is t', this) as selector, and will not select the cells with the recent versions of buttons.
    All you need to do is change the selector in the example to $('v, is > t', this) and you're done.

  • geethunimeshgeethunimesh Posts: 25Questions: 9Answers: 0

    Yeah, That's right.
    It worked. And I got this
    live.datatables.net/qokabeve/17/edit

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin

    Actually - it was a bug in the example, not the library. This is the commit that fixes it. I'll publish the updated example shortly.

    Thanks,
    Allan

This discussion has been closed.