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 <gurus.knu...@gmail.com> wrote: > > 2015-04-23 21:23 GMT+02:00 Randall Whitsitt <randommo...@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-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
