Clientbase
/
PhpSpreadsheet
mirror of https://github.com/basemaster/PhpSpreadsheet.git
1
0
Fork 0
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 716964eeec Resolve Calculation Engine bug with row and column ranges being identified as named ranges, adding overhead with the additional validation to process that named range MarkBaker 2022-04-15 14:51:31 +0200
  • 4a28fd6eec
         Merge pull request #2749 from PHPOffice/CalcEngine-Parser-Unit_Tests Mark Baker 2022-04-14 22:53:27 +0200
  • 483ef53855 Basic unit tests for formula parsing, in preparation for work on fully supporting the Union Operator, and for providing support for Structured References MarkBaker 2022-04-14 21:21:08 +0200
  • 709e2ae5ca
         Merge pull request #2748 from PHPOffice/Resolve-Issue-with-Boolean-in-Branch-Pruning Mark Baker 2022-04-13 20:27:19 +0200
  • abaa102919 Resolve issue with boolean in branch pruning when array is expected MarkBaker 2022-04-13 20:18:21 +0200
  • 19988626d4 Fix change log typo MarkBaker 2022-04-13 18:17:29 +0200
  • d4585ed0c6
         Merge pull request #2746 from PHPOffice/Issue-2730_Combined-Ranges Mark Baker 2022-04-13 18:16:14 +0200
  • 8b83e8ac4c
         Merge branch 'master' into Issue-2730_Combined-Ranges Mark Baker 2022-04-13 18:04:00 +0200
  • 40730c6023 Handle defined names with the range operator. It gets awkward when the defined name is for an actual range rather than for an individual named cell; because we need to manipulate the stack when that happens. MarkBaker 2022-04-13 14:28:15 +0200
  • 4856376024
         Merge pull request #2739 from mjan4175/fix-external-sheet-column-styles Mark Baker 2022-04-13 12:39:40 +0200
  • 8c84ce4399 Support for chained range operators in the Calculation Engine (e.g. `A3:B1:C2` which gives an effective combined range of `A1:C3` or `A5:C10:C20:F1` which gives an effective combined range of `A1:F20`). MarkBaker 2022-04-12 17:04:07 +0200
  • 2f52cd8644
         Merge branch 'master' into fix-external-sheet-column-styles Mark Baker 2022-04-13 12:25:32 +0200
  • c214a199d6 FIX: Coding style mjan4175 2022-04-12 19:53:21 +0200
  • 5f317250b3 CHANGELOG.md contribution mjan4175 2022-04-12 19:43:42 +0200
  • e41fdf4909 FIX: Invalid styles in rowDimensions of added external sheet. mjan4175 2022-04-12 13:38:19 +0200
  • a6cb80fd4c
         Merge pull request #2718 from PHPOffice/CellAddress-object Mark Baker 2022-04-12 08:46:55 +0200
  • f672734258 Typo MarkBaker 2022-04-12 08:34:03 +0200
  • 3becd5696a
         Merge branch 'master' into CellAddress-object Mark Baker 2022-04-12 08:30:33 +0200
  • 5719b21341 FIX: Changelog revert unwanted changes mjan4175 2022-04-11 09:39:53 +0200
  • 43e0e64cd4 CHANGELOG.md contribution mjan4175 2022-04-11 09:31:07 +0200
  • 31ca617570 FIX: Data types in tests mjan4175 2022-04-11 09:06:38 +0200
  • bb4a22d5e9 FIX: Coding style in tests mjan4175 2022-04-11 08:56:42 +0200
  • 812c14a6ad Fix invalid styles in empty columns of added external sheet. mjan4175 2022-04-11 08:50:28 +0200
  • c6858885c0
         Bump phpstan/phpstan-phpunit from 1.0.0 to 1.1.0 (#2720) dependabot[bot] 2022-04-10 18:03:04 -0700
  • 2370a88c96
         Trivial Change to Unblock Phpstan Update (#2737) oleibman 2022-04-10 17:31:53 -0700
  • b03788c902
         Bump phpstan/phpstan from 1.4.6 to 1.5.3 (#2719) dependabot[bot] 2022-04-10 08:25:24 -0700
  • 64e61d8dec
         Prep Work for Phpstan Upgrade (#2728) oleibman 2022-04-10 08:14:05 -0700
  • 83aaf32161 Handle selected cells MarkBaker 2022-04-03 21:49:25 +0200
  • 4db82032b4
         Remove table by name cs fix aswinkumar863 2022-04-03 18:51:06 +0530
  • feffb76944
         Added Column Formula aswinkumar863 2022-04-03 18:27:38 +0530
  • bc6ec1932a
         Auto adjust table range using ReferenceHelper aswinkumar863 2022-04-03 18:27:00 +0530
  • 50b91e8ede
         Remove table By name aswinkumar863 2022-04-03 18:24:38 +0530
  • 3c3d949a5d
         Added table name validation aswinkumar863 2022-04-03 18:23:13 +0530
  • 0e3dbb7e03
         Merge branch 'PHPOffice:master' into Table-for-Xlsx aswinkumar863 2022-04-03 18:06:24 +0530
  • 28bb2cd7c7
         Bump phpunit/phpunit from 9.5.16 to 9.5.20 (#2726) dependabot[bot] 2022-04-03 05:13:55 -0700
  • 1ae8ef9651
         Bump dompdf/dompdf from 1.2.0 to 1.2.1 (#2721) dependabot[bot] 2022-04-03 04:56:17 -0700
  • 3ae5a3fae3 Additional unit tests for BColumnAndRow methods, to verify that they still work as expected MarkBaker 2022-04-01 16:55:58 +0200
  • 6b4ffda5ae Add functionality to adjust CellRange by "modifying" the from/to CellAddress Value objects MarkBaker 2022-04-01 12:23:32 +0200
  • 1849737abc Add functionality to shift RowRange and ColumnRange MarkBaker 2022-04-01 11:26:47 +0200
  • 62238bc011 Initial work on deprecating `ByColumnAndRow` methods; and providing functionality to use the basic cellAddress methods to be used with a string cell address (e.g. `C5`); an array of columnId and rowId (e.g. `[3, 5]`) or a new CellAddress object. MarkBaker 2022-03-30 17:02:42 +0200
  • 257c22277c
         Merge branch 'PHPOffice:master' into Table-for-Xlsx aswinkumar863 2022-03-26 17:04:48 +0530
  • 8885c4eeef
         Merge pull request #2713 from PHPOffice/Filter-return-result-array-indexes Mark Baker 2022-03-24 22:24:39 +0100
  • 2ab582a707 Bugfix to returned column indexes for FILTER() by row MarkBaker 2022-03-24 22:12:08 +0100
  • 11edcc9f96
         Merge pull request #2711 from PHPOffice/LookupRef-Sort-Functions Mark Baker 2022-03-24 18:30:41 +0100
  • 9019523efc Additional unit testing And a quick bugfix for cell ranges applied to both sort functions and to FILTER() MarkBaker 2022-03-24 17:08:22 +0100
  • 7f00049fe8 Initial work on the SORT() and SORTBY() Lookup/Reference functions MarkBaker 2022-03-22 21:51:52 +0100
  • 6a349ccf5a
         Scrutinizer Faulty Analysis (#2704) oleibman 2022-03-21 14:29:57 -0700
  • c112802023
         Eliminate Most Scrutinizer Problems in Test Suite (#2699) oleibman 2022-03-21 13:58:42 -0700
  • 2482203c3e
         Resolve Scrutinizer Reports for Samples (#2691) oleibman 2022-03-21 13:17:25 -0700
  • 0ce56b1655
         Merge pull request #2707 from PHPOffice/LookupRef-Filter-Function Mark Baker 2022-03-20 18:18:15 +0100
  • f3bb61f3e4 Initial work implementing the FILTER() Lookup/Reference function MarkBaker 2022-03-20 14:03:36 +0100
  • 1642ee4eb1
         Merge pull request #2702 from PHPOffice/Xls-Reader-CF-Styling Mark Baker 2022-03-19 19:57:52 +0100
  • 0a9d15407f Suport fill style and color for reading CF Formats MarkBaker 2022-03-19 19:47:14 +0100
  • be734cf922
         Merge pull request #2696 from PHPOffice/Xls-Reader-Conditional-Formatting Mark Baker 2022-03-19 16:37:42 +0100
  • 23e2d702ff
         Merge branch 'master' into Xls-Reader-Conditional-Formatting Mark Baker 2022-03-19 16:21:14 +0100
  • be8c444951 More minor tweaks MarkBaker 2022-03-19 16:15:48 +0100
  • aea156ff76 Minor tweaks MarkBaker 2022-03-19 16:03:17 +0100
  • 3803658897 Some basic reading of font style information for CF Styles MarkBaker 2022-03-19 15:43:07 +0100
  • 3767917ee5 Stubs for reading style information for Conditional Formatting MarkBaker 2022-03-19 14:48:50 +0100
  • 1bd5369295
         Merge pull request #2667 from kbond/simple-cache-2 Mark Baker 2022-03-19 12:43:42 +0100
  • 0e8c470ca6
         Merge branch 'master' into simple-cache-2 Mark Baker 2022-03-19 12:27:52 +0100
  • 7e9edf5907
         Merge pull request #2698 from PHPOffice/Xls-Reader-DataValidations-Refactoring Mark Baker 2022-03-19 12:18:34 +0100
  • c73bb612e0 Unit tests for Xls Reader DataValidation MarkBaker 2022-03-19 12:04:14 +0100
  • d93f1b2800
         Merge branch 'master' into simple-cache-2 Mark Baker 2022-03-18 23:05:33 +0100
  • 2dc9fc6bb7 Move DataValidation switch statements into a dedicated helper class MarkBaker 2022-03-18 22:38:24 +0100
  • 45c08d6cd4 Initial work on reading conditional styles for the Xls Reader MarkBaker 2022-03-17 13:47:58 +0100
  • 0e7ee37ea6
         Merge pull request #2695 from PHPOffice/Error-Handling-Spill-Calc Mark Baker 2022-03-18 17:59:58 +0100
  • 21b784f200 Add basic support for Error functions when the error is #SPILL! or #CALC! MarkBaker 2022-03-18 17:44:26 +0100
  • dae5dfd6b6
         Merge pull request #2694 from PHPOffice/Implementation-of-UNIQUE()-Function Mark Baker 2022-03-18 15:20:08 +0100
  • 75e45057f3 Fix scrutinizer issue complaint MarkBaker 2022-03-18 14:59:37 +0100
  • 4847e05212
         Merge pull request #2692 from PHPOffice/Implementation-of-UNIQUE()-Function Mark Baker 2022-03-18 14:40:52 +0100
  • c8cf193301 Initial work implementing the new UNIQUE() Lookup/Reference array function MarkBaker 2022-03-18 13:34:59 +0100
  • 576fbc43c9
         Merge pull request #2690 from PHPOffice/UnitTests_ReferenceHelper-DataValidation Mark Baker 2022-03-17 16:05:45 +0100
  • f6fcc4de87 More unit testing for inserting/deleting rows/columns with DataValidation, ConditionalFormatting and PrintArea MarkBaker 2022-03-17 14:54:32 +0100
  • 9b3c3f4adf Merge branch 'master' into Xls-Reader-Conditional-Formatting MarkBaker 2022-03-17 12:11:19 +0100
  • 178f748bc2
         Merge pull request #2689 from PHPOffice/Issue-2678_Update-CF-Ranges-and-Conditions-on-Insert/Delete Mark Baker 2022-03-17 12:05:18 +0100
  • 6a190d650c
         Merge branch 'master' into Issue-2678_Update-CF-Ranges-and-Conditions-on-Insert/Delete Mark Baker 2022-03-17 11:52:57 +0100
  • 6faf828db7 Fix issues with updating Conditional Formatting when inserting/deleting rows/columns - Update existing ranges, expanding if necessary, rather than trying to clone for each individual cell - Update conditions, so that cell references and formulae are maintained correctly MarkBaker 2022-03-17 11:10:29 +0100
  • 9428552d94
         Add editAs Property for 2-cell Anchor Drawings (#2674) oleibman 2022-03-16 16:12:38 -0700
  • a8e179d5d9
         Scrutinizer Complains Some Samples Class Name Conflict with Jpgraph (#2684) oleibman 2022-03-16 15:59:53 -0700
  • f2f626e02c
         Tweak to php-cs-fixer Parameters (#2683) oleibman 2022-03-16 15:34:40 -0700
  • 78c27c03ca
         Merge pull request #2687 from PHPOffice/Bugfix_Support-Row/Column-Ranges-in-INDIRECT()-Function Mark Baker 2022-03-16 23:16:50 +0100
  • ec15c7a6de more minor tweaks MarkBaker 2022-03-16 23:03:19 +0100
  • 0b9207a522
         Merge pull request #2686 from PHPOffice/Additional-Validations-for-Lookup-Arrays Mark Baker 2022-03-16 21:44:24 +0100
  • 4881e2ae9e Validte that lookup arrays are actually arrays MarkBaker 2022-03-16 21:30:19 +0100
  • 4c1d953897
         Merge pull request #2685 from PHPOffice/Refactoring-ReferenceHelper-allow-absolute-cellreference-updates Mark Baker 2022-03-16 19:25:43 +0100
  • 4bc3ed9cc1 Provide $includeAbsoluteReferences option for the CellReferenceHelper when updating cell addresses MarkBaker 2022-03-16 19:14:50 +0100
  • 251605f9b2
         Merge pull request #2682 from PHPOffice/Refactoring-Work-on-ReferenceHelper Mark Baker 2022-03-16 16:54:00 +0100
  • bbe6b8082e Some additional unit tests for the ReferenceHelper And a bugfix when deleting cells that contain hyperlinks (the hperlinks weren't being deleted, so were being "inherited" by whatever cell moved to that address) MarkBaker 2022-03-16 15:29:42 +0100
  • 6f84780bb9 Some work on refactoring the ReferenceHelper to extract the logic for updating cell references. This is a preliminary step toward allowing updates to absolute cell references, required to update Conditional Formatting rules. MarkBaker 2022-03-15 20:08:02 +0100
  • cb5a451aaf Initial work on Reading Conditional Formatting from Xls files MarkBaker 2022-03-15 13:25:23 +0100
  • 09cf6abded
         Merge pull request #2675 from PHPOffice/Refactoring-ReferenceHelper Mark Baker 2022-03-13 21:26:37 +0100
  • 750e42c024 More refactoring of the reference helper; and unit tests to validate insertion/removal of rows/columns from an autofilter range MarkBaker 2022-03-13 18:12:42 +0100
  • a8d9cd700e Allow deleting of columns beyond the end of data in a worksheet to update references (print area, etc) before early exiting the method MarkBaker 2022-03-13 18:10:28 +0100
  • 092f90220e Minor refactoring work MarkBaker 2022-03-13 12:54:40 +0100
  • 004de10f54
         Merge pull request #2673 from PHPOffice/Resolve-CF-Issues-with-Xls-Writer Mark Baker 2022-03-13 11:30:25 +0100
  • 7101da80a5 Update Change Log MarkBaker 2022-03-13 11:12:59 +0100
  • a6e792082b Handle the case of an invalid formula by defaulting to ptgInt + 0, which will avoid breaking the file MarkBaker 2022-03-13 10:53:07 +0100
  • 83161de91e Some refactoring to extract the logic for calculating the CF operand tokens and size, to reduce duplicated code MarkBaker 2022-03-13 04:02:05 +0100
  • 9ca9d741fe Resolve saving cell references, string literals and formula as values for conditional formatting rules in the Xls file save MarkBaker 2022-03-13 03:04:37 +0100