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)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Excel-Functions
  Show dependency treegraph
Reported: 2020-10-16 19:35 UTC by Roman Kuznetsov
Modified: 2023-03-29 23:45 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


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
Add a LET function into Calc for interoperability with MSO


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 Comment hidden (me-too)
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.