Activity for Giu Fus
-
Giu Fus posted a comment on discussion General Discussion
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.
-
Goal: put in D10 of 2nd sheet the sum of Q21 and all other generated cell
-
result xls
-
template file
-
Hi, I need an hand to find the better approach to solve my requirement: Attached you find the template i'm working on, the result and a video to explain my problem: How to use a formula in a section of the xls that reference to cells populated by a foreach of another section. I hope you can give me some tips. Thanks
1