Hi, this will not work, you are setting text, not a function, see http://poi.apache.org/components/spreadsheet/formula.html and http://poi.apache.org/components/spreadsheet/eval.html for details how to do it.
Dominik On Tue, Jul 30, 2019, 00:20 kalr...@head-in-cloud.com < kalr...@head-in-cloud.com> wrote: > Hi Team, > I am trying to do something like this : > https://imgur.com/zF7HXpn <https://imgur.com/zF7HXpn> > > But its not calculating when doing the same stuff from code like this : > table.getRow(2).getCell(1).setText("=SUM(ABOVE"); > > > > > > -- > Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html > > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org > For additional commands, e-mail: dev-h...@poi.apache.org > >