Windows 10 version 1903

[Sandy M]

Good afternoon

I have Apache Open Office on my Windows 10 pc. I need to update to Windows 10 
version 1903. I have you heard anything about the update wiping the open office 
out during the update?

Thank you

Sandy M.

Sent from my iPad

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

Re: Problem

[Rory O'Farrell]

On Sat, 18 Jan 2020 13:56:14 -0500
Ronald Horton  wrote:

> I have been having this problem with Open Office Writer for a while, and it 
> seems to be on your end because it is happening in two separate computers.  
> Whenever I go to type a text and I want to do a color change, it will not let 
> me do the change now.  It will only go into the paint bucket format which 
> appears on the screen even though I do the right things in the right places.  
> It seems that the paint bucket has taken over the place where you change text 
> color as well.  It will not let me change text color no matter what I do.  
> Surely you can fix this problem.  

For diagnostic information please try selecting some text, then use /Format 
/Character : Font effects tab, and change the Font colour by using the dropdown 
beside the current colour (probably "automatic").  Does the colour of the 
selected text change?  This will let us know if the colour selection mechanism 
is broken or not.

-- 
Rory O'Farrell 

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

Problem

[Ronald Horton]

I have been having this problem with Open Office Writer for a while, and it 
seems to be on your end because it is happening in two separate computers.  
Whenever I go to type a text and I want to do a color change, it will not let 
me do the change now.  It will only go into the paint bucket format which 
appears on the screen even though I do the right things in the right places.  
It seems that the paint bucket has taken over the place where you change text 
color as well.  It will not let me change text color no matter what I do.  
Surely you can fix this problem.  

Sent from Mail for Windows 10

Re: Calc Help

[Brian Barker]

At 11:55 18/01/2020 -0500, Vince Bonly wrote:
Note: Cells with a yellow background identify required data must be 
entered. Cells with a (darker) gray background identify cells which 
show calculated results.


I have a Calc sheet that I enter data on a regular basis, as shown below:

[D] [E] [F][G][H] < Column headings

*/_Today is Week #_/*   */_Today's Date Is_/*   */_Game 
#1_/*   */_Game #2 _/*  */_Game #3_/*   */_Match 
Series_/*  */_Match Average_/*

*1* 6-Sep   152 146 187 485 161.7
*2* 13-Sep  133 159 141 433 144.3
*3* 20-Sep  147 155 148 450 150.0
*4* 27-Sep  161 151 142 454 151.3
*5* 4-Oct   130 139 116 385 128.3
*6* 11-Oct  *Did Not Bowl. *
*7* 18-Oct  148 187 119 454 151.3
*8* 25-Oct  155 167 169 491 163.7
*9* 1-Nov   140 141 157 438 146.0
*10*8-Nov   147 135 155 437 145.7
*11*15-Nov  139 133 155 427 142.3
*12*22-Nov  164 162 164 490 163.3
*13*29-Nov  120 110 155 385 128.3
*14*6-Dec   150 136 125 411 137.0
*15*13-Dec  170 187 132 489 163.0
*16*20-Dec  160 168 146 474 158.0
*17*27-Dec  160 144 150 454 151.3
*18*3-Jan   151 141 138 430 143.3
*/_---Half Season---_/*
*19*10-Jan  *Did Not Bowl. *
*20*17-Jan  161 134 147 442 147.3
*21*24-Jan

I use the results generated in columns G and H in another section of 
the sheet, as shown:


[AL] [AN] < Column headings

*Team #2- ACHES & PAINS v2.0
Post Match Play*
*Russ: *458 *Player's Average: *152.67
*Vince: *   442 147.33
*Dave: *555 185.00
*Bob: * 600 200.00

Cells AL7 and AN7 are set to = the results calculated and provided 
within cells G26 and H26, i.e., they show: 442 and 147.3.


My problem is that after calculating an update result within columns 
G and H, e.g., on 24 Jan, (week # 21's data), the results based on 
entry of data in D27:F27, there will be new results in the next row, 
at cells G27 and H27. Therefore, I am forced to manually change the 
formulae within AL7 and AN7 to correctly reflect the updated results 
provided in columns AL and AN, by changing =G26 to =G27 and by 
changing =H26 to =H27.


Is there an easier method of handling this task, through use of a 
function or a formula?


I hope this is described clearly enough. If needed, I will attempt 
to store the complete calc sheet at a Dropbox link. Let me know.


On another mailing list to which I am subscribed - nothing to do with 
office suites - enquirers are expected to provide *minimal* examples, 
and that lesson could be learned here. Almost everything you've 
included in your message is irrelevant, and it is a matter of some 
work to try to guess what your underlying problem is. People are 
perhaps unlikely to want to carry out that work, especially if they 
cannot be guaranteed that their efforts will transpire to be 
relevant. That work of simplification should in all fairness fall, of 
course, to you. And there are no yellow or gray backgrounds showing 
in your message, so that's not relevant, I hope.


I think your problem reduces to finding a reference to the last 
member of a list in a column. Is that right?


One way to do something like this is to add a "sentinel" value at the 
end of the list in at least one of your columns. You need to choose 
some value that cannot otherwise appear in the headings or data. If 
you put, say, "X" in the first unused row of column A (you could 
choose any column), then

=MATCH("X";A1:A999;0)
will return the row number of the row containing the sentinel. Note 
that MATCH() returns the index within the range provided, so would 
not return the row number if you gave it a data range did not start 
in row 1. But as long as you choose a sentinel value that does not 
appear in your headings, you can start the range from row 1.


Now you need to harvest the values in the cells above the sentinel 
row in the relevant columns, and there are probably many ways to do 
this. Examples for the value in column G might be:

=OFFSET(G1;MATCH("X";A1:A999;0)-2;0)
or
=INDIRECT("G"("X";A1:A999;0)-1)

But I fear (and hope!) that someone may be able to provide a neater solution.

One other possibility is to reverse your original table, so that the 
most recent week is at the top. You would use Insert | Rows (or 
right-click | Insert Rows) to insert a new row for each new week. 
Then the row from which values need to be harvested does not change. 
Does that fit your needs?


Incidentally, it is not obvious what you want to appear in your 
second table if the current week has "Did Not Bowl." and appears to 
have no values in the relevant columns (G and H) of the first table. 
Do you 

Calc Help

[Vince@GMAIL]

AOO 4.1.5 on Win10 Home desktop

_

Note: Cells with a yellow background identify required data must be 
entered.  Cells with a (darker) gray background identify cells which 
show calculated results.


I have a Calc sheet that I enter data on a regular basis, as shown below:

[D] [E] [F]    [G]            [H] < Column headings

*/_Today is Week #_/* 	*/_Today's Date Is_/* 	*/_Game #1_/* 	*/_Game #2 
_/* 	*/_Game #3_/* 	*/_Match Series_/* 	*/_Match Average_/*

*1* 6-Sep   152 146 187 485 161.7
*2* 13-Sep  133 159 141 433 144.3
*3* 20-Sep  147 155 148 450 150.0
*4* 27-Sep  161 151 142 454 151.3
*5* 4-Oct   130 139 116 385 128.3
*6* 11-Oct  *Did Not Bowl. *
*7* 18-Oct  148 187 119 454 151.3
*8* 25-Oct  155 167 169 491 163.7
*9* 1-Nov   140 141 157 438 146.0
*10*8-Nov   147 135 155 437 145.7
*11*15-Nov  139 133 155 427 142.3
*12*22-Nov  164 162 164 490 163.3
*13*29-Nov  120 110 155 385 128.3
*14*6-Dec   150 136 125 411 137.0
*15*13-Dec  170 187 132 489 163.0
*16*20-Dec  160 168 146 474 158.0
*17*27-Dec  160 144 150 454 151.3
*18*3-Jan   151 141 138 430 143.3
*/_---Half Season---_/*
*19*10-Jan  *Did Not Bowl. *
*20*17-Jan  161 134 147 442 147.3
*21*24-Jan  





I use the results generated in columns G and H in another section of the 
sheet, as shown:


                    [AL] [AN] < Column headings

*Team #2- ACHES & PAINS v2.0
Post Match Play*
*Russ: *458 *Player's Average: *152.67
*Vince: *   442 147.33
*Dave: *555 185.00
*Bob: * 600 200.00


Cells AL7 and AN7 are set to = the results calculated and provided 
within cells G26 and H26, i.e., they show: 442 and 147.3.


My problem is that after calculating an update result within columns G 
and H, e.g., on 24 Jan, (week # 21's data), the results based on entry 
of data in D27:F27, there will be new results in the next row, at cells 
G27 and H27. Therefore, I am forced to manually change the formulae 
within AL7 and AN7 to correctly reflect the updated results provided in 
columns AL and AN, by changing =G26 to =G27 and by changing =H26 to =H27.


Is there an easier method of handling this task, through use of a 
function or a formula?


I hope this is described clearly enough.  If needed, I will attempt to 
store the complete calc sheet at a Dropbox link. Let me know.


Regards,

VinceB.

Calc Help

[WA.TWORSX via AOL]

AOO 4.1.5 on Win10 Home desktop

_

Note: Cells with a yellow background identify required data must be 
entered.  Cells with a (darker) gray background identify cells which 
show calculated results.


I have a Calc sheet that I enter data on a regular basis, as shown below:

[D] [E] [F]    [G]            [H] < Column headings

*/_Today is Week #_/* 	*/_Today's Date Is_/* 	*/_Game #1_/* 	*/_Game #2 
_/* 	*/_Game #3_/* 	*/_Match Series_/* 	*/_Match Average_/*

*1* 6-Sep   152 146 187 485 161.7
*2* 13-Sep  133 159 141 433 144.3
*3* 20-Sep  147 155 148 450 150.0
*4* 27-Sep  161 151 142 454 151.3
*5* 4-Oct   130 139 116 385 128.3
*6* 11-Oct  *Did Not Bowl. *
*7* 18-Oct  148 187 119 454 151.3
*8* 25-Oct  155 167 169 491 163.7
*9* 1-Nov   140 141 157 438 146.0
*10*8-Nov   147 135 155 437 145.7
*11*15-Nov  139 133 155 427 142.3
*12*22-Nov  164 162 164 490 163.3
*13*29-Nov  120 110 155 385 128.3
*14*6-Dec   150 136 125 411 137.0
*15*13-Dec  170 187 132 489 163.0
*16*20-Dec  160 168 146 474 158.0
*17*27-Dec  160 144 150 454 151.3
*18*3-Jan   151 141 138 430 143.3
*/_---Half Season---_/*
*19*10-Jan  *Did Not Bowl. *
*20*17-Jan  161 134 147 442 147.3
*21*24-Jan  





I use the results generated in columns G and H in another section of the 
sheet, as shown:


                    [AL] [AN] < Column headings

*Team #2- ACHES & PAINS v2.0
Post Match Play*
*Russ: *458 *Player's Average: *152.67
*Vince: *   442 147.33
*Dave: *555 185.00
*Bob: * 600 200.00


Cells AL7 and AN7 are set to = the results calculated and provided 
within cells G26 and H26, i.e., they show: 442 and 147.3.


My problem is that after calculating an update result within columns G 
and H, e.g., on 24 Jan, (week # 21's data), the results based on entry 
of data in D27:F27, there will be new results in the next row, at cells 
G27 and H27. Therefore, I am forced to manually change the formulae 
within AL7 and AN7 to correctly reflect the updated results provided in 
columns AL and AN, by changing =G26 to =G27 and by changing =H26 to =H27.


Is there an easier method of handling this task, through use of a 
function or a formula?


I hope this is described clearly enough.  If needed, I will attempt to 
store the complete calc sheet at a Dropbox link. Let me know.


Regards,

VinceB.

Re: American Spell Check problem

[Martin Groenescheij]

> On 18 Jan 2020, at 14:47, Chuck Spalding  wrote:
> 
> I, too, am not a regular Windows user, but I believe you're supposed to use
> forward slashes ("/") instead of back slashes ("\").

You’re correct for the first half of your statement.
For the second half you’re incorrect, under Windows use the back slash.

> 
> Chuck
> 
>> On Sat, Jan 18, 2020 at 3:34 AM Rory O'Farrell  wrote:
>> 
>> On Fri, 17 Jan 2020 17:20:35 -0500 (EST)
>> MICHAEL SHIELDS Owner  wrote:
>> 
>>> I hate to sound Illiterate, but am I supposed to enter the address with
>> percentage points as well. I assume the Windows explorer bar (address bar)
>> is at the top of the screen
>>> and not at the address bar a few inches under?  I hate when it comes to
>> computer terms, etc.
>> 
>> Enter exactly as I set it out.  Not having used Windows in any detail for
>> over ten years I cannot navigate around it for you, but if you click on the
>> icon of a disk drive, I think you should enter that line in the address
>> line of the Window that then opens.
>> 
>> Rory
>> 
>> 
>>> - Original Message -
> 
> [snip]
> 
>>> To fix this, rename your OpenOffice user profile.
>>> 
>>> As you are using Windows close OpenOffice and the Quickstarter.
>>> 
>>> Open File Explorer. Copy and paste %appdata%\OpenOffice\4 in the File
>> Explorer (sometimes called Windows Explorer) Address Bar and press Enter.
>>> 
>>> Rename the "user" folder - "user.old" is a good choice.
>>> 
>>> Now restart OpenOffice.
>>> 
>>> Start OpenOffice.--
>>> Rory O'Farrell 
>> [snip]
>> 


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

Re: OpenOffice - Shortcuts

[Dave]

Hallo Gabi,

gute Entscheidung.

Hier meine Einführung einschließlich Übungsteil. Wenn du die Übung machst,
erklärt sich alles von selbst:

http://openoffice-uni.org

Viel Erfolg
David Paenson

On Sat 18. Jan 2020 at 15:41, Gabi Zimmermann  wrote:

> Guten Tag,
>
> bin eben auf OpenOffice umgestiegen. Wie in all meinen anderen Programmen
> möchte ich mit Shortcuts arbeiten, natürlich mit denselben. Also will ich
> eigene festlegen.
> Auf Ihrer Seite
> https://www.openoffice.org/de/doc/oooauthors/writer/a-tastenkombinationen.pdf
> sind die bestehenden zwar aufgeführt, aber ich wüsste
> gern, in welchem Bereich sich welche Funktion befindet. Man sucht sich ja
> sonst dumm und dämlich!
>
> 2 Beispiele: Wo finde ich "speichern unter..." oder "Seite einrichten"?
> "Dokument schließen" scheint es gar nicht zu geben?
>
> Eine Übersicht ähnlich wie diese wäre super:
> http://www.alphazalpha.de/ms_office_befehle+shortcuts.pdf
>
> --
> Mit freundlichen Grüßen
>
> Gabi Zimmermann
> Rahnsdorfer Str. 47
> 15566 Schöneiche
>
> Tel. 030/66774231
> 0176/45807614
> www.alphazalpha.de
>
>
> -
> To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-de-h...@openoffice.apache.org
>
>

OpenOffice - Shortcuts

[Gabi Zimmermann]

Guten Tag,

bin eben auf OpenOffice umgestiegen. Wie in all meinen anderen Programmen möchte ich mit Shortcuts arbeiten, natürlich mit denselben. Also will ich 
eigene festlegen.
Auf Ihrer Seite https://www.openoffice.org/de/doc/oooauthors/writer/a-tastenkombinationen.pdf sind die bestehenden zwar aufgeführt, aber ich wüsste 
gern, in welchem Bereich sich welche Funktion befindet. Man sucht sich ja sonst dumm und dämlich!


2 Beispiele: Wo finde ich "speichern unter..." oder "Seite einrichten"? "Dokument 
schließen" scheint es gar nicht zu geben?

Eine Übersicht ähnlich wie diese wäre super: 
http://www.alphazalpha.de/ms_office_befehle+shortcuts.pdf

--
Mit freundlichen Grüßen

Gabi Zimmermann
Rahnsdorfer Str. 47
15566 Schöneiche

Tel. 030/66774231
0176/45807614
www.alphazalpha.de


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

Re: American Spell Check problem

[Chuck Spalding]

I, too, am not a regular Windows user, but I believe you're supposed to use
forward slashes ("/") instead of back slashes ("\").

Chuck

On Sat, Jan 18, 2020 at 3:34 AM Rory O'Farrell  wrote:

> On Fri, 17 Jan 2020 17:20:35 -0500 (EST)
> MICHAEL SHIELDS Owner  wrote:
>
> > I hate to sound Illiterate, but am I supposed to enter the address with
> percentage points as well. I assume the Windows explorer bar (address bar)
> is at the top of the screen
> >  and not at the address bar a few inches under?  I hate when it comes to
> computer terms, etc.
>
> Enter exactly as I set it out.  Not having used Windows in any detail for
> over ten years I cannot navigate around it for you, but if you click on the
> icon of a disk drive, I think you should enter that line in the address
> line of the Window that then opens.
>
> Rory
>
>
> > - Original Message -

[snip]

> > To fix this, rename your OpenOffice user profile.
> >
> > As you are using Windows close OpenOffice and the Quickstarter.
> >
> > Open File Explorer. Copy and paste %appdata%\OpenOffice\4 in the File
> Explorer (sometimes called Windows Explorer) Address Bar and press Enter.
> >
> > Rename the "user" folder - "user.old" is a good choice.
> >
> > Now restart OpenOffice.
> >
> > Start OpenOffice.--
> > Rory O'Farrell 
> [snip]
>

Re: Sharing Excel

[Sarah Staddon]

Hi

Thanks very much for your help.

I didn't explain myself very well. I do actually want to share and for us both 
to edit "live". I use something similar at work, with a colleague.  We both add 
figures each day for others to view. I didn't know how it was set up. I was 
sent a link and this open in my browser. 

Will have a go with OneDrive, or similar.

Fingers crossed!!

Sarah
On Saturday, 18 January 2020 Steven Ahlers  wrote:
Forwarding to OP. I was going to suggest the same thing.



Sent from my iPhone

> On Jan 17, 2020, at 8:15 PM, Alan B  wrote:
> 
> Sarah,
> 
> Another method, that would allow working on the spreadsheet without sending
> a copy back and forth and back again, would be to save it online and share
> it using a service like OneDrive, Google Drive, DropBox and others.
> 
> The idea is you both use the same file so if you edit at 3pm and your son
> at 4pm he sees your edits and vice versa without having to check email to
> see if an updated version of the file is in the inbox.
> 
> I offer this suggestion because you wrote "share a file" which I'm thinking
> means you both want to work with the same file so you can see each other's
> progress.
> 
> If that's not your goal then Wade's suggestion is certainly the simpler
> option.
> 
>> On Fri, Jan 17, 2020 at 4:28 PM Sarah Staddon 
>> wrote:
>> 
>> Hello
>> My son lives away and we are trying to share an excel spreadsheet to work
>> together on a diary fitness and dieting.
>> Can you please tell me how to do this?
>> Many thanks
>> Sarah Staddon
> 
> 
> 
> -- 
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011

Re: makro Funktion zum Laden von csv in eine Tabelle

[technik_...@jrsch.de]

Danke.


Am 10.01.2020 um 13:11 schrieb Bernd Obermayr:

Am 10.01.20 um 10:10 schrieb technik_...@jrsch.de:

Hallo,

gibt es eine interne Funktion, um eine CSV Datei in eine Tabelle einzufügen?

Ich habe mir ein Makro gebastelt, aber das dauert doch sehr lange.
Vielleicht gibt es was schnelleres?


MfG

Horst


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


Hi,
es gibt die Calc Tools von Thomas Krumbein, da ist sowas dabei.




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

Re: American Spell Check problem

[Rory O'Farrell]

On Fri, 17 Jan 2020 17:20:35 -0500 (EST)
MICHAEL SHIELDS Owner  wrote:

> I hate to sound Illiterate, but am I supposed to enter the address with 
> percentage points as well. I assume the Windows explorer bar (address bar) is 
> at the top of the screen
>  and not at the address bar a few inches under?  I hate when it comes to 
> computer terms, etc.

Enter exactly as I set it out.  Not having used Windows in any detail for over 
ten years I cannot navigate around it for you, but if you click on the icon of 
a disk drive, I think you should enter that line in the address line of the 
Window that then opens.

Rory


> - Original Message -
> From: "Rory O'Farrell" 
> To: "users" 
> Cc: "kingbman" 
> Sent: Friday, January 17, 2020 1:31:29 PM
> Subject: Re: American Spell Check problem
> 
> On Fri, 17 Jan 2020 14:57:02 -0500 (EST)
> MICHAEL SHIELDS Owner  wrote:
> 
> > My Windows 10 did an update, and may have disabled my Spell Check. I have 
> > been trying to enable Spell Check, but to no avail. Apparently, there is a 
> > notice that "Spell Check hasn't been updated" Is that the problem? 
> > Mike Shields 
> 
> 
> To fix this, rename your OpenOffice user profile.
> 
> As you are using Windows close OpenOffice and the Quickstarter.
> 
> Open File Explorer. Copy and paste %appdata%\OpenOffice\4 in the File 
> Explorer (sometimes called Windows Explorer) Address Bar and press Enter.
> 
> Rename the "user" folder - "user.old" is a good choice.
> 
> Now restart OpenOffice.
> 
> Start OpenOffice.-- 
> Rory O'Farrell 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 


-- 
Rory O'Farrell 

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