spellheck again Re: PROBLEM SOLVED Re: problem remains Re: [Issue 127728] SPELLCHECK/DICTIONARY NOT WORKING AFTER UPDATE INSTALL to 4.1.5

[Chris Addington]

good morning

i have just set up new laptop & installed openoffice & copying wordbook 
& template files as below


i have noticed that whilst using a template document that spellcheck 
worked ok, but when i used a 'new' document (top left of toolbar) then 
spellcheck does not work


-> 


regardschris

Chris Addington Pr.Eng.

On 10/03/2018 14:24, Chris Addington wrote:


1. file manager, address bar; (select): /app data/roaming/open 
office/4 -> rename user.old.


2. start openoff

3. fm user.old - copy 'wordbook', 'template'; paste into new user 
folder. if you copy all the folders you wind up with same problem, but 
this way you keep your dictionary, templates.


can also get techs to find out by elimination which folder is causing 
problem.


but, this does not alleviate responsibility to WARN people attempting 
to download


sincerely

Chris Addington Pr.Eng.
On 10/03/2018 13:50, Chris Addington wrote:


hi andrea

i tried that - doesn't work (but not sure what is meant by 
'quickstarter', what is it? where is it? close it? how?)


the point is that the bug was KNOWN - had a WARNING been given i 
would NOT have installed - and i would not now be 3 days behind on work.


*i appreciate you are volunteers - i am a volunteer also (in other 
areas) - i do NOT get paid - BUT, BUT, BUT - volunteers still have a 
responsibility to inform correctly - oxfam etc. ignore their 
responsibilities.*


what do i do?

sincerely

Chris Addington Pr.Eng.
On 10/03/2018 13:07, Andrea Pescetti wrote:

Dear Chris,
this is not an OpenOffice bug, but a Windows bug. Do as advised at
https://s.apache.org/g4NG
and it will be fixed.

You can now understand why we strongly prefer to use the standard 
support channels: answers are archived and available to all future 
similar cases. We are all volunteers and personal support is 
unsustainable.


You have been referred multiple times to the public channels. I will 
be unable to continue answering private mails due to time 
constraints, but I'm confident that the procedure above will fix 
your issue.


Regards,
  Andrea.

Il 10/03/2018 12:12, Chris Addington ha scritto:

hi andrea

the other key point is that *it is was KNOWN that there was this 
bug - yet there was NO WARNING given against downloading & 
installing 4.1.5 *- i had purposefully delayed installing 4.1.5 for 
some weeks just to avoid/minimise another install-headache.



but, NO WARNING !


sincerelychris

Chris Addington Pr.Eng.

On 09/03/2018 11:39, Chris Addington wrote:

hi andrea, bugzilla

- i received the mail below saying 'resolved' - downloaded & 
installed 4.1.5 again - PROBLEM REMAINS


you also won't explain 'user profile' - where do i change this - 
the forum simply references 'user profile' but doesn't say where 
to find this.





Chris Addington Pr.Eng.

On 09/03/2018 10:37, bugzi...@apache.org wrote:

https://bz.apache.org/ooo/show_bug.cgi?id=127728

oooforum (fr)  changed:

    What    |Removed |Added
 


  Status|RESOLVED    |CLOSED

Re: PROBLEM SOLVED Re: problem remains Re: [Issue 127728] SPELLCHECK/DICTIONARY NOT WORKING AFTER UPDATE INSTALL to 4.1.5

[Martin Groenescheij]

On 11/03/18 5:17 AM, JD wrote:

A better solution:
do not create a an OpenOffice user profile. PERIOD.
It is totally useless for the correct operation of OO.



And where are user settings stored when there is no user profile?



On 03/10/2018 11:05 AM, Andrea Pescetti wrote:

Maurice Howe wrote:
This guy makes it indelibly clear why users are sometimes encouraged 
to try


I concur this is an example of a user that, while he managed to solve 
it in the end, is quite problematic, noisy, and won't follow any 
advice longer than one line (even though he succeeded when he finally 
tried). And our solution is easy but not super-easy.


I see three ways (two requiring OpenOffice development) to solve this:

