PhpSpreadsheet

PhpSpreadsheet copied to clipboard

The OFFSET function cannot use the return value of the INDIRECT 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) ### What is the...

Awilen-Bernkastel

Problems with Trend Best Fit

1

There are at least 2 problems. The first is minor, using the wrong property in a single statement; this is addressed by @quonly in PR #4339. A more serious problem...

oleibman

Creating autoload without composer

2

Hello, I have an offline apache server so I can't use composer. How to generate the autoload php file ? Thx.

Flow75

Pie chart (2D) created as 3D

5

Hello, I'm trying to create a 2D Pie chart, by following this example: [33_Chart_create_pie.php](https://github.com/PHPOffice/PhpSpreadsheet/blob/master/samples/Chart33b/33_Chart_create_pie.php) Basically the generated chart is a 3D Pie: I've done a bit of reverse engineering and...

trane77

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

5

=WENNFEHLER(SVERWEIS(D2;'file:///C:/Program Files (x86)/xampp/htdocs/cao-adresses.xlsx'#$Worksheet.A2:C99999;3;0); "") will be converted to =WENNFEHLER(SVERWEIS(D2;[1]worksheet!a2:C99999;3;0); "") when loading the file with phpspreadsheet and save it again as a new file. i attached a sample-file, that can...

comfine

Want Constant for Formatting Integer Using Thousands Separator

3

I need to format numbers with thousands separators and no decimals like this: const FORMAT_NUMBER_COMMA_SEPARATED3 = '#,##0'; Adding a PR to fix.

reetp

Add format number with thousands separator and no decimal

1

Add format number with thousands separator and no decimal "#,##0'" This is: - [X ] a new feature ### Why this change is needed? Because I can't format a number...

reetp

Load spreadsheet from memory.

5

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

openFaster

Border in vertical merged cell

3

I have this problem setting border in vertical merged cell (getOutline()) the border is visible only on the top, left and right of the first cell of the merged group...

marcopiai

Writing XLSX from templates don't keep all archive files

3

I am loading a template file, editing it and then saving it, like this : ``` $filename = 'templateImportFactureVente_CAF.xlsx'; $spreadsheet = IOFactory::load( __DIR__ . '/../../' . $filename ); // edit...

mdias-cp