Calc 7.2 and autocompletion changes

It occurred to me that these changes affect documentation: https://bugs.documentfoundation.org/show_bug.cgi?id=142214

However, the whole thing is kind of up in the air because there is clearly a need for improvement and fast, as annoyed users are voicing their disappointment. I would at least hope that the feature would be addressed in a point release.

Ilmari

Hi Ilmari,

I agree that when the changes are complete, we should make sure that the Calc Guide describes the implemented behaviour accurately.

Regards,

Steve

Hi all,

Hi Ilmari,

I agree that when the changes are complete, we should make sure that the
Calc Guide describes the implemented behaviour accurately.

There is already a change in 7.2, the limit indicated here:
https://help.libreoffice.org/latest/en-GB/text/scalc/01/06130000.html
doesn't exist anymore. See the comment from Eike on this question:
https://ask.libreoffice.org/t/autoinput-how-to-increase-number-of-cells-above-to-be-scanned/67591
Cheers
Sophie

Thanks Sophie,

The limit will be removed from the Calc Guide at 7.2.

I can also remove it from the help in due course, if nobody else does it first.

Regards,

Steve

Ok, but the most controversial thing is that if there are empty cells between the existing similar string and the cell you are typing in, it will not offer autocompletion *at all*. It is clear that this either has to be simply reverted or the logic reworked in a way that improves the user experience compared to the old way.

Ilmari

This ignoring of content above empty cells was reverted today and will not be in 7.2.1 anymore.

Ilmari