PhpSpreadsheet

Commit Graph

Author	SHA1	Message	Date
Mark Baker	a34dd71cce	Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959 ) * Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice * Simplify STDEV() function logic by remembering that STDEV() is simply the square root of VAR(), so we can simply use the VAR() calculaion rather than duplicating the basic logic... and also allow for the differences between Excel/Gnumeric and Open/LibreOffice	2021-03-27 18:31:24 +01:00
Mark Baker	f1e82a212f	Extended unit tests (#1087 ) * Merge branch 'master' of C:\Projects\PHPOffice\PHPSpreadsheet\develop with conflicts. * Additional unit tests for average functions, and fix to AVERAGEIF() function if third argument is passed * Update change log * Stricter typed comparisons in AVERAGEIF() conditions * Unit tests for BETADIST() and BETAINV()	2019-07-16 16:18:42 +02:00

Author

SHA1

Message

Date

Mark Baker

a34dd71cce

Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959 )

* Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice
* Simplify STDEV() function logic by remembering that STDEV() is simply the square root of VAR(), so we can simply use the VAR() calculaion rather than duplicating the basic logic... and also allow for the differences between Excel/Gnumeric and Open/LibreOffice

2021-03-27 18:31:24 +01:00

Mark Baker

f1e82a212f

Extended unit tests (#1087 )

* Merge branch 'master' of C:\Projects\PHPOffice\PHPSpreadsheet\develop with conflicts.

* Additional unit tests for average functions, and fix to AVERAGEIF() function if third argument is passed

* Update change log

* Stricter typed comparisons in AVERAGEIF() conditions

* Unit tests for BETADIST() and BETAINV()

2019-07-16 16:18:42 +02:00

2 Commits