Re: Downloaded - Confused...

[Johnny Rosenberg]

If you downloaded the Windows version, I think there is only supposed to be
one file (exe). Install exactly like you install everything else.
If you got a lot of files, it seems like you downloaded a Linux version,
which you only should do if you are using Linux, of course.
You don't need an account.
>From where did you download Apache OpenOffice? You should download it from
http://www.openoffice.org/download only.

I haven't used Apache OpenOffice for a very long time, but I guess someone
will correct me if I'm wrong.


Kind regards

Johnny Rosenberg

Den mån 29 maj 2023 kl 19:52 skrev Mike Christensen :

> Downloaded the app and see all these files…many files.
> Is there an EASY “how to” to use or access a spreadsheet.
> …establishing an account…? Creating an account/logon…?
> Excuse my ignorance, I guess I need the clueless version.
> I just want to create a spreadsheet…that’s it.
> Thanks
>
> Sent from Mail for Windows
>
>

Re: ACTING UP

[Johnny Rosenberg]

Den ons 15 feb. 2023 kl 05:07 skrev Dave Fisher :

> We are all volunteers here.
>
> Please do us all a favor and turn off the all caps.
>
> Tell us your Apache OpenOffice and Windows versions and exactly what is
> going wrong for you. What changed for you and when?
>

I just love how you just assume he uses Windows just because he has a
problem of some kind… 


Kind regards

Johnny Rosenberg



> Best,
> Dave
>
> Sent from my iPhone
>
> > On Feb 14, 2023, at 7:56 PM, Richard Kennington 
> wrote:
> >
> > I HAVE OPEN OFFICE IT IS NOT WORKING RIGHT I HAVE IT ON MY TASKBAR WHEN
> I
> > CLOSE IT & REOPEN IT SOME TIME THE THERE ARE NOT THERE & WILL NOT BE
> THERE
> > I WOULD LIKE SOMEONE TO CHECK THE PROGRAM OUT.
> > RICHARD KENNINGTON
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: excel

[Johnny Rosenberg]

Den tis 14 feb. 2023 kl 07:04 skrev Richard Rik
:

> Do you offer a free excel with apache?


No, I don't. Neither does Apache.
So what do Apache offer?
Free spreadsheet app – yes (called ”Calc”).
Free Excel – no, only Microsoft can offer such a thing since it's their
product, so ask them. They will most likely say no, but who knows?

>
>   If so have a question or two.
>

So no questions then, I guess.

> thank you



Kind regards

Johnny Rosenberg

Re: After all these years ... still buggy implementations ... do users still tolerate it?

[Johnny Rosenberg]

Den lör 24 okt. 2020 kl 12:29 skrev Olle Olsson :

>  I find it amazing that after so many years, and so much effort spent on
> implementations, the oo tools are still in what I would call "pre-release
> testing stage".
>

I don't know, I didn't use Apache OpenOffice for a while, since it crashed
at startup, and I didn't have the energy to send a bug report at the time,
so I just continued using LibreOffice instead.


> The main concern I have is that images cannot be handled reliably in oo
> Writer.
>

Ah, that old problem that I had in Word many years ago, which made me
switch to OpenOffice.org in the first place! I still use Word at work and I
still have big issues with images. I change something and suddenly all the
pictures are all over the place. I'm sure I'm doing something wrong, so I
guess that Word is just not for me.

Modern documents are image heavy.


Mine aren't, but I guess you're right.


> Rarely we see text-only documents.


I have a lot of them, but I'm really more a spreadsheet kind of guy, so I
rarely write text documents at all.


> And
> often images are photographic. And sometimes many of them. Do take a look
> at the main information dissemination medium of our time: the web. The web
> has become a "multi media" medium, where it is so easy to create
> image-heavy web objects (and where the behavior actually is predictable!)
>

So what do you need Writer for?

>
> So what happens if you create an image-heavy oo Writer  document? Well, the
> images you painstakingly inserted , have later disappeared from your
> document.!

 From your document maybe, not from mine. I actually searched for odt files
a minute ago and I found one that I made in 2007, 29 pages with a lot of
images in it (which, as I said, is very rare for me, but rare doesn't mean
it never happens). As far as I can see, all images are still there and they
are still aligned exactly as I remember them.

Not saying that I don't believe you, but maybe you just have a workflow
better suitable for whatever you prefer to use instead of Apache OpenOffice
Writer?


> What is left there in the document, in front of your eyes, is a
> placeholder that signals something like "read error" of "graphic cannot be
> displayed".
>

Maybe you inserted your images as links rather than images?


>
> And there is no way to get information from the document about what that
> inserted graphical object was, or where it came from.
>

As I said, I don't have Apache OpenOffice anymore, but I tested this now in
LibreOffice. I inserted an image, then changed its link to something
non-existant, and now, in the place holder, the whole path can be seen. Is
this not true for Apache OpenOffice?


>
> So in many respects, you have to create your document again, populating it
> with the illustrations you want it to contain. And a day later, again
> insert images ... ad nauseam.
>

Well, when I finish a document, at least if it's important, I always export
it to PDF. Especially if I'm going to send it to people. That takes care of
many problems, such as the receiver doesn't use the same software etc.
Sometimes I get Word documents in my email (at work), and that annoys me a
lot. If I'm not supposed to make changes in the document, send it as PDF,
that's my opinion about that… 


>
> When this is the case, it is astonishing that people want to use oo Writer
> for mission-critical tasks.
>

And to me it's astonishing that people want to use Word, and that's for
approximately the same reasons. So you had problems with Writer, I had
problems with Word. We are different people with different workflows, so
maybe it's not that astonishing after all.

Re: unable to get to my file

[Johnny Rosenberg]

Den tis 20 okt. 2020 kl 18:15 skrev Gérald Drolet :

> Hello,
>
> I have a mac Catalina version 10.15.7
>
> I am unable to get to my files,
>
> I contacted Apple, they are tilling me that I should contact You,
>

Sounds like Apple to me… 

”We” are just users like you who try to help each other out, so Apple could
just as well have asked you to contact your friends or family or something.
Anyway, now you wrote here, so let's see if someone can help you. Given the
information you brought here so far, I strongly doubt it.
So what exactly do you mean by ”get to my files”? Can you not find them?
Can you find them but not open them? Does the wrong application try to open
them? What exactly is your problem? What kind of files are you talking
about? Can you explain exactly what you are doing, step by step, what
happens when you try to do so and then what you expected to happen?



Kind regards

Johnny Rosenberg


> Please help me,
>
> Gerald Drolet
> droletger...@gmail.com
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: How to do it???

[Johnny Rosenberg]

Den tis 20 okt. 2020 kl 18:15 skrev Larry Tanzer :

> Good Morning,
> I recently installed your Open Office 4.1.7   So far, it has worked well.
> Today, I ran into a snag.  I received an e-mail with a word document
> attached.  When I click on the attachment, it opens up, but a moment later
> another screen opens up on top of it, asking me to subscribe to Office
> 365.  If I close that screen, it also closes the attachment.
> How do I get to open the attachment in Open Office?  I probably have the
> same issue if the attachment is an excel spreadsheet.  I am using Windows
> 10.
>

You clicked on the attachment in what? Your web browser (which one?), your
email client (which one?) or what?

have you tried to just save the attachment and then open it from where you
saved it?


Kind regards

Johnny Rosenberg


> Thank you,
> Larry Tanzer

Re: Lost work

[Johnny Rosenberg]

Den sön 16 aug. 2020 kl 23:29 skrev Bec Koshak :

> Your update this morning corrupted 25 pages of my next novel and it now is
> all useless hashtags. Thanks s=
> o very much.
>

Just restore it from your daily incremental backups, and you'll only need
to redo the work you did since then, hopefully not all 25 pages.


Kind regards

Johnny Rosenberg

Re: crash

[Johnny Rosenberg]

Den sön 16 aug. 2020 kl 10:42 skrev dm darwin :

> Hello to whom it may concern,
> Have used you open office for a while, regrettable in the last 8 month
>

It's not our product. We are just users, like you. We help each other out
the best we can. Some times I ask a question, sometimes I reply to someone
else's question.
Maybe a few developers read this list too, I don't know, but if you really
want someone to dig into your problem it's probably better to file a bug
report, if you are sure that you ran into a bug. Doing so you will need to
provide much more information than you did here, though. Everything you can
think of. What did you do when it crashed? What crashed (writer, calc
etc.)? What version do you use? What is your operating system?  What
version of your operating system? What hat did you wear when Apache
OpenOffice crashed? Anything you can think of. Too much information is
better than too little. Ok, maybe you shouldn't mention your hat, but you
know what I mean.


> your program crashes constantly, needless to say all written information
> is gone and cant be restored .

What happens when you try to restore it? And how do you do that?

Please is this now a permanent feature?
>
Yes, it's permanent. Some developer thought it was a good idea to let the
application crash now and then, so he built in the randomCrash() method,
which seems to work very well.

No, just kidding. If your application crashes often, then something is
obviously wrong. Either your system itself, the application or some setting
somewhere.

One thing to try is to reset your Apache OpenOffice user profile. Just give
the folder a different name and restart Apache OpenOffice, and it will
create a new, fresh one for you. If that works, that is if Apache
OpenOffice no longer crashes, then you know that something in your old user
profile caused the crashes. If crashes still occur, something else is
wrong, and you could probably start using your old profile again, if it
contains something useful for you.

Since you didn't mention your operating system, I can't tell you where your
profile folder is, but on my system it's at ~/.openoffice/4/ and it's
called ”user”. Just rename it to something else, like user_old, restart
Apache OpenOffice and now you have both user and user_old but only user is
used.

In your user_old you'll find things like your global macros,
configurations, templates, extensions and more. If there is something that
you really need, just copy it over to the new user profile.

As I have lost again today 2.5 hours work I'm not a very happy person
> please if you reply no political correctness just the simple facts.
>

Then I'll suggest that you turn your automatic save on, Set it to a few
minutes or so. Another option is of course to manually save every time you
added something worth saving. That's very easy: Just press Ctrl+s. No need
to even move your hand from the keyboard to the mouse to do such a basic
thing.


Kind regards

Johnny Rosenberg

Thanks
> D Magdalene
>

Re: tired of the crashes

[Johnny Rosenberg]

By the way, did you try to reset your profile? That should probably be my
first suggestion…

https://forum.openoffice.org/en/forum/viewtopic.php?f=74=12426#p58403


Kind regards

Johnny Rosenberg


Den sön 9 aug. 2020 kl 01:17 skrev Johnny Rosenberg :

> Den lör 8 aug. 2020 kl 23:12 skrev David Carroll <3...@epbfi.com>:
>
>> Every week I have to write a radio show.  Every week, Open Office
>> crashes, and I have to rewrite.  I have tried finding a way to back up my
>> text, but nothing works.
>>
>> Is there a cure for this?
>>
>
> Probably only the usual cure: File a bug report and include as much
> information as possible and then wait for a fix.
> Other fixes are maybe not Apache OpenOffice-related in the same way, such
> as switching to another operating system to see if that helps. Or, if
> nothing works, try another office suite, such as LibreOffice or any of the
> others (at least until the issue in Apache OpenOffice is fixed). I guess
> I'm not supposed to suggest that, but if nothing helps and you need to
> work, what can you do? The job has to be done, right?
>
>
> Kind regards
>
> Johnny Rosenberg
>
>>
>> David Carroll
>>
>> 3...@epbfi.com
>>
>>
>>
>>

Re: tired of the crashes

[Johnny Rosenberg]

Den lör 8 aug. 2020 kl 23:12 skrev David Carroll <3...@epbfi.com>:

> Every week I have to write a radio show.  Every week, Open Office crashes,
> and I have to rewrite.  I have tried finding a way to back up my text, but
> nothing works.
>
> Is there a cure for this?
>

Probably only the usual cure: File a bug report and include as much
information as possible and then wait for a fix.
Other fixes are maybe not Apache OpenOffice-related in the same way, such
as switching to another operating system to see if that helps. Or, if
nothing works, try another office suite, such as LibreOffice or any of the
others (at least until the issue in Apache OpenOffice is fixed). I guess
I'm not supposed to suggest that, but if nothing helps and you need to
work, what can you do? The job has to be done, right?


Kind regards

Johnny Rosenberg

>
> David Carroll
>
> 3...@epbfi.com
>
>
>
>

Re: Functionality

[Johnny Rosenberg]

Den sön 17 maj 2020 kl 20:14 skrev Tammy Hodges :

> Hi, thanks for the free open source product. For most things, it works
> pretty well. One suggestion, a lot of people need to insert basic shapes
> like circles and rectangles in their documents. The word processor does a
> poor job of handling this. I have to open the draw to create a simple
> gradient in a rectangle and then I can't use it in the text document
> because I have to keep adjusting it. It's a massive waste of time. Try
> adding that basic functionality to the word processor.
>

You are writing to a list of other users, of which most of us are unable to
do anything like that. I'll suggest you to file an enhancement request or a
bug report at their bug reporting site.
have a look here:
https://wiki.openoffice.org/wiki/Documentation/FAQ/ProjectLevel/BugzillaQuestions/How_do_I_report_a_bug%3F

I couldn't test your problem myself, since Apache OpenOffice refused to
open at all (SIGABRT), so I just uninstalled it and that problem
disappeared… I'm not sure what happened, because I think it worked a while
ago. Never mind.
Anyway, I'm not sure exactly what you are trying to do, but just for fun I
experimented a bit with a rectangle in LibreOffice Writer, and I couldn't
fins any problems with it. Creating a gradient was easy and I could move it
around with expected results and, depending on the anchor setting, it
stayed where it was supposed to stay. I'm not sure I'm testing the right
things here, or exactly what went wrong for you, but at least the word
processor of LibreOffice seems to work as expected. Unfortunately I
couldn't test the same thing with Apache OpenOffice Writer, for the reasons
I mentioned above. Maybe Apache OpenOffice Writer just isn't the best tool
for what you do.

Anyway, as mentioned above, if it doesn't work properly in Apache
OpenOffice Writer, filing a bug report should be the next step. I didn't
use Apache OpenOffice regularly for a long time, but historically I have
had good experience filing Apache OpenOffice bug reports. I think most of
them actually got fixed, some of them rather quickly. I don't know if this
is true today, but maybe it's worth a try?


Kind regards

Johnny Rosenberg


> Thanks
>

Re: Time Sheet

[Johnny Rosenberg]

Den fre 27 mars 2020 kl 00:00 skrev Jan Macdonald :

> Hello OpenOffice,
>
> Wow ~ this is one complicated program.  During my career I used Excel,
> what a breeze. Then for a fun part-time job post-retirement I was directed
> to use OpenOffice.  It’s a challenge!
>
> I have a time sheet that is showing the $ sign in the hour column. So for
> example if I worked five hours it displays $5.00. How can I remove the
> dollar sign and still have the format add my hours?
>

You do it exactly the same way as you do it in Excel, so this should be a
breeze too.



Kind regards

Johnny Rosenberg


>
> Thank you!
>
> Jan MacDonald
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Showing number as binary

[Johnny Rosenberg]

Den ons 19 feb. 2020 kl 22:18 skrev Brian Barker
:

> At 21:08 19/02/2020 +0100, Johnny Rosenberg wrote:
> >Here's one way. I don't have Apache OpenOffice so I can't test it,
> >but I tested it with LibreOffice and I think it would work in Apache
> >OpenOffice too:
> >=VALUE(BASE(42;2))
> >Now format the cell like the following:
> >[...]
> >" "
> >
> >Note that if omitting the quotes, typing   in that field
> >will fail, (the cell will display 00 101 010). I'm not sure why
> >though. As I said, I tested this in LibreOffice, hopefully it will
> >work in Apache OpenOffice too.
>
> For what it's worth, the version without quotes works too in my OpenOffice.
>
> At 21:16 19/02/2020 +0100, Johnny Rosenberg wrote:
> >After some more experimenting I found this way, ...
> >And the cell formula looks like this:
> >=TEXT(VALUE(BASE(42;2));""" """)
>
> Again,
> =TEXT(VALUE(BASE(42;2));" ")
> works in my OpenOffice.
>
>
Ok, seems to be a bug (or feature…) in LibreOffice then.

I just saw that Apache OpenOffice is available in AUR (Arch User
Repository), so I'm installing it right now, so I don't have to guess in
the future… 


