How is the sum of a highlighted column inserted?

2013-06-05 Thread John Hart
In Quatro-Pro there was an icon to put a column sum formula in the last 
highlighted cell.
The Calc help file says to click on the summation Icon only there isn't 
one on the toolbar and I couldn't find a way to insert it.




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



Re: How is the sum of a highlighted column inserted?

2013-06-05 Thread Regina Henschel

Hi John,

John Hart schrieb:

In Quatro-Pro there was an icon to put a column sum formula in the last
highlighted cell.
The Calc help file says to click on the summation Icon only there isn't
one on the toolbar and I couldn't find a way to insert it.


It is not in the toolbar, but left of the input line. You must have 
finished your input. Then there should be:

/Name Box/  fx  Σ   =   /Input line/

Kind regards
Regina



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



Re: [AOO 4.0]: migration of AOO 3.4.x/OOo 3.x user profile data - help needed

2013-06-05 Thread Oliver-Rainer Wittmann

Hi Hans Zybura,

On 04.06.2013 19:26, Hans Zybura wrote:

Hi, comments inline...

Crosspost to the api mailing list for a reason.

Regards, Hans Zybura


-Original Message- From: Oliver-Rainer Wittmann
[mailto:orwittm...@googlemail.com] Sent: Monday, June 03, 2013
10:47 AM To: d...@openoffice.apache.org Subject: Re: [AOO 4.0]:
migration of AOO 3.4.x/OOo 3.x user profile data - help needed

Hi,

small wrap-up at the top: - nobody prefers to migrate extensions
from AOO 3.4.x resp. OOo 3.x


A couple of month ago there was a heated dispute about introducing
incompatible changes for extensions in the addons.xcu (for negligible
benefit). One of the arguments meant to silence the critics was:
Well, it's no problem because we have an update mechanism for
extensions. I expressed doubts if the update mechanism would work.
Now it turns out I was wrong. I shouldn't have worried about the
update mechanism. Without migration, users will have to find and
reinstall all of their extensions anyway "by hand".



May be I should have said:
"Until now, nobody prefers to migrate extensions from AOO 3.4.x resp. 
OOo 3.x".



The current update mechanism for extensions simply looks for a newer
version of the extension by use of a link provided by the extension
developer himself. We did that for our extension, but didn't have to
make use of it until now.

OO developers decided not to take into account compatibility issues
caused by introducing incompatible changes in addons.xcu. OK, so we
have to deal with it. To prevent any trouble for our customers, we
could very likely have provided an automatic update, so that an end
user wouldn't have noticed any problem at all after a successful
migration.

Now OO developers are about to make it impossible for extension
developers to simply provide an automatic update before or after the
migration to AOO 4.0. Without migrating extensions, there is no
automatic update path anymore.

Great user experience! Great experience for extension developers and
support folks!

I remember much talk about the "eco system of AOO" on this mailing
list. Is this what the talk was about?



I tried to get involved certain people on this topic.
I had send my intial post to dev@o.a.o and users@o.a.o. Sorry, that I 
did not include api@o.a.o as I assumed that extension developers are 
looking at dev@o.a.o.


The intention of this thread was not to present facts regarding the 
development. It is meant to show on what I would like to work on for AOO 
4.0 regarding the migration of the user profile and to get feedback on 
it. (BTW, I had already started a discussion thread in January 2013 
regarding the migration of the user profile - see thread "[IMPORTANT, 
DISCUSS]: no migration/use of former user profile with AOO 4.0".)


I used terms like "I would like to ...", "My current preference is ..." 
and "I need support and help ..." - I am not presenting facts.

I explicitly ask for help for these tasks.
I got no response and no feedback from users@o.a.o. I was disappointed 
about it, because it means that nobody from users@o.a.o seems to be 
interested to help/support me. From dev@o.a.o I only got feedback about 
the risks of a user profile migration and that nobody prefers a 
migration of the extensions.


I have taken your feedback as not constructive criticsm. Your feedback 
sounds like that I decided that extensions will not be migrated. That is 
not the case.
Earlier in January I already started a similar discussion - see above 
mentioned thread. Here, no strong preferences regarding the migration of 
extensions were given.
In this thread I expressed my willingness to work on the migration of 
the user profile (which also contains the user installed extensions), 
otherwise nothing will be migrated as stated in January. As this is not 
a one-person show I asked for help and support. The only feedback I got 
was that a migration might be risky and no one has preference to migrate 
extensions.
Then I got your feedback which more or less killed my motivation to work 
on the migration of the user profile.


May be you are volunteering to support me as you seem to be interested 
in a working migration of the user profile?



Best regards, (a disappointed) Oliver.




more comments inline.

On 02.06.2013 13:17, Andrea Pescetti wrote:

On 29/05/2013 Oliver-Rainer Wittmann wrote:

On 28.05.2013 18:23, Rob Weir wrote:

