[users] Re: CLI Interface Question

[Andrew Douglas Pitonyak]

On 01/23/2012 06:37 PM, Mark LaPierre wrote:

Hey Y'all,

Is there any way to tell Oo how to open a file?  when I open a .txt 
file with this command line:


openoffice.org -writer -o ${JPATH}/${JFILE}

I get an "ASCII Filter Options" dialog where I have to select my Char 
set, Defaut font, and Language.  I don't need this dialog.  I just 
want it to open my text document without arguing with me.


Linux mushroom.patch 2.6.32-220.2.1.el6.i686 #1 SMP Thu Dec 22 
18:50:52 GMT 2011 i686 i686 i386 GNU/Linux


CentOS 6.2

Oo 3.2.1

On Fedora, I tried "soffice -o foo.txt &" and it opened the file without 
asking me questions. How is your file encoded? Is it really straight ASCII?


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Will OOo be killed?

[Andrew Douglas Pitonyak]

Excellent!

On 12/14/2011 05:21 PM, Dennis E. Hamilton wrote:

"I wonder if they will need to migrate that one after it moves out of incubator 
stage..."

No. That transfer can and will be done automatically.

  - Dennis


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Will OOo be killed?

[Andrew Douglas Pitonyak]

On 12/14/2011 02:27 AM, Michelle Konzack wrote:

Hello Michael Adams,

Am 2011-12-14 08:53:21, hacktest Du folgendes herunter:

Do not worry. This list is meant to stop soon anyway. It will just
fade away.

What do you mean with this?

I believe that this particular list has been replaced by an Apache list

http://incubator.apache.org/openofficeorg/mailing-lists.html

This list: ooo-users-subscr...@incubator.apache.org 



I wonder if they will need to migrate that one after it moves out of 
incubator stage...


There is a similar list for LibreOffice

us...@global.libreoffice.org

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Help with writing macro

[Andrew Douglas Pitonyak]

On 09/20/2011 04:48 PM, Grzesiek Sójka wrote:
I need to write a macro accepting variable length parameter list. I 
was tryint to googl but no luck. So the question is how to write 
(preferably in OpenOffice Basic) macro accepting variable length 
parameter list.
I am not aware of any way to write a macro that accepts an totally 
arbitrary number of parameters. That said:


*** (1)
You can specify as many arguments as you desire to be optional. The 
disadvantage is that you must then set an upper bound on the number of 
arguments, and then you must also test each argument to see if it was 
included.


*** (2)
When you call a macro as a function from Calc, ranges are packaged and 
sent as an array, which means that you require only a single variable 
for each range included. This may, or may not, be of use.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: how to de-duplicate.

[Andrew Douglas Pitonyak]

Because this is a one time thing, I would take the fastest path to 
success. This is a bit cumbersome, but, you did say that you only needed 
to do this ONCE!


* Place the data of interest in column A
* Sort Column A. With the options, you can turn case sensitivity on and 
off, etc. Probably do not need to do this, but hey

* If it is not there already, add a column header. I used "Names".
* Select the data including the column header
* Use DAta > DAta Pilot > STart
* For "Source", use "current selection", which is what should be marked 
already, and click OK
* I have this strange dialog now, and there is "Name", the column 
heading", shown next to the buttons. Drag "Name" into the "Row Fields" area.

* Click OK.

You just created a Data Pilot, that is probably at the bottom of your 
data. The rows are the unique values for that column. You can copy those 
as you desire I believe.


I have other methods as well, but, this is probably the most interesting 
method.




On 09/05/2011 06:39 PM, Bob Marcus wrote:
I’m relatively new to ooS, but I am not finding a key word in the 
usual Help.
I have a single column on a spreadsheet with some 8000 entries.  Many 
of the entries are duplicate words, some with variations on 
capitalizations.  I want to relist that one column to show only a 
single entry for each word.  That is, I want to consolidate the 
entries so that I have only one entry for each of the words in the 
column.  Again, that is if I have the word ‘metal’ listed 10 times, I 
want a new list with that word, ‘metal’,  only once.
I see that there are pro programs to buy but my use is one time and I 
think I remember that there is some formula.

Thanks for any advice.
Bob M


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Auto backup?

[Andrew Douglas Pitonyak]

Side note:

Assume that your primary hard drive will fail. I have lost three hard 
drives in the last year (all the same brand, h) [two different 
computers at different sites].


So, if possible, set backups so that you have a copy on a physically 
different drive. I am current poking around to see what is needed to 
call a custom macro after a save event. The intent is to store a backup 
for a specific document on a USB key. I do not know much else about the 
requirement for this macro (since it is not my macro, I am just trying 
to figure out how to tie in as needed).


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Open Office installation Problem?

[Andrew Douglas Pitonyak]

Are you logged in as an administrator with full rights to the computer?

On 07/22/2011 02:33 PM, thomas.gardi...@sbcglobal.net wrote:

Hello,
I have "Failed" repeatedly to install Open Office 3.3 on my HP dc5100 
Desktop, with Windows XP Pro.,Pentium 4, 3GHZ, 3GB Memory.
I have tried with and without Norton Anti Virus enabled. Tried 
Installing as downloading and from Install file saved on desktop.
In ever case,I find a Open Office Installation File folder on my 
Desktop, containing 54 MB of files but  I get the attached error 
message near the end of installation?

*
I have successfully installed OpenOffice from the same download source 
on; another Identical HP dc5100 desktop(with same specs) and on a Dell 
D620 and IBM T40 237314U laptops. All have Windows XP Pro OS?

Can anyone suggest a solution to my "Failed Installation"?
I will appreciate any available help
Thomas Gardiner


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Problems

[Andrew Douglas Pitonyak]

Start OOo from the command line with the parameter "-norestore" So,

soffice -norestore

Also, take a look at this link. The information is old, so I do not know 
if it still applies:


http://tboxmy.blogspot.com/2008/06/openofficeorg-document-recovery-screen.html




On 07/16/2011 06:58 AM, geoff Lander wrote:

I am not able to concentrate on lenghty instructions for medical reasons.

Every time I open the program to maintain a document I get a recovery 
screen on which I am unable to start recovery because the button isn't 
visible and refuses be moved onto the screen. Openoffice is now 
unusable.  I have deleted the document converned and reloaded open 
office to no avail.  Openoffice has to be cancelled to continue with 
anything else.  Can you help?  Link me to the answerl?p.

I have tried your help pages but find them huge and totally confusing.

Mr Lander


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Base as desktop Database

[Andrew Douglas Pitonyak]

On 07/15/2011 02:53 PM, Eduard Filipas wrote:

hi

i been looking around and i can find several odbc ways to connect 
diffrent databases to OO.Base..but cant find article how to establish 
odbc connection from my executable to OO.Base. Is it possible for 
OO.Base to act as desktop database server ? i have small aplication in 
mind ..

Sadly, I do not believe that this is supported.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: set cell's value?

[Andrew Douglas Pitonyak]

On 07/04/2011 03:15 PM, Michael Adams wrote:

On Tuesday 05 July 2011 05:29, James wrote:

I want to put an 'x' in Calc cells based on whether another cell's
date (totalincoming) is larger than a different cell's value.
I started this macro but is there an easier way?
How do I set a cell's value?

I'd forget the macro and just use 'IF' or am i missing something?
=IF(B3>C3;"X";"O")

And of course, Mr. Adams beat me to the best answer! :-)

Should have rad all the replies before responding.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: set cell's value?

[Andrew Douglas Pitonyak]

On 07/04/2011 01:29 PM, James wrote:
I want to put an 'x' in Calc cells based on whether another cell's 
date (totalincoming) is larger than a different cell's value.

I started this macro but is there an easier way?
How do I set a cell's value?


Well, off hand, i would say that you cannot depending on how the macro 
is called. If the macro is called as a function from in the sheet, then 
that function may not directly change the value of a cell in the same 
sheet that caused the function to be called. if the macro is called 
based on some other event (or if the cell that you desire to change is 
on another sheet), then it is fine.





REM  *  BASIC  *

' put an 'x' in cells where totalincoming (06:41:45) is greater or 
equal to flatrateincoming (06:36)

Sub Main( totalincoming As Date, flatrateincoming as Date )
Option Explicit
dim cellcontents as string

If totalincoming >= flatrateincoming Then
cellcontents = "x"
End If

' set current cell's value


This part is a bit tricky. First of all, you must be able to get the 
cell of interest. You probably want to do something like:


Dim oCell
oCell = ThisComponent.getSheets().getByName("Sheet1").getCellByPosition(2,4)


Now, what do you want to set? A string

oCell.setString("X")

A numeric value

oCell.setValue(3.141592654)



End Sub
If the values are known to be held in specific cells, then just use a 
formula in the cell of interest. You can also write your own function, 
that simply returns the value of interest, and call that function 
(macro) from the cell of interest.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: set cell's value?

[Andrew Douglas Pitonyak]

On 07/04/2011 01:34 PM, RA Brown wrote:

James wrote:

I want to put an 'x' in Calc cells based on whether another cell's date
(totalincoming) is larger than a different cell's value.
I started this macro but is there an easier way?
How do I set a cell's value?


REM  *  BASIC  *

' put an 'x' in cells where totalincoming (06:41:45) is greater or equal
to flatrateincoming (06:36)
Sub Main( totalincoming As Date, flatrateincoming as Date )
 Option Explicit
 dim cellcontents as string

 If totalincoming>= flatrateincoming Then
 cellcontents = "x"
 End If

 ' set current cell's value

End Sub

Being a bit nit-picky here.  This that a date or time?  There is a
difference.
Ummm, well, that kind of depends. Date and time are represented as a 
floating point number. The integer portion represents the date, and the 
fractional portion represents the time. Although one might argue that a 
time only value has the date portion set to zero, but, that represents a 
very specific date. Also, setting the time portion to 0, also happens to 
correspond to a valid time value.


So, if you state that it is a time value only, this means that you 
simply assume it to be true (kind of sort of).


I know, only the Mathematicians and some of the physicists and some 
number of engineers agreed with me.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Templates

[Andrew Douglas Pitonyak]

On 06/14/2011 01:00 AM, David Howells wrote:

Hello,

Would you please advise me on downloading the best Open Office 
templates for writing a book?  I could not find one in my searches.


David
I created my own template. The authors project has their own templates 
as well.


http://www.odfauthors.org/openoffice.org/english


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Problem with Cross-Reference

[Andrew Douglas Pitonyak]

On 05/15/2011 09:35 PM, Adam wrote:



On Fri, May 13, 2011 at 1:13 PM, RA Brown > wrote:


Adam wrote:


   Yes, it can be very much of a problem.  The MS formats were
closed
   and had to be reversed engineered to get what is available.
 The






Funnily enough if I use the Page number instead of the paragraph 
number in cross references it works fine. That is


Instead of using Insert > Cross r_e_ference... > Numbered Paragraphs 
and then selecting "Number" in the "Insert reference to" option


If you use Insert > Cross r_e_ference... > Numbered Paragraphs and 
then select "Page" in the "Insert reference to" option


then your document is saved with correct cross references.

I sense that this is a relatively easy bug to fix and would enable 
better and safer functionality when needing to work with partners 
using MS Word.


Adam

The problem may not be that OOo must improve its ability to import and 
export to the doc format. it is a fact that the ODF format can represent 
certain things that the DOC format cannot. The same is also true. Now, I 
do not know for certain that this is one of those instances, but, the 
last item that I checked it was the case. (it was related to multiple 
instances of a certain type of index and the ODF format itself did not 
support it). OOo has the ability to represent certain types of running 
page format changes that Word is not able to handle. I don't remember 
some of the others. I do remember spending a couple of hours trying to 
figure out how to produce certain table formatting in Word.


Do not remember any other examples off hand... but I think that I have 
seen others.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Inserting a page before a table

[Andrew Douglas Pitonyak]

On 05/16/2011 08:44 AM, Dave Barton wrote:

 Original Message  
From: william drescher
To: users@openoffice.org
Date: Mon, 16 May 2011 06:44:38 -0400


On 5/15/2011 3:45 PM, Richard Detwiler wrote:

On 5/14/2011 11:01 AM, william drescher wrote:

I have a form that consists of one table. The table starts at
the very beginning of the page. I can not figure out how to
insert a new page before the table. I can't get the cursor
outside of the table at the top.

How ?

Thanks in advance.

Bill


I'm using OOo version 3.1.1 (not the newest, I realize). I just
tried it and found it to be simple: I put the insertion point to
the left of the first character in the upper left hand cell of
the table, and press Enter, and it moves the table down one line
and puts the insertion point at the top of the page, outside of
the table.

In some earlier version, I remember struggling to do that task,
though.

In my case OO 3.3.0, the table goes to the left margin and clicking to
the left just highlights the first row.

bill

You seem to have misunderstood Richard's instructions. Put the insertion
point (ie. the flashing caret/cursor position indicator) INSIDE the top
left hand cell of the table, as indicated by the * in the rough
illustration below:

| *123 | 456 | 789 |

| abcd | efg | hij |

Assuming the top left hand cell contains the number 123, position the
flashing caret immediately to the left of the 1 and press Enter.

Hope this helps.

Dave

It seems that this only works if the text table is the very first thing 
in the document. In other words, if you do this once and it works, then 
try it again you will not have another new line inserted before the text 
table.


Hmm, ok, if the thing immediately before the text table is another text 
table, it will insert a newline before the text table as well. Wow, I 
remember when the only method was to write a macro to manually force a 
new paragraph before the text table; big improvement.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Potential Problems with Large Documents?

[Andrew Douglas Pitonyak]

On 05/15/2011 03:34 PM, jonathon wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 15/05/2011 08:16, Andrew Douglas Pitonyak wrote:


If you open AndrewMacro.odt in OOo 3.3 and then close the document, OOo
will crash. This is because there are more than 32K (or is that 64K)
style changes in the document. Note that this bug is fixed in OOo 3.4 I
believe (or at least the dev versions that I have run contain the fix).

Can you explain "more than 32K style changes in the document" in more
detail?

I don't remember ever having OOo crash because I was using too many styles.

Even in those documents that contained text in a hundred different
languages, and a dozen paragraph styles for each language.
IOW, text that used more than 1,000 paragraph styles, in addition to
umpteen hundred (¿500?) character styles, 30+ page styles, 100+ list
styles, and ten frame styles.

OOo was stable.

Saving the document to MS Word format, and then opening it with MSO on
Windows is a different story. It is trivial to create documents with OOo
on Windows, that when opened with MSO on Windows will cause an instant
Blue Screen of Death.

jonathon


You really need to work at it to exceed the number of supported styles. 
With 30 pages, you probably require 1000 to 2000 changes per page. With 
500 pages, you require you still require like 60 to 120 changes per 
page.  OK, it is 2^16 items in the sfx item pool that causes the problem.


This is the bug report I opened in 2008.

http://www.openoffice.org/issues/show_bug.cgi?id=104896


Seems that I was not the first to find the bug and report it This 
was posted in 2007


This contains the technical details and provides the fix (available in 3.4)
http://openoffice.org/bugzilla/show_bug.cgi?id=84159


If you want to see the bug in action, download AndrewMacro.odt as 
referenced below (save all your data first, in fact, I would close all 
your other documents). After loading my document, well, just close it 
and watch OOo Crash. Note that OOo will run just fine with its current 
size of 535 pages until you do close it, however.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Potential Problems with Large Documents?

[Andrew Douglas Pitonyak]

If you open AndrewMacro.odt in OOo 3.3 and then close the document, OOo 
will crash. This is because there are more than 32K (or is that 64K) 
style changes in the document. Note that this bug is fixed in OOo 3.4 I 
believe (or at least the dev versions that I have run contain the fix). 
At 100 pages, you are likely pretty safe. AndrewMacro.odt contains an 
extreme number of style changes because of color-coded program listings. 
This means that there may be hundreds of changes per page.


On 05/14/2011 02:28 PM, Adam wrote:
I've been reading with interest the thread on "Crisis-Thesis 
Corrupted" and just wondered, I have a document that is now 5Mb in 
size, 100 A4 pages and contains close to 40 images that is about 2 
days away from being completedis there any physical document size 
constraint or potential problems with large documents that I should be 
aware of? Or are there any precautions that can be recommended. I do 
regular backups but would just die if anything should happen to 
prevent me from successfully completing this document.


Thanks for nay feedback on this...

--
Adam (wanting to tread cautiously)



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Re: Crisis-Thesis Corrupted

[Andrew Douglas Pitonyak]

On 05/12/2011 04:11 AM, Kara Samantha Mcdermott wrote:
Alright. My College Thesis has been "corrupted." I am not fooling 
around here. My college education is at stake, and I am unamused, I 
have my document, and it is is bringing up the "ASCII" shenanigans. It 
has been corrupted- alright. I need it to be fixed. My thesis is due, 
Friday.


My guess is that you are an undergraduate English major.

I have many people working on fixing it, to no avail. OpenOffice has 
ruined my college education.


Ideas to find newer copies:

Ask your adviser for their last review copy.

If you emailed a copy, check your sent your box. I know many people that 
use email as off-site storage for very important documents, and the 
email out box (depending on the email client) as secondary storage in a 
different location.


It is corrupted, without fixing. The best that anyone can do is pull 
up an old, seriously un-revised copy from months ago. I have a few 
issues.

A. Why did this happen?


Any answer is highly speculative.

I inspected your document with a binary editor and it is nothing but 
zeros. I have seen this two times. In both cases, a drive failure 
occurred while the file was being written to disk. I cannot speculate, 
but, if you noticed something "bad" while saving the document (OOo 
crashed, Windows locked, etc), that may provide a clue.


B. Why can't I pull up an old copy? I saved hundreds of times, today 
alone.


My guess is that you always saved to the same file. If the file is 
damaged while the file is being saved, then the good file is 
over-written by junk. I have never experienced this, well, not with OOo 
anyway. Also, if there is a bad sector on your hard drive where the file 
was stored, then that file may not be recoverable using normal means. 
With my my last hard drive failure (last month), I lost everything on 
that drive. The failure before that, I only lost about 20 files that 
occupied areas of the disk that were no longer readable.


Side Note:
Assume that your drive will fail and backup important data. The drive 
may be fine, but it also may not be. If you have a techno-nerdy friend, 
ask them if they know how to check the SMART information on the drive. 
Most drives these days are able to notice and report errors. My Linux 
computer does a dandy job of this; my Windows computer not so much. When 
I last lost everything, it was on a Windows computer that never said a 
word until the drive was unusable and the problem manifested itself as a 
read error. An inspection of the Windows event log showed that the drive 
had been reporting numerous errors long before the drive failed. 
Ironically, it was the backup drive that failed so I did not even suffer 
down time on that failure.



C. I will not graduate now, because I will not be able to hand this in.
There is no fixing this. No apology will be good enough.


Approach your professor and academic adviser to assess the impact on 
your graduation and on the diploma. Interested in the final results.




Kara McDermott


--
Andrew Pitonyak


--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help

[users] Spell check multiple languages in OOo

[Andrew Douglas Pitonyak]

Question posed here:

http://www.oooforum.org/forum/viewtopic.phtml?p=418838

Stated as follows:

I write in four languages, sometimes I use more than one language in the 
same document.
The spellcheckers of the languages used do work. But there are several 
deficiencies to the language selection mechanism which I explain by 
examples:


The immediately visible language list starts with the language of the OO 
Installation i.e.German (Germany) which you cannot change. Then there is 
the language of your area, in my case German (Switzerland).


If I want to change to US English, I have to browse from Australia via 
another 12 counties before I get to US English. After this my 
immediately visible language list has 3 languages, German (D), German 
(CH) and English (US).


Now I select a paragraph or an arbitrary chunk of text and want this to 
be Italian. So I click "More" and what a surprise: I am offered the menu 
to select a font. So temporarily I have to select Italian for the whole 
document in order to spellcheck the Italian part. After that I want to 
continue in English, but English has been replaced by Italian in the 
immediately visible list. So again I have to click “More” and then again 
I browse from Australia to the US.


[b]I propose:[/b]
- Let the user define an immediately visible list of languages of his 
choice.
- Repair the problem with the selection of paragraphs and other text 
selections and doing so
- offer the possibility to change language “From here to the Begin” and 
“From here to the End”.


--

Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--

To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: sy...@openoffice.org with Subject: help

[users] Re: OO default

[Andrew Douglas Pitonyak]

Lisa,

I cannot comment on how the mac install functions, but in the Windows 
Install, if you desire OOo to be the default for file types other than 
OOo file types, then you must explicitly state this during the install. 
So, if you were using a windows computer I would say that this occurred 
specifically because you told it to. Note that this is an easy (and 
common) error to make. Many years ago, this was the default and you had 
to uncheck it if you did not want it, now, you must check it if you do.




On 03/16/2011 01:25 AM, Lisa Dee wrote:
First - hardly a rant - merely expressing an opinion. I still contend 
that is presumptuous to set OO as default launcher. Second - I don't 
use Microsoft - only save my Pages (Mac) documents as Word .doc for 
those who do not have Mac OS.


When I do the "Open With", it only allows me to check a box that says 
"Always open this document with" - there is no box for "Change All 
Like This"


Thanks anywayI'll have to figure out how to make OO not my default 
launch...



Does this help:
http://www.fileinfo.com/help/mac-change-program.html
http://osxdaily.com/2009/10/25/change-file-associations-in-mac-os-x/


btw - I don't mind working with OO, just prefer the option is all - no 
offense meant.


Although it is not true of all people, my opinion is that it should be 
difficult to take offense at your comments :-)



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

--

To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: sy...@openoffice.org with Subject: help

Re: [users] Verify bug in OOo Web Browser Preview

[Andrew Douglas Pitonyak]

On 02/20/2011 01:19 PM, Eric Wood wrote:

On 2/20/2011 12:20 PM, Andrew Douglas Pitonyak wrote:
I am using OOo Calc. I have a document with several sheets, some 
contain data, others contain graphs. In Calc, I click File>Preview in 
Web Browser. It displays the document very nicely in my browser 
(either Chrome or IE8). However, to display the graphs, OOo creates 
.jpg files in a temporary folder, and the HTML of the page OOo has 
created has the wrong file path for these files, so they do not 
display. I



For Win XP, OOo 3.3.0 the scr="" doesn't contain any path:
Eric, based on your feedback, the user in question moved from 3.2 to 3.3 
and the problem went away. Thanks for the help.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Verify bug in OOo Web Browser Preview

[Andrew Douglas Pitonyak]

On 02/20/2011 01:19 PM, Eric Wood wrote:

On 2/20/2011 12:20 PM, Andrew Douglas Pitonyak wrote:
I am using OOo Calc. I have a document with several sheets, some 
contain data, others contain graphs. In Calc, I click File>Preview in 
Web Browser. It displays the document very nicely in my browser 
(either Chrome or IE8). However, to display the graphs, OOo creates 
.jpg files in a temporary folder, and the HTML of the page OOo has 
created has the wrong file path for these files, so they do not 
display. I



For Win XP, OOo 3.3.0 the scr="" doesn't contain any path:


Eric, thanks for giving this a try...

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] Verify bug in OOo Web Browser Preview

[Andrew Douglas Pitonyak]

http://www.oooforum.org/forum/viewtopic.phtml?p=415074

I am running Linux, is someone able to reproduce this bug? I don't want 
to open a bug report on something that I cannot test for a few days.


User has: Calc on Windows 7 64-bit, IE or Chrome

Part of the statement is as follows:

I am using OOo Calc. I have a document with several sheets, some contain 
data, others contain graphs. In Calc, I click File>Preview in Web 
Browser. It displays the document very nicely in my browser (either 
Chrome or IE8). However, to display the graphs, OOo creates .jpg files 
in a temporary folder, and the HTML of the page OOo has created has the 
wrong file path for these files, so they do not display. I think this 
must be a bug in OOo, because it repeats part of the file path, and it 
seems that if I repeat the process described above, the file path gets 
longer each time, by further repetitions of the same part, as I 
mentioned in my original post.



Mabb, as an admin, I have access to your direct email address, so I 
chose to Blind Carbon Copy you on this email so that you will know that 
it was sent but others cannot see your email address (and I did request 
permission for it to be known). Will see if we have any responses.



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: API to clone a row in a writer's table

[Andrew Douglas Pitonyak]

On 12/31/2010 07:16 AM, Sandro wrote:

Thanks Andrew,

Andrew Douglas Pitonyak  pitonyak.org>  writes:>


Note that I have not tried anything that I am about to suggest

1. Insert the new row where you desire it to be.

2. Use the view cursor to select the row that you desire to duplicate.

3. Use a dispatch to copy row to the clipboard.

4. Move the view cursor to the new position and use a dispatch to paste
the row into the new row.

after sending this mail I did also investigate the solution with dispatcher,
but I realized I couldn't understand how to move the viewcursor to the
correct location... moreover I mean to use it in a headless environ and I
wasn't sure that this is the best solution.


I expect that in headless mode you will likely NOT have a view cursor. 
Unfortunately, the view cursor may be the only way to easily select an 
entire row, but, a cell cursor may also work (I almost never do this so 
I would need to invest a few hours to understand it. I rarely have a 
few hours)


My best guess without looking anything up (because it is late and my 
wife told me to come to bed) is that you can use the current controller 
to select (it should support something like this: 
"currentcontroller.select(oCell)", but, that is just a guess.



  Anyhow this is what I did:


  table = document.TextTables.getByIndex(0)
  cell = table.getCellByPosition(0,1)
  controller=document.getCurrentController()
  frame=controller.getFrame()
  view_cursor=controller.getViewCursor()

 ...  how to move the cursor to the cell??

  dispatcher =  context.ServiceManager.
 createInstance('com.sun.star.frame.DispatchHelper')

  dispatcher.executeDispatch(frame, '.uno:EntireRow', '', 0, tuple())
  dispatcher.executeDispatch(frame, '.uno:Copy', '', 0, tuple())
  dispatcher.executeDispatch(frame, '.uno:Paste', '', 0, tuple())
  dispatcher.executeDispatch(frame, '.uno:JumpToNextCell', '', 0, tuple())


Yes, I had exactly this sort of thing in mind. This likely fails in 
headless mode, however. May have to use a cell cursor or similar. 
Copying arbitrary text, however, is tricky at best.


  

Note: This will likely fail with a complex table and special care is
required for complex content (such as when a cell contains multiple text
objects; for example, an embedded image).

The case I'm dealing with now is simple but as it is part of a template
system that is public I can't make assumptions on how complex will the real
templates be.


I disagree. There is no shame in stating that certain things will ONLY 
work on a simple table (which is the majority case anyway).



I think that new provisions may exist for copying text content. If that is
the case, you may be able to copy the text content in each cell to the new
cell in the new row.

Can you explain what you mean by "new provisions may exist for copying text
content". I think this is what I was looking for but I was not able to find
a way neather for copying text and style nor for pasting it!...


In a Calc document, I can specifically say "copy this range over there" 
without using any other special thing like the clipboard. For all I know 
that may actually work in text tables as well since they share many 
similarities to a Calc Sheet (again, I did not verify). it looks 
something like this:


Sub CopySpreadsheetRange
  REM Get sheet 1, the original, and 2, which will contain the copy.
  oSheet1 = ThisComponent.Sheets.getByIndex(0)
  oSheet2 = ThisComponent.Sheets.getByIndex(1)

  REM Get the range to copy and the rang to copy to.
  oRangeOrg = oSheet1.getCellRangeByName("A1:C10").RangeAddress
  oRangeCpy = oSheet2.getCellRangeByName("A1:C10").RangeAddress

  REM The insert position
  oCellCpy = oSheet2.getCellByPosition(oRangeCpy.StartColumn,_
oRangeCpy.StartRow).CellAddress

  REM Do the copy
  oSheet1.CopyRange(oCellCpy, oRangeOrg)
End Sub

This may be related to this:

http://api.openoffice.org/docs/common/ref/com/sun/star/text/XTextCopy.html

http://api.openoffice.org/docs/common/ref/com/sun/star/text/XTextTableCursor.html

Never used the XTextCopy, never seen it used. Perhaps you can ask on the 
d...@api.openoffice.org mailing list.


thanks for your time
sandro
*:-)


On 12/28/2010 11:36 AM, Sandro wrote:

Hi,
I already spent many hours on this problem and I can't find the correct
approach.  I really hope someone can help me or point me in the correct
direction/reading.

I need to programmatically duplicate rows of a Table in openoffice writer.

It's not difficult to add rows via table.Rows.insertByIndex(idx, count),
that adds empty rows and it's easy to add text in that row assigning
DataArray to the CellRange. Doing this way you loose control on the style of
the cells and specifically if a cell has words with different style
(bold/italic) they get flattened to the

Re: [users] API to clone a row in a writer's table

[Andrew Douglas Pitonyak]

Note that I have not tried anything that I am about to suggest :-)

1. Insert the new row where you desire it to be.

2. Use the view cursor to select the row that you desire to duplicate.

3. Use a dispatch to copy row to the clipboard.

4. Move the view cursor to the new position and use a dispatch to paste 
the row into the new row.


Note: This will likely fail with a complex table and special care is 
required for complex content (such as when a cell contains multiple text 
objects; for example, an embedded image).


I think that new provisions may exist for copying text content. If that 
is the case, you may be able to copy the text content in each cell to 
the new cell in the new row.





On 12/28/2010 11:36 AM, Sandro wrote:

Hi,
I already spent many hours on this problem and I can't find the correct
approach.  I really hope someone can help me or point me in the correct
direction/reading.

I need to programmatically duplicate rows of a Table in openoffice writer.

It's not difficult to add rows via table.Rows.insertByIndex(idx, count),
that adds empty rows and it's easy to add text in that row assigning
DataArray to the CellRange. Doing this way you loose control on the style of
the cells and specifically if a cell has words with different style
(bold/italic) they get flattened to the same face. What I need is to
duplicate a row in a way that preserves the style of each word in the
cell/row.

This is the last step of a Python template system that uses openoffice
(http://oootemplate.argolinux.org). I access the document via 'uno'
interface in Python but any language would do to explain the logic behind
it.

thanks in advance


sandro
*:-)


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: Embed Syntax Highlighted Source Code

[Andrew Douglas Pitonyak]

On 12/25/2010 04:57 PM, Thangalin wrote:

Hi,

I was actually trying to find a working solution.


I expect that you will not find a fully automated working solution for 
your specific problem. Then again, I suspect that you and I have 
previously exchanged messages on this topic (or at least one other 
person desired to do exactly the same thing)


1. Link to external text files
2. Notice when a text file has changed and update the internal 
representation
3. Provide "pretty printing" or "color coded  pretty display" of 
multiple languages



I looked at your example document and, as far as I could tell, it was syntax
highlighting but it was not syntax highlighting externally stored source
files. It looked like you had to copy and paste the source code into the OO
document, and then manually apply the syntax highlighting. That means having
two copies of the same source, which is duplication, and not ideal.


In a perfect world I suppose that you will setup a repository which you 
can then poll. Your document must then be set to update itself based on 
the files. Come to think of it, perhaps you can wet something so that 
the document can generate itself in some specified format. Seems doable 
if you have the skills.




--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Question

[Andrew Douglas Pitonyak]

While using OOo, it is better to use OOo's native format, which is ODF.

On 12/22/2010 01:31 PM, Marius Popa wrote:

Good evening! I am also Marius Popa and I want to know if OpenOffice.org
v3.2.1 is able to save .xps files. What format is better: XPS or ODF?



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Emailing: ScreenShot009

[Andrew Douglas Pitonyak]

On 12/01/2010 02:31 PM, Tony Layland wrote:
Hello, the attached error message occurs every time I open OpenOffice. 
How can I correct this

thanks


If you go to the directory specified (C:\Documents and Settings\Tony 
Layland\Application Data\OpenOffice.org\3\user\basic\Standard), OOo is 
trying to load a file named script.xlb. I assume that this file either 
contains an error or it does not exist and it is referenced someplace.


The corrective action depends on which as well as what other macros 
and/or you may have. For example, if you have no settings, you can 
delete (or rename) the entire 3 data directory (but then you lose all of 
your personal stuff such as macros you created. You can try to correct 
the error in the script.xlb file if it does exist. If the file does not 
exist, you could try to create one containing this:



1.0//EN" "library.dtd">
http://openoffice.org/2000/library"; 
library:name="Standard" library:readonly="false" 
library:passwordprotected="false">



or, perhaps this


1.0//EN" "library.dtd">
http://openoffice.org/2000/library"; 
library:name="Standard" library:readonly="false" 
library:passwordprotected="false">








--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Fwd: Macro Management

[Andrew Douglas Pitonyak]

On 12/02/2010 03:04 AM, JOE Conner wrote:

On 12/1/2010 9:10 PM, Andrew Douglas Pitonyak wrote:

On 12/01/2010 09:46 PM, JOE Conner wrote:

Please, someone, direct me to some documentation that describes step by
step how to copy a macro from a document to "MY MACROS."  Or,
alternatively, give me a step by step how to.  All my attempts seem to
not succeed, sometimes it looks like they have copied, only to be upon
examination actually an empty shell.

WinXP Pro w/SP3.
OOo 3.3.0 RC7.

Joe Conner, Poulsbo, WA USA


Couple of things to watch for, first of all, you can NEVER 
over-write the standard library. I mention this in this document 
(http://www.pitonyak.org/OOME_3_0.odt) that I lack the time to 
finish from my published book.


So, if you desire to copy the Standard library, you must manually 
copy the data, but, I will not bother to discuss that for now.


Ignoring the standard library, you should be able to do the following:

use Tools > Macros > Organize Dialogs then select the Libraries tab

The drop down location must read "My Macros & Dialogs"

Select Import

Select the document containing the macro

Select the libraries that you desire to import. Do NOT try to import 
the Standard library


If desired, you may choose to replace any existing library. If you do 
not, it should not over-write an existing library, but I have not 
verified this.


Thanks Andrew, that gets me closer.  Unfortunately, the macro I am 
trying to import is called "Module1" and is the only macro in the 
"Standard" folder.  The import does not drop down deep enough  into 
the "standard's" internals to chose the desired macro.


I wish there were an add-on that did a descent job of managing macros.

Thanks again for your time and thoughtful answer.

Joe Conner, Poulsbo, WA USA

Module 1 is in the Standard library so you CANNOT import it directly. 
You must use the IDE to manually copy the code to the clipboard and then 
paste it into a new module.


You can import libraries, not modules.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Fwd: Macro Management

[Andrew Douglas Pitonyak]

On 12/01/2010 09:46 PM, JOE Conner wrote:

Please, someone, direct me to some documentation that describes step by
step how to copy a macro from a document to "MY MACROS."  Or,
alternatively, give me a step by step how to.  All my attempts seem to
not succeed, sometimes it looks like they have copied, only to be upon
examination actually an empty shell.

WinXP Pro w/SP3.
OOo 3.3.0 RC7.

Joe Conner, Poulsbo, WA USA

*Sorry for the noise, I used the wrong email account so the email you 
see right above here will show up as MODERATED in a few days.  
Meanwhile, I still need the answer.  Thank you.*
Couple of things to watch for, first of all, you can NEVER over-write 
the standard library. I mention this in this document 
(http://www.pitonyak.org/OOME_3_0.odt) that I lack the time to finish 
from my published book.


So, if you desire to copy the Standard library, you must manually copy 
the data, but, I will not bother to discuss that for now.


Ignoring the standard library, you should be able to do the following:

use Tools > Macros > Organize Dialogs then select the Libraries tab

The drop down location must read "My Macros & Dialogs"

Select Import

Select the document containing the macro

Select the libraries that you desire to import. Do NOT try to import the 
Standard library


If desired, you may choose to replace any existing library. If you do 
not, it should not over-write an existing library, but I have not 
verified this.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Upgrade to Fedora 14 killed OOo

[Andrew Douglas Pitonyak]

On 11/30/2010 01:16 PM, John Jason Jordan wrote:

On Tue, 30 Nov 2010 01:26:42 -0300
Ariel Constenla-Haile  dijo:yes :-)

yum localinstall  --nogpgcheck ooobasis* openoffice*

according to the help
  --nogpgcheck  disable gpg signature checking
so it won't matter if the packages are not signed.

Thanks. Got it reinstalled now, and have added the correct exclude line
in /etc/yum.conf so future upgrades won't overwrite any of the files.



That Ariel is everywhere always giving great advise. Feel like I 
should buy some of these people a yummy beverage...


Forgot about yum.conf. A problem if you do not. I forgot a few times 
very bad results.



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Upgrade to Fedora 14 killed OOo

[Andrew Douglas Pitonyak]

This happens every time for me (since I use the official release).

My fix is similar to the following:

rpm -qa | grep -i ooobasis > foo.txt
rpm -qa | grep -i openoffice >> foo.txt
rpm -e `cat foo.txt`

The first two lines add a list of the OOo RPMs in foo.txt
The third line removes them all.

After I do this, then I re-install the official OOo. My problem is 
always that some of the libraries are not properly linked if I do not do 
this.




On 11/29/2010 07:51 PM, John Jason Jordan wrote:

I have OOo 3.2.1 installed on Fedora 14, x86_64 (Gnome). The version I
installed was downloaded from OOo, not installed from the Fedora
repositories.

Yesterday I upgraded Fedora 13 to Fedora 14, including a lot of updates
since Fedora 14 was released. Today none of my launch menu items will
launch the program. The program files appear to be intact in /opt/, but
nothing works. From the command line I go to the folder containing
(e.g.) swriter, type swriter, and get an error that there is no such
command.

I tried reinstalling, but yum said all the packages are already
installed. That is, except I didn't reinstall the desktop integration
package. I suspect reinstalling it might cure the problem, but I don't
know which package to install:

  ...freedesktop-menus...
  ...mandriva-menus...
  ...redhat-menus...
  ...suse-menus...

It's probably either freedesktop or redhat, but I don't want to install
the wrong one. I can't remember which one I used before, and I can't
find anything in the documentation.

Can someone help me get my OOo working again?

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] copying from calc to writer

[Andrew Douglas Pitonyak]

On 11/18/2010 02:14 AM, Brian Barker wrote:

At 13:44 17/11/2010 +0530, Anand Warik wrote:
Brian Barker please solve one more problem, that of turning the 
object 90 degree


Er, why me, please - why not another of this list's 2500 subscribers?!


:-)
Because you Mr. Brian Barker are a Calc stud
I even saw your phone number on the wall in the public restroom "for 
help with Calc, call 555-B-Barker



In fact, I'd thought of the technique later described by Thomas Lange, 
but I held back in case anyone found a simpler method.


Brian Barker


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Upgrade 3.1.1 to 3.2.1 (Fedora)

[Andrew Douglas Pitonyak]

On 11/02/2010 01:16 PM, John Jason Jordan wrote:

I have OOo 3.1.1 installed (from OOo, not from repositories) on Fedora
11 x86_64. I have downloaded and untarred the x86_64 RPM for 3.2.1 from
OOo. I have also made a full system backup and also made a copy
of my .openoffice.org config folder.  Before I install I have some dumb
questions:

1) Do I have to uninstall 3.1.1 first, or will the new install
overwrite the old?


If I am feeling very paranoid, then I remove any add-ons that I 
installed before I proceed.


I have no idea, but, when I install on my Fedora box, I always uninstall 
the previous version first. I find the process a bit involved, however. 
I use rpm to generate a list of what is already installed:


First, I create a file that contains the OOo specific files. Note that 
the first line uses a single > to redirect the output to a new file and 
the second line uses >> to append to the existing file.


rpm -qa | grep openoffice > o.txt
rpm -qa | grep ooobas >> o.txt

Look in o.txt to see the files that are present. What is missing from 
this list? When I install OOo, it usually installs a JRE. The desktop 
integration files should be included (if any). You can decide if you 
care about the JRE or if you want to leave it.


Next, I remove all of the files from the file.

rpm -e `cat o.txt`

