Re: Bugzilla Bug 20321 "NO IDEA SHARED FORMULA EXP PTG" appears whenread copy/paste formula HSSF

[Danny Mui]

The write way to fix this is to undo the "optimization" of the shared 
formula.  Instead of referencing an EXP ptg, we should expand the 
formula in full when reading the file (sheet.fillfields).  My first cut 
with shared formulas was to just allow it to be read.  Didn't realize 
people messed with the shared formula fields.

Having the Excel Developer's SDK book is a real help for doing this but 
using the BiffViewer and reading hex dumps can work as well.

Joji John wrote:



Yes, The problem is excatly what you are describing. I would like to know
if I can work with somebody to fix this problem and thus contribute to this
project. I require some directions to fix this bug.
Thanks and Regards,
Joji John,


                                                                                                          
                     Danny Mui                                                                            
                     <[EMAIL PROTECTED]        To:       POI Developers List <[EMAIL PROTECTED]>  
                     m>                       cc:                                                         
                                              Subject:  Re: Bugzilla Bug 20321 "NO IDEA SHARED FORMULA    
                     08/22/2003 10:15          EXP PTG" appears when read copy/paste formula  HSSF        
                     PM                                                                                   
                     Please respond to                                                                    
                     "POI Developers                                                                      
                     List"                                                                                
                                                                                                          
                                                                                                          



The bug in question occurs when you try to modify a cell in the
copy/pasted formula group.  If you're simply reading/writing AROUND
these cells you should be fine.  In the future we should break up the
shared formula to be regular formulas.
If this isn't what you're doing, please submit a new bug report with
example code (simplest amount of code possible) and the excel file that
duplicates this problem.
Joji John wrote:

 

Hi,
I am using HSSF to read microsoft excel files. Now, we have a situation
same as the one  described in Bug # 20321. I had taken the latest poi jar
file poi-bin-2.0-pre3-20030728.zip  updated at  28-Jul-2003 11:56 and
   

found
 

the problem persisting. Do we have some information on any possible fix to
this defect?
Thanks and Regards,
Joji John,
IBM Software Labs,
Airport Road,
Bangalore 560 017
Phone: 91 80 5044974
Email: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


   



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]