C W wrote:
Greetings,
I am completely oblivious when it comes to creating and manipulating any kind
of coding or formatting in Calc so please be gentle.
It is my desire to create a small spread sheet that has 2 rows and 6 columns.
I'd like to have row 2, column 1 be a total from columns 3 and 5; I'd like to
have row 2, column 2 be a total from columns 4 and 6. Does that make sense?
Here's kinda how I'd like it to look:
Closed Totals | ##
Escalated Totals | ##
Online Closed | ##
Online Escalated | ##
Offline Closed | ##
Offline Escalated | ##
**Where the titles are in Row 1 in descending columns, the "|" indicates the cell
separation, and the "##" are in row 2 in descending columns next to the titles.
The titles would be in row 1, columns 1 through 6 and the "##" would be in row
2, columns 1 through 6.
Now, the tricky part . . . is there a way to make it so I can click on the "##"
next to Online Closed, Online Escalated, Offline Closed, Offline Escalated and have them
go up 1 digit starting with 0?
Another example:
Online Closed 24 <----I would click on the cell with the number and it
would go up 1 point to 25 . . . or perhaps have some up/down arrows instead?
Ultimately, I'd like to have it so the totals from the Online and Offline Closed categories would then give
me a final tally in the top row, "Closed Totals" in the "##" box next to that and the
same for the "Escalated Totals."
I know this sounds like quite a bit but anyone's help would be greatly
appreciated. =)
What you are saying is quite confusing, probably because you seem to be
using "row" to mean column (vertical), and "column" to mean row
(horizontal). Think of columns that support a roof, and rows of plants
in a garden.
That said, what you want to do would require inserting a "spin control"
in the cells where you want to click on an "up-down" arrow to change
the value of the cells. This is easy to do, but the interaction with the
cell values requires a little macro programming. Perhaps someone else
on the list who has more experience in this than I can help you.
Regards,
Matt
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
