; Mon, 24 Jul 2017 09:18:32 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1802770 [14/18] - in /poi/site/publish: ./ apidocs/ apidocs/org/apache/poi/common/usermodel/ apidocs/org/apache/poi/common/usermodel/fonts/ apidocs/org/apache/poi/common/usermodel/fonts/class-use/ apidocs/org/apache/poi/ddf/ apidocs/org/ap... Date: Mon, 24 Jul 2017 09:18:26 -0000 To: commits@poi.apache.org From: nick@apache.org X-Mailer: svnmailer-1.0.9 Message-Id: <20170724091832.CEEC43A5A03@svn01-us-west.apache.org> archived-at: Mon, 24 Jul 2017 09:18:41 -0000 Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function1Arg.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function1Arg.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function1Arg.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function1Arg.html Mon Jul 24 09:18:21 2017 @@ -132,11 +132,7 @@ class Bin2Dec -

Implementation for Excel Bin2Dec() function.

- Syntax:
Bin2Dec (number)
-

- Converts a binary number to decimal.

Implementation for Excel Bin2Dec() function.

@@ -150,11 +146,7 @@ class Code -

Implementation for Excel CODE () function.

- Syntax:
CODE (text )
-

- Returns a numeric code for the first character in a text string.

Implementation for Excel CODE () function.

@@ -176,21 +168,13 @@ class Dec2Bin -

Implementation for Excel Bin2Dec() function.

- Syntax:
Bin2Dec (number,[places] )
-

- Converts a decimal number to binary.

Implementation for Excel Bin2Dec() function.

class Dec2Hex -

Implementation for Excel DELTA() function.

- Syntax:
DEC2HEX (number,places )
-

- Converts a decimal number to hexadecimal.

Implementation for Excel DELTA() function.

@@ -206,11 +190,7 @@ class FactDouble -

Implementation for Excel FACTDOUBLE() function.

- Syntax:
FACTDOUBLE (number)
-

- Returns the double factorial of a number.

Implementation for Excel FACTDOUBLE() function.

@@ -226,40 +206,25 @@ class Hex2Dec -

Implementation for Excel HEX2DEC() function.

- Syntax:
HEX2DEC (number)
-

- Converts a hexadecimal number to decimal.

Implementation for Excel HEX2DEC() function.

class Hyperlink -

Implementation of Excel HYPERLINK function.

- - In Excel this function has special behaviour - it causes the displayed cell value to behave like - a hyperlink in the GUI.

Implementation of Excel HYPERLINK function.

class Imaginary -

Implementation for Excel IMAGINARY() function.

- Syntax:
IMAGINARY (Inumber)
-

- Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.

Implementation for Excel IMAGINARY() function.

class ImReal -

Implementation for Excel ImReal() function.

- Syntax:
ImReal (Inumber)
-

- Returns the real coefficient of a complex number in x + yi or x + yj text format.

Implementation for Excel ImReal() function.

@@ -276,7 +241,7 @@ class Oct2Dec -

Implementation for Excel Oct2Dec() function.

@@ -298,19 +263,13 @@ class T -

Implementation of Excel T() function -

- If the argument is a text or error value it is returned unmodified.

Implementation of Excel T() function

class Value -

Implementation for Excel VALUE() function.

- - Syntax:
VALUE(text)
- - Converts the text argument to a number.

Implementation for Excel VALUE() function.

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function2Arg.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function2Arg.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function2Arg.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function2Arg.html Mon Jul 24 09:18:21 2017 @@ -140,11 +140,7 @@ class Complex -

Implementation for Excel COMPLEX () function.

- Syntax:
COMPLEX (real_num,i_num,suffix )
-

- Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.

Implementation for Excel COMPLEX () function.

@@ -163,31 +159,19 @@ class Dec2Bin -

Implementation for Excel Bin2Dec() function.

- Syntax:
Bin2Dec (number,[places] )
-

- Converts a decimal number to binary.

Implementation for Excel Bin2Dec() function.

class Dec2Hex -

Implementation for Excel DELTA() function.

- Syntax:
DEC2HEX (number,places )
-

- Converts a decimal number to hexadecimal.

Implementation for Excel DELTA() function.

class Delta -

Implementation for Excel DELTA() function.

- Syntax:
DELTA (number1,number2 )
-

- Tests whether two values are equal.

Implementation for Excel DELTA() function.

@@ -203,10 +187,7 @@ class Hyperlink -

