Deprecated
Table of Contents
Calculation.php
Line | Element | Reason |
---|---|---|
143 | Calculation::$suppressFormulaErrors | use setSuppressFormulaErrors() instead |
Database.php
Line | Element | Reason |
---|---|---|
10 | Database | |
41 | Database::DAVERAGE() | Use the evaluate() method in the Database\DAverage class instead |
79 | Database::DCOUNT() | Use the evaluate() method in the Database\DCount class instead |
113 | Database::DCOUNTA() | Use the evaluate() method in the Database\DCountA class instead |
148 | Database::DGET() | Use the evaluate() method in the Database\DGet class instead |
183 | Database::DMAX() | Use the evaluate() method in the Database\DMax class instead |
218 | Database::DMIN() | Use the evaluate() method in the Database\DMin class instead |
252 | Database::DPRODUCT() | Use the evaluate() method in the Database\DProduct class instead |
287 | Database::DSTDEV() | Use the evaluate() method in the Database\DStDev class instead |
322 | Database::DSTDEVP() | Use the evaluate() method in the Database\DStDevP class instead |
356 | Database::DSUM() | Use the evaluate() method in the Database\DSum class instead |
391 | Database::DVAR() | Use the evaluate() method in the Database\DVar class instead |
426 | Database::DVARP() | Use the evaluate() method in the Database\DVarP class instead |
DateTime.php
Line | Element | Reason |
---|---|---|
10 | DateTime | |
23 | DateTime::isLeapYear() | Use the isLeapYear method in the DateTimeExcel\Helpers class instead |
39 | DateTime::getDateValue() | Use the getDateValue method in the DateTimeExcel\Helpers class instead |
69 | DateTime::DATETIMENOW() | Use the now method in the DateTimeExcel\Current class instead |
95 | DateTime::DATENOW() | Use the today method in the DateTimeExcel\Current class instead |
154 | DateTime::DATE() | Use the fromYMD method in the DateTimeExcel\Date class instead |
189 | DateTime::TIME() | Use the fromHMS method in the DateTimeExcel\Time class instead |
223 | DateTime::DATEVALUE() | Use the fromString method in the DateTimeExcel\DateValue class instead |
253 | DateTime::TIMEVALUE() | Use the fromString method in the DateTimeExcel\TimeValue class instead |
276 | DateTime::DATEDIF() | Use the interval method in the DateTimeExcel\Difference class instead |
300 | DateTime::DAYS() | Use the between method in the DateTimeExcel\Days class instead |
337 | DateTime::DAYS360() | Use the between method in the DateTimeExcel\Days360 class instead |
373 | DateTime::YEARFRAC() | Use the fraction method in the DateTimeExcel\YearFrac class instead |
401 | DateTime::NETWORKDAYS() | Use the count method in the DateTimeExcel\NetworkDays class instead |
431 | DateTime::WORKDAY() | Use the date method in the DateTimeExcel\WorkDay class instead |
454 | DateTime::DAYOFMONTH() | Use the day method in the DateTimeExcel\DateParts class instead |
481 | DateTime::WEEKDAY() | Use the day method in the DateTimeExcel\Week class instead |
692 | DateTime::WEEKNUM() | Use the number method in the DateTimeExcel\Week class instead |
714 | DateTime::ISOWEEKNUM() | Use the isoWeekNumber method in the DateTimeExcel\Week class instead |
737 | DateTime::MONTHOFYEAR() | Use the month method in the DateTimeExcel\DateParts class instead |
760 | DateTime::YEAR() | Use the ear method in the DateTimeExcel\DateParts class instead |
783 | DateTime::HOUROFDAY() | Use the hour method in the DateTimeExcel\TimeParts class instead |
806 | DateTime::MINUTE() | Use the minute method in the DateTimeExcel\TimeParts class instead |
829 | DateTime::SECOND() | Use the second method in the DateTimeExcel\TimeParts class instead |
858 | DateTime::EDATE() | Use the adjust method in the DateTimeExcel\Edate class instead |
886 | DateTime::EOMONTH() | Use the lastDay method in the DateTimeExcel\EoMonth class instead |
493 | DateTime::STARTWEEK_SUNDAY | Use DateTimeExcel\Constants::STARTWEEK_SUNDAY |
502 | DateTime::STARTWEEK_MONDAY | Use DateTimeExcel\Constants::STARTWEEK_MONDAY |
511 | DateTime::STARTWEEK_MONDAY_ALT | Use DateTimeExcel\Constants::STARTWEEK_MONDAY_ALT |
520 | DateTime::STARTWEEK_TUESDAY | Use DateTimeExcel\Constants::STARTWEEK_TUESDAY |
529 | DateTime::STARTWEEK_WEDNESDAY | Use DateTimeExcel\Constants::STARTWEEK_WEDNESDAY |
538 | DateTime::STARTWEEK_THURSDAY | Use DateTimeExcel\Constants::STARTWEEK_THURSDAY |
547 | DateTime::STARTWEEK_FRIDAY | Use DateTimeExcel\Constants::STARTWEEK_FRIDAY |
556 | DateTime::STARTWEEK_SATURDAY | Use DateTimeExcel\Constants::STARTWEEK_SATURDAY |
565 | DateTime::STARTWEEK_SUNDAY_ALT | Use DateTimeExcel\Constants::STARTWEEK_SUNDAY_ALT |
574 | DateTime::DOW_SUNDAY | Use DateTimeExcel\Constants::DOW_SUNDAY |
583 | DateTime::DOW_MONDAY | Use DateTimeExcel\Constants::DOW_MONDAY |
592 | DateTime::DOW_TUESDAY | Use DateTimeExcel\Constants::DOW_TUESDAY |
601 | DateTime::DOW_WEDNESDAY | Use DateTimeExcel\Constants::DOW_WEDNESDAY |
610 | DateTime::DOW_THURSDAY | Use DateTimeExcel\Constants::DOW_THURSDAY |
619 | DateTime::DOW_FRIDAY | Use DateTimeExcel\Constants::DOW_FRIDAY |
628 | DateTime::DOW_SATURDAY | Use DateTimeExcel\Constants::DOW_SATURDAY |
637 | DateTime::STARTWEEK_MONDAY_ISO | Use DateTimeExcel\Constants::STARTWEEK_MONDAY_ISO |
646 | DateTime::METHODARR | Use DateTimeExcel\Constants::METHODARR |
Engineering.php
Line | Element | Reason |
---|---|---|
12 | Engineering | |
45 | Engineering::BESSELI() | Use the BESSELI() method in the Engineering\BesselI class instead |
70 | Engineering::BESSELJ() | Use the BESSELJ() method in the Engineering\BesselJ class instead |
96 | Engineering::BESSELK() | Use the BESSELK() method in the Engineering\BesselK class instead |
121 | Engineering::BESSELY() | Use the BESSELY() method in the Engineering\BesselY class instead |
147 | Engineering::BINTODEC() | Use the toDecimal() method in the Engineering\ConvertBinary class instead |
179 | Engineering::BINTOHEX() | Use the toHex() method in the Engineering\ConvertBinary class instead |
211 | Engineering::BINTOOCT() | Use the toOctal() method in the Engineering\ConvertBinary class instead |
247 | Engineering::DECTOBIN() | Use the toBinary() method in the Engineering\ConvertDecimal class instead |
283 | Engineering::DECTOHEX() | Use the toHex() method in the Engineering\ConvertDecimal class instead |
319 | Engineering::DECTOOCT() | Use the toOctal() method in the Engineering\ConvertDecimal class instead |
355 | Engineering::HEXTOBIN() | Use the toBinary() method in the Engineering\ConvertHex class instead |
382 | Engineering::HEXTODEC() | Use the toDecimal() method in the Engineering\ConvertHex class instead |
422 | Engineering::HEXTOOCT() | Use the toOctal() method in the Engineering\ConvertHex class instead |
464 | Engineering::OCTTOBIN() | Use the toBinary() method in the Engineering\ConvertOctal class instead |
491 | Engineering::OCTTODEC() | Use the toDecimal() method in the Engineering\ConvertOctal class instead |
528 | Engineering::OCTTOHEX() | Use the toHex() method in the Engineering\ConvertOctal class instead |
552 | Engineering::COMPLEX() | Use the COMPLEX() method in the Engineering\Complex class instead |
574 | Engineering::IMAGINARY() | Use the IMAGINARY() method in the Engineering\Complex class instead |
595 | Engineering::IMREAL() | Use the IMREAL() method in the Engineering\Complex class instead |
616 | Engineering::IMABS() | Use the IMABS() method in the Engineering\ComplexFunctions class instead |
638 | Engineering::IMARGUMENT() | Use the IMARGUMENT() method in the Engineering\ComplexFunctions class instead |
659 | Engineering::IMCONJUGATE() | Use the IMCONJUGATE() method in the Engineering\ComplexFunctions class instead |
680 | Engineering::IMCOS() | Use the IMCOS() method in the Engineering\ComplexFunctions class instead |
701 | Engineering::IMCOSH() | Use the IMCOSH() method in the Engineering\ComplexFunctions class instead |
722 | Engineering::IMCOT() | Use the IMCOT() method in the Engineering\ComplexFunctions class instead |
743 | Engineering::IMCSC() | Use the IMCSC() method in the Engineering\ComplexFunctions class instead |
764 | Engineering::IMCSCH() | Use the IMCSCH() method in the Engineering\ComplexFunctions class instead |
785 | Engineering::IMSIN() | Use the IMSIN() method in the Engineering\ComplexFunctions class instead |
806 | Engineering::IMSINH() | Use the IMSINH() method in the Engineering\ComplexFunctions class instead |
827 | Engineering::IMSEC() | Use the IMSEC() method in the Engineering\ComplexFunctions class instead |
848 | Engineering::IMSECH() | Use the IMSECH() method in the Engineering\ComplexFunctions class instead |
869 | Engineering::IMTAN() | Use the IMTAN() method in the Engineering\ComplexFunctions class instead |
890 | Engineering::IMSQRT() | Use the IMSQRT() method in the Engineering\ComplexFunctions class instead |
911 | Engineering::IMLN() | Use the IMLN() method in the Engineering\ComplexFunctions class instead |
932 | Engineering::IMLOG10() | Use the IMLOG10() method in the Engineering\ComplexFunctions class instead |
953 | Engineering::IMLOG2() | Use the IMLOG2() method in the Engineering\ComplexFunctions class instead |
974 | Engineering::IMEXP() | Use the IMEXP() method in the Engineering\ComplexFunctions class instead |
996 | Engineering::IMPOWER() | Use the IMPOWER() method in the Engineering\ComplexFunctions class instead |
1018 | Engineering::IMDIV() | Use the IMDIV() method in the Engineering\ComplexOperations class instead |
1040 | Engineering::IMSUB() | Use the IMSUB() method in the Engineering\ComplexOperations class instead |
1061 | Engineering::IMSUM() | Use the IMSUM() method in the Engineering\ComplexOperations class instead |
1082 | Engineering::IMPRODUCT() | Use the IMPRODUCT() method in the Engineering\ComplexOperations class instead |
1107 | Engineering::DELTA() | Use the DELTA() method in the Engineering\Compare class instead |
1131 | Engineering::GESTEP() | Use the GESTEP() method in the Engineering\Compare class instead |
1153 | Engineering::BITAND() | Use the BITAND() method in the Engineering\BitWise class instead |
1175 | Engineering::BITOR() | Use the BITOR() method in the Engineering\BitWise class instead |
1197 | Engineering::BITXOR() | Use the BITXOR() method in the Engineering\BitWise class instead |
1219 | Engineering::BITLSHIFT() | Use the BITLSHIFT() method in the Engineering\BitWise class instead |
1241 | Engineering::BITRSHIFT() | Use the BITRSHIFT() method in the Engineering\BitWise class instead |
1269 | Engineering::ERF() | Use the ERF() method in the Engineering\Erf class instead |
1290 | Engineering::ERFPRECISE() | Use the ERFPRECISE() method in the Engineering\Erf class instead |
1316 | Engineering::ERFC() | Use the ERFC() method in the Engineering\ErfC class instead |
1331 | Engineering::getConversionGroups() | Use the getConversionCategories() method in the Engineering\ConvertUOM class instead |
1348 | Engineering::getConversionGroupUnits() | Use the getConversionCategoryUnits() method in the ConvertUOM class instead |
1364 | Engineering::getConversionGroupUnitDetails() | Use the getConversionCategoryUnitDetails() method in the ConvertUOM class instead |
1379 | Engineering::getConversionMultipliers() | Use the getConversionMultipliers() method in the ConvertUOM class instead |
1396 | Engineering::getBinaryConversionMultipliers() | Use the getBinaryConversionMultipliers() method in the ConvertUOM class instead |
1421 | Engineering::CONVERTUOM() | Use the CONVERT() method in the ConvertUOM class instead |
21 | Engineering::EULER | Use Engineering\Constants::EULER instead |
Financial.php
Line | Element | Reason |
---|---|---|
16 | Financial | |
59 | Financial::ACCRINT() | Use the periodic() method in the Financial\Securities\AccruedInterest class instead |
107 | Financial::ACCRINTM() | Use the atMaturity() method in the Financial\Securities\AccruedInterest class instead |
146 | Financial::AMORDEGRC() | Use the AMORDEGRC() method in the Financial\Amortization class instead |
180 | Financial::AMORLINC() | Use the AMORLINC() method in the Financial\Amortization class instead |
216 | Financial::COUPDAYBS() | Use the COUPDAYBS() method in the Financial\Coupons class instead |
252 | Financial::COUPDAYS() | Use the COUPDAYS() method in the Financial\Coupons class instead |
288 | Financial::COUPDAYSNC() | Use the COUPDAYSNC() method in the Financial\Coupons class instead |
325 | Financial::COUPNCD() | Use the COUPNCD() method in the Financial\Coupons class instead |
362 | Financial::COUPNUM() | Use the COUPNUM() method in the Financial\Coupons class instead |
399 | Financial::COUPPCD() | Use the COUPPCD() method in the Financial\Coupons class instead |
428 | Financial::CUMIPMT() | Use the interest() method in the Financial\CashFlow\Constant\Periodic\Cumulative class instead |
457 | Financial::CUMPRINC() | Use the principal() method in the Financial\CashFlow\Constant\Periodic\Cumulative class instead |
491 | Financial::DB() | Use the DB() method in the Financial\Depreciation class instead |
522 | Financial::DDB() | Use the DDB() method in the Financial\Depreciation class instead |
555 | Financial::DISC() | Use the discount() method in the Financial\Securities\Rates class instead |
579 | Financial::DOLLARDE() | Use the decimal() method in the Financial\Dollar class instead |
603 | Financial::DOLLARFR() | Use the fractional() method in the Financial\Dollar class instead |
626 | Financial::EFFECT() | Use the effective() method in the Financial\InterestRate class instead |
656 | Financial::FV() | Use the futureValue() method in the Financial\CashFlow\Constant\Periodic class instead |
679 | Financial::FVSCHEDULE() | Use the futureValue() method in the Financial\CashFlow\Single class instead |
712 | Financial::INTRATE() | Use the interest() method in the Financial\Securities\Rates class instead |
739 | Financial::IPMT() | Use the payment() method in the Financial\CashFlow\Constant\Periodic\Interest class instead |
768 | Financial::IRR() | Use the rate() method in the Financial\CashFlow\Variable\Periodic class instead |
797 | Financial::ISPMT() | Use the schedulePayment() method in the Financial\CashFlow\Constant\Periodic\Interest class instead |
823 | Financial::MIRR() | Use the modifiedRate() method in the Financial\CashFlow\Variable\Periodic class instead |
845 | Financial::NOMINAL() | Use the nominal() method in the Financial\InterestRate class instead |
867 | Financial::NPER() | Use the periods() method in the Financial\CashFlow\Constant\Periodic class instead |
885 | Financial::NPV() | Use the presentValue() method in the Financial\CashFlow\Variable\Periodic class instead |
905 | Financial::PDURATION() | Use the periods() method in the Financial\CashFlow\Single class instead |
927 | Financial::PMT() | Use the annuity() method in the Financial\CashFlow\Constant\Periodic\Payments class instead |
951 | Financial::PPMT() | Use the interestPayment() method in the Financial\CashFlow\Constant\Periodic\Payments class instead |
986 | Financial::PRICE() | Use the price() method in the Financial\Securities\Price class instead |
1016 | Financial::PRICEDISC() | Use the priceDiscounted() method in the Financial\Securities\Price class instead |
1047 | Financial::PRICEMAT() | Use the priceAtMaturity() method in the Financial\Securities\Price class instead |
1069 | Financial::PV() | Use the presentValue() method in the Financial\CashFlow\Constant\Periodic class instead |
1107 | Financial::RATE() | Use the rate() method in the Financial\CashFlow\Constant\Periodic\Interest class instead |
1137 | Financial::RECEIVED() | Use the received() method in the Financial\Securities\Price class instead |
1157 | Financial::RRI() | Use the interestRate() method in the Financial\CashFlow\Single class instead |
1177 | Financial::SLN() | Use the SLN() method in the Financial\Depreciation class instead |
1198 | Financial::SYD() | Use the SYD() method in the Financial\Depreciation class instead |
1221 | Financial::TBILLEQ() | Use the bondEquivalentYield() method in the Financial\TreasuryBill class instead |
1244 | Financial::TBILLPRICE() | Use the price() method in the Financial\TreasuryBill class instead |
1267 | Financial::TBILLYIELD() | Use the yield() method in the Financial\TreasuryBill class instead |
1293 | Financial::XIRR() | Use the rate() method in the Financial\CashFlow\Variable\NonPeriodic class instead |
1324 | Financial::XNPV() | Use the presentValue() method in the Financial\CashFlow\Variable\NonPeriodic class instead |
1354 | Financial::YIELDDISC() | Use the yieldDiscounted() method in the Financial\Securities\Yields class instead |
1385 | Financial::YIELDMAT() | Use the yieldAtMaturity() method in the Financial\Securities\Yields class instead |
Functions.php
Line | Element | Reason |
---|---|---|
223 | Functions::null() | Use the null() method in the Information\ExcelError class instead |
238 | Functions::NAN() | Use the NAN() method in the Information\Error class instead |
253 | Functions::REF() | Use the REF() method in the Information\ExcelError class instead |
272 | Functions::NA() | Use the NA() method in the Information\ExcelError class instead |
287 | Functions::VALUE() | Use the VALUE() method in the Information\ExcelError class instead |
302 | Functions::NAME() | Use the NAME() method in the Information\ExcelError class instead |
315 | Functions::DIV0() | Use the DIV0() method in the Information\ExcelError class instead |
330 | Functions::errorType() | Use the type() method in the Information\ExcelError class instead |
345 | Functions::isBlank() | Use the isBlank() method in the Information\Value class instead |
360 | Functions::isErr() | Use the isErr() method in the Information\ErrorValue class instead |
375 | Functions::isError() | Use the isError() method in the Information\ErrorValue class instead |
390 | Functions::isNa() | Use the isNa() method in the Information\ErrorValue class instead |
405 | Functions::isEven() | Use the isEven() method in the Information\Value class instead |
420 | Functions::isOdd() | Use the isOdd() method in the Information\Value class instead |
435 | Functions::isNumber() | Use the isNumber() method in the Information\Value class instead |
450 | Functions::isLogical() | Use the isLogical() method in the Information\Value class instead |
465 | Functions::isText() | Use the isText() method in the Information\Value class instead |
480 | Functions::isNonText() | Use the isNonText() method in the Information\Value class instead |
504 | Functions::n() | Use the asNumber() method in the Information\Value class instead |
527 | Functions::TYPE() | Use the type() method in the Information\Value class instead |
639 | Functions::isFormula() | Use the isFormula() method in the Information\Value class instead |
ExcelError.php
Line | Element | Reason |
---|---|---|
42 | ExcelError::$errorCodes | Use ERROR_CODES constant instead. |
Logical.php
Line | Element | Reason |
---|---|---|
10 | Logical | |
26 | Logical::true() | Use the TRUE() method in the Logical\Boolean class instead |
45 | Logical::false() | Use the FALSE() method in the Logical\Boolean class instead |
74 | Logical::logicalAnd() | Use the logicalAnd() method in the Logical\Operations class instead |
103 | Logical::logicalOr() | Use the logicalOr() method in the Logical\Operations class instead |
134 | Logical::logicalXor() | Use the logicalXor() method in the Logical\Operations class instead |
162 | Logical::NOT() | Use the NOT() method in the Logical\Operations class instead |
202 | Logical::statementIf() | Use the statementIf() method in the Logical\Conditional class instead |
235 | Logical::statementSwitch() | Use the statementSwitch() method in the Logical\Conditional class instead |
255 | Logical::IFERROR() | Use the IFERROR() method in the Logical\Conditional class instead |
275 | Logical::IFNA() | Use the IFNA() method in the Logical\Conditional class instead |
299 | Logical::IFS() | Use the IFS() method in the Logical\Conditional class instead |
LookupRef.php
Line | Element | Reason |
---|---|---|
19 | LookupRef | |
47 | LookupRef::cellAddress() | Use the cell() method in the LookupRef\Address class instead |
73 | LookupRef::COLUMN() | Use the COLUMN() method in the LookupRef\RowColumnInformation class instead |
95 | LookupRef::COLUMNS() | Use the COLUMNS() method in the LookupRef\RowColumnInformation class instead |
121 | LookupRef::ROW() | Use the ROW() method in the LookupRef\RowColumnInformation class instead |
143 | LookupRef::ROWS() | Use the ROWS() method in the LookupRef\RowColumnInformation class instead |
164 | LookupRef::HYPERLINK() | Use the set() method in the LookupRef\Hyperlink class instead |
189 | LookupRef::INDIRECT() | Use the INDIRECT() method in the LookupRef\Indirect class instead |
228 | LookupRef::OFFSET() | Use the OFFSET() method in the LookupRef\Offset class instead |
250 | LookupRef::CHOOSE() | Use the choose() method in the LookupRef\Selection class instead |
274 | LookupRef::MATCH() | Use the MATCH() method in the LookupRef\ExcelMatch class instead |
299 | LookupRef::INDEX() | Use the index() method in the LookupRef\Matrix class instead |
318 | LookupRef::TRANSPOSE() | Use the transpose() method in the LookupRef\Matrix class instead |
340 | LookupRef::VLOOKUP() | Use the lookup() method in the LookupRef\VLookup class instead |
362 | LookupRef::HLOOKUP() | Use the lookup() method in the LookupRef\HLookup class instead |
381 | LookupRef::LOOKUP() | Use the lookup() method in the LookupRef\Lookup class instead |
398 | LookupRef::FORMULATEXT() | Use the text() method in the LookupRef\Formula class instead |
MathTrig.php
Line | Element | Reason |
---|---|---|
8 | MathTrig | |
26 | MathTrig::ARABIC() | Use the evaluate method in the MathTrig\Arabic class instead |
56 | MathTrig::ATAN2() | Use the atan2 method in the MathTrig\Trig\Tangent class instead |
79 | MathTrig::BASE() | Use the evaluate method in the MathTrig\Base class instead |
104 | MathTrig::CEILING() | Use the ceiling() method in the MathTrig\Ceiling class instead |
127 | MathTrig::COMBIN() | Use the withoutRepetition() method in the MathTrig\Combinations class instead |
152 | MathTrig::EVEN() | Use the even() method in the MathTrig\Round class instead |
164 | MathTrig::getEven() | Use the evaluate() method in the MathTrig\Helpers class instead |
186 | MathTrig::FACT() | Use the fact() method in the MathTrig\Factorial class instead |
207 | MathTrig::FACTDOUBLE() | Use the factDouble() method in the MathTrig\Factorial class instead |
229 | MathTrig::FLOOR() | Use the floor() method in the MathTrig\Floor class instead |
252 | MathTrig::FLOORMATH() | Use the math() method in the MathTrig\Floor class instead |
274 | MathTrig::FLOORPRECISE() | Use the precise() method in the MathTrig\Floor class instead |
295 | MathTrig::INT() | Use the evaluate() method in the MathTrig\IntClass class instead |
318 | MathTrig::GCD() | Use the evaluate() method in the MathTrig\Gcd class instead |
342 | MathTrig::LCM() | Use the evaluate() method in the MathTrig\Lcm class instead |
364 | MathTrig::logBase() | Use the withBase() method in the MathTrig\Logarithms class instead |
385 | MathTrig::MDETERM() | Use the determinant() method in the MathTrig\MatrixFunctions class instead |
406 | MathTrig::MINVERSE() | Use the inverse() method in the MathTrig\MatrixFunctions class instead |
423 | MathTrig::MMULT() | Use the multiply() method in the MathTrig\MatrixFunctions class instead |
440 | MathTrig::MOD() | Use the mod() method in the MathTrig\Operations class instead |
459 | MathTrig::MROUND() | Use the multiple() method in the MathTrig\Mround class instead |
477 | MathTrig::MULTINOMIAL() | Use the multinomial method in the MathTrig\Factorial class instead |
495 | MathTrig::ODD() | Use the odd method in the MathTrig\Round class instead |
514 | MathTrig::POWER() | Use the evaluate method in the MathTrig\Power class instead |
535 | MathTrig::PRODUCT() | Use the product method in the MathTrig\Operations class instead |
558 | MathTrig::QUOTIENT() | Use the quotient method in the MathTrig\Operations class instead |
575 | MathTrig::RAND() | Use the randBetween or randBetween method in the MathTrig\Random class instead |
594 | MathTrig::ROMAN() | Use the evaluate() method in the MathTrig\Roman class instead |
613 | MathTrig::ROUNDUP() | Use the up() method in the MathTrig\Round class instead |
632 | MathTrig::ROUNDDOWN() | Use the down() method in the MathTrig\Round class instead |
653 | MathTrig::SERIESSUM() | Use the evaluate method in the MathTrig\SeriesSum class instead |
672 | MathTrig::SIGN() | Use the evaluate method in the MathTrig\Sign class instead |
684 | MathTrig::returnSign() | Use the returnSign method in the MathTrig\Helpers class instead |
702 | MathTrig::SQRTPI() | Use the pi method in the MathTrig\Sqrt class instead |
727 | MathTrig::SUBTOTAL() | Use the evaluate method in the MathTrig\Subtotal class instead |
748 | MathTrig::SUM() | Use the sumErroringStrings method in the MathTrig\Sum class instead |
771 | MathTrig::SUMIF() | Use the SUMIF() method in the Statistical\Conditional class instead |
792 | MathTrig::SUMIFS() | Use the SUMIFS() method in the Statistical\Conditional class instead |
811 | MathTrig::SUMPRODUCT() | Use the product method in the MathTrig\Sum class instead |
832 | MathTrig::SUMSQ() | Use the sumSquare method in the MathTrig\SumSquares class instead |
849 | MathTrig::SUMX2MY2() | Use the sumXSquaredMinusYSquared method in the MathTrig\SumSquares class instead |
866 | MathTrig::SUMX2PY2() | Use the sumXSquaredPlusYSquared method in the MathTrig\SumSquares class instead |
883 | MathTrig::SUMXMY2() | Use the sumXMinusYSquared method in the MathTrig\SumSquares class instead |
902 | MathTrig::TRUNC() | Use the evaluate() method in the MathTrig\Trunc class instead |
920 | MathTrig::SEC() | Use the sec method in the MathTrig\Trig\Secant class instead |
938 | MathTrig::SECH() | Use the sech method in the MathTrig\Trig\Secant class instead |
956 | MathTrig::CSC() | Use the csc method in the MathTrig\Trig\Cosecant class instead |
974 | MathTrig::CSCH() | Use the csch method in the MathTrig\Trig\Cosecant class instead |
992 | MathTrig::COT() | Use the cot method in the MathTrig\Trig\Cotangent class instead |
1010 | MathTrig::COTH() | Use the coth method in the MathTrig\Trig\Cotangent class instead |
1028 | MathTrig::ACOT() | Use the acot method in the MathTrig\Trig\Cotangent class instead |
1044 | MathTrig::numberOrNan() | Use the numberOrNan method in the MathTrig\Helpers class instead |
1062 | MathTrig::ACOTH() | Use the acoth method in the MathTrig\Trig\Cotangent class instead |
1081 | MathTrig::builtinROUND() | Use the round() method in the MathTrig\Round class instead |
1099 | MathTrig::builtinABS() | Use the evaluate method in the MathTrig\Absolute class instead |
1117 | MathTrig::builtinACOS() | Use the acos method in the MathTrig\Trig\Cosine class instead |
1135 | MathTrig::builtinACOSH() | Use the acosh method in the MathTrig\Trig\Cosine class instead |
1153 | MathTrig::builtinASIN() | Use the asin method in the MathTrig\Trig\Sine class instead |
1171 | MathTrig::builtinASINH() | Use the asinh method in the MathTrig\Trig\Sine class instead |
1189 | MathTrig::builtinATAN() | Use the atan method in the MathTrig\Trig\Tangent class instead |
1207 | MathTrig::builtinATANH() | Use the atanh method in the MathTrig\Trig\Tangent class instead |
1225 | MathTrig::builtinCOS() | Use the cos method in the MathTrig\Trig\Cosine class instead |
1243 | MathTrig::builtinCOSH() | Use the cosh method in the MathTrig\Trig\Cosine class instead |
1261 | MathTrig::builtinDEGREES() | Use the toDegrees method in the MathTrig\Angle class instead |
1279 | MathTrig::builtinEXP() | Use the evaluate method in the MathTrig\Exp class instead |
1297 | MathTrig::builtinLN() | Use the natural method in the MathTrig\Logarithms class instead |
1315 | MathTrig::builtinLOG10() | Use the natural method in the MathTrig\Logarithms class instead |
1333 | MathTrig::builtinRADIANS() | Use the toRadians method in the MathTrig\Angle class instead |
1351 | MathTrig::builtinSIN() | Use the sin method in the MathTrig\Trig\Sine class instead |
1369 | MathTrig::builtinSINH() | Use the sinh method in the MathTrig\Trig\Sine class instead |
1387 | MathTrig::builtinSQRT() | Use the sqrt method in the MathTrig\Sqrt class instead |
1405 | MathTrig::builtinTAN() | Use the tan method in the MathTrig\Trig\Tangent class instead |
1423 | MathTrig::builtinTANH() | Use the tanh method in the MathTrig\Trig\Tangent class instead |
1437 | MathTrig::nullFalseTrueToNumber() | Use the validateNumericNullBool method in the MathTrig\Helpers class instead |
Statistical.php
Line | Element | Reason |
---|---|---|
19 | Statistical | |
43 | Statistical::AVEDEV() | Use the averageDeviations() method in the Statistical\Averages class instead |
64 | Statistical::AVERAGE() | Use the average() method in the Statistical\Averages class instead |
85 | Statistical::AVERAGEA() | Use the averageA() method in the Statistical\Averages class instead |
108 | Statistical::AVERAGEIF() | Use the AVERAGEIF() method in the Statistical\Conditional class instead |
130 | Statistical::BETADIST() | Use the distribution() method in the Statistical\Distributions\Beta class instead |
152 | Statistical::BETAINV() | Use the inverse() method in the Statistical\Distributions\Beta class instead |
177 | Statistical::BINOMDIST() | Use the distribution() method in the Statistical\Distributions\Binomial class instead |
196 | Statistical::CHIDIST() | Use the distributionRightTail() method in the Statistical\Distributions\ChiSquared class instead |
215 | Statistical::CHIINV() | Use the inverseRightTail() method in the Statistical\Distributions\ChiSquared class instead |
235 | Statistical::CONFIDENCE() | Use the CONFIDENCE() method in the Statistical\Confidence class instead |
254 | Statistical::CORREL() | Use the CORREL() method in the Statistical\Trends class instead |
275 | Statistical::COUNT() | Use the COUNT() method in the Statistical\Counts class instead |
296 | Statistical::COUNTA() | Use the COUNTA() method in the Statistical\Counts class instead |
317 | Statistical::COUNTBLANK() | Use the COUNTBLANK() method in the Statistical\Counts class instead |
339 | Statistical::COUNTIF() | Use the COUNTIF() method in the Statistical\Conditional class instead |
360 | Statistical::COUNTIFS() | Use the COUNTIFS() method in the Statistical\Conditional class instead |
379 | Statistical::COVAR() | Use the COVAR() method in the Statistical\Trends class instead |
402 | Statistical::CRITBINOM() | Use the inverse() method in the Statistical\Distributions\Binomial class instead |
423 | Statistical::DEVSQ() | Use the sumSquares() method in the Statistical\Deviations class instead |
445 | Statistical::EXPONDIST() | Use the distribution() method in the Statistical\Distributions\Exponential class instead |
470 | Statistical::FDIST2() | Use the distribution() method in the Statistical\Distributions\F class instead |
490 | Statistical::FISHER() | Use the distribution() method in the Statistical\Distributions\Fisher class instead |
510 | Statistical::FISHERINV() | Use the inverse() method in the Statistical\Distributions\Fisher class instead |
530 | Statistical::FORECAST() | Use the FORECAST() method in the Statistical\Trends class instead |
548 | Statistical::GAMMAFunction() | Use the gamma() method in the Statistical\Distributions\Gamma class instead |
569 | Statistical::GAMMADIST() | Use the distribution() method in the Statistical\Distributions\Gamma class instead |
589 | Statistical::GAMMAINV() | Use the inverse() method in the Statistical\Distributions\Gamma class instead |
607 | Statistical::GAMMALN() | Use the ln() method in the Statistical\Distributions\Gamma class instead |
626 | Statistical::GAUSS() | Use the gauss() method in the Statistical\Distributions\StandardNormal class instead |
649 | Statistical::GEOMEAN() | Use the geometric() method in the Statistical\Averages\Mean class instead |
670 | Statistical::GROWTH() | Use the GROWTH() method in the Statistical\Trends class instead |
692 | Statistical::HARMEAN() | Use the harmonic() method in the Statistical\Averages\Mean class instead |
714 | Statistical::HYPGEOMDIST() | Use the distribution() method in the Statistical\Distributions\HyperGeometric class instead |
738 | Statistical::INTERCEPT() | Use the INTERCEPT() method in the Statistical\Trends class instead |
759 | Statistical::KURT() | Use the kurtosis() method in the Statistical\Deviations class instead |
781 | Statistical::LARGE() | Use the large() method in the Statistical\Size class instead |
803 | Statistical::LINEST() | Use the LINEST() method in the Statistical\Trends class instead |
825 | Statistical::LOGEST() | Use the LOGEST() method in the Statistical\Trends class instead |
849 | Statistical::LOGINV() | Use the inverse() method in the Statistical\Distributions\LogNormal class instead |
870 | Statistical::LOGNORMDIST() | Use the cumulative() method in the Statistical\Distributions\LogNormal class instead |
892 | Statistical::LOGNORMDIST2() | Use the distribution() method in the Statistical\Distributions\LogNormal class instead |
914 | Statistical::MAX() | Use the MAX() method in the Statistical\Maximum class instead |
935 | Statistical::MAXA() | Use the MAXA() method in the Statistical\Maximum class instead |
956 | Statistical::MAXIFS() | Use the MAXIFS() method in the Statistical\Conditional class instead |
977 | Statistical::MEDIAN() | Use the median() method in the Statistical\Averages class instead |
999 | Statistical::MIN() | Use the min() method in the Statistical\Minimum class instead |
1020 | Statistical::MINA() | Use the minA() method in the Statistical\Minimum class instead |
1041 | Statistical::MINIFS() | Use the MINIFS() method in the Statistical\Conditional class instead |
1062 | Statistical::MODE() | Use the mode() method in the Statistical\Averages class instead |
1086 | Statistical::NEGBINOMDIST() | Use the negative() method in the Statistical\Distributions\Binomial class instead |
1109 | Statistical::NORMDIST() | Use the distribution() method in the Statistical\Distributions\Normal class instead |
1129 | Statistical::NORMINV() | Use the inverse() method in the Statistical\Distributions\Normal class instead |
1149 | Statistical::NORMSDIST() | Use the cumulative() method in the Statistical\Distributions\StandardNormal class instead |
1170 | Statistical::NORMSDIST2() | Use the distribution() method in the Statistical\Distributions\StandardNormal class instead |
1188 | Statistical::NORMSINV() | Use the inverse() method in the Statistical\Distributions\StandardNormal class instead |
1209 | Statistical::PERCENTILE() | Use the PERCENTILE() method in the Statistical\Percentiles class instead |
1232 | Statistical::PERCENTRANK() | Use the PERCENTRANK() method in the Statistical\Percentiles class instead |
1255 | Statistical::PERMUT() | Use the PERMUT() method in the Statistical\Permutations class instead |
1277 | Statistical::POISSON() | Use the distribution() method in the Statistical\Distributions\Poisson class instead |
1298 | Statistical::QUARTILE() | Use the QUARTILE() method in the Statistical\Percentiles class instead |
1318 | Statistical::RANK() | Use the RANK() method in the Statistical\Percentiles class instead |
1337 | Statistical::RSQ() | Use the RSQ() method in the Statistical\Trends class instead |
1358 | Statistical::SKEW() | Use the skew() method in the Statistical\Deviations class instead |
1377 | Statistical::SLOPE() | Use the SLOPE() method in the Statistical\Trends class instead |
1399 | Statistical::SMALL() | Use the small() method in the Statistical\Size class instead |
1419 | Statistical::STANDARDIZE() | Use the execute() method in the Statistical\Standardize class instead |
1441 | Statistical::STDEV() | Use the STDEV() method in the Statistical\StandardDeviations class instead |
1462 | Statistical::STDEVA() | Use the STDEVA() method in the Statistical\StandardDeviations class instead |
1483 | Statistical::STDEVP() | Use the STDEVP() method in the Statistical\StandardDeviations class instead |
1504 | Statistical::STDEVPA() | Use the STDEVPA() method in the Statistical\StandardDeviations class instead |
1523 | Statistical::STEYX() | Use the STEYX() method in the Statistical\Trends class instead |
1543 | Statistical::TDIST() | Use the distribution() method in the Statistical\Distributions\StudentT class instead |
1562 | Statistical::TINV() | Use the inverse() method in the Statistical\Distributions\StudentT class instead |
1583 | Statistical::TREND() | Use the TREND() method in the Statistical\Trends class instead |
1606 | Statistical::TRIMMEAN() | Use the trim() method in the Statistical\Averages\Mean class instead |
1627 | Statistical::VARFunc() | Use the VAR() method in the Statistical\Variances class instead |
1648 | Statistical::VARA() | Use the VARA() method in the Statistical\Variances class instead |
1669 | Statistical::VARP() | Use the VARP() method in the Statistical\Variances class instead |
1690 | Statistical::VARPA() | Use the VARPA() method in the Statistical\Variances class instead |
1712 | Statistical::WEIBULL() | Use the distribution() method in the Statistical\Distributions\Weibull class instead |
1735 | Statistical::ZTEST() | Use the zTest() method in the Statistical\Distributions\StandardNormal class instead |
TextData.php
Line | Element | Reason |
---|---|---|
10 | TextData | |
23 | TextData::CHARACTER() | Use the character() method in the TextData\CharacterConvert class instead |
39 | TextData::TRIMNONPRINTABLE() | Use the nonPrintable() method in the TextData\Trim class instead |
55 | TextData::TRIMSPACES() | Use the spaces() method in the TextData\Trim class instead |
71 | TextData::ASCIICODE() | Use the code() method in the TextData\CharacterConvert class instead |
87 | TextData::CONCATENATE() | Use the CONCATENATE() method in the TextData\Concatenate class instead |
109 | TextData::DOLLAR() | Use the DOLLAR() method in the TextData\Format class instead |
127 | TextData::SEARCHSENSITIVE() | Use the sensitive() method in the TextData\Search class instead |
145 | TextData::SEARCHINSENSITIVE() | Use the insensitive() method in the TextData\Search class instead |
163 | TextData::FIXEDFORMAT() | Use the FIXEDFORMAT() method in the TextData\Format class instead |
180 | TextData::LEFT() | Use the left() method in the TextData\Extract class instead |
198 | TextData::MID() | Use the mid() method in the TextData\Extract class instead |
215 | TextData::RIGHT() | Use the right() method in the TextData\Extract class instead |
231 | TextData::STRINGLENGTH() | Use the length() method in the TextData\Text class instead |
249 | TextData::LOWERCASE() | Use the lower() method in the TextData\CaseConvert class instead |
267 | TextData::UPPERCASE() | Use the upper() method in the TextData\CaseConvert class instead |
285 | TextData::PROPERCASE() | Use the proper() method in the TextData\CaseConvert class instead |
304 | TextData::REPLACE() | Use the replace() method in the TextData\Replace class instead |
323 | TextData::SUBSTITUTE() | Use the substitute() method in the TextData\Replace class instead |
339 | TextData::RETURNSTRING() | Use the test() method in the TextData\Text class instead |
356 | TextData::TEXTFORMAT() | Use the TEXTFORMAT() method in the TextData\Format class instead |
372 | TextData::VALUE() | Use the VALUE() method in the TextData\Format class instead |
390 | TextData::NUMBERVALUE() | Use the NUMBERVALUE() method in the TextData\Format class instead |
409 | TextData::EXACT() | Use the exact() method in the TextData\Text class instead |
427 | TextData::TEXTJOIN() | Use the TEXTJOIN() method in the TextData\Concatenate class instead |
446 | TextData::builtinREPT() | Use the builtinREPT() method in the TextData\Concatenate class instead |
Web.php
Line | Element | Reason |
---|---|---|
10 | Web | |
26 | Web::WEBSERVICE() | Use the webService() method in the Web\Service class instead |
Axis.php
Line | Element | Reason |
---|---|---|
269 | Axis::getLineProperty() | Use the getLineColor property in the Properties class instead |
Chart.php
Line | Element | Reason |
---|---|---|
395 | Chart::getMajorGridlines() | Use Axis->getMajorGridlines() |
408 | Chart::getMinorGridlines() | Use Axis->getMinorGridlines() |
ChartColor.php
Line | Element | Reason |
---|---|---|
11 | ChartColor::EXCEL_COLOR_TYPE_ARGB | use EXCEL_COLOR_TYPE_RGB instead |
Properties.php
Line | Element | Reason |
---|---|---|
14 | Properties::EXCEL_COLOR_TYPE_STANDARD | use constant from ChartColor instead |
16 | Properties::EXCEL_COLOR_TYPE_SCHEME | use constant from ChartColor instead |
18 | Properties::EXCEL_COLOR_TYPE_ARGB | use constant from ChartColor instead |
64 | Properties::LINE_STYLE_DASH_SQUERE_DOT | use LINE_STYLE_DASH_SQUARE_DOT instead |
Html.php
Line | Element | Reason |
---|---|---|
226 | Html::setInputEncoding() | no use is made of this property |
242 | Html::getInputEncoding() | no use is made of this property |
Slk.php
Line | Element | Reason |
---|---|---|
111 | Slk::setInputEncoding() | no use is made of this property |
127 | Slk::getInputEncoding() | no use is made of this property |
Settings.php
Line | Element | Reason |
---|---|---|
136 | Settings::setLibXmlDisableEntityLoader() | will be removed without replacement as it is no longer necessary on PHP 7.3.0+ |
150 | Settings::getLibXmlDisableEntityLoader() | will be removed without replacement as it is no longer necessary on PHP 7.3.0+ |
Drawing.php
Line | Element | Reason |
---|---|---|
168 | Drawing::imagecreatefrombmp() | use Php function imagecreatefrombmp instead |
Font.php
Line | Element | Reason |
---|---|---|
290 | Font::$defaultColumnWidths | Use DEFAULT_COLUMN_WIDTHS constant instead. |
NumberFormat.php
Line | Element | Reason |
---|---|---|
23 | NumberFormat::FORMAT_DATE_YYYYMMDD2 | use FORMAT_DATE_YYYYMMDD instead |
83 | NumberFormat::FORMAT_CURRENCY_USD_SIMPLE | use FORMAT_CURRENCY_USD_INTEGER instead |
87 | NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE | use FORMAT_CURRENCY_EUR_INTEGER instead |
Worksheet.php
Line | Element | Reason |
---|---|---|
1199 | Worksheet::setCellValueByColumnAndRow() | Use the setCellValue() method with a cell address such as 'C5' instead;, or passing in an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object. |
1253 | Worksheet::setCellValueExplicitByColumnAndRow() | Use the setCellValueExplicit() method with a cell address such as 'C5' instead;, or passing in an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object. |
1380 | Worksheet::getCellByColumnAndRow() | Use the getCell() method with a cell address such as 'C5' instead;, or passing in an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object. |
1459 | Worksheet::cellExistsByColumnAndRow() | Use the cellExists() method with a cell address such as 'C5' instead;, or passing in an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object. |
1566 | Worksheet::getStyleByColumnAndRow() | Use the getStyle() method with a cell address range such as 'C5:F8' instead;, or passing in an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 8]), or an AddressRange object. |
1805 | Worksheet::setBreakByColumnAndRow() | Use the setBreak() method with a cell address such as 'C5' instead;, or passing in an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object. |
2024 | Worksheet::mergeCellsByColumnAndRow() | Use the mergeCells() method with a cell address range such as 'C5:F8' instead;, or passing in an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 8]), or an AddressRange object. |
2076 | Worksheet::unmergeCellsByColumnAndRow() | Use the unmergeCells() method with a cell address range such as 'C5:F8' instead;, or passing in an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 8]), or an AddressRange object. |
2152 | Worksheet::protectCellsByColumnAndRow() | Use the protectCells() method with a cell address range such as 'C5:F8' instead;, or passing in an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 8]), or an AddressRange object. |
2200 | Worksheet::unprotectCellsByColumnAndRow() | Use the unprotectCells() method with a cell address range such as 'C5:F8' instead;, or passing in an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 8]), or an AddressRange object. |
2269 | Worksheet::setAutoFilterByColumnAndRow() | Use the setAutoFilter() method with a cell address range such as 'C5:F8' instead;, or passing in an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 8]), or an AddressRange object or AutoFilter object. |
2462 | Worksheet::freezePaneByColumnAndRow() | Use the freezePane() method with a cell address such as 'C5' instead;, or passing in an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object. |
2881 | Worksheet::getCommentByColumnAndRow() | Use the getComment() method with a cell address such as 'C5' instead;, or passing in an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object. |
2958 | Worksheet::setSelectedCellByColumnAndRow() | Use the setSelectedCells() method with a cell address such as 'C5' instead;, or passing in an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object. |
Html.php
Line | Element | Reason |
---|---|---|
1654 | Html::getUseEmbeddedCSS() | no longer used |
1670 | Html::setUseEmbeddedCSS() | no longer used |