DeprecatedTest.php 2.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. <?php
  2. namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\TextData;
  3. use PhpOffice\PhpSpreadsheet\Calculation\TextData;
  4. use PHPUnit\Framework\TestCase;
  5. // Sanity tests for functions which have been moved out of TextData
  6. // to their own classes. A deprecated version remains in TextData;
  7. // this class contains cursory tests to ensure that those work properly.
  8. // If Scrutinizer fails the PR because of these deprecations, I will
  9. // remove this class from the PR.
  10. class DeprecatedTest extends TestCase
  11. {
  12. public function testDeprecated(): void
  13. {
  14. self::assertSame('x', TextData::TRIMNONPRINTABLE('x'));
  15. self::assertSame('x y', TextData::TRIMSPACES('x y'));
  16. self::assertSame(48, TextData::ASCIICODE('0'));
  17. self::assertSame('abc', TextData::CONCATENATE('a', 'b', 'c'));
  18. self::assertSame('$1.00', TextData::DOLLAR(1));
  19. self::assertEquals(2, TextData::SEARCHSENSITIVE('b', 'abc'));
  20. self::assertEquals(2, TextData::SEARCHINSENSITIVE('b', 'abc'));
  21. self::assertSame('1.00', TextData::FIXEDFORMAT(1));
  22. self::assertSame('xyz', TextData::LEFT('xyzw', 3));
  23. self::assertSame('yz', TextData::MID('xyzw', 2, 2));
  24. self::assertSame('zw', TextData::RIGHT('xyzw', 2));
  25. self::assertSame(4, TextData::STRINGLENGTH('xyzw'));
  26. self::assertSame('xyzw', TextData::LOWERCASE('Xyzw'));
  27. self::assertSame('XYZW', TextData::UPPERCASE('Xyzw'));
  28. self::assertSame('Xyzw', TextData::PROPERCASE('xyzw'));
  29. self::assertSame('xabw', TextData::REPLACE('xyzw', 2, 2, 'ab'));
  30. self::assertSame('xyzw', TextData::TEXTFORMAT('xyzw', '@'));
  31. self::assertEquals(3, TextData::VALUE('3'));
  32. self::assertEquals(3, TextData::NUMBERVALUE('3'));
  33. self::assertTrue(TextData::EXACT('3', '3'));
  34. self::assertSame('a,b,c', TextData::TEXTJOIN(',', true, 'a', 'b', 'c'));
  35. self::assertSame('aaa', TextData::builtinREPT('a', 3));
  36. self::assertSame('ayxw', TextData::SUBSTITUTE('xyxw', 'x', 'a', 1));
  37. self::assertSame('1', TextData::CHARACTER('49'));
  38. self::assertSame('0', TextData::CHARACTER('48'));
  39. }
  40. }