Merge pull request #2807 from PHPOffice/Performance-CellIterator
Mark Baker
2022-05-06 11:24:24 +0200
ae09dd13e1Update logic in Cell Iterators to use Cell Collection directly where appropriate, bypassing the overhead of additional calls through the worksheet with extra checks and validations
MarkBaker
2022-05-05 16:53:56 +0200
7201ddd088Update get cell logic in Cell Iterators
MarkBaker
2022-05-05 16:53:56 +0200
Merge pull request #2804 from PHPOffice/Performance-Xlsx-Writer
Mark Baker
2022-05-05 13:49:11 +0200
1b71e75bc2Performance Experiment for the Xls Writer, to avoid creating empty cells; and should also be slightly faster
MarkBaker
2022-05-05 10:08:34 +0200
5ae74145dePerformance Experiment for the String Table, to avoid creating empty cells; should also be slightly faster
MarkBaker
2022-05-05 10:05:32 +0200
b399c09dd5Performance Experiment for the String Table, to avoid creating empty cells; should also be slightly faster
MarkBaker
2022-05-05 10:05:32 +0200
d686a991dbMemory Experiment in Xlsx Writer
MarkBaker
2022-05-04 10:35:37 +0200
Real Errors Identified in Calculation by Scrutinizer (#2775)
oleibman
2022-04-30 17:43:18 -0700
32559b44a3Use the call to Coordinate::coordinateFromString() to validate the coordinate passed to createNewCell() _before_ we try adding it to the Collection
MarkBaker
2022-04-30 20:14:36 +0200
e3a6bc1e4cWe should still get an exception for invalid named ranges, but I'm suppressing the message check temporarily in the tests until I can investigate why we're getting 'Column string index can not be longer than 3 characters' instead of 'Invalid cell coordinate XXXX'.
MarkBaker
2022-04-30 17:29:45 +0200
b34f0a96a7More significant reductions in memory usage for peaks, and faster execution times for key Cell Collection methods
MarkBaker
2022-04-30 17:07:24 +0200
Merge pull request #2786 from PHPOffice/Cell-Collection-Memory-Experiments
Mark Baker
2022-04-28 20:02:38 +0200
45be09e98bMinor tweaks to execution speed, including eliminating a method call on storing a cell
MarkBaker
2022-04-28 19:04:53 +0200
0171709e7fThe `sortCellReferenceArray()` in `Coordinate` should have returned cells ordered by row, then by column... but instead sorted by column, then row. Fixed that bug, using a slightly faster algorithm for the sort index than the simple fix would have used, and modified the tests that didn't have the correct expected result :-(
MarkBaker
2022-04-28 17:18:37 +0200
1924f3c1d7Improved memory performance for getSortedCoordinates() in the Cell Collection; with minimal execution time overhead.
MarkBaker
2022-04-28 12:43:05 +0200
Merge pull request #2771 from PHPOffice/Extract-Worksheet-Validations
Mark Baker
2022-04-23 13:23:04 +0200
69edf61ed6Extract cell/range validations from Worksheet and move into a separate Worksheet/Validations class as public static methods Extract tryDefinedName logic from Worksheet, nd move into the Worksheet/Validations class as a public static method Apply stricter validation to autofilter range arguments
MarkBaker
2022-04-23 13:08:06 +0200
Merge pull request #2761 from PHPOffice/Reduce-Size-of-Cell-Collection-Unique-ID
Mark Baker
2022-04-20 20:42:51 +0200
ad56616309Reduce size of Unique ID Prefix used for the Cell Collection when "in memory" (reduces the per-cell memory overhead, while still retaining a unique prefix to ensure no clash between worksheet collections). External cache (where multiple threads may be accessing the same cache with different workeets) still uses the same length and entropy in the prefix as before
MarkBaker
2022-04-20 20:01:45 +0200
Merge pull request #2754 from PHPOffice/Issue-2413_Autosize-Column-Allow-for-AutoFilter
Mark Baker
2022-04-17 22:07:13 +0200
ea584301c7Modify Autosize calculation to make allowance for the filter dropdown icon in the first row of an AutoFilter range
MarkBaker
2022-04-17 21:50:52 +0200