mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-20 18:51:41 +00:00
oleibman
5de82981d8
* Html Reader Not Handling non-ASCII Data Correctly Fix #2942. Code was changed by #2894 because PHP8.2 will deprecate how it was being done. See linked issue for more details. Dom loadhtml assumes ISO-8859-1 in the absence of a charset attribute or equivalent, and there is no way to override that assumption. Sigh. The suggested replacements are unsuitable in one way or another. I think this will work with minimal disruption (replace ampersand, less than, and greater than with entities representing illegal characters, then use htmlentities, then restore ampersand, less than, and greater than). * Better Implementation Use regexp to escape non-ASCII. Less kludgey, less reliant on the vagaries of the PHP maintainers. * Additional Tests Test non-ASCII outside of cell contents: sheet title, image alt attribute. * Apply Same Change in Second Location Forgot to change loadFromString. * Additional Test Confirm escaped ampersand is handled correctly.
29 lines
737 B
HTML
29 lines
737 B
HTML
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<!-- deliberately do not identify charset for this test -->
|
|
<title>Test Utf-8 characters voilà</title>
|
|
</head>
|
|
<body>
|
|
<table>
|
|
<tbody>
|
|
<tr>
|
|
<td>éàâèî</td><!-- Latin1 -->
|
|
<td>αβγδε</td><!-- Greek -->
|
|
</tr>
|
|
<tr>
|
|
<td>𐐁𐐂𐐃 & だけち</td><!-- Osmanya (not in BMP) and Hiragana -->
|
|
<td>אבגדה</td><!-- Hebrew -->
|
|
<td>𪔀𪔁𪔂</td><!-- CJK Unified Ideographs Extension B (not in BMP) -->
|
|
</tr>
|
|
<tr>
|
|
<td>᠐᠑᠒</td><!-- Mongolian -->
|
|
<td>അആ</td><!-- Malayalam -->
|
|
<td>กขฃ</td><!-- Thai -->
|
|
<td>✀✐✠</td><!-- Dingbats -->
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</body>
|
|
</html>
|