1. An OpenOfficeProfileFixer.exe (so to say; I'm note referring to 
something that exists) file that simply renames the user profile 
under Windows. This will cover the large majority of the clueless 
users. This can exist as a separate tool, hosted by an OpenOffice 
committer is his personal space at apache.org.


2. An option to "start clean" at install time, that renames a 
possibly existing OpenOffice profile.


3. A Tools - Reset default settings menu item that renames the 
profile at the next restart of OpenOffice.


There is nothing to fix in the OpenOffice code. Profile corruption 
happens due to many factors, but it is not linked to OpenOffice in a 
clear way: it involves user profiles that are carried over from 
OpenOffice 2.x or 3.x and may already be damaged but working.


So in the end one of the three options above is the best mitigation.

Regards,
  Andrea.

-
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





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

Re: PROBLEM SOLVED Re: problem remains Re: [Issue 127728] SPELLCHECK/DICTIONARY NOT WORKING AFTER UPDATE INSTALL to 4.1.5

[JD]

A better solution:
do not create a an OpenOffice user profile. PERIOD.
It is totally useless for the correct operation of OO.


On 03/10/2018 11:05 AM, Andrea Pescetti wrote:

Maurice Howe wrote:
This guy makes it indelibly clear why users are sometimes encouraged 
to try


I concur this is an example of a user that, while he managed to solve 
it in the end, is quite problematic, noisy, and won't follow any 
advice longer than one line (even though he succeeded when he finally 
tried). And our solution is easy but not super-easy.


I see three ways (two requiring OpenOffice development) to solve this:

1. An OpenOfficeProfileFixer.exe (so to say; I'm note referring to 
something that exists) file that simply renames the user profile under 
Windows. This will cover the large majority of the clueless users. 
This can exist as a separate tool, hosted by an OpenOffice committer 
is his personal space at apache.org.


2. An option to "start clean" at install time, that renames a possibly 
existing OpenOffice profile.


3. A Tools - Reset default settings menu item that renames the profile 
at the next restart of OpenOffice.


There is nothing to fix in the OpenOffice code. Profile corruption 
happens due to many factors, but it is not linked to OpenOffice in a 
clear way: it involves user profiles that are carried over from 
OpenOffice 2.x or 3.x and may already be damaged but working.


So in the end one of the three options above is the best mitigation.

Regards,
  Andrea.

-
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: PROBLEM SOLVED Re: problem remains Re: [Issue 127728] SPELLCHECK/DICTIONARY NOT WORKING AFTER UPDATE INSTALL to 4.1.5

[Andrea Pescetti]

Maurice Howe wrote:

This guy makes it indelibly clear why users are sometimes encouraged to try


I concur this is an example of a user that, while he managed to solve it 
in the end, is quite problematic, noisy, and won't follow any advice 
longer than one line (even though he succeeded when he finally tried). 
And our solution is easy but not super-easy.


I see three ways (two requiring OpenOffice development) to solve this:

1. An OpenOfficeProfileFixer.exe (so to say; I'm note referring to 
something that exists) file that simply renames the user profile under 
Windows. This will cover the large majority of the clueless users. This 
can exist as a separate tool, hosted by an OpenOffice committer is his 
personal space at apache.org.


2. An option to "start clean" at install time, that renames a possibly 
existing OpenOffice profile.


3. A Tools - Reset default settings menu item that renames the profile 
at the next restart of OpenOffice.


There is nothing to fix in the OpenOffice code. Profile corruption 
happens due to many factors, but it is not linked to OpenOffice in a 
clear way: it involves user profiles that are carried over from 
OpenOffice 2.x or 3.x and may already be damaged but working.


So in the end one of the three options above is the best mitigation.

Regards,
  Andrea.

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

Re: PROBLEM SOLVED Re: problem remains Re: [Issue 127728] SPELLCHECK/DICTIONARY NOT WORKING AFTER UPDATE INSTALL to 4.1.5

[Maurice Howe]

This guy makes it indelibly clear why users are sometimes encouraged to try
LIBRE or ANYthing ​else.

On Sat, Mar 10, 2018 at 9:24 AM, Chris Addington  wrote:

> 1. file manager, address bar; (select): /app data/roaming/open
> office/4 -> rename user.old.
>
> 2. start openoff
>
> 3. fm user.old - copy 'wordbook', 'template'; paste into new user folder.
> if you copy all the folders you wind up with same problem, but this way you
> keep your dictionary, templates.
>
> can also get techs to find out by elimination which folder is causing
> problem.
>
> but, this does not alleviate responsibility to WARN people attempting to
> download
>
> sincerely
>
> Chris Addington Pr.Eng.
>
> On 10/03/2018 13:50, Chris Addington wrote:
>
>>
>> hi andrea
>>
>> i tried that - doesn't work (but not sure what is meant by
>> 'quickstarter', what is it? where is it? close it? how?)
>>
>> the point is that the bug was KNOWN - had a WARNING been given i would
>> NOT have installed - and i would not now be 3 days behind on work.
>>
>> *i appreciate you are volunteers - i am a volunteer also (in other areas)
>> - i do NOT get paid - BUT, BUT, BUT - volunteers still have a
>> responsibility to inform correctly - oxfam etc. ignore their
>> responsibilities.*
>>
>> what do i do?
>>
>> sincerely
>>
>> Chris Addington Pr.Eng.
>> On 10/03/2018 13:07, Andrea Pescetti wrote:
>>
>>> Dear Chris,
>>> this is not an OpenOffice bug, but a Windows bug. Do as advised at
>>> https://s.apache.org/g4NG
>>> and it will be fixed.
>>>
>>> You can now understand why we strongly prefer to use the standard
>>> support channels: answers are archived and available to all future similar
>>> cases. We are all volunteers and personal support is unsustainable.
>>>
>>> You have been referred multiple times to the public channels. I will be
>>> unable to continue answering private mails due to time constraints, but I'm
>>> confident that the procedure above will fix your issue.
>>>
>>> Regards,
>>>   Andrea.
>>>
>>> Il 10/03/2018 12:12, Chris Addington ha scritto:
>>>
 hi andrea

 the other key point is that *it is was KNOWN that there was this bug -
 yet there was NO WARNING given against downloading & installing 4.1.5 *- i
 had purposefully delayed installing 4.1.5 for some weeks just to
 avoid/minimise another install-headache.


 but, NO WARNING !


 sincerelychris

 Chris Addington Pr.Eng.

 On 09/03/2018 11:39, Chris Addington wrote:

> hi andrea, bugzilla
>
> - i received the mail below saying 'resolved' - downloaded & installed
> 4.1.5 again - PROBLEM REMAINS
>
> you also won't explain 'user profile' - where do i change this - the
> forum simply references 'user profile' but doesn't say where to find this.
>
> 
>
>
> Chris Addington Pr.Eng.
>
> On 09/03/2018 10:37, bugzi...@apache.org wrote:
>
>> https://bz.apache.org/ooo/show_bug.cgi?id=127728
>>
>> oooforum (fr)  changed:
>>
>> What|Removed |Added
>> 
>>
>>   Status|RESOLVED|CLOSED
>>
>>
>

>>>
>>
>

PROBLEM SOLVED Re: problem remains Re: [Issue 127728] SPELLCHECK/DICTIONARY NOT WORKING AFTER UPDATE INSTALL to 4.1.5

[Chris Addington]

1. file manager, address bar; (select): /app data/roaming/open 
office/4 -> rename user.old.


2. start openoff

3. fm user.old - copy 'wordbook', 'template'; paste into new user 
folder. if you copy all the folders you wind up with same problem, but 
this way you keep your dictionary, templates.


can also get techs to find out by elimination which folder is causing 
problem.


but, this does not alleviate responsibility to WARN people attempting to 
download


sincerely

Chris Addington Pr.Eng.

On 10/03/2018 13:50, Chris Addington wrote:


hi andrea

i tried that - doesn't work (but not sure what is meant by 
'quickstarter', what is it? where is it? close it? how?)


the point is that the bug was KNOWN - had a WARNING been given i would 
NOT have installed - and i would not now be 3 days behind on work.


*i appreciate you are volunteers - i am a volunteer also (in other 
areas) - i do NOT get paid - BUT, BUT, BUT - volunteers still have a 
responsibility to inform correctly - oxfam etc. ignore their 
responsibilities.*


what do i do?

sincerely

Chris Addington Pr.Eng.
On 10/03/2018 13:07, Andrea Pescetti wrote:

Dear Chris,
this is not an OpenOffice bug, but a Windows bug. Do as advised at
https://s.apache.org/g4NG
and it will be fixed.

You can now understand why we strongly prefer to use the standard 
support channels: answers are archived and available to all future 
similar cases. We are all volunteers and personal support is 
unsustainable.


You have been referred multiple times to the public channels. I will 
be unable to continue answering private mails due to time 
constraints, but I'm confident that the procedure above will fix your 
issue.


Regards,
  Andrea.

Il 10/03/2018 12:12, Chris Addington ha scritto:

hi andrea

the other key point is that *it is was KNOWN that there was this bug 
- yet there was NO WARNING given against downloading & installing 
4.1.5 *- i had purposefully delayed installing 4.1.5 for some weeks 
just to avoid/minimise another install-headache.



but, NO WARNING !


sincerelychris

Chris Addington Pr.Eng.

On 09/03/2018 11:39, Chris Addington wrote:

hi andrea, bugzilla

- i received the mail below saying 'resolved' - downloaded & 
installed 4.1.5 again - PROBLEM REMAINS


you also won't explain 'user profile' - where do i change this - 
the forum simply references 'user profile' but doesn't say where to 
find this.





Chris Addington Pr.Eng.

On 09/03/2018 10:37, bugzi...@apache.org wrote:

https://bz.apache.org/ooo/show_bug.cgi?id=127728

oooforum (fr)  changed:

What|Removed |Added
 


  Status|RESOLVED|CLOSED

Re: problem solved

[Heidi Lasher-Oakes]

Thanks!  It was really bugging me.  I got as far as downloading the md5sum
file, but was trying to compare it directly with the AOO file by listing
both filenames after the md5sum -c command.  Next time I'll try it your way.

On Sat, Jun 27, 2015 at 4:12 PM, James Knott  wrote:

> On 06/27/2015 12:44 PM, Heidi Lasher-Oakes wrote:
> > md5sum -c .tar.gz.md5
> >
>
> The -c option is used when you have a text file that contains the md5sum
> for one or more files.  Md5sum will read that file and check the file's
> md5 sum against the line in the text file.  If you look at the md5 on
> the server, it is in the form that could be pasted into a text file.
> This means you could download several files, paste the line into a text
> file and then run md5sum -c on the text file to verify all the files
> with one command.  Some servers, such as those used for Linux, often
> have an md5sum file, which you can download.
>
>

Re: problem solved

[James Knott]

On 06/27/2015 12:44 PM, Heidi Lasher-Oakes wrote:
> md5sum -c .tar.gz.md5
>

The -c option is used when you have a text file that contains the md5sum
for one or more files.  Md5sum will read that file and check the file's
md5 sum against the line in the text file.  If you look at the md5 on
the server, it is in the form that could be pasted into a text file. 
This means you could download several files, paste the line into a text
file and then run md5sum -c on the text file to verify all the files
with one command.  Some servers, such as those used for Linux, often
have an md5sum file, which you can download.


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

RE: problem solved

[Dennis E. Hamilton]

It is generally the case that the .md5 file needs to be in the same directory 
as the downloaded file(s), and you probably need to do the md5sum call with 
your console session being in that directory as the current directory.

Also, if there are spaces in the  part you need to put the whole 
thing in quotes.  I.e.,

 >md5sum -c ".tar.gz.md5"

