oleibman 64bdc6424c Incorrect SUMPRODUCT Calculation ...

Fix #3909. SUMPRODUCT is mishandling multi-row ranges. In Calculation/Calculation, `checkMatrixOperands` will often resize its operands. When it does so, it needs to recalculate the dimensions of each. This fixes the reported problem.

Likely cause was PR #3260. That ticket noted the poor coverage of the code being replaced. Tests of the problem in this ticket were absent and are now added. Despite this, I note that `resizeMatricesShrink` is virtually uncovered, and `resizeMatricesExpand` has substantial gaps in its coverage. I have covered some, but not all, of the Expand gaps. I am struggling to come up with examples to fill its remaining gaps and those for Shrink. However, I will merge this fix in about a week even if I don't succeed.

2024-02-21 22:32:30 -08:00

..

autofilter2.xlsx

Coverage Improvements (#2859)

2022-06-01 08:29:56 -07:00

autofilterTest.xlsx

Refactoring xlsx reader (#1033)

2019-06-30 23:42:25 +02:00

blankcell.xlsx

Use Less Space When Inserting Rows and Columns

2024-01-03 18:03:28 -08:00

bug1686b.xlsx

Fix for 3 Issues Involving ReadXlsx and NamedRange (#1742)

2020-12-10 18:08:10 +01:00

ChartSheet.xlsx

Add unit tests for ChartSheet reading

2022-05-16 13:30:30 +02:00

colorscale.xlsx

Added Conditional Formatting: ColorScale for Xlsx (#3738)

2023-09-30 07:23:42 -07:00

colortabs.xlsx

Xlsx Reader Theme Support Broken After 17.1 (#2403)

2021-11-26 09:38:09 -08:00

condfmtnum.xlsx

Handle ConditionalStyle NumberFormat When Reading Xlsx File (#1296)

2020-01-04 00:10:41 +01:00

ConditionalFormat_Ranges.xlsx

Store the currently selected cell when loading Conditional Format Ranges, then reset afterwards

2022-11-30 11:12:33 +01:00

conditionalFormatting2Test.xlsx

Conditionals - Extend Support for (NOT)CONTAINSBLANKS (#1278)

2020-01-04 18:50:04 +01:00

conditionalFormatting3Test.xlsx

#984 add support notContainsText for conditional styles in xlsx reader

2021-05-02 22:09:38 +02:00

conditionalFormattingDataBarTest.xlsx

Support DataBar of conditional formatting rule (#1754)

2021-01-29 16:57:40 +01:00

conditionalFormattingTest.xlsx

Refactoring xlsx reader (#1033)

2019-06-30 23:42:25 +02:00

data_with_tables.xlsx

fix: Load tables when flag IReader::READ_DATA_ONLY is used (#3726)

2023-09-14 05:58:52 -07:00

dataValidation2Test.xlsx

Fix for #2149 / Read data validations for drop down list in another sheet. (#2150)

2021-06-15 13:28:10 +02:00

dataValidationTest.xlsx

Basic unit test and fix for loading data validations from xlsx file (#1063)

2019-07-08 19:55:14 +02:00

double_attr_drawing.xlsx

Fix failure when parsing xlsx with drawing having double (redefined) … (#945)

2019-05-30 11:42:00 +02:00

drawingOneCellAnchor.xlsx

Fix loading drawing size (#2492)

2022-01-16 21:59:31 -08:00

empty_drawing.xlsx

Fix #853 when loading and saving XLSX file with empty drawing cause c… (#882)

2019-05-30 10:38:03 +02:00

excelChartsTest.xlsx

Fix/chart axis titles (#1760)

2021-01-31 19:13:50 +01:00

explicitdate.xlsx

Handle Explicit "Date" Type for Cell (#2485)

2022-01-13 18:40:18 -08:00

HiddenMergeCellsTest.xlsx

Unit tests for correctly handling hidden merged cells in Readers

2022-09-16 12:27:57 +02:00

HiddenSheet.xlsx

Add Hidden Worksheet unit tests for other Readers

2022-05-24 14:40:45 +02:00

ignoreerror.xlsx

Add Ability to Ignore Cell Errors in Excel (#3508)

2023-04-08 21:58:07 -07:00

issue2109b.xlsx

Xlsx Reader Better Namespace Handling Phase 1 Try2 (#2173)

2021-06-25 09:05:49 +02:00

issue.731.xlsx

Xlsx Support Flipping of Image (#3801)

2023-11-30 08:46:43 -08:00

issue.1432b.xlsx

Data Validations Referencing Another Sheet (#2265)

2021-08-24 08:58:38 -07:00

issue.1482.xlsx

Xlsx Namespace Handling of Drawings, RowAndColumnAttributes, MergeCells (#3137)

2022-11-01 07:46:35 -07:00

issue.2246a.xlsx

Fix Reading XLSX files without styles.xml throws an exception. (#2247)

2021-08-16 05:05:32 -07:00

issue.2246b.xlsx

Fix Reading XLSX files without styles.xml throws an exception. (#2247)

2021-08-16 05:05:32 -07:00

issue.2301.xlsx

Xlsx Reader Better Namespace Handling Phase 1 Second Bugfix (#2303)

2021-09-27 16:59:45 -07:00

issue.2316.xlsx

Corrections for Xlsx Read Comments (#2329)

2021-10-23 17:32:44 -07:00

issue.2331c.xlsx

Unexpected Format in Timestamp (#2332)

2021-10-23 18:23:53 -07:00

issue.2362.xlsx

ZipArchive and "Inconsistent" Zip File (#2376)

2021-11-12 01:18:57 -08:00

issue.2387.xlsx

Xlsx Reader Theme Support Broken After 17.1 (#2403)

2021-11-26 09:38:09 -08:00

issue.2450.xlsx

General Style Specified in Uppercase in Input Xlsx (#2451)

2021-12-18 09:25:08 -08:00

issue.2488.xlsx

Xlsx Reader Cell DataType Numeric or Boolean Without Value (#2489)

2022-01-16 21:19:09 -08:00

issue.2490.xlsx

Reading Xlsx With Supplied Palette (#2595)

2022-02-23 22:09:22 -08:00

issue.2494.xlsx

Namespacing Phase 2 - Styles (#2471)

2022-02-11 06:42:04 -08:00

issue.2501.b.xlsx

Xlsx Reader Merge Range For Entire Column(s) or Row(s) (#2504)

2022-01-23 10:44:09 -08:00

issue.2506.xlsx

Xlsx Chart Reader and Writer Mishandle Explosion Value (#2928)

2022-07-14 07:48:53 -07:00

issue.2516b.xlsx

fix warning when open xlsx file with thumbnail (#2517)

2022-01-24 14:17:53 -08:00

issue.2542.xlsx

Xlsx Reader Warning When No sz Tag for RichText (#2550)

2022-02-12 06:43:29 -08:00

issue.2677.namespace.xlsx

Xlsx Reader External Data Validations Flag Missing (#3078)

2022-09-28 00:14:37 -07:00

issue.2677.removeformula1.xlsx

Xlsx Reader External Data Validations Flag Missing (#3078)

2022-09-28 00:14:37 -07:00

issue.2778.xlsx

Real Errors Identified in Calculation by Scrutinizer (#2774)

2022-04-30 19:13:17 -07:00

issue.2885.xlsx

Ignore square-$-brackets prefix in format string (#2886)

2022-06-15 14:55:17 -07:00

issue.2965.xlsx

Limited Support for Chart Titles as Formulas (#2971)

2022-08-06 17:39:18 -07:00

issue.3093.xlsx

Xlsx Reader Accept Palette of Fewer than 64 Colors (#3096)

2022-10-02 18:02:34 -07:00

issue.3126.xlsx

Generation3 Copy With Image in Footer (#3140)

2022-11-02 07:44:57 -07:00

issue.3143a.xlsx

Permit Max Column for Row Breaks (#3345)

2023-02-11 07:44:14 -08:00

issue.3145.xlsx

Using htmlspecialchars to fix issue #3145 (#3146)

2022-10-31 18:05:54 -07:00

issue.3202.xlsx

Conditional Formatting Improvements for Xlsx (#3372)

2023-02-23 22:28:22 -08:00

issue.3277.xlsx

add reproducer

2023-01-03 11:52:46 -05:00

issue.3370.xlsx

Conditional Formatting Improvements for Xlsx (#3372)

2023-02-23 22:28:22 -08:00

issue.3435.xlsx

Correct Xlsx Parsing of quotePrefix="0" (#3438)

2023-03-07 07:51:20 -08:00

issue.3453.xlsx

WIP Handle REF Error as Part of Range (#3467)

2023-03-25 07:03:52 -07:00

issue.3464.xlsx

Fix incorrect font color read from xlsx (#3465)

2023-03-18 09:04:31 -07:00

issue.3495d.xlsx

Xlsx Reader Formula with quotePrefix (#3497)

2023-04-04 07:29:47 -07:00

issue.3534.xlsx

Use Column Style When Row Dimension Exists Without Style (#3688)

2023-09-02 20:38:29 -07:00

issue.3552.xlsx

Not Finding Rels File (#3555)

2023-05-10 18:57:16 -07:00

issue.3553.xlsx

Not Finding Rels File (#3554)

2023-05-10 18:09:05 -07:00

issue.3613.xlsx

Avoid NULL in String Function Call (#3617)

2023-06-22 12:41:53 -07:00

issue.3654.xlsx

Fix Xlsx Read Ignoring Comments (#3655)

2023-08-21 23:36:29 -07:00

issue.3654c.xlsx

Fix Xlsx Read Ignoring Comments (#3655)

2023-08-21 23:36:29 -07:00

issue.3658.xlsx

SetCalculatedValue Avoid Casting String to Numeric (#3685)

2023-08-26 07:17:55 -07:00

issue.3665.xlsx

Xlsx Reader Namespacing for Tables, AutoFilters (#3668)

2023-08-10 16:07:38 -07:00

issue.3679.img.xlsx

Fix Several Problems in a Very Complicated Spreadsheet (#3681)

2023-08-27 16:01:02 -07:00

issue.3720.xlsx

Unexpected Namespacing in rels File (#3722)

2023-09-12 19:13:03 -07:00

issue.3767.xlsx

Address Some Chart Problems (#3771)

2023-11-09 13:15:38 -08:00

issue.3770.xlsx

Theme File Missing But Referenced in Spreadsheet (#3772)

2023-10-26 12:06:36 -07:00

issue.3807.xlsx

Prevent Loop in Shared/File::realpath (#3809)

2023-12-04 16:58:53 -08:00

issue.3833.logarithm.xlsx

Chart Axis Display Units and Logarithmic Scale

2023-12-19 22:34:35 -08:00

issue.3833.units.xlsx

Chart Axis Display Units and Logarithmic Scale

2023-12-19 22:34:35 -08:00

issue.3863.xlsx

Excel Omits Between Operator for Data Validation

2024-01-11 23:03:55 -08:00

issue.3909b.xlsx

Incorrect SUMPRODUCT Calculation

2024-02-21 22:32:30 -08:00

namespacenonstd.xlsx

Xlsx Reader Better Namespace Handling Phase 1 Try2 (#2173)

2021-06-25 09:05:49 +02:00

namespacepurl.xlsx

Xlsx Reader Better Namespace Handling Phase 1 Try2 (#2173)

2021-06-25 09:05:49 +02:00

namespaces.openpyxl35.xlsx

Xlsx Reader Better Namespace Handling Phase 1 Try2 (#2173)

2021-06-25 09:05:49 +02:00

namespaces.xlsx

Xlsx Reader Better Namespace Handling Phase 1 Try2 (#2173)

2021-06-25 09:05:49 +02:00

namespacestd.xlsx

Xlsx Reader Better Namespace Handling Phase 1 Try2 (#2173)

2021-06-25 09:05:49 +02:00

octo#thorpe.xlsx

Read Spreadsheet with # in Name (#2409)

2021-11-30 07:39:50 -08:00

PageSetup.xlsx

Forgot to check in the test files for the unit tests

2020-07-05 16:28:46 +02:00

pageSetupTest.xlsx

Refactoring xlsx reader (#1033)

2019-06-30 23:42:25 +02:00

pr1769e.xlsx

Remove unnecessary changes. Added test

2021-04-19 11:25:48 +01:00

pr1769g.py.xlsx

XLSX Reader and Empty Fill Tag (#2011)

2021-04-20 17:20:59 +02:00

pr2050cf-fill.xlsx

Pattern Fill style should default to 'solid' if there is a pattern fill with colour but no style (#2050)

2021-04-30 20:05:45 +02:00

pr2225-datavalidation-onezero.xlsx

Add unit tests for files with true/false (LibreOffice) in DataValidation boolean values and those with 1/0 (Excel, GoogleSheets)

2021-07-21 05:53:49 -07:00

pr2225-datavalidation-truefalse.xlsx

Add unit tests for files with true/false (LibreOffice) in DataValidation boolean values and those with 1/0 (Excel, GoogleSheets)

2021-07-21 05:53:49 -07:00

propertyTest.xlsx

Refactoring xlsx reader (#1033)

2019-06-30 23:42:25 +02:00

RgbTint.xlsx

Redo Calculation of Color Tinting (#3580)

2023-05-25 13:05:55 -07:00

ribbon.donotopen.zip

Test For Excel File Saved With Ribbon Data (#2883)

2022-06-14 08:33:36 -07:00

rootZipFiles.xlsx

Fix reading of files in the root of a zip (#2731)

2022-04-18 06:54:41 -07:00

rowColumnAttributeTest.xlsx

Refactoring xlsx reader (#1033)

2019-06-30 23:42:25 +02:00

sheetprotect.xlsx

Namespace-Aware Code for SheetViewOptions, SheetProtection (minor break) (#3230)

2022-12-11 17:38:26 -08:00

sheetsChartsTest.xlsx

Fix/sheets xlsx chart (#1761)

2021-01-31 18:53:54 +01:00

splits.xlsx

Split Screens (#3622)

2023-06-28 07:13:20 -07:00

stylesTest.xlsx

Refactoring xlsx reader (#1033)

2019-06-30 23:42:25 +02:00

tableTest.xlsx

Load Table with XLSX Reader

2022-05-15 13:30:54 +05:30

TableWithoutFilter.xlsx

Allow option for disabled filtering on tables

2022-12-13 11:01:29 +01:00

threesheets.xlsx

ListWorksheetInfo/Names for Html/Csv/Slk (#3709)

2023-09-07 18:29:45 -07:00

urlImage.xlsx

Change and Re-enable URLImageTest (#2844)

2022-05-21 08:07:59 -07:00

verticalAlignTest.xlsx

Fix XLSX broken vertical align font style (#2619)

2022-02-23 20:23:59 -08:00

without_cell_reference.xlsx

Support missing attribute r in c node when reading xlsx

2017-09-22 14:49:38 +09:00

Zip-Linux-Directory-Separator.xlsx

Unit tests for both linux and windows directory separators in zip files

2023-03-24 23:14:11 +01:00

Zip-Windows-Directory-Separator.xlsx

Unit tests for both linux and windows directory separators in zip files

2023-03-24 23:14:11 +01:00