Examples of Worksheet

com.aspose.cells.Worksheet
com.google.gdata.data.spreadsheet.Worksheet
com.lastcalc.db.Worksheet
edu.isi.karma.rep.Worksheet
@author szekely
it.eng.spagobi.engines.qbe.worksheet.WorkSheet
@authors Alberto Ghedin (alberto.ghedin@eng.it)
jmc.Worksheet
org.xlsx4j.sml.Worksheet
3.org/2001/XMLSchema}anyType"> <sequence> <element name="sheetPr" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetPr" minOccurs="0"/> <element name="dimension" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetDimension" minOccurs="0"/> <element name="sheetViews" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetViews" minOccurs="0"/> <element name="sheetFormatPr" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetFormatPr" minOccurs="0"/> <element name="cols" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_Cols" maxOccurs="unbounded" minOccurs="0"/> <element name="sheetData" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetData"/> <element name="sheetCalcPr" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetCalcPr" minOccurs="0"/> <element name="sheetProtection" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetProtection" minOccurs="0"/> <element name="protectedRanges" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_ProtectedRanges" minOccurs="0"/> <element name="scenarios" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_Scenarios" minOccurs="0"/> <element name="autoFilter" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_AutoFilter" minOccurs="0"/> <element name="sortState" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SortState" minOccurs="0"/> <element name="dataConsolidate" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_DataConsolidate" minOccurs="0"/> <element name="customSheetViews" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_CustomSheetViews" minOccurs="0"/> <element name="mergeCells" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_MergeCells" minOccurs="0"/> <element name="phoneticPr" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_PhoneticPr" minOccurs="0"/> <element name="conditionalFormatting" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_ConditionalFormatting" maxOccurs="unbounded" minOccurs="0"/> <element name="dataValidations" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_DataValidations" minOccurs="0"/> <element name="hyperlinks" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_Hyperlinks" minOccurs="0"/> <element name="printOptions" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_PrintOptions" minOccurs="0"/> <element name="pageMargins" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_PageMargins" minOccurs="0"/> <element name="pageSetup" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_PageSetup" minOccurs="0"/> <element name="headerFooter" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_HeaderFooter" minOccurs="0"/> <element name="rowBreaks" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_PageBreak" minOccurs="0"/> <element name="colBreaks" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_PageBreak" minOccurs="0"/> <element name="customProperties" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_CustomProperties" minOccurs="0"/> <element name="cellWatches" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_CellWatches" minOccurs="0"/> <element name="ignoredErrors" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_IgnoredErrors" minOccurs="0"/> <element name="smartTags" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SmartTags" minOccurs="0"/> <element name="drawing" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_Drawing" minOccurs="0"/> <element name="legacyDrawing" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_LegacyDrawing" minOccurs="0"/> <element name="legacyDrawingHF" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_LegacyDrawing" minOccurs="0"/> <element name="drawingHF" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_DrawingHF" minOccurs="0"/> <element name="picture" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetBackgroundPicture" minOccurs="0"/> <element name="oleObjects" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_OleObjects" minOccurs="0"/> <element name="controls" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_Controls" minOccurs="0"/> <element name="webPublishItems" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_WebPublishItems" minOccurs="0"/> <element name="tableParts" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_TableParts" minOccurs="0"/> <element name="extLst" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_ExtensionList" minOccurs="0"/> </sequence> </restriction> </complexContent> </complexType>
org.zkoss.zss.model.Worksheet
ZK Spreadsheet sheet. @author henrichen

Examples of org.zkoss.zss.model.Worksheet

    if (data == null || data.size() != 10)
      throw new UiException(MZk.ILLEGAL_REQUEST_WRONG_DATA, new Object[] {Objects.toString(data), this});
    
    String sheetId= (String) data.get("sheetId");
    
    Worksheet sheet = ((Spreadsheet) comp).getSelectedSheet();
    if (!Utils.getSheetUuid(sheet).equals(sheetId))
      return;
    
    int action = (Integer) data.get("action");
    int left = (Integer) data.get("left");

View Full Code Here

Examples of org.zkoss.zss.model.Worksheet

    int col = (Integer) data.get("col");
    int mx = (Integer) data.get("mx");//x offset against body
    int my = (Integer) data.get("my");
    
    Spreadsheet spreadsheet = (Spreadsheet) comp;
    Worksheet sheet = ((Spreadsheet) comp).getSelectedSheet();
    if (!Utils.getSheetUuid(sheet).equals(sheetId))
      return;
    
    if ("lc".equals(type)) {
      type = org.zkoss.zss.ui.event.Events.ON_CELL_CLICK;

View Full Code Here

Examples of org.zkoss.zss.model.Worksheet

      throw new UiException(MZk.ILLEGAL_REQUEST_WRONG_DATA,
        new Object[] {Objects.toString(data), this});
    
    _spreadsheet = ((Spreadsheet)comp);
    if(_spreadsheet.isInvalidated()) return;//since it is invalidate, i don't need to update
    final Worksheet selSheet = _spreadsheet.getSelectedSheet();
    final String sheetId = (String) data.get("sheetId");
    if (selSheet == null || !sheetId.equals(((SheetCtrl)selSheet).getUuid())) { //not current selected sheet, skip.
      return;
    }
    
    _ctrl = ((SpreadsheetCtrl)_spreadsheet.getExtraCtrl());
    _hidecolhead = _spreadsheet.isHidecolumnhead();
    _hiderowhead = _spreadsheet.isHiderowhead();
    String token = (String) data.get("token");
    
    _rowHelper = _ctrl.getRowPositionHelper(sheetId);
    _colHelper = _ctrl.getColumnPositionHelper(sheetId);
    
    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if(!Utils.getSheetUuid(sheet).equals(sheetId)) return;
    
    _mergeMatrix = _ctrl.getMergeMatrixHelper(sheet);
    
    String type = (String) data.get("type");

View Full Code Here

Examples of org.zkoss.zss.model.Worksheet

    int colfreeze = AuRequests.getInt(data, "fcol", -1);
    
    Book book = spreadsheet.getBook();
    int len = book.getNumberOfSheets();
    for (int i = 0; i < len; i++) {
      Worksheet sheet = book.getWorksheetAt(i);
      if (sheetId.equals(((SheetCtrl)sheet).getUuid())) {
        spreadsheet.setSelectedSheetDirectly(sheet.getSheetName(), cacheInClient, row, col, 
            left, top, right, bottom,
            highlightLeft, highlightTop, highlightRight, highlightBottom,
            rowfreeze, colfreeze);
        break;
      }

View Full Code Here

Examples of org.zkoss.zss.model.Worksheet

    final CellReference c1 = ref.getFirstCell();
    final CellReference c2 = ref.getLastCell();
    final String sheetnm1 = c1.getSheetName();
    final String sheetnm2 = c2.getSheetName();
    final Book book = sheet.getBook(); 
    final Worksheet sheet1 = sheetnm1 != null ? book.getWorksheet(sheetnm1) : sheet;
    final Worksheet sheet2 = sheetnm2 != null ? book.getWorksheet(sheetnm2) : sheet;
    final int tRow = c1.getRow();
    final int lCol = c1.getCol();
    final int bRow = c2.getRow();
    final int rCol = c2.getCol();
    return newRange(sheet1, sheet2, tRow, lCol, bRow, rCol);

View Full Code Here

Examples of org.zkoss.zss.model.Worksheet

    final int s1 = book.getSheetIndex(sheet);
    final int s2 = book.getSheetIndex(lastSheet);
    final int sb = Math.min(s1,s2);
    final int se = Math.max(s1,s2);
    for (int s = sb; s <= se; ++s) {
      final Worksheet sht = book.getWorksheetAt(s);
      final RefSheet refSht = BookHelper.getOrCreateRefBook(book).getOrCreateRefSheet(sht.getSheetName());
      addRef(new CellRefImpl(row, col, refSht));
    }
  }

View Full Code Here

Examples of org.zkoss.zss.model.Worksheet

    final int s1 = book.getSheetIndex(sheet);
    final int s2 = book.getSheetIndex(lastSheet);
    final int sb = Math.min(s1,s2);
    final int se = Math.max(s1,s2);
    for (int s = sb; s <= se; ++s) {
      final Worksheet sht = book.getWorksheetAt(s);
      final RefSheet refSht = BookHelper.getOrCreateRefBook(book).getOrCreateRefSheet(sht.getSheetName());
      addRef(new AreaRefImpl(tRow, lCol, bRow, rCol, refSht));
    }
  }

View Full Code Here

Examples of org.zkoss.zss.model.Worksheet

        final int lCol = ref.getLeftCol();
        final RefSheet refSheet = ref.getOwnerSheet();
        final Cell cell = getCell(tRow, lCol, refSheet);
        
        final Object[] values = BookHelper.editTextToValue(txt, cell);
        final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
        
        final int cellType = values == null ? -1 : ((Integer)values[0]).intValue();
        final Object value = values == null ? null : values[1];
        
        return BookHelper.validate(sheet, tRow, lCol, value, cellType);

View Full Code Here

Examples of org.zkoss.zss.model.Worksheet

        final int lCol = ref.getLeftCol();
        final RefSheet refSheet = ref.getOwnerSheet();
        final Cell cell = getCell(tRow, lCol, refSheet);
        
        final Object[] values = BookHelper.editTextToValue(txt, cell);
        final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
        
        final int cellType = values == null ? -1 : ((Integer)values[0]).intValue();
        final Object value = values == null ? null : values[1];
        
        Set<Ref>[] refs = null;

View Full Code Here

Examples of org.zkoss.zss.model.Worksheet

      final int tRow = ref.getTopRow();
      final int lCol = ref.getLeftCol();
      final int bRow = ref.getBottomRow();
      final int rCol = ref.getRightCol();
      final RefSheet refSheet = ref.getOwnerSheet();
      final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
      final Workbook book = sheet.getWorkbook();
      
      for(int row = tRow; row <= bRow; ++row) {
        for (int col = lCol; col <= rCol; ++col) {
          final Cell cell = BookHelper.getCell(sheet, row, col);
          final CellStyle style = cell != null ? cell.getCellStyle() : null;

View Full Code Here

0 1 2 3 4 5

TOP

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.