This should be the exact name of the MD5 file.  That file will list the name of 
each file that it has an md5 checksum for.  This article provides a good 
explanation: <https://en.wikipedia.org/wiki/Md5sum>.  If you look at the md5 
file you will see that it names the file that it holds the hash for.  (It 
should have an "*" in front of that file name to indicate that it is a binary 
file, as the downloaded file is.

PS: I don't know what you downloaded as a .tar.gz.  That would usually be the 
source code, not an installer for an Apache OpenOffice binary installer 
(Windows) or package (OSX and Linux).  Please say more.

 - Dennis


-Original Message-
From: Heidi Lasher-Oakes [mailto:hlash...@gmail.com] 
Sent: Saturday, June 27, 2015 09:45
To: users@openoffice.apache.org
Subject: problem solved

Thanks to all who replied with suggestions last night.  It turned out that
my problem was related to the command

md5sum -c .tar.gz.md5

which is the specific md5sum command suggested on Apache's "How to verify
the download <http://www.openoffice.org/download/checksums.html>" page.  I
had never used this command before.
It was returning a specific error, "no properly formatted MD5 checksum
lines found".  After I posted my problem report, I ran this checksum
command instead

md5sum .tar.gz

I verified the checksum manually by comparing the result with the md5sum
provided on the download page.  After that, I installed the file
successfully.

After doing a little research, I found more detailed
<http://www.codejacked.com/using-md5sum-to-validate-the-integrity-of-downloaded-files/>
information
<http://www.cyberciti.biz/tips/howto-verify-integrity-of-the-tar-balls-with-md5sum-command.html>
about how to verify the md5sum using md5sum -c.  I still haven't managed to
get it to work.  I have an alternative, so that's okay, but I do wish I
understood.  Anyway, I thought someone else here might be interested in
having the info, so here it is.


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

problem solved

[Heidi Lasher-Oakes]

Thanks to all who replied with suggestions last night.  It turned out that
my problem was related to the command

md5sum -c .tar.gz.md5

which is the specific md5sum command suggested on Apache's "How to verify
the download " page.  I
had never used this command before.
It was returning a specific error, "no properly formatted MD5 checksum
lines found".  After I posted my problem report, I ran this checksum
command instead

md5sum .tar.gz

I verified the checksum manually by comparing the result with the md5sum
provided on the download page.  After that, I installed the file
successfully.

After doing a little research, I found more detailed

information

about how to verify the md5sum using md5sum -c.  I still haven't managed to
get it to work.  I have an alternative, so that's okay, but I do wish I
understood.  Anyway, I thought someone else here might be interested in
having the info, so here it is.

Re: SQL problem (SOLVED)

[John Meyer]

On 10/20/2013 1:14 PM, John Meyer wrote:

Semi-solved, I think.

I managed to join the following:

SELECT "AGENTS"."AGENT_ID", COUNT(*) AS "Total Sales" FROM "AGENTS" 
INNER JOIN "SALES" ON "AGENTS"."AGENT_ID"="SALES"."SALES_REP" GROUP BY 
"AGENTS"."AGENT_ID"


The only problem is I can't seem to add the agent's name.


I ended up solving the problem by breaking up the query into two 
subqueries: one to count the results and the other to join the 
information with the name.  It isn't the most elegant solution int he 
world, but it works!


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

Re: Indirect and Address problem (SOLVED)

[John Meyer]

haven't had my first cup of coffee.
On 10/3/2013 12:41 PM, Brian Barker wrote:

At 12:14 03/10/2013 -0600, John Meyer wrote:

Okay, so I just needed one more step with Brian's problem.


Er, I don't remember having a problem! ;^)

When I imported the date from the web site, it also had the time 
portion. So, I created another column and put a formula of 
QUOTIENT(B2;1) ...


INT(B2) might be easier.


... and formatted that as a date.


I'm not sure formatting will make any difference here.


Voila, it works.


Good-oh!

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: Indirect and Address problem (SOLVED)

[Brian Barker]

At 12:14 03/10/2013 -0600, John Meyer wrote:

Okay, so I just needed one more step with Brian's problem.


Er, I don't remember having a problem! ;^)

When I imported the date from the web site, it also had the time 
portion. So, I created another column and put a formula of QUOTIENT(B2;1) ...


INT(B2) might be easier.


... and formatted that as a date.


I'm not sure formatting will make any difference here.


Voila, it works.


Good-oh!

Brian Barker


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

Re: Indirect and Address problem (SOLVED)

[John Meyer]

Okay, so I just needed one more step with Brian's problem.  When I 
imported the date from the web site, it also had the time portion. So, I 
created another column and put a formula of QUOTIENT(B2;1) and formatted 
that as a date.  Voila, it works.


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