You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Randall Whitsitt <ra...@outlook.com> on 2015/04/23 21:23:01 UTC
HELP WITH CALC
Just spent two hours on site and forums only to be convinced your web designer should be fired.
I AM ON OLD MAN who got this way with “SuperCalc” and “Excel”. Why don’t the formulas that have been used for the past 30 years work with OpenOffice Calc?
Your Lessons and tutorials are both poorly laid out and TOTALLY INADEQUATE to answer specific questions.
I want to transfer data from a cell on one page into a cell on another.
Please send me a list of valid formulas for OpenOffice Calc.
Sent from Windows Mail
Re: HELP WITH CALC
Posted by Don Daugherty <dd...@sunflower.com>.
On 4/23/2015 5:06 PM, Dave Barton wrote:
> Don Daugherty wrote:
>> On 4/23/2015 2:23 PM, Randall Whitsitt wrote:
>> I'm a young man of 79, but I'll try to answer at least one of your
>> questions.
> Another Kid! ;)
> 8<-- snip -->8
>> If the data is is in cell A3 of Page X and you want an automatic copy of
>> it in cell D19 of Page R, I'd go to Page R, cell D19 and type = X:A3.
> Hi Don,
>
> Maybe I am misreading your suggestion (not forwarded to Randall), but if
> R is say Sheet2 and I enter =Sheet2:A3 (instead of =Sheet2.A3) I get
> "#NAME?" in Sheet2 B19.
>
> Using Apache OpenOffice 4.1.1
> AOO411 m6(Build:9775) - Rev. 1617669
> 2014-08-13 09:06:54 (Mi. 13 Aug 2014)
>
> Regards
> Dave
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
Dave,
mea culpa! Of course the correct syntax is Sheet2.A3, not Sheet2:A3 !
Don
---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: HELP WITH CALC
Posted by Dave Barton <db...@tasit.net>.
Don Daugherty wrote:
> On 4/23/2015 2:23 PM, Randall Whitsitt wrote:
> I'm a young man of 79, but I'll try to answer at least one of your
> questions.
Another Kid! ;)
8<-- snip -->8
> If the data is is in cell A3 of Page X and you want an automatic copy of
> it in cell D19 of Page R, I'd go to Page R, cell D19 and type = X:A3.
Hi Don,
Maybe I am misreading your suggestion (not forwarded to Randall), but if
R is say Sheet2 and I enter =Sheet2:A3 (instead of =Sheet2.A3) I get
"#NAME?" in Sheet2 B19.
Using Apache OpenOffice 4.1.1
AOO411 m6(Build:9775) - Rev. 1617669
2014-08-13 09:06:54 (Mi. 13 Aug 2014)
Regards
Dave
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: HELP WITH CALC
Posted by Don Daugherty <dd...@sunflower.com>.
On 4/23/2015 2:23 PM, Randall Whitsitt wrote:
I'm a young man of 79, but I'll try to answer at least one of your
questions.
> Just spent two hours on site and forums only to be convinced your web designer should be fired.
I didn't pay a penny for Open Office Calc, Writer, etc. so I haven't
figured out who's paying for the web design, lessons, tutorials, etc..
> I AM ON OLD MAN who got this way with “SuperCalc” and “Excel”. Why
don’t the formulas that have been used for the past 30 years work with
>OpenOffice Calc?
I don't know what formulas you've tried, but F1 takes you to Help where
you'll find lots of them.
>I want to transfer data from a cell on one page into a cell on another.
If the data is is in cell A3 of Page X and you want an automatic copy of
it in cell D19 of Page R, I'd go to Page R, cell D19 and type = X:A3.
---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: HELP WITH CALC
Posted by Henry Rappaport <he...@hento.ca>.
RETIREMENT
Now to unlearn
Habits of unhappiness
Practiced since
Way back when.
To loose them one by one
Until what remains
Is the other side
Of then.
From Loose to the World
by Henry Rappaport
also of advanced years
H
> On Apr 23, 2015, at 12:57 PM, Johnny Rosenberg <gu...@gmail.com> wrote:
>
> 2015-04-23 21:23 GMT+02:00 Randall Whitsitt <ra...@outlook.com>:
>
>> Just spent two hours on site and forums only to be convinced your web
>> designer should be fired.
>>
>>
>> I AM ON OLD MAN who got this way with “SuperCalc” and “Excel”. Why don’t
>> the formulas that have been used for the past 30 years work with OpenOffice
>> Calc?
>>
>>
>> Your Lessons and tutorials are both poorly laid out and TOTALLY INADEQUATE
>> to answer specific questions.
>>
>>
>> I want to transfer data from a cell on one page into a cell on another.
>>
>
> Just like with Excel and other spreadsheet applications, if I understand
> your question correctly, you don't transfer cell data to other cells; it's
> the other way around. It's cell x that throw a value to cell y, it's cell y
> that looks in cell x for a value and then display it.
>
> For instance, if cell G73 on a sheet called ”DataSheet” has the value "Here
> are some nonsense text” and you want to ”transfer” that value to cell M8 on
> a sheet called ”Results”, then in M8 on ”Results”, type:
> =DataSheet!G73
> Now M8 on ”Results” will also display ”Here are some nonsense text”
>
>
>>
>>
>> Please send me a list of valid formulas for OpenOffice Calc.
>>
>
> I assume you mean cell functions. There are a lot of cell functions in
> Calc. Most of them are the same as those in Excel and other spreadsheet
> applications. I'm sure there is a list somewhere that some poor fellow
> wrote, but there is another way to view all spreadsheet functions: Just
> highlight a cell and hit Ctrl+F2. Now you can see all the available
> functions. You can view all of them or all of those in a certain category,
> for instance.
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
>
>
>
>>
>>
>>
>>
>>
>>
>> Sent from Windows Mail
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: HELP WITH CALC
Posted by Johnny Rosenberg <gu...@gmail.com>.
2015-04-23 21:57 GMT+02:00 Johnny Rosenberg <gu...@gmail.com>:
> 2015-04-23 21:23 GMT+02:00 Randall Whitsitt <ra...@outlook.com>:
>
>> Just spent two hours on site and forums only to be convinced your web
>> designer should be fired.
>>
>>
>> I AM ON OLD MAN who got this way with “SuperCalc” and “Excel”. Why
>> don’t the formulas that have been used for the past 30 years work with
>> OpenOffice Calc?
>>
>>
>> Your Lessons and tutorials are both poorly laid out and TOTALLY
>> INADEQUATE to answer specific questions.
>>
>>
>> I want to transfer data from a cell on one page into a cell on another.
>>
>
> Just like with Excel and other spreadsheet applications, if I understand
> your question correctly, you don't transfer cell data to other cells; it's
> the other way around. It's cell x that throw a value to cell y, it's cell y
> that looks in cell x for a value and then display it.
>
I was typing too fast there…
It's NOT cell x that throw a value to cell y, it's cell y that looks in
cell x for a value and then display it.
”Not” can be an important word sometimes…
Sorry for confusing.
>
> For instance, if cell G73 on a sheet called ”DataSheet” has the value
> "Here are some nonsense text” and you want to ”transfer” that value to cell
> M8 on a sheet called ”Results”, then in M8 on ”Results”, type:
> =DataSheet!G73
> Now M8 on ”Results” will also display ”Here are some nonsense text”
>
>
>>
>>
>> Please send me a list of valid formulas for OpenOffice Calc.
>>
>
> I assume you mean cell functions. There are a lot of cell functions in
> Calc. Most of them are the same as those in Excel and other spreadsheet
> applications. I'm sure there is a list somewhere that some poor fellow
> wrote, but there is another way to view all spreadsheet functions: Just
> highlight a cell and hit Ctrl+F2. Now you can see all the available
> functions. You can view all of them or all of those in a certain category,
> for instance.
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
>
>
>
>>
>>
>>
>>
>>
>>
>> Sent from Windows Mail
>
>
>
Re: HELP WITH CALC
Posted by Johnny Rosenberg <gu...@gmail.com>.
2015-04-23 21:23 GMT+02:00 Randall Whitsitt <ra...@outlook.com>:
> Just spent two hours on site and forums only to be convinced your web
> designer should be fired.
>
>
> I AM ON OLD MAN who got this way with “SuperCalc” and “Excel”. Why don’t
> the formulas that have been used for the past 30 years work with OpenOffice
> Calc?
>
>
> Your Lessons and tutorials are both poorly laid out and TOTALLY INADEQUATE
> to answer specific questions.
>
>
> I want to transfer data from a cell on one page into a cell on another.
>
Just like with Excel and other spreadsheet applications, if I understand
your question correctly, you don't transfer cell data to other cells; it's
the other way around. It's cell x that throw a value to cell y, it's cell y
that looks in cell x for a value and then display it.
For instance, if cell G73 on a sheet called ”DataSheet” has the value "Here
are some nonsense text” and you want to ”transfer” that value to cell M8 on
a sheet called ”Results”, then in M8 on ”Results”, type:
=DataSheet!G73
Now M8 on ”Results” will also display ”Here are some nonsense text”
>
>
> Please send me a list of valid formulas for OpenOffice Calc.
>
I assume you mean cell functions. There are a lot of cell functions in
Calc. Most of them are the same as those in Excel and other spreadsheet
applications. I'm sure there is a list somewhere that some poor fellow
wrote, but there is another way to view all spreadsheet functions: Just
highlight a cell and hit Ctrl+F2. Now you can see all the available
functions. You can view all of them or all of those in a certain category,
for instance.
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
>
>
>
>
>
>
> Sent from Windows Mail
Re: HELP WITH CALC
Posted by Dave Barton <db...@tasit.net>.
Hi Randall,
From one old man to another. My responses are given in-line with your
original message.
-------- Original Message --------
From: Randall Whitsitt <ra...@outlook.com>
To: Apache OpenOffice Users <us...@openoffice.apache.org>
Date: Thu, 23 Apr 2015 19:23:01 +0000
> Just spent two hours on site and forums only to be convinced your web designer should be fired.
You are entitled to your opinion and free speech is like free software,
you have the option to use it or not. However, it is a little unusual to
insult the people from who you next ask for help. This is a FOSS (Free
Open Source Software) volunteer project, not a business/corporation and
anyone replying to your request will be a user just like yourself.
> I AM ON OLD MAN who got this way with “SuperCalc” and “Excel”. Why don’t the formulas that have been used for the past 30 years work with OpenOffice Calc?
There are many possible answers to that question, but here are two that
come to mind:
1. Apache OpenOffice is not, and neither was it's predecessor
OpenOffice.org, designed to be some kind of "el-cheapo" MS Office
"knock-off clone". It was and still is, developed from a totally
different basis to create equally useful software.
2. "Grumpy Old Men" like us generally dislike change, but things do
change. That's life and we have to accept it. ;)
> Your Lessons and tutorials are both poorly laid out and TOTALLY INADEQUATE to answer specific questions.
Yes, we have millions of (mostly appreciative) users, but only a
relatively small number of volunteers contributing to the work of the
project. Regrettably, documentation is one of the main areas where this
shortage is most evident. "Old Timers", with a bit of spare time,
sometimes help out with reviewing/correcting/updating existing
documentation. So if you have a moment feel free to help out. No
experience necessary.
> I want to transfer data from a cell on one page into a cell on another.
This is all you needed to ask and here is the answer:
Assuming you have data (eg. 123) in cell A1 of sheet 1 and you wanted
that same data as a formula in another cell (eg. B6) of sheet 2.
In Excel the formula in B6 of sheet 2 is: =Sheet1!A1
In Apache OpenOffice the formula in B6 of sheet 2 is: =Sheet1.A1
The exclamation mark is replaced by a period/full stop.
> Please send me a list of valid formulas for OpenOffice Calc.
There are other resources, but take a look at Appendix B of the Calc
User Guide version 3.3 on this page:
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/OOo3.3_User_Guide_Chapters
It's a bit dated (remember the volunteer shortage), but it should be of
some help to you.
Also look in Calc's main menu "Help" option.
Other list subscribers have taken the time to reply to your request, but
since you are not subscribed to the list I have taken the liberty of
redirecting copies to you. Please reply to the
users@openoffice.apache.org mailing list only, not directly to me.
Regards
Dave
Re: HELP WITH CALC
Posted by James Plante <ji...@me.com>.
> On Apr 23, 2015, at 2:23 PM, Randall Whitsitt <ra...@outlook.com> wrote:
>
> Please send me a list of valid formulas for OpenOffice Calc.
Just hit the button in the tool bar that's marked "f(x)". You'll get all of them, along with a wizard that explains the parameters one at a time and helps you build the formula.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org