Attachment #21587 for bug #44480

View | Details | Raw Unified | Return to bug 44480
Collapse All | Expand All




import org.openxml4j.opc.TargetMode;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBookView;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBookViews;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDialogsheet;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet;

    }

    public Sheet createSheet(String sheetname) {
        return createSheet(sheetname, null);
    }
    
    public Sheet createSheet(String sheetname, CTWorksheet worksheet) {
        CTSheet sheet = addSheet(sheetname);
        XSSFWorksheet wrapper = new XSSFWorksheet(sheet, worksheet, this);
        this.sheets.add(wrapper);
        return wrapper;
    }
    
    public Sheet createDialogsheet(String sheetname, CTDialogsheet dialogsheet) {
    	  CTSheet sheet = addSheet(sheetname);
    	  XSSFDialogsheet wrapper = new XSSFDialogsheet(sheet, dialogsheet, this);
    	  this.sheets.add(wrapper);
    	  return wrapper;
    }

	private CTSheet addSheet(String sheetname) {
		CTSheet sheet = workbook.getSheets().addNewSheet();
        if (sheetname != null) {
            sheet.setName(sheetname);
        }
		return sheet;
	}

    public void dumpDrawingGroupRecords(boolean fat) {
        // TODO Auto-generated method stub


             out.close();
             
             for (int i = 0 ; i < this.getNumberOfSheets() ; ++i) {
            	 XSSFSheet sheet = (XSSFSheet) this.getSheetAt(i);
                 PackagePartName partName = PackagingURIHelper.createPartName("/xl/worksheets/sheet" + i + ".xml");
                 corePart.addRelationship(partName, TargetMode.INTERNAL, WORKSHEET_RELATIONSHIP, "rSheet" + 1);
                 PackagePart part = pkg.createPart(partName, WORKSHEET_TYPE);





package org.apache.poi.xssf.usermodel;

import java.util.Collection;
import java.util.Iterator;
import java.util.LinkedList;
import java.util.List;

import org.apache.poi.ss.usermodel.Footer;
import org.apache.poi.ss.usermodel.Header;
import org.apache.poi.ss.usermodel.Patriarch;
import org.apache.poi.ss.usermodel.PictureData;
import org.apache.poi.ss.usermodel.PrintSetup;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.xssf.usermodel.helpers.ColumnHelper;
import org.apache.poi.xssf.util.CellReference;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBreak;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDialogsheet;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTHeaderFooter;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPageBreak;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPageMargins;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPageSetUpPr;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPrintOptions;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRow;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetFormatPr;


public class XSSFSheet implements Sheet {

    protected CTSheet sheet;
    protected CTWorksheet worksheet;
    protected CTDialogsheet dialogsheet;
    protected List<Row> rows;
    protected ColumnHelper columnHelper;
    protected XSSFWorkbook workbook;

    public static final short LeftMargin = 0;
    public static final short RightMargin = 1;

    public static final short BottomMargin = 3;
    public static final short HeaderMargin = 4;
    public static final short FooterMargin = 5;

	public XSSFSheet(CTSheet sheet, CTWorksheet worksheet, XSSFWorkbook workbook) {
        this.workbook = workbook;
        this.sheet = sheet;
        this.worksheet = worksheet;
        if (this.worksheet == null) {
        	this.worksheet = CTWorksheet.Factory.newInstance();
        }
        if (this.worksheet.getSheetData() == null) {
        	this.worksheet.addNewSheetData();
        }
        initRows(this.worksheet);
        initColumns(this.worksheet);
	}
        initRows(worksheet);
        initColumns(worksheet);
    }

    public XSSFSheet(XSSFWorkbook workbook) {
        this.workbook = workbook;

        return this.workbook;
    }
    
    protected CTWorksheet getWorksheet() {
        return this.worksheet;
    }
    
    public ColumnHelper getColumnHelper() {
    	return columnHelper;
    }

    protected void initRows(CTWorksheet worksheet) {
        this.rows = new LinkedList<Row>();
        for (CTRow row : worksheet.getSheetData().getRowArray()) {
            this.rows.add(new XSSFRow(row, this));
        }
    }

    protected void initColumns(CTWorksheet worksheet) {
        columnHelper = new ColumnHelper(worksheet);
    }


        return this.sheet;
    }
    
    protected CTWorksheet getWorksheet() {
        return this.typesheet;
    }
    
    public int addMergedRegion(Region region) {
        // TODO Auto-generated method stub
        return 0;

    }

    protected XSSFRow addRow(int index, int rownum) {
        CTRow row = this.worksheet.getSheetData().insertNewRow(index);
        XSSFRow xrow = new XSSFRow(row, this);
        xrow.setRowNum(rownum);
        return xrow;

    }

    public boolean getAutobreaks() {
        return getSheetTypePageSetUpPr().getAutoPageBreaks();
    }

	private CTPageSetUpPr getSheetTypePageSetUpPr() {
    	if (getSheetTypeSheetPr().getPageSetUpPr() == null) {
    		getSheetTypeSheetPr().setPageSetUpPr(CTPageSetUpPr.Factory.newInstance());
    	}
		return getSheetTypeSheetPr().getPageSetUpPr();
	}

	protected CTSheetPr getSheetTypeSheetPr() {
    	if (worksheet.getSheetPr() == null) {
    		worksheet.setSheetPr(CTSheetPr.Factory.newInstance());
    	}
		return worksheet.getSheetPr();
	}

    public Comment getCellComment(int row, int column) {

    }

    public short[] getColumnBreaks() {
        CTBreak[] brkArray = getSheetTypeColumnBreaks().getBrkArray();
        if (brkArray.length == 0) {
            return null;
        }

        return breaks;
    }

	protected CTPageBreak getSheetTypeColumnBreaks() {
		if (worksheet.getColBreaks() == null) {
			worksheet.setColBreaks(CTPageBreak.Factory.newInstance());
		}
		return worksheet.getColBreaks();
	}

    public short getColumnWidth(short column) {

    }

    public short getDefaultColumnWidth() {
        return (short) getSheetTypeSheetFormatPr().getDefaultColWidth();
    }

    public short getDefaultRowHeight() {
        return (short) (getSheetTypeSheetFormatPr().getDefaultRowHeight() * 20);
    }

	protected CTSheetFormatPr getSheetTypeSheetFormatPr() {
		if (worksheet.getSheetFormatPr() == null) {
			worksheet.setSheetFormatPr(CTSheetFormatPr.Factory.newInstance());
		}
		return worksheet.getSheetFormatPr();
	}

    public float getDefaultRowHeightInPoints() {
        return (short) getSheetTypeSheetFormatPr().getDefaultRowHeight();
    }

    public boolean getDialog() {
    	if (dialogsheet != null) {
    		return true;
    	}
    	return false;
    }

    public boolean getDisplayGuts() {

    }

    public boolean getFitToPage() {
        return getSheetTypePageSetUpPr().getFitToPage();
    }

    public Footer getFooter() {

    }
    
    public Footer getOddFooter() {
        return new XSSFOddFooter(getSheetTypeHeaderFooter());
    }

	protected CTHeaderFooter getSheetTypeHeaderFooter() {
		if (worksheet.getHeaderFooter() == null) {
			worksheet.setHeaderFooter(CTHeaderFooter.Factory.newInstance());
		}
		return worksheet.getHeaderFooter();
	}
    
    public Footer getEvenFooter() {
        return new XSSFEvenFooter(getSheetTypeHeaderFooter());
    }
    
    public Footer getFirstFooter() {
        return new XSSFFirstFooter(getSheetTypeHeaderFooter());
    }

    public Header getHeader() {

    }
    
    public Header getOddHeader() {
        return new XSSFOddHeader(getSheetTypeHeaderFooter());
    }
    
    public Header getEvenHeader() {
        return new XSSFEvenHeader(getSheetTypeHeaderFooter()
);
    }
    
    public Header getFirstHeader() {
        return new XSSFFirstHeader(getSheetTypeHeaderFooter());
    }

    public boolean getHorizontallyCenter() {
    	return getSheetTypePrintOptions().getHorizontalCentered();
        return false;
    }

	protected CTPrintOptions getSheetTypePrintOptions() {
		if (worksheet.getPrintOptions() == null) {
			worksheet.setPrintOptions(CTPrintOptions.Factory.newInstance());
		}
		return worksheet.getPrintOptions();
	}

    public int getLastRowNum() {
        int lastRowNum = -1;
        for (Iterator<Row> it = rowIterator() ; it.hasNext() ; ) {


    public short getLeftCol() {
    	// TODO no test for this method at the moment.
    	String cellRef = worksheet.getSheetViews().getSheetViewArray(0).getTopLeftCell();
    	CellReference cellReference = new CellReference(cellRef);
        return cellReference.getCol();
    }

    public double getMargin(short margin) {
        CTPageMargins pageMargins = getSheetTypePageMargins();
        switch (margin) {
        case LeftMargin:
            return pageMargins.getLeft();

        }
    }

	protected CTPageMargins getSheetTypePageMargins() {
		if (worksheet.getPageMargins() == null) {
			worksheet.setPageMargins(CTPageMargins.Factory.newInstance());
		}
		return worksheet.getPageMargins();
	}

    public Region getMergedRegionAt(int index) {

    }

    public int[] getRowBreaks() {
        CTPageBreak rowBreaks = getSheetTypeRowBreaks();
        int breaksCount = rowBreaks.getBrkArray().length;
        if (breaksCount == 0) {
            return null;

        return breaks;
    }

	protected CTPageBreak getSheetTypeRowBreaks() {
		if (worksheet.getRowBreaks() == null) {
			worksheet.setRowBreaks(CTPageBreak.Factory.newInstance());
		}
		return worksheet.getRowBreaks();
	}

    public boolean getRowSumsBelow() {


    public short getTopRow() {
    	// TODO no test for this method at the moment.
    	String cellRef = worksheet.getSheetViews().getSheetViewArray(0).getTopLeftCell();
    	CellReference cellReference = new CellReference(cellRef);
        return (short) cellReference.getRow();
    }

    }

    public boolean isColumnBroken(short column) {
        CTBreak[] brkArray = getSheetTypeColumnBreaks().getBrkArray();
        for (int i = 0 ; i < brkArray.length ; i++) {
            if (brkArray[i].getId() == column) {
                return true;

    }

    public boolean isDisplayFormulas() {
    	return getSheetTypeSheetView().getShowFormulas();
        return false;
    }

    public boolean isDisplayGridlines() {
        return getSheetTypeSheetView().getShowGridLines();
        return false;
    }

    public boolean isDisplayRowColHeadings() {
        return getSheetTypeSheetView().getShowRowColHeaders();
        return false;
    }

    public boolean isGridsPrinted() {
    	return isPrintGridlines();
        return false;
    }

    public boolean isPrintGridlines() {
    	return getSheetTypePrintOptions().getGridLines();
        return false;
    }

    public boolean isRowBroken(int row) {

    }

    public void removeColumnBreak(short column) {
        CTBreak[] brkArray = getSheetTypeColumnBreaks().getBrkArray();
        for (int i = 0 ; i < brkArray.length ; i++) {
            if (brkArray[i].getId() == column) {
                getSheetTypeColumnBreaks().removeBrk(i);
                continue;
            }
        }

            Row r = it.next();
            if (r.getRowNum() == row.getRowNum()) {
                it.remove();
                worksheet.getSheetData().removeRow(counter);
            }
            counter++;
        }
    }

    public void removeRowBreak(int row) {
        CTBreak[] brkArray = getSheetTypeRowBreaks().getBrkArray();
        for (int i = 0 ; i < brkArray.length ; i++) {
            if (brkArray[i].getId() == row) {
                getSheetTypeRowBreaks().removeBrk(i);
                continue;
            }
        }

    }

    public void setAutobreaks(boolean b) {
        getSheetTypePageSetUpPr().setAutoPageBreaks(b);
    }

    public void setColumnBreak(short column) {
        if (! isColumnBroken(column)) {
            CTBreak brk = getSheetTypeColumnBreaks().addNewBrk();
            brk.setId(column);
        }
    }

    }

    public void setDefaultColumnWidth(short width) {
        getSheetTypeSheetFormatPr().setDefaultColWidth((double) width);
    }

    public void setDefaultRowHeight(short height) {
        getSheetTypeSheetFormatPr().setDefaultRowHeight(height / 20);

    }

    public void setDefaultRowHeightInPoints(float height) {
        getSheetTypeSheetFormatPr().setDefaultRowHeight(height);

    }

    public void setDialog(boolean b) {
        // TODO Auto-generated method stub

    }

    public void setDisplayFormulas(boolean show) {
    	getSheetTypeSheetView().setShowFormulas(show);

    }

	protected CTSheetView getSheetTypeSheetView() {
		if (getDefaultSheetView() == null) {
			getSheetTypeSheetViews().setSheetViewArray(0, CTSheetView.Factory.newInstance());
		}
		return getDefaultSheetView();
	}

    public void setDisplayGridlines(boolean show) {
    	getSheetTypeSheetView().setShowGridLines(show);

    }

    public void setDisplayGuts(boolean b) {

    }

    public void setDisplayRowColHeadings(boolean show) {
    	getSheetTypeSheetView().setShowRowColHeaders(show);

    }

    public void setFitToPage(boolean b) {
        getSheetTypePageSetUpPr().setFitToPage(b);
    }

    public void setGridsPrinted(boolean value) {
    	setPrintGridlines(value);

    }

    public void setHorizontallyCenter(boolean value) {
    	getSheetTypePrintOptions().setHorizontalCentered(value);

    }

    public void setMargin(short margin, double size) {
        CTPageMargins pageMargins = getSheetTypePageMargins();
        switch (margin) {
        case LeftMargin:
            pageMargins.setLeft(size);

    }

    public void setPrintGridlines(boolean newPrintGridlines) {
    	getSheetTypePrintOptions().setGridLines(newPrintGridlines);

    }

    public void setProtect(boolean protect) {

    }

    public void setRowBreak(int row) {
        CTPageBreak pageBreak = getSheetTypeRowBreaks();
        if (! isRowBroken(row)) {
            CTBreak brk = pageBreak.addNewBrk();
            brk.setId(row);

    }

    public void setTabSelected(boolean flag) {
        CTSheetViews views = getSheetTypeSheetViews();
        for (CTSheetView view : views.getSheetViewArray()) {
            view.setTabSelected(flag);
        }
    }

	protected CTSheetViews getSheetTypeSheetViews() {
		if (worksheet.getSheetViews() == null) {
			worksheet.setSheetViews(CTSheetViews.Factory.newInstance());
			worksheet.getSheetViews().addNewSheetView();
		}
		return worksheet.getSheetViews();
	}
    
    public boolean isTabSelected() {

     * workbookView entries) are saved."
     */
    private CTSheetView getDefaultSheetView() {
        CTSheetViews views = getSheetTypeSheetViews();
        if (views == null || views.getSheetViewArray() == null || views.getSheetViewArray().length <= 0) {
            return null;
        }

    }
    
    protected XSSFSheet cloneSheet() {
    	XSSFSheet newSheet = new XSSFSheet(this.workbook);
    	newSheet.setSheet((CTSheet)sheet.copy());
        return newSheet;
    }
    
	private void setSheet(CTSheet sheet) {
		this.sheet = sheet;
	}

}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.xssf.usermodel;

import org.apache.poi.ss.usermodel.Sheet;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTHeaderFooter;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet;

public class XSSFWorksheet extends XSSFSheet implements Sheet{

	public XSSFWorksheet(CTSheet sheet, CTWorksheet worksheet,
			XSSFWorkbook workbook) {
		super(sheet, worksheet, workbook);
	}
	
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.xssf.usermodel;

import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDialogsheet;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTHeaderFooter;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPageBreak;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPageMargins;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPageSetUpPr;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPrintOptions;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetFormatPr;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetPr;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetViews;

public class XSSFDialogsheet extends XSSFSheet implements Sheet{

	public XSSFDialogsheet(CTSheet sheet, CTDialogsheet dialogsheet,
			XSSFWorkbook workbook) {
		super(sheet, null, workbook);
		this.worksheet = null;
		this.dialogsheet = dialogsheet;
		if (this.dialogsheet == null) {
			this.dialogsheet = CTDialogsheet.Factory.newInstance();
		}
	}
	
	public Row createRow(int rowNum) {
		return null;
	}

	protected CTHeaderFooter getSheetTypeHeaderFooter() {
		if (dialogsheet.getHeaderFooter() == null) {
			dialogsheet.setHeaderFooter(CTHeaderFooter.Factory.newInstance());
		}
		return dialogsheet.getHeaderFooter();
	}

	protected CTSheetPr getSheetTypeSheetPr() {
    	if (dialogsheet.getSheetPr() == null) {
    		dialogsheet.setSheetPr(CTSheetPr.Factory.newInstance());
    	}
		return dialogsheet.getSheetPr();
	}

	protected CTPageBreak getSheetTypeColumnBreaks() {
		return null;
	}

	protected CTSheetFormatPr getSheetTypeSheetFormatPr() {
		if (dialogsheet.getSheetFormatPr() == null) {
			dialogsheet.setSheetFormatPr(CTSheetFormatPr.Factory.newInstance());
		}
		return dialogsheet.getSheetFormatPr();
	}

	protected CTPageMargins getSheetTypePageMargins() {
		if (dialogsheet.getPageMargins() == null) {
			dialogsheet.setPageMargins(CTPageMargins.Factory.newInstance());
		}
		return dialogsheet.getPageMargins();
	}

	protected CTPageBreak getSheetTypeRowBreaks() {
		return null;
	}

	protected CTSheetViews getSheetTypeSheetViews() {
		if (dialogsheet.getSheetViews() == null) {
			dialogsheet.setSheetViews(CTSheetViews.Factory.newInstance());
			dialogsheet.getSheetViews().addNewSheetView();
		}
		return dialogsheet.getSheetViews();
	}

	protected CTPrintOptions getSheetTypePrintOptions() {
		if (dialogsheet.getPrintOptions() == null) {
			dialogsheet.setPrintOptions(CTPrintOptions.Factory.newInstance());
		}
		return dialogsheet.getPrintOptions();
	}
	
}




/* ====================================================================
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
==================================================================== */

package org.apache.poi.xssf.usermodel;

import junit.framework.TestCase;

import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDialogsheet;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet;


public class TestXSSFDialogSheet extends TestCase {
	
	public void testDialogsheetConstructor() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        Sheet sheet = workbook.createSheet("Sheet 1");
		XSSFDialogsheet dialogsheet = new XSSFDialogsheet(CTSheet.Factory.newInstance(), CTDialogsheet.Factory.newInstance(), workbook);
		assertNotNull(dialogsheet);
		XSSFDialogsheet dialogsheet2 = new XSSFDialogsheet(CTSheet.Factory.newInstance(), null, workbook);
		assertNotNull(dialogsheet2);
	}
	
	public void testCreateDialogSheet() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        Sheet dialogsheet = workbook.createDialogsheet("Dialogsheet 1", CTDialogsheet.Factory.newInstance());
        assertNotNull(dialogsheet);
	}
    
    public void testGetDialog() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = (XSSFSheet) workbook.createSheet("Sheet 1");
        assertFalse(sheet.getDialog());
        XSSFSheet dialogsheet = (XSSFSheet) workbook.createDialogsheet("Dialogsheet 1", null);
        assertTrue(dialogsheet.getDialog());
    	
    }
	
	public void testAddRow() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        Sheet dialogsheet = workbook.createDialogsheet("Dialogsheet 1", CTDialogsheet.Factory.newInstance());
        assertNotNull(dialogsheet);
        Row row = dialogsheet.createRow(0);
        assertNull(row);
	}
    
    public void testGetSetAutoBreaks() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFDialogsheet sheet = (XSSFDialogsheet) workbook.createDialogsheet("Dialogsheet 1", null);
        assertTrue(sheet.getAutobreaks());
        sheet.setAutobreaks(false);
        assertFalse(sheet.getAutobreaks());
    }
    
    public void testIsSetFitToPage() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFDialogsheet sheet = (XSSFDialogsheet) workbook.createDialogsheet("Dialogsheet 1", null);
        assertFalse(sheet.getFitToPage());
        sheet.setFitToPage(true);
        assertTrue(sheet.getFitToPage());
        sheet.setFitToPage(false);
        assertFalse(sheet.getFitToPage());
    }
    
    public void testGetSetMargin() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFDialogsheet sheet = (XSSFDialogsheet) workbook.createDialogsheet("Dialogsheet 1", null);
        assertEquals((double) 0, sheet.getMargin((short) 0));
        sheet.setMargin((short) 0, 10);
        assertEquals((double) 10, sheet.getMargin((short) 0));
        assertEquals((double) 10, sheet.getMargin((short) 1));
        assertEquals((double) 10, sheet.getMargin((short) 2));
        assertEquals((double) 10, sheet.getMargin((short) 3));
        assertEquals((double) 10, sheet.getMargin((short) 4));
        assertEquals((double) 10, sheet.getMargin((short) 5));
        sheet.setMargin((short) 1, 11);
        assertEquals((double) 11, sheet.getMargin((short) 1));
        assertEquals((double) 11, sheet.getMargin((short) 2));
        assertEquals((double) 11, sheet.getMargin((short) 3));
        assertEquals((double) 11, sheet.getMargin((short) 4));
        assertEquals((double) 11, sheet.getMargin((short) 5));
        sheet.setMargin((short) 2, 12);
        assertEquals((double) 12, sheet.getMargin((short) 2));
        assertEquals((double) 12, sheet.getMargin((short) 3));
        assertEquals((double) 12, sheet.getMargin((short) 4));
        assertEquals((double) 12, sheet.getMargin((short) 5));
        sheet.setMargin((short) 3, 13);
        assertEquals((double) 13, sheet.getMargin((short) 3));
        assertEquals((double) 13, sheet.getMargin((short) 4));
        assertEquals((double) 13, sheet.getMargin((short) 5));
        sheet.setMargin((short) 4, 14);
        assertEquals((double) 14, sheet.getMargin((short) 4));
        assertEquals((double) 14, sheet.getMargin((short) 5));
        sheet.setMargin((short) 5, 15);
        assertEquals((double) 15, sheet.getMargin((short) 5));
        
        // Test that nothing happens if another margin constant is given (E.G. 65)
        sheet.setMargin((short) 65, 15);
        assertEquals((double) 10, sheet.getMargin((short) 0));
        assertEquals((double) 11, sheet.getMargin((short) 1));
        assertEquals((double) 12, sheet.getMargin((short) 2));
        assertEquals((double) 13, sheet.getMargin((short) 3));
        assertEquals((double) 14, sheet.getMargin((short) 4));
        assertEquals((double) 15, sheet.getMargin((short) 5));
    }
    
    public void testGetFooter() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFDialogsheet sheet = (XSSFDialogsheet) workbook.createDialogsheet("Dialogsheet 1", null);
        assertNotNull(sheet.getFooter());
        sheet.getFooter().setCenter("test center footer");
        assertEquals("test center footer", sheet.getFooter().getCenter());
    }
    
    public void testGetAllHeadersFooters() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFDialogsheet sheet = (XSSFDialogsheet) workbook.createDialogsheet("Dialogsheet 1", null);
        assertNotNull(sheet);
        assertNotNull(sheet.getOddFooter());
        assertNotNull(sheet.getEvenFooter());
        assertNotNull(sheet.getFirstFooter());
        assertNotNull(sheet.getOddHeader());
        assertNotNull(sheet.getEvenHeader());
        assertNotNull(sheet.getFirstHeader());
        
        assertEquals("", sheet.getOddFooter().getLeft());
        sheet.getOddFooter().setLeft("odd footer left");
        assertEquals("odd footer left", sheet.getOddFooter().getLeft());
        
        assertEquals("", sheet.getEvenFooter().getLeft());
        sheet.getEvenFooter().setLeft("even footer left");
        assertEquals("even footer left", sheet.getEvenFooter().getLeft());
        
        assertEquals("", sheet.getFirstFooter().getLeft());
        sheet.getFirstFooter().setLeft("first footer left");
        assertEquals("first footer left", sheet.getFirstFooter().getLeft());
        
        assertEquals("", sheet.getOddHeader().getLeft());
        sheet.getOddHeader().setLeft("odd header left");
        assertEquals("odd header left", sheet.getOddHeader().getLeft());
        
        assertEquals("", sheet.getOddHeader().getRight());
        sheet.getOddHeader().setRight("odd header right");
        assertEquals("odd header right", sheet.getOddHeader().getRight());
        
        assertEquals("", sheet.getOddHeader().getCenter());
        sheet.getOddHeader().setCenter("odd header center");
        assertEquals("odd header center", sheet.getOddHeader().getCenter());

    }
    
    public void testGetSetHorizontallyCentered() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFDialogsheet sheet = (XSSFDialogsheet) workbook.createDialogsheet("Dialogsheet 1", null);
        assertFalse(sheet.getHorizontallyCenter());
        sheet.setHorizontallyCenter(true);
        assertTrue(sheet.getHorizontallyCenter());
        sheet.setHorizontallyCenter(false);
        assertFalse(sheet.getHorizontallyCenter());
    }
    
    public void testIsSetPrintGridlines() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFDialogsheet sheet = (XSSFDialogsheet) workbook.createDialogsheet("Dialogsheet 1", null);
        assertFalse(sheet.isPrintGridlines());
        sheet.setPrintGridlines(true);
        assertTrue(sheet.isPrintGridlines());
    }
    
    public void testIsSetDisplayFormulas() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFDialogsheet sheet = (XSSFDialogsheet) workbook.createDialogsheet("Dialogsheet 1", null);
        assertFalse(sheet.isDisplayFormulas());
        sheet.setDisplayFormulas(true);
        assertTrue(sheet.isDisplayFormulas());
    }
    
    public void testIsSetDisplayGridLines() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFDialogsheet sheet = (XSSFDialogsheet) workbook.createDialogsheet("Dialogsheet 1", null);
        assertTrue(sheet.isDisplayGridlines());
        sheet.setDisplayGridlines(false);
        assertFalse(sheet.isDisplayGridlines());
    }
    
    public void testIsSetDisplayRowColHeadings() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFDialogsheet sheet = (XSSFDialogsheet) workbook.createDialogsheet("Dialogsheet 1", null);
        assertTrue(sheet.isDisplayRowColHeadings());
        sheet.setDisplayRowColHeadings(false);
        assertFalse(sheet.isDisplayRowColHeadings());
    }
	
}

