Re: Label Template

[Alan Pearce]

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 Pearce  
Subject: Re: Label Template 

Do you mean File | New | Labels from whence you can select the label format you 
want?Since you are not subscribed to this list you may not see all the replies 
to your query. To subscribe to Apache OpenOffice mailing lists go to 
http://openoffice.apache.org/mailing-lists.htmlAs a courtesy I have forwarded a 
copy of this reply to you as well as to the mailing list. Do Not reply to me 
personally but just to the list at  - replies to 
my personal email address will be ignored.On 12/03/2023 09:25, Alan Pearce 
wrote:> 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.

Label Template

[Alan Pearce]

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.

Re: Fwd: Printing on an envelope

[Alan Pearce]

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: users@openoffice.apache.org 
Cc: Paul Wysocki  
Subject: Re: Fwd: Printing on an envelope 

I rarely print envelopes, but on my printer, I usually just print landscape and 
manually feed an envelope. I do use the mechanism to feed an envelope. The 
problem with that, however, is that some feed the envelope in the middle and 
some on the right or left side. So I expect this to take some experimentation. 
What I did, was to feed a regular sheet of paper and then I checked to see 
where it printed with respect to the envelope so that I could refine margins 
(and similar). So now I can print individual envelopes when I want to. I just 
pull up my "template" and off I go.Not much help perhaps, but it is how I 
solved it for my infrequent use.On Tuesday, March 07, 2023 17:39 EST, Shari 
Lynn Smith  wrote: Hi Paul,Please join the OpenOffice 
mailing list so you can /*reply directly*/,and see all the 
responses:https://openoffice.apache.org/mailing-lists.html#users-mailing-list-publicCan
 you let us know what you are trying to do exactly? Does you printerallow you 
to print directly on to the envelope? Have you print directlyto an envelope 
with another program?If you printer will print to an envelope directly, you 
should just needto change the paper size in OpenOffice. Some printers are able 
to printon envelopes some are not.Shari> From: Paul 
Wysocki> Date: Tue, Mar 7, 2023 at 2:14 PM> 
Subject:printing envelope assistance> To:>>> 
Hello!>> Through a Computer Store in Richland Center, WI, Open Office was 
downloaded> on my computer.>> I am having great difficulty with trying to print 
an envelope. Please help!>> Thanks,> Paul Wysocki> 

Re: Downloading

[Alan Pearce]

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 the required 
forms in which my credit card number was requested.  Within a few minutes of 
supplying that number  I was confronted with some “Lazy Games” site immediately 
followed by a message from Capital One asking if I had just placed an order for 
$45.  I had not; consequently they held up the payment, suspended my card while 
they search out the fraud.  Unfortunately, that meant that you were unable to 
accept my card which means that until I receive a replacement I cannot join 
OpenOffice!  I will try again when the new card is received.Unhappily,Vivian 
King-To 
unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Cell grid lines not printing

[Alan Pearce]

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 
From: Joost Andrae  
Date: 05/12/2022  14:51  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Re: Cell grid lines not printing 

Hi James,the cell grid lines won't print. You have to add cell borders (menu 
item /Format/Cells.../ tabpage Borders; within the format bar there's also an 
entry called Borders)Kind regards, JoostAm 05.12.2022 um 15:25 schrieb Jim 
Munroe:> When I create a new spreadsheet showing the cell grid lines, when I 
print it the grid lines are not showing – how do I make them print?> > James 
Munroe> 1 Badgers Corner> East Goscote> LEICESTER> LE7 3WS  email: 
jim.mun...@btinternet.com> > > > Sent from Mail for Windows> > 
-To 
unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Help!!!!!

[Alan Pearce]

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 somehow set my spreadsheet to READ ONLY and cannot figure outhow to 
reset it so that I can update it. I have gone toFILE/PROPERTIES and have Record 
Changes checked but it is grayed out.Help!Thanks in advance for any 
help you can provide.Phil

Re: open office problem

[Alan Pearce]

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 random borders to cells and I can't seem 
to remove them.Help?ThanksSam386-847-8082

Re: Help in downloading

[Alan Pearce]

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 
From: angela martin  
Date: 06/12/2021  19:13  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Help in downloading 

Hi there. I do not have too much experience in downloading software. I have a 
dell Intell Core 15 laptop windows 10? And I am trying to access my word files 
but Microsoft Office is stopping me from doing so. I have had no trouble in 
accessing for 3 years or so and now I cannot view my documents. Can you please 
help me download openoffice? Thank you. Angela MartinSent from Mail for Windows

Re: ms word interference

[Alan Pearce]

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 work on openoffice. Everything opens to ms word, even 
the stuff I wrote years ago before I downloaded word.Thanks,Patrick

Re: greetings

[Alan Pearce]

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 frozen. The page 
opens, but no information on 
it.Regards,Larry-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Read only

[Alan Pearce]

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 Runquist  
Date: 26/10/2021  18:19  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Read only 

I have a 42 page report that will not print. Says it's in the read onlyformat 
and I cannot change it!  PLease help!!!  Hours and hours spent onthis and I can 
print it. It doesnt even show up when I do try to print it.Help!!!

Re: How to recover a accidently deleted manuscript

[Alan Pearce]

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 of 
theprograms Rory recommended, but, regretfully, it was not recovered. Theactual 
manuscript was recovered, but it was in all garbled words, so Iwasted $70 for 
nothing.  I don't have a choice but to start over again!Thanks for your 
help.Jackie OlsenOn Thu, Oct 14, 2021 at 7:37 AM Robin Lord 
 wrote:> Have you looked in the recycle bin>> On Thu, 14 
Oct 2021, at 03:00, Alan Cliffe wrote:> > I can't tell you how to retrieve it, 
but for future reference you might> > want to make PDFs of every OO document 
you make.> > On Wednesday, October 13, 2021, 03:20:36 AM EDT, Jackie Olsen> 
>  wrote:> >> >  Hello,> >> > I accidentally deleted a 
100-page manuscript and was hoping someone could> > help me retrieve it? I've 
searched everywhere and can't find it. I don't> > know enough about coding to 
be able to search in a deeper manner.> >> > Thanks in advance for your help!> 
>> > Sincerely,> > Jacqueline D Olsen>> --> Best Regards>> Robin>> 
-> To 
unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org> For additional 
commands, e-mail: users-h...@openoffice.apache.org>>>

Re: Sending an e mail from documents

[Alan Pearce]

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.I tried doing that on my windows 10. I get the 
response:i need to install an e mail programme or control an association in a 
default programme !How do I install an e mail programme please?CheersJulianGet 
Outlook for 
AndroidFrom: David 
Belina Sent: Monday, September 27, 2021 5:03:59 PMTo: 
Madeleine Shore ; users@openoffice.apache.org 
Subject: Re: Sending an e mail from documentsIf 
you are using Apache Open Office, under the file tab is a selection in the 
drop-down list for “Send” and clicking on that opens up a list with several 
option. Clicking from there will eventually open up you email application 
(Safari on a Mac) and you choose who you wish to send it to.Other programs 
usually have such and option under the File menu.Good Luck.DaveOn September 27, 
2021 at 9:53:03 AM, Madeleine Shore 
(mshor...@hotmail.com) wrote:Hi,I don't know 
whether I'm on the correct site but, as a novice to computer technology, I 
wonder if someone could point me in the right direction.I wish to send a 
document via email and I'm unsure how to do this.Any help would be most 
appreciated.CheersJulian Shore

