https://bugs.documentfoundation.org/show_bug.cgi?id=164238
Bug ID: 164238
Summary: LET function should assign the types to its variables
according to their expressions, if possible
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
In a General-formatted cell, entering e.g. =TODAY() would auto-format it to a
date format; =TRUE() to Boolean, etc.
That would propagate through (some) functions and calculations, like
=IF(1;TODAY()) or =TODAY()-1.
On the other hand, =LET(mydate;TODAY();mydate) in a General-tormatted cell
would produce e.g. 45634 - i.e., the cell won't assume the respective date
format.
It would be nice, if the variables of LET would keep the expression's type /
format group the same way, and then would propagate it to the function's
result.
--
You are receiving this mail because:
You are the assignee for the bug.
