poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From one...@apache.org
Subject svn commit: r1823925 - /poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml
Date Mon, 12 Feb 2018 06:42:27 GMT
Author: onealj
Date: Mon Feb 12 06:42:26 2018
New Revision: 1823925

URL: http://svn.apache.org/viewvc?rev=1823925&view=rev
Log:
bug 61898: update Spreadsheet Quick Guide: short -> int

Modified:
    poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml

Modified: poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml?rev=1823925&r1=1823924&r2=1823925&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml (original)
+++ poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml Mon Feb 12 06:42:26
2018
@@ -134,7 +134,7 @@
     Sheet sheet = wb.createSheet("new sheet");
 
     // Create a row and put some cells in it. Rows are 0 based.
-    Row row = sheet.createRow((short)0);
+    Row row = sheet.createRow(0);
     // Create a cell and put a value in it.
     Cell cell = row.createCell(0);
     cell.setCellValue(1);
@@ -193,7 +193,7 @@
                     <source>
     Workbook wb = new HSSFWorkbook();
     Sheet sheet = wb.createSheet("new sheet");
-    Row row = sheet.createRow((short)2);
+    Row row = sheet.createRow(2);
     row.createCell(0).setCellValue(1.1);
     row.createCell(1).setCellValue(new Date());
     row.createCell(2).setCellValue(Calendar.getInstance());
@@ -260,16 +260,16 @@
         Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook();
 
         Sheet sheet = wb.createSheet();
-        Row row = sheet.createRow((short) 2);
+        Row row = sheet.createRow(2);
         row.setHeightInPoints(30);
 
-        createCell(wb, row, (short) 0, HorizontalAlignment.CENTER, VerticalAlignment.BOTTOM);
-        createCell(wb, row, (short) 1, HorizontalAlignment.CENTER_SELECTION, VerticalAlignment.BOTTOM);
-        createCell(wb, row, (short) 2, HorizontalAlignment.FILL, VerticalAlignment.CENTER);
-        createCell(wb, row, (short) 3, HorizontalAlignment.GENERAL, VerticalAlignment.CENTER);
-        createCell(wb, row, (short) 4, HorizontalAlignment.JUSTIFY, VerticalAlignment.JUSTIFY);
-        createCell(wb, row, (short) 5, HorizontalAlignment.LEFT, VerticalAlignment.TOP);
-        createCell(wb, row, (short) 6, HorizontalAlignment.RIGHT, VerticalAlignment.TOP);
+        createCell(wb, row, 0, HorizontalAlignment.CENTER, VerticalAlignment.BOTTOM);
+        createCell(wb, row, 1, HorizontalAlignment.CENTER_SELECTION, VerticalAlignment.BOTTOM);
+        createCell(wb, row, 2, HorizontalAlignment.FILL, VerticalAlignment.CENTER);
+        createCell(wb, row, 3, HorizontalAlignment.GENERAL, VerticalAlignment.CENTER);
+        createCell(wb, row, 4, HorizontalAlignment.JUSTIFY, VerticalAlignment.JUSTIFY);
+        createCell(wb, row, 5, HorizontalAlignment.LEFT, VerticalAlignment.TOP);
+        createCell(wb, row, 6, HorizontalAlignment.RIGHT, VerticalAlignment.TOP);
 
         // Write the output to a file
         FileOutputStream fileOut = new FileOutputStream("xssf-align.xlsx");
@@ -287,7 +287,7 @@
      * @param halign the horizontal alignment for the cell.
      * @param valign the vertical alignment for the cell.
      */