Implementation of Excel HYPERLINK function.

- - In Excel this function has special behaviour - it causes the displayed cell value to behave like - a hyperlink in the GUI.

Implementation of Excel HYPERLINK function.

@@ -224,12 +205,7 @@ class Intercept -

Implementation of Excel function INTERCEPT()

- - Calculates the INTERCEPT of the linear regression line that is used to predict y values from x values
- (http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html) - Syntax:
- INTERCEPT(arrayX, arrayY)

Implementation of Excel function INTERCEPT()

@@ -241,23 +217,13 @@ class Lookup -

Implementation of Excel function LOOKUP.

- - LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column.

Implementation of Excel function LOOKUP.

class Match -

Implementation for the MATCH() Excel function.

- - Syntax:
- MATCH(lookup_value, lookup_array, match_type)

- - Returns a 1-based index specifying at what position in the lookup_array the specified - lookup_value is found.

- - Specific matching behaviour can be modified with the optional match_type parameter.

Implementation for the MATCH() Excel function.

@@ -267,7 +233,7 @@ class Quotient -

Implementation for Excel QUOTIENT () function.

@@ -279,32 +245,19 @@ class Rept -

Implementation for Excel REPT () function.

- Syntax:
REPT (text,number_times )
-

- Repeats text a given number of times.

Implementation for Excel REPT () function.

class Roman -

Implementation for Excel WeekNum() function.

- Syntax:
WeekNum (Serial_num,Return_type)
-

- Returns a number that indicates where the week falls numerically within a year.

Implementation for Excel WeekNum() function.

class Slope -

Implementation of Excel function SLOPE()

- - Calculates the SLOPE of the linear regression line that is used to predict y values from x values
- (http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html) - Syntax:
- SLOPE(arrayX, arrayY)

Implementation of Excel function SLOPE()

@@ -316,47 +269,25 @@ class Sumx2my2 -

Implementation of Excel function SUMX2MY2()

- - Calculates the sum of differences of squares in two arrays of the same size.
- Syntax:
- SUMX2MY2(arrayX, arrayY)

- - result = Σ_{i: 0..n}(x_i²-y_i²)

Implementation of Excel function SUMX2MY2()

class Sumx2py2 -

Implementation of Excel function SUMX2PY2()

- - Calculates the sum of squares in two arrays of the same size.
- Syntax:
- SUMX2PY2(arrayX, arrayY)

- - result = Σ_{i: 0..n}(x_i²+y_i²)

Implementation of Excel function SUMX2PY2()

class Sumxmy2 -

Implementation of Excel function SUMXMY2()

- - Calculates the sum of squares of differences between two arrays of the same size.
- Syntax:
- SUMXMY2(arrayX, arrayY)

- - result = Σ_{i: 0..n}(x_i-y_i)²

Implementation of Excel function SUMXMY2()

class WeekNum -

Implementation for Excel WeekNum() function.

- Syntax:
WeekNum (Serial_num,Return_type)
-

- Returns a number that indicates where the week falls numerically within a year.

Implementation for Excel WeekNum() function.

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function3Arg.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function3Arg.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function3Arg.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function3Arg.html Mon Jul 24 09:18:21 2017 @@ -100,11 +100,7 @@ class Complex -

Implementation for Excel COMPLEX () function.

- Syntax:
COMPLEX (real_num,i_num,suffix )
-

- Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.

Implementation for Excel COMPLEX () function.

@@ -143,15 +139,7 @@ class Hlookup -

Implementation of the HLOOKUP() function.

- - HLOOKUP finds a column in a lookup table by the first row value and returns the value from another row.
- - Syntax:
- HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)

- - lookup_value The value to be found in the first column of the table array.
- table_array An area reference for the lookup data.

Implementation of the HLOOKUP() function.

@@ -169,23 +157,13 @@ class Lookup -

Implementation of Excel function LOOKUP.

- - LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column.

Implementation of Excel function LOOKUP.

class Match -

Implementation for the MATCH() Excel function.

- - Syntax:
- MATCH(lookup_value, lookup_array, match_type)

- - Returns a 1-based index specifying at what position in the lookup_array the specified - lookup_value is found.

- - Specific matching behaviour can be modified with the optional match_type parameter.

Implementation for the MATCH() Excel function.

@@ -197,8 +175,7 @@ class Substitute -

An implementation of the SUBSTITUTE function:

- Substitutes text in a text string with new text, some number of times.

An implementation of the SUBSTITUTE function:

@@ -216,15 +193,7 @@ class Vlookup -

Implementation of the VLOOKUP() function.

- - VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.
- - Syntax:
- VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

- - lookup_value The value to be found in the first column of the table array.
- table_array An area reference for the lookup data.

Implementation of the VLOOKUP() function.

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function4Arg.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function4Arg.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function4Arg.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/Function4Arg.html Mon Jul 24 09:18:21 2017 @@ -110,15 +110,7 @@ class Hlookup -

Implementation of the HLOOKUP() function.

- - lookup_value The value to be found in the first column of the table array.
- table_array An area reference for the lookup data.

Implementation of the HLOOKUP() function.

@@ -130,38 +122,19 @@ class Replace -

An implementation of the Excel REPLACE() function:

- Replaces part of a text string based on the number of characters - you specify, with another text string.
- - Syntax:
- REPLACE(oldText, startNum, numChars, newText)

- - oldText The text string containing characters to replace
- startNum The position of the first character to replace (1-based)
- numChars The number of characters to replace
- newText The new text value to replace the removed section

An implementation of the Excel REPLACE() function:

class Substitute -

An implementation of the SUBSTITUTE function:

- Substitutes text in a text string with new text, some number of times.

An implementation of the SUBSTITUTE function:

class Vlookup -

Implementation of the VLOOKUP() function.

- - lookup_value The value to be found in the first column of the table array.
- table_array An area reference for the lookup data.

Implementation of the VLOOKUP() function.

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/XYNumericFunction.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/XYNumericFunction.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/XYNumericFunction.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/class-use/XYNumericFunction.html Mon Jul 24 09:18:21 2017 @@ -100,37 +100,19 @@ class Sumx2my2 -

Implementation of Excel function SUMX2MY2()

- - Calculates the sum of differences of squares in two arrays of the same size.
- Syntax:
- SUMX2MY2(arrayX, arrayY)

- - result = Σ_{i: 0..n}(x_i²-y_i²)

Implementation of Excel function SUMX2MY2()

class Sumx2py2 -

Implementation of Excel function SUMX2PY2()

- - Calculates the sum of squares in two arrays of the same size.
- Syntax:
- SUMX2PY2(arrayX, arrayY)

- - result = Σ_{i: 0..n}(x_i²+y_i²)

Implementation of Excel function SUMX2PY2()

class Sumxmy2 -

Implementation of Excel function SUMXMY2()

- - Calculates the sum of squares of differences between two arrays of the same size.
- Syntax:
- SUMXMY2(arrayX, arrayY)

- - result = Σ_{i: 0..n}(x_i-y_i)²

Implementation of Excel function SUMXMY2()

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-summary.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-summary.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-summary.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/functions/package-summary.html Mon Jul 24 09:18:21 2017 @@ -154,17 +154,13 @@ BaseNumberUtils -

Some utils for converting from and to any base

Bin2Dec -

Implementation for Excel Bin2Dec() function.

- Syntax:
Bin2Dec (number)
-

- Converts a binary number to decimal.

Implementation for Excel Bin2Dec() function.

@@ -192,11 +188,7 @@ Code -

Implementation for Excel CODE () function.

- Syntax:
CODE (text )
-

- Returns a numeric code for the first character in a text string.

Implementation for Excel CODE () function.

@@ -212,11 +204,7 @@ Complex -

Implementation for Excel COMPLEX () function.

- Syntax:
COMPLEX (real_num,i_num,suffix )
-

- Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.

Implementation for Excel COMPLEX () function.

@@ -274,31 +262,19 @@ Dec2Bin -

Implementation for Excel Bin2Dec() function.

- Syntax:
Bin2Dec (number,[places] )
-

- Converts a decimal number to binary.

Implementation for Excel Bin2Dec() function.

Dec2Hex -

Implementation for Excel DELTA() function.

- Syntax:
DEC2HEX (number,places )
-

- Converts a decimal number to hexadecimal.

Implementation for Excel DELTA() function.

Delta -

Implementation for Excel DELTA() function.

- Syntax:
DELTA (number1,number2 )
-

- Tests whether two values are equal.

Implementation for Excel DELTA() function.

@@ -330,16 +306,7 @@ EOMonth -

Implementation for the Excel EOMONTH() function.

- EOMONTH() returns the date of the last day of a month..