Re: Sending an e mail from documents

[Alan Pearce]

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: Madeleine Shore , users@openoffice.apache.org 
Subject: Re: Sending an e mail from documents 

If you are using Apache Open Office, under the file tab is a selection in the 
drop-down list for “Send” and clicking on that opens up a list with several 
option. Clicking from there will eventually open up you email application 
(Safari on a Mac) and you choose who you wish to send it to.Other programs 
usually have such and option under the File menu.Good Luck.DaveOn September 27, 
2021 at 9:53:03 AM, Madeleine Shore (mshor...@hotmail.com) wrote:Hi,  I don't 
know whether I'm on the correct site but, as a novice to computer technology, I 
wonder if someone could point me in the right direction.  I wish to send a 
document via email and I'm unsure how to do this.  Any help would be most 
appreciated.  Cheers  Julian Shore  

Re: Restore lost OO file

[Alan Pearce]

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 accidentally deleted a narrative file, created in OO and backed up to my 
flashdrive. Is there a way to copy that file from my flashdrive back into my 
documents file so I can modify it using OO?? Thanks. Edward 

Re: Error message when opening up a document - problem now sorted !!

[Alan Pearce]

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 sorry if I was rude.  I needed help and didn't know 
I was in the discussion section for users.  People were asking me questions and 
I have no idea with technical stuff..  So I am very sorry for my confusion and 
my reaction at that time, I was so frustrated with the problem I had.On the 
good side, I have found the right instructions after much searching and am very 
happy everything is working well now.  OpenOffice and the replacement driver 
for my printer is fully sorted now, so my little fuji xerox printer is back in 
action, it has a small footprint and it is quite old now, but gives great 
results (very clear laser print).Again, apologies for my confusion and 
rudeness.  It might be an idea to have a screen advising people it is a forum 
for users, not actual tech help.SincerelyTheresa 
GreenhillFrom: Hagar Delest 
Sent: Monday, 5 July 2021 2:18 AMTo: 
users@openoffice.apache.org Subject: Re: Error 
message when opening up a documentLe 04/07/2021 à 16:49, Robin Lord a écrit :> 
Please do not be so rude, people are trying to help youShe doesn't know how a 
mailing list works.In case she still has this 
one:https://openoffice.apache.org/mailing-lists.htmlHagar-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: I don't trust Microsoft. Can Apache be trusted?

[Alan Pearce]

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 extremely upset and frustrated customer of Microsoft Office 
2019 Professional and their deceptive practices. I purchased a laptop in 
January from HP and along with it purchased MS Office 2019 Pro. Attempting the 
activate the package it continued to prompt me to put the computer on-line and 
log into/create a Microsoft.com account. No one informed me during the sale 
that I needed a Microsoft.com account. I contacted HP and was informed that in 
order to use Office 2019 Pro, a Microsoft.com account is mandatory! I read the 
Microsoft terms fine print and they get to collect ALL information, store it on 
their cloud, and as such, THEY own it. All in the name of an "enhanced user 
experience". For this reason, I do not want, need, desire,or trust, Microsoft 
or their Microsoft.com account. Does Apache Open Office require an online 
account? Are users able to use the product off-line? Store their files locally? 
If so, I'll give it a shot as I am done with Microsoft and all this privacy 
invasion. I will also send a donation annually to support you as long as you 
maintain the ability of user privacy, Please advise.All The Very 
Best!R2Randolph 
twogood303.907.5900r...@rmi.net-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: New Computer - Microsoft has changed my documents to Word

[Alan Pearce]

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 documents to Word 

Hi and HelpI have a new computer, have downloaded Apache Open Office, and have 
copied documents that are Open Office ODT onto my new computer via a Flash 
Drive. Now all of my files appear to be Word documents and when I attempt to 
open a document, the Microsoft popup wants to prompt me to purchase their 
software which I do not want.  I get a message that I have to delete the S app 
and afterwards can never add it again.I have tried to change/open via AOF but 
that doesn't work.  Do I have to purchase the AOF app and if I do purchase, 
will Microsoft then allow me to change the documents into OF?  Any help will be 
appreciated!!  

Re: Default Value field in a table formatted to Date

[Alan Pearce]

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: users@openoffice.apache.org 
Subject: Re: Default Value field in a table formatted to Date 

Hi,I'm not quite sure what you like to accomplish.Within Calc you can use the 
formula TODAY()So if you enter =today() into a cell you'll get the current 
date.If you save this within a spreadsheet document and if you load that 
document then this cell will show you the current date.Kind regards, JoostAm 
12.11.2020 um 09:04 schrieb DAB DAB:> Hi, I am new to openoffice and have used 
MS Access in the past. I have created a table called Customers and have 3 
fields CustomerID, Name and Date. The date field type is date. When I open the 
table I want the Date field to default to today’s date so I don’t have to keep 
inputting a date.> > What is the best way to do this in openoffice?> > Sent 
from Mail for Windows 10> > 
-To 
unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Making Apache Open Office my default program

[Alan Pearce]

Sorry Art I can't I can't offer further  help on this. Maybe another forum 
member will be able to.Alan.

 Original message 
From: Art Pederson  
Date: 29/10/2020  03:20  (GMT+00:00) 
To: Apache Open Office  
Subject: Re: Making Apache Open Office my default program 

Because 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 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: 
Making Apache Open Office my default program>> Something changed on my 
laptop(Windows 10) and it now tries to use> Outlook365 (not on my computer) 
instead of Apache Open Office to open> files.  Howdo I make Apache Open Office 
my default program again?> Thanks.-- God Bless!Art PedersonPrince Albert, 
Saskatchewan,> Canada*Email: ve5...@sasktel.net, 
ve5aap> @gmail.comhttp://www.victoryfm.ca-- God Bless!Art PedersonPrince 
Albert, Saskatchewan, Canada*Email: 
ve5...@sasktel.net, ve5aap@gmail.comhttp://www.victoryfm.ca

Re: Making Apache Open Office my default program

[Alan Pearce]

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: Making Apache Open Office my default program 

Something changed on my laptop(Windows 10) and it now tries to use Outlook365 
(not on my computer) instead of Apache Open Office to open files.  Howdo I make 
Apache Open Office my default program again?  Thanks.-- God Bless!Art 
PedersonPrince Albert, Saskatchewan, Canada*Email: 
ve5...@sasktel.net, ve5aap@gmail.comhttp://www.victoryfm.ca

Re: ODP: Apache open office 4.1.7

