You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by "kalra.p@head-in-cloud.com" <ka...@head-in-cloud.com> on 2019/07/29 22:20:37 UTC
=SUM(ABOVE) in apache poi docx. How to write it to cell so that i
can calculate sum of above cells
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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: =SUM(ABOVE) in apache poi docx. How to write it to cell so that i
can calculate sum of above cells
Posted by Dominik Stadler <do...@gmx.at>.
Ups, sorry, saw to late that you are talking about docx, not xlsx. Not sure
if this is possible there...
Dominik
On Wed, Jul 31, 2019, 07:11 Dominik Stadler <do...@gmx.at> wrote:
> 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 kalra.p@head-in-cloud.com <
> kalra.p@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-unsubscribe@poi.apache.org
>> For additional commands, e-mail: dev-help@poi.apache.org
>>
>>
Re: =SUM(ABOVE) in apache poi docx. How to write it to cell so that i
can calculate sum of above cells
Posted by Dominik Stadler <do...@gmx.at>.
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 kalra.p@head-in-cloud.com <
kalra.p@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-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
>
>