Summary: | Allow toggling of absolute and relative references when working with Function Wizard | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Jean-Sebastien Bevilacqua <realitix> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | aaalmosss, ilmari.lauhakangas, jalojo, miguelangelrv, xiscofauli, xv3247 |
Priority: | medium | ||
Version: | 5.2.4.2 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=142341 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 105582, 109329 | ||
Attachments: | usecase |
Description
Jean-Sebastien Bevilacqua
2017-07-21 09:38:38 UTC
Nice tough, but next to the function wizard there is a name box, where you can put a name for the range of cells you need in the vlookup. And so you can drag it down without changing the range array. And it is better way when the spreadsheet needs a data checkup, or upgrade. Thanks Xavier for your answer, very interesting. I tested it and it work great. I would like more opinions about it to know if it's enough. Created attachment 134768 [details]
usecase
An example where this could be useful.
Criterion can be used as name for E2:E120 and to replace the first argument. Maybe the feature should be 'F4 Toggle reference', working insidee the wizard when selecting a range. (In reply to m.a.riosv from comment #5) > Maybe the feature should be 'F4 Toggle reference', working insidee the > wizard when selecting a range. So this: https://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative#Absolute_Addressing It seems we have consensus this is useful, so changing summary and setting to NEW. |