[Alan Pearce]

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 Sep 2020 03:11:54 +0200 
(CEST)> Felmon Davis  wrote:>>> On Tue, 22 Sep 2020, 
000340019D24E92F Microsoft wrote:> Do you really checked out Everything on 
your machine (System’s>>> device drivers) and the peripheral device (Printer: 
e.g. the status>>> of ink in the printer or the condition of the laser head 
(depending>>> on the type))? also page size: my US printer refuses A4; my 
EU printer refuses>> Letter. fjd>> There are two settings to be considered: 
setting the Page size in > OpenOffice (/Format /Page), but also a setting for 
the Printer.  In > OpenOffice /File /Print there is a Properties button (on a 
Mac, one > may need to have selected to use OpenOffice Printer dialogs). > 
Selecting the Properties button on the /File /Print window allows > one to 
select the Paper size the printer will use.  This is the size > of the sheet of 
paper the printer will expect in its paper tray, and > on which it will attempt 
to print the Page size selected in > OpenOffice.yeah but this hasn't worked on 
my printers. probably must do a deeper dive.the EU printer is an HP MFP 
M281fdw, the US printer is not at hand right now but is a Brother model, both 
laser.nothing I need to fix.hoping the OP gets their solution.fjd> I have five 
printers available on my house network, and every one > will accept both A4 and 
Letter when this Properties setting is > adjusted.>>> Od: Carol Russell>>> 
Wysłano: Tuesday, September 22, 2020 1:27 AM>>> Do: 
users@openoffice.apache.org>>> Temat: Apache open office 4.1.7>> open 
office will not print out information to my printer.  Printer will only>>> 
print out blank sheet. I have cheked out everything before e-mailing you.>>> 
Please respond, I use  this site on a daily bases.  Respectively Yours Carol>>> 
Russell>>> -->> Felmon Davis Verbum sat 
sapienti.>>>-- Felmon DavisVerbum sat 
sapienti.-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Saving documents (was: Perhaps UPSs should be used ...]

[Alan Pearce]

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.org 
Subject: Re: Saving documents (was: Perhaps UPSs should be used ...] 

At 16:56 14/07/2020 -0400, Dan Lewis wrote:>It is also important to save all 
documents on a regular basis.True.>Tools > Options > Load/Save > General has 
options that will you >should consider using. Just make sure to limit the 
number of minutes to 4 of 5.Useful though this facility is, it is important 
that readers are not misled by this suggestion. Like all sensible applications, 
OpenOffice saves document files only when the user asks for this to happen - 
using Save or Save As or by selecting Save from the options provided when a 
modified document is closed without having been saved. This is important, so 
that a user may choose, after a period of editing, to abandon all changes and 
close the document or session without modifying the original document.The 
option at Tools | Options... | Load/Save | General | Save | Save AutoRecovery 
information every ... Minutes has another purpose. If it is ticked, information 
about the current editing session is salted away regularly - but separately 
from the actual document file. This information is deleted automatically if a 
session is terminated normally. Its purpose is instead to deal with program or 
system crashes or power outages. In these circumstances an offer is made, when 
OpenOffice is next started, to recover editing changes made in the aborted 
session as far as possible.Brian Barker  
-To 
unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Update failures

[Alan Pearce]

Thank you to Rory and Martin for the explanation. I and no doubt many others 
didn't know that. I wasn't being diffucult, just wanted to know what was meant.



 Original message 
From: Rory O'Farrell  
Date: 02/01/2020  08:51  (GMT+00:00) 
To: users@openoffice.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 mean by "actual"? 
Actual as opposed to what?> > Alan, try to understand that the majority of the 
users live outside the US, hence there is a big change their mother tong is not 
English and they give answers to the best of their ability.A translation 
problem: in this case actual is equivalent to the "current" version.I agree 
with Martin; one needs to understand and allow for differences in native 
tongues.Rory> > > > > >  Original message > > From: Andrea 
 > > Date: 02/01/2020  06:50  (GMT+00:00) > > To: 
users@openoffice.apache.org > > Subject: Re: Update failures > > > > Exactly 
that what 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: 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 schrieb Russ Peters:> I've searched and searched the 
internet for answers and seem to get> lost somewhere!>> I have two computers 
running windows 10. I have open office> 4.1.7.installed. When I check for>> 
updates I get the following message  " error reading data from> internet, 
server error message".>> Is this a known problem of can you recommend a fix? 
Response for both> computers.>>> 
-> To 
unsubscribe, e-mail: users-unsubscrib e...@openoffice.apache.org> For 
additional commands, e-mail: 
users-h...@openoffice.apache.org>-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: 
users-h...@openoffice.apache.org-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org> > > 
-> To 
unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org> For additional 
commands, e-mail: users-h...@openoffice.apache.org> -- Rory O'Farrell 
-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Update failures

[Alan Pearce]

Sorry Andrea but that  doesn't answer my question. What do you mean by 
"actual"? Actual as opposed to what?



 Original message 
From: Andrea  
Date: 02/01/2020  06:50  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Re: Update failures 

Exactly that what 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: 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 schrieb Russ Peters:> I've searched and 
searched the internet for answers and seem to get> lost somewhere!>> I have two 
computers running windows 10. I have open office> 4.1.7.installed. When I check 
for>> updates I get the following message  " error reading data from> internet, 
server error message".>> Is this a known problem of can you recommend a fix? 
Response for both> computers.>>> 
-> To 
unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org> For additional 
commands, e-mail: 
users-h...@openoffice.apache.org>-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: 
users-h...@openoffice.apache.org-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Update failures

[Alan Pearce]

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 schrieb Russ Peters:> I've searched and searched the 
internet for answers and seem to get> lost somewhere!>> I have two computers 
running windows 10. I have open office> 4.1.7.installed. When I check for>> 
updates I get the following message  " error reading data from> internet, 
server error message".>> Is this a known problem of can you recommend a fix? 
Response for both> computers.>>> 
-> To 
unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org> For additional 
commands, e-mail: 
users-h...@openoffice.apache.org>-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Labels

[Alan Pearce]

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: 
#408606Linux since June 2005On Sat, Dec 14, 2019 at 5:05 PM Jacquetta 
Ellinger wrote:>> I’m not a 
programmer/developer but I’m pretty competent at using software, however, 
OpenOffice is too tough.  I like it generally, I like the concept of it, but 
every time I try to do something new, I spend hours first searching out 
instructions, then trying them, having them not work, trying again, having them 
not work - that is files crashing and virtually wasting my life away.  Today, I 
cannot get OO to create a database from a spreadsheet I’ve created so I can 
print a lousy 100 mailing labels.  I could have had half of them written by 
hand by now.  I’m going to have to buy Word and I hate that.> 
-> To 
unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org> For additional 
commands, e-mail: 
users-h...@openoffice.apache.org>-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Labels

[Alan Pearce]

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 at using software, 
however, OpenOffice is too tough.  I like it generally, I like the concept of 
it, but every time I try to do something new, I spend hours first searching out 
instructions, then trying them, having them not work, trying again, having them 
not work - that is files crashing and virtually wasting my life away.  Today, I 
cannot get OO to create a database from a spreadsheet I’ve created so I can 
print a lousy 100 mailing labels.  I could have had half of them written by 
hand by now.  I’m going to have to buy Word and I hate 
that.-To 
unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Database Wizard

[Alan Pearce]

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 expert.Cheers,Alan

 Original message 
From: James Wheeler  
Date: 21/11/2019  14:30  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Database Wizard 

I have recently purchased a new computer and installed OpenOffice. It’s asking 
me if I want to create a new database or use an existing?  I have a thumb drive 
full of documents that are in OpenOffice format and all that I want to do is 
plug in the thumb drive and continue working on the files that are already 
there. What is the simplest way to set this program up?Thanks,Jim   
-To 
unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Read Only files

