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&#x
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 f
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?
&
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 on
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 Openo
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 Debian/test
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 t
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.
--
Fernand Vanrie wrote:
> 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 ful
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 abcdef
Christoph Jopp wrote:
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 Knode KD
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=This
Christoph Jopp wrote:
> Jonathan Kaye schrieb:
>> Jonathan Kaye wrote:
>>
>>
>>
>>> 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 th
Christoph Jopp wrote:
> Jonathan Kaye schrieb:
>> Jonathan Kaye wrote:
>>
>>
>>
>>> 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 th
Fernand Vanrie wrote:
>>>
>> As a follow-up to my previous message, I can see that
>> oCell=oSheet.getCellByposition(0,0) 'A1
>> and then
>> oCell.CharWeight = com.sun.star.awt.FontWeight.BOLD
>> should make the contents of oCell bold. What I don't understand is how to
>> make a substring of
Jonathan Kaye wrote:
> 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 it
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 leav
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 g
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
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
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 val
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 cli
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 suggest
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 Macro
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
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?
>> >
>> > W
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
Steffen Grund wrote:
> Hello,
>
> I am not the Basic expert here, but wouldn't something like this work?
>
> While Position <>
> Position = Instr(i, ProcessString, " ")
> etc. etc. etc.
> Wend
>
> and just initialize Position before, so it does not have the exit value?
>
>
Johnny Rosenberg wrote:
Hi Johnny and Ariel,
Thanks to both of you. Your advice was extremely helpful and I've been able
to carry on a fair bit until hitting the next obstacle. The contextual help
available in the Macro editor really speeds things up and the methods that
Johnny suggests are also
Jonathan Kaye wrote:
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 th
Hi all,
Trying to write these Basic macros is extremely frustrating. I'm sure I'm
missing some basic documentation somewhere but I can't find it for the life
of me.
I have written the follow macro:
Function SimpSet(ProcessString) As String
Dim Position As Integer
Position = InStr(Pr
Jonathan Kaye wrote:
> Fernand Vanrie wrote:
>
>
>>> 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 refe
Fernand Vanrie wrote:
>> 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, su
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 = ThisCom
Bernard Marcelly wrote:
> Hi Jonathan,
>
> Message de Jonathan Kaye date 2008-02-06 06:30 :
>
>> I want to set up a column in a spreadsheet containing 18 fields. So in
>> cell T1 I enter the following: =map(b1) and I get the following
>> behaviour: a window opens
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 t
36 matches
Mail list logo
