Attachment #27033 for bug #51196

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




/* ====================================================================
   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.examples;

import java.io.FileOutputStream;
import java.util.Date;

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.*;
import org.apache.poi.ss.usermodel.charts.*;
import org.apache.poi.xssf.usermodel.*;
import org.apache.poi.xssf.usermodel.charts.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook; 

/**
 * Illustrates how to create a simple scatter chart.
 */
public class ScatterChart {

	public static void main(String[]args) throws Exception {
		Workbook wb = new XSSFWorkbook();
		CreationHelper creationHelper = wb.getCreationHelper();
		Sheet sheet = wb.createSheet("new sheet");
		final int NUM_OF_ROWS = 3;
		final int NUM_OF_COLUMNS = 10;

		// Create a row and put some cells in it. Rows are 0 based.
		Row row;
		Cell cell;
		for (int rowIndex = 0; rowIndex < NUM_OF_ROWS; rowIndex++) {
			row = sheet.createRow((short)rowIndex);
			for (int colIndex = 0; colIndex < NUM_OF_COLUMNS; colIndex++) {
				cell = row.createCell((short)colIndex);
				cell.setCellValue(colIndex * (rowIndex + 1));
			}
		}

		Drawing drawing = sheet.createDrawingPatriarch();
		ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 0, 5, 10, 15);

		Chart chart = drawing.createChart(anchor);
		ChartLegend legend = chart.getOrCreateLegend();
		legend.setPosition(LegendPosition.RIGHT);

		ScatterChartData data = chart.getChartDataFactory().createScatterChartData();

		ValueAxis bottomAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM);
		ValueAxis leftAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.LEFT);

		ScatterChartSerie firstSerie = data.addSerie();
		firstSerie.setXValues(sheet, new CellRangeAddress(0, 0, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));
		firstSerie.setXValues(sheet, new CellRangeAddress(1, 1, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));

		ScatterChartSerie secondSerie = data.addSerie();
		secondSerie.setXValues(sheet, new CellRangeAddress(0, 0, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));
		secondSerie.setYValues(sheet, new CellRangeAddress(2, 2, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));

		chart.plot(data, bottomAxis, leftAxis);

		// Write the output to a file
		FileOutputStream fileOut = new FileOutputStream("ooxml-scatter-chart.xlsx");
		wb.write(fileOut);
		fileOut.close();
	}
}




/* ====================================================================
   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.List;

import org.apache.poi.ss.usermodel.charts.ChartData;
import org.apache.poi.ss.usermodel.charts.ChartAxis;
import org.apache.poi.ss.usermodel.charts.ChartLegend;
import org.apache.poi.ss.usermodel.charts.ChartDataFactory;
import org.apache.poi.ss.usermodel.charts.ChartAxisFactory;

/**
 * High level representation of a chart.
 *
 * @author Roman Kashitsyn
 */
public interface Chart {
	
	/**
	 * @return an appropriate ChartDataFactory implementation
	 */
	ChartDataFactory getChartDataFactory();

	/**
	 * @return an appropriate ChartAxisFactory implementation
	 */
	ChartAxisFactory getChartAxisFactory();

	/**
	 * @return chart legend instance
	 */
	ChartLegend getOrCreateLegend();

	/**
	 * Delete current chart legend.
	 */
	void deleteLegend();

	/**
	 * @return list of all chart axis
	 */
	List<? extends ChartAxis> getAxis();

	/**
	 * Plots specified data on the chart.
	 *
	 * @param data a data to plot
	 */
	void plot(ChartData data, ChartAxis... axis);
}




package org.apache.poi.ss.usermodel;

/**
 * High level representation of spreadsheet drawing.
 * @author Yegor Kozlov
 * @author Roman Kashitsyn
 */
public interface Drawing {
	/**
	 * Creates a picture.
	 * @param anchor       the client anchor describes how this picture is
	 *                     attached to the sheet.
	 * @param pictureIndex the index of the picture in the workbook collection
	 *                     of pictures.
	 *
	 * @return the newly created picture.
	 */
	Picture createPicture(ClientAnchor anchor, int pictureIndex);

	/**
	 * Creates a comment.
	 * @param anchor the client anchor describes how this comment is attached
	 *               to the sheet.
	 * @return the newly created comment.
	 */
	Comment createCellComment(ClientAnchor anchor);

	/**
	 * Creates a chart.
	 * @param anchor the client anchor describes how this chart is attached to
	 *               the sheet.
	 * @return the newly created chart
	 */
	Chart createChart(ClientAnchor anchor);

	/**
	 * Creates a new client anchor and sets the top-left and bottom-right
	 * coordinates of the anchor.
	 *
	 * @param dx1  the x coordinate in EMU within the first cell.
	 * @param dy1  the y coordinate in EMU within the first cell.
	 * @param dx2  the x coordinate in EMU within the second cell.
	 * @param dy2  the y coordinate in EMU within the second cell.
	 * @param col1 the column (0 based) of the first cell.
	 * @param row1 the row (0 based) of the first cell.
	 * @param col2 the column (0 based) of the second cell.
	 * @param row2 the row (0 based) of the second cell.
	 * @return the newly created client anchor
	 */
	ClientAnchor createAnchor(int dx1, int dy1, int dx2, int dy2, int col1, int row1, int col2, int row2);
}




/* ====================================================================
   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.charts;

/**
 *  Specifies the possible crossing states of an axis.
 *
 * @author Roman Kashitsyn
 */
public enum AxisCrossBetween {
	/**
	 * Specifies the value axis shall cross the category axis
	 * between data markers.
	 */
	BETWEEN,
	/**
	 * Specifies the value axis shall cross the category axis at
	 * the midpoint of a category.
	 */
	MIDPOINT_CATEGORY
}




/* ====================================================================
   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.charts;

/**
 * Specifies the possible crossing points for an axis.
 *
 * @author Roman Kashitsyn
 */
public enum AxisCrosses {
	/**
	 * The category axis crosses at the zero point of the value axis (if
	 * possible), or the minimum value (if the minimum is greater than zero) or
	 * the maximum (if the maximum is less than zero).
	 */
	AUTO_ZERO,
	/**
	 * The axis crosses at the maximum value.
	 */
	MIN,
	/**
	 * Axis crosses at the minimum value of the chart.
	 */
	MAX
}




/* ====================================================================
   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.charts;

/**
 * Specifies the possible ways to place a picture on a data point, series, wall, or floor.
 *
 * @author Roman Kashitsyn
 */
public enum AxisOrientation {
	/**
	 * Specifies that the values on the axis shall be reversed
	 * so they go from maximum to minimum.
	 */
	MAX_MIN,
	/**
	 * Specifies that the axis values shall be in the usual
	 * order, minimum to maximum.
	 */
	MIN_MAX
}




/* ====================================================================
   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.charts;

/**
 * Enumeration of all possible axis positions.
 *
 * @author Roman Kashitsyn
 */
public enum AxisPosition {
	BOTTOM,
	LEFT,
	RIGHT,
	TOP
}




/* ====================================================================
   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.charts;

/**
 * High level representation of chart axis.
 *
 * @author Roman Kashitsyn
 */
public interface ChartAxis {
	
	/**
	 * @return axis id
	 */
	long getId();

	/**
	 * @return axis position
	 */
	AxisPosition getPosition();

	/**
	 * @param position new axis position
	 */
	void setPosition(AxisPosition position);

	/**
	 * @return axis number format
	 */
	String getNumberFormat();

	/**
	 * @param format axis number format
	 */
	void setNumberFormat(String format);

	/**
	 * @return true if log base is defined, false otherwise
	 */
	boolean isSetLogBase();

	/**
	 * @param logBase a number between 2 and 1000 (inclusive)
	 * @throws IllegalArgumentException if log base not within allowed range
	 */
	void setLogBase(double logBase);

	/**
	 * @return axis log base or 0.0 if not set
	 */
	double getLogBase();

	/**
	 * @return true if minimum value is defined, false otherwise
	 */
	boolean isSetMinimum();

	/**
	 * @return axis minimum or 0.0 if not set
	 */
	double getMinimum();

	/**
	 * @param min axis minimum
	 */
	void setMinimum(double min);

	/**
	 * @return true if maximum value is defined, false otherwise
	 */
	boolean isSetMaximum();

	/**
	 * @return axis maximum or 0.0 if not set
	 */
	double getMaximum();

	/**
	 * @param max axis maximum
	 */
	void setMaximum(double max);

	/**
	 * @return axis orientation
	 */
	AxisOrientation getOrientation();

	/**
	 * @param axis orientation
	 */
	void setOrientation(AxisOrientation orientation);

	/**
	 * @param crosses axis cross type
	 */
	void setCrosses(AxisCrosses crosses);

