Re: Numbers automatically advance in spreadsheet columns

[Jean Lear]

As a regular user of Calc in Apache OpenOffice I have added two extra items
to my tool bar (another learning curve to do this).  I have added 'Fill
Down' and 'Fill Series'
Fill Series will bring up the Fill Series window which allows a lot  of
alternatives for what is being done in the column or row selected.
Fill down is also useful to repeat text down a number of rows.
Hope this extra information helps.
Jean

On Tue, Apr 28, 2020 at 4:27 AM Peter Kovacs  wrote:

> 1) Mark the Cell
>
> 2) Right Klick -> select copy
>
> 3) select first Cell of your row. (i.e. the cell below)
>
> 4) Press shift And mark the last cell -> you now see the rows that you
> target marked.
>
> 5) right click select copy.
>
>
> Am 27.04.20 um 19:08 schrieb David Deeks:
> > I have been an Open Office user for many years, but only recently
> discovered this group, and have already learned a couple of things!
> >
> > I am hoping however that someone can help with a specific and
> longstanding problem with numbers in spreadsheet columns. If I have a cell
> with a number in that I want repeated down the column, I would love to able
> to simply highlight the cell and drag down the column. The problem is that
> in each line the numbers always increase by 1. This is useful of course
> sometimes, but not always! I have tried all formats, including text etc,
> and feel as though I’ve looked through every menu - but cannot find how to
> stop it doing this. I am sure there must be a way?
> >
> > Thanks
> >
> > David Deeks
> > -
> > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> > For additional commands, e-mail: users-h...@openoffice.apache.org
> >
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Adobe OO for Linux...?

[Alan B]

Hello Martin,

I haven't installed the RPM package. However on the Apache OpenOffice
website I found these instructions for RPM install.
https://www.openoffice.org/download/common/instructions.html#linux-rpm

Seems you need to:
navigate to the directory the RPMs were extracted to
su to root
issue the command rpm -Uvih *rpm
there's a few other steps for shell integration

Been a while since I installed my DEB version but, if I recall correctly,
it was the same process. Extract, use a wildcard to indicate all DEBs,
*deb. That install is working just fine.

On Mon, Apr 27, 2020 at 1:47 PM Martin Rosenfeld 
wrote:

> Thanks for the suggestions as to where to download Apache OpenOffice
> X_64 for Linux Mageia (RPM version). I got a GZ file which I unzipped
> into a folder that contained a gazillion rpm files. I don't know what to
> do next. Should I ask this on a Mageia forum?
>
> Martin
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Numbers automatically advance in spreadsheet columns

[Peter Kovacs]

1) Mark the Cell

2) Right Klick -> select copy

3) select first Cell of your row. (i.e. the cell below)

4) Press shift And mark the last cell -> you now see the rows that you 
target marked.


5) right click select copy.


Am 27.04.20 um 19:08 schrieb David Deeks:

I have been an Open Office user for many years, but only recently discovered 
this group, and have already learned a couple of things!

I am hoping however that someone can help with a specific and longstanding 
problem with numbers in spreadsheet columns. If I have a cell with a number in 
that I want repeated down the column, I would love to able to simply highlight 
the cell and drag down the column. The problem is that in each line the numbers 
always increase by 1. This is useful of course sometimes, but not always! I 
have tried all formats, including text etc, and feel as though I’ve looked 
through every menu - but cannot find how to stop it doing this. I am sure there 
must be a way?

Thanks

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



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

Re: Adobe OO for Linux...?

[David Belina]

Thanks for the suggestions as to where to download Apache 
OpenOffice 
X_64 for Linux Mageia (RPM version). I got a GZ file which I unzipped 
into a folder that contained a gazillion rpm files. I don't know what to 
do next. Should I ask this on a Mageia forum?

Martin

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

Re: Adobe OO for Linux...?

[Martin Rosenfeld]

Thanks for the suggestions as to where to download Apache OpenOffice 
X_64 for Linux Mageia (RPM version). I got a GZ file which I unzipped 
into a folder that contained a gazillion rpm files. I don't know what to 
do next. Should I ask this on a Mageia forum?


Martin

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

Re: Numbers automatically advance in spreadsheet columns

[David Deeks]

Brian, Alan

