DO NOT REPLY [Bug 20321] New: - "NO IDEA SHARED FORMULA EXP PTG" appears when read copy/paste formula

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20321>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20321

"NO IDEA SHARED FORMULA EXP PTG" appears when read copy/paste formula

           Summary: "NO IDEA SHARED FORMULA EXP PTG" appears when read
                    copy/paste formula
           Product: POI
           Version: 2.0-dev
          Platform: Other
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Critical
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: mlzhao@sina.com.cn


Environment: W2k professional + Excel 2000 + POI 2.0pre1
question 1: I copy a formula and paste it to a serial cells in a excel file in 
MS Excel. Then I read the pasted formulas to a String, the String is "NO IDEA 
SHARED FORMULA EXP PTG".

question 2: After I modify one of the pasted formula to a number, and save the 
workbook to another excel file, I open the file in MS Excel. All of the cells 
which reference the modified cell appeared #REF!. I'm not sure if it is the 
same question as bug 15223, because after I get the latest code from CVS, 
things not changed.