Search found 2778 matches

by JeJe
Tue Apr 23, 2024 4:32 pm
Forum: Writer
Topic: How to change default highlighting color Writer?
Replies: 2
Views: 152

Re: How to change default highlighting color Writer?

Are you using LibreOffice or OpenOffice. That LibreOffice thread is old, it now has an expert configuration where a lot of values can be set but I don't know enough to know whether that is one of them Another way is with a macro. The attached document has one (mostly made with the macro recorder) to...
by JeJe
Tue Apr 23, 2024 1:22 pm
Forum: Writer
Topic: Text produced using Writer does not display using Microsoft Word
Replies: 5
Views: 376

Re: Text produced using Writer does not display using Microsoft Word

What's in the block of text - are there OO specific features apart from plain text which might not copy? You could try saving that block of text as an rtf file and then open it again (in Word) and insert that into your other Word document.
by JeJe
Tue Apr 23, 2024 1:11 pm
Forum: Writer
Topic: Delete blank page after table
Replies: 5
Views: 289

Re: Delete blank pages

You can remove the paragraph after the last table with this macro:

Code: Select all

Sub RemoveLastParagraph
txt = thiscomponent.text
tc =txt.createtextcursorbyrange(txt.end)
tc.createenumeration.nextelement.dispose
End Sub
by JeJe
Sat Apr 20, 2024 7:13 pm
Forum: Macros and UNO API
Topic: Macro button to hide/unhide rows in Calc
Replies: 6
Views: 688

Re: Macro button for hide/unhide rows in Calc

Apart from the IDE help file, Pitonyak's free books, searching here - someone's usually already asked a similar question - there is the MRI Object Inspector which is invaluable. https://forum.openoffice.org/en/forum/viewtopic.php?t=49294 this extension is too: https://extensions.openoffice.org/en/pr...
by JeJe
Fri Apr 19, 2024 9:59 pm
Forum: Macros and UNO API
Topic: Can Calc Open 3rd Party Text Editor
Replies: 2
Views: 310

Re: Can Calc Open 3rd Party Text Editor

You can open a file with SystemShellExecute. This works for me on Windows, I presume Linux also. oSvc = createUnoService("com.sun.star.system.SystemShellExecute") oSvc.execute(ConvertToUrl("C:\windows\notepad.exe"), "C:\tmp\a.txt", 0) Controlling an external application...
by JeJe
Tue Apr 16, 2024 5:33 pm
Forum: Writer
Topic: Split large book file into 2 odt files
Replies: 12
Views: 1600

Re: Split large book file into 2 odt files

Have you tried selecting the first or second parts and then insert menu - section and ticking the Hide box so the section is hidden?
by JeJe
Tue Apr 16, 2024 11:14 am
Forum: Code Snippets
Topic: Alternative Full Screen for Writer (for MS Windows Only)
Replies: 0
Views: 384

Alternative Full Screen for Writer (for MS Windows Only)

AltFullScreen Extension For Writer Help (for MS Windows Only) Writer's native Full Screen feature doesn't allow access to panels or the Status bar or the Menubar. This extension is an alternative full screen which is more flexible. It only works on Microsoft Windows as it uses Windows OS Api calls. ...
by JeJe
Tue Apr 16, 2024 1:23 am
Forum: Macros and UNO API
Topic: Write access to generic statusbar item
Replies: 6
Views: 1028

Re: Write access to generic statusbar item

createContainerWindow requires a URL. If you want to create a window without one you can use createWindow but then, my understanding is, you need to do a lot more work involving attaching the dialog model etc if needed. Resizing after creating the dialog seems a non-issue to me - you can resize it b...
by JeJe
Wed Apr 10, 2024 11:56 am
Forum: Macros and UNO API
Topic: OpenOffice Automation for MailMerge and PDF Creation
Replies: 11
Views: 1326

Re: OpenOffice Automation for MailMerge and PDF Creation

If you're saying this gives an error .OutputType = com.sun.star.text.MailMergeType.FILE then have you tried the constant instead .OutputType =2 I don't know VFP but Array() creates and passes an empty array in Basic - have you tried defining an empty array in VFP and then passing that? Have you seen...
by JeJe
Wed Apr 10, 2024 11:45 am
Forum: Macros and UNO API
Topic: [Solved] Get Set Modify the script name for dialog control events
Replies: 9
Views: 1043

Re: Get Set Modify the script name for dialog control events

Do you want to assign a macro at runtime?

viewtopic.php?t=25499

If you want to take control of the IDE dialog page using basic - I think the best you could do would be to export the dialog, edit the xml file, then import the edited version.
by JeJe
Wed Apr 10, 2024 1:28 am
Forum: Macros and UNO API
Topic: [Solved] Get Set Modify the script name for dialog control events
Replies: 9
Views: 1043

Re: Get Set Modify the script name for dialog control events

You have to write the macro first in a module then double click on the dialog control in the IDE Choose the events tab of the properties window that pops up. Click on the ... at the for right for the event you want to set Click on the macro button in the assign action window to look up the macro you...
by JeJe
Mon Apr 08, 2024 4:43 pm
Forum: Writer
Topic: Slide show Writer
Replies: 9
Views: 681

Re: Slide show Writer

The XVisualNavigator extension has page previews, if it still works (its old)

https://extensions.openoffice.org/en/pr ... lnavigator

Edits: seems to still work in my OO
by JeJe
Mon Apr 08, 2024 4:39 pm
Forum: Writer
Topic: Slide show Writer
Replies: 9
Views: 681

Re: Slide show Writer

There is the organon extension, if that might be in the realm of what you're looking for:

https://extensions.openoffice.org/en/project/organon
by JeJe
Mon Apr 08, 2024 4:21 pm
Forum: Writer
Topic: Slide show Writer
Replies: 9
Views: 681

Re: Slide show Writer

If what you want is something like the slide pane on the left in Impress...

go to Window Menu/new window...
size the new window appropriately, put it on the left, and zoom to a small size so it looks like a column of whole pages
by JeJe
Mon Apr 08, 2024 1:42 pm
Forum: Writer
Topic: [Solved] Automatic Font Color Switching
Replies: 2
Views: 261

Re: Automatic Font Color Switching

Modify the paragraph style so its font is black instead of automatic.
by JeJe
Mon Apr 08, 2024 1:10 pm
Forum: Writer
Topic: Slide show Writer
Replies: 9
Views: 681

Re: slide show writer

There aren't any developers here - the forum is for helping users.

I'm unclear about exactly what feature you want... would a master document be any use for this?

https://wiki.openoffice.org/wiki/Docume ... r_document
by JeJe
Sat Apr 06, 2024 10:05 pm
Forum: Macros and UNO API
Topic: OpenOffice Automation for MailMerge and PDF Creation
Replies: 11
Views: 1326

Re: OpenOffice Automation for MailMerge and PDF Creation

My guess is its unlikely its going to be a few lines of code - some things are much longer in OO that Office VBA. So if you post what you've got and where you're stuck - at the moment you're asking us to write it all for you. (Someone might... sometimes they do... but, the idea of this is to help pe...
by JeJe
Sat Apr 06, 2024 11:58 am
Forum: Macros and UNO API
Topic: OpenOffice Automation for MailMerge and PDF Creation
Replies: 11
Views: 1326

Re: OpenOffice Automation for MailMerge and PDF Creation

Have you looked at the documentation on automation?

https://www.openoffice.org/udk/common/m ... ation.html

A search will find threads here on mail merge and PDF Creation.
by JeJe
Mon Apr 01, 2024 1:05 pm
Forum: Writer
Topic: Getting back overwritten text
Replies: 3
Views: 553

Re: Getting back overwritten text

If you removed it by cutting it eg ctr+x key there might be a copy on Window's clipboard manager (win+v). (That gets cleared on shutdown but some 3rd party clipboard managers save the history)

Removing with the delete key or selecting it and typing something to replace it doesn't do that.
by JeJe
Mon Apr 01, 2024 12:48 pm
Forum: Macros and UNO API
Topic: [Solved] Dialog - setEnabled instead of setVisible?
Replies: 2
Views: 633

Re: Dialog - setEnabled instead of setVisible?

Its setEnable not setEnabled - use MRI and you can easily find out for yourself.

viewtopic.php?t=49294
by JeJe
Thu Mar 28, 2024 6:03 pm
Forum: Macros and UNO API
Topic: Scale picture in merged Calc cells
Replies: 2
Views: 689

Re: Scale picture in merged Calc cells

Select the cells, then:

Code: Select all

thiscomponent.currentselection.size
by JeJe
Wed Mar 27, 2024 11:29 pm
Forum: Writer
Topic: Limited space in each document one create?
Replies: 13
Views: 1319

Re: Limited space in each document one create?

If you have some long text with line feed characters you could try pasting it into Notepad as an intermediary and then from there into Writer. That may convert the line feeds to paragraph marks and let you do it in one go instead of in chunks.
by JeJe
Tue Mar 26, 2024 3:59 pm
Forum: Macros and UNO API
Topic: Write access to generic statusbar item
Replies: 6
Views: 1028

Re: Write access to generic statusbar item

I just use Basic so don't know anything about creating a controller. My code to create a blank clickable status bar item in Basic is here. https://forum.openoffice.org/en/forum/viewtopic.php?t=110487 It is indeed a bit like a nasty hack, but attached is a rudimentary extension for adding a dialog to...
by JeJe
Mon Mar 25, 2024 6:53 pm
Forum: Macros and UNO API
Topic: [Dropped] Filter onto another sheet
Replies: 8
Views: 1412

Re: Sort onto another sheet

There's no changed document been uploaded.

Did you try MrProgrammer's suggestion, he's added more links to his post above?
by JeJe
Mon Mar 25, 2024 6:48 pm
Forum: Macros and UNO API
Topic: Write access to generic statusbar item
Replies: 6
Views: 1028

Re: Write access to generic statusbar item

My understanding is: Its not possible to write a statusbar controller in Basic and you'd need to use a different language. You can replace the status bar with a progress bar and some text, but then you lose the status bar features You can create a clickable blank item on the status bar in Basic. And...
by JeJe
Sun Mar 24, 2024 6:09 pm
Forum: Macros and UNO API
Topic: [Dropped] Filter onto another sheet
Replies: 8
Views: 1412

Re: Sort onto another sheet

Documents you post should have sensitive information removed. Column c only has green or no color in it. By a separate sheet you seem to mean a sheet in a different document? Perhaps you could make a simple version (with sensitive information removed) of part of the original and the matching result ...
by JeJe
Sun Mar 24, 2024 2:47 pm
Forum: Macros and UNO API
Topic: [Dropped] Filter onto another sheet
Replies: 8
Views: 1412

Re: Sort onto another sheet

Have you tried the macro recorder - sounds like it might be able to do what you're asking, or some of it? How did you do them the first time as you talk about rewriting?
by JeJe
Thu Mar 21, 2024 10:38 pm
Forum: Macros and UNO API
Topic: [Solved] Applying a new style to a page in Writer using Java code
Replies: 7
Views: 1139

Re: Applying a new style to a page in Writer using Java code

Thanks Lupp. Yeah, page styles are a paragraph property - not very intuitive. My code assumes that the applied page style's next page style will be the desired one - otherwise you'll also need to set the following page's first paragraph's page style to override the style's next page style setting.
by JeJe
Tue Mar 19, 2024 10:57 am
Forum: Macros and UNO API
Topic: [Solved] Applying a new style to a page in Writer using Java code
Replies: 7
Views: 1139

Re: Applying a new style to a page in Writer using Java code

This creates a new page style and then sets the viewcursor pagestyle to it in Basic with thiscomponent.stylefamilies.getbyname("PageStyles") ps = thiscomponent.CreateInstance("com.sun.star.style.PageStyle") .insertbyname "MyNewStyleName",ps end with thiscomponent.curren...
by JeJe
Tue Mar 19, 2024 3:07 am
Forum: External Programs
Topic: [Solved] LibreOffice Calc Sort via AU3, VBA/VBS
Replies: 5
Views: 1544

Re: LibreOffice Calc Sort via AU3, VBA/VBS

Your VB5 code runs for me within LO with an error on the line 'Set tSortField = oServiceManager.Bridge_GetStruct("com.sun.star.table.TableSortField") Looking at MRI the servicemanager doesn't have that property or method runs within LO by changing to Set tSortField = new "com.sun.star...