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. 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
