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
+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. *** +1 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. |