Lines 26-31 Link Here

(-)src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFSheet.java (+54 lines)
26	import org.apache.poi.ss.usermodel.Sheet;	26	import org.apache.poi.ss.usermodel.Sheet;
27	import org.apache.poi.xssf.usermodel.helpers.ColumnHelper;	27	import org.apache.poi.xssf.usermodel.helpers.ColumnHelper;
28	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol;	28	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol;
		29	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDialogsheet;
		30	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet;
		31	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet;
29		32
30		33
31	public class TestXSSFSheet extends TestCase {	34	public class TestXSSFSheet extends TestCase {
Lines 335-338 Link Here
335	assertNotNull(col);	338	assertNotNull(col);
336	assertTrue(col.getBestFit());	339	assertTrue(col.getBestFit());
337	}	340	}
		341
		342	public void testGetDialog() {
		343	XSSFWorkbook workbook = new XSSFWorkbook();
		344	XSSFSheet sheet = (XSSFSheet) workbook.createSheet("Sheet 1");
		345	assertFalse(sheet.getDialog());
		346	XSSFSheet dialogsheet = (XSSFSheet) workbook.createDialogsheet("Dialogsheet 1", null);
		347	assertTrue(dialogsheet.getDialog());
		348
		349	}
		350
		351	public void testGetSetHorizontallyCentered() {
		352	XSSFWorkbook workbook = new XSSFWorkbook();
		353	XSSFSheet sheet = (XSSFSheet) workbook.createSheet("Sheet 1");
		354	assertFalse(sheet.getHorizontallyCenter());
		355	sheet.setHorizontallyCenter(true);
		356	assertTrue(sheet.getHorizontallyCenter());
		357	sheet.setHorizontallyCenter(false);
		358	assertFalse(sheet.getHorizontallyCenter());
		359	}
		360
		361	public void testIsSetPrintGridlines() {
		362	XSSFWorkbook workbook = new XSSFWorkbook();
		363	XSSFSheet sheet = (XSSFSheet) workbook.createSheet("Sheet 1");
		364	assertFalse(sheet.isPrintGridlines());
		365	sheet.setPrintGridlines(true);
		366	assertTrue(sheet.isPrintGridlines());
		367	}
		368
		369	public void testIsSetDisplayFormulas() {
		370	XSSFWorkbook workbook = new XSSFWorkbook();
		371	XSSFSheet sheet = (XSSFSheet) workbook.createSheet("Sheet 1");
		372	assertFalse(sheet.isDisplayFormulas());
		373	sheet.setDisplayFormulas(true);
		374	assertTrue(sheet.isDisplayFormulas());
		375	}
		376
		377	public void testIsSetDisplayGridLines() {
		378	XSSFWorkbook workbook = new XSSFWorkbook();
		379	XSSFSheet sheet = (XSSFSheet) workbook.createSheet("Sheet 1");
		380	assertTrue(sheet.isDisplayGridlines());
		381	sheet.setDisplayGridlines(false);
		382	assertFalse(sheet.isDisplayGridlines());
		383	}
		384
		385	public void testIsSetDisplayRowColHeadings() {
		386	XSSFWorkbook workbook = new XSSFWorkbook();
		387	XSSFSheet sheet = (XSSFSheet) workbook.createSheet("Sheet 1");
		388	assertTrue(sheet.isDisplayRowColHeadings());
		389	sheet.setDisplayRowColHeadings(false);
		390	assertFalse(sheet.isDisplayRowColHeadings());
		391	}
