Re: Change of background color

[Chuck Spalding]

You can change the background color at

OpenOffice > Preferences > OpenOffice (group) > Appearance


(That's the sequence on a Mac. Windows might be different.)

For the "Document background" selection, choose Automatic (above Black in
the list).

Chuck


On Mon, Oct 21, 2019 at 8:03 AM Peter  wrote:

> All Open Text items, including Text and Spreadsheets the two I use most
> frequently.
>
> The background is now Black
>
> Tx
>
> Peter
>
> Sent from Mail for Windows 10
>
> From: Steven Ahlers
> Sent: October 21, 2019 10:46 AM
> To: users@openoffice.apache.org
> Cc: pdea...@sympatico.ca
> Subject: Re: Change of background color
>
> Peter,
>
> In What type of document are you trying to change the background color?
>
> Please reply to: users@openoffice.apache.org
> so that all users can assist you.
>
>
> > On Oct 21, 2019, at 9:26 AM, Peter  wrote:
> >
> > I would like to change the background color but don’t see how
> >
> > Tx
> >
> > Peter de Auer
> >
> > Sent from Mail for Windows 10
> >
> >
>
>
>

Re: OpenOffice 4.1.7: No page borders

[Chuck Spalding]

To be a bit more clear than the previous response, I believe you want

Format -> Page... -> Page

and then set the page margins.

The Borders settings define a line border around the text area defined by
the margins.

On Sat, Nov 23, 2019 at 3:34 PM JD  wrote:

> Hi,
> I tried to create a document without any left, right, top, or bottom
> borders via
>
> Format->Page->Borders
>
> which I set to 0.
>
> But the editor keep starting text at .5 inch offset from the left page's
> edge, and wraps at .5 inch offset
> from right page's edge.
>
> How do I prevent this from happening?
>
>
> Thanx
>

Re: Open Office cannot check for updates

[Chuck Spalding]

Checking for updates works for me (OO 4.1.7 on Mac OS X 10.12).

Chuck

Re: American Spell Check problem

[Chuck Spalding]

I, too, am not a regular Windows user, but I believe you're supposed to use
forward slashes ("/") instead of back slashes ("\").

Chuck

On Sat, Jan 18, 2020 at 3:34 AM Rory O'Farrell  wrote:

> On Fri, 17 Jan 2020 17:20:35 -0500 (EST)
> MICHAEL SHIELDS Owner  wrote:
>
> > I hate to sound Illiterate, but am I supposed to enter the address with
> percentage points as well. I assume the Windows explorer bar (address bar)
> is at the top of the screen
> >  and not at the address bar a few inches under?  I hate when it comes to
> computer terms, etc.
>
> Enter exactly as I set it out.  Not having used Windows in any detail for
> over ten years I cannot navigate around it for you, but if you click on the
> icon of a disk drive, I think you should enter that line in the address
> line of the Window that then opens.
>
> Rory
>
>
> > - Original Message -

[snip]

> > To fix this, rename your OpenOffice user profile.
> >
> > As you are using Windows close OpenOffice and the Quickstarter.
> >
> > Open File Explorer. Copy and paste %appdata%\OpenOffice\4 in the File
> Explorer (sometimes called Windows Explorer) Address Bar and press Enter.
> >
> > Rename the "user" folder - "user.old" is a good choice.
> >
> > Now restart OpenOffice.
> >
> > Start OpenOffice.--
> > Rory O'Farrell 
> [snip]
>

Re: [AOO-Templates]

[Chuck Spalding]

Alan,

Your guidance sort of works for me (OO 4.1.7 on Mac OS 10.12.6). If I do
not have any document open, the menu selection *File > From Template...*
works as expected. But if I have any document open (Writer or Calc), the
selection *File > New > Templates and Documents* does nothing—the *Templates
and Documents* dialog does *not* open as claimed in the documentation.

I can't resist mentioning that it's not obvious that one should look at
documentation for version 3.3 when using version 4.1. Also, it's
"interesting" that the *What's New* section of the documentation page
 contains only two items
from 2013. (Yes, I know it's a volunteer organization.)

Chuck

On Wed, Jan 29, 2020 at 10:22 AM Alan B  wrote:

> Hi Susan,
>
> Sorry you've invested so much time without success.
>
> The following instructions worked for me...
> 1. the web page with links to the instructions
> OpenOffice.org 3.3 User Guides (ODT) - Apache OpenOffice Wiki
> <
> https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/OOo3.3_Chapters_ODT
> >
>

[snip]

Re: Open office

[Chuck Spalding]

I use OpenOffice on macOS High Sierra. The webpage
 referenced by another
response states that OpenOffice 4.1.7 is compatible with MacOS X Lion
(10.7) through macOS Catalina (10.15).

To answer your other question, the  OpenOffice download is "~ 163 MByte".
It can be obtained here .

Chuck


On Tue, Feb 18, 2020 at 12:22 PM Mark Holmes 
wrote:

> Hi,  will this work with mac os high serria.  Also due to data
> restrictions, what is the size of the download
>
> Regards
>
> Mark Holmes
>

Re: Loading dictionary extension

[Chuck Spalding]

The text refers to version "20200*2*01", but the link goes to version "20200
*1*01". I believe the correct link is:

https://sourceforge.net/projects/aoo-extensions/files/17102/51/dict-en-20200201.oxt/download

When I double-click on an OXT file (with OpenOffice 4.1.7 for Mac),
OpenOffice freezes (and has to be forced quit). I eventually got the file
to be read ( a few days ago), but unfortunately I don't remember how I did
that.

Chuck


On Wed, Feb 19, 2020 at 1:19 AM Rory O'Farrell  wrote:

> On Wed, 19 Feb 2020 15:59:45 +1030
> Greg Mayman  wrote:


[snip]

The dict-en-20200201.oxt file is available for download from
>
>
> https://sourceforge.net/projects/aoo-extensions/files/17102/50/dict-en-20200101.oxt/download
>
> When it is downloaded, double click it to install.  Do not try to install
> with the file on the remote site.
>
> --
> Rory O'Farrell 
>
[snip]

Re: Using Open office

[Chuck Spalding]

David,

OpenOffice can read/modify/save files in DOC/XLS format. One can even set
preferences to use those formats by default when creating files.

I don't know why, but the OpenOffice community seems to strongly resist the
use of DOC/XLS file formats instead of the "native" ODT/ODS formats.
There's a long posting
 on the
OpenOffice forum about file formats. The claim is made that saving content
as a DOC/XLS file will "almost certainly ... lose content and/or
formatting" (that's stated in bold, red text near the top of the posting).

If that's an issue for your files, then the proposed PDF approach seems to
be the easiest solution.

Personally, I have *many* files in DOC/XLS formats on my Mac, and I use
OpenOffice exclusively. (My reason for using the "foreign" formats is to be
able to use the Quick Look feature to see file contents without actually
opening a file with OpenOffice.) I do not exchange files with others, so I
don't know what compatibility problems there might be, but working in those
"foreign" formats seems to be fine within my system.

Chuck


On Thu, Feb 20, 2020 at 4:06 AM David Hunt  wrote:

> I have started using Open Office on my HP PC, with Windows 10.
> Sadly any document I send out can be read by other windows users, but I
> phone and some I pads complain that all documents are scrambled or Zipped.?
>
> Any suggestions please.
> I do not have Microsoft Office any more, corrupted and Microsoft support
> totally unhelpful.
>
> Dave  Thanks in hope.
>
> Sent from Mail for
> Windows 10
>
>

Re: Failure

[Chuck Spalding]

Hello,

Please note that "Apache" has the domain name "apache.*ORG*", not "apache.
*COM*". It is not a commercial organization, which you can see if you visit
their website .

Regarding how to contact "Apache", have you tried looking at their website?
(When I do a Google search for "apache", the apache.org site is listed at
the *top* of the results.)

You could also look at the OpenOffice website
 (which,
again is a .ORG site).

As somebody else wrote earlier, please calm down. You are not being ripped
off.

Regards,

Chuck


On Thu, Mar 12, 2020 at 12:24 PM  wrote:

> This is ridiculous!  This message goes to all users--not to Apache!
> How is Apache contacted?  I can't get anything but a bunch of garbage in
> my online searches.
> FYI.  The original disc was purchased at Sam's Club several years ago and
> has been updated free of further charges thereafter.  I have never seen
> anything that says the program was originally free of charge.
>
> -Original Message-
> From: jhivacaville 
> To: users 
> Sent: Thu, Mar 12, 2020 10:13 amubject: Re: Failure
>
> YOU PROVIDED THE LINK FROM WHICH TO DOWNLOAD!  I USED THIS LINK!  AREN'T
> YOU AWARE OF THE LINK YOU PROVIDED?
> I am using the latest updated version of Windows 10.
> AGAIN!  I have the most recent update of the program I purchased several
> years ago.  The program now fails to fill the background of the cells with
> those colors from the color chart provided.  In reviewing older saved
> files, I find that the background colors have also been removed.
> I have also used the app on Windows 10 that is supposed to make older
> programs compatible with Windows.  This also does not work.
>
>
> apache.org>; jhivacaville 
> Sent: Thu, Mar 12, 2020 8:17 am
> Subject: Re: Failure
>
>
>  Original Message 
> From: jhivacavi...@aol.com
> Sent: Thursday, March 12, 2020, 14:54 UTC
> To: users@openoffice.apache.org
> Subject: Failure
>
> > I downloaded from the provided link.  The installation does not install
> the desktop icon and it does not fill the background of the cells as
> previously related.
> > Is this a scam/sham?  What good is the program if it does not work
> properly and completely?
>
> It would help us to answer your question if you provided adequate
> information about your issue:
>
> 1. Which link are you referring to?
> 2. Which operating system are you using?
> 3. Can you provide more detailed information about your issue.
>
> Several million other users are not experiencing the same problem.
>
> --
> Please address any reply to the mailing list users@openoffice.apache.org
> only. Any messages sent to my personal address are automatically deleted
> from the server and will never be read.
>

Re: Microsoft has converted my OpenOffice documents

[Chuck Spalding]

They probably did not "change the files". They probably changed which
program will, by default, open files with various file types (e.g., DOC and
XLS).

If that's the case, you need to change the file-to-program associations.
That does not involve any change to the file contents.

Chuck

On Mon, Mar 23, 2020 at 6:55 PM larry phillips
 wrote:

>  I had the same problem with it and I do not use office. The computer shop
> put a trial
> version on my computer when they file converted my files from the old
> computer to the
> new one or Microsquish included it in their windows. I do not want it or
> need it so I am
> probably going to delete it off my computer. I am incensed the Seattle
> jerks set up their
> software to go in and change the files on my computer.  Larry P
>
[snip]

Re: Email App from Openoffice

[Chuck Spalding]

I have the "opposite" question: I *want* the behavior the original poster
described.

How do I configure OpenOffice (on a Mac) to use Gmail as the mail
"application"? The method suggested to the OP doesn't seem applicable,
since Gmail is accessed through a browser—that is, the "application" is the
browser.

I tried putting the path to the browser in Preferences > Internet > E-mail
> E-mail program, but that didn't work (which is not surprising).

(For the record, I do not have the Apple Mail application configured, since
I never use it.)

Thanks in advance for any help.

Chuck

On Tue, May 12, 2020 at 6:56 AM Martin Groenescheij 
wrote:

>
> On 12/05/2020 10:55, Anan Narang wrote:
> > Hi
> >
> > I have been using open office for a while on my macbook, on most of the
> files i have client contact emails, usually when i click on these email
> address, the apple mail application open up for me to continue writing the
> emails to selected email address from the .ods file, however this seems to
> have changed i recently downloaded new version of open office, and when i
> now click the email address links on the file instead of apple mail opening
> up the web browser open with my gmail account.
> >
> > How do i change this back to opening to Apple mail
>
> From the Help File "On UNIX systems, specifies the e-mail program to
> use when you send the current document as e-mail."
> Go to Preferences -> Internet -> E-mail and browse to your desired mail
> application
>

[snip]

Re: MAC OS - Still cannot eliminate OO icon from Mac desktop when program running

[Chuck Spalding]

Dan,

It appears that that you are opening the OpenOffice program from within the
downloaded dmg file (i.e., from the window described below). That file
contains a virtual disk that contains the program and other files. You are
supposed to copy the OpenOffice program from that virtual disk to the
Applications folder on your computer.

The steps for installing OpenOffice on a Mac are as follows:

1. Download the OpenOffice distribution file
Apache_OpenOffice_4.1.7_MacOS_x86-64_install_en-US.dmg.

2. Double click on the icon for the dmg file (i.e., wherever it got
downloaded to), which will (a) mount the virtual disk contained in the dmg
file, which creates an "OpenOffice" icon on the desktop, and (b) display
the virtual disk's contents in a window named "OpenOffice" (which is the
"screen" referenced in the instructions that you quoted).

3. *In that "OpenOffice" window*, drag the "OpenOffice.app" icon to the
"Applications" icon (also in that window—it is an alias for the actual
Applications folder). (You appear to have dragged the "OpenOffice" icon
from the desktop to the Applications folder, which is not the same
thing—different name and different source location.)

4. Close the "OpenOffice" window.

5. Select (single-click) the "OpenOffice" icon on the desktop, and select
File > Eject "OpenOffice". (You could also right click [or hold down
Control and left click] on that icon and select Eject "OpenOffice" from the
menu that is displayed.)

6. Drag the downloaded dmg file to the Trash (or save it somewhere for
[unlikely] future use).

Then, to use OpenOffice, double click on its icon in the Applications
folder.

If you want to avoid having to go to the Applications folder (or the
Launcher?) each time you want to use OpenOffice, you can keep its icon in
the Dock permanently.

I hope this helps,

Chuck

P.S. For the record, I have not looked at the instructions posted on the
OpenOffice website.

Re: EXPORTING NARRATIVE FILES

[Chuck Spalding]

Perhaps he's using a Mac, on which the print dialog for all(?) applications
(definitely including OpenOffice) provides the ability to "print to PDF".

Chuck

On Tue, May 26, 2020 at 2:26 PM Brian Barker
 wrote:

> At 15:06 26/05/2020 -0500, Steven Ahlers wrote:
> >I generally generate PDFs from the print dialogue: from File menu
> >choose Print, in bottom left corner there's a button to start the
> >PDF dialogue which allows you to name the file and where you want to save
> it.
>
> Really? Then you cannot be using OpenOffice! There is no such button.
>
> The only way to can use the Print dialogue to create a PDF version of
> a document is if you happen to have a PDF virtual printer installed
> on your system. That is quite a useful thing to have and you might
> want to recommend it to others, but it is not a part of OpenOffice
> and you cannot assume others will have it.
>
> Brian Barker

Re: MAC OS - Still cannot eliminate OO icon from Mac desktop when program running

[Chuck Spalding]

Dan,

I don't know how you did it, but you do not have the OpenOffice
*application* in your Applications folder. (You could [single] click on
that icon and type Cmd-I [File > Get Info]. If I were a betting person, I
would bet the Kind is "Volume", not "Application".) Furthermore, I can't
imagine how clicking on the disk icon would go directly to the application.

You need to remove whatever "OpenOffice" icon you have in the Applications
folder, and start over. After double-clicking on the downloaded dmg file, a
window named "OpenOffice" will open. *Staying totally in that* *window*,
drag the icon "OpenOffice.app" and drop it on top of the "Applications"
icon *in that window*. Then, when you open the Applications folder, you
should see "OpenOffice.app" (with a size of about 400MB), and Get Info will
show it as an Application.

I just thought of another possible source of confusion. You have two
Applications folders that can come into play. One is the "system"
Applications folder (e.g., at the path /Macintosh HD/Applications), and one
is in your "personal" Applications folder (e.g., at the path /Macintosh
HD/Users//Applications). You want the OpenOffice app to be in
the "system" folder. However, regardless of which Applications folder
contains the "mystery" file, I don't understand the behavior you describe.

Good luck,

Chuck


On Tue, May 26, 2020 at 7:51 PM Dan at News Media Services
 wrote:

>  Hi Dave,Thank you for your response.Here is what I did, after reading
> your notes:
> Quit Open Office by selecting"Quit" in OO menu bar.Ejected OO disk icon
> that remained on desktop.Opened the Application Folder located in the Dock
> on desktop.Selected and clicked on OO icon in application folder.OO disk
> icon again appeared on desktop.Clicked on OO disk icon to start program.OO
> start bar appeared and loaded on desktop.OO files opened, as usual.
> Everything above is what I go through each time I quit OO.
> The disk icon never goes away while OO is open.If I try to eject the OO
> disk on the desktop, a message says because OO files are opened, I have to
> Force Eject. This would terminate the OO program, until I relaunch it.
>

[snip]

Re: Open Office Spreadsheet question

[Chuck Spalding]

Using OpenOffice 4.1.7 on macOS High Sierra (10.13.6), I do not see that
menu selection in *Calc*. (I do see View > "Nonprinting Characters" in
*Writer*.)

Chuck

On Fri, Jul 10, 2020 at 1:14 PM Martin Groenescheij 
wrote:

>
>
> > On 10 Jul 2020, at 21:50, Glenn Little WB4UIV <
> glennmaill...@bellsouth.net> wrote:
> >
> > How can I display non printable characters?
>
> Top menu select View than select View non printable characters
>
> [snip]

Re: Open Office/Apple macOS 11

[Chuck Spalding]

David,

Note that the address you sent your message to is "*users*@
openoffice.apache.org". We are *users* of OpenOffice like you, not the
*maintainers* of the software.

There is a "support forum" at this address:
http://forum.openoffice.org/en/forum/ .

You might also be interested in the bug-tracking system at
http://bz.apache.org/ooo/ .

By the way, it would have been helpful if you had included a link to (or
the content of) the "Announcement of 6th January". I don't recall that
announcement, and I can't find it in the archive of messages sent to
users@openoffice.apache.org, so I can't tell what problems you are having.
Perhaps you were referring to this message that was posted on *4th* January:

From: Dave Fisher 
Subject: Re: Apache for Mac Big Sur?
Date: 2021/01/04 18:28:10
List: users@openoffice.apache.org

Hi -

What fails currently with OpenOffice on BigSur is opening Microsoft Office
Open XML files - docx, xlsx, pptx, and the rest.

A new release 4.1.9 is in the pipeline which has been confirmed by French
user forum members to fix this issue.

The release will take a week to three weeks to go through our volunteer’s
testing. If you are interested in helping test then please join the
developer list at d...@openoffice.apache.org .

Regards,
Dave


Regards,

Chuck


On Sat, Feb 6, 2021 at 3:03 AM David Shelton 
wrote:

> Dear Sirs,
>
> I use a MacBook Air which I updated to macOS 11 in december, and then had
> problems with your Open Office which I have been using for a long time.
>
> I read your Announcement of 6th January concerning this situation which is
> about exactly the problems I am facing.
>
> Could you please tell me if and when you will be releasing a new version
> to solve these problems. I am not competent enough to help in your testing,
> I just need a solution.
>
>  Kind regards,
>
> David Shelton
>
>
>

Re: Mysterious ' in Calc

[Chuck Spalding]

Brian,

Thank you for enlightening us to this useful information! I'm sure there
are many other features of OpenOffice that I haven't yet "discovered".

Chuck

On Sun, Jun 27, 2021 at 3:46 PM Brian Barker
 wrote:

> At 22:49 27/06/2021 +0100, David Deeks wrote:
> >I have discovered that I have some part-columns of figures in Calc
> >that do not sort properly, and have identified that, unlike other
> >numbers in the same columns, they all appear in the "input line"
> >with a ' preceding them - whilst appearing in the body of the
> >spreadsheet and in the "format" window without it.
>

[snip]


> No need for that. There are various ways to repair values if what you
> wanted was actually numbers. But here is a simple trick:
> o Select the appropriate cells - possibly an entire column. (You can
> include any genuine numbers without causing any problem.)
> o Go to Data | Text to Columns... .
> o Leave all options as default.
> o OK.
>
> I trust this helps.
>
> Brian Barker
>

Re: Spreadsheet

[Chuck Spalding]

Karl,

If I correctly understand your objective, try these steps:

1. Enter the desired multiplier in any cell (e.g., 1.05 for a 5% increase).
2. Select that cell and copy to the clipboard (i.e., Edit > Copy).
3. Select all the cells you want to modify (e.g., click on the first cell
and Shift-Click on the last cell).
4. Select Edit > Paste Special...
5. Click on the "Multiply" selection under "Operations".
6. Make sure "Numbers" is selected in the "Selection" choices, or simply
select "Paste all".
7. Click on "OK".

If you don't like the result, you can select Edit > Undo: Copy to restore
the previous values. (Don't ask me why it's "Undo: *Copy*" when you just
did a *Paste*. ;-)

Note that the "Multiply" selection in the Paste Special dialog is retained,
so you will need to be careful if you next want to use Paste Special for a
different behavior.

Chuck

On Tue, Mar 29, 2022 at 9:27 AM stmo  wrote:

>   I am trying to increase a number in a column by a percentage but I want
> to increase the entire column.
> [snip]

>
> > On Mon, Mar 28, 2022 at 11:40 AM stmo  wrote:
> >
> >> I have spent an entire week trying to find an answer to this.
> >>
> >> I need the formula and exactly where to put it in order to increase a
> >> percentage amount in a spread sheet with numerous entry's   Could not
> >> find in FAQs   We use windows 10 and OO 4.4.5
> >>
> >> Thanks
> >> Karl G
>
[snip]

Re: open office

[Chuck Spalding]

The response below seems to me to be not very useful for the original
poster.

The way to start a text document is to select File > New > Text Document.
(That's the "File" menu, "New" menu item, and "Text Document" in the
submenu.)

The way to change the margins is to select Format > Page..., and then
select the "Page" tab in the popup window. After making selections in the
popup window, click on OK to have the changes take effect (or Cancel to
have the changes ignored).

Assuming that you have the default toolbars, the font can be changed with
the pulldown list accessed in the second field on the second row. (If you
hover the pointer over the field, you'll see "Font Name".) The font size
can be changed with the next field to the right.

You're supposed to be able to change the font color with a toolbar tool,
but it's not working for me now. Instead, select Format > Character..., and
then select the "Font Effects" tab in the popup window. (The font name,
style, and size can be set on the "Font" tab in that popup window.) After
making selections in the popup window, click on OK to have changes take
effect (or Cancel to have the changes ignored).

This website might be helpful: https://forum.openoffice.org/en/forum/ . A
previous response provided a link to user manuals.

Good luck,

Chuck

On Wed, Feb 14, 2024 at 3:22 AM Krotka  wrote:

> Just write a page like a letter,
>   And save in HTML format.
>
> Then find a server that will share your website, preferably a free server,
> it's the most difficult.
>
> Lose your HTML file there, remember that it has the name Index.html.
> Choose such a server so that uploading your site from your computer is
> easy. You should have a "File Download" or similar button on the server.
>
> And now. Check if your site works.
> Remember, however, that your site written in Open Office will be larger
> than written in pure HTML.
>
> Po polsku:
> Po prostu napisz stronę jak pismo,
>  i zapisz w formacie html.
>
> Potem znajdź serwer który będzie udostępniał twoją stronę, najlepiej
> darmowy serwer, to najtrudniejsze.
>
> Przegraj tam swój plik html, pamiętaj by miał nazwę index.html.
> Wybierz taki serwer, by wgrywanie tam twojej strony z twojego komputera
> było łatwe. Powinieneś mieć na serwerze dostępny guzik " pobierz plik" lub
> podobny .
>
> I już. Sprawdź czy twoja strona działa.
>
> wt., 13 lut 2024, 23:06 użytkownik Mary 
> napisał:
>
> > Hi,
> >
> > It is now ion my computer.
> >
> > How do I open a page to  start typing it?
> > How do simple edits.
> >
> > like changing the margins, text size and color and font
> > How do save a page to my computer?
> >
> > I read readme,but it  looked like some sort of internals to programmers
> to
> > me.
> >
> > Are the commands the it it the same as word? I know word a little, enough
> > to get by.  Not that we like it. Plus it no longer works, even tough we
> > bought and still have the install disk.
> > I hope you can help
> >
> > Mary
> >
>