PhpSpreadsheet

PhpSpreadsheet copied to clipboard

Named ranges not usable as anchors in OFFSET function

3

This is: ``` - [x] a bug report - [ ] a feature request - [x] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) ``` I have noticed...

andvaranaut

Concatenated cell content is only displayed up to the first "&"

17

### Discussed in https://github.com/PHPOffice/PhpSpreadsheet/discussions/3009 Originally posted by **rf1234** August 17, 2022 I have a cell containing a string and a date like this: ="Gesamtbetrag in EUR "&BaseData!C3 The cell BaseData!C3...

rf1234

Coordinate::extractAllCellReferencesInRange no longer accepts sheet name in reference

1

This is: ``` - [x] a bug report - [ ] a feature request - [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) ``` ### What...

rasmuscnielsen

This is: ``` - [х] a bug report - [ ] a feature request - [x] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) ``` ### What is...

artygrand

Default style alignment does not work for Xlsx Writer

2

This is: ``` - [x] a bug report - [ ] a feature request - [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) ``` ### What...

homersimpsons

Load file xlsx is very slow

32

`

nguyenthao1988

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...

oleibman

Fix #3907. After row/column insertion/deletion, PhpSpreadsheet updates formulas which include cells which have moved. However, it can mis-identify cell addresses within the formula. Examples: - `=SUM(A2,'F1 (SETTINGS)'!A1:B1)` It identifes F1...

oleibman

Support Box and Whisker charts

1

This is: ``` - [x] a feature request ``` - **Support Box and Whisker charts**

u01jmg3

Chart Position Inconsistent with Original Spreadsheet

2

This is: ``` - [X] a bug report - [ ] a feature request - [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) ``` ### What...

roland-jungwirth