[Solved] Calc cell: Characters property from Excel

[eeigor]

Help me find an analog of Excel range property:
Property Characters ([Start], [Length]) As Characters

in order to change the color of individual characters with a macro.

[Villeroy]

The cell supports interface com.sun.star.text.XTextRange as shown by the MRI extension.

[eeigor]

Need a usage example. I can't figure out how to find and extract the substring.
@Villeroy, please show me how to work with the getText(), getStart(), and getEnd() methods. Read-only. And setString().

[Villeroy]

I don't know. If I ever had to do that (luckily I don't have to), I would start MRI and read
https://wiki.openoffice.org/wiki/Docume ... _Documents
https://wiki.openoffice.org/wiki/Docume ... _Documents

[Lupp]

This is only a relic of the original thread. The subject was changed, and most of the posts vanished.
Now the thread is tagged SOLVED despite the fact that there is no solution.

There couldn't be a solution in the full sense since a property delivering the information asked for doesn't exist.

However, the deleted posts contained two workarounds: One by Villeroy using a Python script, and one by myself using the Calc function REGEX() available in LibreOffice V 6.2.0 or higher calling it in a macro via FunctionAccess. Both these workarounds were restricted to cases where the findings of a search (which actually were the ranges the question mentioned) did not include (parts of) the string-representation of a TextField.

[MrProgrammer]

This is only a relic of the original thread. The subject was changed, and most of the posts vanished.

The topic was split because the OP asked a second question (about RegEx) after the original one was solved. Forum policy is one subject per topic. The later posts, including those you mentioned, are in Does LO have a RegEx object?

Now the thread is tagged SOLVED despite the fact that there is no solution.

The split topic says the original question was solved:

With that it is more or less clear.

Unfortunately the forum software does not allow a user's post to be split in the middle of it. I would have preferred for that sentence to remain with the original topic and the split topic to begin with the next "Another question …" sentence. But this isn't possible, nor is it possible to duplicate the post so I can put one in each topic. I suppose I could put that in my own post, but forum moderation is enough work when user's don't start new topics appropriately.

[eeigor]

I'll be more careful in the future.

[Zizi64]

Here is a sample file that show you how to colorize letters individually by a macro in a Calc Cell (created and tested in LibreOffice):

Gradient color.ods

(22.88 KiB) Downloaded 153 times

viewtopic.php?f=7&t=77844

[eeigor]

Looks mesmerizing...