| View previous topic :: View next topic |
| Author |
Message |
tsiliman
Newbie
Joined: 15 Jul 2012
Posts: 3
|
 Posted: Sun Jul 15, 2012 6:04 am Post subject: Result and Input cell |
 |
|
Hello.
I have a column of 5 cells. Three of them are filled with the input data, and the two remaining return the results. But at the same time, I'd like the result cells to be the input data cells.
Is there a way to make all cells act as input and result cells, instead of creating multiple columns?
This link is a good example of what I'm trying to do.
http://www.handymath.com/cgi-bin/arc18.cgi?submit=Entry
Thanks |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sun Jul 15, 2012 11:07 am Post subject: |
|
|
What does that web-page do? It separates data input strictly from the calculated output. You enter units and constant values and the result appears on a separate report.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
tsiliman
Newbie
Joined: 15 Jul 2012
Posts: 3
|
| Posted: Sun Jul 15, 2012 6:43 pm Post subject: |
|
|
| The web page returns output to a new page! If it was a calc spreadsheet, it would be exactly what i need. Any cell can be filled with data, any cell can return results. |
|
| Back to top |
|
|
tsiliman
Newbie
Joined: 15 Jul 2012
Posts: 3
|
| Posted: Mon Jul 16, 2012 2:26 pm Post subject: |
|
|
| Anyone? |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Tue Jul 17, 2012 4:54 am Post subject: |
|
|
| tsiliman wrote: | | The web page returns output to a new page! If it was a calc spreadsheet, it would be exactly what i need. Any cell can be filled with data, any cell can return results. |
Do the same thing? Sheet one is input sheet two is output? Presumably you would have to switch manually between sheets but you get the same result I would think.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
