Re: [opensuse] Tricky spreadsheet problem, could really use some help.
- From: kanenas@xxxxxxxxxxxxx
- Date: Tue, 8 May 2012 20:40:28 -1000
On Tuesday 08 May 2012 08:11:20 pm Roger Luedecke wrote:
On Tue, 2012-05-08 at 22:30 -0700, Thomas Taylor wrote:
On Tue, 08 May 2012 22:03:42 -0700
Roger Luedecke <roger.luedecke@xxxxxxxxx> wrote:
I used to know spreadsheets, but I completely forgot how to use them
and have been trying to retrain myself. I normally use Lotus Symphony
which is based off of OpenOffice 3. I expect the behavior should be the
same between Lotus and LibreOffice.
I want to build a time-sheet. Sheet one has the time being tracked, and
the summary sheet should sum up the values giving total money owed, and
hours used on each project.
Currently I have it set up on the first page with columns for the
following; Date, Project, Task, Start, Stop, Subtotal, and Notes. I use
the formula under 'Subtotal' to calculate the time between 'Start' and
'Stop'. That works correctly, though I do not know how to get it to
apply to all of the column automatically so I don't have to manually
reenter the formula each time.
I anticipate the summary page will be more difficult. I want it to be
able to not only give a total of hours, and the pay owed, but to be
able to display what the total hours were spent on each project. I'd
like it to automatically populate this list based on my entries under
'Projects.' I haven't the foggiest of conceptions on where to start on
this page of the workbook.
Any help would be immensely appreciated.
Hi Roger;
In Libreoffice Calc the formula can be copied (ctrl-c) from one cell and
applied to an entire column by selecting the column and pasting (ctrl-v)
to the selection.
That doesn't work in either LibreOffice or Lotus. This seems to be an
Excel only feature.
all of this is basic info, and you can read all about it if you click on help.
Copying a formula from one cell to another or many others is a standard
feature on just about any spreadsheet. if help does not come up, you might
have to install it in yast2/software management...
--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse+owner@xxxxxxxxxxxx
- References:
- [opensuse] Tricky spreadsheet problem, could really use some help.
- From: Roger Luedecke
- Re: [opensuse] Tricky spreadsheet problem, could really use some help.
- From: Thomas Taylor
- Re: [opensuse] Tricky spreadsheet problem, could really use some help.
- From: Roger Luedecke
- [opensuse] Tricky spreadsheet problem, could really use some help.
- Prev by Date: Re: [opensuse] Tricky spreadsheet problem, could really use some help.
- Next by Date: Re: [opensuse] Tricky spreadsheet problem, could really use some help.
- Previous by thread: Re: [opensuse] Tricky spreadsheet problem, could really use some help.
- Next by thread: Re: [opensuse] Tricky spreadsheet problem, could really use some help.
- Index(es):
Relevant Pages
|
