Thomas Lange - Sun Germany - ham02 - Hamburg wrote:
Hi Jonathan,
Jonathan Kaye wrote:
Hi all,
I posted this several days ago on comp.openoffice.questions and haven't
received anything I can use to solve the problem. Any ideas out there?
This may be a tricky one. I am helping to produce
Cor Nouws wrote:
Hi Jonathan,
Jonathan Kaye wrote (8-9-2009 16:29)
AFAIK it is not possible on competitive products. I have really really
searched the Openoffice.org website high and low and can't, for the life
of me, find where I can file a feature request. Any hints?
The mail you
Jonathan Kaye wrote:
Cor Nouws wrote:
Hi Jonathan,
Jonathan Kaye wrote (8-9-2009 16:29)
AFAIK it is not possible on competitive products. I have really really
searched the Openoffice.org website high and low and can't, for the life
of me, find where I can file a feature request. Any
Hi all,
I posted this several days ago on comp.openoffice.questions and haven't
received anything I can use to solve the problem. Any ideas out there?
This may be a tricky one. I am helping to produce a dictionary and things
are nearing completion thanks to the outstanding support from the
Drew Jensen wrote:
Thomas Lange - Sun Germany - ham02 - Hamburg wrote:
Hi Jonathan,
I have asked around, and no we have no means of creating such a page
style. Also no one could think off different means to produce a similar
effect.
Thus I'm afraid you are the first one who ever
Hi all,
I posted this on comp.openoffice.questions a few days ago. Maybe somebody on
this list can confirm that this is a bug in which case I'll file a report
(if one doesn't exist already).
I believe I have found a bug in openoffice's mail merge routine (OOo version
3.1.0 - running on
Juergen Schmidt wrote:
Hi Jonathan,
you can remove the ~/.openoffice.org/3/user/uno_packages folder
completely. The will lose all installed extensions but everyhting else
should be fine.
Juergen
Thanks Juergen,
I was aware of that option but I managed to remove it without losing the
Hi all,
I posted this a while ago on the Openoffice.questions NG. No solution was
offered but I was told it is a known problem. Maybe somebody here has some
ideas on how to solve it. I'd like to avoid removing my entire
~/.openoffice.org/3/ folder if possible.
Hi all,
Thanks to the wonderful help I received from Fernand and Christoph I have a
macro that takes a cell, emboldens the characters up to a fullstop and
leaves the remainder in normal weight. My own modest contribution was to
then remove the full stop so a cell like abcd.ef is converted to
Fernand Vanrie wrote:
snip
oTextCursor.goLeft(1, true) = highlighting(selecting)
oTextCursor.goLeft(1, False) = no slection
hope it helps
fernand
Thanks Fernand. No, the above doesn't remove the fullstop. When I get to
these last 3 lines, the cursor is one position to the left of the
Christoph Jopp wrote:
Jonathan Kaye schrieb:
Jonathan Kaye wrote:
snip
Hi Fernand,
Thanks for the reference. I had a look but there's a huge amount of
material and I didn't really see anything relevant to the situation I
described. Can you give me a hint as to how to define
Christoph Jopp wrote:
Hi Jonathan
Jonathan Kaye schrieb:
Hi Christoph,
I tried this:
Sub SetBold
Dim oDoc As Object, oSheet As Object, oCell As Object
Dim oTextCursor as Object
Dim Position as Integer
oDoc=ThisComponent
oSheet=oDoc.Sheets.getByName(Sheet1)
oCell
Christoph Jopp wrote:
snip
First, a big thank you to Fernand and Christoph for all your help. Xray is
happily running (in English). I found what the problem was and it's
actually quite funny. Maybe there is a warning about it somewhere but if
not, perhaps there should be.
I read this NG using
Hi again,
I'm now trying to get my head around how objects work in macros. I'm trying
to write a subroutine that will take the contents of a cell and embolden
the text up to a fullstop and leave the rest of the string unchanged.
Borrowing shamelessly from Andrew's excellent manual I've managed to
Jonathan Kaye wrote:
snip
Hi Fernand,
Thanks for the reference. I had a look but there's a huge amount of
material and I didn't really see anything relevant to the situation I
described. Can you give me a hint as to how to define a substring of an
object that is itself an object and so can
Fernand Vanrie wrote:
Jonathan Kaye wrote:
Hi again,
I'm now trying to get my head around how objects work in macros. I'm
trying to write a subroutine that will take the contents of a cell and
embolden the text up to a fullstop and leave the rest of the string
unchanged. Borrowing
Paolo Mantovani wrote:
Jonathan Kaye ha scritto:
Hi all,
Thanks to the excellent advice I've received I now have (I believe) a
working and bug free macro. One difficult (for me) piece of it was a
macro called cutspace which scans a string until it finds either a
fullstop or a space (let's
Johnny Rosenberg wrote:
Maybe this, if it works, also is a somewhat ugly solution…
Johnny Rosenberg
Or something like that, I don't know the exact syntax for InStr at the
moment.
It appears this doesn't work. I wanted to evaluate the function InStr and
assign its value to the
Hi all,
Thanks to the excellent advice I've received I now have (I believe) a
working and bug free macro. One difficult (for me) piece of it was a macro
called cutspace which scans a string until it finds either a fullstop or
a space (let's call it a chunk) and gathers all the tones (indicated by
Paolo Mantovani wrote:
Hi,
Il lunedì 11 febbraio 2008 20:12:48 Jonathan Kaye ha scritto:
Steffen Grund wrote:
Hello,
I am not the Basic expert here, but wouldn't something like this work?
While Position exit_value
Position = Instr(i, ProcessString, )
etc
Andrew Douglas Pitonyak wrote:
Download AndrewMacro.odt and take a look at chapter 9 Formatting macros
Hi Andrew,
Thanks for your response. I downloaded your .odt file some time ago. I
mentioned that several times on this admittedly confusing thread. I looked
at chapter 9 (Formatting Macros)
Paolo Mantovani wrote:
Lft = Lft + movetones(Chunk) +
What is movetones ?
ciao
Paolo M
I'll add a bit more detail to the previous response. Actually movetones is
part of cutspace and I gave the code for cutspace earlier in this thread.
movetones just moves the tone markers (1234) to
Andreas Saeger wrote:
Replace map with anothe name. I used XMAP.
=XMAP(B2) -- ,+; !2+ .[B!]
Thanks Andreas.
Yes I did that some time ago. I'm not sure which code you are referring to
but I changed map to various other names when Bernard Marcelly pointed out
the smart feature and suggested I
Ariel Constenla-Haile wrote:
Hi Jonathan
Jonathan Kaye escribió:
The mysterious argument is not optional error
was solved by not choosing to the run the macro from the IDE
Organize Macros-- select the relevant macro and click the Run button)
but rather running them from the spreadsheet
John Sisson wrote:
The great resource for OO-Basic programming is Andrew Pitonyak's
OpenOffice.org Macros Explained. In there is a lot of help on all
aspects of ooBasic programming including String functions such as
split() which along with trim() seems appropriate to your task.
Thanx - John
Steffen Grund wrote:
Hello,
I am not the Basic expert here, but wouldn't something like this work?
While Position exit_value
Position = Instr(i, ProcessString, )
etc. etc. etc.
Wend
and just initialize Position before, so it does not have the exit value?
Hi
Jonathan Kaye wrote:
snip
My problem was that I was running the macro from the Openoffice.org Basic
Macros window (I hit the Run button) which gave me the argument not
optional error message. When I enter the macro in the spread sheet it runs
without error which enabled be to correct the macro
Fernand Vanrie wrote:
snip
I really did try and couldn't any reference to specifying the current
cursor position. I'm sure it's in there somewhere but I can't guess what
it's called. Is there a reference manual for OOo Basic that includes all
the built-in properties, methods, functions,
Jonathan Kaye wrote:
Fernand Vanrie wrote:
snip
I really did try and couldn't any reference to specifying the current
cursor position. I'm sure it's in there somewhere but I can't guess what
it's called. Is there a reference manual for OOo Basic that includes all
the built-in properties
Hi all,
I am making slow progress on understanding the ins and outs of OOo Basic. I
have written the following macro which seems to work:
Code:
Sub oe
' Appends the character œ at the end of selected cell
Dim oDoc As Object
Dim oCell As Object
Dim oSheet As Object
Dim here As Object
oDoc =
Hi all,
I'm writing to this ng at the suggestion of someone on the
openoffice.questions ng. I hope I'm at the right place.
OOo macros are driving me crazy! I'm running OOo 2.3.1 on a linux (Debian
Lenny) box. The behaviour of macros is, to say the least flakey. I have a
macro called map thanks to
31 matches
Mail list logo