Kind regards

Johnny Rosenberg


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

Re: Showing number as binary

[Johnny Rosenberg]

Den ons 19 feb. 2020 kl 21:08 skrev Johnny Rosenberg :

> Den ons 19 feb. 2020 kl 10:09 skrev Andrea Vt :
>
>> Hi all :-)
>>
>> Is there a way to show a number as binary with a separation?
>>
> Yes, there seems to be.
>
>>
>> E.g. 42 as 0010 1010. (BASE(42;2;8) -> 00101010)
>>
>> Thanks and have a nice day
>>
> Have a nice day you too.
>
>
> And maybe I should answer the question I think you meant to ask too: ”How?”
>
> Here's one way. I don't have Apache OpenOffice so I can't test it, but I
> tested it with LibreOffice and I think it would work in Apache OpenOffice
> too:
> =VALUE(BASE(42;2))
> Now format the cell like the following:
> Right click the cell → click Format cells…
> Select the Number tab.
> In the field ”Format description”, enter the following:
> " "
> Hit OK.
>
> Note that if omitting the quotes, typing   in that field will
> fail, (the cell will display 00 101 010). I'm not sure why though.
> As I said, I tested this in LibreOffice, hopefully it will work in Apache
> OpenOffice too.
>
>
> Kind regards
>
> Johnny Rosenberg
>

After some more experimenting I found this way, that differs from the other
method in the following ways:

   - No need for using cell formatting
   - The cell content is a string rather than a number

And the cell formula looks like this:
=TEXT(VALUE(BASE(42;2));""" """)

Of course you should replace ”42” with a cell reference or a formula in
most cases, like this:
=TEXT(VALUE(BASE(A1;2));""" """)

Sorry for stating the obvious… 


Kind regards

Johnny Rosenberg

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

Re: Showing number as binary

[Johnny Rosenberg]

Den ons 19 feb. 2020 kl 10:09 skrev Andrea Vt :

> Hi all :-)
>
> Is there a way to show a number as binary with a separation?
>
Yes, there seems to be.

>
> E.g. 42 as 0010 1010. (BASE(42;2;8) -> 00101010)
>
> Thanks and have a nice day
>
Have a nice day you too.


And maybe I should answer the question I think you meant to ask too: ”How?”

Here's one way. I don't have Apache OpenOffice so I can't test it, but I
tested it with LibreOffice and I think it would work in Apache OpenOffice
too:
=VALUE(BASE(42;2))
Now format the cell like the following:
Right click the cell → click Format cells…
Select the Number tab.
In the field ”Format description”, enter the following:
" "
Hit OK.

Note that if omitting the quotes, typing   in that field will fail,
(the cell will display 00 101 010). I'm not sure why though.
As I said, I tested this in LibreOffice, hopefully it will work in Apache
OpenOffice too.


Kind regards

Johnny Rosenberg




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

Re: Spreadsheet

[Johnny Rosenberg]

Den ons 30 okt. 2019 kl 23:29 skrev Stag Mist :

> Dear OpenOffice Team,
>
> I'm using OpenOffice on a Mac. My problem is that when I open the app it
> automatically opens a Text Document. Is there any option to change it from
> opening a Text Document to a opening Spreadsheet? How can I set this?
>

I don't have a Mac and it was a long time since I had Apache OpenOffice,
but do n't you have icons somewhere for each and every one of the different
parts of Open Office?
if not, maybe you can change the line that starts the application? On my
system, Manjaro with LibreOffice, the line for launching LibreOffice Calc
looks like this:
libreoffice --calc %U
I' don't remember what command starts Apache OpenOffice, maybe it's still
”soffice”? In that case, did you try ”soffice --calc %U”?
Maybe opening a terminal and enter something like ”man soffice” will give
you a hint or two?


Kind regards

Johnny Rosenberg



>
> Thanks in advance,
> SM
>

Re: Linux Mint install (DEB)

[Johnny Rosenberg]

Den sön 20 okt. 2019 kl 10:46 skrev Maurice Howe :

> What?  I'm just another user, but...
> Nothing in your cryptic msg made sense.
>

Then you're probably a Windows user… :P


Kind regards

Johnny Rosenberg


>
> On Sun, Oct 20, 2019 at 1:59 AM Ryan Johnson 
> wrote:
>
> > Error: Dependency is not satisfiable: openoffice-ure (4.1.7)
> >
> > The deb installer for ure 4.1.7 file is in the same folder as the deb for
> > all of OO.
> >
> > --
> > Ryan Johnson
> > Free Software Foundation
> > <https://www.fsf.org/>
> > Electronic Frontier Foundation <https://www.eff.org/>
> >
>

Re: Unable to download Open Offive

[Johnny Rosenberg]

Den lör 26 okt. 2019 kl 09:45 skrev Tereza :

> Hi
>
> I am getting the following message, when I tried to download it. Can you
> please assist
>
>  Cannot securely connect to this page
> This might be because the site uses outdated or unsafe TLS security
> settings. If this keeps happening, try contacting the website’s owner.
> Try this:
> • Go back to the last page
>
>
You forgot to give us the most important information: The exact web address
that you tried to download from. Apache OpenOffice is downloadable from a
lot of different places. Some are good and some are bad. You should only
download from http://www.openoffice.org/download. Is that what you did?


Kind regards

Johnny Rosenberg

Re: Spreadsheet

[Johnny Rosenberg]

Den tis 15 okt. 2019 kl 18:19 skrev David Walters
:

> Hi,
>
> Can you send me the link for the Apache Open Office spreadsheet extension.
> I don’t seem to be able to locate it on your website.
>

Do you mean this?
https://extensions.openoffice.org/en/search?f%5B0%5D=field_project_application%3A4

These are extensions for Apache OpenOffice Calc, I think.


Kind regards

Johnny Rosenberg


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

Re: !

[Johnny Rosenberg]

Den sön 13 okt. 2019 kl 13:49 skrev W. Robert J. Funnell, Prof. <
robert.funn...@mcgill.ca>:

> Are you aware that the people responding to these messages about free
> software are all volunteers? It is rather inappropriate to tell them
> what they 'must' do.
>

I agree. Many users seems to think this a like a paid support (but free).
I'm not sure why, because when you subscribe to this list all information
is there right in front of you. Doesn't people read before they hit
Subscribe?


> Subject lines on e-mail messages make it much easier to manage the
> large numbers of messages on the list.
>
> It's easy to turn off the capitalization that you don't like. It's
> also easy to find the answer yourself by doing a simple Web search.
>
> Maybe someone less offended than I by the wording of your message will
> give you the answer directly.
>

After reading below, not so much.
But he's maybe right in one thing:
”It is not your bussiness, if a letter has a subject or not.”
Maybe not, but I won't open the message.
I rarely read messages at all, but if I see a subject that feels
interesting and I think I can help (if it's not interesting I can probably
not help anyway), I'll at least read it. If it's full of insults, I'll just
hope that I can resist the temptation to write back (which some times fail)
or I'll just close the message and go on with my life.

Kind regards

Johnny Rosenberg

>
> - Robert
>
> On Sun, 13 Oct 2019, auto_sto...@ngs.ru.INVALID wrote:
>
> > What a bullshit you have done with OpenOffice. I think
> > that it is not your busines what and how I am writing. I
> > want to the first letter in a cell not to be capitalized
> > but your idiotic system things that it is smarter than my
> > and "correcting" it every time.
> >
> > And one more thing, it is not your bussiness, if a letter has a subject
> or
> > not. You must read all messages
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: please help

[Johnny Rosenberg]

Just want to apologise for not being able to resist making fun of some
parts of the OP's post. I'm sorry, it was very unnecessary.


Kind regards

Johnny Rosenberg


Den tors 10 okt. 2019 kl 19:10 skrev Johnny Rosenberg <
gurus.knu...@gmail.com>:

> Den tors 10 okt. 2019 kl 14:47 skrev Dave Bito'o'wu Pratt <
> nostradumbas...@gmail.com>:
>
>> This will be the fourth try at attempting to contact you. You don't make
>> it
>> easy. The following is my original message.
>>
>
> What was the other three attempts? Writing to this list or what?
> And who are you referring to when you say ”you”? There is no Apache
> OpenOffice support. This list is just users helping other users. I'm one of
> those users (I'm actually an ex user, but that's hopefully not very
> important) and some times I ask questions and some times I answer
> questions, just like most people on the list.
>
>
>> I used to use Word up until about 10 years ago when somebody suggested
>> Open
>> Office to me. I much prefer this to Word.
>
>
> I prefer a hex editor over Word…
>
>
>> I do have one issue though. I
>> used Excel a lot. They had a function where I could add certain lines to a
>> total. On your .ods file, I can find that function.
>
>
> You can? That's great. Doesn't the mean that the problem is solved? I just
> wonder how you could find it in the ods file. Shouldn't you rather look in
> the Apache OpenOffice Calc application?
>
>
>> I don't have Word or
>> Excel on my PC now.
>
>
> Lucky guy. I have both on my job computer and I hate both.
>
> I miss that function.
>
>
> You said you could find it (in your ods file), or did you mean something
> else? Like what?
>
>
>> I have Open Office version 4.1.6.
>> Does that have the function I want? I've checked all the options at the
>> top
>> and can't find that function. Am I just missing seeing it? Please help
>> because I miss that function. Thank you.
>>
>
> Okay, jokes aside, can you please better describe what that ”function”
> actually did? I don't really understand what ”add certain lines to a total”
> means. Certain lines? To a total? How? Can you give a simple example? What
> is the function called in Excel?
>
> I'm sure that if the function doesn't exist in Calc, it's possible to make
> one with a macro, but I can't tell how complicated that would be unless I
> have more information.
>
>
> Kind regards
>
> Johnny Rosenberg
>

Re: please help

[Johnny Rosenberg]

Den tors 10 okt. 2019 kl 14:47 skrev Dave Bito'o'wu Pratt <
nostradumbas...@gmail.com>:

> This will be the fourth try at attempting to contact you. You don't make it
> easy. The following is my original message.
>

What was the other three attempts? Writing to this list or what?
And who are you referring to when you say ”you”? There is no Apache
OpenOffice support. This list is just users helping other users. I'm one of
those users (I'm actually an ex user, but that's hopefully not very
important) and some times I ask questions and some times I answer
questions, just like most people on the list.


> I used to use Word up until about 10 years ago when somebody suggested Open
> Office to me. I much prefer this to Word.


I prefer a hex editor over Word…


> I do have one issue though. I
> used Excel a lot. They had a function where I could add certain lines to a
> total. On your .ods file, I can find that function.


You can? That's great. Doesn't the mean that the problem is solved? I just
wonder how you could find it in the ods file. Shouldn't you rather look in
the Apache OpenOffice Calc application?


> I don't have Word or
> Excel on my PC now.


Lucky guy. I have both on my job computer and I hate both.

I miss that function.


You said you could find it (in your ods file), or did you mean something
else? Like what?


> I have Open Office version 4.1.6.
> Does that have the function I want? I've checked all the options at the top
> and can't find that function. Am I just missing seeing it? Please help
> because I miss that function. Thank you.
>

Okay, jokes aside, can you please better describe what that ”function”
actually did? I don't really understand what ”add certain lines to a total”
means. Certain lines? To a total? How? Can you give a simple example? What
is the function called in Excel?

I'm sure that if the function doesn't exist in Calc, it's possible to make
one with a macro, but I can't tell how complicated that would be unless I
have more information.


Kind regards

Johnny Rosenberg

Re: Themes

[Johnny Rosenberg]

Den ons 7 aug. 2019 kl 22:17 skrev Sarah Lane :

> I know this seems trivial, but you have NO themes. Think of themes like
> music, or a widow view. High prices are paid for good window views in real
> life.
> There are also facts supporting “good” themes:
>Green symbolizes nature and thus promotes a serene and calming
> environment. Associated with health, healing and well being, green has a
> soothing effect on the body and mind, reducing anxiety and promoting
> concentration. Exposure to the color green may even increase reading
> ability.
> I have used OO since almost the beginning. I always end up using something
> else. Even paying for something else. Why? Because of the themes. Please
> make UI themes a priority in your programing.
> Thank you, thank you, Sarah
>
> I didn't use Apache OpenOffice for a long time, but if you say there are
no themes I believe you. However, LibreOffice has.


Kind regards

Johnny Rosenberg



> Sent from Mail for Windows 10
>
>

Re: Online Registration

[Johnny Rosenberg]

Den sön 26 maj 2019 kl 00:54 skrev Doug Parris :

> Why is it that I have to go through the process to register Open Office
> EVERY time I click it to open the application??
>

Never happened to me. Maybe you downloaded your version somewhere else than
http://www.openoffice.org/?


Kind regards

Johnny Rosenberg


> Doug Parris
>

Re: Destroyed document - please help!

[Johnny Rosenberg]

Den mån 29 apr. 2019 kl 21:38 skrev i...@taxi-pt.si :

> Dear Madam, Sir,
>
> today I have opened an Open Office document after I started my computer.
> When I wanted to open the document it asked me to update the Open Office
> and I clicked yes. When the document opened it asked me what ASCII
> filter options and I chose the character set that it offerd and clicked
> OK. It has fucked up my document that contained my reservations and now
> I can´t get it back. PLEASE, I BEG YOU, PLEASE HELP ME get it back.
> Please let me know what I need to do. Thank you
>

What kind of document (ods, odt, odg, what?)
In what way is it ”fucked up”? Are some characters wrong or does it all
look like random characters or what?
Did you save your document before you closed when you saw that your
document was ”fucked up”?
Have you tried to open an older version of your document from your daily
incremental backups? What does those look like?

>From where did you download Apache OpenOffice? It sounds strange to me that
it asks you to update when trying to open a file, but on the other hand I
didn't use Apache OpenOffice for a long time now, so I'm not sure. Anyway,
always download from http://www.openoffice.org/download and never ever from
anywhere else. You can not be sure what you are actually downloading
otherwise.


Kind regards

Johnny Rosenberg



>
> --
> Katja Knap
>
> PT TAXI
> PT trgovina in storitve d.o.o.
> Podbreg 37
> 4280 Kranjska Gora
> tel.: 00386 51 226 117
> e-mail: i...@taxi-pt.si
> web: www.taxi-pt.si
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Hilfestellung

[Johnny Rosenberg]

Den lör 27 apr. 2019 kl 11:43 skrev Andrea :

> That below
>
> (On April 26, 2019 at 3:51:08 AM, Anita Krisch  (anita.kri...@gmx.at)
> wrote:)
>
> is the original message :-)
>

Yes, as a part of a response, but I never saw the original email.


Kind regards

Johnny Rosenberg



>
> Am 27.04.2019 um 11:20 schrieb Johnny Rosenberg:
> > Did you send this to the wrong mailing list? Just wondering, because I
> > never saw the original message here.
> >
> >
> > Kind regards
> >
> > Johnny Rosenberg
> >
> >
> > Den lör 27 apr. 2019 kl 06:04 skrev David Belina :
> >
> >> Verwenden Sie Windows?
> >>
> >>
> >> On April 26, 2019 at 3:51:08 AM, Anita Krisch (anita.kri...@gmx.at)
> wrote:
> >>
> >> Meine XLS Dateien die ich über Email erhalte, werden nicht automatisch
> von
> >> open office geöffnet.
> >> Können Sie mir helfen.
> >
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Hilfestellung

[Johnny Rosenberg]

Did you send this to the wrong mailing list? Just wondering, because I
never saw the original message here.


Kind regards

Johnny Rosenberg


Den lör 27 apr. 2019 kl 06:04 skrev David Belina :

> Verwenden Sie Windows?
>
>
> On April 26, 2019 at 3:51:08 AM, Anita Krisch (anita.kri...@gmx.at) wrote:
>
> Meine XLS Dateien die ich über Email erhalte, werden nicht automatisch von
> open office geöffnet.
> Können Sie mir helfen.

Re: How do I open a document when I forgot the password?

[Johnny Rosenberg]

Den mån 25 mars 2019 kl 02:41 skrev Marilyn LeBaron :

> How do I open a document I forgot the password to?


You are not supposed to be able to, that's the point in having passwords in
the first place (as somebody already mentioned).


> It will not let me make a new copy. The instructions are to open the
> document and save a copy of it to begin editing it.


What instructions? Who told you that?


> But, I cannot do that the document will not open without a password.