338	}	392	}




        assertEquals("Lorem", cell.getRichStringCellValue().getString());
    }
    
    // TODO filename string hard coded in XSSFWorkbook constructor in order to make ant test-ooxml target be successfull.
    public void testLoadStyles() throws Exception {
        XSSFWorkbook workbook = new XSSFWorkbook(new File("src/ooxml/testcases/org/apache/poi/xssf/data", "styles.xlsx").getAbsolutePath());
        Sheet sheet = workbook.getSheetAt(0);
        Row row = sheet.getRow(0);
        Cell cell = row.getCell((short) 0);
        CellStyle style = cell.getCellStyle();
        // assertNotNull(style);
    }

    // TODO filename string hard coded in XSSFWorkbook constructor in order to make ant test-ooxml target be successfull.
    public void testLoadPictures() throws Exception {
        XSSFWorkbook workbook = new XSSFWorkbook(new File("src/ooxml/testcases/org/apache/poi/xssf/data", "picture.xlsx").getAbsolutePath());
        List<PictureData> pictures = workbook.getAllPictures();
        assertEquals(1, pictures.size());
    }

Return to bug 44480

Lines 52-57 Link Here

(-)src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFWorkbook.java (-6 / +23 lines)
52	import org.openxml4j.opc.TargetMode;	52	import org.openxml4j.opc.TargetMode;
53	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBookView;	53	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBookView;
54	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBookViews;	54	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBookViews;
		55	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDialogsheet;
