RE: [libreoffice-users] Libreoffice Calc
Sent with Proton Mail secure email. On Thursday, May 30th, 2024 at 7:13 PM, Virgil Arrington 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/0613.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
[libreoffice-users] Libreoffice Calc
For some reason my questions are not getting posted. Hopefully the fourth attempt works. Software: LO, Version 7.3.7.2, Linux (Mint) Problem: I was asked about autocomplete for cells in Calc. My response was to use a list of cells in Validity. Unfortunately, only a vertical scroll bar is available, which works fine for short lists, but not so great when the list is over 1000 cells in another sheet (same file though). 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? Thanks, Dave Sent with [Proton Mail](https://proton.me/) secure email. -- 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
[libreoffice-users] Calc auto complete from a list of cells
I was asked how to make an auto complete from a list of cells in another sheet in the same file. I thought the validation would work, but it only supports a scroll bar. That is fine for short lists, but not for hundreds of lines. Any suggestions on how to do this? I have seen it in some apps. I played with VLOOKUP, but it doesn't return a list. If there is no good way to do this, can it be a feature request? Thanks, Dave Sent with [Proton Mail](https://proton.me/) secure email. -- 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
[libreoffice-users] Writer input fiels for form letter?
How can fields be added to a Writer document so that the field prompts for the data? For example, imagine a business letter like this: (when cursor over field, it says "Enter the desired date") (When cursor over field, it says "Enter the name of the recipient") Re: (When cursor over field, it says "Enter the subject of the letter") Encl: (When the cursor over field, it says "Enter the number of enclosures") Thanks, Dave Sent with [Proton Mail](https://proton.me/) secure email. -- 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
Re: [libreoffice-users] Fw: Potential bug printing blank Writer tables
The version is 7.5.2. Normally, when I post a question, get a copy of my post. That did not happen, so I assumed something went wrong. Dave, Sent with Proton Mail secure email. --- Original Message --- On Friday, May 5th, 2023 at 2:37 PM, Tom wrote: > Your first message was received. I guess no one responded yet. :) > Which version of Writer are you using? > > Peace... > > Tom W > > On 5/5/23 11:33 AM, dboland9 wrote: > > > Resending because it does not seem to have reached the mail group. > > > > Dave, > > > > Sent with Proton Mail secure email. > > > > --- Forwarded Message --- > > From: dboland9 dbola...@protonmail.com > > Date: On Friday, May 5th, 2023 at 8:07 AM > > Subject: Potential bug printing blank Writer tables > > To: Users users@global.libreoffice.org > > > > > A form was created using Writer tables, double spaced. Printing of the > > > borders was very inconsistent - some too light to even see, a few ok, > > > with most in between. Could I ask others to create a page in Writer with > > > a table covering most of the page. Hit the Enter key twice in each line, > > > then print it. > > > > > > Tables printed with content in them seem to work fine. > > > > > > Dave, > > > > > > Sent with Proton Mail secure email. > > > -- > 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 -- 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
[libreoffice-users] Fw: Potential bug printing blank Writer tables
Resending because it does not seem to have reached the mail group. Dave, Sent with [Proton Mail](https://proton.me/) secure email. --- Forwarded Message --- From: dboland9 Date: On Friday, May 5th, 2023 at 8:07 AM Subject: Potential bug printing blank Writer tables To: Users > A form was created using Writer tables, double spaced. Printing of the > borders was very inconsistent - some too light to even see, a few ok, with > most in between. Could I ask others to create a page in Writer with a table > covering most of the page. Hit the Enter key twice in each line, then print > it. > > Tables printed with content in them seem to work fine. > > Dave, > > Sent with [Proton Mail](https://proton.me/) secure email. -- 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
[libreoffice-users] Potential bug printing blank Writer tables
A form was created using Writer tables, double spaced. Printing of the borders was very inconsistent - some too light to even see, a few ok, with most in between. Could I ask others to create a page in Writer with a table covering most of the page. Hit the Enter key twice in each line, then print it. Tables printed with content in them seem to work fine. Dave, Sent with [Proton Mail](https://proton.me/) secure email. -- 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
Re: [libreoffice-users] blood pressure readings template
A template really isn't needed. All you need are: - A title in one of the cells on the first row. For example "My Blood Pressure Readings". - Leave a row space for readability. - On row three, add these column headings starting with column 1: "Date", "Time", "Systolic", "Diastolic", "Pulse", "Notes" - You may want to make the column headings bold for readability. - Start recording the readings in the spreadsheet. Once you have a few readings, you can highlight the range and create a chart that will show you how the blood pressure is varying by day or time, and any other special situation noted in Notes column. Very easy actually. Dave, Sent with Proton Mail secure email. --- Original Message --- On Tuesday, April 18th, 2023 at 1:31 PM, V Stuart Foote wrote: > [libreoffice-users] > Serena Clooney > Tue, 18 Apr 2023 18:01:50 +0100 > Hi > > I wonder if you could please help me. > > We have been asked to record my 92 yr old mum's blood pressure readings > at > home and to present the results in spreadsheet form to our GP. > > Can anyone help with a Libreoffice template to help record these daily > readings,please? > > Many thanks > Srena > > -- > > Have a look at these templates, either might work for you. > > https://extensions.libreoffice.org/en/extensions/show/blood-pressure-weight-body-mass-index-tracking > > or > > https://extensions.libreoffice.org/en/extensions/show/body-parameters-monitor > > -- > V Stuart Foote > > -- > 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 -- 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
[libreoffice-users] LO data wizzard
I was trying to use mail merge in LO. The documentation (7.1, but I have 7.4) has some errors/omissions. - Step 6. The text says to click Finish once the connection is tested. Actually, you need to select the correct sheet prior to Finish. Sometimes there will be more than one sheet with addresses. - Step 10. "Click Finish. The data source is now registered." I get an error that says the file already exists - overwrite it? Clicking Help gets another error saying the page does not exist. So, what do I do here??? Dave, Sent with [Proton Mail](https://proton.me/) secure email. -- 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
[libreoffice-users] Frame auto-resize image
How does on place a frame in a Writer document so that the image is automatically resized to fit the size of the frame? The most important dimension is width, so the height can be sacrificed to keep the W/H ratio. I know how to resize the frame for the image, but the application has a fixed location, thus size. Thanks, Dave Sent with [Proton Mail](https://proton.me/) secure email. -- 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
[libreoffice-users] Connect to .accdb files
I read that LO Base can open the Access 2007/2010 files. The instructions say to select the Access 2007 connection. Well, there are no Access connections. Only JDBC, Thunderbird, spreadsheet, dBase, Firebird, Text, MySQL, ODBC, PostgreSQL, and Writer. Any ideas? Thanks, Dave Sent with [ProtonMail](https://protonmail.com/) Secure Email. -- 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
[libreoffice-users] Smart pdf forms with calculations
Has anyone tried to use LO to create a smart form that does calculations? I'm thinking of an order form that calculates sales tax based on the location and shipping cost based on the destination. Some areas have no sales tax, others a little, etc. Thanks, Dave Sent with [ProtonMail](https://protonmail.com) Secure Email. -- 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
