Re: question....

[James Plante]

@elderdanlewis,
I, too, am sorry you received the snarky answer. It was inappropriate.

If you’ll click on the Apple menu and choose “About this Mac,” you’ll see all 
the info that anybody needs to answer most questions. Actually, we need to know 
specifically which OSX version you have installed. “About this Mac” will tell 
you that, and a lot more besides. 

Jim


> On Jan 2, 2016, at 8:40 PM, elderdanlewis  wrote:
> 
> I have one of the earliest Intel MacBook which was in 2006. The computer in 
> question probably doesn't have an Intel motherboard and will not run OS X at 
> all. Even if it does, it cannot be upgraded to Lion. This is what was told to 
> me.
> 
> Dan
> 
>  Original message 
> From: "Dennis E. Hamilton"  
> Date:01/02/2016  7:02 PM  (GMT-05:00) 
> To: tec...@yahoo.com 
> Cc: users@openoffice.apache.org 
> Subject: RE: question 
> 
> I am sorry that you did not receive a polite and respectful response.
> 
> The system requirements for the latest release, Apache OpenOffice 4.1.2, can 
> be found at 
> 
> 
> You will need to verify your actual OS X configuration, including version of 
> OS X.
> 
> The 4.1.x-required OS X 10.7 (Lion) was released in 2011.  If you have not or 
> cannot upgrade your computer to OS X 10.7, you may have difficult running an 
> Apache OpenOffice 4.1.x release.
> 
> - dennis
> 
> 
>> -Original Message-
>> From: tec...@yahoo.com.INVALID [mailto:tec...@yahoo.com.INVALID]
>> Sent: Saturday, January 2, 2016 15:01
>> To: users@openoffice.apache.org
>> Subject: question
>> 
>> Hi, Question:If I had a 10 year old Mac running a 10 Year old OS, would
>> I be able to download and use your latest OpenOffice release?-Thanks
> 
> 
> -
> 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: question....

[James Plante]

Ah! Now someone can possibly be of help. Just a little more info, please. Can 
you launch the Mac partition and do as I suggested? This time, we’ll want the 
processor that’s installed. “About this Mac” will give it to you. 

Stay tuned. There may be an Ubuntu command that will give you this information. 
But I use a Mac, and run version 4.1.2, so I’m useless from this point on. If 
you’ll provide that information, some other (Ubuntu) user will be in a position 
to help. What partitioning software are you running? Parallels or VirtualBox or 
something else?

Jim

> On Jan 4, 2016, at 2:58 PM, elderdanlewis  wrote:
> 
> I have installed ubuntu 14.04 on my MacBook, and I do not use the OS X 
> partition. This way I can use the latest version. 
> 
> Dan
> 
>  Original message ----
> From: James Plante  
> Date:01/03/2016  9:35 AM  (GMT-05:00) 
> To: users@openoffice.apache.org 
> Subject: Re: question 
> 
> @elderdanlewis,
> I, too, am sorry you received the snarky answer. It was inappropriate.
> 
> If you’ll click on the Apple menu and choose “About this Mac,” you’ll see all 
> the info that anybody needs to answer most questions. Actually, we need to 
> know specifically which OSX version you have installed. “About this Mac” will 
> tell you that, and a lot more besides. 
> 
> Jim
> 
> 
>> On Jan 2, 2016, at 8:40 PM, elderdanlewis  wrote:
>> 
>> I have one of the earliest Intel MacBook which was in 2006. The computer in 
>> question probably doesn't have an Intel motherboard and will not run OS X at 
>> all. Even if it does, it cannot be upgraded to Lion. This is what was told 
>> to me.
>> 
>> Dan
>> 
>>  Original message 
>> From: "Dennis E. Hamilton"  
>> Date:01/02/2016  7:02 PM  (GMT-05:00) 
>> To: tec...@yahoo.com 
>> Cc: users@openoffice.apache.org 
>> Subject: RE: question 
>> 
>> I am sorry that you did not receive a polite and respectful response.
>> 
>> The system requirements for the latest release, Apache OpenOffice 4.1.2, can 
>> be found at <http://www.openoffice.org/dev_docs/source/sys_reqs_aoo41.html>
>> 
>> 
>> You will need to verify your actual OS X configuration, including version of 
>> OS X.
>> 
>> The 4.1.x-required OS X 10.7 (Lion) was released in 2011.  If you have not 
>> or cannot upgrade your computer to OS X 10.7, you may have difficult running 
>> an Apache OpenOffice 4.1.x release.
>> 
>> - dennis
>> 
>> 
>>> -Original Message-
>>> From: tec...@yahoo.com.INVALID [mailto:tec...@yahoo.com.INVALID]
>>> Sent: Saturday, January 2, 2016 15:01
>>> To: users@openoffice.apache.org
>>> Subject: question
>>> 
>>> Hi, Question:If I had a 10 year old Mac running a 10 Year old OS, would
>>> I be able to download and use your latest OpenOffice release?-Thanks
>> 
>> 
>> -
>> 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
> 


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

Re: Email

[James Plante]

Go to NeoOffice->Preferences…
Click the disclosure triangle next to “Internet”
At the bottom of the disclosed list, you’ll find “E-mail”; click on that 
selection.
The dialog that results will ask you to locate your mail client. Click on the 
square button with “…” in it, and browse to find your mail client. Click it; 
select “Open”.
The browse dialog goes away, leaving you with the original window. But now that 
window contains the full path to your mail client. 
Click “OK”.
Now you should be able to e-mail documents.

Jim
 

> On Jan 11, 2016, at 11:40 AM, John Kurcz  wrote:
> 
> I GIVE UP.  Tried SITES looking for a way to set up email.
> 
> My computer repair company,  two friends who know a lot about computers, all 
> gave up trying to find a way to email a document from Open Office to someone. 
>  
> Microsoft documents no trouble sending a document email but cannot on Open 
> Office.
> 
> I updated from XP to Windows 7.  The company that made the update tried but 
> could not find a way to install an email account.  
> 
> I am hoping you have a “SIMPLE” 1,2,3, installation directions.
> 
> I would like to use my AOL account but I am flexible.
> 
> John Jay


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

Re: Open Office changing my document from word

[James Plante]

Cathy,

I don’t suppose it has occurred to you that you’re yelling and screeching at 
other users who have no more authority over the operation of the program than 
you do. YOU DO NOT HAVE MY PERMISSION TO YELL AT ME!!! WE ARE NOT MARRIED, 
SO STOP IT! 

Now calm down and tell us which operating system you’re using: Windows or Mac. 
Then tell us, step by step, how your documents came to be “changed.” Then one 
of us may be able to tell you how to solve your problem. 

But we won’t do that if you keep screeching like a spoiled child of privilege 
who seems to regard all of us other users as your personal servants. I don’t 
really care about how inconvenienced you may be; AOO works well for the rest of 
us. Insult us again at your peril. We are not your paid consultants (or 
servants.)

Jim

> On Jan 18, 2016, at 6:37 PM, cathy colorado  wrote:
> 
> I am so annoyed with you right now, that I feel a strong hatred for you. I 
> can't believe your software is so invasive that you would change my Word 
> Documents to ODT without asking permission, and without making it easily user 
> friendly to undo. You are automatically changing my Word documents and they 
> are disappearing. Stop I want to keep your software, but you DO NOT HAVE 
> PERMISSION TO CHANGE MY WORD DOCUMENTS 
> 
> Please tell me exactly how to undo this mess and stop your software from 
> changing my Word Documents WITHOUT MY PERMISSION!!!  If I could scream in 
> your ear personally right this minute I would. You are annoying!
> 
> Cathy   


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

Re: Shut down

[James Plante]

It would help us to analyze your problem if you would provide the version 
number of your operating system; the version of OpenOffice that you are 
running; and the type of computer (laptop? desktop?).

A couple of suggestions that might work: Click on the Apple menu at the top of 
the screen; select “Force Quit…” from the menu. Then find OpenOffice in the 
Force Quit menu and select it. Click the button at the bottom, and it should be 
gone. 

If nothing else works, reboot the Mac and hold down the shift key while it 
reboots. It should restart with no applications running. 

If neither of those works, write back with as much information as you can 
provide. Somebody here is likely to know a way to fix this.

Jim
 
> On Jan 29, 2016, at 4:42 AM, Paul J Darby  wrote:
> 
> Sir or Madam;
> I cannot shut down Open office on my Mac I have tried switching off but it 
> reboots with it live again.
> 
> Regards 
> Paul J Darby
> -
> 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: OpenOffice intitial "banner" window immovability.

[James Plante]

Did you try clicking the “Open…” icon at the bottom of the left column?

Jim

> On Feb 2, 2016, at 1:32 PM, Ranger test  wrote:
> 
> Hello, 
> 
> I’ve had to reinstall AOO 4.1.2 after OS X 10.11.3 difficulties.
> 
> When AOO opens (it is one of my applications which open automatically upon 
> start up), the "Apache OpenOffice ™ 4” banner window opens (as before 
> reinstallation).
> 
> Now however, I cannot close/minimise the “banner” window nor can I drag it 
> off the desktop view area. Can anyone suggest how I can remove the “banner” 
> to allow clear access to AOO work files unimpeded, please?
> 
> Sincerely, Paul Collins.
> 
> 
> -
> 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: Draw and Licensing

[James Plante]

OpenOffice is a suite, and its components cannot be downloaded or installed 
separately. However, the whole suite is free, and can be used commercially or 
personally. You can give a copy to your friends or colleagues. 

However, please download the suite from only the approved site: 
http://www.openoffice.org/download 
Select your operating system (Windows, OS X, Linux), Language, and version 
(you’ll probably want the most recent, v. 4.1.2), then click the button that 
says “Download full installation.” 

Don’t obtain the download from any other site unless you like ads, malware, 
trojans, and pay services. This program is distributed free of charge; there’s 
no cost for downloading it. There’s no formal support for it, either. This 
user’s list is the way you get support: State your machine type and operating 
system; state as precisely as possible the problem that you’re encountering. 
Tell us what you’ve already tried, and the results of those attempts. Finally, 
it may help to state what results you were attempting to achieve. This program 
is distributed free worldwide, and this list has thousands of users just like 
you. One of us is very likely to have a solution. 

BTW, I’m not an “official” of Apache OpenOffice; nobody here is. We cannot give 
you permission for commercial use because Apache already gave you that 
permission in its license agreement. It states roughly that the program can be 
downloaded, used, and redistributed without charge. For more specifics, read 
the EULA, or write back here.

Regards, 

Jim

> On Feb 3, 2016, at 10:31 AM, Rau, Rhetta  wrote:
> 
> Hello, 
> I have a user that would like to use the Draw module of Open Office. 
> Is Draw free and can be used for commercial use?  
> Also – Can Draw be downloaded separately?
>  
> Please let me know.
> Thanks,
>  
> Rhetta J. Rau
> Service Desk Manager
> 
> 
> 
> (406) 656-6399 n (800) 865-9847 (fax)
> 222 North 32nd Street, Suite 700
> Billings, Montana  59101
> 
> Consider the environment before printing.

Re: a query from a newbie

[James Plante]

Reply inline below: 

