[libreoffice-users] Re: a little math problem with Calc

2012-07-07 Thread Andreas Säger

Am 07.07.2012 00:37, alex sato wrote:

Regina.

I'm writing this email just to say thank you again.

About the idea of rewriting math function using string. I may do it but
just for fun, not for a serious use.
;-)



Programming Basic is no fun. Never.

Function Test (n)
dim r(3)
r(0)=CINT(n)
r(1)=n-r(0)
r(2)=r(1)*100
r(3)=CINT(r(2))
Test = r
End Function




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] updated list of KPP English dictionaries for LO

2012-07-07 Thread webmaster-Kracked_P_P


I created a page for the KPP dictionaries, out of the NA-DVD folders.

http://libreoffice-na.us/KPP-dictionaries/dictionary.html

I have 3 updated dictionaries.

The British dictionary now go to 639,116, the Canadian goes to 639,112.

The American English one is now 773,407 words.

All three dictionaries now include missing words, including open source 
and FOSS terms.  The American English includes a lot more.


In a bit, I will be updating the Extension Center with the new versions 
of the dictionaries.  I have to decide how I am going to deal with the 
page[s] I have there first.


I will not be updating the smaller word lists though.

The new URL/page will, for now, list all of the KPP dictionaries, old 
and new.


The current 3.5.x NA-DVD dictionary page reflects the updates and will 
not include the 638K versions, since the 639K version are the updates 
for the British and Canadian dictionaries.




Next week, hopefully, 3.5.5 will be out and then I will create a 3.5.5 
version ISO file to upload to the servers for downloading.  That will be 
the one that will have the new dictionaries and the up-to-date 
documentation list.


Impress has a full set of chapters for 3.5.x.

Getting Started has Chapters 1-9 except 5 and 7 for 3.5.x.

Draw has Chapters 1-3 for 3.5.x.

I wish someone would help the documentation writers to get a set of 
chapters for BASE.  There has been no additions since January, and that 
was a draft file.





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Macro code to highlight a field on a Form

2012-07-07 Thread Marion Noel Lodge
Hi Andreas,

Thanks very much for pointing me to the .setSelection(aSelection) method.

I've experimented with it and I can get it to work sometimes but not
others.  (I think the problem lies within my Form.  I have macros that fire
when leaving certain fields and have the effect of moving the cursor
elsewhere from where I am trying to be!)

I'm away for the next week, so I have run out of time.  But I'm confident
that I'll now be able to sort it out when I return.

Regarding the MRI extension, I take it that it is similar to the XRay
extension.  Is it worth loading both?  They seem to do both similar and
different things.

Thanks again,

Noel
--
Marion  Noel Lodge
lodg...@gmail.com


On 2 July Andreas Säger ville...@t-online.de
viahttp://support.google.com/mail/bin/answer.py?hl=en-GBctx=mailanswer=1311182
 global.libreoffice.org wrote:
Hello,

All you need is the MRI extension.


 http://extensions.libreoffice.org/extension-center/mri-uno-object-inspection-tool


Within seconds it can point you to method


 http://www.openoffice.org/api/docs/common/ref/com/sun/star/awt/XTextComponent.html#setSelection


The .setSelection(aSelection) method takes a struct specifying the start
position and the end position of your text selection.

MRI also generates snippets like this while using it:

 Sub Snippet(Optional oInitialTarget As Object)
   Dim oSource As Object
   Dim aSelection As New com.sun.star.awt.Selection

   oSource = oInitialTarget.Source
   aSelection = oSource.getSelection()
 End Sub




[Tutorial] Introduction into object inspection with MRI

 http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=49294


Hope this helps,
A.S.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] what a year and a day makes

2012-07-07 Thread webmaster-Kracked_P_P


I was looking in my ISO folder and I realized that yesterday was an 
anniversary.


One year and one day ago, I created the first LibreOffice North 
American Community DVD .iso file.  That was for LO 3.3.3.


Today, I created an updated 3.5.4 .iso file for my use.  Next week will 
be 3.5.5.


One year of making and handing out NA-DVDs to the local community.  I do 
not know how many 100's of DVD I have made in that year's time.  I do 
not remember all the business, government offices, and individuals that 
I have given a copy of the DVDs to.


LibreOffice has grown a lot since then.  So has the NA-DVD. Much of the 
DVD has not changed much, except the theme, the extensions, templates, 
and other files that are listed in its pages.  Old version have been 
updated, if available.  New items added.  My, KPP English dictionaries 
were developed for LO [and OOo/AOO].  And other thing, good and bad, has 
happened during this past year that has changed the project and myself.


The LibreOffice project is coming up on its 2 year anniversary.  During 
that time, OOo has been dropped my Oracle and picked up by Apache and 
renamed AOO.


I started with LO back in its 3.3.0 beta days and dropped OOo then and 
there.  I started working on the idea of a DVD to hand out to friends, 
family, and business people I knew when LO went to 3.3.1.  Then that 
idea developed into the North American Community DVD Project.  Back 
then, the hope was to put out an English version, A Spanish version, and 
a French version.  Well, at least the English project went ahead.  I do 
not speak or read any other human language.  I can only deal with 
English [human] and programming languages [computer].


I hope that the next year will see a growth in the NA-DVD project and at 
least 10 times as many users using LibreOffice.


Let us all make the next year be a great year for LibreOffice and all of 
the regional projects for marketing and distribution of LO to their users.


Tim Lungstrom
Elmira, New York, USA
current developer and webmaster of the LO NA-DVD project
webmas...@libreoffice-na.us [project email]
webmas...@krackedpress.com [list email]



.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] what a year and a day makes

2012-07-07 Thread Tom Davies
Hi :)
+1
A good year on balance i hope :)  Seems to have been mostly positive.  Good 
work Tim and much appreciated.
Regards from
Tom :)  


--- On Sat, 7/7/12, webmaster-Kracked_P_P webmas...@krackedpress.com wrote:

From: webmaster-Kracked_P_P webmas...@krackedpress.com
Subject: [libreoffice-users] what a year and a day makes
To: LibreO - Users Global users@global.libreoffice.org
Date: Saturday, 7 July, 2012, 14:01


I was looking in my ISO folder and I realized that yesterday was an anniversary.

One year and one day ago, I created the first LibreOffice North American 
Community DVD .iso file.  That was for LO 3.3.3.

Today, I created an updated 3.5.4 .iso file for my use.  Next week will be 
3.5.5.

One year of making and handing out NA-DVDs to the local community.  I do not 
know how many 100's of DVD I have made in that year's time.  I do not remember 
all the business, government offices, and individuals that I have given a copy 
of the DVDs to.

LibreOffice has grown a lot since then.  So has the NA-DVD. Much of the DVD has 
not changed much, except the theme, the extensions, templates, and other files 
that are listed in its pages.  Old version have been updated, if available.  
New items added.  My, KPP English dictionaries were developed for LO [and 
OOo/AOO].  And other thing, good and bad, has happened during this past year 
that has changed the project and myself.

The LibreOffice project is coming up on its 2 year anniversary.  During that 
time, OOo has been dropped my Oracle and picked up by Apache and renamed AOO.

I started with LO back in its 3.3.0 beta days and dropped OOo then and there.  
I started working on the idea of a DVD to hand out to friends, family, and 
business people I knew when LO went to 3.3.1.  Then that idea developed into 
the North American Community DVD Project.  Back then, the hope was to put out 
an English version, A Spanish version, and a French version.  Well, at least 
the English project went ahead.  I do not speak or read any other human 
language.  I can only deal with English [human] and programming languages 
[computer].

I hope that the next year will see a growth in the NA-DVD project and at least 
10 times as many users using LibreOffice.

Let us all make the next year be a great year for LibreOffice and all of the 
regional projects for marketing and distribution of LO to their users.

Tim Lungstrom
Elmira, New York, USA
current developer and webmaster of the LO NA-DVD project
webmas...@libreoffice-na.us [project email]
webmas...@krackedpress.com [list email]



