Commit Graph

  • 7e89d3397e Resolve problems with writing the CF Header for each group of rules MarkBaker 2022-03-12 20:55:37 +0100
  • 762300da47 Ensure that some CF style is displayed in Xls samples, even while background colour is still a problem, so that it's easy to verify that the rule is beng written correctly MarkBaker 2022-03-12 20:54:48 +0100
  • d82c01e729
    Merge branch 'PHPOffice:master' into Table-for-Xlsx aswinkumar863 2022-03-12 15:28:51 +0530
  • 2cdffeb8ad
    WIP Remove + From Mode in BaseWriter (#2657) oleibman 2022-03-11 23:51:59 -0800
  • 68158c8120
    Phpstan Differences from Php7 to Php8, Again (#2665) oleibman 2022-03-11 23:28:30 -0800
  • c0ea894c27
    Merge pull request #2669 from PHPOffice/Issue-2666_Active-Sheet-Index-from-Google-Sheets Mark Baker 2022-03-11 21:50:31 +0100
  • b208c52107 Fix for setting Active Sheet to the first loaded worksheet when `bookViews` element isn't defined (e.g. when file is created from Google Sheets) MarkBaker 2022-03-11 21:02:55 +0100
  • 3a4da89bfe
    allow psr/simple-cache 2.x Kevin Bond 2022-03-11 11:24:48 -0500
  • 92a50d134f
    Format as Table for Xlsx aswinkumar863 2022-03-10 19:54:45 +0530
  • 1801f582f5 Correction to Change Log MarkBaker 2022-03-10 10:24:28 +0100
  • 572f4e94bd
    Add two cell anchor drawing (#2532) naotake51 2022-03-10 12:21:47 +0900
  • ce5f91e6a1
    Fix Sample39 (#2664) oleibman 2022-03-09 18:55:31 -0800
  • bd2e7b64a6
    Handle Booleans in Conditional Styles (#2654) oleibman 2022-03-09 18:30:57 -0800
  • 0d5d9eb0ff
    Php8.1/Phpstan Problems (#2649) oleibman 2022-03-09 18:05:36 -0800
  • ee1e56d8e7
    Merge pull request #2653 from PHPOffice/CalcEngine-Debug-Log-Test Mark Baker 2022-03-06 11:12:53 +0100
  • a8f473e9f4 Switch to using sprintf() rather than concatenation for all calculation engine debug logging MarkBaker 2022-03-06 10:51:05 +0100
  • 044836b426 Unit test for the Calculation Engine debug log MarkBaker 2022-03-05 22:31:52 +0100
  • ac33bd9010
    Merge pull request #2652 from PHPOffice/Gnumeric-Selected-Cells-in-Worksheet Mark Baker 2022-03-05 19:41:54 +0100
  • dbf25f0721 Set Selected Cells for Worksheets in Gnumeric Loader MarkBaker 2022-03-05 19:00:32 +0100
  • 86f2684615
    Merge pull request #2651 from PHPOffice/Issue-1971_Failing-to-correctly-escape-double-quotes-in-subformulae Mark Baker 2022-03-05 12:50:24 +0100
  • cba0e13b2a Escape double quotes in a string value unless it's an empty string value MarkBaker 2022-03-05 12:31:11 +0100
  • 51453db41e
    Merge pull request #2650 from PHPOffice/Changelog-Updates Mark Baker 2022-03-05 11:14:09 +0100
  • 16ad02bca8 Minor updates to te change log MarkBaker 2022-03-05 10:56:14 +0100
  • 7f79e7a17c
    Merge pull request #2644 from PHPOffice/CalcEngine-Refactor-Branch-Pruning Mark Baker 2022-03-04 14:53:46 +0100
  • c4f79af56d
    Merge branch 'master' into CalcEngine-Refactor-Branch-Pruning Mark Baker 2022-03-04 14:40:34 +0100
  • 39bba33d00
    Merge pull request #2640 from PHPOffice/CSV-Reader-Dataype-casting-improvements Mark Baker 2022-03-04 14:39:00 +0100
  • dd981a3d77
    Merge branch 'master' into CSV-Reader-Dataype-casting-improvements Mark Baker 2022-03-04 14:25:37 +0100
  • e243476f77 Initial work on refactoring branch pruning logic MarkBaker 2022-03-03 13:51:18 +0100
  • 23631cb9e5
    Correct fill color example in conditional formatting docs. (#2646) Paul Weidner 2022-03-04 01:41:21 -0800
  • dade9cc063
    Corrupt Sample Output for 20 and 30 (#2648) oleibman 2022-03-04 00:51:11 -0800
  • e87be5e16d
    Failing Test Requiring Too Much Precision (#2647) oleibman 2022-03-04 00:11:04 -0800
  • aad91f1d25 Merge branch 'master' into CSV-Reader-Dataype-casting-improvements MarkBaker 2022-03-02 12:43:19 +0100
  • 45ca934a53 Update Change Log and Documentation MarkBaker 2022-03-02 12:33:20 +0100
  • f3d5028518 Work on setting up locale-aware formatted number conversion for the Csv Reader Unit tests for locale-aware boolean conversion for Csv Reader MarkBaker 2022-02-27 23:24:20 +0100
  • a7a48bf0ca
    Bump dompdf/dompdf from 1.1.1 to 1.2.0 (#2633) dependabot[bot] 2022-03-01 03:58:33 -0800
  • 30815cc060
    Bump phpunit/phpunit from 9.5.13 to 9.5.16 (#2635) dependabot[bot] 2022-03-01 03:48:06 -0800
  • a8ebf45fd7
    Bump phpstan/phpstan from 1.4.5 to 1.4.6 (#2634) dependabot[bot] 2022-03-01 03:34:55 -0800
  • f575d2b8b2
    Add Ability to Suppress Mac Line Ending Check for CSV Reader (#2623) oleibman 2022-03-01 02:01:37 -0800
  • 8258919d72
    Phpstan Differences from Php7 to Php8 (#2631) oleibman 2022-03-01 01:53:12 -0800
  • 5579712688 Make CSV Reader boolean casting (e.g. string ``"TRUE"` to boolean `TRUE`) locale-aware. MarkBaker 2022-02-27 23:06:22 +0100
  • fe969f59cc
    Merge pull request #2627 from PHPOffice/Improve-Translation-Separator-Conflict Mark Baker 2022-02-27 13:48:45 +0100
  • b31d42c52f Some Refactoring of the Ods Reader, moving all formula and address translation from Ods to Excel into a separate class to eliminate code duplication MarkBaker 2022-02-27 12:21:35 +0100
  • 99f488efc6 Resolve `translateSeparator()` method to handle separators (row and column) for array functions as well as for function argument separators; and cleanly handle nesting levels MarkBaker 2022-02-27 10:51:06 +0100
  • e6047cfa9d
    Merge pull request #2626 from PHPOffice/Ods-Merge-Range-Tests Mark Baker 2022-02-26 23:04:28 +0100
  • 444d0fd77c Unit tests for merge ranges for Ods Reader/Writer MarkBaker 2022-02-26 21:41:37 +0100
  • d88e8f85ba
    Merge pull request #2625 from PHPOffice/Iso-Date-Datatype-Additional-Unit-Tests Mark Baker 2022-02-26 16:10:24 +0100
  • 138638ad57 Ensure that selected worksheet is correctly set from Gnumeric Reader MarkBaker 2022-02-26 15:46:32 +0100
  • 2af0b66f5f Read number formatting for Gnumeric... highlighted as not occurring when reading date values MarkBaker 2022-02-26 15:20:00 +0100
  • fe901d13b4 Read number formatting for Gnumeric... highlighted as not occurring when reading date values MarkBaker 2022-02-26 15:08:12 +0100
  • 52071e9f4a ODS Reader should also use the new Method for date values MarkBaker 2022-02-26 15:07:20 +0100
  • ef4029df63 Refactor ISO data type validation from cell to shared date; add extra checks for invalid dates; and appropriate unit tests MarkBaker 2022-02-26 13:43:35 +0100
  • 9cf526a920
    Reading Xlsx With Supplied Palette (#2595) oleibman 2022-02-23 22:09:22 -0800
  • 0cb60a5098
    Fix XLSX broken vertical align font style (#2619) Thorsten Ho 2022-02-24 05:23:59 +0100
  • 579145eb3c
    Wrap actual file loading in protected methods, while just providing a stub `load()` method in the BaseReader abstract. This is to allow a wrapper in the file loader logic across all Readers, with a try/catch block that can be used to handle special loader settings. (#2620) Mark Baker 2022-02-23 21:31:57 +0100
  • 16953e27d8
    Adjust Cell Reference regexp in Calculation Engine to handle worksheet names containing quotes (#2617) Mark Baker 2022-02-22 15:55:59 +0100
  • 3c57d9e291
    Fix for issue #2614 (#2615) Mark Baker 2022-02-22 09:06:10 +0100
  • c9f948bd91
    Initial work on implementing Array-enabled for the HLOOKUP() and VLOOKUP() functions (#2611) Mark Baker 2022-02-21 19:56:21 +0100
  • db21d043fe
    Implementation of the ISREF() information function (#2613) Mark Baker 2022-02-21 18:47:23 +0100
  • 0ee4d96576
    Array-enable the ISFORMULA() function (#2610) Mark Baker 2022-02-20 19:32:13 +0100
  • 35b65bef8c
    First steps toward array-enabling the information functions (#2608) Mark Baker 2022-02-20 16:46:25 +0100
  • 9893926ff9
    Add Test For NULL=0 (#2607) oleibman 2022-02-19 13:12:44 -0800
  • 71927f5591
    Issue 2551 array enable lookup ref functions (#2606) Mark Baker 2022-02-19 18:49:01 +0100
  • c10d86eb9c
    Start work on array-enabling the Lookup and Reference functions (#2602) Mark Baker 2022-02-19 18:36:50 +0100
  • d5dc58d20e
    Extract information functions (#2605) Mark Baker 2022-02-19 13:53:17 +0100
  • 9c473682bc
    Set precision for Database function unit tests, for RowColumnReference and Dimension Helper unit tests (#2604) Mark Baker 2022-02-18 21:37:26 +0100
  • 3c0004760d
    Prepare changelog for next version Adrien Crivelli 2022-02-18 14:01:46 +0100
  • 3a9e29b4f3
    1.22.0 Adrien Crivelli 2022-02-18 13:57:07 +0100
  • f4885d90dc
    PHP 8.1 compatibility Adrien Crivelli 2022-02-18 13:14:25 +0100
  • 0371ccb686
    Convert all relevant Logical functions to support array arguments (#2600) Mark Baker 2022-02-18 02:56:23 +0100
  • e580f10c46
    Unit test some basic arra-formula chaining (#2599) Mark Baker 2022-02-17 19:37:40 +0100
  • 03993bce05
    The last big block of Engineering functions; those involving complex numbers (#2597) Mark Baker 2022-02-17 15:17:33 +0100
  • 1a4e4ed7c5 fix php 8.1 error when autoFilter['ref'] is null Roland Eigelsreiter 2022-02-16 10:18:13 +0100
  • ef839f56be
    Get started with array-enabling the Engineering functions - Erf, Bessel, bitwise, comparisons Unit of Measure and Number base conversions first (#2594) Mark Baker 2022-02-16 18:32:07 +0100
  • cdbe5c7c9b
    Converting Statistical functions to be array-enabled (phase #2) (#2593) Mark Baker 2022-02-15 20:34:39 +0100
  • f1cb75eaec
    Start work on Array-enabling the Statistical functions (#2588) Mark Baker 2022-02-15 14:41:17 +0100
  • 7901eb0b91
    Eliminate calls to flattenSingleValue() that are no longer required in TextData Functions when we're checking for array values as arguments (#2592) Mark Baker 2022-02-15 01:29:12 +0100
  • 70c12d2b05
    Eliminate calls to flattenSingleValue() that are no longer required when we're checking for array values as arguments (#2591) Mark Baker 2022-02-14 23:11:53 +0100
  • 7e996a7c98
    Eliminate calls to flattenSingleValue() that are no longer required when we're checking for array values as arguments (#2590) Mark Baker 2022-02-14 22:59:39 +0100
  • aff97833c6
    Renamed "worskeet" to "worksheet" comment typo (#2589) Aaron Layson 2022-02-15 00:07:04 +0800
  • e3b7cb5f9d
    I'm ignoring SUMIF() and SUMIFS() for the moment; so this should complete all the applicable Math/Trig functions;so the subset SERIESSUM() function and RANDBETWEEN() should complete Math/Trig (#2586) Mark Baker 2022-02-13 12:50:05 +0100
  • c9d1df8554
    Update Changelog (#2587) oleibman 2022-02-13 00:45:27 -0800
  • de2fb1f438
    Reset phpstan to level 8... there's too many issues working with mixed and needing to cast to a specific type like string; but the alternative for maintaining exact types is a unnecessar extra of code for explicit handling of casting with checks that we don't need when we know datatypes from manual viewing of the codebase (#2585) Mark Baker 2022-02-12 22:04:02 +0100
  • 8f3c52a3cf
    Enable array-readiness for more Math/Trig functions (#2584) Mark Baker 2022-02-12 20:47:47 +0100
  • 866dd38611
    Merge pull request #2583 from PHPOffice/Issue-2551_Enable-Array-Readiness-for-Functions-Maths Mark Baker 2022-02-12 17:21:57 +0100
  • 5d88c6b534
    Merge branch 'master' into Issue-2551_Enable-Array-Readiness-for-Functions-Maths Mark Baker 2022-02-12 17:11:45 +0100
  • 75213f5ee1 Enable array-readiness for more Math/Trig functions MarkBaker 2022-02-12 13:38:06 +0100
  • 0eeba6dc0c
    `ReferenceHelper@insertNewBefore` checks for missing coordinates before replacing values (#2541) Orkhan Ahmadov 2022-02-12 16:08:11 +0100
  • 90e9ea9505
    Fixed handling of inline strings in XLSX (#2569) mweimerskirch 2022-02-12 15:55:48 +0100
  • 5bf0656e92
    Xlsx Reader Warning When No sz Tag for RichText (#2550) oleibman 2022-02-12 06:43:29 -0800
  • b300e186fe
    Merge pull request #2582 from PHPOffice/Issue-2551_Array-ready-Functions-Text-Phase-2 Mark Baker 2022-02-12 12:41:59 +0100
  • b3ff2e347f All Text functions made array-ready MarkBaker 2022-02-11 20:08:34 +0100
  • 6a2905a34c
    Merge pull request #2580 from PHPOffice/Issue-2551-Array-Ready-Function-Financial Mark Baker 2022-02-11 19:19:03 +0100
  • d2473441c3
    Merge branch 'master' into Issue-2551-Array-Ready-Function-Financial Mark Baker 2022-02-11 19:07:33 +0100
  • c41dd0afae FIND(), SEARCH(), LEFT(), RIGHT, MID(), CLEAN(), TRIM(), TEXTJOIN() and REPT() functions MarkBaker 2022-02-11 14:49:53 +0100
  • ad5532e2f4
    Namespacing Phase 2 - Styles (#2471) oleibman 2022-02-11 06:42:04 -0800
  • c9886127c0 Style and phpstan cleanups MarkBaker 2022-02-11 13:55:52 +0100
  • 8818a7d620 Merge branch 'master' into Issue-2551-Array-Ready-Function-Financial MarkBaker 2022-02-11 13:36:35 +0100
  • 88da4e17e5
    Merge pull request #2579 from PHPOffice/Issue-2578_Negative-dollar-values-for-DOLLARDE()-and-DOLLARFR()-Functions Mark Baker 2022-02-11 13:30:43 +0100
  • f577dde178 Fix for DOLLARDE() and DOLLARFR() with negative dollar values Additional argument validations MarkBaker 2022-02-11 12:52:25 +0100
  • df12b06c59 Text function array value tests, plus some cleanup MarkBaker 2022-02-11 12:34:29 +0100