Are you sure that this isn't anything more than that the column width has
reduced? Try increasing the column width on one of the columns that is showing
the problem.
Alan.
Original message
From: Nellyfanjita Computer
Date:21/01/2017 19:29 (GMT+00:00)
To: users@openoffi
Something seems to have changed in recent times. I can no longer click on a
cell and simply drag the contents to a new cell. If I play around long enough I
can sometimes make it work. It has become quicker to cut and paste. Please can
someone tell me the correct procedure?
Thanks,
Alan.
Thanks to all for your help. Now I understand. I don't know why it can't be as
easy as Excel.
Alan.
If you don't want to change your settings you can delete the highlighted area
which is offered and continue typing your new text. I think you can do this
with the right arrow key or maybe the delete key, I can't check as I am not
able to get acess into AOO at the moment.
Alan.
Alan N Pearce
T
Might be best to save it as a PDF first and then attach it to an email. If you
don't know how to do it then please feel free to ask me.
Alan.
Alan N Pearce
Tel: 01275 856887
Mob: 07761 255688
Sent from Samsung tablet
Original message
From: Johnny Rosenberg
Date:10/02/2017
Right click on the file and choose "Open With" then choose Open Office or
whatever is your choice. When saving choose save as and select the file type.
Alan.
Original message
From: Darnley Howard
Date:15/02/2017 04:39 (GMT+00:00)
To: users@openoffice.apache.org
Subject: D
STOP THIS NONSENCE
Alan.
Alan N Pearce
Tel: 01275 856887
Mob: 07761 255688
Sent from Samsung tablet
Original message
From: M Henri Day
Date:26/02/2017 19:19 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Re: Installing OO.o
2017-02-26 20:16 GMT+
I would like to multiply Hours and Minutes by a number of GB pounds. Is this
possible and if so how please?
Alan.
Sent from Samsung tablet
Thanks to all who replied to my request. I am sure that I will be able to sort
out a method now.
Regards,
Alan.
Sent from Samsung tablet
Original message
From: Alan Pearce
Date:18/03/2017 12:51 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Multiplying Time by
B1 → type 40 → format as currency
C1 → type =A1*24*B1 → formatting as currency will happen automatically.
Result: £60.
Simple as that…
Kind regards
Johnny Rosenberg
2017-03-19 11:37 GMT+01:00 Alan Pearce :
Thanks to all who replied to my request. I am sure that I will be able to
sort o
Sue,Bit of a long shot but at first glance it looks as if the cell height is wrong. try hilighting all the rows affected and right click on the number column on the left, I have forgotten what we call it, and select optimum row heightAlan. Original message From: Sue Johnston Date:2
Hi Bill,
I had a similar problem with CSV i.e. with the apostrophie turning the numbers
to text. I simply downloaded the file again and it came in correctly without
the apostrophie and the numbers behaved as numbers, not text. I had never had
this pronlem before and I don't know what, if anythin
Compose your email in your mail client and select "attach", this should offer
you the File Manager dialogue box, select whatever it is you wish to attach and
away you go.
Alan.
Alan N Pearce
Sent from Samsung tablet
Original message
From: PG
Date:23/08/2017 20:30 (GMT+0
Absolutely! I use it on Win 10 successfully.
Alan.
Sent from Samsung tablet
Original message
From: smit...@tpg.com.au
Date: 18/09/2017 10:35 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Value
Hello
Is the Apache Open Office really free?
If things look to
I don't know MAC but the answer lies in the message. Go to something like
settings or tools and change your preferences to allow third party apps,
Remember to change this back after the download.
Alan.
Sent from Samsung tablet
Original message
From: Daniel Quintana
Date
Why don't you use a pdf converter such as PDF995 it's free if you put up with
thr adverts.
Alan.
Sent from Samsung tablet
Original message
From: Martin Groenescheij
Date: 11/11/2017 01:00 (GMT+00:00)
To: users@openoffice.apache.org
Cc: melodyp...@aol.com
Subject: Re
e of the message is, it definitely not comes from OpenOffice.
Oh, it surely does! (And the rest of us know what the cause is.)
Brian Barker
Oh. Do we? How about letting us all in on the secret then☺
Alan Pearce.
-
To unsubscribe, e-
+0000, Alan Pearce wrote:
>From: Brian Barker
>Date: 13/11/2017 23:29 (GMT+00:00)
>>At 09:35 14/11/2017 +1100, Martin Groenescheij wrote:
>>>At 20:20 13/11/2017 +, David G.Macmillan wrote:
>>>>NOW on selecting the required document a box appears "OpenOf
Here, here!
Original message
From: Tony Clifford
Date: 08/12/2017 21:27 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Re: Your Program
I am here happily using OpenOffice because MS Office does not recognize its own
license. My thanks to those who write this soft
Why don't you say what you really mean?
Original message
From: Oralene Smith
Date: 09/12/2017 05:25 (GMT+00:00)
To: users@openoffice.apache.org
Subject: [AOO-Templates]
I hope I didn’t pay for this program, because it is the worse program I have
ever tried to used. If y
Try reinstalling the printer driver.
Alan.
Original message
From: Firsts
Date: 23/01/2018 15:57 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Not printing after latest Win 10 update (KB4056892)
Cannot print from Open Office after latest Window 10 update. Have reins
Check that it hasn't opened in "read only" mode.
Alan.
Original message
From: Louis Cipriano
Date: 06/02/2018 12:24 (GMT+00:00)
To: users@openoffice.apache.org, mar...@groenescheij.com
Subject: Re: sort data
Ok I’ve opened the workbook. selected the sheet. Hightighted t
You mentioned that it happened when you came to save your work.,could it be
that you were being offered some form of cloud storage which maybe chargeable?
Original message
From: Catalan Bird Tours
Date: 12/06/2018 17:30 (GMT+00:00)
To: users@openoffice.apache.org
Subject:
When this occasionally hapens to me I have found closing the document and
reopening solves the ptoblem.
Original message
From: David Robley
Date: 18/06/2018 23:35 (GMT+00:00)
To: users@openoffice.apache.org, Tom
Subject: Re: read-only documents
A google search for "user
But, if it's "read only", you can't have made any changes Martin
Alan
Original message
From: Martin Groenescheij
Date: 19/06/2018 10:55 (GMT+00:00)
To: users@openoffice.apache.org
Cc: tom9...@earthlink.net
Subject: Re: read-only documents
On 1
I use pdf995. It is free and works a treat.
Original message
From: William Hopkins
Date: 20/07/2018 12:58 (GMT+00:00)
To: users@openoffice.apache.org
Subject: PDF cpnverter
Hi, I wanted to download a PDF converter to go with Open Office but when I
searched and came up
:00)
To: users@openoffice.apache.org
Subject: Re: PDF cpnverter
What can you say about „pdf995“?
I downloaded it to my Mac, yet cannot open it, The sstem says: no program for
opening.
Any idea, what to do?
Many thanks,
Andras
> On 2018. Jul 20., at 20:48, Alan Pearce
> wrote:
>
It may be that the column width has narrowed and is not wide enough. Try
widening one and see what happens.
Original message
From: Alane Blachford Pena
Date: 29/07/2018 23:17 (GMT+00:00)
To: users@openoffice.apache.org
Subject: scrambled files
I have been making a sprea
Right click on the document in File Manager and choose Open With. You will then
be given a choice of which programme to use to open the document.
Hope this helps,Alan.
Original message
From: Vanessa Harvie
Date: 12/09/2018 12:23 (GMT+00:00)
To: users@openoffice.apache.org
Hi all,
Dors anyone know how to paste text into a Text Box inserted into a spread sheet
please? The paste option doesn't seem to exist.
Thanks,Alan.
Re-posting in case the last one didn't get through!
Original message
From: Alan Pearce
Date: 06/01/2019 14:12 (GMT+00:00)
To: Apache Open Office
Subject: Pasting into a Text Box
Hi all,
Does anyone know how to paste text into a Text Box inserted into a spread
Thank you Brian,
It does exactly what you describe. Solved my problem.
Regards,Alan.
Original message
From: Brian Barker
Date: 07/01/2019 08:30 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Re: Pasting into a Text Box
At 14:12 06/01/2019 +, Alan Pearce wrote
It sounds as if you have the print setup wrong. Try highlighting what you want
to print then going to Format/print/define print range.
Regards,Alan.
Original message
From: Pat
Date: 18/01/2019 01:24 (GMT+00:00)
To: users@openoffice.apache.org
Subject: print problem
Hi I
File / print / select which pages. Hope this helps.
Alan.
Original message
From: Edward Eckhard
Date: 19/01/2019 19:17 (GMT+00:00)
To: users
Subject: Need to print ONLY selected pages
Help! Need some advise.
I often print out narrative files I create and have no trou
Hi Lee,
Has it opened as "Read only"? If so go to file/save as and give it another
name. Reopen and it will probably work ok.
Cheers,Alan.
Original message
From: Lee Garrett
Date: 22/01/2019 18:26 (GMT+00:00)
To: users@openoffice.apache.org
Subject: OpenProj
Hello,
I u
Does anyone know if there is a version of AOO for android tablet devices please.
Thanjs,Alan.
hrieb Andrea:
> Am 27.01.2019 um 19:17 schrieb Alan Pearce:
>> Does anyone know if there is a version of AOO for android tablet
>> devices please.
>> Thanjs,Alan.
>>
>
> Try this version ...
>
> https://andropen-office.de.uptodown.com/android
It is also av
Right click in cell and providing there is a comment in the cell you will be
offered "Show Comments"
Alan.
Original message
From: "WA.TWORSX via AOL"
Date: 18/02/2019 16:36 (GMT+00:00)
To: AOO Mail List
Subject: Show All Comments
Hi Group:AOO Calc on Windows 10-64b
/_all comments_/ that exist for
a sheet can be toggled on / off ?On 2/18/2019 11:54 AM, Alan Pearce wrote:>
Right click in cell and providing there is a comment in the cell you will be
offered "Show Comments"> > Alan.>> Original message >
From: &q
Go to "Format Page" and reset your margins.
Alan
Original message
From: Valli Horner
Date: 08/03/2019 23:26 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Printing a Spreadsheet in Open Office Calc
Hello,I can’t seem to get the printer to use the entire page wh
Try clicking on "FORMAT/PAGE"
Original message
From: Samantha W
Date: 17/03/2019 00:26 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Writer View Help
I am e-mailing as I have no desire to register to get a question answered.I
have just replaces an old square
Does anyone know a custom format for Weight i.e. Stones and pounds for
spreadsheet cells?
Original message From: Alan Pearce
Date: 26/03/2019 09:48 (GMT+00:00) To:
Apache Open Office Subject: Format Cells Hi,Does
anyone know a custom format for Weight i.e. Stones and pounds for spreadsheet
cells? It doesn't appear in the list of standard formats.T
I think you are asking for is the "Wrap" function so that what you are typing
is wrapped to the next line within a cell either when you reach the limit of
the cell size or you press carriage return. I am not able to access OO at this
moment but think you will find it somewhere in "Format/Cells"
ak inside acell.On
15.04.2019 08:00, Alan Pearce wrote:> I think you are asking for is the "Wrap"
function so that what you are typing is wrapped to the next line within a cell
either when you reach the limit of the cell size or you press carriage return.
I am not able to access OO at
As an aside you should never use an office file to pass on crucial
information because it can be changed, unless you passward protect it and I'm
not absolutley sure you can do this when sending a file. It should be allowed
to send as PDF and even then it can be changed.
O
Open the document and then go to "file /save as" and give ot a new name.
Also it some times, mostly, works if you close and re-open the document.Good
luck,Alan.
Original message
From: Artis Tiedemann
Date: 13/07/2019 20:33 (GMT+00:00)
To: users@openoffice.
Help please!
I am in Open Office Calc and a dialogue box has kept appearing saying "The
document you are about to export has one or more protected items with password
that cannot be exported. Please retype your password to be able to export your
document" I AM NOT TRYING TO EXPORT MY DOCUME
t you.> On Oct 21,
2019, at 4:33 AM, Alan Pearce wrote:> >
Help please!> > I am in Open Office Calc and a dialogue box has kept appearing
saying "The document you are about to export has one or more protected items
with password that cannot be exported. Please retype your
(GMT+00:00)
To: users@openoffice.apache.org
Subject: Re: Unwanted Dialogue Box
At 10:33 21/10/2019 +0100, Alan Pearce wrote:>I am in Open Office Calc and a
dialogue box has kept appearing >saying "The document you are about to export
has one or more >protected items with password
I have not tried this but if you highlight the tabs of all three sheets by
clicking on each whilst holding the control key down then ensure that the print
dialogue box is checked to print only current sheets, does this work?
Alan
Original message
From: Maurice Howe
Date:
Hi Sam,
When this happens I either close and re-open or if this doesn't work use "
file/save as" and give it a slightly different name. WAlanhen I am happy that
all is well I delete the old file and "rename" the new one with the original
name, if need be.
Original message
I can't answer your question but from information I have gleaned from another
group, working on thumb drives/usb sticks isn't a good idea as apparently they
don't like long term multiple access. So download to your pc and carry out your
work then upload to store seems to be the answer. But I am
No, I can't get on with mail merge either. Why does it have to be so
complicated?
Original message
From: Jacquetta Ellinger
Date: 14/12/2019 22:22 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Labels
I’m not a programmer/developer but I’m pretty competent
Rant it might be but I certainly agree.
Original message
From: Wade Smart
Date: 14/12/2019 23:07 (GMT+00:00)
To: users@openoffice.apache.org, Jacquetta Ellinger
Subject: Re: Labels
Ok.Nice rant.-- Registered Linux User: #480675Registered Linux Machine:
#408606L
Andrea, What do you mean please?
Alan.
Original message
From: Andrea
Date: 01/01/2020 19:42 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Re: Update failures
A possible way is just to downlaod the most actual version and to install itAm
01.01.2020 um 19:46 sc
at I wrote when I answered Peters question :-)If update don't
work, just download the most actual version and install itAm 02.01.2020 um
00:37 schrieb Alan Pearce:> Andrea, What do you mean please?>> Alan.>>
Original message > From: Andrea > Date: 0
.apache.org
Cc: alannpea...@talktalk.net
Subject: Re: Update failures
On Thu, 2 Jan 2020 09:01:41 +0100Martin Groenescheij
wrote:> Op 2 jan. 2020 om 08:43 heeft Alan Pearce
het volgende geschreven:> > > > Sorry
Andrea but that doesn't answer my question. What do you m
Thank you for that clarification Brian. I have often wondered about what
happens with autosave and suspected that it was non permanent but wasn't
sure.Alan Pearce
Original message
From: Brian Barker
Date: 16/07/2020 03:25 (GMT+00:00)
To: users@openoffice.apache.o
Follow Martin Groeneschij's instructions. I.E. Format/Print Set Up.
Original message
From: Felmon Davis
Date: 22/09/2020 23:16 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Re: ODP: Apache open office 4.1.7
On Tue, 22 Sep 2020, Rory O'Farrell wrote:> On Tue, 22 Se
Go to your file manager, right click on the file you want to open and select
"open office". That file will then always open in your chosen system.
Alan.
Original message
From: Art Pederson
Date: 28/10/2020 03:15 (GMT+00:00)
To: Apache Open Office
Subject: Makin
ecause the file originated from friends "Read" link, I could not identifythe
file type.On Wed, 28 Oct 2020 at 01:16, Alan Pearce
wrote:> Go to your file manager, right click
on the file you want to open and> select "open office". That file will then
always
But it will change every time you open the spreadsheet which isn't what I
thought you wanted. It is probably something that can be achieved but others
more knowledgable than me will know.
Alan
Original message
From: Joost Andrae
Date: 12/11/2020 11:37 (GMT+00:00)
To:
Right click the file you want to open and select open with. Working from
memory , it may be open as.
Alan
Original message
From: Jennie Bickerton
Date: 12/01/2021 21:59 (GMT+00:00)
To: users@openoffice.apache.org
Subject: New Computer - Microsoft has changed my docum
I stopped using MS office years ago and have never regretted it. AOO works
well for me.
Original message
From: R2
Date: 06/03/2021 18:50 (GMT+00:00)
To: users@openoffice.apache.org
Subject: I don't trust Microsoft. Can Apache be trusted?
Afternoon!I am an extreme
What a lovely response Theresa. Thank you!
Alan.
Original message
From: Theresa Greenhill
Date: 09/07/2021 17:53 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Re: Error message when opening up a document - problem now sorted !!
Dear Open Office staff,I am sor
Copy and Paste within file manager. Or, open from the drive and "Save
As" selecting where you want to save it when asked. Alan.
Original message
From: Edward Eckhard
Date: 23/09/2021 23:49 (GMT+00:00)
To: users
Subject: Restore lost OO file
I accidentall
Also you can raise your email in the usual way and click click on "Attach" or
"Attach File" or something similar dependant upon your email client. This
should take you to the File Manager.
Original message
From: David Belina
Date: 27/09/2021 17:03 (GMT+00:00)
To: Madelei
Download an email app. I use Thunderbird but there are many available.
Original message
From: Madeleine Shore
Date: 27/09/2021 17:19 (GMT+00:00)
To: David Belina , users@openoffice.apache.org
Subject: Re: Sending an e mail from documents
Thanks for the prompt reply.
Are you sure that you didn't back it up?
Original message
From: Jackie Olsen
Date: 14/10/2021 17:50 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Re: How to recover a accidently deleted manuscript
Robin,Yes, that was the first place I looked. Then I purchased one o
Sometimes this happens to me when opening a file. My answer has always been to
close and reopen it. The other method people suggest, which I think is more
effort, is to "Save As: and give it a different name. Don't forget to back up
your work.Alan.
Original message
From: Jerri
Hi Larry,Just an idea, have you scrolled the page to be certain there is
nothing on it?
Original message
From: Larry Hester
Date: 15/11/2021 12:53 (GMT+00:00)
To: users@openoffice.apache.org
Subject: greetings
Good day,I have a spreadsheet that will not open, and seems
Select the file you wish to open in the "File Management" system and right
click on it, then click on "Open With".
Original message
From: pat hanford
Date: 17/11/2021 19:30 (GMT+00:00)
To: users@openoffice.apache.org
Subject: ms word interference
I am unable to view my
Go to your file management system and find the file you want to open. Then
right Click on it andselect "open with". It should offer you various
alternatives, select open office. When you have it open select File/Save as /
then the choice is yours.Hope this helps.Alan.
Original message
Highlight the cell or cells affected and go to Format/Cells/Borders and
select your choice of borders.
Original message
From: s church
Date: 10/05/2022 16:08 (GMT+00:00)
To: users@openoffice.apache.org
Subject: open office problem
Greetings,My OO spreadsheet is adding
I sometimes find that a file opens as "Read Only" by closing it and
re-opening it reverts back to normal.Hope this helps,Alan.
Original message
From: colh...@bresnan.net
Date: 18/10/2022 04:36 (GMT+00:00)
To: "'users@openoffice.apache.org'"
Subject: Help!
I have so
That isn't correct James. The grid lines can be printed by ticking the
right box in Page Set Up. I can't give you the full procedure as at the moment
as I haven't time to run through it. But if someone else doesn't come up with
the answer I'll do it later.Alan.
Original message --
Apache Open Office is FREE software. You are being scammed if asked to pay for
it.
Original message
From: Vivian King
Date: 04/01/2023 23:44 (GMT+00:00)
To: users@openoffice.apache.org
Subject: Downloading
Gentlemen/Ladies, I downloaded OpenOffice and began filling out
I use labels when I need a printed address on an envelope. It's easier to put
a A4 sheet of labels on top of the A4 tray of paper.than messig around
fitting an envelope in the printer..
Original message
From: Andrew Pitonyak
Date: 07/03/2023 23:31 (GMT+00:00)
To: us
Can anyone point me in the right direction please.I need to find the template
for labels. I used it many times years ago but can''t find it now.
Regards,Alan.
Thank you for your reply to my query. I am subscribed to the list but not
under this email address. How it has ended up here I don't know!
Original message
From: David Robley
Date: 13/03/2023 09:38 (GMT+00:00)
To: users@openoffice.apache.org
Cc: Alan P
81 matches
Mail list logo
