Anyone use LibreOffice Calc as definite substitute to M$Excel?

[danielson]

This is a HELP WANTED ad!

- - - - -

I can never seem to find a decent template that could replace the present one i use in Excel.

Sure, i could head over to LibreOffice forum, but i never seem to have success in finding help there.

If someone has a bit of spare time...

Looking for template that can do:

1. 12 months of the year with extra column for present (jobs), outstanding items (jobs) with a funds column and last column with results for each month.
2. In each tab for separate months would like: "job to be done" / "by who" / date assigned / cost / date accomplished.
-if the last column here could automatically set the entire row in chronological order, that would be a huge plus.
-as well as having entire row highlighted when selected.

Sounds like a complicated thing?
I'm no Excel geek, so that's why i'm posting for help.

[Eadwine Rose]

Sounds like nothing too difficult, should be doable in LO yes.

it gets interesting when various extended macros are getting involved. Then you are SOL with LO.

[manyroads]

Your excel templates should work in calc, most do.

[danielson]

Actually, it's a friend who made something for me and it has a macro that oddly enough, Google Spreadsheet will pick up fine whereas Outlook online won't at all because of macro and L.O. won't perfectly either.

Which brings me to finding something easier to work with.

[manyroads]

You can also try FreeOffice...

[timkb4cq]

Actually, it's a friend who made something for me and it has a macro that oddly enough, Google Spreadsheet will pick up fine whereas Outlook online won't at all because of macro and L.O. won't perfectly either.

Yes, the macro language in Calc is not the same as in Excel, so oftentimes they need to be re-written, but LibreOffice can run some Excel Visual Basic scripts if you enable this feature at Tools -> Options -> Load/Save -> VBA Properties.

[danielson]

"VBA Properties" are enabled but still had incompatibilities.

Fact is, i also probably muffed up the existing Excel file so that is why i wanted to start from scratch (a good, easy L.O. template) and modify it for my needs.

[azrielle]

Back when I acquired my first computer, an Atari 800XL, and a SynCalc spreadsheet plug-in cartridge, I managed to figure out from the fairly rudimentary manual how to make my own spreadsheet that would printout on a Star dot matrix printer. And eventually save it onto a floppy disk. The equivalent of a homemade template in other words. Obviously, I have no experience with modern spreadsheets--my last feeble attempts were with WordPerfect era Quatro--but it can't be that difficult to roll your own to resemble your Excel template.

[figueroa]

Originally developed in OpenOffice, but now running in LibreOffice, I developed and use a spreadsheet that reads multiple external files for input data (student enrolment sheets) for summarizing student enrolments in one tab and creating class lists of students in another tab.

Another sheet with six active tabs is used for computing and tracking of school payroll. One tab for teachers and other salaried employees, another for hourly workers, another for church employees, another for additional non-salary-related pay (atteding meetings, bonuses, ad-hoc assignments - links back to tab 1), and a final tab that collates all the other tabs for on-line payroll entry and auditing.

No macros or VB needed. I'm not available, but LibreOffice is totally capable for the described use, and compared to Excel, less tricky, more bullet-proof. One heavy users opinion. Learn by doing. Then you get the spreadsheet you really want, with your own bugs instead of someone else's.

[towwire]

I think he learned one lesson and that is DO NOT used the main one, make a copy and used it for testing.

It sound like he wants a Project Management or a Contractors tempplate.

I agree with 'figueroa' of making your own even by finding one's to go by for each part and linking them together.

So you will have to search the net, and don't limit it to just OpenOffice, LibreOffice or Excel. You may find one that works and you just need to make some changes to fit you.

What is the size of your current one? I'm not available either, too many projects of my own to do.