Background: When you launch the macro editor for a document with macros (Tools->Macros->Organise Macros->Basic) - you end up with an horrible UI. Firstly the tree simply doesn't expand easily - it should be far more helpful around expanding nodes so you can see macros. But more annoyingly - even if you know there is a macro in a spreadsheet - you can't open the basic editor until you have found, and clicked onto it, then selected edit. That is just annoying; particularly since the resulting editor has tabs that show you all the macros from each sheet. We should simplify that to make it far easier to run, edit (and demo editing) macros. Design and develop the organizer for attachment elsewhere like the Tools->Macros->Run... menu item: there are three macro organizers in OO now. Some of the code is in basctl/source/basicide/macrodlg.* I believe. Skills: simple C++ programming, willingness to learn a bit of VCL
Rotating this into the featured EasyHacks on the wiki. However, this looks rather underspecified to me, thus: @Cristoph: Could you re-CC anyone on the design team guide any possible takers along?
(In reply to comment #1) > @Cristoph: Could you re-CC anyone on the design team guide any possible takers > along? Michel Renon started a whiteboard page: https://wiki.documentfoundation.org/Design/Whiteboard/Macros_Dialogs According to his mail on the design list "It's a very first idea, lots of details may be enhanced."
Hi. I'd like to start working on this. However, this would be my first bug. Could someone guide me where to begin?
Adding Noel Power to CC. Could you pick up and mentor Pallav along?
I wasn't aware of this bug/easyhack ( someone else must have opened it ) but in master now mostly this has already been started. I wonder though are you a student ? if so have you considered gsoc ? http://www.google-melange.com/gsoc/homepage/google/gsoc2012 Libreoffice is participating in gsoc and in particular http://wiki.documentfoundation.org/Development/Gsoc/Ideas#Bunch_of_Basic_IDE_improvements which includes this easy hack. The ideas link above also contains a link to the work sofar. Are you interested in gsoc?
I confirm these problems. In addition, if one calls macros twice, one has to open the complete path twice: MyMacros / LibO Macros / Database > Standard > Module. It would be better if the previous path would be reopened immediately. Or Björn's suggestion would be realized. Jürgen
Important: Add a help item telling you where to find basics about - what basic is - what functions are builtin (with some googling and grepping sources you can find out - but there should be better ways) - basic syntax and where to look it up It would be nice if you could open many modules at the same time. It would be nice if the manager would show all scripting types (python,bean,js,basic) in the same window. (Thus one "Organize Macros" item for all languages) It would be nice if you could use an external editor like vim, emacs,... for editing files. I know that macros are not stored in files -but maybe a "view" could be created on disk such as $HOMe/libre-office-macros/doc/ which could then be edited - and libre office could check for updates and sync back
@Marc: Please dont extend the scope of a bug esp. if it is an EasyHack. If in doubt, open a new separate bug.
I'd really like to work on this bug.As I am a beginner(actually it will be my first bug then). I need guidance from someone.can anyone guide me out?
adding LibreOffice developer list as CC to unresolved EasyHacks for better visibility. see e.g. http://nabble.documentfoundation.org/minutes-of-ESC-call-td4076214.html for details
Adding self to CC if not already on
hi I want to work on this , its my first bug ! can someone please guide me for this?
A test document would be good, the problems described seems to need a combination of a "normal" document and macros and not macros alone. Tested with 2 simple macros in a document, and that seems insufficient. Does anybody have a real nasty document ?
I have documents but what do you mean with nasty ? - lot of content in the Document - lot of macro's inside the document
Created attachment 121225 [details] Writerdoc with lot of macro's inside
Heh - JanI is looking at this now and I got him a document.
Migrating Whiteboard tags to Keywords: (EasyHack DifficultyInteresting SkillCpp SkillVcl) [NinjaEdit]
skillVcl doesn't exist
JanI is default CC for Easy Hacks (Add Jan; remove LibreOffice Dev List from CC) [NinjaEdit]
A polite ping, still working on this issue? (yes I am)
still but missing time
still missing time (I know, not a good response)
. yes
I noticed that in LO v5.4 Calc & Writer have an improvement: Tools | Macros | Edit Macros This makes it much easier to edit macros. Base, Draw, & Impress could benefit from a similar feature I think.
Hello, If I understand correctly this issue is fixed on Calc and Writer with edit macros option, can someone help me start on implementing the same solution for Base, Draw, Impress and Math?
(In reply to Howard Johnson from comment #24) > I noticed that in LO v5.4 Calc & Writer have an improvement: > > Tools | Macros | Edit Macros > > This makes it much easier to edit macros. > > Base, Draw, & Impress could benefit from a similar feature I think. The same command can be added to the Tools > Macros menu of Base, Draw, & Impress. Until it is added by default, you can also add it for your installation by using the Customize dialog (Tools > Customize).
Jens Carl committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/62b7faa167162b5e35746c546be1a758dd8f29d2%5E%21 Related tdf#38889: Sync sub menus Tools > Macros It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Jens, Björn: please resolve the ticket as fixed if you think its done.