Re: countif on multiple i­tems - date test

[johnny smith]

On Fri, 07 Dec 2012 08:20:45 -, DaveInDenver  wrote:

> How can I modify the formula to test for a date?
>
> If Column A were dates for example.
> A1 = 08/01/12
> A3 = 08/15/12
> A9 = 09/01/12
>
> How do I select for Aug 2012?

i've found 2 ways, both not ideal. the first is:

B1 = 08/01/12
B2 = 09/01/12
B3 = COUNTIF(A1:A9;">="&B1)-COUNTIF(A1:A9;">="&B2)

--which looks a bit like a workaround, as i was not able to find a way to apply 
a regular AND statement. however, this one is the most compatible, since it 
handles different date formats automatically.

the second option is to use wildcards:

B1 = COUNTIF(A1:A9;"08/[0-9]{2}/12")

or

B1 = COUNTIF(A1:A9;"August [0-9]{1,2}, 2012")

--which depends greatly on the locale settings and thus lacks compatibility 
when loading on a different machine.

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

Re: Auto Format

[johnny smith]

On Saturday, 11 January 2013 20:24:00, Dale Erwin  wrote:

> iF I type a fraction, when I tab out of the box, it 
> seems to change it into a date.  For example if I type 1/64 it changes 
> it to 01/01/64, or 1/32 is changed to 01/01/32. Oddly enough, if I type 
> 1/16 it changes it to 01/16/13.

openoffice.org help provides the following advice when searched for 'number 
recognition':

Do one of the following:
Right-click in a table cell and choose Number recognition. When this feature is 
on, a check mark is displayed in front of the Number recognition command.
Choose Tools - Options - OpenOffice.org Writer - Table, and select or clear the 
Number recognition check box.

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

Re: Conflicts?

[johnny smith]

On Friday, 11 January 2013 20:40:07, jamwilli2...@comcast.net wrote:

> My question is whether I can download OpenOffice and use the same program he 
> is without being in conflict with my M/S Office Suite.

sure you can. there is an option at the end of the installation process whether 
to open ms office files with the newly installed ooo or keep them with mso.

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

Re: RE: Auto Format

[johnny smith]

> I'm having the opposite problem: 1/2 does not auto-convert to ½ as it once
> did.  How do I get that function to work?

that could be set in the replacement table under "tools/autocorrect options" 
for the language used.