> On Feb 3, 2016, at 3:59 PM, Nicholas Barnett  wrote:
> 
> Hi,
> 
> Just bought a new computer (after 11 years with a mac mini). It's another 
> mac, the air book or is it a book air, anyway, I'm trying to make do without 
> Microsoftware, WORD and EXCEL, and I've gone and downloaded Apache's offering.
> 
> I've got the __OpenOffice.org Writer for Microsoft Word users:__ to help me 
> on my way, but I'm disappointed to find no mention of ^ in it.
> 
> WORD uses ^ to code unprintable marks like ^l, linefeed, ^t tab, ^p paragraph 
> and so on.
These are used only in Find and Replace… with regular expressions selected in 
the Find and Replace dialogue. The ones you mentioned are ^l = \n; ^t = \t; and 
^p = $. The beginning of a line is ^; the end of a paragraph is $. That \n is a 
newline character, and searching for $ won’t find it. Find empty paragraphs 
with ^$. 
> 
> Why not add a table with all the ^ codes and what to do in Writer to get the 
> same effect? There must be a way to change a ^l to a ^p or vice versa, or 
> change all ^ps to ^p^ps.
There already is one. You’ll find it by searching Google for “Regular 
Expressions in OpenOffice.” You’ll want to hunt that down, because OOo has a 
few differences. 
> 
> I don't know who I'm writing to, but I did do (what in the 1970s was called) 
> Tech Lit or Tech Doc for a while, as my job, and I quite enjoyed it, but I 
> did get paid. I am quite surprised that Apache Openstuff is free. (I think 
> Office is wildly overpriced, by the same token, and that it says something 
> rather discouraging about people, and "the market" that the keep going back 
> in droves to microsoft, rather than going to Apache or a number of other 
> offerings. Perhaps if you charged $25 for each component, you'd have even 
> more people taking it! Not that I really know what I'm talking about . . . 
> I'm just grateful you're there, and can either help with my ^ codes or at 
> least tell me who I ought to be asking, if not you.
> 
> Yours sincerely
> Nicholas Barnett
> 
> -
> 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: Email.

[James Plante]

Go to OpenOffice -> Preferences; navigate all the way to the bottom of the list 
where it says “Internet.” Click the disclosure triangle next to Internet. 
Select E-mail.

In the dialog that appears, click in the “. . .” button and navigate to your 
e-mail client, whether it be Apple’s Mail.app, or Thunderbird, or Outlook. 
Select it. 

You’re good to go. Now when you choose File->Send->Document as E-mail, OOo will 
call your mail client, attach your document, and stand ready for you to send 
it. But please note that you should, before choosing to send the document, you 
should save it in whatever format you want to send it. If you don’t, it sends a 
document in OpenOffice format, which may not be what you want to send. 
Additionally, without the save, the document is named “noname.odt” which may 
not be what you want either. 

Jim

> On Feb 10, 2016, at 5:55 PM, Martin Groenescheij  
> wrote:
> 
> 
> 
> On 11-Feb-16 08:25, Mike Ellis wrote:
>> How do i put and email program into open office,so I can email some of the
>> work that I am writing on
>> 
> Use File --> Send to email in different formats
> If OpenOffice can't find an email client it suggest to save the file and 
> attach the file to your email.
> 
> -
> 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: How to Generate a Drop Down List within a CALC cELL?

[James Plante]

First, create the choices that you want to have in the dropdown list: In a 
blank spreadsheet, 
Go to cell D1. Enter “One”, return; in D2 enter “Two”, return; etc. Let’s say 
you do six entries, D1:D6.

Now, select the cell at which you want to make the dropdown list. Let’s use A2. 
Now go to 
Data->Validity; you’ll get a dialog box. In that box, at the “Allow” prompt, 
click the dropdown box and select “Cell Range.” The dialog changes. 

On the right of the “cell range” box, select the “shrink” button. Now in the 
spreadsheet, select D1 and drag to D6. Hit the shrink button again, and once 
again the dialog changes. The selected range of inputs is now $Sheet1.$D$1:$D$6.

Click “OK” and you’re good to go. Cell A2 now has an arrow next to it when it 
is selected—and only when selected! Click the arrow, and you can choose any of 
the six entries you made in D1:D6. 

There are other options available in the dialog. Explore them. You can use 
numbers, text, or formulas that give rise to arrays. Read the docs to find out 
more about it. (Google is your buddy.)

For instance, if you had a bunch of different cells in which you wanted to 
control or expedite data entry, you could put all the selections in different 
areas on Sheet2. Then when it’s time to select your cell range, shrink the 
dialog, change sheets, select the desired range, hit shrink again, and the 
dialog would show something like “$Sheet2.$F$10:$F$15”, and those choices would 
populate your target cell.

Jim Plante
 
> On Feb 11, 2016, at 10:56 AM, Vince  wrote:
> 
> Hello:
> 
> Using AOO 4.1.2 on WIN 8.1.
> 
> I do not know the correct terminology for searching in HELP file, but I want 
> to have a drop down selection list, with a clickable arrowhead, inside a Calc 
> cell.  How can this be done?
> 
> Regards,
> VinceB.
> 
> 
> 


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

Re: How to Generate a Drop Down List within a CALC cELL?

[James Plante]

Reply inline
> On Feb 11, 2016, at 3:35 PM, Vince  wrote:
> 
> 
> TNX Jim for the info; I will give it a try, but would like to be clear about  
> how to compose the required reference string and about where to properly 
> locate the drop-down selection list .
You can locate it anywhere you find convenient. I’d suggest that you put it on 
another sheet, but you don’t have to.

>  I will first try with the selection list definition being located on a sheet 
> within the same workbook.  I could name that sheet "Selection Lists" and 
> write a reference string to that.  
I would pick a short name. If you put a space in the title, it has to be quoted 
when you reference it. Just call it “Lists,” or something like that. If you’ll 
use the shrink button as I said, you don’t have to “write” any references. It’s 
all done for you. You just select the range of the cells in which the choices 
appear. But you can write it if you want to: $Lists.$A$1:$A$5 will work just as 
well as selecting with the shrink button, and it works just as well. 

All those $’s hold the reference in one spot. They’re called “Absolute 
references.” 

> I have not ever tried to write a reference string to a sheet that is located 
> within a separate Workbook file, and do not know if that is possible to work.
Well, you *can* put the list in a separate workbook, but both workbooks have to 
be open for the reference to work. Just keep it in the same workbook, but on a 
different sheet. Sheets are selected with the tabs at the bottom of the window 
where it says “Sheet1”,  “Sheet2”, and “Sheet3.” You can add more sheets if you 
need them, and you can change the names. Right-click on the sheet tab to bring 
up a context menu that will allow you to change the sheet name. ***If you’re 
going to do that, though, do it before you create your reference list. 
> 
> At this point, my selection list must include the following that I plan to do 
> logic operations on from another sheet:
> 
> * With Vets '16
> * With George '16
> * During '16  BVL Practice
> * During '16  BVL Competition
> * '16 Practice Alone
List them just the way I told you: One selection per cell, all cells in the 
same column. 

> 
> Those choices are associated with a Workbook where I record my bowling scores 
> and George's bowling scores, such as they are!  In some cases I bowl a 3-game 
> series whereas in other cases I bowl a 5-game match, and yet when practicing 
> alone, any number of games may be bowled!.

This isn’t rocket science, and nowhere near as hard as picking up a 7-10 split. 
Just give it a try and throw a few gutter balls. We learn best from failure. 
Good thing programming doesn’t hurt, or I’d be a wreck. 
> 
> Regards,
> VinceB.
> 
> 
> 
> On 2/11/2016 12:18 PM, James Plante wrote:
>> First, create the choices that you want to have in the dropdown list: In a 
>> blank spreadsheet,
>> Go to cell D1. Enter “One”, return; in D2 enter “Two”, return; etc. Let’s 
>> say you do six entries, D1:D6.
>> 
>> Now, select the cell at which you want to make the dropdown list. Let’s use 
>> A2. Now go to
>> Data->Validity; you’ll get a dialog box. In that box, at the “Allow” prompt, 
>> click the dropdown box and select “Cell Range.” The dialog changes.
>> 
>> On the right of the “cell range” box, select the “shrink” button. Now in the 
>> spreadsheet, select D1 and drag to D6. Hit the shrink button again, and once 
>> again the dialog changes. The selected range of inputs is now 
>> $Sheet1.$D$1:$D$6.
>> 
>> Click “OK” and you’re good to go. Cell A2 now has an arrow next to it when 
>> it is selected—and only when selected! Click the arrow, and you can choose 
>> any of the six entries you made in D1:D6.
>> 
>> There are other options available in the dialog. Explore them. You can use 
>> numbers, text, or formulas that give rise to arrays. Read the docs to find 
>> out more about it. (Google is your buddy.)
>> 
>> For instance, if you had a bunch of different cells in which you wanted to 
>> control or expedite data entry, you could put all the selections in 
>> different areas on Sheet2. Then when it’s time to select your cell range, 
>> shrink the dialog, change sheets, select the desired range, hit shrink 
>> again, and the dialog would show something like “$Sheet2.$F$10:$F$15”, and 
>> those choices would populate your target cell.
>> 
>> Jim Plante
>>  
>>> On Feb 11, 2016, at 10:56 AM, Vince  wrote:
>>> 
>>> Hello:
>>> 
>>> Using AOO 4.1.2 on WIN 8.1.
>>> 
>>> I do not know the correct terminology for searching in HE

Re: How to Generate a Drop Down List within a Calc cell?

[James Plante]

Vince, I’m not sure that it’s really necessary, but you might also format the 
cells in your list box to text as well as the target range. 

One thing that may save you some time: You can copy and paste the active cell 
(the one in which the user chooses from the list). This will save you from 
having to format a whole column of cells.
Just select the cell and copy normally. Go to the next cell where you want to 
make those choices and select “Paste”, or Ctrl-V. 

> On Feb 12, 2016, at 4:22 PM, Vince  wrote:
> 
> 
> 
> When '16 BVL Practice was used, IIRC, the ERR:519 showed.  The cells within 
> my Source were not formatted as text beforehand.
> 
> Next time, I will try that Shrink box.
> 
> TNX.
> 
> On 2/12/2016 4:38 PM, Brian Barker wrote:
>> At 16:18 12/02/2016 -0500, Vince Bonly wrote:
>>> Came upon one glitch: I did not see a Shrink button in my version (4.1.2) 
>>> of AOO on the right of the "cell range" box. What I did see, after setting 
>>> the Criteria-Allow to "Cell range", is an input line after a "Source" 
>>> prompt.
>> 
>> The Shrink button is to the right of that Source box. It's an alternative 
>> (easier and more reliable) way to fill the box.
>> 
>>> I learned that the definition string for my selection choices should not 
>>> begin with an apostrophe ( ' ) nor with a [left] arrow ( < ).  I was trying 
>>> to begin with '16 BVL Practice or ; neither of those worked.
>> 
>> That's not true. An apostrophe before a number will be interpreted as a text 
>> format marker and not included in the cell value - but that shouldn't cause 
>> any problem if you have text following it, as you do here. (There are some 
>> complications if you have AutoCorrect set to change apostrophes to smart 
>> quotes.) In any case, you need only to format the cell range as Text before 
>> entering the values to avoid this problem entirely.
>> 
>> I don't see why  should be a problem. (It isn't for me.) If you 
>> actually want to be able to accept genuinely empty cells, just ensure that 
>> "Allow blank cells" is ticked in the Validity dialogue.
>> 
>> 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
>> 
>> 
> 
> 
> -
> 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: Why does Apple Charge For Open Office?

[James Plante]

Apache OpenOffice (AOO) is a free download, and there’s a binary that runs on 
the Mac. Go to www.openoffice.org, and ONLY to that site, for your download. 
Click on the “I want to download Apache OpenOffice” link. A screen will present 
you with the option to choose your operating system, language, and version. 
Click on the "Download full installation” button. When you do that, you’ll be 
taken to SourceForge, where your download will start automatically. DON’T CLICK 
ANYTHING!! The webpage is full of other ads, some of which look like download 
mechanisms for AOO. Just leave it alone, and the work will be done for you. 

There is a version of OpenOffice (not Apache Open Office though) on Apple’s App 
Store. It’s called NeoOffice. Neo is what I use for word processing. It’s code 
base is from OpenOffice v. 3.x.x, and the current AOO is v. 4.1.2. Neo looks 
better on a Mac. The current AOO seems to work better, at least when it comes 
to importing MS Office files. I think somebody’s got an IOS reader for AOO 
files, but it’s not free, and you cannot edit or markup files. 

If all your friend needs to do is to read the doc, don’t download anything. 
Just save it out of AOO as a .pdf, and send that (File -> Export as PDf; or 
File -> Send…:: Email as PDF…). 

Your friend might want to run a malware checker on her Mac. Those “Premium” 
editions can cause a lot of damage; they’re as ubiquitous as “Nigerian Prince” 
scams these days.

Good luck,

Jim


> On Feb 18, 2016, at 1:58 AM, David Paley  wrote:
> 
> I sent a friend of mine some writing I did a couple days ago, and since she
> was having trouble opening it with the .doc extension I sent it to her
> with, I sent her another copy in the Open Office extension that I wrote it
> on. She downloaded the Apple Open Office app to read it and got told she
> needed the Premium Edition which she would have to pay for. I thought Open
> Office was a free program. Am I mistaken?
> 
> -- 
> 
> 
> [image: --]
> David Brian Paley
> [image: http://]about.me/dbp54
> 


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

Re: Open Office Writer UTTER , UTTER Rubbish (or not)

[James Plante]

Guys, I agree with most of you. But let’s not feed the troll, shall we? 

Gunny, good suggestion :-)

Jim

> On Mar 13, 2016, at 3:49 PM, Dale Erwin  wrote:
> 
> On 3/13/2016 8:40 AM, Darren Myers wrote:
>> Max
>>  I am a developer in BMC / People soft  applications, 32 years and 4 months  
>> overall experience..
>>  I shouldn't have to delete a profile and re-create it and go through that 
>> pain in order to get the most basic function working.
>> Open office need to fix this MAJOR problem.  It was an issue for users in 
>> 4.1.1 and still in 4.1.2
>>  However it really doesn't matter now, I simply opened my MS doc up online 
>> and MICROSOFT! allows you to edit and SPELL CHECK.
>> Lets be honest and truthful here, Open office is inferior, and by all 
>> accounts the worst freeware I have ever installed or used.
> 
> Sorry to hear you're having so much of a problem with Open Office. I've never 
> had any myself, so the only advice I can offer is:  Don't let the door hit 
> you in the ass on the way out.
> 
> 
> 
> -
> 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: file

[James Plante]

This is one BIG advantage of AOO: It doesn’t run Word or Excel macros. I 
clicked, I looked, and the file’s unintelligible. Could be encrypted, but with 
a “.ru” domain, I wouldn’t take the chance.


> On Mar 19, 2016, at 11:50 AM, Dennis E. Hamilton  
> wrote:
> 
> From Microsoft Office 2016: "The file format and extension of don't match.  
> The file could be corrupted or unsafe. ..."
> 
> I recommend that anyone receiving this message from the list simply delete it 
> and its attachment.
> 
> - Dennis
> 
>> -Original Message-
>> From: alex3706...@yandex.ru [mailto:alex3706...@yandex.ru]
>> Sent: Saturday, March 19, 2016 04:36
>> To: users@openoffice.apache.org
>> Subject: file
>> 
>> 
>> -
>> 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
> 


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

Re: help with controls!!!!!!

[James Plante]

Tina,
If you need to explain why you made a particular edit, don’t forget Insert -> 
Note. That can be very handy in situations like yours.

Jim

> On Mar 19, 2016, at 7:19 PM, Tina  wrote:
> 
> Thank all of you so muchThe job I'm being offered, 
> the translation editing, depends on being able to do this. Yes, I need to be 
> able to show the changes I have made and what was there before. Thank you for 
> answering so quickly!!! God bless and have a wonderful Easter.
>  
> Tina
> 
> "'God' brings us into each others lives for a reason and purpose that we may 
> never know until the end. But every interaction that we have - even if just a 
> simple smile, is a catalyst for something bigger, with a positive or negative 
> outcome, so you must be aware of yourself so you can help another when it is 
> needed." ~SchaOn
> 
> 
> 
> | I'm trying to do my bit to help the environment and thought you  |
> | may be interested in taking part? To join the movement on  |
> | WAYN.com and help make a difference. |
> 
> 
> 
>El Viernes, 18 de marzo, 2016 23:33:03, Vernon Lewis 
>  escribió:
> 
> 
> You probably have a reply by now but just in case; 
> 
> Menu Edit; Select Changes and click on the record and show options.
> 
> Easy if you know how.
> 
> Best wishes,
> 
> 
> Vernon
>> On 19 Mar 2016, at 1:38 PM, Tina  wrote:
>> 
>>   Hi, I need to be able to show my editing on texts for a translation that I 
>> am doing.How can I do this, please? URGENT!!
>> 
>> Tina
>> 
>> "'God' brings us into each others lives for a reason and purpose that we may 
>> never know until the end. But every interaction that we have - even if just 
>> a simple smile, is a catalyst for something bigger, with a positive or 
>> negative outcome, so you must be aware of yourself so you can help another 
>> when it is needed." ~SchaOn
>> 
>> 
>> 
>> | I'm trying to do my bit to help the environment and thought you  |
>> | may be interested in taking part? To join the movement on  |
>> | WAYN.com and help make a difference. |
>> 
> 
>> From Vernon Lewis
>> Mobile 0403 090 355
>> The information contained, attached, implied and or otherwise expressed is 
>> without limitations, is private and confidential and privileged.  The 
>> communication is intended for the addressed recipient alone. No forwarding, 
>> copying or publication to unauthorised parties is accepted unless approved 
>> in writing by Teagueplus.com
>> Sent from mobile device.
>> All Rights Reserved Vernon Lewis
>> Copyright © 
> 
> 


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

Re: Images with Text

[James Plante]

Now that you have the page style defined, go to the page *before* the one where 
you want the background image. Choose Insert —> Manual Break… :: Page, then 
select your styled page. That will put your page where you want it.

Jim

> On Mar 23, 2016, at 2:35 PM, Dale Erwin  wrote:
> 
> I can't even find the email now, but the first suggestion I read was to put 
> the image in the background and then type over it, and that seemed to work 
> just fine.  Only problem was that the background was on every page.  So I 
> undid everything, made a new page style for the page with the image.  Now 
> something is happening that I have never experienced before.  When I put the 
> cursor in the page where I want the image to appear and double-click on the 
> page style I created, nothing happens... at least that's what I thought but 
> what happened is that the first page of the document was set to the style and 
> not the page where I wanted the image.
> 
> No matter what page in the document I select, the style gets applied to the 
> first page, and since the Next style is set to the main style, it is the only 
> page with the background image.  I've never seen this behavior before.  What 
> am I doing wrong?  Why doesn't the page style I double-click get applied to 
> the page where the cursor is?
> 
> Dale Erwin
> 
> -
> 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: embeded grahics

[James Plante]

The mailing list strips off attachments, so nothing came through. You’ll have 
to put it on DropBox or some other place and post a link to it. 

What kind of graphics are you imbedding? JPG, PNG, TIFF, or GIF should all be 
visible. SVG or EPS, maybe not. 

Jim

> On Apr 1, 2016, at 8:45 AM, John Caruso  wrote:
> 
> Open this file in OO writer and see if the images show up. Sorry there was no 
> description. Thanks
> 
> 
> -Original Message-
> From: Martin Groenescheij 
> To: users 
> Cc: Martin 
> Sent: Fri, Apr 1, 2016 12:58 am
> Subject: Re: embeded grahics
> 
> 
> 
> On 01-Apr-16 13:29, John Caruso wrote:
> > Why cant i see embedded graphics in an OOwriter document.
> 
> This is the fourth time you raised this question without a description 
> of your problem. All I can suggest is try SpecSavers 
> >
> 
> >
> >
> > -
> > 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: Cut and paste from Word to Open Office Spacing issue.

[James Plante]

…or use Paste Special…. Unformatted text. That will let the style of the 
paragraph into which you’re pasting have control of the pasted text. 

Jim

> On Apr 10, 2016, at 11:16 AM, Rory O'Farrell  wrote:
> 
> On Sun, 10 Apr 2016 08:18:58 -0600
> Terry Rooney  wrote:
> 
>> MS Word single spaced documents when pasted into Open Office Writer are
>> double spaced even though my original spacing is set to single and my Open
>> Office spacing is set to single.
>> 
> 
> Chheck and adjust the settings in the paragraph style used for the pasted 
> text.
> 
> - 
> Rory O'Farrell 
> 
> -
> 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: No me funciona el corrector ortografico del OpenOffice.

[James Plante]

Google Translate understands Spanish just fine. 

> On May 7, 2016, at 9:39 AM, John Caruso  wrote:
> 
> no habla espanol
> 
> 
> 
> 
> 
> 
> -Original Message-
> From: Alberto Rodríguez 
> To: users 
> Sent: Sat, May 7, 2016 8:11 am
> Subject: No me funciona el corrector ortografico del OpenOffice.
> 
> 
> Hola;
> 
> Me he descargado su OpenOffice en Castellano (español) y su paquete de idioma 
> pero no me funciona el corrector ortográfico, ninguna palabra por muy mal que 
> la escriba (ejemplos vurro, vlanco, ombre...) me aparecen señaladas como 
> incorrectas.
> 
> PETICIÓN.
>  a.. ¿Que puedo hacer para solucionar esto? ¿como puedo activar el corrector 
> ortográfico?
> Saludos.
> 
> Alberto Rodríguez usuario


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

Re: Thunderbird

[James Plante]

Jack,
It’s a free download, so just go to 
https://www.mozilla.org/en-US/thunderbird/
and download it. Check the “Features” link at the bottom of that page. Google 
around for tutorials and forums. 

Like any FOSS (Free/Open Source Software) it will have a learning curve. It 
will do things differently from Outlook. I “think" you can set it up as a data 
source in AOO, and use that for your mailing labels. (There are label templates 
out there. You’ll have to look for them.)

Hope this helps.

Jim Plante

> On May 10, 2016, at 11:24 PM, Jack Waters  wrote:
> 
> I use AOO and Office 2007.  I use office word very little, just for certain
> things like address labels, and Outlook.  Can anyone tell me anything about
> Thunderbird, or give me info on a Thunderbird list?  I want to see if I can
> set up my groups and all of my addresses in Thunderbird and stop using
> Outlook.
> 
> 
> 
> C. J. [Jack] Waters
> 
> Police Sergeant, Retired
> 
> Forensic Unit Manager, Retired
> 
> Tampa Police Department
> 
> Insight: "The American Republic will endure, until politicians realize they
> can bribe the people with their own money." -Alexis de Tocqueville
> (1805-1859)
> 
> 
> 


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

Re: bug

[James Plante]

The problem IS the format. That cell is formatted to display mm/yy if it 
appears as you said. You entered 5/18, meaning May 18. The cell is formatted to 
display the month and the two-digit year, therefore it displays the month as 5 
and the year (2016) as 16, since if you don’t enter a year, it presumes the 
current year. That’s how it got to 5/16. The format is not set to display the 
day of the month, so it doesn’t. Try entering 12/24. It’ll come out 12/16 
unless you change the format.

If you can, as you assert, “change the format,” then change it to mm/dd instead 
of mm/yy. If you don’t know how to do that, go RTFM, and come back if you need 
more help.(Hint: Right-click the cell, choose Format Cells… then choose Date, 
and either pick a pre-made format from the list, or format manually.) For 
special formats, you’ll need to RTFM to find out the formatting codes.

Jim Plante

> On May 18, 2016, at 1:29 PM, Ron Patterson  wrote:
> 
> The problem is not the format.  I can change that.  The problem is the 
> numbers that are entered are not the numbers I type in.   5/18 is appearing 
> as 5/16.
> 


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

Re: bug

[James Plante]

Ron, I sincerely apologize for laughing so hard at your confusion. That RTFM 
stands for Read The F’ing Manual, but it can refer to any type of 
documentation. It is a frequent reply given to guys who should know what 
they’re doing in the first place, and should know how to find the answer in the 
second place (in the F’n manual, of course). But that clearly doesn’t apply in 
this case. Nevertheless, RTFM is an instruction to peruse the documentation. In 
this case, I’m referring to the Help file, which can be accessed from the main 
menu bar under “Help.” So click on Help, and select OpenOffice Help in the 
menu. 

Once that window opens, there’s a dropdown field in the upper left corner. Make 
sure that says “OpenOffice Calc,” or whichever program you need help with. 
While you’re there, click the up/down arrow button on the right end of the text 
field and see what other categories of help are offered there. Make sure to put 
“OpenOffice Calc” back in the box before you leave it. 

Below that dropdown field is another box labeled “Search term.” Click in that 
and type “date formats.” Read that selection list carefully: There are two 
different choices for “date formats.” You want the second one. Just 
double-click on it. You’ll find more than you ever wanted to know about them on 
the right side of the window. You’ll find that Right-click, Format Cells… 
dialog offers a LOT of flexibility. But you’ll have to read that Help file page 
in order to know what options are available and how to implement them. 

If you get lost again, please write back. And again, I apologize for making 
light of your confusion.

…but dammit, that was funny.

Regards,

Jim


> On May 18, 2016, at 7:07 PM, Ron Patterson  wrote:
> 
> Thanks Doug,  I searched AOO and could not locate the RTFM.  How might one 
> find this celebrated gift to naifs?
> 
> 
> On 5/18/2016 5:31 PM, Doug wrote:
>> 
>> On 05/18/2016 06:12 PM, Ron Patterson wrote:
>>> Thanks Jim - that makes sense.  But what is RTFM please?
>>> 
>> Read The Fine Manual.  "Fine" is a euphemism.
>> 
>> -
>> 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: Detecting/Counting Cell's Values if data is within a Specific Range of Values

[James Plante]

One way would be to export it to PDF, and send the PDF as an attachment. 

Jim
 
> On May 31, 2016, at 8:15 PM, Vince  wrote:
> 
> Ooops!  Copy from AOO-Calc and Paste to Thunderbird 45.1.0 for the mail list 
> did not go very well (my first attempt) with that array.
> 
> 
> If anyone is interested, is there a suggestion for how I could project the 
> array properly for email list viewing?
> 
> VinceB.
> 
> 
> On 5/31/2016 8:04 PM, Vince wrote:
>> Hi Brian:
>> 
>> I created a play-file that used the array shown below:
>> 
>> 
>>   B CD   
>>   E
>> * */Week #/* */Game #1/* */Game #2 /* */Game #3/*
>> 8
>> 9 1 141 137  
>>135
>> 10   2  97 135   
>>134
>> 113 193   172
>>  138
>> 124 151 185  
>> 125
>> 135 197 127  
>> 186
>> 146 153 138 137
>> 157 158 188  134
>> 168 132 150   132
>> 
>> Your suggested formula (=SUMPRODUCT($D$9:$F$16>100;$D$9:$F$16<129), with a 
>> modified target range, results returned are:
>> 
>> *<100*   *1*
> 
>> *100 thru 129* *2*
>> *130 thru 139* *10*
>> *140 thru 149* *1*
>> *150 thru 159* *3*
>> *160 thru 169* *0*
>> *170 thru 179* *1*
>> *180 thru 189* *3*
>> *190 thru 199* *3*
>> 
> 
> 
> -
> 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: ODT Update

[James Plante]

As Kay Schenk said, use only the official site. DO NOT click on any buttons 
screaming “Download.” The download starts automatically. 

And if you don’t want gremlins, stop enabling them. You’ve published your full 
name, address, email, and telephone number on a worldwide public forum. If you 
get spammed, it isn’t anyone’s fault but your own. Do not do that unless it is 
necessary. If it IS necessary, reveal such information only to an individual by 
private e-mail, not on a public list. (And, if this message seems abrupt and 
peremptory, please construe it simply to be advice. It is not my intention to 
be offensive.)

Jim Plante


> On May 31, 2016, at 10:32 AM, Kay Schenk  wrote:
> 
> 
> On 05/31/2016 07:30 AM, bob jones wrote:
>> I tried twice yesterday to upgrade to your 2016 edition.  Impossible,.  Your 
>> update procedures are clustered with hangers-on.   Some of them attach 
>> themselves to my system during the OO update procedure and once inserted 
>> into the system, are very difficult to delete.  I had to use my desktop 
>> add/remove programmes 3 times on one of the invaders, (image-something or 
>> other before) I finally got rid of it.Another, something that offered to 
>> update my operating system was almost as persistent.
>> I need you to send me a secure link so I can update, but there must be no 
>> unwelcome passengers ; if your update procedure results in my importing a 
>> gremlin I shall hold you responsible. from R.A.Jones 24 Wordsworth Avenue 
>> Worcester WR3 8DN tel 01905 455825 wordsw...@yahoo.co.uk
>> 
> 
> Please ONLY obtain Apache OpenOffice using the download page from our web 
> site:
> 
> http://www.openoffice.org/download/index.html
> 
> and hopefully you will not experience these problems.
> 
> -- 
> 
> MzK
> 
> "Time spent with cats is never wasted."
>   -- Sigmund Freud
> 
> -
> 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: can't open 2 programs at once

[James Plante]

> On Jun 6, 2016, at 1:35 PM, jd1008  wrote:
> 
> 1. You misquote who wrote the statement. Why do you keep doing that? John 
> Donly did not post it. I did.
That’s his mail client’s doing, not Brian’s. It’s saying that [“J” only “D” 
only] wrote the post. Your initials. Get it? 
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: can't open 2 programs at once

[James Plante]

> On Jun 6, 2016, at 1:55 PM, jd1008  wrote:
> 
> 
> 
> On 06/06/2016 12:45 PM, James Plante wrote:
>>> On Jun 6, 2016, at 1:35 PM, jd1008  wrote:
>>> 
>>> 1. You misquote who wrote the statement. Why do you keep doing that? John 
>>> Donly did not post it. I did.
>> That’s his mail client’s doing, not Brian’s. It’s saying that [“J” only “D” 
>> only] wrote the post. Your initials. Get it?
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>> 
>> 
> Is the list server doing this?
> It is annoying.
> 
No, it’s probably his mail client’s way of referencing e-mails. There’s likely 
nothing that can be done about it other than you changing your email name.
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Quick Question

[James Plante]

You can’t. 

But you should be able to copy the contents (Edit->Select all; Edit->copy) and 
paste the contents into a new text document. 
Note: I haven’t tested this, but I don’t believe protection extends to the 
copy. 

> On Jun 24, 2016, at 3:35 AM, Rory O'Farrell  wrote:
> 
> On Fri, 24 Jun 2016 02:57:55 -0400
> Brandi Wingard  wrote:
> 
>> Hi!
>> 
>> I have been trying for over five years to access a file I created and put a
>> password protected lock on.
>> I can no longer remember the password I used to lock the file, so I cannot
>> get into it. Is there any way you guys could help me unlock it or access
>> what is in it again? It would mean the world to me. It's an important
>> document to me that I would hate to completely lose.
>> 
>> Thanks in advance!
>> --Brandi Wingard
> 
> There is effectively no way to break an OpenOffice password except by using 
> brute force, which may (depending on computer speed) tie up your computer for 
> days or longer.
> 
> -- 
> Rory O'Farrell 
> 
> -
> 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: Quick Question

[James Plante]

Yep, that would be a problem. I was thinking that if it were protected from 
editing, copy-paste would be a workaround. 
But if the doc is protected from opening at all, that won’t work.

Jim

> On Jun 24, 2016, at 8:16 AM, James Knott  wrote:
> 
> On 06/24/2016 08:53 AM, James Plante wrote:
>> But you should be able to copy the contents (Edit->Select all; Edit->copy) 
>> and paste the contents into a new text document. 
>> Note: I haven’t tested this, but I don’t believe protection extends to the 
>> copy. 
> 
> Ummm...  If he can't get into the file at all, what's he supposed to cut
> 'n paste?
> 
> 
> -
> 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: QUESTION == how to I open a new document

[James Plante]

> On Jul 14, 2016, at 9:05 AM, petma...@bigpond.com wrote:
> 
> To whom can “help”
> 
> I have just upgraded and down loaded Open Office 4.1.1 but cannot load a new 
> document or excel – can you advise me please where to find these – otherwise 
> editing existing documents a excel files works well and it is good to have 
> the spell check back.
> 
> thanks
> 
> Peter Martin
To open a NEW document, use File -> New…; from the dropdown, select Text 
document, spreadsheet, drawing, etc., as you require. 


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

Re: Spreadsheet - extra sheets in preview

[James Plante]

Try redefining your print area.

Jim Plante

> On Jul 28, 2016, at 8:58 PM, Moises  wrote:
> 
> 
> I am working on a huge financial report and I copy and pasted a table I had 
> onto the other pages and so far I have 6 pages but all of a sudden I have 7 
> extra pages instead of the original 1 page
> 
> Is there a way I can remove these extra pages?
> Sent from my iPhone
> -
> 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: How to open zipped file

[James Plante]

kazuko, change the file extension to .zip, and the unzip utility will work. At 
present, the file extension is probably .odt; just change that to .zip, and you 
can open it with the unzip utility. 

Jim Plante
> On Jul 31, 2016, at 3:24 AM, kazuko  wrote:
> 
> Hi
> My open office documents were sent to iCloud Drive iPad from PC Windows 10.
> But I had no idea these files are zipped. I installed app for unzip but these 
> couldn't adjust open office files. Please help me how to unzip my files.
> 
> Kazuko
> 
> 
> iPhoneから送信
> -
> 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: Email format.

[James Plante]

He said “each sentence.” If he meant “each line,” as I suspect, then it’s 
likely because every line ends with a CRLF, so the next line obviously starts a 
new paragraph, in which the initial letter is capitalized, as it should be. 

Nikoli, for an e-mail client, you can try Thunderbird. Many folks use this free 
software. I don’t so I cannot talk about its features. Get it free at 
https://www.mozilla.org/en-US/thunderbird/
Load it up and try it out. If you don’t like it, just remove it.

Now, just what are you trying to do with that book? Your post implies that 
you’re trying to open it in an e-mail client? Or are you trying to open it in 
OpenOffice? If the latter, I think you’re opening it in read-only mode. So open 
it, select all, copy that text, and paste it into a new text document. You 
should be able to edit that one. Save it before you start working on it though.

If that doesn’t work, the write back some more. That “initial cap” problem is 
easy to solve if you know about regular expressions, so don’t try to do it by 
hand. You’re using a word processor, not a typewriter, so let the word 
processor determine where to end the lines; you just type until you get to the 
end of a paragraph (not a line), THEN hit the return key. 

Jim Plante

> On Aug 7, 2016, at 6:08 AM, Maurice Howe  wrote:
> 
> I think Nikoli meant "each LINE" (not each SENTENCE).
> 
> On Sun, Aug 7, 2016 at 7:04 AM, James Knott  wrote:
> 
>> On 08/06/2016 07:19 PM, Nikoli A. McCracken wrote:
>>> The first letter of every sentence in an article or email, is Initial
>> cap!
>>> Who the hey writes like that anymore?
>> 
>> Only those who respect the reader.
>> 
>>> Didn’t that go away along about Shakespeare’s time? I went to Msoft Tech
>> support, and they blandly said
>>> There was no way to change it!
>> 
>> On this point, you're wrong.  A sentence always starts with a capital.
>> Reading text that does not have capitals is very irritating to the point
>> I often don't bother.
>> 
>> Sentence structure, grammar and correct spelling are all there to make
>> it easier to understand what is being said.  The current situation,
>> where those are so often ignored, shows the sad state of behaviour or
>> even education these days.
>> 
>> 
>> -
>> 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: saving certain pages to a document

[James Plante]

Or perhaps…
Create new doc.
From styles menu: load styles
From the dialog that results, check the “From file” box.
Select your original file from the dialog that results;
Choose the parameters from the import dialog;
Import. 

Anyway, that’s the way I do it. I don’t like the “Select everything and delete 
it” option, because I did that once. Screwed up and chose to save the file. It 
did what I told it, and saved an empty doc over my finished report. 
Fortunately, I use a Mac with a Time Machine backup, so I didn’t lose it all. 
But it was--at least momentarily--a heart-stopper. 

Jim

> On Aug 14, 2016, at 3:43 AM, Felmon Davis  wrote:
> 
> On Sun, 14 Aug 2016, Martin Groenescheij wrote:
> 
>> 
>> 
>> On 14/08/16 2:47 AM, Rory O'Farrell wrote:
>>> On Sat, 13 Aug 2016 12:33:37 -0400 (EDT)
>>> Felmon Davis  wrote:
 greets!
 I suspect it's not possible without attempting a macro but:
 is it possible to save say pages 10 to 20 of a document to a file?
 I know one can export selected pages to a pdf but I'd like to 'export'
 selected pages to odt or, preferably, to doc.
 basically 'save as' but get to choose the pages.
 f.
 -- 
 Felmon Davis
 Reporter:   "How did you like school when you were growing up, Yogi?"
 Yogi Berra: "Closed."
 
>>>  On the rare occasions I need to do this I use one of two approaches.  I 
>>> either Save the file under a new name, then delete the earlier and later 
>>> pages to leave only what I require, or I select and Copy the pages 
>>> required, pasting them into a new file.
>> Alternative is to copy the .odt file and delete the content of the copied 
>> file. save this under a new name. Now you have at least an empty document 
>> with all Styles as in your original file. Everything you copy now from your 
>> original documents should have at least the Styles preserved.
> 
> forgot about this way of doing it (preserving formatting); may have had mixed 
> success with it in the past also.
> 
> I'll remember it the next occasion.
> 
> I suppose I could also build a template.
> 
> f.
> 
> -- 
> Felmon Davis
> 
> "Success covers a multitude of blunders."
>   -- George Bernard Shaw
> 
> -
> 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: Installing the latest upgrade on my Mac.

[James Plante]

Google “Gatekeeper on Mac”. It’s a security feature.

> On Aug 15, 2016, at 9:53 AM, Geraint Pugh  wrote:
> 
> Can’t get the “install anyway” button to work when I get the message that you 
> are an unidentified source.
> 
> Geraint Pugh.
> -
> 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: Opening docs on laptop win 10 from win XP on old computer

[James Plante]

The .wps file was produced by Microsoft Works, and to my knowledge, only Works 
will open it. If you can find a copy somewhere, open it and save as .txt or 
.rtf in order to be able to save the content. The formatting will be mostly 
lost, but you’ll have the content that can be opened by AOO; then you can 
reformat it if desired.

Jim

> On Sep 21, 2016, at 9:15 AM, danwade2...@comcast.net wrote:
> 
> Don't seem to have a problem opening spreadsheets from win XP.
>  
> Have not been able to open wordprocessing docs...XP doc has .wps and after 
> copying to flash drive and trying to open on laptop the .wps changes to 
> Window Media Player and doc will not open.
>  
> Am I not following the right path?
>  
> 

Re: Problem with Sort in Calc

[James Plante]

No, it is not true.

Let’s assume for this example that your spreadsheet has six columns: Name, 
Address, City, State, Zip, Phone

We want to sort this list by City, so do this:

Select the top left cell in your table. In our example, it is cell A1. 
Next, select Data->Sort…
This should select all cells within the table. A dialog box will appear. At the 
top of the dialog, you are given two tabs: Sort criteria, and Options. Select 
options.
Select the options you want, but [**important**] make sure to check “Range 
contains column labels”. When you’ve finished selecting, clic on Sort criteria 
again. 
This time you should see “Sort by: Name” on the first line. Click on the 
disclosure triangle at the end of the “Sort by” field.
Select City instead.
Click OK.

The list is now sorted.

A warning: If you simply select the City column and sort it, only that column 
will be sorted, and your data will be mixed up. If that happens by accident, 
you should immediately select Edit->Undo. The whole table must be selected in 
order to sort all the rows of all the columns. 

Jim

> On Oct 6, 2016, at 10:59 AM, Vince%Gmail  wrote:
> 
> Windows 10, desktop,
> 
> AOO412m3(Build:9782)  -  Rev. 1709696
> 2015-10-21 09:53:29 (Mi, 21 Okt 2015)
> 
> 
> When sorting data in AOO Calc, must the "key" text  data be located in the 
> leftmost column? It seems that it is so.
> 
> 
> Regards,
> 
> VinceB.
> 
> 
> 
> -
> 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: New Open Office Apache program

[James Plante]

The problem you encountered was with Gatekeeper. It prevents you from running 
software obtained from sources that Apple doesn’t know about, hence they’re 
judged to be untrustworthy. 

So to get AOO to launch, open System Preferences, and select Security & 
Privacy. Under the General tab, you’ll see in the bottom half of the window 
“Allow apps downloaded from:” with the choices being “App Store” and “App Store 
and identified developers.” 

Underneath that choice, you should see a notice to the effect that Gatekeeper 
blocked AOO from opening, and gives you a button labeled “Open Anyway.”

But before you can click that button, go to the lower left corner and click the 
little lock icon, then enter your administrator’s password. You can now make 
changes to the system. Click the “Open Anyway” button. AOO will launch. 

You can sell all your Mac stuff if you want, but you’ll be shooting yourself in 
the foot if you do. Most problems have solutions. Many solutions require a 
limited amount of work and/or study. If you go with Windows stuff, you’ll have 
a lot of problems, but there are lots of people who’ll give you solutions. You 
will come to know them well. If you go with Linux, you’ll have to do a lot more 
studying, and learn some new cuss words. But it works, and it’s not Apple.

Good luck to you.  BTW, what are you asking for the new Mac Pro?

Jim

> On Oct 14, 2016, at 10:27 PM, Jim Driscoll  wrote:
> 
> Dear Sir,
> 
> I have a new Apple Mac Pro computer. I previously had to get special 
> permission from Apple to open your old Open Office program. I made a 
> permanent change to my Apple computer to access other down loaded programs.
> 
> Now Apple in their updates has changed my computer back to no new programs 
> unless approved by Apple. 
> 
> I downloaded your new Open Office Apache updated program and you made it seem 
> so simple, like Apple would give me no problems. Apple again shut your 
> program down. Now I have no access to my documents. 
> 
> I need help. This time Apple will not help. 
> 
> Any recommendations on computers because I am selling all my Apple iPhones, 
> my 2 MacPros and various other Apple devices. Apple dumped 236 of my CD 
> downloaded songs in a transfer from iPhone 5 to iPhone 6s. They did this 
> transfer at the store with no backup. So it was Apples software that dumped 
> the songs. Apple can now be described as Sub Rosa Crooks.
> 
> Jim Driscoll
> jimdriscol...@gmail.com
> 971-678-1905
> 
> 
> -
> 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: New Open Office Apache program

[James Plante]

> On Oct 15, 2016, at 11:27 AM, chuck ef  wrote:
> 
> My word, 4.1.3 opens quickly now. 4.1.2 was such a slug for some reason.

You’re right! I downloaded yesterday, and just now started 4.1.3 to check Jim 
Driscoll’s problem. After quitting, that program reloads in a flash on this 
iMac. 

Thanks for the tip,

Jim

Re: New Open Office Apache program

[James Plante]

Andrea,
The release note refers to an article in the Apple Knowledge Base that was 
written for systems up to and including El Capitain (MacOS 10.11). In Sierra 
(MacOS 10.12) the procedure is as I described and as chuck ef expanded on, 
i.e., how to kill Gatekeeper permanently (not recommended). 

What I posted is current, and was taken point-by-point as I installed AOO on my 
iMac and Sierra. 

You may copy and edit my post and use it to amend the release notes if you like.

Regards,
Jim

> On Oct 15, 2016, at 3:22 PM, Andrea Pescetti  wrote:
> 
> Andrea Pescetti wrote:
>> James Plante wrote:
>>> The problem you encountered was with Gatekeeper. It prevents you from
>>> running software obtained from sources that Apple doesn’t know about,
>>> hence they’re judged to be untrustworthy.
>>> So to get AOO to launch, open System Preferences, and select Security
>>> & Privacy. Under the General tab, you’ll see in the bottom half of the
>>> window “Allow apps downloaded from:” with the choices being “App
>>> Store” and “App Store and identified developers.”
>>> Underneath that choice, you should see a notice to the effect that
>>> Gatekeeper blocked AOO from opening, and gives you a button labeled
>>> “Open Anyway.”
>>> But before you can click that button, go to the lower left corner and
>>> click the little lock icon, then enter your administrator’s password.
>>> You can now make changes to the system. Click the “Open Anyway”
>>> button. AOO will launch.
>> 
>> Is this better or more current than what we have now in the OpenOffice
>> 4.1.3 Release Notes? Our instructions have been the same for a few
>> years, and if the new Mac OS X Sierra adopted another approach they
>> might need some updates.
> 
> To be clear, I refer to the first bullet point here:
> 
> https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+4.1.3+Release+Notes#AOO4.1.3ReleaseNotes-KnownIssues
>  
> <https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+4.1.3+Release+Notes#AOO4.1.3ReleaseNotes-KnownIssues>
> 
> Regards,
>  Andrea.
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org 
> <mailto:users-unsubscr...@openoffice.apache.org>
> For additional commands, e-mail: users-h...@openoffice.apache.org 
> <mailto:users-h...@openoffice.apache.org>

Re: Writing Templates

[James Plante]

Tracey,
My advice is to make your own. Find a resumé that looks good to you, and 
duplicate it. Save it as Resume.ott. 
Articles’ formats are going to depend on the guidelines of whoever publishes 
them. Obtain a format example, and duplicate it. 
Poetry? Pretty much open; you can get away with just about anything in the name 
of artistic license. So make a template that is pleasing to you. 
I didn’t know there was any specific format for a biography. Did you mean 
“bibliography” by chance?
If so, those are pretty much governed by whatever publisher is going to handle 
the main article. Some want Chicago Manual of Style, others Turabian, and it 
can vary all over the spectrum. Again, create your own .ott’s for the ones you 
may frequently use. 

Jim

> On Nov 2, 2016, at 1:33 PM, Tracey Salgado  wrote:
> 
> Hello, I was wondering, what are the  best templates for general writing, 
> such as resumes, biographies, articles, poetry and things of that nature? I 
> really appreciate your help on this!
> Best,
> Dorianne
> 
> Sent from Mail for Windows 10
> 


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

Re: Writing Templates

[James Plante]

Jonathon,
Of course it depends on what the template does. But at some point, it stops 
being a template and becomes a specialized program. Project management is a 
good example, too. Just as some people try to keep all the books of a small (or 
even a medium) business in Excel when they should be using a dedicated database 
and a good double-entry bookkeeping system like e.g. GnuCash, I’m sure some 
will try to manage a project with inappropriate software too. 

And I understand and appreciate your reference to high-priced templates. I’ve 
constructed a template to duplicate a two-page government form that 
self-calculates and shows/hides conditional text. It was tedious to construct, 
and required a bunch of sanding and polishing before it was ready to use. Then 
the government changed the !$@^&*&! form to a six-pager.  I revised it with a 
modest amount of Anglo-Saxon expressions that I learned from early exposure to 
Chaucer. Most users of AOO can’t do that (or perhaps, "are smart enough *not* 
to do that” would be a better way to put it.)

My reply referred to those quickie tasks, like a personal or business letter; 
an invoice; an article for the local paper; or maybe a personal essay. A 
template helps you get started quickly before your lose that spark of 
inspiration. It should also provide enough final polish that it can be 
submitted for publication and subsequently saved in the archive of rejected 
articles….errr…personal essays. For these, “make your own” is the way I’d go. I 
would also advise saving the .ott that you create into AOO’s template system 
(File -> Templates -> Save…), and then save a copy in a separate folder (Save 
as… [ODF Text Document Template (.ott)]) so you can tinker with it and not mess 
up your primary template. 

Jim


> On Nov 3, 2016, at 2:09 AM, toki  wrote:
> 
> On 02/11/2016 18:58, James Plante wrote:
> 
>> My advice is to make your own. 
> 
> That really depends upon what the template does.
> 
> The typical MSO Template with an MSRP in the US$400 price range, whilst
> creatable by power users, is usually both awkward and tedious to
> construct. Those in the US$10,000 price range are usually beyond the
> territory occupied by power users. Between those two price points,
> things are iffy, but tend towards requiring specialists to construct,
> and power users to utilize.
> 
> On the flipside, it is much easier to download templates for Project
> Management, than it is to construct them from scratch.
> 
> jonathon
> 
> 
> 


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

Re: From Howard Goldfarb

[James Plante]

Howard,
With a spreadsheet open, select View -> Toolbars, then select the Drawing 
toolbar.
You’ll have yet another toolbar to look at. From the Drawing toolbar, select 
the Block Arrow choice, then click and drag in the spreadsheet. The block arrow 
will appear. It has handles, and you can drag it to where it is needed. 

Note that while the arrow is selected, the choices in the top toolbar change. 
You can change the color of the arrow, among other things. As soon as you click 
in a spreadsheet cell, though, it goes away.  

Jim



> On Nov 3, 2016, at 4:17 AM, howard  wrote:
> 
> Dear Sir/Madam;
> 
> I have been trying, without success, to find on the many, many toolbars
> solid pointed arrows to incorporate into a spreadsheet. Please assist as I
> have become totally frustrated; thank-you.
> 
> Yours truly,
> 
> Howard Goldfarb
> 
> 
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> 
> 
> -
> 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: administrator authorisation

[James Plante]

John Jones,
I don’t use Windows, so my capacity to help is going to be limited. However, 
here are some thoughts:
In order for your to change the admin password, you have to know the current 
admin password. 
It is possible that the installer did not change the admin password from the 
default, if there is one. 
It is also possible that he used the prior password.
If you don’t know the current admin password, you’re really shooting blind. You 
can try some of the more common “default” passwords. 
If not, then try “PASSWORD”; “password”; “ADMIN”; “admin”; or permutations of 
those concatenated with the year, e.g., “admin2016”. 

Just don’t try more than about five per hour; Windows should warn you when the 
number of password attempts is approaching its limit. Not being a Windows user, 
I don’t know much more than that. 

Good luck,

Jim



> On Nov 7, 2016, at 1:21 AM, Martin Groenescheij  
> wrote:
> 
> 
> 
> On 07/11/16 2:06 PM, John Jones wrote:
>> John F. Jones
>> Auckland
>> New Zealand
>> 
>> Apache Open Office was installed on my laptop by the computer professional 
>> who installed Windows 10. He is now in Australia and I have lost contact 
>> with him so cannot ask him what the administrator password is so I can’t 
>> update my Open Office. What is the procedure for changing the password so I 
>> can be authorized to update Open Office on my laptop?
> 
> This is a Windows Administrator problem and hos nothing do do with OpenOffice.
> 
>> 
>> Regards,
>> 
>> John F. Jones.
>> 
>> Sent from Mail for Windows 10
>> 
> 
> 
> -
> 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: help with rand() function

[James Plante]

Felix, 
You would do better asking this on the Developer’s list rather than here on the 
user’s list. Most of us here wouldn’t know a Mersenne Twister from Boston baked 
beans. Another possibility: Download the source code and look for it yourself.

Jim Plante

> On Nov 20, 2016, at 4:34 PM, Felix R.  wrote:
> 
> Hello, I would like know about the period of the rand() function, I have
> searched  in the forum but I have not found anything in the matter.
> 
> I suspect that there can be an implementation of the  Mersenne Twister
> generator, but i'm not sure.
> 
> I hope you may help me, regards.
> 
> Felix Ramirez


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

Re: AOO-Templates

[James Plante]

Has it occurred to anybody else here that envelopes are just a “page style?” 
In fact, it’s already a built-in choice in AOO 4.1.3. 
So load one up in a new document. Fill in return address, and the primary 
address. Add an “ATTN:” line if it suits you. Put XXXs in the first line and 
last available line on the “envelope”, and print it on a blank sheet of A4 or 
Letter size paper. Do things fit? OK, try an real envelope. Did it work? Great! 
Do File -> Templates…::Save. Now you’ve got a rudimentary envelope template. 

But play around with it. For business matters, you may like to include fields 
for the addressee, address, address2, City, State, Zip/Postal Code. These can 
be either User Defined fields, or they can be fields that you’ve dragged and 
dropped from your contacts database. This latter one is cool, because you 
simply View Data Sources, select your contacts data, and drag the column 
headers into the proper places on the envelope template. Then when you select, 
say Henrik Schultz, his info is propagated to all data fields in the template. 
(And you spell his name correctly, instead of Heinrich like you usually do.) 
Got those fields placed? Good. File -> Templates…::Save. Overwrite the 
rudimentary one. Now you’ve got a working template. 

You can probably figure the rest out from here, but what you have so far will 
work. Remember that in AOO, styles are everything. 

Jim
 
> On Nov 25, 2016, at 4:13 PM, Julian Thomas  wrote:
> 
> 
>> On Oct 9, 2016, at 15:24, Brian Barker  wrote:
>> 
>> Google's cache of a similar address to the one you give leads to
>> http://templates.openoffice.org/template/download/39885 , which is probably 
>> what you need. But note that this appears to be a template for printing on a 
>> Letter-size sheet of plain paper, which you can then fold and glue into a C6 
>> envelope with some parts already printed - which may not be what you need. 
>> If you need a template for printing a recipient's address and perhaps your 
>> return address on an existing C6 envelope, you can probably create one 
>> yourself from scratch very easily.
> 
> This may well work for envelopes depending on how your printer feeds them.  
> My envelope templates are for letter size paper - landscape - with margins 
> set to the envelope area.  Mine feeds in the center but an earlier printer 
> fed the envelope on the left. 
> 
> —
> jt - j...@jt-mj.net
> 
> If numbers aren't beautiful, I don't know what is. - Paul Erdős 
> 
> 
> 
> 
> 
> -
> 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: Libre Office

[James Plante]

I have both LO and AO, as well as NeoOffice for the Mac. Overall, I like Neo 
better  because its solo developer tends to business as quick as possible. And 
it’s a dandy program. Defects? Sure! But as I said, critical flaws are dealt 
with promptly. (And not that Neo is not free; Costs $30 or so on the App 
store.) Most of the stuff I can do in Neo can also be done in AO and LO, but I 
like Neo because of its Aqua (native) interface to the Mac. Fonts look better, 
as to icons and other things. But they appear to be functionally the same. 

Thought I’d add to your comments a little:
> On Feb 6, 2017, at 2:42 PM, Girvin Herr  wrote:
> 
> 1. AOO may not be as feature-rich (some would call it feature bloat) as
>   LO, but what features are there seem to be a bit more stable than
>   LO.  This is more of a feeling than a hard fact and I cannot point
>   to any specific feature that supports it.
> 
> 2. AOO does not include a database report generator, which is crucial
>   to my work.  You can create the database, but there is no way in AOO
>   to print it out nicely.  LO does include a report generator and it
>   works fine.
Are you sure it needs a report generator? Can you not open your database as a 
data source in Writer to produce reports? A report is really just a big, 
complex form letter. 
> 
> 3. LO does not restore a session properly, where AOO does.
>   I like to keep several oft-used files open all the time.  I do not
>   close these files before I shut down.  I expect these files to be
>   reopened at startup the next time I use the system, so I don't have
>   to manually open them all.  AOO does this properly. LO, from version
>   4.x on, does not.
Thank you, Girvin. You just gave me a useful idea. 

Jim Plante

Re: Libre Office

[James Plante]

@Girvin,
The important thing is to get the work done; the tool is secondary. I agree 
with your decision, and you are correct: I once used NeoOffice to construct an 
entire six-page form (FNMA1004) for real estate appraisals that has a couple of 
hundred blanks to fill and boxes to check, one page with an imbedded 
spreadsheet. It worked fine, blood loss was manageable and the scars are almost 
invisible now :-)

@Julian,
I thought about using that iWork suite, and I have it. About all the activity 
it gets is regular updates in the background. The problem is that I write 
appraisal reports that run 100-200 pages long. They’re heavily 
cross-referenced, which can be done with ease in AOO and LO, but not easily if 
at all in Pages. The rest would work OK, but Pages lacks user fields, so when I 
type something that appears at several places in the report (e.g., report 
date), I type that one time and it propagates to the other fields in the 
report. Clients aren’t ever satisfied, and always want this or that included or 
left out, necessitating a change in report date. In Neo, I just enter the new 
date and I *know* it’s changed properly in all the places it is used. 

The user field issue might be worked around by dropping in single cells from a 
spreadsheet, but like Girvin, I have a work flow that I’m happy with and would 
be loath to change. 

Jim Plante

> On Feb 6, 2017, at 4:50 PM, Girvin Herr  wrote:
> 
> 
> 
> On 02/06/2017 01:56 PM, James Plante wrote:
>> On Feb 6, 2017, at 2:42 PM, Girvin Herr > <mailto:ghe...@fastmail.com>> wrote
>>> 
>>> 2. AOO does not include a database report generator, which is crucial
>>>  to my work.  You can create the database, but there is no way in AOO
>>>  to print it out nicely.  LO does include a report generator and it
>>>  works fine.
>> Are you sure it needs a report generator? Can you not open your database as 
>> a data source in Writer to produce reports? A report is really just a big, 
>> complex form letter.
> Jim,
> Umm.  I guess I will have to amend my "no way" to "no easy way". The report 
> generator does use either Writer or Calc to do the formatting/printing.  
> However, I have spent a good amount of time formatting my reports the way I 
> want them.  To throw that out and start over is not acceptable.  It is much 
> easier to use LO when I need to print a report.  I think I tried manually 
> using writer for a report once and the results were not pretty.  I admit I am 
> not experienced in this process but it seems it would take a lot of recurring 
> work to format the data in Writer for each table, of which I have many, and 
> each update, which are ongoing.  The Report Generator just makes it so much 
> easier.  It is like a wizard for the data. Would you like to use writer to 
> create and maintain your forms?  You can, but that doesn't mean you should, 
> unless you are into pain.
>>> 
>>> 3. LO does not restore a session properly, where AOO does.
>>>  I like to keep several oft-used files open all the time.  I do not
>>>  close these files before I shut down.  I expect these files to be
>>>  reopened at startup the next time I use the system, so I don't have
>>>  to manually open them all.  AOO does this properly. LO, from version
>>>  4.x on, does not.
>> Thank you, Girvin. You just gave me a useful idea.
>> 
>> Jim Plante
> You're welcome.
> Girvin
> 


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

Re: Libre Office

[James Plante]

Apparently not, Jonathon. Going to NeoWiki.neooffice.org 
<http://neowiki.neooffice.org/>, I find this at the bottom of the page:

If you purchased and installed NeoOffice 2015 
<http://neowiki.neooffice.org/index.php/El_Capitan_and_Sierra_Upgrade_Issues#Problems_after_upgrading_to_El_Capitan_or_Sierra.3F>
 and you find a bug, send us an e-mail 
<mailto:elcapitansierrab...@neooffice.org>. Please include any screen snapshots 
<https://support.apple.com/HT201361> that might help us see what you see on 
your computer.

The page was last updated 1/22/2017, and NeoOffice is still being maintained on 
the App Store.

Now, I have no idea what Patrick Luby has been up to. A few years back, I 
foolishly installed a new update to Neo while I was in the middle of a 
sixty-page report that had numerous photos imbedded. When I took a certain 
action (I don’t remember what it was) all the photos squished onto the last 
page and had to be redistributed through the text. I sent Patrick a bug report 
and the document. Ninety minutes later, he had a trial fix for me that worked. 
That’s pretty good tech support. 

Moving forward in time, he started charging $100/year for tech support, and I 
quit going to the trinity forum more than a couple of times a year. You 
couldn’t post or comment unless you were paid up. Now I see that help is in a 
Wiki, and bug fixes are available through that e-mail link above, but no charge 
for bug fixes appears in the pages; maybe he’s back to doing it for free, and 
is relying on the App Store version to produce enough income to support this. I 
just don’t know. 

How-to’s and other user support? We’re it, along with the OOo forum. Which is, 
I suppose, as it should be. 

Jim Plante

> On Feb 8, 2017, at 6:29 AM, toki  wrote:
> 
> On 02/06/2017 09:56 PM, James Plante wrote:
>> Overall, I like Neo better  because its solo developer tends to business as 
>> quick as possible. 
> 
> I was under the impression that the developor had pretty much closed up
> shop. The last time I went poking around that site, I didn't see any
> indicators of paid support being available.
> 
> jonathon
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 

Re: Is there a MAC version available. If so please fwd. me a link to it. THANKS.

[James Plante]

There’s a mac version called NeoOffice available on the App store. It uses the 
AOO code base. However, this one costs about $30 last time I looked. I use it 
all the time for 200-page reports that are heavy in graphics and 
cross-referenced. 

Jim

> On Mar 4, 2017, at 6:29 AM, chuck ef  wrote:
> 
> There is a macOS version- you will see it at the Apache OO download page. I 
> use it all the time. 
> 
> Sent from my iPhone
> 
>> On Mar 4, 2017, at 3:45 AM, Paul Hughes  wrote:
>> 
>> 
>> 
>> ---
>> This email message is for the sole use of the intended recipient(s) and may 
>> contain
>> confidential information.  Any unauthorized review, use, disclosure or 
>> distribution
>> is prohibited.  If you are not the intended recipient, please contact the 
>> sender by
>> reply email and destroy all copies of the original message.
>> ---
> 
> -
> 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: Determine Five Best Scores

[James Plante]

@Brian: Thank you! I had not seen that function in use before.

@Vince: Take a look in the Help file for another explanation of the LARGE() and 
SMALL() functions. Since you’re keeping track of bowling scores, you might also 
want to take a look at the RANK() function. From your posts, I’m thinking it 
may come in handy later on.

Jim Plante

> On Mar 8, 2017, at 3:30 AM, Brian Barker  wrote:
> 
> At 21:39 07/03/2017 -0500, Vince Bonly wrote:
>> Can someone offer assistance to me to solve a problem, using AOO 4.1.3-CALC 
>> ? I have typically 8 or 9 players in a bowling group ...
> 
> You'll forgive my giggling, but it always amuses me when people write an 
> essay on their life (but which may still not exactly specify the problem) 
> instead of paring their problem down to what they really need!
> 
>> I need to determine the five highest scores from the group of 8 players 
>> after each player finished 3 games of bowling. Is there a function that 
>> would allow determination and display of the five highest scores when 
>> considering 8x3=24 scores ?
> 
> So you need five results from twenty-four values - not the nine you have 
> shown in your example (or fifteen if we extend the idea)?
> 
> Are your values in C3 to E10?
> 
> For your five results, use
> =LARGE(C3:E10;1)
> =LARGE(C3:E10;2)
> =LARGE(C3:E10;3)
> =LARGE(C3:E10;4)
> =LARGE(C3:E10;5)
> 
> Even simpler (and more reliably), if you want these values in a column, start 
> with
> =LARGE(C$3:E$10;ROW()-n)
> - where "n" is a suitable value (depending on the row you choose for this top 
> value result) so that ROW()-n gives the result 1. Then fill this formula down 
> the five cells.
> 
> Note that this technique copes with duplicate values, so if there are two 
> equal third highest scores, say, both will appear in your list. I'm guessing 
> that this is what you will want.
> 
> 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
> 


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

Re: contact me to help me with apache open office

[James Plante]

> On Mar 10, 2017, at 1:30 AM, Martin Groenescheij  
> wrote:
> 
> 
> 
> On 10/03/17 3:48 PM, Gene Riddell wrote:
>> my open office is no longer working properly. i cannot force/quit it. i can 
>> be reached after 5pm friday eastern standard time. 7277299749.
> 
> 5 pm in Australia is probably mid night somewhere else, so it would be wise 
> to tell us what Time Zone you are in.
Errr, he did: eastern standard time. That, and the 10-digit phone number, puts 
him on the east coast of the US. Just FYI, the US has four time zones on the 
continent: Eastern, Central, Mountain, and Pacific. I’m sure Australia must 
have at least that many. 

> And if I call 7277299749 in Australia (where I live) I probably get someone 
> on the phone that doesn't know what I'm talking about.
If you get anybody at all, he probably won’t. Does Australia have ten-digit 
phone numbers? 

@Gene Riddell
What type of computer and what operating system are you using? Which version of 
AOO? 




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

Re: Cannot open a file.

[James Plante]

Kevin, 
Rory is usually right about things like this, but there’s one trick you might 
try. Find that ODT file in Windows Explorer (or the Finder if on a Mac). Change 
the file extension from .odt to .zip, and unzip the file. Open the one named 
“content”. It will have all the text in it, but none of the formatting. Copy 
and paste this to a new document and save it under a filename that’s different 
from your original file’s name. Reformat it at your leisure.

Jim Plante

> On Mar 26, 2017, at 2:05 AM, Rory O'Farrell  wrote:
> 
> On Sat, 25 Mar 2017 21:30:25 -0700
> Kevin Brown  wrote:
> 
>> I have been using Open Office for a few years and I really enjoy this 
>> program. I have a problem with a certain file I can no longer open, when I 
>> attempt to do so it comes up with all my text being # hashtags and can’t fix 
>> the problem. When the file is clicked it brings up a bar that says ASCII 
>> Filter Options then gives you some options such as Character Set, Default 
>> fonts, language and something at the bottom that says paragraph break which 
>> you can click that says CR & LF, or Cr or LF by itself. I have tried to 
>> operate these options but nothing is working. I just want to get my file 
>> back to working, please let me know something as soon as possible, it will 
>> be greatly appreciated. 
>>  
>>~Kevin Brown
>> 
>> Sent from Mail for Windows 10
>> 
> 
> The display of ### and the ASCII filter message indicates that OpenOffice 
> does not now understand the structure of the file.  Unfortunately, this 
> indicates your file is damaged, most probably beyond repair.  If you have a 
> backup, you should revert to this.  
> 
> https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=84056
> 
> This damage may have happened because of a system or program crash, or 
> because of over-hasty powering off of the computer before the internal 
> house-keeping had completed and the hardware/software write buffers had 
> flushed to disk.
> -- 
> Rory O'Farrell 
> 
> -
> 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: Cannot open a file.

[James Plante]

Won’t cost a damn thing to try, will it?

> On Mar 26, 2017, at 12:16 PM, Brian Barker  wrote:
> 
> At 10:52 26/03/2017 -0500, James Plante wrote:
>> Rory is usually right about things like this, ...
> 
> Perhaps more often than you think.
> 
>> ... but there's one trick you might try. Find that ODT file in Windows 
>> Explorer (or the Finder if on a Mac). Change the file extension from .odt to 
>> .zip, and unzip the file. Open the one named "content". It will have all the 
>> text in it, but none of the formatting.
> 
> Hold on: it has the text but also the formatting - as an XML file. You'd need 
> appropriate software (or a lot of effort) to strip out just the text.
> 
> In any case, when - as here - the user sees nothing but hash marks, the 
> operating system is delivering an empty sector or sectors in place of the 
> document. This will not be a valid zip file and cannot be unzipped.
> 
> Brian Barker 
> 
> -
> 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: Possible Corporate installation

[James Plante]

I cannot speak for AOO, and I am not an attorney anywhere. What I would do if I 
were in your position is to print out the AOO license for the version that 
you’re using; write a statement of your circumstances and what you’ve been 
asked to do; then take it to a California lawyer, and ask for a letter of 
opinion. 

Having that letter in your file will give you some ammunition against lawsuits 
or other enforcement action. That’s the best you can do, since AFAIK there is 
NO management of AOO that can speak with executive authority with respect to 
the software. 


> On Mar 30, 2017, at 9:14 AM, Russ Hayes  wrote:
> 
> Good morning,
> 
> 
> I'm writing to confirm how we can move forward with Open Office for a project 
> we are working on for the State of California.  We are a subcontractor to 
> Xerox and are configuring/loading both mobile and fixed computers for 
> deployment across the state.  They've asked us to install OpenOffice on each 
> machine prior to delivery to the state throughout the rest of the year.
> 
> 
> As an Open Source program, is there any open source agreement we need to have 
> signed before we move forward with this?  Or, does the download of the 
> software form the agreement to adhere to Open Source requirements?  Again, 
> this is a State of CA implementationwe're being extra careful to make 
> sure we don't run into a problem later on and just wanted to confirm how we 
> move forward.
> 
> 
> Thank you in advance,
> 
> 
> Russell A. Hayes
> 
> Shade and Putnam


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

Re: Malicious Posters

[James Plante]

+1


> On Apr 6, 2017, at 6:20 PM, John Hart  wrote:
> 
> Why do moderators of this list allow malicious posters to ruin it's 
> effectiveness? On 4/6/2017 3:31 PM, Jim McLaughlin wrote: Get an actual 
> computer and operating system instead of an Apple product. --- On 3/9/2017 
> 5:20 PM, Jim McLaughlin wrote: You really are a  dumb fuck. --- On 2/26/2017 
> 12:16PM, Jim McLaughlin wrote: 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. --- On 2/26/2017 10:38AM, Jim 
> McLaughlin wrote: Imagine how much I care what you think. --- 2017-02-26 
> 18:01 GMT+01:00 Jim McLaughlin Why would Microsoft alter Windows Defender in 
> Win 10 to make use of open source garbage like OO 4.1.3 easier?  You 
> are at best naive. --- On 2/6/2017 1:42 PM, Jim McLaughlin wrote: I give you 
> a litany of the defects that have plagued OO since at least ver 2.0, 
> unrepaired, and yourr response is personal perjorative insults. --- On 
> 2/6/2017 1:09 PM, Jim McLaughlin wrote: OO is a bad joke. yaers and years 
> with the same defects, --- On 2/2/2017 10:30 AM, Jim McLaughlin wrote: So you 
> are a dumb shit incapable of receiving advice in th omly manner in which it 
> is offered. --- On 1/29/2017 12:29 PM, Jim McLaughlin wrote: Yet another 
> instane of a long festering defect in the OO "organization" --- On 1/5/2017 
> 7:19 PM, Jim McLaughlin wrote: SElf proclaimed Apple fanatics like Goeyass 
> are incapable of actually learning. Etc
> 
> 


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

Re: CRASH

[James Plante]

If it were mine, I’d try to go around it. Open your problem chart. Then open a 
new blank spreadsheet. Select your chart, and choose Select all (Ctrl-A). Copy. 
Then select the new spreadsheet document and paste. Try modifying the 
newly-created document.

Hope that works for you.

Jim

> On Apr 7, 2017, at 2:26 PM, Ray Fisher  wrote:
> 
> 
> Sirs, I have been using Open Office for several years now with no 
> problems…until now… I updated a chart that I had saved and when I went to 
> click on save as everything locked up and I could do nothing except manually 
> shut my computer down. This happened four times. I cannot save the updated 
> chart.
> When I restarted my computer manually and tried to update the same chart I 
> get a crash notice and info was supposedly sent to someone at Open Office. 
> This also happened four times so I have finally given up on updating that 
> chart.. I have been able to update that chart in the past every time with no 
> problems until now.
> Any explanations as to why this is happening? Thanka, Ray
> Sent from Mail for Windows 10
> 


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

Re: Transferring Data from Other Sheet

[James Plante]

Select sheet 1. Select cell C5. Type “=“ (no quotes). Now, select sheet 2. 
Select C8. Hit return to accept. You should be back in sheet 1, and cell C5 
should be showing the value or text that is in sheet2:C8. 

Jim Plante

> On Apr 8, 2017, at 2:41 PM, VinceB.  wrote:
> 
> Using Calc:AOO413m1(Build:9783)  -  Rev. 1761381 2016-09-29 02:39:19 on 
> desktop Win10 PC.
> 
> I am trying  To Reference a Cell in the Same Document, but from two separate 
> sheets.
> 
> That is, I want to duplicate the value contained in cell C8 of my sheet 2 
> into cell C5 of my sheet 1.
> 
> Getting err:501  or err:509.
> 
> 
> Please advise how this should be done. I suspect that I am missing quotation 
> marks or something.
> 
> VinceB.
> 
> 
> 
> -
> 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: Urgent need to save doc...

[James Plante]

Celeste, please see comments within your message below:
> On Jun 5, 2017, at 4:08 PM, Celeste Cantor-Stephens 
>  wrote:
> 
> Hi support team,
> 
> I'm in need of some quite urgent help...
> 
> OpenOffice has just crashed on my laptop. I'm using a mac air, and see the
> turning, coloured circle when I go to Open Office.
Yes, AOO has crashed. Now which version are you using? 4.1.3?

> The OpenOffice word
(OpenOffice Writer. Word is a Microsoft program)

> document I have been working on - previously saved to my computer (mac air)
> and external hard-drive - had a notification about lack of space.
Can you be more specific? A “notification about lack of space” where? Lack of 
memory (RAM)? or lack of hard disk space?

> Because I
> opened extra OpenOffice docs (from the dock) I can't see it any more.
Since AOO is locked up, you can’t do anything with them anyway. 

> I've
> deleted files and closed everything but OpenOffice. The document I am
> working on - which contains my master's thesis - due to be submitted in
> under a month!! - has disappeared from folders on my computer. As soon as
> it crashed I tried to move copies on my hard-drive, which was probably a
> mistake because that particular file seems to have gone from there too. I
> don't want to force OpenOffice to close because I absolutely can't loose
> this work!
You might as well force quit it. It’s hung up and you can’t operate it anyhow. 

> Please advise... I hope that all makes sense…
Here’s what I advise: Force quit AOO. Search through your files using the 
Finder and/or Spotlight. If you locate them, copy them to a thumb drive. If you 
*don’t* locate the files, and IF you’ve activated Time Machine, your problem is 
probably already solved. Just retrieve yesterday’s version, and you won’t have 
so much to re-do. If it were *my* master’s thesis, I’d copy all relevant data 
to iCloud and DropBox; make a thumb drive copy; and have AOO set to do 
automatic backups every 30 minutes. Do the off-site and thumb drive backup once 
per day. 

If you don’t locate those files, and haven’t activated Time Machine, then get 
to work: You still have a month. 

> 
> Huge thanks in advance,
> 
> Celeste


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

Re: Macro Code Trrou

[James Plante]

Everywhere there’s a comma, put a semicolon. That might fix it. Make it look 
like this:
> LastSn = rng.Find(“*"; rng.Cells(1); Lookat:=xlPart; LookIn:=xlFormulas; 
> SearchOrder:=xlByRows; SearchDirection:=xlPrevious; MatchCase:=False) .Row)

> On Jun 23, 2017, at 11:29 AM, QCIT3 MMisonora  wrote:
> 
> Hi there,
> 
> I just gotten the macros on a file that was originally from Excel to 
> OpenOffice to appear and sometimes run. However, on one of the macros there 
> is a mistake on one of my lines according OpenOffice and was hoping if 
> someone can tell me how to fix it. The line says "LastSn = rng.Find("*", 
> rng.Cells(1), Lookat:=xlPart, LookIn:=xlFormulas, SearchOrder:=xlByRows, 
> SearchDirection:=xlPrevious, MatchCase:=False) .Row)"
> 
> Sent from Outlook


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

Re: Open Office for MacBook

[James Plante]

Jill,
Go to http://www.openoffice.org; click the second choice (“I want to download 
Apache OpenOffice”)
The next page of the website will detect the type of browser you’re using, and 
offer the correct download.
Since I’m using an iMac with the latest MacOS, it offers me OS X (version >= 
10.7) (DMG), in English (US), and version 4.1.3
Select the button marked “Download full version”
Walk away. Don’t click anything else. your file will download to your 
“Downloads” folder as a .dmg file unless you’ve done something to alter the 
destination of downloaded files. 

After the download is complete (it’ll take a while), open the Downloads folder 
and double-click the .dmg file. The program will be extracted, the web page 
will take you to a different place, again offering a download button: LEAVE 
THIS PAGE ALONE. DON’T CLICK ANYTHING. Wait until a window appears showing 
“OpenOffice” in the title bar. The top line of icons shows OpenOffice.app and 
an alias to your Applications folder. Drag the OpenOffice.app icon to the 
Applications folder. 

When you click on the newly-installed OpenOffice.app, you’ll run headlong into 
Gatekeeper. Gatekeeper keeps you safe from malware and other bad stuff. But 
it’s a digital hemorrhoid. It’ll tell you AOo is an app it doesn’t recognize, 
and it won’t allow it to open. Just Command-click on the OpenOffice.app icon 
and tell it to open anyway.

Hope this helps,

Jim Plante
> On Jun 26, 2017, at 2:54 PM, Jill Melanie Wirth  wrote:
> 
> Hello ~ I have used Open Office 3.4.1 on my Mac OS X version 10.6.8
> I just bought a new Mac OS Sierra, version 10.12.5
> I would like to download Open Office on this computer.
> Please tell me what version to choose.
> Thank you very much for your help.
> All the Best,
> Jill Wirth


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

Re: CANCELLATION

[James Plante]

Nope! Not gonna comment. Considering the sig line, it’s low-hanging fruit.

Jim
> On Jun 29, 2017, at 3:58 PM, sharand...@aol.com wrote:
> 
> THE PROGRAM I PURCHASED ON 6/27 IS NOT COMPATABLE WITH MY PRPGRAM.  I  
> PURCHASED IT BECAUSE MY OLD  PROGRAM WITH YOU STOPPED WORKING.  PLEASE  
> REFUND 
> MY MONEY
> 
> Sharand  East
> 480-489-6612
> 
> Remember: Ugly can be  fixed, but stupid is forever.
> John Wanye


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

Re: Page Number Question on Writer

[James Plante]

Jeffrey,
Doug's workaround will do for the current document (which I assume you're being 
bugged to provide yesterday.)
But do take the time to learn page styles from the references already provided 
by others. It'll save you a world of trouble going forward, especially if you 
chain them: Title Page's next page style is Author; Author leads to TOCpage; 
TOCpage's "next style" is "First Page" and so on. Get that down, and all you 
have to do is write; Writer takes care of the rest.

Styles are one of the main strengths of AOO, so pay attention to paragraph and 
character styles, too. They can be very handy for quoted text, sidebars, and 
tables among other things. 

Regards,
Jim Plante

On Nov 28, 2012, at 2:10 PM, Doug  wrote:

> On 11/28/2012 12:56 PM, Jeffrey Deutsch wrote:
>> On Wed, Nov 28, 2012 at 12:51 PM, Doug  wrote:
>>> On 11/28/2012 12:29 PM, Jeffrey Deutsch wrote:
 Hello,
 
 I'm finalizing my eBook manuscript on Writer. The only thing left to
 do is set up Roman numeral page numbers for the first three pages
 (title page, about the author and table of contents) - or possibly
 only give the about the author and table of contents pages Roman
 numerals - and then Arabic numerals for the rest. Also, the Arabic
 numerals must start with 1.
 
 As a second-best solution, I'm willing to have the first three pages
 have no page numbers at all, as long as the rest have Arabic page
 numbers starting with 1.
 
 I've struggled with it and read over the relevant Help file more times
 than I care to count. Any help you can offer would be much
 appreciated. Thank you very kindly!
 
 Jeff Deutsch
 Speaker & Life Coach
 A SPLINT - ASPies LInking with NTs
 http://www.asplint.com
 
 
