Thank you and Gerhard for clearing this up to me. Calc has several limitations and quirks that make it harder for companies to even consider replacing Microsoft Office with LibreOffice, but IMO this is the most important one. I can't speak for Italy, but in Portugal barely any big organization uses Access. They all do their work in Excel but they require macros. And no organization would even consider replacing Microsoft Office if there's no macro compatibility. Hundreds of spreadsheets with macros that would have to be converted?
This is not the correct mailing list for this, I know but was it ever considered to move from StarBasic to VBA? On Mon, Feb 11, 2019 at 2:42 AM Franklin Weng <frank...@libreoffice.org> wrote: > On February 11, 2019 7:44:49 AM GMT+08:00, Pedro Rosmaninho < > mota.pr...@gmail.com> wrote: > >How do the macros in LO work? I thought they were Basic macros? What's > >the > >difference for the VBA macros of excel? > > > > StarBasic, not Visual basic. Excel VBA cannot directly convert to > StarBasic so they need to be rewritten or recorded again. > > I would suggest using Python to recreate macros instead of using > StarBasic, just that currently there is not many documents available. > > -- > Franklin Weng, Member, Board of Director & Certification Commitee > The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE > > Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts > > Legal details: https://www.documentfoundation.org/imprint > -- To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy