You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
- [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 expected behavior?
The HTML Reader should produce a cell with two lines of text when parsing a table cell containing a br tag.
What is the current behavior?
The cell produced initially appears in Excel as a single line, although editing the cell results in the expected display.
<?phprequire__DIR__ . '/vendor/autoload.php';
// Import from html$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load('sample.html');
// Write the resulting spreadsheet as xlsx$writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
$writer->save('sample.xlsx');
Which versions of PhpSpreadsheet and PHP are affected?
All versions up to at least 1.7.0, all versions of PHP
Proposed fix
The cell requires the wrapText attribute to be applied, as in pull request #1070
The text was updated successfully, but these errors were encountered:
1.9.0
### Added
- When <br> appears in a table cell, set the cell to wrap [#1071](#1071) and [#1070](#1070)
- Add MAXIFS, MINIFS, COUNTIFS and Remove MINIF, MAXIF [#1056](#1056)
- HLookup needs an ordered list even if range_lookup is set to false [#1055](#1055) and [#1076](#1076)
- Improve performance of IF function calls via ranch pruning to avoid resolution of every branches [#844](#844)
- MATCH function supports `*?~` Excel functionality, when match_type=0 [#1116](#1116)
- Allow HTML Reader to accept HTML as a string [#1136](#1136)
### Fixed
- Fix to AVERAGEIF() function when called with a third argument
- Eliminate duplicate fill none style entries [#1066](#1066)
- Fix number format masks containing literal (non-decimal point) dots [#1079](#1079)
- Fix number format masks containing named colours that were being misinterpreted as date formats; and add support for masks that fully replace the value with a full text string [#1009](#1009)
- Stricter-typed comparison testing in COUNTIF() and COUNTIFS() evaluation [#1046](#1046)
- COUPNUM should not return zero when settlement is in the last period [#1020](#1020) and [#1021](#1021)
- Fix handling of named ranges referencing sheets with spaces or "!" in their title
- Cover `getSheetByName()` with tests for name with quote and spaces [#739](#739)
- Best effort to support invalid colspan values in HTML reader - [#878](#878)
- Fixes incorrect rows deletion [#868](#868)
- MATCH function fix (value search by type, stop search when match_type=-1 and unordered element encountered) [#1116](#1116)
- Fix `getCalculatedValue()` error with more than two INDIRECT [#1115](#1115)
- Writer\Html did not hide columns [#985](#985)
This is:
What is the expected behavior?
The HTML Reader should produce a cell with two lines of text when parsing a table cell containing a br tag.
What is the current behavior?
The cell produced initially appears in Excel as a single line, although editing the cell results in the expected display.
What are the steps to reproduce?
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:
sample.html:
Which versions of PhpSpreadsheet and PHP are affected?
All versions up to at least 1.7.0, all versions of PHP
Proposed fix
The cell requires the wrapText attribute to be applied, as in pull request #1070
The text was updated successfully, but these errors were encountered: