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
- [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)
What is the expected behavior?
detect returned string when calling fromString then skip operation
(line 132) $value = DateTimeExcel\DateValue::fromString($value) + DateTimeExcel\TimeValue::fromString($value);
What is the current behavior?
string+string is an issue in PHP 8.x
Fatal error: Uncaught TypeError: Unsupported operand types: string + string in C:\Program Files\EasyPHP-Devserver-17\eds-www\aplitec\includes\modules\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Calculation\TextData\Format.php:132
What are the steps to reproduce?
save("crash.xlsx");
?>
If this is an issue with reading a specific spreadsheet file, then it may be appropriate to provide a sample file that demonstrates the problem; but please keep it as small as possible, and sanitize any confidential information before uploading.
What features do you think are causing the issue
Reader
[ X] Writer
Styles
Data Validations
Formula Calculations
Charts
AutoFilter
Form Elements
Does an issue affect all spreadsheet file formats? If not, which formats are affected?
DATE Cell formatting when date cell is still a keyword and not yet a valid date!
Which versions of PhpSpreadsheet and PHP are affected? PHP >= 8.0
Sorry, I don't even understand what your spreadsheet contains. C2 seems to contain [onload.datecalcullong]. Is that what it is supposed to contain? B4 seems to contain ="Crash on au "&TEXT(C2,"jj/mm/aaaa"), which Excel evaluates as Crash on [onload.datecalcullong]. PhpSpreadsheet evaluates it as a #VALUE error (and it does not throw an exception when I load and save). Possibly this is locale-related - I'll need to do some research about that. But, while I'm doing that, it would be helpful to know how you expect this to behave.
This is:
What is the expected behavior?
detect returned string when calling fromString then skip operation
(line 132) $value = DateTimeExcel\DateValue::fromString($value) + DateTimeExcel\TimeValue::fromString($value);
What is the current behavior?
string+string is an issue in PHP 8.x
Fatal error: Uncaught TypeError: Unsupported operand types: string + string in C:\Program Files\EasyPHP-Devserver-17\eds-www\aplitec\includes\modules\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Calculation\TextData\Format.php:132
What are the steps to reproduce?
save("crash.xlsx"); ?>If this is an issue with reading a specific spreadsheet file, then it may be appropriate to provide a sample file that demonstrates the problem; but please keep it as small as possible, and sanitize any confidential information before uploading.
What features do you think are causing the issue
Does an issue affect all spreadsheet file formats? If not, which formats are affected?
DATE Cell formatting when date cell is still a keyword and not yet a valid date!
Which versions of PhpSpreadsheet and PHP are affected? PHP >= 8.0
BUG_PHPSpreadsheet_PHP8_DATE.xlsx
The text was updated successfully, but these errors were encountered: