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: -
+1
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.
The implementation of the LET function will significantly expand the capabilities of the Calc formula language.
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.
*** Bug 158468 has been marked as a duplicate of this bug. ***
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).
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
(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?
(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.
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/521a56d8d1e12b7471fda6b62b21d51776c9fbaf tdf#137543 - Add new LET function to Calc It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d557d2ae8c3c259bcf01465e6380cad77ed4bdb9 Related: tdf#137543 - Add new LET function to Calc It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e52b555a1d9fb40aa923adcd73f3021c3380db84 Related: tdf#137543 - fix LET function jump count number It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.