-    private static void createCell(Workbook wb, Row row, short column, HorizontalAlignment
halign, VerticalAlignment valign) {
+    private static void createCell(Workbook wb, Row row, int column, HorizontalAlignment
halign, VerticalAlignment valign) {
         Cell cell = row.createCell(column);
         cell.setCellValue("Align It");
         CellStyle cellStyle = wb.createCellStyle();
@@ -467,13 +467,13 @@
     Sheet sheet = wb.createSheet("new sheet");
 
     // Create a row and put some cells in it. Rows are 0 based.
-    Row row = sheet.createRow((short) 1);
+    Row row = sheet.createRow(1);
 
     // Aqua background
     CellStyle style = wb.createCellStyle();
     style.setFillBackgroundColor(IndexedColors.AQUA.getIndex());
     style.setFillPattern(FillPatternType.BIG_SPOTS);
-    Cell cell = row.createCell((short) 1);
+    Cell cell = row.createCell(1);
     cell.setCellValue("X");
     cell.setCellStyle(style);
 
@@ -481,7 +481,7 @@
     style = wb.createCellStyle();
     style.setFillForegroundColor(IndexedColors.ORANGE.getIndex());
     style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
-    cell = row.createCell((short) 2);
+    cell = row.createCell(2);
     cell.setCellValue("X");
     cell.setCellStyle(style);
 
@@ -497,8 +497,8 @@
     Workbook wb = new HSSFWorkbook();
     Sheet sheet = wb.createSheet("new sheet");
 
-    Row row = sheet.createRow((short) 1);
-    Cell cell = row.createCell((short) 1);
+    Row row = sheet.createRow(1);
+    Cell cell = row.createCell(1);
     cell.setCellValue("This is a test of merging");
 
     sheet.addMergedRegion(new CellRangeAddress(
@@ -545,8 +545,7 @@
     fileOut.close();
   </source>
 <p>
-  Note, the maximum number of unique fonts in a workbook is limited to 32767 (
-  the maximum positive short). You should re-use fonts in your applications instead of
+  Note, the maximum number of unique fonts in a workbook is limited to 32767. You should
re-use fonts in your applications instead of
   creating a font for each cell.
 Examples:
 </p>
@@ -554,7 +553,7 @@ Examples:
 <source>
     for (int i = 0; i &lt; 10000; i++) {
         Row row = sheet.createRow(i);
-        Cell cell = row.createCell((short) 0);
+        Cell cell = row.createCell(0);
 
         CellStyle style = workbook.createCellStyle();
         Font font = workbook.createFont();
@@ -572,7 +571,7 @@ Examples:
     style.setFont(font);
     for (int i = 0; i &lt; 10000; i++) {
         Row row = sheet.createRow(i);
-        Cell cell = row.createCell((short) 0);
+        Cell cell = row.createCell(0);
         cell.setCellStyle(style);
     }
 </source>
@@ -584,8 +583,8 @@ Examples:
                     <source>
     HSSFWorkbook wb = new HSSFWorkbook();
     HSSFSheet sheet = wb.createSheet();
-    HSSFRow row = sheet.createRow((short) 0);
-    HSSFCell cell = row.createCell((short) 0);
+    HSSFRow row = sheet.createRow(0);
+    HSSFCell cell = row.createCell(0);
     cell.setCellValue("Default Palette");
 
     //apply some colors from the standard palette,
@@ -685,7 +684,7 @@ Examples:
     row.setHeightInPoints((2*sheet.getDefaultRowHeightInPoints()));
 
     //adjust column width to fit the content
-    sheet.autoSizeColumn((short)2);
+    sheet.autoSizeColumn(2);
 
     FileOutputStream fileOut = new FileOutputStream("ooxml-newlines.xlsx");
     wb.write(fileOut);
@@ -701,8 +700,8 @@ Examples:
     DataFormat format = wb.createDataFormat();
     Row row;
     Cell cell;
-    short rowNum = 0;
-    short colNum = 0;
+    int rowNum = 0;
+    int colNum = 0;
 
     row = sheet.createRow(rowNum++);
     cell = row.createCell(colNum);
@@ -806,19 +805,14 @@ Examples:
     sheet1.addMergedRegion( region );
 
     // Set the border and border colors.
-    final short borderMediumDashed = BorderStyle.MEDIUM_DASHED;
-    RegionUtil.setBorderBottom( borderMediumDashed,
-        region, sheet1, wb );
-    RegionUtil.setBorderTop( borderMediumDashed,
-        region, sheet1, wb );
-    RegionUtil.setBorderLeft( borderMediumDashed,
-        region, sheet1, wb );
-    RegionUtil.setBorderRight( borderMediumDashed,
-        region, sheet1, wb );
+    RegionUtil.setBorderBottom( BorderStyle.MEDIUM_DASHED, region, sheet1, wb );
+    RegionUtil.setBorderTop(    BorderStyle.MEDIUM_DASHED, region, sheet1, wb );
+    RegionUtil.setBorderLeft(   BorderStyle.MEDIUM_DASHED, region, sheet1, wb );
+    RegionUtil.setBorderRight(  BorderStyle.MEDIUM_DASHED, region, sheet1, wb );
     RegionUtil.setBottomBorderColor(IndexedColors.AQUA.getIndex(), region, sheet1, wb);
-    RegionUtil.setTopBorderColor(IndexedColors.AQUA.getIndex(), region, sheet1, wb);
-    RegionUtil.setLeftBorderColor(IndexedColors.AQUA.getIndex(), region, sheet1, wb);
-    RegionUtil.setRightBorderColor(IndexedColors.AQUA.getIndex(), region, sheet1, wb);
+    RegionUtil.setTopBorderColor(   IndexedColors.AQUA.getIndex(), region, sheet1, wb);
+    RegionUtil.setLeftBorderColor(  IndexedColors.AQUA.getIndex(), region, sheet1, wb);
+    RegionUtil.setRightBorderColor( IndexedColors.AQUA.getIndex(), region, sheet1, wb);
 
     // Shows some usages of HSSFCellUtil
     CellStyle style = wb.createCellStyle();
@@ -1119,8 +1113,8 @@ Examples:
     // Create a couple of lines in the group.
     HSSFSimpleShape shape1 = group.createShape(new HSSFChildAnchor(3,3,500,500));
     shape1.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE);
-    ( (HSSFChildAnchor) shape1.getAnchor() ).setAnchor((short)3,3,500,500);
-    HSSFSimpleShape shape2 = group.createShape(new HSSFChildAnchor((short)1,200,400,600));
+    ( (HSSFChildAnchor) shape1.getAnchor() ).setAnchor(3,3,500,500);
+    HSSFSimpleShape shape2 = group.createShape(new HSSFChildAnchor(1,200,400,600));
     shape2.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE);
                     </source>
                     <p>
@@ -1265,9 +1259,9 @@ Examples:
     sheet1.groupRow( 7, 14 );
     sheet1.groupRow( 16, 19 );
 
-    sheet1.groupColumn( (short)4, (short)7 );
-    sheet1.groupColumn( (short)9, (short)12 );
-    sheet1.groupColumn( (short)10, (short)11 );
+    sheet1.groupColumn( 4, 7 );
+    sheet1.groupColumn( 9, 12 );
+    sheet1.groupColumn( 10, 11 );
 
     FileOutputStream fileOut = new FileOutputStream(filename);
     wb.write(fileOut);
@@ -1278,7 +1272,7 @@ Examples:
                     </p>
                     <source>
     sheet1.setRowGroupCollapsed( 7, true );
-    sheet1.setColumnGroupCollapsed( (short)4, true );
+    sheet1.setColumnGroupCollapsed( 4, true );
                     </source>
                     <p>
                         The row/column you choose should contain an already
@@ -1383,7 +1377,7 @@ Examples:
     String sname = "TestSheet", cname = "TestName", cvalue = "TestVal";
     Workbook wb = new HSSFWorkbook();
     Sheet sheet = wb.createSheet(sname);
-    sheet.createRow(0).createCell((short) 0).setCellValue(cvalue);
+    sheet.createRow(0).createCell(0).setCellValue(cvalue);
 
     // 1. create named range for a single cell using areareference
     Name namedCell = wb.createName();
@@ -1522,7 +1516,7 @@ Examples:
   Reading cell comments
         </p>
   <source>
-    Cell cell = sheet.get(3).getColumn((short)1);
+    Cell cell = sheet.get(3).getColumn(1);
     Comment comment = cell.getCellComment();
     if (comment != null) {
       RichTextString str = comment.getString();
@@ -1602,7 +1596,7 @@ Examples:
         <source>
     Sheet sheet = workbook.getSheetAt(0);
 
-    Cell cell = sheet.getRow(0).getCell((short)0);
+    Cell cell = sheet.getRow(0).getCell(0);
     Hyperlink link = cell.getHyperlink();
     if(link != null){
         System.out.println(link.getAddress());
@@ -1625,7 +1619,7 @@ Examples:
     Cell cell;
     Sheet sheet = wb.createSheet("Hyperlinks");
     //URL
-    cell = sheet.createRow(0).createCell((short)0);
+    cell = sheet.createRow(0).createCell(0);
     cell.setCellValue("URL Link");
 
     Hyperlink link = createHelper.createHyperlink(Hyperlink.LINK_URL);
@@ -1634,7 +1628,7 @@ Examples:
     cell.setCellStyle(hlink_style);
 
     //link to a file in the current directory
-    cell = sheet.createRow(1).createCell((short)0);
+    cell = sheet.createRow(1).createCell(0);
     cell.setCellValue("File Link");
     link = createHelper.createHyperlink(Hyperlink.LINK_FILE);
     link.setAddress("link1.xls");
@@ -1642,7 +1636,7 @@ Examples:
     cell.setCellStyle(hlink_style);
 
     //e-mail link
-    cell = sheet.createRow(2).createCell((short)0);
+    cell = sheet.createRow(2).createCell(0);
     cell.setCellValue("Email Link");
     link = createHelper.createHyperlink(Hyperlink.LINK_EMAIL);
     //note, if subject contains white spaces, make sure they are url-encoded
@@ -1654,9 +1648,9 @@ Examples:
 
     //create a target sheet and cell
     Sheet sheet2 = wb.createSheet("Target Sheet");
-    sheet2.createRow(0).createCell((short)0).setCellValue("Target Cell");
+    sheet2.createRow(0).createCell(0).setCellValue("Target Cell");
 
-    cell = sheet.createRow(3).createCell((short)0);
+    cell = sheet.createRow(3).createCell(0);
     cell.setCellValue("Worksheet Link");
     Hyperlink link2 = createHelper.createHyperlink(Hyperlink.LINK_DOCUMENT);
     link2.setAddress("'Target Sheet'!A1");



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org


Mime
View raw message