Re: [libreoffice-users] Re: Fit last column in spreadsheet to print
On 2021-01-11 01:14, John Kaufmann wrote: On 2021-01-11 00:45, Brian Barker wrote: At 00:21 11/01/2021 -0500, John Kaufmann wrote: Sorry, but I don't follow: What does it mean for a spreadsheet to print one sheet wide? See "Printing options for page styles" in Chapter 6, "Printing, Exporting, E-mailing, and Signing" of the Calc Guide. o Go to Format | Page... | Sheet | Scale. o Set "Scaling mode" to "Fit print range(s) to width/height" and "Width in pages" to 1. Very nice! I had overlooked that. Thanks, Brian. ... (especially in an environment where a sheet could be a million columns wide) ... (Er, sorry, but maximum columns per sheet is 1024.) I did exaggerate, didn't I? 10^6 high, but only 10^3 (AMJ) wide. I should have checked. Um, sorry: That should be 2^20 high by 2^10 (AMJ) wide. [That was sloppy.] -- 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] Re: Fit last column in spreadsheet to print
On 2021-01-11 00:45, Brian Barker wrote: At 00:21 11/01/2021 -0500, John Kaufmann wrote: Sorry, but I don't follow: What does it mean for a spreadsheet to print one sheet wide? See "Printing options for page styles" in Chapter 6, "Printing, Exporting, E-mailing, and Signing" of the Calc Guide. o Go to Format | Page... | Sheet | Scale. o Set "Scaling mode" to "Fit print range(s) to width/height" and "Width in pages" to 1. Very nice! I had overlooked that. Thanks, Brian. ... (especially in an environment where a sheet could be a million columns wide) ... (Er, sorry, but maximum columns per sheet is 1024.) I did exaggerate, didn't I? 10^6 high, but only 10^3 (AMJ) wide. I should have checked. I trust this helps. You bet. Thanks again, 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] Question about tab order in form in Writer
Hi! I'm working on converting a 20 page document into a PDF form. I'm using the form design mode of LibreOffice Writer 7.0.3 on Windows 10 to add the various form fields. At the time I started this, I thought I had to manually set the tab order on each form field. After investing some odd behavior with tab order in forms, I learned Writer will automatically set the tab order of the form fields. I have since upgraded to LibreOffice 7.0.4. My question: is it possible to "reset" the tab order values I set manually? If not, is it possible to "undo" or remove the tab order values I set on each form field? I'm only 2 pages into my document, fortunately. :) Thanks in advance! Happy New Year! :) Peace... "The Other" Tom -- 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] Re: Fit last column in spreadsheet to print
On 2021-01-10 18:07, Alan B wrote: ... Your initial question was "...see how I can fit the last column in to print on 8/12 x 11..." which to me is equivalent to "fit all columns on a single sheet". So the answer is to set the page width of the printout to one sheet wide. ? Sorry, but I don't follow: What does it mean for a spreadsheet to print one sheet wide? (especially in an environment where a sheet could be a million columns wide) -- 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] macros - where stored for Calc
On 10 Jan 2021 at 12:32, Girvin Herr wrote: Send reply to: ghe...@fastmail.com Subject:Re: [libreoffice-users] macros - where stored for Calc To: users@global.libreoffice.org From: Girvin Herr Date sent: Sun, 10 Jan 2021 12:32:04 -0800 > On 1/10/21 3:18 AM, Johnny Rosenberg wrote: > > Den sön 10 jan. 2021 kl 12:07 skrev Philip Jackson : > > > >> On 10/01/2021 08:49, Johnny Rosenberg wrote: > >>> Den sön 10 jan. 2021 kl 08:35 skrev Tom Cloyd MS MA < > tomcloydm...@gmail.com>: > > I recently moved my LO user profile to a new computer, but my Calc > > macros were not to be found. I had to recreate them. I am about to > > repeat this move with another computer. I REALLY want to move my macros > > also, but somehow my backups is not catching them. > > > > Please - where are they stored? > >>> Here's what I replied: > Mine seem to be located at ~/.config/libreoffice/4/user/basic/ > In ~/.config/libreoffice/4/user/basic/Standard I find my own global > macros. They are stored in XML format with file suffixes like xba, xlb, > xlc, xdl ... > The xdl files are for dialogues, by the way. > > I'm running Manjaro. I guess it could be slightly different in other > operating systems. > >> My LO templates spent years being in a subdirectory in the > >> ~/.config/libreoffice/4/user/ structure but after an update (system or > >> LO, I can't remember now) they all apparently disappeared. Hunting around, > >> I found them in my home root directory ~/Templates/ > >> > > I upgrade relatively often and mine are still in > > ~/.config/libreoffice/4/user/template/ > > I don't remember if that was also true when I had Ubuntu (I'm on Manjaro > > since 2016 or so), though. > > > > > > Kind regards > > > > Johnny Rosenberg > > > > > >> I don't recall ever having moved them there (but I cannot exclude it 100%) > >> but it seems as good a place as any. > >> Philip > >> > >> > >> -- > >> 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 > >> > Greetings, > > IIRC, the LO default templates directory is in > ~/.config/libreoffice/4/user/template Looking at Tools > LibreOffice > > Paths will confirm this and it is the place where it can be changed. The > Open Desktop standard is in ~/Templates. I added ~/Templates to my LO > Templates path with a semicolon separator, so my LO searches both places. > > HTH > > Girvin In looking at my setup on Fedora System. Don't know if this matches other setups. Directory where macros are stored. /home/msetzerii/.config/libreoffice/4/user/basic/Standard Files in Directory -rw-r--r--. 1 msetzerii msetzerii 288 Jun 7 2018 dialog.xlb -rw-rw-r--. 1 msetzerii msetzerii 18729 Jan 8 22:25 Module1.xba -rw-rw-r--. 1 msetzerii msetzerii 348 Jan 8 22:25 script.xlb Now an added question. I've made about 40 backup of my macros by doing the following over time. Tools / Macros / Edit Click on the panel on Right that list the macros Currently it shows 398 lines. Do a Ctrl-A to hightlight all lines, and then a Ctrl-C. Open a text editor, and paste the lines and save as libremacroxx The Module1.xba file currently has 400 lines in it. I've copied the text file to other machines, and just reversed the process of pasting the lines into the window, and they seem to transfer just fine. I also like keeping multiple copies, so I can compare them to see how I've made changes over time. Sometimes make a mistake, and having a back to be able to restore all or whatever macros. Just use the basic setup, so perhaps some have more files. > > > > -- > 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 ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ -- 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:
[libreoffice-users] Re: Fit last column in spreadsheet to print
Hi Charles, Your initial question was "...see how I cna fit the last column in to print on 8/12 x 11..." which to me is equivalent to "fit all columns on a single sheet". So the answer is to set the page width of the printout to one sheet wide. Not sure what to say to your follow up, "...I have no idea what I would set the “Width in pages” to fir this spreadsheet...", because width will ALWAYS BE set to one sheet if you want the printout to fit across one sheet. If it has many rows then be sure to set the #of pages high by a number that will fit everything. If set to 100 the output won't be stretched to be 100 pages tall. And you hit on the real trick, "...with all columns across the same page and also in readable print..." Readable print depends on the number of columns and the width of the sheet. If the print isn't legible, try printing the sheet landscape. Now there's immediately 2½" more paper to scale your columns across. If the print is still too small then try landscape on a legal page or reduce the number of columns that need to be seen or both. p.s. moved back to the list. meant to reply there the first time On Mon, Jan 4, 2021 at 2:52 PM charles meyer wrote: > Hi Alan, > > > > I hope you’re enjoying a good new year. > > > > In Calc, I opened the spreadsheet and then held d own the mouse to > highlight all the columns and rows of content to print. > > > > I then selected Format > Page and the Sheet tab and selected “Fit print > range wit width/height” but I have no idea what I would set the “Width in > pages” to fir this spreadsheet both with all columns across the same page > and also in readable print. > > > > I tried this in Excel and I can either get all the columns across the page > on one page but in tiny print or I can cat the font size in readable size > but not all the columns align across the one page. > > > > Any further thoughts re: the “Width in pages” to be set to in Calc? > > > > I can’t even see how many pages this spread sheet is on as unlike Libre > Writer or Word there is no page indicator in either Calc or Excel. > > > > Thank you. > > > > Charles. > > > > From: Alan B > Date: Tue, Dec 22, 2020 at 3:40 PM > Subject: Re: [libreoffice-users] Fit last column in spreadsheet to print > To: charles meyer > > Charles, > > > > Both LibreOffice Calc and Microsoft Excel include a print feature to scale > the print range by width and height. The width and height unit used is > number of pages. > > > > From your question I expect you want the printout to be one page wide. > > > > In Calc, select the print range then the menu Format > Page Select the > Sheet tab and for scaling mode select "Fit print range(s) to width/height" > and then specify the desired "Width in pages:". > > > > Same for Excel though I'm sure the menu path would be different. > > > > On Tue, Dec 22, 2020 at 1:49 PM charles meyer > wrote: > > Hi all, > > Woulds anyone please be willing to look at my spreadsheet file to see how I > cna fit the last column in to print on 8/12 x 11. > > It's in Excel. > > Maybe Calc would do better? > > Thank you. > > -- > 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 > > > Alan Boba > CISSP, CCENT, ITIL v3 Foundations 2011 > > > > -- Forwarded message - > From: Alan B > Date: Tue, Dec 22, 2020 at 3:40 PM > Subject: Re: [libreoffice-users] Fit last column in spreadsheet to print > To: charles meyer > > > Charles, > > Both LibreOffice Calc and Microsoft Excel include a print feature to scale > the print range by width and height. The width and height unit used is > number of pages. > > From your question I expect you want the printout to be one page wide. > > In Calc, select the print range then the menu Format > Page Select the > Sheet tab and for scaling mode select "Fit print range(s) to width/height" > and then specify the desired "Width in pages:". > > Same for Excel though I'm sure the menu path would be different. > > > On Tue, Dec 22, 2020 at 1:49 PM charles meyer > wrote: > >> Hi all, >> >> Woulds anyone please be willing to look at my spreadsheet file to see how >> I >> cna fit the last column in to print on 8/12 x 11. >> >> It's in Excel. >> >> Maybe Calc would do better? >> >> Thank you. >> >> -- >> 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 >> > > > -- > Alan Boba > CISSP, CCENT, ITIL v3 Foundations 2011 > > -- Alan
Re: [libreoffice-users] macros - where stored for Calc
On 1/10/21 3:18 AM, Johnny Rosenberg wrote: Den sön 10 jan. 2021 kl 12:07 skrev Philip Jackson : On 10/01/2021 08:49, Johnny Rosenberg wrote: Den sön 10 jan. 2021 kl 08:35 skrev Tom Cloyd MS MA < tomcloydm...@gmail.com>: I recently moved my LO user profile to a new computer, but my Calc macros were not to be found. I had to recreate them. I am about to repeat this move with another computer. I REALLY want to move my macros also, but somehow my backups is not catching them. Please - where are they stored? Here's what I replied: Mine seem to be located at ~/.config/libreoffice/4/user/basic/ In ~/.config/libreoffice/4/user/basic/Standard I find my own global macros. They are stored in XML format with file suffixes like xba, xlb, xlc, xdl … The xdl files are for dialogues, by the way. I'm running Manjaro. I guess it could be slightly different in other operating systems. My LO templates spent years being in a subdirectory in the ~/.config/libreoffice/4/user/ structure but after an update (system or LO, I can't remember now) they all apparently disappeared. Hunting around, I found them in my home root directory ~/Templates/ I upgrade relatively often and mine are still in ~/.config/libreoffice/4/user/template/ I don't remember if that was also true when I had Ubuntu (I'm on Manjaro since 2016 or so), though. Kind regards Johnny Rosenberg I don't recall ever having moved them there (but I cannot exclude it 100%) but it seems as good a place as any. Philip -- 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 Greetings, IIRC, the LO default templates directory is in ~/.config/libreoffice/4/user/template Looking at Tools > LibreOffice > Paths will confirm this and it is the place where it can be changed. The Open Desktop standard is in ~/Templates. I added ~/Templates to my LO Templates path with a semicolon separator, so my LO searches both places. HTH Girvin -- 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] macros - where stored for Calc
Den sön 10 jan. 2021 kl 12:07 skrev Philip Jackson : > On 10/01/2021 08:49, Johnny Rosenberg wrote: > > Den sön 10 jan. 2021 kl 08:35 skrev Tom Cloyd MS MA < > >> tomcloydm...@gmail.com>: > >>> I recently moved my LO user profile to a new computer, but my Calc > >>> macros were not to be found. I had to recreate them. I am about to > >>> repeat this move with another computer. I REALLY want to move my macros > >>> also, but somehow my backups is not catching them. > >>> > >>> Please - where are they stored? > > Here's what I replied: > >> Mine seem to be located at ~/.config/libreoffice/4/user/basic/ > >> In ~/.config/libreoffice/4/user/basic/Standard I find my own global > >> macros. They are stored in XML format with file suffixes like xba, xlb, > >> xlc, xdl … > >> The xdl files are for dialogues, by the way. > >> > >> I'm running Manjaro. I guess it could be slightly different in other > >> operating systems. > > My LO templates spent years being in a subdirectory in the > ~/.config/libreoffice/4/user/ structure but after an update (system or > LO, I can't remember now) they all apparently disappeared. Hunting around, > I found them in my home root directory ~/Templates/ > I upgrade relatively often and mine are still in ~/.config/libreoffice/4/user/template/ I don't remember if that was also true when I had Ubuntu (I'm on Manjaro since 2016 or so), though. Kind regards Johnny Rosenberg > > I don't recall ever having moved them there (but I cannot exclude it 100%) > but it seems as good a place as any. > Philip > > > -- > 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
Re: [libreoffice-users] macros - where stored for Calc
On 10/01/2021 08:49, Johnny Rosenberg wrote: Den sön 10 jan. 2021 kl 08:35 skrev Tom Cloyd MS MA < tomcloydm...@gmail.com>: I recently moved my LO user profile to a new computer, but my Calc macros were not to be found. I had to recreate them. I am about to repeat this move with another computer. I REALLY want to move my macros also, but somehow my backups is not catching them. Please - where are they stored? Here's what I replied: Mine seem to be located at ~/.config/libreoffice/4/user/basic/ In ~/.config/libreoffice/4/user/basic/Standard I find my own global macros. They are stored in XML format with file suffixes like xba, xlb, xlc, xdl … The xdl files are for dialogues, by the way. I'm running Manjaro. I guess it could be slightly different in other operating systems. My LO templates spent years being in a subdirectory in the ~/.config/libreoffice/4/user/ structure but after an update (system or LO, I can't remember now) they all apparently disappeared. Hunting around, I found them in my home root directory ~/Templates/ I don't recall ever having moved them there (but I cannot exclude it 100%) but it seems as good a place as any. Philip -- 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