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

Fri, 29 Aug 2003 13:56:55 +0000

The shared formula record is read only so we can write it back out. I believe it's in the FormulaAggregate Record. The record is there but you can't manipulate it like you would with any regular formula.



Joji John wrote:



Hi Danny,
I was trying to read the shared formula cells in an excel file using apache
POI. Do we have a version of POI that has the capability of reading the
shared formula records? I had tried with the latest code from apache
(poi-bin-2.0-pre3-20030728.zip) and was not able to read the formula. That
is why I am planning to contribute in fixing this bug. Kindly confirm...

Thanks and Regards,
Joji John,
IBM Software Labs,
Airport Road,
Bangalore 560 017
Phone: 91 80 5044974
Email: [EMAIL PROTECTED]


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



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]





---------------------------------------------------------------------
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]

Reply via email to