[Alan Pearce]

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 
From: Sam Warren  
Date: 31/10/2019  01:13  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Read Only files 

After I downloaded the new version all my files are in Read Only. Ifollowed all 
the instructions and the Read Only box was not clicked. I am80 and not too tech 
savvy.-- *SAM WARREN**(619) 
635-8657*Virus-free.www.avast.com<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: Printing issue

[Alan Pearce]

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: 27/10/2019  23:20  (GMT+00:00) 
To: Girvin Herr  
Cc: Apache OpenOffice  
Subject: Re: Printing issue 

I've found that it is far simpler to PRINT ALL (and discard what'sunneeded) 
than to futz around with the nitty-gritty.  Yes, the N-G works,but it's often 
not worth the bother.  Paper is cheap.  Your time 
ain't.MauriceVirus-free.www.avast.com<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>On
 Sun, Oct 27, 2019 at 6:01 PM Girvin Herr  wrote:> Dave,>> 
In addition to these good replies, may I ask if you tried Ctrl-P and> selected 
"All sheets"? Calc seems to default to printing the "selected"> sheet, which is 
the one you are currently looking at. Using the "quick"> print icon on the 
toolbar will also default to the "selected" sheet and> not print the others. 
This is not controlled by the Print Ranges, except> that if a sheet is not in 
the print range, "All Sheets" will still not> print it. Calc likes to _not_ 
print stuff. Very frustrating at times.>> HTH.>> Girvin>>> On 10/27/19 12:00 
PM, Christel Lugo wrote:> > Hello,> >> > I am having a problem with 
Calc-specifically, it won’t print the pages I> need printed. I keep trying to 
print three specific pages and it will only> ever print one of them. The print 
preview only shows one of them, too.> >> > I have tried defining the print 
range via format and highlighting to no> avail. I have also tried simply 
selecting a page number range in the print> screen. I have tried deleting the 
print range under format, but nothing> works.> >> > Can you help?> >> > 
Thanks,> >> > Dave Lugo> >> > Sent from my iPhone> > 
-> > To 
unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org> > For additional 
commands, e-mail: users-h...@openoffice.apache.org> >>

Re: Unwanted Dialogue Box

[Alan Pearce]

Thank you Brian,

I apologise I really wasn't shouting, just emphasising.  Thank you for your 
suggestions I will look further. It was in .xls and I haven't checked what it 
recovered as.Regards.Alan.

 Original message 
