Hi,
using svyExcelUtils _cell.setCellFormula when you open the file the formula is correct but the value is zero.
I solve it setting _cell.setCellValue(null) after;
_cell = _rowSum.createCell(i+1); _cell.setCellFormula("SUM(" + scopes.svyExcelUtils.getCellReferenceFromRange(2, 1 + _rowNum, i+1, i+1) + ")"); _cell.setCellValue(null);
Is only a suggestion to put it on the example of the wiki.
Un Saludo
Juan Ramírez
Hi,
using svyExcelUtils _cell.setCellFormula when you open the file the formula is correct but the value is zero.
I solve it setting _cell.setCellValue(null) after;
_cell = _rowSum.createCell(i+1); _cell.setCellFormula("SUM(" + scopes.svyExcelUtils.getCellReferenceFromRange(2, 1 + _rowNum, i+1, i+1) + ")"); _cell.setCellValue(null);Is only a suggestion to put it on the example of the wiki.
Un Saludo
Juan Ramírez