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 ;
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 indivi
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 w
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: users-unsubscr...@openoffice.apache
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 c
On 10/16/16 17:46, Edwin Irving wrote:
> I want to have columns I set as currency to assume the last two
> digits should be behind a decimal point. For example, if I input
> 1257, I automatically want a decimal inserted between the the 2 and 5
> to read $12.57. Presently, I have to insert a decima
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 to op
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/Options
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
Tools/Options/Op
. 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:
everything 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/application
ere the config 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
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 the
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 cha
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
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
>> ed
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
On 08/11/15 11:30, Ingrid W wrote:
> Hello,
>
> I am creating documents using a template. Each worksheet I add, I insert
> using "insert sheet from file". That sheet is a template that I did not
> create. I am creating an inventory and each sheet is a list of what is in
> that numbered box.
>
> T
On 07/28/15 23:20, Brian Barker wrote:
> At 21:09 28/07/2015 -0600, Gary Aitken wrote:
>> I recently did an upgrade from a development version of 4.1.1 to a
>> production version (AOO411m6(Build:9775)). I don't know what the
>> build was for the development version;
Hi Fred,
On 07/28/15 21:53, FC wrote:
> Attention: Alan.
>
> Since you were so helpful to me in helping to solve the
> extra blank page printed on my one-page spreadsheet perhaps
> you have a suggestion on another one.
> I have three linked spreadsheets, A, B, and C, of ten pages
> each
I recently did an upgrade from a development version of 4.1.1 to a production
version (AOO411m6(Build:9775)). I don't know what the build was for the
development version; it was quite some time ago, maybe 6 months.
In any case, when I go to open a spreadsheet (.ods) or a text file (.odt),
I get t
Running freebsd
I had previously upgraded from 3.x to 4.1.x some time ago;
since then modified a few things in my profile, I think.
In any case, I recently upgraded from 4.1.1_4 to 4.1.1_9.
When I first started oo, I got the dialog asking about transferring
3.x user data to 4.x
Since I was running
what a formula actually means.
> Op Mon, 16 Feb 2015 08:35:34 +0100 schreef Brian Barker
> :
>
>> 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. Assum
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/n
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 ther
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
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 u
On 01/25/14 19:02, Julian Thomas wrote:
>
> On 25 Jan 2014, at 16:52, Dave Barton 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" extension:
can figure out what's wrong with it.
> On Sat, 25 Jan 2014 14:48:38 -0700 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.
>
On 01/25/14 15:15, Rory O'Farrell wrote:
> Gary Aitken wrote:
>
>> 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
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 preview,
On 01/10/14 04:13, e-letter wrote:
> On 10/01/2014, 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
windows office. I h
On 09/07/13 08:43, Doug wrote:
> On 09/07/2013 09:20 AM, Joost Andrae wrote:
>> Hi Doug,
>>
>> I've an idea what happened to you: Maybe reducing the complexity of
>> graphical objects on the printed output may help you.
>> Go to menu item /tools/options/OpenOffice/printing
>> and activate both che
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?
>
On 09/01/13 09:56, Regina Henschel wrote:
>> 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
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?
Than
the un-modulated ,
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
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 ,
but that is bound to moving to the next record.
Thanks,
Gary
--
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?
>
On 02/04/13 12:06, Rory O'Farrell wrote:
> On Mon, 4 Feb 2013 11:52:30 -0600
> Christian Joffrain wrote:
>
>> My machine is French but I want OpenOffice in English. Why do you chose for
>> me, why can't I select what I want?
>
> Pick the version you require from
> http://www.openoffice.org/dow
(resend to get the subject right, sorry for the duplication)
Thank you!
That helps a lot, and I can modify the wrapping options to work for this
document.
However, I am puzzled because of the following:
>> 1. If Frame3 is moved to the right so there is whitespace between it and
>> Frame4,
>>
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.
> : host mx1.eu.apache.org[192.87.106.230] said:
> 552
> spam score (5.7) exceeded threshold (HTML_MESSAGE,MIME_HTML_ONLY,SPF_PASS
> (in repl
the text to fill in the space below Frame9 and between Frame11
and Frame8. It will fill in to the left of Frame5, and to the right of
Frame6, but not the rest.
Any ideas what's going on in questions #4 and #5 below?
Thanks!
> On 12/10/2012 1:03 AM, Gary Aitken wrote:
>> Hi all,
>
Hi all,
I've attached an odt file derived from something I was working on that is
driving
me nuts as far as text flow is concerned. I don't understand how anchoring
affects text flow, or why in some cases text does not fill up a hole on the
page.
If someone can point me to a detailed explanat
On 12/09/12 16:58, tj wrote:
> On 12/9/2012 18:45, Gary Aitken wrote:
>> 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
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 tan/yellow.
On 12/04/12 02:36, Martin Groenescheij wrote:
>
> On 4/12/2012 5:56 PM, Gary Aitken wrote:
>> On 12/03/12 23:46, Martin Groenescheij wrote:
>>> On 4/12/2012 5:36 PM, Gary Aitken wrote:
>>>> On 12/03/12 18:39, James Plante wrote:
>>>>
>>>
On 12/03/12 23:46, Martin Groenescheij wrote:
>
> On 4/12/2012 5:36 PM, Gary Aitken wrote:
>> On 12/03/12 18:39, James Plante wrote:
>>
>>> One of the reasons I *don't* use master docs is because
>>> of the extra work needed to cross-reference variou
On 12/03/12 18:39, James Plante wrote:
> One of the reasons I *don't* use master docs is because
> of the extra work needed to cross-reference various parts of a report, e.g.,
> on page 24, see cost analysis in Appendix C, page 98. (And page 98 keeps
> incrementing as your document grows; it fina
49 matches
Mail list logo