Search found 2773 matches
- Tue Apr 16, 2024 5:33 pm
- Forum: Writer
- Topic: Split large book file into 2 odt files
- Replies: 12
- Views: 1536
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?
- Tue Apr 16, 2024 11:14 am
- Forum: Code Snippets
- Topic: Alternative Full Screen for Writer (for MS Windows Only)
- Replies: 0
- Views: 328
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. ...
- Tue Apr 16, 2024 1:23 am
- Forum: Macros and UNO API
- Topic: Write access to generic statusbar item
- Replies: 6
- Views: 1010
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...
- Wed Apr 10, 2024 11:56 am
- Forum: Macros and UNO API
- Topic: OpenOffice Automation for MailMerge and PDF Creation
- Replies: 11
- Views: 1285
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...
- 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: 1006
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.
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.
- 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: 1006
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...
- Mon Apr 08, 2024 4:43 pm
- Forum: Writer
- Topic: Slide show Writer
- Replies: 9
- Views: 665
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
https://extensions.openoffice.org/en/pr ... lnavigator
Edits: seems to still work in my OO
- Mon Apr 08, 2024 4:39 pm
- Forum: Writer
- Topic: Slide show Writer
- Replies: 9
- Views: 665
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
https://extensions.openoffice.org/en/project/organon
- Mon Apr 08, 2024 4:21 pm
- Forum: Writer
- Topic: Slide show Writer
- Replies: 9
- Views: 665
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
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
- Mon Apr 08, 2024 1:42 pm
- Forum: Writer
- Topic: [Solved] Automatic Font Color Switching
- Replies: 2
- Views: 253
Re: Automatic Font Color Switching
Modify the paragraph style so its font is black instead of automatic.
- Mon Apr 08, 2024 1:10 pm
- Forum: Writer
- Topic: Slide show Writer
- Replies: 9
- Views: 665
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
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
- Sat Apr 06, 2024 10:05 pm
- Forum: Macros and UNO API
- Topic: OpenOffice Automation for MailMerge and PDF Creation
- Replies: 11
- Views: 1285
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...
- Sat Apr 06, 2024 11:58 am
- Forum: Macros and UNO API
- Topic: OpenOffice Automation for MailMerge and PDF Creation
- Replies: 11
- Views: 1285
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.
https://www.openoffice.org/udk/common/m ... ation.html
A search will find threads here on mail merge and PDF Creation.
- Mon Apr 01, 2024 1:05 pm
- Forum: Writer
- Topic: Getting back overwritten text
- Replies: 3
- Views: 546
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.
Removing with the delete key or selecting it and typing something to replace it doesn't do that.
- Mon Apr 01, 2024 12:48 pm
- Forum: Macros and UNO API
- Topic: [Solved] Dialog - setEnabled instead of setVisible?
- Replies: 2
- Views: 618
Re: Dialog - setEnabled instead of setVisible?
Its setEnable not setEnabled - use MRI and you can easily find out for yourself.
viewtopic.php?t=49294
viewtopic.php?t=49294
- Thu Mar 28, 2024 6:03 pm
- Forum: Macros and UNO API
- Topic: Scale picture in merged Calc cells
- Replies: 2
- Views: 685
Re: Scale picture in merged Calc cells
Select the cells, then:
Code: Select all
thiscomponent.currentselection.size
- Wed Mar 27, 2024 11:29 pm
- Forum: Writer
- Topic: Limited space in each document one create?
- Replies: 13
- Views: 1311
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.
- Tue Mar 26, 2024 3:59 pm
- Forum: Macros and UNO API
- Topic: Write access to generic statusbar item
- Replies: 6
- Views: 1010
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...
- Mon Mar 25, 2024 6:53 pm
- Forum: Macros and UNO API
- Topic: [Dropped] Filter onto another sheet
- Replies: 8
- Views: 1400
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?
Did you try MrProgrammer's suggestion, he's added more links to his post above?
- Mon Mar 25, 2024 6:48 pm
- Forum: Macros and UNO API
- Topic: Write access to generic statusbar item
- Replies: 6
- Views: 1010
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...
- Sun Mar 24, 2024 6:09 pm
- Forum: Macros and UNO API
- Topic: [Dropped] Filter onto another sheet
- Replies: 8
- Views: 1400
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 ...
- Sun Mar 24, 2024 2:47 pm
- Forum: Macros and UNO API
- Topic: [Dropped] Filter onto another sheet
- Replies: 8
- Views: 1400
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?
- 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: 1128
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.
- 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: 1128
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...
- Tue Mar 19, 2024 3:07 am
- Forum: External Programs
- Topic: [Solved] LibreOffice Calc Sort via AU3, VBA/VBS
- Replies: 5
- Views: 1485
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...
- Tue Mar 19, 2024 2:31 am
- Forum: External Programs
- Topic: [Solved] LibreOffice Calc Sort via AU3, VBA/VBS
- Replies: 5
- Views: 1485
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...
- Mon Mar 18, 2024 12:38 am
- Forum: External Programs
- Topic: [Solved] LibreOffice Calc Sort via AU3, VBA/VBS
- Replies: 5
- Views: 1485
Re: LibreOffice Calc Sort via AU3, VBA/VBS
Have you tried the macro recorder?
- Fri Mar 15, 2024 1:07 am
- Forum: Code Snippets
- Topic: List of Writer Textsections in document order
- Replies: 3
- Views: 1110
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.
There may not be an exact match with the navigator list given by the view cursor position in the case of sections in frames.
- Wed Mar 13, 2024 5:11 pm
- Forum: Code Snippets
- Topic: List of Writer Textsections in document order
- Replies: 3
- Views: 1110
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...
- Wed Mar 13, 2024 3:55 pm
- Forum: Code Snippets
- Topic: List of Writer Textsections in document order
- Replies: 3
- Views: 1110
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,...