bridgeplayr

I do not understand how "locale-specific date formatting masks" present a problem. I have read and re-read all of the comments in this thread, and I have looked at Calculate/DateValue.php....

Attached is a small piece of code with a table in a spreadsheet containing a dozen "potentially confusing" string dates separated by slashes. In the table I use Excel function...

There is no ambiguity when a user specifies a cell format "m/d/yyyy", and the cell contains the string "1/10/2021". The computer's system date setting is immaterial. There is only one...

Experimenting with format specifications shows you are right. In my mind, then, I ask "Why format a cell?" if it makes no difference to the DATEVALUE function. It returns the...

And, I never liked Excel's DATEVALUE function anyway!

Yes, I think I understand why. I believe it is an ancient date/time formatting convention by Windows to match the computer's understanding of date/time with the user's "predicted" date/time. In...

This Chart generator is similar to the one in #2967 [33_LineChart_DateAxis_VertGridlines.php.txt](https://github.com/PHPOffice/PhpSpreadsheet/files/9215835/33_LineChart_DateAxis_VertGridlines.php.txt) - This issue resolution builds on the modifications suggested in #2967 (I should probably have combined these two issues.)...

I missed it, darn it. Let me check the implementation, and I’ll comment further. (Thanks for the speedy notice!) From: oleibman ***@***.***> Sent: Thursday, July 28, 2022 9:31 PM To:...

My vertical Gridlines issue #2969 is predicated on adding support for a “date” axis, issue #2967. The “date” axis is available in Excel only for LineCharts - not available on...

Sample spreadsheet creator is derived from samples/Chart/33_Chart_create_scatter.php [33_LineChart_DateAxis.php.txt](https://github.com/PHPOffice/PhpSpreadsheet/files/9215709/33_LineChart_DateAxis.php.txt) - Data remains in worksheet "Data" with 8 datapoints instead of 4 - some dates changed to not end on quarter boundaries...