Page 1 of 1

Newbie to Calc immediate conversion of Macros!

PostPosted: Mon Nov 25, 2019 4:09 pm
by AmishTechie
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

Re: Newbie to Calc immediate conversion of Macros!

PostPosted: Mon Nov 25, 2019 4:34 pm
by FJCC
There is no attached document.

Re: Newbie to Calc immediate conversion of Macros!

PostPosted: Mon Nov 25, 2019 5:30 pm
by John_Ha
Welcome.

See [Tutorial] Differences between Writer and MS Word files for a discussion of some differences you will find.

Re: Newbie to Calc immediate conversion of Macros!

PostPosted: Mon Nov 25, 2019 6:13 pm
by Zizi64
Attached is this year's worksheet.

The file size limit is 128 KiB in this forum.

You can share the larger files on a free file sharing service.

Re: Newbie to Calc immediate conversion of Macros!

PostPosted: Tue Nov 26, 2019 4:33 pm
by AmishTechie
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

Re: Newbie to Calc immediate conversion of Macros!

PostPosted: Tue Nov 26, 2019 5:30 pm
by Zizi64
Try to share it on a free file sharing service (Google drive or others).