David, Can you do me a big favor, generate a sheet that has this error as simple as a sheet as possible. Attach it to a bug in bugzilla. this will allow us to test it, do hex dumps and figure out how to add support for it.
As it stands I'd say writing formulas is much farther along than reading. Thanks, Andy David N Horn wrote: >Hello all. This is my first post to the list and I hope someone will be >able to help me out. > >I am currently using the poi api as part of a larger project (aren't we >all?!) and I need to be able to read in any .xls file and then manipulate >its contents as per the needs of the project. I am able to read in the >files and output the cell contents well enough but I am having problems when >it comes to formula cells. > >Now, from what I have read here, I know formulas are not yet well supported, >but I understand there is _some_ support. I am using dev version 1.8.0 and >my formulas are far from complicated. They are of the type SUM(D3:D15) or >AVERAGE(C9:I9), nothing fancy. > >The code I use reads in the formula cells okay and even recognises them to >be formula cells, but usually displays them as "NO IDEA SHARED FORMULA EXP >PTG". I understand this to mean a shared formula is being used (a shared >formula being one that spans sheets/workbooks?) which is not the case. >Moreover, some of the cells read using poi (actually HSSF) do show as the >correct formula, even though I can see no difference whatsoever between >those that read right and those that do not! Which only adds to the >confusion. > >Is there something I am doing wrong here? Is there no support yet for what >I am trying to do? What can I do to my code to ensure formulas are read >right across the board? > >Thanks for your help folks. > >David N Horn > > >"I like work: it fascinates me. I could sit and look at it for hours." > > - Jerome K Jerome > "Three Men in a Boat" > > > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
