Search found 425 matches

by Mr.Dandy
Sat Feb 17, 2024 6:22 pm
Forum: Macros and UNO API
Topic: [Solved] Remove empty lines between tables
Replies: 14
Views: 2259

Re: Remove empty lines between tables

The macro works fine. Thanks
That's solved the regex issue.
by Mr.Dandy
Wed Feb 14, 2024 3:16 pm
Forum: Macros and UNO API
Topic: [Solved] Remove empty lines between tables
Replies: 14
Views: 2259

Re: Remove empty lines between tables

As I said in my first post, I would like to remove only empty lines between two tables Expected result below: capture.gif This can be done manually. But my document is of course more complex than the one shown as example. Moved from Writer forum to Macros and UNO API because Mr.Dandy wants a macro. ...
by Mr.Dandy
Tue Feb 13, 2024 10:19 am
Forum: Macros and UNO API
Topic: [Solved] Remove empty lines between tables
Replies: 14
Views: 2259

[Solved] Remove empty lines between tables

Hello,

I'm try to use this regex

Code: Select all

^$
But nothing is found
by Mr.Dandy
Fri Feb 02, 2024 4:50 pm
Forum: Site Feedback
Topic: Forum pages load slowly
Replies: 17
Views: 2527

Re: Forum pages load slowly

We do report it, as mentioned earlier (see also: https://www.mail-archive.com/dev@openoffice.apache.org/msg44995.html), but if normal users also start to report it then, maybe the infra team in charge of the servers will pay more attention. Okay, but which address? It's not specified in Dick Groska...
by Mr.Dandy
Fri Feb 02, 2024 11:08 am
Forum: Site Feedback
Topic: Forum pages load slowly
Replies: 17
Views: 2527

Re: Forum pages load slowly

In that case, why didn't you moderators send this e-mail? I think it's easier for me as simple user of this forum, to let the administrators manage their tasks (in this part named "Site feedback"). ;) Note that this morning I got a lot of errors: Peer failed to perform TLS handshake Maybe ...
by Mr.Dandy
Thu Feb 01, 2024 11:23 am
Forum: Site Feedback
Topic: Forum pages load slowly
Replies: 17
Views: 2527

Re: Forum pages load slowly

robleyd wrote: Thu Feb 01, 2024 11:18 am We - moderators - have no access to the server
Who talk about moderators?
by Mr.Dandy
Thu Feb 01, 2024 11:14 am
Forum: Site Feedback
Topic: Forum pages load slowly
Replies: 17
Views: 2527

Re: Forum pages load slowly

Isn't that what forum administrators do? ;)
by Mr.Dandy
Wed Jan 31, 2024 12:38 pm
Forum: Macros and UNO API
Topic: [Solved] [Basic] Replace Sheet with a new one
Replies: 4
Views: 1513

Re: [Basic] Replace Sheet with a new one

No options, just save as OTS :)
by Mr.Dandy
Wed Jan 31, 2024 12:29 pm
Forum: Site Feedback
Topic: Forum pages load slowly
Replies: 17
Views: 2527

Re: Slow

Reported where?


Seems to be fluent now. :)
by Mr.Dandy
Wed Jan 31, 2024 10:36 am
Forum: Site Feedback
Topic: Forum pages load slowly
Replies: 17
Views: 2527

Re: Slow

OK it's a pain

But perhaps an admin could warn the person in charge at Apache? :)
by Mr.Dandy
Wed Jan 31, 2024 9:27 am
Forum: Macros and UNO API
Topic: [Solved] List all keys in a Collection
Replies: 7
Views: 1801

Re: List all keys in a Collection

Thanks for your returns
I retain the code of Mr.Programmer
by Mr.Dandy
Wed Jan 31, 2024 9:18 am
Forum: Site Feedback
Topic: Forum pages load slowly
Replies: 17
Views: 2527

Forum pages load slowly

Hello,

The forum is frankly very slow this morning.
It takes almost a minute to get to a page.
is it just me or is there a problem?
by Mr.Dandy
Fri Jan 26, 2024 12:43 pm
Forum: Macros and UNO API
Topic: [Solved] List all keys in a Collection
Replies: 7
Views: 1801

[Solved] List all keys in a Collection

Sub Main Dim dico As New Collection dico.Add("49000", "Angers") ' key = "Angers", Item = "49000" dico.Add("33000", "Bordeaux") dico.Add("09000", "Foix") dico.Add("11350", "Cucugnan") for i = 1 to dic...
by Mr.Dandy
Sat Nov 18, 2023 11:25 am
Forum: Writer
Topic: Export link to local files from Writer to PDF
Replies: 1
Views: 796

Re: Export link to ocal files from writer to pdf - issues

Instead of a PDF, use an HTML document to run your local PDFs
by Mr.Dandy
Sat Nov 18, 2023 11:19 am
Forum: Macros and UNO API
Topic: [Solved] Change an empty node value with DocumentBuilder
Replies: 7
Views: 2399

Re: Change an empty node value with DocumentBuilder

Bidouille wrote: Thu Nov 16, 2023 12:05 pm Rather than beating about the bush
Indeed

Thanks for the code: solved! :)
by Mr.Dandy
Wed Nov 15, 2023 8:20 pm
Forum: Macros and UNO API
Topic: [Solved] Change an empty node value with DocumentBuilder
Replies: 7
Views: 2399

Re: Change an empty node value with DocumentBuilder

However I see a NodeValue property
capture.gif
capture.gif (96.11 KiB) Viewed 2216 times
by Mr.Dandy
Wed Nov 15, 2023 6:33 pm
Forum: Macros and UNO API
Topic: [Solved] Change an empty node value with DocumentBuilder
Replies: 7
Views: 2399

Re: Change an empty node value with DocumentBuilder

I don't understand what I do with this page
The c.s.s.xml.dom.DOMException returns no message:
capture.png
capture.png (116.06 KiB) Viewed 2270 times
by Mr.Dandy
Wed Nov 15, 2023 12:32 pm
Forum: Macros and UNO API
Topic: [Solved] Change an empty node value with DocumentBuilder
Replies: 7
Views: 2399

[Solved] Change an empty node value with DocumentBuilder

Come back with a new issue :( My XML is <?xml version="1.0" encoding="UTF-8"?> <item> <state>true</state> <name/> <location>A</location> <version>13</version> <features>None</features> </item> Change an existing value works but not if this is empty Sub Main sURL = ConvertToUrl(&q...
by Mr.Dandy
Sun Nov 12, 2023 5:30 pm
Forum: Macros and UNO API
Topic: [Solved] Save an XML
Replies: 6
Views: 2107

Re: Save an XML

Great!
Thanks
by Mr.Dandy
Sun Nov 12, 2023 5:11 pm
Forum: Macros and UNO API
Topic: [Solved] Save an XML
Replies: 6
Views: 2107

Re: Save an XML

NewDocument create a new document, see viewtopic.php?t=33563
by Mr.Dandy
Sun Nov 12, 2023 4:10 pm
Forum: Macros and UNO API
Topic: [Solved] Save an XML
Replies: 6
Views: 2107

Re: Save an XML

JeJe wrote: Sun Nov 12, 2023 3:44 pm But with oDocBuilder NewDocument has methods such as setOutputStream
NewDocument as its name suggests, create a blank XML
But I would like to modify an existing file
So I am therefore obliged to get parseURI method

Note that my XML is deliberately simplified, but the real file is more complex.
by Mr.Dandy
Sun Nov 12, 2023 12:02 pm
Forum: Macros and UNO API
Topic: [Solved] Save an XML
Replies: 6
Views: 2107

[Solved] Save an XML

Hello folks, I use c.s.s.xml.dom.DocumentBuilder to access and modify nodes element But this service seems not support output stream to save the file How can I do to write the tree at the end? This is a simple example Sub Main sURL = ConvertToUrl("c:\Temp\foo.xml") XmlAddValue(sURL, "...
by Mr.Dandy
Thu Nov 02, 2023 11:20 am
Forum: Macros and UNO API
Topic: [Solved] Routine to remove duplicates
Replies: 11
Views: 5318

Re: Routine to remove duplicates

Thank you very much.
You have provided me all the code what I need
by Mr.Dandy
Thu Oct 26, 2023 8:45 pm
Forum: Macros and UNO API
Topic: [Solved] Routine to remove duplicates
Replies: 11
Views: 5318

[Solved] Routine to remove duplicates

Hello folks

Removing duplicates on 2nd column (B) but keep 1st column data (A)
Expected result on D / E columns
How can I do this?
screenshot.png
screenshot.png (34.16 KiB) Viewed 5318 times
Thanks
by Mr.Dandy
Thu Oct 26, 2023 8:30 pm
Forum: Tablets
Topic: [Dropped] AndrOpen Office (Android) configuration
Replies: 5
Views: 12175

Re: OpenOffice for Android (AndrOpen Office) Configuration

eDerzawiec wrote: Wed Oct 11, 2023 10:13 pm I can access an .xls file (for example) from any directory on my phone, but it is opened in read-only mode.
Did you have same behavior with an ODS?
by Mr.Dandy
Thu Jul 13, 2023 8:57 am
Forum: Base
Topic: [Solved] LibreOffice Base: Index not found error
Replies: 7
Views: 3359

Re: LibreBase Index not found error

Are you sure that all database packages has been installed?
by Mr.Dandy
Wed Jul 12, 2023 1:48 pm
Forum: Base
Topic: [Solved] Cannot Edit My Queries
Replies: 3
Views: 2789

Re: Cannot Edit My Queries

Without see your ODB, how can you think that we can answering?
Please upload the document
by Mr.Dandy
Wed Jul 12, 2023 1:45 pm
Forum: Base
Topic: [Solved] LibreOffice Base: Index not found error
Replies: 7
Views: 3359

Re: LibreBase Index not found error

The database seems to be corrupted.
Which format is used: HSQL native or external, Firebird, another?
by Mr.Dandy
Tue Jun 20, 2023 11:32 am
Forum: Macros and UNO API
Topic: HTTP GET request in JavaScript
Replies: 6
Views: 2605

Re: HTTP GET request in JavaScript

robleyd wrote: Tue Jun 20, 2023 10:15 am You made no previous reference to Rhino - whatever that may be.
https://wiki.openoffice.org/wiki/Docume ... ipt_Editor
I don't know other editor to make this in AOO.
by Mr.Dandy
Tue Jun 20, 2023 10:05 am
Forum: Macros and UNO API
Topic: HTTP GET request in JavaScript
Replies: 6
Views: 2605

Re: HTTP GET request in JavaScript

robleyd wrote: Tue Jun 20, 2023 8:56 am Maybe these links can help - they refer to the Fetch API ?
Did you try to execute in Rhino editor?
These don't work.