color of recorded changes

2012-12-09 Thread Gary Aitken
How does one determine / change the color used when recording changes to a writer document? I'm working with a .docx from ms word, which I will export as a .odt. When I turn on Edit/Changes/Record the color used (there are no others in the document) is a very difficult to see light

Re: Fwd: Undelivered Mail Returned to Sender

2012-12-10 Thread Gary Aitken
On 12/10/12 03:47, Martin Groenescheij wrote: I send the reply to your email address because the reply to users@openoffice.apache.org bounced. users@openoffice.apache.org: host mx1.eu.apache.org[192.87.106.230] said: 552 spam score (5.7) exceeded threshold

Re: My machine is French but I want OpenOffice in English. Why do you chose for me, why can't I select what I want? eom

2013-02-04 Thread Gary Aitken
On 02/04/13 13:40, Hagar Delest wrote: Le 04/02/2013 21:15, Gary Aitken a écrit : Is there a reason one can't have one version with multiple languages on a machine, so one user can use, for example, Spanish, another French, and a third English? Is the i18n stuff not configured at runtime

Re: line break in multi-line input box

2013-08-15 Thread Gary Aitken
the same as the un-modulated enter, going to the next record. On 08/15/2013 02:16 PM, Gary Aitken wrote: Can anyone tell me how to insert a line break in a multi-line input form? In this case it's a front end for a database, and the field is a blob in a mysql db. Under ms access it was ctrlenter

scripts in AOO spreadsheets interpreted by MS excel?

2013-09-01 Thread Gary Aitken
It's my understanding the AOO document format for writer is a recognized standard; and I know they are readable by ms word. Is this also the case for the spreadsheet (calc) documents? Are they readable by MS excel? If so, are scripts (Java) also generally properly interpreted by MS excel?

Re: scripts in AOO spreadsheets interpreted by MS excel?

2013-09-01 Thread Gary Aitken
On 09/01/13 09:56, Regina Henschel wrote: snip Is this also the case for the spreadsheet (calc) documents? Are they readable by MS excel? It depends on the version of Microsoft Office. They started lately to support ODF in Excel. Before MS 2007 you need a plugin. For MS 2007 itself I'm

Re: scripts in AOO spreadsheets interpreted by MS excel?

2013-09-03 Thread Gary Aitken
On 09/01/13 22:57, Andrew Douglas Pitonyak wrote: On 09/01/2013 11:23 AM, Gary Aitken wrote: Is this also the case for the spreadsheet (calc) documents? Are they readable by MS excel? If so, are scripts (Java) also generally properly interpreted by MS excel? I was not aware that you could

Re: sending resume using open office

2014-01-10 Thread Gary Aitken
On 01/10/14 04:13, e-letter wrote: On 10/01/2014, users-digest-h...@openoffice.apache.org users-digest-h...@openoffice.apache.org wrote: jcish...@suddenlink.net wrote: To whom it may concern, My name is John, I have been using open office for some time now and fine it as good or better than

duplex pages upside down

2014-01-25 Thread Gary Aitken
I'm not sure what caused this, as I haven't printed any duplex pages for a while, but now the back side of double-sided pages is printing upside down. The printer is an hp officejet pro 8500. I'm on a freebsd (*nix) system, using gutenprint/cups as the print driver. If I look at the page

Re: duplex pages upside down

2014-01-25 Thread Gary Aitken
Gary Aitken I'm not sure what caused this, as I haven't printed any duplex pages for a while, but now the back side of double-sided pages is printing upside down. The printer is an hp officejet pro 8500. I'm on a freebsd (*nix) system, using gutenprint/cups as the print driver. If I

Re: Recent documents

2014-01-25 Thread Gary Aitken
On 01/25/14 19:02, Julian Thomas wrote: On 25 Jan 2014, at 16:52, Dave Barton d...@tasit.net wrote: Yes, it can be done manually by editing some configuration files, but it is much easier and convenient to use one of the available extensions. My own preference is the History Master

