Package org.odftoolkit.simple

Examples of org.odftoolkit.simple.SpreadsheetDocument$ChartContainerImpl

1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
    }
  }

  @Test
  public void testAppendRowsWithCoveredCell() {
    SpreadsheetDocument odsDoc = null;
    Table table = null;
    try {
      odsDoc = SpreadsheetDocument.newSpreadsheetDocument();
      table = Table.newTable(odsDoc);
      mergeCells(table, 1, 1, 3, 2);
View Full Code Here
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
  }

  @Test
  public void testAppendRowsWithRowsRepeated() {
    SpreadsheetDocument odsDoc = null;
    Table table = null;
    try {
      odsDoc = SpreadsheetDocument.newSpreadsheetDocument();
      table = Table.newTable(odsDoc, 1, 1);
      table.appendRows(12);
View Full Code Here
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
    }
  }

  @Test
  public void testAppendColumnsWithColumnsRepeated() {
    SpreadsheetDocument odsDoc = null;
    Table table = null;
    try {
      odsDoc = SpreadsheetDocument.newSpreadsheetDocument();
      table = Table.newTable(odsDoc, 1, 1);
      table.appendColumns(12);
View Full Code Here
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
  // Bug 97 - Row.getCellAt(int) returns null when the cell is a repeat cell
  @Test
  public void testGetCellAt() {
    try {
      SpreadsheetDocument doc = (SpreadsheetDocument) SpreadsheetDocument.loadDocument(ResourceUtilities
          .getTestResourceAsStream("testGetCellAt.ods"));
      Table odfTable = doc.getTableList().get(0);
      Row valueRows = odfTable.getRowByIndex(0);
      for (int i = 0; i < 4; i++) {
        Cell cell = valueRows.getCellByIndex(i);
        Assert.assertNotNull(cell);
        int value = cell.getDoubleValue().intValue();
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
  public void testSetBorders() {
    try {
     
        Border borderbase = new Border(Color.LIME, 1.0701, 0.0208, 0.0346, SupportedLinearMeasure.CM);
      borderbase.setLineStyle(StyleTypeDefinitions.LineType.SINGLE);
      SpreadsheetDocument doc = SpreadsheetDocument.newSpreadsheetDocument();
      Table table = doc.getTableByName("Sheet1");
     
      Cell cell = table.getCellByPosition(2, 2);
      cell.setBorders(CellBordersType.BOTTOM, borderbase);
      cell.setBorders(CellBordersType.RIGHT, borderbase);
      cell.setBorders(CellBordersType.DIAGONALTLBR, borderbase);

      //verification
      Border base = cell.getBorder(CellBordersType.BOTTOM);
      base = cell.getBorder(CellBordersType.RIGHT);
      base = cell.getBorder(CellBordersType.DIAGONALTLBR);
      Assert.assertEquals(borderbase, base);
      Assert.assertEquals(StyleTypeDefinitions.LineType.SINGLE, borderbase.getLineStyle());
     
      //save
      doc.save(ResourceUtilities.newTestOutputFile("testSupportedLinearMeasure.ods"));
    } catch (Exception e) {
      LOGGER.log(Level.SEVERE, e.getMessage(), e);
      Assert.fail(e.getMessage());
    }
  }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
  public void testSetBorders_NONE() {
    try {
     
        Border borderbase = new Border(Color.LIME, 3.0701, 0.0208, 0.0346, SupportedLinearMeasure.CM);
      borderbase.setLineStyle(StyleTypeDefinitions.LineType.SINGLE);
      SpreadsheetDocument doc = SpreadsheetDocument.newSpreadsheetDocument();
      Table table = doc.getTableByName("Sheet1");
     
      Cell cell = table.getCellByPosition(0, 0);
      //cell.setBorders(CellBordersType.DIAGONAL_LINES, borderbase);
      cell.setBorders(CellBordersType.RIGHT, borderbase);
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
  public void testSetBorders_DIAGONAL_LINES() {
    try {
     
        Border borderbase = new Border(Color.LIME, 3.0701, 0.0208, 0.0346, SupportedLinearMeasure.CM);
      borderbase.setLineStyle(StyleTypeDefinitions.LineType.SINGLE);
      SpreadsheetDocument doc = SpreadsheetDocument.newSpreadsheetDocument();
      Table table = doc.getTableByName("Sheet1");
     
      Cell cell = table.getCellByPosition(0, 0);
      cell.setBorders(CellBordersType.DIAGONAL_LINES, borderbase);

      //validate
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
  @Test
  public void testGetBorder() {
    try {
      Border borderbase = new Border(Color.LIME, 3.0701, 0.0208, 0.0346, SupportedLinearMeasure.CM);
      borderbase.setLineStyle(StyleTypeDefinitions.LineType.SINGLE);
      SpreadsheetDocument doc = SpreadsheetDocument.newSpreadsheetDocument();
      Table table = doc.getTableByName("Sheet1");
     
      Cell cell = table.getCellByPosition(2, 2);
      cell.setBorders(CellBordersType.ALL_FOUR, borderbase);

      //validate
      TableCellProperties styleCell = cell.getStyleHandler().getTableCellPropertiesForWrite();
      Border bor = styleCell.getBorder();
      Assert.assertEquals(borderbase, bor);
     
      //save
      doc.save(ResourceUtilities.newTestOutputFile("testSupportedLinearMeasure.ods"));
    } catch (Exception e) {
      LOGGER.log(Level.SEVERE, e.getMessage(), e);
      Assert.fail(e.getMessage());
    }
  }
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
  @Test
  public void testGetLeftBorder() {
    try {
      Border borderbase = new Border(Color.LIME, 3.0701, 0.0208, 0.0346, SupportedLinearMeasure.CM);
      borderbase.setLineStyle(StyleTypeDefinitions.LineType.DOUBLE);
      SpreadsheetDocument doc = SpreadsheetDocument.newSpreadsheetDocument();
      Table table = doc.getTableByName("Sheet1");
     
      Cell cell = table.getCellByPosition(2, 2);
      cell.setBorders(CellBordersType.RIGHT, borderbase);

      //validate
      TableCellProperties styleCell = cell.getStyleHandler().getTableCellPropertiesForWrite();
      Border bor = styleCell.getRightBorder();
      Assert.assertEquals(borderbase, bor);
     
      //save
      doc.save(ResourceUtilities.newTestOutputFile("testSupportedLinearMeasure.ods"));
    } catch (Exception e) {
      LOGGER.log(Level.SEVERE, e.getMessage(), e);
      Assert.fail(e.getMessage());
    }
  }
View Full Code Here
184
185
186
187
188
189
190
191
192
193
194
195
    }
  }
 
        @Test
  public void testSettingNullBackgroundOnProperties() throws Exception {
            SpreadsheetDocument doc = SpreadsheetDocument.newSpreadsheetDocument();
            Table table = doc.getTableByName("Sheet1");
            Cell cell = table.getCellByPosition(1, 1);
            cell.setCellBackgroundColor(Color.BLACK);
            // setting null resets the element, see ODFTOOLKIT-326
            cell.getStyleHandler().getTableCellPropertiesForWrite().setBackgroundColor(null);
            Assert.assertNull(cell.getStyleHandler().getTableCellPropertiesForRead().getBackgroundColor());
View Full Code Here
TOP

Related Classes of org.odftoolkit.simple.SpreadsheetDocument$ChartContainerImpl

  • com.confluenity.jaylen.listeners.SpreadSheetFrameListener
  • com.ka.spreadsheet.diff.SpreadSheetDiffer
  • org.odftoolkit.odfdom.dom.element.draw.DrawFrameElement
  • org.odftoolkit.odfdom.dom.element.draw.DrawObjectElement
  • org.odftoolkit.odfdom.dom.element.draw.DrawPageElement
  • org.odftoolkit.odfdom.dom.element.office.OfficeSpreadsheetElement
  • org.odftoolkit.odfdom.dom.element.table.TableTableCellElement
  • org.odftoolkit.odfdom.dom.element.table.TableTableElement
  • org.odftoolkit.odfdom.dom.element.text.TextPElement
  • org.odftoolkit.odfdom.dom.OdfContentDom
    • 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.