Problem while reading formulae containing references

[manigarre <ma...@global-analytics.com>]

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.