Our organization may be switching to LibreOffice

  • Our organization is planning to switch a large percentage of users from Microsoft Office to LibreOffice. Our department uses several Excel workbooks that include macros written in VBA. It is my understanding that these macros will not work in Calc and will need to be written using some other language.


    First of all, I’m not a programmer. I do have a limited knowledge of Excel and VBA and have been successful in several of our departmental projects. However, if our department is affected by this change, I’ll be starting over with a new language. I’m a little confused about the available languages. I’ve have seen references to Basic, Star Basic, and Python as well as others. I don’t believe that any of my scripts are going to be very complicated in the grand scheme of things. What would be the preferred yet simplest language to use?


    I have also seen several converters online. Just how good are these, and would anyone have a recommendation of one to use?


    Thank you in advance for any advice that you can give me.

  • Our organization is planning to switch a large percentage of users from Microsoft Office to LibreOffice ...


    Hello,


    Is it possible that, for such a crucial decision that your bigwigs have not analyzed the actual consequences ... !!!


    Have they at least evaluated (and communicated about ...) the potential solutions ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • I do appreciate your sentiments Carim. However, I just trying to learn what my options are so that I can either make a convincing case for our department to be allowed to keep using Excel or devise the best plan for making the conversion. Again, any advice would be greatly appreciated.

  • Despite what Libre Office, etc say these programs are not as good as Excel.


    If your company uses macros at all then they won't work and re-writing them will be a mammoth task, even for a simple Excel macro.


    Basically, you get what you pay for.

  • I do appreciate your sentiments Carim. However, I just trying to learn what my options are so that I can either make a convincing case for our department to be allowed to keep using Excel or devise the best plan for making the conversion. Again, any advice would be greatly appreciated.

    Re,


    From your comment, your management truly seems so far away from reality that it is more to be pitied than criticized ...


    Wish you the Best of Luck

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • My understanding is that some basic VBA will run in LibreOffice without alteration, though I can't say I've actually had to try it. If you need to learn another language, either Python or Javascript would be more useful (Javascript is the current MS roadmap for Office add-ins).

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • RoyUK, thank you. While I most definitely understand the economics behind such decisions, I’m hoping that the benefits in our case will be seen. If not, then I be learning something new.


    Rory, thanks for your input. I had not thought much about Javascript. However, It may be helpful to convert to it instead. That kind of brings up another thought. Can macros also be written in Python, and Javascript for Excel?


    I would still be interested in hearing from anyone who may have had an experience with a converter. Do they work or they just do a hit or miss job?

  • If this is a small outfit, sure why not, Libre Office, will take XLs files to a point, and there will be some process or conversions


    Codes are toast, regardless what anyone says. Much work will be required either way - so this is a big balance


    Large enterprise organisations, will never touch anything outside office for core applications i.e. 10,000 users and more its not possible, just sit and use older versions of Office 2010 or 2013 on Win 7 or 10 and alls well


    Maybe the best approach is to alpha test this once spun up as a project and have 2-5% or workforce test and see the results and impact, leaving office as a back stop

    Again or my workplace this is impossible, the largest employer in Europe and one of the larges in the world, its an impossible change


    jiuk

  • Thanks Jack for your comment. Our organization is around 5000 employees. Of course all of them would have a need for a product such as this. It is my understanding that there will still be some who will be allowed to keep Office 365. I'm hoping that we will be able to successfully make our case as one of them. If not, it won't be the end of the world. :)

  • if 365 is possible its a bit or a round-about, thou should work out ok from them that need Excel over A.N.Other


    Depends on your organisation, many do not code so makes little difference and most don’t use heavy Excel. Be a steep learn 5000+ is a mission waiting

    Compatibility needs a keen eye! i.e. existing XLS vs libra

    jiuk