- Syntax:
- EOMONTH(start_date,months)

- start_date is the starting date of the calculation - months is the number of months to be added to start_date, - to give a new date.

Implementation for the Excel EOMONTH() function.

@@ -355,11 +322,7 @@ FactDouble -

Implementation for Excel FACTDOUBLE() function.

- Syntax:
FACTDOUBLE (number)
-

- Returns the double factorial of a number.

Implementation for Excel FACTDOUBLE() function.

@@ -413,34 +376,19 @@ Hex2Dec -

Implementation for Excel HEX2DEC() function.

- Syntax:
HEX2DEC (number)
-

- Converts a hexadecimal number to decimal.

Implementation for Excel HEX2DEC() function.

Hlookup -

Implementation of the HLOOKUP() function.

- - lookup_value The value to be found in the first column of the table array.
- table_array An area reference for the lookup data.

Implementation of the HLOOKUP() function.

Hyperlink -

Implementation of Excel HYPERLINK function.

- - In Excel this function has special behaviour - it causes the displayed cell value to behave like - a hyperlink in the GUI.

Implementation of Excel HYPERLINK function.

@@ -452,21 +400,13 @@ Imaginary -

Implementation for Excel IMAGINARY() function.

- Syntax:
IMAGINARY (Inumber)
-

- Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.

Implementation for Excel IMAGINARY() function.

ImReal -

Implementation for Excel ImReal() function.

- Syntax:
ImReal (Inumber)
-

- Returns the real coefficient of a complex number in x + yi or x + yj text format.

Implementation for Excel ImReal() function.

@@ -478,28 +418,13 @@ Indirect -

Implementation for Excel function INDIRECT

- - INDIRECT() returns the cell or area reference denoted by the text argument.

- - Syntax:
- INDIRECT(ref_text,isA1Style)

- - ref_text a string representation of the desired reference as it would - normally be written in a cell formula.
- isA1Style (default TRUE) specifies whether the ref_text should be - interpreted as A1-style or R1C1-style.

Implementation for Excel function INDIRECT

Intercept -

Implementation of Excel function INTERCEPT()

@@ -528,23 +453,13 @@ Lookup -

Implementation of Excel function LOOKUP.

- - LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column.

Implementation of Excel function LOOKUP.

Match -

Implementation for the MATCH() Excel function.

- - Syntax:
- MATCH(lookup_value, lookup_array, match_type)

- - Returns a 1-based index specifying at what position in the lookup_array the specified - lookup_value is found.

- - Specific matching behaviour can be modified with the optional match_type parameter.

Implementation for the MATCH() Excel function.

@@ -610,7 +525,7 @@ Oct2Dec -

Implementation for Excel Oct2Dec() function.

@@ -620,18 +535,7 @@ Offset -

Implementation for Excel function OFFSET()

- - OFFSET returns an area reference that is a specified number of rows and columns from a - reference cell or area.

- - Syntax:
- OFFSET(reference, rows, cols, height, width)

- reference is the base reference.
- rows is the number of rows up or down from the base reference.
- cols is the number of columns left or right from the base reference.
- height (default same height as base reference) is the row count for the returned area reference.
- width (default same width as base reference) is the column count for the returned area reference.

Implementation for Excel function OFFSET()

@@ -643,7 +547,7 @@ Quotient -

Implementation for Excel QUOTIENT () function.

@@ -661,37 +565,19 @@ Replace -

An implementation of the Excel REPLACE() function:

- Replaces part of a text string based on the number of characters - you specify, with another text string.
- - Syntax:
- REPLACE(oldText, startNum, numChars, newText)

An implementation of the Excel REPLACE() function:

Rept -

Implementation for Excel REPT () function.

- Syntax:
REPT (text,number_times )
-

- Repeats text a given number of times.

Implementation for Excel REPT () function.

Roman -

Implementation for Excel WeekNum() function.

- Syntax:
WeekNum (Serial_num,Return_type)
-

- Returns a number that indicates where the week falls numerically within a year.

Implementation for Excel WeekNum() function.

@@ -709,19 +595,13 @@ Slope -

Implementation of Excel function SLOPE()

Substitute -

An implementation of the SUBSTITUTE function:

- Substitutes text in a text string with new text, some number of times.

An implementation of the SUBSTITUTE function:

@@ -751,45 +631,25 @@ Sumx2my2 -

Implementation of Excel function SUMX2MY2()