>>> An obvious work-around for the second-best solution:  Make the first 3 pages
>>> a separate file without page numbers.  Or just write the Roman numbers at
>>> the
>>> bottom of each page, using center justification. Then the remainder will be
>>> its
>>> own file with page numbers starting at 1.  Now you can have most of the
>>> "best"
>>> solution. Two files doesn't sound like all that big a deal.
>>> 
>>> --doug
>>> 
>>> -
>>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>>> For additional commands, e-mail: users-h...@openoffice.apache.org
>>> 
>> Hi Doug,
>> 
>> Actually, I'd've already submitted them in four separate files - thing
>> is, the recipient strongly prefers the manuscript in one file only.
>> 
>> Anything you can suggest under that constraint would really help.
>> 
>> Thank you for your courtesy!
>> 
>> Jeff Deutsch
>> Speaker & Life Coach
>> A SPLINT - ASPies LInking with NTs
>> http://www.asplint.com
>> 
>> Your mood can affect how you read this e-mail. Please read it with a smile.
>> (http://tonecheck.com)
>> 
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>> 
>> 
> OK, let's try this:
> Write the two files, one three pages long with Roman numbers
> at the bottom of each page, and the other 50 or 100 pages,. or
> whatever it is, with Arabic numbers starting at 1.
> 
> When you have them done, open File 1, and on the fourth page,
> insert File 2, and then save the whole thing as File 3 and send File 3 to
> your publisher.
> 
> --doug
> 
> -
> 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: ack! Mac Viewing Issues

[James Plante]

I've had a similar problem with OOo on the Mac. Got about 170 pages of a 200+ 
page report done, and the program wouldn't save the file. It started the 
aberrant behavior you describe. I closed the file, and opened it in NeoOffice, 
a dedicated Mac version of OOO. Worked fine. Find NeoOffice at 
http://www.neooffice.org/neojava/en/index.php. It costs $10 to d/l, but if it 
saves your book, it's worth it. 

Jim Plante

On Dec 3, 2012, at 2:47 PM, damali ayo  wrote:

> My apologies Hagar, I did not see that link.
> 
> I did change the user profile and it is still acting the same strange way.
> 
> What i find most odd, is how the notes seem to be in the doc, but don't show 
> up until i click them. Other things I wrote in the notes section appear then 
> too. It's like a hide and seek game. That's why i think the information is 
> all there...somewhere.
> 
> Is there any other program that you suggest i use to complete work on this 
> manuscript? Will a new version of MS word be able to import the .odt file?
> 
> Thanks, i think that's my last question, since nothing has changed. :(
> 
> damali
> 
>> Profile location is given here (same topic): 
>> http://forum.openoffice.org/en/forum/viewtopic.php?p=58401#p58401
>> There is a link to that post in the very post I've linked.
>> 
>> Hagar
>> 
>> Le 03/12/2012 21:32, damali ayo a écrit :
>> 
>>> Hagar,
>>> 
>>> How do i do this in mac? The link you send does not detail that process.
>>> 
>>> damali
>>> 
 Have you tried to reset the profile? It may help.
 
 Hagar
 
 
 Le 03/12/2012 21:15, damali ayo a écrit :
 
> Thanks! I so appreciate your thoughts.
> 
> I had already saved in .odt quite a few times, this was even a "save as" 
> .odt file i was working on. I had imported it from .doc over a week (and 
> many many saves) ago. I had not gone back to .doc at all.
> 
> I don't have any photos. I do have a table of contents, several sections 
> (14) and endnotes. I increased the memory to support this (great tip!), 
> quit and restarted the program, but the problems persist.
> 
> I forgot to mention a symptom...i noticed it was acting strange when i 
> tried to highlight several lines in the endnotes and it only let me 
> highlight random portion. So I closed the doc and re-opened. That's when 
> everything went pear-shaped.
> 
> Other ideas?
> 
> damali
> 
>> First, save in native ODF (.odt).
>> Remember that the .doc import/export filters have been reverse 
>> engineered, you may face some troubles by continuing using this format.
>> Always work in .odt and export in .doc when needed only. This way you 
>> keep a secure copy of your document.
>> 
>> If your document has a lot of objects (pictures, ...), try to increase 
>> the memory settings (Tools>Preferences>OOo>Memory).
>> 
>> If no change, you can try to reset your user profile but I doubt it will 
>> change anything in your case: 
>> http://forum.openoffice.org/en/forum/viewtopic.php?p=58403#p58403
>> 
>> Hagar
>> 
>> 
>> Le 03/12/2012 20:55, damali ayo a écrit :
>> 
>>> Hello Forum,
>>> 
>>> I have been chugging along on a 300 page manuscript in Open Office. I 
>>> brought it into OO from an old (I mean old) version of word. All was 
>>> going well until a few minutes ago when OO seemed to be reading my 
>>> document very strangely. The header disappeared, the endnotes 
>>> half-disappeared, and when I click on a number in the text for a note, 
>>> it takes me to the note at the end but then others are missing. I have 
>>> no idea what happened or why. When I open the document anew it 
>>> positions me somewhere in the middle of it.
>>> 
>>> I have the sense that it's a viewing issue, and the file isn't actually 
>>> screwed up...at least I hope so. I have no other way of opening it 
>>> though.
>>> 
>>> I quit OO, restarted my computer, and no changes.
>>> It's slightly terrifying. I've been working on this book for over a 
>>> year. Any help would be angelic, truly.
>>> 
>>> Details:
>>> 
>>> Involved participants:
>>> Mac OS 10.5.8
>>> Microsoft word v.X for mac (yes i need an entirely new computer, I know)
>>> OpenOffice 3
>>> 
>>> Thank you!!
>> 
>> -
>> 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
>>> 
>>> 
>> 
>> -
>> To unsubscribe, e-mail: users-unsubscr

Re: ack! Mac Viewing Issues

[James Plante]

It's a computer, for chrissake. It doesn't (or shouldn't) care how long a 
document is. Programs fault because of either logic errors or runtime errors. 
In this case, it looks like memory management may be at fault, or maybe a 
dangling pointer or something. I don't really have any idea. Maybe it's just an 
integer out of range somewhere, or a bollixed-up hash table. It's way over my 
pay grade to fix it, but someone with the necessary knowledge can d/l Neo's 
source code (it's based on OOo) and see how Patrick (Neo's sole engineer) 
addressed the problem. 

At any rate, if word processing is mission-critical, and the word processor 
fails in one operation, should you trust it with critical work? And if it can 
keep straight the complexity of a master doc, it should be able to keep track 
of a single document. One of the reasons I *don't* use master docs is because 
of the extra work needed to cross-reference various parts of a report, e.g., on 
page 24, see cost analysis in Appendix C, page 98. (And page 98 keeps 
incrementing as your document grows; it finally ends up being on page 210--and 
your cross-reference reflects that.)  

I really, really like AOO, but if it faults out on long docs, I'll keep using 
Neo until it works without failing.


On Dec 3, 2012, at 7:22 PM, VA  wrote:

> I wonder if it might be helpful to save larger works into smaller chunks and 
> then use the Master Document feature to bring them all together. It takes 
> some getting used to, but once learned, it has some neat advantages to trying 
> to edit several hundred pages in one file.
> 
> Virgil
> 
> -Original Message- From: James Plante
> Sent: Monday, December 03, 2012 8:05 PM
> To: users@openoffice.apache.org
> Subject: Re: ack! Mac Viewing Issues
> 
> I've had a similar problem with OOo on the Mac. Got about 170 pages of a 200+ 
> page report done, and the program wouldn't save the file. It started the 
> aberrant behavior you describe. I closed the file, and opened it in 
> NeoOffice, a dedicated Mac version of OOO. Worked fine. Find NeoOffice at 
> http://www.neooffice.org/neojava/en/index.php. It costs $10 to d/l, but if it 
> saves your book, it's worth it.
> 
> Jim Plante
> 
> On Dec 3, 2012, at 2:47 PM, damali ayo  wrote:
> 
>> My apologies Hagar, I did not see that link.
>> 
>> I did change the user profile and it is still acting the same strange way.
>> 
>> What i find most odd, is how the notes seem to be in the doc, but don't show 
>> up until i click them. Other things I wrote in the notes section appear then 
>> too. It's like a hide and seek game. That's why i think the information is 
>> all there...somewhere.
>> 
>> Is there any other program that you suggest i use to complete work on this 
>> manuscript? Will a new version of MS word be able to import the .odt file?
>> 
>> Thanks, i think that's my last question, since nothing has changed. :(
>> 
>> damali
>> 
>>> Profile location is given here (same topic): 
>>> http://forum.openoffice.org/en/forum/viewtopic.php?p=58401#p58401
>>> There is a link to that post in the very post I've linked.
>>> 
>>> Hagar
>>> 
>>> Le 03/12/2012 21:32, damali ayo a écrit :
>>> 
>>>> Hagar,
>>>> 
>>>> How do i do this in mac? The link you send does not detail that process.
>>>> 
>>>> damali
>>>> 
>>>>> Have you tried to reset the profile? It may help.
>>>>> 
>>>>> Hagar
>>>>> 
>>>>> 
>>>>> Le 03/12/2012 21:15, damali ayo a écrit :
>>>>> 
>>>>>> Thanks! I so appreciate your thoughts.
>>>>>> 
>>>>>> I had already saved in .odt quite a few times, this was even a "save as" 
>>>>>> .odt file i was working on. I had imported it from .doc over a week (and 
>>>>>> many many saves) ago. I had not gone back to .doc at all.
>>>>>> 
>>>>>> I don't have any photos. I do have a table of contents, several sections 
>>>>>> (14) and endnotes. I increased the memory to support this (great tip!), 
>>>>>> quit and restarted the program, but the problems persist.
>>>>>> 
>>>>>> I forgot to mention a symptom...i noticed it was acting strange when i 
>>>>>> tried to highlight several lines in the endnotes and it only let me 
>>>>>> highlight random portion. So I closed the doc and re-opened. That's when 
>>>>>>

Re: ack! Mac Viewing Issues

[James Plante]

On Dec 4, 2012, at 3:36 AM, Martin Groenescheij  wrote:

> The advantage of entering a cross-reference as a field is that you do */not 
> have to adjust the references manually/* every time you change the document. 
> Just update the fields with F9 and the references in the document are updated 
> too.

And with AOO, you can simply pick paragraph headings as the cross-reference if 
you're working on a single document. If, OTOH, you're using a master doc, then 
you must name the sub-file and explicitly spell out the reference. This is 
quite inconvenient in a big, complex document; there's also a high probability 
of error. If I'm working in a sub-file--say, Site Value, and I want to 
reference an entry in the section titled "market analysis," then the field 
reference has to be complete and accurate into a file that's not open, or 
worse, which is open and being changed by someone else. 

Now, a programmer who can figure out how to keep that much information straight 
in a dynamic document has my complete admiration. But it is easier for me to 
simply write a single, massive document that knows its own parts thoroughly. 
AOO does this until the document length exceeds about 170 pages, then it loses 
its mind, starts acting goofy, and won't save. 

And, btw, you don't have to lose your changes when that happens. Just open a 
new document, copy the new material from the malfunctioning one, and paste it 
into the new blank document. That will save nicely. The longer doc won't. 

Jim Plante

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

Re: ack! Mac Viewing Issues

[James Plante]

On Dec 4, 2012, at 7:39 AM, Rory O'Farrell  wrote:

> Just for badness, I once created an OpenOffice document of 22K+ pages (yes, 
> over 22,000 pages), of plain text.  I can't remember how many copies of War 
> and Peace it was, but it could be edited and saved, although so slow as to be 
> effectively unuseable.
> 
> I have two documents of formatted text, linked Table of Contents, footnotes, 
> endnotes and hyperlinks, each of well over 200 pages, which I regularly edit 
> and expand, without trace of any goofiness on their part

Rory, thanks for that info. That tells me that my goofiness problem may be 
system-related. I'm on a Mac, so it may have nothing to do with the AOO code 
itself. That yours worked, even miserably slowly, tells me I've got a different 
problem than I thought I had. It's still above my pay grade to fix it, though. 
:-(

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

Re: Unscribe

[James Plante]

Andrea,

It's spelled UNSUBSCRIBE, not Unscribe.
 
And if you seek to annoy someone with that ridiculous email, bear in mind that 
you're annoying people who know vastly more about annoying people with a 
computer than you do. If you succeed, it could end badly for you. Meantime, 
follow the directions at the bottom of the e-mail.

Jim

On Dec 13, 2012, at 3:22 PM, Andrea Cataffo Gmail  
wrote:

> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribe
> UnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribeUnscribUnscribeUnscribeUnscribeUnscribeUnscribeUnscri

Re: How to associate opne office with my e-mail account

[James Plante]

Pat,
OpenOffice wants a mail client, not an e-mail service. What you're describing 
is a web-based mail service. 

You might have several web-based mail services. Just for purposes of 
demonstration, let's say you have a gmail account, a yahoo account, and your 
Xfinity account. It is possible for you to check all three accounts with a 
single mouse-click if you do the following:

Open Outlook or Outlook Express. If you don't have either of those, download 
Thunderbird and open it. Somewhere in the preferences for those 
programs--called "mail clients"--there will be a tab labeled "Accounts." Set up 
each of your accounts in your selected mail client. Let's say they're 
pa...@yahoo.com; pat...@gmail.com; and pa...@xfinity.com. 

Once you have your accounts set up in your mail client, you can tell OpenOffice 
to use that mail client to send e-mail. Just set the association with, say, 
Outlook. Outlook should be set to send messages from one of these accounts by 
default; you'd likely choose pa...@xfinity.com as the default account. 

Having done that, the next time you choose to e-mail a document you'll be given 
the choice of sending the native document (e.g., MyPaper.doc) or a PDF (e.g., 
MyPaper.PDF). In the latter case, the document will be converted to PDF and 
attached to a blank e-mail message. You can fill in the addressee and subject 
line, and add a message in the body. Then click the "send" button as you 
normally would. 

Regards,
Jim Plante

On Jan 13, 2013, at 10:35 AM, Pat Flynn  wrote:

> I recently upgraded to Windows 8 Pro from Vista Home Premium. Every time I 
> try to send a document from Open Office by e-mail, a drop down tells me that 
> I have to establish an association with my mail program. I have tried Xfinity 
> , which is my mail service at mail.comcast.net, Open Office on line help and 
> Windows and have gotten no answer as how to do this. When I check my File 
> Explorer and Programs, I find no program named Xfinity or Comcast mail. 
> 
> 
> Can you please help me out on this? 
> 
> 
> Pat Flynn 
> shirlpat @comcast.net


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

Re: How to associate open office with my e-mail account

[James Plante]

Won't work, Brian. Zimbra's browser-based. From the VMware site:
"VMware Zimbra is an enterprise-class email, calendar and collaboration 
solution, built for the cloud, both public and private. With a redesigned 
browser-based interface, Zimbra offers the most innovative messaging experience 
available today, connecting end users to the information and activity in their 
personal clouds."

OpenOffice wants a dedicated mail client like T-bird, Outlook, or Apple's Mail.

Jim Plante

On Jan 13, 2013, at 2:37 PM, Brian Barker  wrote:

> At 16:35 13/01/2013 +, Pat Flynn wrote:
>> I recently upgraded to Windows 8 Pro from Vista Home Premium. Every time I 
>> try to send a document from Open Office by e-mail, a drop down tells me that 
>> I have to establish an association with my mail program. I have tried 
>> Xfinity, which is my mail service at mail.comcast.net, Open Office on line 
>> help and Windows and have gotten no answer as how to do this. When I check 
>> my File Explorer and Programs, I find no program named Xfinity or Comcast 
>> mail.
> 
> You appear to be using Zimbra as your mail client - the local program on your 
> PC in which you compose messages and which transmits them to your mail 
> provider, Comcast.  If this is so, you should be looking to associate 
> OpenOffice with Zimbra, not with Xfinity or Comcast.  OpenOffice should use 
> your default e-mail program, so you may need to educate Windows 8 as to what 
> this is.
> 
> 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
> 


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

Re: reveal codes

[James Plante]

If the document looks wrong, and you can't find out why, then just select 
"default formatting" to clear all formatting. Then reapply the correct format. 
Two mouse-clicks, no waiting. 

Jim Plante

On Jan 20, 2013, at 11:45 AM, Brian Barker  wrote:

> At 12:38 20/01/2013 -0500, Helen wrote:
>> I should have clarified what I meant by a troubling code.   I meant 
>> something that I (or any user) might put in, and then later decide this is 
>> not exactly the way you want it, and so wish to make an adjustment.  Your 
>> document looks wrong but you don't know how to find the formatting element 
>> that you inserted and now wish to delete.  In WP, that is easy. Press Reveal 
>> Codes, find the code you don't want, and delete it.
> 
> I'm with you all the way - except for the last three words!
> 
> If your document "looks wrong but you don't know how to find the formatting 
> element that you inserted", you certainly need a simple way to discover this. 
>  (I don't know whether any problems I have in this area are Writer's or 
> mine!)  But users must not be allowed to make changes at that level; instead, 
> they must be required, having discovered what the problem is, to solve it 
> where it was caused.  Anything else breaks the structure.
> 
> Brian Barker
> 
> 
> 
> -
> 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: reveal codes

[James Plante]

Or just stick your cursor in front of the paragraph following the offending 
page break and press delete. 

But there wouldn't BE a hard page break present if page styles had been used 
correctly to begin with. Writer's use of styles assures consistency throughout 
the whole document. But learning to "use styles correctly" is no easy job. I've 
had quite a few wrestling matches with it over that kind of thing myself. But 
overall, it's worth the fight to make it work.

Anything's easy once you learn how. ('Till then, though, you can invent some 
new profanity. :-)

Jim Plante

On Jan 20, 2013, at 12:57 PM, Eric Fenster  wrote:

>> just select "default formatting" to clear all formatting.
> 
> Why destroy everything and start over if all that's necessary is to put the 
> cursor on a code and DEL
> 
> For ex, a hard page break that becomes out of place because text has been 
> added during editing. Click on the page break code, it's done. The doc 
> reformats.
> 
> 
> 
> -
> 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: [improvement idea] "in-place" editing of Input Fields in Writer

[James Plante]

Oliver,
You can get much of the behavior you desire by defining User Fields instead of 
Input Fields. They have the added benefit of being global. In other words, if 
you change one at the end of the document, and that same field appears at the 
beginning, BOTH fields change if you edit either one of them. The only thing 
User Fields won't offer you is the editing if the doc is read-only. 

Why would you want to traverse all the input fields? OpenOffice, of course, 
does that automatically when you have Input fields in a template. You complain 
that you cannot back up to the previous field. But if you've made a mistake in 
the previous field, just click in that field when you've finished all of them, 
and make your correction. Although I find that to be my preferred way of making 
corrections, your requirements may differ. Perhaps you could write a macro to 
list all the fields and allow you to change their contents in a dialog?

Regards,

Jim 

On Feb 6, 2013, at 10:23 AM, Oliver-Rainer Wittmann  
wrote:

> Hi,
> 
> recently I got notice about our (from my point of view) very user-unfriendly 
> way for editing Input Fields in Writer.
> Currently, you can not place the cursor into an Input Field which in general 
> is shown with a grey background when Menu View - Field Shading is on. If you 
> click on the Input Field, a modal dialog pops up. In this dialog you can edit 
> the Input Field's content. On confirmation of the dialog the Input Field's 
> content is changed in the text document. To edit the next Input Field you 
> need to click on it. There is also a special key shortcut - namely 
> Shift-Ctrl-F9. This key shortcut opens the Input Field content editing dialog 
> for the first field. This time the dialog has a Next button by which you can 
> confirm your change and switch directly to the next Input Field. A Previous 
> button is not available. By Murphys law the dialog hides most of the time the 
> Input Field in the text document.
> 
> I have got the opinion that such an editing experience is bad, especially, if 
> the document is a form which makes use of a lot of Input Fields to be filled 
> by the user.
> 
> My idea is to be able to edit the Input Fields directly in the text 
> document's content together with some special handling. The special handling 
> which I had in mind is:
> - Some special key handling to "travel" from Input Field to Input Field, 
> forward and backward. May be key Ctrl-Tab for forward movement and 
> Shift-Ctrl-Tab for backward movement.
> - Feedback when the user "enters" (cursor inside Input Field) and "leaves" 
> (cursor outside Input Field) a Input Field. May be some transparent overlay, 
> similar to the selection overlay, when the cursor is inside a Input Field.
> - Even if the document is read-only, the editing of the Input Fields should 
> be possible when configured correspondingly.
> 
> What is your opinion about the current Input Field editing?
> What is your feedback on my idea to improve the editing of Input Fields?
> 
> If I found time, I would like to implement such an improvement.
> Unfortunately, I do not have the resources, now.
> 
> Everybody volunteering to help/to provide feedback on development, qa, user 
> experience, documentation, translation of possible new UI and the new 
> documentation is welcome.
> 
> 
> Best regards, Oliver.
> 
> -
> 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: all functions in text tables

[James Plante]

Just use Calc itself. Create the table portion of your invoice in Calc, using 
whatever SS functions you find convenient. When finished, copy the invoice 
table from Calc and paste into Writer. You'll have an imbedded spreadsheet. 
(N.B.: After pasting, click OFF of the imbedded SS to see what will print. 

Once the SS is imbedded, you can double-click on it to get at all the SS 
functions again. 

Jim

On Jul 1, 2013, at 2:19 AM, Jeromy McClain  wrote:

> Hi, I was wondering if it is possible to unlock all the unavailable
> functions for text tables like it is in calc. F.e. the "=sumif" function
> could be very helpful to create text based bills with an inlayed table in
> the same scale with more own math parameters than =sum.
> 
> Greetings from Berlin
> 
> Jeromy


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

Re: Is Apache Open Office good for sales tax service spreadsheets?

[James Plante]

Depends on how much data you intend to acquire. For a small shop, using AOO 
would be feasible. But as Tom Goldie said below, a database should be employed 
if you're acquiring lots of data. Spreadsheets do well on small data sets, but 
beyond a certain point they get unwieldly, then become unusable. You've got 
only 65,534 rows (records) to work with in a spreadsheet; many more records are 
possible in a database.

Regards,
Jim Plante
 
On Sep 29, 2013, at 6:51 AM, Gabrielle Becker  wrote:

> hi, 
> I am just looking for a simple spreadsheet program where I can keep track of 
> who I charged what, plus what sales tax there was, plus address, time and 
> invoice number.It needs to be searchable.  Etc. Is Apache open office good 
> for this type of use? I would be getting cash or checks so no need for 
> keeping track of bank account or credit card numbers. 
>  


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

Re: Informal Mac OS / OpenOffice Survey

[James Plante]

10.9 Mavericks

On Dec 11, 2013, at 9:07 AM, Rob Weir  wrote:

> An informal survey to help our project planning: If you run OpenOffice
> on the Mac, what version of Mac OS are you running today?
> 
> 10.4 (Tiger)
> 10.5 (Leopard)
> 10.6 (Snow Leopard)
> 10.7 (Lion)
> 10.8 (Mountain Lion)
> 10.9 (Mavericks)
> 
> -
> 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: New B

[James Plante]

Paul,

OpenOffice has five different components: Writer, Calc, Draw, Impress, and 
Base. I don't think it can recognize a Base file from a system double-click or 
other system routing. Try opening OO, then tell it to open the file you were 
sent. It may not work, but it's worth a try.

Jim Plante

On Feb 28, 2014, at 4:11 PM, Paul  wrote:

>A friend recently has started using OO. He e-mailed me a .odb file. as a 
> attachment
> I downloaded /installed  OO  V4.0.1
>I clicked the attachment option to open with OO;  OO opened, the file is 
> there as recent file
>but did not open. Thre file is a list of volunteers/addresses etc.
>Please advise
>Paul
> 
> ---
> List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 


---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: AMAZING -- Case of Subscription via a Remailer Address [was: Re: Removing yourself from the list :)]

[James Plante]

FYI, I get many messages from this list that do not have the "unsubscribe" 
footer. Don't know what's up with that, and since I don't want to unsubscribe, 
I don't care. 

Thought you might find the info handy for troubleshooting.

Jim 

On Mar 10, 2014, at 10:42 PM, Tom Panfil  wrote:

> Hi Tubular,
> 
> Well, I just inspected headers and see that I had fooled myself. My original 
> subscription request was:
> 
>Subject:   Subscribe to OpenOffice Users Mailing List
>Body:   Hello, Subscribe tapan...@ieee.org
> 
> My reply to the "confirm subscribe to ooo-us...@incubator.apache.org"  was:
> 
>Subject:   Confirm Subscription to ooo-user Mailing List
>Body:   Hi, I do want to subscribe to the ooo-users mailing list,
>   BUT I would prefer that my mail be set to my Reply-To 
> Address: tapan...@ieee.org
>   Rather than to my From Address: tap.h...@verizon.net
> 
> The resulting WELCOME message said in part:
> 
> Acknowledgment: I have added the address
>tap.h...@verizon.net
>  to the ooo-users mailing list.
>  Welcome to ooo-us...@incubator.apache.org!
>  Please save this message so that you know the address you are
>  subscribed under, in case you later want to unsubscribe or change your
>  subscription address.
> 
> So, my attempt to con the list server to use my IEEE Remailer address failed.
> 
> It looks like people are not allowed to subscribe via their preferred 
> remailer addresses.
> 
> You must have actually been seeing people writing from ISP supplied addresses 
> other than the ISP provided addresses from which they subscribed.
> 
> You must be right -- Maybe some others have been under the same misconception 
> which I just aired.  Maybe this will help them.
> 
> v/r,
> 
> Tom
> 
> On 3/10/14 10:57 PM, Tubular wrote:
>> Thank you, Tom for the insight; however, if these people cannot send email 
>> from these type of email addresses, how did they get on the list to start 
>> with?
>> 
>> 
>> 
>> Tom Panfil wrote:
>>> Hello OpenOffice Apache Moderators,
>>> 
>>> I don't want to unsubscribe from any of the three project lists to which I 
>>> subscribe (users, dev, api)  but like you,  I've seen too many requests 
>>> sent to the lists from people who want to unsubscribe.  I assume that 
>>> something is finally done administratively to unsubscribe their addresses 
>>> since they eventually stop pestering.
>>> 
>>> Many people who are members of ACM or IEEE or other professional 
>>> associations register using a Remailer Address serviced by the 
>>> organization.  The use of a Remailer Address enables provision of at least 
>>> the following services by the organization:
>>> 
>>> * Virus scanning of mail sent to the member's "Remailer Address"
>>> * Quarantining of S--- sent to the member's "Remailer Address" --
>>>   Note that I did not use the "S-Word" since using it might cause
>>>   Verizon refuse to send the message considering it to be S.
>>> * Forwarding of non-infected non-S--- messages to the member's ISP
>>>   provided addresses.
>>> * Ease of changing of ISPs by simply registering a new ISP supplied
>>>   e-mail address with the Remailer Service so that mail sent to the
>>>   Remailer address is forwarded to the member's "new" current ISP
>>>   provided address.  Correspondents need not be informed of the change
>>>   of ISP.
>>> 
>>> These people *cannot* send from their Remailer Addresses.  They can and 
>>> usually do include their preferred Remailer Address in the Reply-To field 
>>> of their message headers.  Their e-mail messages are sent from their ISP 
>>> provided addresses.
>>> 
>>> So, I think that a significant proportion of those who send to the list 
>>> asking to be removed have tried sending to the address in the footer of the 
>>> messages and were not removed from the list since they are subscribed with 
>>> a Remailer Address.  That address from which they are send is different 
>>> from the address which is subscribed
>>> 
>>> I recommend that some mechanism be established for such subscribers to take 
>>> action to be removed from OpenOffice Apache lists.  The instructions they 
>>> need should be provided in the footer with the other three instructions.
>>> 
>>> I can't imagine that *no* developers and maintainers of OpenOffice know of 
>>> Remailer Addresses.  How could this problem have festered so long?   Does 
>>> the project cadre really not know about Remailer Addresses?   If you can 
>>> maintain Apache projects you must be able to understand this dilemma now 
>>> that I have explained it somewhat clearly, I think.
>>> 
>>> Note that I am subscribed via an IEEE Remailer address.
>>> 
>>> I'd no doubt have the same problem which these other poor souls have if I'd 
>>> try to unsubscribe.
>>> 
>> 
>> 
>> 
>> -
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 2012.0.2241 / Virus Database: 3722/6671 - Release Date: 03/09/14
>> 
> 
>

Re: Suggestion.

[James Plante]

+1 on that, Bruce.

I've got a small stash of letters, memos, and technical docs (many just for my 
own use) that I keep; some of these were crafted in the 1.x version of 
OpenOffice. Most are version 3.x templates, though. They all still work, just 
as you describe.

Learning to use templates does not require an extensive amount of additional 
work. And if you mostly use the same type of document, e.g., an in-house memo 
form, then set that as the default template. You can always open a different 
one when you want to write a letter or a formal report. 

Jim Plante

On May 15, 2014, at 11:15 PM, Bruce Byfield  wrote:

> On Wednesday 14 May 2014 06:38:37 PM Doug wrote:
> 
> it is hardly worth the effort for the average memo writer, letter
>> writer, or even article writer. It would be like a numismatist learning
>> metallurgy!
> 
> When I first started using OpenOffice.org well over a decade ago, I sat down 
> and 
> figured all the types of short documents I did, and developed templates for 
> them them. Some years ago, I imported them to ODF, and I am still using them 
> today.
> 
> Whenever I use those templates, I never have to think about formatting except 
> occasionally to change styles. Often, I don't even have to do that, because 
> of 
> the Next field automatically changes styles for me. The time I save on each 
> document is small, but over the years I must have saved days' worth of work 
> -- 
> and all because I took a little extra time once, years ago, to learn about 
> styles. So even if you're only doing short, one-off documents, styles can 
> save 
> you time and effort.
> 
> -- 
> Bruce Byfield 604-421-7189 (on Pacific time)
> blog: https://brucebyfield.wordpress.com
> website: http://members.axion.net/~bbyfield/
> 
> ---
> List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 


---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Abus et escroquerie sur site SMS pour l'obtention de code de téléchargement

[James Plante]

Folks, let's not feed the troll any more, OK?

Jim

On Jul 4, 2014, at 12:26 PM, Baccara  wrote:

> mt wrote:
>> Hello Baccara,
>> 
>> 
>> On 3/7/14 at 9:33 AM, bbacc...@tstonramp.com (Baccara) wrote:
>>  
>>> ...
>>> Wonderful solution, Rory, 
> **snip **
>>> Have you thought of using the Delete key for messages you are not 
>>> interested in?
>>> 
>>> This has proven to be the safest solution on every public mailing 
>>> (discussion) list.
>>> 
>>> HTH,
>>> 
>>> marina
>>>
> marina, you took the time to contact me personally.  My question to you, how 
> do I determine if I am interested or not when only the question was answered 
> in English.
> 
> How nice you think so highly of my request for respect to be shown for the 
> English speaking members of the mailing list.
> 
> Lastly, why are you wasting my time contacting me personally when you 
> obviously didn't understand my comment. 
> 
> 
> 
> -
> 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: Calc issues, Mac OS X 10.9.4

[James Plante]

Reply interleaved:

On Jul 24, 2014, at 12:24 PM, chuck ef  wrote:

> I am an OO newbie so bear with me. 
> I am on an iMac using 10.9.4 and I have never used OO before. I downloaded 
> 4.1.0. I am trying to migrate an MS Excel spreadsheet to Calc. It will be 
> nice to get away from MS. 
> Anyway, I have noticed two problems right off the bat - maybe they are known 
> already and I simply need to be vectored to the appropriate Apache site. But 
> in the even that they are not known already 
> 1.) I seem unable to cut-and-paste "large" amounts from my current MS Excel 
> file into OO Calc. I can do a small set of cells. When I do a 'select all' in 
> Excel and try to paste into Calc, however, nothing happens. 
This is likely because when you "Select All," you're selecting the entire range 
of the spreadsheet's capability, not just the cells that contain data. That's a 
LOT of cells, and a copy/paste could take a lot of time.
> Work around: Open the Excel spreadsheet from within Calc. That is OK but not 
> particularly satisfying when I later have to paste more in from some other 
> source. But it is OK for now.
I find that trying Insert->From file... will work, but it often replaces what 
I've already imported. Workaround (for me) has been to open each Excel file in 
Calc, then save as an .odt. After doing that, opening inserting and copying 
work as expected within AOO. 
> 2.) I use a so-called Apple Magic Mouse. Excel often is jittery when I 
> accidentally slide a finger across the top of the mouse - columns zoom by but 
> it is recoverable, though irritating. However, Calc does not seem to be able 
> to recover so easily. It can get confused quickly (by a minor though quick 
> finger swipe across the mouse - speed of swipe seems to be the issue) and 
> head off into columns unknown. I try scrolling back with the mouse (sliding a 
> finger across the top of the mouse like a track pad) but it does not seem to 
> be able to get back to Column 'A'. It just seems lost (three-letter columns 
> will come down to two-letter columns but then go back to three-letter and so 
> forth, sort of drifting even though I am making a determined effort to scroll 
> back to the origin).
> Work around: Use the Calc scroll bar at the bottom of the Calc spreadsheet. 
> Again, that is OK but not very satisfying. I was also able to "recover" by 
> reloading (from the Calc menu) but that would probably not be a good solution 
> for this apparent column tracking problem if it occurs before I have had a 
> chance to save my work - I have not tried that though.
> Has anyone seen this before? Am I retracing old issues?
Another workaround: Use the address box in the lower left corner of the 
window's title bar. Click in it, type "A1" and return. It should take you 
immediately to cell A1. I have no idea what causes the squirrely behavior, but 
it is present with Apple's touch pads, too. 

Jim

  


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

Re: Calc issues, Mac OS X 10.9.4

[James Plante]

Yes. The file will load just fine--UNLESS you try to Insert-->From file...  If 
you do that, the inserted file overwrites the one you loaded originally. So I 
have to open each Excel file and save it as an .ott. Then I can copy/paste 
between them normally.

Jim

On Jul 25, 2014, at 12:41 PM, James Lambert  wrote:

> James:
> Have you tried just loading an MS file directly?
> James Lambert
> 
> 
> -Original Message----- From: James Plante
> Sent: Friday, July 25, 2014 7:32 AM
> To: users@openoffice.apache.org
> Subject: Re: Calc issues, Mac OS X 10.9.4
> 
> Reply interleaved:
> 
> On Jul 24, 2014, at 12:24 PM, chuck ef  wrote:
> 
>> I am an OO newbie so bear with me.
>> I am on an iMac using 10.9.4 and I have never used OO before. I downloaded 
>> 4.1.0. I am trying to migrate an MS Excel spreadsheet to Calc. It will be 
>> nice to get away from MS.
>> Anyway, I have noticed two problems right off the bat - maybe they are known 
>> already and I simply need to be vectored to the appropriate Apache site. But 
>> in the even that they are not known already 
>> 1.) I seem unable to cut-and-paste "large" amounts from my current MS Excel 
>> file into OO Calc. I can do a small set of cells. When I do a 'select all' 
>> in Excel and try to paste into Calc, however, nothing happens.
> This is likely because when you "Select All," you're selecting the entire 
> range of the spreadsheet's capability, not just the cells that contain data. 
> That's a LOT of cells, and a copy/paste could take a lot of time.
>> Work around: Open the Excel spreadsheet from within Calc. That is OK but not 
>> particularly satisfying when I later have to paste more in from some other 
>> source. But it is OK for now.
> I find that trying Insert->From file... will work, but it often replaces what 
> I've already imported. Workaround (for me) has been to open each Excel file 
> in Calc, then save as an .odt. After doing that, opening inserting and 
> copying work as expected within AOO.
>> 2.) I use a so-called Apple Magic Mouse. Excel often is jittery when I 
>> accidentally slide a finger across the top of the mouse - columns zoom by 
>> but it is recoverable, though irritating. However, Calc does not seem to be 
>> able to recover so easily. It can get confused quickly (by a minor though 
>> quick finger swipe across the mouse - speed of swipe seems to be the issue) 
>> and head off into columns unknown. I try scrolling back with the mouse 
>> (sliding a finger across the top of the mouse like a track pad) but it does 
>> not seem to be able to get back to Column 'A'. It just seems lost 
>> (three-letter columns will come down to two-letter columns but then go back 
>> to three-letter and so forth, sort of drifting even though I am making a 
>> determined effort to scroll back to the origin).
>> Work around: Use the Calc scroll bar at the bottom of the Calc spreadsheet. 
>> Again, that is OK but not very satisfying. I was also able to "recover" by 
>> reloading (from the Calc menu) but that would probably not be a good 
>> solution for this apparent column tracking problem if it occurs before I 
>> have had a chance to save my work - I have not tried that though.
>> Has anyone seen this before? Am I retracing old issues?
> Another workaround: Use the address box in the lower left corner of the 
> window's title bar. Click in it, type "A1" and return. It should take you 
> immediately to cell A1. I have no idea what causes the squirrely behavior, 
> but it is present with Apple's touch pads, too.
> 
> Jim
> 
> 
> 
> 
> -
> 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
> 


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

Re: Inserting pictures

[James Plante]

You've got View->Field Names toggled on. Go to View->Field Names and make sure 
there's no check mark beside the "Field Names" menu item. Then try again to 
place your picture.

Jim Plante

On Jul 27, 2014, at 2:08 PM, Donna Stanley  wrote:

> HELP! I have been trying, with no luck to insert a picture into a document 
> and have read everything I can find, plus tutorials, but still have the same 
> problem. I can neither drag and drop or go to Insert in the toolbar because 
> all I ever get is an icon and Graphic 1. What in heaven's name am I doing 
> wrong? I am using a Mac OS X. 
> Thanks.
> A very frustrated Donna Stanley
> -
> 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: Sneak in Scam

[James Plante]

It's a *telephone* scam, Doug. They call you, and tell you that there are 
problems with your Windows computer, and that they can repair them. I don't 
know what happens when you agree; maybe they have you log into their site and 
install malware, maybe they just charge you for the login. I just don't know. 
You see, when the caller completed his opening sentence, I said something very 
rude which may damage international relations--and hung up. I use a Mac, and I 
won't touch Windows with a vaccinated crowbar. (Personal choice.)

Jim Plante

On Aug 18, 2014, at 10:47 AM, Doug  wrote:

> 
> On 08/18/2014 09:44 AM, Vincent A. Juliano wrote:
>> I've had an indian company call me twice about my computer "Problems" and 
>> how they could fix them.  Each time the explanation got "murky" as we went 
>> long.  Each time I cancelled out.  Unfortunately I do not remember the 
>> company name.
>> 
>> On Aug 17, 2014, at 10:02 PM, carl wilson wrote:
>> 
>>> Dear Sir/Madam
>>> 
>>> There is an Indian based "Company" Techliveconnect that is using you as a
>>> means of convincing potential users that that they have major computer
>>> problems particularly when they download a piece of software called
>>> Driverdoctor. They appear to be a well organised scam with the charges going
>>> through a Dutch "company" called Avangate. Do you know of them
>>> 
>> 
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>> 
>> 
> Have you considered that the email itself may be part of the scam, and if you 
> answer it, you may be opening up yourself to some skullduggery?
> 
> --doug
> 
> -
> 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: Sneak in Scam

[James Plante]

Because many data service providers interface *only* through Internet Explorer. 
That can be handled. But the VB code the services use won't run on Mac or 
Linux. 

I'm a real estate appraiser and our local Multiple Listing Service uses a 
database/web application that runs only on IE. I've asked several times for 
just plain ascii access: Here's a map number, send me all the properties. He 
cannot do that, and his board won't let him change the software that they paid 
thousands for, and keep paying a high subscription fee for. I finally just 
cancelled my subscription and do things the old-fashioned way.

But mostly, I think using Windows is just a bad habit that's harder to quit 
than smoking.

Jim Plante

On Aug 19, 2014, at 9:57 AM, Doug  wrote:

>  I wonder why more people don't just come to Linux?


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

Re: open office enquiry

[James Plante]

On Aug 25, 2014, at 6:31 AM, Alan B  wrote:

>  So the NeoOffice support forum is your next step.

No, unfortunately it is not--unless you contribute $100/year for tech support. 
Neo has only one full-time engineer to maintain the program: Patrick Luby. And 
while he does give good value for the money, you cannot post questions to the 
support forum unless you maintain that contributor status. There are only two 
or three part-time coders who contribute.

(N.B.: I once had a problem with NeoOffice screwing up my inserted pictures, 
then crashing. I posted the problem and an example file on the support forum, 
and Patrick issued a patch within 90 minutes. He seldom takes more than a day 
or two to solve problems, although the knotty ones do take longer. His service 
is unsurpassed.)

I use NeoOffice on Mavericks (latest version). To unmerge cells, select the 
whole data set (not Select All...). From the main menu at the top of the 
screen, choose Format, then Merge Cells, then uncheck either Merge Cells or 
Merge and Center cells, whichever is checked. 

Now you can sort. Then, immediately save the file under a different name. Look 
carefully at your original data and the data that resulted from the sort. Do 
the data in the rows make sense? Is anything missing? Are they in proper sort 
order in all columns? Remember, to sort you must select the entire data set. If 
you select only a column, then that column is all that will be sorted; the rest 
of the data will stay as it was. 

You can get the latest NeoOffice from the App Store for free. It is one of the 
few programs in the App Store which notifies you of available patches or 
updates; it does not update automatically, but allows you to selectively eschew 
updates until you've finished your current project (just in case...).  Tech 
support must be paid for. Only you can decide whether it's worth it. 

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

Re: Disappearing fonts

[James Plante]

Try the Font Book app. Open the application, then look up the fonts that have 
"disappeared." Click on the font and see if it is labeled as "off". If it is, 
then right-click (or two-fingered tap; or Command click) to see the context 
menu. Enable the font. Quit Font Book, and see if that worked.

Jim

> On Oct 22, 2014, at 4:15 PM, Vincent A. Juliano  
> wrote:
> 
> About two months ago I upgraded my OS X from 10.6 to 10.9.6.  All went 
> well…..except that occasionally when I opened a file it would be blank.  
> Sometimes it was a new file.
> In the beginning I started deleting the empty file and then Voila’ by using 
> select all  I was able to select a different font and the information would 
> magically appear.
> 
> It pretty much slowed down in recent days but i’m sure it will happen again 
> and at a most inopportune time. (Murphy’s law anyone?)  
> 
> It used to occur only with Times New Roman font but now it happens with 
> different fonts. sometimes right after I correct it.
> 
> Does any one have any idea what is happening?
> 
> Does anyone have a fix for this problem?
> 
> It’s Halloween here but my ghosts are computer illiterate like me so we can 
> rule them out!
> 
> Thanks in advance


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

Re: Disappearing fonts

[James Plante]

One other thing you may want to do: Download NeoOffice from the App store. On 
Macs, it seems to work with fewer annoyances than AOO. It is Patrick Luby's 
rendering of the AOO source code. Being from the App store, it automatically 
updates itself in the background. And it just works.

You don't have to remove AOO in order to use Neo. They don't conflict; their 
files interchange smoothly; but they don't share data like directory paths, 
templates, AutoText, Autocorrect or Preferences. 

Jim

> On Oct 22, 2014, at 4:15 PM, Vincent A. Juliano  
> wrote:
> 
> About two months ago I upgraded my OS X from 10.6 to 10.9.6.  All went 
> well…..except that occasionally when I opened a file it would be blank.  
> Sometimes it was a new file.
> In the beginning I started deleting the empty file and then Voila’ by using 
> select all  I was able to select a different font and the information would 
> magically appear.
> 
> It pretty much slowed down in recent days but i’m sure it will happen again 
> and at a most inopportune time. (Murphy’s law anyone?)  
> 
> It used to occur only with Times New Roman font but now it happens with 
> different fonts. sometimes right after I correct it.
> 
> Does any one have any idea what is happening?
> 
> Does anyone have a fix for this problem?
> 
> It’s Halloween here but my ghosts are computer illiterate like me so we can 
> rule them out!
> 
> Thanks in advance


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

Re: Disappearing fonts

[James Plante]

Vincent,

### To download NeoOffice, do this: ###

Click the App Store icon in your dock. When the window opens, type "NeoOffice" 
in the search block in the upper right corner of the window. Click on the "Buy" 
tab at the bottom. 

If you want to keep track of the download, click on the "Purchases" tab at the 
top of the App Store window. You'll see a progress bar indicating the state of 
the download. 

When the download finishes, go to the "Downloads" folder; it should be on your 
Dock in the near vicinity of the Trash basket. Open the downloads folder, and 
double-click the NeoOffice .pkg file. It should unpack and start the 
installation dialogs. Just follow the prompts in the installation window, and 
it'll install.

After it is installed, go to the applications folder in the Finder, find 
NeoOffice.app, and drag the icon to the Dock. 

Click the icon in the doc, and Neo should open. (Note: It'll take some time for 
the initial opening while Neo loads all the fonts and does computer stuff in 
the background. After that, opening will take less time (I don't care to know 
why). It takes MUCH less time than MS Word to open. 

Now sit down and read all you can about Styles. See the help file, and the 
NeoWiki listings. Learn Styles well; become fluent. Styles is the heart and 
soul of the word processor, and they make life a whole lot easier. There are 
Page styles, Paragraph styles, Character styles, Frame styles, and Graphic 
styles. At least become familiar with all of them, and what they can do. Google 
"styles in NeoOffice" to see a wide assortment of articles. 

### Okay, to check up on that font problem, do this: ###

Open the Finder. Just so we're looking at the same stuff, select View -> as 
Columns (Cmd-3). 

In the left pane of the Finder window, select Applications. You should see all 
applications that are in the Applications folder listed vertically in 
alphabetical order. Scroll the column down until you see the Foot Book.app. 
Double-click it. 

From this point forward, all window references will be to the Font Book menu:
The left column begins with "All Fonts." Select your language here. Under 
"Smart Collections," I have available "English" and "Fixed Width." Select 
"English." 

Moving now to the second column, scroll down to see whether your "missing" 
fonts are present. They may be on your system, but are just turned off in Font 
Book. I had this problem with Mavericks having turned off my Century Schoolbook 
font. 

From here onward, I will assume that you've found the font family that went 
missing. I will further assume that it is Arial, just to provide an example. 

Select the Arial font. Now, right-click on it to show the context menu. (If 
you're using a touch pad, then a two-fingered click will do this. On a 
single-button mouse, Cmd-click will do it.) This menu provides the choice to 
Enable Arial. Select that. You want to right-click again, this time select 
"Resolve Duplicates." It sounds like you may be running into font conflicts; 
this should clear it up.

Now, quit OpenOffice and restart it. See if the above procedure fixed the 
problem. 

You'll have to do this even if you download NeoOffice, because the fonts that 
are available are controlled by Yosemite, not the OO application. 

Note that NeoOffice is derived from OpenOffice's open source code. It has a 
clean Aqua interface, and is much more Mac-like than AOO. It is maintained by a 
single engineer, Patrick Luby. Technical support is available at 
http://trinity.neooffice.org for $100/year. You may want to consider that. I 
once had a problem with NeoOffice losing my inserted photos. I posted to the 
tech support forum, then uploaded my problem and a sample doc to Bugzilla when 
requested. Ninety minutes later, Patrick had a test patch available for 
download that fixed the problem. Doesn't get much better than that. Patrick has 
a couple of people who provide part-time help in analyzing and testing 
problems, but he's the only coder; that's why he charges $100/year. 

Since NeoOffice is a spin-off of AOO, it operates the same. But it looks 
better. With respect to document operations, what works in AOO will work in 
Neo, and vice-versa. 

Regards,

Jim

> On Oct 24, 2014, at 9:37 AM, Vincent A. Juliano  
> wrote:
> 
> I  am being called out and will be back in four hours.  Please hold your 
> thoughts.  I prefer to download the NeoOffice but I don;t have time and I 
> need help to do that.  thank you so much
> Vince
> 
> On Oct 24, 2014, at 10:14 AM, James Plante  wrote:
> 
>> One other thing you may want to do: Download NeoOffice from the App store. 
>> On Macs, it seems to work with fewer annoyances than AOO. It is Patrick 
>> Luby's rendering of the AOO source code. Being from

Re: NeoOffice vs AOO - Was Re: Disappearing fonts

[James Plante]

Nope, you're still correct. That's for TECH support, though. You can still get 
help with "How do I" problems from forums like this one, since AOO and Neo 
operate pretty much identically. There's also NeoWiki, and of course Google. 
The reason Patrick went to the $100/yr support was because he just can't let a 
minor problem pass. He's got to tinker. He was wasting so much time with small 
quibbles that he couldn't get his main work done porting OOo to the Mac. So 
$100/year it is. But you're not likely to require actual tech support unless 
there's a really weird problem, which Patrick's testing will usually catch 
anyway.

Jim


> On Oct 24, 2014, at 1:54 PM, mt  wrote:
> 
> On 24/10/14 at 4:14 PM, jimpla...@me.com (James Plante) wrote:
> 
>> One other thing you may want to do: Download NeoOffice from the App store. 
>> On Macs, it seems to work with fewer annoyances than AOO.
> 
> Not sure this is really true. I have used both NeoOffice and Apache 
> OpenOffice, and have opted for the latter -no regrets.
> 
> The main issue I had with NeoOffice was the exorbitant cost of accessing 
> support - unless Patrick has changed his marketing strategy, one had to pay 
> at least $100 a year in order to be able to access the support forums.
> 
> Happy to stand corrected if that's no longer the case!
> 
> marina
> ---
> Italy or Australia
> MacBook Pro 2.5 GHz Intel Core i5, OS X 10.9.5
> MacBook Pro 2.4 GHz Intel Core 2 Duo, OS X 10.6.8
> www.mtadiello.com@martadiello
> 
> 
> -
> 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: NeoOffice vs AOO - Was Re: Disappearing fonts

[James Plante]

FYI, Patrick has submitted many code changes to OpenOffice (not AOO, though, to 
my knowledge). Few if any were actually implemented. Don't know why. Patrick 
isn't stingy, and you can download the source code and make your own changes 
and submit them wherever you like. I think he'd welcome new developers; on a 
few occasions before he went to the $100/yr fee he fairly begged for them. 
"Parasites" is a little too extreme when referring to NeoOffice. 

I've noticed a lot of posts on here that follow the theme of "Help! I 
downloaded OpenOffice and it won't start on my Linux/Windows box. What do I 
need to do?" Much of the time, they've downloaded from one of those parasites 
you mentioned, and have got a load of adware, spyware, or outright malware in 
the bargain--along with an outdated version of AOO. That isn't Apache's fault. 

The nice thing about Neo is that you get it only by d/l from Patrick or a 
couple of mirrors, or from the App Store. Therefore, uncorrupted. It also uses 
the Mac's native display system, so the fonts look cooler and the interface is 
what Mac users expect. AOO's is pretty clean, but Neo looks and behaves better, 
IMO. 

As far as support is concerned, see the prior posts. It's available. Patrick 
doesn't deal with HowTo's any more; he's been busy keeping up with Apple's OS 
changes. One cool result is that the latest version of Neo runs completely 
native--no Java or JRE required. 


Jim


 
> On Oct 25, 2014, at 4:36 AM, Larry Gusaas  wrote:
> 
> On 2014-10-25, 12:06 AM mt wrote:
>> On 24/10/14 at 9:23 PM, jimpla...@me.com (James Plante) wrote:
>> 
>>> Nope, you're still correct. That's for TECH support, though. You can still 
>>> get help with "How do I" problems from forums like this one, since AOO and 
>>> Neo operate pretty much identically. There's also NeoWiki, and of course 
>>> Google.
>> ...
>> 
>> Apparently we were both wrong -just found NeoOffice new support policy at 
>> <http://www.neooffice.org/neojava/en/contact.php>
>> 
>> So basically, NeoOffice is the same as AOO and uses the same free, 
>> user-based support network.
>> 
>> In the past, when NeoOffice was the only Mac alternative to AOO, there was 
>> no option but it. But now, with AOO already being available for Macs... why 
>> use NeoOffice at all?
>> 
>> Don't know, but I have a feeling it might also be on the way out altogether.
> They are a bunch of parasites. They charge for their product but don't 
> provide support.
> They use AOO code but do not contribute their code back to the project.
> The developer was fired by Sun (then owner of OpenOffice) and then quit 
> working on the Mac porting project.
> I have been using OpenOffice on Macs since I bought my first Mac in 2007.
> 
> -- 
> _
> 
> Larry I. Gusaas
> Moose Jaw, Saskatchewan Canada
> Website: http://larry-gusaas.com
> "An artist is never ahead of his time but most people are far behind theirs." 
> - Edgard Varese
> 
> 
> 
> -
> 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: ASF Code of Conduct

[James Plante]

Just a reminder, folks: Can we please avoid feeding the troll?

Jim

> On Nov 21, 2014, at 10:14 AM, Urmas  wrote:
> 
> "Dennis E. Hamilton":
> 
>> I find Rory's approach to be entirely within the spirit...
> 
> Giving generic advices cannot be 'in spirit' for any support. We can afford 
> people who have mettle to actually say the OP is an idiot who wants to 
> terminate his sentences with NumPad decimal dot, for example.
> Let's leave rote instructions and faux politeness to Hindu phone support, 
> shall we?
> 
> 
> 
> -
> 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: How Do I Change Text in the Legend of a Chart?

[James Plante]

To further illustrate Brian's points, try this:
Right-click on the sheet tab "SPH"; from the context menu, choose "Rename 
Sheet..." 
In the dialog, type "Single Point Hats" or whatever other name suits you. Click 
"OK".
Now check your data ranges again. You'll find that instead of "SPH" or "$SPH", 
it will read instead, "Single Point Hats" or "$Single Point Hats." 

See? You named the sheet. Or, whoever you received the sheet from did it. And 
you can change it if the existing name is too cryptic to suit you.

If you choose to change the data range, be sure to include the name of the 
sheet. 

Jim Plante


On Nov 24, 2014, at 10:43 PM, Brian Barker  wrote:
> 
> 
> At 18:40 24/11/2014 -0800, Fred Conly wrote:
>> Why anyone would use the designation SPH to refer to Sheet n is 
>> incomprehensible; ...
> 
> No doubt it stands for something to do with the spreadsheet's purpose. Ask 
> the author. Oh, look: that's you.
> 
>> ... why not, for example, SHn?
> 
> As I mentioned, Sheet1 etc. are indeed the default names. Someone thought 
> better.
> 
>> I understand what you say about multiple sheet references. In this case 
>> there is only one sheet of Data and one sheet of Chart.
> 
> Until you add another. Calc cannot know you won't. You cannot know you won't.
> 
> Brian Barker  
> 
> -
> 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: Multiple columns in header or footer?

[James Plante]

...or simply use two text frames. See the Help w/r/t Frames.

Jim

> On Jan 6, 2015, at 2:02 AM, Oliver Brinzing  wrote:
> 
> Hi Michael,
> 
>> I'd like to place a tagline on the right-hand side of my resume's
>> header, with my name and job title on the left:
> 
> insert a table without borders ;-)
> 
> Regards
> Oliver
> 
> 
> -
> 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: CSV Files

[James Plante]

Just to be a pedantic nit-picker, "csv" stands for "character separated 
values," not "comma separated values." You choose which character. 

Hence, the "9" in your arguments to tell it to separate with tabs. You can 
choose commas, semicolons, or just about any other character.

Jim

> On Jan 20, 2015, at 2:00 PM, Johnny Rosenberg  wrote:
> 
> 2015-01-20 12:49 GMT+01:00 Stuart Murray :
> 
>> When I save information as a CSV file it brings up the text import window.
>> I click on ok and then it always opens the file. Is there a way of
>> preventing the file from opening when I click on ok? I do this several
>> times a day every day so each file saved needs to be closed after it is
>> saved. It's not the end of the world but it would save a little time each
>> day and the make the process sleeker for the dozen or so files I am saving
>> all at the same time each day.
>> 
>> Many thanks
>> 
>> Stuart
>> 
>> 
> I'm afraid I can't answer your question, but I still have something to say,
> I think.
> 
> I had a couple of spreadsheets that I needed to convert to csv (or rather
> tsv – Tab Separated Values, but I still used the .csv suffix) and copy it
> to my Android phone, so I could view it there with a simple csv app…
> 
> I used a macro for it and I ran the macro by pushing a button that I added
> to the first row of the spreadsheet. That row is always visible, since I
> use the Freeze feature, otherwise I could run the macro from the keyboard,
> add a menu item or something.
> 
> Anyway, I only needed this for one or two particular document, so some
> things in my macro are hard coded. I just wanted to get the job done, so to
> speak…
> 
> Here it is. If you want to use it, you need to edit at least the hard coded
> path (which is faked in this version anyway)…
> I removed the part where it moves the csv to the phone, since that part is
> done by a Bash script anyway, called from the macro.
> 
> Sub SaveAsCsv
> ' Place the cursor at the first unused row.
> Call SelectRow
> 
> ' Then, save the spreadsheet.
> ThisComponent.store()
> 
> ' Now, save the active sheet as CSV.
> Dim PropVal(1) as New com.sun.star.beans.PropertyValue
> PropVal(0).Name="FilterName"
> PropVal(0).Value="Text - txt - csv (StarCalc)"
> PropVal(1).Name="FilterOptions"
> REM You need to edit the line below if you prefer saving as csv rather than
> tsv.
> REM I don't remember which number means what, but I remember that I
> REM ”Googled it” to determine the number that I actually used. A wild guess
> REM would be that the 9 means TAB (since that is its ASCII-code), but I'm
> REM sure some ”Googling” will get the right numbers for you.
> PropVal(1).Value ="9,34,0,1,1"
> 
> Dim FileURL As String, FilePath As String
> REM The next line needs to be edited. I'm not sure why I hard coded the
> path,
> REM but I think I remember that I just couldn't find another way at the
> time being.
> REM I still would like to know, so if anyone… There should be a simple way
> to
> REM find out the path to the current file, shouldn't it? I think there were
> some
> REM discussions about this in this mailing list, but I don't remember if
> anyone
> REM finally figured it out…
> FilePath="/some/path/to/this/file/"
> FilePath=FilePath & ThisComponent.getTitle()
> FileUrl=ConvertToUrl(FilePath)
> FileUrl=Left(FileUrl,Len(FileUrl)-3) & "csv"
> ThisComponent.StoreToUrl(FileUrl, PropVal())
> End Sub
> 
> Sub SelectRow
> Dim Row As Integer, Sheet As Object
> Sheet=ThisComponent.Sheets.getByName("Tider")
> Row=Sheet.getCellByPosition(0,0).getValue()
> SelectFirstEmptyRow(Sheet,0,Row)
> End Sub
> 
> Sub SelectFirstEmptyRow(Sheet As Object, Column As Integer,Row As Integer)
> Dim Cell As Object
> Dim Ranges As Object
> 
> Cell=Sheet.GetCellByPosition(Column,Row)
> 
> SelectCell(Sheet,Column,Row)
> End Sub
> 
> Function SelectCell(Sheet As Object, Column As Integer,Row As Integer)
> ' Select and highlight the cell
> ThisComponent.CurrentController.Select(Sheet.getCellByPosition(Column,Row))
> SelectEmptyRange
> End Function
> 
> Sub SelectEmptyRange
> Dim EmptyRange
> 
> EmptyRange=ThisComponent.createInstance("com.sun.star.sheet.SheetCellRanges")
> ThisComponent.CurrentController.Select(EmptyRange)
> End Sub
> 
> 
> Read the REM lines above for more information…
> 
> 
> 
> Kind regards
> 
> Johnny Rosenberg
> ジョニー・ローゼンバーグ


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

Re: Open Office Software

[James Plante]

Why don't you just use iBooks Author and be done with it? 

To answer your first question, AOO won't integrate with iWork09. You'd have to 
save your iWork doc as a .doc or .txt first, then you can open it with AOO 
Writer. 

And Lester's prophesy fails: All three platforms can read .jpg files.

And Lester, please stop the religious stuff. It's out of place here. 

> On Jan 23, 2015, at 7:51 AM, Gordon Rouston  wrote:
> 
> I have a IMAC, Yosemite with iWork 09 and pages, how ill your software 
> integrate with mine. 
> 
> Gordon Rouston
> 
> PS working with IBOOKS to publish my book on IBOOKS, converting a PDF to   
> edit book with Wondershare, will your word processing work for what I am 
> doing?
> 
> Thanks
> -
> 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: Problem: Canon MG5650 printer with Open Office documents

[James Plante]

Peter, here are some random thoughts:

Have you tried downloading the most current printer driver from Canon? 

If your computer is 6 to 8 years old (or older, as you say), it could be that 
the printer driver is incompatible. You may need to download an earlier driver. 

Please tell us which OS you are running and which version of that OS.

Jim


> On Feb 23, 2015, at 6:45 AM, Peter D.  wrote:
> 
> 
> Monday 23 February 2015, 12h45
> 
> A few minutes ago I thought I would again try the printer ...(  Sometimes 
> devices manage to cure themselves ... )
> I attempted to print a letter
> 
> (  The printer was switched off about mid-afternoon Saturday 21 Feb 2015 - 
> has not been on, has not been used since then   In the email below (sent 
> today 10h14) I tell you the printer printed well from other sources. I wrote:
>  "   Tesco Support established the printer functions 
> satisfactorily when printing from other sources ...  "
>   The "other source" was a page from BBC news  )
> 
> The printer printed from three-quarters of the way down the page(missed the 
> rest of the letter)andthe printer printed (upside down) the header and the 
> end of the BBC page:
>   " BBC News - Home 
> Page 4 of 4
> 
>  http:/www.bbc.co.uk/news
> 21/02/2015  "
> 
> I think this is odd !!!
> 
> 
> 
> PDG
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Monday 23 February 2015, 10h14
> 
> Good morning!
> 
> I have a problem ...My major problem may be my ignorance (lack of knowledge & 
> lack of skill) using a PC ... ???Please will anyone offering wise counsel 
> bear this in mind
> 
> -
> 
> Background
> For 6 or 8 years (or longer)  I have been using Open Office to write 
> lettersInitially I used a Canon i560 to print these lettersLatterly I used a 
> Canon iP4600 to print
> Last week the iP4600 ceased to function
> I bought a (new) Canon MG5650 from Tesco
> 
> -
> 
> I installed the MG5650
> The printer dd not function wellIt crunched up the first sheet of paperIt 
> punched two holes in the second sheet of paper
> (  I was worried and  (Friday 21 February 2015)  I consulted with Canon 
> Support in The Netherlands - at length )
> Eventually (with the guidance of Canon Support) it began to perform properly 
> (it seemed to perform very well ... ?)BUT - the printer would not print 
> letters from Open Office "Documents"Canon Support said the problem was with 
> Open Office, not with the printer
> (  By this time it was 17h00, and, Canon Support closed )
> I tried to print (click on the icon on the third row from the top of the 
> screen) a letter from Open Office "Documents"I could not print
> (  I was worried and (Saturday 22 February 2015) I consulted Tesco Support - 
> at even greater length (for hours)  )
> The iP4600 was still the printer shown (the default printer)
> Having installed the MG5650 ... with the help of Tesco Support I tried to 
> delete (remove) the iP4600 from the systemEntering " Devices & printers " I 
> identified and deleted the iP4600( At least, the iP4600 vanished from the 
> page )
> But - when I tried to print, the iP4600appeared as the default printer
> I again looked in " Devices & printers " - the iP4600 was (still) displayed; 
> it had "returned"I again deleted the iP4600But the iP4600 returned - again 
> and again
> Eventually ... the iP4600 vanished from "Devices & printers" (it seems it has 
> vanished)Eventually ... only the MG5650 is shown in "Devices & Printers"When 
> I click on the icon "print" the default printer now is the MG5650 - this is 
> progress !!!
> (  All this about deleting the iP4600 may be irrelevant - I do not know   
> Accordingly, I tell you, I inform you - I am sorry if this is wasting your 
> time )
> 
> 
> NOW TO THE MATTER IN HAND - THE PROBLEM
> 
> 
> (Using the MG5650)  I was still unable to print properly from Open Office 
> "Documents"
> Tesco Support guided me through all manner of efforts to resolve this 
> problem( Tesco Support devoted more than 2 hours to me and my problem)
> Tesco Support established the printer functions satisfactorily when printing 
> from other sources ...
> When printing from Open Office  "Documents"  2 problems are manifest (or 
> appear to be manifest)
> First:  (in spite of the "display" showing the letter correctly)  the print 
> begins three-quarters of the way down the page ...  then continues to 
> print previous letters stored in "Documents"  the printer does not 
> start from the beginning of the letter selected Second: it seems the 
> printer sometimes "picks up", prints two letters (documents) one over the 
> other on the one piece of paper thus two series of printing 
> overlay each other - both semi obscured 
> Tesco Support spent even more time with me ...Tesco Support suggested trying 
> Libre Office ...We didThe result was the same as with Open Office - both 
> prob

Re: mortgage amortization with loan tracking for PITI payments

[James Plante]

Michael,
You'll never learn how if someone else does it for you, and these mortgage 
amortization sheets are an easy place to start. They're complicated enough to 
make you think, but not so much that you can't shoot your way out of a corner. 
Additionally, nobody thinks the same way you do, so if you learn how to build 
the sheet yourself, you'll be able to customize it to get exactly what you want.

Begin by collecting (and naming) your known values: Principal, annual interest 
rate, term of the loan in years, annual insurance, annual taxes. Put those in 
the upper left corner of the sheet, one on each row, and label them. E.g., 
A1=principal; B1 = principal amount; C1 = blank. A2 = Term (years); B2 = length 
of mortgage; C2 = B2*12 (the total term of the loan in months). A3 = Annual 
rate; B3= APR of loan; C3 = B3/12. 

You get the idea. Let column A be the label for the commonly-used terms of a 
loan. Column B is the actual value of those terms; and column C is the periodic 
value--the one you'll be using in formulas. You'll have an easier time keeping 
track of things if you name those periodic values using Insert->Names...Define. 
Name them something that makes sense to you. 

Now set up the columns for your amortization schedule right below the known 
values. 

You know the principal amount of your loan and the annual interest rate. Use 
the PMT formula to find the monthly payment amount: =PMT(number of years * 12; 
annual rate / 12; remaining principal). There are two more parameters that can 
be passed to the PMT function, but in this case both are zero and can be 
ignored. (See the function wizard and the help.) For the first payment, you'll 
use the principal of the loan as the starting value. For all subsequent 
payments, use the *remaining* principal.

Once you have the monthly payment (which includes monthly interest), you 
calculate the interest portion by multiplying the principal that you used in 
the PMT formula times the monthly interest rate, like this: = (annual rate / 
12) * principal

Subtract the interest portion from the total payment, then subtract the 
remainder from the principal to get the remaining principal. Use that remaining 
principal as the "principal" in the next line's PMT calculation. 

You know your annual taxes and insurance, so simply divide those amounts by 12 
to arrive at the monthly amounts. To find your total monthly payment, add the 
result of the PMT function to the monthly tax and insurance contributions. 

That should get you going. Write back when you get stuck. (And I'm sure you 
will. Always happens to me, at least.) 

Jim Plante

> On Feb 27, 2015, at 2:12 PM, mellowmyc...@gmail.com wrote:
> 
> As I am very green in this area I am searching for a program that I can use 
> to track PITI payments that I can set up to track my monthly payments. I will 
> know my loan amount, interest rate, annual insurance and annual property tax 
> liabilities. Inputting those variables I need to determine monthly payments. 
> As the payments are entered I should see a running total of escrow balances, 
> interest paid, principal paid and new loan amount.
> 
> I know this is simple enough for most people to find, but these financial 
> spreadsheets are a little difficult for me to navigate so if I could be 
> pointed in the right direction of existing software for me to use, I would 
> really appreciate the help.
> 
> Thank you in advance for your assistance.
> Michael B.


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

Re: HELP!!!

[James Plante]

!. This is not a company.
2. It is a mailing list consisting of mostly users (as opposed to developers) 
of AOO.
3. All the users are real, except for the ones that are virtual. 
4. Virtual users are controlled by an Artificial Stupidity System; don't listen 
to them.
5. Please tell us what problem you're having, and maybe the rest of us can 
help. 

Seriously, this is a free product. Nobody gets paid for helping anybody else, 
so our tolerance for acerbic remarks is somewhat limited. Tell us where it 
hurts.


> On Mar 26, 2015, at 12:00 PM, Phil Fitzpatrick  wrote:
> 
> How do I speak to a REAL person at this company so I can get some REAL
> help???
> 
> Phil Fitzpatrick
> Duluth, MN


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

Re: Check Register

[James Plante]

Ted, 
I'm making some assumptions by answering this. It sounds to me as if you're 
using some template that may have been delivered with your software. It also 
sounds as if you did not download Apache OpenOffice from the approved site. 
Going to http://www.openoffice.org should redirect you to the Sourceforge site. 
Selecting Download for OSX should take you to the download page, and from that 
point on, don't do anything. The download starts automatically. I haven't been 
to that page in a while, but last time there were ads for stuff with prominent 
download buttons. Do NOT click any of those. Let the automatic download do it 
for you. THERE IS NO CHARGE for Apache OpenOffice. And there usually are no 
templates in the download. So what you may have done is downloaded and paid for 
a checkbook template.

> On Apr 15, 2015, at 1:43 PM, Ted Watt  wrote:
> 
> April 15, 2015
> 
>  After recently discontinuing Quicken I needed a simple form to record my 
> checking account activity.  I spent endless hours on line checking as many as 
> I could find before choosing OpenOffice.  I liked the simplicity and 
> flexibility of your offering, and downloaded  it on Monday, Apr. 13.  I then 
> commenced  trying to fine tune the format and entering my account activity 
> from the beginning of the year.  Getting the format as I wanted it was 
> challenging, but I got it pretty much as I wanted it.  When I finished as 
> much as I could on Monday just prior to shutting down my computer I thought I 
> somehow lost everything that had so far been accomplished.  No way could I 
> get my check register back up! But, happily, on Tuesday when I started up my 
> computer I got my check register back up with all that I had entered.  I then 
> spent several more hours on entries, sometimes losing everything, but then 
> getting it back.   However, just prior to quitting for the day I’ve no idea 
> what I was doing, but again I lost “checkbook.”  Tried several times to find 
> it, but no luck.  I figured perhaps I’d be lucky again on the next start-up 
> (today), but not so.  I worked on it for a couple hours, but finally gave up 
> in exasperation.  I had hoped to be abel to call for some assistance, but 
> apparently phone service is not available.  
Did you save the document? Can you locate it using the Mac's Finder? If so, 
it's still there.  
> 
> At this point I’m extremely unhappy.   How I could create so many problems 
> with something so seemingly simple is extremely frustrating.  I will now 
> start over from scratch for one last try.
> 
> Here are a few questions that occurred while I was working on “checkbook”:
> 
>   Is it normal that the “balance” figure should show in every balance 
> cell below it?
It is if the cell formula allows it. If the cell formula in "balance" does not 
begin with "=IF(", then you're seeing what you should be seeing. It's not good 
practice to fail to check for a valid entry, but it's the easy way to get the 
cell to display.

>   How can I change the document title?
File->Save as... Then use that filename.

>   Between the doc title and column titles what is the purpose of the 3 
> column bold rectangle?
That's probably some merged cells designed to hold the document title, e.g., 
"Register 2015" or something similar. If you don't want it, then select that 
merged block and choose Format->Merge Cells, then uncheck "Merge" or "Merge and 
Center cells" as appropriate.

>   When I make a column to be all one color (by scrolling down the column) 
>why do all the dividing lines disappear?
Probably because you don't have the dividing lines turned on in Preferences, 
but I'm guessing. The displayed lines are "ghost" lines, so that you can keep 
track of what you're doing on the screen. They won't print unless you tell them 
to. 

>   Is there any reason why the format (i.e. left, center, right etc.)of 
> entries in any column cannot be changed?
No. Select it first, then choose the alignment that you want. 
> 
> My computer is Mac OS X 10.10.2.
> 
> Oh, by the way, for some unknown reason I had to pay $4.99 for the download 
> which I keep seeing on your website is free - receipt #2765-1435-5460-2762 
> from Sourceline Media.com.  If I can get it to work it will be well worth it.

Sourceline Media.com is not Apache OpenOffice, nor is it Sourceforge.net. You 
downloaded from somebody else. 
> 
> 
> 
> Regards,
> 
> Ted Watt
> wattad...@gmail.com
> -
> 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