mergeCells + td.style + hiddenColumns (PRO Version)

Tags: #<Tag:0x00007efc65460e48>
#1

Hi,

I have some row with cells merged and custom style. If i have one or more hidden columns my custom style is removed.

My Configuration :
hiddenColumns: {
columns: [6],
indicators: false
},
mergeCells: [{“row”:1,“col”:0,“rowspan”:1,“colspan”:6},{“row”:10,“col”:0,“rowspan”:1,“colspan”:6},{“row”:16,“col”:0,“rowspan”:1,“colspan”:6}]

cells: function (row, col, prop) {
    var cellProperties = {};
    switch(spreadsheet.data[row].type) {
        case "title":
        cellProperties.renderer = "titleRenderer";
        break;
        
        case "subtitle":
        cellProperties.renderer = "subtitleRenderer";
        break;
        
        case "total":
        cellProperties.renderer = "sumRenderer";
        break;
        
        default:
        cellProperties.renderer = "defaultNumberRenderer";
    }

    return cellProperties;
},

function titleRenderer(instance, td, row, col, prop, value, cellProperties) {
    Handsontable.renderers.TextRenderer.apply(this, arguments);
    
    /* Font styles */
    td.style.background = '#F3F3F4';
    td.style.textAlign = 'center';
}

Screen without hiddenColumns

Capture d’écran 2016-02-04 à 15.24.39.png955×473 63.6 KB

Screen with hiddenColumns

Capture d’écran 2016-02-04 à 15.25.36.png952×467 46.6 KB

#2

Hi @jbbouillat can you create a full live demo (JSBin/JSFiddle)?

#3

Hi,

With hiddenColumns (Only first line with custom style) : http://jsfiddle.net/dhqd7vxL/39/

Without hiddenColumns (Normal custom style) : http://jsfiddle.net/dhqd7vxL/40/

Best Regards.

#4

Thank for sharing @jbbouillat indeed there’s is an incorrect styling when the column is hidden.

#5

Is it a bug ?

#6

In my option it is, but I have to share this demo with other team members.

#7

Hi @jbbouillat
Are still facing issues with the latest version? We have change many aspects of handling meta data in the latest version 1.9.0. Can you check it please?

#8