Thanks so much for your very prompt replies - problem solved!

Well pleased I discovered the group!

All best

David

> On 27 Apr 2020, at 18:25, Brian Barker  
> wrote:
> 
> At 18:08 27/04/2020 +0100, David Deeks wrote:
>> I have been an Open Office user for many years, but only recently discovered 
>> this group, and have already learned a couple of things!
> 
> Only two?
> 
> ;^)
> 
>> I am hoping however that someone can help with a specific and longstanding 
>> problem with numbers in spreadsheet columns. If I have a cell with a number 
>> in that I want repeated down the column, I would love to able to simply 
>> highlight the cell and drag down the column. The problem is that in each 
>> line the numbers always increase by 1. This is useful of course sometimes, 
>> but not always!
> 
> There are various ways to do this.
> 
> o (As someone has already said) Use Ctrl+fill instead of normal fill.
> 
> o Enter the same number again in the cell immediately below the original. 
> Select both cells. (Drag over them or use click and Shift+click). Now fill 
> down as usual.
> 
> o Select the entire range you want filled - including your original cell. Go 
> to Edit | Fill > | Down.
> 
> o For more complex requirements, select the entire range and use Edit | Fill 
> > | Series... .
> 
> I trust this helps.
> 
> Brian Barker
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 


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

Re: Numbers automatically advance in spreadsheet columns

[WA.TWORSX via AOL]

TNX Alan:

I had experienced same as David did; now I know that I must hold Ctrl 
key to repeat the number while dragging the mouse pointer.


Regards, and please ALL, stay safe.

VinceB.

On 4/27/2020 1:13 PM, Alan B wrote:

Hello David,

Have you tried,
- select cell
- grab cell handle at bottom right with mouse left click and hold
- press and hold Ctrl key
- drag mouse

That will produce a column that repeats the number in the highlighted cell.

On Mon, Apr 27, 2020 at 1:08 PM David Deeks 
wrote:


I have been an Open Office user for many years, but only recently
discovered this group, and have already learned a couple of things!

I am hoping however that someone can help with a specific and longstanding
problem with numbers in spreadsheet columns. If I have a cell with a number
in that I want repeated down the column, I would love to able to simply
highlight the cell and drag down the column. The problem is that in each
line the numbers always increase by 1. This is useful of course sometimes,
but not always! I have tried all formats, including text etc, and feel as
though I’ve looked through every menu - but cannot find how to stop it
doing this. I am sure there must be a way?

Thanks

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

Re: Numbers automatically advance in spreadsheet columns

[Brian Barker]

At 18:08 27/04/2020 +0100, David Deeks wrote:
I have been an Open Office user for many years, but only recently 
discovered this group, and have already learned a couple of things!


Only two?

;^)

I am hoping however that someone can help with a specific and 
longstanding problem with numbers in spreadsheet columns. If I have 
a cell with a number in that I want repeated down the column, I 
would love to able to simply highlight the cell and drag down the 
column. The problem is that in each line the numbers always increase 
by 1. This is useful of course sometimes, but not always!


There are various ways to do this.

o (As someone has already said) Use Ctrl+fill instead of normal fill.

o Enter the same number again in the cell immediately below the 
original. Select both cells. (Drag over them or use click and 
Shift+click). Now fill down as usual.


o Select the entire range you want filled - including your original 
cell. Go to Edit | Fill > | Down.


o For more complex requirements, select the entire range and use Edit 
| Fill > | Series... .


I trust this helps.

Brian Barker


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

Re: Numbers automatically advance in spreadsheet columns

[Alan B]

Hello David,

Have you tried,
- select cell
- grab cell handle at bottom right with mouse left click and hold
- press and hold Ctrl key
- drag mouse

That will produce a column that repeats the number in the highlighted cell.

On Mon, Apr 27, 2020 at 1:08 PM David Deeks 
wrote:

> I have been an Open Office user for many years, but only recently
> discovered this group, and have already learned a couple of things!
>
> I am hoping however that someone can help with a specific and longstanding
> problem with numbers in spreadsheet columns. If I have a cell with a number
> in that I want repeated down the column, I would love to able to simply
> highlight the cell and drag down the column. The problem is that in each
> line the numbers always increase by 1. This is useful of course sometimes,
> but not always! I have tried all formats, including text etc, and feel as
> though I’ve looked through every menu - but cannot find how to stop it
> doing this. I am sure there must be a way?
>
> Thanks
>
> David Deeks
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Numbers automatically advance in spreadsheet columns

