Found it. With an update the default option had changed to include
Formats. Unticking this and normal service has been restored.
On 06/12/2023 09:30, Budge wrote:
I have been sorting on a column using Data>Sort and extending to include
the range wanted. This worked a few weeks ago but
I have been sorting on a column using Data>Sort and extending to include
the range wanted. This worked a few weeks ago but now on the same
spreadsheet I get a popup:-
Ranges containing merged cells can only be sorted without formats.
I click on OK but then nothing happens.
Something has
My problem is that I have enabled wrapping in the cells of a row and
expected the longer text to start a new line and increase the height of
the cell but this does not remain when I move to another line.
What is causing this and how can I correct it so two lines of text are
shown in the
correctly.
What have I done wrong and how may I solve these issues please?
Budge.
--
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
correctly.
What have I done wrong and how may I solve these issues please?
Budge.
--
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
re reading
and testing for this but one step at a time. Will first secure my CA
certificate and work out how to use it with KeePassXC.
That should keep me amused over the weekend.
Thanks again.
Budge.
On 01/09/2023 17:53, Philip Jackson wrote:
Further to my last reply, you can encrypt a Writer
a "stamp" and
added to any document and there may be issues of scaling the size of the
image to suit the environment in which it is used.
If anybody can shine more light it would be very much appreciated.
Budge.
On 31/08/2023 12:48, Philip Jackson wrote:
On 31/08/2023 12:09, Budg
ticked for "show date in signature line."
Please can somebody advise?
Budge
--
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.documentfoun
remove the empty line so that all the cells in the line only have the
required two lines?
Budge.
--
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
Hi John,
I checked out the Google link on authentication and it seems that the problem
probably lies with my ISP. I have asked him to check the headers to find out
if the problem is with him or further away. Will let you know what I learn.
Regards,
Budge.
On 07/07/2023 17:45, John Kaufmann
Hi Regina,
You have it exactly. Now I have what I want so very many thanks.
Thanks also to all who helped.
All good for now thanks.
Budge.
On 06/07/2023 21:20, Regina Henschel wrote:
Hi Budge,
Budge schrieb am 06.07.2023 um 17:15:
I have downloaded a document from the VistitBritain
I see the screenshot didn't copy. Is this a settings thing here or rule for
the site?
On 06/07/2023 20:37, Budge wrote:
Hi all,
Sorry I was distracted earlier.
Here is the link:-
https://www.visitbritain.org/sites/default/files/vb-corporate/business-hub/resources
in that the
pages are in a column. See screenshot:-
Hope this does the same for you or I am stuck on how to solve it.
On 06/07/2023 20:25, Dave Howorth wrote:
On Thu, 6 Jul 2023 16:42:26 +0100
Brad Rogers wrote:
On Thu, 6 Jul 2023 16:15:34 +0100
Budge wrote:
Hello Budge,
How may I break
within the document please so I
may work on each page and then page down?
Hope somebody can help me with this as I have never seen this format before!
Budge
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how
- gsmtp
*
No idea why or what. Whoever uses Outlook anyway but does it mean my mail has
been hacked?
Regards,
Budge.
On 06/07/2023 13:49, DaveB wrote:
Original Message
From: John Kaufmann [mailto:kaufm...@nb.net]
Sent: Thursday, July 6, 2023, 11:57 UTC
To: Budge
I disconnected a year ago and now wish to subscribe. Please advise how I can
join. Spoilt for choices when searching browser so no idea which to use.
Thanks,
Budge
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing
me with this.
Budge
--
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/us
I am trying to print CD labels using Avery Label L7676.
When I open the new sheet using label format, the page appears as a form but as
a rectangle not as expected. How do I now format the page to contain the
printing within the circle to be printed please?
--
To unsubscribe e-mail to:
Two questions please.
I am using Avery A4 L7161 adhesive labels and have opened using the new>label
option which gives me the grid in which to type the text. Having selected font
and size I find the print is too close to the edge of the label.
How may I adjust the margin between the first
enter one or more as required.
Please could you start me in the right direction and advise if LibreOffice is
what I should be using or should I use a simpler editor altogether?
Regards,
Budge
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https
On 05/12/2019 14:05, Budge wrote:
I have just started to try and learn about templates and I read that to
open the templates manager I should use Ctrl+Shift+E.
Well nothing happened but when I then opened writer for a new document
there was a lower case e underlined at the start of the letter
I have just started to try and learn about templates and I read that to
open the templates manager I should use Ctrl+Shift+E.
Well nothing happened but when I then opened writer for a new document
there was a lower case e underlined at the start of the letter. I could
not delete it and what is
On 25/10/2019 20:12, Budge wrote:
> I am trying to do a VLOOKUP to fill in data from one sheet into another.
>
> This works between existing related files which are from previous
> month's quarter but not for my new data for this quarter. Other than
> actual entries the fil
more recent data file
(...to_Sep_2019.ods) I get #Ref for each entry.
Back with the dunces once more!!!
Budge
--
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: h
hen enter
On Tue, Apr 2, 2019 at 6:23 PM Budge mailto:aje...@errichel.co.uk>> wrote:
> Using Writer with DejaVu Sans font and having created a label
using the
> Avery A4 template with Synchronize active, all is well until I
try and
> include the Tradema
-
Ctrl+Shift+U and release, then 2122, then enter
On Tue, Apr 2, 2019 at 6:23 PM Budge wrote:
Using Writer with DejaVu Sans font and having created a label using the
Avery A4 template with Synchronize active, all is well until I try and
include the Trademark symbol. The advice I have
Using Writer with DejaVu Sans font and having created a label using the
Avery A4 template with Synchronize active, all is well until I try and
include the Trademark symbol. The advice I have is:-
Place the cursor in the location where you want the symbol to appear.
On the Insert menu
octobre 2018 à 15:07 +0100, Budge a écrit :
I have a simple lookup of a value in a sheet column from a table array
which enters a code for the value in the adjacent cell. This is to
provide room booking information from which I can derive and use a
related code number. (All working well now thanks
On 09/10/2018 17:18, Brian Barker wrote:
At 16:40 09/10/2018 +0100, Budge Noname wrote:
An array has a column of figures derived from a calculation formula in
which some input values are not available and have been returned as
#Err. (Cannot recall error number). In order to use this array
surrounding the array.
What is correct way to get rid of the errors (due to gaps in data) in
the original calculations. I have special copied the formulas to
numbers and get the numbers OK but how do I avoid the #Err. If I delete
the #Err and leave empty tyhe array still does not work!
Budge
as
"Room 1,Room 3" I would need the codes displayed as 4611,4613
What is the simplest means of showing the room codes when the two (or
more) rooms are shown as one cell entry?
Grateful for your advice please.
Budge
---
This email has been checked for viruses by AVG.
On 05/10/2018 15:53, Brian Barker wrote:
At 11:40 05/10/2018 +0100, Budge Noname wrote:
I have a value in a column (which is not the first column,) ...
What does it matter which column it is in? (Answer: it doesn't.)
... in the first sheet and second sheet with a two column table of
values
I expect there are several ways to do this but seek guidance please.
I have a value in a column (which is not the first column,) in the first
sheet and second sheet with a two column table of values with their
equivalents. I want to look up the value find the equivalent from the
second sheet
On 01/08/2018 12:37, Budge wrote:
Ashamed to ask but cannot get VLOOKUP to work.
I am trying to look up the value in column A in sheet 1 in sheet 2
column 1 and insert the value found in column 10 in sheet 1. Neither
sheets are sorted.
=VLOOKUP(A2,'Bookings_Between_Apr_to Jun_2018_data
things 'Bookings_Between_Apr_to Jun_2018_data'.$A2:$L64
is supposed to define the array in which to search and I thought the $
signs fixed the range but no, when I copy the formula down the page the
array changes.
Where am I going wrong please?
Budge
---
This email has been checked for viruses
On 03/05/2018 12:26, Budge wrote:
I need to concatenate four cells into a single cell string, ie,
First Name, Second Name, Arrival Date, Departure Date. The dates are in
the form 03/04/2018 in a column of cells with date dd/mm/ format.
Using CONCATENATE how can I keep the date cell
they are written into the single cell?
Budge
---
This email has been checked for viruses by AVG.
http://www.avg.com
--
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
at the
lowest level possible.
Where is this set please?
Budge
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquett
I have a formula VLOOKUP(E2,Sheet2.A2:B690,2,0) in cell J2 which fills
in J2 with the value corresponding to the number in E2 which is looked
up from a table in sheet2.
My problem is that when I copy this formula down column J the E2 changes
to E3 which is correct, but the table defined by
On 21/07/17 11:32, Budge wrote:
I am using a formula to fill in a cell. The formula is in cell J2
=VLOOKUP(E2,Sheet2.A2:B690,2,0).
This is looks up the value from E2 in the column 1 of the table on sheet
2 defined by corners A2:B690, takes the corresponding value from column
2 of the table
I am using a formula to fill in a cell. The formula is in cell J2
=VLOOKUP(E2,Sheet2.A2:B690,2,0).
This is looks up the value from E2 in the column 1 of the table on sheet
2 defined by corners A2:B690, takes the corresponding value from column
2 of the table and enters it into cell J2.
I
OS/2 Warp 4 system and Lotus
SmartSuite.
Many thanks once more.
Budge.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
Hi Brian,
On 01/02/17 16:55, Brian Barker wrote:
At 16:13 01/02/2017 +, Budge Noname wrote:
Struggling here with VLOOKUP which I think is the right tool. I have a
column of numbers on one sheet (sheet 1) ...
Let's say they are in column A.
... and on another sheet (sheet 2) a column
confirm my approach and or advise how to proceed.
Budge
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http
Struggling here with VLOOKUP which I think is the right tool.
I have a column of numbers on one sheet (sheet 1) and on another sheet
(sheet 2) a column of numbers with an associated name in adjacent cell.
My objective is to find the name associated with the number on sheet 2
and enter it in
Struggling here with VLOOKUP which I think is the right tool.
I have a column of numbers on one sheet (sheet 1) and on another sheet
(sheet 2) a column of numbers with an associated name in adjacent cell.
My objective is to find the name associated with the number on sheet 2
and enter it in
Struggling here with VLOOKUP which I think is the right tool.
I have a column of numbers on one sheet (sheet 1) and on another sheet
(sheet 2) a column of numbers with an associated name in adjacent cell.
My objective is to find the name associated with the number on sheet 2
and enter it in
Hi Brian
On 30/01/17 15:25, Brian Barker wrote:
At 13:21 30/01/2017 +, Budge Noname wrote:
I am trying to hide some columns when printing. If I use the format
cells > cell protection > hide when printing the contents of the cells
are hidden and the sheet width is reduced as ex
white space and many sheets!
I would like to use the filter method, assuming this will solve my
problem but when I tried on one column everything disappeared.
I have tried to follow the help instructions but cannot get it right.
Please could somebody give a real beginner a hand.
paper size in the printer settings.
Fortunately not had this problem but many thanks for the tip.
Many thanks again for your reply.
Regards,
Budge
Kind regards
Regina
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/ma
50 matches
Mail list logo