Need help To convert Excel Sheet to Libre sheet

Dear Users,
I'm David Johnson, from the Technology team from Janalakshmi Financial Services, Bangalore based NDFC. Currently we are migrating our excel based application to Libre office; hence I need Help on the same. We have been using a survey kind of tool which is developed in Excel to be converted in to Libre office. Can anybody advice us how we go about it. It has to work on all the platforms. Please advice.

If there is anybody (a consultant) in around Bangalore. Who can support us are welcomed. Look forward for your support at the earliest.

What's your problem specifically?

Unless there are macros, usually it's enough to open LibreOffice Calc and
let it open the excel file. Then save it in odf (.ods) format.

Let is know of there are troubles with these steps, and please report
specific problems.

All the best.

Dear Gabriele and Tim,
PFA; This is the Excel Macro sheet we are trying to convert. Could you please help me.

That is a true statement - LibreOffice does not support the proprietary
Microsoft VBA (it may in a very very limited way but not enough for most
test cases that I've seen) - you'll have to rewrite it in Basic.

Best,
Joel

You mean a paid professional? I could ask one or two people - if you're
instead asking for a volunteer to assist, best bet is to just asked
around on the email thread and maybe the OOo forum (there are a few
great macro people over there).

Best,
Joel

Dear Joel & Tim,
Thanks for your valuable inputs, appreciate it. Is there any professional, whom you know, could help me to redevelop the same in Libre Calc.

see the list of certified migration professionals at <http://www.libreoffice.org/get-help/professional-support/>

Dear Joel,
It is a paid processional, we need to recreate the same excel in Libre office, we need this at the earliest.

Indeed the certified migrators are a good place to start to poke people.
You can also contact CIB who may be able to help.
https://libreoffice.cib.de/

Best,
Joel

Hi :slight_smile:
As you probably know the Indian Government is making a strong push to free
themselves from the vendor lock-ins created by using non-OpenSource
products.

So, it is possible there may even be funding to help with this sort of
thing or there may well be some organisation, or conglomeration of
organisations to help with this sort of work.

Almost certainly you may well be able to find someone local who can do the
re-programming either as a one-off for just this Excel-Calc migration or as
a part-time employee/consultant to help with similar jobs in the future or
to help as 2nd/3rd tier in-house IT Support for any issues that may "crop
up" in the whole migration away from all the Microsoft and other
proprietary products.

One of the advantages of OpenSource is that you don't have to wait until
some profit-making organisation decides on the value to them of the help
you need. With an OpenSource program you can pay someone to do it for you,
on your priorities, or even have a go yourself. If your code is of good
enough quality then it might well be added to the main program. Many
organisations find that paying for a dev to work on their own issues is
still cheaper than paying licensing fees as well as giving them more
control. Quite a lot of the development of LibreOffice is due to many
organisations co-operating with each other in this way through The Document
Foundation.

Regards from
Tom :slight_smile:

A bit oftopic, but I would really love this in KiCad soon!