Bug 137543

Summary:	Add a LET function into Calc
Product:	LibreOffice	Reporter:	Roman Kuznetsov <79045_79045>
Component:	Calc	Assignee:	Balázs Varga (allotropia) <balazs.varga991>
Status:	ASSIGNED ---
Severity:	enhancement	CC:	buzea.bogdan, ddascalescu+freedesktop, himajin100000, jannis.huebl, kubry, me, mgb1508, miguelangelrv, olivier.hallot, ovari123, pavelsayekat, phunanon, piotr.osada, sokol, thb, winfrieddonkers
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	150900

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).

Comment 8 Óvári 2024-05-01 07:57:02 UTC

Olivier Hallot can a Help page for the LET function, at say https://help.libreoffice.org/master/en-US/text/scalc/01/func_let.html, please be added?

Similar to https://help.libreoffice.org/master/en-US/text/scalc/01/func_let.html

Thank you

Comment 9 Óvári 2024-05-01 07:57:52 UTC

(In reply to me from comment #7)
> 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).

Thank you for your offer. Can you please work on the LAMBDA function?

Comment 10 Olivier Hallot 2024-05-02 10:34:19 UTC

(In reply to Óvári from comment #8)
> Olivier Hallot can a Help page for the LET function, at say
> https://help.libreoffice.org/master/en-US/text/scalc/01/func_let.html,
> please be added?
> 
> Similar to
> https://help.libreoffice.org/master/en-US/text/scalc/01/func_let.html
> 
> Thank you

Hi!
Yes of course, as soon as the function LET is implemented, otherwise people will find a Help page on something that does not exist.