Re: Assistance re:scam

[Alan B]

In addition to previous comment, know that OpenOffice and OpenOffice
volunteer support are free.

However you must access the correct websites, the actual OpenOffice
websites, to use them

The OpenOffice website is https://www.openoffice.org/

OpenOffice support options are at
https://www.openoffice.org/support/index.html#community-support. This page
provides links to the free user support communities.

You will notice, none of these pages require payment to use them.

If you do download OpenOffice from the official website there will be a
prompt asking for a donation. That prompt DOES NOT require a donation to be
able to perform the download.


On Wed, Apr 17, 2024 at 8:56 AM btinternet
 wrote:

> Good morning,
> Firstly my experience. Early this month I purchased an Apple IMac from a
> company OURDEAL. The purchase came with a free copy of your OPENOFFICE
> software. This package could not be loaded giving the error message “Open
> Office cannot be opened because the developer cannot be verified. Mac OS
> cannot verify that this APP is free from Malware”
> I contacted OurDeal who advise me to contact yourselves. This I did and
> prior’s to giving my problems was invited to pay one pound to access your
> help desk. After detailing the above problem I was left hanging for 15
> minutes so I closed the call.
> Today Find that you have taken 40 pounds from my bank account. WHY?
> I find that I cannot re access your system giving my Email details and
> password I entered at the time. I have contacted my bank and their FRAUD
> office is investigating the issue.
> I am a 76 yr old guy with very little IT knowledge so I ask you Please as
> a gesture of honesty to refund this money to my bank asap and to ensure no
> further payments are deducted from my bank account. I understand that my
> banks Fraud dept will be in contact with you regarding this matter.
> Meanwhile I look forward to hearing from you without any further delay,
> Yours faithfully,
> Michael Constable
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Date Format error in Spreadsheet

[Alan B]

Ctrl+Z at the right time also creates the entry as a date.

Type "1/2/". When the 2nd "/" is typed the 1/2 becomes ½.
Immediately type Ctrl+Z and ½ reverts back to 1/2.
Now type /2024 and complete the cell entry.
The date will be correctly entered as "1/2/2024".

On Mon, Jan 15, 2024 at 6:35 PM Duane  wrote:

> Cell formatted for date in form 12/31/99 reads as the fraction, 1/2  when
> the date is specified as 1/2/2024.  I have the latest version of
> installed.  The same problem existed with the down level version.   Let me
> know if this is a bug or if I am doing something wrong.  All other dates
> seem to work as they should.
> Thank you for your help and consideration.
> Duane Weber
> du...@austin.rr.com
> [1d73218c-758c-45c9-a2cc-ef10f108762a]



--

Re: please advice

[Alan B]

If you mean that the worksheet should appear as an empty page with no
gridlines and any tabs should look that way too, then...

1. Use the Tools>Options... menu
2. Expand the OpenOffice Calc branch
3. Select the "View" options
4. Untick the "Grid lines" item
5. Click "OK"

This change applies to every worksheet and every tab of every worksheet.



On Wed, Nov 15, 2023 at 8:24 AM Wade Smart  wrote:

> Format > Cells > Border  - you can remove them or change them.
>
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
> On Wed, Nov 15, 2023 at 5:44 AM ΣΤΕΛΙΟΣ ΚΡΟΥΣΤΑΛΛΗΣ 
> wrote:
> >
> > in the accounting sheets between the cells there are dotted lines, how
> > do I remove them?
> > thank you in advance for your
> >
> > -
> > 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
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Software support

[Alan B]

Gemma,

Whatever type of computer is being used, Windows or Mac, will have
accessibility options like screen magnification, high contrast text and
borders, etc.

If the computer's accessibility options are used then every program used on
the computer will have the selected options applied. So every program would
be zoomed, or have larger text, or higher contrast text or all of it if all
of it was selected.

If the only interest is to increase the size of the worksheet's cells and
their contents, not the menus, not anything else, then the zoom feature for
the worksheet does that.  Zoom is found under the View menu and the
controls at the bottom right corner of the Calc window.

On Tue, Nov 7, 2023 at 3:10 PM Gemma Lloyd 
wrote:

>
> Dear Open Office Support,
>
> My grandfather who has used Open office via you and Sun Systems for years
> and worked as an engineer in the tech and electronics sector (ICL,D2D,
> Fujitsu and Celestica) all his life now at the grand age of 81 has issues
> with his eye sight due to macular degenerative disease. I was wondering if
> there is anyway Open Office more specifically excel can be enlarged or if
> there are any accessibility settings or software you know of that could
> help him continue to use his computer at all?
>
> Any help or advice would be most appreciated. Looking forward to your
> response.
>
> Yours sincerely
>
> Gemma Lloyd
>
> Sent from my iPhone
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Can't open files

[Alan B]

A couple of questions, Linda

#1 Are you using Windows?

#2 To open files do you find the file you want to open and double-click it?

If yes to both and the file doesn't open then right-click the file, select
the "Open with" option, and then select the correct program to open the
file. After having done this, double click to open the file.

On Thu, Jul 20, 2023 at 11:01 PM Linda Edwards 
wrote:

> Good morning,
>
> I received and installed Openoffice a couple weeks ago and have used it a
> few times since then.  However, I tried to open Openoffice files today and
> can't do so.  I reinstalled the program and still can't seem to open the
> files.  Can you help, please?
>
> Thank you,
> Linda Edwards
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: OpenOffice.org - Windows 11 Compatibility

[Alan B]

Ahh... that was it.

It was warning against another version with almost exactly the same name
and noted some issues with it. For that reason it recommended downloading
from the OO website to avoid picking the wrong app.

On Fri, Jun 30, 2023 at 4:49 PM Matthias Seidel 
wrote:

> Hi Alan,
>
> Am 30.06.23 um 22:26 schrieb Alan B:
> > Matthias,
> >
> > Let me do a little digging in my browser history and see if I can find
> the
> > article again. It was a couple of weeks ago and I came across it while
> > searching for something else so I really didn't dig past the one article.
>
> Thanks for looking!
>
> I am interested if the article is really about our official offer:
>
>
> https://apps.microsoft.com/store/detail/apache-openoffice/XP89J5462CMGJD?mode=full
>
> All other (unofficial) versions are gone now...
>
> Regards,
>
>Matthias
>
> >
> > On Fri, Jun 30, 2023 at 11:13 AM Matthias Seidel <
> matthias.sei...@hamburg.de>
> > wrote:
> >
> >> Hi,
> >>
> >> Am 30.06.23 um 16:58 schrieb Alan B:
> >>> Per the OO website, the current version is Windows 11 compatible.
> >>> https://www.openoffice.org/dev_docs/source/sys_reqs_aoo41.html
> >>>
> >>> I have seen some reports warning against using the Microsoft Store
> >> version
> >>> because of some broken feature issues. For that reason I suggest
> >>> downloading the latest version from the Apache OO website.
> >>> https://www.openoffice.org/
> >> The download from the Microsoft Store is *exactly* the same binary you
> >> download from our website.
> >>
> >> What broken features should that be? Just asking...
> >>
> >> Regards,
> >>
> >>Matthias
> >>
> >>> The 3.4  version only lists compatibility through Windows 8. If
> problems
> >>> are encountered with it on W11, rather than fight to "make it work" on
> >> W11
> >>> it would be simpler to upgrade to the known compatible version.
> >>> https://www.openoffice.org/dev_docs/source/sys_reqs_aoo34.html
> >>>
> >>> On Fri, Jun 30, 2023 at 4:48 AM Benny, Olivia  >
> >>> wrote:
> >>>
> >>>> Hello Support,
> >>>>
> >>>> Greetings!
> >>>>
> >>>> Few of our computers are having OpenOffice.org software with the below
> >>>> mentioned versions :
> >>>>
> >>>> Software Title
> >>>> Software Version
> >>>> OpenOffice.org 3.4
> >>>> 3.4.9590
> >>>>
> >>>> Can you please let us know whether the version of OpenOffice.org
> listed
> >>>> above is compatible with Windows 11, if not please provide the version
> >>>> which is compatible.
> >>>>
> >>>> Please let us know if you have any further queries.
> >>>>
> >>>> Regards,
> >>>> Olivia Benny
> >>>>
> >>>>
> >>
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: OpenOffice.org - Windows 11 Compatibility

[Alan B]

Matthias,

Let me do a little digging in my browser history and see if I can find the
article again. It was a couple of weeks ago and I came across it while
searching for something else so I really didn't dig past the one article.


On Fri, Jun 30, 2023 at 11:13 AM Matthias Seidel 
wrote:

> Hi,
>
> Am 30.06.23 um 16:58 schrieb Alan B:
> > Per the OO website, the current version is Windows 11 compatible.
> > https://www.openoffice.org/dev_docs/source/sys_reqs_aoo41.html
> >
> > I have seen some reports warning against using the Microsoft Store
> version
> > because of some broken feature issues. For that reason I suggest
> > downloading the latest version from the Apache OO website.
> > https://www.openoffice.org/
>
> The download from the Microsoft Store is *exactly* the same binary you
> download from our website.
>
> What broken features should that be? Just asking...
>
> Regards,
>
>Matthias
>
> >
> > The 3.4  version only lists compatibility through Windows 8. If problems
> > are encountered with it on W11, rather than fight to "make it work" on
> W11
> > it would be simpler to upgrade to the known compatible version.
> > https://www.openoffice.org/dev_docs/source/sys_reqs_aoo34.html
> >
> > On Fri, Jun 30, 2023 at 4:48 AM Benny, Olivia 
> > wrote:
> >
> >> Hello Support,
> >>
> >> Greetings!
> >>
> >> Few of our computers are having OpenOffice.org software with the below
> >> mentioned versions :
> >>
> >> Software Title
> >> Software Version
> >> OpenOffice.org 3.4
> >> 3.4.9590
> >>
> >> Can you please let us know whether the version of OpenOffice.org listed
> >> above is compatible with Windows 11, if not please provide the version
> >> which is compatible.
> >>
> >> Please let us know if you have any further queries.
> >>
> >> Regards,
> >> Olivia Benny
> >>
> >>
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: OpenOffice.org - Windows 11 Compatibility

[Alan B]

Per the OO website, the current version is Windows 11 compatible.
https://www.openoffice.org/dev_docs/source/sys_reqs_aoo41.html

I have seen some reports warning against using the Microsoft Store version
because of some broken feature issues. For that reason I suggest
downloading the latest version from the Apache OO website.
https://www.openoffice.org/

The 3.4  version only lists compatibility through Windows 8. If problems
are encountered with it on W11, rather than fight to "make it work" on W11
it would be simpler to upgrade to the known compatible version.
https://www.openoffice.org/dev_docs/source/sys_reqs_aoo34.html

On Fri, Jun 30, 2023 at 4:48 AM Benny, Olivia 
wrote:

> Hello Support,
>
> Greetings!
>
> Few of our computers are having OpenOffice.org software with the below
> mentioned versions :
>
> Software Title
> Software Version
> OpenOffice.org 3.4
> 3.4.9590
>
> Can you please let us know whether the version of OpenOffice.org listed
> above is compatible with Windows 11, if not please provide the version
> which is compatible.
>
> Please let us know if you have any further queries.
>
> Regards,
> Olivia Benny
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: OpenOffice - Windows 11 Compatibility

[Alan B]

Per the Apache OpnOffice website, yes the 4.0 and 4.1 versions are
compatible.
https://www.openoffice.org/dev_docs/source/sys_reqs.html



On Thu, Jun 29, 2023 at 5:59 PM Benny, Olivia 
wrote:

> Hello Support,
>
> Greetings!
>
> Few of our computers are having OpenOffice software with the below
> mentioned versions :
>
> Software Title
> Software Version
> OpenOffice 4.0.1
> 4.01.9714
> OpenOffice 4.1.10
> 4.110.9807
> OpenOffice 4.1.3
> 4.13.9783
> OpenOffice 4.1.5
> 4.15.9789
> OpenOffice 4.1.6
> 4.16.9790
> OpenOffice.org 3.4
> 3.4.9590
> OpenOffice 4.1.7
> 4.17.9800
> OpenOffice 4.1.8
> 4.18.9803
>
> Can you please let us know whether the version of OpenOffice listed above
> is compatible with Windows 11, if not please provide the version which is
> compatible.
>
> Please let us know if you have any further queries.
>
> Regards,
> Olivia Benny
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: How can I waterproof my document

[Alan B]

You're welcome, Adrian.

Glad to know it's useful.

On Mon, Jun 26, 2023 at 4:33 PM ACG  wrote:

> Thanks for that reply Alan... I've also learned something new. Great!
> Adrian
>
>
> On 26/06/2023 21:19, Alan B wrote:
> > Working from what you ask, "I don't want others to edit my book while
> they
> > are viewing it," The first option that comes to mind is a secure PDF.
> >
> > OO can create a secure PDF via "File > Export as PDF..."
> >
> > The "PDF Options" dialog will open.
> >
> > Select the "Security" tab.
> > Click the "Set Passwords..." button.
> >
> > The "Set passwords" dialog will open with options for two types of
> > passwords. One password is to allow opening the PDF. That's not the one
> to
> > use. The "Set permission password" is the one to use.
> >
> > For the "Set permission password" put a password in the "Password" field
> > and repeat it in the "Confirm" field.
> > Click the "OK" button to return to the "PDF Options" dialog box.
> > Tick the "Not permitted" option in the "Changes" section on the right
> side
> > of the Options dialog box.
> > ... you may also want to disable copying text / images from the PDF into
> > another file, untick "Enable copying of content" to prevent copying from
> > the PDF
> > Now click the "Export" button.
> >
> > The new PDF can be opened without a password but cannot be edited in a
> PDF
> > editor without knowing the "permission password." So don't make the
> > permission password simple. NOTE: this permission password only applies
> to
> > the PDF. It has NOTHING to do with the .odt file.
> >
> > Whoever receives the PDF can open and read it at will but cannot edit it
> > (and cannot copy from it if the "Enable copying of content" option was
> > unticked). Even if the file is copied, the copy will still have the
> > permission password in it so the copy can't be edited either.
> >
> > By doing this the file you send cannot be edited by the recipient and
> > copies of the file cannot be edited.
> >
> > Keep in mind there are many ways to create an editable file from a PDF.
> But
> > the file you send and any copies made cannot be changed.
> >
> > On Sat, Jun 24, 2023 at 6:13 PM The Telepath 
> wrote:
> >
> >> Hello OpenOffice,
> >> I am wondering how you can waterproof a document on OpenOffice. I am a
> >> writer and I am trying to send a copy of my book to people who are
> giving
> >> me feedback. I don't want others to edit my book while they are viewing
> it.
> >> What is the best way to send people a copy of my book, and they can only
> >> view it?
> >>
> >> Thanks,
> >> Jada Schallhorn
> >>
> >
>
>
> --
> https://independent.academia.edu/AdrianGrant1
> contributions at
> https://onomastics.co.uk/forum/toponymy/
> https://onomastics.co.uk/forum/anthroponymy/
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Need Resotred Help & do not know why to find it?

[Alan B]

You mention you're using a Mac.

Mac has a program called Time Machine. It is installed on Mac from the
factory since macOS 10.5

If it is set to do backups, then check in Time Machine for your file.

This Apple webpage has basic instructions for Time Machine.
https://support.apple.com/en-us/HT201250

On Mon, Jun 26, 2023 at 2:12 PM alexandra anderson 
wrote:

> I do not know where to turn to look for help.
>  I am not good on computers, older woman but I deleted a important
> speardsheet in OpenOffice 4…
> Is there a way I can RESTORE THE OLD SPEARD SHEET A FEW DAYS THROUGH
> OPENOFFICE AND ANY OTHER WAY ON MY COMPUTER?I AM LOST TIME HERE..
> Any feedback would help me so much
>
>
> A+Thank you
> Alexandra
>
>
>
>
> Begin forwarded message:
>
> From: alexandra anderson mailto:alexand...@cox.net>>
> Subject: I NEED HELP.. desperate!!
> Date: June 26, 2023 at 10:16:09 AM MST
> To: users-unsubscr...@openoffice.apache.org  users-unsubscr...@openoffice.apache.org>
> Cc: alexandra anderson mailto:alexand...@cox.net>>
>
> Please HELP, anyone..
>
> I am NOT an expert, older woman,  & I have OpenOffice 4 on a MAC.
>
>  I accidental deleted a a spreadsheet file and I can NOT figure how to
> backup a few days not to lose all my important data.
> Is there anyone who can HELP me?
>
> I did tried, Tools, Options, Load/Save and nothing happened.
>
> I am so in need of help.
>
> Please, help me…
> Thank you
> Alexandra



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: How can I waterproof my document

[Alan B]

Working from what you ask, "I don't want others to edit my book while they
are viewing it," The first option that comes to mind is a secure PDF.

OO can create a secure PDF via "File > Export as PDF..."

The "PDF Options" dialog will open.

Select the "Security" tab.
Click the "Set Passwords..." button.

The "Set passwords" dialog will open with options for two types of
passwords. One password is to allow opening the PDF. That's not the one to
use. The "Set permission password" is the one to use.

For the "Set permission password" put a password in the "Password" field
and repeat it in the "Confirm" field.
Click the "OK" button to return to the "PDF Options" dialog box.
Tick the "Not permitted" option in the "Changes" section on the right side
of the Options dialog box.
... you may also want to disable copying text / images from the PDF into
another file, untick "Enable copying of content" to prevent copying from
the PDF
Now click the "Export" button.

The new PDF can be opened without a password but cannot be edited in a PDF
editor without knowing the "permission password." So don't make the
permission password simple. NOTE: this permission password only applies to
the PDF. It has NOTHING to do with the .odt file.

Whoever receives the PDF can open and read it at will but cannot edit it
(and cannot copy from it if the "Enable copying of content" option was
unticked). Even if the file is copied, the copy will still have the
permission password in it so the copy can't be edited either.

By doing this the file you send cannot be edited by the recipient and
copies of the file cannot be edited.

Keep in mind there are many ways to create an editable file from a PDF. But
the file you send and any copies made cannot be changed.

On Sat, Jun 24, 2023 at 6:13 PM The Telepath  wrote:

> Hello OpenOffice,
> I am wondering how you can waterproof a document on OpenOffice. I am a
> writer and I am trying to send a copy of my book to people who are giving
> me feedback. I don't want others to edit my book while they are viewing it.
> What is the best way to send people a copy of my book, and they can only
> view it?
>
> Thanks,
> Jada Schallhorn
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Small letter

[Alan B]

Hello Darrell,

First a caution, this is a public mailing list with a public archive. The
personal details in your email are "saved" on the Internet. Suggest don't
put addresses or phone numbers in future messages.

As to "I get a small letter in the upper left hand corner..." I'm trying to
understand.

1. by "small letter" do you mean that when you begin typing the letter on
screen is small and so is difficult to read?

2. by "small letter" do you mean lower case letter, as in "a" vs "A", and
is the small letter always there whenever a new document is started?

If #1 there are several things that can affect the apparent size of the
letter.

1.a. Zoom setting in Writer - sets how much of the Writer window is filled
by the document. Zoom in more and the apparent size of the letters
increases. Via the menu View>Zoom.
1.b. Font size (only applies to the current Writer document) - the default
should be 12. That is generally easily legible on my screens and is a
common font size for printed documents. If the size is less than 12 that
may be part of your problem. Increase the font size to 12.
1.c. Font scaling (applies to all fonts shown on the computer screen no
matter what program) - affects how the fonts display on the screen and is
used to make them larger than they would look otherwise. ALL fonts on
screen are scaled. The scaling does not affect the size of printed fonts.
If your screen is high resolution then the letters will appear smaller than
on a same size screen with a lower resolution. Font scaling allows
adjusting for that. It is usually in the "Accessibility" section of
settings.

If #2 then I suspect the default template has been changed. Fixing that
will require modifying the default template to remove the pesky letter that
has been added to it.

On Wed, May 17, 2023 at 1:23 PM Darrell  wrote:

> Greetings ,
>
> My problem is: When I open Apache Open Office I get a small letter in
> the upper left hand corner. I have tried several times to find out how I
> get a normal size letter space but to no avail. Can you help,
>
> Thank You Darrell Brewington 775-427-1577
>
> mard...@cccomm.net
>
> Fallon,Nv.
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: changed

[Alan B]

This link is for the Apache OpenOffice website, https://www.openoffice.org/

Once there click the "I want to download Apache OpenOffice
 link" and you'll be
connected to the free download for the current version, 4.1.14 as you say.
Earlier versions and versions for various computer operating systems are
also available at the link.

Click the download button and a new page will open, https://sourceforge.net,
click NOTHING on this new page, just wait for the download to begin.

On Tue, May 2, 2023 at 4:55 PM Geeny In A Bottle Komanac <
gina.koma...@gmail.com> wrote:

> Hi has something changed for copy/paste an item in open office?
> I have version 4.1.9 (where do I upgrade free for 4.1.14?
> please and thanks
>
>
> Gina, RMT, Yoga Instructor (http://www.geenyinabottle.com)
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: support | Open office Calc.

[Alan B]

Here is a Document Foundation, LibreOffice's publisher, link that lists the
Calc functions. Unfortunately I don't see indication of which versions the
defined function is in or which version it was first available.
https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions

Please name a function in your sheet that is not working, the version of
Calc you're using, and the message being displayed in the cell that has the
error. That would help investigating the problem and finding an answer.


On Thu, Apr 27, 2023 at 4:59 AM J. Pauwels  wrote:

> Dear,
>
> I'm looking for some support regarding OpenOffice Calc. The latest
> update did block some functions in old spreadsheets.
>
> I'm a standard user of your software - non English speaking - and have
> little knowledge of particular terminology.
>
> So a patient and open person would be advisable, maybe an European?
>
> Thanks for your support,
>
> J. Pauwels.



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Help Making Sense of .csv Files

[Alan B]

Hello Linda,

I opened the file, "Active Provider Directory 20220902", in Calc. The
columns I'm seeing with lots of spaces are additional details like
ADDRESS2, OTHER SPECIALTIES, OTHER LANGUAGES. Not a surprise they wouldn't
be completed.

Things you are interested in, like speciality and location, have values for
every row of the file I imported.

Columns, PROVIDER NAME, ADDRESS 1, CITY, STATE, ZIP, COUNTY, PROVIDER TYPE,
PRIMARY SPECIALTY, OTHER SPECIALTIES, CONTRACTS and a few more have values
in every row of the sheet.

Using Calc "AutoFilter" it is a few clicks to filter by CITY and PRIMARY
SPECIALTY, for example.
e.g. filter for city = "Athens" and primary speciality = "Allergy and
Immunology". Applying those filters gets four results out of the 270,993
rows in the file.
Not sure how you're opening the file.

If you're not opening the file in Calc, that's step 1.

#1 Find the downloaded file and right-click it then click "open with Calc"
or "Calc" on the menu. If that's not there, look for the "Open with" option
on the menu and click that. The submenu that opens will have Calc on the
list. Click it.

#2 Calc will present a "Text Import" dialog before the data is displayed in
the spreadsheet. In that dialog set "Separator Options" to "Separated by"
and be certain the ONLY option checked is "Comma". Then click "OK"

#3 Now that the file is open before you click Data > AutoFilter on the
menu. The column titles on the first row will now have little downward
pointing triangles next to each title. Click on those as needed to filter
the list to see only what you want.

VERY IMPORTANT step saver if you want to refer to the file again. The file
is still .csv. AutoFilter cannot be saved in .csv.
#4 Click File > Save on the menu. A warning about "Confirm File Format"
will appear. Click the "Use ODF Format" button and then click the "Save"
button.

Next time you want to use the file, open the spreadsheet file (ODF format
file), not the .csv file, and your AutoFilter will still be in place and
ready to use.

On Thu, Feb 9, 2023 at 1:26 AM Linda Hull  wrote:

> This isn't a usual "I can't do x or y" problem. It might be an OO doesn't
> open it right?  I would like it if someone could help me make these files
> readable. Barring that, I need some specific doctors.  The data seems to be
> all spread out in these .csv files.  They ought to be lists of doctors,
> including specialities and other information, so that one could find a
> doctor.  When I open the file: Active Provider Directory 20220902 (59.27
> MB), I get a page with huge spaces and nobody seems to have entered the
> data correctly.  Am I wrong?
> I would like to be able to find doctors by different parameters, such as
> specialty and location.
> 'Find' works. 'Find all' does not, for me.  The file is on this page:
> https://dch.georgia.gov/providers/provider-directory
> From:
> https://dch.georgia.gov/how-do-i
> It's the government, who knows what they intended to do?
> They don't answer their phone.
>
> Linda
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: my open office program will not open.

[Alan B]

On Windows 10

Open Task Manager

Look in the list of background processes (if no list, look for the "More
details" link at bottom left of Task Manager, click that, the background
processes list should be shown now)

Find every OpenOffice process, select them, and then click "End Task" button

Now try the installation

On Tue, Dec 13, 2022 at 5:35 PM Kay Harper  wrote:

> My open office system will not open.  I thought perhaps I could remove the
> program and download it again.  When I try to remove it I come up with the
> following:   Please exit the Open Office 4.1.1.13 and the OpenOffice 4,1,13
> Quickstarter before you continue.  If you are using a multi-user system.
> Also make sure that no other user has OpenOffice 4.1.13 open.  I am the
> only user on this system.  I am using Windows 10.  Hlp would be greatly
> appreciated.
> Thank you,  Kay
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Windows 10

[Alan B]

According to Apache's System Requirements page for OpenOffice, yes 4.1.9
can be used on Windows.
https://www.openoffice.org/dev_docs/source/sys_reqs_aoo41.html

You may upgrade to the latest version if you wish.

Strongly recommend check the specs of your laptop vs Windows 10 system
requirements. Personally I wouldn't use Windows 10 on anything less than an
i3, with SSD and 8GB RAM.

On Tue, Oct 25, 2022 at 9:16 AM Geeny In A Bottle Komanac <
gina.koma...@gmail.com> wrote:

>  If I update to windows 10, can I still use open office 4.1.9?
> or do I have to upgrade to latest version?
> I am using a 2013 laptop Toshiba
>
>
> Gina, RMT, Yoga Instructor (http://www.geenyinabottle.com)
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Forgot Password

[Alan B]

You may also try an OpenOffice password cracker.

A web search with the term "openoffice password cracker" turns up quite a
few hits. It will be brute force cracking, in other words make a password,
try it, if fails try another, and so on. But the password cracker
automatically creates and tries the passwords so you don't have to.

If you really need the document AND the password's not too complex, AND you
have some idea its length, then running the password cracker for a few
minutes to several days until it finds the password will get you back into
the document.

not to complex - if you know it is only letters and numbers, or better yet
only upper case or lower case letters and some numbers then fewer passwords
for the cracker to create and try and quicker results
its length - if you know it is six or eight or ten characters, or at least
five characters you can tell the password cracker to start with passwords
that length. Saves time because the cracker doesn't start with passwords of
length one character and work up from there

If you know the above things then do the web search and try some of the
password crackers.

On Wed, Sep 28, 2022 at 4:50 AM H S  wrote:

> Hallo,
> I saved a document with a password and unfortunately forgot the password.
> Can you please help me how to open the file again. Thanks in advance.
>
> Kind regards
>
> H.Rotar
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Line cut off

[Alan B]

Do you mean a printed line on paper output or the bottom of a cell is cut
off on screen?

What are the things you have tried to fix it?

For paper, have you tried adjusting the margins or the scaling?

For screen, have you adjusted row height?

On Fri, Apr 15, 2022 at 6:56 PM Mike & Lisa Bobbitt
 wrote:

> Hi,
>
> I'm using Open Office on Windows 10. There are times where a line
> (spreadsheet) gets cut off at the bottom and nothing I do fixes it. Please
> help.
>
> Lisa
>
>
>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Spreadsheet

[Alan B]

You want to...

a) increase certain entries by a percentage

- or -

b) increase a percentage already in the spread sheet

If a) then enter the percentage in a cell of your choice, remember
percentages less than 100% are entered as fractions, e.g. 20% is entered as
.2, 45% as .45, and so on. Multiply the value that needs to increase by the
percentage and add that amount to the value.
If the value is 55 and is in cell B1
and the percentage to increase is 10% and .1 is entered in C1
and the new value should appear in D1, then in D1 enter the following
=B1+(B1*C1)

If b) and there is a cell with a percentage already in the spreadsheet, and
that percentage is being used already in formulas in the spreadsheet, then
change the percentage to the new value.

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



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Reveal Codes

[Alan B]

There is no reveal codes in OpenOffice.

Reveal Codes was a Wordperfect feature. The Word feature of the same name
is activated by Shift+F1. The Word feature may go by the same name but is
nothing like the Wordperfect feature because the structure of the files is
different.

If you have a line (or double line, or dashed line, or etc) across a page,
check for borders in the paragraph style both above the line and below the
line. I've had that happen to me before and frustrated the heck out of me
before I finally figured it out. Still happens sometimes. Don't know what
I'm doing to make it happen but have at least figured out how to get rid of
it.

On Sun, Mar 20, 2022 at 3:06 PM Jennie Bickerton
 wrote:

> Hi Steve,
> I am having problems in a document with paragraph numbers and
> sub-paragraph entries ( 1. and then A. etc.) and also a double line across
> the page that I have no idea how it got there.  I know in Microsoft there
> was an "F#" that would open Reveal Codes so that I could then go in and
> remove whatever indent or code I had mistakenly inserted.
> Is there any reveal codes in Open Office?
> Thank you so much!
> Jennie Bickerton



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Problem saving file

[Alan B]

Maybe idea out of left field, but is there plenty of free space on drive
that is target of save? Especially if OS is on that drive too.

If not, try saving to a different drive or a thumb drive.

Have experienced very strange problems with drives that have run out of
space.

On Sun, Mar 13, 2022 at 7:02 PM Marvin Vann 
wrote:

> Good afternoon,
>
> I’m having difficulty saving the file I’ve been working on for some time.
>  When save attempted, the progress bar at bottom progresses about half-way
> then starts over.  Keeps repeating until program force terminated.
>
> 1.  Have, of course, tried repeating with failure.
>
> 2.  As experiment, loaded last good saved version; document looks
> correct.  Then 1) added a space and 2) deleted said space.  Office now
> thinks document has been modified.  It should save-as identical to the
> source it was loaded from.  Instead the progress bar behaves as described
> above and keeps trying forever, and displays the following message:
>
> Error saving the document Suitland 58 Deceased b:
> Write Error
> Error in writing sub-document content.xml.
>
> 3.  Thinking the program might be corrupted, I deleted and reinstalled
> Open Office.  Same problem persists.
>
> 4.  This happened once before several months ago.  Workaround was to open
> a new file and to copy the unsaveable file piece by piece and when complete
> document had  been moved the Save As command worked. Even this now fails.
>
> 5.  Looked at your help files, found nothing relevant.
>
> Marvin J. Vann
> savan...@aol.com



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Software Inquires

[Alan B]

Sam,
You have reached the volunteer support mailing list.
Please refer to this URL https://www.openoffice.org/support/ and select the
link "Professional Services" and then the "Consultants page" link to
identify a commercial provider of OpenOffice support services.

On Wed, Mar 2, 2022 at 9:01 AM SamGreen - M Moser Associates
 wrote:

> Dear OpenOffice,
>
>
>
> Please can someone from your sales team contact me with regards to your
> OpenOffice Software.
>
>
>
> I have attached a document below outlining what services we will require.
>
>
>
> Please let me know if this is within your capabilities
>
>
>
> Kind regards,
>
>
>
>
> *Sam Green Compliance Coordinator *
>
> M: (+44) 07542 937 396
>
> T: (+44) 20 7621 5400
>
>
>
>
>
>
>
> *M Moser Associates*
> St Magnus House
> 3 Lower Thames Street
> London EC3R 6HD
> *mmoser.com* 
>
> *See our locations around the globe* 
>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Formatting for USA Telephone Numbers

[Alan B]

Correction
After applying the recommended format, (###) ###-, and entering
1234567890 the displayed value will be (123) 456-7890.

No idea how/why I typed what's in my original answer.

My apology for any confusion I may have caused.


On Fri, Feb 25, 2022, 8:20 AM Alan B  wrote:

> To format a ten digit number as (555) 555-1212 use the following format
> code
>
> (###) ###-
>
> Enter the ten digits into the cell, e.g. 1234567890, and the number will
> be displayed as (120) 456-7890
> NOTE: area code must not start with zero. Zero in any other position will
> maintain the format. There is a space between the right paren ) and the
> next #.
>
> To enter only ten digits and have the US dialing prefix, +1 displayed use
> the following format code
>
> "+1" (###) ###-
>
> Enter the ten digits into the cell, e.g. 1234567890, and the number will
> be displayed as +1 (123) 456-7890
> NOTE: there must be a space between the second quote " and left paren (.
> If there is no space then the formatted result will be +1(123) 456-7890
>
> On Wed, Feb 23, 2022 at 9:33 PM Vince@Verizon
>  wrote:
>
>> Hi:
>>
>> How do I format cells for entry of USA Telephone Numbers, as: 1
>> (###) ###*-*
>>
>> whenever, for example,I have typed a ten-digit number, e.g., 1234567890
>> (no spaces, no negative/minus sign, no parenthesis, by use of the number
>> keypad (NumLk is enabled).
>>
>> Yes, I want the "1" prefix, the area code to appear within parenthesis,
>> and a negative/minus sign between the 3rd digit and the 4th digit. A
>> space follows the prefix "1" and a space follows the closing parenthesis.
>>
>> I have tried to set a user defined number-format, but am getting strange
>> results with apostrophes and/or double quote markings mixed in when
>> viewing the Format Cells dialogue, e.g., (#") "###"*-*". And, I
>> don;t understand why that is. I was hoping to find a pre-defined/default
>> format for use when entering USA telephone numbers. I am flexible; I can
>> probably do without the "1" prefix and/or the parenthesis.
>>
>> Should I be formatting these cells as "text" (left-justified) rather
>> than as numbers (right-justified)?
>>
>> Regards,
>>
>> VinceB.
>>
>>
>
> --
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011
>
>

Re: Formatting for USA Telephone Numbers

[Alan B]

To format a ten digit number as (555) 555-1212 use the following format code

(###) ###-

Enter the ten digits into the cell, e.g. 1234567890, and the number will be
displayed as (120) 456-7890
NOTE: area code must not start with zero. Zero in any other position will
maintain the format. There is a space between the right paren ) and the
next #.

To enter only ten digits and have the US dialing prefix, +1 displayed use
the following format code

"+1" (###) ###-

Enter the ten digits into the cell, e.g. 1234567890, and the number will be
displayed as +1 (123) 456-7890
NOTE: there must be a space between the second quote " and left paren (. If
there is no space then the formatted result will be +1(123) 456-7890

On Wed, Feb 23, 2022 at 9:33 PM Vince@Verizon 
wrote:

> Hi:
>
> How do I format cells for entry of USA Telephone Numbers, as: 1
> (###) ###*-*
>
> whenever, for example,I have typed a ten-digit number, e.g., 1234567890
> (no spaces, no negative/minus sign, no parenthesis, by use of the number
> keypad (NumLk is enabled).
>
> Yes, I want the "1" prefix, the area code to appear within parenthesis,
> and a negative/minus sign between the 3rd digit and the 4th digit. A
> space follows the prefix "1" and a space follows the closing parenthesis.
>
> I have tried to set a user defined number-format, but am getting strange
> results with apostrophes and/or double quote markings mixed in when
> viewing the Format Cells dialogue, e.g., (#") "###"*-*". And, I
> don;t understand why that is. I was hoping to find a pre-defined/default
> format for use when entering USA telephone numbers. I am flexible; I can
> probably do without the "1" prefix and/or the parenthesis.
>
> Should I be formatting these cells as "text" (left-justified) rather
> than as numbers (right-justified)?
>
> Regards,
>
> VinceB.
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Trouble opening

[Alan B]

Hello,

Which program is it you downloaded?
What website did you download it from?
What computer system do you use (Windows 7, Windows 10, Mac, etc.)?

On Mon, Feb 14, 2022 at 11:12 AM Sharon 
wrote:

> Good morning,
> I downloaded your program, however it will not open when i go to the
> file.
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: working in spreadsheet

[Alan B]

Cannot see how the spreadsheet looks. Pictures are not saved / displayed on
the help list.

And... what happened, how did you save the spreadsheet? I do not understand
what you mean, "...saved it md titmrd off computer...".

On Thu, Feb 3, 2022 at 2:45 PM Linda Howell 
wrote:

> i saved my spreadsheet and saved it md titmrd off computer. next meet
> morning i woke up to the spreadsheet looking like this
> i need help. asap. i have 7 months of stuff on this. thank u
> Sent from my iPhone
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: File Access Denied

[Alan B]

It doesn't look like your question has gotten a response.

The message means that the logon (username & password) being used when
trying to access the file does not have the privileges needed.

Privileges are associated with the username so, are you using a different
username? If yes, logon with the original username the files were created
with and try again.

Are the files saved on a network administered by someone else? If yes,
refer the problem to your network administrator. They should be able to
correct it quickly or tell you why you no longer have access.

If none of the above apply, then more information is needed.
* what operating system is being used, e.g. Windows 10, Mac OS X...
* do you have administrator access on the computer? e.g. can you install /
remove software

On Sat, Jan 29, 2022 at 12:47 AM gee 523  wrote:

> Hello
>
> Suddenly, I am unable to open my Open Office documents.
>
> The error message reads “File Access Denied.  You’ll need to provide
> administrator permission to apply properties to this file”.
>
> Please advise.
>
> Thank you,
> Galen Stoner
>
>
> Sent from Mail for Windows
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Problems

[Alan B]

Ron,
Strongly recommend do not include your phone number or personal information
beyond your email address. This is a public mailing list and whatever you
post here can be read by anyone.

As to the crashing there are many many potential causes and they differ
depending on such things as the particular software being used and the
configuration of the computer. If an old version of Windows and a new
version of OpenOffice or vice versa that could be the problem. A recent
Windows update could even be the source of the problem.

In no particular order here are some potential solutions if your computer
is using Windows 10. I suggest try each one, see if the problem persists
and if so move on to the next one.
* Make sure ALL Windows updates have been applied
* Make sure you're using the latest version of OpenOffice
* Uninstall OpenOffice then reinstall it
* Check space available on the hard drive, Windows seems to like 20% of the
hard drive free (regardless of the drive's size). If there's not 20% free
see if you can remove files and/or uninstall programs you don't use to get
to 20% free
* Use your antivirus and antimalware software and do full scans of the hard
drive to see if any threats are found and if they are let the antivirus and
antimalware programs fix them
* Check CPU and Memory usage in the Performance tab in Task Manager. If
either of them are pegged see what program(s) are causing it and shut them
down or uninstall ones you don't need.

On Thu, Jan 27, 2022 at 2:12 PM Ron Wiernusz  wrote:

> I have been experiencing crashes of the Open Office program. They seem to
> becoming more often. What is happening to it?
> When a crash occurs I loose all the info I had put in.
> Thank you for a prompt response,
> Ronald Wiernusz
> 570-814-9299
>
> Sent from Mail for Windows
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: A fault has developed which will not allow me to open any of the programs or files that use Open Office.

[Alan B]

Hello Kim,

Not certain from the description what steps you take to experience the
problem.

That said, suggest you try installing OpenOffice again. If the installation
has become compromised in some way, installing again should resolve the
problem.

On Mon, Jan 24, 2022 at 9:01 PM Kim Hovren 
wrote:

> Please advise.
> A fault has developed which will not allow me to open any of the programs
> or files that use Open Office.
>
> Thank you.
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Older Open Office

[Alan B]

Hello,

Older versions can be found here
https://www.openoffice.org/download/

When using the above link, you will see "Select your favorite operating
system, language, and version:"

Look below "version:". That is a list that can be used to select the
version you want by clicking the arrow at the right side of the box. It
should show 4.1.11 when you first look at it. If the version you want isn't
in the list select the last option, "Older releases".

Keep in mind newer computers (especially a 14 years newer computer) may not
run older software because the older software is not compatible.

Software does reach "end of life" where it is no longer supported, bugs
fixed, hacking vulnerabilities patched, etc. And older versions may not
read files sent to you created by newer versions of software.

Open Office end of life info is here.
https://www.openoffice.org/development/releases/eol.html

On Sat, Jan 22, 2022 at 4:03 PM S.L. Crosby 
wrote:

> I have used Open Office for several years and recently replaced my 14 year
> old computer. When I downloaded Open Office I received the new edition and
> while I appreciate your brilliance, I'm just lost and would like to know if
> you could send me a link for the older edition. I'm 75 and set in my ways.
> If this is possible I would gladly send a check to your project. Please
> send me your mailing address.Thank you.Sheila Crosby, Shreveport, LA.
> slcrosby_...@yahoo.com
>
> Sent from Yahoo Mail on Android



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Help! lost Open Office on my computer/laptop

[Alan B]

The image is not displayed. What is the text in the image?


On Fri, Jan 21, 2022 at 4:51 PM Lisa Floyd  wrote:

> It appears that an update must have run when I turned on my lap top this
> morning.
> Suddenly I am not able to open ANY Open Office document without getting
> this messge:
>
>
>
> Why and what to do?
>
> lisafloyd
>
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Linking sheets

[Alan B]

Don,

Not sure I understand what you're trying to do and this suggestion isn't
"automatic" but, if what you want to do is go directly to a location on a
different sheet, it can be done without navigating there.

Presuming each sheet is a different tab in the same workbook...


   1. Insert the cursor at the beginning of the "Name Box" (just above the
   empty rectangle where the column headings row and row number columns meet).
   The Name Box will have the address of the current cell in it.
   2. Type the name of the sheet you want to get to followed by a period,
   ".".
   3. Press enter.
   4. The cell highlight will move to the sheet/cell entered in the Name
   Box and bring that sheet to the top.

The Name Box shows the address of the current cell without the page name.

If, for example, you're on sheet in cell Z125 and want to move to
sheetSSSP cell Z125 then...
- put the cursor before the address (Z125) of the current cell in the Name
Box
- type sheetSSSP. (the Name Box now contains sheetSSSP.Z125)
- press enter

sheetSSSP will now be the top sheet and the cursor will be in cell Z125.

As I said, not automatic, but maybe a useful method for you to navigate to
the same cell on a different sheet.

I do not believe this will work if the sheets are in different files.


On Fri, Sep 24, 2021 at 9:28 PM Don Town  wrote:

>
> >>
> >> On September 23, 2021 at 7:35:19 PM, Don Town (bg...@sbcglobal.net)
> wrote:
> >>
> >> Hello everyone
> >>
> >> Is there any way to link various sheets in a document?
> >>
> >> What I'd like to do is... to move any ONE sheet...and when switching to
> another sheet,
> >> the software might automagically place me at the same coordinates
> without having to
> >> navigate to them... such that ALL the sheets in a document stay
> coordinated with
> >> one another habitually.
> >>
> >> That way, it's easy to review a specific piece of information in that
> same area
> >> across all the sheets .
> >>
> >> Thanks
> >> Don
> >>
> >> Using: OO 4.1.7 and / or 4.1.8 on a Mac
>
>
> > On Sep 23, 2021, at 11:59 PM, David Belina  wrote:
> >
> > What you just described is a database.
> >
> > Dave
>
> My issue isn't about knowing what it's called.
> It's about finding out if / how to make that technique happen.
>
> I regularly need to create a new updated sheet every 3-4 days.
> The newer sheet is meant to update stock / information levels from the
> older sheets that are to stay frozen in the  condition they
> are in, while also staying easy to review as they become increasingly
> obsoleted.
>
> You seem to imply this is possible.
>
> Would be nice to have the OLD sheet "leashed" to the new  relevant> sheet so they stay in step with being able to simultaneously
> glance back easier at the same spot on all of them as the new information
> supercedes the old.
>
> I have / had no idea if this is even possible, much less **how** to do it.
>
> Thanks
> Don
>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: OpenOffice

[Alan B]

The password is needed to decrypt the files.

A password cracker can recover the password. I did that a year or so ago
when I had the same problem. Problem solved.

Search for OpenOffice password cracker. You'll find several. Don't remember
which I used or I would tell you.

Depends on the type of passwords you're using, whether and how long before
password is recovered. In my case was an alphanumeric six character
password. I think it took about 10 minutes before it figured out the
password.

On Wed, Aug 11, 2021 at 3:10 PM Andy Migliore  wrote:

> I used open office a few years ago on some files, I protected some with a
> password but that was 10 years ago and I've forgotten password, is there a
> way to recover files.
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Help on using Open Office Calc

[Alan B]

No. There is not. Not dealing with a corporation like Adobe, Microsoft, etc.

There are organizations that provide paid support for OpenOffice. And there
are free/community help offerings.

You can check here to look for support solutions that come closest to
meeting your needs.
https://www.openoffice.org/support/

There is one link on the page above that purports to provide a link to free
Calc lessons.
http://openofficeschool.org/

I do not have any insight into the quality or value of any offerings at the
links provided. Please, explore and find what works best for you.

On Sat, Jun 26, 2021 at 4:00 AM chor pheng tan
 wrote:

> Hi - I am presently using Open Office and I need help in using this
> software. Is there any contact number in Singapore where I can call to seek
> assistance? Please provide the contact number.
>
> Thank you  Chor Pheng



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Assistance needed to Download the current OpenOffice

[Alan B]

In addition to David's note, would you please state what computer operating
system (OS) you are using?

Windows 7, Windows 8, Windows 10, Mac OS X, Chrome OS (a Chromebook), etc.

It makes a difference in regard to which installation package is correct
for you and what steps are required to install.

And as per David, please reply to the list, not to personal email.

Thank you.

On Sat, Jan 2, 2021 at 1:34 AM Gloria Weir  wrote:

> Hi.  It used to be easy to Download the most recent OpenOffice and now it
> won't install on my computer.
>
> I need your assistance in Downloading a version of OpenOffice please.  I
> really like working with it.
> I only need it to do documents.
>
> Thank you
>
> Gloria
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: HELP!

[Alan B]

Hi Pat,
This is an email based volunteer staffed support list. Sorry no phone.

However many helpful people will try to assist you. For my own effort, let
me refer you to:

Instructions, with pictures, for creating labels in Writer. Bonus,
screenshots are from a Mac. Last updated Feb, 2020
https://www.wikihow.com/Print-Address-Labels-Using-OpenOffice

More instructions with pictures.The web page is rather recent as it was
last updated July 2018. The screenshots are from Windows though which may
make following them a bit more difficult
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Print_labels_from_db

Try the above and if you don't succeed get back to the list telling us
which instructions you used and at what step you encountered problems.

On Sat, Dec 19, 2020 at 3:34 PM Pat Woodhouse
 wrote:

> Is there ANY possibility I could talk to someone who could walk me through
> getting  spreadsheet data onto labels?  If not, can very specific
> directions be emailed to me?
> When I was working I had a PC and could do labels practically blindfolded
> because I had very good instructions.  Now that I’m retired, and no longer
> have a PC, but rather a Mac and someone suggested using Open Office.  I
> took their advice and have been doing pretty well with it, but the labels
> really stump me.  The little information I could find was not helpful
> because I didn’t understand what I was reading.  I have a spreadsheet with
> 225 names and addresses, and I NEED to get labels printed.
> Thank you for any help you can provide,Pat Woodhouse
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Can't Export JPG

[Alan B]

Probably wise. More than enough tracking cookies on any system already.

On Tue, Dec 8, 2020 at 8:51 AM Wade Smart  wrote:

> Yea, not going through all of that just to see a image.
>
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
> On Tue, Dec 8, 2020 at 7:48 AM Alan B  wrote:
> >
> > The "We Transefer" landing page is obnoxious but, if you accept the Terms
> > of Service (the plain English version of which seem straightforward and,
> > surprisingly to me, don't claim ownership of content posted) policy and
> > then click Manage cookies (or don't and instead click I accept right
> away)
> > and turn off all the tracking features that there are controls to disable
> > then it is possible to download and view the video without signing up
> for a
> > We Transfer account.
> >
> > The video displays exactly what Shawn describes. There are no selections
> > available in the "Save as type:" drop down except for PDF. The drop down
> > list does open. But there is only one item in the list, PDF.
> >
> > To Shawn, I suggest posting somewhere else that doesn't require the
> viewer
> > to accept a ToS agreement and disable or accept a bunch of cookies.
> > Dropbox, Google Drive, and pCloud (among others) all allow the account
> > holder to create links that do not require the user to accept any
> > agreements or prompt them regarding cookie policies. Instead, the links
> go
> > directly to the referenced content.
> >
> > e.g.
> >
> https://u.pcloud.link/publink/show?code=XZRh54XZTn9F7zIoqKVIN83piy3eoVRBCY77
> >
> > On Mon, Dec 7, 2020 at 6:59 PM Wade Smart  wrote:
> >
> > > Nope.
> > > "Welcome to We Transfer."
> > > --
> > > Registered Linux User: #480675
> > > Registered Linux Machine: #408606
> > > Linux since June 2005
> > >
> > > On Mon, Dec 7, 2020 at 6:29 AM Dick Groskamp  wrote:
> > > >
> > > >
> > > >
> > > > On 2020/12/06 18:55:40, Wade Smart  wrote:
> > > > > Page not found.
> > > > >
> > > > > --
> > > > > Registered Linux User: #480675
> > > > > Registered Linux Machine: #408606
> > > > > Linux since June 2005
> > > > >
> > > > > On Sun, Dec 6, 2020 at 12:54 PM BK Home Photos <
> he...@bkhomephotos.com>
> > > wrote:
> > > > > >
> > > > > > Here's a link to view my screen recording video --
> > > https://we.tl/t-VaTFP152C9---BK Home Photosp. 646.481.9662Our Work //
> > > bkhomephotos.com  On Sun, 06 Dec 2020 13:48:35 -0500
> > > he...@bkhomephotos.com  wrote Yes, I understand the difference
> > > between Export and Export As PDF... I don't have the other options in
> th
> > > drop down like you.---BK Home Photosp. 646.481.9662Our Work //
> > > bkhomephotos.com  On Sun, 06 Dec 2020 13:35:11 -0500
> b...@apache.org
> > > wrote Attachments are removed from this list, so normal subscribers
> > > cannot see
> > > > > > your capture.
> > > > > >
> > > > Try this one:  https://we.tl/t-VaTFP152C9
> > > > > > @List: The capture shows Export to PDF, saving to  to "MS
> OneDrive".
> > > > > > I have sent an off-list reply to the OP with captures of the
> normal
> > > > > > export as images looks like.
> > > > > >
> > > > > > Dave
> > > > > >
> > > > > >  Original Message 
> > > > > > From: BK Home Photos [mailto:he...@bkhomephotos.com]
> > > > > > Sent: Sunday, December 6, 2020, 18:04 UTC
> > > > > > To: ofarr...@iol.ie
> > > > > > Cc: users@openoffice.apache.org
> > > > > > Subject: Can't Export JPG
> > > > > >
> > > > > > > Hi, if you check the video sent, I clicked the drop down, and
> > > there are no other options other than pdf.---BK Home Photosp.
> > > 646.481.9662Our Work // bkhomephotos.com  On Sun, 06 Dec 2020
> > > 12:55:03 -0500  ofarr...@iol.ie  wrote On Sun, 06 Dec 2020
> 10:44:14
> > > -0500
> > > > > > > BK Home Photos  wrote:
> > > > > > >
> > > > > > >> I did click "export." I did not click "export as pdf."---BK
> Home
> > > Photosp. 646.481.9662Our Work // bkhomephotos.com --

Re: Can't Export JPG

[Alan B]

The "We Transefer" landing page is obnoxious but, if you accept the Terms
of Service (the plain English version of which seem straightforward and,
surprisingly to me, don't claim ownership of content posted) policy and
then click Manage cookies (or don't and instead click I accept right away)
and turn off all the tracking features that there are controls to disable
then it is possible to download and view the video without signing up for a
We Transfer account.

The video displays exactly what Shawn describes. There are no selections
available in the "Save as type:" drop down except for PDF. The drop down
list does open. But there is only one item in the list, PDF.

To Shawn, I suggest posting somewhere else that doesn't require the viewer
to accept a ToS agreement and disable or accept a bunch of cookies.
Dropbox, Google Drive, and pCloud (among others) all allow the account
holder to create links that do not require the user to accept any
agreements or prompt them regarding cookie policies. Instead, the links go
directly to the referenced content.

e.g.
https://u.pcloud.link/publink/show?code=XZRh54XZTn9F7zIoqKVIN83piy3eoVRBCY77

On Mon, Dec 7, 2020 at 6:59 PM Wade Smart  wrote:

> Nope.
> "Welcome to We Transfer."
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
> On Mon, Dec 7, 2020 at 6:29 AM Dick Groskamp  wrote:
> >
> >
> >
> > On 2020/12/06 18:55:40, Wade Smart  wrote:
> > > Page not found.
> > >
> > > --
> > > Registered Linux User: #480675
> > > Registered Linux Machine: #408606
> > > Linux since June 2005
> > >
> > > On Sun, Dec 6, 2020 at 12:54 PM BK Home Photos 
> wrote:
> > > >
> > > > Here's a link to view my screen recording video --
> https://we.tl/t-VaTFP152C9---BK Home Photosp. 646.481.9662Our Work //
> bkhomephotos.com  On Sun, 06 Dec 2020 13:48:35 -0500
> he...@bkhomephotos.com  wrote Yes, I understand the difference
> between Export and Export As PDF... I don't have the other options in th
> drop down like you.---BK Home Photosp. 646.481.9662Our Work //
> bkhomephotos.com  On Sun, 06 Dec 2020 13:35:11 -0500  b...@apache.org
> wrote Attachments are removed from this list, so normal subscribers
> cannot see
> > > > your capture.
> > > >
> > Try this one:  https://we.tl/t-VaTFP152C9
> > > > @List: The capture shows Export to PDF, saving to  to "MS OneDrive".
> > > > I have sent an off-list reply to the OP with captures of the normal
> > > > export as images looks like.
> > > >
> > > > Dave
> > > >
> > > >  Original Message 
> > > > From: BK Home Photos [mailto:he...@bkhomephotos.com]
> > > > Sent: Sunday, December 6, 2020, 18:04 UTC
> > > > To: ofarr...@iol.ie
> > > > Cc: users@openoffice.apache.org
> > > > Subject: Can't Export JPG
> > > >
> > > > > Hi, if you check the video sent, I clicked the drop down, and
> there are no other options other than pdf.---BK Home Photosp.
> 646.481.9662Our Work // bkhomephotos.com  On Sun, 06 Dec 2020
> 12:55:03 -0500  ofarr...@iol.ie  wrote On Sun, 06 Dec 2020 10:44:14
> -0500
> > > > > BK Home Photos  wrote:
> > > > >
> > > > >> I did click "export." I did not click "export as pdf."---BK Home
> Photosp. 646.481.9662Our Work // bkhomephotos.com  On Sun, 06 Dec
> 2020 10:38:54 -0500  wadesm...@gmail.com  wrote Click "Export" not
> "Export As"
> > > > >
> > > > > I've just checked.  /File /Export, then change the file type to
> JPG/JPEG from the file type dropdown.
> > > > >
> > > >
> > >
> > > -
> > > 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
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: [AOO-Templates]

[Alan B]

How and where are the pages stored while in progress over a period of time?
Stored as files wherever you like (NOTE: a multi-page document is stored as
a single file. Individual pages of a document are not stored as discrete
files). This is the same as any pc/tablet based program you might use to
create and edit files. Where the files are saved is up to you.

Can you go back and edit at any time? Yes.

Is there spell checking? Yes.

On Thu, Nov 12, 2020 at 8:48 AM s.e. o. 
wrote:

> I am not a user yet. I want to download your programs for writing. How and
> where are the pages stored while in progress over a period of time? Can you
> go back and edit at any time? Is there spell checking? I have purchased a
> new device and plan on adding an app for writers similar to Microsoft Word
> without the unnecessary extras. Thanks
>
> Sent from my iPhone
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Please Could you Advise How I can solve this PLEASE

[Alan B]

Dave,

You identify parts as missing, how are you able to say this is so?

If the document opens without errors or warnings so you are able to see
"parts are missing" then the document has downloaded completely.

The missing parts may be references inside the document to parts that are
located outside the document and inaccessible to you. It is also possible
parts of the document are set to hidden and need to be unhidden to be
visible. The last possibility I can think of is change tracking. Visibility
of comments, changes and revision marks can be set in various ways so it
either looks like a "clean" document with no editing or commenting having
been done or be set to show all or a selected combination of comments,
edits, and revision marks.

The structure of a Word document file is such that if every bit of the file
does not download then Word or OpenOffice would see it as corrupted and
complain when attempting to open it. The design of file download programs
is such that, with rare exceptions, the file downloads completely and
successfully. And if it doesn't download successfully, it is very unlikely
to be recognized as a document file by the computer.

On Wed, Nov 4, 2020 at 5:27 AM David Millington 
wrote:

> When I receive a Word document it does not download completely,
> Parts are are missing
> I have an urgent document to read and have this problem.
> Ewoud Greatly appreciate your help
> My sincere thanks
> Dave
> ><>
>
> Sent from Mail for Windows 10
>
>
>
> --
> This email has been checked for viruses by AVG.
> https://www.avg.com
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Problem Opening and Editing Documents

[Alan B]

Hello Jan,

>From your description I am understanding this happens with all Open Office
documents.

My suggestion is to do a test as follows.
*Create a new document with Writer.
*Save it as a Microsoft Word file, either .doc or .docx format, then close
Writer.
*Open Writer again and open the .doc(x) file that was just created.

If the file opens without the warning then it is possible the anti-malware
program on your computer is causing the problem. I have found reports of
this type of problem with Bitdefender.

If the test file did open without warning then disable your anti-malware
program (Bitdefender or whatever it may be) and try again to open some of
your Open Office documents. If they open without the warning then the
problem is the anti-malware program.

Report the problem to the anti-malware software vendor via their support
site. If they don't have a ready solution then find a different
anti-malware solution. Better to stay protected by moving to a different
product than stay unprotected waiting an indefinite amount of time for a
solution from the software vendor.

On Wed, Oct 28, 2020 at 2:27 PM Jan Beasley  wrote:

> Hello,
> I have been having trouble opening and editing Open Office documents, so I
> decided to download the latest release today thinking that would resolve
> the issue. It did not. I still receive the following error message when
> trying to open documents: Locked for Editing by: Unknown User. Open
> Document Read-Only or open a copy of the document for editing.
>
> So, every time I need to edit a document, I have to open a copy, make
> changes, and then save it as a new document under a slightly
> different name. This results in multiple documents for the same thing
> really.
>
> How can I fix this? Do I just lose all of my documents I have been saving
> for years, uninstall the program completely, and start all over? Please
> help!!
>
> Thank you, Jan
>
> *Jan Beasley, REALTOR®*
> *Team H2 Realty, LLC*
>
> *Direct*: (540) 836-5572
> *Email*: j...@teamh2realty.com
>
> RE/MAX Advantage
> 2017 West Main St
> Waynesboro, VA 22980
>
> Team H2 Realty - "DRIVE & EXPERIENCE"
>
>
> *Licensed to Sell Real Estate in Virginia*
>
> <
> https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=icon
> >
> Virus-free.
> www.avast.com
> <
> https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=link
> >
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: files in READ ONLY form

[Alan B]

Files have a read only property that can be set on or off outside the
program that created them.

IF you are not being prompted for a password and are being shown a "Read
only" message then...
- exit OpenOffice
- Use you file manager program (In Windows it's File Explorer, has a manila
file folder icon) to go to the directory (a.k.a. folder) the file is in
- Select one of the files that is showing as read only
- right-click the file and select properties
- see if the "Read-only" box is ticked, if it is uncheck it and click OK

IF the Read-only box was ticked, now that you've unticked it and clicked
OK, double-click the file to open it in OpenOffice

Does it still display the "Read only" message?

If no, then the problem is resolved for THAT file.

To resolve for the other files, select all of them in File Explorer, right
click and select Properties, then uncheck "Read-only" and click OK button.

Files processed this way will no longer display the "Read only" message.

On Thu, Sep 10, 2020 at 2:46 PM REYNOLD CONGER  wrote:

>
> I have never put any of my files into read-only form and yet I suddenly
> find most of my files now read-only files.
> I've subscribed to Carbonite backup service for years. I recently
> purchased a new computer and requested to Carbonite to restore my files
> onto the hard drive of the new computer.
> I have also been using OpenOffice for years.
> After my files were backed up on the new computer, I discovered the
> majority of my files are in the read-only mode which means I cannot edit
> them.
> Denies that this could have happened yet it has happened. What can I do to
> restore my files to a usable condition?
> Obviously, since I did not put the files into read-only form I have no
> passwords associated with it.
>
> Reynold Conger.
> Sent from Mail for
> Windows 10
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Question for Blended Learning

[Alan B]

Doris,

Following up Dan's note, here is a link I found with detailed instructions
how to install OpenOffice on a Chromebook. The article is dated July this
year so it is as current as possible.

http://www.linuxmadesimple.info/2020/07/how-to-install-openoffice-on-chromebook.html

I saw that Google Docs includes an app called "Forms". It may or may not
enable teaching the database concepts in your lesson. From the looking I
did, there didn't seem to be a way to review the underlying structure.

I also found that Google has a product called "Google Cloud Databases".
These included traditional SQL, e.g. MS SQL Server, MySQL, PostgreSQL, and
others, as well as noSQL databases. There is a free option with this
product. You would have to check with Google to ask if there is an
educational option.

These two options are mentioned because Chromebooks are designed for
connected use and it generally requires some extra work, per the
instructions in the link, to install local programs on them as is done with
a traditional Windows pc/laptop.

On Mon, Aug 3, 2020 at 2:08 PM Doris Gardner 
wrote:

> Does Open Office offer a solution for users on ChromeBooks?
>
> Our county schools will have 'blended learning'  where students have
> face-to-face instruction two days a week and work at home online three days
> a week. Our county is have 1-to-1 digital initiative where all students
> grades 4-12 will receive a Chromebook to use for at-home distance learning.
>
> We have traditionally used Microsoft Office Access to teach units on
> database concepts. We are looking for options that will enable us to teach
> that unit using other platforms on Chromebooks.
>
> Thank you for any insight you can provide
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Compatible with Windows 10 Home; Able to open & convert .docx files

[Alan B]

Yes AND need to understand that the "editable PDF" is a special case of a
PDF document.

To create one from a LibreOffice (this is an OpenOffice mail list but you
referenced LibreOffice so this reply addresses LibreOffice) document that
can later be edited in LibreOffice the option "Hybrid PDF (embed ODF file)"
MUST be selected when creating the PDF from the LibreOffice document.

If and only if this step is taken the pdf can be edited within LibreOffice
provided other features are also available. Per LibreOffice help...
https://help.libreoffice.org/6.2/en-US/text/shared/01/ref_pdf_export.html?DbPAR=SHARED
this embeds the ODF inside the PDF.

The PDF can then be opened and edit in LibreOffice just as if it was an ODT
file.

So yes, LibreOffice can edit PDF but it must be a particular type of PDF.

On Thu, Jul 23, 2020 at 11:52 AM Gerald E Boor  wrote:

> In LibreOffice, you can export a PDF to make it editable.  Just
> wondering if OpenOffice also does that?  Thanks!
>
> Jerry in Michigan
>
> On 7/22/20 3:05 PM, Alan B wrote:
> > Hello Norma,
> >
> > #1 Is apache open office able to convert .docx files to .doc files? Yes.
> > Open the .docx file and save as .doc file.
> > NOTE: Formatting, e.g. margins, tables, and others, is not always
> perfectly
> > converted when the .docx file is opened and the same may be seen in the
> > saved .doc file.
> >
> > #2 Can apache open office convert .pdf files to .doc file?
> > Not so far as I know.
> >
> > For #1, I .docx files can always be read using Word online by creating a
> > free outlook.com account. No worries about converting the file. Also,
> .docx
> > files can have features that don't translate to the .doc format. Keeping
> > the file in .docx format is the way to be certain no features of the
> > document are lost.
> >
> > For #2, there are free converters online. Microsoft Office will open
> .pdfs
> > but there are limitations with what it will do. Check here for more info
> >
> https://support.microsoft.com/en-us/office/opening-pdfs-in-word-1d1d2acc-afa0-46ef-891d-b76bcd83d9c8
> >
> >
> > On Wed, Jul 22, 2020 at 12:06 PM normakline 
> > wrote:
> >
> >>
> >> Greetings --Is apache open office able to convert .docx files to .doc
> >> files?Is your apache open office compatible with Windows Home 10?Can
> apache
> >> open office convert .pdf files to .doc file?The information will help
> me to
> >> buy a new laptop or tablet.Thank you.  NormaSent from my Samsung Galaxy
> >> Tab®|PRO
> >
> >
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Compatible with Windows 10 Home; Able to open & convert .docx files

[Alan B]

Hello Norma,

#1 Is apache open office able to convert .docx files to .doc files? Yes.
Open the .docx file and save as .doc file.
NOTE: Formatting, e.g. margins, tables, and others, is not always perfectly
converted when the .docx file is opened and the same may be seen in the
saved .doc file.

#2 Can apache open office convert .pdf files to .doc file?
Not so far as I know.

For #1, I .docx files can always be read using Word online by creating a
free outlook.com account. No worries about converting the file. Also, .docx
files can have features that don't translate to the .doc format. Keeping
the file in .docx format is the way to be certain no features of the
document are lost.

For #2, there are free converters online. Microsoft Office will open .pdfs
but there are limitations with what it will do. Check here for more info
https://support.microsoft.com/en-us/office/opening-pdfs-in-word-1d1d2acc-afa0-46ef-891d-b76bcd83d9c8


On Wed, Jul 22, 2020 at 12:06 PM normakline 
wrote:

>
>
> Greetings --Is apache open office able to convert .docx files to .doc
> files?Is your apache open office compatible with Windows Home 10?Can apache
> open office convert .pdf files to .doc file?The information will help me to
> buy a new laptop or tablet.Thank you.  NormaSent from my Samsung Galaxy
> Tab®|PRO



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: open office writer

[Alan B]

Paul,

There is no phone support. This mailing list is volunteer support. Having
said that, from your problem description, it seems likely if you
double-click one of the files you want to edit in Wordpad the file opens in
Writer instead.

If this is a fair description of the problem then, to correct it, you
must...
1. RIGHT-CLICK one of the files you would like to open in Worpad
2. on the menu that appears click the "Properties" item, usually the last
item on the menu
3.  click the "Change..." button
4. Find Wordpad in the list of apps (it may be necessary to click "more
apps" to see Wordpad in the list)
5. Click on Wordpad
6. Click the OK button
7. Click the next OK button

These steps will make Wordpad open this file and any other Wordpad file
when the file is double-clicked. It only needs to be done one time.

The above steps were written using Windows 10 as reference. Steps 1 & 2 are
consistent across all versions of Windows as far as I recall. From step 3
onward there may be slight differences depending the version of Windows.
Regardless, the requirement is the same. Change the program that opens the
file to Wordpad from whatever it is.

Two notes:
If/when you install OpenOffice again be mindful during the install for the
option to make OpenOffice the default program. Do not select this option
and it will not be necessary to perform the seven steps above, again, to
make Wordpad open your documents.

Uninstall Writer is not necessary. Very little disk space is recovered by
doing so and having it installed is not the root cause of the problem.

On Sat, May 16, 2020 at 9:15 AM p s  wrote:

> All i want is open office calc. I want to delete writer and all its' bits
> and I do not want my files deleted. (most of which have been "grabbed" by
> "WRITER".
> I can delete writer but do my files go with it?  If i delete it, and the
> files stay, will i be able to access them?
> It is invasive. It has swallowed word pad. I like working with word pad.
> Everything I do is taken over by writer. Then it is useless.
>
> To do anything with a file, I must copy, then delete the empty writer file.
> Post the file to Wordpad. Make the changes and save.
> When I go back to the file, everything is changed.
>
> Can you also tell me why it is so damn hard to get through to you people?
> Just stick some people on the phone and let them ( the experts) direct an
> inquiry of whatever kind.
> You have wasted months of my time.
> cheers
> Paul Spiers
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: E-mail Program

[Alan B]

You're welcome.

Some options for a PDF editor include Adobe's PDF editor, Foxitsoftware's
Phantom PDF, and Qoppa's PDF Studio Standard. There's others. These are the
ones I'm most familiar with.

Adobe's product is a subscription. My understanding is that when the
subscription expires the product will no longer work, can't even open the
program. Adobe also sells a perpetual license for their 2017 product. For
the 2017 product all the features work all the time. For myself, I wouldn't
pay full license price for something that's already three years old and
won't get any updates.

Foxitsoftware's Phantom PDF Standard is sold as a perpetual license with
upgrades for one year. Cost is about 90% of a one year subscription for
Adobe Acrobat Standard DC. The difference being, after the year is up, all
features continue to work.

Qoppa's PDF Studio Standard is sold as a perpetual license with upgrades
for one year. If a new release comes out within a certain time after your
purchase, nine months I think, you're entitled to the new release, so an
upgrade may become available during the license term, not just updates.
It's about 60% of the cost of Adobe's one year subscription. I've used
Qoppa on Linux for years and generally purchase a new license about every
third year. It's met all my advanced PDF needs nicely. I've never used the
Windows version. The license may be used on two devices.

On Fri, May 8, 2020 at 3:06 AM sasha blaskovich 
wrote:

> Hi Alan,
> THank you so much for your answer!!
> From your below, I need it for exactly the following:
> "If the requirements include changing text (adding, removing, reflowing) in
> an existing PDF, controlling how others can use the document (prohibit
> select and copy text, open to a certain page, prevent modification, etc)
> then yes, a PDF editor would be required."
>
>
> ____
> From: Alan B 
> Sent: May 6, 2020 6:24 PM
> To: users@openoffice.apache.org 
> Subject: Re: E-mail Program
>
> No open source PDF editors that I am aware of.
>
> Regarding this particular question it is important to understand the
> requirement. Many people I have supported have asked for a PDF editor.
> Getting them to define what they actually want to do often determines that
> the features of Adobe Acrobat Reader or Foxit Reader, among others, will
> meet their requirements.
>
> If the requirements include changing text (adding, removing, reflowing) in
> an existing PDF, controlling how others can use the document (prohibit
> select and copy text, open to a certain page, prevent modification, etc)
> then yes, a PDF editor would be required.
>
> If the requirements include highlighting, marking out, underscoring
> existing text, applying a digital signature, adding comments, then Adobe
> Acrobat Reader or Foxit Reader both will meet the requirements. If the
> requirement is to create a PDF document then OpenOffice programs can be
> used to do that along with other methods, e.g. Foxit Reader includes a PDF
> "printer". Select it as the target printer and instead of a page coming out
> of your physical printer, a PDF document is created.
>
> On Tue, May 5, 2020 at 12:40 PM sasha blaskovich 
> wrote:
>
> > That was very helpful.  The distinction is now very clear.
> > Is there an Open Source PDF Editor, like Adobe Pro?
> >
> > 
> > From: Alan B 
> > Sent: May 5, 2020 6:33 AM
> > To: users@openoffice.apache.org 
> > Subject: Re: E-mail Program
> >
> > You're welcome, Sasha.
> >
> > Some additional information for you to consider.
> >
> > Yes, some are simply profiting without contributing. However some people
> > have limited / no online access. Sellers that provide physical media,
> > DVD/USB, are providing a worthwhile service for them.
> >
> > The other point, OpenOffice is "open source software". Not "freeware".
> > There are distinctions. Most often, freeware comes with other unwanted or
> > unneeded software that continually requests the user to upgrade to paid
> > version or to buy some additional product. A nag that is not helpful and,
> > if the nag is followed, can lead to undesirable problems on the pc.
> >
> > When you search for software I suggest including the phrase "open
> source",
> > with the quotes, in your search. You will find many useful programs
> > provided in the same manner as OpenOffice.
> >
> > e.g.
> > Audacity - sound file editing
> > GIMP, Krita - image editing and creation
> > OpenShot - video editing
> > Thunderbird - email
> > Calibre - ebook library and management
> > Gramps - geanalogical research software
> > etc.
> 

Re: Unable to uninstall

[Alan B]

To uninstall the French version try the following...
1. Restart the pc (this will force all programs to close)
2. Log back in to your desktop
3. Go to Settings
4. Select Apps
5. In "Search this list" type "office"
* If Windows has OpenOffice correctly installed it will be visible in the
filtered list that is now displayed
6. Click OpenOffice
7. Click the Uninstall button
8. Follow the remaining prompts
* If a warning is displayed saying a program is preventing installation
select the option to attempt to close the program
9. Now try installing the English version

If step 5, 8 or something else does not follow per the list above please
provide more information.

On Thu, May 7, 2020 at 1:48 AM BERNARD H SILVERMAN <
outlook_c9a92ba9c18dd...@outlook.com> wrote:

> I downloaded Open Office and somehow it downloaded the French version.  I
> do not speak French and since all of the instructions are shown to me in
> French I am unable to Uninstall it.  To make matters worse I tried to
> reinstall open office again this time making sure I was reinstalling the
> English version but I am getting back an error message telling me the
> download is not completing because another Open Windows application is
> already installed.  HELP!
>
> Sent from Mail for
> Windows 10
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: E-mail Program

[Alan B]

No open source PDF editors that I am aware of.

Regarding this particular question it is important to understand the
requirement. Many people I have supported have asked for a PDF editor.
Getting them to define what they actually want to do often determines that
the features of Adobe Acrobat Reader or Foxit Reader, among others, will
meet their requirements.

If the requirements include changing text (adding, removing, reflowing) in
an existing PDF, controlling how others can use the document (prohibit
select and copy text, open to a certain page, prevent modification, etc)
then yes, a PDF editor would be required.

If the requirements include highlighting, marking out, underscoring
existing text, applying a digital signature, adding comments, then Adobe
Acrobat Reader or Foxit Reader both will meet the requirements. If the
requirement is to create a PDF document then OpenOffice programs can be
used to do that along with other methods, e.g. Foxit Reader includes a PDF
"printer". Select it as the target printer and instead of a page coming out
of your physical printer, a PDF document is created.

On Tue, May 5, 2020 at 12:40 PM sasha blaskovich 
wrote:

> That was very helpful.  The distinction is now very clear.
> Is there an Open Source PDF Editor, like Adobe Pro?
>
> ________
> From: Alan B 
> Sent: May 5, 2020 6:33 AM
> To: users@openoffice.apache.org 
> Subject: Re: E-mail Program
>
> You're welcome, Sasha.
>
> Some additional information for you to consider.
>
> Yes, some are simply profiting without contributing. However some people
> have limited / no online access. Sellers that provide physical media,
> DVD/USB, are providing a worthwhile service for them.
>
> The other point, OpenOffice is "open source software". Not "freeware".
> There are distinctions. Most often, freeware comes with other unwanted or
> unneeded software that continually requests the user to upgrade to paid
> version or to buy some additional product. A nag that is not helpful and,
> if the nag is followed, can lead to undesirable problems on the pc.
>
> When you search for software I suggest including the phrase "open source",
> with the quotes, in your search. You will find many useful programs
> provided in the same manner as OpenOffice.
>
> e.g.
> Audacity - sound file editing
> GIMP, Krita - image editing and creation
> OpenShot - video editing
> Thunderbird - email
> Calibre - ebook library and management
> Gramps - geanalogical research software
> etc.
>
> On Tue, May 5, 2020 at 2:40 AM sasha blaskovich 
> wrote:
>
> > Thank you very much!  It is very sad that there are vultures out there
> > that are selling this freeware!
> > I hope they are providing a kickback from their sales
> >
> > 
> > From: Alan B 
> > Sent: May 4, 2020 6:04 PM
> > To: users@openoffice.apache.org 
> > Subject: Re: E-mail Program
> >
> > Sasha,
> >
> > To add to Wade's statement...
> >
> > OO is free for anyone to download and should be downloaded from the
> > official website, https://www.openoffice.org/
> >
> > Click on the "I want to download Apache OpenOffice" link to get to the
> > download page.
> >
> > No registration required.
> > Return to the page as often as you like to check for a new version.
> > Download the new version, again for free, when it is available on the
> > download page.
> >
> > On Mon, May 4, 2020 at 6:28 PM sasha blaskovich 
> > wrote:
> >
> > > Hi,
> > > I recently bought your Open Office software CD on Amazon.ca and need to
> > > know if there is an Open Office E-mail program similar to the MS
> Outlook
> > > program?
> > > Thanks,
> > > Regards,
> > > Sasha
> > >
> >
> >
> > --
> > Alan Boba
> > CISSP, CCENT, ITIL v3 Foundations 2011
> >
>
>
> --
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: E-mail Program

[Alan B]

You're welcome, Sasha.

Some additional information for you to consider.

Yes, some are simply profiting without contributing. However some people
have limited / no online access. Sellers that provide physical media,
DVD/USB, are providing a worthwhile service for them.

The other point, OpenOffice is "open source software". Not "freeware".
There are distinctions. Most often, freeware comes with other unwanted or
unneeded software that continually requests the user to upgrade to paid
version or to buy some additional product. A nag that is not helpful and,
if the nag is followed, can lead to undesirable problems on the pc.

When you search for software I suggest including the phrase "open source",
with the quotes, in your search. You will find many useful programs
provided in the same manner as OpenOffice.

e.g.
Audacity - sound file editing
GIMP, Krita - image editing and creation
OpenShot - video editing
Thunderbird - email
Calibre - ebook library and management
Gramps - geanalogical research software
etc.

On Tue, May 5, 2020 at 2:40 AM sasha blaskovich 
wrote:

> Thank you very much!  It is very sad that there are vultures out there
> that are selling this freeware!
> I hope they are providing a kickback from their sales
>
> ____
> From: Alan B 
> Sent: May 4, 2020 6:04 PM
> To: users@openoffice.apache.org 
> Subject: Re: E-mail Program
>
> Sasha,
>
> To add to Wade's statement...
>
> OO is free for anyone to download and should be downloaded from the
> official website, https://www.openoffice.org/
>
> Click on the "I want to download Apache OpenOffice" link to get to the
> download page.
>
> No registration required.
> Return to the page as often as you like to check for a new version.
> Download the new version, again for free, when it is available on the
> download page.
>
> On Mon, May 4, 2020 at 6:28 PM sasha blaskovich 
> wrote:
>
> > Hi,
> > I recently bought your Open Office software CD on Amazon.ca and need to
> > know if there is an Open Office E-mail program similar to the MS Outlook
> > program?
> > Thanks,
> > Regards,
> > Sasha
> >
>
>
> --
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: E-mail Program

[Alan B]

Sasha,

To add to Wade's statement...

OO is free for anyone to download and should be downloaded from the
official website, https://www.openoffice.org/

Click on the "I want to download Apache OpenOffice" link to get to the
download page.

No registration required.
Return to the page as often as you like to check for a new version.
Download the new version, again for free, when it is available on the
download page.

On Mon, May 4, 2020 at 6:28 PM sasha blaskovich 
wrote:

> Hi,
> I recently bought your Open Office software CD on Amazon.ca and need to
> know if there is an Open Office E-mail program similar to the MS Outlook
> program?
> Thanks,
> Regards,
> Sasha
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Adobe OO for Linux...?

[Alan B]

Hello Martin,

I haven't installed the RPM package. However on the Apache OpenOffice
website I found these instructions for RPM install.
https://www.openoffice.org/download/common/instructions.html#linux-rpm

Seems you need to:
navigate to the directory the RPMs were extracted to
su to root
issue the command rpm -Uvih *rpm
there's a few other steps for shell integration

Been a while since I installed my DEB version but, if I recall correctly,
it was the same process. Extract, use a wildcard to indicate all DEBs,
*deb. That install is working just fine.

On Mon, Apr 27, 2020 at 1:47 PM Martin Rosenfeld 
wrote:

> Thanks for the suggestions as to where to download Apache OpenOffice
> X_64 for Linux Mageia (RPM version). I got a GZ file which I unzipped
> into a folder that contained a gazillion rpm files. I don't know what to
> do next. Should I ask this on a Mageia forum?
>
> Martin
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Numbers automatically advance in spreadsheet columns

[Alan B]

Hello David,

Have you tried,
- select cell
- grab cell handle at bottom right with mouse left click and hold
- press and hold Ctrl key
- drag mouse

That will produce a column that repeats the number in the highlighted cell.

On Mon, Apr 27, 2020 at 1:08 PM David Deeks 
wrote:

> I have been an Open Office user for many years, but only recently
> discovered this group, and have already learned a couple of things!
>
> I am hoping however that someone can help with a specific and longstanding
> problem with numbers in spreadsheet columns. If I have a cell with a number
> in that I want repeated down the column, I would love to able to simply
> highlight the cell and drag down the column. The problem is that in each
> line the numbers always increase by 1. This is useful of course sometimes,
> but not always! I have tried all formats, including text etc, and feel as
> though I’ve looked through every menu - but cannot find how to stop it
> doing this. I am sure there must be a way?
>
> Thanks
>
> David Deeks
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: conversion

[Alan B]

Use same technique as would be done for ods file.

1. File>Page Preview
2. Click "Format Page" button
3. Click "Sheet" tab
4. Click "Grid" option in the Print group
5. Click "OK" button
6. Print per your usual method

On Tue, Apr 7, 2020 at 6:11 PM  wrote:

> client sent file in xlsx  can I print it so I have grid lines
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Failure

[Alan B]

jhivacaville,

Go to this website to download the latest version of the program, free.
https://www.openoffice.org/download/index.html

As already mentioned the program is free.

The message does go to all users, not to Apache foundation. This is not
ridiculous. This is the support model for this program and many other open
source programs. It is a different model than used by commercial software
publishers.

Everyone here is a volunteer providing free support to other users. Neither
strong words, frustration or CAPITAL LETTERS will change that.

On Thu, Mar 12, 2020 at 3: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.
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Saving changes in original

[Alan B]

Sorry Saleema, no new ideas.

I am not certain from your description what steps you take to get to the
point Save is not available.
You say '...the "save" option was not checked in settings...'. In which
settings?
When I have Writer open there is no "Settings" menu. There are "File",
"Edit", "View", "Insert", "Format", "Table", "Tools", "Window", and "Help"
menu items. None of the sub menus under any of those menus has a "settings"
option.
More specificity is needed about the steps you are taking to understand
clearly how you get to the point of "Save" not being available.

e.g.
1) open Writer,
2) after Writer is open use the File>Open menu,
3) find and select "my file"
... (and what folder is the file in? Documents, Downloads, someplace
else)...
4) click "Open"
-- or --
1) find file on computer (where, maybe Documents?),
2) double-click file to open
-- or --
...something else? If so, describe the process step-by-step.

And once the file is open similar step-by-step description as above to get
to the point of saving the file.

On Fri, Mar 6, 2020 at 1:19 PM Saleemaeg  wrote:

> Thanks so much for your quick response Alan.
>
> I tried to remedy the issue last night and found that the "save" option
> was not checked in settings, only the "save as" option was checked. I then
> checked the "save" option and that seemed to correct the problem on every
> new doc I opened. However, my original one will only "save as."  Not a big
> deal, may be a glitch on my computer, but if you have any ideas about it, I
> would appreciate your input.
>
> Thanks for the awesome work you and the Open Office team accomplish. Well
> done!
>
> Best,
> Saleema
>
> > On Mar 6, 2020, at 8:26 AM, Alan B  wrote:
> >
> > Saleema,
> >
> > To save changes to an existing document, File>Save, is the way to do it.
> > Note, if there are no changes "Save" will be dimmed and clicking it
> doesn't
> > cause any action.
> >
> > If this is what you are doing already then a little more detail about the
> > exact steps from opening the file to attempting to save it would be
> helpful.
> >
> > Also, is this a problem with every document you attempt to edit and save
> or
> > with only one or a small number of documents?
> >
> >
> >> On Fri, Mar 6, 2020 at 4:28 AM SaleemaEG  wrote:
> >>
> >> Hi, and thank you so much for open office, it is great!
> >>
> >> Would you please tell me how to "save" changes in my original document
> >> without creating a new version?  I am trying to save my changes (I do
> not
> >> choose "save as")  but I keep getting a new page with the edit I want to
> >> save. Sometimes I simply notice a misspelled word and I correct it,  but
> >> the original remains the same. Is there a way to* save* in the original?
> >>
> >> Thank you in advance for any help you can offer.
> >>
> >> With Gratitude,
> >> Saleema
> >
> >
> > --
> > Alan Boba
> > CISSP, CCENT, ITIL v3 Foundations 2011
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Saving changes in original

[Alan B]

Saleema,

To save changes to an existing document, File>Save, is the way to do it.
Note, if there are no changes "Save" will be dimmed and clicking it doesn't
cause any action.

If this is what you are doing already then a little more detail about the
exact steps from opening the file to attempting to save it would be helpful.

Also, is this a problem with every document you attempt to edit and save or
with only one or a small number of documents?


On Fri, Mar 6, 2020 at 4:28 AM SaleemaEG  wrote:

> Hi, and thank you so much for open office, it is great!
>
> Would you please tell me how to "save" changes in my original document
> without creating a new version?  I am trying to save my changes (I do not
> choose "save as")  but I keep getting a new page with the edit I want to
> save. Sometimes I simply notice a misspelled word and I correct it,  but
> the original remains the same. Is there a way to* save* in the original?
>
> Thank you in advance for any help you can offer.
>
> With Gratitude,
> Saleema
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: PROBLEM

[Alan B]

John,

1. Select File>Page Preview from the menu
2. Click the "Format Page" button
3. Click the "Sheet" tab
4. Select "Fit print range(s) to width/height" from the "Scaling mode" list
5. Set "Width in pages" to 1

Print the worksheet.


On Thu, Mar 5, 2020 at 3:37 PM John Clipper 
wrote:

> Apache too big to have a help line?
>
> I have a  spreadsheet - 8 columns. All cols contain data. When I print
> spreadsheet -
>
> result 7 cols on page 1
>
> col 8 on page 2.
>
> Any solution available?
>
> John
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Help with document

[Alan B]

Hello Bella,

Some background info that I hope is helpful, re:templates...

If the last part of the file name provided by the university was .ott it is
a template file, e.g. university.ott. If not .ott at end of the name it is
not a template file.

If it is a template file like university.ott...:
* and university.ott is opened by double-click or File>Open... then the
document name at the top of the OpenOffice window will be "Untitled 1". It
will not be "university.ott" or "university"
* when saving the file for the first time OpenOffice will prompt for a file
name
* all edits will be saved in the file, "file-name-you-make-up.ODT"
* if "university.ott" template file is opened again none of the edits will
be there because that is not the file the edits were saved in

If for example you named the file "university" when saving, OpenOffice has
given it the full name "university.ODT". To find the file containing your
edits the file "university.ODT" must be opened.

Since you saved your edits but they weren't there when the file was opened
again I suspect you opened and edited a template file, .ott, then named and
closed it per the prompts when done. Then when opening the file again the
original "university.ott" file was opened and so no edits are found in the
file.

The "file-name-you-make-up.ODT", e.g. "university.ODT", is the file that
must be opened to see your edits.

If you're using Windows the file that was saved with all the edits is most
likely to be found in your "My Documents" folder.




On Wed, Mar 4, 2020 at 3:23 PM Bella Dowthwaite 
wrote:

> G’day
>
> Thank you for all of the replies. I didn’t realise this was going to a
> mailing list, I was just trying to contact the company itself for online
> support. Apologies!
>
> I had saved it in .odt format, and it was a template (document) given by
> my university for me to fill in. The same thing happened (column
> disappearing) when I used it on other applications too.
>
> Anyway, I have typed up my answers in the disappearing column in a
> seperate document now, without using the template. I think the document was
> just uneditable in open office.
>
> Thank you again for the replies I appreciate it.
>
> Bella
>
> > On 5 Mar 2020, at 2:39 am, Alan B  wrote:
> >
> > Is the template publicly available? If yes, please indicate where it can
> be
> > found so some testing can be done.
> >
> > Also, to help replicate your conditions when testing, what version of
> > OpenOffice are you using and what kind of computer (Windows, include
> > version, i.e. 7, 10, etc., Mac, something else?)
> >
> > Thank you.
> >
> > On Wed, Mar 4, 2020 at 3:18 AM Bella Dowthwaite <
> belladowthwa...@gmail.com>
> > wrote:
> >
> >> Hello,
> >>
> >> I am an Open Office user and am having a big issue with a document.
> >> I downloaded a template for university studies, filled it in, and then
> >> when I closed it and re-opened it (I had already saved it as is) a whole
> >> column in the template had disappeared, full of my written work.
> >>
> >> I downloaded the template and filled in the column again on a new
> >> document, but when I closed it again and reopened it the same thing has
> >> happened. A whole column of writing had disappears and I cannot find it
> >> anywhere.
> >>
> >> I have lost a lot of work and am very concerned.
> >>
> >> Please let me know how to resolve this.
> >>
> >> Call on 0434672500 if possible.
> >>
> >> Thank you kindly
> >>
> >> Bella Dowthwaite
> >> -
> >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> >> For additional commands, e-mail: users-h...@openoffice.apache.org
> >>
> >>
> >
> > --
> > Alan Boba
> > CISSP, CCENT, ITIL v3 Foundations 2011
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Help with document

[Alan B]

Is the template publicly available? If yes, please indicate where it can be
found so some testing can be done.

Also, to help replicate your conditions when testing, what version of
OpenOffice are you using and what kind of computer (Windows, include
version, i.e. 7, 10, etc., Mac, something else?)

Thank you.

On Wed, Mar 4, 2020 at 3:18 AM Bella Dowthwaite 
wrote:

> Hello,
>
> I am an Open Office user and am having a big issue with a document.
> I downloaded a template for university studies, filled it in, and then
> when I closed it and re-opened it (I had already saved it as is) a whole
> column in the template had disappeared, full of my written work.
>
> I downloaded the template and filled in the column again on a new
> document, but when I closed it again and reopened it the same thing has
> happened. A whole column of writing had disappears and I cannot find it
> anywhere.
>
> I have lost a lot of work and am very concerned.
>
> Please let me know how to resolve this.
>
> Call on 0434672500 if possible.
>
> Thank you kindly
>
> Bella Dowthwaite
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Open office

[Alan B]

The download is 165mb.

According to the OpenOffice website there is a version for OS 10 versions
>= 10.7. High Sierra is 10.13 so that's the intended version.

I don't use Mac and haven't checked to see if there are any specific
compatibility issues with OpenOffice and High Sierra.

On Tue, Feb 18, 2020 at 3: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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Calc cell large

[Alan B]

Dana,

Try opening Calc and going through the menu View > Zoom...

If 100% is not marked, click, it then click the "OK" button.

If you find 100% already marked this certainly won't be the solution. If it
is not marked it may be the fix that's needed.

On Tue, Feb 4, 2020 at 2:03 AM Dana Lynch  wrote:

> Calc cells suddenly are huge and I can't reset calc. I did default
> format, reinstalled, and even did computer restore from before problem
> but to no avail. I can adjust height and width, but one at a time. This
> only affects new files and not ones I have stored on external hard
> drives. Please help me as I don't want to purchase Microsoft Office.
> Thank you.
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Unsaved Open Office Writer Document

[Alan B]

Hello Narissa,

I think you are out of luck. If OpenOffice or the computer had crashed or
if you forced the program to close without saving the document you would be
able to find the document per the instructions at the link below.
https://smallbusiness.chron.com/recover-unsaved-work-openoffice-29581.html

That crash recovery version of the document the instructions direct how to
find disappeared whenever the program was closed by clicking the Discard
button in every test I tried.

One other possibility is look in the directory the file is saved in. Make
sure your file browser is set to show hidden files. It is possible a
version of the file might still be there. The name would likely start with
the ~ character and end with #. The file has a greater chance of being
there if it was saved on a network drive instead of the pc's hard drive.

Good luck.

At the risk of rubbing salt in a wound, and not at all intending to,
regardless what happens with this file I suggest the following to people as
a way to protect against just this sort of thing. "Save early, save often".
The keyboard combination Ctrl+S allows saving the file just as rapidly as
typing a capital letter. Get into the Ctrl+S habit at any time you pause
your editing and there's a great chance of not loosing any work.

On Mon, Feb 3, 2020 at 10:36 AM Narissa Hinojosa 
wrote:

> Hello! I am desperate for help!!
>
> I accidentally clicked “don’t save” when editing a document! I have looked
> everywhere and I can’t find out how to get it back! I went through the
> steps online of the c:\users\ that brings up the backup file and it’s not
> in there!
>
> Thank you so much for your time!
>
>
> Narissa Hinojosa
> General Manager
> phone: 361-883-8712
> email: nari...@electrictancc.com
>
> The content of this email is confidential and intended for the recipient
> specified in message only. It is strictly forbidden to share any part of
> this message with any third party, without a written consent of the sender.
> If you received this message by mistake, please reply to this message and
> follow with its deletion, so that we can ensure such a mistake does not
> occur in the future



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: [AOO-Templates]

[Alan B]

Hi Chuck,

I'm also using OO 4.1.7. On Linux though. Have Windows 10 but have not
tested with it. Only so much time for volunteering in a day.

Based on your feedback I tried with no document open, with a new unsaved
document open (Untitled 1), and with a previously saved document open.

In all cases File > New > Templates and Documents initialized a new
Untitled 1 document based on the selected template.

Seems you have discovered a bug in the Mac version.

On Wed, Jan 29, 2020 at 8:59 PM Chuck Spalding  wrote:

> 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
> <https://wiki.openoffice.org/wiki/Documentation> 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]
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: [AOO-Templates]

[Alan B]

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


2. The chapter with template usage info found in the "Getting Started
Guide" section of the webpage above. The link will download an .odt file
that opens in Writer
Ch3 - Using Styles and Templates


4. Refer to the section "Importing a template" on page 22.
The template must be imported before it can be used in the next step.
Note: you must know where the template file has been downloaded to so it
can be picked for import

5. Refer to "Using a template to create a document" on page 14.
Once a template is imported this is the only step that needs to be repeated
to create a document with a given template.




On Wed, Jan 29, 2020 at 6:42 AM Susan B  wrote:

> I have been trying for 5 hours to download and utilize some of the
> templates from your site. When they download they just go into my document
> file. I do not understand how to get them to where the app will open them
> up in a blank file or on a blank page. Can you tell me where I can find,
> easy to follow, instructions on downloading and installing them to Open
> Office. Or give me a URL with the directions for doing this? I am quite
> lost and need some of them quickly for starting my new business.
>
> Respectfully,
> Susan Busk
> Managing Partner
> S Trading & More
> dba: S Custom Jewelry
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Calc Help-INTERIM SOLUTION

[Alan B]

See David Robeley's response.

I was jumping back and forth between virtual machines and inadvertently
used the one with LibreOffice without remembering you're using OpenOffice.
My bad.

Sorry about that.

On Mon, Jan 27, 2020 at 4:20 PM WA.TWORSX via AOL
 wrote:

> Alan:
>
> I tried in cell H44: =MINIFS(G6:G41,G6:G41,">0"), but it is not working
> for me. Error508: Error in bracketing is shown.
>
> I also tried with use of semicolons =MINIFS(G6:G41;G6:G41;">0") rather
> than commas; #NAME? error is returned.
>
> No joy here.
>
> I could not find anything  as =MINFS(  ) funtion within the built-in
> (F1) Help file. Can you point me to a discussion elsewhere?
>
>
> On 1/27/2020 3:01 PM, Alan B wrote:
> > Hello Vince,
> >
> > Thank you for your kind words.
> >
> > In your sheet notes you describe needing to "segment a formula" into
> > several ranges. Unnecessary work, I think.
> >
> > Try the following formulas instead...
> > In H43, =MAXIFS(G6:G41,G6:G41,">0")
> > In H44, =MINIFS(G6:G41,G6:G41,">0")
> >
> > They appear to me to work as desired in your example sheet.
> >
> > On Sun, Jan 26, 2020 at 2:40 PM WA.TWORSX via AOL
> >  wrote:
> >
> >> I believe that I am successful with an interim solution to my original
> >> problem.
> >>
> >> This DropBox link, I think, will allow you to download my interim
> >> solution, which comes with some caveats and compromises:
> >>
> >>
> >>
> https://www.dropbox.com/s/05gk2h8zt7lbua2/Calc%20Help-updating%20Data_INTERIM%20SOLUTION.ods?dl=0
> >>
> >>
> >> The caveats and compromises are presented in the referenced .ods file by
> >> way of annotated comments on the content of cells as used in my
> solution.
> >>
> >> I am very appreciative to AlanB for the time he has spent in an effort
> >> to lead me toward the correct Calc sheet.  Believe me, I have learned
> >> from his thoughtfulness and patience to explain why he made specific
> >> suggestions for changing my approach.  This is how I am able to learn.
> >> Thank you Alan!  If it were not for your assistance, I would not have
> >> gotten to this point.
> >>
> >> In his 1/24/2020 posted reply, Alan mentioned a glitch involving cell
> >> G36.  I have not been able to duplicate the problem.
> >>
> >> Alan's logic for the formula in cell J6:
> >>
> >>> * The formula in cell J6 for "Total Pins" column calculates total pins
> >> for
> >>> rows 6 through row the formula is in.
> >>>
> >>
> =IF(ISNUMBER(I6),DSUM($G$5:INDIRECT(CONCATENATE("$G",ROW())),1,$BB$5:$BB$6),"")
> >>> This formula should be copied to all week# rows in column J. It updates
> >>> correctly for each row it is in.
> >> is far above my present skill level. Thus, I may return to it in the
> >> future when I attempt to set up a calc sheet for a new WINTER SR LEAGUE
> >> bowling season.
> >>
> >> Yes, this all started with my goal of AL7 and AN7 being updated
> >> automatically, without first changing the enclosed formula or being
> >> modified by hand.  My interim solution allows for auto-updating of AL7.
> >> Cell AN7 is simply: AN7=(AL7/3).
> >>
> >> Regards,
> >>
> >> VinceB.
> >>
> >>
> >> P.S. The PBA Oklahoma Open Bowing Tournament stepladder finals are
> >> presently being televised on FS1 channel. I'm gone!
> >>
> >>
> >>
> >>
> >>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Calc Help-INTERIM SOLUTION

[Alan B]

Hello Vince,

Thank you for your kind words.

In your sheet notes you describe needing to "segment a formula" into
several ranges. Unnecessary work, I think.

Try the following formulas instead...
In H43, =MAXIFS(G6:G41,G6:G41,">0")
In H44, =MINIFS(G6:G41,G6:G41,">0")

They appear to me to work as desired in your example sheet.

On Sun, Jan 26, 2020 at 2:40 PM WA.TWORSX via AOL
 wrote:

>
> I believe that I am successful with an interim solution to my original
> problem.
>
> This DropBox link, I think, will allow you to download my interim
> solution, which comes with some caveats and compromises:
>
>
> https://www.dropbox.com/s/05gk2h8zt7lbua2/Calc%20Help-updating%20Data_INTERIM%20SOLUTION.ods?dl=0
>
>
> The caveats and compromises are presented in the referenced .ods file by
> way of annotated comments on the content of cells as used in my solution.
>
> I am very appreciative to AlanB for the time he has spent in an effort
> to lead me toward the correct Calc sheet.  Believe me, I have learned
> from his thoughtfulness and patience to explain why he made specific
> suggestions for changing my approach.  This is how I am able to learn.
> Thank you Alan!  If it were not for your assistance, I would not have
> gotten to this point.
>
> In his 1/24/2020 posted reply, Alan mentioned a glitch involving cell
> G36.  I have not been able to duplicate the problem.
>
> Alan's logic for the formula in cell J6:
>
> > * The formula in cell J6 for "Total Pins" column calculates total pins
> for
> > rows 6 through row the formula is in.
> >
> =IF(ISNUMBER(I6),DSUM($G$5:INDIRECT(CONCATENATE("$G",ROW())),1,$BB$5:$BB$6),"")
> > This formula should be copied to all week# rows in column J. It updates
> > correctly for each row it is in.
> is far above my present skill level. Thus, I may return to it in the
> future when I attempt to set up a calc sheet for a new WINTER SR LEAGUE
> bowling season.
>
> Yes, this all started with my goal of AL7 and AN7 being updated
> automatically, without first changing the enclosed formula or being
> modified by hand.  My interim solution allows for auto-updating of AL7.
> Cell AN7 is simply: AN7=(AL7/3).
>
> Regards,
>
> VinceB.
>
>
> P.S. The PBA Oklahoma Open Bowing Tournament stepladder finals are
> presently being televised on FS1 channel. I'm gone!
>
>
>
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Calc Help

[Alan B]

DNB is meant to note someone did not bowl. It is just text entered in each
cell rather than merging the cells and entering "Did not bowl".

Now, some bad news. After reviewing what I suggested I realized the formula
given for cell AL7 will always show the value in G36 if the column G
formula is copied to every row at the start of each season. If it is added
week by week to each row in column G, then no problem. That doesn't make
for an easy to maintain sheet though.

My idea was enter three scores each week and everything else updates.

I did a little more thinking and came up with the following which meets the
goal above (this all started so AL7 and AN7 will update without being
modified by hand)...

* cells in the range D6:F41 must always be a score, the text "DNB", or be
empty
* Rows 6 through 41 must always have the games entered week by week. IOW,
no entering week 7 before week 6.
* the row for half way in the season must be removed. Only rows for bowling
weeks are allowed

* The formula in cell G6 for "Match Series" column is...
=IF(SUM(D6:F6)=0,IF(D6="DNB","DNB",""),SUM(D6:F6))
The formula displays the total for the games, DNB, or "".
SUM is 0 if columns D-F have DNB or "".
This formula can be copied to all the rows in the column and it will update
correctly for each row it is in.

* The formula in cell H6 for "Match Average" column is...
=IF(ISNUMBER(G6),G6/3,G6)
This formula can be copied to all the rows in the column and it will update
correctly for each row it is in.

* The formula in cell J6 for "Total Pins" column calculates total pins for
rows 6 through row the formula is in.
=IF(ISNUMBER(I6),DSUM($G$5:INDIRECT(CONCATENATE("$G",ROW())),1,$BB$5:$BB$6),"")
This formula should be copied to all week# rows in column J. It updates
correctly for each row it is in.
So for row 10 it calculates the total of rows 6 through 10, For row 15 the
total of row 6 through 15 and so on. If there is no number in League
Average it displays "".
Buried in the formula is the DSUM function. It requires a "Criteria Range"
to work. As written here the criteria range is cells BB5 and BB6. Cell BB5
contains the formula =G5. Cell BB6 contains >=0. For a criteria range to
work the column titles of the "database" and the "criteria range" must
match exactly (not accounting for formatting). If column title G, "Match
Series", is ever changed having cell BB5 be a formula that refers to it
prevents needing to remember to update the criteria.
The INDIRECT function enables the formula to identify the ROW() it is in so
the DSUM database range doesn't have to be entered individually for each
row, e.g. $G$5:$G$5, $G$5:$G$6, $G$5:$G$7 ... , $G$5:$G$10 and so on.

* The formula in cell AL7 for Vince post match play is...
=INDEX($Sheet1.G6:G41,36-COUNTBLANK($G$6:$G$41),1)
The column G formula returns one of three values, the sum of the games,
"DNB", or "". The season has 36 weeks. The formula presumes that as weeks
go by the Match Series column will be either a number, "DNB", or "" and
that "" are always the last rows in the column. Provided these conditions
are true the formula always returns the most recently entered week's Match
Series result.

* The formula in cell AN7 for Vince post match average is...
=INDEX($Sheet1.H6:H41,36-COUNTBLANK($H$6:$H$41),1)
This works the same as the above formula except for Match Average.




On Fri, Jan 24, 2020 at 10:16 AM WA.TWORSX via AOL
 wrote:

>
> On 1/20/2020 5:58 PM, Alan B wrote:
> > I've found a method that can work, providing the spreadsheet design is
> > modified somewhat.
> > It comes from a formula provided by RusselB in the OpenOffice forums.
> >
> > =index(range;count(range);1)
> >
> > For your sample spreadsheet this formula in cell AL7
> > =INDEX($Sheet1.G6:G42,COUNTA($Sheet1.G6:G42),1)
> > will return the Match Series value for the last value entered. When
> week#20
> > is completed the number in AL7 will update. When week#21 is completed it
> > will update again, and so on.
> >
> > REQUIRED design changes
> > 1. There must not be any merged cells that span column G. A merged cell
> in
> > the column breaks the formula. Update the =INDEX formula for column H and
> > the same is true, no merged cells.
> > 2. The formulas in the Match Average and Total Pins columns should
> change.
> > The IF test should be whether the tested cell contains a number, not
> > whether it is blank. This will prevent #value! errors being displayed in
> > those cells.
> > 3. Last, any blank rows in a column must be BELOW the currently completed
> > week number.
> >
> > To meet design change #1 the "Did not bowl" in week

Re: microsoft office

[Alan B]

...hit Send accidentally

the complete message

Hi Margaret,

I'm not familiar with Open Office, or other documents, being converted
without authorization to Microsoft Word format.

So I have a question. To open a document do you find the file then
double-click it with your mouse and it opens in Word?

If that's what you do and what happens then the problem is likely something
called a "file association".

If Word has been recently installed, reinstalled, or the the repair feature
has been applied to the Microsoft Office installation then the file
associations could have changed. Some Windows updates also change (set to
Microsoft's preferences) file associations.

To change the file association so your Open Office documents open in Write,
Calc, etc...
1. Find one of your files
2. Right-click the file
3. Select the Properties item on the menu (it should be at or near the
bottom)
4. In the dialog box that opens look for the "Opens with:" entry (it should
be near the top)
5. To the right of "Opens with:" there is a button "Change...", click this
button
6. Now you'll get a screen asking how you want to open the file, click the
program you want to use
7. Then click the OK button, the list closes
8. Next click the OK button

You're done. If file associations were the problem, they have just been
changed to open files with the program you want them to open in.


On Thu, Jan 23, 2020 at 5:54 PM Margaret Shearman
 wrote:

> I have been having problems with Microsoft sort of sabotaging my
> independent software and browser preferences.  Just recently I noticed that
> all my Open Office documents were converted to Microsoft Word without my
> authorization.  Is there a default word processing setting in Windows that
> allows this to happen and can I change it.  Or I also save to OneDrive
> cloudis this why my documents are changed?
> Margaret Shearman
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: microsoft office

[Alan B]

Hi Margaret,

I'm not familiar with Open Office, or other documents, being converted
without authorization to Microsoft Word format.

So I have a question. To open a document do you find then file and
double-click it with your mouse? If that's what you do and the document
opens in Word then the problem is likely something called a "file
association".

If Word has been recently installed, reinstalled, or the the repair feature
has been applied to the Microsoft Office


On Thu, Jan 23, 2020 at 5:54 PM Margaret Shearman
 wrote:

> I have been having problems with Microsoft sort of sabotaging my
> independent software and browser preferences.  Just recently I noticed that
> all my Open Office documents were converted to Microsoft Word without my
> authorization.  Is there a default word processing setting in Windows that
> allows this to happen and can I change it.  Or I also save to OneDrive
> cloudis this why my documents are changed?
> Margaret Shearman
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Calc Help

[Alan B]

I tested by modifying the formula in cell H7 in your sample spreadsheet.
The modified formula is...

=IF((ISNUMBER(G7));(G7/3);"")

The test is whether or not the value in G7 is a number, ISNUMBER(G7). Text
or a blank returns false, any number returns true. Replace the existing
formula in column H with this. The same changes should be applied in the
formula in column J.

The if test logic is reversed from your original formula. Now if the test
is true because the cell in column G contains a number then value1, Match
Series / 3, should be the result.

So IF(test; value1; value2) changes the order of your values. Instead of
IF(test;"";(G7/3)) the formula is IF(test;(G7/3);"").

On Wed, Jan 22, 2020 at 9:45 AM WA.TWORSX via AOL
 wrote:

> Hi Alan:
>
> I am trying to work my way through your suggestions. Changes to satisfy
> Design Change  Requirements #1 and #3 are not a problem.
>
> However, Required Design Change #2 is problematic for me. :-[
>
> I am not successful with IF-testing in the Match Average and Total Pins
> columns to satisfy Required Design Change #2.
>
> I have tried:
>
>  1. When I use =IF(G27>0;G27/3);"", the returned result is 0. (Not
> acceptable.)
>  2. When I use =IF(D27>0;G27/3);"", cell H27 returns a blank
> (acceptable??).
>
>
> How is a cell's content IF-tested for a number? Is IFNUMBER() needed
> here? If, yes, I will try using >0 within the parenthesis.
>
> I inserted: =INDEX($Sheet1.G6:G42,COUNTA($Sheet1.G6:G42),1) into cell
> AL7; am getting Error 508.  Please verify the punctuation used in your
> suggested formula; I am expecting to see semicolons. I have changed the
> commas to semicolons, but that produces a blank cell in AL7, which does
> not change after inputting additional scores in columns D, E, and F.   I
> am stumped. :-[
>
>
> TNX for your inputs, Alan.
>
> Regards,
>
> VinceB.
>
>
> On 1/20/2020 5:58 PM, Alan B wrote:
> > I've found a method that can work, providing the spreadsheet design is
> > modified somewhat.
> > It comes from a formula provided by RusselB in the OpenOffice forums.
> >
> > =index(range;count(range);1)
> >
> > For your sample spreadsheet this formula in cell AL7
> > =INDEX($Sheet1.G6:G42,COUNTA($Sheet1.G6:G42),1)
> > will return the Match Series value for the last value entered. When
> week#20
> > is completed the number in AL7 will update. When week#21 is completed it
> > will update again, and so on.
> >
> > REQUIRED design changes
> > 1. There must not be any merged cells that span column G. A merged cell
> in
> > the column breaks the formula. Update the =INDEX formula for column H and
> > the same is true, no merged cells.
> > 2. The formulas in the Match Average and Total Pins columns should
> change.
> > The IF test should be whether the tested cell contains a number, not
> > whether it is blank. This will prevent #value! errors being displayed in
> > those cells.
> > 3. Last, any blank rows in a column must be BELOW the currently completed
> > week number.
> >
> > To meet design change #1 the "Did not bowl" in week 6 cannot be merged
> > cells. And to meet condition #3 they cannot be empty either. As an
> > alternative you could enter DNB in each cell in the row.
> >
> > The row of merged cells that demark "half season" needs to change because
> > of #1. If the row is deleted and the season half is indicated by a heavy
> > border between week 18 and 19, that would suffice.
> >
> > This is the simplest solution I could find. More complex formulas might
> be
> > possible that would meet your goal but I'm not familiar enough with Calc
> to
> > readily conceive of them.
> >
> >
> > On Mon, Jan 20, 2020 at 1:31 PM Vince@GMAIL  wrote:
> >
> >> Hello Alan B:
> >>
> >> TNX for reading my query about Calc Help-updating Data.ods.
> >>
> >> For reasons, unknown to me, my pasted example seems to be
> >> plain/unformatted text, although I had sent it out via Mozilla
> >> Thunderbird email client using both HTML and plain text to the AOO
> >> mailing list, and appeared properly displayed in my compose window.  I
> >> realize that w/o the full formatting, it is difficult to read and
> >> understand what is displayed at your end.
> >>
> >> This Dropbox link, I think, will allow you to download the full AOO-Calc
> >> file:
> >>
> >>
> >>
> https://www.dropbox.com/scl/fi/2ibk2u5elew1y4mx9b583/Calc-Help-updating-Data.ods?dl=0=zeujgqduhbuo82jmxryylinvd
> >> .
> >>

Re: Calc Help

[Alan B]

I've found a method that can work, providing the spreadsheet design is
modified somewhat.
It comes from a formula provided by RusselB in the OpenOffice forums.

=index(range;count(range);1)

For your sample spreadsheet this formula in cell AL7
=INDEX($Sheet1.G6:G42,COUNTA($Sheet1.G6:G42),1)
will return the Match Series value for the last value entered. When week#20
is completed the number in AL7 will update. When week#21 is completed it
will update again, and so on.

REQUIRED design changes
1. There must not be any merged cells that span column G. A merged cell in
the column breaks the formula. Update the =INDEX formula for column H and
the same is true, no merged cells.
2. The formulas in the Match Average and Total Pins columns should change.
The IF test should be whether the tested cell contains a number, not
whether it is blank. This will prevent #value! errors being displayed in
those cells.
3. Last, any blank rows in a column must be BELOW the currently completed
week number.

To meet design change #1 the "Did not bowl" in week 6 cannot be merged
cells. And to meet condition #3 they cannot be empty either. As an
alternative you could enter DNB in each cell in the row.

The row of merged cells that demark "half season" needs to change because
of #1. If the row is deleted and the season half is indicated by a heavy
border between week 18 and 19, that would suffice.

This is the simplest solution I could find. More complex formulas might be
possible that would meet your goal but I'm not familiar enough with Calc to
readily conceive of them.


On Mon, Jan 20, 2020 at 1:31 PM Vince@GMAIL  wrote:

> Hello Alan B:
>
> TNX for reading my query about Calc Help-updating Data.ods.
>
> For reasons, unknown to me, my pasted example seems to be
> plain/unformatted text, although I had sent it out via Mozilla
> Thunderbird email client using both HTML and plain text to the AOO
> mailing list, and appeared properly displayed in my compose window.  I
> realize that w/o the full formatting, it is difficult to read and
> understand what is displayed at your end.
>
> This Dropbox link, I think, will allow you to download the full AOO-Calc
> file:
>
>
> https://www.dropbox.com/scl/fi/2ibk2u5elew1y4mx9b583/Calc-Help-updating-Data.ods?dl=0=zeujgqduhbuo82jmxryylinvd
> .
>
> I am trying to "harvest", via a formula or function, the resulting
> _Match Series_ (column G) data, which is data only relevant to Vince's
> game scores. Sorry, I neglected to include the _Vince's Individual
> Record_ heading over columns B:L in my original example.  The game
> scores for Vince (only) are being tracked on a weekly basis to generate
> the result that is given in column $G.
>
> At present, Cell AL7 contains the formula =G26. This value changes each
> week, as Vince's new scores are poked into columns D, E, and F each week
> (i.e., on the next week's row). So, at present, I am manually changing
> the formula within AL7 to reflect the current week's row.
>
> (The _Match Series_ data for my teammates Russ, Dave, and Bob are being
> poked manually into AL6, AL8, and AL9, weekly. )
>
> In another thread, dated 1/18/2020,  Brian Barker has offered
> suggestions using =MATCH, =OFFSET, and =INDIRECT functions.  I am not
> familiar with those functions, but will likely attempt their use when
> time permits me to learn more about them. Brian also prefers the use of
> minimal examples; therefore, I fear that I am verbose in my queries and
> comments. However, I am hopeful that my comments above have been helpful
> in clarifying my OP.
>
> Again, thanks for your interest in solving my problem.
>
> Regards,
>
> VinceB.
>
>
> On 1/19/2020 10:00 PM, Alan B wrote:
> > Hello Vince,
> >
> > I'm intrigued but not able to follow what you're trying to do. Columns D
> > through H appear to be the games bowled in any given week, rows (or
> should
> > I say weeks) 1 through 21 are the results of the games in those weeks.
> That
> > seems clear to me. But whose games, Russ, Vince, Dave, or Bob's?
> >
> > The disconnect comes with "using the results in [AL] and [AN]".
> >
> > How does a single row shown as 1 - 21 and columns [D] though [H] in your
> > example relate to multiple individuals [AL] through [AN]?
> They do not .
> > And more importantly, what are you trying to achieve? If I understood
> that
> > I might be able to offer some useful help.
> See my comments above. HTH.
> > On Sat, Jan 18, 2020 at 12:48 PM Vince@GMAIL  wrote:
> >
> >> AOO 4.1.5 on Win10 Home desktop
> >>
> >> _
> >>
> >> Note: Cells with a yellow background identify required data must be
> >> entered.  Cells with

Re: Calc Help

[Alan B]

Hello Vince,

I'm intrigued but not able to follow what you're trying to do. Columns D
through H appear to be the games bowled in any given week, rows (or should
I say weeks) 1 through 21 are the results of the games in those weeks. That
seems clear to me. But whose games, Russ, Vince, Dave, or Bob's?

The disconnect comes with "using the results in [AL] and [AN]".

How does a single row shown as 1 - 21 and columns [D] though [H] in your
example relate to multiple individuals [AL] through [AN]?

And more importantly, what are you trying to achieve? If I understood that
I might be able to offer some useful help.

On Sat, Jan 18, 2020 at 12:48 PM Vince@GMAIL  wrote:

> AOO 4.1.5 on Win10 Home desktop
>
> _
>
> Note: Cells with a yellow background identify required data must be
> entered.  Cells with a (darker) gray background identify cells which
> show calculated results.
>
> I have a Calc sheet that I enter data on a regular basis, as shown below:
>
> [D] [E] [F][G][H] < Column headings
>
> */_Today is Week #_/*   */_Today's Date Is_/*   */_Game #1_/*   */_Game #2
> _/* */_Game #3_/*   */_Match Series_/*  */_Match Average_/*
> *1* 6-Sep   152 146 187 485 161.7
> *2* 13-Sep  133 159 141 433 144.3
> *3* 20-Sep  147 155 148 450 150.0
> *4* 27-Sep  161 151 142 454 151.3
> *5* 4-Oct   130 139 116 385 128.3
> *6* 11-Oct  *Did Not Bowl. *
> *7* 18-Oct  148 187 119 454 151.3
> *8* 25-Oct  155 167 169 491 163.7
> *9* 1-Nov   140 141 157 438 146.0
> *10*8-Nov   147 135 155 437 145.7
> *11*15-Nov  139 133 155 427 142.3
> *12*22-Nov  164 162 164 490 163.3
> *13*29-Nov  120 110 155 385 128.3
> *14*6-Dec   150 136 125 411 137.0
> *15*13-Dec  170 187 132 489 163.0
> *16*20-Dec  160 168 146 474 158.0
> *17*27-Dec  160 144 150 454 151.3
> *18*3-Jan   151 141 138 430 143.3
> */_---Half Season---_/*
> *19*10-Jan  *Did Not Bowl. *
> *20*17-Jan  161 134 147 442 147.3
> *21*24-Jan
>
>
>
>
>
> I use the results generated in columns G and H in another section of the
> sheet, as shown:
>
>  [AL] [AN] < Column headings
>
> *Team #2- ACHES & PAINS v2.0
> Post Match Play*
> *Russ: *458 *Player's Average: *152.67
> *Vince: *   442 147.33
> *Dave: *555 185.00
> *Bob: * 600 200.00
>
>
> Cells AL7 and AN7 are set to = the results calculated and provided
> within cells G26 and H26, i.e., they show: 442 and 147.3.
>
> My problem is that after calculating an update result within columns G
> and H, e.g., on 24 Jan, (week # 21's data), the results based on entry
> of data in D27:F27, there will be new results in the next row, at cells
> G27 and H27. Therefore, I am forced to manually change the formulae
> within AL7 and AN7 to correctly reflect the updated results provided in
> columns AL and AN, by changing =G26 to =G27 and by changing =H26 to =H27.
>
> Is there an easier method of handling this task, through use of a
> function or a formula?
>
> I hope this is described clearly enough.  If needed, I will attempt to
> store the complete calc sheet at a Dropbox link. Let me know.
>
> Regards,
>
> VinceB.
>
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Windows 10 version 1903

[Alan B]

Hi Sandy,

I have Windows 10 v 1903 with LibreOffice. Not the same as Open Office, I
know, but both come from the same code.

LibreOffice works fine on my pc and has been on it since it was Windows 7.
I has continued to function through all upgrades... Windows 7 --> Windows
10 (whatever the earliest release was) --> all the other Windows 10
upgrades through and including Windows 10 v 1903.

I've also done some searching to see if there are issues with Open Office
on Windows 1903. It seems some people are having issues with Open Office on
Windows 1903. Whether that happens to you will only be known if you try the
upgrade.

If you try the upgrade and have problems then there are two solutions I've
seen. Upgrade to the latest version of Open Office which people report
sometimes resolves the problem. The other option is install LibreOffice
which doesn't seem to be experiencing the problem and is reported to work
without issue.

I hope this information is helpful and is enough for you to decide what you
want to try next.

I encourage you to update Windows. It is the most widely used pc operating
system in the world and because of that the most widely attacked. Not
updating it leaves it vulnerable to attacks.

On Sat, Jan 18, 2020 at 5:31 PM Sandy M  wrote:

> Good afternoon
>
> I have Apache Open Office on my Windows 10 pc. I need to update to Windows
> 10 version 1903. I have you heard anything about the update wiping the open
> office out during the update?
>
> Thank you
>
> Sandy M.
>
> Sent from my iPad
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Sharing Excel

[Alan B]

Sarah,

Another method, that would allow working on the spreadsheet without sending
a copy back and forth and back again, would be to save it online and share
it using a service like OneDrive, Google Drive, DropBox and others.

The idea is you both use the same file so if you edit at 3pm and your son
at 4pm he sees your edits and vice versa without having to check email to
see if an updated version of the file is in the inbox.

I offer this suggestion because you wrote "share a file" which I'm thinking
means you both want to work with the same file so you can see each other's
progress.

If that's not your goal then Wade's suggestion is certainly the simpler
option.

On Fri, Jan 17, 2020 at 4:28 PM Sarah Staddon 
wrote:

> Hello
> My son lives away and we are trying to share an excel spreadsheet to work
> together on a diary fitness and dieting.
> Can you please tell me how to do this?
> Many thanks
> Sarah Staddon



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: question about using OpenOffice and Micro office

[Alan B]

...oops, accidentally hit send. The complete message was meant to be...

A comment about installing OpenOffice when Microsoft Office is already
installed.

Watch carefully during the installation process. At one point a question
will be asked whether to make OpenOffice the "default" program.

If you respond Yes then double-clicking one of you document files will open
it in OpenOffice. If No is selected then double-clicking one of your
documents will continue to open in Microsoft product after OpenOffice
install completes.

In either case, the default program can be changed so double-click always
opens documents in a particular program.

And if the default is not the program you wish to use for a given document
then right-click the file, select the "open with" option and click the
program you want.

On Mon, Dec 30, 2019 at 11:43 AM SC  wrote:

>
> Hi,
>
> Is it possible to download and install OpenOffice if I already have
> Microsoft Office on my computer?
>
> I don't want to delete my Microsoft Office from my computer.
>
> If possible, I would like to install OpenOffice and try it out and see how
> I like it.
>
> My home computer has Win. 8.1.  I wish manufacturers of computers would
> not install things like Microsoft products and instead give buyers options
> of operating systems to buy and install.
>
> At work I need to buy a new computer with Win 10.  I would like to install
> OpenOffice on it.
>
> What is the latest version of OpenOffice and will it work with Win 10?
>
> Thank you for making this available without cost.  May you all have a
> great New Year!
>
> Sharon
> Richmond, VA
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: question about using OpenOffice and Micro office

[Alan B]

A comment about installing OpenOffice when Microsoft Office is already
installed.
Watch carefully during the installation process. At one point a question
will be asked whether to make

On Mon, Dec 30, 2019 at 11:43 AM SC  wrote:

>
> Hi,
>
> Is it possible to download and install OpenOffice if I already have
> Microsoft Office on my computer?
>
> I don't want to delete my Microsoft Office from my computer.
>
> If possible, I would like to install OpenOffice and try it out and see how
> I like it.
>
> My home computer has Win. 8.1.  I wish manufacturers of computers would
> not install things like Microsoft products and instead give buyers options
> of operating systems to buy and install.
>
> At work I need to buy a new computer with Win 10.  I would like to install
> OpenOffice on it.
>
> What is the latest version of OpenOffice and will it work with Win 10?
>
> Thank you for making this available without cost.  May you all have a
> great New Year!
>
> Sharon
> Richmond, VA
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Making a PDF file

[Alan B]

Karen, not sure your goal.

If you want to print the email (you start with "...turn an email into a
pdf" and then you end with "...when I try to print", so I'm guessing you
want to print the email) why not use the "print" option in your email? It
saves a bunch of steps.

If you've tried printing the email while viewing and you don't get the
print out you expect, say extra parts of the web page are printing not only
the text of the email, then you may be selecting the print menu from the
browser and not from within the email.

With an email open type Ctrl+P. If the printing dialog that opens is the
one you usually see then for sure it is the wrong print option being used.
Click "Cancel" to return to your email. Then look carefully around the
edges of the email's reading area. See if you can locate a little printer
icon, a three periods "..."  icon,  or a "more..." link. The three periods
or the more link should lead to a printer selection if there isn't a print
icon on the message border. If you find a print option, try it.

You need to use the command to print the message (which is put on the page
as part of the email program), it is not the command to print the whole
webpage (everything in the browser window).


On Fri, Nov 8, 2019 at 7:20 PM Karen Berinsky 
wrote:

>
>
> Sent from Mail for Windows 10
> Can anyone tell me how do turn an  email into a PDF file so I can print it
> out on Open Office?  If I just copy and past, it’s all over the place when
> I try to print.
>
> Thank you
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: open office software SPREADSHEETS

[Alan B]

Do you want to sort data in column A -or- sort entire rows using column A
to order the rows?

The two operations produce different results.

I posted a video on YouTube ages ago showing these operations. The
interface is changed a bit since but the ideas, select what you want to
sort, then sort, haven't changed.

If you want a look, check here... Sorting a table in a spreadsheet,
https://www.youtube.com/watch?v=RjTgDyNqqQY

If it doesn't address your issue, post back with a bit more detail.

On Thu, Oct 24, 2019 at 10:29 AM John Clipper 
wrote:

> I will gladly pay for help.
>
> nearly 2 hours spent on -
>
> 1. How to sign on to a Forum in order to ask  a question on Forum re
> spreadsheets. No success.
>
> 2. found some “answers”. without signing on. See #1
>
> 3. The question was about how to sort data in Col A
>
> 4. I have used other features with success.
>
> J.Clipper
>
> clip...@casema.nl
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Will I Lose My Files

[Alan B]

No. Updating the software does not cause loss of files you've created.

You will be able to both read and edit files created with prior versions of
the software in the new software.

On Mon, Sep 23, 2019 at 11:03 AM Frank Guasto 
wrote:

> If I update/download the new version of OpenOffice, will I lose any files
> or spreadsheets I’ve Created?
>
> Sent from my iPhone
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Windows 10 compatibility

[Alan B]

Download from the official site - https://www.openoffice.org/

Look for "I want to download Apache OpenOffice" and click on it to get to
the download links. Click on "Download the full installation".

Version 4.1.6 is Windows 10 compatible.

It will pick up your historic documents.



On Mon, Sep 2, 2019 at 5:49 AM Carolyn <21sm...@tiscali.co.uk.invalid>
wrote:

> I have been a very satisfied user of OpenOffice for many years & want to
> continue using this product.
>
> Unfortunately, this weekend my laptop died & Iv had to purchase a new
> laptop which has windows10. Iv also had to take the old laptop into PC
> World who are undertaking a Data Recovery who will then transfer the files
> to my new laptop. So as soon as I get my new laptop I need to download
> OpenOffice to access my documents.
>
> Please can you advise if the latest version of OpenOffice 4.1.6 is
> compatible with Windows 10 & any link you suggest I use to download my new
> software and will it pick up my historic documents.
>
> I Look forward to hearing from you with any help / advice you can offer,
>
> Regards
> Carolyn Murphy
>
>
>
> Sent from my iPad
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Icons

[Alan B]

Since you've installed OpenOffice the icons (either shortcuts or actual
files) don't need to be there.

The OpenOffice program shortcuts can be found in the Start menu.

On Sun, Aug 4, 2019 at 6:09 PM Randy Fornoff  wrote:

> Hello, A couple of days ago I downloaded and installed Open Office. Since
> then I have numerious icons on my desktop. Do they need to be there or can
> they be compressed until needed. Please advise. Thank nyou.
>
> Sent from Mail for
> Windows 10
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: BASE questions

[Alan B]

Hello Mike,

Don't have all your answers off the top of my head, however for an auto
incrementing id use field type Integer with Autovalue set to YES.

On Mon, Jul 29, 2019 at 4:03 AM Mike  wrote:

> I'm new to Base and discovering just how ignorant I am despite 40 years
> working in IT.  I have created a simple data base with three tables.
> When trying to create relationships and forms it's become obvious that
> some of my field definitions need to be changed.  Problem 1: how can I
> display all of the variables I used to specify each field?Problem 2:
> I created a table and made a mess of it.  How can I delete that table?
> DROP TABLE ... hasn't worked.  Problem 3:  The ID in my main table is a
> numeric sequential number.  Can I define the field so that the number is
> automatically assigned using a field type?
>
> Background:  I'm working in OpenOffice 4.1.6 on a MacBook Pro running
> MacOS 0.13.6.  My first reference is to LibreOffice 4.0 Base Handbook,
> OO helps, OpenOffice Forum, then finally Google.  I assume that
> LibreOffice BASE and OO BASE are sufficiently similar that LO
> documentation should be relevant to OO BASE.
>
> thanks,
>
> Mike Shearer
> Australia
>
>
>
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: open office questions

[Alan B]

Hi Jon,
I'm responding to offer some thoughts about your invoicing requirements. If
you've thought it through, you're all set. If not, you might want to
consider some of the following.
Will you need to track status of invoices?
 - paid / unpaid
 - partial paid and balance due
Report on invoices?
 - total invoices mailed this month
 - total of invoices paid this month
What will the volume be like?
 - a few a month or many each week?
 - how do you envision producing them? e.g. fill in spaces on a document
and print the document or fill in a form on the screen, taxes and totals
automatically calculated and then invoice printed.

OpenOffice can certainly all of it Depending on the amount of automation
you desire making it happen will be simple or require more than basic
skill. If you only need to fill out a paper invoice with no automation,
that would be a basic form in Writer. If you want automation OpenOffice can
meet the need but the system needs to be built. If you want automation and
aren't up to building it, consider an invoicing program. I searched "open
source invoice software" and got the following links which may help you
decide.
https://opensource.com/article/18/10/open-source-invoicing-tools
http://opensourcebilling.org/
https://www.bambooinvoice.net/

I hope the above is useful.



On Wed, Jul 17, 2019 at 1:04 PM jonathan smith
 wrote:

> Hi,
> I am a young artist who needs word to do invoices and general use for
> business uses, can you tell me please:
> 1. is your downloadable free software legal, because you have to buy
> Microsoft Office?
> 2. Is it simple to download as I am not technologically minded at all.
> Many thanks for your time,
> Jon



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Open Office

[Alan B]

Hello Jane,

You don't describe the steps being followed when each issue occurs so my
suggestions are guesses based on what I imagine might be happening.

1. If using the tab key to indent the lines that will not affect the
margin.The next line will start to the left of the tab. To make an indent
for a paragraph (lines indented the same so long as Enter key not pressed)
select Formal > Paragraph from the menu. Then on the "Indents & Spacing"
tab set the "Before text" space to the value you want.
2. The same indentations will not be different "here and there". Wherever
your indentations are different there will be a space or a change in font
size or a margin change associated with the spot where the indentation is
different.
3. More information needed, what is the message?
4. More information needed. What method to open (e.g. double-click mouse on
icon, select from menu, etc), does one method always work and another
always fail, what is your computer's operating system (e.g. Windows 7,
Windows 10, OS X), how much memory in your computer, what size is the hard
drive and how much space is free on the hard drive? With Windows I have
experienced programs working sometimes and other times not if the hard
drive has less than 10% free space.
5. Try selecting the text, right-clicking, then select the "Default
Formatting" menu option.

On Sun, Jul 7, 2019 at 2:21 PM Janie  wrote:

> I am a new use of Open Office and have encountered a few problems.
> 1. When setting indentations they don’t stay set.
> 2. The indentations seem to indent differently here and there.
> 3. I often get an error message when attempting to open the document.
> 4. Often times the program does not open.
> 5. When I use a BOLD lettering, such as in a Chapter title, I cannot turn
> it off afterwards when I want to go back to normal print.
> Can you offer any suggestion as to how I can solve these problems”
> Thank You,
> Jane Holmes
> janemholm...@gmail.com
>
> Sent from Mail for Windows 10
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Removing Duplicate entries?

[Alan B]

I do not know what you mean by "using a TextEdit". However I can offer the
following suggestions (all presume each mail list address is on a single
line) ...

1. sort the address list and then remove the duplicate entries by
inspecting the list
2. for a long list, import the entries to a table then run a query for
unique entries, save the query result as the new list

On Thu, Jun 20, 2019 at 5:31 PM daniel  wrote:

> Hi Friends,
>
> Is there a way to remove duplicates from a mail list using a TextEdit with
> OpenOffice on a Mac Computer?
>
> Thank you for your time!
>
> daniel
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: How to Convert Open Office to PDF File?

[Alan B]

>From the File menu, select "Export As" then "Export Directly as PDF". Or,
if you need to tweak the PDF settings instead of Export Directly, select
"Export as PDF..."

On Mon, Jun 3, 2019 at 3:36 PM Freddie Campbell
 wrote:

> Dear Sirs,Am having difficulty in uploading Open Office
> Docs to Facebook-Without the viewer having to "Download" the File to view
> it. Is PDF an option,and how can I convert the File to PDF?
> Freddie Campbell



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Unable to Size the written Page

[Alan B]

Hello,
Seems one of two possibilities to me.
1) The zoom level of the document has changed. This makes things look
larger on screen but has no effect on the print format. Even something that
looks huge on screen, if formatted for A4 would still print correctly on
A4. To adjust zoom level...
Select View > Zoom... from the menu. Pick the Zoom Factor to use, maybe
"Fit width". Then click the "OK" button.

2) The document format has been changed. e.g. from A4 to A6. In this case
change the document format as follows...
Select Format > Page... from the menu. Pick the 2nd tab at the top of the
dialog box, Page. Open the "Format" list and select the appropriate
document size. Click the OK button.

On Tue, Apr 30, 2019 at 3:29 PM mj.mcgrath
 wrote:

>
>
> Dear Sir/MadamI would be grateful if you could help me on how to resize
> the page as it has multiplied in size.My email address:
> MJ.McGrath@Virginmedia.comTel Number: 07982 616096
> I look for ward to hearing from you at some time soon.
> Warmest regardsMichael J McGrath
>
>
> Sent from my Samsung device



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Help with installation

[Alan B]

Kurt,

I have read, but not experienced, that some antivirus products affect
installation or launch of OpenOffice.

Your experience, install seems successful but programs won't launch, sounds
very much like the problem described with Windows 10 and Windows Defender
Antivirus.

To test this, turn off Windows Defender and then try and launch an
OpenOffice program. If it launches successfully then find the file
"soffice.bin" on your hard drive. Once found, modify Windows Defender
Antivirus settings to add the folder it is in to "Controlled Folder Access"
in Windows Defender Security Center.

My reference for this suggestion is here:
https://www.tenforums.com/tutorials/87858-add-protected-folders-controlled-folder-access-windows-10-a.html

For the latest version of OpenOffice the soffice.bin file should be found
here...
C:\Program Files\OpenOffice 4\program\soffice.bin

On Sun, Apr 21, 2019 at 10:43 AM kurt Potter  wrote:

> Hi:
>
> I recently bought an Asus computer and am trying to install open office.
> It appears that I have installed everything as the icons for writer , calc,
> etc are showing but I cannot open then. Do you know what the problem might
> be?
>
> Kurt
>
> Sent from Mail for
> Windows 10
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: how to flip a picture??

[Alan B]

In Draw, a picture can be turned right side up by:
- right-click the picture
- select "Position and Size..." from the menu
- select "Rotation" tab
- specify "Angle" to rotate

In the case of flipping it right side up it needs to be rotated 180
degrees. So specify 180 degrees and click "OK"

To do same with mouse
- click the picture twice (NOT double-click)
  - first click picture gets square green selection handles
  - once selection handles appear click again, picture gets round red
handles
- point at any corner handle, mouse pointer changes to circular arrow,
click and drag with circular arrow to rotate picture
NOTE: the handles along the sides and top, the mouse changes to parallel
lines those will shear the picture. don't click or drag them to rotate.

On Sat, Apr 20, 2019 at 11:08 AM M Aldrich  wrote:

> i can’t figure out how to turn a picture right side up. flipping
> horizontally and vertically doesn’t work. thanks.
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Spreadsheets

[Alan B]

Not certain I'm understanding your question so I will answer similar
question and hope it is what you mean.

I use OpenOffice Calc and save my spreadsheets. The saved files appear to
be Excel files. I don't have Excel. Why are the files for a program I do
not have?

If the above describes your issue then the "problem" is the files are saved
in Excel format instead of Calc format. This setting can be changed each
time a file is saved and can be set to default to save as Excel in Tools >
Options > Load Save.

If this is not the problem then I do not understand your question. I have
created files in Calc for use in Excel many times. And I have created files
in Calc for use in Calc but saved them in Excel format. Also, many times.

As far as I am aware the file that is created is not licensed, it is the
program (Excel, Calc, etc.) that is licensed.

On Wed, Apr 17, 2019 at 12:46 PM Mavjon 
wrote:

>
> When I backup my spreadsheets they get noted as unlicensed Excel files.
> As a consequence I cannot open these files for restoration. I do not have
> Microsoft Office installed on my computer.
> Why cannot the files be shown as OpenOffice?
> Thanks for any help you can give.
>
>
>
> Sent from Mail for Windows 10
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Lost work

[Alan B]

Michael,

"...file does not exist..." can happen when a file's location changes (so
the file still exists) but the "recent files" entry in the menu is pointing
to the last place the file was. So, the exact file name, including the
path, referred to in the menu doesn't exist any more.

The message can also happen if the file's name is changed but the file is
still in the same place. Again, from the point of view of the "recent
files" entry, that exact file name doesn't exist.

Did you change the name of the file?

Did you change the location of the file?

If you did either of the above then you must use the File > Open command
from the menu and pick out the renamed or relocated file.

If you didn't do either then my final suggestion would be to search the
hard drive of your pc for the file. Presuming you're using Windows 7 or
later do the following:

Open powershell and enter the following commands...
cd \
get-childitem -filter "yourfilename" -force -recurse -erroraction
silentlycontinue | select-object FullName

When the command completes there will either be an empty line (file was not
found) or the path and name of the file, e.g.
c:\users\me\documents\temp\somewhere\myfile.odt

On Mon, Apr 15, 2019 at 11:18 AM Michael Pettit
 wrote:

> I have been writing  a book on OpenOffice for several weeks and saving all
> work as I went.  Yesterday I attempted to resume work and taskbar icon was
> gone.  I reopened it and attempted to open recent work.  I got a message
> saying file does not exist.  Multiple attempts to find "mybook" were
> unsuccessful.  Any way I can recover this?  Thanks.
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: ? can any outside computer enter my OpenOffice document ? Thanks !

[Alan B]

Is see two questions here...

1) Can an outside computer connect to the desktop on your computer?

"Out of the box" no. Computers are not usually set up to enable remote
connections when first set up. However there are many things that can be
done to enable remote connections on purpose or can happen to enable remote
connection by compromise.

2) ...enter my OpenOffice document...?

Compatible software can open the document unless it is password protected.
Then, the password is required.


On Fri, Apr 12, 2019 at 2:21 AM Irish Man  wrote:

> ? can an outside computer enter my OpenOffice document on my desktop ?
> Thanks !
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: How get the latest up-date

[Alan B]

1) To get latest version...
Go here: https://www.openoffice.org/download/
click the words "Download full installation"

2) Shortcut disappeared.
You don't say which shortcut(s), on Desktop, in menu, on Taskbar? No
matter, install per #1 above and shortcuts will be created again.

On Mon, Apr 1, 2019 at 7:02 PM arnoldand ilace  wrote:

> Dear Forum;
>
> 1] Having used Open Office with great appreciation, how do I get the
> latest version?
> 2] In the latest update from Windows, my short cut to Open Office
> disappeared.  How do I get it back on my desk top?
>
> Thanks;  Arnold
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: OpenProj

[Alan B]

Hello Lee,

To access all program features you may want to check ProjectLibre,
https://www.projectlibre.com/. ProjectLibre is an open source "fork" of
OpenProj, written by the original authors of OpenProj.

Download the "Community Edition" of ProjectLibre to install and run on a pc
and have access to features in ProjectLibre that are not available in the
free version of OpenProj.


On Tue, Jan 22, 2019 at 1:42 PM Lee Garrett 
wrote:

> Hello,
>
> I used OpenProj.  When I go to print and want to change some settings, I
> can't select certain options.  How can I get full use of the applications?
>
> --
> Lee Garrett
> 404.388.0164
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Need to print ONLY selected pages

[Alan B]

After selecting File > Print from the menu look for the "Range and copies"
section of the print dialog. In there is a Pages radio button. Select
"Pages" then enter the desired range or ranges of pages in the box.

For example enter "1-3;7;11-12;19" without the quotes to print pages 1
through 3, and 7, and 11 through 12, and 19.

On Sat, Jan 19, 2019 at 5:31 PM Edward Eckhard 
wrote:

> Help! Need some advise.
>
> I often print out narrative files I create and have no trouble.
> However, I have a twenty-one page document, but only want to print
> selected pages.
>
> Can't get to work! For example, I only want to print pages one and two,
> but later will
> want to print pages three thru five, later pages six thru 8, etc.
>
> How can I print selected pages? I know I can do it, but I'm doing
> something wrong.
>
> Edward
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Alphabetic Listing

[Alan B]

You don't say how the hymns are arranged and segregated from one another.

"With a few keystrokes" is unlikely unless the arrangement supports it.

How are they stored?
- one per file
- one file for all
- something else?

And how are they arranged?
- Write
 one per page
 one per paragraph
 something else?
- Calc
 one per cell
 one per sheet
 something else?
- another program?


On Thu, Jan 17, 2019 at 9:09 PM Patrick Hunt  wrote:

> To Whom -
> I have been using O.O. 4.1.5 Text for a few years on a Windows 10
> Microsoft desktop computer.  I have some 100 Church hymns there, printed in
> no particular order.  Is there a way, with a few key strokes, to alpha list
> them so I can print out such an alternate listing on my Brother laser
> printer?
> Thanks -
> P. Hunt
>
> Sent from my iPad
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: OPen office

[Alan B]

Hello Lois,

There is no equivalent to Publisher in Open Office. Depending on your
needs, Draw may suffice. The Open Office programs are a complete suite and
separate components can't be individually downloaded or installed.

The most common recommendation I've seen for a Publisher like program is
Scribus. Available at this link, https://www.scribus.net/. It is open
source like Open Office.

On Thu, Oct 18, 2018 at 6:00 PM Lois and Jerry Harrington <
loisandjer...@hotmail.com> wrote:

> Can a person download only what you would have to be the same as
> “microsoft publisher? If so is there a point where one can choose what not
> to download ?
> Thank you. Lois Harrington



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011