.


-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] Re: Macro code to highlight a field on a Form

2012-07-07 Thread Tom
Hi :)
There is an excellent guide on writing Macros 
https://wiki.documentfoundation.org/Documentation/Publications#Programmers
but getting personalised advice from an experienced expert such as Andreas
is even better.  

Still it can be useful to have a guide too.  
Regards from
Tom :)  


--
View this message in context: 
http://nabble.documentfoundation.org/Macro-code-to-highlight-a-field-on-a-Form-tp3993100p3994218.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?

2012-07-07 Thread Tom Davies
Hi :)
Nicely done :)

The subsequent link you gave was a link to the LO form to fill-in rather than 
to the specific bug-report you created.  Ideally it would be great to have a 
link to the specific bug report in the one posted to the other project, eg
In the MySql report a link given to the report submitted to LO  
In the LO report a link given to the MySql one.  

It helps if the devs can get their heads together more easily rather than just 
blaming the other project ;)  I'm not sure devs do that but most people would 
in similar circumstances.  
Regards from
Tom :)  


--- On Fri, 6/7/12, leeand00 leean...@gmail.com wrote:

From: leeand00 leean...@gmail.com
Subject: [libreoffice-users] Re: Invalid descriptor Index 07009 when using a 
query parameter?
To: users@global.libreoffice.org
Date: Friday, 6 July, 2012, 2:41

Okay for anyone who's interested I submitted the bug here:
http://bugs.mysql.com/bug.php?id=65832thanks=sub

Enjoy!

--
View this message in context: 
http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3993950.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Specialty Dictionaries

2012-07-07 Thread Tom Davies
Hi :)
It sounds like interesting and useful functionality that might well be worth 
adding if it hasn't been done already.  I think a lot of us here have been 
focussing on work-arounds to just get the job done.  But i think it might be 
a good idea to post a bug-report and make it a Feature request.
Regards from
Tom :)


--- On Fri, 6/7/12, Simon Cropper simoncrop...@fossworkflowguides.com wrote:

From: Simon Cropper simoncrop...@fossworkflowguides.com
Subject: Re: [libreoffice-users] Specialty Dictionaries
To: users@global.libreoffice.org
Date: Friday, 6 July, 2012, 1:19

On 06/07/12 05:26, nvrk wrote:
 On Thu, Jul 5, 2012 at 3:06 AM, Simon Cropper 
 simoncrop...@fossworkflowguides.com wrote:
 
 
 Yeah, I have thought of both these things. Have hacked a standard file
 before, particularly in MS Word. Easily done assuming it is a text file and
 not a binary file.
 
 The problem is the binomial. I also thought of the concatenation string
 but most of the single characters have been used for have special meanings
 in various word processors. Hyphens for example are used in LO as hyphens
 and so how would you know when removing the character at the end of your
 report is complete, what is a concatenation character and what is a real
 hyphen?
 
 In other situations I have used =!= as a joining string but as stated it
 is messy and hard to read.
 
 
 An underscore works well.
 

Yeap, but an underscore gets used a lot in technical reports (e.g. in a URL). 
If you do a global search and replace to remove the character at the end of 
writing so the report looks clean and well presented you neuter the URL or 
corrupt the other text string that uses it.

As an alternative to free form typing of jargon or technical terms then 
running a spell checker, terms could be inserted from a list. This works OK but 
in the absence of LO integration you can't flag the inserted text as 'hey this 
is jargon, I just inserted it from a secure source, don't bother spell 
checking'. This can be done but requires you to manually apply language 
characteristics to hundreds or thousands of names, or alternatively hit 
ignore the same number of times with the spell checker. :(

Ideally you need a blank concatenation character that is recognizing by LO as 
linking two words (such as a non-breaking space already available in LO but 
does not necessarily have to physically bind the words together but would need 
to be seen by the spell checker as a joining character) AND IS RECOGNIZED by 
the spell checker, substituted with something like an underscore and compared 
to the lists in the dic files which would appear as Eucalyptus_vulgaris. I 
just need someone in the know to be able to insert this functionality and these 
problems would be solved.

-- Cheers Simon

   Simon Cropper - Open Content Creator

   Free and Open Source Software Workflow Guides
   
   Introduction               http://www.fossworkflowguides.com
   GIS Packages           http://www.fossworkflowguides.com/gis
   bash / Python    http://www.fossworkflowguides.com/scripting



-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF output???

2012-07-07 Thread Tom Davies
Hi :)
Ouch, i wish i had time and a stable enough internet connection to work on 
this.  Is the document uploaded to Nabble or somewhere yet?
Regards from
Tom :)  


