Package org.zkoss.poi.ss.usermodel

Examples of org.zkoss.poi.ss.usermodel.Name

48
49
50
51
52
53
54
55
56
57
58
59
60
  public static Range range(Worksheet sheet, String reference) {
    AreaReference ref = getAreaReference(sheet, reference);
    if (ref == null) {
      //try NamedRange
      final Workbook wb = sheet.getWorkbook();
        final Name range = wb.getName(reference);
        if (range != null) {
          ref = getAreaReference(sheet, range.getRefersToFormula());
        } else {
          throw new IllegalArgumentException("Cannot find the named range '" + reference + "'");
        }
    }
    if (ref == null)
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
75
    int bottom = spreadsheet.getSelection().getBottom();
    Textbox fsaw_filename = (Textbox) Path
        .getComponent("//p1/rangeAddWin/raw_rangename");
    String name = fsaw_filename.getValue();

    Name namevar = book.createName();
    namevar.setNameName(name);
    namevar.setSheetIndex(sheetindex);
    CellRangeAddress cra = new CellRangeAddress(top, bottom, left, right);
    namevar.setRefersToFormula(cra.formatAsString());
   
    Window rangeAddWin = (Window) Path.getComponent("//p1/rangeAddWin");
    rangeAddWin.detach();
  }
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
    try {
      Listbox rcw_rangeList = (Listbox) Path
          .getComponent("//p1/rangeChooseWin/rcw_rangeList");

      Listitem st = rcw_rangeList.getSelectedItem();
      Name range;
      Rect rect;
      if (st != null) {
        String rangeName = st.getLabel();
        range = book.getName(rangeName);
        CellRangeAddress cra = CellRangeAddress.valueOf(range.getRefersToFormula());
        rect = new Rect(cra.getFirstColumn(), cra.getFirstRow(),
            cra.getLastColumn(), cra.getLastRow());
        spreadsheet.setSelection(rect);
      }
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
      } else {
        return;
      }
     
      Listitem st = rangeList.getSelectedItem();
      Name range;
      Rect rect;
      if (st != null) {
        String rangeName = st.getLabel();
        range = book.getName(rangeName);
        CellRangeAddress cra = CellRangeAddress.valueOf(range.getRefersToFormula());
        rect = new Rect(cra.getFirstColumn(), cra.getFirstRow(),
            cra.getLastColumn(), cra.getLastRow());
        spreadsheet.setHighlight(rect);
      }
View Full Code Here
TOP

Related Classes of org.zkoss.poi.ss.usermodel.Name

  • org.zkoss.zss.app.RangeHelper
  • org.zkoss.zss.model.Ranges
    • 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.