Open audetto opened 1 year ago
Date automatically handled in Excel.
Excel sees a string not a date. Even =DATEVALAUE() cannot handle the string format.
Windows 11, Excel 365
Excel represents dates as number of days since 1900 something. Ideally kdb-studio should use this format.
Using a string still requires DATEVALUE(), in which case kdb-studio should select a better format (see https://support.microsoft.com/en-us/office/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252) but it might become locale-dependent. The number is safer.
"Open in Excel" works, but it has the bad habit of opening a new Excel session, from which one can copy, true, but still very cumbersome.
Bug Report
Steps to Reproduce:
Expected Result:
Date automatically handled in Excel.
Actual Result:
Excel sees a string not a date. Even =DATEVALAUE() cannot handle the string format.
Environment:
Windows 11, Excel 365
Additional Context:
Excel represents dates as number of days since 1900 something. Ideally kdb-studio should use this format.
Using a string still requires DATEVALUE(), in which case kdb-studio should select a better format (see https://support.microsoft.com/en-us/office/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252) but it might become locale-dependent. The number is safer.
"Open in Excel" works, but it has the bad habit of opening a new Excel session, from which one can copy, true, but still very cumbersome.