Re: [libreoffice-users] Question [not!] on INDIRECT()

2021-10-18 Thread Brian Barker
At 01:13 18/10/2021 +0200, Rob Jasper wrote: I have the following question: If, as here, you prepare your question as a reply to a previous message when it is nothing of the sort, it will be lost in the previous thread and may not be seen by possible helpers. I have in column A value either

Re: [libreoffice-users] How to print a section of a SS

2021-10-18 Thread Alan B
I hasn't been mentioned if the OP is printing to PDF, and my bad for never reporting the bug, but using LibreOffice File>Export as PDF or the Export Directly as PDF icon causes EVERYTHING on all tabs to print to the PDF no matter what print range might be specified, no matter if the print ranges ar

Re: [libreoffice-users] How to print a section of a SS

2021-10-18 Thread John R. Sowden
Thank you Alan and Steve.  I was not printing to a PDF, but that could have been a later nightmare.  Where my mindset was wrong was that I thought that the mousing a section WAS the define.  So I clicked on define, then moused, then had nothing.  I just tried your method Steve and it worked.  M

Re: [libreoffice-users] How to print a section of a SS

2021-10-18 Thread Steve Edmonds
Your welcome John. I was doing exactly what you were doing to start with. Steve On 19/10/2021 16:51, John R. Sowden wrote: Thank you Alan and Steve.  I was not printing to a PDF, but that could have been a later nightmare.  Where my mindset was wrong was that I thought that the mousing a sectio

Re: [libreoffice-users] How to print a section of a SS

2021-10-18 Thread Steve Edmonds
Hi John. What version of Libreoffice are you on. When you say you want to print a section of a sheet, is that a single section on just one sheet or sections of multiple sheets. For me on a single sheet, sometimes the print range has some history from previous activity. I go Format>Print Range