The first portion, "rpm -e" tells rpm to remove a RPM list. using the 
back-tick character `, says that the list should come from the command 
cat o.txt, which prints the contents to the screen.


Now, is this what you should do? I suppose that you can use yum to 
remove OOo from your computer, never used it to do so.


You installed a new version, so, there is another potential problem. yum 
will now try to update what your new version that did not come from a 
repository. If you edit etc/yum.conf and add the line 
"exclude=openoffice*", then yum will not try to do this.




2) If I need to uninstall, I could use a hand with the yum syntax, as
I'm not very familiar with yum from the command line. There are a lot
of packages and I need to be sure I get them all. I found numerous
instructions on the net (all different), but I can tell that the syntax
is wrong.

3) I have a ton of personal settings and extensions in
~/.openoffice.org. Are there any issues with 3.2.1
I have not noticed any problems yet with 3.2.1, and I use it a lot on 
Fedora.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] OpenOffice.org community council - only Oracle employees now??

[Andrew Douglas Pitonyak]

On 10/30/2010 05:19 AM, jonathon wrote:

On 10/28/2010 07:00 PM, Ingrid Halama wrote:


I look at the votes of the issues.

Looking at them is a possibility.
However, the history of Issuezilla clearly demonstrates that votes have
zero impact and zero influence in what Sun allowed to be added to OOo.

Voting was clearly a sham, a means of creating the delusion that Sun was
allowing the community to state their preferences.


Sun / Oracle employees state that they look at the votes. I have seen 
exchanges by developers discussing what has the most votes while 
deciding on what to work. On the other hand, it is also clear that 
voting is not the only criteria used while deciding what will be done.




What is being ignored here, is that Oracle _OWNS_ the code that is in
the OOo cvs system. So much so, that it can, and does legally distribute
that code under a closed source, proprietary license.


So, do you take offense with StarOffice and the fact that Oracle / Sun 
makes money selling licenses with support? Note that the final product 
contains proprietary content (or at least last I checked it did). In the 
very early days, regular expressions and the database component were 
part of the proprietary content. Over time, these portions have been 
redone as open. I have no idea now what the value add is other than 
support (meaning I don't know how many of the previous value adds still 
exist).




Er no. The issue is that neither Sun nor Oracle grokked FLOSS, and are
simply using it as q way to get, or more preceisly, attempt to obtain
developers that they (Sun, and then Oracle) do not have to pay.

Sun, and subsequently Oracle, deliberately chose a Non-FLOSS license
that they require all code to be distributed under. The ones that are
playign the policital game, by choosing clsoed soruce licensing is Sun,
and Oracle, not Go-OO and LibreOffice.


I have worked with more than one company that are not willing to move to 
a product that does not have support provided by the company that 
produces it. The irony was not lost on me that I had no available 
support for the MS Products in question. For some products, however, the 
company actually sent people to our site to provide support. Will they 
change their position over time? Perhaps, slowly.


I am unclear how any of this pertains to the original post...

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Change path for .~lock.xyz files

[Andrew Douglas Pitonyak]

Exactly - as this is the only place where it makes sense.

Not really - it causes problems when you try to edit a document that you
have read/write privs for, but the doc is located in a folder where you
do NOT have privs to create NEW files. I know, because this bug has
created big problems for me - but when I reported it, of course I was
told it isn't a bug, it is an 'improvement'... right, it is an
improvement that changes the way it worked for YEARS, and caused (and
still causes) me no end of grief.

I would *love* the ability to change the path for the lock files... or
better yet, I'd prefer for OOo to go back to the way it determined if a
file was being edited or not prior to the change (don't remember which
version this changed in, but it was some time ago)...

Thanks (again) devs..
Did you open a bug report with an appropriate description (ie, unable to 
open a document read-only in a directory to which you cannot write... 
Hard to argue with "not able to open a document for edit in a directory 
you cannot write").


If they shoot you down, then change it to enhancement and convince 
others to vote on it. Not reasonable to expect an enhancement to be 
created just because it is something that you want. On the other hand, 
if you want it as well as a 200 of your closest friends and relatives it 
is more likely to receive attention.


Finally, perhaps you can implement this yourself, but, there are very 
specific reasons that it is now done this way. For years, there were 
complaints of how it used to be handled because of specific networking 
shares (or something like that). Because of this, I doubt that they will 
revert to the old method without making it a configuration specific 
thing (or perhaps setting something in the environment).


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] Using Read Please with OOo

[Andrew Douglas Pitonyak]

 ReadPlease is used by people with vision problems.

http://www.readplease.com/

A user mentioned that they installed this and it initially worked fine, 
but, after a restart, they are uncertain how to trigger it in OOo 
version 3.1 on Windows XP.


I use Linux, not Windows, so I am not able to install and test. Any 
windows users familiar with this product? My guess is that it does not 
integrate with OOo and it is simply a question on how to trigger the 
product from OOo.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Linked code, syntax highlighting, frames, and captions

[Andrew Douglas Pitonyak]

 On 10/14/2010 07:51 PM, Thangalin wrote:

Hi!

I would like to do the following:

- Link to an external source code file (for example a SQL script in ASCII
format)
- Apply syntax highlighting to the imported text
- Place the highlighted text inside a frame
- Add a caption to the frame
- Edit the external source file and have OpenOffice refresh the linked
content and re-apply syntax highlighting

Is this possible? If so, how? I could not find any examples.



You can see how I format code for display in this extension
http://extensions.services.openoffice.org/en/project/CodeFormatter

The purpose is to make it "pretty", but not to maintain this while 
editing. There is an explanation of an older version of this here:


http://www.pitonyak.org/AndrewMacro.odt

Be warned, however, that there is a bug in OOo that will cause OOo to 
crash when you close AndrewMacro.odt (a fix is in the works for the 
bug). So, be certain to save all your work frequently after you open 
this document. This might avoid the trouble (I think this link is good).


http://www.pitonyak.org/AndrewMacro.pdf

This is a tricky problem. If you really want it for editing, should 
probably write something specifically for that, or just get an editor 
that supports this sort of thing out of the box.



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Exporting a database table

[Andrew Douglas Pitonyak]

 On 09/29/2010 07:11 AM, Drew wrote:

On Tue, 2010-09-28 at 20:52 -0700, Jeffrey Needle wrote:

I'm trying to export an Open Office database table to a dBase IV file.
I can't figure out how to do it.  The Save As option on the file menu is
grayed out.  Can someone please advise?  Using WinXP.  Thanks.


Hi Jeff,

Well, this is just so intuitive I can't understand why you didn't figure
it out for yourself...*ROFL*

First:

Create a new Base File.

now in the New Database wizards select
'connect to existing database'
(Yes, I know there is no existing dBase file yet, but hey..)
For a type select bBase
Finish the wizard process by selecting a directory for the dbf files.
Finish and open the new Base file, of type dBase.

Now open your existing Base file.

Grab your table and drag/drop it to the new Base file.

The Copy table wizard launches.

That's it...see intuitive.

Really though not too bad, once you know.


My head hurts!

You are correct, not intuitive. Never would have figured that out 
without prompting. Wow


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] drawing arc with defined angle (was Re: [users] inaccessible toolbar)

[Andrew Douglas Pitonyak]

 On 09/28/2010 03:18 AM, Mike Scott wrote:

On 28/09/2010 03:48, Andrew Douglas Pitonyak wrote:


It would be nice to see something where the radius and angle of an arc
could be defined by keyboard entry, in the way position and rotation
can. Mind you, OOo seems not alone in this area - xfig and inkscape
have afaics a similar issue; I didn't try any of the $M packages :-}

When precise angles and dimensions were an issue, I used a macro to
produce the shapes. Seems silly, I know...



The only silliness is that OOo doesn't provide the necessary control. 
It would be so simple, surely! An arc needs a (radius, angle) property 
sheet just as much as a rectangle needs a (width, height) one.


(Maybe I need to get more into the OOo API. But I'd rather be 
producing pictures than macros :-)  )


It is silly that you must, but, it is the only method I have found to 
totally specify what you desire to do.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] drawing arc with defined angle (was Re: [users] inaccessible toolbar)

[Andrew Douglas Pitonyak]

 On 09/27/2010 10:21 AM, Mike Scott wrote:

On 27/09/10 04:23, Bruce Martin wrote:

Dear Mike and all:

There is an add-on to Oo Draw known as CAD00o. This gices you some 
limited

CAD-Like macros, but they are a bit more awkward to use for a CAD
experienced user than Autocad. But them they are free, not a matter 
of $5000

or More US$.


I've now tried that. Clunky, clunky! But with the aid of a few guide 
lines and high magnification, I've made something near enough for now. 
Thanks for the tip.


It would be nice to see something where the radius and angle of an arc 
could be defined by keyboard entry, in the way position and rotation 
can. Mind you, OOo seems not alone in this area - xfig and inkscape 
have afaics a similar issue; I didn't try any of the $M packages :-}
When precise angles and dimensions were an issue, I used a macro to 
produce the shapes. Seems silly, I know...


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] OOo users at Linux Fest in Columbus Ohio

[Andrew Douglas Pitonyak]

 On 09/15/2010 10:44 AM, webmas...@krackedpress.com wrote:
  
Wish I was there.  I lived there in the late 70's and early 80's.

Downtown not too big, but there was a lot of shopping malls
and you could find almost anything you needed for almost any
industry in one of those businesses and shops.

Did they have it in the big building in the state fair grounds?
They have/had one of the largest single floor building for such
events for 200-300 miles around.
It was held at the convention center that did not exist in the 70's and 
80's :-)


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] OpenOffice.org OOoBasic macros for oowriter and oocalc: How to add comments to our macros so that the comments appear in the Dialog box when choosing a Macro to run or edit, etc., like the

[Andrew Douglas Pitonyak]

 I expect that this is not possible by default unless it is somehow 
related to say a hot-key or icon that you have created. In other words, 
I do not expect that you will see this while selecting a macro from the 
standard OOo run macros dialog. Would be nice if I am wrong, however.


On 09/19/2010 04:09 AM, Akhil (Yahoo ID) wrote:


OpenOffice.org OOoBasic macros for oowriter and oocalc: How to add 
comments to our macros so that the comments appear in the Dialog box 
when choosing a Macro to run or edit, etc., like the comments of Built 
in Commands ?



OpenOffice.org OOoBasic macros for oowriter and oocalc, set 01 of many

Attached zip contains some macros.

Would like them to be used and improved  by others.

Some questions :

How to add comments to our macros so that the comments appear in the 
Dialog box when choosing a Macro to run or edit, etc., like the 
comments of Built in Commands ?





13:22 19-09-2010

auth...@documentation.openoffice.org
users@openoffice.org





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html

Re: [users] OOo users at Linux Fest in Columbus Ohio

[Andrew Douglas Pitonyak]

 I dropped 40 minutes of raw high-def video in the mail this morning, 
so you should have it in two days Drew


I will let you edit the video down as you desire...

S, guys, you can look for more video to come.

On 09/14/2010 09:51 AM, Drew wrote:

Hi folks,

A quick follow up to the list participants.

As for prowling for video "man on the street" interviews - didn't get
any done.

Sunday evening Joyce and me had the pleasure of
visiting Andrew and his family, at his home.

Where I did manage to, after a delicious home made taco
dinner with lots of fresh garden veggies, and glass of California table
wine, get us in front of a video camera for a bit of
OpenOffice.org talk.

About 50 minutes of raw video

Here is a quick 2 minute Intro, with Andy's $0.02 StarOffice
history and a lesson for the kids.

lower quality clip on youtube
http://www.youtube.com/watch?v=39fkR62lrAE


Higher quality file of this clip ~43 meg for download at:
http://ooo.baseanswers.com/olf/ooo-intro.ogg

Anyhow - I will not clog this mailing list with announcements as I edit
the next couple of clips where we actually talk about the application
and the project - rather will continue those on the discuss list.

Thanks

Hope to see more folks at next years Ohio Linux Fest...or ?

Drew



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] OOo users at Linux Fest in Columbus Ohio

[Andrew Douglas Pitonyak]

 I was "asked" to work a "bit" of overtime, so, I have planned little 
to nothing, but, my intention was to discuss this Saturday at lunch.


I know that Kevin cannot make it Saturday, so, anyone that wants to stop 
in Friday sometime between 4:30 and 10:00, drop me a line to tell me you 
are coming. If you are hungry or thirsty I will provide something, so 
don't worry about eating (not that I have given any thought as to what I 
will do). Y'all can meet my girls, Husband to one, Father to two.


I will send a separate email to those that expressed an interest with 
directions to my house.


On 09/08/2010 07:23 PM, Drew wrote:

Hi Andrew,

Well, only a few days till the festival now.

Joyce and I are both excited to be meeting everyone. We will be in
Friday afternoon.

Saturday lunch at the gomono sounds excellent - and I've take the
liberty to Tweet the address and time a few times.. :>)

The Ohio LinuxFest folks announced the 1,000 registration a few days ago
and I'll be on the prowl, video recorder in hand, looking for folks
willing to answer, on camera, in 2 minutes or less two questions:

What do you think of OpenOfice.org now.
Where would you like to see it go.

Both you and Corfy may consider yourselves forewarned.

See you there,

Drew

On Tue, 2010-08-24 at 22:31 -0400, Andrew Douglas Pitonyak wrote:

OK, so who is attending Linux Fest in Columbus Ohio this year?

http://ohiolinux.org/

September 10 - 12

I, Andrew Pitonyak will be there.
Drew Jensen (the Base GURU) will be there
Jason "Corfy"  (OOo Forum Moderator) will be there

Seems like an opportunity for us OOo folks to get together Friday night,
Saturday night, or something similar.

Historically, Jason and I have gone to lunch on Saturday at BD Mongolian
Grill (you pick your food and spices then they cook it for you).

http://www.gomongo.com/
http://www.gomongo.com/locations/locationDetails.php?loc=25

bd's mongolian barbeque
295 Marconi Blvd.
Columbus OH  43215
(614) 586-0077

If there is sufficient interest, I will attempt to setup something else
as well (Like Friday and/or Saturday dinner). I will probably try to
include my wife and two young daughters (I like spending time with them,
what can I say), which may mean a kid friendly location, or simply
having people swing by my place (since I live about 10 minutes from
downtown).

So, who is interested? I can provide my cell phone for people worried
about being lost.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] file storage

[Andrew Douglas Pitonyak]

 On 09/01/2010 12:21 PM, David Barton wrote:

hello
i am a new user to OpenOffice.  do i understand correctly that my application
and files are stored on my hard drive  ( like MS office ) and not off site  (
like google apps ) ?

tnx  dave barton
OOo (OpenOffice.org) will indeed save your files on your computer. When 
you use File > Save or File > Save As, the dialog should show you were 
the file is to be saved.



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Showing formatting codes

[Andrew Douglas Pitonyak]

 On 08/31/2010 10:50 PM, Bob Knepper wrote:

You said>The issue is whether or not the individual is willing to invest the time 
into learning how to use OOo,<


And this is exactly what I tell people while we are gearing up for a 
project using MS Word. The bottom line is that if you move to a new 
product, that is the truth of the matter. I see this over and over every 
time a new version of Windows or Word is released (I can't tell you how 
many hours I have already lost dealing with the new security paradigm in 
Windows 7 as opposed to XP).


On average, if I throw OOo into the face of a casual user, I expect them 
to be comfortable in a week. A very advanced user close to a month 
(because they have so much more to learn).


It is just wrong to assume that any competing product is obvious or 
intuitive. I have blown long periods of time trying to accomplish things 
in competing products (while using "expert users") that I was able to 
just do in OOo. It becomes obvious because you learn the general paradigm.


I am not arguing that OOo is easy and obvious in all areas after you 
learn the paradigm (mailing labels style annoy me every time I do them), 
just that I think that the statement above is absolutely correct.




This condesending response to Seamas O Brogain may be true but contributes to 
the negative opinions.   I'm sorry because I had planned to use OOo, and may 
still.


I missed the comments. Couldn't say if they were condescending or not; 
hope not...



Bob Knepper



Well Bob, if you opt to jump in, you will find some exciting new 
capabilities, and strongly miss a few of your favorite features from 
your current product; it is always so.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Showing formatting codes

[Andrew Douglas Pitonyak]

 Note that my intention for my questions was related to what is 
expected from the macro, not how are they implemented in OOo.


More below and inline.

On 08/31/2010 10:58 AM, John Kaufmann wrote:

In a message dated 2010.08.31 08:29 -0500, Andrew Douglas Pitonyak wrote:

I used a version [of WordPerfect Reveal Codes] once. I don't remember 
what it showed.


Which of the following [numbers added to facilitate discussion] are 
shown:


[1] Page styles
[2] Numbering styles
[3] character styles
[4] paragraph styles
[5] font change
[6] italics
[7] bold


To begin: 3 and all attributes of 3 (like 5,6,7 and much more), based 
on an early WP model of styles being either Open (going on forever) or 
Paired (going on until style closes).  That style model, in turn, is 
based on a natural model of formatted text as (a) a stream of 
characters (b) laid down on some output medium (screen, paper, etc).  
IOW, it's a model very like SGML/HTML with styling, except that (at 
least the last time I looked), styling is not cascaded from multiple 
sources.  That means that, to a larger extent than Word or Writer, 
much is under the user's control in the WP model.  Style groupings 
that are media-dependent (like 1) or structural (like 4, or tables), 
can be defined as a user-defined grouping.  For example, I can make a 
style "Envelope" and /call/ it a page style, but at root it is simply 
a Paired style.


Next: 2, although WP calls them "Outline styles" - being any 
hierarchical style set, nested to any level determined by the user (as 
opposed to Writer's fixed 10 levels).


So, as word processing goes, it's a very sleek, elegant and powerful 
model, derived from considering the basic elements of putting thoughts 
down on a medium of display, and letting the user build style 
constructs as needed, rather than defining construct classes.  Reveal 
Codes shows them all - built-in attributes (like Bold) and 
user-defined styles (that might include Bold). [Note that WP 
distinction between "attributes" (which are always paired - of 
definite duration) and "styles" (which may be paired or open).]  There 
is /nothing/ in a document that is not revealed.  [I have Writer 
documents with spacing problems that I have not been able to diagnose; 
that never happened to me with WordPerfect - because, if needed, I 
could always look at the positioning codes.]




Does this differentiate between a change based on a style and a hard
coded change?


Yes, explicitly.



What I was really asking is.

Does the user requesting a reveal codes to have it pointed out to them 
that a change is caused by a style or because the user selected the text 
and said "make this bold". If I work with text directly, this can be 
tricky to differentiate. Also, what if the user says "remove that bold 
thing", does this mean to implement a "hard coded change", or try to 
determine if that attribute was set by a style and then possibly remove 
the style. I think that the later is too difficult to implement.





What does it mean to delete a style from the display?


The style is removed, with all attributes of which it is composed.



Does this mean that things are set to use the default style, or to
inherit the previous item's style?


Again, please see description above of Paired vs Open styles.  One 
nice thing about Reveal Codes is to make it easy to see the effects of 
styles on output.



WordPerfect worked (if I remember correctly) by turning attributes on
and off, which makes it easier to simply delete a tag (because you do
not need to set it to something else).


That's right.


To properly duplicate the functionality as done in WP, would require
significant effort (split display, etc), which is why it has likely not
been done.


Splitting a display screen between the intended output (typically at 
the top of the screen) and the codes to produce that output (at the 
bottom) is a fairly natural use of screen real-estate; WP has done it 
forever. More likely what impedes the building of something like 
Reveal Codes for Writer is the fundamental difference in the document 
model: a Writer document is not a stream of characters punctuated by 
structures like frames and tables, but a collection of objects 
including streamed characters, needing something like an XML structure 
editor.




I am not arguing that it is not natural, and not a good way to do it, I 
am just saying that implementing the split screen where there is 
currently no support for it is a difficult task (which is probably why 
the reveal codes macro uses a dialog rather than a split screen).


I suppose that in a perfect world, the macro would have multiple modes. 
Work based on styles, work based on attributes in the text, etc...


I see that the problem runs much deeper. Fixing this would require 
significant time (primarily because I have no idea what it is doing, but 
I know th

Re: [users] Showing formatting codes

[Andrew Douglas Pitonyak]

 OK, so I made changes and then emailed this back to Mr. Rosenberg, 
since he was making the initial changes.


Search for "??ADP" and you will find my changes.

(1) The property names were not sorted, but the list is sorted as though 
it is Oh fiddle sticks, this will cause everything to fail. Johnny, 
don't push that out, it is wrong. I need to change this so that it does 
NOT assume that the array is sorted. I will send another version along 
shortly.


(2) I selected a paragraph with a hyperlink and it failed because the 
property index was greater than the color array.


(3) Placed a check in case the property is not found.

OK, I will go back and use a straight search and then NOT sort the array.


On 08/31/2010 03:52 PM, Johnny Rosenberg wrote:

2010/8/31 Johnny Rosenberg:

2010/8/28 Séamas Ó Brógáin:

A feature that could show where styles and formatting begin and end
(similar to that in Wordperfect) would be hugely important to me, and
indeed to many others also to judge by the numerous participants in the
discussion at www.oooforum.org/forum/viewtopic.phtml?t=9696.

I was delighted to learn of the macros RevealCodes2 and RevealCodes3
created by Ian Laurenson
(http://homepages.paradise.net.nz/hillview/OOo/) but very disappointed
to discover that they don’t work (at least for me) and instead return
the message “BASIC run-time error. An exception occurred. Type:
com.sun.star.uno.RuntimeException.” I presume this is because they were
written for an earlier version of Openoffice (1.1, I think), whereas I
have the latest (3.2)––or is something else wrong?

I installed the RevealCodes3 and tried to debug it and I think I found
it, however I am not sure if I can fix it, since I'm not an expert…

It fails at the following line in the function fnDirectProperties(oTextRange):
vValue = oTextRange.getPropertyValue(sItem)

When it fails, sItem=”ParaChapterNumberingLevel”, something that is no
longer supported, see the following issue:
http://qa.openoffice.org/issues/show_bug.cgi?id=103670

I'll give it a try to fix the macro, I think. No promises though;
there's a lot of code that someone else (than me) wrote…


Best regards

Johnny Rosenberg

I did a really ugly ”fix” but since I don't really know how it is
supposed to work I'll let you test it. I had some errors when trying
to run it, but at least the thing started now and a dialogue appeared.
I also made some changes to two buttons…

But I'm afraid that there are a lot of more things that need to be
fixed before this baby works correctly… Besides, my ugly fix is not
complete, I only kind of ”bypassed” an error.

I uploaded the document here, maybe someone else want to help:

http://hem.bredband.net/guraknugen/RevealCodes3-Modified.sxw



Regards

Johnny Rosenberg


I know almost nothing about Openoffice macros and cannot tell if this is
something that can be rectified. Does any kind soul know whether I might
be able to get these macros to work, and if so, how?

Many thanks.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org




--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Showing formatting codes

[Andrew Douglas Pitonyak]

 On 08/31/2010 04:16 AM, Séamas Ó Brógáin wrote:

Jonathon wrote:


Whilst it can be provided, it won't do you the slightest bit of good.
This is simply due to the different philosophy in how a word processor
should be written.

I don’t understand. If it can be provided, how do you know it won’t do
me any good?

This is one of the most frequently requested absent features of
Openoffice (to judge by the site I referred to earlier) and one that
would be hugely useful to those who work professionally with text, such
as writers and editors. Making visible the points at which styles and
formatting attributes begin and end would be a very significant control
for those editing a text or preparing it for publication. Many texts,
especially those received from others and particularly those that are a
composite of other texts, have “phantom” styles and attributes, such as
an opening tag followed by a closing tag with no significant text in
between, duplicated tags, and tags for styles that are no longer
required. These can make texts unnecessarily complex and cause headaches
for editor and typesetter.

I have one complex text that only one person ever worked on but that is
full of redundant styles and attributes as a result of the compiler
working on the text, and changing his mind, over the years.

I am aware that the internal format of Openoffice is not the same as
that of Wordperfect (which I have never used). I mentioned Wordperfect
(as others in the same predicament do) only as a shorthand way of
describing the feature. Despite the difference in internal format, a
simulation of this feature is possible by means of a macro, as proved by
the fact that it has been done. Ian’s macro caused the opening and
closing points of styles and formatting to be made visible, and (if I
understand correctly) allowed them to be deleted. Even if they were only
displayed they could be hunted down manually. What has changed in the
meantime is not (I think) the format of the XML in the internal text
file (contents.xml) but the format of the macro language.

If someone were to update the macro to make it work with Openoffice 3,
or otherwise provide this feature, they would remove “the old request”
from the list of grouses and earn the undying gratitude of editors and
others, beginning with the undersigned.

Séamas Ó Brógáin


I used a version once. I don't remember what it showed.

Which of the following are shown:

Page styles
Numbering styles
character styles
paragraph styles
font change
italics
bold

Does this differentiate between a change based on a style and a hard 
coded change?

What does it mean to delete a style from the display?
Does this mean that things are set to use the default style, or to 
inherit the previous item's style?


WordPerfect worked (if I remember correctly) by turning attributes on 
and off, which makes it easier to simply delete a tag (because you do 
not need to set it to something else).


To properly duplicate the functionality as done in WP, would require 
significant effort (split display, etc), which is why it has likely not 
been done.




--
Andrew Pitonyak



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] OOo users at Linux Fest in Columbus Ohio

[Andrew Douglas Pitonyak]

OK, so who is attending Linux Fest in Columbus Ohio this year?

http://ohiolinux.org/

September 10 - 12

I, Andrew Pitonyak will be there.
Drew Jensen (the Base GURU) will be there
Jason "Corfy"  (OOo Forum Moderator) will be there

Seems like an opportunity for us OOo folks to get together Friday night, 
Saturday night, or something similar.


Historically, Jason and I have gone to lunch on Saturday at BD Mongolian 
Grill (you pick your food and spices then they cook it for you).


http://www.gomongo.com/
http://www.gomongo.com/locations/locationDetails.php?loc=25

bd's mongolian barbeque
295 Marconi Blvd.
Columbus OH  43215
(614) 586-0077

If there is sufficient interest, I will attempt to setup something else 
as well (Like Friday and/or Saturday dinner). I will probably try to 
include my wife and two young daughters (I like spending time with them, 
what can I say), which may mean a kid friendly location, or simply 
having people swing by my place (since I live about 10 minutes from 
downtown).


So, who is interested? I can provide my cell phone for people worried 
about being lost.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: Two page test cursor document

[Andrew Douglas Pitonyak]

On 08/21/2010 09:59 PM, Thomas Blasejewicz wrote:


Sigrid Carrera さんは書きました:

Harold,

I saved the document and opened it. The cursor is to the left of 
the first

as far as I know, this works as intended. Since the original document
was saved by Andrew, you should see the document from the very start.
But, when you make a change and safe this, the next time you open the
same document, your cursor should be at the same position where you
were last.

Have you tried changing something? Does this work now for you? It
should not matter, if you have en-US or en-GB of OOo. It should also
not matter if you have the vanilla or the go-ooo build of
OpenOffice.org.



Good morning from Japan and thank you for your help.
I opened the document and the cursor was at the very top of the 
document, as usual.
A few minutes ago I followed your advice, applied some change, saved, 
reopend.

Now the cursor is CLOSER to the last position.
Last position:
"I will place the cursor here > < is the cursor there?" - > between 
the ><

I applied the lately discussed "highlight" and saved.
BUT, upon reopening the document the cusor is NOT between ><, but in 
the middle of "cursor".
Even though that is strange, I would be satisfied with that kind of 
"precision", because then I would not have to scroll through 30 pages ...



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org


Sometimes, we forget obvious solutions, like, using the navigator.

Use F5 to toggle the navigator on and off. Using the Navigator, you are 
able to jump directly to specific items such as headings, graphics, 
tables, etc. That said, being close is frequently sufficient.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Last cursor position

[Andrew Douglas Pitonyak]

 On 08/21/2010 11:54 AM, Andrew Douglas Pitonyak wrote:
>  I sent a document off list to see if a document that I create sets the
> cursor at a specific location. Any volunteers using an EN USA version of
> OOo want to test my document... Of so, drop me a line and I will send a
> copy of the document to see if this only works based on the user that
> saved the document.
>
> The document is very small (two pages of text).
I am configured to save documents using ODF 1.2 Extended. Note that this
is currently in the review process (ie, it is not finalized).

I took a quick look at the 1.1 format, which is finalized. There is a
specification for specifying the cursor position using the tag:

cursor-position

Note that this tag does NOT exist in my document.

I did notice, however, that in the included settings.xml, I have the
following items:


19473
0
22057
17612
true
false


view2
7867
31443
0
19473
22056
37084
0
1
false
125
false




true
false
false
true


This data appears to be very OOo specific. I moved the cursor to the
left and saved the document. What changed? The ViewLeft value. I assume,
therefore, that this is what is used to specify the cursor position.

The ViewLeft attribute is not in my OOo 1.1 document. So, I grabbed the
1.2 documents out for public review. Not there either. I assume,
therefore, that when I save a document, the view is probably determined
based on a view, which will change subject to some criteria (but this is
a totally wild guess based on some observed data).




-- 
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: Two page test cursor document

[Andrew Douglas Pitonyak]

 On 08/21/2010 02:19 PM, Harold Fuchs wrote:

On 21 August 2010 19:07, Sigrid Carrerawrote:


Harold,

2010/8/21 Harold Fuchs:

On 21 August 2010 17:22, Andrew Douglas Pitonyak
  Here is the document Thanks for testing it.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html

I saved the document and opened it. The cursor is to the left of the

first

character on page 1. Curiouser and curiouser. Oh, my OOo (3.1.1 Win XP

Pro)

is EN GB so maybe that has a bearing after all.

as far as I know, this works as intended. Since the original document
was saved by Andrew, you should see the document from the very start.
But, when you make a change and safe this, the next time you open the
same document, your cursor should be at the same position where you
were last.

Have you tried changing something? Does this work now for you? It
should not matter, if you have en-US or en-GB of OOo. It should also
not matter if you have the vanilla or the go-ooo build of
OpenOffice.org.

Andrew, if you want, you can send your test document to me as well.

Sigrid



Sigrid, when I change the document, put the cursor where Andrew had it and
then re-save the document then, when I re-open it the cursor is not at the
beginning and it is *not* where I left it. Instead the cursor is somewhere
before the place I left it.

This seems to be completely broken. Part of the puzzle is that we don't seem
to know what OOo is designed to do in this situation.

When I save a document, the cursor location appears to be saved with the 
document. When I open my document again, it is at the original location. 
It had never occurred to me that anyone else might see different behavior.


My best guess is that it is probably stored in settings.xml (inside the 
document). I did a test.


I saved the document, copied the saved copy, moved the cursor, then 
saved again. The cursor was properly positioned in both documents, 
irrespective of the document name.


I need to play with my four year old, so I need to stop verifiying what 
changed in the settings.xml...



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Last cursor position

[Andrew Douglas Pitonyak]

 On 08/21/2010 12:13 PM, Harold Fuchs wrote:

2010/8/21 Andrew Douglas Pitonyak


  I sent a document off list to see if a document that I create sets the
cursor at a specific location. Any volunteers using an EN USA version of
OOo want to test my document... Of so, drop me a line and I will send a
copy of the document to see if this only works based on the user that
saved the document.

The document is very small (two pages of text).



Andrew,

I'm happy to try: hwfa.openoff...@gmail.com and I'll let it through my
filters.

Just out of curiosity, why do you want volunteers using an EN USA version of
OOo? Do you believe this will make a difference? Why? Shouldn't, surely?
Or???


Sending the file to you shortly.

I asked for an EN US, because another post here indicated that he had a 
problem with a version in Japan (when they created their own document). 
I sent a copy to Japan and I wondered if it mattered if it was the same 
as the system on which I created the document, which is EN US. (trying 
to eliminate as many variables as I can the build may even matter, 
ie, I use a standard distribution not a Fedora build).


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Last cursor position

[Andrew Douglas Pitonyak]

 I sent a document off list to see if a document that I create sets the
cursor at a specific location. Any volunteers using an EN USA version of
OOo want to test my document... Of so, drop me a line and I will send a
copy of the document to see if this only works based on the user that
saved the document.

The document is very small (two pages of text).

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] toggle functions

[Andrew Douglas Pitonyak]

 On 08/21/2010 05:08 AM, Thomas Blasejewicz wrote:
> Andrew Douglas Pitonyak さんは書きました:
>>  What do you mean by "Highlight"?
>>
>> Can you write a single macro to do this? My guess is that it can be done
>> if you desire to do so. the trick, however, is that your macro must be
>> able to determine the current state so that it can be toggled.
>>
>> You say that you have a macro that turns it on, and one that turns it off.
>>
>> Can you post the macros for this and let me have a look?
>>
>> On 08/20/2010 10:05 PM, Thomas Blasejewicz wrote:
> By "highlight" I mean applying a colored background to the selected text
> (in the form of a fluorescent marker).
> Naturally, that makes the text stand out.
>
> Yes, I DO have 2 macros (it took me some struggle to set them up).
> One applies the background color to the text (highlight it) and the
> other removes it, if I select exactly the highlighted text.
> I would love to send you the macro content, but I am afraid I do not
> know how find, copy and paste the content.
>
> If you could me a hint as to how to achieve that I will gladly provide
> you the requested information
I have good news and bad news :-)

There is a background attribute which contains the color for the
background. You can grab the cursor and check to see if the background
is set to your special background color (or if it is set to anything at
all). Then, you can make your decision of what to do based on that
(clear it or set it). There may be a few difficulties based on the
complexity of your selection and things such as cursor position. For
example, what happens if you select a range of text and only part of it
has the background set and part does not? Also, if the cursor is
positioned at the end of the text with the background, you may
experience a different result than if it is at the front. I could ramble
on, but, no reason at this point.

As to how to find the macro, well, this depends on where you stored it
in the first place. The macro may be stored in a single document, in
which case it should only be available in a single document. It is most
likely stored in the OOo Standard library.

Use Tools > Macros > Organize Macros > OpenOffice.org Basic to open the
OOo Macros dialog.

In the left side of the screen, scroll to the top of the list labeled
"Macro From". Expand "My Macros". There should be a Library named
"Standard". I would look there first. Highlight a module (probably named
"Module 1" and click Edit.

-- 
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] toggle functions

[Andrew Douglas Pitonyak]

 What do you mean by "Highlight"?

Can you write a single macro to do this? My guess is that it can be done
if you desire to do so. the trick, however, is that your macro must be
able to determine the current state so that it can be toggled.

You say that you have a macro that turns it on, and one that turns it off.

Can you post the macros for this and let me have a look?

On 08/20/2010 10:05 PM, Thomas Blasejewicz wrote:
> Good morning
> I am sure, I will make myself with this question - which I actually
> posted already 2-3 times in the past - the most unpopular person on the
> list.
>
> Toggle functions/features.
> Hit F5 -> get the navigator; hit F5 again -> the navigator disappears.
> Ctrl+shift+p -> superscript; Ctrl+shift+p -> superscript back to normal.
>
> The first example is a function, the second a font attribute. THIS
> apparently works.
> I have tried in the past to assign a key combination to "highlight" text
> and then remove the highlight.
> Upon asking, I was told, the ONLY way to achieve this is by creating
> **TWO DIFFERENT** macros.
> THAT is what I did and currently use.
>
> But isn't this rather stupid (mysterious):
> I CAN toggle the font attribute "superscript" with the SAME key ON/OFF
> But I can NOT toggle the font attribute "highlight" ON/OFF.
> (I have been working on this for a very long time already ...)
>
> WHY???
>
> Never in the past when I posted this question has anyone attempted (not
> to mention succeeded) to answer this question.
> And, as a matter of course, this feature is available in almost ALL
> other software that I use/know.
>
>
> Anything that makes sense would be highly appreciated. Even this were
> not possible technically (rather difficult to believe!), I would like to
> know the REASON instead of quietely dealing with this schizophrenic
> behavior.
>
> Thank you.

-- 
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Last cursor position

[Andrew Douglas Pitonyak]

 Place the cursor where you want it and then choose file > Save. When I
open the document again, the cursor is where it was when I last saved
the document. Is this not the case for you? Very odd indeed. It has
always done this for me. Is there some configuration setting that
controls this?

On 08/20/2010 09:52 PM, Thomas Blasejewicz wrote:
> Good morning
> (OO 3.2)
> This relates to the other question I posted a few minutes ago, but
> considered it advisable to open a new thread.
>
> I frequently have to open, close and reopen documents, usually 20-30
> pages long.
> EVERY time I reopen a document, the cursor starts at the top of the
> document.
> This is maybe normal, but not where I was working when I closed the
> document.
>
> I have been told before, that I could set bookmarks and jump to that
> position.
> I know I can do that, but that is not really helpful. The last cursor
> position is different every time I save the document and even if I set a
> bookmark -> close the document -> reopen it:
> the cursor still will be at the top of the document and I have to
> perform several key or mouse actions to manually jump to the last
> WORKING position. (in this also a number of unnecessary bookmarks
> accumulates)
>
> In Wordperfect there is something called "quickmark" -> a bookmark set
> automatically at the cursor postion when saving the file and to which
> the cursor jumps automatically when the file is reopened.
>
> Is there something as elegant as this, or do I have to put up with
> manually scrolling/jumping through dozens of pages each time I open a file?
>
> Thank you.
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.org
> For additional commands, e-mail: users-h...@openoffice.org
>

-- 
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Database Macros

[Andrew Douglas Pitonyak]

 In need of an update, but, take a look at this

http://www.pitonyak.org/database/AndrewBase.odt



On 08/08/2010 01:48 AM, R C wrote:

It seems that one cannot record macros in the OO database.

I am doing a project for my Church's library.  In my database 
(library.odb) I have a button in the form portion that I linked to a 
macro. -- a dummy marco that has Msgbox line.  I am not sure how to 
program VB (I program in other languages, but not VB) so that my macro 
does the following:


Uses current record of table library with fields Title, Author, Name, 
DateCheckOut
Adds a new record to table history with fields Title, Author, Name, 
DateCheckOut, DateReturn
Clears the fields Name and DateCheckOut in the current record of table 
library

history.Title =  library.Title
history.Author =  library.Author

history.DateReturn = TODAY()
library.Name=""
library.DataCheckOut=""
update both tables -- have changes accepted and written

Does any one know how I can get VB commands needed to do the above?  I 
know how to put the lines in my macro; I just don't know what the 
lines should be to open the tables, fill a new record, and to close 
the tables with the updates taken into affect.


Thanks,

Ron



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Track Changes

[Andrew Douglas Pitonyak]

 yes

On 08/06/2010 12:24 PM, Guy Voets wrote:

Hello,

Does anyone know whether Track Changes registered in OpenOffice.org
are also 'visible' in MS Word when the text is saved as 'doc'?
I mean Edit>  Changes>  track changes (or something alike - this is
the Dutch version)

Thx


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Open Office and Window 7 problem

[Andrew Douglas Pitonyak]

 I seem to remember this under Windows XP. Hmm, what did I do

I think that I dropped to the command line and manually ran one one of 
the programs while telling it to ignore recovery or something silly like 
that. Boy, my mind is fading...


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] about protected documents

[Andrew Douglas Pitonyak]

 I believe that the loadComponentFromURL method accepts a property with 
the name Password (and the value is the password).


On 08/06/2010 07:21 AM, Gabriel Monnerat wrote:


Hi all

Does anybody know if you need some specific filter to open documents 
in UNO with passwords?


If true, have a example?

Regards,



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] ASCII crisis

[Andrew Douglas Pitonyak]

 On 07/29/2010 10:49 PM, april wrote:

I am desperately seeking anyone that can help me uninstall/disable this ASCII. Ever since 
I was prompted to perform a "mandatory" update with (Adobe?), this ASCII filter 
has been encrypting or encoding very important documents that I need to pull up/view for 
the first time. Please help me!!

april
april-mich...@comcast.net


April,

Can you provide a list of steps to reproduce this? I am looking for a 
list such as:


While editing a Write document in OOo, use File > Open to open an 
existing document. Select the file Hello.ods and click OK.





--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] [moderated]

[Andrew Douglas Pitonyak]

 Where are you trying to login? If this is a web site, please provide 
the address to the web site where it tells you to login.



On 08/01/2010 07:01 AM, Margaret Coombe wrote:

When I login in is keeps on saying not logged in or registered. Also why am I
unable to e-mail my documents etc. As I am not a computer wizz I would
appreciate any help.

  King Regards

  Margaret Coombe


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] Problems with Calc Charts

[Andrew Douglas Pitonyak]

 Doug,

I rarely use charts in Calc, but, I looked at your example charts. I do 
not know enough about this to even begin to duplicate the problem or to 
intelligently post about it. Off hand, this first issue appears to be 
incorrect, but, again, it is like asking me to explain women, I am clueless.


I am posting to the user forum to see if there can be clarification


_Bugs I am trying to report:_


_Charts_

  1.

 With the release of Ooo3.1, the ability to have a Column chart
 with a choice for the data series x axis has disappeared. The x
 axis defaults to the number of points chosen to be displayed for
 the y axis of the series. No longer is there an ability for
 selecting any x-axis data series. I have checked in Excel and find
 that it doesn't have this problem. I have attached an example in
 the DJIA_example.ods. In the X values for the series used to be
 $A$40:$A$79. Now as you can see the X values are just shown as
 1,2,3,40 which has no real relevance to the data I attempting
 to show in the chart.


I don't use the Bar Chart, but when I check the Chart Wizard to set 
one up, I find that it also is limited to only the Y series. The net 
result is that you can't do a Bar or Column Chart for a data range 
versus another data range. This is a reduction from the chart 
capabilities of OO2.x and SO9.x


First of all, I have no idea how to create the charts that you show 
(looks like some kind of percentages are calculated and used for 
display). I tried the following:


Open Calc document.
Use Insert > Chart
Select a column chart
Choose A40:B70 as my data
Set data to be in columns
Check First column as labels
This causes the first column to be a label. Is this not what you desire? 
Off hand, my guess is no, so I probably do not understand.

Click next
From this next screen, you can indicate which columns are the data columns.



2 The other bug which occurred after upgrading to Ooo3.2 is shown in 
the FUND_Example.ods attached. The information in the column chart 
does not display until you click on the chart and do an edit. The the 
data show up as in the DJIA_Example.ods.


_Bugs I am trying to report:_

_Charts_

  1.

 With the release of Ooo3.1, the ability to have a Column chart
 with a choice for the data series x axis has disappeared. The x
 axis defaults to the number of points chosen to be displayed for
 the y axis of the series. No longer is there an ability for
 selecting any x-axis data series. I have checked in Excel and find
 that it doesn't have this problem. I have attached an example in
 the DJIA_example.ods. In the X values for the series used to be
 $A$40:$A$79. Now as you can see the X values are just shown as
 1,2,3,40 which has no real relevance to the data I attempting
 to show in the chart.

   I don't use the Bar Chart, but when I check the Chart Wizard to 
   set one up, I find that it also is limited to only the Y series. 
The net result is that you can't do a Bar or Column Chart for a 
data range versus another data range. This is a reduction from the 
chartcapabilities of OO2.x and SO9.x


   2 The other bug which occurred after upgrading to Ooo3.2 is 
 shown in the FUND_Example.ods attached. The information in
the column chart does not display until you click on the chart
  and  do an edit. The the data show up as in the 
 DJIA_Example.ods.


Any comments would be appreciated.

Thank you,

Doug

when I looked at the second example, there was no data in the second 
chart, but, it also showed the data range as empty.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] Where to route OOo registration issues?

[Andrew Douglas Pitonyak]

As an administrator on the OOo Forum, I frequently receive requests for 
help assuming that the forum is directly associated with OOo membership.


The user claims to have sent email to places such as webmaster. Where 
should I direct the person?


Note that it also appears as though the OOo web site has multiple user 
names for this user based on one email address: dbo...@earthlink.net


Note that if you copy your response to dbo...@earthlink.net, then I do 
not need to manually forward your responses, but, I will do so if required.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Get reference to datarange from cell

[Andrew Douglas Pitonyak]

Try INDIRECT. Does this little example provide a sufficient hint?

=SUM(INDIRECT(CONCATENATE(D4; ":";E4)))

On 07/22/2010 06:05 AM, Ian Coetzee wrote:

Hi all

I have tried googling and going through all the functions I could 
find, but I cant for the love of me find a way to do this.


I have a few dataranges (+- 10) that I am doing vlookups on.

The format of the dataranges are as follows:

Company1
{
_Company 1_
Account1 \t 
Account2 \t 
...
Account \t 
}

Company2
{
_Company 2_
Account1 \t 
Account2 \t 
...
Account \t 
}



Company
{
_Company _
Account1 \t 
Account2 \t 
...
Account \t 
}

I need to display that data as follows

|_Company 1_  |
_Company 2_|_Company _
  |
Account1 |=Vlookup($A1,Company1,2,0)  
|=Vlookup($A1,Company2,2,0) |=Vlookup($A1,Company,2,0)  |
Account2 |=Vlookup($A2,Company1,2,0)  
|=Vlookup($A2,Company2,2,0) |=Vlookup($A2,Company,2,0)  |

...
Account|=Vlookup($A,Company1,2,0)|=Vlookup($A,Company2,2,0) 
|=Vlookup($A,Company,2,0)|


Does any of you know how I will be able to make my Vlookup use the 
cell (B1,C1,etc) to define which datarange to use?


Hope anybody understands this post (I know I almost confused myself here)

Regards
Ian


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] OOo Math: how to get zero-width spaces?

[Andrew Douglas Pitonyak]

On 07/03/2010 09:59 PM, In-Betweener wrote:

Suppose I type

x+y

into an equation. It will be rendered like this:

x + y

what if I want to keep the expression rendered with no spaces around 
"+"? e.g.:


x+y

The example is very simple, but I stumble on the same problem at 
several other situations. Examples:


x bar Ry

I don't want the space between "x" and the "barred R", but OOo Math 
always puts that there.


xT^'b

OOo Math puts a (unwanted) space before the "b".

With MS Equation (and MathType) I used a zero-width space to join what 
usually was rendered automatically separated by a space. So far, I 
didn't find a similar feature in OOo Math.


Does it exist?

Please look at the attachment.

I poked around a bit I can certainly change the spacing on the 
entire formula (not what is desired)...


I thought that it was possible to create your own special symbols. I did 
not see how to do it when I took a quick look. If this is possible, then 
you may be able to create a special symbol that inserts a "+" that is 
then not treated as an operator. Sorry, no more time to consider this 
tonight!


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] How can MSAccess use OOo components?

[Andrew Douglas Pitonyak]

On 07/03/2010 05:00 AM, Andreas wrote:

 Hi,

is it possible to let MSAccess controle Calc and Writer in the same 
way as it can do it with Excel and Word?


I need to create reports that are basically data dumps in tabs of a 
spreadsheet.

So I'd like to fill single cells and dump whole recordsets.

Can I have an OOo object in VBA to do this?
Yes, you can control OOo using VBA. I have almost no experience doing 
this, however. I ran one or two tests some years back just to see if I 
could Of course, to do that I had to find a windows computer with 
the appropriate things installed on it :-)


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Questions about OpenOffice macros in a Linux environment

[Andrew Douglas Pitonyak]

On 06/21/2010 01:55 AM, Jeffrey Needle wrote:

Hello.  Forgive me for my awkwardness.  I'm getting my feet firmly
planted in Linux right now.  I'm using Ubuntu 10.04.  I am also using
OpenOffice 3.2.

My question involves the database module.  I'm looking for a way to
create a macro (I think that's the way to do it) that will insert the
current date into a field.  I know there are keyboard macro programs
like Autokey, but it is not successful in inserting the date.  Instead,
it inserts a blank two-character field.  I've worked with the Autokey
people, but they can't seem to help.

I wondered if there was some way to do this in OpenOffice.

Thanks.
   

Yes, you can insert a date directly into a field using a macro

This may help:

http://www.pitonyak.org/database/AndrewBase.odt


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: Creating a Comment in a Macro

[Andrew Douglas Pitonyak]

If I remember correctly, this is one of the things that I have never 
figured out how to do using a macro. If you ask on the 
d...@api.openoffice.org list, they may have a solution.


On 06/14/2010 09:53 AM, Phil Hibbs wrote:

BTW, this is the macro as recorded:

sub Comment
rem --
rem define variables
dim document   as object
dim dispatcher as object
rem --
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem --
dispatcher.executeDispatch(document, ".uno:DrawEditNote", "", 0, Array())

rem --
rem dispatcher.executeDispatch(document, ".uno:InsertAnnotation", "",
0, Array())

rem --
dispatcher.executeDispatch(document, ".uno:DrawEditNote", "", 0, Array())

rem --
dim args4(0) as new com.sun.star.beans.PropertyValue
args4(0).Name = "ToPoint"
args4(0).Value = "$B$2"

dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args4())

rem --
dispatcher.executeDispatch(document, ".uno:DeleteNote", "", 0, Array())


end sub


Phil Hibbs.
   


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] calc: Allow only entry of certain values for a cell?

[Andrew Douglas Pitonyak]

On 06/13/2010 08:50 AM, Gelonida wrote:

Hi,

I'm loking for some advice how to best do following:

I'm having a spreadsheet with a cell layout, that corresponds my needs.

Now I would like to add certain behavoir as beeing known from web forms
to a few cells.
- having a select box instead of free entry for certain cells
   


I believe that you can do this by inserting a drop-down list box in a 
cell and then associating the control with a cell in your Calc document.



- triggering en event (macro) when the contents of one of these cells
changed
   


I do not believe that you can tell Calc to automatically call a macro 
when the value in a cell changes.



Rephrased:


1. Limited input range for cells


When clicking (or doubleclicking) on the cell I would get a select box
or a minidialoge offering me the possible options.
Examples:
- numbers only from 1 to 12
- or text, but only 'Yes' and 'No'


2.) Sanity check of certain cell inputs
   


I do believe that you can provide for constrained input.  Something 
about Data > Validity and you can set constraints. I have not used it, 
other than in testing and writing macros to deal with it during my 
testing (some years ago).



---
- after having changed the value of a cell.
- I'd like to trigger a macro, which performs some sanity checks.

Thanks for any suggestions or ideas how you attack similiar problems.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

   


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] macro

[Andrew Douglas Pitonyak]

On 06/12/2010 05:00 AM, Harrie Borgers wrote:

L.S



A novice's requires

Where can I read more about:  args(0)
   


I assume that you recorded a macro. This looks like part of a variable 
declaration, or, indexing the first element in an array.



How to call - in basic - a second spreadsheet with variable name

How do I read out  the value of cell(3,4) for calculation



Arie bor


   


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] what newsgroup would you suggest for talking about python scripst for open office?

[Andrew Douglas Pitonyak]

On 06/09/2010 04:47 PM, Gelonida wrote:

Hi,

I just wanted to be sure, that this is the right group for discussing
python scripts for open office.

Please tell me in case you're aware of a more appropriate group.
   
Much depends on precisely what it is that you want to know. If you 
receive no response from the dev mailing list as recommended by another, 
then, also try the macro portions of one of these forums:


http://www.oooforum.org/
http://user.services.openoffice.org/





--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Calc: How to restore Style attributes to "as-is" (i.e. no-change) ?

[Andrew Douglas Pitonyak]

I do not know how to do this, but, I do know that if I do NOT set a 
value for a property, then it uses the value from the parent (or has no 
effect).


I have mostly done this sort of thing using macros, so, i might be able 
to guess that with a macro you could set the value to some "default" 
value, but not sure how to do this from the GUI. If I really wanted to 
restore the "heading1" style, I would try:


Open a new document
Copy some text with the default heading 1 style.
Paste the default heading 1 text into the document with the modified 
version.


I would probably try some variation on this. A last ditch effort might 
go something like this:


Assume "doc1" contains the "bad" heading1.
Save doc1 to doc2.
Delete all text from doc2.
Delete all "bad" styles from doc2.

At this point, doc2 contains ALL styles from doc1 but it is missing the 
deleted styles. It also has no text.


Create a new document with no text and the styles as you desire. Save 
this as doc3.


From doc2, use F11 to display the styles and formatting window. In the 
upper right corner, you can click on the drop-down and select "load 
styles". Do NOT check "overwrite" styles. Now, load the styles from 
doc3. This should not overwrite any existing styles, but, should add 
styles that do not exist.


Now, doc2 should have the styles as you want them.

From doc1, import the styles from doc2 and check the overwrite box.

Sorry, it is complicated, but, it strikes me as a last resort if you 
cannot find another solution.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] how to eliminate page breaks in mail merge?

[Andrew Douglas Pitonyak]

not sure which of these will work best

1. Merge as labels

2. Use a macro to remove page breaks

3. Regular expressions. Not likely, but, maybe



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] macros in OO 3.2

[Andrew Douglas Pitonyak]

Interesting Did not expect that...

On 05/24/2010 06:53 AM, a...@exemail.com.au wrote:

Problem solved:
->Tools/Customize/Menus/Menu -> Tools | Macros | Record Macro -> Add 
-> Menu/BASIC/Record Macro

-> close the Add box
-> Click OK in the Customize/Menus box
-> Voila: Record Macro is now an option.
Cheers
Alan Kerns



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] macros in OO 3.2

[Andrew Douglas Pitonyak]

On 05/21/2010 05:47 AM, a...@exemail.com.au wrote:

I recently installed OO 3.2 into PCLinux OS 2010.
Everything seems to be working fine except the Tools/Macros/Record 
Macro option is missing.


I believe that you cannot record macros from all products, only some. 
Are you able to record a macro from Write or Calc?


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Openoffice not opening

[Andrew Douglas Pitonyak]

My answer may not be timely, but, I just recently had this problem. I 
worked around it by:


Open OOo and tell it to NOT recover the document.
OOo then hung after opening a blank window, so, I killed it.
If I started OOo, it hung, so, I started it by double clicking on an OOo 
document.


Seems a bit silly, but, it worked for me.




On 05/09/2010 04:28 AM, David & Pat Corballis wrote:

My Openoffice refuses to open.
It started with Calc. It needed to recover the document
Whenever I open a calc programme, the Document Recovery Window comes up.
I press Start Recovery, it gets to work and "Successfully Recovered" 
appears. The trouble begins when I press Next >.

Then a window - Runtime Error1 - appears - abnormal program termination.
I have now got 5 programs waiting recovery. They all recover only to 
be terminated again.


I can't run any calc programmes on Windows, and I have a similar 
problem when I switch over to Ubuntu.
And now none of my Openoffice programmes will run, including writer. 
As I attempt to open them an increasing number of* .-lock.* icons appear.


Would un-installing and re-installing, or downloading Openoffice again 
help?


David Corballis





--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Where is the Circles and Ellipses toolbar

[Andrew Douglas Pitonyak]

On 04/01/2010 06:24 PM, RA Brown wrote:

Andrew Douglas Pitonyak wrote:
I want to draw an arc in Draw. I checked the help, and it tells me to 
open the Ellipses toolbar. I cannot find this toolbar.


I used Tools > Customize > Toolbars, and I have a toolbar named 
Circles and Ovals. OK, great, this toolbar has the items of interest. 
Unfortunately, I cannot find this toolbar. I tried View > Toolbars, 
and this toolbar is not listed there.




In the default v3.2 setup, when you open Draw the Drawing Toolbar is 
on the bottom.  Find the "Basic Shapes" icon, about the ninth from the 
left.  There you have the option to select the Circle or other basic 
shapes.


Hope this helps.
Thanks... Unfortunately, some of my configuration was likely somehow 
"damaged". I might eventually just delete my configuration directory and 
start over.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Where is the Circles and Ellipses toolbar

[Andrew Douglas Pitonyak]

On 04/01/2010 07:48 PM, Brian Barker wrote:

At 18:08 01/04/2010 -0400, Andrew Douglas Pitonyak wrote:
I want to draw an arc in Draw. I checked the help, and it tells me to 
open the Ellipses toolbar. I cannot find this toolbar.


I agree: it appears now to be called Circles and Ovals.

I used Tools > Customize > Toolbars, and I have a toolbar named 
Circles and Ovals. OK, great, this toolbar has the items of interest. 
Unfortunately, I cannot find this toolbar. I tried View > Toolbars, 
and this toolbar is not listed there.


I don't see any way to get this toolbar directly.  A number of buttons 
in the Drawing toolbar have small down-arrows to their right, 
indicating the availability of another toolbar.  The smiley face, for 
example, spawns the Symbol Shapes toolbar.  It seems that the Circles 
and Ovals toolbar is spawned by such a button, but that this button 
does not appear by default in the Drawing (or any) toolbar!


o  Click the down-arrow at the right end of the Drawing (or any) toolbar.
o  Select Customize Toolbar... .
o  Click Add... .
o  Under Category, select Drawing.
o  Here, you could just click Arc or Circle Arc under Commands, which 
would put the button you need into the Drawing toolbar.
o  Alternatively, scroll down the Commands list and notice that there 
are two apparently identical entries labelled Ellipse.  The first is 
the Ellipse button, which is already in the Drawing toolbar; the 
second is the one you need: the key to the Circles and Ovals toolbar.

o  Select this second Ellipse icon and click Add and Close.
o  If desired, use the arrow buttons to move the new button to the 
required place on the Drawing toolbar.

o  Click OK.
o  Now you will see a new ellipse button, this time with the tell-tale 
down-arrow to its right.  Click the arrow and you will see the Circles 
and Ovals toolbar.


No: I don't know why it should be this complicated, either.

I trust this helps.

Brian Barker

Yes... Very much. Exactly what I needed...

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

[users] Where is the Circles and Ellipses toolbar

[Andrew Douglas Pitonyak]

I want to draw an arc in Draw. I checked the help, and it tells me to 
open the Ellipses toolbar. I cannot find this toolbar.


I used Tools > Customize > Toolbars, and I have a toolbar named Circles 
and Ovals. OK, great, this toolbar has the items of interest. 
Unfortunately, I cannot find this toolbar. I tried View > Toolbars, and 
this toolbar is not listed there.




--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Writer -- Insert Picture

[Andrew Douglas Pitonyak]

On 01/12/2010 12:45 AM, Jean-Baptiste Faure wrote:

Le 12.01.2010 06:30, James E. Lang a écrit :
   

Further clarification: I want to replace the string "Key " in a line
of text with a small image of a key.

 

Hi,

In the contextual menu of the picture, you have to choose Anchor>  As
character (fourth item).

Regards
JBF
   
When first inserted, a picture always seems to be anchored to a 
paragraph (I think). I find it difficult, especially with large images, 
to convince it to paste where I really want it. My usually solution is 
to make certain that I have sufficient space (and nothing but space, 
like blank lines) after the spot where I want the image. I then anchor 
the image as a character, then remove the extra space.


There are times, of course, where I desire other behavior than for the 
image to act like a single character, in which case, I drag the image to 
where I want it and set wrapping characteristics and such...


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] FW: America] - Subscribers are not moderated

[Andrew Douglas Pitonyak]

Demand all you want, but, I think that the only posts that are moderated 
are from people that are not subscribed. The end result is that most 
messages are posted rather quickly to the list, as opposed to the longer 
wait for those that are not subscribed to the list. I suspect that in 
general, you do not want a moderated list.


:
I demand more effective methods should be there to avoid such nonsense 
(including even this mail as some subscribers may think off).


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html

Re: [users] Backing up OOo extensions in Ubuntu

[Andrew Douglas Pitonyak]

On 12/18/2009 06:47 PM, Mark C. Miller wrote:

I use the program "grsync" in Ubuntu to do my system backups.  It grabs
several system folders, but near as I can tell nothing in OOo.

Is there a way to backup my OOo templates, extensions, etc?  Which
directories would I want to back-up?  I would really prefer not to have
to go back and grab everything from scratch in case of a crash.  I mean,
that's the point of having a back-up, right?

Or would it be better to post this on the ubuntu user list?

tnx

mcm



   

You can likely find these items under

~/.openoffice.org/3/

That directory should contain everything.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] How Do I Delete My Forum Account?

[Andrew Douglas Pitonyak]

On 12/16/2009 12:23 PM, s.a@ca.rr.com wrote:

Hi, I registered for your forum last night and I've decided I want to delete my 
user name and password. I want to be completely removed from your database. How 
can I do this
The user was referring to the OOoForum. We discussed off list, and the 
account has been removed.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: calculating fields with a macro in a database

[Andrew Douglas Pitonyak]

On 12/11/2009 08:00 AM, Jonathan Kaye wrote:

jomali wrote:
Thanks John. My macros are extremely specific to a given task and could only
be created via a macro programming language (such a the variety of basic
used in openoffice). I use the dbms supplied by openoffice (mysql?). I have
not been able to find any mention of how to use macros created in openoffice
for calculated fields. I guess it can't be done.
Thanks again.
Jonathan

   
If you do this one field at a time, then I expect that you will call 
your macro from a Form. The macro would then be triggered by the form as 
the data is entered.


It sounds like you might be referring to something like a stored 
procedure that is called when another field is updated directly in the 
DB. This will be dependent on the DB used.


Your other option, which may not be practical, is to write a macro that 
uses SQL to read the data, then use the macro to write it back out to 
the "calculated" field.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] picture placement

[Andrew Douglas Pitonyak]

Ahhh, wife just called me... OK, quickly then...

I believe that you can create a frame style and apply it to graphics. 
You can create a style to set things as desired... No time to verify, 
sorry...




On 11/10/2009 12:28 PM, McLauchlan, Kevin wrote:

G'day all.

Here's today's question...   :-)

Is there a good tutorial/explanation somewhere on how to place photos/graphic 
items in a document so that they:

a) Move smoothly with the text to which they are attached (as document gets 
edited/repaginated).

b) Keep text from sliding under their edges and being obscured.

c) Don't go sillly when the text gets pushed across a page boundary.

d) Behave sensibly when anchored to a paragraph in a table cell, even when the 
table cell is pushed to the bottom of a page or shifts to the following page.


What I've been doing is silly.

I place my cursor at the desired location in text,
click Insert>  Picture>   From file>  and browse to the desiired picture

When it comes in, I resize if necessary, and I right click to verify the Anchor 
and the Wrap settings.

I've tried both Character and Paragraph anchors.  I've tried various wrap 
options.

A picture and text will seem to co-exist properly until the text moves and then 
all bets seem to be off.

I've had a pic in a cell in the middle of a page and cell is the right size to 
contain both the text and the photo that's anchored to it... in approximately 
the desired positions. Then the table cell gets moved to the bottom of the page 
(by text or other objects added on earlier pages). The table cell is reluctant 
to jump to the next page and so squashes itself down to just the size of the 
text, leaving the photo feeling lost and confused. The photo them bumps up 
against the top of the cell, but overlaps the bottom of the cell, as well as 
the bottom of the text area and the page footer.   I think maybe it's not 
supposed to work that way?

Is there some other batch of settings that I've been neglecting? Another dialog 
I've overlooked?



  - Kevin


The information contained in this electronic mail transmission
may be privileged and confidential, and therefore, protected
from disclosure. If you have received this communication in
error, please notify us immediately by replying to this
message and deleting it from your computer without copying
or disclosing it.


   


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] RE: Problem with ToC formatting in Writer

[Andrew Douglas Pitonyak]

On 11/10/2009 11:43 AM, McLauchlan, Kevin wrote:

From: Michele Zarri [mailto:m.za...@gmail.com] said:
 

[...]
   

I guess you have already tried this, but it is worth trying again...

1. right click on the TOC and select edit Index/Table
2. go to the Entries tab and select level 1 on the left menu
3. remove any unwanted "T" from the structure (that is leave
only one T
between the entry (E) and page number (#) right aligned, with filling
character .
4. repeat for level 2

Also, just in case, select the para styles Contents 1 and
Contents 2 and
click on the "default" button to reset all the settings.
 

I "solved" it by creating a clean document, faking some text and 
creating/applying styles with the same names as my heading styles from the culprit 
document, creating a ToC in the clean document, then copying and pasting into the culprit 
doc, and updating the ToC.  Seemed to work... sorta... kinda... maybe... I'm not 
confident it'll stay that way.

I guess this is one of the many joys of inheriting Word documents from people 
who had their own special ways of producing docs.

   
I found many wonderful joys while dealing with Word documents. Something 
about the way they handle (or don't) styles and then converting that 
mess to OOo.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] alternating rows of no background, transparent gray

[Andrew Douglas Pitonyak]

On 11/06/2009 02:55 PM, Michele Zarri wrote:

2009/11/6 James:
   

I want to take a table with alternating rows of no background, transparent
gray.
So it is easier to read a line.
How do I do this with Writer?

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org


 

Hello James,

I do not think there is an automatic way to do that, but I recall
someone having written a macro which did just that... I am sure it is
hidden somewhere on the OOoForum but I could find the URL... :-)

One option is to create a small table (two rows, two columns, plus
column/row heading if needed), apply manually the formatting desired,
and then add this style to the auto-format styles.
Then select your table and apply the autoformat you just defined.

Not as good as the macro, but definitely going to save a lot of work.

Cheers,

Michele
   
I wrote a macro that I use to format my tables... It does something 
similar...


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: Pictures inside frames - Anchor To Frame

[Andrew Douglas Pitonyak]

Sorry for any delays, I had two hard drives fail on the same day and it 
took a while for me to get back up...


What is a caption? A caption is a paragraph containing a specific "field".

If you look at a caption, you will usually see something like this:


Figure : This is a pretty picture.


What are these things?

1. "Figure " is regular text.

2. I used "" to represent a field containing the formula 
"Figure + 1", which means that it obtains the current value of Figure, 
adds 1 to it, and displays that at the current location. As captions are 
removed and inserted, all other captions retain the correct value.


3. ": This is a pretty picture." is just text for the caption.

Assume that this is the 5th caption so that it appears as "Figure 5: 
This is a pretty picture." If you reference figure 5 in context, all 
text preceding the field to the start of the paragraph is included. In 
other words, you are expected to use short text values preceding the 
field in a single paragraph for a caption. When is this a problem?


I created captions for equations. On a whim, I opted to number equations 
in different ways



EQ 5  x = y + 1


z = 2+xEQ 6

Can you see why this did not work? The only problem was that I wanted to 
insert a reference, and the reference to (6) with the context stuff 
wanted to insert everything before the 6. I know, so do not reference 
that way



If OOo creates the caption, it places the figure in a frame with the 
"caption paragraph".




On 11/09/2009 11:45 AM, John Kaufmann wrote:

document, if you like.

You can separate them by cut/paste and distribute them over the whole

But if you cut the caption from a picture (frame) and paste it 
elsewhere, does it retain the property of "caption" - or is it just 
unassociated text?


As mentioned above, a caption is nothing more than a paragraph with a 
specific field in it. There are fields already created for Figure, 
Table, Illustration, Drawing, Listing, and Text. Hmm, I might have 
created at least one of those myself. Too lazy to check against a new 
document. The point, however, is that I can create my own fields for this.


Did you just figure out that really there is nothing special about a 
caption and it may not be considered a caption until you choose to cross 
reference it?


I believe (but I haven't checked) that you can make your own 
fully-functional captions without using the Insert > Caption menu at

all.


Yes, as I understand it, that is essentially Andrew Pitonyak's method 
- though it seems to me he does that primarily to compensate for 
Writer's weakness in handling graphics.

Correct, that is how I do it.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Pictures inside frames - Anchor To Frame

[Andrew Douglas Pitonyak]

I feel like I see this question off and on...

On 11/05/2009 02:26 PM, John Kaufmann wrote:
According to the OO documentation ("Working with Graphics"), any 
picture inside a frame should have "To Frame" among its Anchor options. 


That sounds WRONG. I can think of no particular reason that an image 
inside of a frame should be anchored to the frame. I assume, however, 
that it must be anchored either to the frame, or to something in that 
frame. If not, well, then it is not really in the frame. Not to split 
hairs, but one might argue that an image anchored to a frame might 
actually exist outside the frame (but I might argue that for any anchor 
type).


I have certainly anchored images as a character inside of a frame.

In a document I wrote are ~30 pictures inside frames - but only half 
of them have the "Anchor.. To Frame" option.  After much study, I'm 
still unable to see the difference between those that have and those 
that do not have the option.  Even pictures side by side can be 
different.  Can anyone tell me what to look for to normalize this?


I suppose that it depends on how the image ended up inside of a specific 
frame.


And - bonus question - since Writer believes that a picture with 
caption is lost without a frame (and thus supplies one automatically), 
why would the picture ever *not* be anchored to the frame?


I would say that the previous statement is not entirely true either. 
First, look at why writer may choose to do it this way...


You tell OOo to caption an image. The intent is to keep the image with 
the caption. If both are in the same frame, then they will stay 
together, kind of like throwing two items into a box together. So, OOo 
places an image into a frame and then places the caption into the frame 
with the image.


There are other advantages to this, that can only be done by using 
something like a frame. For example, what if I want text to flow around 
an image and its caption? Well, I can flow text around a frame, and if 
the frame contains the image and the caption then you are done.


I usually embed my images as a character on a line with nothing else. I 
use a paragraph style that is configured to stay with the next 
paragraph, which contains the caption.


I place the caption below the image. THis contains a field (for the 
caption number) and text. I use a specific paragraph style for the caption.


There are certain benefits to this, but the ability to drag the image 
and caption around in a frame is not one of them. I would ramble on more 
about this, but I am hours late for going to sleep.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] How to stop Writer from applying any para numbering anywhere?

[Andrew Douglas Pitonyak]

On 10/22/2009 11:35 AM, john d. herron wrote:

Hi, everyone.

How can I tell swriter 2.4 to stop using any and all paragraph bullets 
and numbering in a whole document?
I've a paragraph style from which I've removed all references to 
numbering, but numbering continues unabated.

It's driving me insane!

Help, please?

john
Sounds like you may need a macro Might look something like this 
(untested thrown together macro).


Sub ClearNumStyle()
  REM Author: Andrew Pitonyak
  Dim oParEnum 'Enumerator used to enumerate the paragraphs
  Dim oPar 'The enumerated paragraph
  Dim s$

  REM Enumerate the paragraphs.
  REM Tables are enumerated along with paragraphs
  oParEnum = ThisComponent.getText().createEnumeration()
  Do While oParEnum.hasMoreElements()
oPar = oParEnum.nextElement()

REM This avoids the tables. Add an else statement if you want to
REM process the tables.
If oPar.supportsService("com.sun.star.text.Paragraph") Then
  If Len(oPar.NumberingStyleName) > 0 Then
oPar.NumberingStyleName = ""
  End If
End If
  Loop
End Sub

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] labeling figures

[Andrew Douglas Pitonyak]

On 10/14/2009 08:30 PM, James wrote:

I have a bunch of pictures I added to a writer document.
I want to refer to each one in the text "(see figure 1)", etc but want 
them automatically numbered and the reference in the text 
automatically updated if I move it or insert another.. rg



Insert a caption on each figure, then you can cross reference each...

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] reverse numbering

[Andrew Douglas Pitonyak]

On 10/01/2009 12:22 PM, James wrote:

On 09/30/09 00:06, James wrote:
Instead of numbering a sequence of steps 1..6, I want to number them 
6..1.

More information:
This is a numbered list in Writer.
I am not aware of a way to cause numbered lists to automatically number 
backwards. I was using numbering the same way that Figures are numbered. 
This will work, but requires more work on your part...


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] reverse numbering

[Andrew Douglas Pitonyak]

On 09/30/2009 12:06 AM, James wrote:
Instead of numbering a sequence of steps 1..6, I want to number them 
6..1.
You can use a number range variable, and you can make it count backwards 
starting from a specific number. On the first entry, insert the sequence 
field and set the value to 6. For the rest, insert the sequence as "NAME 
- 1" (assuming your sequence is named "NAME").


Not the best solution, but it should work.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Big Matrix in OOo

[Andrew Douglas Pitonyak]

On 09/29/2009 12:19 PM, Manu Unni V G wrote:

Hi All,

Is there a way to use Big Matrix package in OOo or is there
an alternative for handling SVD, Eigen etc

Regards
Manu

   

I am not aware of an extension to do this in OOo.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: OK, I'm and Idiot - Template use

[Andrew Douglas Pitonyak]

On 09/28/2009 09:40 PM, Barbara Duprey wrote:


When they get to the second page, I want them to have th full page 
length, plus a header that starts with page number 2.  I do not want 
a header on the first page.


This is really easy to set up in Word, I'm having a hard time 
convincing other's in my department that moving to OOo is worthwhile 
when these kinds of problems creep up.  Sorry.  Rant off.


mcm
What I'm trying to do is create a document that has a 4-block header 
on the left hand side, the title in the center, and then open space 
for the author to enter their material.


Ah! OK, what you're running into is that Word doesn't really have 
anything exactly like OOo's "page styles" -- and that's what you need 
for this. You'll apply the style "First Page" to the beginning of your 
document, and add your 4-block header (not entirely sure what that 
means, but as long as you do it doesn't matter!). Add the title -- you 
may want to modify the Title paragraph style to your liking. Then you 
should probably add a couple of blank lines, then force a page break 
(Insert > Manual Break > Page Break, or just Ctrl-Enter). That will 
get you to a new page that uses the "Default" page style (or your own, 
if you want, depending on how you set up the "First Page" style). Once 
you're there, use Insert > Header > Default, then click in the 
resulting header and Insert > Fields > Page Number, aligning the field 
as you want.(it will start with 2 automatically, even though there was 
no page number shown on the first page). You can then save this 
document as a template.When your users create a document using the 
template, start typing on the first page, and flow onto the second 
page (and any succeeding ones), the Default page style will apply on 
the later pages and they'll have the whole page (less the space needed 
by the header) to use, with its appropriate page number. That sound 
like what you're after?


By the way, all this is assuming that the document will stay in OOo -- 
if it will be going back and forth to Word, things get more 
complicated, and you'll probably need somebody else to help.




This sort of thing is trivially done in OOo, but is very difficult in 
Word. For example, I use this template for most of my writing:


http://www.pitonyak.org/Small%20Simple%20Book.ott

My first page uses the "Title Page" page style. If you look at this page 
style you will see that it is defined such that the next page is of type 
"Information Page".


So, move to the second page, and you see that it indeed uses this style.

OK, so what comes after the information page? The TOC - First Page

A TOC - Following style comes after the TOC - First Page.

So, what follows a TOC - Following? A TOC - Following.  This is similar 
to my chapter first page and chapter following styles. A chapter begins 
with Chapter first page. A chapter first page always starts on the right 
hand side (because I defined it that way). It then flows to a chapter 
following. Some people even use different styles for all left and right 
pages so that you can use appropriate margins.


Just something to think about.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Re: Increase font macro

[Andrew Douglas Pitonyak]

On 09/28/2009 06:59 PM, Eustace wrote:

On 2009-09-28 07:54 Eustace wrote:
How can I make a macro to increase or decrease the font size of a 
document by a certain percent (f.e. 10%)?


emf


I recorded a macro to change the font size from 12 to 13 and then 
opened it to edit it. I found the following relevant lines:


==
sub IncreaseFontSize
rem 
--

rem define variables
dim document   as object
dim dispatcher as object
rem 
--

rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem 
--

dim args1(2) as new com.sun.star.beans.PropertyValue
args1(0).Name = "FontHeight.Height"
args1(0).Value = 13
args1(1).Name = "FontHeight.Prop"
args1(1).Value = 100
args1(2).Name = "FontHeight.Diff"
args1(2).Value = 0

dispatcher.executeDispatch(document, ".uno:FontHeight", "", 0, args1())


end sub
==

args2(0).Value is the resulting font size. Instead of

  args1(0).Value = 13

I suppose I need something like:

  args1(0).Value = getFontHeight() * 1.1

Actually I tried to replace the code as above, but the result was that 
font size 12 became font size 2...


How do I get the current font size and then increase it?

And BTW what are the FontHeight.Prop, and FontHeight.Diff?

emf



This macro is tricky for many reasons

First, the macro works on the selected text. You would need to obtain 
the font size, but what if different portions uses different font sizes? 
The following macro is not very safe because it assumes that things are 
the same everywhere.


  Dim oSels As Object, oSel As Object
  Dim lSelCount As Long, lWhichSelection As Long

  oSels = ThisComponent.getCurrentSelection()
  If IsNull(oSels) Then
Exit Sub
  End If
  If oSels.getCount() = 0 Then
Exit Sub
  End If
  oSel = oSels.getByIndex(0)
  lSelCount = oSels.getCount()
  For lWhichSelection = 0 To lSelCount - 1
oSel = oSels.getByIndex(lWhichSelection)
oSel.CharHeight = oSel.CharHeight * 1.1
  Next

You may not like this because it will take you from 12 to 13.1 I believe.

The following converts to an integer, which may not be what you want:

  Dim oSels As Object, oSel As Object
  Dim lSelCount As Long, lWhichSelection As Long

  oSels = ThisComponent.getCurrentSelection()
  If IsNull(oSels) Then
Exit Sub
  End If
  If oSels.getCount() = 0 Then
Exit Sub
  End If
  oSel = oSels.getByIndex(0)
  lSelCount = oSels.getCount()
  For lWhichSelection = 0 To lSelCount - 1
oSel = oSels.getByIndex(lWhichSelection)
oSel.CharHeight = CInt(oSel.CharHeight * 1.1)
  Next

This may be enough to get you started.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org