You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ug...@apache.org on 2008/01/16 17:08:37 UTC
svn commit: r612495 [2/3] - in /poi/branches/ooxml/src/ooxml: ./ java/
java/org/ java/org/apache/ java/org/apache/poi/ java/org/apache/poi/ss/
java/org/apache/poi/ss/usermodel/ java/org/apache/poi/xssf/
java/org/apache/poi/xssf/strings/ java/org/apache...
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/SharedStringSource.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/SharedStringSource.java
------------------------------------------------------------------------------
svn:keywords = Date Revision Author HeadURL Id
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/SharedStringSource.java
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Sheet.java
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Sheet.java?rev=612495&view=auto
==============================================================================
--- poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Sheet.java (added)
+++ poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Sheet.java Wed Jan 16 08:08:22 2008
@@ -0,0 +1,727 @@
+/* ====================================================================
+ 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.ss.usermodel;
+
+import java.util.Iterator;
+
+/* ====================================================================
+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.
+==================================================================== */
+
+import org.apache.poi.hssf.util.PaneInformation;
+import org.apache.poi.hssf.util.Region;
+
+public interface Sheet {
+
+ /* Constants for margins */
+ public static final short LeftMargin = Sheet.LeftMargin;
+
+ public static final short RightMargin = Sheet.RightMargin;
+
+ public static final short TopMargin = Sheet.TopMargin;
+
+ public static final short BottomMargin = Sheet.BottomMargin;
+
+ public static final byte PANE_LOWER_RIGHT = (byte) 0;
+
+ public static final byte PANE_UPPER_RIGHT = (byte) 1;
+
+ public static final byte PANE_LOWER_LEFT = (byte) 2;
+
+ public static final byte PANE_UPPER_LEFT = (byte) 3;
+
+ /**
+ * Used for compile-time optimization. This is the initial size for the collection of
+ * rows. It is currently set to 20. If you generate larger sheets you may benefit
+ * by setting this to a higher number and recompiling a custom edition of HSSFSheet.
+ */
+
+ public final static int INITIAL_CAPACITY = 20;
+
+ /**
+ * Create a new row within the sheet and return the high level representation
+ *
+ * @param rownum row number
+ * @return High level HSSFRow object representing a row in the sheet
+ * @see org.apache.poi.hssf.usermodel.HSSFRow
+ * @see #removeRow(HSSFRow)
+ */
+ Row createRow(int rownum);
+
+ /**
+ * Remove a row from this sheet. All cells contained in the row are removed as well
+ *
+ * @param row representing a row to remove.
+ */
+
+ void removeRow(Row row);
+
+ /**
+ * Returns the logical row (not physical) 0-based. If you ask for a row that is not
+ * defined you get a null. This is to say row 4 represents the fifth row on a sheet.
+ * @param rownum row to get
+ * @return HSSFRow representing the rownumber or null if its not defined on the sheet
+ */
+
+ Row getRow(int rownum);
+
+ /**
+ * Returns the number of phsyically defined rows (NOT the number of rows in the sheet)
+ */
+
+ int getPhysicalNumberOfRows();
+
+ /**
+ * gets the first row on the sheet
+ * @return the number of the first logical row on the sheet
+ */
+
+ int getFirstRowNum();
+
+ /**
+ * gets the last row on the sheet
+ * @return last row contained n this sheet.
+ */
+
+ int getLastRowNum();
+
+ /**
+ * Get the visibility state for a given column.
+ * @param column - the column to get (0-based)
+ * @param hidden - the visiblity state of the column
+ */
+
+ void setColumnHidden(short column, boolean hidden);
+
+ /**
+ * Get the hidden state for a given column.
+ * @param column - the column to set (0-based)
+ * @return hidden - the visiblity state of the column
+ */
+
+ boolean isColumnHidden(short column);
+
+ /**
+ * set the width (in units of 1/256th of a character width)
+ * @param column - the column to set (0-based)
+ * @param width - the width in units of 1/256th of a character width
+ */
+
+ void setColumnWidth(short column, short width);
+
+ /**
+ * get the width (in units of 1/256th of a character width )
+ * @param column - the column to set (0-based)
+ * @return width - the width in units of 1/256th of a character width
+ */
+
+ short getColumnWidth(short column);
+
+ /**
+ * get the default column width for the sheet (if the columns do not define their own width) in
+ * characters
+ * @return default column width
+ */
+
+ short getDefaultColumnWidth();
+
+ /**
+ * get the default row height for the sheet (if the rows do not define their own height) in
+ * twips (1/20 of a point)
+ * @return default row height
+ */
+
+ short getDefaultRowHeight();
+
+ /**
+ * get the default row height for the sheet (if the rows do not define their own height) in
+ * points.
+ * @return default row height in points
+ */
+
+ float getDefaultRowHeightInPoints();
+
+ /**
+ * set the default column width for the sheet (if the columns do not define their own width) in
+ * characters
+ * @param width default column width
+ */
+
+ void setDefaultColumnWidth(short width);
+
+ /**
+ * set the default row height for the sheet (if the rows do not define their own height) in
+ * twips (1/20 of a point)
+ * @param height default row height
+ */
+
+ void setDefaultRowHeight(short height);
+
+ /**
+ * set the default row height for the sheet (if the rows do not define their own height) in
+ * points
+ * @param height default row height
+ */
+
+ void setDefaultRowHeightInPoints(float height);
+
+ /**
+ * get whether gridlines are printed.
+ * @return true if printed
+ */
+
+ boolean isGridsPrinted();
+
+ /**
+ * set whether gridlines printed.
+ * @param value false if not printed.
+ */
+
+ void setGridsPrinted(boolean value);
+
+ /**
+ * adds a merged region of cells (hence those cells form one)
+ * @param region (rowfrom/colfrom-rowto/colto) to merge
+ * @return index of this region
+ */
+
+ int addMergedRegion(Region region);
+
+ /**
+ * determines whether the output is vertically centered on the page.
+ * @param value true to vertically center, false otherwise.
+ */
+
+ void setVerticallyCenter(boolean value);
+
+ /**
+ * Determine whether printed output for this sheet will be vertically centered.
+ */
+
+ boolean getVerticallyCenter(boolean value);
+
+ /**
+ * determines whether the output is horizontally centered on the page.
+ * @param value true to horizontally center, false otherwise.
+ */
+
+ void setHorizontallyCenter(boolean value);
+
+ /**
+ * Determine whether printed output for this sheet will be horizontally centered.
+ */
+
+ boolean getHorizontallyCenter();
+
+ /**
+ * removes a merged region of cells (hence letting them free)
+ * @param index of the region to unmerge
+ */
+
+ void removeMergedRegion(int index);
+
+ /**
+ * returns the number of merged regions
+ * @return number of merged regions
+ */
+
+ int getNumMergedRegions();
+
+ /**
+ * gets the region at a particular index
+ * @param index of the region to fetch
+ * @return the merged region (simple eh?)
+ */
+
+ Region getMergedRegionAt(int index);
+
+ /**
+ * @return an iterator of the PHYSICAL rows. Meaning the 3rd element may not
+ * be the third row if say for instance the second row is undefined.
+ */
+
+ Iterator rowIterator();
+
+ /**
+ * whether alternate expression evaluation is on
+ * @param b alternative expression evaluation or not
+ */
+
+ void setAlternativeExpression(boolean b);
+
+ /**
+ * whether alternative formula entry is on
+ * @param b alternative formulas or not
+ */
+
+ void setAlternativeFormula(boolean b);
+
+ /**
+ * show automatic page breaks or not
+ * @param b whether to show auto page breaks
+ */
+
+ void setAutobreaks(boolean b);
+
+ /**
+ * set whether sheet is a dialog sheet or not
+ * @param b isDialog or not
+ */
+
+ void setDialog(boolean b);
+
+ /**
+ * set whether to display the guts or not
+ *
+ * @param b guts or no guts (or glory)
+ */
+
+ void setDisplayGuts(boolean b);
+
+ /**
+ * fit to page option is on
+ * @param b fit or not
+ */
+
+ void setFitToPage(boolean b);
+
+ /**
+ * set if row summaries appear below detail in the outline
+ * @param b below or not
+ */
+
+ void setRowSumsBelow(boolean b);
+
+ /**
+ * set if col summaries appear right of the detail in the outline
+ * @param b right or not
+ */
+
+ void setRowSumsRight(boolean b);
+
+ /**
+ * whether alternate expression evaluation is on
+ * @return alternative expression evaluation or not
+ */
+
+ boolean getAlternateExpression();
+
+ /**
+ * whether alternative formula entry is on
+ * @return alternative formulas or not
+ */
+
+ boolean getAlternateFormula();
+
+ /**
+ * show automatic page breaks or not
+ * @return whether to show auto page breaks
+ */
+
+ boolean getAutobreaks();
+
+ /**
+ * get whether sheet is a dialog sheet or not
+ * @return isDialog or not
+ */
+
+ boolean getDialog();
+
+ /**
+ * get whether to display the guts or not
+ *
+ * @return guts or no guts (or glory)
+ */
+
+ boolean getDisplayGuts();
+
+ /**
+ * fit to page option is on
+ * @return fit or not
+ */
+
+ boolean getFitToPage();
+
+ /**
+ * get if row summaries appear below detail in the outline
+ * @return below or not
+ */
+
+ boolean getRowSumsBelow();
+
+ /**
+ * get if col summaries appear right of the detail in the outline
+ * @return right or not
+ */
+
+ boolean getRowSumsRight();
+
+ /**
+ * Returns whether gridlines are printed.
+ * @return Gridlines are printed
+ */
+ boolean isPrintGridlines();
+
+ /**
+ * Turns on or off the printing of gridlines.
+ * @param newPrintGridlines boolean to turn on or off the printing of
+ * gridlines
+ */
+ void setPrintGridlines(boolean newPrintGridlines);
+
+ /**
+ * Gets the print setup object.
+ * @return The user model for the print setup object.
+ */
+ PrintSetup getPrintSetup();
+
+ /**
+ * Gets the user model for the document header.
+ * @return The Document header.
+ */
+ Header getHeader();
+
+ /**
+ * Gets the user model for the document footer.
+ * @return The Document footer.
+ */
+ Footer getFooter();
+
+ /**
+ * Sets whether sheet is selected.
+ * @param sel Whether to select the sheet or deselect the sheet.
+ */
+ void setSelected(boolean sel);
+
+ /**
+ * Gets the size of the margin in inches.
+ * @param margin which margin to get
+ * @return the size of the margin
+ */
+ double getMargin(short margin);
+
+ /**
+ * Sets the size of the margin in inches.
+ * @param margin which margin to get
+ * @param size the size of the margin
+ */
+ void setMargin(short margin, double size);
+
+ /**
+ * Answer whether protection is enabled or disabled
+ * @return true => protection enabled; false => protection disabled
+ */
+ boolean getProtect();
+
+ /**
+ * @return hashed password
+ */
+ short getPassword();
+
+ /**
+ * Answer whether object protection is enabled or disabled
+ * @return true => protection enabled; false => protection disabled
+ */
+ boolean getObjectProtect();
+
+ /**
+ * Answer whether scenario protection is enabled or disabled
+ * @return true => protection enabled; false => protection disabled
+ */
+ boolean getScenarioProtect();
+
+ /**
+ * Sets the protection on enabled or disabled
+ * @param protect true => protection enabled; false => protection disabled
+ * @deprecated use protectSheet(String, boolean, boolean)
+ */
+ void setProtect(boolean protect);
+
+ /**
+ * Sets the protection enabled as well as the password
+ * @param password to set for protection
+ */
+ void protectSheet(String password);
+
+ /**
+ * Sets the zoom magnication for the sheet. The zoom is expressed as a
+ * fraction. For example to express a zoom of 75% use 3 for the numerator
+ * and 4 for the denominator.
+ *
+ * @param numerator The numerator for the zoom magnification.
+ * @param denominator The denominator for the zoom magnification.
+ */
+ void setZoom(int numerator, int denominator);
+
+ /**
+ * The top row in the visible view when the sheet is
+ * first viewed after opening it in a viewer
+ * @return short indicating the rownum (0 based) of the top row
+ */
+ short getTopRow();
+
+ /**
+ * The left col in the visible view when the sheet is
+ * first viewed after opening it in a viewer
+ * @return short indicating the rownum (0 based) of the top row
+ */
+ short getLeftCol();
+
+ /**
+ * Sets desktop window pane display area, when the
+ * file is first opened in a viewer.
+ * @param toprow the top row to show in desktop window pane
+ * @param leftcol the left column to show in desktop window pane
+ */
+ void showInPane(short toprow, short leftcol);
+
+ /**
+ * Shifts rows between startRow and endRow n number of rows.
+ * If you use a negative number, it will shift rows up.
+ * Code ensures that rows don't wrap around.
+ *
+ * Calls shiftRows(startRow, endRow, n, false, false);
+ *
+ * <p>
+ * Additionally shifts merged regions that are completely defined in these
+ * rows (ie. merged 2 cells on a row to be shifted).
+ * @param startRow the row to start shifting
+ * @param endRow the row to end shifting
+ * @param n the number of rows to shift
+ */
+ void shiftRows(int startRow, int endRow, int n);
+
+ /**
+ * Shifts rows between startRow and endRow n number of rows.
+ * If you use a negative number, it will shift rows up.
+ * Code ensures that rows don't wrap around
+ *
+ * <p>
+ * Additionally shifts merged regions that are completely defined in these
+ * rows (ie. merged 2 cells on a row to be shifted).
+ * <p>
+ * TODO Might want to add bounds checking here
+ * @param startRow the row to start shifting
+ * @param endRow the row to end shifting
+ * @param n the number of rows to shift
+ * @param copyRowHeight whether to copy the row height during the shift
+ * @param resetOriginalRowHeight whether to set the original row's height to the default
+ */
+ void shiftRows(int startRow, int endRow, int n, boolean copyRowHeight, boolean resetOriginalRowHeight);
+
+ /**
+ * Creates a split (freezepane). Any existing freezepane or split pane is overwritten.
+ * @param colSplit Horizonatal position of split.
+ * @param rowSplit Vertical position of split.
+ * @param topRow Top row visible in bottom pane
+ * @param leftmostColumn Left column visible in right pane.
+ */
+ void createFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow);
+
+ /**
+ * Creates a split (freezepane). Any existing freezepane or split pane is overwritten.
+ * @param colSplit Horizonatal position of split.
+ * @param rowSplit Vertical position of split.
+ */
+ void createFreezePane(int colSplit, int rowSplit);
+
+ /**
+ * Creates a split pane. Any existing freezepane or split pane is overwritten.
+ * @param xSplitPos Horizonatal position of split (in 1/20th of a point).
+ * @param ySplitPos Vertical position of split (in 1/20th of a point).
+ * @param topRow Top row visible in bottom pane
+ * @param leftmostColumn Left column visible in right pane.
+ * @param activePane Active pane. One of: PANE_LOWER_RIGHT,
+ * PANE_UPPER_RIGHT, PANE_LOWER_LEFT, PANE_UPPER_LEFT
+ * @see #PANE_LOWER_LEFT
+ * @see #PANE_LOWER_RIGHT
+ * @see #PANE_UPPER_LEFT
+ * @see #PANE_UPPER_RIGHT
+ */
+ void createSplitPane(int xSplitPos, int ySplitPos, int leftmostColumn, int topRow, int activePane);
+
+ /**
+ * Returns the information regarding the currently configured pane (split or freeze).
+ * @return null if no pane configured, or the pane information.
+ */
+ PaneInformation getPaneInformation();
+
+ /**
+ * Sets whether the gridlines are shown in a viewer.
+ * @param show whether to show gridlines or not
+ */
+ void setDisplayGridlines(boolean show);
+
+ /**
+ * Returns if gridlines are displayed.
+ * @return whether gridlines are displayed
+ */
+ boolean isDisplayGridlines();
+
+ /**
+ * Sets whether the formulas are shown in a viewer.
+ * @param show whether to show formulas or not
+ */
+ void setDisplayFormulas(boolean show);
+
+ /**
+ * Returns if formulas are displayed.
+ * @return whether formulas are displayed
+ */
+ boolean isDisplayFormulas();
+
+ /**
+ * Sets whether the RowColHeadings are shown in a viewer.
+ * @param show whether to show RowColHeadings or not
+ */
+ void setDisplayRowColHeadings(boolean show);
+
+ /**
+ * Returns if RowColHeadings are displayed.
+ * @return whether RowColHeadings are displayed
+ */
+ boolean isDisplayRowColHeadings();
+
+ /**
+ * Sets a page break at the indicated row
+ * @param row FIXME: Document this!
+ */
+ void setRowBreak(int row);
+
+ /**
+ * Determines if there is a page break at the indicated row
+ * @param row FIXME: Document this!
+ * @return FIXME: Document this!
+ */
+ boolean isRowBroken(int row);
+
+ /**
+ * Removes the page break at the indicated row
+ * @param row
+ */
+ void removeRowBreak(int row);
+
+ /**
+ * Retrieves all the horizontal page breaks
+ * @return all the horizontal page breaks, or null if there are no row page breaks
+ */
+ int[] getRowBreaks();
+
+ /**
+ * Retrieves all the vertical page breaks
+ * @return all the vertical page breaks, or null if there are no column page breaks
+ */
+ short[] getColumnBreaks();
+
+ /**
+ * Sets a page break at the indicated column
+ * @param column
+ */
+ void setColumnBreak(short column);
+
+ /**
+ * Determines if there is a page break at the indicated column
+ * @param column FIXME: Document this!
+ * @return FIXME: Document this!
+ */
+ boolean isColumnBroken(short column);
+
+ /**
+ * Removes a page break at the indicated column
+ * @param column
+ */
+ void removeColumnBreak(short column);
+
+ /**
+ * Aggregates the drawing records and dumps the escher record hierarchy
+ * to the standard output.
+ */
+ void dumpDrawingRecords(boolean fat);
+
+ /**
+ * Creates the toplevel drawing patriarch. This will have the effect of
+ * removing any existing drawings on this sheet.
+ *
+ * @return The new patriarch.
+ */
+ Patriarch createDrawingPatriarch();
+
+ /**
+ * Expands or collapses a column group.
+ *
+ * @param columnNumber One of the columns in the group.
+ * @param collapsed true = collapse group, false = expand group.
+ */
+ void setColumnGroupCollapsed(short columnNumber, boolean collapsed);
+
+ /**
+ * Create an outline for the provided column range.
+ *
+ * @param fromColumn beginning of the column range.
+ * @param toColumn end of the column range.
+ */
+ void groupColumn(short fromColumn, short toColumn);
+
+ void ungroupColumn(short fromColumn, short toColumn);
+
+ void groupRow(int fromRow, int toRow);
+
+ void ungroupRow(int fromRow, int toRow);
+
+ void setRowGroupCollapsed(int row, boolean collapse);
+
+ /**
+ * Sets the default column style for a given column. POI will only apply this style to new cells added to the sheet.
+ *
+ * @param column the column index
+ * @param style the style to set
+ */
+ void setDefaultColumnStyle(short column, CellStyle style);
+
+ /**
+ * Adjusts the column width to fit the contents.
+ *
+ * This process can be relatively slow on large sheets, so this should
+ * normally only be called once per column, at the end of your
+ * processing.
+ *
+ * @param column the column index
+ */
+ void autoSizeColumn(short column);
+
+ /**
+ * Returns cell comment for the specified row and column
+ *
+ * @return cell comment or <code>null</code> if not found
+ */
+ Comment getCellComment(int row, int column);
+
+}
\ No newline at end of file
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Sheet.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Sheet.java
------------------------------------------------------------------------------
svn:keywords = Date Revision Author HeadURL Id
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Sheet.java
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Textbox.java
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Textbox.java?rev=612495&view=auto
==============================================================================
--- poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Textbox.java (added)
+++ poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Textbox.java Wed Jan 16 08:08:22 2008
@@ -0,0 +1,74 @@
+/* ====================================================================
+ 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.ss.usermodel;
+
+public interface Textbox {
+
+ public final static short OBJECT_TYPE_TEXT = 6;
+
+ /**
+ * @return the rich text string for this textbox.
+ */
+ RichTextString getString();
+
+ /**
+ * @param string Sets the rich text string used by this object.
+ */
+ void setString(RichTextString string);
+
+ /**
+ * @return Returns the left margin within the textbox.
+ */
+ int getMarginLeft();
+
+ /**
+ * Sets the left margin within the textbox.
+ */
+ void setMarginLeft(int marginLeft);
+
+ /**
+ * @return returns the right margin within the textbox.
+ */
+ int getMarginRight();
+
+ /**
+ * Sets the right margin within the textbox.
+ */
+ void setMarginRight(int marginRight);
+
+ /**
+ * @return returns the top margin within the textbox.
+ */
+ int getMarginTop();
+
+ /**
+ * Sets the top margin within the textbox.
+ */
+ void setMarginTop(int marginTop);
+
+ /**
+ * Gets the bottom margin within the textbox.
+ */
+ int getMarginBottom();
+
+ /**
+ * Sets the bottom margin within the textbox.
+ */
+ void setMarginBottom(int marginBottom);
+
+}
\ No newline at end of file
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Textbox.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Textbox.java
------------------------------------------------------------------------------
svn:keywords = Date Revision Author HeadURL Id
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Textbox.java
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Workbook.java
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Workbook.java?rev=612495&view=auto
==============================================================================
--- poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Workbook.java (added)
+++ poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Workbook.java Wed Jan 16 08:08:22 2008
@@ -0,0 +1,458 @@
+/* ====================================================================
+ 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.ss.usermodel;
+
+import java.io.IOException;
+import java.io.OutputStream;
+import java.util.List;
+
+public interface Workbook {
+
+ /**
+ * used for compile-time performance/memory optimization. This determines the
+ * initial capacity for the sheet collection. Its currently set to 3.
+ * Changing it in this release will decrease performance
+ * since you're never allowed to have more or less than three sheets!
+ */
+
+ public final static int INITIAL_CAPACITY = 3;
+
+ /** Extended windows meta file */
+ public static final int PICTURE_TYPE_EMF = 2;
+
+ /** Windows Meta File */
+ public static final int PICTURE_TYPE_WMF = 3;
+
+ /** Mac PICT format */
+ public static final int PICTURE_TYPE_PICT = 4;
+
+ /** JPEG format */
+ public static final int PICTURE_TYPE_JPEG = 5;
+
+ /** PNG format */
+ public static final int PICTURE_TYPE_PNG = 6;
+
+ /** Device independant bitmap */
+ public static final int PICTURE_TYPE_DIB = 7;
+
+ /**
+ * sets the order of appearance for a given sheet.
+ *
+ * @param sheetname the name of the sheet to reorder
+ * @param pos the position that we want to insert the sheet into (0 based)
+ */
+
+ void setSheetOrder(String sheetname, int pos);
+
+ /**
+ * sets the tab whose data is actually seen when the sheet is opened.
+ * This may be different from the "selected sheet" since excel seems to
+ * allow you to show the data of one sheet when another is seen "selected"
+ * in the tabs (at the bottom).
+ * @see org.apache.poi.hssf.usermodel.HSSFSheet#setSelected(boolean)
+ * @param index
+ */
+ void setSelectedTab(short index);
+
+ /**
+ * gets the tab whose data is actually seen when the sheet is opened.
+ * This may be different from the "selected sheet" since excel seems to
+ * allow you to show the data of one sheet when another is seen "selected"
+ * in the tabs (at the bottom).
+ * @see org.apache.poi.hssf.usermodel.HSSFSheet#setSelected(boolean)
+ */
+ short getSelectedTab();
+
+ /**
+ * sets the first tab that is displayed in the list of tabs
+ * in excel.
+ * @param index
+ */
+ void setDisplayedTab(short index);
+
+ /**
+ * sets the first tab that is displayed in the list of tabs
+ * in excel.
+ */
+ short getDisplayedTab();
+
+ /**
+ * @deprecated POI will now properly handle unicode strings without
+ * forceing an encoding
+ */
+ public final static byte ENCODING_COMPRESSED_UNICODE = 0;
+
+ /**
+ * @deprecated POI will now properly handle unicode strings without
+ * forceing an encoding
+ */
+ public final static byte ENCODING_UTF_16 = 1;
+
+ /**
+ * set the sheet name.
+ * Will throw IllegalArgumentException if the name is greater than 31 chars
+ * or contains /\?*[]
+ * @param sheet number (0 based)
+ */
+ void setSheetName(int sheet, String name);
+
+ /**
+ * set the sheet name forcing the encoding. Forcing the encoding IS A BAD IDEA!!!
+ * @deprecated 3-Jan-2006 POI now automatically detects unicode and sets the encoding
+ * appropriately. Simply use setSheetName(int sheet, String encoding)
+ * @throws IllegalArgumentException if the name is greater than 31 chars
+ * or contains /\?*[]
+ * @param sheet number (0 based)
+ */
+ void setSheetName(int sheet, String name, short encoding);
+
+ /**
+ * get the sheet name
+ * @param sheet Number
+ * @return Sheet name
+ */
+
+ String getSheetName(int sheet);
+
+ /** Returns the index of the sheet by his name
+ * @param name the sheet name
+ * @return index of the sheet (0 based)
+ */
+ int getSheetIndex(String name);
+
+ /** Returns the index of the given sheet
+ * @param sheet the sheet to look up
+ * @return index of the sheet (0 based)
+ */
+ int getSheetIndex(Sheet sheet);
+
+ /**
+ * create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns
+ * the high level representation. Use this to create new sheets.
+ *
+ * @return HSSFSheet representing the new sheet.
+ */
+
+ Sheet createSheet();
+
+ /**
+ * create an HSSFSheet from an existing sheet in the HSSFWorkbook.
+ *
+ * @return HSSFSheet representing the cloned sheet.
+ */
+
+ Sheet cloneSheet(int sheetNum);
+
+ /**
+ * create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns
+ * the high level representation. Use this to create new sheets.
+ *
+ * @param sheetname sheetname to set for the sheet.
+ * @return HSSFSheet representing the new sheet.
+ */
+
+ Sheet createSheet(String sheetname);
+
+ /**
+ * get the number of spreadsheets in the workbook (this will be three after serialization)
+ * @return number of sheets
+ */
+
+ int getNumberOfSheets();
+
+ /**
+ * Get the HSSFSheet object at the given index.
+ * @param index of the sheet number (0-based physical & logical)
+ * @return HSSFSheet at the provided index
+ */
+
+ Sheet getSheetAt(int index);
+
+ /**
+ * Get sheet with the given name
+ * @param name of the sheet
+ * @return HSSFSheet with the name provided or null if it does not exist
+ */
+
+ Sheet getSheet(String name);
+
+ /**
+ * removes sheet at the given index
+ * @param index of the sheet (0-based)
+ */
+
+ void removeSheetAt(int index);
+
+ /**
+ * determine whether the Excel GUI will backup the workbook when saving.
+ *
+ * @param backupValue true to indicate a backup will be performed.
+ */
+
+ void setBackupFlag(boolean backupValue);
+
+ /**
+ * determine whether the Excel GUI will backup the workbook when saving.
+ *
+ * @return the current setting for backups.
+ */
+
+ boolean getBackupFlag();
+
+ /**
+ * Sets the repeating rows and columns for a sheet (as found in
+ * File->PageSetup->Sheet). This is function is included in the workbook
+ * because it creates/modifies name records which are stored at the
+ * workbook level.
+ * <p>
+ * To set just repeating columns:
+ * <pre>
+ * workbook.setRepeatingRowsAndColumns(0,0,1,-1-1);
+ * </pre>
+ * To set just repeating rows:
+ * <pre>
+ * workbook.setRepeatingRowsAndColumns(0,-1,-1,0,4);
+ * </pre>
+ * To remove all repeating rows and columns for a sheet.
+ * <pre>
+ * workbook.setRepeatingRowsAndColumns(0,-1,-1,-1,-1);
+ * </pre>
+ *
+ * @param sheetIndex 0 based index to sheet.
+ * @param startColumn 0 based start of repeating columns.
+ * @param endColumn 0 based end of repeating columns.
+ * @param startRow 0 based start of repeating rows.
+ * @param endRow 0 based end of repeating rows.
+ */
+ void setRepeatingRowsAndColumns(int sheetIndex, int startColumn, int endColumn, int startRow, int endRow);
+
+ /**
+ * create a new Font and add it to the workbook's font table
+ * @return new font object
+ */
+
+ Font createFont();
+
+ /**
+ * Finds a font that matches the one with the supplied attributes
+ */
+ Font findFont(short boldWeight, short color, short fontHeight, String name, boolean italic, boolean strikeout, short typeOffset, byte underline);
+
+ /**
+ * get the number of fonts in the font table
+ * @return number of fonts
+ */
+
+ short getNumberOfFonts();
+
+ /**
+ * get the font at the given index number
+ * @param idx index number
+ * @return HSSFFont at the index
+ */
+
+ Font getFontAt(short idx);
+
+ /**
+ * create a new Cell style and add it to the workbook's style table
+ * @return the new Cell Style object
+ */
+
+ CellStyle createCellStyle();
+
+ /**
+ * get the number of styles the workbook contains
+ * @return count of cell styles
+ */
+
+ short getNumCellStyles();
+
+ /**
+ * get the cell style object at the given index
+ * @param idx index within the set of styles
+ * @return HSSFCellStyle object at the index
+ */
+
+ CellStyle getCellStyleAt(short idx);
+
+ /**
+ * Method write - write out this workbook to an Outputstream. Constructs
+ * a new POI POIFSFileSystem, passes in the workbook binary representation and
+ * writes it out.
+ *
+ * @param stream - the java OutputStream you wish to write the XLS to
+ *
+ * @exception IOException if anything can't be written.
+ * @see org.apache.poi.poifs.filesystem.POIFSFileSystem
+ */
+
+ void write(OutputStream stream) throws IOException;
+
+ /**
+ * Method getBytes - get the bytes of just the HSSF portions of the XLS file.
+ * Use this to construct a POI POIFSFileSystem yourself.
+ *
+ *
+ * @return byte[] array containing the binary representation of this workbook and all contained
+ * sheets, rows, cells, etc.
+ *
+ * @see org.apache.poi.hssf.model.Workbook
+ * @see org.apache.poi.hssf.model.Sheet
+ */
+
+ byte[] getBytes();
+
+ /** @deprecated Do not call this method from your applications. Use the methods
+ * available in the HSSFRow to add string HSSFCells
+ */
+ int addSSTString(String string);
+
+ /** @deprecated Do not call this method from your applications. Use the methods
+ * available in the HSSFRow to get string HSSFCells
+ */
+ String getSSTString(int index);
+
+ /** gets the total number of named ranges in the workboko
+ * @return number of named ranges
+ */
+ int getNumberOfNames();
+
+ /** gets the Named range
+ * @param index position of the named range
+ * @return named range high level
+ */
+ Name getNameAt(int index);
+
+ /** gets the named range name
+ * @param index the named range index (0 based)
+ * @return named range name
+ */
+ String getNameName(int index);
+
+ /**
+ * Sets the printarea for the sheet provided
+ * <p>
+ * i.e. Reference = $A$1:$B$2
+ * @param sheetIndex Zero-based sheet index (0 Represents the first sheet to keep consistent with java)
+ * @param reference Valid name Reference for the Print Area
+ */
+ void setPrintArea(int sheetIndex, String reference);
+
+ /**
+ * For the Convenience of Java Programmers maintaining pointers.
+ * @see #setPrintArea(int, String)
+ * @param sheetIndex Zero-based sheet index (0 = First Sheet)
+ * @param startColumn Column to begin printarea
+ * @param endColumn Column to end the printarea
+ * @param startRow Row to begin the printarea
+ * @param endRow Row to end the printarea
+ */
+ void setPrintArea(int sheetIndex, int startColumn, int endColumn, int startRow, int endRow);
+
+ /**
+ * Retrieves the reference for the printarea of the specified sheet, the sheet name is appended to the reference even if it was not specified.
+ * @param sheetIndex Zero-based sheet index (0 Represents the first sheet to keep consistent with java)
+ * @return String Null if no print area has been defined
+ */
+ String getPrintArea(int sheetIndex);
+
+ /**
+ * Delete the printarea for the sheet specified
+ * @param sheetIndex Zero-based sheet index (0 = First Sheet)
+ */
+ void removePrintArea(int sheetIndex);
+
+ /** creates a new named range and add it to the model
+ * @return named range high level
+ */
+ Name createName();
+
+ /** gets the named range index by his name
+ * <i>Note:</i>Excel named ranges are case-insensitive and
+ * this method performs a case-insensitive search.
+ *
+ * @param name named range name
+ * @return named range index
+ */
+ int getNameIndex(String name);
+
+ /** remove the named range by his index
+ * @param index named range index (0 based)
+ */
+ void removeName(int index);
+
+ /**
+ * Returns the instance of HSSFDataFormat for this workbook.
+ * @return the HSSFDataFormat object
+ * @see org.apache.poi.hssf.record.FormatRecord
+ * @see org.apache.poi.hssf.record.Record
+ */
+ DataFormat createDataFormat();
+
+ /** remove the named range by his name
+ * @param name named range name
+ */
+ void removeName(String name);
+
+ Palette getCustomPalette();
+
+ /** Test only. Do not use */
+ void insertChartRecord();
+
+ /**
+ * Spits out a list of all the drawing records in the workbook.
+ */
+ void dumpDrawingGroupRecords(boolean fat);
+
+ /**
+ * Adds a picture to the workbook.
+ *
+ * @param pictureData The bytes of the picture
+ * @param format The format of the picture. One of <code>PICTURE_TYPE_*</code>
+ *
+ * @return the index to this picture (1 based).
+ */
+ int addPicture(byte[] pictureData, int format);
+
+ /**
+ * Gets all pictures from the Workbook.
+ *
+ * @return the list of pictures (a list of {@link HSSFPictureData} objects.)
+ */
+ List getAllPictures();
+
+ /**
+ * protect a workbook with a password (not encypted, just sets writeprotect
+ * flags and the password.
+ * @param password to set
+ */
+ void writeProtectWorkbook(String password, String username);
+
+ /**
+ * removes the write protect flag
+ */
+ void unwriteProtectWorkbook();
+
+ /**
+ * Gets all embedded OLE2 objects from the Workbook.
+ *
+ * @return the list of embedded objects (a list of {@link HSSFObjectData} objects.)
+ */
+ List getAllEmbeddedObjects();
+
+}
\ No newline at end of file
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Workbook.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Workbook.java
------------------------------------------------------------------------------
svn:keywords = Date Revision Author HeadURL Id
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/ss/usermodel/Workbook.java
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/strings/SharedStringsTable.java
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/strings/SharedStringsTable.java?rev=612495&view=auto
==============================================================================
--- poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/strings/SharedStringsTable.java (added)
+++ poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/strings/SharedStringsTable.java Wed Jan 16 08:08:22 2008
@@ -0,0 +1,126 @@
+/* ====================================================================
+ 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.strings;
+
+import java.io.IOException;
+import java.io.InputStream;
+import java.io.OutputStream;
+import java.util.LinkedList;
+
+import org.apache.poi.ss.usermodel.SharedStringSource;
+import org.apache.xmlbeans.XmlException;
+import org.apache.xmlbeans.XmlOptions;
+import org.openxml4j.opc.PackagePart;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRst;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSst;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.SstDocument;
+
+
+/**
+ * Table of strings shared across all sheets in a workbook.
+ *
+ * FIXME: I don't like having a dependency on PackagePart (from OpenXML4J) in model classes.
+ * I'd rather let Workbook keep track of all part-document relationships and keep all other
+ * classes clean. -- Ugo
+ *
+ * @version $Id$
+ */
+public class SharedStringsTable implements SharedStringSource {
+
+ private final LinkedList<String> strings = new LinkedList<String>();
+
+ private PackagePart part;
+
+ /**
+ * Create a new SharedStringsTable by reading it from a PackagePart.
+ *
+ * @param part The PackagePart to read.
+ * @throws IOException if an error occurs while reading.
+ */
+ public SharedStringsTable(PackagePart part) throws IOException {
+ this.part = part;
+ InputStream is = part.getInputStream();
+ try {
+ readFrom(is);
+ } finally {
+ if (is != null) is.close();
+ }
+ }
+
+ /**
+ * Read this shared strings table from an XML file.
+ *
+ * @param is The input stream containing the XML document.
+ * @throws IOException if an error occurs while reading.
+ */
+ public void readFrom(InputStream is) throws IOException {
+ try {
+ SstDocument doc = SstDocument.Factory.parse(is);
+ for (CTRst rst : doc.getSst().getSiArray()) {
+ strings.add(rst.getT());
+ }
+ } catch (XmlException e) {
+ throw new IOException(e.getLocalizedMessage());
+ }
+ }
+
+ public String getSharedStringAt(int idx) {
+ return strings.get(idx);
+ }
+
+ public synchronized int putSharedString(String s) {
+ if (strings.contains(s)) {
+ return strings.indexOf(s);
+ }
+ strings.add(s);
+ return strings.size() - 1;
+ }
+
+ /**
+ * Save this table to its own PackagePart.
+ *
+ * @throws IOException if an error occurs while writing.
+ */
+ public void save() throws IOException {
+ OutputStream out = this.part.getOutputStream();
+ try {
+ writeTo(out);
+ } finally {
+ out.close();
+ }
+ }
+
+ /**
+ * Write this table out as XML.
+ *
+ * @param out The stream to write to.
+ * @throws IOException if an error occurs while writing.
+ */
+ public void writeTo(OutputStream out) throws IOException {
+ XmlOptions options = new XmlOptions();
+ options.setSaveOuter();
+ SstDocument doc = SstDocument.Factory.newInstance(options);
+ CTSst sst = doc.addNewSst();
+ sst.setCount(strings.size());
+ sst.setUniqueCount(strings.size());
+ for (String s : strings) {
+ sst.addNewSi().setT(s);
+ }
+ doc.save(out);
+ }
+}
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/strings/SharedStringsTable.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/strings/SharedStringsTable.java
------------------------------------------------------------------------------
svn:keywords = Date Revision Author HeadURL Id
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/strings/SharedStringsTable.java
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFCell.java
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFCell.java?rev=612495&view=auto
==============================================================================
--- poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFCell.java (added)
+++ poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFCell.java Wed Jan 16 08:08:22 2008
@@ -0,0 +1,268 @@
+/* ====================================================================
+ 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 java.util.Calendar;
+import java.util.Date;
+
+import org.apache.poi.hssf.usermodel.HSSFDateUtil;
+import org.apache.poi.ss.usermodel.Cell;
+import org.apache.poi.ss.usermodel.CellStyle;
+import org.apache.poi.ss.usermodel.Comment;
+import org.apache.poi.ss.usermodel.RichTextString;
+import org.apache.poi.ss.usermodel.SharedStringSource;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCell;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellFormula;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.STCellType;
+
+
+public class XSSFCell implements Cell {
+
+ private static final String FALSE_AS_STRING = "0";
+ private static final String TRUE_AS_STRING = "1";
+ private final CTCell cell;
+ private final XSSFRow row;
+ private SharedStringSource sharedStringSource;
+ private short cellNum;
+
+ /**
+ * Create a new XSSFCell. This method is protected to be used only by
+ * tests.
+ */
+ protected XSSFCell(XSSFRow row) {
+ this(row, CTCell.Factory.newInstance());
+ }
+
+ public XSSFCell(XSSFRow row, CTCell cell) {
+ this.cell = cell;
+ this.row = row;
+ }
+
+ protected void setSharedStringSource(SharedStringSource sharedStringSource) {
+ this.sharedStringSource = sharedStringSource;
+ }
+
+ public boolean getBooleanCellValue() {
+ if (STCellType.B != cell.getT()) {
+ throw new NumberFormatException("You cannot get a boolean value from a non-boolean cell");
+ }
+ if (cell.isSetV()) {
+ return (TRUE_AS_STRING.equals(this.cell.getV()));
+ }
+
+ return false;
+ }
+
+ public Comment getCellComment() {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public String getCellFormula() {
+ if (STCellType.STR != cell.getT()) {
+ throw new NumberFormatException("You cannot get a formula from a non-formula cell");
+ }
+ return this.cell.getF().getStringValue();
+ }
+
+ public short getCellNum() {
+ return this.cellNum;
+ }
+
+ public CellStyle getCellStyle() {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public int getCellType() {
+ switch (this.cell.getT().intValue()) {
+ case STCellType.INT_B:
+ return CELL_TYPE_BOOLEAN;
+ case STCellType.INT_N:
+ return CELL_TYPE_NUMERIC;
+ case STCellType.INT_E:
+ return CELL_TYPE_ERROR;
+ case STCellType.INT_S: // String is in shared strings
+ case STCellType.INT_INLINE_STR: // String is inline in cell
+ return CELL_TYPE_STRING;
+ case STCellType.INT_STR:
+ return CELL_TYPE_FORMULA;
+ default:
+ throw new IllegalStateException("Illegal cell type: " + this.cell.getT());
+ }
+ }
+
+ public Date getDateCellValue() {
+ if (STCellType.N == this.cell.getT() || STCellType.STR == this.cell.getT()) {
+ double value = this.getNumericCellValue();
+ if (false /* book.isUsing1904DateWindowing() */) { // FIXME
+ return HSSFDateUtil.getJavaDate(value,true);
+ }
+ else {
+ return HSSFDateUtil.getJavaDate(value,false);
+ }
+ }
+ throw new NumberFormatException("You cannot get a date value from a cell of type " + this.cell.getT());
+ }
+
+ public byte getErrorCellValue() {
+ if (STCellType.E != cell.getT()) {
+ throw new NumberFormatException("You cannot get a error value from a non-error cell");
+ }
+ if (this.cell.isSetV()) {
+ return Byte.parseByte(this.cell.getV());
+ }
+ return 0;
+ }
+
+ public double getNumericCellValue() {
+ if (STCellType.N != cell.getT() && STCellType.STR != cell.getT()) {
+ throw new NumberFormatException("You cannot get a numeric value from a non-numeric cell");
+ }
+ if (this.cell.isSetV()) {
+ return Double.parseDouble(this.cell.getV());
+ }
+ return Double.NaN;
+ }
+
+ public RichTextString getRichStringCellValue() {
+ if(this.cell.getT() == STCellType.INLINE_STR) {
+ if(this.cell.isSetV()) {
+ return new XSSFRichTextString(this.cell.getV());
+ } else {
+ return new XSSFRichTextString("");
+ }
+ }
+ if(this.cell.getT() == STCellType.S) {
+ if(this.cell.isSetV()) {
+ int sRef = Integer.parseInt(this.cell.getV());
+ return new XSSFRichTextString(sharedStringSource.getSharedStringAt(sRef));
+ } else {
+ return new XSSFRichTextString("");
+ }
+ }
+ throw new NumberFormatException("You cannot get a string value from a non-string cell");
+ }
+
+ public void setAsActiveCell() {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setCellComment(Comment comment) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setCellErrorValue(byte value) {
+ if ((this.cell.getT() != STCellType.E) && (this.cell.getT() != STCellType.STR))
+ {
+ this.cell.setT(STCellType.E);
+ }
+ this.cell.setV(String.valueOf(value));
+ }
+
+
+
+ public void setCellFormula(String formula) {
+ if (this.cell.getT() != STCellType.STR)
+ {
+ this.cell.setT(STCellType.STR);
+ }
+ CTCellFormula f = CTCellFormula.Factory.newInstance();
+ f.setStringValue(formula);
+ this.cell.setF(f);
+ // XXX: is this correct? Should we recompute the value when the formula changes?
+ if (this.cell.isSetV()) {
+ this.cell.unsetV();
+ }
+
+ }
+
+ public void setCellNum(short num) {
+ this.cellNum = num;
+ }
+
+ public void setCellStyle(CellStyle style) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setCellType(int cellType) {
+ switch (cellType) {
+ case CELL_TYPE_BOOLEAN:
+ this.cell.setT(STCellType.B);
+ break;
+ case CELL_TYPE_NUMERIC:
+ this.cell.setT(STCellType.N);
+ break;
+ case CELL_TYPE_ERROR:
+ this.cell.setT(STCellType.E);
+ break;
+ case CELL_TYPE_STRING:
+ this.cell.setT(STCellType.S);
+ break;
+ default:
+ throw new IllegalArgumentException("Illegal type: " + cellType);
+ }
+ }
+
+ public void setCellValue(double value) {
+ if ((this.cell.getT() != STCellType.N) && (this.cell.getT() != STCellType.STR))
+ {
+ this.cell.setT(STCellType.N);
+ }
+ this.cell.setV(String.valueOf(value));
+ }
+
+ public void setCellValue(Date value) {
+ setCellValue(HSSFDateUtil.getExcelDate(value, false /*this.book.isUsing1904DateWindowing()*/)); // FIXME
+ }
+
+ public void setCellValue(Calendar value) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setCellValue(RichTextString value) {
+ if(this.cell.getT() == STCellType.INLINE_STR) {
+ this.cell.setV(value.getString());
+ return;
+ }
+ if(this.cell.getT() != STCellType.S) {
+ this.cell.setT(STCellType.S);
+ }
+ int sRef = sharedStringSource.putSharedString(value.getString());
+ this.cell.setV(Integer.toString(sRef));
+ }
+
+ public void setCellValue(boolean value) {
+ if ((this.cell.getT() != STCellType.B) && (this.cell.getT() != STCellType.STR))
+ {
+ this.cell.setT(STCellType.B);
+ }
+ this.cell.setV(value ? TRUE_AS_STRING : FALSE_AS_STRING);
+ }
+
+ @Override
+ public String toString() {
+ return "[" + this.row.getRowNum() + "," + this.getCellNum() + "] " + this.cell.getV();
+ }
+
+
+}
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFCell.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFCell.java
------------------------------------------------------------------------------
svn:keywords = Date Revision Author HeadURL Id
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFCell.java
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRichTextString.java
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRichTextString.java?rev=612495&view=auto
==============================================================================
--- poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRichTextString.java (added)
+++ poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRichTextString.java Wed Jan 16 08:08:22 2008
@@ -0,0 +1,91 @@
+/* ====================================================================
+ 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.Font;
+import org.apache.poi.ss.usermodel.RichTextString;
+
+
+/**
+ * TODO - the rich part
+ */
+public class XSSFRichTextString implements RichTextString {
+ private String string;
+
+ public XSSFRichTextString(String str) {
+ this.string = str;
+ }
+
+ public void applyFont(int startIndex, int endIndex, short fontIndex) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void applyFont(int startIndex, int endIndex, Font font) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void applyFont(Font font) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void applyFont(short fontIndex) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void clearFormatting() {
+ // TODO Auto-generated method stub
+
+ }
+
+ public int compareTo(Object o) {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public short getFontAtIndex(int index) {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public short getFontOfFormattingRun(int index) {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public int getIndexOfFormattingRun(int index) {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public String getString() {
+ return string;
+ }
+
+ public int length() {
+ return string.length();
+ }
+
+ public int numFormattingRuns() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+}
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRichTextString.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRichTextString.java
------------------------------------------------------------------------------
svn:keywords = Date Revision Author HeadURL Id
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRichTextString.java
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRow.java
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRow.java?rev=612495&view=auto
==============================================================================
--- poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRow.java (added)
+++ poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRow.java Wed Jan 16 08:08:22 2008
@@ -0,0 +1,200 @@
+/* ====================================================================
+ 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 java.util.Iterator;
+import java.util.LinkedList;
+import java.util.List;
+
+import org.apache.poi.ss.usermodel.Cell;
+import org.apache.poi.ss.usermodel.Row;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCell;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRow;
+
+
+public class XSSFRow implements Row {
+
+ private CTRow row;
+
+ private List<Cell> cells;
+
+ /**
+ * Create a new XSSFRow. This method is protected to be used only by
+ * tests.
+ */
+ protected XSSFRow() {
+ this(CTRow.Factory.newInstance());
+ }
+
+ public XSSFRow(CTRow row) {
+ this.row = row;
+ this.cells = new LinkedList<Cell>();
+ for (CTCell c : row.getCArray()) {
+ this.cells.add(new XSSFCell(this, c));
+ }
+
+ }
+
+ public Iterator<Cell> cellIterator() {
+ return cells.iterator();
+ }
+
+ public int compareTo(Object obj) {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public Cell createCell(short column) {
+ return createCell(column, Cell.CELL_TYPE_BLANK);
+ }
+
+ /**
+ * Add a new empty cell to this row.
+ *
+ * @param column Cell column number.
+ * @param index Position where to insert cell.
+ * @param type TODO
+ * @return The new cell.
+ */
+ protected XSSFCell addCell(short column, int index, int type) {
+ CTCell ctcell = row.insertNewC(index);
+ XSSFCell xcell = new XSSFCell(this, ctcell);
+ xcell.setCellNum(column);
+ if (type != Cell.CELL_TYPE_BLANK) {
+ xcell.setCellType(type);
+ }
+ return xcell;
+ }
+
+ public Cell createCell(short column, int type) {
+ int index = 0;
+ for (Cell c : this.cells) {
+ if (c.getCellNum() == column) {
+ // Replace c with new Cell
+ XSSFCell xcell = addCell(column, index, type);
+ cells.set(index, xcell);
+ return xcell;
+ }
+ if (c.getCellNum() > column) {
+ XSSFCell xcell = addCell(column, index, type);
+ cells.add(index, xcell);
+ return xcell;
+ }
+ ++index;
+ }
+ XSSFCell xcell = addCell(column, index, type);
+ cells.add(xcell);
+ return xcell;
+ }
+
+ public Cell getCell(short cellnum) {
+ Iterator<Cell> it = cellIterator();
+ for ( ; it.hasNext() ; ) {
+ Cell cell = it.next();
+ if (cell.getCellNum() == cellnum) {
+ return cell;
+ }
+ }
+ return null;
+ }
+
+ public short getFirstCellNum() {
+ for (Iterator<Cell> it = cellIterator() ; it.hasNext() ; ) {
+ Cell cell = it.next();
+ if (cell != null) {
+ return cell.getCellNum();
+ }
+ }
+ return -1;
+ }
+
+ public short getHeight() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public float getHeightInPoints() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public short getLastCellNum() {
+ short lastCellNum = -1;
+ for (Iterator<Cell> it = cellIterator() ; it.hasNext() ; ) {
+ Cell cell = it.next();
+ if (cell != null) {
+ lastCellNum = cell.getCellNum();
+ }
+ }
+ return lastCellNum;
+ }
+
+ public int getPhysicalNumberOfCells() {
+ int count = 0;
+ for (Iterator<Cell> it = cellIterator() ; it.hasNext() ; ) {
+ if (it.next() != null) {
+ count++;
+ }
+ }
+ return count;
+ }
+
+ public int getRowNum() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public boolean getZeroHeight() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public void removeCell(Cell cell) {
+ int counter = 0;
+ for (Iterator<Cell> it = cellIterator(); it.hasNext(); ) {
+ Cell c = it.next();
+ if (c.getCellNum() == cell.getCellNum()) {
+ it.remove();
+ row.removeC(counter);
+ continue;
+ }
+ counter++;
+ }
+ }
+
+ public void setHeight(short height) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setHeightInPoints(float height) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setRowNum(int rowNum) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setZeroHeight(boolean height) {
+ // TODO Auto-generated method stub
+
+ }
+
+}
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRow.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRow.java
------------------------------------------------------------------------------
svn:keywords = Date Revision Author HeadURL Id
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRow.java
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java
URL: http://svn.apache.org/viewvc/poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java?rev=612495&view=auto
==============================================================================
--- poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java (added)
+++ poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java Wed Jan 16 08:08:22 2008
@@ -0,0 +1,549 @@
+/* ====================================================================
+ 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 java.util.Iterator;
+
+import org.apache.poi.hssf.util.PaneInformation;
+import org.apache.poi.hssf.util.Region;
+import org.apache.poi.ss.usermodel.CellStyle;
+import org.apache.poi.ss.usermodel.Comment;
+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.PrintSetup;
+import org.apache.poi.ss.usermodel.Row;
+import org.apache.poi.ss.usermodel.Sheet;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCol;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTHeaderFooter;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRow;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSelection;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetFormatPr;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetView;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetViews;
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet;
+
+
+public class XSSFSheet implements Sheet {
+
+ private CTSheet sheet;
+
+ private CTWorksheet worksheet;
+
+ public XSSFSheet(CTSheet sheet) {
+ this.sheet = sheet;
+ this.worksheet = CTWorksheet.Factory.newInstance();
+ this.worksheet.addNewSheetData();
+ // XXX ???
+ CTSheetViews views = this.worksheet.addNewSheetViews();
+ CTSheetView view = views.addNewSheetView();
+ view.setWorkbookViewId(0);
+ view.setZoomScale(100);
+ CTSelection selection = view.addNewSelection();
+ selection.setActiveCell("A1");
+ CTSheetFormatPr format = this.worksheet.addNewSheetFormatPr();
+ format.setDefaultColWidth(13.2307692307692);
+ format.setDefaultRowHeight(13);
+ format.setCustomHeight(true);
+ CTCols cols = this.worksheet.addNewCols();
+ CTCol col = cols.addNewCol();
+ col.setMin(1);
+ col.setMax(2);
+ col.setWidth(13.2307692307692);
+ col.setCustomWidth(true);
+ for (int i = 3 ; i < 5 ; ++i) {
+ col = cols.addNewCol();
+ col.setMin(i);
+ col.setMax(i);
+ col.setWidth(13.2307692307692);
+ col.setCustomWidth(true);
+ }
+ CTHeaderFooter hf = this.worksheet.addNewHeaderFooter();
+ hf.setOddHeader("&C&A");
+ hf.setOddFooter("&C&\"Arial\"&10Page &P");
+ }
+
+ protected CTWorksheet getWorksheet() {
+ return this.worksheet;
+ }
+
+ public int addMergedRegion(Region region) {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public void autoSizeColumn(short column) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public Patriarch createDrawingPatriarch() {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public void createFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void createFreezePane(int colSplit, int rowSplit) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public Row createRow(int rownum) {
+ CTRow row = this.worksheet.getSheetData().insertNewRow(rownum);
+ row.setR(rownum + 1);
+ row.setHt(13.41); // XXX ???
+ return new XSSFRow(row);
+ }
+
+ public void createSplitPane(int splitPos, int splitPos2, int leftmostColumn, int topRow, int activePane) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void dumpDrawingRecords(boolean fat) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public boolean getAlternateExpression() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public boolean getAlternateFormula() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public boolean getAutobreaks() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public Comment getCellComment(int row, int column) {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public short[] getColumnBreaks() {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public short getColumnWidth(short column) {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public short getDefaultColumnWidth() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public short getDefaultRowHeight() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public float getDefaultRowHeightInPoints() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public boolean getDialog() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public boolean getDisplayGuts() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public int getFirstRowNum() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public boolean getFitToPage() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public Footer getFooter() {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public Header getHeader() {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public boolean getHorizontallyCenter() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public int getLastRowNum() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public short getLeftCol() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public double getMargin(short margin) {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public Region getMergedRegionAt(int index) {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public int getNumMergedRegions() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public boolean getObjectProtect() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public PaneInformation getPaneInformation() {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public short getPassword() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public int getPhysicalNumberOfRows() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public PrintSetup getPrintSetup() {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public boolean getProtect() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public Row getRow(int rownum) {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public int[] getRowBreaks() {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public boolean getRowSumsBelow() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public boolean getRowSumsRight() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public boolean getScenarioProtect() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public short getTopRow() {
+ // TODO Auto-generated method stub
+ return 0;
+ }
+
+ public boolean getVerticallyCenter(boolean value) {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public void groupColumn(short fromColumn, short toColumn) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void groupRow(int fromRow, int toRow) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public boolean isColumnBroken(short column) {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public boolean isColumnHidden(short column) {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public boolean isDisplayFormulas() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public boolean isDisplayGridlines() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public boolean isDisplayRowColHeadings() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public boolean isGridsPrinted() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public boolean isPrintGridlines() {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public boolean isRowBroken(int row) {
+ // TODO Auto-generated method stub
+ return false;
+ }
+
+ public void protectSheet(String password) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void removeColumnBreak(short column) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void removeMergedRegion(int index) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void removeRow(Row row) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void removeRowBreak(int row) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public Iterator rowIterator() {
+ // TODO Auto-generated method stub
+ return null;
+ }
+
+ public void setAlternativeExpression(boolean b) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setAlternativeFormula(boolean b) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setAutobreaks(boolean b) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setColumnBreak(short column) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setColumnGroupCollapsed(short columnNumber, boolean collapsed) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setColumnHidden(short column, boolean hidden) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setColumnWidth(short column, short width) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setDefaultColumnStyle(short column, CellStyle style) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setDefaultColumnWidth(short width) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setDefaultRowHeight(short height) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setDefaultRowHeightInPoints(float height) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setDialog(boolean b) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setDisplayFormulas(boolean show) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setDisplayGridlines(boolean show) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setDisplayGuts(boolean b) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setDisplayRowColHeadings(boolean show) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setFitToPage(boolean b) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setGridsPrinted(boolean value) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setHorizontallyCenter(boolean value) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setMargin(short margin, double size) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setPrintGridlines(boolean newPrintGridlines) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setProtect(boolean protect) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setRowBreak(int row) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setRowGroupCollapsed(int row, boolean collapse) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setRowSumsBelow(boolean b) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setRowSumsRight(boolean b) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setSelected(boolean sel) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setVerticallyCenter(boolean value) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void setZoom(int numerator, int denominator) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void shiftRows(int startRow, int endRow, int n) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void shiftRows(int startRow, int endRow, int n, boolean copyRowHeight, boolean resetOriginalRowHeight) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void showInPane(short toprow, short leftcol) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void ungroupColumn(short fromColumn, short toColumn) {
+ // TODO Auto-generated method stub
+
+ }
+
+ public void ungroupRow(int fromRow, int toRow) {
+ // TODO Auto-generated method stub
+
+ }
+
+}
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java
------------------------------------------------------------------------------
svn:keywords = Date Revision Author HeadURL Id
Propchange: poi/branches/ooxml/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java
------------------------------------------------------------------------------
svn:mime-type = text/plain
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org