Bug 164238 - LET function should assign the types to its variables according to their expressions, if possible
Summary: LET function should assign the types to its variables according to their expr...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: QA:needsComment
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency tree / graph
 
Reported: 2024-12-08 06:33 UTC by Mike Kaganski
Modified: 2024-12-23 03:21 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2024-12-08 06:33:26 UTC 
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.