2015-04-23 21:57 GMT+02:00 Johnny Rosenberg <[email protected]>:
> 2015-04-23 21:23 GMT+02:00 Randall Whitsitt <[email protected]>: > >> 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 > > >
