Re: [libreoffice-users] Calc auto complete from a list of cells
Dave, On 2024-05-29 16:38, dboland9 wrote: 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. ... Trying to understand what is needed, I would ask if you can give an example of what you have seen in some apps. Thanks, John -- 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] Q: configure “Remote Files” to access a SMB share on a Fritzbox
Hi all, I try to access files on the SMB share of a Fritzbox router using the “Remote Files” in Libreoffice, but unfortunately without success. From the Linux command line, the following command opens the connection to the share: smbclient -U shareuser --password ** -W WORKGROUP -D Storage //fritz.nas/my.nas In Libreoffice, I enter the following data in the “Remote Files” dialogue using “Add service”: * Type: Windows share * Host: fritz.nas * Share: my.nas * user and password: as above; enable Remember password * Root: Storage Selecting the “Service” entry, the “Remote Files” dialogue is still greyed out, no folders or LO files are displayed, and all I can do is to click “Cancel”. No error message or other information is displayed. My Libreoffice version (installed from Debian Bookworm backports, but I have the same issue with the official macOS build): Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: en-US (C); UI: en-US Debian package version: 4:24.2.4-1~bpo12+1 Calc: threaded How should the Service be configured to access the files on the share? Any help will be highly appreciated! Thanks in advance, Albrecht. -- 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] Export to ePub
On Wed, 26 Jun 2024 12:42:22 +1000 Keith Bainbridge wrote: > I get that in calc. writer gives more options Duh! Thanks Keith. I happened to have a spreadsheet open, so I looked there and couldn't see the options. I just looked in writer and now see it. I wonder why you can't export spreadsheets? -- 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