IMSUM.php 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. <?php
  2. use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
  3. return [
  4. [
  5. ExcelError::NAN(),
  6. '12.34+5.67j',
  7. '123.45+67.89i',
  8. ],
  9. [
  10. ExcelError::NAN(),
  11. '12.34+5.67j',
  12. 'Invalid Complex Number',
  13. ],
  14. [
  15. '135.79+73.56j',
  16. '12.34+5.67j',
  17. '123.45+67.89j',
  18. ],
  19. [
  20. '135.79+62.22i',
  21. '12.34-5.67i',
  22. '123.45+67.89i',
  23. ],
  24. [
  25. '135.79-62.22i',
  26. '12.34+5.67i',
  27. '123.45-67.89i',
  28. ],
  29. [
  30. '135.79-73.56i',
  31. '12.34-5.67i',
  32. '123.45-67.89i',
  33. ],
  34. [
  35. '259.24+141.45i',
  36. '12.34+5.67i',
  37. '123.45+67.89i',
  38. '123.45+67.89i',
  39. ],
  40. [
  41. ExcelError::NAN(),
  42. '12.34+5.67i',
  43. '123.45+67.89i',
  44. '123.45+67.89j',
  45. ],
  46. [
  47. '111.11-73.56i',
  48. '-12.34-5.67i',
  49. '123.45-67.89i',
  50. ],
  51. [
  52. '-111.11-73.56i',
  53. '12.34-5.67i',
  54. '-123.45-67.89i',
  55. ],
  56. [
  57. '-135.79-73.56i',
  58. '-12.34-5.67i',
  59. '-123.45-67.89i',
  60. ],
  61. ];