-
Notifications
You must be signed in to change notification settings - Fork 3.6k
Closed
Description
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 is the expected behavior?
This code should freeze row 1 in Ods document:
$sheet->freezePane('A2');
What is the current behavior?
First row is not frozen.
What are the steps to reproduce?
- Select current sheet.
- Freeze row as in code sample above.
Please provide a Minimal, Complete, and Verifiable example of code that exhibits the issue without relying on an external Excel file or a web server:
<?php
require __DIR__ . '/vendor/autoload.php';
// Create new Spreadsheet object
$spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
// add code that show the issue here...
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'hello world!');
$sheet->freezePane('A2');
$filename = tempnam('/tmp', 'export_');
$writer = new \PhpOffice\PhpSpreadsheet\Writer\Ods($spreadsheet);
$writer->save($filename);
Which versions of PhpSpreadsheet and PHP are affected?
I'm using: 1.17, didn't test earlier versions.
Metadata
Metadata
Assignees
Labels
No labels