Ubuntu
openoffice.org package

calc sumproduct

Asked by jojo

I tried to use the "sumproduct"/"sum" function in my calc but it does not recognize it,
It recognize just "SUMMENPRODUKT" and "summe".
What can be the reason?

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:

This question was reopened

  • by jojo
Revision history for this message
Jesus Gamio (jgamio) said : 		#1

If you use open office is because you default language is another than English

Revision history for this message
jojo (goldjo) said : 		#2

I use the hebrew language as defult.
In the help I see all the function correct, the problems is just when I'm trying to use them.
What do I have to do to solve it?

Revision history for this message
Jesus Gamio (jgamio) said : 		#3

Ok
I you go to Tools-> Options ->Languages

Changes User Interface to English is going to works sum
Local Setting in your languages to keep spelling and anothers things.

Revision history for this message
jojo (goldjo) said : 		#4

You are right.
Thank you

Is there any option to save the menu in my local language while the functions are normal (sum and not summe)?

Revision history for this message
Jesus Gamio (jgamio) said : 		#5

I am not sure but I don't think because User Interface mean all the user environment.

if you need change this to it changes the functions names you are changing the menus too.

Can you help with this problem?

Provide an answer of your own, or ask jojo for more information if necessary.

To post a message you must log in.