	/**
	 * @return axis cross type
	 */
	AxisCrosses getCrosses();

	/**
	 * Declare this axis cross another axis.
	 * @param axis that this axis should cross
	 */
	void crossAxis(ChartAxis axis);
}




/* ====================================================================
   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.charts;

import org.apache.poi.ss.usermodel.Chart;

/**
 * A factory for different chart axis.
 *
 * @author Roman Kashitsyn
 */
public interface ChartAxisFactory {
	
	/**
	 * @return new value axis
	 */
	ValueAxis createValueAxis(AxisPosition pos);

}




/* ====================================================================
   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.charts;

import org.apache.poi.ss.usermodel.Chart;

/**
 * A base for all chart data types.
 *
 * @author Roman Kashitsyn
 */
public interface ChartData {

	/**
	 * Fills a chart with data specified by implementation.
	 *
	 * @param chart a chart to fill in
	 * @param axis chart axis to use
	 */
	void fillChart(Chart chart, ChartAxis... axis);
}




/* ====================================================================
   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.charts;

/**
 * A factory for different chart data types.
 *
 * @author Roman Kashitsyn
 */
public interface ChartDataFactory {
	
	/**
	 * @return an appropriate ScatterChartData instance
	 */
	ScatterChartData createScatterChartData();

}




/* ====================================================================
   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.charts;

/**
 * High level representation of chart legend.
 *
 * @author Roman Kashitsyn
 */
public interface ChartLegend {
	
	/**
	 * @return legend position
	 */
	LegendPosition getPosition();

	/**
	 * @param position new legend position
	 */
	void setPosition(LegendPosition position);

}




/* ====================================================================
   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.charts;

/**
 * Enumeration of all possible chart legend positions.
 *
 * @author Roman Kashitsyn
 */
public enum LegendPosition {
	BOTTOM,
	LEFT,
	RIGHT,
	TOP,
	TOP_RIGHT
}




/* ====================================================================
   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.charts;

import java.util.List;

/**
 * @author Roman Kashitsyn
 */
public interface ScatterChartData extends ChartData {
	/**
	 * @return a new scatter chart serie
	 */
	ScatterChartSerie addSerie();

	/**
	 * @return list of all series
	 */
	List<? extends ScatterChartSerie> getSeries();
}




/* ====================================================================
   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.charts;

import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.usermodel.charts.ChartDataFactory;

/**
 * @author Roman Kashitsyn
 */
public interface ScatterChartSerie {

	/**
	 * @param sheet a sheet to take range from
	 * @param address a column or a row with values
	 */
	void setXValues(Sheet sheet, CellRangeAddress address);
	
	/**'
	 * @param sheet a sheet to take range from
	 * @param address a column or a row with values
	 */
	void setYValues(Sheet sheet, CellRangeAddress address);

}




/* ====================================================================
   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.charts;

/**
 * @author Roman Kashitsyn
 */
public interface ValueAxis extends ChartAxis {

	/**
	 * @return cross between type
	 */
	AxisCrossBetween getCrossBetween();

	/**
	 * @param crossBetween cross between type
	 */
	void setCrossBetween(AxisCrossBetween crossBetween);
}

Lines 80-89 public class CellRangeAddress extends CellRangeAddressBase { Link Here

(-)a/src/java/org/apache/poi/ss/util/CellRangeAddress.java (-2 / +16 lines)
80	* like single cell references (e.g. 'A1' instead of 'A1:A1').	80	* like single cell references (e.g. 'A1' instead of 'A1:A1').
81	*/	81	*/
82	public String formatAsString() {	82	public String formatAsString() {
		83	return formatAsString(null, false);
		84	}
		85
		86	/**
		87	* @return the text format of this range using specified sheet name.
		88	*/
		89	public String formatAsString(String sheetName, boolean useAbsoluteAddress) {
83	StringBuffer sb = new StringBuffer();	90	StringBuffer sb = new StringBuffer();
84	CellReference cellRefFrom = new CellReference(getFirstRow(), getFirstColumn());	91	if (sheetName != null) {
85	CellReference cellRefTo = new CellReference(getLastRow(), getLastColumn());	92	sb.append(sheetName);
		93	sb.append("!");
		94	}
		95	CellReference cellRefFrom = new CellReference(getFirstRow(), getFirstColumn(),
		96	useAbsoluteAddress, useAbsoluteAddress);
		97	CellReference cellRefTo = new CellReference(getLastRow(), getLastColumn(),
		98	useAbsoluteAddress, useAbsoluteAddress);
86	sb.append(cellRefFrom.formatAsString());	99	sb.append(cellRefFrom.formatAsString());
		100
87	//for a single-cell reference return A1 instead of A1:A1	101	//for a single-cell reference return A1 instead of A1:A1
88	if(!cellRefFrom.equals(cellRefTo)){	102	if(!cellRefFrom.equals(cellRefTo)){
89	sb.append(':');	103	sb.append(':');

Lines 21-31 import java.io.IOException; Link Here

(-)a/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFChart.java (-103 / +266 lines)
21	import java.io.OutputStream;	21	import java.io.OutputStream;
22	import java.util.HashMap;	22	import java.util.HashMap;
23	import java.util.Map;	23	import java.util.Map;
		24	import java.util.List;
		25	import java.util.ArrayList;
		26
		27	import javax.xml.namespace.QName;
24		28
25	import org.apache.poi.POIXMLDocumentPart;	29	import org.apache.poi.POIXMLDocumentPart;
26	import org.apache.poi.openxml4j.opc.PackagePart;	30	import org.apache.poi.openxml4j.opc.PackagePart;
27	import org.apache.poi.openxml4j.opc.PackageRelationship;	31	import org.apache.poi.openxml4j.opc.PackageRelationship;
28	import org.apache.poi.util.Internal;	32	import org.apache.poi.util.Internal;
		33	import org.apache.poi.ss.usermodel.Chart;
		34	import org.apache.poi.ss.usermodel.charts.ChartAxis;
		35	import org.apache.poi.ss.usermodel.charts.ChartAxisFactory;
		36	import org.apache.poi.xssf.usermodel.charts.XSSFChartDataFactory;
		37	import org.apache.poi.xssf.usermodel.charts.XSSFChartAxis;
		38	import org.apache.poi.xssf.usermodel.charts.XSSFValueAxis;
		39	import org.apache.poi.xssf.usermodel.charts.XSSFChartLegend;
		40	import org.apache.poi.ss.usermodel.charts.ChartData;
		41	import org.apache.poi.ss.usermodel.charts.AxisPosition;
29	import org.apache.xmlbeans.XmlException;	42	import org.apache.xmlbeans.XmlException;
30	import org.apache.xmlbeans.XmlObject;	43	import org.apache.xmlbeans.XmlObject;
31	import org.apache.xmlbeans.XmlOptions;	44	import org.apache.xmlbeans.XmlOptions;
Lines 33-147 import org.openxmlformats.schemas.drawingml.x2006.chart.CTChart; Link Here
33	import org.openxmlformats.schemas.drawingml.x2006.chart.CTChartSpace;	46	import org.openxmlformats.schemas.drawingml.x2006.chart.CTChartSpace;
34	import org.openxmlformats.schemas.drawingml.x2006.chart.CTTitle;	47	import org.openxmlformats.schemas.drawingml.x2006.chart.CTTitle;
35	import org.openxmlformats.schemas.drawingml.x2006.chart.ChartSpaceDocument;	48	import org.openxmlformats.schemas.drawingml.x2006.chart.ChartSpaceDocument;
		49	import org.openxmlformats.schemas.drawingml.x2006.chart.CTLayout;
		50	import org.openxmlformats.schemas.drawingml.x2006.chart.CTManualLayout;
		51	import org.openxmlformats.schemas.drawingml.x2006.chart.CTPlotArea;
		52	import org.openxmlformats.schemas.drawingml.x2006.chart.CTPrintSettings;
		53	import org.openxmlformats.schemas.drawingml.x2006.chart.CTPageMargins;
		54	import org.openxmlformats.schemas.drawingml.x2006.chart.STLayoutTarget;
		55	import org.openxmlformats.schemas.drawingml.x2006.chart.STLayoutMode;
36	import org.openxmlformats.schemas.officeDocument.x2006.relationships.STRelationshipId;	56	import org.openxmlformats.schemas.officeDocument.x2006.relationships.STRelationshipId;
37	import org.w3c.dom.NodeList;	57	import org.w3c.dom.NodeList;
38	import org.w3c.dom.Text;	58	import org.w3c.dom.Text;
39		59
40	/**	60	/**
41	* Represents a SpreadsheetML Chart	61	* Represents a SpreadsheetML Chart
		62	* @author Nick Burch
		63	* @author Roman Kashitsyn
42	*/	64	*/
43	public final class XSSFChart extends POIXMLDocumentPart {	65	public final class XSSFChart extends POIXMLDocumentPart implements Chart, ChartAxisFactory {
44	/**	66
45	* Root element of the SpreadsheetML Chart part	67	/**
46	*/	68	* Parent graphic frame.
47	private CTChartSpace chartSpace;	69	*/
48	/**	70	private XSSFGraphicFrame frame;
49	* The Chart within that	71
50	*/	72	/**
51	private CTChart chart;	73	* Root element of the SpreadsheetML Chart part
52		74	*/
53	/**	75	private CTChartSpace chartSpace;
54	* Create a new SpreadsheetML chart	76	/**
55	*/	77	* The Chart within that
56	protected XSSFChart() {	78	*/
57	super();	79	private CTChart chart;
58	createChart();	80
59	}	81	List<XSSFChartAxis> axis;
60		82
61	/**	83	/**
62	* Construct a SpreadsheetML chart from a package part	84	* Create a new SpreadsheetML chart
63	*	85	*/
64	* @param part the package part holding the chart data,	86	protected XSSFChart() {
65	* the content type must be <code>application/vnd.openxmlformats-officedocument.drawingml.chart+xml</code>	87	super();
66	* @param rel the package relationship holding this chart,	88	axis = new ArrayList<XSSFChartAxis>();
67	* the relationship type must be http://schemas.openxmlformats.org/officeDocument/2006/relationships/chart	89	createChart();
68	*/	90	}
69	protected XSSFChart(PackagePart part, PackageRelationship rel) throws IOException, XmlException {	91
70	super(part, rel);	92	/**
71		93	* Construct a SpreadsheetML chart from a package part
72	chartSpace = ChartSpaceDocument.Factory.parse(part.getInputStream()).getChartSpace();	94	*
73	chart = chartSpace.getChart();	95	* @param part the package part holding the chart data,
74	}	96	* the content type must be <code>application/vnd.openxmlformats-officedocument.drawingml.chart+xml</code>
75		97	* @param rel the package relationship holding this chart,
76	/**	98	* the relationship type must be http://schemas.openxmlformats.org/officeDocument/2006/relationships/chart
77	* Construct a new CTChartSpace bean. By default, it's just an empty placeholder for chart objects	99	*/
78	*	100	protected XSSFChart(PackagePart part, PackageRelationship rel) throws IOException, XmlException {
79	* @return a new CTChartSpace bean	101	super(part, rel);
80	*/	102
81	private void createChart() {	103	chartSpace = ChartSpaceDocument.Factory.parse(part.getInputStream()).getChartSpace();
82	chartSpace = CTChartSpace.Factory.newInstance();	104	chart = chartSpace.getChart();
83	chart = chartSpace.addNewChart();	105	}
84	}	106
85		107	/**
86	/**	108	* Construct a new CTChartSpace bean. By default, it's just an empty placeholder for chart objects
87	* Return the underlying CTChartSpace bean, the root element of the SpreadsheetML Chart part.	109	*
88	*	110	* @return a new CTChartSpace bean
89	* @return the underlying CTChartSpace bean	111	*/
90	*/	112	private void createChart() {
91	@Internal	113	chartSpace = CTChartSpace.Factory.newInstance();
92	public CTChartSpace getCTChartSpace(){	114	chart = chartSpace.addNewChart();
93	return chartSpace;	115	CTPlotArea plotArea = chart.addNewPlotArea();
94	}	116	CTLayout layout = plotArea.addNewLayout();
95		117	CTManualLayout manualLayout = layout.addNewManualLayout();
96	/**	118	manualLayout.addNewLayoutTarget().setVal(STLayoutTarget.INNER);
97	* Return the underlying CTChart bean, within the Chart Space	119	manualLayout.addNewXMode().setVal(STLayoutMode.EDGE);
98	*	120	manualLayout.addNewYMode().setVal(STLayoutMode.EDGE);
99	* @return the underlying CTChart bean	121	manualLayout.addNewX().setVal(0);
100	*/	122	manualLayout.addNewY().setVal(0);
101	@Internal	123	manualLayout.addNewW().setVal(0.65);
102	public CTChart getCTChart(){	124	manualLayout.addNewH().setVal(0.8);
103	return chart;	125	chart.addNewPlotVisOnly().setVal(true);
104	}	126	CTPrintSettings printSettings = chartSpace.addNewPrintSettings();
105		127	printSettings.addNewHeaderFooter();
106	@Override	128
107	protected void commit() throws IOException {	129	CTPageMargins pageMargins = printSettings.addNewPageMargins();
108	XmlOptions xmlOptions = new XmlOptions(DEFAULT_XML_OPTIONS);	130	pageMargins.setB(0.75);
109		131	pageMargins.setL(0.70);
110	Map<String, String> map = new HashMap<String, String>();	132	pageMargins.setR(0.70);
111	map.put(XSSFDrawing.NAMESPACE_A, "a");	133	pageMargins.setT(0.75);
112	map.put(STRelationshipId.type.getName().getNamespaceURI(), "r");	134	pageMargins.setHeader(0.30);
113	xmlOptions.setSaveSuggestedPrefixes(map);	135	pageMargins.setFooter(0.30);
114		136	printSettings.addNewPageSetup();
115	PackagePart part = getPackagePart();	137	}
116	OutputStream out = part.getOutputStream();	138
117	chartSpace.save(out, xmlOptions);	139	/**
118	out.close();	140	* Return the underlying CTChartSpace bean, the root element of the SpreadsheetML Chart part.
119	}	141	*
120		142	* @return the underlying CTChartSpace bean
121	/**	143	*/
122	* Returns the title, or null if none is set	144	@Internal
123	*/	145	public CTChartSpace getCTChartSpace(){
124	public XSSFRichTextString getTitle() {	146	return chartSpace;
125	if(! chart.isSetTitle()) {	147	}
126	return null;	148
127	}	149	/**
128		150	* Return the underlying CTChart bean, within the Chart Space
129	// TODO Do properly	151	*
130	CTTitle title = chart.getTitle();	152	* @return the underlying CTChart bean
131		153	*/
132	StringBuffer text = new StringBuffer();	154	@Internal
133	XmlObject[] t = title	155	public CTChart getCTChart(){
134	.selectPath("declare namespace a='"+XSSFDrawing.NAMESPACE_A+"' .//a:t");	156	return chart;
135	for (int m = 0; m < t.length; m++) {	157	}
136	NodeList kids = t[m].getDomNode().getChildNodes();	158
137	for (int n = 0; n < kids.getLength(); n++) {	159	@Override
138	if (kids.item(n) instanceof Text) {	160	protected void commit() throws IOException {
139	text.append(kids.item(n).getNodeValue());	161	XmlOptions xmlOptions = new XmlOptions(DEFAULT_XML_OPTIONS);
140	}	162
141	}	163	/*
142	}	164	Saved chart space must have the following namespaces set:
143		165	<c:chartSpace
144	return new XSSFRichTextString(text.toString());	166	xmlns:c="http://schemas.openxmlformats.org/drawingml/2006/chart"
145	}	167	xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main"
		168	xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
		169	*/
		170	xmlOptions.setSaveSyntheticDocumentElement(new QName(CTChartSpace.type.getName().getNamespaceURI(), "chartSpace", "c"));
		171	Map<String, String> map = new HashMap<String, String>();
		172	map.put(XSSFDrawing.NAMESPACE_A, "a");
		173	map.put(XSSFDrawing.NAMESPACE_C, "c");
		174	map.put(STRelationshipId.type.getName().getNamespaceURI(), "r");
		175	xmlOptions.setSaveSuggestedPrefixes(map);
		176
		177	PackagePart part = getPackagePart();
		178	OutputStream out = part.getOutputStream();
		179	chartSpace.save(out, xmlOptions);
		180	out.close();
		181	}
		182
		183	/**
		184	* Returns the parent graphic frame.
		185	* @return the graphic frame this chart belongs to
		186	*/
		187	public XSSFGraphicFrame getGraphicFrame() {
		188	return frame;
		189	}
		190
		191	/**
		192	* Sets the parent graphic frame.
		193	*/
		194	protected void setGraphicFrame(XSSFGraphicFrame frame) {
		195	this.frame = frame;
		196	}
		197
		198	public XSSFChartDataFactory getChartDataFactory() {
		199	return XSSFChartDataFactory.getInstance();
		200	}
		201
		202	public XSSFChart getChartAxisFactory() {
		203	return this;
		204	}
		205
		206	public void plot(ChartData data, ChartAxis... axis) {
		207	data.fillChart(this, axis);
		208	}
		209
		210	public XSSFValueAxis createValueAxis(AxisPosition pos) {
		211	long id = axis.size() + 1;
		212	XSSFValueAxis valueAxis = new XSSFValueAxis(this, id, pos);
		213	if (axis.size() == 1) {
		214	ChartAxis ax = axis.get(0);
		215	ax.crossAxis(valueAxis);
		216	valueAxis.crossAxis(ax);
		217	}
		218	axis.add(valueAxis);
		219	return valueAxis;
		220	}
		221
		222	public List<? extends XSSFChartAxis> getAxis() {
		223	return axis;
		224	}
		225
		226	/**
		227	* Sets the width ratio of the chart.
		228	* Chart width is ratio multiplied by parent frame width.
		229	* @param ratio a number between 0 and 1.
		230	*/
		231	public void setWidthRatio(double ratio) {
232	chart.getPlotArea().getLayout().getManualLayout().getW().setVal(ratio);
233	}
234
235	/**
236	* @return relative chart width
237	*/
238	public double getWidthRatio() {
239	return chart.getPlotArea().getLayout().getManualLayout().getW().getVal();
240	}
241
242	/**
243	* Sets the height ratio of the chart.
244	* Chart height is ratio multiplied by parent frame height.
245	* @param ratio a number between 0 and 1.
246	*/
247	public void setHeightRatio(double ratio) {
248	chart.getPlotArea().getLayout().getManualLayout().getH().setVal(ratio);
249	}
250
251	/**
252	* @return relative chart height
253	*/
254	public double getHeightRatio() {
255	return chart.getPlotArea().getLayout().getManualLayout().getH().getVal();
256	}
257
258	/**
259	* @return true if only visible cells will be present on the chart,
260	* false otherwise
261	*/
262	public boolean isPlotOnlyVisibleCells() {
263	return chart.getPlotVisOnly().getVal();
264	}
265
266	/**
267	* @param plotVisOnly a flag specifying if only visible cells should be
268	* present on the chart
269	*/
270	public void setPlotOnlyVisibleCells(boolean plotVisOnly) {
271	chart.getPlotVisOnly().setVal(plotVisOnly);
272	}
273
274	/**
275	* Returns the title, or null if none is set
276	*/
277	public XSSFRichTextString getTitle() {
278	if(! chart.isSetTitle()) {
279	return null;
280	}
281
282	// TODO Do properly
283	CTTitle title = chart.getTitle();
284
285	StringBuffer text = new StringBuffer();
286	XmlObject[] t = title
287	.selectPath("declare namespace a='"+XSSFDrawing.NAMESPACE_A+"' .//a:t");
288	for (int m = 0; m < t.length; m++) {
289	NodeList kids = t[m].getDomNode().getChildNodes();
290	for (int n = 0; n < kids.getLength(); n++) {
291	if (kids.item(n) instanceof Text) {
292	text.append(kids.item(n).getNodeValue());
293	}
294	}
295	}
296
297	return new XSSFRichTextString(text.toString());
298	}
299
300	public XSSFChartLegend getOrCreateLegend() {
301	return new XSSFChartLegend(this);
302	}
303
304	public void deleteLegend() {
305	if (chart.isSetLegend()) {
306	chart.unsetLegend();
307	}
308	}
146		309
147	}	310	}




import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTShape;
import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTTwoCellAnchor;
import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.STEditAs;
import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTGraphicalObjectFrame;
import org.openxmlformats.schemas.officeDocument.x2006.relationships.STRelationshipId;

/**

     */
    private CTDrawing drawing;
    private boolean isNew;
    private long numOfGraphicFrames = 0L;
    
    protected static final String NAMESPACE_A = "http://schemas.openxmlformats.org/drawingml/2006/main";
    protected static final String NAMESPACE_C = "http://schemas.openxmlformats.org/drawingml/2006/chart";

    /**
     * Create a new SpreadsheetML drawing

        out.close();
    }

	public XSSFClientAnchor createAnchor(int dx1, int dy1, int dx2, int dy2,
			int col1, int row1, int col2, int row2) {
		return new XSSFClientAnchor(dx1, dy1, dx2, dy2, col1, row1, col2, row2);
	}

    /**
     * Constructs a textbox under the drawing.
     *

        return createPicture((XSSFClientAnchor)anchor, pictureIndex);
    }

	/**
	 * Creates a chart.
	 * @param anchor the client anchor describes how this chart is attached to
	 *               the sheet.
	 * @return the newly created chart
	 * @see org.apache.poi.xssf.usermodel.XSSFDrawing#createChart(ClientAnchor)
	 */
    public XSSFChart createChart(XSSFClientAnchor anchor) {
        int chartNumber = getPackagePart().getPackage().
            getPartsByContentType(XSSFRelation.CHART.getContentType()).size() + 1;

        XSSFChart chart = (XSSFChart) createRelationship(
                XSSFRelation.CHART, XSSFFactory.getInstance(), chartNumber);
        String chartRelId = chart.getPackageRelationship().getId();

        XSSFGraphicFrame frame = createGraphicFrame(anchor);
        frame.setChart(chart, chartRelId);

        return chart;
    }

	public XSSFChart createChart(ClientAnchor anchor) {
		return createChart((XSSFClientAnchor)anchor);
	}

    /**
     * Add the indexed picture to this drawing relations
     *

        return shape;
    }

	/**
	 * Creates a comment.
	 * @param anchor the client anchor describes how this comment is attached
	 *               to the sheet.
	 * @return the newly created comment.
	 */
     */
    public XSSFComment createCellComment(ClientAnchor anchor) {
        XSSFClientAnchor ca = (XSSFClientAnchor)anchor;
        XSSFSheet sheet = (XSSFSheet)getParent();

        shape.setRow(ca.getRow1());
        return shape;
    }

    /**
     * Creates a new graphic frame.
     *
     * @param anchor    the client anchor describes how this frame is attached
     *                  to the sheet
     * @return  the newly created graphic frame
     */
    private XSSFGraphicFrame createGraphicFrame(XSSFClientAnchor anchor) {
        CTTwoCellAnchor ctAnchor = createTwoCellAnchor(anchor);
        CTGraphicalObjectFrame ctGraphicFrame = ctAnchor.addNewGraphicFrame();
        ctGraphicFrame.set(XSSFGraphicFrame.prototype());

        long frameId = numOfGraphicFrames++;
        XSSFGraphicFrame graphicFrame = new XSSFGraphicFrame(this, ctGraphicFrame);
        graphicFrame.setAnchor(anchor);
        graphicFrame.setId(frameId);
        graphicFrame.setName("Diagramm" + frameId);
        return graphicFrame;
    }
    
    /**
     * Returns all charts in this drawing.




/* ====================================================================
   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 javax.xml.namespace.QName;

import org.apache.poi.openxml4j.opc.PackageRelationship;
import org.apache.poi.util.Internal;
import org.apache.xmlbeans.XmlObject;
import org.apache.xmlbeans.XmlCursor;
import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTGraphicalObjectFrame;
import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTGraphicalObjectFrameNonVisual;
import org.openxmlformats.schemas.drawingml.x2006.main.CTGraphicalObject;
import org.openxmlformats.schemas.drawingml.x2006.main.CTGraphicalObjectData;
import org.openxmlformats.schemas.drawingml.x2006.main.CTNonVisualDrawingProps;
import org.openxmlformats.schemas.drawingml.x2006.main.CTTransform2D;
import org.openxmlformats.schemas.drawingml.x2006.main.CTPoint2D;
import org.openxmlformats.schemas.drawingml.x2006.main.CTPositiveSize2D;
import org.openxmlformats.schemas.officeDocument.x2006.relationships.STRelationshipId;

/**
 * Represents DrawingML GraphicalObjectFrame.
 *
 * @author Roman Kashitsyn
 */
public final class XSSFGraphicFrame {

	private static CTGraphicalObjectFrame prototype = null;

	private CTGraphicalObjectFrame graphicFrame;
	private XSSFDrawing drawing;
	private XSSFClientAnchor anchor;

	/**
	 * Construct a new XSSFGraphicFrame object.
	 *
	 * @param drawing the XSSFDrawing that owns this frame
	 * @param ctGraphicFrame the XML bean that stores this frame content
	 */
	protected XSSFGraphicFrame(XSSFDrawing drawing, CTGraphicalObjectFrame ctGraphicFrame) {
		this.drawing = drawing;
		this.graphicFrame = ctGraphicFrame;
	}

	@Internal
	public CTGraphicalObjectFrame getCTGraphicalObjectFrame() {
		return graphicFrame;
	}

	/**
	 * Initialize default structure of a new graphic frame
	 */
	protected static CTGraphicalObjectFrame prototype() {
		if (prototype == null) {
			CTGraphicalObjectFrame graphicFrame = CTGraphicalObjectFrame.Factory.newInstance();

			CTGraphicalObjectFrameNonVisual nvGraphic = graphicFrame.addNewNvGraphicFramePr();
			CTNonVisualDrawingProps props = nvGraphic.addNewCNvPr();
			props.setId(0);
			props.setName("Diagramm 1");
			nvGraphic.addNewCNvGraphicFramePr();

			CTTransform2D transform = graphicFrame.addNewXfrm();
			CTPositiveSize2D extPoint = transform.addNewExt();
			CTPoint2D offPoint = transform.addNewOff();

			extPoint.setCx(0);
			extPoint.setCy(0);
			offPoint.setX(0);
			offPoint.setY(0);

			CTGraphicalObject graphic = graphicFrame.addNewGraphic();

			prototype = graphicFrame;
		}
		return prototype;
	}

	/**
	 * Sets the frame macro.
	 */
	public void setMacro(String macro) {
		graphicFrame.setMacro(macro);
	}

	/**
	 * Sets the frame name.
	 */
	public void setName(String name) {
		getNonVisualProperties().setName(name);
	}

	/**
	 * Returns the frame name.
	 * @return name of the frame
	 */
	public String getName() {
		return getNonVisualProperties().getName();
	}

	private CTNonVisualDrawingProps getNonVisualProperties() {
		CTGraphicalObjectFrameNonVisual nvGraphic = graphicFrame.getNvGraphicFramePr();
		return nvGraphic.getCNvPr();
	}

	/**
	 * Attaches frame to an anchor.
	 */
	protected void setAnchor(XSSFClientAnchor anchor) {
		this.anchor = anchor;
	}

	/**
	 * Returns the frame anchor.
	 * @return the anchor this frame is attached to
	 */
	public XSSFClientAnchor getAnchor() {
		return anchor;
	}

	/**
	 * Assign a DrawingML chart to the graphic frame.
	 */
	protected void setChart(XSSFChart chart, String relId) {
		CTGraphicalObjectData data = graphicFrame.getGraphic().addNewGraphicData();
		appendChartElement(data, relId);
		chart.setGraphicFrame(this);
		return;
	}

	/**
	 * Gets the frame id.
	 */
	public long getId() {
		return graphicFrame.getNvGraphicFramePr().getCNvPr().getId();
	}

	/**
	 * Sets the frame id.
	 */
	protected void setId(long id) {
		graphicFrame.getNvGraphicFramePr().getCNvPr().setId(id);
	}

	/**
	 * The low level code to insert {@code <c:chart>} tag into
	 * {@code<a:graphicData>}.
	 *
	 * Here is the schema (ECMA-376):
	 * <pre>
	 * {@code
	 * <complexType name="CT_GraphicalObjectData">
	 *   <sequence>
	 *     <any minOccurs="0" maxOccurs="unbounded" processContents="strict"/>
	 *   </sequence>
	 *   <attribute name="uri" type="xsd:token"/>
	 * </complexType>
	 * }
	 * </pre>
	 */
	private void appendChartElement(CTGraphicalObjectData data, String id) {
		String r_namespaceUri = STRelationshipId.type.getName().getNamespaceURI();
		String c_namespaceUri = XSSFDrawing.NAMESPACE_C;
		XmlCursor cursor = data.newCursor();
		cursor.toNextToken();
		cursor.beginElement(new QName(c_namespaceUri, "chart", "c"));
		cursor.insertAttributeWithValue(new QName(r_namespaceUri, "id", "r"), id);
		cursor.dispose();
		data.setUri(c_namespaceUri);
	}

}




			"/xl/worksheets/sheet#.xml",
			XSSFSheet.class
	);
	public static final XSSFRelation CHARTSHEET = new XSSFRelation(
			"application/vnd.openxmlformats-officedocument.spreadsheetml.chartsheet+xml",
			"http://schemas.openxmlformats.org/officeDocument/2006/relationships/chartsheet",
			"/xl/chartsheets/sheet#.xml",
			XSSFChartSheet.class
	);
	public static final XSSFRelation SHARED_STRINGS = new XSSFRelation(
			"application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml",
			"http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings",




/* ====================================================================
   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.charts;

import org.apache.poi.ss.usermodel.charts.ChartAxis;
import org.apache.poi.ss.usermodel.charts.AxisPosition;
import org.apache.poi.ss.usermodel.charts.AxisOrientation;
import org.apache.poi.ss.usermodel.charts.AxisCrosses;
import org.apache.poi.xssf.usermodel.XSSFChart;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTChart;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTAxPos;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumFmt;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTCrosses;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTOrientation;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTLogBase;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTScaling;
import org.openxmlformats.schemas.drawingml.x2006.chart.STOrientation;
import org.openxmlformats.schemas.drawingml.x2006.chart.STAxPos;
import org.openxmlformats.schemas.drawingml.x2006.chart.STCrosses;

/**
 * Base class for all axis types.
 *
 * @author Roman Kashitsyn
 */
public abstract class XSSFChartAxis implements ChartAxis {

	protected XSSFChart chart;

	private static final double MIN_LOG_BASE = 2.0;
	private static final double MAX_LOG_BASE = 1000.0;

	protected XSSFChartAxis(XSSFChart chart) {
		this.chart = chart;
	}

	public AxisPosition getPosition() {
		return toAxisPosition(getCTAxPos());
	}

	public void setPosition(AxisPosition position) {
		getCTAxPos().setVal(fromAxisPosition(position));
	}

	public void setNumberFormat(String format) {
		getCTNumFmt().setFormatCode(format);
		getCTNumFmt().setSourceLinked(true);
	}

	public String getNumberFormat() {
		return getCTNumFmt().getFormatCode();
	}

	public boolean isSetLogBase() {
		return getCTScaling().isSetLogBase();
	}

	public void setLogBase(double logBase) {
		if (logBase < MIN_LOG_BASE ||
			MAX_LOG_BASE < logBase) {
			throw new IllegalArgumentException("Axis log base must be between 2 and 1000 (inclusive), got: " + logBase);
		}
		CTScaling scaling = getCTScaling();
		if (scaling.isSetLogBase()) {
			scaling.getLogBase().setVal(logBase);
		} else {
			scaling.addNewLogBase().setVal(logBase);
		}
	}

	public double getLogBase() {
		CTLogBase logBase = getCTScaling().getLogBase();
		if (logBase != null) {
			return logBase.getVal();
		}
		return 0.0;
	}

	public boolean isSetMinimum() {
		return getCTScaling().isSetMin();
	}

	public void setMinimum(double min) {
		CTScaling scaling = getCTScaling();
		if (scaling.isSetMin()) {
			scaling.getMin().setVal(min);
		} else {
			scaling.addNewMin().setVal(min);
		}
	}

	public double getMinimum() {
		CTScaling scaling = getCTScaling();
		if (scaling.isSetMin()) {
			return scaling.getMin().getVal();
		} else {
			return 0.0;
		}
	}

	public boolean isSetMaximum() {
		return getCTScaling().isSetMax();
	}

	public void setMaximum(double max) {
		CTScaling scaling = getCTScaling();
		if (scaling.isSetMax()) {
			scaling.getMax().setVal(max);
		} else {
			scaling.addNewMax().setVal(max);
		}
	}

	public double getMaximum() {
		CTScaling scaling = getCTScaling();
		if (scaling.isSetMax()) {
			return scaling.getMax().getVal();
		} else {
			return 0.0;
		}
	}

	public AxisOrientation getOrientation() {
		return toAxisOrientation(getCTScaling().getOrientation());
	}

	public void setOrientation(AxisOrientation orientation) {
		CTScaling scaling = getCTScaling();
		STOrientation.Enum stOrientation = fromAxisOrientation(orientation);
		if (scaling.isSetOrientation()) {
			scaling.getOrientation().setVal(stOrientation);
		} else {
			getCTScaling().addNewOrientation().setVal(stOrientation);
		}
	}

	public AxisCrosses getCrosses() {
		return toAxisCrosses(getCTCrosses());
	}

	public void setCrosses(AxisCrosses crosses) {
		getCTCrosses().setVal(fromAxisCrosses(crosses));
	}

	protected abstract CTAxPos getCTAxPos();
	protected abstract CTNumFmt getCTNumFmt();
	protected abstract CTScaling getCTScaling();
	protected abstract CTCrosses getCTCrosses();

	private static STOrientation.Enum fromAxisOrientation(AxisOrientation orientation) {
		switch (orientation) {
			case MIN_MAX: return STOrientation.MIN_MAX;
			case MAX_MIN: return STOrientation.MAX_MIN;
			default:
				throw new IllegalArgumentException();
		}
	}

	private static AxisOrientation toAxisOrientation(CTOrientation ctOrientation) {
		switch (ctOrientation.getVal().intValue()) {
			case STOrientation.INT_MIN_MAX: return AxisOrientation.MIN_MAX;
			case STOrientation.INT_MAX_MIN: return AxisOrientation.MAX_MIN;
			default:
				throw new IllegalArgumentException();
		}
	}

	private static STCrosses.Enum fromAxisCrosses(AxisCrosses crosses) {
		switch (crosses) {
			case AUTO_ZERO: return STCrosses.AUTO_ZERO;
			case MIN: return STCrosses.MIN;
			case MAX: return STCrosses.MAX;
			default:
				throw new IllegalArgumentException();
		}
	}

	private static AxisCrosses toAxisCrosses(CTCrosses ctCrosses) {
		switch (ctCrosses.getVal().intValue()) {
			case STCrosses.INT_AUTO_ZERO: return AxisCrosses.AUTO_ZERO;
			case STCrosses.INT_MAX: return AxisCrosses.MAX;
			case STCrosses.INT_MIN: return AxisCrosses.MIN;
			default:
				throw new IllegalArgumentException();
		}
	}

	private static STAxPos.Enum fromAxisPosition(AxisPosition position) {
		switch (position) {
			case BOTTOM: return STAxPos.B;
			case LEFT: return STAxPos.L;
			case RIGHT: return STAxPos.R;
			case TOP: return STAxPos.T;
			default:
				throw new IllegalArgumentException();
		}
	}

	private static AxisPosition toAxisPosition(CTAxPos ctAxPos) {
		switch (ctAxPos.getVal().intValue()) {
			case STAxPos.INT_B: return AxisPosition.BOTTOM;
			case STAxPos.INT_L: return AxisPosition.LEFT;
			case STAxPos.INT_R: return AxisPosition.RIGHT;
			case STAxPos.INT_T: return AxisPosition.TOP;
			default: return AxisPosition.BOTTOM;
		}
	}
}




/* ====================================================================
   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.charts;

import org.apache.poi.ss.usermodel.charts.*;

/**
 * @author Roman Kashitsyn
 */
public class XSSFChartDataFactory implements ChartDataFactory {

	private static XSSFChartDataFactory instance;

	private XSSFChartDataFactory() {
		super();
	}

	/**
	 * @return new scatter chart data instance
	 */
	public XSSFScatterChartData createScatterChartData() {
		return new XSSFScatterChartData();
	}

	/**
	 * @return factory instance
	 */
	public static XSSFChartDataFactory getInstance() {
		if (instance == null) {
			instance = new XSSFChartDataFactory();
		}
		return instance;
	}

}




/* ====================================================================
   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.charts;

import org.apache.poi.util.Internal;
import org.apache.poi.ss.usermodel.charts.ChartLegend;
import org.apache.poi.ss.usermodel.charts.LegendPosition;
import org.apache.poi.xssf.usermodel.XSSFChart;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTChart;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTLegend;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTLegendPos;
import org.openxmlformats.schemas.drawingml.x2006.chart.STLegendPos;

/**
 * Represents a SpreadsheetML chart legend
 * @author Roman Kashitsyn
 */
public final class XSSFChartLegend implements ChartLegend {

	/**
	 * Underlaying CTLagend bean
	 */
	private CTLegend legend;

	/**
	 * Create a new SpreadsheetML chart legend
	 */
	public XSSFChartLegend(XSSFChart chart) {
		CTChart ctChart = chart.getCTChart();
		this.legend = (ctChart.isSetLegend()) ?
			ctChart.getLegend() :
			ctChart.addNewLegend();
	}

	/**
	 * Return the underlying CTLegend bean.
	 *
	 * @return the underlying CTLegend bean
	 */
	@Internal
	public CTLegend getCTLegend(){
		return legend;
	}

	public void setPosition(LegendPosition position) {
		if (!legend.isSetLegendPos()) {
			legend.addNewLegendPos();
		}
		legend.getLegendPos().setVal(fromLegendPosition(position));
	}

	/*
	 * According to ECMA-376 default position is RIGHT.
	 */
	public LegendPosition getPosition() {
		if (legend.isSetLegendPos()) {
			return toLegendPosition(legend.getLegendPos());
		} else {
			return LegendPosition.RIGHT;
		}
	}

	private STLegendPos.Enum fromLegendPosition(LegendPosition position) {
		switch (position) {
			case BOTTOM: return STLegendPos.B;
			case LEFT: return STLegendPos.L;
			case RIGHT: return STLegendPos.R;
			case TOP: return STLegendPos.T;
			case TOP_RIGHT: return STLegendPos.TR;
			default:
				throw new IllegalArgumentException();
		}
	}

	private LegendPosition toLegendPosition(CTLegendPos ctLegendPos) {
		switch (ctLegendPos.getVal().intValue()) {
			case STLegendPos.INT_B: return LegendPosition.BOTTOM;
			case STLegendPos.INT_L: return LegendPosition.LEFT;
			case STLegendPos.INT_R: return LegendPosition.RIGHT;
			case STLegendPos.INT_T: return LegendPosition.TOP;
			case STLegendPos.INT_TR: return LegendPosition.TOP_RIGHT;
			default:
				throw new IllegalArgumentException();
		}
	}
}




/* ====================================================================
   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.charts;

import java.util.List;
import java.util.ArrayList;

import org.apache.poi.ss.usermodel.Chart;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.usermodel.charts.ScatterChartData;
import org.apache.poi.ss.usermodel.charts.ScatterChartSerie;
import org.apache.poi.ss.usermodel.charts.ChartDataFactory;
import org.apache.poi.ss.usermodel.charts.ChartAxis;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTPlotArea;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTScatterChart;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTScatterStyle;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTScatterSer;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTAxDataSource;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumRef;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumDataSource;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumFmt;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTValAx;
import org.openxmlformats.schemas.drawingml.x2006.chart.STScatterStyle;
import org.openxmlformats.schemas.drawingml.x2006.chart.STCrosses;
import org.openxmlformats.schemas.drawingml.x2006.chart.STCrossBetween;
import org.openxmlformats.schemas.drawingml.x2006.chart.STOrientation;
import org.openxmlformats.schemas.drawingml.x2006.chart.STTickLblPos;
import org.openxmlformats.schemas.drawingml.x2006.chart.STAxPos;

import org.apache.poi.xssf.usermodel.XSSFChart;

/**
 * Represents DrawingML scatter chart.
 *
 * @author Roman Kashitsyn
 */
public class XSSFScatterChartData implements ScatterChartData {

	/**
	 * List of all data series.
	 */
	private List<Serie> series;

	public XSSFScatterChartData() {
		series = new ArrayList<Serie>();
	}

	public static class Serie implements ScatterChartSerie {
		private int id;
		private int order;
		private boolean useCache;
		private Sheet xSheet;
		private Sheet ySheet;
		private CellRangeAddress xAddress;
		private CellRangeAddress yAddress;

		public Serie(int id, int order) {
			super();
			this.id = id;
			this.order = order;
			this.useCache = false;
		}

		public void setXValues(Sheet sheet, CellRangeAddress address) {
			this.xSheet = sheet;
			this.xAddress = address;
		}

		public void setYValues(Sheet sheet, CellRangeAddress address) {
			this.ySheet = sheet;
			this.yAddress = address;
		}

		/**
		 * @param useCache if true, cached results will be added on plot
		 */
		public void setUseCache(boolean useCache) {
			this.useCache = useCache;
		}

		protected void addToChart(CTScatterChart ctScatterChart) {
			CTScatterSer scatterSer = ctScatterChart.addNewSer();
			scatterSer.addNewIdx().setVal(this.id);
			scatterSer.addNewOrder().setVal(this.order);

			CTAxDataSource xVal = scatterSer.addNewXVal();
			CTNumRef numRef = xVal.addNewNumRef();
			numRef.setF(xAddress.formatAsString(xSheet.getSheetName(), true));

			CTNumDataSource yVal = scatterSer.addNewYVal();
			numRef = yVal.addNewNumRef();
			numRef.setF(yAddress.formatAsString(ySheet.getSheetName(), true));
		}
	}

	public XSSFScatterChartData.Serie addSerie() {
		int numOfSeries = series.size();
		Serie newSerie = new Serie(numOfSeries, numOfSeries);
		series.add(newSerie);
		return newSerie;
	}

	public void fillChart(Chart chart, ChartAxis... axis) {
		if (!(chart instanceof XSSFChart)) {
			throw new IllegalArgumentException("Chart must be instance of XSSFChart");
		}

		XSSFChart xssfChart = (XSSFChart) chart;
		CTPlotArea plotArea = xssfChart.getCTChart().getPlotArea();
		CTScatterChart scatterChart = plotArea.addNewScatterChart();
		addStyle(scatterChart);

		for (Serie s : series) {
			s.addToChart(scatterChart);
		}

		for (ChartAxis ax : axis) {
			scatterChart.addNewAxId().setVal(ax.getId());
		}
	}

	public List<? extends Serie> getSeries() {
		return series;
	}

	private void addStyle(CTScatterChart ctScatterChart) {
		CTScatterStyle scatterStyle = ctScatterChart.addNewScatterStyle();
		scatterStyle.setVal(STScatterStyle.LINE_MARKER);
	}
}




/* ====================================================================
   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.charts;

import org.apache.poi.ss.usermodel.charts.ChartAxis;
import org.apache.poi.ss.usermodel.charts.ValueAxis;
import org.apache.poi.ss.usermodel.charts.AxisPosition;
import org.apache.poi.ss.usermodel.charts.AxisOrientation;
import org.apache.poi.ss.usermodel.charts.AxisCrossBetween;
import org.apache.poi.ss.usermodel.charts.AxisCrosses;

import org.apache.poi.xssf.usermodel.XSSFChart;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTValAx;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTAxPos;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumFmt;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTCrosses;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTScaling;
import org.openxmlformats.schemas.drawingml.x2006.chart.STAxPos;
import org.openxmlformats.schemas.drawingml.x2006.chart.STCrossBetween;
import org.openxmlformats.schemas.drawingml.x2006.chart.STTickLblPos;

/**
 * Value axis type.
 *
 * @author Roman Kashitsyn
 */
public class XSSFValueAxis extends XSSFChartAxis implements ValueAxis {

	private CTValAx ctValAx;

	public XSSFValueAxis(XSSFChart chart, long id, AxisPosition pos) {
		super(chart);
		createAxis(id, pos);
	}

	public long getId() {
		return ctValAx.getAxId().getVal();
	}

	public void setCrossBetween(AxisCrossBetween crossBetween) {
		ctValAx.getCrossBetween().setVal(fromCrossBetween(crossBetween));
	}

	public AxisCrossBetween getCrossBetween() {
		return toCrossBetween(ctValAx.getCrossBetween().getVal());
	}

	@Override
	protected CTAxPos getCTAxPos() {
		return ctValAx.getAxPos();
	}

	@Override
	protected CTNumFmt getCTNumFmt() {
		if (ctValAx.isSetNumFmt()) {
			return ctValAx.getNumFmt();
		}
		return ctValAx.addNewNumFmt();
	}

	@Override
	protected CTScaling getCTScaling() {
		return ctValAx.getScaling();
	}

	@Override
	protected CTCrosses getCTCrosses() {
		return ctValAx.getCrosses();
	}

	public void crossAxis(ChartAxis axis) {
		ctValAx.getCrossAx().setVal(axis.getId());
	}

	private void createAxis(long id, AxisPosition pos) {
		ctValAx = chart.getCTChart().getPlotArea().addNewValAx();
		ctValAx.addNewAxId().setVal(id);
		ctValAx.addNewAxPos();
		ctValAx.addNewScaling();
		ctValAx.addNewCrossBetween();
		ctValAx.addNewCrosses();
		ctValAx.addNewCrossAx();
		ctValAx.addNewTickLblPos().setVal(STTickLblPos.NEXT_TO);

		setPosition(pos);
		setOrientation(AxisOrientation.MIN_MAX);
		setCrossBetween(AxisCrossBetween.MIDPOINT_CATEGORY);
		setCrosses(AxisCrosses.AUTO_ZERO);
	}

	private static STCrossBetween.Enum fromCrossBetween(AxisCrossBetween crossBetween) {
		switch (crossBetween) {
			case BETWEEN: return STCrossBetween.BETWEEN;
			case MIDPOINT_CATEGORY: return STCrossBetween.MID_CAT;
			default:
				throw new IllegalArgumentException();
		}
	}

	private static AxisCrossBetween toCrossBetween(STCrossBetween.Enum ctCrossBetween) {
		switch (ctCrossBetween.intValue()) {
			case STCrossBetween.INT_BETWEEN: return AxisCrossBetween.BETWEEN;
			case STCrossBetween.INT_MID_CAT: return AxisCrossBetween.MIDPOINT_CATEGORY;
			default:
				throw new IllegalArgumentException();
		}
	}
}




       chart = s3.createDrawingPatriarch().getCharts().get(0);
       assertEquals("Sheet 3 Chart with Title", chart.getTitle().getString());
    }

	public void testAddChartsToNewWorkbook() throws Exception {
		XSSFWorkbook wb = new XSSFWorkbook();
		XSSFSheet s1 = wb.createSheet();
		XSSFDrawing d1 = s1.createDrawingPatriarch();
		XSSFClientAnchor a1 = new XSSFClientAnchor(0, 0, 0, 0, 1, 1, 10, 30);
		XSSFChart c1 = d1.createChart(a1);

		assertEquals(1, d1.getCharts().size());
		assertNotNull(c1.getGraphicFrame());
		assertNotNull(c1.getOrCreateLegend());

		XSSFClientAnchor a2 = new XSSFClientAnchor(0, 0, 0, 0, 1, 11, 10, 60);
		XSSFChart c2 = d1.createChart(a2);
		assertEquals(2, d1.getCharts().size());
	}
}




/* ====================================================================
   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.charts;

import junit.framework.TestCase;

import org.apache.poi.ss.usermodel.charts.*;
import org.apache.poi.xssf.usermodel.*;
import org.apache.poi.xssf.usermodel.charts.*;

public final class TestXSSFChartAxis extends TestCase {

	private static final double EPSILON = 1E-7;
	private XSSFChartAxis axis;

	public TestXSSFChartAxis() {
		super();
		XSSFWorkbook wb = new XSSFWorkbook();
		XSSFSheet sheet = wb.createSheet();
		XSSFDrawing drawing = sheet.createDrawingPatriarch();
		XSSFClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 1, 1, 10, 30);
		XSSFChart chart = drawing.createChart(anchor);
		axis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM);
	}
 
	public void testLogBaseIllegalArgument() throws Exception {
		IllegalArgumentException iae = null;
		try {
			axis.setLogBase(0.0);
		} catch (IllegalArgumentException e) {
			iae = e;
		}
		assertNotNull(iae);

		iae = null;
		try {
			axis.setLogBase(30000.0);
		} catch (IllegalArgumentException e) {
			iae = e;
		}
		assertNotNull(iae);
	}

	public void testLogBaseLegalArgument() throws Exception {
		axis.setLogBase(Math.E);
		assertTrue(Math.abs(axis.getLogBase() - Math.E) < EPSILON);
	}

	public void testNumberFormat() throws Exception {
		final String numberFormat = "General";
		axis.setNumberFormat(numberFormat);
		assertEquals(numberFormat, axis.getNumberFormat());
	}

	public void testMaxAndMinAccessMethods() {
		final double newValue = 10.0;

		axis.setMinimum(newValue);
		assertTrue(Math.abs(axis.getMinimum() - newValue) < EPSILON);

		axis.setMaximum(newValue);
		assertTrue(Math.abs(axis.getMaximum() - newValue) < EPSILON);
	}

}




/* ====================================================================
   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.charts;

import junit.framework.TestCase;

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.usermodel.charts.ChartLegend;
import org.apache.poi.ss.usermodel.charts.LegendPosition;
import org.apache.poi.xssf.usermodel.*;

public final class TestXSSFChartLegend extends TestCase {
 
	public void testLegendPositionAccessMethods() throws Exception {
		Workbook wb = new XSSFWorkbook();
		Sheet sheet = wb.createSheet();
		Drawing drawing = sheet.createDrawingPatriarch();
		ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 1, 1, 10, 30);
		Chart chart = drawing.createChart(anchor);
		ChartLegend legend = chart.getOrCreateLegend();

		legend.setPosition(LegendPosition.TOP_RIGHT);
		assertEquals(LegendPosition.TOP_RIGHT, legend.getPosition());
	}
}




/* ====================================================================
   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.charts;

import junit.framework.TestCase;

import org.apache.poi.xssf.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.usermodel.charts.*;
import org.apache.poi.xssf.usermodel.charts.XSSFChartDataFactory;

public final class TestXSSFScatterChartData  extends TestCase {
 
	public void testOneSeriePlot() throws Exception {
		XSSFWorkbook wb = new XSSFWorkbook();
		XSSFSheet sheet = wb.createSheet();
		XSSFDrawing drawing = sheet.createDrawingPatriarch();
		XSSFClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 1, 1, 10, 30);
		XSSFChart chart = drawing.createChart(anchor);

		ChartAxis bottomAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM);
		ChartAxis leftAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.LEFT);

		ScatterChartData scatterChartData =
				XSSFChartDataFactory.getInstance().createScatterChartData();

		ScatterChartSerie serie = scatterChartData.addSerie();
		serie.setXValues(sheet, new CellRangeAddress(0,0,1,10));
		serie.setYValues(sheet, new CellRangeAddress(1,1,1,10));

		assertEquals(scatterChartData.getSeries().size(), 1);

		chart.plot(scatterChartData, bottomAxis, leftAxis);
	}

}




/* ====================================================================
   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.charts;

import junit.framework.TestCase;

import org.apache.poi.ss.usermodel.charts.*;
import org.apache.poi.xssf.usermodel.*;
import org.apache.poi.xssf.usermodel.charts.*;

public final class TestXSSFValueAxis extends TestCase {
 
	public void testAccessMethods() throws Exception {
		XSSFWorkbook wb = new XSSFWorkbook();
		XSSFSheet sheet = wb.createSheet();
		XSSFDrawing drawing = sheet.createDrawingPatriarch();
		XSSFClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 1, 1, 10, 30);
		XSSFChart chart = drawing.createChart(anchor);
		XSSFValueAxis axis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM);

		axis.setCrossBetween(AxisCrossBetween.MIDPOINT_CATEGORY);
		assertEquals(axis.getCrossBetween(), AxisCrossBetween.MIDPOINT_CATEGORY);

		axis.setCrosses(AxisCrosses.AUTO_ZERO);
		assertEquals(axis.getCrosses(), AxisCrosses.AUTO_ZERO);

		assertEquals(chart.getAxis().size(), 1);
	}
}

Return to bug 51196

Line 0 Link Here

(-)a/src/examples/src/org/apache/poi/xssf/usermodel/examples/ScatterChart.java (+80 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.examples;
		19
		20	import java.io.FileOutputStream;
		21	import java.util.Date;
		22
		23	import org.apache.poi.ss.usermodel.*;
		24	import org.apache.poi.ss.util.*;
		25	import org.apache.poi.ss.usermodel.charts.*;
		26	import org.apache.poi.xssf.usermodel.*;
		27	import org.apache.poi.xssf.usermodel.charts.*;
		28	import org.apache.poi.xssf.usermodel.XSSFWorkbook;
		29
		30	/**
		31	* Illustrates how to create a simple scatter chart.
		32	*/
		33	public class ScatterChart {
		34
		35	public static void main(String[]args) throws Exception {
		36	Workbook wb = new XSSFWorkbook();
		37	CreationHelper creationHelper = wb.getCreationHelper();
		38	Sheet sheet = wb.createSheet("new sheet");
		39	final int NUM_OF_ROWS = 3;
		40	final int NUM_OF_COLUMNS = 10;
		41
		42	// Create a row and put some cells in it. Rows are 0 based.
		43	Row row;
		44	Cell cell;
		45	for (int rowIndex = 0; rowIndex < NUM_OF_ROWS; rowIndex++) {
		46	row = sheet.createRow((short)rowIndex);
		47	for (int colIndex = 0; colIndex < NUM_OF_COLUMNS; colIndex++) {
		48	cell = row.createCell((short)colIndex);
		49	cell.setCellValue(colIndex * (rowIndex + 1));
		50	}
		51	}
		52
		53	Drawing drawing = sheet.createDrawingPatriarch();
		54	ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 0, 5, 10, 15);
		55
		56	Chart chart = drawing.createChart(anchor);
		57	ChartLegend legend = chart.getOrCreateLegend();
		58	legend.setPosition(LegendPosition.RIGHT);
		59
		60	ScatterChartData data = chart.getChartDataFactory().createScatterChartData();
		61
		62	ValueAxis bottomAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM);
		63	ValueAxis leftAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.LEFT);
		64
65	ScatterChartSerie firstSerie = data.addSerie();
66	firstSerie.setXValues(sheet, new CellRangeAddress(0, 0, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));
67	firstSerie.setXValues(sheet, new CellRangeAddress(1, 1, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));
68
69	ScatterChartSerie secondSerie = data.addSerie();
70	secondSerie.setXValues(sheet, new CellRangeAddress(0, 0, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));
71	secondSerie.setYValues(sheet, new CellRangeAddress(2, 2, NUM_OF_COLUMNS + 1, NUM_OF_COLUMNS + 1));
72
73	chart.plot(data, bottomAxis, leftAxis);
74
75	// Write the output to a file
76	FileOutputStream fileOut = new FileOutputStream("ooxml-scatter-chart.xlsx");
77	wb.write(fileOut);
78	fileOut.close();
79	}
80	}

Line 0 Link Here

(-)a/src/java/org/apache/poi/ss/usermodel/Chart.java (+66 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.ss.usermodel;
		19
		20	import java.util.List;
		21
		22	import org.apache.poi.ss.usermodel.charts.ChartData;
		23	import org.apache.poi.ss.usermodel.charts.ChartAxis;
		24	import org.apache.poi.ss.usermodel.charts.ChartLegend;
		25	import org.apache.poi.ss.usermodel.charts.ChartDataFactory;
		26	import org.apache.poi.ss.usermodel.charts.ChartAxisFactory;
		27
		28	/**
		29	* High level representation of a chart.
		30	*
		31	* @author Roman Kashitsyn
		32	*/
		33	public interface Chart {
		34
		35	/**
		36	* @return an appropriate ChartDataFactory implementation
		37	*/
		38	ChartDataFactory getChartDataFactory();
		39
		40	/**
		41	* @return an appropriate ChartAxisFactory implementation
		42	*/
		43	ChartAxisFactory getChartAxisFactory();
		44
		45	/**
		46	* @return chart legend instance
		47	*/
		48	ChartLegend getOrCreateLegend();
		49
		50	/**
		51	* Delete current chart legend.
		52	*/
		53	void deleteLegend();
		54
		55	/**
		56	* @return list of all chart axis
		57	*/
		58	List<? extends ChartAxis> getAxis();
		59
		60	/**
		61	* Plots specified data on the chart.
		62	*
		63	* @param data a data to plot
		64	*/
65	void plot(ChartData data, ChartAxis... axis);
66	}

Lines 90-101 public final class XSSFRelation extends POIXMLRelation { Link Here

(-)a/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFRelation.java (-6 / +6 lines)
90	"/xl/worksheets/sheet#.xml",	90	"/xl/worksheets/sheet#.xml",
91	XSSFSheet.class	91	XSSFSheet.class
92	);	92	);
93	public static final XSSFRelation CHARTSHEET = new XSSFRelation(	93	public static final XSSFRelation CHARTSHEET = new XSSFRelation(
94	"application/vnd.openxmlformats-officedocument.spreadsheetml.chartsheet+xml",	94	"application/vnd.openxmlformats-officedocument.spreadsheetml.chartsheet+xml",
95	"http://schemas.openxmlformats.org/officeDocument/2006/relationships/chartsheet",	95	"http://schemas.openxmlformats.org/officeDocument/2006/relationships/chartsheet",
96	"/xl/chartsheets/sheet#.xml",	96	"/xl/chartsheets/sheet#.xml",
97	XSSFChartSheet.class	97	XSSFChartSheet.class
98	);	98	);
99	public static final XSSFRelation SHARED_STRINGS = new XSSFRelation(	99	public static final XSSFRelation SHARED_STRINGS = new XSSFRelation(
100	"application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml",	100	"application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml",
101	"http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings",	101	"http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings",

Lines 55-58 public final class TestXSSFChart extends TestCase { Link Here

(-)a/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFChart.java (+16 lines)
55	chart = s3.createDrawingPatriarch().getCharts().get(0);	55	chart = s3.createDrawingPatriarch().getCharts().get(0);
56	assertEquals("Sheet 3 Chart with Title", chart.getTitle().getString());	56	assertEquals("Sheet 3 Chart with Title", chart.getTitle().getString());
57	}	57	}
		58
		59	public void testAddChartsToNewWorkbook() throws Exception {
		60	XSSFWorkbook wb = new XSSFWorkbook();
		61	XSSFSheet s1 = wb.createSheet();
		62	XSSFDrawing d1 = s1.createDrawingPatriarch();
		63	XSSFClientAnchor a1 = new XSSFClientAnchor(0, 0, 0, 0, 1, 1, 10, 30);
		64	XSSFChart c1 = d1.createChart(a1);
		65
		66	assertEquals(1, d1.getCharts().size());
		67	assertNotNull(c1.getGraphicFrame());
		68	assertNotNull(c1.getOrCreateLegend());
		69
		70	XSSFClientAnchor a2 = new XSSFClientAnchor(0, 0, 0, 0, 1, 11, 10, 60);
		71	XSSFChart c2 = d1.createChart(a2);
		72	assertEquals(2, d1.getCharts().size());
		73	}
58	}	74	}