> (And no, I haven't redone my profile.)

and that seems to be the origin of the evil. after all, you could just try and 
then switch it back.

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

Re: OO

[johnny smith]

On Tue, Jan 15, 2013 at 7:19 AM, Don Warne  wrote:
> My problem is that it keeps writing
> numbers in the left hand margin in a manner that is completely out of
> control.
> I can't erase them or my script jumps onto the preceding line, or even gets
> lost completely - a real nightmare.

you may have accidentally enabled line numbering. please open "tools/line 
numbering" and uncheck "show numbering" if it's checked.

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

Re: reveal codes

[johnny smith]

On Sunday, 20 January 2013 19:46:18, Doug  wrote:

> Why must you insist on making the writer go thru hoops to fix something 
> when Reveal Codes can do it for him quickly and easily? Just let us have 
> the capability--if *you* want to go thru those
> hoops, then go ahead--I don't want to have to!

formatting through styles is a 'clean' way, while low-level tags are a 'dirty' 
path--
which is a nightmare for a person sticking to styles and structure. these're 
simply two incompatible ways of seeing things, and the philosophy of oo is 
likely 
to be the 'styles' one. however, you're always welcome to open any oo 
document as a zip archive and view--or even edit--the low-level picture with 
all 
tags included within content.xml. there were cases when i was about to do that, 
desperate to fix some particular problem by usual gui means, but in the end i 
always managed to find a more conventional way of fixing things.

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

Re: How? copy a graph exactly­ (no data table) to anoth­er file

[johnny smith]

On Friday, 1 February 2013, 19:24:01, David L Babcock  
wrote:

> However the graphs so transferred appear in the new file with a data 
> table instead of actual cell ranges, which kills them dead so far as 
> showing changing data.  They show a snapshot of last year's last data.

the workaround is to copy to the new file not the sheet's content but the sheet 
itself. to do it please right-click the sheet's tab in the bottom of the calc's 
window, open the 'move/copy sheet' window from the context menu and choose what 
is needed from the 'to document' list. the sheet will be copied in full with 
all graphs linked to the appropriate data ranges. you could then delete all the 
old data from the sheet's cells, leaving the graphs alone, and fill in the new 
content.

you should also note that i failed to reproduce the bug in the latest version 
of open office, 3.4.1, although i could recollect experiencing it myself in the 
past. so, it may have bin fixed by the developers since then. if your office is 
not the most up-to-date, then you could probably get your problem fixed by just 
upgrading.

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

Re: How? copy a graph exactly­ (no data table) to anoth­er file

[johnny smith]

On Fri, 01 Feb 2013 19:23:21 -, David L Babcock  
wrote:

> However the graphs so transferred appear in the new file with a data
> table instead of actual cell ranges, which kills them dead so far as
> showing changing data.  They show a snapshot of last year's last data.

On Sat, 02 Feb 2013 12:19:18 -, johnny smith  wrote:

> the workaround is to copy to the new file not the sheet's content but the 
> sheet itself.

since then, i've found a better workaround, which is:
1. rename the sheet with the source data ranges to Sheet1 (experimenting with 
Sheet2 and other similar names didn't succeed),
2. rename the sheet which contains the respective data ranges in the 
destination document to Sheet1 too,
3. copy and paste the graph.

note that the sheet on which the graph itself resides doesn't matter, only that 
one with the data ranges does.

i do not know why the program behaves this way but it does, however. i also was 
not able to find how to perform the trick if the data ranges spread over 
several sheets.

and, lastly, it's obviously a kind of unspecified behaviour indicating some 
issue in the underlying code. as far as i know, the problem with copying graphs 
between sheets exists in ms excel too.

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

Re: Transition to OpenOffice ­Writer

[johnny smith]

On Wednesday, 6 February 2013, at 13:30:50, Joel Ikenberry 
 wrote:

> Here is what I need to know how to do:
> 1. Format different page numbers- Title Page (no number)- Dedication Page (no 
> number)- Table of Contents (roman numerals)- Preface (roman numerals)- 
> Prologue through all chapters ( starting at page 1)- Acknowledgments 
> (continuing page numbers)- Appendices/Index (continuing page numbers)
> 2. Create a traditional Table of Contents (like in any other novel, no 
> business topics or sections and complete with a leader)
> 3. Design headers to display book name on one page, chapter title on the 
> next, continuously
> 4. Vertically align a paragraph

the attached file is an example of handling points 1--3 (i really hope the 
attachment would reach at least the poster himself, if not the list). every 
paragraph, except placeholders in parentheses, has been assigned a custom style 
(see 'format/styles and formatting' and choose 'custom styles' from the 
drop-down list), and so have been the pages.


SampleBook.odt
Description: application/vnd.oasis.opendocument.text

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

Re: How? copy a graph exa­ctly­ (no data table) to ­anoth­er file - partial s­uc

[johnny smith]

On Thu, 07 Feb 2013 18:34:02 -, David L Babcock  
 wrote:

> Using your latest advice (above) I was able to get 4 of 5 graphs  
> transferred.  The 5th graph copied over with the sheet, but when -in the  
> new spreadsheet-  I recopied it to the correct sheet, it still popped  
> into "data table" form.  In all 5 cases the data ranges and the graphs  
> are on the same sheet.

copying between the sheets of the same document can be acomplished through  
the following ritual:
1. rename the source sheet to Sheet1,
2. create a temporary document containing a sheet named Sheet1,
3. copy the graph between these sheets (in fact, you can copy to any other  
tempdoc's sheet on this step, Sheet1's bare existence within the tempdoc  
is quite sufficient),
4. restore the source sheet's name to its original state,
5. rename the destination sheet to Sheet1,
6. copy the graph to this Sheet1 from the tempdoc's Sheet1,
7. rename the destination back to what it used to be previously.

you see, the clue is to always copy between the sheets named 'Sheet1'. i  
realise it's ridiculous, but it works. as it has already been mentioned,  
copying graphs is a bug common throughout all spreadsheet editors.

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

Re: Auto formatting

[johnny smith]

On Tue, 05 Mar 2013 15:53:07 -, John Nunnikhoven   
wrote:



How do I turn off auto formatting?  I have searched the help files but
cannot find anything helpful?


try unchecking everything under the [T] column at  
'tools/options/autocorrect options/options'.


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

Re: Problem with Open Office: printed page not like onscreen page

[johnny smith]

On Tue, 12 Mar 2013 03:54:10 -, Martin Groenescheij  
 wrote:



On 12/03/2013 2:25 PM, Robyn Jamison wrote:

I drafted a 6 page document and when I printed it, the print on each  
page actually ran off the page, by about 1/4.
I ended up re-formatting the pages so that the page was only filled  
down 2/3 of the page, but it’s a imprecise and a pain.


the problem may be with the printer, not with openoffice. just test this  
by printing the document from any other application, e.g. export it to pdf  
and print via your pdf reader.


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

Re: Deleting pages

[johnny smith]

On Tue, 12 Mar 2013 21:02:36 -, Dale Erwin  wrote:

No, Print Preview does not show the automatically inserted blank pages.   
At least, it doesn't on my system.  On my documents, in Print Preview,  
the only hint that blank pages have been inserted is in the page  
numbers.  If one chapter ends on a right page, the next chapter  
automatically begins on a right page so a left page is inserted to cause  
this to happen.  Right pages always have odd-numbered pages, so if one  
chapter ends on, say, page 21, the next chapter will begin on page 23 so  
you know that blank page 22 was inserted.  However, if you export to  
pdf, the pdf file will have the blank pages.


i could achieve similar results when setting 'tools/options/openoffice.org  
writer/print/print automatically inserted blank pages' to false and  
'file/export as pdf/general/export automatically inserted blank pages' to  
true. however, the former seems to synchronise with the latter on the  
event of exporting. (aoo 3.4.1 on winxp sp2.)


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

Re: spell check

[johnny smith]

On Thu, 14 Mar 2013 01:39:07 -, Alan Cliffe  
 wrote:


The spell check feature in my copy of AOO has stopped working. If I  
click the autospellcheck icon, with the squiggly red line, it underlines  
every word of my text as a misspelling. If I click the Spelling and  
Grammar icon, with the blue check mark, it just shows the first word of  
a sentence in red and says the word is not in the dictionary. It doesn't  
matter what word it is; it does it for very common words such as “if” or  
“and.” Any ideas?


you should probably reset your user profile, please see  
. this is a  
known issue to have been fixed in forthcomming openoffice 4.


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

Re: Wavy underlining?

[johnny smith]

On Sun, 31 Mar 2013 06:40:00 -, George H. Johnson  
 wrote:


After some serious work on my PC to kill a virus or two, my OpenOffice  
documents in Writer and Calc now have a wavy [reddish] underlining for  
most words [exceptions: power fields]. Since this appears to be true of  
every document, this must have been reset globally. How can I change it  
back? Thanks.


please try resetting your user profile. for the instructions, see this  
tutorial:


.

the link is from the list of known issues for the latest release, which is  
accessible from here:  
.


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

Re: Open office 2.4.3 with Java 7

[johnny smith]

On Wed, 10 Apr 2013 02:03:06 -, NG, Derek  wrote:

So I can safely assure that OpenOffice 2.4.3 does not support Java 7  
since it is a couple of years old but OpenOffice 3.4.1 and above support  
Java 7?


java claims both backwards and forwards compatibility, which assumes that  
oo 2.4.3 should work smoothly with java 7. however, you should note that  
java 7 requires visual c++ redistributable 2010, the latter being  
accessible for no charge from microsoft and a number of third-party sites.


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

Re: Opening an existing document

[johnny smith]

On Wed, 10 Apr 2013 17:34:40 -, Dale Erwin  wrote:

In previous versions of OOo, when an existing document was opened in  
writer (I don't know about other components), it was opened at the same  
place in the document where it was closed the time beffore.  I find that  
function rather useful and do not understand why it has been  
eliminated.  Would it be possible to get it back?


On Wed, 10 Apr 2013 18:30:59 -, Rory O'Farrell  wrote:

If you refer having the document opening at the last editing position,  
you need to enter a name in

/Tools /Options /OpenOffice.org /User Data on Windows / Linux machines.


and you would probably need to enable loading user-specific settings with  
documents under tools > options > load/save > general (i didn't try myself  
but that seems sensible).


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

Re: Scanning

[johnny smith]

On Sat, 20 Apr 2013 14:23:39 -, Diann  wrote:

I have an iMac OS 10.8.3 (Mountain Lion).  I downloaded OpenOffice  
3.4.1.  .  My printer/scanner is an HP office jet 6600.  The scanner  
works fine in all my other programs, but in Oo it won't work.  I click  
on insert - pictures - scan - select source.  Then nothing happens.


does anything happen when you click insert - picture - scan - request?

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

Re: Zooming in

[johnny smith]

On Wed, 08 May 2013 02:07:48 -, Patricia Hickin   
wrote:



My computer zooms in on OpenOffice (and other) screens without my telling
it to.
(I have a laptop with touchpad).  I know it has something to do with the
way I'm using my fingers on the touchpad but I can't quite figure out how
to avoid it.

Is there any way I can disable this feature?  It drives me crazy.

(It happens with other programs too.)


ctrl + mouse wheel up/down is a common way of zooming in/out in many apps.  
it may be your case too, since touchpads usually possess a substitution  
for a wheel either at the right margin or by touching with two or three  
fingers simultaneously.


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

Re: subscriber status

[johnny smith]

On Mon, 13 May 2013 19:42:27 -, Warren Mullen   
wrote:



How do I enroll as a subscriber to this service?


to subscribe, please send an email to  
users-subscr...@openoffice.apache.org. you then will receive a  
confirmation email with further instructions.


dan lewis, probably by mistake, recommended you the subscription address  
for similar mailing list of libreoffice, which seems to be not quite what  
is needed.


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

Re: Language pack

[johnny smith]

On Wed, 22 May 2013 09:06:55 -, Arianna Carloni
 wrote:

I have downloaded OpenOffice 3.4.1 and the Italian Language Pack as I  
need

to perform spell checks on Italian documents.

I think I am missing a step though, as when I open a text document in
OpenOffice and I try to set the proofing language to Italian it says it's
not installed.


try installing the dictionary as an extension from here:

http://extensions.openoffice.org/en/project/dict-it

the instructions on how to install can be found here:

http://extensions.openoffice.org/en/resources/user/howto_install

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

Re: Array formulas: maximum value – two conditions

[johnny smith]

On Fri, 31 May 2013 20:10:14 -, Johnny Rosenberg  
 wrote:



Column C: Name
Column D: Date
Column H: Points

I want to see the highest point for the name in P3 for dates in this
year (2013).

I tried the following:
{=MAX(IF(AND(YEAR(D2:D1)=YEAR(TODAY());C2:C1=P3); H2:H1; 0))}
Result: 0.
Expected result: 588.

I obviously misunderstood the whole concept, so how is it supposed to be  
done?


substituting ordinary mathematical multiplication for logical conjunction  
did the trick for me, which is as follows:


{=max(if(if(year(d2:d1)=year(today());1;0)*if(c2:c1=p3;1;0);h2:h1;0))}

i think the origin of the problem is that {=and(a1:a3)} is interpreted as  
{=and(a1;a2;a3)}.


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

Re: strip formatting??

[johnny smith]

On Sun, 02 Jun 2013 03:49:39 -, Patricia Hickin   
wrote:



Is there a way to remove all formatting?


please select the text and apply one of the following:

1 press ctrl+m
2 choose 'default formatting' from the 'format' menu
3 choose 'clear formatting' from the 'apply style' drop-down list on the  
'formatting' toolbar


then you can format the text in an appropriate way.

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

Re: re Open Office upgrade

[johnny smith]

On Fri, 07 Jun 2013 12:59:25 -, Des  wrote:

I downloaded the latest version of open office & I installed it but  
unfortunately the program would not open.


My previous version is Open Office 3.3


when upgrading from 3.3 to 3.4, there may be a problem with the user  
profile. please refer to the first known issue in the release notes:




and to the respective topic of the community forum:



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

Re: re Open Office upgrade

[johnny smith]

On Fri, 07 Jun 2013 12:59:25 -, Des  wrote:

I downloaded the latest version of open office & I installed it but  
unfortunately the program would not open.


My previous version is Open Office 3.3

I have a Macbook build 10KS49 Processor 2.13 GHz Intel core 2 Duo Memory  
2 GB 800 MHz DDR2 SDRAM


Can you please give me some advise so I can use the new version of Open  
Office


replies by kadal, steve and johnny (me) have forwarded to des, who is not  
subscribed to the list, along with the instructions on how to subscribe or  
read the list archives.


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

Re: Unattached letters in Persian Words on Mac OSX

[johnny smith]

On Sun, 09 Jun 2013 09:00:04 -, mehdi soleimani  
 wrote:


I am using openoffice 3.4.1 on Mac OS X 10.8.2 . When I type in  
Persian/Farsi the letters are not attached to each other as they are  
supposed to be. I had same problem with Microsoft Office Word 2011 and  
there was a "ligatures" option which did the trick for me. Any idea on a  
workaround? Is it a bug?


my only suggestion is to enable pair kerning under the 'position' tab of a  
character or paragraph style.


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

Re: Unattached letters in Persian Words on Mac OSX

[johnny smith]

On Sun, 09 Jun 2013 11:42:53 -, mehdi soleimani nasab  
 wrote:



Thanks for your reply Johnny. Pair kerning only change the space
between letters. My problem is that a word is depicted as "س‌ل‌ا‌م"
when it should be "سلام".


user FruitLoopMT on the community forum advises as follows:

'First off, OpenOffice does correctly connect the letters. The problem is  
the font oddly enough. The default font is Tahoma which does not connect  
the letters. Arial does not connect them either, and neither does Times  
New Roman. Many other fonts will connect the letters though. I switched to  
Apple Chancery because of the slightly extra padding around the words.  
(Easier to read for a newb like myself.) Verdana is a font that I've seen  
often enough which also connects the letters.


Simple answer is change your font. But that's not good enough for me. I  
have to write reports in Farsi for school all the time and it is a hassle  
to constantly change my font any time I change my language. Go here:  
OpenOffice.org -> Preferences -> OpenOffice.org Writer -> Basic Fonts CTL.  
The default is having all of the fonts Tahoma, which does not connect.  
Change all of the values to a font of your choosing which does connect the  
Farsi/Arabic letters correctly and voila! Any time you change languages  
while typing it will now use your newly set default font and it saves me a  
step from changing it every time I start a new document.'


so, it seems that you need a proper set of multilingual fonts. other posts  
from that forum topic may be found here:  
.


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

Re: Unattached letters in Persian Words on Mac OSX

[johnny smith]

On Mon, 17 Jun 2013 04:48:02 -, Urmas  wrote:

Obviously Tahoma, Arial and Times New Roman do connect letters properly  
with normal software.


that may apply to properly localised distributions rather than to the  
general case. however, i've been just citing the community forum.


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

Re: Codes

[johnny smith]

On Thu, 20 Jun 2013 23:54:50 -, Patricia Hickin   
wrote:



I have obtained the info from www.worldcat.org, compiled a list of the
books, copied the list into Notepad to strip it of formatting.  Next I
copied the list into an OO text document and formatted it as follows:


try stripping off the formatting through 'format/default formatting'.

it may also be of use to attach a sample file with an issue, though you  
would probably have to use a file hosting because of antispam restrictions  
of this mailing list.


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

Re: Codes

[johnny smith]

On Sun, 23 Jun 2013 05:17:07 -, Rory O'Farrell  wrote:

One tip: in many versions (all? I haven't checked) of OpenOffice it can  
be difficult (impossible?) to insert a curly quote into the Replace box  
from /Insert /Special Characters.


inserting special characters into that box is available from the context  
menu or through shift+ctrl+s.


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

Re: Page numbers

[johnny smith]

On Tue, 02 Jul 2013 19:22:56 -, Henry Rappaport  wrote:

Does anyone know how to begin page numbering at a certain number within  
a multi page document. I want to start at page 3 which is actually about  
8 pages into my document.


the easiest way is to open the 'insert/fields/other' dialog, choose 'page'  
from the list of types and enter 2 into the 'offset' field. or you can  
edit an already created page number field by plasing the caret before it  
and clicking 'edit/fields'.


however, that doesn't work smoothly by default when the page is to bear a  
number greater than the total ammount of pages in your document (e.g. p. 7  
of your document, which is to be labelled p. 9). to overcome this, do the  
following:


select the first paragraph of the page that is to be p. 3, open  
'format/paragraph/text flow', switch on both 'insert' and 'with page  
style' and enter what you need (and not zero, which is default) under  
'page number'.


after that the offset feature begins working properly. however, there is  
no more need to make use of that feature because you could just put the  
proper value into the said 'page number' field.


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

Re: OpenOffice 3.3 and Java 7

[johnny smith]

On Wed, 03 Jul 2013 17:58:34 -, Steele, Raymond  
 wrote:


We are currently running Solaris x86 with OpenOffice 3.3. We have  
recently be directed to upgrade our systems to Java 7, but cannot seem  
to get Java 7 to work correctly with OpenOffice version 3.3.


under windows, java 7 requires visual c++ redistributable 2010, which is  
packed neither with it nor with aoo and should be downloaded separately.  
there might be some similar requirements to update the libraries under  
solaris too.


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

Re: Related to changing font color of a large selection of cells in OpenOffice Calc

[johnny smith]

some comments first, the solution follows after an asterisk (*).

On Sat, 06 Jul 2013 07:28:50 -, Pushpak Dagade   
wrote:


Assume I have a spreadsheet with a column containing 50 cells of text  
data.

Suppose I change the font colour of only half the text in a particular
cell, say, no. 10, to red (so cell no. 10 now has its contents in 2  
colours

- red and black). Everything is as expected till now.


here you change the font color of particular characters, i.e. create a new  
character style and apply it to those characters.


The problem comes when I try to select all the cells and change their  
font

colour to say, yellow. What I expect is all cells, irrespective of their
prior font colours, should have their font colour yellow. However, what I
get is a different result for cell no. 10. Cell no.10 has half its text
(which was originally black by default) in yellow, but the red coloured
contents are still red in colour.


here you change the font color of the entire cells, i.e. create a new cell  
style and apply it to the cells. the previously created character style is  
still applied on top of the cell style because the latter is more common  
an the former is more specific.


cell style may be changed expressly through the 'style and formatting'  
panel or may be implied if you just picked it from a drop-down list on the  
'formatting' panel. character styles are always implied in calc, which is  
not good, as your case shows.


*

the solution to the problem is to clear all formatting of the cells in  
question (both cell and character styles) by selecting them and applying  
'format/default formatting'. after that you can turn them yellow as you  
wish.


if you don't want to clear your well adjusted cell style then you can save  
it by selecting a sample cell and clicking 'new style from selection' on  
the 'styles and formatting' panel (which is opened by pressing f11 or  
clicking 'format/styles and formatting'). after applying default  
formatting and deleting all character styling thereby, the newly created  
style can be cast back on the cells.


p.s. if there were a possibility to expressly create new character styles  
in calc, as it is in writer, then you could perform a simple  
search-and-replace operation to switch from the 'red text' character style  
to the default one.


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

Re: Related to changing font color of a large selection of cells in OpenOffice Calc

[johnny smith]

here is a reply pushpak sent to me personally:

Hello johnny,
Thank you for your quick reply. I truly appreciate it.


I was able to understand what you said here clearly. Thank you. Solved ~25%
of my problems straightaway -

 the solution to the problem is to clear all formatting of the cells in

question (both cell and character styles) by selecting them and applying
'format/default formatting'. after that you can turn them yellow as you
wish.




However, I couldn't understand what you said here, since when I was trying
to try it myself on Calc, I couldn't get what I expected -


if you don't want to clear your well adjusted cell style then you can  
save

it by selecting a sample cell and clicking 'new style from selection' on
the 'styles and formatting' panel (which is opened by pressing f11 or
clicking 'format/styles and formatting'). after applying default  
formatting
and deleting all character styling thereby, the newly created style can  
be

cast back on the cells.



Maybe, I didn't clearly understood what you tried to explain.
I' would like to continue with my previous example to explain what I was
trying to do.
I had cells no. 5 and 10 in bold, rest all normal (ie not bold). I selected
all the cells, clicked on 'new style from selection', cleared up all
formatting, changed the cell font colours as required (got everything
expected till now), and then finally double clicked on the saved style.
However, I didn't get back cells no. 5 and 10 in bold.

Can you please let me know what am I doing wrong here.

Thank you once again.
Sorry for my late reply. Got stuck up with some unavoidable work.

Regards,
Pushpak


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

Re: Related to changing font color of a large selection of cells in OpenOffice Calc

[johnny smith]

and here's my reply to pushpak given on 8 July 2013 at 21:00:04:

On Mon, 08 Jul 2013 20:03:08 -, Pushpak Dagade 
wrote:

I had cells no. 5 and 10 in bold, rest all normal (ie not bold). I  
selected all the cells, clicked on 'new style from selection',


from here it went wrong. the selected cells had different cell style: some
were regular and other bold. so, calc can't have create a single style
from the entire selection but rather created a style from the first cell
of the selection, which wasn't bold. saving formatting through creation of
a new style works only if all cells are identical in style.

however, that's not a problem. you can just create a backup of the
selection in some spare location in your spreadsheet, maybe on a new
sheet, then clear formatting of the original and restore its cell styles -
but not character styles - from the backup. For that you should copy the
backup, select the original, choose 'edit/paste special' and uncheck
everything but 'formats'.

if sizes of the original and the backup are equal, which is assumed true,
then all cell styles of the backup will be transfered to the original,
after which the backup may be safely disposed of, because it is no longer
needed.

p.s. please don't respond to me personally but rather to the list, viz.
. it's meant to be a kind of open help desk,
so that your successor in experiencing a similar problem would find the
solution by just googling it.

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

Re: Read Only

[johnny smith]

On Thu, 05 Sep 2013 21:15:02 -, Peggy Clarahan  
wrote:


I have at least one document I have written in Open Office - Open
Document Text that when I return and open the document I cannot make
changes to - the name of the document is followed by "(read only)".  I
have not (knowingly) requested this "read only" status.
1. Is there any way I can change this so it is not "(read only)"?
2. How or why does this happen?
3. Can I copy the text and paste it into a new document so it is not "(read 
only)"


there is a button 'edit file' on the standart toolbar. make sure it's pressed. 
after that you can edit the file and save it to any location. a document can 
become read-only if such property is set for that file or its folder or if you 
saved it, while being under another account, to a location that you have no 
write access to under your current account.

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

Re: OpenOffice and Zotero

[johnny smith]

On Sat, 28 Sep 2013 22:00:03 -, Tom Backer Johnsen  
wrote:


As far as I can see from the Zotero page, no plugins for AOO documents are 
mentioned, only Word and LibreOffice are mentioned.  That seems to be a change, 
I am sure that AOO used to be mentioned there as well.


description of the libreoffice plugin reads as follows:


The latest version of the LibreOffice plugin for Zotero 3.0+ is 3.5.8 
(compatible with all versions of LibreOffice, all versions of Apache 
OpenOffice, and OpenOffice.org 3.0-3.3.x).


it is thus expected to be 'compatible with [...] all versions of apache 
openoffice'.

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

Re: Needed: more keyboard shortcuts! (Writer at least) - Mac OSX

[johnny smith]

On Sun, 29 Sep 2013 19:18:17 -, Julian Thomas  wrote:


there no keyboard shortcut to the menubar categories [File, Edit, View, Insert…]


under windows, you press alt key, and each menu item gets one character 
underlined. alt + that character is the proper shortcut, e.g. alt+f for 'file', 
alt+e for 'edit', alt+o for 'f_o_rmat' etc. would it work on mac if you 
substitute option for alt?


there are no shortcuts for insert mark


ctrl+shift+enter to insert column break,
ctrl+enter to insert manual page break,
shift+enter to insert manual line break.

shortcuts are adjustable through tools/customize/keyboard. just pick a key 
combination from the list of shortcut keys, find the function to assign under 
appropriate category and click 'modify'. you can load/save your shortcut 
collections.

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

on rotating tables

[johnny smith]

On Sun, 20 Oct 2013 19:54:16 -, Uwe Brauer  wrote:


I googled a bit but found no solution to the problem
of rotating a table such that

| 1 | 2 | 3 |
| 4 | 3 | 4 |
becomes
| 4 | 1 |
| 3 | 2 |
| 4 | 3 |


first, invert the range vertically, e.g. by adding the column with consecutive 
numbers to the right of it and then sorting the range in descending order with 
respect to the added column  ('data/sort/sort criteria', set 'sort by' to the 
added column).

second, copy the inverted range, perform 'edit/past special' and tick the 
'transpose' option in the dialogue window that will appear.

or you can use a formula like this: 
rotated_sheet.a1=indirect(address(column(a1);2-row(a1);;;"initial_sheet") -- 
and then copy the resulting range and paste-special it leaving only 'numbers' ticked 
under 'selection'.

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

Re: rotating tables in calc

[johnny smith]

On Sun, 20 Oct 2013 19:54:16 -, Uwe Brauer  wrote:


I googled a bit but found no solution to the problem
of rotating a table such that

| 1 | 2 | 3 |
| 4 | 3 | 4 |
becomes
| 4 | 1 |
| 3 | 2 |
| 4 | 3 |


first, invert the range vertically, e.g. by adding the column with consecutive 
numbers to the right of it and then sorting the range in descending order with 
respect to the added column  ('data/sort/sort criteria', set 'sort by' to the 
added column).

second, copy the inverted range, perform 'edit/past special' and tick the 
'transpose' option in the dialogue window that will appear.

or you can use a formula like this: 
rotated_sheet.a1=indirect(address(column(a1);2-row(a1);;;"initial_sheet") -- 
and then copy the resulting range and paste-special it leaving only 'numbers' ticked 
under 'selection'.

p.s. sorry, my post provider's evil antispam engine rejects the original 
subject.

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

Re: how to display fonts of a­ certain encoding (hebrew­)

[johnny smith]

On Tue, 29 Oct 2013 11:36:53 -, Uwe Brauer  wrote:

> Is there a way to display only the say hebrew fonts.
> The font menu lists all of them, can I filter the list?

you can create respective custom character styles and display them on the list 
of styles. alternatively, font history option (options/openoffice.org 
writer/view/show font history) may be of use.

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

Re: document with 2 tables, s­elect all does not select­ all

[johnny smith]

On Tue, 29 Oct 2013 11:39:44 -, Uwe Brauer  wrote:

> I have a document which contains a
>
> table
>
> Some text
>
> table
>
>
> So I want to select all the text of the document (basically I want to
> change the font), but select all does not select all, it only selects
> one table!

the problem vanishes if you insert some text before the first table (by 
positioning the caret in the beginning of its first cell and typing something).

that looks like a bug.

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

Re: Example where the workaro­und does not work (was: d­ocument with 2 tables, s

[johnny smith]

On Wed, 30 Oct 2013 10:47:49 -, Uwe Brauer  wrote:

> Please look at the following document, which has been generated by a
> converter provided by org[1]
>
> It contains tables which whose text cannot be selected via select all.
> If there is something wrong with the odt, please tell me and I will
> report it on the org mailing list.

notwithstanding dave's comment, the odt seems either defective or incompatible 
with aoo (which may be aoo's fault as well). more specifically, the tables are 
quite lonely within their sections. they have no text before them, nor after. 
such a document can't be created by usual means of aoo, and thus it isn't 
handled as expected. e.g., you can't type anything after the second table or 
after the first one within its section, because there're no empty paragraphs 
after the tables to take your input. you can't even peform select-all operation 
manually (with a mouse rather than through ctrl+a). it seems that the select 
operation uses contents of the  elements to set boundaries of the 
selection. so, if there's no such element, then select-all doesn't work 
properly.

to fix this, i inserted the following two paragraphs into content.xml of your 
file:

some text after the first 
table
some text after the second 
table

they follow the closing tags () of tables. there appeared to be 
no way to do it through gui.

after that select-all worked almost smoothly: it selected the cell on the first 
press, the table on the second one and everything on the third one. what was 
wrong is that it always started with the cell, even when the caret was outside 
table.

however, inserting a paragraph before each table fixed this. it didn't require 
editing content.xml. the final version of the file is attached, and i hope it 
won't be attenuated by antispam.

i can't say on which program's account this bug is. consulting odf 
specification may help answer this question.


testorg.odt
Description: application/vnd.oasis.opendocument.text

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

Re: Example where the workaround does not work (was: document with 2 tables, s

[johnny smith]

On Thu, 31 Oct 2013 11:46:32 +0100, Dave Barton  wrote:


Obviously disassembling and
reassembling the document has broken the table's "Conditional
Formatting", which allows Select All to work.


why? i didn't touch the tables and their styles, just inserted paragraphs with 
already existing style after them. how did this modify the table's conditional 
formatting?

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

Re: Java Troubles When Trying to Use Mail Merge

[johnny smith]

On Thu, 14 Nov 2013 00:35:43 -, jjb i.e. Just Jeff Butler 
 wrote:


I've used Open Office for some time now and LOVE IT!  I haven't tried using the 
Mail Merge Wizard feature until today and it kept telling me that I needed Java 
to run it.  I had previously removed Java from my computer because of the 
problems with it.  Anyway, I reinstalled it to try and get Mail Merge to work.  
Unfortunately, I still can't complete the merge.  It can't seem to find Java.  
I am using Windows 7, 64-bit.


java 7 seems to depend on visual c++ redistributable 2010, so you may need to 
download and install it if it has not been installed yet.

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

Re: Writer, ouline numbered list

[johnny smith]

On Sun, 17 Nov 2013 10:37:07 -, Tom Backer Johnsen  
wrote:


I am having problems with formatting an outline numbered list.  What I would 
like to have is a list where the number of the item is on the same horizontal 
position av the text of the level above.  About like this:

1   Text
1.1 Text
1.1.1   Text
2   Text
2.1 Text


i followed this procedure:

1 go to format -> styles and formatting -> list styles -> right click -> new -> 
position
2 select level 1
a numbering followed by tab stop at, e.g., 1cm
b numbering alignment left
c aligned at, e.g., 0cm
d indent at, e.g. 1cm
3 select level 2
a numbering followed by tab stop at, e.g., 2
b numbering alignment left
c aligned at the same as 2d, i.e. 1cm
d indent at, e.g., 2cm
4 and so on

the point is to set 'aligned at' of the i-th level to the same value as 'indent 
at' (and 'numbering followed by tab stop at') of the (i-1)-th level. everything 
works fine.

a sample file is attached, and i hope the attachment won't be filtered out.

sample.odt
Description: application/vnd.oasis.opendocument.text

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

Re: Performance measurements on Mac vs others

[johnny smith]

On Tue, 31 Dec 2013 18:21:46 -, Johnny Rosenberg  
wrote:


CPU speed isn't everything.


particularly, hdd speed is of importance because large amounts of data are read 
from the disk on startup. on my computer (amd athlon ii x2 240e, 2.8 ghz, 4 gib 
ram, windows xp sp2) openoffice starts in six seconds, and this period of time 
is filled with hdd cracking and knocking. hdd is a rather old western digital 
caviar wd200bb-32aua1.

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

Re: Need Help About Custom Sort

[johnny smith]

On Tue, 14 Jan 2014 13:20:38 -, Shirish Kolekar  
wrote:


Issue : problem while sorting entries in Marathi Language.

Solution tried : Fed Marathi Alphabets in the Sort Order that we want but
still vowels are not being sorted. I Have done sorting successful for
consonents.


i don't speak marathi nor have appropriate fonts, so my advice may be naive. however, when i 
open a context menu for any of the cells in your spreadsheet and choose 'format cells', i see 
'arabic (saudi arabia)' under 'font -> ctl font -> language'. i think, marathi should 
stand there instead, as well as under 'data -> sort -> options -> language'.

if this is not the issue, then you may create a custom sorting list as a workaround by listing 
the alphabet in correct order under 'tools -> options -> openoffice.org calc -> sort 
lists' and then choosing it under 'data -> sort -> options -> custom sort order'.

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

Re: spell check

[johnny smith]

On Wed, 15 Jan 2014 19:59:01 -, ALEX CARSON  
wrote:


Following the installation of version 4.0.1 on my netbook running windows 7 
starter, The spell checker underlines every word in the document. I checked 
that the language was set correctly and the dictionaries were also set, in the 
tools options menu. I have tried uninstalling it and the re - install but 
nothing works.


it may be of use to try this: 
.

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

Re: loadComponentFromURL - Solaris 11 OO 3.3

[johnny smith]

On Thu, 16 Jan 2014 00:00:29 -, Steele, Raymond  
wrote:


I have OpenOffice 3.3 installed and running on my Solaris x86 system. Things 
run under normal user experience, but if I run a custom application it fails on
loadComponentFromURL("private:factory/scalc", "_blank, 0, loadProps).


is it ok that the number of quotation marks is odd?

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

Re: Opening an OpenOffice file.

[johnny smith]

On Wed, 22 Jan 2014 20:16:39 -, Tom Backer Johnsen  
wrote:


Recently. when I try to open an OpenOffice file, a window from OpenOffice appears 
with the text: "The last time you opened OpenOffice, it unexpectedly quit while 
reopening windows. Do you want to try to reopen its windows again?”.

In this window there are two buttons, one with “Don’t Reopen” and the other 
with “Reopen”.  Clicking any of the two buttons has no visible effect, and this 
window remains open until I force quit the application.


please refer to the last item in the list of known issues at 
http://www.openoffice.org/development/releases/3.4.1.html

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

hyphenation of uppercase words

[johnny smith]

dear users,

is there a way to forbid the automatic hyphenation of uppercase words in writer 
to prevent acronyms from breaking between lines?

i was able to find only a workaround of listing all uppercase words in a custom 
dictionary, but that requires creating a new entry each time one types a new 
acronym, which is not convinient enough. it's possible also to insert 
zero-width non-breaking spaces (U+2060) between the letters, but that is 
unnatural and can induce bugs when the word is copied to a plaintext file or if 
the font used has no U+2060 character (which seems to be the case even for 
times new roman, although inserting from dejavu fonts is available). an easy 
one-tick-to-rule-them-all option is needed.

(meanwhile, the feature is included with ms word and easily discoverable on the 
web. it seems to be disadvantageous for the openoffice community.)

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: host issue

[johnny smith]

Randy Kee  wrote:

> its telling me either another instance of O.O. is accessing your personal 
> setting or your personal setting are locked. simultaneous access can lead to 
> inconsistencies in your personal settings. before continuing, you should make 
> sure user closes O.O. on host. how do i close the host?

your openoffice user profile have probably been locked due to a crash or forced 
quit. please see this forum topic for the solution:

https://forum.openoffice.org/en/forum/viewtopic.php?f=6&t=32994

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: enabling macros from excel

[johnny smith]

On Sat, 15 Feb 2014 04:45:56 -, Chris Mccallum 
 wrote:


I'm trying to use a spreadsheet that was created (by someone else) in calc.
when i open it, i get an error message saying,

"Execution of macros is disabled due to the current macro setting in
Tools-Options-Open Office-Security"

I feel pretty dumb, but I just don't see an "Options" under the Tools menu


if your operating system is mac or gnome, then you should substitute 'edit -> 
preferences' for 'tools -> options'.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: [OO] VLookup question with multiple columns

[johnny smith]

On Thu, 20 Feb 2014 00:23:17 -, Wade Smart  wrote:


=VLOOKUP($E18,$Teams.$A$12:$I$23,($G$10+1),0)

E18 = Player Number on Roster (1 to 12)
Teams.A12:I23 = Team Roster names
G10+1= the input of team number

So we have Teams A 12 to 23
1
2
3 etc

Teams B
player name
player name
etc

Teams C
player name
etc

and I want to do this:
Teams A, B, C, D, E
1, 14, name, 2, name
2, 4, name, 5, name
etc.


so, you need to do lookups not only by number from column a, but also according 
to an alternative numbering system, whose numbers are indicated in columns b, 
d, f etc.?

if i have understood everything right, then the result should be like this:

"roster no.","jersey no.","team no. 1","jersey no.","team no. 2"
1,2,"alan",3,"frank"
2,1,"bruce",5,"gerald"
3,5,"charlie",2,"henry"
4,3,"daniel",1,"ian"
5,4,"elton",4,"james"

"numbering system","team no.","player no.","name",
"roster",1,3,"charlie",
"jersey",1,3,"daniel",
"roster",2,3,"henry",
"jersey",2,3,"frank",

(above is a csv file, lines are rows, and comma-separated numbers and quoted 
strings are cells.)

the formula for column d, 'name', of the lower table is:

d9=VLOOKUP(C9;IF(A9="roster";INDIRECT("R2C1:R6C"&(2*B9+1);0);INDIRECT("R2C"&2*B9&":R6C"&2*(B9+1);0));IF(A9="roster";2*B9+1;2);0)

from d10 downwards - just expand d9.

you need only to substitute the appropriate cell ranges.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Securing Open Office

[johnny smith]

On Sun, 02 Mar 2014 00:07:27 -, Kirby, Wayne  
wrote:


Is there a guidance document to secure Open Office?


what do you mean by 'securing open office'? it sounds a bit obscure.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Mailiste löschen

[johnny smith]

On Sun, 02 Mar 2014 13:09:47 -, Margot Duraku  wrote:


Bitte löschen sie die Mailiste sie ärgert mich schon lange immer um 01:00 
gekommen  ich die also bitte löschen


you are not subscribed to the list. you receive the mail from some other 
address, which is subscribed. if you want to unsubscribe, please send a message 
to users-unsubscr...@openoffice.apache.org from the address that is subscribed.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Printing a document

[johnny smith]

On Fri, 14 Mar 2014 20:57:35 -,  wrote:


How do I print a document in landscape?


setting 'format -> page -> page -> orientation' to landscape usually works fine. 
alternatively, you may export the document to pdf (file -> export as pdf) and rotate 
pages apropriately in your pdf viewer.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office not opening

[johnny smith]

On Mon, 17 Mar 2014 15:18:59 -, Frank Goforth  wrote:


thanks, I have by some mistake installed ver 4 which I think is now beta.  It 
appears the current version is 3.3.


no, 4.0.1 is current, 4.1 is beta.


I searched the library on my Mac and cannot find this file you reference.


it's not just in the library, but in the subdirectory 'saved application 
state'. also, it per se is a directory rather than a file.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Problem

[johnny smith]

On Mon, 17 Mar 2014 15:59:50 -, claire moore  
wrote:


Hiya I'm just wondering if there is anyway I can download open office to my 
iPad Air as it keeps telling my safari won't let me many thanks claire


No it will not run on a tablet or smartphone (because the smartphone
isn't smart enough).
But it will run on a Macbook

via Martin Groenescheij

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Window won't go away

[johnny smith]

On Tue, 18 Mar 2014 16:58:40 -, Matt Ware  wrote:


I keep getting this window that want's me to choose an option. Clicking on 
either option does nothing and I can't save or export any files because this 
window is open. I've uninstalled the program and downloaded a new version and 
reinstalled, reset PRAM and reinstalled...It won't go away! I've spent hours 
looking through the help forum to no avail. How do I make this pesky thing go 
away!


please read this thread:

http://markmail.org/thread/3i2aiirs7ayn4yso

particularly, this reply:

http://markmail.org/message/3r7zrctfuocyi3ha

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: How Do I Get Rid of Searchconduit?

[johnny smith]

On Wed, 19 Mar 2014 17:27:14 -, Bernie H  wrote:


It seems Apache OpenOffice has "deposited" this search engine on my
computer, along with Mysearchdial.


it seems that you have downloaded openoffice from a location other than 
openoffice.org/download. thus, it is not surprising that you have found some 
unnecessary stuff appended by the distributor. in future, always download from 
the official website, which is www.openoffice.org.


Please advise how I can kill them both, as I've tried to delete
Mysearchdial from Internet Options (where it highjacked my home page!), but
can't find either program listed so I can uninstall them.


that depends on what your os and browser are. in general, just open the 
browser's preferences and change the homepage. for more detailed instructions, 
please provide more detailed description of the problem and the environment.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Installation of OO 4.0.1 on iMac

[johnny smith]

On Wed, 19 Mar 2014 19:07:28 -, Wolfgang Weichert  
wrote:


I downloaded Open Office from the openoffice.org  website. On clicking the
download button it went to
sourceforge.net/projects/openofficeorg.mirror/?source=dlp.

After moving the application to the application folder and trying to open
it, I get the message "OpenOffice.app can't be opened because it is from an
unidentified developer. Downloaded from sourceforge.net".


Apache OpenOffice 4.0.0 will be flagged by the new Gatekeeper facility in Mac 
OS X Mountain Lion. This is a new feature to help guard against malware on Mac 
systems. There is a procedure laid out at the following link to allow 
applications not installed from the Mac App store to run. See the article at 
Mac support at http://support.apple.com/kb/HT5290.

(from here: 
, 
known issue no. 1)

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: How to change language

[johnny smith]

On Thu, 20 Mar 2014 16:41:59 -, Susan Stacey  
wrote:

> I have just had the open office downloaded for me onto my PC which has just 
> been repaired, they have downloaded the Spanish version ( i live in Spain but 
> am English) i cannot seem to change the language ( i tried tools / options/ 
> configure language ) but this doesn't help.advise, should i download the 
> whole thing again & delete this version?

you should go to http://www.openoffice.org/download/ and download an 
appropriate language pack. they are much smaller than full installation sets.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: OpenOffice 4.0.1 / Problem with xlsx file

[johnny smith]

On Fri, 21 Mar 2014 09:45:09 -, INDAG GmbH & Co Betriebs KG 
 wrote:


With Calc we can open xlsx files generated by Excel 2010.

But when we generate a xlsx file with TIA Portal from Siemens, we cannot open 
it with OpenOffice.
It works with Excel 2010.


the portal may generate defective files. try opening them with excel, saving 
and then opening the generated file with openoffice. if the file be opened, my 
suggestion must be true. then, we can compare the two versions and track the 
problem.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Can not remove background image

[johnny smith]

On Fri, 21 Mar 2014 22:19:34 -, Wade Smart  wrote:


I have a spread sheet that is setup as a form.
There is a background image ... a watermark
in the print range.. For some reason its become
skewed. When I click format > page, it does not
indicate there is a image there.


that may be not a background image but an ordinary graphic moved to background through 'format 
-> arrange -> to background'. such graphics can't be selected by a simple mouse click. 
if so, open the navigator (view -> navigator), select the graphic under the 'graphics' 
category and choose 'format -> arrange -> to foreground'.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Warning: [Was Re: How Do I Get Rid of Searchconduit?

[johnny smith]

On Fri, 21 Mar 2014 22:48:10 -, Bruce Pierson  wrote:


I got this little gem in something called “Sweetpacks” and yes, it cropped up 
after a download from CNET.  I managed to get rid of it but it was not easy.  I 
did it by working my way backwards deleting and then reloading (without using 
CNET).  I am normally careful about downloading but somehow this slipped in.  
After this I am very cautious about getting anything through CNET.


i suppose the point may be that the target file is downloaded not directly but 
with the help of a small 'download manager' file that you are to download 
first. i avoid downloading through such managers.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Warning: [Was Re: How Do I Get Rid of Searchconduit?

[johnny smith]

On Sat, 22 Mar 2014 09:30:27 -, DaveMainwaring  
wrote:


Please explain the choices available for managing downloads


well, i've just checked cnet and found the downloads are direct. however, a 
similar site, brothersoft.com, does use a download manager, stating as follows:


The program you want to download will be downloaded through Brothersoft 
Downloader, making the download process much faster, showing a progress bar and 
ensuring the program is virus-free


the brothersoft downloader's privacy policy link redirects here:

http://www.conduit.com/privacy/conduitpoweredapplication

so, it's quite possible that some conduit's trash would be bundled. so, that 
may be not cnet to blame but the particular program's developer who chose to 
make fundrising through conduit-sponsored distribution.

as for managing downloads, i used to be happy with download master, or there is 
a program 'free download manager' and thousands more. however, today, with an 
acceptable-quality internet connection, i'm quite satisfied with my browser's 
built-in download manager.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Cannot open Apache OpenOffice 4.0.0

[johnny smith]

On Sat, 22 Mar 2014 15:13:56 -, happilyma...@netzero.net 
 wrote:


Suddenly, I can no longer open OpenOffice 4.0.0. Every time I try, I get the 
following error message:
-
soffice.bin - Application Error
The application failed to initialize properly (0xc005). Click on OK 
to terminate the application.
-


look for soffice.bin or soffice.exe in the task manager's list of processes. 
one of them may be running after exit due to some error. if so, terminate it 
and try launching openoffice again.

also, the thread here:

http://www.tomshardware.co.uk/forum/281698-45-application-failed-initialize-properly-0xc005

blames windows' data execution prevention for a similar error. you may try 
disabling it under system properties in control panel.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Can not remove background image

[johnny smith]

On Sat, 22 Mar 2014 16:09:05 -, Wade Smart  wrote:


On Sat, Mar 22, 2014 at 10:57 AM, Wade Smart  wrote:



Navigator is grayed out - can not be selected.


that's unusual behaviour. i've never encountered it.


I started clicking around in cells and found a cell that
allowed Navigator to be selected. Is this locked to cells?


after all, have you managed to change the background image?

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Cannot get Java to work in Open Office Base

[johnny smith]

On Sat, 22 Mar 2014 16:37:15 -, Elizabeth Robinson  
wrote:


I have Open Office version 4.0.1. I have Java 7.0.510.13 including JRE file 
javaw.exe sitting at C:/Program Files/Java/jre7/bin. I am using the Windows XP 
operating system.
 When I try to create a form with the Wizard, it tells me there is no JRE and to add 
one by going to Tools>Options>Java. When I try to add javaw.exe from this 
window, the system says there is no JRE in the folder selected (...Java/jre7/bin). Of 
course, there is a JRE file there!


java 7 requires visual c++ redistributable 2010, which is not bundled with it, 
however. check if you have it installed. also, the right path seems to be jre7, 
not jre7/bin.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Cannot get Java to work in Open Office Base

[johnny smith]

On Sat, 22 Mar 2014 16:37:15 -, Elizabeth Robinson  
wrote:


I am totally stumped. Went to the OpenOffice forum and saw some totally 
confusing explanation about 32-bit versus 64-bit.
 Please give me plain-English step-by-step instructions on (1) how to determine what 
"bit" I have and how to change whatever setting so that Java will run in Base.


how many bits you have should be listed under start -> control panel -> system.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Warning: [Was Re: How Do I Get Rid of Searchconduit?

[johnny smith]

On Sat, 22 Mar 2014 17:57:05 -, Doug  wrote:


i suppose the point may be that the target file is downloaded not
directly but with the help of a small 'download manager' file that you
are to download first. i avoid downloading through such managers.

I strongly dislike the so-called "installers" also, but if you really
want or need the program, how do you get it without?


usually it exists somewhere installer-free, or at least analogue of it. one 
notable example was adobe flashplayer, whose download manager just refused to 
download it (i think, that was because i had turned off task scheduler). first 
time, it was a quest to find a direct download link on adobe's site. by today, 
they have made things a bit simpler, the links are listed on the help page.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: How can you create floating fields in a Base report

[johnny smith]

On Sat, 22 Mar 2014 18:22:55 -, Jennifer E Jones  
wrote:


I have created a Base report but some of my fields contain less data and need 
to shrink left or up to create a consistent look to the report without a lot of 
white space.


on the 6th step of report creation, 'create report', choose 'modify report 
layout' and shrink or expand the columns as you wish.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Cannot get Java to work in Open Office Base

[johnny smith]

On Sat, 22 Mar 2014 19:05:07 -, Andrea Pescetti  wrote:


Aren't we already doing better, by bundling ... the Visual C++
redistributable ... with OpenOffice for Windows?


in 3.4 times, only c++ 2008 was bundled, and now 2010 too?

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: users Digest 23 Mar 2014 15:23:08 -0000 Issue 493

[johnny smith]

On Sun, 23 Mar 2014 18:46:17 -, Jennifer E Jones  
wrote:


When I tried the wizard, I never got options to make something that looks like 
what I want for output so I got an  extension to create a report in design view 
so I could get nice looking labels.  I am trying to make an address book that 
lets me ptint labels based off of a designated query. I have made the entry 
form and query which work fine and then started on the report.  It executes the 
query properly except there is no option for modifying report layout. I was 
hopeful that shrink would work, but this seems to do nothing.

I also now can't get it to put the output into columns (no options that I can 
find).  Here is a screenshot of it in edit view.   I am very frustrated by what 
should be an easy thing to do...  Jennifer


sad to say that your screenshot is filtered by the mailing list. please share 
it through some file sharing service.

as for modifying report layout, there are 6 steps in the wizard, and the 6th 
one provides an option not to create report immediately but to finish the 
wizard and format the table manually through a writer-like interface. so, i 
can't catch what the problem is; maybe you should expain more clearly.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: printing problem

[johnny smith]

On Sun, 23 Mar 2014 21:53:05 -, skyking @sisna.com  
wrote:


I am using a Dell laptop using Windows XP professional with a Lexmark Z645
printer.

The printer works ok with Microsoft Wordpad, but not with Apache.


if it also works ok with adobe reader or any other pdf reader, then you may 
export your file as pdf and print that pdf. for example, sumatrapdf reader, a 
standalone application few megabytes in size, prints through a native windows 
interface, identical to that of notepad and wordpad. hopefully, it would work 
with your printer.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: headers

[johnny smith]

On Mon, 24 Mar 2014 17:37:42 -, Albert Brown  wrote:


Hi, I am trying to add a header to a page but there is no button for
inserts , how do I add a header please. Iam using windows 8.


format -> page -> header -> header on.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: excel extensions

[johnny smith]

On Mon, 24 Mar 2014 18:00:22 -, Peter Scholten  wrote:


I have been unable to find direction on how to get a OO spreadsheet to
behave like or save as an MS Excel spreadsheet.  Can you help with that?


what's wrong with file -> save as -> microsoft excel 97/2000/xp (.xls)?

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Request for Help

[johnny smith]

On Mon, 24 Mar 2014 19:43:50 -, Doo Jung Jin  wrote:


I have received a file with an extension of "HWP" (Hangul Word
Processor-generated file) but cannot open and read it.  Would you help me
find a way how to do it?


later versions of hwp format are not openoffice-compatible. this programme from 
microsoft may be of use:

http://www.microsoft.com/en-us/download/details.aspx?id=36772

it is intended primarily to work side-by-side with ms word. however, pay 
attention to point 4 under install instructions. it seems to allow conversion 
without having ms word installed.

the site online.thinkfree.com may provide you with free online editing and 
translation. it is from hancom, the developer of hangul office. however, online 
editing may pose your security at risk, so judge carefully.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: autocorrect import

[johnny smith]

On Tue, 25 Mar 2014 16:56:57 -, Robert Kingett  wrote:


I was just wondering if there's a simple way I can import my autocorrect
entries from Microsoft word into open office, as I have cerebral palsy
and I use autocorrect as an adaptive tool and I don’t want to enter all
of the entries again.


all your autocorrect entries are contained in the files acor_.dat, acor_en-GB.dat, 
acor_zx-HK.dat etc, the path to which is listed under tools -> options -> 
openoffice.org -> paths. those files are indeed zip archives, so you can change their 
extension to .zip and browse their contents. in such an archive, find the file 
DocumentList.xml and open it as a text file. you will see your autocorrect entries for 
the respective language in xml format. if you have a list of all your autocorrect 
entries for ms word, you may add them all simultaneously using find-and-replace 
facilities of openoffice writer or ms notepad.

as for obtaining the mentioned list of ms word's autocorrect entries, see word's 
options -> paths to know where word stores them. unfortunately, i don't have 
word at hand now and thus can't give further advice. i can check word's storage 
style tomorrow at work and write back with more details.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: 4.1 beta feedback

[johnny smith]

On Tue, 25 Mar 2014 17:39:52 -, Larry Sadler  wrote:


So far, I am happy with the beta . I do have an issue with graphing in
Calc .

Via significant experimentation, I have established the following with
respect to charting a desired independent variable series:

  * the default is linear numerical from 1
  * to replace the default independent variable, you must format chart
using the category dialogue
  * this process is NOT obvious
  * my expectation was that the first data series would default to the
independent variable and be displayed as the X axis
  * the import would differentiate between numerical and text entries


i can't say for the beta, but 3.4.1 allows me to tick the 'first column as 
label' checkbox on the 2nd screen of the chart wizard.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: autocorrect import

[johnny smith]

On Tue, 25 Mar 2014 19:49:28 -, Robert Kingett  wrote:


is it possible to do a teamviewer session? LOL I haveexported my
autocorrect entries in word so perhaps that would help smeone. still
can't get the copoy and replacething happening!


i'm not familiar with teamviewer, so it would take some time to install and 
hold a session. but if you have exported your autocorrect entries, you may send 
me the list and i will convert it to openoffice's format.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: 3.4

[johnny smith]

On Wed, 26 Mar 2014 14:50:44 -, phill alcock  wrote:


can I install 3.4 but also keep my version 4.1 too?


please refer to this wiki page:

https://wiki.openoffice.org/wiki/Run_OOo_versions_parallel

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: autocorrect import

[johnny smith]

after all, robert's problem was solved. he sent me the list of autocorrect 
entries exported from word, which was in the following format:

Name
Value
RTF
soemthing
something
False
wrod
word
False

and so on, with line breaks as carriage returns and with some entries like

:|
:|
True
:(
:(
True

which reduced to something useless during export.

to transfer this file to openoffice format, i performed the following 
find-and-replace operations with regular expressions enabled:

replace $ with ~ (took some five minutes without showing progress bar, so i had 
to be patient)
replace ([^~]*~[^~]*~)(True|False)~ with $1\n
replace ([^~]*)~([^~]*)~ with 

and then added


http://openoffice.org/2001/block-list";>

to the beginning and



to the end of the file.

then i saved the file as utf-8-encoded text, called it 'DocumentList.xml' and 
added it to 'acor_.dat' (opened as a zip archive), replacing the old file with 
the same name. after that, all autocorrect entries started working fine.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Cannot find En Version of OpenOffice on website

[johnny smith]

On Sun, 30 Mar 2014 11:33:11 -, Alexander Ivarsson 
 wrote:


Hej,I have visited your site to download apache openoffice but you dont present 
the option of downloading the english version for people living outside of a 
english speaking country. As soon as i click the various download links on your 
site it directs me to a danish version with no option of downloading the 
english one. That is very frustrating for me and im sure other like me who have 
english as their 1st language.Alexander


see the page , which is accessible 
from the main page www.openoffice.org by clicking download -> get all platforms, 
languages, language packs. also, you may opt for setting your browser's preferred 
language to english if it is your mother tongue.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: 4.1 Writer list of r latst opened file

[johnny smith]

On Sun, 30 Mar 2014 14:53:30 -, Claus Thøgersen  wrote:


This may not be a bug, but when I open .doc files in Writer they do not show up 
in the list of  lats opened files in the file menu. Only the odt documents I 
have used  show up in the list.
Is this  the intended behavior?


no, this is not.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: saving as doesn't let me see destination options

[johnny smith]

On Tue, 01 Apr 2014 13:37:23 -, Joan E. Penzenstadler  
wrote:


In open office writer, I try to save a new document; I can type in the name of the 
document, but in the destination space I can no longer get a choice of destinations.  It 
only offers "documents" but clicking on that doesn't give me the sub-levels any 
more.  Same when I try Save As.  This just started recently and I'm going crazy trying to 
find a way to get that document into the right folder.

Did I hit something somewhere?

Also, in my Documents page, when I was trying to move a document there into an 
existing folder by dragging it, it knocked that folder into another folder and 
now I have a hell of a time finding where it went.
How can I find it without having to open every folder in Documents?

 The problem seems to be with my hellaciously oversensitive touch pad that 
keeps opening up everything it crosses or even gets near.  I am 76 and 
sometimes have an unsteady hand.


please specify your operating system. open/save dialogues are usually 
system-specific, not application-specific.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Printing text Doc

[johnny smith]

On Wed, 02 Apr 2014 00:06:25 -,  wrote:


Hi. I have Windows 8.1 and having trouble printing a whole document in Open 
Office. Although I’ve set my printer settings to ‘fit the page’ the printed 
document is missing some information on the left side. I’m a mature lady and 
only use Open Office occasionally’ but find this frustrating


as a temporary workaround, you can export your document to pdf and print it 
from a pdf reader. adobe reader, for example, has its own 'fit the page' 
feature, which might be more portable than windows' native one.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: trouble with page numbers

[johnny smith]

On Wed, 02 Apr 2014 18:00:43 -, William Nelson  
wrote:


I have a number of text documents with page numbers entered into the header by means of "Insert" and 
"Fields." Today for some reason I find all the page numbers (numerals) have been replaced by the words 
"Page numbers." When I try to reinsert the page number field, I again get the words "Page numbers." 
Please advise. My computer man has no idea what is going on. I will be most grateful.


most probably, you have accidentally pressed ctrl+f9. press it once more or 
directly uncheck view -> field names.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: download

[johnny smith]

On Wed, 02 Apr 2014 19:15:17 -, Mark Johnson  
wrote:


 Hi! i have Open office 3.4.1 is there a updated version? If so can i select 
refresh on program to update or do i need to download newest version?


the latest stable version is 4.0.1. the latest testing version is 4.1.0 beta. 
you can find them at http://www.openoffice.org/download/index.html, 
http://www.openoffice.org/download/other.html or 
http://www.openoffice.org/download/all_beta.html. a package should be 
downloaded in full, about 140 megs. (personally, i am quite happy with 3.4.1.)

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Impossibility to open documents

[johnny smith]

On Thu, 03 Apr 2014 19:16:39 -, Christelle  
wrote:


I have noticed that it's impossible to open registered documents. And this is 
not the first time. What's the problem ?Rgrds


please give more info. what do 'registered documents' mean? how is it 
impossible to open them (by double clicking, dragging, through the open 
dialogue etc.)? what message does openoffice give to inform you that opening is 
impossible? is anything opened after all (e.g. a mess of symbols, or strings of 
squares, or nothing at all)? please be more specific. as of now, nothing is 
clear.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Getting rid of error message

[johnny smith]

On Tue, 08 Apr 2014 18:42:25 -, Gotfred Johan Sunde  
wrote:


A session on OO Calc was (apparently) not closed properly and the next time I 
tried to start the program all I got was an error message telling me of the 
falty closing. The error message gave me two options: DON´T  CLOSE and REOPEN. 
By choosing REOPEN the program froze and it was (and is) impossible to get rid 
of the error message window. Any suggestions?


On recent versions of Mac OS X it might happen, especially after a "Force quit", that the following error message appears: 
"Restore Windows - The application OpenOffice.org was forced to quit while trying to restore its windows. Do you want to try to 
restore its windows again?". If you cannot get rid of it: Option-click the "Go" menu; choose "Library" from the 
menu to open the folder in the Finder; click on the folder "Saved Application State"; delete the file 
"org.openoffice.script.savedState".

for more info please read this forum topic: 
https://forum.openoffice.org/en/forum/viewtopic.php?t=43095

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Question about downloading Apache Open Office

[johnny smith]

On Fri, 11 Apr 2014 03:29:57 -, Laura Fister  wrote:


I currently have Open Office 3.0 on my computer.  Do I need to first remove
it from my computer and then download Apache Open Office, or do I leave my
the 3.0 version on my computer and just download Apache?


upgrading may be preferred over deleting and clean installation if you have a 
highly customised product, e.g. with fine-tuned shortcuts, autocorrect lists, 
spellcheck dictionaries, bibliography databases etc.

however, 3.0 is a rather old, oracle's rather than apache's, version. for this 
reason, such a major upgrade can cause issues, so you should weigh pros and 
contras. it may be of use to make a backup of your user profile (see release 
notes for 3.4.1, section 'known issues', at 
http://www.openoffice.org/development/releases/3.4.1.html for more details; 
notes for 4.0.0 and 4.0.1 may also be of use, they can be found at 
http://www.openoffice.org/development/releases/index.html).

clean installation may be a good choice if you have used only standard settings 
with the previous version - in this case you have nothing to lose.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: password

[johnny smith]

On Sat, 12 Apr 2014 14:58:27 -, Linda Fairbairn  
wrote:


 I would like to reset my account password, but can't seem to find a log-in 
link. Please send me a password reset link. Thank you.


what account are you talking about? openoffice users need not register anywhere 
since the project moved from oracle to apache.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: feedback requests

[johnny smith]

On Tue, 15 Apr 2014 07:44:13 -, Allen Schaaf 
 wrote:


I get a lot of documents that have multiple end of paragraph
elements and I have never figured out how to find and replace 3
(or whatever) with 1 to clean up scanned documents and documents
that were deliberately double spaced with EOPs rather than simply
setting the leading.


the problem is that the find-and-replace function has its vision limited to 
only one paragraph if regular expressions are enabled, and if they are not, 
then there is no way to enter the end-of-line character into the 'search for' 
box. however, you can merge all your text into one paragraph to lift this 
limitation.

just enter '$' to the 'search for' box and '\n' (or something equally 
square to mark line breaks) to the 'replace with' box, then perform in turn the 
'replace all' and 'find all' operations and hit the 'delete' key on your 
keyboard (prepare to wait a couple of minutes here if the document is long 
enough; you will not see any progress bar, so the program will confusingly seem 
freezed). after that, the find-and-replace's field of vision is no more limited 
to one paragraph (well, it is still limited, but that paragraph now contains 
all the text), so you may replace three consecutive  marks with one and 
then replace them back with '\n'.

another way is to install the altsearch extension:

http://extensions.openoffice.org/en/project/alternative-dialog-find-replace-writer-altsearch

one of its features is that searched or replaced text can contain one or more 
paragraphs. however, i have never tried it.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Found a bug within OpenOffice Calc

[johnny smith]

On Tue, 15 Apr 2014 12:36:32 -, Thomas  wrote:


I usually make up mailing form within Openoffice Calc.
But it doesnt allow me to type email hyperlink adresses withdet letters
Å,Ä,Ö
Since thoose letters are allowed in email adresses this can cause a small
problem.


i think that it really does allow. just right-click in the 'receiver' field and 
choose 'special character' from the context menu. however, i expect a properly 
localised operating system to provide some easier means to enter those 
characters.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Background color

[johnny smith]

On Tue, 15 Apr 2014 13:54:35 -, Texicon  wrote:


Hello, to whom it may concern, I am wondering if there is a way to have the 
background permanently change when I click on a cell that has color.  This 
would then allow me to move to another cell and fill it with that color.


the 'format paintbrush' tool on the standard toolbar seems to be what you look 
for. just select the cell from which you want to copy background, double-click 
the 'format paintbrush' button and start selecting cells or cell ranges to 
which you want to copy background colour; press escape when done.

if you have no format paintbrush on the standard toolbar, then go to 'tools -> 
customise -> toolbars', choose 'standard' from the 'toolbar' drop-down list and 
place a tick against the format paintbrush in the 'commands' list. if it is already 
checked but nevertheless doesn't appear on the toolbar, then click on a thin button 
with a downward-pointing triangle on the right of the toolbar; hopefully, you will 
find the paintbrush in the drop-down list that appears.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: feedback requests

[johnny smith]

On Tue, 15 Apr 2014 17:32:29 -, Allen Schaaf 
 wrote:


Thanks for the tip! Just so I'm clear, I would search for ^$^$^$
for three EOLs and replace them with a single ^$, correct?


no, search with regular expressions is limited to one paragraph, so you can use 
only one ^ and one $ in your query. also, in the 'replace with' field the $ 
character has a meaning different from that in the 'search for' field and the ^ 
character has no special meaning at all. look for 'regular expressions' in 
openoffice help for more information.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Issue with OpenOffice 4.1.0 Beta

[johnny smith]

On Tue, 15 Apr 2014 21:34:03 -, Kyle Bradley  wrote:


I just installed the 4.1.0 on my new laptop and found that I could not get
the program to launch. Is it not available for 64 bit windows yet?


it's not available as a native 64-bit application but runs smoothly in 
x86-compatibility mode, which, as far as i know, is supported in windows 
whithout any express action from the user's side. so, we need more details to 
provide you with help: your windows' version, the way in which you try to 
invoke the program (double-clicking on a document, on the .exe file etc.), an 
error message that you see (if any) and so on.

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org