On Tue, 2012-05-08 at 22:30 -0700, Thomas Taylor wrote:

On Tue, 08 May 2012 22:03:42 -0700 Roger Luedecke 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. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

On Wed, 2012-05-09 at 14:18 +0800, Ed Greshko wrote:

On 05/09/2012 02:11 PM, Roger Luedecke wrote:

...

...

...

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.

Let's say you have a formula in cell H2 and you want to have that formula extend from H3-H20.

All you need to do is select H2 and then grab (click/hold) the little black box in the lower right corner and drag it down to H20. The copy and paste doesn't work. But the box dragging worked perfectly. Yay! That is solved. Now for the Summary page.

I want to have the second page 'Summary' dynamically tally up the time spent on each 'Project' so as to give the per-project time spent. Also want it to then sum all the time, and then calculate the payment owed for my time. Do not know how to do the former thing or how to get it to link from one page to the next. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

On Wed, 2012-05-09 at 14:52 +0800, Ed Greshko wrote:

On 05/09/2012 02:41 PM, Roger Luedecke wrote:

...

On Wed, 2012-05-09 at 14:18 +0800, Ed Greshko wrote:

...

On 05/09/2012 02:11 PM, Roger Luedecke wrote:

...

...

...

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. Let's say you have a formula in cell H2 and you want to have that formula extend from H3-H20.

All you need to do is select H2 and then grab (click/hold) the little black box in the lower right corner and drag it down to H20. The copy and paste doesn't work. But the box dragging worked perfectly. Yay! That is solved. Now for the Summary page.

I want to have the second page 'Summary' dynamically tally up the time spent on each 'Project' so as to give the per-project time spent. Also want it to then sum all the time, and then calculate the payment owed for my time. Do not know how to do the former thing or how to get it to link from one page to the next.

So, you have "Shee1" and "Sheet2" for example....

You can reference values of Sheet1 on Sheet2 by simply doing something like this....

In Sheet2, Cell A3....

=Sheet1.C6+12 Will take the value of Sheet1 Cell C6 add 12 and display the results in A3 of Sheet 2.

It is all in the Help.... I looked at the documentation, and found it rather obscure. I'll have to take a second look. Thank you, I'll try that tomorrow and see what I can come up with. I actually have a print book on spreadsheets, but theres so much chaos at home its very hard to focus.

-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 2012-05-09 08:41, Roger Luedecke wrote:

The copy and paste doesn't work. But the box dragging worked perfectly. Yay! That is solved. Now for the Summary page.

Copy paste certainly works in LO. - -- Cheers / Saludos, Carlos E. R. (from 11.4 x86_64 "Celadon" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk+qWW8ACgkQIvFNjefEBxqNIQCgx+5ox4hiPdW0+amn+SZM/BFh mxEAni6vqX9DU+0YoXrCRq7LwK8nefjY =snRF -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

On Wed, 2012-05-09 at 13:48 +0200, Carlos E. R. wrote:

On 2012-05-09 08:41, Roger Luedecke wrote:

...

The copy and paste doesn't work. But the box dragging worked perfectly. Yay! That is solved. Now for the Summary page.

Copy paste certainly works in LO.

It didn't. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

On Tue, 08 May 2012 23:11:20 -0700 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 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.

No, this is not Excel. It's taken from the LibreOffice calc users guide for version 3.4. Tom -- Tom Taylor - retired penguin «§ Peace & Love to all §» AMD Phenom II x4 955 -- 4GB RAM -- 2x1.5TB sata2 openSUSE 12.1x86_64 openSUSE 12.2x86_64 KDE 4.7.2, FF 7.0 KDE 4.8.1, FF 10.0 claws-mail 3.8.0 registered linux user 263467 linxt-At-comcast-DoT-net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

On 05/09/2012 10:15 AM, Ritchie Fraser wrote:

On Wednesday 09 May 2012 06:03:42 Roger Luedecke 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.

I have built an example spreadsheet which I believe does what you want. You can download it from my development web server here: http://thefrasers.homelinux.net/~ritchie/examples/ExampleTimeSheet.ods

Kind Regards

Ritchie How did you get 21.00 an hour in that formula ?

-- Hans Krueger hanskrueger007@roadrunner.com registered Linux user 289023 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

On Thursday 10 May 2012 18:13:41 Roger Luedecke wrote:

On Wed, 2012-05-09 at 15:26 +0100, Ritchie Fraser wrote:

...

On Wednesday 09 May 2012 06:03:42 Roger Luedecke 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,

I have thrown together an LibreOffice spreadsheet which I think should meet your needs. I have tried several times now to post this reply, but the list keeps rejecting it :-(

You should be able to get to the file here...

http :// thefrasers.homelinux.net / ~ritchie / examples / ExampleTimeSheet.ods

You will need to remove all the spaces from the above URL as it seems this is the only way I could get the list to accept it...

Kind Regards

Ritchie

Thank you very much! That is very much what I had in mind. I'll be using that as a guide to make changes to the one I've been working on. That is extremely helpful! And people wonder why I rail against proprietary technology...

Your welcome. I don't get the opportunity to help out on the forum much, but I am glad to help where I can. Ritchie -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org