spreadsheet border broken
I made the following result by coding on a spreadsheet.
However, what you see on the screen is slightly different from the actual data.
Each time you scroll up and down, the value of border changes little by little.
this picture is vue spreadsheet with broken border
this picture Excel screen output as actual saveurl
Add to
The cellModel is thought to be as follows, so I coded it as a structure below and made the result like the picture above.
interface cellStyle {
textAlign?: 'left' | 'right' // this.sht.cellFormat({'textAlign': 'Left'}, 'A$3')
verticalAlign?: 'top' | 'bottom'
borderLeft?: string // this.sht.cellFormat({'borderLeft': '2px solid #14522B'}, 'A$3')
borderRight?: string // this.sht.cellFormat({'borderRight': '2px solid #14522B'}, 'A$3')
borderBottom?: string // this.sht.cellFormat({'borderBottom': '2px solid #14522B'}, 'A$3')
borderTop?: string // this.sht.cellFormat({'borderTop': '2px solid #14522B'}, 'A$3')
backgroundColor?: string // this.sht.cellFormat({'backgroundColor': '#14522B'}, 'A$3')
color?: string // this.sht.cellFormat({'color': '#2B2B2B'}, 'A$3')
fontFamily?: string // this.sht.cellFormat({'fontFamily': '돋움'}, 'A$3')
fontSize?: string // this.sht.cellFormat({'fontSize': '15pt'}, 'A$3')
fontStyle?: 'italic' | '' // this.sht.cellFormat({'fontStyle': 'italic'}, 'A$3')
fontWeight?: 'bold' | '' // // this.sht.cellFormat({'fontWeight': 'bold'}, 'A$3')
textDecoration?: 'underline' | ''// this.sht.cellFormat({'textDecoration': 'underline'}, 'A$3')
}
interface cell {
value?: string // this.sht.updateCell({value: '1'}, 'A$1')
formula?: string // this.sht.updateCell({formula: '=SUM(1, 1)'}, 'A$1')
hyperlink?: string // this.sht.updateCell({hyperlink: 'www.naver.com'}, 'A$1')
wrap?: boolean // this.sht.updateCell({wrap: true}, 'A$1')
colSpan?: number // this.sht.updateCell({colSpan: 2}, 'A$1')
rowSpan?: number // this.sht.updateCell({rowSpan: 2}, 'A$1')
style?: cellStyle
}
what'worng??