- - Calculates the sum of differences of squares in two arrays of the same size.
- Syntax:
- SUMX2MY2(arrayX, arrayY)

- - result = Σ_{i: 0..n}(x_i²-y_i²)

Implementation of Excel function SUMX2MY2()

Sumx2py2 -

Implementation of Excel function SUMX2PY2()

- - Calculates the sum of squares in two arrays of the same size.
- Syntax:
- SUMX2PY2(arrayX, arrayY)

- - result = Σ_{i: 0..n}(x_i²+y_i²)

Implementation of Excel function SUMX2PY2()

Sumxmy2 -

Implementation of Excel function SUMXMY2()

- - Calculates the sum of squares of differences between two arrays of the same size.
- Syntax:
- SUMXMY2(arrayX, arrayY)

- - result = Σ_{i: 0..n}(x_i-y_i)²

Implementation of Excel function SUMXMY2()

T -

Implementation of Excel T() function -

- If the argument is a text or error value it is returned unmodified.

Implementation of Excel T() function

@@ -805,31 +665,19 @@ Today -

Implementation of Excel TODAY() Function

Value -

Implementation for Excel VALUE() function.

- - Syntax:
VALUE(text)
- - Converts the text argument to a number.

Implementation for Excel VALUE() function.

Vlookup -

Implementation of the VLOOKUP() function.

- - lookup_value The value to be found in the first column of the table array.
- table_array An area reference for the lookup data.

Implementation of the VLOOKUP() function.

@@ -841,11 +689,7 @@ WeekNum -

Implementation for Excel WeekNum() function.

- Syntax:
WeekNum (Serial_num,Return_type)
-

- Returns a number that indicates where the week falls numerically within a year.

Implementation for Excel WeekNum() function.

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/package-summary.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/package-summary.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/package-summary.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/package-summary.html Mon Jul 24 09:18:21 2017 @@ -96,7 +96,7 @@ EvaluationName -

Abstracts a name record for formula evaluation.
+

Abstracts a name record for formula evaluation.
For POI internal use only

@@ -104,7 +104,7 @@ EvaluationSheet -

Abstracts a sheet for the purpose of formula evaluation.
+

Abstracts a sheet for the purpose of formula evaluation.
For POI internal use only

@@ -112,7 +112,7 @@ EvaluationWorkbook -

Abstracts a workbook for the purpose of formula evaluation.
+

Abstracts a workbook for the purpose of formula evaluation.
For POI internal use only

@@ -120,7 +120,7 @@ ExternSheetReferenceToken -

Should be implemented by any Ptg subclass that needs has an extern sheet index
+

Should be implemented by any Ptg subclass that needs has an extern sheet index
For POI internal use only

@@ -128,7 +128,7 @@ FormulaParsingWorkbook -

Abstracts a workbook for the purpose of formula parsing.
+

Abstracts a workbook for the purpose of formula parsing.
For POI internal use only

@@ -136,7 +136,7 @@ FormulaRenderingWorkbook -

Abstracts a workbook for the purpose of converting formula to text.
+

Abstracts a workbook for the purpose of converting formula to text.
For POI internal use only

@@ -145,7 +145,7 @@ IStabilityClassifier

Used to help optimise cell evaluation result caching by allowing applications to specify which - parts of a workbook are final.
+ parts of a workbook are final.
The term final is introduced here to denote immutability or 'having constant definition'.

@@ -195,7 +195,7 @@ BaseFormulaEvaluator -

Common functionality across file formats for evaluating formula cells.

@@ -208,17 +208,13 @@ ConditionalFormattingEvaluator -

Evaluates Conditional Formatting constraints.

- - For performance reasons, this class keeps a cache of all previously evaluated rules and cells.

Evaluates Conditional Formatting constraints.

DataValidationEvaluator -

Evaluates Data Validation constraints.

- - For performance reasons, this class keeps a cache of all previously retrieved DataValidation instances.

Evaluates Data Validation constraints.

@@ -265,7 +261,7 @@ FormulaRenderer -

Common logic for rendering formulas.
+

Common logic for rendering formulas.
For POI internal use only

@@ -318,10 +314,7 @@ WorkbookEvaluator -

Evaluates formula cells.

- - For performance reasons, this class keeps a cache of all previously calculated intermediate - cell values.