Yes, exactly. That's the point in having passwords. You are not supposed to
be able to open a password protected document without the password. That's
what password protection is for.


>  I cannot save a new copy it has to be open before I can save and rename
> it.
>
> How do I get the password off?


You can do that only if you know the password. It's called security.


> Who do I go to for help.
>

I think there are software out there that can do it, but unless your
passwords is really stupid, it will take quite a while. Maybe days, maybe
even years. It depends on a lot of things, I guess. I think there was a
discussion about this a couple of years ago, maybe you could search the
archives for that thread. Or maybe that was discussed in the LibreOffice
mailing list, I don't remember.



Kind regards

Johnny Rosenberg



>
> Marilyn LeBaron
>
>
>
> Sent from Mail for Windows 10
>
>

Re: BUG I FOUND

[Johnny Rosenberg]

Den mån 25 mars 2019 kl 09:33 skrev sameer deen :

> Hi Sir/Mam,
>
> I used your OpenOffice 4 for past 1Week,
> Here i found one bug that is, I opened same file in both MSExcel and
> OpenOffice,
> In that Openoffice shows multiple number of copies in a single cell that
> is wrong ,
> I uploaded the photo copy of MSExcel and OpenOffice 4 in one picture and i
> marked it in Red Color box, Please Check that and update it to me.
>

Pictures and most other files usually don't get through when sending email
to this list, so we can't see them. You can either upload it somewhere and
give us a link or just give us the necessary information here:
What does the formula look like?
What are the values in all cells referred to in the formula?
What value do you expect from the formula?
What value did you actually get from the formula?


>
>
> Thanks & Regards,
> Your Customer..
>

We are only users like you (I'm actually not even that these days, but I
still hang out here), so you are our customer just as much as we are your
customer.
Oh, and I hope you didn't buy this product, since it's free (in more than
one way) if you download it from
http://www.openoffice.org/download/index.html.

If you actually paid for it, you might have paid for some kind of support.
If that's the case, maybe you should ask your question to whom you paid.



Kind regards

Johnny Rosenberg


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

Re: OPen office

[Johnny Rosenberg]

Den fre 19 okt. 2018 kl 00:00 skrev Lois and Jerry Harrington <
loisandjer...@hotmail.com>:

> Can a person download only what you would have to be the same as
> “microsoft publisher?

If you want compatibility with Publisher there's a simple rule and I think
it's still valid:
”Only publisher can open publisher files”
So the hint is to never start using Publisher in the first place, because
you'll be stuck with it.


> If so is there a point where one can choose what not to download ?
>

No, but I've seen some different versions that are included in some
GNU/Linux-distribution's repositories when you can choose only what you
want. However, there's not much to gain. Most of the individual parts of
the suite use code from each other, so if you only install, let's say
Writer, the size of your installation will still be almost the same as when
installing everything.
I would install the whole suite and then remove unneeded icons from user
interface (if possible – it depends on the operating system).


Kind regards

Johnny Rosenberg



> Thank you. Lois Harrington

Re: Code to download

[Johnny Rosenberg]

Den fre 5 okt. 2018 kl 13:14 skrev pascale djian :

> I just paid 10 euros to get 2 codes to download Apache OpenOffice but a
> message says I can not use open office on this computer…I would like to
> cancel this order or to get a refund.
>
> Thank you
>
> Provenance : Courrier<https://go.microsoft.com/fwlink/?LinkId=550986>
> pour Windows 10
>
>
Apache OpenOffice is free and no codes are needed to download nor install
it, so if you paid for it you certainly didn't pay to Apache, unless you
donated money to them, which I guess is possible to do.
If you want a refund, you have to contact those whom you paid. Emailing
this mailing list about that is probably only a waste of time, since the
most people in this list are users who try to help each other out.

You should always download Apache OpenOffice from http://www.openoffice.org/
.
I'm not sure why you shouldn't be able to use Apache OpenOffice on your
computer, though. Maybe your computer is 32-bit and you downloaded the
64-bit version of Apache OpenOffice?


Kind regards

Johnny Rosenberg

Re: EVERYTHIGN LOST!!!!

[Johnny Rosenberg]

Den fre 14 sep. 2018 kl 17:47 skrev Daniel Landgraf <
daniellandgra...@gmail.com>:

> after saving my document it consists only of ## (sharps)!!! Very bad,
> now i lost everything!!
>

Not everything, unless you forgot to do your daily backup, of course. But
who forgets that? Nobody, I hope. Those who easily forget things probably
set up a schedule for backup anyway, like a Cron job or something similar.

So just recover your important document from your latest backup. If you
don't have one, maybe your document wasn't that important after all?

Anyway, did you have a question of some kind? I can't see it.


Kind regards

Johnny Rosenberg

Re: problems

[Johnny Rosenberg]

2018-04-30 3:54 GMT+02:00 d L <laf...@hotmail.com>:

> I have tried to download several of the templates and none of them
>
> actually down load why bother having templates if they do not actually
>
> work


How do you know they don't work if you weren't able to download them?


> so your programs is not exactly what I expected will be deleting
>
> and passing on to all my friends and contacts not to use your program
>

It's not our program. We are only users helping each other out. Nothing
more. This is the user's mailing list, it's not a paid support or anything
(the email address is ”us...@openoffice.apache.com”, that should tell you
something). This is very clear when you subscribe to the mailing list; I
don't know why some people don't seem to be able to read.



Kind regards

Johnny Rosenberg


>
> Dennis
>

Re: HTML to PDF Conversion using OpenOffice 4.x

[Johnny Rosenberg]

2018-04-21 5:00 GMT+02:00 Prabhakaran Subramanian <
prabhakaran.subraman...@gmail.com>:

> Hi,
>
> We recently upgraded to OpenOffice 4.x, getting failed task error when i
> try to convert html to PDF. Any help would be appreciated.
> Not able to see this issue in OpenOffice 3.x
>

Did you try the exact same file with Apache OpenOffice 3? Maybe the file is
corrupted.
Is it important that you can do this in Apache OpenOffice? There are other
tools for it, such as wkhtmltopdf, which I've used a lot in the past, when
some companies sent me invoices or bills in html or mht format, which they
don't seem to do anymore, though.



Kind regards

Johnny Rosenberg



>
> Logs:
> org.artofsolving.jodconverter.office.OfficeException: task failed
>
> stack trace:org.artofsolving.jodconverter.office.OfficeException: task
> failed
> at org.artofsolving.jodconverter.office.PooledOfficeManager.
> execute(PooledOfficeManager.java:96)
> at org.artofsolving.jodconverter.office.ProcessPoolOfficeManager.execute(
> ProcessPoolOfficeManager.java:78)
> at org.artofsolving.jodconverter.OfficeDocumentConverter.convert(
> OfficeDocumentConverter.java:78)
> at org.artofsolving.jodconverter.OfficeDocumentConverter.convert(
> OfficeDocumentConverter.java:69)
> Caused by: java.util.concurrent.CancellationException
> at java.util.concurrent.FutureTask.report(FutureTask.java:121)
> at java.util.concurrent.FutureTask.get(FutureTask.java:206)
> at org.artofsolving.jodconverter.office.PooledOfficeManager.
> execute(PooledOfficeManager.java:85)
> ... 131 more
>
> Thanks,
> PS.
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: OTS file not opening

[Johnny Rosenberg]

2018-04-02 3:42 GMT+02:00 james mcauliffe <jamesamcauli...@hotmail.com>:

> Hello
>
>
> our OTS files are not opening, each time they try and convert to an OTD
> file and open in document rather than spreadsheet. Any idea why this is
> happening?
>
> What is OTS and OTD? Or do you mean ODS and ODT?


Kind regards

Johnny Rosenberg



>
> regards
>
> James
>
>
> Sent from Outlook<http://aka.ms/weboutlook>
>

Re: Using Comma for Functions

[Johnny Rosenberg]

2018-03-13 9:32 GMT+01:00 Jay Azar <jay_a...@bradycorp.com>:

> Hey team,
>
> I love your application, I even prefer it over MS Office. However, in Calc,
> I am trying to use a comma instead semicolon for functions but I cannot
> find out how to change it.
>
> May you assist me?
>

I don't have Apache OpenOffice installed at the moment, but I remember that
there was a setting for this when I did. In LibreOffice I find it at Tools
→ Options… → LibreOffice Calc → Formula. I know LibreOffice is a lot
different from Apache OpenOffice these days, but hopefully this takes you a
little bit closer to the answer.


Kind regards

Johnny Rosenberg



>
>
> Best regards,
>
> Jay Azar
> Territory Sales Manager, Qatar
> Brady Corporation
> Office: +974 4020 6615
> Mobile: +974 5592 5691
>

Re: Cut the crap out

[Johnny Rosenberg]

2018-02-12 14:18 GMT+01:00 Gary Madine :

>
> I’m trying to prepare an important business letter in a hurry.
>
> How the hell do I disable your automatic "guessing-ahead-of-time" what
> words I want to type?
>

It's not mine. I'm just a user, like you. That's what this mailing list is
all about. I'm not sure how you could subscribe to the list without getting
that. Maybe you are stupid or something, I can't tell for sure from here.


>
> I’m going to go to the web to find out faster.  I’ll use another tool to
> prepare my comments with
> details.
>

Good, but why did you waste your energy and time to write a lot of crap to
the wrong place? For fun? I'm not even sure why I'm writing back.


>
> Any followups will cover your response to the nasty “feature” your tool is
> exercising.
>

Not sure what that means. I haven't even seen the feature you are talking
about. When I type in Writer there's no guessing going on at all, as far as
I remember (I didn't use Apache OpenOffice for a long time now).


>
> dis-respectfully
>

Glad you said that, so we know how much we should respect you back.


>
> Gary E. Madine
> gary.e.mad...@gmail.com
> 610 807 9439
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Spreadsheet

[Johnny Rosenberg]

2018-02-07 19:17 GMT+01:00 steve ronneberg <jiujitsu...@yahoo.com.invalid>:

> I made a spreadsheet but I am unable to send it or upload it anywhere... I
> saved to my desktop and tried sending from there and still nothing
>

I can't see that this is an Apache OpenOffice issue, unless you tried to
send it from inside Apache OpenOffice. Exactly what are you doing when you
are trying to ”send” your spreadsheet file?



Kind regards

Johnny Rosenberg



>
> Sent from Yahoo Mail on Android

Re: HELP!

[Johnny Rosenberg]

As always, if there are no backups, there's probably nothing you or anyone
else can do about it, more than learning the lesson and start making daily
incremental backups from now on. Drives are cheap these days, and
reasonably fast too, so there's really no excuse for not doing backups.
Additional backups to some reasonably safe cloud service could be a good
complement too, in some cases.



Kind regards

Johnny Rosenberg



2017-11-29 4:32 GMT+01:00 mj weddingsofgeorgia.com <m...@weddingsofgeorgia.com
>:

> I have been working on a project using Open Office Spreadsheet for months
> -- it has worked perfectly and tonight, I open it up and all I get is a
> word document filled with hashtags.
>
> I need SOMEONE to HELP me -- this document has imperative information in
> it and I have sat here in tears for hours trying to fix it.  I've used 4
> different recovery systems and NOTHING is working!!
>
> I NEED SOMEONE TO HELP ME RECOVER THIS FILE!!!  You can reach me here on
> email or by phone at (678) 548-9498.
>
> MJ Stephens

Re: There is a problem with the shared '/usr/bin/soffice' between Libreoffice and OpenOffice.

[Johnny Rosenberg]

2017-11-19 22:55 GMT+01:00 Wroger Wroger <wrogerwro...@gmail.com>:

> How to fix this?
>
> Possibly uninstall open office - (older version) do the libre office
> upgrade and then install the latest Open Office version
>
> Any ideas?
>

This is probably an Ubuntu question rather than an Apache OpenOffice
question, I guess. I don't have Ubuntu any longer, I switched to Arch Linux
recently, but I would try to uninstall both completely and then, if I
wanted both of them, download the debs from http://www.libreoffice.org/
(”Still” version) and http://www.openoffice.org/ respectively and install
them from a terminal with dpkg.


Kind regards

Johnny Rosenberg



>
> It won't FIX the shared libraries issue, but it keeps me going.
>
> How to do the fix though?
>
>
>
> Synaptic package manager..
>
> Summary of fault.
>
> E:
> /var/cache/apt/archives/libreoffice-common_1%3a5.1.6~
> rc2-0ubuntu1~xenial2_all.deb:
> trying to overwrite '/usr/bin/soffice', which is also in package
> openoffice-debian-menus 4.1.3-9783
>
>
> Synaptic package manager install of Libreoffice updates.
>
>
> (Reading database ... 672148 files and directories currently installed.)
> Preparing to unpack
> .../libreoffice-common_1%3a5.1.6~rc2-0ubuntu1~xenial2_all.deb ...
> Unpacking libreoffice-common (1:5.1.6~rc2-0ubuntu1~xenial2) ...
>
> dpkg: error processing archive
> /var/cache/apt/archives/libreoffice-common_1%3a5.1.6~
> rc2-0ubuntu1~xenial2_all.deb
> (--unpack):
>  trying to overwrite '/usr/bin/soffice', which is also in package
> openoffice-debian-menus 4.1.3-9783
>
> rmdir: failed to remove '/var/lib/libreoffice/share/prereg/': No such file
> or directory
> rmdir: failed to remove '/var/lib/libreoffice/share/': No such file or
> directory
> rmdir: failed to remove '/var/lib/libreoffice/program/': No such file or
> directory
> rmdir: failed to remove '/var/lib/libreoffice': No such file or directory
> rmdir: failed to remove '/var/lib/libreoffice': No such file or directory
> Processing triggers for gnome-menus (3.13.3-6ubuntu3.1) ...
> Processing triggers for desktop-file-utils (0.22-1ubuntu5.1) ...
> Processing triggers for mime-support (3.59ubuntu1) ...
> Processing triggers for gnome-icon-theme (3.12.0-1ubuntu3) ...
> Processing triggers for hicolor-icon-theme (0.15-0ubuntu1) ...
> Processing triggers for shared-mime-info (1.5-2ubuntu0.1) ...
> Processing triggers for man-db (2.7.5-1) ...
> Errors were encountered while processing:
>  /var/cache/apt/archives/libreoffice-common_1%3a5.1.6~
> rc2-0ubuntu1~xenial2_all.deb
> E: Sub-process /usr/bin/dpkg returned an error code (1)
> A package failed to install.  Trying to recover:
> dpkg: dependency problems prevent configuration of libreoffice-help-en-us:
>  libreoffice-help-en-us depends on libreoffice-l10n-en-us; however:
>   Package libreoffice-l10n-en-us is not installed.
>
> dpkg: error processing package libreoffice-help-en-us (--configure):
>  dependency problems - leaving unconfigured
> dpkg: dependency problems prevent configuration of
> libreoffice-style-galaxy:
>  libreoffice-style-galaxy depends on libreoffice-common (=
> 1:5.1.6~rc2-0ubuntu1~xenial2); however:
>   Package libreoffice-common is not installed.
>
> dpkg: error processing package libreoffice-style-galaxy (--configure):
>  dependency problems - leaving unconfigured
> dpkg: dependency problems prevent configuration of libreoffice-core:
>  libreoffice-core depends on libreoffice-common (>> 1:5.1.6~rc2); however:
>   Package libreoffice-common is not installed.
>
> dpkg: error processing package libreoffice-core (--configure):
>  dependency problems - leaving unconfigured
> dpkg: dependency problems prevent configuration of libreoffice-l10n-en-gb:
>  libreoffice-l10n-en-gb depends on libreoffice-common; however:
>   Package libreoffice-common is not installed.
>
> dpkg: error processing package libreoffice-l10n-en-gb (--configure):
>  dependency problems - leaving unconfigured
> dpkg: dependency problems prevent configuration of
> libreoffice-style-elementary:
>  libreoffice-style-elementary depends on libreoffice-style-galaxy; however:
>   Package libreoffice-style-galaxy is not configured yet.
>  libreoffice-style-elementary depends on libreoffice-common (=
> 1:5.1.6~rc2-0ubuntu1~xenial2); however:
>   Package libreoffice-common is not installed.
>
> dpkg: error processing package libreoffice-style-elementary (--configure):
>  dependency problems - leaving unconfigured
> dpkg: dependency problems prevent configuration of python3-uno:
>  python3-uno depends on libreoffice-core (= 1:5.1.6~rc2-0ubuntu1~xenial2);
> however:
>   Package libreoffice-core is not configured yet.
>
> dpkg: error processing p

Re: At last

[Johnny Rosenberg]

2017-10-14 0:24 GMT+02:00 Kate Shortt <shortt.k...@icloud.com>:

>
> At last I have found you.
>

You found us, but  we are not the ones you should be looking for. Your
question is about your operating system, and you didn't even mention which
one you use.
You could also have avoided the problem, I think, by checking a checkbox at
installation time for making Apache OpenOffice your default office
application for certain file types, but it seems like you failed to do that.


Kind regards

Johnny Rosenberg



>
> Dear open office. I can't open any files in my open office. It's becoming
> quite serious!
> Please help.
> When I try to open up, about 100 different choices of applications for it
> appear. Whenever I click on one the message 'error' appears in a box
>
> I do hope you can help
> Thanks
> Kate Shortt
>
> Sent from my iPhone
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: help with decimal issues

[Johnny Rosenberg]

2017-10-11 12:34 GMT+02:00 Holistic Living <hle...@gmail.com>:

> Hi,
>
> I'm trying to do an invoice but when I add a zero after the .00 decimal
> point and hit enter then the zero disappears!


Did you format that cell properly?


> It does not do this in the
> Total due box as you can see from the cut and past example below.
>
> There is enough room in the box for the amount of digits entered so I do
> not understand why it does this.
>

Room has not much to do with it. If the cell is formatted to show 1
decimal, it rounds the value to 1 decimal.


>
> Last week I managed to correct this prior to printing but I have no idea
> how I did it.
>

Maybe you set the cell format properly?


>
> Please advise asap.  thanks
>

Since I don't know exactly what you did and I don't have a clue about your
spreadsheet skills, I can only guess what you're doing wrong, so I'll just
say this:
What you see in a cell is a combination of what's actually in there and how
you format the cell. In your tool boxes there are tools for common formats,
such as currency, percent, date and number of decimals. You can control the
cell format in greater detail by right clicking a cell or cell range and
select ”Format cells”. If you do that and select the Number tab, there are
a lot of things to select from. You can even do your own number format by
selecting ”user defined” in the Category box and then enter your own format
in the format description field. If your cell contains the number
1234.56789 and your cell format is # ##0.0" km", then the cell will
display: 1 234.6 km.
The built in help describes this well, so take a look if you want.


Kind regards

Johnny Rosenberg



>
> --
> *Best wishes,*
>
> Deborah Monshin
>
>
>
> *TOTAL NET*
>
> 256.5
>
> *VAT @ 20%*
>
> 51.3
>
> *AMOUNT DUE*
>
> *307.80*
>
>
> <http://www.avg.com/email-signature?utm_medium=email;
> utm_source=link_campaign=sig-email_content=webmail>
> Virus-free.
> www.avg.com
> <http://www.avg.com/email-signature?utm_medium=email;
> utm_source=link_campaign=sig-email_content=webmail>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>

Re: I can't use your product...

[Johnny Rosenberg]

2017-10-08 14:56 GMT+02:00 Jura Rúdnev :

> Dear sirs,
>
> A lot of years ago I had been trying use the OO a few times. It was raw
> and could not being used. Now I have tried again. Yes, your product became
> more interesting, but I can't use it again...
>
> I need some base managing. I downloaded, installed OO4 and started OO
> Base. It has would like to have JRE. Normally, when one program needs one
> other, the link corresponding is presented, but not now... Ok, I found out
> what is JRE, downloaded it and restarted my computer... Now I have OO4,
> Java, wasted nearly 400MB of the my 4G internet (is not free!) and your OO4
> is not working... Look at this screenshot!
>
> Well, a'm going to a free Wi-Fi for download MS Access, because I won't
> waste more than 600 MB for nothing...
>
> Yuriy
>

And why did you write here about it?
If it doesn't do it for you, then just use something else.


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

Re: Technical question regarding Openoffice Spreadsheet

[Johnny Rosenberg]

I don't understand much of what you are trying to say here, but I'll try to
reply anyway:

2017-10-01 12:11 GMT+02:00 Onkel Svart <larsharaldogg...@gmail.com>:

> Hi! I have a technical question regarding Openoffice Spreadsheet.
>
>
> Take for example f_ (x) = x. Print list.
>
> What numbers must one sum in order to get f_ (x) = x?
>

Any numbers. Pick a number of x, and f(x) will be the same number. I'm not
sure what that ”_” is doing there, though.


>
> Calculate a new row as summed up will be = (to) the function over.
> Repeat.
>
> Pascal's triangle will appear in the underlying sums
> to the function f_ (x) = x. (after about 10 row extensions.)

Ok, suddenly we are involving Pascals triangle for no obvious reason, but
sure. we can talk about that… :P


>
> How to solve:
> Best Strategy:
>
> Automate the sums in a spreadsheet.
>
> Suggestion:
>
> The difference of the next vertical polynomial is the previous vertical
> polynomial's function. (See hypothesis.)
>
> Hypothesis:
> The sum of the vertical functions goes to the right, and is a (n-1)-degree
> polynomial - without a defined constant number.
> E.g. (Sigma 2 = -2x+3), (Sigma -2x+3 = x^2-4x+5)...etc.
>
>
> Thus: What operators do you think I could implement, for this task, in
> Openoffice Spreadsheet?
>
>
If you just want to do Pascal's triangle in a spreadsheet you need the +
operator, but since that's too abvious I guess you are asking for something
completely different. What is that?

Anyway, here's one way to illustrate the triangle in Apache OpenOffice Calc:
Enter 1 in a few cells in row 1, for instance in A1 thorough P1.
Do the same thing from A1 through A16.
In B2, enter:
=A2+B1
Fill to the right until O2.
Highlight B2 through N2.
Fill downwards until row 15.
Clear the cells C15, D14:D15, E13:E15 and so on, until it looks like a
triangle.
Now the ”floor” of the triangle looks like this:
1 15 105 455 1365 3003 5005 6435 6435 5005 3003 1362 455 105 15 1.

But this is probably not what you were asking for at all, so if you could
explain a little more what you are looking for, it would be nice.


Kind regards

Johnny Rosenberg



> Best regards
>
> Lars Harald Øvstetun
> Statsråd Evensens veg 5
> 6885 Årdalstangen
>
>
>
>
> <http://www.avg.com/email-signature?utm_medium=email;
> utm_source=link_campaign=sig-email_content=webmail>
> Virus-free.
> www.avg.com
> <http://www.avg.com/email-signature?utm_medium=email;
> utm_source=link_campaign=sig-email_content=webmail>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>

Re: What kind of program?

[Johnny Rosenberg]

2017-09-29 15:50 GMT+02:00 Tomasz Namysło :

> Hello,
> I'm Tomasz and I have a question.
> What program can I edit openoffice code.
>

Any text editor will do, I guess. Gedit, Kate, Emacs, whatever.


> Yes, I know. I want to edit, I do not know what program
> But, I want to start to learn, so I have to start somewhere.
> I've already programmed in c ++ in visual studio.
>

That would probably be fine, I guess. I don't have Windows so I can't tell
for sure, though.


> Please, tell me.
>
> --
> Pozdrawiam,
> Tomasz
>
>

Re: compatibility with Microsoft Publisher

[Johnny Rosenberg]

No. Nothing is compatible with Microsoft Publisher, as far as I know.



Kind regards

Johnny Rosenberg



2017-09-20 16:14 GMT+02:00 Linda Forster <linda.forste...@gmail.com>:

> Is Open Office compatible with Microsoft Publisher. I have a large
> document in Publisher and would like to edit it on my Mac Book Pro.
>
> Thank you,
>
> Linda Forster
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: how to know duplicate entry in spreadsheet at time of entry

[Johnny Rosenberg]

2017-09-12 7:14 GMT+02:00 Brian Barker <b.m.bar...@btinternet.com>:

> At 22:15 11/09/2017 +0200, Johnny Rosenberg wrote:
>
>> I think Excel has a dedicated feature for this.
>>
>
> Oh, very probably. But I think the way to look at any requirement in one
> application is to define it carefully and investigate suitable processes
> rather than looking over the fence to where the grass may appear already to
> be green (or possibly another colour in this case).


I'm not sure what you're referring to. Who is looking over the fence? The
OP? Maybe he switched from Excel to OpenOffice Calc and now he can't do
something that he could do in Excel, so he writes here to find out how to
do it. He could be referring to Excel just as an easy way to explain what
he's talking about. I don't consider that ”looking over the fence”. But I'm
just guessing here.

But I agree that it's not necessarily a good idea to only ”look over the
fence”. Just because it's done in one way in Excel doesn't mean that it's
the best way to do it.



Kind regards

Johnny Rosenberg



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

Re: how to know duplicate entry in spreadsheet at time of entry

[Johnny Rosenberg]

2017-09-11 15:30 GMT+02:00 Brian Barker <b.m.bar...@btinternet.com>:

> At 14:00 11/09/2017 +0530, Badal Ghosh wrote:
>
>> Please inform me how to know duplicate entry at the time of entry. (excel
>> highlighted color) is there any option .
>>
>
> (I don't know what Excel has to do with this.)
>

I think Excel has a dedicated feature for this. I don't have Excel myself,
I only have it on my work computer, but I never tried this feature so I'm
not sure how it works.


Kind regards

Johnny Rosenberg



>
> o Go to Format | Styles and Formatting (or click the Styles and Formatting
> button in the Formatting toolbar, or press F11)..
> o Click the Cell Styles button.
> o Create a new cell style, possibly one with a coloured background.
> o Select the relevant cell range for your data. Let's imagine this is
> A1:A99.
> o Note carefully the cell that is active within this range. Let's imagine
> this is A99.
> o Go to Format | Conditional Formatting.
> o Under Condition 1, select "Formula is" from the left drop-down menu.
> o In the box to the right, enter the formula: COUNTIF(A$1:A$99;A99)>1 .
> Note that the second parameter needs to be the active cell noted above,
> whatever that is.
> o Against Cell Style, select the cell style you created above.
> o OK.
>
> As you enter data, any duplicate value will be given the style you created
> - along with the cell it duplicates.
>
> I trust this helps.
>
> Brian Barker
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

[Johnny Rosenberg]

2017-09-09 4:46 GMT+02:00 zahra a <nasrinkhaks...@gmail.com>:

> hi.
> sorry because i answered this message very late!
> libreoffice supports visual basic (vba) and we dont need to buy it!
>

Really? How did they make Microsoft agree with that?


>
> hope that help, God bless you and his infinite mercy be for you.
>
> On 7/1/17, Johnny Rosenberg <gurus.knu...@gmail.com> wrote:
> > 2017-06-29 21:55 GMT+02:00 QCIT3 MMisonora <mmiqc...@outlook.com>:
> >
> >> Hi there,
> >>
> >> I am a new user to OpenOffice and was wondering if when I write lets say
> >> a
> >> spreadsheet with macros on it and sent to someone who would have to open
> >> that file in Excel cause they don't use OpenOffice, would the macros
> >> still
> >> work or would it not work like when one opens an Excel file with macros
> >> and
> >> it doesn't work.
> >>
> >> Thanks,
> >>
> >> Emma
> >>
> >
> > Most things related to Basic (the programming language) will work in
> Excel
> > too, but as soon as you want to do spreadsheet related things, it won't
> > work at all, unless you simulate all that UNO stuff by writing your own
> > objects for them in Excel, but you will need to create a lot of objects…
> :P
> >
> > If Apache OpenOffice supported VBA (Visual Basic for Applications), then
> > you'd have to buy it, just like you buy MS Office.
> >
> >
> >
> > Kind regards
> >
> > Johnny Rosenberg
> >
> >
> >
> >>
> >>
> >> Sent from Outlook<http://aka.ms/weboutlook>
> >>
> >
>
>
> --
> we have not sent you but as a mercy to the creation.
> holy quran, chapter 21, verse 107.
> in the very authentic narration is:
> imam hosein is the beacon of light and the ark of salvation.
> best website for studying islamic book in different languages
> al-islam.org
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: one little problem

[Johnny Rosenberg]

2017-09-05 10:06 GMT+02:00 Jon Ole Hokstad <jo...@online.no>:

> In using OpenOffice writer Norwegian version I get “Da” ever time I write
> “å” and “om”.
> What is wrong?
>

Did you check your ”Autocorrect” settings?



Kind regards

Johnny Rosenberg



>
> Best regards
> Jon Ole Hokstad
> Parkveien 10 H
> 2500 Tynset
> Tlf.: 412 08 471
> www.tronden.com

Re: hello

[Johnny Rosenberg]

Is there a special reason why you want to open it with Apache OpenOffice?
You can't just open it with your PDF reader?

If you want to edit it, since you obviously created the file in the first
place, maybe with Apache OpenOffice, I suggest that you open the original
file (ODT or whatever format you usually use), edit it, save it and export
it as a new PDF.

If you didn't keep the original file, remember to do that with documents
you create in the future to avoid this problem. Today's disk drives are so
big that you could store millions of text documents on them, so don't erase
documents just to save space.

And as always, do backups every day. I know, that's another issue, but it
can't be pointed out enough…


Kind regards

Johnny Rosenberg


2017-08-16 13:27 GMT+02:00 hello, <wikiaskb...@gmail.com>:

> Please i have a PDF file that i saved on my Desktop and i am trying to
> open it with Openoffice 4.1.3 but he
> Did not open.please how can i do it?
>
>

Re: reveal codes

[Johnny Rosenberg]

2017-08-09 21:48 GMT+02:00 Stephen Nichols <step...@nichols-family.us>:

> I used WordPerfect for 15 years because of two reasons, besides that it’s
> a great product.
> 1)  I hate Microsoft.
> 2)  I absolutely LOVE the “reveal codes” function of WP.  It is the most
> powerful tool in word processing, eliminating all sorts of bad formatting
> issues.
>
> I can’t easily use WP anymore since all of our computers have gone to Macs
> and Corel won’t come back with their Mac version.  I find OpenOffice a very
> suitable replacement.  But … Why can’t/won't OpenOffice add a similar
> feature?
>

I think someone built an add-on for this many years ago, but I'm not sure
if it still works. Or maybe it was made for LibreOffice, I don't remember.

Apache OpenOffice is built around styles, kind of. This has its obvious
advantages, especially when you want consistent documents and it's very
easy to make huge changes very quickly, for instance in a few clicks change
the font size for all headers in hundreds of pages at once. I use styles
all the time and I never needed ”reveal codes” and I'm pretty sure I'll
never need them.


Anyway, if that add-on can't be found or if it doesn't work with newer
versions of Apache OpenOffice, and if you don't want to adapt to styles,
then I would say that Apache OpenOffice is not for you. Pick something
else. This discussion has been up quite a few times and it seems obvious to
me that this feature will never ever be implemented in Apache OpenOffice,
nor in LibreOffice. At least that's what I think.


Kind regards

Johnny Rosenberg


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

Re: maybe its my message for farewell to the group:

[Johnny Rosenberg]

2017-07-05 19:57 GMT+02:00 Wade Smart :

> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
>
> On Wed, Jul 5, 2017 at 10:51 AM, zahra a  wrote:
> > hello every one.
> > i subscribed to the group many months ago.
> > with hope that can help you and getting help from you.
> > i sent answer to the simple questions which i could help
> > and i dont know did my answer help you?
> > are they beneficial for you or not?
> > but unfortunately, your program is not 100% accessible for blind users.
> > for example: footnotes, tables, say all command etc dont work for
> > screen reader users.
> > also openoffice combines diacritics in to letters for arabic language,
> > we cant navigate between diacritics in the way we can navigate through
> > letters using right arrow key and even character count is incorrect.
> > its not my expected behaviour or comfortable for me to use your
> > program, without supporting of diacritics.
> > i dont see any special and useful update for openoffice in recent
> > years and if i cant read, write and edit my books, and developers dont
> > solve this issue, i realy cant use your program and i decide to
> > unsubscribe from this group.
> > whats your idea?
> > who can help me and answer my question?
> > God bless you all.
>
> Are you answers beneficial?
>
> Unknown.
> If they helped the specific OP then, yes.
>
> As for the rest, if it does not work for you, then it doesnt.
> Its pretty simple. You'll need to move on and find something else.
>

