Sent with Proton Mail secure email.
On Thursday, May 30th, 2024 at 7:13 PM, Virgil Arrington <cuyfa...@hotmail.com>
wrote:
> I have found several of your emails in my junk email folder. I find that over
> half of all emails from the LO list go to my junk folder.
>
> Virgil
>
> ________________________________
> From: ady adylo811...@gmail.com
>
> Sent: Thursday, May 30, 2024 7:00:02 PM
> To: users@global.libreoffice.org users@global.libreoffice.org
>
> Subject: Re: [libreoffice-users] Libreoffice Calc
>
> > For some reason my questions are not getting posted. Hopefully the fourth
> > attempt works.
>
>
> There are at least 2 emails from you in the public users mailing list;
> see the mailing list public archives. I am replying to one of them.
>
> > Software: LO, Version 7.3.7.2, Linux (Mint)
> >
> > I thought that LO Calc would let one start typing c, o, l and get
> > coliflour. Is there some way to do this,or is it a feature request?
>
>
> The feature is called "AutoInput". In Calc, you can set it ON/OFF in
> menu Tools > AutoInput.
>
>
> In Calc, if you already have a value in one cell and you want to
> repeat the same value in another cell in the same column – it works
> better if the range has no empty blank cells in-between, but that's
> not a strict condition – then usually the behavior is as you
> described.
>
> If you have "coliflour" (without quotation marks) in cell A1, and
> something else in cell A2, then in cell A3 you could start typing "c"
> (without quotation marks), then a prior (partial) value would be
> suggested, instead of having to type-in the complete value each time.
>
> As of current versions, the feature works similar to a bash-like
> (auto)completion, but incidentally the feature was modified several
> times between LO 7.1 and 7.3, so if you are having problems with this
> I would suggest trying a newer version that you currently report
> (7.3.7.2).
>
> See:
> https://help.libreoffice.org/latest/en-US/text/scalc/guide/auto_off.html?DbPAR=CALC
>
>
> https://help.libreoffice.org/latest/en-US/text/scalc/01/06130000.html?&DbPAR=CALC
>
>
> HTH,
> Ady.
>
Virgil,
Thanks for the reply. I checked my spam folder, no LO there. My expectation
was that when I sen a note to the list for support, I would get a copy back.
That didn't happen so I kept posting. My apologies to anyone offended!
AutoInput only works for cells in the same column. As I tried to explain, the
lists of inputs are in another sheet to keep the input form cleaner looking.
So it looks like a very long scroll bar is the only option for now.
Thanks,
Dave
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy