Giu Fus

Hi, I cannot set the style of a cell containing a replaced value (${myObj.offerValue} a float). The cell has its own dataFormat, that is maintained and the bg color too, but the style of the font is changed and I don't find a way to override it. I tried : <jt:style style.... <jt:style class.... ${{ sheet.getRow(11).getCell(2).setCellStyle(sheet.getRow(11).getCell(1).getCellStyle()); }} Same thing with a Date value, I solved changing the type from Date to LocalDate. Suggestions?

I had not yet discovered this feature but I think that it can just improve maintainability of what I've done, as you said, so thank you, I really appreciate it :) have a great week, bye

Hi, I think I solved, don't know if is a workaround or the better approach, but solved. If you want to take a look this is the template. D10 in sheet #2 should be the sum of all generated Q21. At the moment what I've done is: - tagged Q21 cell with a css class using <jt: style=""> tag - implemented a CellListener that update a beanMap item with the addresses ot the tagged cells (in a string like "Q21,Q31,Q41 etc...") - </jt:> class MyCellListener implements CellListener { @Override public boolean...

I resolved using : - a style tag to mark a cell with a class name, - then implement a custom cell listener that keep updated a list in beans map adding the rowCol indexes of the cell i want to keep track - set cellFormula in the workbook using the list values

Sorry the thread name was deleted after a refresh and it seems I cannot edit it.