Package org.zkoss.poi.ss.usermodel.charts

Examples of org.zkoss.poi.ss.usermodel.charts.ChartData


    Rect selection = spreadsheet.getSelection();
    Ranges.range(sheet).addChart(getClientCenterAnchor(row, col, 600, 300), newChartData(chartType, selection), chartType, ChartGrouping.STANDARD, LegendPosition.RIGHT);
  }
 
  private ChartData newChartData(ChartType chartType, Rect selection) {
    ChartData data = null;
   
    switch (chartType) {
    case Area3D:
      data = fillCategoryData(new XSSFArea3DChartData());
      break;
View Full Code Here


    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        int row = selection.getTop();
        int col = selection.getLeft();
        ChartData data = fillCategoryData(new XSSFColumnChartData(), selection);
       
        Ranges.range(sheet)
        .addChart(getClientAnchor(row, col, 600, 300), data, ChartType.Column, ChartGrouping.STANDARD, LegendPosition.RIGHT);   
      } else {
        showProtectMessage();
View Full Code Here

    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        int row = selection.getTop();
        int col = selection.getLeft();
        ChartData data = fillCategoryData(new XSSFColumn3DChartData(), selection);
       
        Ranges.range(sheet)
        .addChart(getClientAnchor(row, col, 600, 300), data, ChartType.Column3D, ChartGrouping.STANDARD, LegendPosition.RIGHT);   
      } else {
        showProtectMessage();
View Full Code Here

    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        int row = selection.getTop();
        int col = selection.getLeft();
        ChartData data = fillCategoryData(new XSSFLineChartData(), selection);
       
        Ranges.range(sheet)
        .addChart(getClientAnchor(row, col, 600, 300), data, ChartType.Line, ChartGrouping.STANDARD, LegendPosition.RIGHT);   
      } else {
        showProtectMessage();
View Full Code Here

    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        int row = selection.getTop();
        int col = selection.getLeft();
        ChartData data = fillCategoryData(new XSSFLine3DChartData(), selection);
       
        Ranges.range(sheet)
        .addChart(getClientAnchor(row, col, 600, 300), data, ChartType.Line3D, ChartGrouping.STANDARD, LegendPosition.RIGHT);   
      } else {
        showProtectMessage();
View Full Code Here

    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        int row = selection.getTop();
        int col = selection.getLeft();
        ChartData data = fillCategoryData(new XSSFPieChartData(), selection);
       
        Ranges.range(sheet)
        .addChart(getClientAnchor(row, col, 600, 300), data, ChartType.Pie, ChartGrouping.STANDARD, LegendPosition.RIGHT)
      } else {
        showProtectMessage();
View Full Code Here

    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        int row = selection.getTop();
        int col = selection.getLeft();
        ChartData data = fillCategoryData(new XSSFPie3DChartData(), selection);
       
        Ranges.range(sheet)
        .addChart(getClientAnchor(row, col, 600, 300), data, ChartType.Pie3D, ChartGrouping.STANDARD, LegendPosition.RIGHT)
      } else {
        showProtectMessage();
View Full Code Here

    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        int row = selection.getTop();
        int col = selection.getLeft();
        ChartData data = fillCategoryData(new XSSFBarChartData(), selection);
       
        Ranges.range(sheet)
        .addChart(getClientAnchor(row, col, 600, 300), data, ChartType.Bar, ChartGrouping.STANDARD, LegendPosition.RIGHT)
      } else {
        showProtectMessage();
View Full Code Here

    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        int row = selection.getTop();
        int col = selection.getLeft();
        ChartData data = fillCategoryData(new XSSFBar3DChartData(), selection);
       
        Ranges.range(sheet)
        .addChart(getClientAnchor(row, col, 600, 300), data, ChartType.Bar3D, ChartGrouping.STANDARD, LegendPosition.RIGHT)
      } else {
        showProtectMessage();
View Full Code Here

    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        int row = selection.getTop();
        int col = selection.getLeft();
        ChartData data = fillCategoryData(new XSSFAreaChartData(), selection);
       
        Ranges.range(sheet)
        .addChart(getClientAnchor(row, col, 600, 300), data, ChartType.Area, ChartGrouping.STANDARD, LegendPosition.RIGHT)
      } else {
        showProtectMessage();
View Full Code Here

TOP

Related Classes of org.zkoss.poi.ss.usermodel.charts.ChartData

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.