Modified: poi/trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java URL: http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java?rev=780878&r1=780877&r2=780878&view=diff ============================================================================== --- poi/trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java (original) +++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java Mon Jun 1 23:21:13 2009 @@ -1,219 +1,220 @@ -/* ==================================================================== - Licensed to the Apache Software Foundation (ASF) under one or more - contributor license agreements. See the NOTICE file distributed with - this work for additional information regarding copyright ownership. - The ASF licenses this file to You under the Apache License, Version 2.0 - (the "License"); you may not use this file except in compliance with - the License. You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - - Unless required by applicable law or agreed to in writing, software - distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the License for the specific language governing permissions and - limitations under the License. -==================================================================== */ -package org.apache.poi.ss.examples; - -import org.apache.poi.xssf.usermodel.*; -import org.apache.poi.ss.util.CellRangeAddress; -import org.apache.poi.ss.usermodel.*; -import org.apache.poi.hssf.usermodel.HSSFWorkbook; - -import java.util.Map; -import java.util.HashMap; -import java.io.FileOutputStream; - -/** - * A weekly timesheet created using Apache POI. - * Usage: - * TimesheetDemo -xls|xlsx - * - * @author Yegor Kozlov - */ -public class TimesheetDemo { - private static final String[] titles = { - "Person", "ID", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun", - "Total\nHrs", "Overtime\nHrs", "Regular\nHrs" - }; - - private static Object[][] sample_data = { - {"Yegor Kozlov", "YK", 5.0, 8.0, 10.0, 5.0, 5.0, 7.0, 6.0}, - {"Gisella Bronzetti", "GB", 4.0, 3.0, 1.0, 3.5, null, null, 4.0}, - }; - - public static void main(String[] args) throws Exception { - Workbook wb; - - if(args.length > 0 && args[0].equals("-xls")) wb = new HSSFWorkbook(); - else wb = new XSSFWorkbook(); - - Map<String, CellStyle> styles = createStyles(wb); - - Sheet sheet = wb.createSheet("Timesheet"); - PrintSetup printSetup = sheet.getPrintSetup(); - printSetup.setLandscape(true); - sheet.setFitToPage(true); - sheet.setHorizontallyCenter(true); - - //title row - Row titleRow = sheet.createRow(0); - titleRow.setHeightInPoints(45); - Cell titleCell = titleRow.createCell(0); - titleCell.setCellValue("Weekly Timesheet"); - titleCell.setCellStyle(styles.get("title")); - sheet.addMergedRegion(CellRangeAddress.valueOf("$A$1:$L$1")); - - //header row - Row headerRow = sheet.createRow(1); - headerRow.setHeightInPoints(40); - Cell headerCell; - for (int i = 0; i < titles.length; i++) { - headerCell = headerRow.createCell(i); - headerCell.setCellValue(titles[i]); - headerCell.setCellStyle(styles.get("header")); - } - - int rownum = 2; - for (int i = 0; i < 10; i++) { - Row row = sheet.createRow(rownum++); - for (int j = 0; j < titles.length; j++) { - Cell cell = row.createCell(j); - if(j == 9){ - //the 10th cell contains sum over week days, e.g. SUM(C3:I3) - String ref = "C" +rownum+ ":I" + rownum; - cell.setCellFormula("SUM("+ref+")"); - cell.setCellStyle(styles.get("formula")); - } else if (j == 11){ - cell.setCellFormula("J" +rownum+ "-K" + rownum); - cell.setCellStyle(styles.get("formula")); - } else { - cell.setCellStyle(styles.get("cell")); - } - } - } - - //row with totals below - Row sumRow = sheet.createRow(rownum++); - sumRow.setHeightInPoints(35); - Cell cell; - cell = sumRow.createCell(0); - cell.setCellStyle(styles.get("formula")); - cell = sumRow.createCell(1); - cell.setCellValue("Total Hrs:"); - cell.setCellStyle(styles.get("formula")); - - for (int j = 2; j < 12; j++) { - cell = sumRow.createCell(j); - String ref = (char)('A' + j) + "3:" + (char)('A' + j) + "12"; - cell.setCellFormula("SUM(" + ref + ")"); - if(j >= 9) cell.setCellStyle(styles.get("formula_2")); - else cell.setCellStyle(styles.get("formula")); - } - rownum++; - sumRow = sheet.createRow(rownum++); - sumRow.setHeightInPoints(25); - cell = sumRow.createCell(0); - cell.setCellValue("Total Regular Hours"); - cell.setCellStyle(styles.get("formula")); - cell = sumRow.createCell(1); - cell.setCellFormula("L13"); - cell.setCellStyle(styles.get("formula_2")); - sumRow = sheet.createRow(rownum++); - sumRow.setHeightInPoints(25); - cell = sumRow.createCell(0); - cell.setCellValue("Total Overtime Hours"); - cell.setCellStyle(styles.get("formula")); - cell = sumRow.createCell(1); - cell.setCellFormula("K13"); - cell.setCellStyle(styles.get("formula_2")); - - //set sample data - for (int i = 0; i < sample_data.length; i++) { - Row row = sheet.getRow(2 + i); - for (int j = 0; j < sample_data[i].length; j++) { - if(sample_data[i][j] == null) continue; - - if(sample_data[i][j] instanceof String) { - row.getCell(j).setCellValue((String)sample_data[i][j]); - } else { - row.getCell(j).setCellValue((Double)sample_data[i][j]); - } - } - } - - //finally set column widths, the width is measured in units of 1/256th of a character width - sheet.setColumnWidth(0, 30*256); //30 characters wide - for (int i = 2; i < 9; i++) { - sheet.setColumnWidth(i, 6*256); //6 characters wide - } - sheet.setColumnWidth(10, 10*256); //10 characters wide - - // Write the output to a file - String file = "timesheet.xls"; - if(wb instanceof XSSFWorkbook) file += "x"; - FileOutputStream out = new FileOutputStream(file); - wb.write(out); - out.close(); - } - - /** - * Create a library of cell styles - */ - private static Map<String, CellStyle> createStyles(Workbook wb){ - Map<String, CellStyle> styles = new HashMap<String, CellStyle>(); - CellStyle style; - Font titleFont = wb.createFont(); - titleFont.setFontHeightInPoints((short)18); - titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD); - style = wb.createCellStyle(); - style.setAlignment(CellStyle.ALIGN_CENTER); - style.setVerticalAlignment(CellStyle.VERTICAL_CENTER); - style.setFont(titleFont); - styles.put("title", style); - - Font monthFont = wb.createFont(); - monthFont.setFontHeightInPoints((short)11); - monthFont.setColor(IndexedColors.WHITE.getIndex()); - style = wb.createCellStyle(); - style.setAlignment(CellStyle.ALIGN_CENTER); - style.setVerticalAlignment(CellStyle.VERTICAL_CENTER); - style.setFillForegroundColor(IndexedColors.GREY_50_PERCENT.getIndex()); - style.setFillPattern(CellStyle.SOLID_FOREGROUND); - style.setFont(monthFont); - style.setWrapText(true); - styles.put("header", style); - - style = wb.createCellStyle(); - style.setAlignment(CellStyle.ALIGN_CENTER); - style.setWrapText(true); - style.setBorderRight(CellStyle.BORDER_THIN); - style.setRightBorderColor(IndexedColors.BLACK.getIndex()); - style.setBorderLeft(CellStyle.BORDER_THIN); - style.setLeftBorderColor(IndexedColors.BLACK.getIndex()); - style.setBorderTop(CellStyle.BORDER_THIN); - style.setTopBorderColor(IndexedColors.BLACK.getIndex()); - style.setBorderBottom(CellStyle.BORDER_THIN); - style.setBottomBorderColor(IndexedColors.BLACK.getIndex()); - styles.put("cell", style); - - style = wb.createCellStyle(); - style.setAlignment(CellStyle.ALIGN_CENTER); - style.setVerticalAlignment(CellStyle.VERTICAL_CENTER); - style.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); - style.setFillPattern(CellStyle.SOLID_FOREGROUND); - style.setDataFormat(wb.createDataFormat().getFormat("0.00")); - styles.put("formula", style); - - style = wb.createCellStyle(); - style.setAlignment(CellStyle.ALIGN_CENTER); - style.setVerticalAlignment(CellStyle.VERTICAL_CENTER); - style.setFillForegroundColor(IndexedColors.GREY_40_PERCENT.getIndex()); - style.setFillPattern(CellStyle.SOLID_FOREGROUND); - style.setDataFormat(wb.createDataFormat().getFormat("0.00")); - styles.put("formula_2", style); - - return styles; - } -} +/* ==================================================================== + Licensed to the Apache Software Foundation (ASF) under one or more + contributor license agreements. See the NOTICE file distributed with + this work for additional information regarding copyright ownership. + The ASF licenses this file to You under the Apache License, Version 2.0 + (the "License"); you may not use this file except in compliance with + the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. +==================================================================== */ + +package org.apache.poi.ss.examples; + +import org.apache.poi.xssf.usermodel.*; +import org.apache.poi.ss.util.CellRangeAddress; +import org.apache.poi.ss.usermodel.*; +import org.apache.poi.hssf.usermodel.HSSFWorkbook; + +import java.util.Map; +import java.util.HashMap; +import java.io.FileOutputStream; + +/** + * A weekly timesheet created using Apache POI. + * Usage: + * TimesheetDemo -xls|xlsx + * + * @author Yegor Kozlov + */ +public class TimesheetDemo { + private static final String[] titles = { + "Person", "ID", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun", + "Total\nHrs", "Overtime\nHrs", "Regular\nHrs" + }; + + private static Object[][] sample_data = { + {"Yegor Kozlov", "YK", 5.0, 8.0, 10.0, 5.0, 5.0, 7.0, 6.0}, + {"Gisella Bronzetti", "GB", 4.0, 3.0, 1.0, 3.5, null, null, 4.0}, + }; + + public static void main(String[] args) throws Exception { + Workbook wb; + + if(args.length > 0 && args[0].equals("-xls")) wb = new HSSFWorkbook(); + else wb = new XSSFWorkbook(); + + Map<String, CellStyle> styles = createStyles(wb); + + Sheet sheet = wb.createSheet("Timesheet"); + PrintSetup printSetup = sheet.getPrintSetup(); + printSetup.setLandscape(true); + sheet.setFitToPage(true); + sheet.setHorizontallyCenter(true); + + //title row + Row titleRow = sheet.createRow(0); + titleRow.setHeightInPoints(45); + Cell titleCell = titleRow.createCell(0); + titleCell.setCellValue("Weekly Timesheet"); + titleCell.setCellStyle(styles.get("title")); + sheet.addMergedRegion(CellRangeAddress.valueOf("$A$1:$L$1")); + + //header row + Row headerRow = sheet.createRow(1); + headerRow.setHeightInPoints(40); + Cell headerCell; + for (int i = 0; i < titles.length; i++) { + headerCell = headerRow.createCell(i); + headerCell.setCellValue(titles[i]); + headerCell.setCellStyle(styles.get("header")); + } + + int rownum = 2; + for (int i = 0; i < 10; i++) { + Row row = sheet.createRow(rownum++); + for (int j = 0; j < titles.length; j++) { + Cell cell = row.createCell(j); + if(j == 9){ + //the 10th cell contains sum over week days, e.g. SUM(C3:I3) + String ref = "C" +rownum+ ":I" + rownum; + cell.setCellFormula("SUM("+ref+")"); + cell.setCellStyle(styles.get("formula")); + } else if (j == 11){ + cell.setCellFormula("J" +rownum+ "-K" + rownum); + cell.setCellStyle(styles.get("formula")); + } else { + cell.setCellStyle(styles.get("cell")); + } + } + } + + //row with totals below + Row sumRow = sheet.createRow(rownum++); + sumRow.setHeightInPoints(35); + Cell cell; + cell = sumRow.createCell(0); + cell.setCellStyle(styles.get("formula")); + cell = sumRow.createCell(1); + cell.setCellValue("Total Hrs:"); + cell.setCellStyle(styles.get("formula")); + + for (int j = 2; j < 12; j++) { + cell = sumRow.createCell(j); + String ref = (char)('A' + j) + "3:" + (char)('A' + j) + "12"; + cell.setCellFormula("SUM(" + ref + ")"); + if(j >= 9) cell.setCellStyle(styles.get("formula_2")); + else cell.setCellStyle(styles.get("formula")); + } + rownum++; + sumRow = sheet.createRow(rownum++); + sumRow.setHeightInPoints(25); + cell = sumRow.createCell(0); + cell.setCellValue("Total Regular Hours"); + cell.setCellStyle(styles.get("formula")); + cell = sumRow.createCell(1); + cell.setCellFormula("L13"); + cell.setCellStyle(styles.get("formula_2")); + sumRow = sheet.createRow(rownum++); + sumRow.setHeightInPoints(25); + cell = sumRow.createCell(0); + cell.setCellValue("Total Overtime Hours"); + cell.setCellStyle(styles.get("formula")); + cell = sumRow.createCell(1); + cell.setCellFormula("K13"); + cell.setCellStyle(styles.get("formula_2")); + + //set sample data + for (int i = 0; i < sample_data.length; i++) { + Row row = sheet.getRow(2 + i); + for (int j = 0; j < sample_data[i].length; j++) { + if(sample_data[i][j] == null) continue; + + if(sample_data[i][j] instanceof String) { + row.getCell(j).setCellValue((String)sample_data[i][j]); + } else { + row.getCell(j).setCellValue((Double)sample_data[i][j]); + } + } + } + + //finally set column widths, the width is measured in units of 1/256th of a character width + sheet.setColumnWidth(0, 30*256); //30 characters wide + for (int i = 2; i < 9; i++) { + sheet.setColumnWidth(i, 6*256); //6 characters wide + } + sheet.setColumnWidth(10, 10*256); //10 characters wide + + // Write the output to a file + String file = "timesheet.xls"; + if(wb instanceof XSSFWorkbook) file += "x"; + FileOutputStream out = new FileOutputStream(file); + wb.write(out); + out.close(); + } + + /** + * Create a library of cell styles + */ + private static Map<String, CellStyle> createStyles(Workbook wb){ + Map<String, CellStyle> styles = new HashMap<String, CellStyle>(); + CellStyle style; + Font titleFont = wb.createFont(); + titleFont.setFontHeightInPoints((short)18); + titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD); + style = wb.createCellStyle(); + style.setAlignment(CellStyle.ALIGN_CENTER); + style.setVerticalAlignment(CellStyle.VERTICAL_CENTER); + style.setFont(titleFont); + styles.put("title", style); + + Font monthFont = wb.createFont(); + monthFont.setFontHeightInPoints((short)11); + monthFont.setColor(IndexedColors.WHITE.getIndex()); + style = wb.createCellStyle(); + style.setAlignment(CellStyle.ALIGN_CENTER); + style.setVerticalAlignment(CellStyle.VERTICAL_CENTER); + style.setFillForegroundColor(IndexedColors.GREY_50_PERCENT.getIndex()); + style.setFillPattern(CellStyle.SOLID_FOREGROUND); + style.setFont(monthFont); + style.setWrapText(true); + styles.put("header", style); + + style = wb.createCellStyle(); + style.setAlignment(CellStyle.ALIGN_CENTER); + style.setWrapText(true); + style.setBorderRight(CellStyle.BORDER_THIN); + style.setRightBorderColor(IndexedColors.BLACK.getIndex()); + style.setBorderLeft(CellStyle.BORDER_THIN); + style.setLeftBorderColor(IndexedColors.BLACK.getIndex()); + style.setBorderTop(CellStyle.BORDER_THIN); + style.setTopBorderColor(IndexedColors.BLACK.getIndex()); + style.setBorderBottom(CellStyle.BORDER_THIN); + style.setBottomBorderColor(IndexedColors.BLACK.getIndex()); + styles.put("cell", style); + + style = wb.createCellStyle(); + style.setAlignment(CellStyle.ALIGN_CENTER); + style.setVerticalAlignment(CellStyle.VERTICAL_CENTER); + style.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); + style.setFillPattern(CellStyle.SOLID_FOREGROUND); + style.setDataFormat(wb.createDataFormat().getFormat("0.00")); + styles.put("formula", style); + + style = wb.createCellStyle(); + style.setAlignment(CellStyle.ALIGN_CENTER); + style.setVerticalAlignment(CellStyle.VERTICAL_CENTER); + style.setFillForegroundColor(IndexedColors.GREY_40_PERCENT.getIndex()); + style.setFillPattern(CellStyle.SOLID_FOREGROUND); + style.setDataFormat(wb.createDataFormat().getFormat("0.00")); + styles.put("formula_2", style); + + return styles; + } +}
Modified: poi/trunk/src/java/org/apache/poi/ss/formula/package.html URL: http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/formula/package.html?rev=780878&r1=780877&r2=780878&view=diff ============================================================================== --- poi/trunk/src/java/org/apache/poi/ss/formula/package.html (original) +++ poi/trunk/src/java/org/apache/poi/ss/formula/package.html Mon Jun 1 23:21:13 2009 @@ -1,29 +1,29 @@ -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> -<!-- - ==================================================================== - Licensed to the Apache Software Foundation (ASF) under one or more - contributor license agreements. See the NOTICE file distributed with - this work for additional information regarding copyright ownership. - The ASF licenses this file to You under the Apache License, Version 2.0 - (the "License"); you may not use this file except in compliance with - the License. You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - - Unless required by applicable law or agreed to in writing, software - distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the License for the specific language governing permissions and - limitations under the License. - ==================================================================== ---> -<html> -<head> -</head> -<body bgcolor="white"> - -This package contains common internal POI code for manipulating formulas. -Client applications should not refer to these classes directly. - -</body> -</html> +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> +<!-- + ==================================================================== + Licensed to the Apache Software Foundation (ASF) under one or more + contributor license agreements. See the NOTICE file distributed with + this work for additional information regarding copyright ownership. + The ASF licenses this file to You under the Apache License, Version 2.0 + (the "License"); you may not use this file except in compliance with + the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. + ==================================================================== +--> +<html> +<head> +</head> +<body bgcolor="white"> + +This package contains common internal POI code for manipulating formulas. +Client applications should not refer to these classes directly. + +</body> +</html> Modified: poi/trunk/src/resources/main/org/apache/poi/hssf/record/formula/function/functionMetadata-asGenerated.txt URL: http://svn.apache.org/viewvc/poi/trunk/src/resources/main/org/apache/poi/hssf/record/formula/function/functionMetadata-asGenerated.txt?rev=780878&r1=780877&r2=780878&view=diff ============================================================================== --- poi/trunk/src/resources/main/org/apache/poi/hssf/record/formula/function/functionMetadata-asGenerated.txt (original) +++ poi/trunk/src/resources/main/org/apache/poi/hssf/record/formula/function/functionMetadata-asGenerated.txt Mon Jun 1 23:21:13 2009 @@ -1,285 +1,285 @@ -# Licensed to the Apache Software Foundation (ASF) under one or more -# contributor license agreements. See the NOTICE file distributed with -# this work for additional information regarding copyright ownership. -# The ASF licenses this file to You under the Apache License, Version 2.0 -# (the "License"); you may not use this file except in compliance with -# the License. You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. - -# Created by (org.apache.poi.hssf.record.formula.function.ExcelFileFormatDocFunctionExtractor) -# from source file 'excelfileformat.odt' (size=356107, md5=0x8f789cb6e75594caf068f8e193004ef4) -# -#Columns: (index, name, minParams, maxParams, returnClass, paramClasses, isVolatile, hasFootnote ) - -# Built-In Sheet Functions in BIFF2 -0 COUNT 0 30 V R -1 IF 2 3 R V R R -2 ISNA 1 1 V V -3 ISERROR 1 1 V V -4 SUM 0 30 V R -5 AVERAGE 1 30 V R -6 MIN 1 30 V R -7 MAX 1 30 V R -8 ROW 0 1 V R -9 COLUMN 0 1 V R -10 NA 0 0 V - -11 NPV 2 30 V V R -12 STDEV 1 30 V R -13 DOLLAR 1 2 V V V -14 FIXED 2 2 V V V x -15 SIN 1 1 V V -16 COS 1 1 V V -17 TAN 1 1 V V -18 ATAN 1 1 V V -19 PI 0 0 V - -20 SQRT 1 1 V V -21 EXP 1 1 V V -22 LN 1 1 V V -23 LOG10 1 1 V V -24 ABS 1 1 V V -25 INT 1 1 V V -26 SIGN 1 1 V V -27 ROUND 2 2 V V V -28 LOOKUP 2 3 V V R R -29 INDEX 2 4 R R V V V -30 REPT 2 2 V V V -31 MID 3 3 V V V V -32 LEN 1 1 V V -33 VALUE 1 1 V V -34 TRUE 0 0 V - -35 FALSE 0 0 V - -36 AND 1 30 V R -37 OR 1 30 V R -38 NOT 1 1 V V -39 MOD 2 2 V V V -40 DCOUNT 3 3 V R R R -41 DSUM 3 3 V R R R -42 DAVERAGE 3 3 V R R R -43 DMIN 3 3 V R R R -44 DMAX 3 3 V R R R -45 DSTDEV 3 3 V R R R -46 VAR 1 30 V R -47 DVAR 3 3 V R R R -48 TEXT 2 2 V V V -49 LINEST 1 2 A R R x -50 TREND 1 3 A R R R x -51 LOGEST 1 2 A R R x -52 GROWTH 1 3 A R R R x -56 PV 3 5 V V V V V V -# Built-In Sheet Functions in BIFF2 -57 FV 3 5 V V V V V V -58 NPER 3 5 V V V V V V -59 PMT 3 5 V V V V V V -60 RATE 3 6 V V V V V V V -61 MIRR 3 3 V R V V -62 IRR 1 2 V R V -63 RAND 0 0 V - x -64 MATCH 2 3 V V R R -65 DATE 3 3 V V V V -66 TIME 3 3 V V V V -67 DAY 1 1 V V -68 MONTH 1 1 V V -69 YEAR 1 1 V V -70 WEEKDAY 1 1 V V x -71 HOUR 1 1 V V -72 MINUTE 1 1 V V -73 SECOND 1 1 V V -74 NOW 0 0 V - x -75 AREAS 1 1 V R -76 ROWS 1 1 V R -77 COLUMNS 1 1 V R -78 OFFSET 3 5 R R V V V V x -82 SEARCH 2 3 V V V V -83 TRANSPOSE 1 1 A A -86 TYPE 1 1 V V -97 ATAN2 2 2 V V V -98 ASIN 1 1 V V -99 ACOS 1 1 V V -100 CHOOSE 2 30 R V R -101 HLOOKUP 3 3 V V R R x -102 VLOOKUP 3 3 V V R R x -105 ISREF 1 1 V R -109 LOG 1 2 V V V -111 CHAR 1 1 V V -112 LOWER 1 1 V V -113 UPPER 1 1 V V -114 PROPER 1 1 V V -115 LEFT 1 2 V V V -116 RIGHT 1 2 V V V -117 EXACT 2 2 V V V -118 TRIM 1 1 V V -119 REPLACE 4 4 V V V V V -120 SUBSTITUTE 3 4 V V V V V -121 CODE 1 1 V V -124 FIND 2 3 V V V V -125 CELL 1 2 V V R x -126 ISERR 1 1 V V -127 ISTEXT 1 1 V V -128 ISNUMBER 1 1 V V -129 ISBLANK 1 1 V V -130 T 1 1 V R -131 N 1 1 V R -140 DATEVALUE 1 1 V V -141 TIMEVALUE 1 1 V V -142 SLN 3 3 V V V V -143 SYD 4 4 V V V V V -144 DDB 4 5 V V V V V V -148 INDIRECT 1 2 R V V x -162 CLEAN 1 1 V V -163 MDETERM 1 1 V A -164 MINVERSE 1 1 A A -165 MMULT 2 2 A A A -167 IPMT 4 6 V V V V V V V -168 PPMT 4 6 V V V V V V V -169 COUNTA 0 30 V R -183 PRODUCT 0 30 V R -184 FACT 1 1 V V -189 DPRODUCT 3 3 V R R R -190 ISNONTEXT 1 1 V V -193 STDEVP 1 30 V R -194 VARP 1 30 V R -195 DSTDEVP 3 3 V R R R -196 DVARP 3 3 V R R R -197 TRUNC 1 1 V V x -198 ISLOGICAL 1 1 V V -199 DCOUNTA 3 3 V R R R -# New Built-In Sheet Functions in BIFF3 -49 LINEST 1 4 A R R V V x -50 TREND 1 4 A R R R V x -51 LOGEST 1 4 A R R V V x -52 GROWTH 1 4 A R R R V x -197 TRUNC 1 2 V V V x -204 YEN 1 2 V V V x -205 FINDB 2 3 V V V V -206 SEARCHB 2 3 V V V V -207 REPLACEB 4 4 V V V V V -208 LEFTB 1 2 V V V -209 RIGHTB 1 2 V V V -210 MIDB 3 3 V V V V -211 LENB 1 1 V V -212 ROUNDUP 2 2 V V V -213 ROUNDDOWN 2 2 V V V -214 ASC 1 1 V V -215 JIS 1 1 V V x -219 ADDRESS 2 5 V V V V V V -220 DAYS360 2 2 V V V x -221 TODAY 0 0 V - x -222 VDB 5 7 V V V V V V V V -227 MEDIAN 1 30 V R ... -228 SUMPRODUCT 1 30 V A ... -229 SINH 1 1 V V -230 COSH 1 1 V V -231 TANH 1 1 V V -232 ASINH 1 1 V V -233 ACOSH 1 1 V V -234 ATANH 1 1 V V -235 DGET 3 3 V R R R -244 INFO 1 1 V V -# New Built-In Sheet Functions in BIFF4 -14 FIXED 2 3 V V V V x -204 USDOLLAR 1 2 V V V x -215 DBCS 1 1 V V x -216 RANK 2 3 V V R V -247 DB 4 5 V V V V V V -252 FREQUENCY 2 2 A R R -261 ERROR.TYPE 1 1 V V -269 AVEDEV 1 30 V R ... -270 BETADIST 3 5 V V V V V V -271 GAMMALN 1 1 V V -272 BETAINV 3 5 V V V V V V -273 BINOMDIST 4 4 V V V V V -274 CHIDIST 2 2 V V V -275 CHIINV 2 2 V V V -276 COMBIN 2 2 V V V -277 CONFIDENCE 3 3 V V V V -278 CRITBINOM 3 3 V V V V -279 EVEN 1 1 V V -280 EXPONDIST 3 3 V V V V -281 FDIST 3 3 V V V V -282 FINV 3 3 V V V V -283 FISHER 1 1 V V -284 FISHERINV 1 1 V V -285 FLOOR 2 2 V V V -286 GAMMADIST 4 4 V V V V V -287 GAMMAINV 3 3 V V V V -288 CEILING 2 2 V V V -289 HYPGEOMDIST 4 4 V V V V V -290 LOGNORMDIST 3 3 V V V V -291 LOGINV 3 3 V V V V -292 NEGBINOMDIST 3 3 V V V V -293 NORMDIST 4 4 V V V V V -294 NORMSDIST 1 1 V V -295 NORMINV 3 3 V V V V -296 NORMSINV 1 1 V V -297 STANDARDIZE 3 3 V V V V -298 ODD 1 1 V V -299 PERMUT 2 2 V V V -300 POISSON 3 3 V V V V -301 TDIST 3 3 V V V V -302 WEIBULL 4 4 V V V V V -303 SUMXMY2 2 2 V A A -304 SUMX2MY2 2 2 V A A -305 SUMX2PY2 2 2 V A A -306 CHITEST 2 2 V A A -307 CORREL 2 2 V A A -308 COVAR 2 2 V A A -309 FORECAST 3 3 V V A A -310 FTEST 2 2 V A A -311 INTERCEPT 2 2 V A A -312 PEARSON 2 2 V A A -313 RSQ 2 2 V A A -314 STEYX 2 2 V A A -315 SLOPE 2 2 V A A -316 TTEST 4 4 V A A V V -317 PROB 3 4 V A A V V -318 DEVSQ 1 30 V R ... -319 GEOMEAN 1 30 V R ... -320 HARMEAN 1 30 V R ... -321 SUMSQ 0 30 V R ... -322 KURT 1 30 V R ... -323 SKEW 1 30 V R ... -324 ZTEST 2 3 V R V V -325 LARGE 2 2 V R V -326 SMALL 2 2 V R V -327 QUARTILE 2 2 V R V -328 PERCENTILE 2 2 V R V -329 PERCENTRANK 2 3 V R V V -330 MODE 1 30 V A -331 TRIMMEAN 2 2 V R V -332 TINV 2 2 V V V -# New Built-In Sheet Functions in BIFF5 -70 WEEKDAY 1 2 V V V x -101 HLOOKUP 3 4 V V R R V x -102 VLOOKUP 3 4 V V R R V x -220 DAYS360 2 3 V V V V x -336 CONCATENATE 0 30 V V -337 POWER 2 2 V V V -342 RADIANS 1 1 V V -343 DEGREES 1 1 V V -344 SUBTOTAL 2 30 V V R -345 SUMIF 2 3 V R V R -346 COUNTIF 2 2 V R V -347 COUNTBLANK 1 1 V R -350 ISPMT 4 4 V V V V V -351 DATEDIF 3 3 V V V V -352 DATESTRING 1 1 V V -353 NUMBERSTRING 2 2 V V V -354 ROMAN 1 2 V V V -# New Built-In Sheet Functions in BIFF8 -358 GETPIVOTDATA 2 30 -359 HYPERLINK 1 2 V V V -360 PHONETIC 1 1 V R -361 AVERAGEA 1 30 V R ... -362 MAXA 1 30 V R ... -363 MINA 1 30 V R ... -364 STDEVPA 1 30 V R ... -365 VARPA 1 30 V R ... -366 STDEVA 1 30 V R ... -367 VARA 1 30 V R ... +# Licensed to the Apache Software Foundation (ASF) under one or more +# contributor license agreements. See the NOTICE file distributed with +# this work for additional information regarding copyright ownership. +# The ASF licenses this file to You under the Apache License, Version 2.0 +# (the "License"); you may not use this file except in compliance with +# the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, software +# distributed under the License is distributed on an "AS IS" BASIS, +# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +# See the License for the specific language governing permissions and +# limitations under the License. + +# Created by (org.apache.poi.hssf.record.formula.function.ExcelFileFormatDocFunctionExtractor) +# from source file 'excelfileformat.odt' (size=356107, md5=0x8f789cb6e75594caf068f8e193004ef4) +# +#Columns: (index, name, minParams, maxParams, returnClass, paramClasses, isVolatile, hasFootnote ) + +# Built-In Sheet Functions in BIFF2 +0 COUNT 0 30 V R +1 IF 2 3 R V R R +2 ISNA 1 1 V V +3 ISERROR 1 1 V V +4 SUM 0 30 V R +5 AVERAGE 1 30 V R +6 MIN 1 30 V R +7 MAX 1 30 V R +8 ROW 0 1 V R +9 COLUMN 0 1 V R +10 NA 0 0 V - +11 NPV 2 30 V V R +12 STDEV 1 30 V R +13 DOLLAR 1 2 V V V +14 FIXED 2 2 V V V x +15 SIN 1 1 V V +16 COS 1 1 V V +17 TAN 1 1 V V +18 ATAN 1 1 V V +19 PI 0 0 V - +20 SQRT 1 1 V V +21 EXP 1 1 V V +22 LN 1 1 V V +23 LOG10 1 1 V V +24 ABS 1 1 V V +25 INT 1 1 V V +26 SIGN 1 1 V V +27 ROUND 2 2 V V V +28 LOOKUP 2 3 V V R R +29 INDEX 2 4 R R V V V +30 REPT 2 2 V V V +31 MID 3 3 V V V V +32 LEN 1 1 V V +33 VALUE 1 1 V V +34 TRUE 0 0 V - +35 FALSE 0 0 V - +36 AND 1 30 V R +37 OR 1 30 V R +38 NOT 1 1 V V +39 MOD 2 2 V V V +40 DCOUNT 3 3 V R R R +41 DSUM 3 3 V R R R +42 DAVERAGE 3 3 V R R R +43 DMIN 3 3 V R R R +44 DMAX 3 3 V R R R +45 DSTDEV 3 3 V R R R +46 VAR 1 30 V R +47 DVAR 3 3 V R R R +48 TEXT 2 2 V V V +49 LINEST 1 2 A R R x +50 TREND 1 3 A R R R x +51 LOGEST 1 2 A R R x +52 GROWTH 1 3 A R R R x +56 PV 3 5 V V V V V V +# Built-In Sheet Functions in BIFF2 +57 FV 3 5 V V V V V V +58 NPER 3 5 V V V V V V +59 PMT 3 5 V V V V V V +60 RATE 3 6 V V V V V V V +61 MIRR 3 3 V R V V +62 IRR 1 2 V R V +63 RAND 0 0 V - x +64 MATCH 2 3 V V R R +65 DATE 3 3 V V V V +66 TIME 3 3 V V V V +67 DAY 1 1 V V +68 MONTH 1 1 V V +69 YEAR 1 1 V V +70 WEEKDAY 1 1 V V x +71 HOUR 1 1 V V +72 MINUTE 1 1 V V +73 SECOND 1 1 V V +74 NOW 0 0 V - x +75 AREAS 1 1 V R +76 ROWS 1 1 V R +77 COLUMNS 1 1 V R +78 OFFSET 3 5 R R V V V V x +82 SEARCH 2 3 V V V V +83 TRANSPOSE 1 1 A A +86 TYPE 1 1 V V +97 ATAN2 2 2 V V V +98 ASIN 1 1 V V +99 ACOS 1 1 V V +100 CHOOSE 2 30 R V R +101 HLOOKUP 3 3 V V R R x +102 VLOOKUP 3 3 V V R R x +105 ISREF 1 1 V R +109 LOG 1 2 V V V +111 CHAR 1 1 V V +112 LOWER 1 1 V V +113 UPPER 1 1 V V +114 PROPER 1 1 V V +115 LEFT 1 2 V V V +116 RIGHT 1 2 V V V +117 EXACT 2 2 V V V +118 TRIM 1 1 V V +119 REPLACE 4 4 V V V V V +120 SUBSTITUTE 3 4 V V V V V +121 CODE 1 1 V V +124 FIND 2 3 V V V V +125 CELL 1 2 V V R x +126 ISERR 1 1 V V +127 ISTEXT 1 1 V V +128 ISNUMBER 1 1 V V +129 ISBLANK 1 1 V V +130 T 1 1 V R +131 N 1 1 V R +140 DATEVALUE 1 1 V V +141 TIMEVALUE 1 1 V V +142 SLN 3 3 V V V V +143 SYD 4 4 V V V V V +144 DDB 4 5 V V V V V V +148 INDIRECT 1 2 R V V x +162 CLEAN 1 1 V V +163 MDETERM 1 1 V A +164 MINVERSE 1 1 A A +165 MMULT 2 2 A A A +167 IPMT 4 6 V V V V V V V +168 PPMT 4 6 V V V V V V V +169 COUNTA 0 30 V R +183 PRODUCT 0 30 V R +184 FACT 1 1 V V +189 DPRODUCT 3 3 V R R R +190 ISNONTEXT 1 1 V V +193 STDEVP 1 30 V R +194 VARP 1 30 V R +195 DSTDEVP 3 3 V R R R +196 DVARP 3 3 V R R R +197 TRUNC 1 1 V V x +198 ISLOGICAL 1 1 V V +199 DCOUNTA 3 3 V R R R +# New Built-In Sheet Functions in BIFF3 +49 LINEST 1 4 A R R V V x +50 TREND 1 4 A R R R V x +51 LOGEST 1 4 A R R V V x +52 GROWTH 1 4 A R R R V x +197 TRUNC 1 2 V V V x +204 YEN 1 2 V V V x +205 FINDB 2 3 V V V V +206 SEARCHB 2 3 V V V V +207 REPLACEB 4 4 V V V V V +208 LEFTB 1 2 V V V +209 RIGHTB 1 2 V V V +210 MIDB 3 3 V V V V +211 LENB 1 1 V V +212 ROUNDUP 2 2 V V V +213 ROUNDDOWN 2 2 V V V +214 ASC 1 1 V V +215 JIS 1 1 V V x +219 ADDRESS 2 5 V V V V V V +220 DAYS360 2 2 V V V x +221 TODAY 0 0 V - x +222 VDB 5 7 V V V V V V V V +227 MEDIAN 1 30 V R ... +228 SUMPRODUCT 1 30 V A ... +229 SINH 1 1 V V +230 COSH 1 1 V V +231 TANH 1 1 V V +232 ASINH 1 1 V V +233 ACOSH 1 1 V V +234 ATANH 1 1 V V +235 DGET 3 3 V R R R +244 INFO 1 1 V V +# New Built-In Sheet Functions in BIFF4 +14 FIXED 2 3 V V V V x +204 USDOLLAR 1 2 V V V x +215 DBCS 1 1 V V x +216 RANK 2 3 V V R V +247 DB 4 5 V V V V V V +252 FREQUENCY 2 2 A R R +261 ERROR.TYPE 1 1 V V +269 AVEDEV 1 30 V R ... +270 BETADIST 3 5 V V V V V V +271 GAMMALN 1 1 V V +272 BETAINV 3 5 V V V V V V +273 BINOMDIST 4 4 V V V V V +274 CHIDIST 2 2 V V V +275 CHIINV 2 2 V V V +276 COMBIN 2 2 V V V +277 CONFIDENCE 3 3 V V V V +278 CRITBINOM 3 3 V V V V +279 EVEN 1 1 V V +280 EXPONDIST 3 3 V V V V +281 FDIST 3 3 V V V V +282 FINV 3 3 V V V V +283 FISHER 1 1 V V +284 FISHERINV 1 1 V V +285 FLOOR 2 2 V V V +286 GAMMADIST 4 4 V V V V V +287 GAMMAINV 3 3 V V V V +288 CEILING 2 2 V V V +289 HYPGEOMDIST 4 4 V V V V V +290 LOGNORMDIST 3 3 V V V V +291 LOGINV 3 3 V V V V +292 NEGBINOMDIST 3 3 V V V V +293 NORMDIST 4 4 V V V V V +294 NORMSDIST 1 1 V V +295 NORMINV 3 3 V V V V +296 NORMSINV 1 1 V V +297 STANDARDIZE 3 3 V V V V +298 ODD 1 1 V V +299 PERMUT 2 2 V V V +300 POISSON 3 3 V V V V +301 TDIST 3 3 V V V V +302 WEIBULL 4 4 V V V V V +303 SUMXMY2 2 2 V A A +304 SUMX2MY2 2 2 V A A +305 SUMX2PY2 2 2 V A A +306 CHITEST 2 2 V A A +307 CORREL 2 2 V A A +308 COVAR 2 2 V A A +309 FORECAST 3 3 V V A A +310 FTEST 2 2 V A A +311 INTERCEPT 2 2 V A A +312 PEARSON 2 2 V A A +313 RSQ 2 2 V A A +314 STEYX 2 2 V A A +315 SLOPE 2 2 V A A +316 TTEST 4 4 V A A V V +317 PROB 3 4 V A A V V +318 DEVSQ 1 30 V R ... +319 GEOMEAN 1 30 V R ... +320 HARMEAN 1 30 V R ... +321 SUMSQ 0 30 V R ... +322 KURT 1 30 V R ... +323 SKEW 1 30 V R ... +324 ZTEST 2 3 V R V V +325 LARGE 2 2 V R V +326 SMALL 2 2 V R V +327 QUARTILE 2 2 V R V +328 PERCENTILE 2 2 V R V +329 PERCENTRANK 2 3 V R V V +330 MODE 1 30 V A +331 TRIMMEAN 2 2 V R V +332 TINV 2 2 V V V +# New Built-In Sheet Functions in BIFF5 +70 WEEKDAY 1 2 V V V x +101 HLOOKUP 3 4 V V R R V x +102 VLOOKUP 3 4 V V R R V x +220 DAYS360 2 3 V V V V x +336 CONCATENATE 0 30 V V +337 POWER 2 2 V V V +342 RADIANS 1 1 V V +343 DEGREES 1 1 V V +344 SUBTOTAL 2 30 V V R +345 SUMIF 2 3 V R V R +346 COUNTIF 2 2 V R V +347 COUNTBLANK 1 1 V R +350 ISPMT 4 4 V V V V V +351 DATEDIF 3 3 V V V V +352 DATESTRING 1 1 V V +353 NUMBERSTRING 2 2 V V V +354 ROMAN 1 2 V V V +# New Built-In Sheet Functions in BIFF8 +358 GETPIVOTDATA 2 30 +359 HYPERLINK 1 2 V V V +360 PHONETIC 1 1 V R +361 AVERAGEA 1 30 V R ... +362 MAXA 1 30 V R ... +363 MINA 1 30 V R ... +364 STDEVPA 1 30 V R ... +365 VARPA 1 30 V R ... +366 STDEVA 1 30 V R ... +367 VARA 1 30 V R ... Modified: poi/trunk/src/resources/main/org/apache/poi/hssf/record/formula/function/functionMetadata.txt URL: http://svn.apache.org/viewvc/poi/trunk/src/resources/main/org/apache/poi/hssf/record/formula/function/functionMetadata.txt?rev=780878&r1=780877&r2=780878&view=diff ============================================================================== --- poi/trunk/src/resources/main/org/apache/poi/hssf/record/formula/function/functionMetadata.txt (original) +++ poi/trunk/src/resources/main/org/apache/poi/hssf/record/formula/function/functionMetadata.txt Mon Jun 1 23:21:13 2009 @@ -1,286 +1,286 @@ -# Licensed to the Apache Software Foundation (ASF) under one or more -# contributor license agreements. See the NOTICE file distributed with -# this work for additional information regarding copyright ownership. -# The ASF licenses this file to You under the Apache License, Version 2.0 -# (the "License"); you may not use this file except in compliance with -# the License. You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. - -# Created by (org.apache.poi.hssf.record.formula.function.ExcelFileFormatDocFunctionExtractor) -# from source file 'excelfileformat.odt' (size=356107, md5=0x8f789cb6e75594caf068f8e193004ef4) -# ! + some manual edits ! -# -#Columns: (index, name, minParams, maxParams, returnClass, paramClasses, isVolatile, hasFootnote ) - -# Built-In Sheet Functions in BIFF2 -0 COUNT 0 30 V R -1 IF 2 3 R V R R -2 ISNA 1 1 V V -3 ISERROR 1 1 V V -4 SUM 0 30 V R -5 AVERAGE 1 30 V R -6 MIN 1 30 V R -7 MAX 1 30 V R -8 ROW 0 1 V R -9 COLUMN 0 1 V R -10 NA 0 0 V - -11 NPV 2 30 V V R -12 STDEV 1 30 V R -13 DOLLAR 1 2 V V V -14 FIXED 2 2 V V V x -15 SIN 1 1 V V -16 COS 1 1 V V -17 TAN 1 1 V V -18 ATAN 1 1 V V -19 PI 0 0 V - -20 SQRT 1 1 V V -21 EXP 1 1 V V -22 LN 1 1 V V -23 LOG10 1 1 V V -24 ABS 1 1 V V -25 INT 1 1 V V -26 SIGN 1 1 V V -27 ROUND 2 2 V V V -28 LOOKUP 2 3 V V R R -29 INDEX 2 4 R R V V V -30 REPT 2 2 V V V -31 MID 3 3 V V V V -32 LEN 1 1 V V -33 VALUE 1 1 V V -34 TRUE 0 0 V - -35 FALSE 0 0 V - -36 AND 1 30 V R -37 OR 1 30 V R -38 NOT 1 1 V V -39 MOD 2 2 V V V -40 DCOUNT 3 3 V R R R -41 DSUM 3 3 V R R R -42 DAVERAGE 3 3 V R R R -43 DMIN 3 3 V R R R -44 DMAX 3 3 V R R R -45 DSTDEV 3 3 V R R R -46 VAR 1 30 V R -47 DVAR 3 3 V R R R -48 TEXT 2 2 V V V -49 LINEST 1 2 A R R x -50 TREND 1 3 A R R R x -51 LOGEST 1 2 A R R x -52 GROWTH 1 3 A R R R x -56 PV 3 5 V V V V V V -# Built-In Sheet Functions in BIFF2 -57 FV 3 5 V V V V V V -58 NPER 3 5 V V V V V V -59 PMT 3 5 V V V V V V -60 RATE 3 6 V V V V V V V -61 MIRR 3 3 V A V V -62 IRR 1 2 V A V -63 RAND 0 0 V - x -64 MATCH 2 3 V V R R -65 DATE 3 3 V V V V -66 TIME 3 3 V V V V -67 DAY 1 1 V V -68 MONTH 1 1 V V -69 YEAR 1 1 V V -70 WEEKDAY 1 1 V V x -71 HOUR 1 1 V V -72 MINUTE 1 1 V V -73 SECOND 1 1 V V -74 NOW 0 0 V - x -75 AREAS 1 1 V R -76 ROWS 1 1 V A -77 COLUMNS 1 1 V A -78 OFFSET 3 5 R R V V V V x -82 SEARCH 2 3 V V V V -83 TRANSPOSE 1 1 A A -86 TYPE 1 1 V V -97 ATAN2 2 2 V V V -98 ASIN 1 1 V V -99 ACOS 1 1 V V -100 CHOOSE 2 30 R V R -101 HLOOKUP 3 3 V V R R x -102 VLOOKUP 3 3 V V R R x -105 ISREF 1 1 V R -109 LOG 1 2 V V V -111 CHAR 1 1 V V -112 LOWER 1 1 V V -113 UPPER 1 1 V V -114 PROPER 1 1 V V -115 LEFT 1 2 V V V -116 RIGHT 1 2 V V V -117 EXACT 2 2 V V V -118 TRIM 1 1 V V -119 REPLACE 4 4 V V V V V -120 SUBSTITUTE 3 4 V V V V V -121 CODE 1 1 V V -124 FIND 2 3 V V V V -125 CELL 1 2 V V R x -126 ISERR 1 1 V V -127 ISTEXT 1 1 V V -128 ISNUMBER 1 1 V V -129 ISBLANK 1 1 V V -130 T 1 1 V R -131 N 1 1 V R -140 DATEVALUE 1 1 V V -141 TIMEVALUE 1 1 V V -142 SLN 3 3 V V V V -143 SYD 4 4 V V V V V -144 DDB 4 5 V V V V V V -148 INDIRECT 1 2 R V V x -162 CLEAN 1 1 V V -163 MDETERM 1 1 V A -164 MINVERSE 1 1 A A -165 MMULT 2 2 A A A -167 IPMT 4 6 V V V V V V V -168 PPMT 4 6 V V V V V V V -169 COUNTA 0 30 V R -183 PRODUCT 0 30 V R -184 FACT 1 1 V V -189 DPRODUCT 3 3 V R R R -190 ISNONTEXT 1 1 V V -193 STDEVP 1 30 V R -194 VARP 1 30 V R -195 DSTDEVP 3 3 V R R R -196 DVARP 3 3 V R R R -197 TRUNC 1 1 V V x -198 ISLOGICAL 1 1 V V -199 DCOUNTA 3 3 V R R R -# New Built-In Sheet Functions in BIFF3 -49 LINEST 1 4 A R R V V x -50 TREND 1 4 A R R R V x -51 LOGEST 1 4 A R R V V x -52 GROWTH 1 4 A R R R V x -197 TRUNC 1 2 V V V x -204 YEN 1 2 V V V x -205 FINDB 2 3 V V V V -206 SEARCHB 2 3 V V V V -207 REPLACEB 4 4 V V V V V -208 LEFTB 1 2 V V V -209 RIGHTB 1 2 V V V -210 MIDB 3 3 V V V V -211 LENB 1 1 V V -212 ROUNDUP 2 2 V V V -213 ROUNDDOWN 2 2 V V V -214 ASC 1 1 V V -215 JIS 1 1 V V x -219 ADDRESS 2 5 V V V V V V -220 DAYS360 2 2 V V V x -221 TODAY 0 0 V - x -222 VDB 5 7 V V V V V V V V -227 MEDIAN 1 30 V R ... -228 SUMPRODUCT 1 30 V A ... -229 SINH 1 1 V V -230 COSH 1 1 V V -231 TANH 1 1 V V -232 ASINH 1 1 V V -233 ACOSH 1 1 V V -234 ATANH 1 1 V V -235 DGET 3 3 V R R R -244 INFO 1 1 V V -# New Built-In Sheet Functions in BIFF4 -14 FIXED 2 3 V V V V x -204 USDOLLAR 1 2 V V V x -215 DBCS 1 1 V V x -216 RANK 2 3 V V R V -247 DB 4 5 V V V V V V -252 FREQUENCY 2 2 A R R -261 ERROR.TYPE 1 1 V V -269 AVEDEV 1 30 V R ... -270 BETADIST 3 5 V V V V V V -271 GAMMALN 1 1 V V -272 BETAINV 3 5 V V V V V V -273 BINOMDIST 4 4 V V V V V -274 CHIDIST 2 2 V V V -275 CHIINV 2 2 V V V -276 COMBIN 2 2 V V V -277 CONFIDENCE 3 3 V V V V -278 CRITBINOM 3 3 V V V V -279 EVEN 1 1 V V -280 EXPONDIST 3 3 V V V V -281 FDIST 3 3 V V V V -282 FINV 3 3 V V V V -283 FISHER 1 1 V V -284 FISHERINV 1 1 V V -285 FLOOR 2 2 V V V -286 GAMMADIST 4 4 V V V V V -287 GAMMAINV 3 3 V V V V -288 CEILING 2 2 V V V -289 HYPGEOMDIST 4 4 V V V V V -290 LOGNORMDIST 3 3 V V V V -291 LOGINV 3 3 V V V V -292 NEGBINOMDIST 3 3 V V V V -293 NORMDIST 4 4 V V V V V -294 NORMSDIST 1 1 V V -295 NORMINV 3 3 V V V V -296 NORMSINV 1 1 V V -297 STANDARDIZE 3 3 V V V V -298 ODD 1 1 V V -299 PERMUT 2 2 V V V -300 POISSON 3 3 V V V V -301 TDIST 3 3 V V V V -302 WEIBULL 4 4 V V V V V -303 SUMXMY2 2 2 V A A -304 SUMX2MY2 2 2 V A A -305 SUMX2PY2 2 2 V A A -306 CHITEST 2 2 V A A -307 CORREL 2 2 V A A -308 COVAR 2 2 V A A -309 FORECAST 3 3 V V A A -310 FTEST 2 2 V A A -311 INTERCEPT 2 2 V A A -312 PEARSON 2 2 V A A -313 RSQ 2 2 V A A -314 STEYX 2 2 V A A -315 SLOPE 2 2 V A A -316 TTEST 4 4 V A A V V -317 PROB 3 4 V A A V V -318 DEVSQ 1 30 V R ... -319 GEOMEAN 1 30 V R ... -320 HARMEAN 1 30 V R ... -321 SUMSQ 0 30 V R ... -322 KURT 1 30 V R ... -323 SKEW 1 30 V R ... -324 ZTEST 2 3 V R V V -325 LARGE 2 2 V R V -326 SMALL 2 2 V R V -327 QUARTILE 2 2 V R V -328 PERCENTILE 2 2 V R V -329 PERCENTRANK 2 3 V R V V -330 MODE 1 30 V A -331 TRIMMEAN 2 2 V R V -332 TINV 2 2 V V V -# New Built-In Sheet Functions in BIFF5 -70 WEEKDAY 1 2 V V V x -101 HLOOKUP 3 4 V V R R V x -102 VLOOKUP 3 4 V V R R V x -220 DAYS360 2 3 V V V V x -336 CONCATENATE 0 30 V V -337 POWER 2 2 V V V -342 RADIANS 1 1 V V -343 DEGREES 1 1 V V -344 SUBTOTAL 2 30 V V R -345 SUMIF 2 3 V R V R -346 COUNTIF 2 2 V R V -347 COUNTBLANK 1 1 V R -350 ISPMT 4 4 V V V V V -351 DATEDIF 3 3 V V V V -352 DATESTRING 1 1 V V -353 NUMBERSTRING 2 2 V V V -354 ROMAN 1 2 V V V -# New Built-In Sheet Functions in BIFF8 -358 GETPIVOTDATA 2 30 -359 HYPERLINK 1 2 V V V -360 PHONETIC 1 1 V R -361 AVERAGEA 1 30 V R ... -362 MAXA 1 30 V R ... -363 MINA 1 30 V R ... -364 STDEVPA 1 30 V R ... -365 VARPA 1 30 V R ... -366 STDEVA 1 30 V R ... -367 VARA 1 30 V R ... +# Licensed to the Apache Software Foundation (ASF) under one or more +# contributor license agreements. See the NOTICE file distributed with +# this work for additional information regarding copyright ownership. +# The ASF licenses this file to You under the Apache License, Version 2.0 +# (the "License"); you may not use this file except in compliance with +# the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, software +# distributed under the License is distributed on an "AS IS" BASIS, +# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +# See the License for the specific language governing permissions and +# limitations under the License. + +# Created by (org.apache.poi.hssf.record.formula.function.ExcelFileFormatDocFunctionExtractor) +# from source file 'excelfileformat.odt' (size=356107, md5=0x8f789cb6e75594caf068f8e193004ef4) +# ! + some manual edits ! +# +#Columns: (index, name, minParams, maxParams, returnClass, paramClasses, isVolatile, hasFootnote ) + +# Built-In Sheet Functions in BIFF2 +0 COUNT 0 30 V R +1 IF 2 3 R V R R +2 ISNA 1 1 V V +3 ISERROR 1 1 V V +4 SUM 0 30 V R +5 AVERAGE 1 30 V R +6 MIN 1 30 V R +7 MAX 1 30 V R +8 ROW 0 1 V R +9 COLUMN 0 1 V R +10 NA 0 0 V - +11 NPV 2 30 V V R +12 STDEV 1 30 V R +13 DOLLAR 1 2 V V V +14 FIXED 2 2 V V V x +15 SIN 1 1 V V +16 COS 1 1 V V +17 TAN 1 1 V V +18 ATAN 1 1 V V +19 PI 0 0 V - +20 SQRT 1 1 V V +21 EXP 1 1 V V +22 LN 1 1 V V +23 LOG10 1 1 V V +24 ABS 1 1 V V +25 INT 1 1 V V +26 SIGN 1 1 V V +27 ROUND 2 2 V V V +28 LOOKUP 2 3 V V R R +29 INDEX 2 4 R R V V V +30 REPT 2 2 V V V +31 MID 3 3 V V V V +32 LEN 1 1 V V +33 VALUE 1 1 V V +34 TRUE 0 0 V - +35 FALSE 0 0 V - +36 AND 1 30 V R +37 OR 1 30 V R +38 NOT 1 1 V V +39 MOD 2 2 V V V +40 DCOUNT 3 3 V R R R +41 DSUM 3 3 V R R R +42 DAVERAGE 3 3 V R R R +43 DMIN 3 3 V R R R +44 DMAX 3 3 V R R R +45 DSTDEV 3 3 V R R R +46 VAR 1 30 V R +47 DVAR 3 3 V R R R +48 TEXT 2 2 V V V +49 LINEST 1 2 A R R x +50 TREND 1 3 A R R R x +51 LOGEST 1 2 A R R x +52 GROWTH 1 3 A R R R x +56 PV 3 5 V V V V V V +# Built-In Sheet Functions in BIFF2 +57 FV 3 5 V V V V V V +58 NPER 3 5 V V V V V V +59 PMT 3 5 V V V V V V +60 RATE 3 6 V V V V V V V +61 MIRR 3 3 V A V V +62 IRR 1 2 V A V +63 RAND 0 0 V - x +64 MATCH 2 3 V V R R +65 DATE 3 3 V V V V +66 TIME 3 3 V V V V +67 DAY 1 1 V V +68 MONTH 1 1 V V +69 YEAR 1 1 V V +70 WEEKDAY 1 1 V V x +71 HOUR 1 1 V V +72 MINUTE 1 1 V V +73 SECOND 1 1 V V +74 NOW 0 0 V - x +75 AREAS 1 1 V R +76 ROWS 1 1 V A +77 COLUMNS 1 1 V A +78 OFFSET 3 5 R R V V V V x +82 SEARCH 2 3 V V V V +83 TRANSPOSE 1 1 A A +86 TYPE 1 1 V V +97 ATAN2 2 2 V V V +98 ASIN 1 1 V V +99 ACOS 1 1 V V +100 CHOOSE 2 30 R V R +101 HLOOKUP 3 3 V V R R x +102 VLOOKUP 3 3 V V R R x +105 ISREF 1 1 V R +109 LOG 1 2 V V V +111 CHAR 1 1 V V +112 LOWER 1 1 V V +113 UPPER 1 1 V V +114 PROPER 1 1 V V +115 LEFT 1 2 V V V +116 RIGHT 1 2 V V V +117 EXACT 2 2 V V V +118 TRIM 1 1 V V +119 REPLACE 4 4 V V V V V +120 SUBSTITUTE 3 4 V V V V V +121 CODE 1 1 V V +124 FIND 2 3 V V V V +125 CELL 1 2 V V R x +126 ISERR 1 1 V V +127 ISTEXT 1 1 V V +128 ISNUMBER 1 1 V V +129 ISBLANK 1 1 V V +130 T 1 1 V R +131 N 1 1 V R +140 DATEVALUE 1 1 V V +141 TIMEVALUE 1 1 V V +142 SLN 3 3 V V V V +143 SYD 4 4 V V V V V +144 DDB 4 5 V V V V V V +148 INDIRECT 1 2 R V V x +162 CLEAN 1 1 V V +163 MDETERM 1 1 V A +164 MINVERSE 1 1 A A +165 MMULT 2 2 A A A +167 IPMT 4 6 V V V V V V V +168 PPMT 4 6 V V V V V V V +169 COUNTA 0 30 V R +183 PRODUCT 0 30 V R +184 FACT 1 1 V V +189 DPRODUCT 3 3 V R R R +190 ISNONTEXT 1 1 V V +193 STDEVP 1 30 V R +194 VARP 1 30 V R +195 DSTDEVP 3 3 V R R R +196 DVARP 3 3 V R R R +197 TRUNC 1 1 V V x +198 ISLOGICAL 1 1 V V +199 DCOUNTA 3 3 V R R R +# New Built-In Sheet Functions in BIFF3 +49 LINEST 1 4 A R R V V x +50 TREND 1 4 A R R R V x +51 LOGEST 1 4 A R R V V x +52 GROWTH 1 4 A R R R V x +197 TRUNC 1 2 V V V x +204 YEN 1 2 V V V x +205 FINDB 2 3 V V V V +206 SEARCHB 2 3 V V V V +207 REPLACEB 4 4 V V V V V +208 LEFTB 1 2 V V V +209 RIGHTB 1 2 V V V +210 MIDB 3 3 V V V V +211 LENB 1 1 V V +212 ROUNDUP 2 2 V V V +213 ROUNDDOWN 2 2 V V V +214 ASC 1 1 V V +215 JIS 1 1 V V x +219 ADDRESS 2 5 V V V V V V +220 DAYS360 2 2 V V V x +221 TODAY 0 0 V - x +222 VDB 5 7 V V V V V V V V +227 MEDIAN 1 30 V R ... +228 SUMPRODUCT 1 30 V A ... +229 SINH 1 1 V V +230 COSH 1 1 V V +231 TANH 1 1 V V +232 ASINH 1 1 V V +233 ACOSH 1 1 V V +234 ATANH 1 1 V V +235 DGET 3 3 V R R R +244 INFO 1 1 V V +# New Built-In Sheet Functions in BIFF4 +14 FIXED 2 3 V V V V x +204 USDOLLAR 1 2 V V V x +215 DBCS 1 1 V V x +216 RANK 2 3 V V R V +247 DB 4 5 V V V V V V +252 FREQUENCY 2 2 A R R +261 ERROR.TYPE 1 1 V V +269 AVEDEV 1 30 V R ... +270 BETADIST 3 5 V V V V V V +271 GAMMALN 1 1 V V +272 BETAINV 3 5 V V V V V V +273 BINOMDIST 4 4 V V V V V +274 CHIDIST 2 2 V V V +275 CHIINV 2 2 V V V +276 COMBIN 2 2 V V V +277 CONFIDENCE 3 3 V V V V +278 CRITBINOM 3 3 V V V V +279 EVEN 1 1 V V +280 EXPONDIST 3 3 V V V V +281 FDIST 3 3 V V V V +282 FINV 3 3 V V V V +283 FISHER 1 1 V V +284 FISHERINV 1 1 V V +285 FLOOR 2 2 V V V +286 GAMMADIST 4 4 V V V V V +287 GAMMAINV 3 3 V V V V +288 CEILING 2 2 V V V +289 HYPGEOMDIST 4 4 V V V V V +290 LOGNORMDIST 3 3 V V V V +291 LOGINV 3 3 V V V V +292 NEGBINOMDIST 3 3 V V V V +293 NORMDIST 4 4 V V V V V +294 NORMSDIST 1 1 V V +295 NORMINV 3 3 V V V V +296 NORMSINV 1 1 V V +297 STANDARDIZE 3 3 V V V V +298 ODD 1 1 V V +299 PERMUT 2 2 V V V +300 POISSON 3 3 V V V V +301 TDIST 3 3 V V V V +302 WEIBULL 4 4 V V V V V +303 SUMXMY2 2 2 V A A +304 SUMX2MY2 2 2 V A A +305 SUMX2PY2 2 2 V A A +306 CHITEST 2 2 V A A +307 CORREL 2 2 V A A +308 COVAR 2 2 V A A +309 FORECAST 3 3 V V A A +310 FTEST 2 2 V A A +311 INTERCEPT 2 2 V A A +312 PEARSON 2 2 V A A +313 RSQ 2 2 V A A +314 STEYX 2 2 V A A +315 SLOPE 2 2 V A A +316 TTEST 4 4 V A A V V +317 PROB 3 4 V A A V V +318 DEVSQ 1 30 V R ... +319 GEOMEAN 1 30 V R ... +320 HARMEAN 1 30 V R ... +321 SUMSQ 0 30 V R ... +322 KURT 1 30 V R ... +323 SKEW 1 30 V R ... +324 ZTEST 2 3 V R V V +325 LARGE 2 2 V R V +326 SMALL 2 2 V R V +327 QUARTILE 2 2 V R V +328 PERCENTILE 2 2 V R V +329 PERCENTRANK 2 3 V R V V +330 MODE 1 30 V A +331 TRIMMEAN 2 2 V R V +332 TINV 2 2 V V V +# New Built-In Sheet Functions in BIFF5 +70 WEEKDAY 1 2 V V V x +101 HLOOKUP 3 4 V V R R V x +102 VLOOKUP 3 4 V V R R V x +220 DAYS360 2 3 V V V V x +336 CONCATENATE 0 30 V V +337 POWER 2 2 V V V +342 RADIANS 1 1 V V +343 DEGREES 1 1 V V +344 SUBTOTAL 2 30 V V R +345 SUMIF 2 3 V R V R +346 COUNTIF 2 2 V R V +347 COUNTBLANK 1 1 V R +350 ISPMT 4 4 V V V V V +351 DATEDIF 3 3 V V V V +352 DATESTRING 1 1 V V +353 NUMBERSTRING 2 2 V V V +354 ROMAN 1 2 V V V +# New Built-In Sheet Functions in BIFF8 +358 GETPIVOTDATA 2 30 +359 HYPERLINK 1 2 V V V +360 PHONETIC 1 1 V R +361 AVERAGEA 1 30 V R ... +362 MAXA 1 30 V R ... +363 MINA 1 30 V R ... +364 STDEVPA 1 30 V R ... +365 VARPA 1 30 V R ... +366 STDEVA 1 30 V R ... +367 VARA 1 30 V R ... Modified: poi/trunk/src/testcases/org/apache/poi/hssf/data/BigSSTRecord URL: http://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/hssf/data/BigSSTRecord?rev=780878&r1=780877&r2=780878&view=diff ============================================================================== Binary files - no diff available. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
