Good day!
My MS Office subscription came up and I can't afford that bloated POS anymore, so I am new to Open Office
I am a semi-retired contractor for a property management company. My time-project sheet is in excel. My conversion to Calc macros no longer work in some areas.
I need some kind soul to convert my excel spreadsheet right away as the end of the month is coming up. I don't have the time to learn the difference for the end of this month.
Is anyone able to help me out?
Specifically, the Hours in the Monthly sheets use a "named Table" to convert hours to decimal for calculating hours worked.
Attached is this year's worksheet. I only Need the month of November and December converted. I'll take care of the rest when I set up for 2020.
Thank you so much!
Ray Bailey
Newbie to Calc immediate conversion of Macros!
-
- Posts: 2
- Joined: Thu Nov 21, 2019 3:20 pm
Newbie to Calc immediate conversion of Macros!
Last edited by FJCC on Mon Nov 25, 2019 4:33 pm, edited 1 time in total.
Reason: Removed flame icon
Reason: Removed flame icon
AmishTechie
OpenOffice 4.1.7 on Windows 10
OpenOffice 4.1.7 on Windows 10
Re: Newbie to Calc immediate conversion of Macros!
There is no attached document.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Newbie to Calc immediate conversion of Macros!
Welcome.
See [Tutorial] Differences between Writer and MS Word files for a discussion of some differences you will find.
See [Tutorial] Differences between Writer and MS Word files for a discussion of some differences you will find.
LO 6.4.4.2, Windows 10 Home 64 bit
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Re: Newbie to Calc immediate conversion of Macros!
The file size limit is 128 KiB in this forum.Attached is this year's worksheet.
You can share the larger files on a free file sharing service.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
- Posts: 2
- Joined: Thu Nov 21, 2019 3:20 pm
Re: Newbie to Calc immediate conversion of Macros!
Oky,
So I can't upload my ODS spreadsheet as it is too large. So I "Make Copy" the November sheet and try to save it I keep getting "Error saving the document Untitled 1.ods Write Error The file could not be written."
It is being saved as untitled 1.ods on my work drive where the original is saved. I have tried multiple renames and directories.
sigh....
Ray
So I can't upload my ODS spreadsheet as it is too large. So I "Make Copy" the November sheet and try to save it I keep getting "Error saving the document Untitled 1.ods Write Error The file could not be written."
It is being saved as untitled 1.ods on my work drive where the original is saved. I have tried multiple renames and directories.
sigh....
Ray
AmishTechie
OpenOffice 4.1.7 on Windows 10
OpenOffice 4.1.7 on Windows 10
Re: Newbie to Calc immediate conversion of Macros!
Try to share it on a free file sharing service (Google drive or others).
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.