Search found 2773 matches

by JeJe
Tue Apr 16, 2024 5:33 pm
Forum: Writer
Topic: Split large book file into 2 odt files
Replies: 11
Views: 675

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: 59

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: 929

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: 1206

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: 931

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: 931

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: 651

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: 651

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: 651

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: 245

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: 651

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: 1206

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: 1206

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: 539

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: 564

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: 628

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: 1306

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: 929

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: 1340

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: 929

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: 1340

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: 1340

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: 1073

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: 1073

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: 1269

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...
by JeJe
Tue Mar 19, 2024 2:31 am
Forum: External Programs
Topic: [Solved] LibreOffice Calc Sort via AU3, VBA/VBS
Replies: 5
Views: 1269

Re: LibreOffice Calc Sort via AU3, VBA/VBS

You're perhaps not getting other repliers because people here aren't using Autoit and can't explore your problem. As an alternative, if you can use get / setDataArray then presumably Autoit can call its own sort array function? r =thiscomponent.sheets(0).getcellrangebyname("A1:A5") dataarr...
by JeJe
Mon Mar 18, 2024 12:38 am
Forum: External Programs
Topic: [Solved] LibreOffice Calc Sort via AU3, VBA/VBS
Replies: 5
Views: 1269

Re: LibreOffice Calc Sort via AU3, VBA/VBS

Have you tried the macro recorder?
by JeJe
Fri Mar 15, 2024 1:07 am
Forum: Code Snippets
Topic: List of Writer Textsections in document order
Replies: 3
Views: 1053

Re: List of Writer Textsections in document order

CORRECTED ERROR IN THE SORTING ROUTINES

There may not be an exact match with the navigator list given by the view cursor position in the case of sections in frames.
by JeJe
Wed Mar 13, 2024 5:11 pm
Forum: Code Snippets
Topic: List of Writer Textsections in document order
Replies: 3
Views: 1053

Re: List of Writer Textsections in document order

The problem is, if a document is reopened then the textsections will be in document order, but when any textsections are added they get appended to the api list, not added in document order. Or if sections are moved their position is not changed in the API list either. And sections can't be found us...
by JeJe
Wed Mar 13, 2024 3:55 pm
Forum: Code Snippets
Topic: List of Writer Textsections in document order
Replies: 3
Views: 1053

Re: List of Writer Textsections in document order

This is to order in both dimensions but that diverges from the list in the navigator in OO which doesn't do so. (again very limited testing)* REM ***** BASIC ***** Option Explicit Sub GetTextSectionInDocOrderIncHorizontal dim cont,vc,ts, i as long,y as long,ub as long,j as long,k as long, x as long,...