mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-21 01:10:42 +00:00
Adrien Crivelli
ec4098c8fd
While we might never be able to have 100% of our code strict, we can at the very least do it for all of our tests. This ensures that our tests are using our API with the types as intended by the test author, and not silently be cast to what our API requires.
244 lines
10 KiB
PHP
244 lines
10 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Calculation\Engine;
|
|
|
|
use PhpOffice\PhpSpreadsheet\Calculation\Engine\FormattedNumber;
|
|
use PhpOffice\PhpSpreadsheet\Shared\StringHelper;
|
|
use PHPUnit\Framework\TestCase;
|
|
|
|
class FormattedNumberTest extends TestCase
|
|
{
|
|
/**
|
|
* @dataProvider providerNumbers
|
|
*/
|
|
public function testNumber(float $expected, string $value): void
|
|
{
|
|
FormattedNumber::convertToNumberIfFormatted($value);
|
|
self::assertSame($expected, $value);
|
|
}
|
|
|
|
public static function providerNumbers(): array
|
|
{
|
|
return [
|
|
[-12.5, '-12.5'],
|
|
[-125.0, '-1.25e2'],
|
|
[0.125, '12.5%'],
|
|
[1234.5, '1,234.5'],
|
|
[-1234.5, '- 1,234.5'],
|
|
[1234.5, '+ 1,234.5'],
|
|
];
|
|
}
|
|
|
|
/**
|
|
* @dataProvider providerFractions
|
|
*/
|
|
public function testFraction(string $expected, string $value): void
|
|
{
|
|
$originalValue = $value;
|
|
$result = FormattedNumber::convertToNumberIfFraction($value);
|
|
if ($result === false) {
|
|
self::assertSame($expected, $originalValue);
|
|
self::assertSame($expected, $value);
|
|
} else {
|
|
self::assertSame($expected, (string) $value);
|
|
self::assertNotEquals($value, $originalValue);
|
|
}
|
|
}
|
|
|
|
public static function providerFractions(): array
|
|
{
|
|
return [
|
|
'non-fraction' => ['1', '1'],
|
|
'common fraction' => ['1.5', '1 1/2'],
|
|
'fraction between -1 and 0' => ['-0.5', '-1/2'],
|
|
'fraction between -1 and 0 with space' => ['-0.5', ' - 1/2'],
|
|
'fraction between 0 and 1' => ['0.75', '3/4 '],
|
|
'fraction between 0 and 1 with space' => ['0.75', ' 3/4'],
|
|
'improper fraction' => ['1.75', '7/4'],
|
|
];
|
|
}
|
|
|
|
/**
|
|
* @dataProvider providerPercentages
|
|
*/
|
|
public function testPercentage(string $expected, string $value): void
|
|
{
|
|
$originalValue = $value;
|
|
$result = FormattedNumber::convertToNumberIfPercent($value);
|
|
if ($result === false) {
|
|
self::assertSame($expected, $originalValue);
|
|
self::assertSame($expected, $value);
|
|
} else {
|
|
self::assertSame($expected, (string) $value);
|
|
self::assertNotEquals($value, $originalValue);
|
|
}
|
|
}
|
|
|
|
public static function providerPercentages(): array
|
|
{
|
|
return [
|
|
'non-percentage' => ['10', '10'],
|
|
'single digit percentage' => ['0.02', '2%'],
|
|
'two digit percentage' => ['0.13', '13%'],
|
|
'negative single digit percentage' => ['-0.07', '-7%'],
|
|
'negative two digit percentage' => ['-0.75', '-75%'],
|
|
'large percentage' => ['98.45', '9845%'],
|
|
'small percentage' => ['0.0005', '0.05%'],
|
|
'percentage with decimals' => ['0.025', '2.5%'],
|
|
'trailing percent with space' => ['0.02', '2 %'],
|
|
'trailing percent with leading and trailing space' => ['0.02', ' 2 % '],
|
|
'leading percent with decimals' => ['0.025', ' % 2.5'],
|
|
'Percentage with thousands separator' => ['12.345', ' % 1,234.5'],
|
|
|
|
//These should all fail
|
|
'percent only' => ['%', '%'],
|
|
'nonsense percent' => ['2%2', '2%2'],
|
|
'negative leading percent' => ['-0.02', '-%2'],
|
|
|
|
//Percent position permutations
|
|
'permutation_1' => ['0.02', '2%'],
|
|
'permutation_2' => ['0.02', ' 2%'],
|
|
'permutation_3' => ['0.02', '2% '],
|
|
'permutation_4' => ['0.02', ' 2 % '],
|
|
'permutation_5' => ['0.0275', '2.75% '],
|
|
'permutation_6' => ['0.0275', ' 2.75% '],
|
|
'permutation_7' => ['0.0275', ' 2.75 % '],
|
|
'permutation_8' => [' 2 . 75 %', ' 2 . 75 %'],
|
|
'permutation_9' => [' 2.7 5 % ', ' 2.7 5 % '],
|
|
'permutation_10' => ['-0.02', '-2%'],
|
|
'permutation_11' => ['-0.02', ' -2% '],
|
|
'permutation_12' => ['-0.02', '- 2% '],
|
|
'permutation_13' => ['-0.02', '-2 % '],
|
|
'permutation_14' => ['-0.0275', '-2.75% '],
|
|
'permutation_15' => ['-0.0275', ' -2.75% '],
|
|
'permutation_16' => ['-0.0275', '-2.75 % '],
|
|
'permutation_17' => ['-0.0275', ' - 2.75 % '],
|
|
'permutation_18' => ['0.02', '2%'],
|
|
'permutation_19' => ['0.02', '% 2 '],
|
|
'permutation_20' => ['0.02', ' %2 '],
|
|
'permutation_21' => ['0.02', ' % 2 '],
|
|
'permutation_22' => ['0.0275', '%2.75 '],
|
|
'permutation_23' => ['0.0275', ' %2.75 '],
|
|
'permutation_24' => ['0.0275', ' % 2.75 '],
|
|
'permutation_25' => [' %2 . 75 ', ' %2 . 75 '],
|
|
'permutation_26' => [' %2.7 5 ', ' %2.7 5 '],
|
|
'permutation_27' => [' % 2 . 75 ', ' % 2 . 75 '],
|
|
'permutation_28' => [' % 2.7 5 ', ' % 2.7 5 '],
|
|
'permutation_29' => ['-0.0275', '-%2.75 '],
|
|
'permutation_30' => ['-0.0275', ' - %2.75 '],
|
|
'permutation_31' => ['-0.0275', '- % 2.75 '],
|
|
'permutation_32' => ['-0.0275', ' - % 2.75 '],
|
|
'permutation_33' => ['0.02', '2%'],
|
|
'permutation_34' => ['0.02', '2 %'],
|
|
'permutation_35' => ['0.02', ' 2%'],
|
|
'permutation_36' => ['0.02', ' 2 % '],
|
|
'permutation_37' => ['0.0275', '2.75%'],
|
|
'permutation_38' => ['0.0275', ' 2.75 % '],
|
|
'permutation_39' => ['2 . 75 % ', '2 . 75 % '],
|
|
'permutation_40' => ['-0.0275', '-2.75% '],
|
|
'permutation_41' => ['-0.0275', '- 2.75% '],
|
|
'permutation_42' => ['-0.0275', ' - 2.75% '],
|
|
'permutation_43' => ['-0.0275', ' -2.75 % '],
|
|
'permutation_44' => ['-2. 75 % ', '-2. 75 % '],
|
|
'permutation_45' => ['%', '%'],
|
|
'permutation_46' => ['0.02', '%2 '],
|
|
'permutation_47' => ['0.02', '% 2 '],
|
|
'permutation_48' => ['0.02', ' %2 '],
|
|
'permutation_49' => ['0.02', '% 2 '],
|
|
'permutation_50' => ['0.02', ' % 2 '],
|
|
'permutation_51' => ['0.02', ' 2 % '],
|
|
'permutation_52' => ['-0.02', '-2%'],
|
|
'permutation_53' => ['-0.02', '- %2'],
|
|
'permutation_54' => ['-0.02', ' -%2 '],
|
|
'permutation_55' => ['2%2', '2%2'],
|
|
'permutation_56' => [' 2% %', ' 2% %'],
|
|
'permutation_57' => [' % 2 -', ' % 2 -'],
|
|
'permutation_58' => ['-0.02', '%-2'],
|
|
'permutation_59' => ['-0.02', ' % - 2'],
|
|
'permutation_60' => ['-0.0275', '%-2.75 '],
|
|
'permutation_61' => ['-0.0275', ' % - 2.75 '],
|
|
'permutation_62' => ['-0.0275', ' % - 2.75 '],
|
|
'permutation_63' => ['-0.0275', ' % - 2.75 '],
|
|
'permutation_64' => ['0.0275', ' % + 2.75 '],
|
|
'permutation_65' => ['0.0275', ' % + 2.75 '],
|
|
'permutation_66' => ['0.0275', ' % + 2.75 '],
|
|
'permutation_67' => ['0.02', '+2%'],
|
|
'permutation_68' => ['0.02', ' +2% '],
|
|
'permutation_69' => ['0.02', '+ 2% '],
|
|
'permutation_70' => ['0.02', '+2 % '],
|
|
'permutation_71' => ['0.0275', '+2.75% '],
|
|
'permutation_72' => ['0.0275', ' +2.75% '],
|
|
'permutation_73' => ['0.0275', '+2.75 % '],
|
|
'permutation_74' => ['0.0275', ' + 2.75 % '],
|
|
'permutation_75' => ['-2.5E-6', '-2.5E-4%'],
|
|
'permutation_76' => ['200', '2E4%'],
|
|
'permutation_77' => ['-2.5E-8', '-%2.50E-06'],
|
|
'permutation_78' => [' - % 2.50 E -06 ', ' - % 2.50 E -06 '],
|
|
'permutation_79' => ['-2.5E-8', ' - % 2.50E-06 '],
|
|
'permutation_80' => ['-2.5E-8', ' - % 2.50E- 06 '],
|
|
'permutation_81' => [' - % 2.50E - 06 ', ' - % 2.50E - 06 '],
|
|
'permutation_82' => ['-2.5E-6', '-2.5e-4%'],
|
|
'permutation_83' => ['200', '2e4%'],
|
|
'permutation_84' => ['-2.5E-8', '-%2.50e-06'],
|
|
'permutation_85' => [' - % 2.50 e -06 ', ' - % 2.50 e -06 '],
|
|
'permutation_86' => ['-2.5E-8', ' - % 2.50e-06 '],
|
|
'permutation_87' => ['-2.5E-8', ' - % 2.50e- 06 '],
|
|
'permutation_88' => [' - % 2.50e - 06 ', ' - % 2.50e - 06 '],
|
|
];
|
|
}
|
|
|
|
/**
|
|
* @dataProvider providerCurrencies
|
|
*/
|
|
public function testCurrencies(string $expected, string $value): void
|
|
{
|
|
$originalValue = $value;
|
|
$result = FormattedNumber::convertToNumberIfCurrency($value);
|
|
if ($result === false) {
|
|
self::assertSame($expected, $originalValue);
|
|
self::assertSame($expected, $value);
|
|
} else {
|
|
self::assertSame($expected, (string) $value);
|
|
self::assertNotEquals($value, $originalValue);
|
|
}
|
|
}
|
|
|
|
public static function providerCurrencies(): array
|
|
{
|
|
$currencyCode = StringHelper::getCurrencyCode();
|
|
|
|
return [
|
|
'basic_prefix_currency' => ['2.75', "{$currencyCode}2.75"],
|
|
'basic_postfix_currency' => ['2.75', "2.75{$currencyCode}"],
|
|
|
|
'basic_prefix_currency_with_spaces' => ['2.75', "{$currencyCode} 2.75"],
|
|
'basic_postfix_currency_with_spaces' => ['2.75', "2.75 {$currencyCode}"],
|
|
|
|
'negative_basic_prefix_currency' => ['-2.75', "-{$currencyCode}2.75"],
|
|
'negative_basic_postfix_currency' => ['-2.75', "-2.75{$currencyCode}"],
|
|
|
|
'negative_basic_prefix_currency_with_spaces' => ['-2.75', "-{$currencyCode} 2.75"],
|
|
'negative_basic_postfix_currency_with_spaces' => ['-2.75', "-2.75 {$currencyCode}"],
|
|
|
|
'positive_signed_prefix_currency_with_spaces' => ['2.75', "+{$currencyCode} 2.75"],
|
|
'positive_signed_prefix_currency_with_spaces-2' => ['2.75', "{$currencyCode} +2.75"],
|
|
'positive_signed_postfix_currency_with_spaces' => ['2.75', "+2.75 {$currencyCode}"],
|
|
|
|
'basic_prefix_scientific_currency' => ['2000000', "{$currencyCode}2E6"],
|
|
'basic_postfix_scientific_currency' => ['2000000', "2E6{$currencyCode}"],
|
|
|
|
'basic_prefix_scientific_currency_with_spaces' => ['2000000', "{$currencyCode} 2E6"],
|
|
'basic_postfix_scientific_currency_with_spaces' => ['2000000', "2E6 {$currencyCode}"],
|
|
|
|
'high_value_currency_with_thousands_separator' => ['2750000', "+{$currencyCode} 2,750,000"],
|
|
|
|
'explicit dollar' => ['2.75', '$2.75'],
|
|
'explicit euro' => ['2.75', '2.75€'],
|
|
'explicit pound sterling' => ['2.75', '£2.75'],
|
|
'explicit yen' => ['275', '¥275'],
|
|
];
|
|
}
|
|
}
|