55	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet;	56	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet;
56	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook;	57	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook;
57	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet;	58	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet;
Lines 204-218 Link Here
204	}	205	}
205		206
206	public Sheet createSheet(String sheetname) {	207	public Sheet createSheet(String sheetname) {
207	CTSheet sheet = workbook.getSheets().addNewSheet();	208	return createSheet(sheetname, null);
208	if (sheetname != null) {	209	}
209	sheet.setName(sheetname);	210
210	}	211	public Sheet createSheet(String sheetname, CTWorksheet worksheet) {
211	XSSFSheet wrapper = new XSSFSheet(sheet, this);	212	CTSheet sheet = addSheet(sheetname);
		213	XSSFWorksheet wrapper = new XSSFWorksheet(sheet, worksheet, this);
212	this.sheets.add(wrapper);	214	this.sheets.add(wrapper);
213	return wrapper;	215	return wrapper;
214	}	216	}
		217
		218	public Sheet createDialogsheet(String sheetname, CTDialogsheet dialogsheet) {
		219	CTSheet sheet = addSheet(sheetname);
		220	XSSFDialogsheet wrapper = new XSSFDialogsheet(sheet, dialogsheet, this);
		221	this.sheets.add(wrapper);
		222	return wrapper;
		223	}
215		224
		225	private CTSheet addSheet(String sheetname) {
		226	CTSheet sheet = workbook.getSheets().addNewSheet();
		227	if (sheetname != null) {
		228	sheet.setName(sheetname);
		229	}
		230	return sheet;
		231	}
		232