Evaluates formula cells.

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/package-use.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/package-use.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/package-use.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/package-use.html Mon Jul 24 09:18:21 2017 @@ -252,7 +252,7 @@ BaseFormulaEvaluator -

Common functionality across file formats for evaluating formula cells.

@@ -262,21 +262,21 @@ EvaluationName -

Abstracts a name record for formula evaluation.
+

Abstracts a name record for formula evaluation.
For POI internal use only

EvaluationSheet -

Abstracts a sheet for the purpose of formula evaluation.
+

Abstracts a sheet for the purpose of formula evaluation.
For POI internal use only

EvaluationWorkbook -

Abstracts a workbook for the purpose of formula evaluation.
+

Abstracts a workbook for the purpose of formula evaluation.
For POI internal use only

@@ -289,14 +289,14 @@ FormulaParsingWorkbook -

Abstracts a workbook for the purpose of formula parsing.
+

Abstracts a workbook for the purpose of formula parsing.
For POI internal use only

FormulaRenderingWorkbook -

Abstracts a workbook for the purpose of converting formula to text.
+

Abstracts a workbook for the purpose of converting formula to text.
For POI internal use only

@@ -304,7 +304,7 @@ IStabilityClassifier

@@ -348,7 +348,7 @@ BaseFormulaEvaluator -

Common functionality across file formats for evaluating formula cells.

@@ -362,9 +362,7 @@ DataValidationEvaluator -

Evaluates Data Validation constraints.

- - For performance reasons, this class keeps a cache of all previously retrieved DataValidation instances.

Evaluates Data Validation constraints.

@@ -403,21 +401,21 @@ EvaluationName -

Abstracts a name record for formula evaluation.
+

Abstracts a name record for formula evaluation.
For POI internal use only

EvaluationSheet -

Abstracts a sheet for the purpose of formula evaluation.
+

Abstracts a sheet for the purpose of formula evaluation.
For POI internal use only

EvaluationWorkbook -

Abstracts a workbook for the purpose of formula evaluation.
+

Abstracts a workbook for the purpose of formula evaluation.
For POI internal use only

@@ -435,14 +433,14 @@ FormulaParsingWorkbook -

Abstracts a workbook for the purpose of formula parsing.
+

Abstracts a workbook for the purpose of formula parsing.
For POI internal use only

FormulaRenderingWorkbook -

Abstracts a workbook for the purpose of converting formula to text.
+

Abstracts a workbook for the purpose of converting formula to text.
For POI internal use only

@@ -460,7 +458,7 @@ IStabilityClassifier

@@ -481,10 +479,7 @@ WorkbookEvaluator -

Evaluates formula cells.

- - For performance reasons, this class keeps a cache of all previously calculated intermediate - cell values.

Evaluates formula cells.

@@ -507,7 +502,7 @@ EvaluationName -

Abstracts a name record for formula evaluation.
+

Abstracts a name record for formula evaluation.
For POI internal use only

@@ -543,7 +538,7 @@ IStabilityClassifier

@@ -581,14 +576,14 @@ ExternSheetReferenceToken -

Should be implemented by any Ptg subclass that needs has an extern sheet index
+

Should be implemented by any Ptg subclass that needs has an extern sheet index
For POI internal use only

FormulaRenderingWorkbook -

Abstracts a workbook for the purpose of converting formula to text.
+

Abstracts a workbook for the purpose of converting formula to text.
For POI internal use only

@@ -615,9 +610,7 @@ ConditionalFormattingEvaluator -

Evaluates Conditional Formatting constraints.

- - For performance reasons, this class keeps a cache of all previously evaluated rules and cells.

Evaluates Conditional Formatting constraints.

@@ -657,7 +650,7 @@ BaseFormulaEvaluator -

Common functionality across file formats for evaluating formula cells.

@@ -667,14 +660,14 @@ EvaluationSheet -

Abstracts a sheet for the purpose of formula evaluation.
+

Abstracts a sheet for the purpose of formula evaluation.
For POI internal use only

EvaluationWorkbook -

Abstracts a workbook for the purpose of formula evaluation.
+

Abstracts a workbook for the purpose of formula evaluation.
For POI internal use only

@@ -687,14 +680,14 @@ FormulaParsingWorkbook -

Abstracts a workbook for the purpose of formula parsing.
+

Abstracts a workbook for the purpose of formula parsing.
For POI internal use only

FormulaRenderingWorkbook -

Abstracts a workbook for the purpose of converting formula to text.
+

