Created attachment 163130 [details] The formula editor I use formula editor to create a RECHERCHEV() formula. In the formula, the editor doesn't add $ in the matrix. Example : It would be better to write =RECHERCHEV(A8;$Feuille2.$A$1:$B$40;2;0) instead of =RECHERCHEV(A8;$Feuille2.A1:B40;2;0) because after, when you copy-paste the formula in other cases, the range A1:B40 becomes A2:B41, A3:B42... instead of staying A1:B40 Could you modify the formula editor in order to add $ in the matrix ?
Tested in Excel : Excel adds $, not LibreOffice.
@Eike, I thought you might be interested in this issue
In the point and click / mouse selecting cases we probably should continue to generate relative references for single cells but absolute references for cell ranges. Would make sense.
Or rather absolute references for non-single dimensions, like A1, A$1:A$3, $A1:$C1, $A$1:$C$1, so single dimensions are copy-adjustable.
$A$1:$C$3 that last should had been..
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3b5fccb308b9554d024e1d576abbf3ebec26b7a5 Resolves: tdf#134876 Absolute range references when selecting in Wizard It will be available in 7.1.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.
Verified. It's ok Version: 7.1.0.0.alpha0+ Build ID: 6ad2f463784a24c566477cdd60ae729651bb8564 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
It works with Calc 7.3.7.2. Thank you very much.