[David Deeks]

I have been an Open Office user for many years, but only recently discovered 
this group, and have already learned a couple of things!

I am hoping however that someone can help with a specific and longstanding 
problem with numbers in spreadsheet columns. If I have a cell with a number in 
that I want repeated down the column, I would love to able to simply highlight 
the cell and drag down the column. The problem is that in each line the numbers 
always increase by 1. This is useful of course sometimes, but not always! I 
have tried all formats, including text etc, and feel as though I’ve looked 
through every menu - but cannot find how to stop it doing this. I am sure there 
must be a way?

Thanks

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

WG: Ihre Eingabe / Präsentation/ Animation

[nordsee0909]

Sehr geehrte Damen und Herren,

ich habe eine Zahlenreihe von 1 bis 75 erstellt, die ich auf „Klick“ animieren 
möchte. Den entsprechenden Zahlen habe ich ihren Platz zugeordnet. Die Zahlen 
(Animation) sollen auf anklicken, in unterschiedlicher Reihenfolge ausgeführt 
werden.

Bei der Überprüfung der Präsentation musste feststellen, dass die Zahlen 
nacheinander in der Reihenfolge von 1 (aufsteigend) beginnend erscheinen, egal 
welche ich als erste ausgewählt habe.

 

Wie kann ich einstellen, dass z.B. die angeklickte 8 als 1. Zahl, die 15 als 
2., die 37 als 3. usw. erscheint / animiert wird.

Ich ein Bild von der zu erstellende Folie als Anhang mit übermittelt.

Mit freundlichen Grüßen

W. SCHATTAT > nordsee0...@aol.com  (Mail-Adresse)

 

 
Hallo,
ich bin ein Moderator der Mailingliste :dev...@openoffice.apache.org.
Ihre Eingabe entspricht nicht dem Themenkreis, für den dieses Listeeingerichtet 
worden ist.
Bitte richten Sie Ihre Eingabe an users-de@openoffice.apache.org .
Mit freundlichem GrüßenMichael Stehmann






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

Re: doc vs docx

[Peter Kovacs]

On the development list, we discuss modern MS Office Formats from time 
to time. And we have multiple Ideas on how we could improve the issue.


But currently the Discussions are maybe more a bundle of Ideas then a 
real plan. I believe this topic will get more attention after we have 
finally managed to release 4.2.0.


This my personal personal position and is not an aligned development list.


This does not help you much, but maybe it is nice to have some 
impressions from the dev perspective.



Am 27.04.20 um 02:02 schrieb pat hanford:

A company wants me to submit an article in docx form. I can not save an article 
in docx only doc. Is there an update?

Sent from Mail for Windows 10




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

Re: doc vs docx

[Davy Elias -davyintermedi...@gmail.com]

Hi,

you can use online converter --
https://document.online-convert.com/convert-to-docx

-

On Mon, Apr 27, 2020 at 2:34 PM pat hanford  wrote:

> A company wants me to submit an article in docx form. I can not save an
> article in docx only doc. Is there an update?
>
> Sent from Mail for
> Windows 10
>
>

doc vs docx

[pat hanford]

A company wants me to submit an article in docx form. I can not save an article 
in docx only doc. Is there an update?

Sent from Mail for Windows 10

Re: download

[allan menachem]

thank you

Allan Menachem, M.D.


From: BMCS 
Sent: Sunday, April 26, 2020 1:39 PM
To: users@openoffice.apache.org 
Subject: Re: download

On 26/04/2020 18:14, Allan Menachem wrote:
> i have iMac catalina os operating system but cant install office.org..would 
> appreciate help or suggestions

Might it be that you are encountering the macOS GateKeeper message?
See Q05 and A05 here:
https://forum.openoffice.org/en/forum/viewtopic.php?f=74=89283=420635=Mac+FAQ#p420635
Also on the Apple website: https://support.apple.com/en-ie/HT202491
--
Please address any reply to users@openoffice.apache.org only.
Messages sent to my personal email address will not be answered.




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