Sounds like this project is pretty much abandoned anyway, isn't it?
Hopefully I'm wrong.


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

Re: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

[Johnny Rosenberg]

2017-06-29 21:55 GMT+02:00 QCIT3 MMisonora <mmiqc...@outlook.com>:

> Hi there,
>
> I am a new user to OpenOffice and was wondering if when I write lets say a
> spreadsheet with macros on it and sent to someone who would have to open
> that file in Excel cause they don't use OpenOffice, would the macros still
> work or would it not work like when one opens an Excel file with macros and
> it doesn't work.
>
> Thanks,
>
> Emma
>

Most things related to Basic (the programming language) will work in Excel
too, but as soon as you want to do spreadsheet related things, it won't
work at all, unless you simulate all that UNO stuff by writing your own
objects for them in Excel, but you will need to create a lot of objects… :P

If Apache OpenOffice supported VBA (Visual Basic for Applications), then
you'd have to buy it, just like you buy MS Office.



Kind regards

Johnny Rosenberg



>
>
> Sent from Outlook<http://aka.ms/weboutlook>
>

Re: Help Me Make This Faster

[Johnny Rosenberg]

2017-06-22 21:22 GMT+02:00 QCIT3 MMisonora <mmiqc...@outlook.com>:

>
> Hello there,
> Recently the company I am working for has downloaded your program,
> OpenOffice and have tried to open some files we have previously made files
> on Windows Excel with your program. However, it took about twenty minutes
> to load, so I was wondering why is it loading so slow and how can we make
> it load faster. The computers we are using are Windows 7 computers that run
> on a Core 2 Duo with 2 GB of RAM and a 32-bit Operating System.
> Please help,
> Emma
>
>
Have you tried to open it with LibreOffice? I think they worked a little
more with these kinds of issues. Maybe it will open faster, or maybe not. I
don't know since I only work with ODF, but it wouldn't hurt to try, I guess.


Kind regards

Johnny Rosenberg



>
> Sent from Outlook<http://aka.ms/weboutlook>
>

Re: Lost Work

[Johnny Rosenberg]

2017-04-10 9:09 GMT+02:00 International Aircraft Collection <
i...@iaircraft.co>:

> How is this possible in now a days [image: ☹]i  can not belive it
>
>
> I was actually thinking the same thing: How is it possible nowadays, that
there are still people out there who don't do backups? I just can't believe
it.



Kind regards

Johnny Rosenberg




> Best Regards
>
> James Smith
>
> *Cel:* +1 801 675 4496 <+1%20801-675-4496>
> *Office *+1 808 824 3437 Ext: 102
>
> *Email:* i...@iaircraft.co
> <http://www.iaircraft.co>
> *Skype:* iaircraftc1
> *Web:* www.iaircraft.co
>
>
>
> --
> *From:* Dave <nore...@tasit.net>
> *Sent:* Monday, April 10, 2017 9:31 AM
> *To:* users@openoffice.apache.org; International Aircraft Collection
> *Subject:* Re: Lost Work
>
>  Original Message 
> From: International Aircraft Collection <i...@iaircraft.co>
> <i...@iaircraft.co>
> To: users@openoffice.apache.org <users@openoffice.apache.org>
> <users@openoffice.apache.org>
> Date: Mon, 10 Apr 2017 05:42:41 +
>
> Helllo,
>
>
> I just lost all my work on this page.  All my years work is now gone.
>
>
> Pease help me restore it. Please see attached file
>
>
> Best Regards
>
> James Smith
>
>
> Hi James,
>
> Sorry to say that there is nothing in your file to restore/recover,
> because it contains nothing but 32,768 bytes of zeros. So unless you have a
> backup, your work is permanently lost.
>
> For future reference I suggest:
>
>1. You save your work in ODF (*O*pen*D*ocument *F*ormat ISO/IEC
>26300:2006 standard http://en.wikipedia.org/wiki/ODF), not the old MS
>Excel binary format.
>If an ODF file becomes corrupted there is more chance of recovery.
>
>2. If you don't already make backups of your important files, you
>should do so. There are numerous options for backing up computer files and
>many of them are free.
>
> Regards
>
> Dave
> --
> Please address any reply to the mailing list only. Any messages sent to
> this noreply@ address are automatically deleted from the server and will
> never be read.
>
>
>

Re: open office-HELP!!!

[Johnny Rosenberg]

Forgot to ask… did you install that ”Mac cleaner” before or after this
problem occured? Some ”cleaners” are actually malware, I think…



Kind regards

Johnny Rosenberg


2017-03-20 17:20 GMT+01:00 Sue Johnston <suejohnst...@gmail.com>:

> Dear Sir,
> Having used Open Office successfully for several years it is now unusable
> and rubbish. I have taken it off and reinstalled several times with no
> beneficial effect. this is a screen shot of recent work.I have installed a
> Mac cleaner at cost, and am totally frustrated as I am the  Treasurer of a
> Museum and the Secretary of a Gardening club and have other roles where I
> need Open Office urgently.
> I am now considering a Micro Soft package as I cannot sort this out. It
> has happened in the past few weeks. Any hi lighting I do is in Black. The
> print goes furry and sometimes doubles up, I cannot delete cells easily . I
> could go on and on but am at my wits end.
>
> I hope you can help
> Yours
> Sue Johnston
>

Re: open office-HELP!!!

[Johnny Rosenberg]

Looks like a hardware issue, I have never seen anything like this in Apache
OpenOffice.
What happens if you open the same file with LibreOffice?
http://www.libreoffice.org/download/download/?type=mac-x86_64
Choose the ”still” version, 5.2.6.


Kind regards

Johnny Rosenberg



2017-03-20 17:20 GMT+01:00 Sue Johnston <suejohnst...@gmail.com>:

> Dear Sir,
> Having used Open Office successfully for several years it is now unusable
> and rubbish. I have taken it off and reinstalled several times with no
> beneficial effect. this is a screen shot of recent work.I have installed a
> Mac cleaner at cost, and am totally frustrated as I am the  Treasurer of a
> Museum and the Secretary of a Gardening club and have other roles where I
> need Open Office urgently.
> I am now considering a Micro Soft package as I cannot sort this out. It
> has happened in the past few weeks. Any hi lighting I do is in Black. The
> print goes furry and sometimes doubles up, I cannot delete cells easily . I
> could go on and on but am at my wits end.
>
> I hope you can help
> Yours
> Sue Johnston
>

Re: Multiplying Time by Numbers

[Johnny Rosenberg]

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

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

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

Here's an example
A1 → type 1:30
B1 → type 40 → format as currency
C1 → type =A1*24*B1 → formatting as currency will happen automatically.
Result: £60.

Simple as that…



Kind regards

Johnny Rosenberg



2017-03-19 11:37 GMT+01:00 Alan Pearce <alannpea...@talktalk.net>:

> Thanks to all who replied to my request. I am sure that I will be able to
> sort out a method now.
>
> Regards,
> Alan.
>
> Sent from Samsung tablet
>
>  Original message 
> From: Alan Pearce <alannpea...@talktalk.net>
> Date:18/03/2017  12:51  (GMT+00:00)
> To: users@openoffice.apache.org
> Subject: Multiplying Time by Numbers
>
> I would like to multiply Hours and Minutes by a number of GB pounds. Is
> this possible and if so how please?
>
>
> Alan.
>
> Sent from Samsung tablet

Re: Open Office

[Johnny Rosenberg]

2017-02-10 21:36 GMT+01:00 Andrea <andrea...@gmx.ch>:

> OO Supports the "send as email" feature - why not use it?
>

Maybe the OP doesn't have an email client installed?


Kind regards

Johnny Rosenberg



>
> In Writer you can choose the format OO, MS-Word, PDF - I din't check it,
> but I think this is able in other parts too ...
>
>
> Am 10.02.2017 um 19:24 schrieb Alan Pearce:
>
>> Might be best to save it as a PDF first and then attach it to an email.
>> If you don't know how to do it then please feel free to ask me.
>>
>> Alan.
>>
>> Alan N Pearce
>> Tel: 01275 856887
>> Mob: 07761  255688
>>
>> Sent from Samsung tablet
>>
>>
>>  Original message 
>> From: Johnny Rosenberg <gurus.knu...@gmail.com>
>> Date:10/02/2017  18:10  (GMT+00:00)
>> To: users@openoffice.apache.org
>> Subject: Re: Open Office
>>
>> 2017-02-10 5:08 GMT+01:00 <weale...@btinternet.com>:
>>
>> Dear Sirs how do I associate a email account with Open Office if I want to
>>> email a document to a friend
>>> Regards Eric Weale
>>>
>>> Sent from Mail for Windows 10
>>>
>>>
>>> You don't need to. Just write your mail, then attach the document and
>> send
>> it all to your friend.
>>
>>
>>
>> Kind regards
>>
>> Johnny Rosenberg
>>
>>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Open Office

[Johnny Rosenberg]

2017-02-10 5:08 GMT+01:00 <weale...@btinternet.com>:

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



Kind regards

Johnny Rosenberg

Re: Libre Office

[Johnny Rosenberg]

2017-02-06 21:09 GMT+01:00 Jim McLaughlin <jjim.mclaugh...@gmail.com>:

> No, it doesn't.
>
> OO is a  bad joke.  yaers and years with the same defects, unresolved.
> Dictionary issues; shut down failures; us profile issues.  They continue
> forever, and there is no resolution bu the project authors.
>
> Bad joke.
>

That's true. Since I started using OpenOffice.org (1.0.3 I think) I
switched to LibreOffice when it was first released. Then it destroyed my
most important spreadsheet so bad that only Apache OpenOffice was able to
recover it, so I switched back to Apache OpenOffice. Unfortunately there
was too many bugs that made some of my spreadsheets almost impossible to
use, so once again I switched to LibreOffice which has a quite different
approach to Apache OpenOffice. Instead of keeping their old bugs forever
they introduce new interesting ones with every release. So I would say that
neither Apache OpenOffice nor LibreOffice work properly, at least not with
spreadsheets.

As some kind of reference I can mention that I use Excel at work (I can't
even install it at home since there doesn't seem to be a Linux version for
some reason), and even if I only used it for like a year now (Excel 2013),
I already found quite a lot of quite interesting bugs, forcing me into a
lot of workarounds all the time. And I also find the user interface quite
unusable. I seem to never being able to figure out where to find stuff, so
I often need to search the web for really simple things. On the positive
side I can mention the macro recorder which almost works now and then.
Sometimes I need to remove some lines to make the macro work when I
otherwise get an error message telling be that a command doesn't exist…
very funny indeed. A macro recorder that creates commands that doesn't
exist – hilarious…



Kind regards

Johnny Rosenberg


> On Mon, Feb 6, 2017 at 12:01 PM, Matthias Seidel <
> matthias.sei...@hamburg.de
> > wrote:
>
> > So does OpenOffice.
> >
> >
> > Am 06.02.2017 um 20:59 schrieb Jim McLaughlin:
> > > Libre Office works.
> > >
> > > On Mon, Feb 6, 2017 at 11:19 AM, John Gregson <jfgreg...@shaw.ca>
> wrote:
> > >
> > >> What is the difference between Open Office and Libre office?
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> J. Gregson
> > >> jfgreg...@shaw.ca
> > >>
> > >>
> >
> >
> >
>

Re: uninstall

[Johnny Rosenberg]

2017-02-06 17:05 GMT+01:00 Nellyfanjita Computer :

> David you need to flag up "Control panel" on your computer start up list.
> It will have a section named install/uninstall. Scroll down the list of
> programmes to Open office and click on that to highlight it. Then click on
> uninstall. It will take a few minutes to uninstall all the files. If you
> are asked "this programme wants to make changes to your computer" just
> click on accept. I hope that is helpful.
>
>
Will probably work on a certain operating system, but he didn't tell us
which one he has…


>
>
> Sent from my Samsung Galaxy smartphone.
>
>
>  Original message 
> From: David Porter 
> Date: 06/02/2017 3:58 p.m. (GMT+00:00)
> To: users@openoffice.apache.org
> Subject: uninstall
>
> I downloaded your Open Office it is not going to work for me. I need to
> uninstall need help
>

Re: What Happened to OO Writer?

[Johnny Rosenberg]

2017-02-03 7:28 GMT+01:00 nasrin khaksar <nasrinkhaks...@gmail.com>:

> hi.
> also i tried abiword which is only 9mb.
> but unfortunately it has not any update for windows users since 2012
> and worse, it has not even accessibility feature!
>

I don't know much about Windows, but can't Windows users install from
source?


Kind regards

Johnny Rosenberg



>
> On 2/3/17, Martin Groenescheij <mar...@groenescheij.com> wrote:
> >
> >
> > On 03/02/17 12:23 AM, nasrin khaksar wrote:
> >> hi.
> >> i tried to download only writer in two years ago without any success.
> >> i realy wish that openoffice libreoffice developers make the situation
> >> easy for users that only want one or two part of the program, not one
> >> complete package.
> >
> > OpenOffice is an office suite, have you ever rented office space with
> > only a chair or only a desk?
> > If you rent an office you get a Desk, a Chair and probably a Phone ad I
> > bet there will be carpet on the floor.
> >
> >
> >> i downloaded and tested many versions of two office suites, but i only
> >> need writer not one complete office package!
> >> i wish that developers of these great office projects, read my comment.
> >> thanks every one and God bless you all.
> >>
> >> On 1/3/17, Martin Groenescheij <mar...@groenescheij.com> wrote:
> >>> Cc: to poster
> >>>
> >>>
> >>> On 03/01/17 5:07 PM, Sagan Android wrote:
> >>>> Hi There,
> >>>>
> >>>> About ten years ago (IIRC) I convinced my office to switch to Open
> >>>> Office.
> >>>> Not long after I was let go.
> >>>>
> >>>> Tonight I decided to see how to project was going so I went to
> >>>> www.openoffice.org . I can't even find how to download Writer! The
> >>>> Download
> >>>> page only offers a "full installation" which I don't want to allocate
> >>>> space
> >>>> for.
> >>> You can only download the full package, all modules use most of the
> same
> >>> code, hence even if it was
> >>> possible to download only part of OpenOffice it doesn't save much disk
> >>> space.
> >>>
> >>>> So I searched for Writer on the site. That took me to
> >>>> http://www.openoffice.org/product/writer.html , but again, no
> download
> >>>> option for Writer. The Product section has a link for Writer that just
> >>>> loops back to http://www.openoffice.org/product/writer.html.
> >>>>
> >>>> Eventually I found http://www.openoffice.org/sw/ which had a link to
> go
> >>>> to
> >>>> http://wiki.services.openoffice.org/wiki/Writer . On there, is a link
> >>>> back
> >>>> to... you guessed it, http://www.openoffice.org/product/writer.html.
> >>>> Round
> >>>> and around we go. Nowhere is there an obvious link to download Writer.
> >>>>
> >>>> If the project if still active, can you please have links so people
> can
> >>>> download the program they want? Maybe some extra related links for
> >>>> spell/gramme checking, etc.
> >>>>
> >>>> Best wishes,
> >>>> Pat
> >>>>
> >>>
> >>> -
> >>> 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
> >
> >
>
>
> --
> we have not sent you but as a mercy to the creation.
> holy quran, chapter 21, verse 107.
> in the very authentic narration is:
> imam hosein is the beacon of light and the ark of salvation.
> best website for studying islamic book in different languages
> al-islam.org
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: What Happened to OO Writer?

[Johnny Rosenberg]

2017-02-02 14:23 GMT+01:00 nasrin khaksar <nasrinkhaks...@gmail.com>:

> hi.
> i tried to download only writer in two years ago without any success.
> i realy wish that openoffice libreoffice developers make the situation
> easy for users that only want one or two part of the program, not one
> complete package.
> i downloaded and tested many versions of two office suites, but i only
> need writer not one complete office package!
> i wish that developers of these great office projects, read my comment.
> thanks every one and God bless you all.
>

This has been discussed many times and the answer seems to be the same
every time. Even if you could download Writer only, its size would still be
maybe 90% of the size of the whole suite.

I heard that AbiWord stepped up a bit with their latest release, I don't
know since I don't use it myself, but maybe that is worth trying? A lot
less to download than Apache OpenOffice…


Kind regards

Johnny Rosenberg





>
> On 1/3/17, Martin Groenescheij <mar...@groenescheij.com> wrote:
> > Cc: to poster
> >
> >
> > On 03/01/17 5:07 PM, Sagan Android wrote:
> >> Hi There,
> >>
> >> About ten years ago (IIRC) I convinced my office to switch to Open
> >> Office.
> >> Not long after I was let go.
> >>
> >> Tonight I decided to see how to project was going so I went to
> >> www.openoffice.org . I can't even find how to download Writer! The
> >> Download
> >> page only offers a "full installation" which I don't want to allocate
> >> space
> >> for.
> >
> > You can only download the full package, all modules use most of the same
> > code, hence even if it was
> > possible to download only part of OpenOffice it doesn't save much disk
> > space.
> >
> >>
> >> So I searched for Writer on the site. That took me to
> >> http://www.openoffice.org/product/writer.html , but again, no download
> >> option for Writer. The Product section has a link for Writer that just
> >> loops back to http://www.openoffice.org/product/writer.html.
> >>
> >> Eventually I found http://www.openoffice.org/sw/ which had a link to go
> >> to
> >> http://wiki.services.openoffice.org/wiki/Writer . On there, is a link
> >> back
> >> to... you guessed it, http://www.openoffice.org/product/writer.html.
> >> Round
> >> and around we go. Nowhere is there an obvious link to download Writer.
> >>
> >> If the project if still active, can you please have links so people can
> >> download the program they want? Maybe some extra related links for
> >> spell/gramme checking, etc.
> >>
> >> Best wishes,
> >> Pat
> >>
> >
> >
> > -
> > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> > For additional commands, e-mail: users-h...@openoffice.apache.org
> >
> >
>
>
> --
> we have not sent you but as a mercy to the creation.
> holy quran, chapter 21, verse 107.
> in the very authentic narration is:
> imam hosein is the beacon of light and the ark of salvation.
> best website for studying islamic book in different languages
> al-islam.org
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: please remove openoffice from my imac computer thanks

[Johnny Rosenberg]

2017-01-12 19:51 GMT+01:00 Eileen Peakman <egp...@gmail.com>:

> I never asked for open Office to be removed
>

Nobody said you were, unless the OP and you are the same person. The email
addresses are different, though (calexic...@gmail.com ≠ egp...@gmail.com).


> > On 11 Jan 2017, at 21:19, Johnny Rosenberg <gurus.knu...@gmail.com>
> wrote:
> >
> > Sure. Where do you live?
> >
> > 2016-11-24 20:13 GMT+01:00 mel moore <calexic...@gmail.com>:
> >
> >>
> >>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: please remove openoffice from my imac computer thanks

[Johnny Rosenberg]

Sure. Where do you live?

2016-11-24 20:13 GMT+01:00 mel moore :

>
>

Re: Calendar

[Johnny Rosenberg]

2017-01-10 17:15 GMT+01:00 <lindamcil...@bis.midco.net>:

> Do you have a calendar app?


I have a few, but I guess you mean if there is one built in to the Apache
OpenOffice suite. No, there isn't.


Kind regards

Johnny Rosenberg

Re: AOO crashes on applying styles

[Johnny Rosenberg]

2016-09-11 10:36 GMT+02:00 Matthias Seidel <matthias.sei...@hamburg.de>:

> I can confirm that it does not occur on Xubuntu 16.04.1. So it may be
> related to the window manager.
>

Could be, I use Compiz, which is rather buggy, as it seems, and I don't use
the default settings. For instance I use the desktop cube för desktop
shifting.


Kind regards

Johnny Rosenberg


> I will try en-uk on Ubuntu 16.04.1 to see if it is related to the
> language pack.
>
> There are at least 2 other situations where I can reproduce a crash.
> One was confirmed for 4.1.1 on Mac
> (https://bz.apache.org/ooo/show_bug.cgi?id=125762).
>
> Matthias Seidel
>
>
> Am 11.09.2016 um 10:21 schrieb Rory O'Farrell:
> > On Sun, 11 Sep 2016 10:12:20 +0200
> > Matthias Seidel <matthias.sei...@hamburg.de> wrote:
> >
> >> Which OS do you use?
> >>
> >> I can confirm the bug with v4.1.2 (german) on Ubuntu 16.04.1
> >>
> >> kind regards
> >>
> >> Matthias Seidel
> > The bug does not occur on any of my Xubuntu 16.04.1 machines (en-UK).
> There have been reports that it can occur on full Ubuntu 1g.04.1; other
> users of Xubuntu 16.04.1 report no such bug.  I do not know the situation
> of other *Ubuntu 16.04.1 versions
> >
> > Rory O'Farrell
> >
> >
> >>
> >> Am 11.09.2016 um 01:22 schrieb Johnny Rosenberg:
> >>> 2016-09-11 0:19 GMT+02:00 Matthias Seidel <matthias.sei...@hamburg.de
> >:
> >>>
> >>>> Hello,
> >>>>
> >>>> is anyone else having this issue?
> >>>>
> >>> Yes, I do. There are a few operations in the styles section that always
> >>> cause Apache OpenOffice to crash. I mentioned it here a few years ago
> but
> >>> the response were that ”it works for me”. Later I switched hardware
> >>> completely (processor, memory, graphics card, mother board, everything
> >>> except the DVD burner and ”tower”…), but exactly the same problem
> persists,
> >>> so I guess it's not my hardware's fault, at least.
> >>>
> >>> So since I couldn't work with some of my files efficiently, I switched
> over
> >>> (again) to LibreOffice, which I don't like at all (on the other hand, I
> >>> don't like any of the office suites I've ever tried at all, everyone of
> >>> them have serious issues), but it solved that particular problem, at
> least.
> >>>
> >>>
> >>> Kind regards
> >>>
> >>> Johnny Rosenberg
> >>>
> >>>
> >>>
> >>>> https://bz.apache.org/ooo/show_bug.cgi?id=126980
> >>>>
> >>>> It would be nice to resolve this bug for the upcoming 4.1.3 release.
> >>>>
> >>>> kind regards
> >>>>
> >>>> Matthias Seidel
> >>>>
> >>>>
> >>>>
> >>
> >
>
>
>

Re: AOO crashes on applying styles

[Johnny Rosenberg]

2016-09-11 10:12 GMT+02:00 Matthias Seidel <matthias.sei...@hamburg.de>:

> Which OS do you use?
>

Ubuntu 14.04, 32-bit


Kind regards

Johnny Rosenberg



>
> I can confirm the bug with v4.1.2 (german) on Ubuntu 16.04.1
>
> kind regards
>
> Matthias Seidel
>
>
> Am 11.09.2016 um 01:22 schrieb Johnny Rosenberg:
> > 2016-09-11 0:19 GMT+02:00 Matthias Seidel <matthias.sei...@hamburg.de>:
> >
> >> Hello,
> >>
> >> is anyone else having this issue?
> >>
> > Yes, I do. There are a few operations in the styles section that always
> > cause Apache OpenOffice to crash. I mentioned it here a few years ago but
> > the response were that ”it works for me”. Later I switched hardware
> > completely (processor, memory, graphics card, mother board, everything
> > except the DVD burner and ”tower”…), but exactly the same problem
> persists,
> > so I guess it's not my hardware's fault, at least.
> >
> > So since I couldn't work with some of my files efficiently, I switched
> over
> > (again) to LibreOffice, which I don't like at all (on the other hand, I
> > don't like any of the office suites I've ever tried at all, everyone of
> > them have serious issues), but it solved that particular problem, at
> least.
> >
> >
> > Kind regards
> >
> > Johnny Rosenberg
> >
> >
> >
> >> https://bz.apache.org/ooo/show_bug.cgi?id=126980
> >>
> >> It would be nice to resolve this bug for the upcoming 4.1.3 release.
> >>
> >> kind regards
> >>
> >> Matthias Seidel
> >>
> >>
> >>
>
>
>

Re: AOO crashes on applying styles

[Johnny Rosenberg]

2016-09-11 9:54 GMT+02:00 Fernando Cassia <fcas...@gmail.com>:

> On Sat, Sep 10, 2016 at 11:22 PM, Johnny Rosenberg <gurus.knu...@gmail.com
> >
> wrote:
>
> > I mentioned it here a few years ago but
> > the response were that ”it works for me”. Later I switched hardware
> > completely (processor, memory, graphics card, mother board, everything
> > except the DVD burner and ”tower”…), but exactly the same problem
> persists,
> > so I guess it's not my hardware's fault, at least.
> >
>
> Sounds like bad bug triage. That kind of error -if it can be reproduced by
> you- should be easy to reproduce and confirm by devs. Did you provide
> sample documents?
>

I don't remember, this was a couple of years ago, I think…
But I guess I could, if nobody else can reproduce it with any file.


Kind regards

Johnny Rosenberg




>
> FC
> --
> During times of Universal Deceit, telling the truth becomes a revolutionary
> act
> - George Orwell
>

Re: AOO crashes on applying styles

[Johnny Rosenberg]

2016-09-11 10:03 GMT+02:00 Rory O'Farrell <ofarr...@iol.ie>:

> On Sun, 11 Sep 2016 07:54:56 +
> Fernando Cassia <fcas...@gmail.com> wrote:
>
> > On Sat, Sep 10, 2016 at 11:22 PM, Johnny Rosenberg <
> gurus.knu...@gmail.com>
> > wrote:
> >
> > > I mentioned it here a few years ago but
> > > the response were that ”it works for me”. Later I switched hardware
> > > completely (processor, memory, graphics card, mother board, everything
> > > except the DVD burner and ”tower”…), but exactly the same problem
> persists,
> > > so I guess it's not my hardware's fault, at least.
> > >
> >
> > Sounds like bad bug triage. That kind of error -if it can be reproduced
> by
> > you- should be easy to reproduce and confirm by devs. Did you provide
> > sample documents?
> >
> > FC
> > --
> > During times of Universal Deceit, telling the truth becomes a
> revolutionary
> > act
> > - George Orwell
>
> Does it work when Windows is started in "Safe Mode"?  If so,  the problem
> is caused by crosstalk from some application/driver that runs in Windows
> Normal mode.  On my infrequently used Windows machine (XP) it works
> correctly.
>


Don't know anything about Windows, didn't use it since 2007.


Kind regards

Johnny Rosenberg


>
> --
> Rory O'Farrell <ofarr...@iol.ie>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: locked file

[Johnny Rosenberg]

2016-07-17 10:18 GMT+02:00 Martin Groenescheij <mar...@groenescheij.com>:

>
>
> On 17/07/16 2:18 PM, Heather wrote:
>
>>
>> Having trouble with a UBS. I have a ODT file which I can't open. It
>> states corrupt and therefore cannot be opened can try to repair file,should
>> Open Office repair the file so I press Yes, and then I get a blank page at
>> the top says repaired doc.
>>
>> There is an attached locked file of 1kg.  It is a big file 56,000kg.
>>
>
> That's far to heavy to lift by one person, probably you can hire a
> forklift truck.


Well, 56 ton requires a really big forklift truck. Maybe too expensive for
most users?
Or maybe the comma is a decimal separator, just like it is in about half of
all the countries in the world, making it 56 kg and not a gram more or
less. Then only a friend is needed. Together they can lift it without
destroying their backs, I think.


Kind regards

Johnny Rosenberg



>
>
>
>> I also have the same file on the computer -I made a copy of the usb, but
>> I am unable to open it.
>> regards
>> Heather
>>
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>>
>>
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>>
>>
>>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Shrink text in OO4

[Johnny Rosenberg]

2016-07-17 10:05 GMT+02:00 Martin Groenescheij <mar...@groenescheij.com>:

>
>
> On 17/07/16 3:23 PM, Dale Erwin wrote:
>
>> On 7/16/2016 10:41 AM, ke...@kge.me.uk wrote:
>>
>>> Hi,
>>>
>>> I need to shrink a section of text, in OpenOffice 4 writer, so it shows
>>> very small but can still be read by the computer. Can you tell me how to
>>> do this (if it can be done)?
>>>
>>> Many thanks
>>>
>>> Keith Edwards
>>>
>>
>> Up to a certain point, depending on the font you are using. Highlight the
>> text you want affected and then adjust the point size.  To do this, in the
>> tool bar near the top of the window, there is a box with the name of the
>> font (the default is Times New Roman) and next to that is a box with the
>> point size in effect (12 is the default).  Click on the arrow to the right
>> of this 12 and select a smaller number.  Some fonts can be made smaller
>> than others.
>>
>
> The smallest size you can select is 6 pt, but if you enter in the box 5%
> it get even smaller.
>

You can enter whatever you want in that box, even decimal values. The
lowest number appears to be 2, because if you enter anything lower it will
be changed to 2.
I did a quick test by typing HHH and let each H be different sizes
from 3.0 to 4.0. When checking their sizes afterwards, some are changed, so
they are instead 3.0, 3.0, 3.2, 3.2, 3.4, 3.5, 3.5, 3.7, 3.7, 3.9, 4.0

Entering 5 % just gets the %-character removed.
Zooming to 600 %, even size 2 pt can easily be read.

I tried this with the following fonts:
Arial
Deja vu sans
Free Sans
Liberation Sans
Times New Roman
Ubuntu


Kind regards

Johnny Rosenberg



> Even if you zoom to the maximum you can't read it anymore.
>
>
>>
>> Dale Erwin
>>
>>
>>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: locked file

[Johnny Rosenberg]

2016-07-17 6:18 GMT+02:00 Heather <mcfar...@xtra.co.nz>:

>
> Having trouble with a UBS. I have a ODT file which I can't open. It states
> corrupt and therefore cannot be opened can try to repair file,should Open
> Office repair the file so I press Yes, and then I get a blank page at the
> top says repaired doc.
>
> There is an attached locked file of 1kg.  It is a big file 56,000kg.
>

Ok, you obviously mean kB or KiB. The difference is not very big, but I
guess kB, so we are talking about 56 MB here, which is exactly 56·10⁶ B.
Then I'm also assuming your comma character is a thousands separator and
not a decimal separator – even though that's not the case in about half of
all the countries in the world, mine included.

Yes, that's indeed a very big file. Way too big to attach anywhere, I
think. Files attached to this mailing list are usually stripped off, no
matter what size they are, so if you want someone to have a look at them,
you need to upload them somewhere and provide a link to them.

If you can't open a file just because there's a file in the same folder
with its name ending with ”.lock”, just remove that file and try again.
That file is there to prevent someone else to open the file in edit mode
when it's already opened by someone else. If Apache OpenOffice crash during
editing, the lock file is probably not removed automatically, therefore you
need to remove it manually.

However, you should be able to open the USB version, since there is
probably no lock file on it…



Kind regards

Johnny Rosenberg



>
> I also have the same file on the computer -I made a copy of the usb, but I
> am unable to open it.
> regards
> Heather
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Shrink text in OO4

[Johnny Rosenberg]

2016-07-16 17:41 GMT+02:00 :

> Hi,
>
> I need to shrink a section of text, in OpenOffice 4 writer, so it shows
> very small but can still be read by the computer. Can you tell me how to
> do this (if it can be done)?


Just edit the font size of the style associated with that section of text.
If no style is associated with only that section of text, create a new one
and associate it with that text.


>
> Many thanks
>
> Keith Edwards

Re: Downloading EXCEL files into Open Office

[Johnny Rosenberg]

2016-07-11 22:08 GMT+02:00 Mark Wallendjack :

> When download EXCEL files, they don't recognize my Open Office spreadsheet
> program.


Spreadsheet files don't recognise anything, they are just files. Apache
OpenOffice however, recognise certain file types, Excel files are among
those. Also your operating system recognise them, if you set it up
properly. I don't know how to do that in your operating system since I
don't know which one you have, but I'm sure it's very easy.



>   Is there a way to do that?  I certainly don't want to buy Microsoft
> Office for the privilege!
>
>
> Thanks - a new Open office user.
>
>
> Mark
>

Re: Sort Sequence in Calc

[Johnny Rosenberg]

2016-05-28 18:32 GMT+02:00 Peter Hillier-Brook :

> On 28/05/16 16:43, Vince wrote:
> > AOO 4.1.2 on WIN8.1 desktop
> > __
> >
> > I am trying to organize the many passwords that I use when accessing the
> > computer and the internet, etc. My goal is simply to have a paper copy
> > of the various passwords for storage is a secure location and I will
> > probably also store the AOO Calc .ods file on a flash drive. .  (I am
> > also wondering if I should be using AOO Base instead of Calc?)
>
> I suggest that you *should* be using Password Safe. It can be found here:
>
> https://github.com/pwsafe/pwsafe/releases/tag/3.38.2