Abstracts a workbook for the purpose of converting formula to text.
For POI internal use only

@@ -702,7 +695,7 @@ IStabilityClassifier

@@ -726,7 +719,7 @@ BaseFormulaEvaluator -

Common functionality across file formats for evaluating formula cells.

@@ -736,21 +729,21 @@ EvaluationName -

Abstracts a name record for formula evaluation.
+

Abstracts a name record for formula evaluation.
For POI internal use only

EvaluationSheet -

Abstracts a sheet for the purpose of formula evaluation.
+

Abstracts a sheet for the purpose of formula evaluation.
For POI internal use only

EvaluationWorkbook -

Abstracts a workbook for the purpose of formula evaluation.
+

Abstracts a workbook for the purpose of formula evaluation.
For POI internal use only

@@ -763,14 +756,14 @@ FormulaParsingWorkbook -

Abstracts a workbook for the purpose of formula parsing.
+

Abstracts a workbook for the purpose of formula parsing.
For POI internal use only

FormulaRenderingWorkbook -

Abstracts a workbook for the purpose of converting formula to text.
+

Abstracts a workbook for the purpose of converting formula to text.
For POI internal use only

@@ -778,7 +771,7 @@ IStabilityClassifier

@@ -787,10 +780,7 @@ WorkbookEvaluator -

Evaluates formula cells.

- - For performance reasons, this class keeps a cache of all previously calculated intermediate - cell values.

Evaluates formula cells.

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/ptg/Ptg.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/ptg/Ptg.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/formula/ptg/Ptg.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/formula/ptg/Ptg.html Mon Jul 24 09:18:21 2017 @@ -108,7 +108,7 @@ extends java.lang.Object 'parse thing'. Originally, the name referred to the single byte identifier at the start of the token, but in POI, Ptg encapsulates the whole formula token (initial byte + value data). -

Ptgs are logically arranged in a tree representing the structure of the parsed formula. However, in BIFF files Ptgs are written/read in @@ -399,7 +399,7 @@ extends java.lang.Object int offset)

Writes the ptgs to the data buffer, starting at the specified offset. -
+
The 2 byte encode length field is not written by this method.

Returns:: number of bytes written

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/BuiltinFormats.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/BuiltinFormats.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/BuiltinFormats.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/BuiltinFormats.html Mon Jul 24 09:18:21 2017 @@ -101,48 +101,48 @@

public final class BuiltinFormats
 extends java.lang.Object

Utility to identify built-in formats. The following is a list of the formats as - returned by this class.

- 0, "General"
- 1, "0"
- 2, "0.00"
- 3, "#,##0"
- 4, "#,##0.00"
- 5, "$#,##0_);($#,##0)"
- 6, "$#,##0_);[Red]($#,##0)"
- 7, "$#,##0.00);($#,##0.00)"
- 8, "$#,##0.00_);[Red]($#,##0.00)"
- 9, "0%"
- 0xa, "0.00%"
- 0xb, "0.00E+00"
- 0xc, "# ?/?"
- 0xd, "# ??/??"
- 0xe, "m/d/yy"
- 0xf, "d-mmm-yy"
- 0x10, "d-mmm"
- 0x11, "mmm-yy"
- 0x12, "h:mm AM/PM"
- 0x13, "h:mm:ss AM/PM"
- 0x14, "h:mm"
- 0x15, "h:mm:ss"
- 0x16, "m/d/yy h:mm"
-

+ returned by this class.

+ 0, "General"
+ 1, "0"
+ 2, "0.00"
+ 3, "#,##0"
+ 4, "#,##0.00"
+ 5, "$#,##0_);($#,##0)"
+ 6, "$#,##0_);[Red]($#,##0)"
+ 7, "$#,##0.00);($#,##0.00)"
+ 8, "$#,##0.00_);[Red]($#,##0.00)"
+ 9, "0%"
+ 0xa, "0.00%"
+ 0xb, "0.00E+00"
+ 0xc, "# ?/?"
+ 0xd, "# ??/??"
+ 0xe, "m/d/yy"
+ 0xf, "d-mmm-yy"
+ 0x10, "d-mmm"
+ 0x11, "mmm-yy"
+ 0x12, "h:mm AM/PM"
+ 0x13, "h:mm:ss AM/PM"
+ 0x14, "h:mm"
+ 0x15, "h:mm:ss"
+ 0x16, "m/d/yy h:mm"
+

