cellfrmt.java

The jxcell allows any Java developer to automate any manual spreadsheet process within their organiz

    private void Colorful3(CellFormat cellFmt)
    {
        try{
            m_view.setSelection(savedSelection);
            SetSolidPattern(cellFmt, java.awt.Color.black.getRGB(),java.awt.Color.black.getRGB());
            AdjustFont(java.awt.Color.white.getRGB(), false, false, false, cellFmt);
            m_view.setCellFormat(cellFmt);
            
            m_view.setSelection(hdrRange);
            
            AdjustFont(java.awt.Color.green.getRGB(), true, true, false, cellFmt);
            AlignRight(cellFmt);
            m_view.setCellFormat(cellFmt);
            
            m_view.setSelection(colRange);
            AdjustFont(java.awt.Color.magenta.getRGB(), true, true, false, cellFmt);
            m_view.setCellFormat(cellFmt);
            
        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
    }//Colorful3
    
    private void List1(CellFormat cellFmt)
    {
        String newSelection, numberFormat;
        int fcolor, bcolor;
        
        try{
            m_view.setSelection(savedSelection);
            //Outline Border - thin
            cellFmt.setTopBorder(CellFormat.eBorderThin);
            cellFmt.setLeftBorder(CellFormat.eBorderThin);
            cellFmt.setRightBorder(CellFormat.eBorderThin);
            cellFmt.setTopBorderColor(m_view.getPaletteEntry(16));
            cellFmt.setLeftBorderColor(m_view.getPaletteEntry(16));
            cellFmt.setRightBorderColor(m_view.getPaletteEntry(16));
            m_view.setCellFormat(cellFmt);
            
            m_view.setSelection(hdrRange);
            SetSolidPattern(cellFmt, m_view.getPaletteEntry(14).getRGB(),java.awt.Color.black.getRGB());
            AdjustFont(java.awt.Color.blue.getRGB(), true, true, false, cellFmt);
            AlignCenter(cellFmt);
            m_view.setCellFormat(cellFmt);
    
            m_view.setSelection(ftrRange);
            SetSolidPattern(cellFmt, m_view.getPaletteEntry(14).getRGB(),java.awt.Color.black.getRGB());
            AdjustFont(java.awt.Color.blue.getRGB(), true, false, false, cellFmt);
            numberFormat = "$ #,##0.00_);(#,##0.00)";
            cellFmt.setNumberFormat(numberFormat);
            AlignRight(cellFmt);
            m_view.setCellFormat(cellFmt);
            
            fcolor = m_view.getPaletteEntry(19).getRGB();
            bcolor = java.awt.Color.red.getRGB();
            for (int i = m_view.getSelStartRow() + 1; i < m_view.getSelEndRow() - 1; i = i + 2)
            {
                newSelection =  m_view.formatRCNr(i, m_view.getSelStartCol(), false) +
                                ":" + m_view.formatRCNr(i, m_view.getSelEndCol(), false);
                                
                m_view.setSelection(newSelection);
                SetHatchPattern(cellFmt, fcolor, bcolor);
                m_view.setCellFormat(cellFmt);
            }
    
            fcolor = java.awt.Color.white.getRGB();
            bcolor = m_view.getPaletteEntry(15).getRGB();
            for (int i = m_view.getSelStartRow() + 2; i < m_view.getSelEndRow() - 1; i = i + 2)
            {
                newSelection =  m_view.formatRCNr(i, m_view.getSelStartCol(), false) +
                                ":" + m_view.formatRCNr(i, m_view.getSelEndCol(), false);
                                
                m_view.setSelection(newSelection);
                SetHatchPattern(cellFmt, fcolor, bcolor);
                m_view.setCellFormat(cellFmt);
            }
            
        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
    }    
            
    private void List2(CellFormat cellFmt)
    {
        String numberFormat, newSelection;
        int fcolor, bcolor;
        
        try{
            m_view.setSelection(savedSelection);
            //Outline Border - thin
            cellFmt.setTopBorder(CellFormat.eBorderThin);
            cellFmt.setLeftBorder(CellFormat.eBorderThin);
            cellFmt.setRightBorder(CellFormat.eBorderThin);
            cellFmt.setTopBorderColor(m_view.getPaletteEntry(16));
            cellFmt.setLeftBorderColor(m_view.getPaletteEntry(16));
            cellFmt.setRightBorderColor(m_view.getPaletteEntry(16));
            m_view.setCellFormat(cellFmt);
        
           m_view.setSelection(hdrRange);
           cellFmt.setTopBorder(CellFormat.eBorderThick);
           cellFmt.setTopBorderColor(m_view.getPaletteEntry(16));
           cellFmt.setBottomBorder(CellFormat.eBorderThin);
           SetSolidPattern(cellFmt, m_view.getPaletteEntry(15).getRGB(),java.awt.Color.black.getRGB());
           AlignCenter(cellFmt);
           AdjustFont(java.awt.Color.red.getRGB(), true, true, false, cellFmt);
           m_view.setCellFormat(cellFmt);
           
           m_view.setSelection(ftrRange);
           cellFmt.setBottomBorder(CellFormat.eBorderThick);
           cellFmt.setBottomBorderColor(m_view.getPaletteEntry(16));
           cellFmt.setTopBorder(CellFormat.eBorderThin);
           numberFormat = "$ #,##0.00_);(#,##0.00)";
           cellFmt.setNumberFormat(numberFormat);
           AlignRight(cellFmt);
           m_view.setCellFormat(cellFmt);
           
           fcolor = java.awt.Color.red.getRGB();
           bcolor = java.awt.Color.white.getRGB();
           for (int i = m_view.getSelStartRow() + 1; i < m_view.getSelEndRow() - 1; i = i + 2)
           {
               newSelection =  m_view.formatRCNr(i, m_view.getSelStartCol(), false) +
                               ":" + m_view.formatRCNr(i, m_view.getSelEndCol(), false);
                                
               m_view.setSelection(newSelection);
               SetHatchPattern(cellFmt, fcolor, bcolor);
               m_view.setCellFormat(cellFmt);
           }
    
        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
        
    
    } //List2
    
    private void List3(CellFormat cellFmt)
    {
        try{
            m_view.setSelection(colRange);
            m_view.setCellFormat(cfmt);
            m_view.setSelection(hdrRange);
            cellFmt.setTopBorder(CellFormat.eBorderMedium);
            cellFmt.setTopBorderColor(java.awt.Color.darkGray);
            cellFmt.setBottomBorder(CellFormat.eBorderMedium);
            cellFmt.setBottomBorderColor(java.awt.Color.darkGray);
            AlignCenter(cellFmt);
            AdjustFont(m_view.getPaletteEntry(11).getRGB(), true, false, false, cellFmt);
            m_view.setCellFormat(cellFmt);
            
            m_view.setSelection(ftrRange);
            cellFmt.setTopBorder(CellFormat.eBorderMedium);
            cellFmt.setTopBorderColor(java.awt.Color.darkGray);
            cellFmt.setBottomBorder(CellFormat.eBorderMedium);
            cellFmt.setBottomBorderColor(java.awt.Color.darkGray);
            AlignRight(cellFmt);
            m_view.setCellFormat(cellFmt);
        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
    }//List3
    
    
    private void AdjustFont(
        int  color,
        boolean         bold,
        boolean         italic,
        boolean         underline,
        CellFormat cellFmt)
    {                       
        cellFmt.setFontBold(bold);
        cellFmt.setFontItalic(italic);
        cellFmt.setFontUnderline(underline);
            
        cellFmt.setFontColor(new Color(color));
    
    } //AdjustFont
    
    private void AlignCenter(CellFormat cellFmt)
    {
        try{
            cellFmt.setHorizontalAlignment(CellFormat.eHorizontalAlignmentCenter);
            cellFmt.setVerticalAlignment(CellFormat.eVerticalAlignmentBottom);
            cellFmt.setWordWrap(false);
            
        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
    }//AlignCenter            
        
    private void AlignRight(CellFormat cellFmt)
    {
        try{
            cellFmt.setHorizontalAlignment(CellFormat.eHorizontalAlignmentRight);
            cellFmt.setVerticalAlignment(CellFormat.eVerticalAlignmentBottom);
            cellFmt.setWordWrap(false);
            
        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
    }//AlignRight
    
    private void Set3DBorder(CellFormat cellFmt,
                int row1, 
                int col1, 
                int row2, 
                int col2,
                int outlineColor,
                int rightColor,
                int bottomColor)
    {
        try{
            m_view.setSelection(row1, col1, row2, col2);
            //create an outline around the selection
            cellFmt.setTopBorder(CellFormat.eBorderMedium);
            cellFmt.setBottomBorder(CellFormat.eBorderMedium);
            cellFmt.setLeftBorder(CellFormat.eBorderMedium);
            cellFmt.setRightBorder(CellFormat.eBorderMedium);
            cellFmt.setTopBorderColor(new Color(outlineColor));
            cellFmt.setBottomBorderColor(new Color(outlineColor));
            cellFmt.setLeftBorderColor(new Color(outlineColor));
            cellFmt.setRightBorderColor(new Color(outlineColor));
            m_view.setCellFormat(cellFmt);
            
            m_view.setSelection(row1, col2, row2, col2);
            cellFmt.setRightBorder(CellFormat.eBorderMedium);
            cellFmt.setRightBorderColor(new Color(rightColor));
            m_view.setCellFormat(cellFmt);
            
            m_view.setSelection(row2, col1, row2, col2);
            cellFmt.setBottomBorder(CellFormat.eBorderMedium);
            //m_view.getPaletteEntry(bottomColor);
            cellFmt.setBottomBorderColor(new Color(bottomColor));
            m_view.setCellFormat(cellFmt);

        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
    } //3DBorder
        
    private void SetSolidPattern(CellFormat cellFmt,
                 int fcolor, 
                 int bcolor)
    {
            short nPattern;
            nPattern = 1;
            try{
                cellFmt.setPattern(nPattern);
                cellFmt.setPatternFG(new Color(fcolor));
                cellFmt.setPatternBG(new Color(bcolor));
                
            }
            catch (Exception e){
                System.out.println(e.getMessage());
            }
            
    } //SetSolidPattern
    
    private void SetHatchPattern(CellFormat cellFmt,
            int fcolor,
            int bcolor)
            
    {
        try{
                cellFmt.setPattern((short)4);
                cellFmt.setPatternFG(new Color(fcolor));
                cellFmt.setPatternBG(new Color(bcolor));
        }
        catch (Exception e){
            System.out.println(e.getMessage());
        }
    }//SetHatchPattern
    
    

}