And there are tons of alternatives as well. I use KeePassX (GPL v2) on my
PC (Ubuntu) and KeePassDroid on my phone (Android). They seem to work well
together.
A few more listed here:
https://en.wikipedia.org/wiki/List_of_password_managers



>
> I've been using it for 10 years on WinXP, Win 7; Win10 and various Linux
> flavours without problems.
>
> Peter HB
>
>

Re: written in stone

[Johnny Rosenberg]

2016-05-22 5:08 GMT+02:00 Doug <dmcgarr...@optonline.net>:

>
> On 05/21/2016 08:40 PM, Ron Patterson wrote:
>
>> Brian  -  problem solved - albeit not the way you would like - but now
>> you can sleep nights.
>>
>> I simply opened a new spreadsheet and copied columns A thru E to it but
>> not the problem column F.  Then I deleted the old spread sheet.  Viola.
>>
>> Thanks for all your help.
>>
>> 
>
> A viola is a fat fiddle. What you really want is voilà!  Don't forget the
> exclamation point!


And, just like the correct example above, no space before the exclamation
mark! The same goes for question marks and all the other things, like colon
and whatever.
Some people have Viola as their first name, by the way.


Kind regards

Johnny Rosenberg



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

Re: [Grid lines in Calc]

[Johnny Rosenberg]

2016-05-04 19:23 GMT+02:00 Girvin R. Herr <gherr...@sbcglobal.net>:

>
>
> On 05/03/2016 08:53 PM, Brian Barker wrote:
>
>> At 21:42 03/05/2016 -0400, John Caruso wrote:
>>
>>> I have given up on OO because I could not get grid lines in Calc 4.1.2,
>>> I found an old copy of office10 and installed it and now I get grid lines
>>> in Excel with no problem
>>>
>>
>> I'm not sure what you mean by "office10": is that version 10.0 of
>> Microsoft Office, i.e. Microsoft Office XP? Or perhaps you mean Microsoft
>> Office 2010? But no matter.
>>
>> I'm always amused when people write to the Users list to say that cannot
>> use the product. It is perhaps understandable that you should find some
>> difficulty or other, but choosing to advertise to thousands of generally
>> satisfied users that you are unable to make the product do what you need
>> seems somewhat weird.
>>
>> Grid lines show by default in Open Office spreadsheets, so readers will
>> wonder what you are doing wrong. If they don't show, you can restore them
>> at Tools | Options... | OpenOffice Calc | View | Visual aids | Grid lines.
>> If you see new documents as not displaying the grid. you must be using a
>> template - perhaps even a default template - which has display of the grid
>> disabled.
>>
>> Note that the purpose of the grid is to guide the eye in the editing
>> window: it does not appear in the printed output as it is not intended for
>> that purpose. If you want spreadsheet cells to be outlined in the printed
>> output, you need to format your cells to have *borders*. You can do this
>> very flexibly on the Borders tab of the Format Cells dialogue (or using the
>> Borders button in the Formatting toolbar). In general, you will want to be
>> very selective about which cells have which arrangement of borders set to
>> what style and colour. But it is possible to mimic the grid (if that is
>> what you need) by setting similar borders to all cells: simply select all
>> cells before you do this, using Edit | Select All (or Ctrl+A) or by
>> clicking the rectangle at the top left, where the row and column headers
>> meet.
>>
>> Incidentally, you have again hijacked an existing thread by creating your
>> message as a reply to it when it was nothing of the sort (and without even
>> changing the Subject header). As I mentioned before, this is not only
>> discourteous to others but is also unhelpful to you: your message will be
>> buried in the existing thread and may well not be seen by anyone not
>> interested in the earlier topic.
>>
>> I trust this helps.
>>
>> Brian Barker
>>
>>
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>>
>>
>> Brian,
> You forgot the file global print grid option:
>
>Format | Page | Sheet and check the Print | Grid box
>
> That will print the grid on all rows that contain data.  That is, it will
> stop on the last row and column without any data.  I use it all the time
> when I want the grid printed, which is more often than not.  When I need
> more empty gridded cells on the page, I insert a period "." in a cell in
> the last row I want the grid on.


Won't a space character work? Or at least something like =" "?


Kind regards

Johnny Rosenberg



> That is not very noticeable when printed and it does the job.
> HTH
> Girvin Herr
>
>

Re: Change read only files to allow me to edit and save revisions

[Johnny Rosenberg]

2016-04-22 21:49 GMT+02:00 Maurice Howe <mauriceh...@gmail.com>:

> Aren't we overcomplicating things?
>
> Couldn't you simply OPEN and SAVE files under new names anywhere you'd like
> in your file structure (desktop, etc)?  Then you can edit THOSE versions as
> if you had authored them.
>

I don't think he mentioned how many the files are. I just assumed there
were at least a couple of hundred or something. Maybe I was totally wrong
there.


>
> Maurice
>
> On Fri, Apr 22, 2016 at 2:53 PM, Eldon Fredericks <fre...@purdue.edu>
> wrote:
>
> > Should have described operating system. I’m using a mac with os x 10.11.4
> > (el Capitan). Any suggestions? The files were created with the Seagate
> > drive connected directly to my laptop. Now I have the Seagate connected
> to
> > the router so I can get at the files from both my laptop and my iMac.
> >
> > Thanks,
> > freder
> >
> > > On Apr 22, 2016, at 1:06 PM, Johnny Rosenberg <gurus.knu...@gmail.com>
> > wrote:
> > >
> > > 2016-04-22 18:47 GMT+02:00 Eldon Fredericks <fre...@purdue.edu>:
> > >
> > >> I have a whole bunch of files, both Open Office Writer and Open Office
> > >> Calc files created by me and stored on a Seagate drive connected to my
> > >> wireless router.
> > >>
> > >> I can see those files and I can retrieve them but I cannot modify nor
> > save
> > >> them.
> > >>
> > >> Is there a way to modify read only files to allow editing and saving?
> > >>
> > >
> > > Depends on why you can't modify them and what operating system you are
> > > running. If those files belongs to a different user (root, for
> instance),
> > > then you probably wouldn't be able to open them at all, unless you have
> > > group read rights. If, for some reason, your files doesn't have any
> write
> > > rights, the same problem will occur. This is easily fixed for all your
> > > files with a one-liner in Bash, if you are on Linux or similar, using a
> > > combination of find and chmod. For instance by looking for all files
> in a
> > > certain directory (and sub directories) named (using regular
> expressions)
> > > ”.*\.od[st]”, and change their permissions with chmod +w.
> > >
> > > And don't forget to do the same on your backup to AFTER you made sure
> > your
> > > one-liner actually works…
> > >
> > >
> > >
> > > Kind regards
> > >
> > > Johnny Rosenberg
> > >
> > >
> > >
> > >>
> > >> Thanks for any help.
> > >>
> > >> freder
> > >>
> > >>
> > >> -
> > >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> > >> For additional commands, e-mail: users-h...@openoffice.apache.org
> > >>
> > >>
> >
> >
> > -
> > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> > For additional commands, e-mail: users-h...@openoffice.apache.org
> >
> >
>

Re: Change read only files to allow me to edit and save revisions

[Johnny Rosenberg]

2016-04-22 20:53 GMT+02:00 Eldon Fredericks <fre...@purdue.edu>:

> Should have described operating system. I’m using a mac with os x 10.11.4
> (el Capitan). Any suggestions? The files were created with the Seagate
> drive connected directly to my laptop. Now I have the Seagate connected to
> the router so I can get at the files from both my laptop and my iMac.
>

Do you have the same problem from both your laptop and your iMac?

And by the way, iMac has Bash, doesn't it?


>
> Thanks,
> freder
>
> > On Apr 22, 2016, at 1:06 PM, Johnny Rosenberg <gurus.knu...@gmail.com>
> wrote:
> >
> > 2016-04-22 18:47 GMT+02:00 Eldon Fredericks <fre...@purdue.edu>:
> >
> >> I have a whole bunch of files, both Open Office Writer and Open Office
> >> Calc files created by me and stored on a Seagate drive connected to my
> >> wireless router.
> >>
> >> I can see those files and I can retrieve them but I cannot modify nor
> save
> >> them.
> >>
> >> Is there a way to modify read only files to allow editing and saving?
> >>
> >
> > Depends on why you can't modify them and what operating system you are
> > running. If those files belongs to a different user (root, for instance),
> > then you probably wouldn't be able to open them at all, unless you have
> > group read rights. If, for some reason, your files doesn't have any write
> > rights, the same problem will occur. This is easily fixed for all your
> > files with a one-liner in Bash, if you are on Linux or similar, using a
> > combination of find and chmod. For instance by looking for all files in a
> > certain directory (and sub directories) named (using regular expressions)
> > ”.*\.od[st]”, and change their permissions with chmod +w.
> >
> > And don't forget to do the same on your backup to AFTER you made sure
> your
> > one-liner actually works…
> >
> >
> >
> > Kind regards
> >
> > Johnny Rosenberg
> >
> >
> >
> >>
> >> Thanks for any help.
> >>
> >> freder
> >>
> >>
> >> -
> >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> >> For additional commands, e-mail: users-h...@openoffice.apache.org
> >>
> >>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Change read only files to allow me to edit and save revisions

[Johnny Rosenberg]

2016-04-22 18:47 GMT+02:00 Eldon Fredericks <fre...@purdue.edu>:

> I have a whole bunch of files, both Open Office Writer and Open Office
> Calc files created by me and stored on a Seagate drive connected to my
> wireless router.
>
> I can see those files and I can retrieve them but I cannot modify nor save
> them.
>
> Is there a way to modify read only files to allow editing and saving?
>

Depends on why you can't modify them and what operating system you are
running. If those files belongs to a different user (root, for instance),
then you probably wouldn't be able to open them at all, unless you have
group read rights. If, for some reason, your files doesn't have any write
rights, the same problem will occur. This is easily fixed for all your
files with a one-liner in Bash, if you are on Linux or similar, using a
combination of find and chmod. For instance by looking for all files in a
certain directory (and sub directories) named (using regular expressions)
”.*\.od[st]”, and change their permissions with chmod +w.

And don't forget to do the same on your backup to AFTER you made sure your
one-liner actually works…



Kind regards

Johnny Rosenberg



>
> Thanks for any help.
>
> freder
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Default behaviour with links to other documents

[Johnny Rosenberg]

2016-04-16 21:36 GMT+02:00 Andrea Pescetti <pesce...@apache.org>:

> Johnny Rosenberg wrote:
>
>> 2016-04-16 10:05 GMT+02:00 Andrea Pescetti:
>>
>>> It is not ignored but, due to the possible security implications, it has
>>> no effect unless you also lower the security level (which is improperly
>>> called "Macro security level" but is more comprehensive). Yes, this
>>> should
>>> be documented better...
>>>
>> Which security level is the highest that don't ignore that setting?
>>
>
> As it is implemented now, the minimum level. See
> https://bz.apache.org/ooo/show_bug.cgi?id=126641#c3
> (same link Dennis posted).


Oh, sorry. My bad.

Thanks.


Kind regards

Johnny Rosenberg



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

Re: Default behaviour with links to other documents

[Johnny Rosenberg]

2016-04-16 10:05 GMT+02:00 Andrea Pescetti <pesce...@apache.org>:

> Johnny Rosenberg wrote:
>
>> But why is ”Always” ignored? Wouldn't it be better to let ”On demand” be
>> the default option? At least I think so. If an options is ignored, it
>> should either be corrected or removed.
>>
>
> It is not ignored but, due to the possible security implications, it has
> no effect unless you also lower the security level (which is improperly
> called "Macro security level" but is more comprehensive). Yes, this should
> be documented better...
>

Which security level is the highest that don't ignore that setting?


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

Re: Default behaviour with links to other documents

[Johnny Rosenberg]

2016-04-15 1:42 GMT+02:00 Dennis E. Hamilton <dennis.hamil...@acm.org>:

> This behavior is a result of a security-vulnerability mitigation that was
> introduced in Apache OpenOffice 4.1.2.  See
> <http://www.openoffice.org/security/cves/CVE-2015-4551.html>.
>
> The remedy that was used is not very nuanced.  I believe that the Tools >
> Options > OpenOffice Calc > General > Updating options are ignored and "On
> request" is performed instead of "Always."
>
> You can verify that.
>

Yes, Always was ticked in my case, but it was ignored. I selected Never and
I got rid of the dialogue, however with links not updated… at least better
than before. I suppose I can update them manually when needed, right?
But why is ”Always” ignored? Wouldn't it be better to let ”On demand” be
the default option? At least I think so. If an options is ignored, it
should either be corrected or removed.





>
> See Bugzilla Issue 126641,
> <https://bz.apache.org/ooo/show_bug.cgi?id=126641>.
>
> If you are careful to use the workaround only when working with
> spreadsheets of your own creation and not obtained from others, the
> adjustment that Andrea Pescetti describes might work for you, even though
> it talks about macros.  Try it.
>

I'll have a look at it. And yes, almost everything spreadsheet are made by
me for me and nobody else, and hopefully I know what I'm doing…


Kind regards

Johnny Rosenberg



>
> With regard to the notification about whether updating from links was
> successful or not, we probably would require that to be there, simply
> because it is the only way someone might see that unexpected link updating
> is happening when part of a covert action.  That should be treated as a
> separate issue for further consideration.  That is not going to happen so
> easily.
>
>  - Dennis
>
> > -Original Message-
> > From: Johnny Rosenberg [mailto:gurus.knu...@gmail.com]
> > Sent: Thursday, April 14, 2016 14:56
> > To: users@openoffice.apache.org
> > Subject: Default behaviour with links to other documents
> >
> > I have a few spreadsheet documents that contain one or more links to
> > other
> > documents. Every time I open them I get the very annoying question about
> > whether I want the links to be updated or not.
> >
> > Is there a way I can set a default behaviour for that? I mean the
> > current
> > behaviour seems to be ”ask the user”, and I want it do be either ”yes”
> > or
> > ”no”, just so I don't need to get annoyed by that irritating dialogue
> > every
> > time I open such a document (which I do daily).
> >
> > And if I select ”yes” or ”no” as default behaviour, I don't want to see
> > any
> > dialogue windows about it at all from there on. No ”Your links were
> > updated
> > successfully”, nor ”Your links were not updated”.
> >
> >
> > Kind regards
> >
> > Johnsenberg
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Default behaviour with links to other documents

[Johnny Rosenberg]

I have a few spreadsheet documents that contain one or more links to other
documents. Every time I open them I get the very annoying question about
whether I want the links to be updated or not.

Is there a way I can set a default behaviour for that? I mean the current
behaviour seems to be ”ask the user”, and I want it do be either ”yes” or
”no”, just so I don't need to get annoyed by that irritating dialogue every
time I open such a document (which I do daily).

And if I select ”yes” or ”no” as default behaviour, I don't want to see any
dialogue windows about it at all from there on. No ”Your links were updated
successfully”, nor ”Your links were not updated”.


Kind regards

Johnny Rosenberg

Re: Deleted

[Johnny Rosenberg]

2016-03-02 9:24 GMT+01:00 Whitney Hinshelwood <
whitneyhinshelw...@hotmail.com>:

>
> Hello
>
> Open office was deleted off my MacBook so it deleted documents ending in
> odt
>
> Is there anyway of me getting those documents back?
>

If they really are gone, just restore them from your daily backup.


Kind regards

Johnny Rosenberg



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

Re: Using templates in OpenOffice calc

[Johnny Rosenberg]

2016-02-04 16:31 GMT+01:00 Brian Barker :

