Documentation

Deprecated

Table of Contents

src/PhpSpreadsheet/Calculation/Calculation.php
src/PhpSpreadsheet/Calculation/Database.php
src/PhpSpreadsheet/Calculation/DateTime.php
src/PhpSpreadsheet/Calculation/Engineering.php
src/PhpSpreadsheet/Calculation/Financial.php
src/PhpSpreadsheet/Calculation/Functions.php
src/PhpSpreadsheet/Calculation/Information/ExcelError.php
src/PhpSpreadsheet/Calculation/Logical.php
src/PhpSpreadsheet/Calculation/LookupRef.php
src/PhpSpreadsheet/Calculation/MathTrig.php
src/PhpSpreadsheet/Calculation/Statistical.php
src/PhpSpreadsheet/Calculation/TextData.php
src/PhpSpreadsheet/Calculation/Web.php
src/PhpSpreadsheet/Chart/Axis.php
src/PhpSpreadsheet/Chart/Chart.php
src/PhpSpreadsheet/Chart/ChartColor.php
src/PhpSpreadsheet/Chart/Properties.php
src/PhpSpreadsheet/Reader/Html.php
src/PhpSpreadsheet/Reader/Slk.php
src/PhpSpreadsheet/Settings.php
src/PhpSpreadsheet/Shared/Drawing.php
src/PhpSpreadsheet/Shared/Font.php
src/PhpSpreadsheet/Style/NumberFormat.php
src/PhpSpreadsheet/Worksheet/Worksheet.php
src/PhpSpreadsheet/Writer/Html.php

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

Search results