Posted 23 October 2018, 8:11 pm EST - Updated 3 October 2022, 2:04 am EST
Hi,
I have to add functionality in spreadsheet js when user provide size in input box and set size to whole column. For implementing, I have using below command for set column width :
sheet.setColumnWidth(_columnIndex, _columnSize, GC.Spread.Sheets.SheetArea.colHeader);
When I fetching column width size, I am using below command :
spread.getActiveSheet().getColumnWidth(_columnIndex, GC.Spread.Sheets.SheetArea.viewport)
It’s working fine to set and get column width, Problem is that when I set column width example : 400 and check column size on web browser it’s showing different number like : 360
I have attached screenshot which measure size of column.
One more thing, would you please tell me what is measure parameter of getCellRect() and getColumnWidth() methods. Means both method return same width parameter of a cell but have different value.
Regards,
Ravish Patel