From: Brian Barker  
Date: 21/10/2019  16:27  (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 that cannot be exported. Please 
retype >your password to be able to export your document" I AM NOT TRYING TO 
>EXPORT MY DOCUMENT.Er, it seems you are. (And you may not need to 
shout!)>WHAT'S MORE IT MUSTN'T BE EXPORTED.What do you think "exported" means 
here? It just means the creation of a version of your document in an 
alternative format, e.g. as Portable Document Format. Your document isn't being 
sent anywhere inappropriate.>I have managed to delete it by pressing cancel 
about 3 times but now >the box won't go away however many times I press cancel. 
Any ideas please?It seems that this happens if you are keeping your document in 
a format foreign to OpenOffice and when AutoRecovery information is saved. Are 
you saving in something other than OpenOffice's native .ods format - perhaps 
.xls? That's generally not advisable. It seems that saving the AutoRecovery 
information when your document is in a foreign format is described as 
"exporting".If this is the problem, there appear to be a number of solutions:o 
Provide the password each time it is asked for.o Remove the password protection 
from the relevant items. (Probably not what you want to do.)o Disable 
AutoRecovery. To do this, remove the tick from Tools | Options... | Load/Save | 
General | Save | Save AutoRecovery information every xx Minutes. (Also probably 
not a good idea.)o (Best) Save your document as .ods. Keep it in that form and 
always edit that copy. If necessary for transmission to a correspondent, save a 
copy in the foreign format each time you need to do this. This is good practice 
anyway.At 15:40 21/10/2019 +0100, Alan Pearce wrote:>Typing into a cell, I was 
modifying an old document. I didn't note >wether it was text or figures, it 
happened quite a few times over >the last two days so I am sure it was probably 
both, it could have >been either. After cancelling about three times each time 
it >appeared it would go away. However in the end it wouldn't stay away >and it 
was not possible to work on it or save it.Still sounds like AutoRecovery.>I got 
out of the problem in the end by forcing a computer shutdown >and then 
re-opening via recovery.You see how useful this was, so don't disable the 
facility but use the first or last suggestions above.I trust this helps.Brian 
Barker-To 
unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Unwanted Dialogue Box

[Alan Pearce]

Steven,

Typing into a cell, I was modifying an old document. I didn't note wether it 
was text or figures, it happened quite a few times over the last two days so I 
am sure it was probably both , it could have been either. After cancelling 
about three times each time it appeared it would go away. However in the end it 
wouldn't stay away and it was not possible to work on it or save it. I got out 
of the problem in the end by forcing a computer shutdown and then re-opening 
via recovery. Although I would still like to know why.Regards,Alan.

 Original message 
From: Steven Ahlers  
Date: 21/10/2019  15:11  (GMT+00:00) 
To: users@openoffice.apache.org 
Cc: alannpea...@talktalk.net 
Subject: Re: Unwanted Dialogue Box 

Alan,What are you trying to do when this dialogue box appears?Please respond 
to:users@openoffice.apache.orgso that all users can assist 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 password to be able 
to export your document" I AM NOT TRYING TO EXPORT MY DOCUMENT. WHAT'S MORE IT 
MUSN'T BE EXPORTED. I have managed to delete it by pressing cancel about 3 
times but now the box won't go away however many times I press cancel. Any 
ideas please?Alan.

Unwanted Dialogue Box

[Alan Pearce]

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 DOCUMENT. WHAT'S MORE IT MUSN'T BE 
EXPORTED. I have managed to delete it by pressing cancel about 3 times but now 
the box won't go away however many times I press cancel. Any ideas please?Alan.

Re: read only problem

[Alan Pearce]

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.apache.org 
Subject: read only problem 

I inadvertently  clicked read-only.   Instructions on the help page, while very 
clear,  did not work.  For now, I am stuck with a read-only document that I 
need to access.Any help?Thanks.ArtisSent from Mail for Windows 10

Re: Unfound file extension.

[Alan Pearce]

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.



 Original message 
From: Julian THOMAS  
Date: 20/06/2019  14:32  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Re: Unfound file extension. 

Typical burrocrats!Options - find a windoze user with Office and have them save 
as xlsx.Or a Mac user - I'm almost positive that the [free]  Numbers app will 
save as xlsx. Sent from JT's Ipad - maybe using voice dictation!> On Jun 19, 
2019, at 23:51, Diana Allen  wrote:> > This is 
a problem since according to the revenue department, when filing 
electronically, it MUST be in this format.Is there a workaround for this 
problem, or will I have to file on paper and pay fees? 
-To 
unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Force a Line Return in a Calc Cell

[Alan Pearce]

Thank you Dave I didn't know that one!

Alan

 Original message 
From: Dave AOO  
Date: 15/04/2019  08:33  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Re: Force a Line Return in a Calc Cell 

The keyboard combination Ctrl+Enter will force a [CR] break 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 this moment but think you will find it somewhere 
in "Format/Cells".> > Alan.> >  Original message > From: 
"WA.TWORSX via AOL"  > Date: 14/04/2019  22:24  
(GMT+00:00) > To: AOO Mail List  > Subject: Force 
a Line Return in a Calc Cell > > AOO415m1(Build:9789)  -  Rev. 
18174962017-12-11 17:25, CALC_DELL desktop PC, 
Windows10x64 Home_Calc Users:What is the 
required keystroke combination to use for forcing a carriage-return-line feed 
(CR) in a Calc 
cell?VinceB.-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: 
users-h...@openoffice.apache.org-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Force a Line Return in a Calc Cell

[Alan Pearce]

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".

Alan.

 Original message 
From: "WA.TWORSX via AOL"  
Date: 14/04/2019  22:24  (GMT+00:00) 
To: AOO Mail List  
Subject: Force a Line Return in a Calc Cell 

AOO415m1(Build:9789)  -  Rev. 18174962017-12-11 17:25, 
CALC_DELL desktop PC, Windows10x64 
Home_Calc Users:What is the required keystroke 
combination to use for forcing a carriage-return-line feed (CR) in a Calc 
cell?VinceB.-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Fwd: Format Cells

[Alan Pearce]

 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.Thanks,Alan.    

Format Cells

[Alan Pearce]

Does anyone know a custom format for Weight i.e. Stones and pounds for 
spreadsheet cells?

Re: Writer View Help

[Alan Pearce]

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 monitor with a new widescreen one, and the 
default view layout is automatic, so every time I open a document it displays 
in 2-page format. I can set it to one by clicking at the bottom but to do this 
every single time I open a document is very annoying as I use a lot of 
documents frequently. To zoom in so the automatic is one page makes the text 
too big. To make the whole window smaller allows the background to be a 
distraction from the text I want to be looking at. Even if I open a document, 
click single page, close it and open it again it goes back to being automatic 
number of pages. I just need to change the default from 'automatic' to 'single 
page'. I appreciate the usefulness of the automatic option but the single page 
option is equally useful and for me, more so.Please tell me how I can do 
this.Thank you,Samantha

Re: Printing a Spreadsheet in Open Office Calc

[Alan Pearce]

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 when printing my 
spreadsheet.  There is always 2.75” inch margin on the right side of the page 
when I print my spreadsheet. Can you help please.Valli 
Horner613726-7325-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Show All Comments

[Alan Pearce]

Sorry, I don't know of an answer. Brian suggests a macro.



 Original message 
From: "WA.TWORSX via AOL"  
Date: 18/02/2019  18:38  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Re: Show All Comments 

Yes, I am aware of that, but I am wondering if /_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: "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-64bit Home desktop.I am working in a 
spreadsheet template, and would like to have all comments displayed on screen.I 
think there is a method to show all written comments in AOO-Calc sheet.  If 
yes, Is there a way to toggle it 
off/on?VinceB.-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Show All Comments

[Alan Pearce]

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-64bit Home desktop.I am working in a 
spreadsheet template, and would like to have all comments displayed on screen.I 
think there is a method to show all written comments in AOO-Calc sheet.  If 
yes, Is there a way to toggle it 
off/on?VinceB.-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Re: Android

[Alan Pearce]

Thank you to Mathias and Andrea for the replies to my query. It's now installed 
and up and running.
Cheers,Alan

 Original message 
From: Matthias Seidel  
Date: 27/01/2019  20:24  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Re: Android 

Am 27.01.19 um 21:04 schrieb 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 available in the official Google store:

https://play.google.com/store/apps/details?id=com.andropenoffice=en-us

>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>

Android

[Alan Pearce]

Does anyone know if there is a version of AOO for android tablet devices please.
Thanjs,Alan.

Re: OpenProj

[Alan Pearce]

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 used OpenProj.  When I go to print and want to change some settings, I
can't select certain options.  How can I get full use of the applications?

-- 
Lee Garrett
404.388.0164

Re: Need to print ONLY selected pages

[Alan Pearce]

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 trouble. 
However, I have a twenty-one page document, but only want to print selected 
pages. 

Can't get to work! For example, I only want to print pages one and two, but 
later will 
want to print pages three thru five, later pages six thru 8, etc. 

How can I print selected pages? I know I can do it, but I'm doing something 
wrong. 

Edward 

Re: print problem

[Alan Pearce]

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 have been on the forum but still cant get help
I am not that good with technology as I am a senior but can usually work things 
out but this has me stumped  I cant seem to print a letter but previous items 
on my documents list will print but not this letter  I have tried printing it 
on other sites but no wont print .I feel it has something to do with  the set 
up but I have tried to delete the whole thing and rewrite it but it still wont 
print I have tried reinstall the disc still nothing If I write any thing now it 
wont print but the little photos I downloaded from my files did print and  
previous documents  will print but nothing I do now will print   What did I do 
  
Regards Patricia Bann  


Sent from Mail for Windows 10

Re: Pasting into a Text Box

[Alan Pearce]

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:
>Does anyone know how to paste text into a Text Box inserted into a 
>spread sheet please? The paste option doesn't seem to exist.

If you click the text box, you see the (flashing) outline and the 
eight coloured handles. Is this called "object mode"? That's not what 
you want. Double-click it and you will see instead just the (steady) 
outline. Is this called "editing mode"? Now you can use Edit | Paste 
or Ctrl+V (or Edit | Paste Special... or Ctrl+Shift+V). You can also 
use right-click | Paste, but you need to right-click within or 
immediately adjacent to existing text content. If you right-click in 
the text box but away from existing text content, the box selection 
will relax back to the other mode and you will not see Paste in the 
context menu.

I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Fwd: Pasting into a Text Box

[Alan Pearce]

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 sheet 
please? The paste option doesn't seem to exist.
Thanks,Alan.

Pasting into a Text Box

[Alan Pearce]

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: Microsoft word has hijacked my docs

[Alan Pearce]

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 
Subject: Microsoft word has hijacked my docs 


Hi ,

I have been using your Open Office 4.1.3 after a friend who works in IT 
downloaded it for me. All was well until I used a free trial period on 
Microsoft Word to read a document sent to me by someone. It as the only way to 
read it. Then a few weeks ago all my documents suddenly converted to Word docs 
and I can’t use them, alter them etc without paying a subscription. I have 
contacted Microsoft who say they cannot help. even though as I pointed out 
to them they have essentially stolen MY documents. It is outrageous. Is there 
some way to change them back to Open Office?

Many thanks.

Regards, Vanessa
Sent from Mail for Windows 10



---
This email has been checked for viruses by AVG.
https://www.avg.com

Re: scrambled files

[Alan Pearce]

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 spreadsheet for my cd songs. After recording 55 cds, the 
file said someone else was using it and it could not be edited. Noone else has 
access to that file. I opened a copy so I could continue the file. After 
completing the list of nearly 4000 entries, I went to open it today and a 
screen came up with what language, form etc on it. When I opened the file it 
came up as # and nothing else. I failed to back it up after the 
last 25 cds were entered, so now I have to redo them again. What is the problem 
with this program. Nothing like this has happened before and I have been using 
your program for several years. Please advise how I can keep this from 
happening on my other files, since I have a lot of genealogy files which are 
irreplaceable.
Alane Blachford Pena
alaneblachfordpe...@netzero.com
Sent from Mail for Windows 10


This Tiny Device Will Cut Your Energy Bill To Pennies
Unrestricted Investing
http://thirdpartyoffers.netzero.net/TGL3241/5b5e3d031f54f3d01370fst02vuc

Re: PDF converter

[Alan Pearce]

I have no idea as I don't use MAC. Works ok on my  windows systems. It normally 
installs as a printer and to convert a document to .pdf you have to choose 
"print" and then select pdf995.

 Original message 
From: heltai andras  
Date: 22/07/2018  09:25  (GMT+00: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:
> 
> 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 with one my computer warned me against downloading it, 
> Can you send me a link to an authentic download so I can be sure of it, 
> Thanks, Bill Hopkins
> 
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
> 


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: PDF cpnverter

[Alan Pearce]

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 with one my computer warned me against downloading it, Can 
you send me a link to an authentic download so I can be sure of it, Thanks, 
Bill Hopkins

Sent from Mail for Windows 10

Re: read-only documents

[Alan Pearce]

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 19/6/18 8:59 am, Alan Pearce wrote:
> When this occasionally hapens to me I have found closing the document and 
> reopening solves the ptoblem.
But could create other problems e.g. you loose all changes made.
>
>  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 rights windows 10" will turn up a number of
> sites with potential solutions. This is a Windows issue, not Apache
> OpenOffice.
>
>
> On 19/06/18 06:02, Tom wrote:
>> In Windows 10 (a newly re-installed Windows 10) I have a spreadsheet that 
>> opens in read-only mode and says I have insufficient rights to change that. 
>> How can I get those rights? It will not let me save the sheet with the same 
>> name.
>>
>> Sent from Mail for Windows 10
>>
>>
>
> Cheers


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: read-only documents

[Alan Pearce]

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 rights windows 10" will turn up a number of 
sites with potential solutions. This is a Windows issue, not Apache 
OpenOffice.


On 19/06/18 06:02, Tom wrote:
> In Windows 10 (a newly re-installed Windows 10) I have a spreadsheet that 
> opens in read-only mode and says I have insufficient rights to change that. 
> How can I get those rights? It will not let me save the sheet with the same 
> name.
>
> Sent from Mail for Windows 10
>
>


Cheers
-- 
David Robley

"Don't you hate it when your boogers freeze?" -- Calvin
  


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Cancel subscription

[Alan Pearce]

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: Re: Cancel subscription 

Tera

Listen to them.  OO is free.  I'm just a consumer like you and I've never
paid anything.

Whether you realise it or not, you "accessed" Apache via an untrusted
source.  Whoever it was conned you into paying.  Retrace your steps and try
to contact them again for, eg your money back.

All the best

Stephen Christopher


On Tue, Jun 12, 2018 at 5:23 PM, Tera Blink 
wrote:

> Craig...I am not confused.  When I accessed Apache for resume templates...
> when I started to use the template I was told in order to save it, download
> it, etc... there was a 2 week free trial and then a charge for the service.
> Tera
>
>
> Sent from Yahoo Mail for iPhone
>
>
> On Tuesday, June 12, 2018, 11:20 AM, Craig Russell 
> wrote:
>
> Hi Tera Blink,
>
> I'm afraid you have confused the OpenOffice project at Apache with a
> commercial company that is *not* affiliated with Apache OpenOffice..
>
> Apache OpenOffice can always be downloaded and used *for free* with no
> charges whatever.
>
> https://www.openoffice.org/download/
>
> Apache OpenOffice will *never* charge anyone for downloading or using the
> software.
>
> You should contact whoever sold you a free trial and ask for your
> subscription to be canceled.
>
> And you can always ask on this list for specific advice *for free* on
> using the features of Apache OpenOffice.
>
> Regards,
>
> Craig
>
> > On Jun 12, 2018, at 5:59 AM, Tera Blink 
> wrote:
> >
> > Hello,
> >
> > I signed up for your 2 week free trial of the “office” features so I
> could try out your resume templates.
> > Please cancel my subscription effective immediately as I did not find a
> resume app that suited my needs.
> >
> > Kindest Regards,
> > Tera Blink
> >
> > Sent from Mail for Windows 10
> >
>
> Craig L Russell
> c...@apache.org
>
>
>
>

Re: sort data

[Alan Pearce]

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 the 2 columns I 
want to sort (A1:b5) and the sort function is still grayed out.  Its like that 
for the whole book.


Be safe,
Lou Cipriano
203 509-8288
lou...@gmail.com


> On Feb 6, 2018, at 3:28 AM, Martin Groenescheij  
> wrote:
> 
> 
> 
> On 05/02/18 10:44 PM, Louis Cipriano wrote:
>> when I go to sort a table the sort option in data is grayed out.  how do I 
>> work around that?
> 
> If you haven't selected any column or row there is nothing to sort, quite 
> logical isn't?
> 
>> 
>> 
>> Be safe,
>> Lou Cipriano
>> 203 509-8288
>> lou...@gmail.com
>> 
>> 
>> 
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 
> 
> 

Re: Not printing after latest Win 10 update (KB4056892)

[Alan Pearce]

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 reinstalled 
Open Office to
No avail

DJF

Re: [AOO-Templates]

[Alan Pearce]

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 you offer it free, please take it off of the internet, 
and reduce the frustration the people who down load will endure.

Sent from Mail for Windows 10

Re: Your Program

[Alan Pearce]

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 software . voluntarily.!
Tony Clifford 

Sent from my iPad

> On 8 Dec 2017, at 21:12, Howard Blum  wrote:
> 
> This jerk deserves MS Office.
> 
>> On Dec 8, 2017 12:54 PM, "Paul"  wrote:
>> 
>> Wow, when Open Office first came out I thought it would be a great
>> substitute for Microsoft Office.  However, I just spent about an hour
>> trying to do one simple thing: turn off autoinput as you erroneously call
>> it, in the spreadsheet component.  Incredibly, that option is deeply hidden
>> in the Tools>Cell Contents option. That's just ridiculous.  Ridiculous.
>> Your program is also ridiculous.
>> 
>> When I uninstall this piece of trash you call Open Office, how can I be
>> sure there will be NO remains of it on my computer.  I won't no evidence
>> that I EVER used such a poorly written piece of junk. EVER.
>> 
>> Seriously, if you're going to write a program, you ought to try it out
>> before releasing it.  This is worthless junk.
>> 
>> Paul Jacobus
>> 
>> After Weeks Of Rumors, Joanna Gaines Comes Clean
>> risingstarnewspaper.com
>> http://thirdpartyoffers.netzero.net/TGL3231/5a2afa533205e7a52591fst04vuc
>> 
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>> 
>> 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: APACHE OPENOFFICE 4.1.3-4.1.4.

[Alan Pearce]

Thank you Brian. A nice clear answer. It has explained some thhings I didn't 
know.
Regards,Alan.

 Original message 
From: Brian Barker <b.m.bar...@btinternet.com> 
Date: 14/11/2017  16:03  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Re: APACHE OPENOFFICE 4.1.3-4.1.4. 

At 23:49 13/11/2017 +, Alan Pearce wrote:
>From: Brian Barker <b.m.bar...@btinternet.com>
>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 "OpenOffice 
>>>>Document Recovery" the ref 2017DP Consultation Response and Not Recovered 
>>>>Yet.
>>>
>>>The why is difficult to answer as we [meaning *I*!] don't know 
>>>what the cause of the message is, it definitely not comes from OpenOffice.
>>
>>Oh, it surely does! (And the rest of us know what the cause is.)
>
>Oh. Do we? How about letting us all in on the secret then

It's no secret! Providing that Tools | Options... | Load/Save | 
General | Save | Save AutoRecovery information every ... Minutes is 
ticked, OpenOffice regularly but quietly salts away information about 
the current editing session. Normally, this information is purged 
when the active document is closed. If OpenOffice fails for any 
reason (hardware problem? software glitch? user malpractice?), the 
saved information is not deleted. This is detected the next time 
OpenOffice is started and the offer described above - to attempt 
OpenOffice Document Recovery, here on the document file "2017DP 
Consultation Response" - is made. If the recovery is successful, a 
version of the document is presented and the user can decide whether 
to save it instead of or as well as the original file - whatever 
condition that is in. If the recovery is not successful, the offer 
will be repeated each time OpenOffice is started. The solution in 
this case is simple: to decline the recovery process once.

Strangely, the manuals suggest that this facility saves the current 
state of documents over the originals - as if File | Save were being 
used at regular intervals. But that is not the case (and would be 
unhelpful anyway). The built-in help is somewhat clearer on the subject.

Brian Barker  


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: APACHE OPENOFFICE 4.1.3-4.1.4.

[Alan Pearce]

 Original message 
From: Brian Barker <b.m.bar...@btinternet.com> 
Date: 13/11/2017  23:29  (GMT+00:00) 
To: users@openoffice.apache.org 
Cc: "David G.Macmillan" <dg.macmil...@talktalk.net> 
Subject: Re: APACHE OPENOFFICE 4.1.3-4.1.4. 

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 "OpenOffice 
>>Document Recovery" the ref 2017DP Consultation Response and Not Recovered Yet.
>
>The why is difficult to answer as we [meaning *I*!] don't know what 
>the cause 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-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Apache Open Office 4.1.4

[Alan Pearce]

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: Apache Open Office 4.1.4 



Sent from my mobile device.

> On 11 Nov 2017, at 9:12 am, melodyp...@aol.com wrote:
> 
> Hi,
> 
> 
> Please let me know if your latest version of "Apache open Office 4.1.4" would 
> work with Windows 7.

On the download page you find a link to System Requirements
here you find the required information.

> I would like to dowload it to convert Word files into PDF files.
> Please let me know.
> 
> 
> Thank you very much!
> Mariagrazia Byrnes


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Unable to open OpenOffice on Mac

[Alan Pearce]

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: 20/09/2017  08:03  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Unable to open OpenOffice on Mac 

Hi,

I attempted to download OpenOffice version 4.1.3 onto my Mac with OS X
version 10.12.6 and it was successful but when I opened the application
this message came up:

“OpenOffice” can’t be opened because it is from an unidentified developer.
Your security preferences allow installation of only apps from the App
Store and identified developers.

I attempted to bypass the Gatekeeper function but the message still
appeared. Do you know if the 4.1.3 version of OpenOffice is compatible with
my OS X version?

I appreciate your help.

Sincerely,
Daniel

-- 
Daniel Quintana
M.A. in Counseling Psychology
Sofia University (formerly Institute of Transpersonal Psychology)

Re: Value

[Alan Pearce]

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 good to be true, they most likely are.

Will it work on Windows 10, ryzen 5 1400, 8 gig memory?

Paul
-- 
Sent from my Android device with Email Mail. Please excuse my brevity.

RE: apply e-mail program to OpenOffice documents

[Alan Pearce]

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+00:00) 
To: OpenOffice  
Subject: RE: apply e-mail program to OpenOffice documents 

Thanks for the reply. Maybe I did not make myself clear, I know there is no 
e-mail app etc,  I have two e-mail programs either one of which I would like to 
use to send an OpenOffice document. What I need is the instruction on how to 
make that happen. The OpenOffice site offers no help. Thanks PG

Sent from Mail for Windows 10

From: James Knott
Sent: Wednesday, August 23, 2017 12:20 PM
To: users@openoffice.apache.org; reeves1...@gmail.com
Subject: Re: apply e-mail program to OpenOffice documents

On 08/23/2017 02:50 PM, PG wrote:
> I have looked at pretty much all your site for information on HOW to install 
> on e-mail program into OpenOffice. When I follow the limited instructions I 
> found all I get is “no e-mail program installed” None of your forums appear 
> to give any importance to this issue. All I want to do is e-mail a created 
> document to an e-mail contact. Please advise. PG
> Sent from Mail for Windows 10
>
>

There is no email app for OpenOffice.  You use whatever email app is
installed on your computer.  Many people use Thunderbird.

When you have an email app installed, you can use it to send documents.

Re: Trouble with Calc

[Alan Pearce]

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 anything, I did differently.

Regards,
Alan.

Sent from Samsung tablet

 Original message 
From: Bill Dillinger  
Date:15/05/2017  15:21  (GMT+00:00) 
To: mar...@groenescheij.com,users@openoffice.apache.org,Brian Barker 
 
Subject: Re: Trouble with Calc 

Hello,
I have received helpful suggestions from Brian and Martin and very much 
appreciate them. Thanks for the help and any additional notes that may 
yet come in. I realize now my original message was not completely clear 
because I did not fully understand my problem. As was suggested by both 
my problem was due because the numbers in the .csv file were being 
brought in as text not numbers.

One suggestion was to click the "Detect special numbers" option when 
opening the file. I did try this and it didn't work.
It was suggested to use the function =VALUE(c2) in a new column in Calc 
to convert the text to numbers. When I did this I got Err 502.
Then Brian suggested the problem could be due to leading blanks in the 
field. This seems to be the real problem. If I remove the leading blanks 
in Calc the text becomes numbers.  Also if I remove the leading blanks 
in the .csv file the fields will be input as numbers.

I would be impractical to remove leading blanks manually through out the 
file. I know editor questions are not appropriate to this forum but FYI 
I will mention what I have learned so far. Using OpenOffice Writer I see 
that the fields start with a tab character. I am working on it but have 
not found a way to find and replace the tab character in any of the 
editors I have access to on my computer.

Still working on it. Thanks for the help.

Bill Dillinger


On 5/15/2017 8:46 AM, Martin Groenescheij wrote:
>
>
> On 14/05/17 5:22 AM, Bill Dillinger wrote:
>> Hello,
>> I can't seem to manage Calc with even a simple problem. I am trying 
>> to read and work with a spreadsheet made from a .csv file with 
>> columns of numbers. I really have tried to read and work with the 
>> HELP file.
>>
>> First I could not add 4 numbers but with lots of tries found that it 
>> seemed to be because all my numbers ended in .0 and when I did a 
>> global replace of .0 with nothing I could then add numbers. Once I 
>> did that I was able to compute an average and then copy the formula 
>> to other places in the spreadsheet. I first did try formatting the 
>> number field but that didn't seem to help. If someone could tell me 
>> why I can't use numbers ending in .0 I would be interested.
>
> First thing you should check is to see if the number is really a 
> number. Sometimes when you open a CSV file the numbers
> are imported as text. It's good practise to tick the box "Detect 
> special numbers" when you open or import CSV files.
> It's easy to check if a number is imported as text by selecting a cell 
> look at the top bar if the number is preceded with ` e.g.
> `123 it is a text field. Changing the format doesn't help.
> You could do two things:
>  1 deleting all ` in the cells which doesn't make sense if you have a 
> lot of numbers to change
>  2 start from scratch and check the "Detect special numbers" box
>
>>
>> Second my current problem is I cannot find the spread of 4 numbers. I 
>> tried =MAX(C2:C3;C4;C5)-MIN(C2;C3;C4:C5) and it worked! Then when I 
>> copied that formula into a new location to get 
>> =MAX(C6;C7;C8;C9)-MIN(C6;C7;C8;C9) it gives me the incorrect value 0. 
>> If I copy or type the formula into any other cell it will not work.
>>
>> If anyone knows what my problem is I would appreciate it.
>>
>> Thank you
>>
>> Bill Dillinger
>>
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>>
>>
>
>


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: open office-HELP!!!

[Alan Pearce]

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:20/03/2017  16:20  (GMT+00:00) To: users@openoffice.apache.org Subject: open office-HELP!!! Dear Sir,Having used Open Office successfully for several years it is now unusable and rubbish. I have taken it off and reinstalled several times with no beneficial effect. this is a screen shot of recent work.I have installed a Mac cleaner at cost, and am totally frustrated as I am the  Treasurer of a Museum and the Secretary of a Gardening club and have other roles where I need Open Office urgently. I am now considering a Micro Soft package as I cannot sort this out. It has happened in the past few weeks. Any hi lighting I do is in Black. The print goes furry and sometimes doubles up, I cannot delete cells easily . I could go on and on but am at my wits end.I hope you can helpYours Sue Johnston

Re: Multiplying Time by Numbers

[Alan Pearce]

Thanks Johnny.

On 19/03/2017 11:18, Johnny Rosenberg wrote:

When you enter time in a cell, enter it like hh:mm:ss (separator depends on
your language settings).
Examples:
0:0:9 → 00:00:09
0:9 → 00:09:00
9:0 → 09:00:00
1:13:3 → 01:13:03
12:4:56 → 12:04:56

the cell will format to hh:mm:ss automatically. Of course you can change
this. I guess h:mm would be what you're looking for. In that case, the
avove examples will display as:
0:00
0:09
9:00
1:13
12:04 (for some reason the result is not rounded up to 12:05, maybe that's
a bug, or maybe it's expected behaviour)

What's really in the cell is a floating point number less than 1. 1 means
24 hours, so 0.5 is 12:00:00, 0.75 is 18:00:00 and so on. To get it in
hours, just multiply with 24. Then you get something that you can multiply
directly with anything, such as your currency.

Here's an example
A1 → type 1:30
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 <alannpea...@talktalk.net>:


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 <alannpea...@talktalk.net>
Date:18/03/2017  12:51  (GMT+00:00)
To: users@openoffice.apache.org
Subject: Multiplying Time by Numbers

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



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Fwd: Multiplying Time by Numbers

[Alan Pearce]

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 <alannpea...@talktalk.net> 
Date:18/03/2017  12:51  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Multiplying Time by Numbers 

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

Multiplying Time by Numbers

[Alan Pearce]

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

Re: Installing OO.o

[Alan Pearce]

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+01:00 Jim McLaughlin :

> And yet you've responded twice to my post, which you could have ignored.
> You apparently do think I care, and lack the self restraint to control
> yourself.
>
> I own you.
>

​Quite the contrary, dear «Jim McLaughlin» - after making a fool of your
self on this forum, you continue to respond to someone who points the fact
out, You've been pwned ;-)

Henri

Re: Downloading MS Office Documents

[Alan Pearce]

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: Downloading MS Office Documents 

I have  Open Office 4.1.2. When I download an Office document I get a box 
saying "You are trying to use Office but don't have Office." I previous 
versions these documents would automatically convert. Excel documents are 
opened in Calc, etc.I tried using the Load/Save feature in the Tools-Options 
menu but that had no effect. How do I get these documents to open in Open 
Office? DARNLEY W. HOWARD
President/Principal Consultant
Advansa International
(c) 781/350-0610
www.linkedin.com/in/darnleyhoward/
emergingmktstories.wordpress.com
smallbusinessstories.wordpress.com/

Re: Open Office

[Alan Pearce]

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  18:10  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Re: Open Office 

2017-02-10 5:08 GMT+01:00 :

> Dear Sirs how do I associate a email account with Open Office if I want to
> email a document to a friend
> Regards Eric Weale
>
> Sent from Mail for Windows 10
>
>
You don't need to. Just write your mail, then attach the document and send
it all to your friend.



Kind regards

Johnny Rosenberg

Re: Caps and Lowercase-Auto-complete Problem

[Alan Pearce]

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
Tel: 01275 856887
Mob: 07761  255688

Sent from Samsung tablet

 Original message 
From: "VinceB."  
Date:03/02/2017  14:51  (GMT+00:00) 
To: AOO Mail List  
Subject: Caps and Lowercase-Auto-complete Problem 


I am trying to enter a case-specific text string into a Calc cell. The 
string has both uppercase and lowercase and numerical characters.  It 
appears that Calc is remembering similar/previously entered strings and 
forces those to appear within the cell, i.e., changing a lowercase to an 
uppercase appearing as the first character, or changing a lowercase to 
an uppercase where the character is not the first nor the last character 
within the string.  The format for the cell is "Text". Clearing cell's 
all content and tried again; no go. Using the check mark with the 
desired string display in the bar does not help me.

How can I disable the auto-complete feature for this effort?

What am I doing incorrectly ?


Regards,

VinceB.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Drag and Drop in a Spreadsheet

[Alan Pearce]

Thanks to all for your help. Now I understand. I don't know why it can't be as 
easy as Excel.


Alan.

Drag and Drop in a Spreadsheet

[Alan Pearce]

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.

Re: Big problem

[Alan Pearce]

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@openoffice.apache.org 
Subject: Re: Big problem 

Don't sweat the small stuff.  



Sent from my Samsung Galaxy smartphone.


 Original message 
From: Tom Hayden 
Date: 21/01/2017 7:28 p.m. (GMT+00:00)
To: users@openoffice.apache.org
Subject: Big problem

Hello
I have a problem that I never encountered before.  When opening a file that I 
have been working on for several years the document opened with nothing but the 
pound symbols. Like this:  , all 300 pages have this now instead of 
my writings.  Is there a way I can recover my previous work?  Can I somehow go 
back to a former date before this occurred?  Can anyone tell me how and why 
this occurred?  Never had such a problem before!  I am bummed big time. Please 
help! Thanks so much.

Sent from Mail for Windows 10