--- On Thu, 5/7/12, Rogier F. van Vlissingen vlisc...@gmail.com wrote:

From: Rogier F. van Vlissingen vlisc...@gmail.com
Subject: Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF 
output???
To: users@global.libreoffice.org
Date: Thursday, 5 July, 2012, 19:58

Hmm, disappointing though. I cannot see how these kinds of things can be
avoided if you are editing a manuscript, and I never had such problems in
the past with OO in 2002, with a book that certainly went through just as
many revisions.

I am clueless anymore how to fix it. If I fix one, another one pops up...

On Thu, Jul 5, 2012 at 1:12 PM, Fernand Vanrie s...@pmgroup.be wrote:

 Rogier ,

 Its not worth a issue, its user related due to serial direct formating,
 spaces folowd by spaces etc..When checking the underlying XML you can sea
 lots of unused tags and sometimes the PDF-creator is confused :-)

 The solution and the probable cause...

 In the end, this problem was fixable, by using 'clear direct formatting'
 in
 the areas affected. (Could not do whole doc lest we wipe out italics and
 such).

 The amazing fact was that the problem did not manifest in a PDF at the
 subdocument level, it just showed up in PDF output from the masterdoc.
 Very
 likely it was some kind of imperfection with the process of switching
 fonts
 somewhere in mid project. Unclear if it is substantial enough to rise to
 the level of a reportable issue. It probably is, but I would not know how
 to duplicate it.



 On Wed, Jul 4, 2012 at 3:37 AM, Fernand Vanrie s...@pmgroup.be wrote:

  Rogier ,

 We produce about 8000 full color magazine pages a year using OO-LO on
 Windows, without any PDF anomalies

 - are you using Windows ?

 - what Fonts ?

 you can also send some problematic pages to my personal emailadress

 Groeten

 Fernand

  Back in 2002 I produced a book, going straight to print off a Open
 Office
 PDF, and the results were thoroughly satisfactory. In fact, my book at
 that
 time was probably the first production book that was fully produced
 straight from OO, skipping DTP altogether.

 Today, 10 years later I'm doing a tentative layout for a book in Libre
 Office, though this time without the intention of going to print from
 the
 PDF, but I'm finding out I could not do it if I wanted to for there are
 some unpredictable anomalies happening in the PDF in LIbre Office. (I
 have
 not tried OO yet. Today I would probably use Scribus or Adobe Indesign
 to
 prepare a proper print layout.) What is happening is that there are
 completely unpredictable irregularities in the LO PDF output for which I
 cannot find any evident cause.


      - There is irregular line spacing happening in the PDF output for

      reasons that are entirely unclear in the original.
      - In some cases opening smart quotes seem to display at a point
 size

      about 5 times the size of the text in the PDF (not in the actual
 document
      files), which at least provides a visual clue for the irregular
 line
      spacing.

 Does anyone have similar experience, and has anyone perhaps found a
 workaround, or is this an issue.




 --
 For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
 **
 org 
 users%2Bhelp@global.**libreoffice.orgusers%252bh...@global.libreoffice.org
 
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-*
 *** http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/http://www.**libreoffice.org/get-help/**
 mailing-lists/how-to-**unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 
 Posting guidelines + more: 
 http://wiki.**documentfoundati**on.org/**http://documentfoundation.org/**
 Netiquette 
 http://wiki.**documentfoundation.org/**Netiquettehttp://wiki.documentfoundation.org/Netiquette
 
 List archive: 
 http://listarchives.**libreoff**ice.org/global/users/http://libreoffice.org/global/users/
 http://**listarchives.libreoffice.org/**global/users/http://listarchives.libreoffice.org/global/users/
 

 All messages sent to this list will be publicly archived and cannot be
 deleted






 --
 For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
 org users%2bh...@global.libreoffice.org
 Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.**documentfoundation.org/**
 Netiquette http://wiki.documentfoundation.org/Netiquette
 List archive: 
 http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted




-- 
Rogier F. van Vlissingen, NY
(917) 549 0959 * http://viz.me/vliscony*
*www.acimnthomas.com

Re: [libreoffice-users] Specialty Dictionaries

2012-07-07 Thread webmaster-Kracked_P_P


I wonder how hard it would be, or how confusing it would be to make a 2 
word reference in the word list file.  If the space appears blank, 
then what would happen if there was some other blank character that 
looked like the space character.


I think the originally defined system came from some other organization, 
like Hunspell or Myspell.  It may take a lot of work, and make all of 
the current .oxt dictionaries need to be re-done if there was a new 
formatting system that allowed a 2 word listing.


My question is why would one be needed?  It the only reason for it is 
one combination of terms is valid, while a different ending term is 
not?  That would make some real context oriented spelling and worse that 
figuring out grammar issues. You will need to have defines all the 
possible two word term combinations instead of having each single 
word/term checked for proper spelling.


The more I think about it, the more I want to cringe over what might be 
needed to get it working fully and not mess with defined characters for 
non-English fonts or other issues for taking over a pre-defined 
character for some internal function, when that character may be mapped 
for a glyph/letter for some font used by some user.   Then that user[s] 
would have their document messed up in some way.


Still, if someone can figure out all the issues and work out a way that 
they will not cause a set of users problems down the line, then by all 
means create a request for a modification of the spell checker system.  
I really doubt that it will be changed form the current system, but you 
can try.



On 07/07/2012 06:22 PM, Tom Davies wrote:

Hi :)
It sounds like interesting and useful functionality that might well be worth adding if it hasn't 
been done already.  I think a lot of us here have been focussing on work-arounds to just get 
the job done.  But i think it might be a good idea to post a bug-report and make it a 
Feature request.
Regards from
Tom :)


--- On Fri, 6/7/12, Simon Cropper simoncrop...@fossworkflowguides.com wrote:

From: Simon Cropper simoncrop...@fossworkflowguides.com
Subject: Re: [libreoffice-users] Specialty Dictionaries
To: users@global.libreoffice.org
Date: Friday, 6 July, 2012, 1:19

On 06/07/12 05:26, nvrk wrote:

On Thu, Jul 5, 2012 at 3:06 AM, Simon Cropper 
simoncrop...@fossworkflowguides.com wrote:


Yeah, I have thought of both these things. Have hacked a standard file
before, particularly in MS Word. Easily done assuming it is a text file and
not a binary file.

The problem is the binomial. I also thought of the concatenation string
but most of the single characters have been used for have special meanings
in various word processors. Hyphens for example are used in LO as hyphens
and so how would you know when removing the character at the end of your
report is complete, what is a concatenation character and what is a real
hyphen?

In other situations I have used =!= as a joining string but as stated it
is messy and hard to read.


An underscore works well.


Yeap, but an underscore gets used a lot in technical reports (e.g. in a URL). If you do a global 
search and replace to remove the character at the end of writing so the report looks clean 
and well presented you neuter the URL or corrupt the other text string that uses 
it.

As an alternative to free form typing of jargon or technical terms then running a spell 
checker, terms could be inserted from a list. This works OK but in the absence of LO integration 
you can't flag the inserted text as 'hey this is jargon, I just inserted it from a secure source, 
don't bother spell checking'. This can be done but requires you to manually apply language 
characteristics to hundreds or thousands of names, or alternatively hit ignore the same 
number of times with the spell checker. :(

Ideally you need a blank concatenation character that is recognizing by LO as linking two 
words (such as a non-breaking space already available in LO but does not necessarily have 
to physically bind the words together but would need to be seen by the spell checker as a 
joining character) AND IS RECOGNIZED by the spell checker, substituted with something 
like an underscore and compared to the lists in the dic files which would appear as 
Eucalyptus_vulgaris. I just need someone in the know to be able to insert 
this functionality and these problems would be solved.

-- Cheers Simon

Simon Cropper - Open Content Creator

Free and Open Source Software Workflow Guides

Introduction   http://www.fossworkflowguides.com
GIS Packages   http://www.fossworkflowguides.com/gis
bash / Pythonhttp://www.fossworkflowguides.com/scripting



-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: 

Re: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-07-07 Thread Tom Davies
i :)
I think one advantage of wiki's is that they are easy for anyone to update 
anytime.  Hopefully information from that gets fed into blogs and official 
documentation and maybe even the help files.  

Star Trek computers can do pretty much anything by just asking it to do 
whatever and people seem to expect their machines to be able to do the same.  
The physics in most sci-fi has been referred to a Want'em Physics 

I really liked Ken's remarks and agree that the average skill level does appear 
to have dropped or even plummeted.  People are expected to just instantly 
understand some very complex ideas with no training.  

Regards from
Tom :)  


--- On Thu, 5/7/12, Ken Springer snowsh...@q.com wrote:

From: Ken Springer snowsh...@q.com
Subject: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc
To: users@global.libreoffice.org
Date: Thursday, 5 July, 2012, 14:43

On 7/5/12 2:41 AM, Andreas Säger wrote:

snip

 All this had been written hundreds of times for dozends of spreadsheets
 applications in books, web-pages, mailing lists and forums. People don't
 read this.

I know, but I have a hard time blaming X percent of them.  I run into many 
users who have no clue such information even exists or go about finding it.  
They aren't into computers enough to search the web (occasionally they still 
have dial-up) as computers aren't major parts of their life, and library access 
can be minimal.  And no clue that all of the spreadsheets are very similar.

You can make that argument for lots of things.  There's hundreds of books on 
automotive electrical systems, but you still have people wanting a Ford manual 
to get specific information, for example.

I would be willing to bet the computer skills of the average computer user 30 
years ago was higher than it is today.

 They want to have it explained for the exact problem they
 struggle with *right now* without ever telling any details about their
 problem. People want computers they can talk to and the machine resolves
 all the contradictions, completes missing information before it spills
 out the correct solution. Since today's machines fail at fuzzy logic,
 they try to find some human to resolve and complete

All of this I attribute to the instant gratification we get today with 
computers and related electronics.  Want a book?  Download it to an ereader, 
who has to wait for it to be shipped to you?  No need to go to the store and 
look for something, buy it online.  Etc., etc., etc.

 or even better:
 write a macro program so a single click substitutes 5 clicks.

When I was using my Atari 16/32 bit machines with Neodesk, I had macros for 
desktop operations all the time, for the very reason you mentioned.  These were 
actions I repeated often.  Now, most of those reasons I used macros for are 
part of the OS and/or software.  And I don't do enough repetitive stuff to 
actually get much value from a macro recorder.

I think a certain percentage are too lazy to learn how to do it, and another 
percentage don't know what a macro is.  :-(

Rather than write a macro program, I'd download an open source or free 
one.   :-)

No offense intended, but to me to suggest writing a macro program, unless you 
have a very special need, is like reinventing the wheel.   :-)

 IF function with example:
 http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_IF_function

Maybe a lot of these types of links could be incorporated into LO's Help pages 
and/or on a free disk image you can download.  Perhaps Webmaster Krackedpress 
ND DVD too.  I don't know what's on that disk.

Wiki pages tend to baffle me, I just can never discover any structure like a 
newsgroup that makes sense to me.  And the wasted space.  :-(  And they 
are never as efficient in use as a well designed book with a well designed 
index.


-- Ken

Mac OS X 10.6.8
Firefox 13.0.1
Thunderbird 13.0.1
LibreOffice 3.5.2.2




-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted