Bug 36941

I have an Excel file with some formulas, some of them return "NO IDEA SHARED
FORMULA EXP PTG" when I use:

HSSFCell.getCellFormula()

I have found some postings and some bugs with similar issues, some seem to
fixed, some not. Seems to have something to do with "shared formulas". Since I
use the latest version of POI (poi-3.0-alpha1-20050704.jar) and I don't know if
it's the same issue, I opened a new bug to attatch my excel sheet causing the
problems. I cannot reproduce such a "problematic" excel sheet by myself, it
comes from someone else.

If I change the values of some cells in the sheet, that's not a problem. I also
can copy the cells to an other spreadsheet or workbook - the problem "survives".

Only if I remove a complete row or a complete column before (in Excel!), the
formulas suddenly appear when I try to read them using HSSFCell.getCellFormula().

You can find the problematic cells / formulas in G59:G64

I also attatched a (very) simple java class for testing.

Some other Bugs/Postings talk about similar problems and patches for it, but I
can't find a POI version where these patches are applied, or it must be a
different problem.

I don't understand how people can use Formula Reading from POI, the error
happend with the latest version of POI and with the third Excel file I ever tested!