Re: duplex pages upside down

2014-01-26 Thread Gary Aitken
On 01/26/14 06:00, Regina Henschel wrote: Gary Aitken schrieb: On 01/25/14 15:59, Maurice Howe wrote: When you use short edge is there an apply tab or anything like that? No. It's a dropdown, so it shows up once the menu is clicked; then an OK to dismiss the whole dialog, then a Print

Re: duplex pages upside down

2014-01-26 Thread Gary Aitken
On 01/26/14 16:36, Regina Henschel wrote: Hi Gary, Gary Aitken schrieb: On 01/26/14 06:00, Regina Henschel wrote: Gary Aitken schrieb: On 01/25/14 15:59, Maurice Howe wrote: When you use short edge is there an apply tab or anything like that? No. It's a dropdown, so it shows up once

Re: calc reference relative to named range

2015-02-16 Thread Gary Aitken
Feb 2015 08:35:34 +0100 schreef Brian Barker b.m.bar...@btinternet.com: At 22:20 15/02/2015 -0700, Gary Aitken wrote: I can't find how to do this in the docs; not even sure it's possible but seems like it should be. Assume column A is named foo (select column, insert/name/define). In column B I

Re: calc reference relative to named range

2015-02-16 Thread Gary Aitken
On 02/16/15 00:35, Brian Barker wrote: At 22:20 15/02/2015 -0700, Gary Aitken wrote: I can't find how to do this in the docs; not even sure it's possible but seems like it should be. Assume column A is named foo (select column, insert/name/define). In column B I can use the corresponding

calc reference relative to named range

2015-02-15 Thread Gary Aitken
Hi all, I can't find how to do this in the docs; not even sure it's possible but seems like it should be. Assume column A is named foo (select column, insert/name/define) In column B I can use the corresponding element in the same row in A in a formula by using its name, e.g. =foo*3 Is there

After Safe and restart, Editing Calc Chart loses data

2015-08-23 Thread Gary Aitken
Running aoo 4.1.1 on fbsd If I create a chart in calc, as long as I do not exit calc I can edit the chart. In addition, if the values on which the chart is based change, the chart changes. However, if I save the spreadsheet and exit calc, then run calc again and open the spreadsheet, things are

Re: After Save and restart, Editing Calc Chart loses data

2015-08-25 Thread Gary Aitken
Hi Brian, Thanks for the reply. Anyone, please give me a sanity check on this one. On 08/25/15 02:03, Brian Barker wrote: You don't seem to have had any replies to this message. At 13:15 23/08/2015 -0600, you wrote: If I create a chart in calc, as long as I do not exit calc I can edit the

Re: After Save and restart, Editing Calc Chart loses data

2015-08-25 Thread Gary Aitken
On 08/25/15 20:48, Brian Barker wrote: At 07:56 25/08/2015 -0600, Gary Aitken wrote: At 13:15 23/08/2015 -0600, Gary Aitken wrote: If I create a chart in calc, as long as I do not exit calc I can edit the chart. In addition, if the values on which the chart is based change, the chart changes

Re: After Save and restart, Editing Calc Chart loses data

2015-08-25 Thread Gary Aitken
On 08/25/15 11:05, Joe Conner wrote: With my Ubuntu64 I open the file, and if I choose the graph and attempt to reposition it the data disappears. This too is odd. Thanks Joe. My sys is fbsd amd 64 so that's two different ones. I just filed a bug, 126490 On 08/25/2015 06:56 AM, Gary Aitken

Re: location of icons

2016-10-11 Thread Gary Aitken
. I set the desktop files in > /opt/openoffice4/share/xdg/ to +x to resolve this. Misusing the > executable flags for trustworthyness is an xfce4 kluge, but that is > the way it is. hmm. mine are 444 and I don't get anything. Running xfce 4.12 Thanks again! > On 10/11/2016 12:16 PM

