Hello everyone.
I'm new here to the forum.
I created this originally in Excel, then in OpenOffice. This version is in LibreOffice.
I would like to create some module code to build this from the information placed on the WRK sheet.
Currently I have a simple solution for the overtime calculation, how should I change it, if there is someone that thinks it should be changed.
Each of the cells on the YTD sheet I originally setup as hyperlinks to the sheet in Excel, but I can't do that in OO or in LO.
In essence I would like to be able to start the year with nothing but one sheet that contains the pertinent information, and some macro controlled buttons to build the sheet from there.
I welcome your thought's on the worksheet as well as ideas/pointers on doing the coding.
It has been a very long time since I've done any programming. Say since volume 12#7 of PC-Magazine.
Thank you so much for your time.
[Dropped] I'd like to build this Timesheet in Basic code
[Dropped] I'd like to build this Timesheet in Basic code
Last edited by MrProgrammer on Mon May 01, 2023 3:18 pm, edited 1 time in total.
Reason: Dropped: No response from rickwesh when requested -- MrProgrammer, forum moderator
Reason: Dropped: No response from rickwesh when requested -- MrProgrammer, forum moderator
RickWesh
Libre Office 7.5.2 / Windows 10
Libre Office 7.5.2 / Windows 10
Re: I'd like to build this Timesheet in Basic code
If you make a start and then when you get stuck you can ask for help. You can find the OpenOffice.org 3.2 BASIC Guide online and
Andrew Pitonyak OpenOffice books too.
The best way though is possibly to do a search here or in a search engine for what you want to do eg for
openoffice macro how to set a cell value
And look at the result - which may well be from here. And work like that...
Andrew Pitonyak OpenOffice books too.
The best way though is possibly to do a search here or in a search engine for what you want to do eg for
openoffice macro how to set a cell value
And look at the result - which may well be from here. And work like that...
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
Re: I'd like to build this Timesheet in Basic code
Thank you for the reply.
I actually have started some coding. As a matter of fact I strayed up considerably longer than I should have last night.
I have the guides, as well as the PDF by Pitonyak.
Restarting coding has gone pretty smoothly considering how long it's been since I last took on such an endeavor.
The reason for my posting the workbook here was in hopes of getting comments on the layout of the spreadsheets.
I created the workbook for personal use.
I know the idea of a timesheet workbook is probably mundane, but could you give your thoughts on what I produced?
Thank you again.
I actually have started some coding. As a matter of fact I strayed up considerably longer than I should have last night.
I have the guides, as well as the PDF by Pitonyak.
Restarting coding has gone pretty smoothly considering how long it's been since I last took on such an endeavor.
The reason for my posting the workbook here was in hopes of getting comments on the layout of the spreadsheets.
I created the workbook for personal use.
I know the idea of a timesheet workbook is probably mundane, but could you give your thoughts on what I produced?
Thank you again.
RickWesh
Libre Office 7.5.2 / Windows 10
Libre Office 7.5.2 / Windows 10
Re: I'd like to build this Timesheet in Basic code
The document is complete rubbish. You ignore the entire software. Before adding even more stupid Basic code to this nonsense, you should learn how to work with spreadsheets, office documents, templates, styles in general.
Every IT professional would implement anything like that with no spreadsheet at all. Collecting data in constantly growing lists is a database task, no matter how many spreadsheet users try to do this with spreadsheets. Spreadsheets are the most popular misapprehension in the history of software.
Every IT professional would implement anything like that with no spreadsheet at all. Collecting data in constantly growing lists is a database task, no matter how many spreadsheet users try to do this with spreadsheets. Spreadsheets are the most popular misapprehension in the history of software.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: I'd like to build this Timesheet in Basic code
Ok well thank you so much for your time and thoughts.
Please have a wonderful day.
Please have a wonderful day.
RickWesh
Libre Office 7.5.2 / Windows 10
Libre Office 7.5.2 / Windows 10
- MrProgrammer
- Moderator
- Posts: 4904
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: I'd like to build this Timesheet in Basic code
You could save a couple of weeks of your time by not using macros. You can get essentially the same information with a simple data sheet and two pivot tables, one for month summary and one for year summary. For 2024, make a copy of the spreadsheet, add 365 to the dates in Data.A2:A366 with Edit → Paste Special → Add and fill down another row because it's leap year. Even better, keep everything in one spreadsheet and add year filters to the pivot tables.
A pivot table provides minimal formatting options however you can copy all of its cells via formulas =PivotTableCell and format the copies to death with colors, fonts, bold, custom headings etc. This is best done with styles.
I welcome your thought's, rickwesh, on the spreadsheet which I've attached.
That won't be the main problem. It will be understanding the UNO API. It is quite clever, but the concepts are hard. Expect to spend at least a week to learn the essential ideas of services, interfaces, etc. Then expect to spend at least another week to determine which of the thousands of services, interfaces, methods, and properties will provide the data you want and allow you to manipulate it. This is really complex stuff. There are many examples for you in the forum, but finding the appropriate ones for your task and understanding how they work will be a slow process.
I do not offer to provide any macro assistance or examples.
In the Year pivot table, enable Drill to Details. I haven't used this much but I think it might do what you want. Use the Help button in the dialog to learn more.
Your formula =IF(cell>8;cell-8;) produces Err:511 in OpenOffice. I changed it to =MAX(cell-8/24;0), keeping track of time in days. Read section 4. Times in cells in Ten concepts that every Calc user should know.
If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: I'd like to build this Timesheet in Basic code
+1
Yes indeed! But at least it's really nice and colourful!
Libreoffice 7.4 on Debian 12 (Bookworm) (on RaspberryPI4)
Libreoffice 7.6 flatpak on Debian 12 (Bookworm) (on RaspberryPI4)