Do we need to worry about the "messy" profiles that occurred
from OOo 3.3.0 upgrades to AOO 3.4.0? That was when we saw
spell checking breaking, missing dictionaries, and crashes.
One of the nice things about a "clean start" with AOO 4.0 was
that we avoid these kinds of problems.

From my point of view AOO 3.4.x users which had problems due to
a "messy" profile and had solved these problems, can migrate
their profile to AOO 4.0. AOO 3.4.x users which does not had
solved their problems are able to suppress the migration of
their existing profile - see the corresponding FirstStartWizard
page for the

openoffice.org problem

2013-06-05 Thread D . Radheshwar

I am getting the following message when I try to open a pdf file that I had 
saved on my desktop or open the program to work

either another instance of OpenOffice.org is accessing your personal setting or 
your personal settings are locked.
simultaneous access can lead to inconsistencies in your personal settings, you 
should make sure user 'dradheshwar' closes OpenOffice.org on host 
'ds-macbook-pro.home'.

do you really want to continue?

yes no

I removed the previous download of OpenOffice.org from my computer and 
installed it again. The problem persists.
How to resolve, can you help?

Many thanks.

Damu Radheshwar







Re: openoffice.org problem

2013-06-05 Thread Rory O'Farrell
On Wed, 5 Jun 2013 14:19:17 -0400
D. Radheshwar  wrote:

> 
> I am getting the following message when I try to open a pdf file that I had 
> saved on my desktop or open the program to work
> 
> either another instance of OpenOffice.org is accessing your personal setting 
> or your personal settings are locked.
> simultaneous access can lead to inconsistencies in your personal settings, 
> you should make sure user 'dradheshwar' closes OpenOffice.org on host 
> 'ds-macbook-pro.home'.
> 
> do you really want to continue?
> 
> yes   no
> 
> I removed the previous download of OpenOffice.org from my computer and 
> installed it again. The problem persists.
> How to resolve, can you help?
> 
> Many thanks.
> 
> Damu Radheshwar

With OpenOffice closed, find and delete any lock files on your computer.  These 
have a form like .~lock.fred.odt# where fred is the filename and the type will 
vary according to the OpenOffice application

I am aware that OpenOffice Draw can do minor edits to .pdf files, but it is not 
intended for major pdf file revision.  You should look for another tool if that 
is what you intend.

-- 
Rory O'Farrell 

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



Re: openoffice.org problem

2013-06-05 Thread Hagar Delest

This error message is related to your profile in fact. When a user runs AOO, 
there is a lock file in the user profile to prevent such situation.

At the root of the user profile (see 
http://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=12426 ), in the \3 
folder, there should be a .lock file. Just delete it.

Hagar


Le 05/06/2013 21:09, Rory O'Farrell a écrit :


On Wed, 5 Jun 2013 14:19:17 -0400
D. Radheshwar  wrote:



I am getting the following message when I try to open a pdf file that I had 
saved on my desktop or open the program to work

either another instance of OpenOffice.org is accessing your personal setting or 
your personal settings are locked.
simultaneous access can lead to inconsistencies in your personal settings, you 
should make sure user 'dradheshwar' closes OpenOffice.org on host 
'ds-macbook-pro.home'.

do you really want to continue?

yes no

I removed the previous download of OpenOffice.org from my computer and 
installed it again. The problem persists.
How to resolve, can you help?

Many thanks.

Damu Radheshwar


With OpenOffice closed, find and delete any lock files on your computer.  These 
have a form like .~lock.fred.odt# where fred is the filename and the type will 
vary according to the OpenOffice application

I am aware that OpenOffice Draw can do minor edits to .pdf files, but it is not 
intended for major pdf file revision.  You should look for another tool if that 
is what you intend.



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



Re: How is the sum of a highlighted column inserted?

2013-06-05 Thread John Hart

On 6/5/2013 1:42 AM, Regina Henschel wrote:


It is not in the toolbar, but left of the input line. You must have 
finished your input. Then there should be:

/Name Box/  fx  Σ   =   /Input line/

Kind regards
Regina


Thanks,





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



Openoffice Base Feature

2013-06-05 Thread TCNS Customer Service

Hi,

This information may only relate to Open Office Base software. I use it 
every day and it's the only open office application I use. It works 100% of 
the time and makes my life easier, thank you.

I didn't notice anyone mentioning it, so I wanted to write this email for 
some time. Since version 2.4.0

when you click in the record search box, search for text box the contents of 
the field are not selected. With version 2.4.0

when you open the dialog box, the contents of the field are selected. This 
makes editing easy.

I tried the newer versions, and keep going back to version 2.4.0

just because of the feature.

If you ever put back the functionality of the text box, I would like to 
support the project moving forward.

Thank you for considering it.

I also mention it in the hope you will continue to support 2.4.0.

In case you're just sitting around waiting for user feedback, one day it 
would be nice to be able to copy and paste append a record also, but I can 
imaging that's a tricky one.


Regards,
Gigi Baxter
 


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