Bug 137543 - Add a LET function into Calc
Summary: Add a LET function into Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Thorsten Behrens (allotropia)
URL:
Whiteboard:
Keywords:
: 158468 (view as bug list)
Depends on:
Blocks: Excel-Functions
  Show dependency tree / graph
 
Reported: 2020-10-16 19:35 UTC by Roman Kuznetsov
Modified: 2024-04-12 07:01 UTC (History)
15 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 Roman Kuznetsov 2020-10-16 19:35:45 UTC 
Description:
Add a LET function into Calc for interoperability with MSO

https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999

Steps to Reproduce:
-

Actual Results:
there is no a LET function in Calc

Expected Results:
there is a LET function in Calc


Reproducible: Always


User Profile Reset: No



Additional Info:
-
Comment 1 m_a_riosv 2020-10-17 19:45:59 UTC 
+1
Comment 2 BogdanB 2020-10-18 12:30:14 UTC 
I don't kwow if in this is needed a confirm, but I checked that it is not available in LO and it is available in MSO.
Comment 3 Vladimir Sokolinskiy 2022-03-09 11:38:08 UTC 
The implementation of the LET function will significantly expand the capabilities of the Calc formula language.
Comment 4 Dan Dascalescu 2023-03-29 23:45:14 UTC 
This would be very useful to shorten formulas that repeat the same quantity, such as outputting both an absolute and a percentage change between two values.
Comment 5 ady 2023-11-30 19:21:06 UTC 
*** Bug 158468 has been marked as a duplicate of this bug. ***
Comment 6 Pavel Sayekat 2023-12-12 17:49:54 UTC 
+1
Comment 7 me 2024-03-12 04:02:46 UTC 
Is anyone working on this feature? I am working on a process that makes use of a load bearing spreadsheet. At this point, we will have to migrate to MSO or Google Sheets if LAMBDA and LET are not supported.

If no one is working on this feature, but the maintainers are open to it, I'd like to work on supporting LAMBDA and LET. I have left a similar comment on the bug for LAMBDA (https://bugs.documentfoundation.org/show_bug.cgi?id=138749).