poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hehabr <heh...@web.de>
Subject Re: Apache POI: How to update excel file with many formulas?
Date Thu, 03 Aug 2017 13:07:29 GMT
Can you share the Excel file? -- No. Sorry. There are "hundreds" of formulas
inside. The beginning of the chain looks like this:

D5	=C34

C34	=SUM(A8:A13)

A8	=IFERROR(SUM(B22);0)
A9    "is empty"
A10	=SUM(B24)
A11  "is empty"
A12	=SUM(B26)
A13  "is empty"

B22	=SUM(D12:F12)
B24	=SUM(D14:F14)
B26	=SUM(D16:F16)


D12	=SUM(D30:D40)
E12
=IF(H9="Yes";MAX(E18-(J18-J20)*SheetA!B2;SheetA!C2);MAX(E18-(J18-J20)*SheetA!F3;SheetA!F3)-IF(E9>0;F59;0))
F12	=F228/(D458+E58)*(D82+E82)

D14	=IF(H54>0;D40/H40/I40/J40*H64*I64*J64;0)
E14	=E40/H40*H64+E40/J40*(J64-J40)*0,3
F14	=F40/(D40+E40)*(D64+E64)

D16	=IF(H66>0;D42/H42/I42*H66*I66;0)
E16	=E32/H32*H66+E42/J42*(J66-J42)*0,3
F16	=F42/(D42+E42)*(D66+E66)

etc



--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-How-to-update-excel-file-with-many-formulas-tp5728410p5728412.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message