// 0x17 - 0x24 reserved for international and undocumented - 0x25, "#,##0_);(#,##0)"
- 0x26, "#,##0_);[Red](#,##0)"
- 0x27, "#,##0.00_);(#,##0.00)"
- 0x28, "#,##0.00_);[Red](#,##0.00)"
- 0x29, "_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)"
- 0x2a, "_($* #,##0_);_($* (#,##0);_($* \"-\"_);_(@_)"
- 0x2b, "_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(@_)"
- 0x2c, "_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)"
- 0x2d, "mm:ss"
- 0x2e, "[h]:mm:ss"
- 0x2f, "mm:ss.0"
- 0x30, "##0.0E+0"
- 0x31, "@" - This is text format.
- 0x31 "text" - Alias for "@"
-

+ 0x25, "#,##0_);(#,##0)"
+ 0x26, "#,##0_);[Red](#,##0)"
+ 0x27, "#,##0.00_);(#,##0.00)"
+ 0x28, "#,##0.00_);[Red](#,##0.00)"
+ 0x29, "_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)"
+ 0x2a, "_($* #,##0_);_($* (#,##0);_($* \"-\"_);_(@_)"
+ 0x2b, "_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(@_)"
+ 0x2c, "_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)"
+ 0x2d, "mm:ss"
+ 0x2e, "[h]:mm:ss"
+ 0x2f, "mm:ss.0"
+ 0x30, "##0.0E+0"
+ 0x31, "@" - This is text format.
+ 0x31 "text" - Alias for "@"
+

@@ -212,7 +212,7 @@ extends java.lang.Object static int getBuiltinFormat(java.lang.String pFmt) -

Get the format index that matches the given format string.
+

Get the format index that matches the given format string.
Automatically converts "text" to excel's format string to represent text.

@@ -303,7 +303,7 @@ extends java.lang.Object

getBuiltinFormat

public static int getBuiltinFormat(java.lang.String pFmt)

Get the format index that matches the given format string.
+

Get the format index that matches the given format string.
Automatically converts "text" to excel's format string to represent text.

Parameters:: pFmt - string matching a built-in format
Returns:: index of format or -1 if undefined.

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionFilterType.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionFilterType.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionFilterType.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionFilterType.html Mon Jul 24 09:18:21 2017 @@ -112,7 +112,7 @@ extends java.lang.Enum<Used primarily for XSSF conditions, which defines a multitude of additional "filter" types for conditional formatting. HSSF rules will always be null (not a filter type) or #FILTER. XSSF conditions will be null (not a filter type) or any value other than #FILTER. -

Instance names match the constants from STCfType for convenience.

Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormattingRule.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormattingRule.html?rev=1802770&r1=1802769&r2=1802770&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormattingRule.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormattingRule.html Mon Jul 24 09:18:21 2017 @@ -158,11 +158,7 @@ extends ConditionFilterType getConditionFilterType() -

This is null if -

- getConditionType() != ConditionType.FILTER -

- This is always ConditionFilterType.FILTER for HSSF rules of type ConditionType.FILTER.

This is null if

@@ -178,11 +174,7 @@ extends ConditionFilterData getFilterConfiguration() -

This is null if -

- getConditionFilterType() == null -

- This means it is always null for HSSF, which does not define the extended condition types.

This is null if

@@ -386,11 +378,11 @@ extends ConditionFilterType getConditionFilterType()

This is null if -

getConditionType() != ConditionType.FILTER -

This is always ConditionFilterType.FILTER for HSSF rules of type ConditionType.FILTER. -

For XSSF filter rules, this will indicate the specific type of filter.

Returns:: filter type for filter rules, or null if not a filter rule.

@@ -403,11 +395,11 @@ extends ConditionFilterData getFilterConfiguration()

This is null if -

getConditionFilterType() == null -

This means it is always null for HSSF, which does not define the extended condition types. -

This object contains the additional configuration information for XSSF filter conditions.

Returns:: the Filter Configuration Data, or null if there isn't any

@@ -468,13 +460,13 @@ extends The priority of the rule, if defined, otherwise 0. -

If priority is 0, just use definition order, as that's how older HSSF rules are evaluated. -

For XSSF, this should always be set. For HSSF, only newer style rules have this set, older ones will return 0. -

If a rule is created but not yet added to a sheet, this value may not be valid.

Returns:: rule priority

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