216	public void dumpDrawingGroupRecords(boolean fat) {	233	public void dumpDrawingGroupRecords(boolean fat) {
217	// TODO Auto-generated method stub	234	// TODO Auto-generated method stub
218		235
Lines 479-485 Link Here
479	out.close();	496	out.close();
480		497
481	for (int i = 0 ; i < this.getNumberOfSheets() ; ++i) {	498	for (int i = 0 ; i < this.getNumberOfSheets() ; ++i) {
482	XSSFSheet sheet = (XSSFSheet) this.getSheetAt(i);	499	XSSFSheet sheet = (XSSFSheet) this.getSheetAt(i);
483	PackagePartName partName = PackagingURIHelper.createPartName("/xl/worksheets/sheet" + i + ".xml");	500	PackagePartName partName = PackagingURIHelper.createPartName("/xl/worksheets/sheet" + i + ".xml");
484	corePart.addRelationship(partName, TargetMode.INTERNAL, WORKSHEET_RELATIONSHIP, "rSheet" + 1);	501	corePart.addRelationship(partName, TargetMode.INTERNAL, WORKSHEET_RELATIONSHIP, "rSheet" + 1);
485	PackagePart part = pkg.createPart(partName, WORKSHEET_TYPE);	502	PackagePart part = pkg.createPart(partName, WORKSHEET_TYPE);

Line 0 Link Here

(-)src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFWorksheet.java (+32 lines)
	1	/* ====================================================================
	2	Licensed to the Apache Software Foundation (ASF) under one or more
	3	contributor license agreements. See the NOTICE file distributed with
	4	this work for additional information regarding copyright ownership.
	5	The ASF licenses this file to You under the Apache License, Version 2.0
	6	(the "License"); you may not use this file except in compliance with
	7	the License. You may obtain a copy of the License at
	8
	9	http://www.apache.org/licenses/LICENSE-2.0
	10
	11	Unless required by applicable law or agreed to in writing, software
	12	distributed under the License is distributed on an "AS IS" BASIS,
	13	WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
	14	See the License for the specific language governing permissions and
	15	limitations under the License.
	16	==================================================================== */
	17
	18	package org.apache.poi.xssf.usermodel;
	19
	20	import org.apache.poi.ss.usermodel.Sheet;
	21	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTHeaderFooter;
	22	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet;
	23	import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet;
	24
	25	public class XSSFWorksheet extends XSSFSheet implements Sheet{
	26
	27	public XSSFWorksheet(CTSheet sheet, CTWorksheet worksheet,
	28	XSSFWorkbook workbook) {
	29	super(sheet, worksheet, workbook);
	30	}
	31
	32	}

Lines 56-72 Link Here

(-)src/ooxml/testcases/org/apache/poi/xssf/io/TestLoadSaveXSSF.java (-3 / +5 lines)
56	assertEquals("Lorem", cell.getRichStringCellValue().getString());	56	assertEquals("Lorem", cell.getRichStringCellValue().getString());
57	}	57	}
58		58
		59	// TODO filename string hard coded in XSSFWorkbook constructor in order to make ant test-ooxml target be successfull.
59	public void testLoadStyles() throws Exception {	60	public void testLoadStyles() throws Exception {
60	XSSFWorkbook workbook = new XSSFWorkbook(new File(filename, "styles.xlsx").getAbsolutePath());	61	XSSFWorkbook workbook = new XSSFWorkbook(new File("src/ooxml/testcases/org/apache/poi/xssf/data", "styles.xlsx").getAbsolutePath());
61	Sheet sheet = workbook.getSheetAt(0);	62	Sheet sheet = workbook.getSheetAt(0);
62	Row row = sheet.getRow(0);	63	Row row = sheet.getRow(0);
63	Cell cell = row.getCell((short) 0);	64	Cell cell = row.getCell((short) 0);
64	CellStyle style = cell.getCellStyle();	65	CellStyle style = cell.getCellStyle();
65	// assertNotNull(style);	66	// assertNotNull(style);
66	}	67	}
67		68
		69	// TODO filename string hard coded in XSSFWorkbook constructor in order to make ant test-ooxml target be successfull.
68	public void testLoadPictures() throws Exception {	70	public void testLoadPictures() throws Exception {
69	XSSFWorkbook workbook = new XSSFWorkbook(new File(filename, "picture.xlsx").getAbsolutePath());	71	XSSFWorkbook workbook = new XSSFWorkbook(new File("src/ooxml/testcases/org/apache/poi/xssf/data", "picture.xlsx").getAbsolutePath());
70	List<PictureData> pictures = workbook.getAllPictures();	72	List<PictureData> pictures = workbook.getAllPictures();
71	assertEquals(1, pictures.size());	73	assertEquals(1, pictures.size());
72	}	74	}