First of all - AWESOME JOB on the "update" webinars! Exciting stuff!!
I'm having an issue with setting the numberCellStyle using the svyUtils...
My output puts a "." after ALL number cells (e.g. 0. , 5. , etc.). I had a look through svyExcelUtils.js and tried this code:
- Code: Select all
numberCellStyle = workbook.createCellStyle();
numberCellStyle.cloneStyleFrom(workbook.rowStyle);
numberCellStyle.setAlignment(scopes.svyExcelUtils.ALIGNMENT.RIGHT);
numberCellStyle.setDataFormat("#,###,###");
workbook.numberCellStyle = numberCellStyle;
but no luck in removing the "." in the number cells. I'm SURE it's a stupid user error - but I would appreciate any point in the right direction...
Bob