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]
