Ask Your Question
0

LO BASIC or Python on LO Calc ?

asked 2019-07-18 09:35:34 +0200

lonk gravatar image

updated 2019-07-18 10:01:17 +0200

In the past I used Excel VBA to create Add-in menus the same way as from here https://sitestory.dk/excel_vba/user-d... . But now in my own new office, we only use Fedora 30 Workstation, LibreOffice 6.4.x.x.x and Fedora 30 Server for we have left MS Windows and MS Office for over one year. Can LO BASIC or Python create menus like that ?

edit retag flag offensive close merge delete

Comments

Look at this extension (creates both menu items and a toolbar): http://anaphraseus.sourceforge.net/

gabix gravatar imagegabix ( 2019-07-18 13:38:20 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2019-08-22 00:32:00 +0200

Ratslinger gravatar image

Hello,

Sorry for not responding to this sooner.

You can use macros (Basic, Python and more) to create menus on-the-fly. Haven't any current samples using Calc. All my initial work was done with Base which has a more complex manner of menu levels than other modules in LO.

I have posted a Base sample and document here -> Base Macros to Modify Menubars. There is a bit of information in the document regarding other modules. Have tested with Writer & Calc some time ago and it is less complex than Base. Sorry, no current samples of these but probably can produce if necessary.

None of it is simple. Some of the methods tried (like changing an item in an existing Menu bar) presented erroneous results.

edit flag offensive delete link more

Comments

@Ratslinger

Noted and thank you so much for your support and your concern.

Now I am moving all works from MS Excel and to LO Calc and Base.

Next step is from MS Excel VBA to LO Calc BASIC Macro.

I am also reading Andrew Pitonyak's tutorials, he also mentioned the slight difference between LO Basic Macro vs. VB.

Python will be the last and very far in the future for I have not so much time.

| Fedora 30 Workstation KDE of Fedora from Spins | LibreOffice 6.3.0.4 | Fedora 30 Server |

lonk gravatar imagelonk ( 2019-08-22 06:32:42 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-18 09:35:34 +0200

Seen: 61 times

Last updated: 2 days ago