avik        2005/05/31 12:10:47

  Modified:    src/java/org/apache/poi/hssf/model FormulaParser.java
               src/testcases/org/apache/poi/hssf/model
                        TestFormulaParser.java
  Log:
  bug 35084, reported by Stefano Rocca. fixed in Sheet.java
  
  Revision  Changes    Path
  1.21      +1 -1      
jakarta-poi/src/java/org/apache/poi/hssf/model/FormulaParser.java
  
  Index: FormulaParser.java
  ===================================================================
  RCS file: 
/home/cvs/jakarta-poi/src/java/org/apache/poi/hssf/model/FormulaParser.java,v
  retrieving revision 1.20
  retrieving revision 1.21
  diff -u -r1.20 -r1.21
  --- FormulaParser.java        18 May 2005 18:58:57 -0000      1.20
  +++ FormulaParser.java        31 May 2005 19:10:47 -0000      1.21
  @@ -129,7 +129,7 @@
    
       /** Recognize an Alpha Character */
       private boolean IsAlpha(char c) {
  -        return Character.isLetter(c) || c == '$';
  +        return Character.isLetter(c) || c == '$' || c=='_';
       }
       
       
  
  
  
  1.17      +15 -0     
jakarta-poi/src/testcases/org/apache/poi/hssf/model/TestFormulaParser.java
  
  Index: TestFormulaParser.java
  ===================================================================
  RCS file: 
/home/cvs/jakarta-poi/src/testcases/org/apache/poi/hssf/model/TestFormulaParser.java,v
  retrieving revision 1.16
  retrieving revision 1.17
  diff -u -r1.16 -r1.17
  --- TestFormulaParser.java    18 May 2005 18:58:57 -0000      1.16
  +++ TestFormulaParser.java    31 May 2005 19:10:47 -0000      1.17
  @@ -388,6 +388,21 @@
                        assertTrue("IntPtg",(ptgs[1] instanceof IntPtg));
                        assertTrue("DividePtg",(ptgs[2] instanceof DividePtg));
        }
  +     
  +     /** bug 35027, underscore in sheet name*/
  +     public void testUnderscore() {
  +             HSSFWorkbook wb = new HSSFWorkbook();
  +     
  +     wb.createSheet("Cash_Flow");;
  +     
  +     HSSFSheet sheet = wb.createSheet("Test");
  +     HSSFRow row = sheet.createRow(0);
  +     HSSFCell cell;
  +     
  +     cell = row.createCell((short)0);
  +     cell.setCellFormula("Cash_Flow!A1");
  +             
  +     }
   
        public static void main(String [] args) {
           System.out.println("Testing 
org.apache.poi.hssf.record.formula.FormulaParser");
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/

Reply via email to