OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Result and Input cell

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
tsiliman
Newbie
Newbie


Joined: 15 Jul 2012
Posts: 3

PostPosted: Sun Jul 15, 2012 6:04 am    Post subject: Result and Input cell Reply with quote

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
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Jul 15, 2012 11:07 am    Post subject: Reply with quote

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 https://forum.openoffice.org
Back to top
View user's profile Send private message
tsiliman
Newbie
Newbie


Joined: 15 Jul 2012
Posts: 3

PostPosted: Sun Jul 15, 2012 6:43 pm    Post subject: Reply with quote

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
View user's profile Send private message
tsiliman
Newbie
Newbie


Joined: 15 Jul 2012
Posts: 3

PostPosted: Mon Jul 16, 2012 2:26 pm    Post subject: Reply with quote

Anyone?
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Tue Jul 17, 2012 4:54 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group