Porting OpenOffice BASIC to LibreOffice

English
,
#1

While I have to follow the trend, at least considering a switch from OpenOffice to LibreOffice, and everything on the surface looks just great in LibreOffice (identical as seen in OpenOffice), I find Calc macros behaving differently.

Are the two BASIC the same?
Anywhere I can find reference for porting OpenOffice BASIC into LibreOffice?

Without the appropriate tool, it will imply redoing everything from scratch, which to me is something too expansive (effort and time). Chance is that I may have to live with the last OpenOffice release, till the end.

CSLam

#2

Don’t worry, Basic the same here and there. The only difference is the individual methods of individual objects obtained through the API. Usually, to get to work the old macro in the new version of LibreOffise need to change a few lines. In the future, you can come in handy function GetProductname() from standard library Tools module Misc

#3

Try the OpenOffice forum at OpenOffive Forum

This has been going for a long time and has users who have moved to LibreOffice.

#4

I have given up for a long long time, but I am trying to make it a target converting into LibreOffice in 2017, thus the attempt sets off again. My only problem is Calc, because there are macros built into the OpenOffice worksheets.

I have some luck this time, because I think I find the way making things go as expected now. Yet, the solution looks a bit odd, and I am trying to let everybody know, in case they do have some understanding explaining this.

Original Setup: Macro tied to a button, defined to get activated upon releasing the mouse button -
This does not work in LibreOffice - the mechanism does work, but the macro does not work out correctly.

New Setup: Macro tied to a button, but changed to get activated upon pressing the mouse button - This makes the macro work correctly in LibreOffice - the same piece of code, no change at all!

Strange?

CSLam

#5

(Better post under your user ID in such cases.)
@ the wiki poster
Strange! I do not use Subs much, but if I do it’s mostly in LibO Calc and execution is triggered by ‘Mousebutton released’. It always worked, and it still does in V5.3.0.1RC as I just tested.
Of course I do not know your (probably complicated) code as long as you don’t post it. However, I cannot imagine a reason for “…but the macro does not work out correctly.”. In my (surely very simple) example it does.

You may test with my ad hoc exemple which also works in the same way under AOO V4.1.2 (portable).

(The conditional ‘Exit Sub’ is for denying the execution if the release action took place outside of the button area. This I suppose to be the most accepted way to use buttons. If you know a simpler way, please report.)

#6

I wanted to share the sample spreadsheet, but do not know how I can attach the thing here. It’s never complicated: the macros help inserting or duplicating a line, and sorting the spreadsheet, which I believe are the most popular actions needed, which without a macro are something tedious enough when you are doing it over and over, daily.

CSLam

#7

(Ok, I do not use macros very much. And I do not worry about supporting sorts by macros. my main usage of spreadsheets is by formulae.)
To upload attachments you need a bit of “karma”: I will see you get it.

#8

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.