SpreadJs set border on a merged range

Asked Mar 19 '19 at 15:28

Active Mar 19 '19 at 15:28

Viewed 221 times

I would like to set a border on a merged range using spreadJs spreadsheet library, however I cannot get this to work.

const lineStyle = GC.Spread.Sheets.LineStyle;
const lineBorder = GC.Spread.Sheets.LineBorder;
const borderColor = 'rgb(255,0,0)';

var option = {
    all: true
};

sheet
    .getRange(1, 1, 3, 2)
    .setBorder(new lineBorder(borderColor, lineStyle.thin), option);

Instead it is just doing the top left square, has anyone got any ideas?

asked Mar 19 '19 at 15:28

user3284707

3,033
3
35
69

Which version of spreadJS are you using? – matvs Mar 19 '19 at 16:25
I'm using version 12.0.7 – user3284707 Mar 19 '19 at 16:52
How are you creating the span? What framework are you working in? It seems to be working on my end – GrapeCity Team Mar 21 '19 at 20:51

SpreadJs set border on a merged range

0 Answers0