> At 13:39 04/02/2016 +, Clair Sutton wrote:
>
>> I use OpenOfficeCalc to do my accounts work and have just realised I can
>> make a template to use, from year to year, instead of copying last year's
>> and emptying it of the old data (Yep, that is what I used to do!).
>>
>> However, I noticed that the Calc documents I made for this year's
>> accounts, from the templates, don't appear as the other ones do. The
>> document seems the same when I get into it, but, in the list of documents
>> in the folder, the other ones have the 'page with seagulls on it' icon and
>> the name, and the new ones I just made using the template have a 'blank
>> page with corner missing' icon and the name and when I double click on it I
>> have to choose which program I want to open it with. (Then when I choose
>> Calc it opens ok, but the dialog box has a 'tickbox' in it which I can
>> usually choose to 'Always Open with this' and this doesn't work either -
>> like, I can't tick it).
>>
>> I am presuming that I've done something wrong, but since I know very
>> little about spreadsheets (you may have guessed) I wondered if you could
>> tell me how I can fix it please?
>>
>
> I think this is fairly straightforward, and that the problem has nothing
> to do with your practice of (sensibly) using a template. It may have
> started at around that time by coincidence. (And you get a Brownie Point
> for your clear explanation of the problem!)
>
> OpenOffice has a strange option in the Save As... dialogue box. Near the
> bottom, you will see an "Automatic file name extension" tick box. Has this
> become unticked? If it has, you will be saving documents in the correct
> format, but the file names will not be getting the proper extension. So a
> spreadsheet document will be called just "name" rather than "name.ods".
> Without the extension, your operating system - apparently Windows - will
> not know what application to invoke by default if you double-click the
> document icon to open the document.


I think this only happens in Windows. Most other operating systems don't
care much for the extension. I just tried this in a non-windows
environment. I copied an ods file and put the copy in the same folder as
the original, but without the .ods extension. Both files had the same icon
and both files opened without any questions with Apache OpenOffice. A few
years back I did a similar experiment. I don't remember exactly what I did,
but either I changed the extension of an mp3 file to .jpeg or maybe I did
the other way around. Still the right program opened the file. As far as I
know, ONLY Windows gets confused when the file extension is wrong or not
there at all. I don't know about Mac though, since I never had one.

Anyway, this aside, I agree that this could be the problem for the OP,
since the OP actually said he was using Windows.


> This means that it will not know what icon to use and will display a
> default icon instead. It also means that if you challenge Windows to open
> the document by double-clicking the icon, it will ask you to select your
> chosen application. The "always use" option allows you to associate a file
> extension with an application on the fly, but this will be greyed out
> precisely because there is no such extension present.
>
> The solution is very easy: just tick that box in the Save As... dialogue.
> Once you have done this, your choice will stick - just as the absence of a
> tick has stuck, causing you the current problem. For existing files, you
> can either rename them to add the .ods extension or else simply save the
> documents (even under the same name) with the option ticked. The rogue
> copies can then be deleted, of course.
>
> I trust this helps.
>
> Brian Barker
>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: "Crashes"

[Johnny Rosenberg]

2016-01-19 12:25 GMT+01:00 Lennart Olsson <lennartolsso...@gmail.com>:

> Hello,
>
> I am so tired of all these frequently happening crashes on my Open Office.
> They happen repeatedly every week and when I press the button for restoring
> the files, the message says that they are restored and I press 'Continue'
> and when I want to open the file, the same thing happens over and over
> again.
>
> Moreover, it usually takes an unnaturally long time to open the programme.
> Is it on the net? I thought it was in my personal lap top, but then it
> should not take such time, should it?
>

As far as I know, it shouldn't, but it does for me too. Opening Apache
OpenOffice Calc takes approximately 10-15 s (!) on my system: 16 GB RAM,
Intel i7, Ubuntu 14.04.

On my system, Apache OpenOffice almost always crash when I do something
with the styles window open.


Kind regards

Johnny Rosenberg



>
>
>
> Regards,
>
> Mr. Lennart Olsson
> Skogsvägen 3,
> SE-912 31  VILHELMINA
> Sweden
> <lennartolsso...@gmail.com>
>

Re: Open Office 4 text problem

[Johnny Rosenberg]

2016-01-10 16:49 GMT+01:00 Roy Noble :

> I was typing up a document on your word program and suddenly without my
> realization of deleting the text, it all disappeared.


What disappeared? Only the text or the whole window? Or something else?

I assume you are running Apache OpenOffice Writer, as you say ”word
program”, which perhaps refers to MS Office Word. Writer is however not an
MS Word clone or anything like that.
It's also not ”our” program. I'm just a user like you, so this list is just
people using Apache OpenOffice, helping each other out; it's not like
professional support or something.
Just saying, in case you don't know.


> This has happened to me maybe 3 times over a period of time.

I am not able to undo this change and get my text back. Please send me a
> possible solution to this problem that keeps occurring.
>

Do the file still exist? If so, what size is it?


>
> ---
> This email has been checked for viruses by Avast antivirus software.
> http://www.avast.com
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: reader problem

[Johnny Rosenberg]

2016-01-08 5:33 GMT+01:00 scdale :

> I am exhausted trying to fix a problem.
> I downloaded and installed Open Office 4.1.2.  I wanted it not just for
> word processing but the major reason was to open my documents etc.
> It doesn’t.  Word Pad does or any of the other two on the list.  I simply
> CANNOT ADD OPEN OFFICE TO THE LIST IN ORDER TO HAVE IT OPEN MY DOCUMENTS.
>

Your operating system is supposed to take care of that, not Apache
OpenOffice, so ask on a forum for your operating system. Seems to be some
flavour of Windows, so I can't answer it, otherwise I would.

However, when you ran Apache OpenOffice for the first time, I think you
should have been asked if you want Apache OpenOffice to be your default
program for your documents. That could have solved your problem, I guess.
Or maybe not.

What kinds of documents are you trying to open? Maybe Apache OpenOffice
just can't handle them? Suffixes like .ods, .odt, .doc, .xls and so on
should be no problems, but maybe you are trying to open other kinds of
documents?


> I have gone to the default area and that doesn’t make it open them either
> by default.
> I have worked for about 7 hours reading everything I can find on the
> computer.  Any forums concerning Open Office DOES NOT ANSWER THIS
> QUESTION.  PERIOD.
>
> Can you please help?
> Thanks,
> Diana

Re: Crash when trying to create a new style

[Johnny Rosenberg]

2016-01-03 23:14 GMT+01:00 Matthias Seidel <matthias.sei...@hamburg.de>:

> You mean you installed OpenOffice with their DEBS, aren't you?
> After you uninstalled LibreOffice with:
>
> sudo apt-get remove --purge libreoffice*
> sudo apt-get clean
> sudo apt-get autoremove
>

I think I just did sudo apt-get purge libreoffice*, but it was a long time
ago, when Ubuntu 14.04 was the latest Ubuntu release, so I really don't
remember.


>
> I also did a fresh start and "new file" in CALC, no crash...
> I use the german version (32 bit) but I doubt that it is dependend on the
> language.
>
> As for MS fonts, I have installed "ttf-mscorefonts-installer" from Ubuntu
> Software-Center.
>

I don't think I did that this time, since I never use those fonts anyway,
but I don't remember for sure.



Kind regards

Johnny Rosenberg



>
> kind regards
>
> Matthias
>
>
>
> Am 03.01.2016 um 19:20 schrieb Johnny Rosenberg:
>
>> 2016-01-03 16:51 GMT+01:00 Matthias Seidel <matthias.sei...@hamburg.de>:
>>
>> Hello Johnny,
>>>
>>> I can't reproduce your crash.
>>> I am on Ubuntu 14.04 (32bit). Did you uninstall LibreOffice before
>>> installing OpenOffice?
>>>
>>>
>> Yes, I did, and then I installed LibreOffice with their DEBS. I tested the
>> same thing in LibreOffice 4.2.6.3 (I installed it a long time ago…),
>> without a crash. However, when working with a particular document, which
>> was converted from an XLS file, containing some MS fonts like Arial Narrow
>> that my current system lacks, I can't edit existing styles. If I right
>> click one and select Edit, nothing happens (in neither Apache OpenOffice
>> nor LibreOffice). If I create a new spreadsheet, I can edit styles. Maybe
>> something wrong with some of my files then…
>>
>> I'll install the latest stable LibreOffice and see what happens.
>>
>> Still, the original problem happens after a fresh start of the operating
>> system and Apache OpenOffice with a ”new file”, so everything doesn't seem
>> to be my file's fault…
>>
>>
>> Kind regards
>>
>> Johnny Rosenberg
>>
>>
>>
>> kind regards, Matthias
>>>
>>>
>>>
>>> Am 03.01.2016 um 16:33 schrieb Johnny Rosenberg:
>>>
>>> Apache OpenOffice 4.1.2 installed with the DEB files downloaded from
>>>> http://www.openoffice.org/download/index.html. I installed it a few
>>>> days
>>>> ago, so it should be the latest version.
>>>> Operating system: Ubuntu 14.04
>>>>
>>>> How to make it crash:
>>>> 1. Start your operating system.
>>>> 2. Rename ”~/.openoffice/4/user” to ”~/.openoffice/4/user.old” (or
>>>> don't,
>>>> in my case it didn't matter at all)
>>>> 3. Open Apache OpenOffice 4.1.2 (4.1.1 will also do, I had the same
>>>> problem
>>>> with it)
>>>> 4. Select Apache OpenOffice Calc (I don't know if Writer has the same
>>>> problem, I almost never run anything else than Calc)
>>>> 5. Hit F11 to open the stylist.
>>>> 6. Right click a paragraph style, select New.
>>>> 7. Apache OpenOffice crash.
>>>> 8. Undo step 2 if you like.
>>>>
>>>> Am I the only one with this problem? If so, where do I start looking for
>>>> what's causing this problem?
>>>>
>>>>
>>>> Kind regards
>>>>
>>>> Johnny Rosenberg
>>>>
>>>>
>>>>
>>>
>>
>

Crash when trying to create a new style

[Johnny Rosenberg]

Apache OpenOffice 4.1.2 installed with the DEB files downloaded from
http://www.openoffice.org/download/index.html. I installed it a few days
ago, so it should be the latest version.
Operating system: Ubuntu 14.04

How to make it crash:
1. Start your operating system.
2. Rename ”~/.openoffice/4/user” to ”~/.openoffice/4/user.old” (or don't,
in my case it didn't matter at all)
3. Open Apache OpenOffice 4.1.2 (4.1.1 will also do, I had the same problem
with it)
4. Select Apache OpenOffice Calc (I don't know if Writer has the same
problem, I almost never run anything else than Calc)
5. Hit F11 to open the stylist.
6. Right click a paragraph style, select New.
7. Apache OpenOffice crash.
8. Undo step 2 if you like.

Am I the only one with this problem? If so, where do I start looking for
what's causing this problem?


Kind regards

Johnny Rosenberg

Re: Crash when trying to create a new style

[Johnny Rosenberg]

2016-01-03 16:51 GMT+01:00 Matthias Seidel <matthias.sei...@hamburg.de>:

> Hello Johnny,
>
> I can't reproduce your crash.
> I am on Ubuntu 14.04 (32bit). Did you uninstall LibreOffice before
> installing OpenOffice?
>

Yes, I did, and then I installed LibreOffice with their DEBS. I tested the
same thing in LibreOffice 4.2.6.3 (I installed it a long time ago…),
without a crash. However, when working with a particular document, which
was converted from an XLS file, containing some MS fonts like Arial Narrow
that my current system lacks, I can't edit existing styles. If I right
click one and select Edit, nothing happens (in neither Apache OpenOffice
nor LibreOffice). If I create a new spreadsheet, I can edit styles. Maybe
something wrong with some of my files then…

I'll install the latest stable LibreOffice and see what happens.

Still, the original problem happens after a fresh start of the operating
system and Apache OpenOffice with a ”new file”, so everything doesn't seem
to be my file's fault…


Kind regards

Johnny Rosenberg



> kind regards, Matthias
>
>
>
> Am 03.01.2016 um 16:33 schrieb Johnny Rosenberg:
>
>> Apache OpenOffice 4.1.2 installed with the DEB files downloaded from
>> http://www.openoffice.org/download/index.html. I installed it a few days
>> ago, so it should be the latest version.
>> Operating system: Ubuntu 14.04
>>
>> How to make it crash:
>> 1. Start your operating system.
>> 2. Rename ”~/.openoffice/4/user” to ”~/.openoffice/4/user.old” (or don't,
>> in my case it didn't matter at all)
>> 3. Open Apache OpenOffice 4.1.2 (4.1.1 will also do, I had the same
>> problem
>> with it)
>> 4. Select Apache OpenOffice Calc (I don't know if Writer has the same
>> problem, I almost never run anything else than Calc)
>> 5. Hit F11 to open the stylist.
>> 6. Right click a paragraph style, select New.
>> 7. Apache OpenOffice crash.
>> 8. Undo step 2 if you like.
>>
>> Am I the only one with this problem? If so, where do I start looking for
>> what's causing this problem?
>>
>>
>> Kind regards
>>
>> Johnny Rosenberg
>>
>>
>

Re: My Preference For Version 3.4.1 of OpenOffice

[Johnny Rosenberg]

2015-12-29 21:19 GMT+01:00 Anthony Roske <anthonyro...@yahoo.co.uk>:

> … … …

I have therefore reverted to version 3.4.1 which does not have this
> "problem". Furthermore this version has an constant SUM function at the
> bottom of the screen which automatically  shows the total of whichever
> cells have been selected. I find this very useful.
>

I also find that useful. I use it all the time – with Apache OpenOffice
4.1.1. It's located at the left side of the zoom bar, I think it's the same
position as in 3.4.1, so I'm not sure you didn't seem to have it. Also, if
I right click the SUM field, I can select other things, like Maximum value,
Minimum value, Average and so on.

Kind regards

Johnny Rosenberg



> I will watch for future versions to see if the above have been remedied.
> A. Roske

Re: Multi-page tiff to PDF conversion

[Johnny Rosenberg]

2015-12-18 21:55 GMT+01:00 Prabhakaran Subramanian <
prabhakaran.subraman...@gmail.com>:

> Hi,
>
> If Open Office supports Multi-page tiff to PDF conversion?
> I just read some articles and it shows it was not supported.
>
> Thanks,
> PS.
>

Apache OpenOffice is probably not designed to do such tasks, but there are
other applications out there that are. If using the command line isn't a
problem, there is tiff2pdf.
Install it easily on the following operating systems as root.

Debian or Ubuntu:
apt-get install ghostscript libtiff-tools

CentOs or Red Hat:
yum install ghostscript libtiff

Fedora:
yum install ghostscript libtiff-tools

Convert input.tiff to output.pdf:
tiff2pdf -o output.pdf input.tiff

More information:
man tiff2pdf



Kind regards

Johnny Rosenberg

Re: Loading a dialogue

[Johnny Rosenberg]

2015-12-06 19:51 GMT+01:00 Oliver Brinzing <oliver.brinz...@gmx.de>:

> Hi Johnny,
>
> > Is it only me or does Apache OpenOffice always crash when trying to
> import
> > a dialogue from a .dlg file (which was created by Apache OpenOffice)?
>
> i cannot confirm a crash with aoo 4.1 (win 10pro 64bit)
>
> Regards
> Oliver
>
>
Ok, thanks. Maybe something else that causes this, then. I'm going to
install another operating system soon, maybe that will solve the problem.

Also, Apache OpenOffice crash when I remove a style, does that too only
happen to me? Again, using 4.1.1.


Regards

Johnny Rosenberg


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

Loading a dialogue

[Johnny Rosenberg]

Is it only me or does Apache OpenOffice always crash when trying to import
a dialogue from a .dlg file (which was created by Apache OpenOffice)?

Apache OpenOffice crash when I try that, every time. Does that happen to
you too? If so, I might just report it…

I have Apache OpenOffice 4.1.1 (since I can't install anything on my
computer at the moment, due to some depency troubles which I won't fix
since I'm going to install another operating system soon anyway), so I
would like to know if this problem also exists in 4.1.2.


Kind regards

Johnny Rosenberg

Re: PDF editing

[Johnny Rosenberg]

2015-12-01 0:28 GMT+01:00 Julian Thomas <j...@jt-mj.net>:

> Some PDF's seem to have fields that can be filled in by the user - this is
> useful for filling in various forms.
>

Yes, it is. I do that all the time with Evince. Works great if the PDF is
correctly made.


>
> The all purpose Preview in OS X will do this as well as act as a mean and
> lean replacement for Acrobat Reader for viewing PDF's.
>

You are probably right there too. So it works just like Evince then, I
suppose.

So why are you writing? You forgot to ask a question… :)


Kind regards

Johnny Rosenberg



>  —
> jt - j...@jt-mj.net
>
> Even the Magic 8 ball has an opinion on email clients: Outlook not so good.
>
>
>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>