Re: location of icons

2016-10-11 Thread Gary Aitken
nfig path for the xfce4 icon chooser is? Thanks > Le 11/10/2016 à 20:31, Gary Aitken a écrit : >> Hi all, >> >> I just upgraded my os from fbsd-9.2 to 10.3 and installed aoo 4.1.2. >> The installation appears to have gone well, but when I start up my desktop >> (

location of icons

2016-10-11 Thread Gary Aitken
Hi all, I just upgraded my os from fbsd-9.2 to 10.3 and installed aoo 4.1.2. The installation appears to have gone well, but when I start up my desktop (xfce4) the launchers with shortcuts to aoo are missing the icons. My /usr/local/applications/openoffice-4.1.2/*.desktop files have entries in

Re: location of icons

2016-10-11 Thread Gary Aitken
hing in the settings manager and don't see an icon chooser, although I may have not included it if it's optional in the xfce4 install process. I'll keep poking around. Thanks > As a workaround, you can create a custom desktop entry in your > ~/.local/share/applications folder. Then put the fu

Re: what is the jre environment looking for?

2016-10-15 Thread Gary Aitken
On 10/15/16 18:14, Girvin R. Herr wrote: > > > On 10/15/2016 12:38 PM, Gary Aitken wrote: >> On 10/15/16 13:15, Gary Aitken wrote: >> >>> After re-installing my os (freebsd 10.3), aoo (4.1.2), mysql >>> (5.6), and java (openjdk7, 8) when I attempt t

Re: what is the jre environment looking for?

2016-10-15 Thread Gary Aitken
On 10/15/16 13:15, Gary Aitken wrote: > After re-installing my os (freebsd 10.3), aoo (4.1.2), mysql (5.6), > and java (openjdk7, 8) when I attempt to open a database I get the > message > "No Java installation found..." > ok... > > The > Tools/Opti

what is the jre environment looking for?

2016-10-15 Thread Gary Aitken
Hi all, First, thanks for all the helpful advice I've gotten on this list over the years. After re-installing my os (freebsd 10.3), aoo (4.1.2), mysql (5.6), and java (openjdk7, 8) when I attempt to open a database I get the message "No Java installation found..." ok... The

need sample xml file for input to writer

2017-04-05 Thread Gary Aitken
Hi all, I need to generate an odt file with text and links to image files. I've looked briefly at the 700+ page spec but am trying to save myself a lot of time as I need to produce the output asap for some volunteer work I'm doing, so... Can anyone provide me with a bare-bones XML file that

selectively modifiable text document?

2017-04-17 Thread Gary Aitken
Hi all, Is it possible to make a text document (odt) read-only with selectively modifiable regions? I'm looking for an alternative to modifiable pdfs. Thanks, Gary - To unsubscribe, e-mail:

Re: Auto Correct question

2017-05-27 Thread Gary Aitken
On 05/27/17 18:11, Kimberly Wise wrote: HelloI am working on a spreadsheet that needs to have certainwording. Specifically I am trying to put in the phrase RTsCarswithout the hyphen but with the capitalization. Every time I put it in the T becomes lowercase. I need it tobe uppercase. Is there a

Re: calc array expression using result of min fn

2018-08-15 Thread Gary Aitken
On 08/14/18 11:24, Oliver Brinzing wrote: have you tried something like this: {=SUM(IF(B2:B10<=C2:C10;1;0))} Unfortunately, that won't work in my case; or rather, that's what I was trying to avoid. My example was a simplification; the actual need is for something like MIN(B2:B10 ; C2:C10 ;

calc array expression using result of min fn

2018-08-14 Thread Gary Aitken
I'm having trouble getting an array expression to work in calc. What I want is this: { COUNT( (MIN(B2:B10; C2:C10) = B2:B10) ) } That is, count the number of rows in which the minimum across columns B and C is in column B. The expression MIN(B3; C3) = B3 works fine when entered in an