Hi all,
I've been using POI-3.0.1-Final for the last 15 days and couldn't
find any ways to solve the following problems. If anyone able to solve them
please help me.
1) Suppose I've a sheet containing values like below
A B C
1 =SUM($A1,def_name) =SUM($A1,def_name)
2 =SUM($A2,def_name) =SUM($A2,def_name)
. ............ ........
and def_name is a value defined in some other sheet other than the
sheet containing the above formulae. When I try to
read B1 and print it, it is showing =SUM($B1,def_name) and for C1 it
is showing =SUM($C1,def_name) like that..
2) When I write some formulae into a new excel file and open it the
formulae are not evaluating on their own / excel not
evaluating them. When I press F2 + Enter then they are evaluating.
3) I've searched forum for handling Shared Formulae but couldn't find
any. I'm also not able to read them like most who
have posted so.
Need help regarding the above mentioned problems.
Thank You.
--
View this message in context:
http://www.nabble.com/Problem-while-reading-formulae-containing-references-tf4085302.html#a11611450
Sent from the POI - User mailing list archive at Nabble.com.
