PHPOffice/PhpSpreadsheet

View on GitHub

A pure PHP library for reading and writing spreadsheet files

Stars: 14k
Forks: 3.6k
Open beginner issues: 0
Indexed issues: 81
Avg merge: 3d 4h
Merged PRs (30d): 14

Dominant language: PHP
License: MIT
Last GitHub push: Sep 19, 2026
Latest indexed: Sep 19, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed

Beginner friendly Everything

Open All

81 open issues indexed

VALUE() parses product text like "5V 2.1A - EU Wall Adaptor" as a date Open

Difficulty 2/5 1-3 hours Newbie friendliness 74/100

PHPOffice/PhpSpreadsheet#4996 · Opened Sep 18, 2026
PivotTableBuilder on older Excel Versions Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

PHPOffice/PhpSpreadsheet#4976 · 10 comments · Opened Aug 25, 2026
EU Cyber Resilience Act (CRA) Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

PHPOffice/PhpSpreadsheet#4923 · 4 comments · Opened Jun 24, 2026
Memory leak Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

PHPOffice/PhpSpreadsheet#4922 · Opened Jun 22, 2026
Untrusted impersonation of the project at phpspreadsheet.com Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

PHPOffice/PhpSpreadsheet#4882 · 1 reaction · Opened May 22, 2026
Saving XLSX performance Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

PHPOffice/PhpSpreadsheet#4860 · 14 comments · Opened Apr 23, 2026
Slow performance with versions 2.2+ and 3+ Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

PHPOffice/PhpSpreadsheet#4807 · 3 comments · Opened Feb 13, 2026
InsertRowBefore does not update named cell references Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

PHPOffice/PhpSpreadsheet#4804 · 2 comments · Opened Feb 9, 2026
Cyclic reference with sharepoint document causes infinite loops Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

PHPOffice/PhpSpreadsheet#4791 · 4 comments · Opened Jan 28, 2026
Formula Error: Unexpected operator '=' in /vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/Cell.php:563 Open

Difficulty 3/5 1-2 days Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#4710 · 6 comments · Opened Nov 11, 2025
Saving 40K+ lines of data ends with 504 Gateway Timeout Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

PHPOffice/PhpSpreadsheet#4621 · 4 comments · Opened Aug 30, 2025
Read file value incorrect Open

Difficulty 4/5 3-5 days Newbie friendliness 20/100

PHPOffice/PhpSpreadsheet#4512 · 6 comments · Opened Jun 18, 2025
load and save a ods or xlsx file with a cell containing formular including an external filepah on windows-system leads to a replacement [1] instead of the correct filepath Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

PHPOffice/PhpSpreadsheet#4435 · 4 comments · Opened Apr 2, 2025
The OFFSET function cannot use the return value of the INDIRECT function. Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

PHPOffice/PhpSpreadsheet#4403 · 4 comments · Opened Mar 13, 2025
Problems with Trend Best Fit Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#4400 · Opened Mar 10, 2025
Writing XLSX from templates don't keep all archive files Open

Difficulty 4/5 3-5 days Newbie friendliness 28/100

PHPOffice/PhpSpreadsheet#4394 · 3 comments · Opened Mar 4, 2025
Unfinished Business WIth (Cell)ReferenceHelper After Columns/Rows Deleted Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#4379 · 5 comments · Opened Feb 22, 2025
"3D Range references are not yet supported" error when trying to use GROUPBY, is there a way to support it? Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

PHPOffice/PhpSpreadsheet#4282 · 8 comments · Opened Dec 17, 2024
Chart: Not able to use multiple bar types (DataSeries::TYPE_BARCHART) in a single chart. Open

charts

Difficulty 4/5 3-5 days Newbie friendliness 45/100

PHPOffice/PhpSpreadsheet#3994 · Opened Apr 18, 2024
Chart: Y axis is no longer displayed after load and save Open

charts

Difficulty 4/5 3-5 days Newbie friendliness 38/100

PHPOffice/PhpSpreadsheet#3977 · 1 comment · Opened Apr 6, 2024
Uncaught TypeError: PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart::writePlotGroup(): Argument #6 ($plotGroupingType) must be of type string, null given Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

PHPOffice/PhpSpreadsheet#3975 · Opened Apr 6, 2024
Load file xlsx is very slow Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#3917 · 34 comments · 1 reaction · Opened Feb 22, 2024
Issue with Merging Ranged Sections in PHP Spreadsheet Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#3894 · 3 comments · Opened Feb 5, 2024
Large Import of MultiSheets with Chunk and Queued Reading the ReadChunk Crashes Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#3835 · Opened Dec 19, 2023
Inconsistent results when using COUNTIF Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

PHPOffice/PhpSpreadsheet#3802 · 3 comments · Opened Nov 29, 2023
Excel Uses New Files for Chart Styles and Colors Open

charts

Difficulty 4/5 3-5 days Newbie friendliness 35/100

PHPOffice/PhpSpreadsheet#3799 · 1 comment · Opened Nov 24, 2023
Calculation error when switching IF 2nd and 3rd parameters Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

PHPOffice/PhpSpreadsheet#3790 · 1 comment · Opened Nov 10, 2023
Failure to calculate cell with specific nested IF conditions Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

PHPOffice/PhpSpreadsheet#3755 · 2 comments · 3 reactions · Opened Sep 29, 2023
Form Controls Within Drawing Xml Open

form controls

Difficulty 5/5 Over a week Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#3735 · Opened Sep 14, 2023
INDIRECT and Relative Address When Used as Part of Range Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

PHPOffice/PhpSpreadsheet#3697 · Opened Aug 30, 2023
Excel File Export Issue with MySQL v8.0 with any PHP version. Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#3666 · 4 comments · Opened Aug 1, 2023
getFormattedValue(): invalid format value in some cases Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

PHPOffice/PhpSpreadsheet#3625 · 3 comments · Opened Jun 30, 2023
Invalid cell coordinate TABLEAU1[#ALL] Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#3618 · 1 comment · Opened Jun 18, 2023
namedRangeToArray() does not calculate some formulas Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#3614 · 2 comments · Opened Jun 14, 2023
Support Box and Whisker charts Open

charts

Difficulty 5/5 Over a week Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#3493 · 1 comment · 1 reaction · Opened Mar 30, 2023
ReferenceHelper should update Chart references on insert/delete row/column Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

PHPOffice/PhpSpreadsheet#3480 · Opened Mar 23, 2023
SERIES Function Not Implemented Open

calculation engine charts

PHPOffice/PhpSpreadsheet#3478 · 3 comments · 1 assignee · Opened Mar 23, 2023
DataSeriesValues: How to provide hardcoded values Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

PHPOffice/PhpSpreadsheet#3433 · 16 comments · Opened Mar 3, 2023
Xls Glitches Open

Difficulty 5/5 Over a week Newbie friendliness 15/100

PHPOffice/PhpSpreadsheet#3403 · 2 comments · Opened Feb 26, 2023
`insertNewRowBefore` and/or `removeRow`, does not update cell Reference in formula on other sheets Open

PHPOffice/PhpSpreadsheet#3380 · 3 comments · 1 assignee · Opened Feb 20, 2023
How to insert arrow by Drawing? Open

feature shapes

Difficulty 5/5 Over a week Newbie friendliness 10/100

PHPOffice/PhpSpreadsheet#3172 · 4 comments · Opened Nov 15, 2022
Push buttons are not preserved when loading and saving a file. Open

form controls

Difficulty 4/5 3-5 days Newbie friendliness 30/100

PHPOffice/PhpSpreadsheet#3147 · 7 comments · Opened Oct 28, 2022
Infinite Loop while saving a large Spreadsheet with Formulas Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

PHPOffice/PhpSpreadsheet#3046 · 4 comments · 1 reaction · Opened Sep 2, 2022
Preventing a field from splitting if there are multiple pages Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#3040 · Opened Aug 30, 2022
Concatenated cell content is only displayed up to the first "&" Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

PHPOffice/PhpSpreadsheet#3010 · 17 comments · Opened Aug 17, 2022
Documentation - clarifying X/Y and X2/Y2 Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

PHPOffice/PhpSpreadsheet#3000 · 4 comments · Opened Aug 8, 2022
PDF outputs chart labels horizontally, overriding template vertical setting. Open

charts writer/pdf

Difficulty 4/5 3-5 days Newbie friendliness 38/100

PHPOffice/PhpSpreadsheet#2978 · 1 comment · Opened Aug 1, 2022
poor performance with autosizing of columns if there are merged cells Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#2871 · 8 comments · Opened Jun 3, 2022
Incorrect date rendering Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

PHPOffice/PhpSpreadsheet#2832 · 26 comments · Opened May 16, 2022
Run-time error '429': ActiveX component can't create object Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

PHPOffice/PhpSpreadsheet#2727 · Opened Apr 3, 2022

PHPOffice/PhpSpreadsheet

Get new issues in your inbox