Package org.openxmlformats.schemas.spreadsheetml.x2006.main

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetView

813
814
815
816
817
818
819
820
     *
     * @param value whether to display or hide all zero values on the worksheet
     */
    @Override
    public void setDisplayZeros(boolean value){
        CTSheetView view = getSheetTypeSheetView();
        view.setShowZeros(value);
    }
View Full Code Here
2670
2671
2672
2673
2674
2675
2676
2677
     *
     * @return <code>true</code> if this sheet is selected
     */
    @Override
    public boolean isSelected() {
        CTSheetView view = getDefaultSheetView();
        return view != null && view.getTabSelected();
    }
View Full Code Here
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
   
    public boolean isFreezePanes() {
        final CTWorksheet ctsheet = getCTWorksheet();
        final CTSheetViews views = ctsheet != null ? ctsheet.getSheetViews() : null;
        final List<CTSheetView> viewList = views != null ? views.getSheetViewList() : null;
        final CTSheetView view = viewList != null && !viewList.isEmpty() ? viewList.get(0) : null;
      final CTPane pane = view != null ? view.getPane() : null;
      if (pane == null) {
        return false;
      } else {
        return pane.getState() == STPaneState.FROZEN;
      }
View Full Code Here
220
221
222
223
224
225
226
227
228
229
230
231
    private static CTWorksheet newSheet(){
        CTWorksheet worksheet = CTWorksheet.Factory.newInstance();
        CTSheetFormatPr ctFormat = worksheet.addNewSheetFormatPr();
        ctFormat.setDefaultRowHeight(15.0);

        CTSheetView ctView = worksheet.addNewSheetViews().addNewSheetView();
        ctView.setWorkbookViewId(0);

        worksheet.addNewDimension().setRef("A1");

        worksheet.addNewSheetData();
View Full Code Here
380
381
382
383
384
385
386
387
388
389
        } else {
            pane.setTopLeftCell(new CellReference(leftmostColumn, topRow).formatAsString());
            pane.setActivePane(STPane.BOTTOM_RIGHT);
        }

        CTSheetView ctView = getDefaultSheetView();
        ctView.setSelectionArray(null);
        CTSelection sel = ctView.addNewSelection();
        sel.setPane(pane.getActivePane());
    }
View Full Code Here
575
576
577
578
579
580
581
582
     * When false, cells with zero value appear blank instead of showing the number zero.
     *
     * @return whether all zero values on the worksheet are displayed
     */
    public boolean isDisplayZeros(){
        CTSheetView view = getDefaultSheetView();
        return view == null ? true : view.getShowZeros();
    }
View Full Code Here
586
587
588
589
590
591
592
593
     * When false, cells with zero value appear blank instead of showing the number zero.
     *
     * @param value whether to display or hide all zero values on the worksheet
     */
    public void setDisplayZeros(boolean value){
        CTSheetView view = getSheetTypeSheetView();
        view.setShowZeros(value);
    }
View Full Code Here
2130
2131
2132
2133
2134
2135
2136
2137
     * Note: multiple sheets can be selected, but only one sheet can be active at one time.
     *
     * @return <code>true</code> if this sheet is selected
     */
    public boolean isSelected() {
        CTSheetView view = getDefaultSheetView();
        return view != null && view.getTabSelected();
    }
View Full Code Here
243
244
245
246
247
248
249
250
251
252
253
254
    private static CTWorksheet newSheet(){
        CTWorksheet worksheet = CTWorksheet.Factory.newInstance();
        CTSheetFormatPr ctFormat = worksheet.addNewSheetFormatPr();
        ctFormat.setDefaultRowHeight(15.0);

        CTSheetView ctView = worksheet.addNewSheetViews().addNewSheetView();
        ctView.setWorkbookViewId(0);

        worksheet.addNewDimension().setRef("A1");

        worksheet.addNewSheetData();
View Full Code Here
478
479
480
481
482
483
484
485
486
487
        } else {
            pane.setTopLeftCell(new CellReference(leftmostColumn, topRow).formatAsString());
            pane.setActivePane(STPane.BOTTOM_RIGHT);
        }

        CTSheetView ctView = getDefaultSheetView();
        ctView.setSelectionArray(null);
        CTSelection sel = ctView.addNewSelection();
        sel.setPane(pane.getActivePane());
    }
View Full Code Here
TOP

Related Classes of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetView

  • com.narirelays.ems.utils.ExcelUtility
  • org.apache.poi.hssf.extractor.HXFExcelExtractor
  • org.apache.poi.hssf.HSSFXML
  • org.apache.poi.hssf.model.SharedStringsTable
  • org.apache.poi.xssf.eventusermodel.TestReadOnlySharedStringsTable
  • org.apache.poi.xssf.eventusermodel.XSSFReader$SheetIterator
  • org.apache.poi.xssf.model.CommentsTable
  • org.apache.poi.xssf.model.Control
  • org.apache.poi.xssf.model.Drawing
  • org.apache.poi.xssf.model.ExternalLinksTable
    • 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.