[libreoffice-users] Re: BASIC script how to read/write system files, like /dev/null in Linux

2012-10-15 Thread Andreas Säger
Am 14.10.2012 21:08, chaonis wrote:
 I am trying to write scripts accessing the system files, such as /dev/ttyS0.
 If I use Open I got the error Device I/O error message. Are there any
 special function call needed to be done for the system files? User
 permission is good as I can access to the file using any other Linux
 commands.
 

You have so many programming languages availlable. Why StarBasic?
StarBasic is the most primitive API-caller. It is almost useless for
anything outside the UNO scope. (Apart from that, it is the worst
implementation of an extinct language).


-- 
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: how to delete an entire heading

2012-10-15 Thread rost52

Now I know what you meant. This indeed works to delete the header.
In my previous test I clicked into the header text which was obviously wrong.

On 15.10.2012 12:30, Steve Edmonds wrote:

Hi.
That has changed. There is a blue line comes and goes as the mouse goes over the header, with a 
blue tab. If I click this tab I get the option to remove.

Steve

On 2012-10-15 16:26, rost52 wrote:
Steve, Thanks for pointing this out. I immediately tested also on the header (at the top of each 
page to be precise) and there too I could not apply Tink's suggestion.

Let's see what will come later the day.

On 15.10.2012 11:36, Steve Edmonds wrote:

Hi.
I think there may be a crossed wire between header (at the top of the page) and heading (at the 
top of a paragraph).

Steve

On 2012-10-15 15:14, rost52 wrote:

Tink, thanks for the hint but it doesn't work.
I clicked in the header line.
Right click menu opens but doesn't show a menu item: Remove (or similar)
Is there a basic setting needed?

Tom, could you successfully apply this method?


On 15.10.2012 03:20, Tinkerer wrote:

Put the cursor in the Header then right click, from the menu, choose, Remove
Header.
You then have a choice, Delete header, Delete Header and Text.

Tink.



--
View this message in context: 
http://nabble.documentfoundation.org/how-to-delete-an-entire-heading-tp4013210p4013288.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] Integer part of a number

2012-10-15 Thread Brian Barker

At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote:

On 14.10.2012 12:20, Gilles SICHE wrote:
could anyone tell me which formula I should use 
for the integer part of a cell to be shown in another cell, ...


The answer could be:
=IF(C31;0;INT(C3))


You are overthinking the problem: if C3 is positive, that's no different from
=INT(C3)

Brian Barker


--
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: BASIC script how to read/write system files, like /dev/null in Linux

2012-10-15 Thread Tom Davies
Hi :)
What are 'the best' languages to choose?  Python and/or C++? or something else?

I know 'the best' is a bit subject to personal feelings and knowledge and 
experience but it would be interesting to hear people's opinions.  From what i 
can gather Python and C++ are teh best although mainstream seems to rate Java 
more highly and it appears in job ads more often.  On the other hand when jobs 
ask for C++ the pay-grade is far higher.  I got as far as Speccy Basic, a 
little pascal and some machine code but i think that's all s far behind me 
that i doubt i could write much even in those languages now (machine code was 
a tfn and only ever worked on the specific machine i wrote for (at best)).  
Regards from
Tom :)  


--- On Mon, 15/10/12, Andreas Säger ville...@t-online.de wrote:

From: Andreas Säger ville...@t-online.de
Subject: [libreoffice-users] Re: BASIC script how to read/write system files, 
like /dev/null in Linux
To: users@global.libreoffice.org
Date: Monday, 15 October, 2012, 7:17

Am 14.10.2012 21:08, chaonis wrote:
 I am trying to write scripts accessing the system files, such as /dev/ttyS0.
 If I use Open I got the error Device I/O error message. Are there any
 special function call needed to be done for the system files? User
 permission is good as I can access to the file using any other Linux
 commands.
 

You have so many programming languages availlable. Why StarBasic?
StarBasic is the most primitive API-caller. It is almost useless for
anything outside the UNO scope. (Apart from that, it is the worst
implementation of an extinct language).


-- 
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] Re: From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot

2012-10-15 Thread Tom Davies
Hi :)
Yes, that is the best way to migrate.  Keep whatever MS Office you happen to 
have and install LO.  There's no reason to upgrade the MS Office so you still 
make the saving but you still have acess to it when you need it.  Gradually you 
find more and more reason to use LO as you learn more about how to use it and 
less reason to be pushed into using MSO.  
Regards from
Tom :)  


--- On Sun, 14/10/12, anne-ology lagin...@gmail.com wrote:

From: anne-ology lagin...@gmail.com
Subject: Re: [libreoffice-users] Re: From MS Word to Writer: keeping my styles, 
macros, toolbars from Normal.dot
To: Andreas Säger ville...@t-online.de
Cc: users@global.libreoffice.org
Date: Sunday, 14 October, 2012, 23:21

       why not just keep both programs on the machine  ;-)



On Thu, Oct 11, 2012 at 7:27 AM, Andreas Säger ville...@t-online.de wrote:

Am 11.10.2012 11:43, Kyla Robertson wrote:
  Hello,
 
  I'm migrating from MS Word (Office 2002 !) to LibO Writer. In Word, my
  Normal.dot template contains many, many things: about 150 styles, 250
  macros, some auto-insert texts, some custom shortcuts, many toolbars
  and custom buttons.
 
  How can I keep this all to use it with Writer?
 
  In Migration Guide: A guide to ease your migration to OpenOffice.org
  from other office [suites] (2004)
  (
 http://www.openoffice.org/documentation/manuals/oooauthors/MigrationGuide.pdf
 ),
  I found a few things:
   * AutoText entries: will the built-in method to import them still
  work with LibO 3.6.2?(should I get version 3.6.2 or 3.5.6, btw? I'm
  not sure I understand the difference.)
   * AutoCorrect entries: there's a work-around with a macro and the
  editing of a ./user/autocorr/acorr.dat file...
   * Custom dictionaries: there was a work-around to import their
  content, but the link to download the macro isn't valid anymore.
 
  Do you know of a more recent migration guide, or a tutorial on the
  Web, or forum post maybe? I couldn't find anything else.
 
  Thanks in advance for your help!
 

 This is not a free clone of some other program. All it can do is loading
 .doc files fairly well. Please switch to this software or stay with
 WinWord.



-- 
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] Re: BASIC script how to read/write system files, like /dev/null in Linux

2012-10-15 Thread Walther Koehler
Hi,

if you drop Basic as a makro language in writer, you will drop me as a makro 
user, and maybe even as a LO user.

It gives me the freedom to automatize much of my daily tasks without learning 
another high level language.

And when I want to use GNU/Linux system functions I use extensiveley the shell 
comand, i.e. dir() is quite slow, but calling a shell script with an 
elaborate find command does the task very quick.
or: use sed to run through the odt's looking up the print date or ...

Maybe it might helt with /dev/.. too.

Walther

Although sometimes 

 Am Montag, 15. Oktober 2012 schrieb Tom Davies:
 Hi :)
 What are 'the best' languages to choose?  Python and/or C++? or something
 else?

 I know 'the best' is a bit subject to personal feelings and knowledge and
 experience but it would be interesting to hear people's opinions.  From
 what i can gather Python and C++ are teh best although mainstream seems to
 rate Java more highly and it appears in job ads more often.  On the other
 hand when jobs ask for C++ the pay-grade is far higher.  I got as far as
 Speccy Basic, a little pascal and some machine code but i think that's all
 s far behind me that i doubt i could write much even in those languages
 now (machine code was a tfn and only ever worked on the specific machine i
 wrote for (at best)).  Regards from
 Tom :) 


 --- On Mon, 15/10/12, Andreas Säger ville...@t-online.de wrote:

 From: Andreas Säger ville...@t-online.de
 Subject: [libreoffice-users] Re: BASIC script how to read/write system
 files, like /dev/null in Linux To: users@global.libreoffice.org
 Date: Monday, 15 October, 2012, 7:17

 Am 14.10.2012 21:08, chaonis wrote:
  I am trying to write scripts accessing the system files, such as
  /dev/ttyS0. If I use Open I got the error Device I/O error message.
  Are there any special function call needed to be done for the system
  files? User permission is good as I can access to the file using any
  other Linux commands.

 You have so many programming languages availlable. Why StarBasic?
 StarBasic is the most primitive API-caller. It is almost useless for
 anything outside the UNO scope. (Apart from that, it is the worst
 implementation of an extinct language).


 --
 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



Fwd: Re: [libreoffice-users] Re: BASIC script how to read/write system files, like /dev/null in Linux

2012-10-15 Thread Walther Koehler
Subject: Re: [libreoffice-users] Re: BASIC script how to read/write system 
files, like /dev/null in Linux
Date: Montag, 15. Oktober 2012
From: Walther Koehler w.koeh...@onlinemed.de
To: users@global.libreoffice.org

Hi,

if you drop Basic as a makro language in writer, you will drop me as a makro 
user, and maybe even as a LO user.

It gives me the freedom to automatize much of my daily tasks without learning 
another high level language.

And when I want to use GNU/Linux system functions I use extensiveley the shell 
comand, i.e. dir() is quite slow, but calling a shell script with an 
elaborate find command does the task very quick.
or: use sed to run through the odt's looking up the print date or ...

Maybe it might helt with /dev/.. too.

Walther

Although sometimes 

 Am Montag, 15. Oktober 2012 schrieb Tom Davies:
 Hi :)
 What are 'the best' languages to choose?  Python and/or C++? or something
 else?

 I know 'the best' is a bit subject to personal feelings and knowledge and
 experience but it would be interesting to hear people's opinions.  From
 what i can gather Python and C++ are teh best although mainstream seems to
 rate Java more highly and it appears in job ads more often.  On the other
 hand when jobs ask for C++ the pay-grade is far higher.  I got as far as
 Speccy Basic, a little pascal and some machine code but i think that's all
 s far behind me that i doubt i could write much even in those languages
 now (machine code was a tfn and only ever worked on the specific machine i
 wrote for (at best)).  Regards from
 Tom :) 


 --- On Mon, 15/10/12, Andreas Säger ville...@t-online.de wrote:

 From: Andreas Säger ville...@t-online.de
 Subject: [libreoffice-users] Re: BASIC script how to read/write system
 files, like /dev/null in Linux To: users@global.libreoffice.org
 Date: Monday, 15 October, 2012, 7:17

 Am 14.10.2012 21:08, chaonis wrote:
  I am trying to write scripts accessing the system files, such as
  /dev/ttyS0. If I use Open I got the error Device I/O error message.
  Are there any special function call needed to be done for the system
  files? User permission is good as I can access to the file using any
  other Linux commands.

 You have so many programming languages availlable. Why StarBasic?
 StarBasic is the most primitive API-caller. It is almost useless for
 anything outside the UNO scope. (Apart from that, it is the worst
 implementation of an extinct language).


 --
 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] From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot

2012-10-15 Thread e-letter
On 11/10/2012, Kyla Robertson robertsonk...@gmail.com wrote:
 Hello,

 I'm migrating from MS Word (Office 2002 !) to LibO Writer. In Word, my
 Normal.dot template contains many, many things: about 150 styles, 250
 macros, some auto-insert texts, some custom shortcuts, many toolbars
 and custom buttons.

 How can I keep this all to use it with Writer?

You can't. Nor should you.

LO is not m$. Create all your styles (not macros, they are terrible
functions to use) in LO, creating native odf files. Perform a
cost-benefit analysis of your time to learn LO, the advantages of odf,
etc. and compare to the cost of using m$ and decide which to use
accordingly.

Do not use LO as a free opportunity to write and create m$ documents.
Search this mailing archive for previous posts on this ad nauseum
topic.

-- 
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] From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot

2012-10-15 Thread Tom Davies
Hi :)
Lol!!  Welcome back e-letter!  

It seems a lot of things can be recovered and adapted for use with LO.  You 
don't have to start again from scratch and refuse to do business with the entre 
rest of the world until they start migrating away from MS.  If you did then LO 
would get nowhere. 

It is a good idea to keep your versions of your documents in LO formats = 
OpenDocument Formats such as odt, as those are native to the apps.  It would 
mean you can rely on them much more.  If/when you have to collaborate or 
present your documents to non-LO users then it's best to do Save As .. to 
save into the older MS formats (or the newer ones but they are a bit less 
predictable between different versions of MSO) such as doc (or Pdf if they 
don't need o be able to be edited).  

Note that Google-docs, Calligra, Lotus Symphony, AbiWord and all the rest use 
OpenDocument Formats as their default native formats too.  Even MS Office is 
starting to pretend to allow people to use OpenDocument Formats although their 
implementation is a bit broken (what else would you expect from MS right?).  

Regards from
Tom :)  






 From: e-letter inp...@gmail.com
To: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 11:49
Subject: Re: [libreoffice-users] From MS Word to Writer: keeping my styles, 
macros, toolbars from Normal.dot
 
On 11/10/2012, Kyla Robertson robertsonk...@gmail.com wrote:
 Hello,

 I'm migrating from MS Word (Office 2002 !) to LibO Writer. In Word, my
 Normal.dot template contains many, many things: about 150 styles, 250
 macros, some auto-insert texts, some custom shortcuts, many toolbars
 and custom buttons.

 How can I keep this all to use it with Writer?

You can't. Nor should you.

LO is not m$. Create all your styles (not macros, they are terrible
functions to use) in LO, creating native odf files. Perform a
cost-benefit analysis of your time to learn LO, the advantages of odf,
etc. and compare to the cost of using m$ and decide which to use
accordingly.

Do not use LO as a free opportunity to write and create m$ documents.
Search this mailing archive for previous posts on this ad nauseum
topic.

-- 
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] From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot

2012-10-15 Thread Gordon Burgess-Parker

On 15/10/12 12:16, Tom Davies wrote:

Even MS Office is starting to pretend to allow people to use OpenDocument 
Formats although their implementation is a bit broken (what else would you 
expect from MS right?).


Interestingly when you start a new installation of Word 2010 it asks you 
whether you want it to use OOXML or ODF as the default...

I hope that's not the slippery slope of embrace and extinguish

--

Registered Linux User no 240308
GBP's alternative computing:http://gbplinuxfoss.blogspot.com/  
Say No to OOXMLhttp://www.linuxjournal.com/article/9594#mpart8

I only accept odf or pdf documents by 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: Fwd: Re: [libreoffice-users] Re: BASIC script how to read/write system files, like /dev/null in Linux

2012-10-15 Thread Tom Davies
Hi :)
No-one is suggesting dropping Star Basic!  That would be a huge nightmare for 
many people i'm sure.    

I was just curious what might be better.  A quick look at what languages can be 
used for macros in LO reveals 4 choices;  LO Basic, Python, BeanShell, or 
JavaScript.  I was just wondering which was 'best'.  Are all 4 really well 
implemented in LO?  I guess LO Basic is the Star Basic being referred to in 
this thread?  

I think Andreas was just suggesting that choosing to use Star Basic is not the 
best choice.  However one of the great things about OpenSource is that you do 
get choices.  We can all disagree about almost everything and still end up 
co-operating with each other even if we didn't want to.  

Outside of IT choice is usually seen as a good thing.  Many countries see 
democracy as good and ostensibly give a choice of who you can vote for to 
rule.  In shops people would be outraged if there was nothing else to buy 
except baked beans.  People expect to be able to buy a wide range of diferent 
products from different companies and for it all to work together well enough.  
Somehow IT seems to demand dictatorships and freedom FROM choice rather than 
freedom OF choice.  We don't all do the same things and even if we did we 
probably wouldn't do them the same way so it's fairly insane to expect 1 
product and 1 company to be the only thing worth using.

I was just curious about other people's choices to help me understand more 
about a subject i know little about.  
Regards from
Tom :)







 From: Walther Koehler w.koeh...@onlinemed.de
To: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 11:43
Subject: Fwd: Re: [libreoffice-users] Re: BASIC script how to read/write 
system files, like /dev/null in Linux
 
Subject: Re: [libreoffice-users] Re: BASIC script how to read/write system 
files, like /dev/null in Linux
Date: Montag, 15. Oktober 2012
From: Walther Koehler w.koeh...@onlinemed.de
To: users@global.libreoffice.org

Hi,

if you drop Basic as a makro language in writer, you will drop me as a makro 
user, and maybe even as a LO user.

It gives me the freedom to automatize much of my daily tasks without learning 
another high level language.

And when I want to use GNU/Linux system functions I use extensiveley the shell 
comand, i.e. dir() is quite slow, but calling a shell script with an 
elaborate find command does the task very quick.
or: use sed to run through the odt's looking up the print date or ...

Maybe it might helt with /dev/.. too.

Walther

Although sometimes 

Am Montag, 15. Oktober 2012 schrieb Tom Davies:
 Hi :)
 What are 'the best' languages to choose?  Python and/or C++? or something
 else?

 I know 'the best' is a bit subject to personal feelings and knowledge and
 experience but it would be interesting to hear people's opinions.  From
 what i can gather Python and C++ are teh best although mainstream seems to
 rate Java more highly and it appears in job ads more often.  On the other
 hand when jobs ask for C++ the pay-grade is far higher.  I got as far as
 Speccy Basic, a little pascal and some machine code but i think that's all
 s far behind me that i doubt i could write much even in those languages
 now (machine code was a tfn and only ever worked on the specific machine i
 wrote for (at best)).  Regards from
 Tom :) 


 --- On Mon, 15/10/12, Andreas Säger ville...@t-online.de wrote:

 From: Andreas Säger ville...@t-online.de
 Subject: [libreoffice-users] Re: BASIC script how to read/write system
 files, like /dev/null in Linux To: users@global.libreoffice.org
 Date: Monday, 15 October, 2012, 7:17

 Am 14.10.2012 21:08, chaonis wrote:
  I am trying to write scripts accessing the system files, such as
  /dev/ttyS0. If I use Open I got the error Device I/O error message.
  Are there any special function call needed to be done for the system
  files? User permission is good as I can access to the file using any
  other Linux commands.

 You have so many programming languages availlable. Why StarBasic?
 StarBasic is the most primitive API-caller. It is almost useless for
 anything outside the UNO scope. (Apart from that, it is the worst
 implementation of an extinct language).




-- 
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: MS raised prices so people will now start renting their office products instead

2012-10-15 Thread Wolfgang Keller
 But Ooo/LO does use structure markup. All .odt/.ods documents are XML
 files.

XML is just syntax. It does not necessarily imply structure markup, as
shown by e.g. .docx and .odt. Just unzip an .odt document and open
contents.xml in a XML editor to see what spaghetti xml looks like.

Sincerely,

Wolfgang

-- 
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] Integer part of a number

2012-10-15 Thread Tom Davies
Hi :)
The best answer in this thread was the first answer, by Rolf Lochbühler.  Brian 
is right as usual but Pertti's answer deals with unexpectedly wrong counts.
Regards from
Tom :)  






 From: Brian Barker b.m.bar...@btinternet.com
To: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 9:45
Subject: Re: [libreoffice-users] Integer part of a number
 
At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote:
On 14.10.2012 12:20, Gilles SICHE wrote:
could anyone tell me which formula I should use 
for the integer part of a cell to be shown in another cell, ...

The answer could be:
=IF(C31;0;INT(C3))

You are overthinking the problem: if C3 is positive, that's no different from
=INT(C3)

Brian Barker


-- 
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] Re: documentation for LO base

2012-10-15 Thread Wolfgang Keller
 I use it at the office for time registration and invoicing. At home
 for the Taekwon-do club membership.

Should I perceive that as a threat? ;-

 It's actually marvelous in combination with postgresql SDBC driver.
 And actually useful as it is so easy to get your data to Calc, more
 useful then I remember Access.

In fact that's also the only application case that I would consider
using Calc and Writer for in their current state - for graphing and
printing database data.

Imho the most logical and least error-prone way to use Calc is to do
all your calculations in PostgreSQL and only display and graph the
results in Calc. *Never* do complex calculations in Calc.

 It always hurts a bit when people who don't use databases say that
 Base is not good, databases are not useful etc.

Because they don't have a use for it (pure letter-writers for home-use)
or because they don't have a clue (most office users).
 
 I know a lot of people that never use a spreadsheet either. But I
 think LO wouldn't be complete with Calc or Base.

You mean withOUT, I presume?
 
Sincerely,

Wolfgang

-- 
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: MS raised prices so people will now start renting their office products instead

2012-10-15 Thread Wolfgang Keller
  that's the way it is and that's why currently I don't use LO Writer
  for anything else than for converting .doc files to .pdf

 I might just be something a little bit above a IT moron but using LO
 Writer to convert doc into pdf appears to me like using a tractor to
 participate in a F1 race or using an F1 race car to plough a field.
 Why not installing a pdf-writer SW, there are even free-of-charge
 versions available.

The point is that you do not only need a printer driver to generate the
PDF, but also an application that can open those .doc, .ppt etc. files.

Sincerely,

Wolfgang

-- 
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] Integer part of a number

2012-10-15 Thread Brian Barker

At 12:38 15/10/2012 +0100, Tom Davies wrote:

... but Pertti's answer deals with unexpectedly wrong counts.


It does nothing of the sort, of course.

Brian Barker


--
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: Auto and Manual Spell do not work x

2012-10-15 Thread Tom Davies
Hi :)
Did you uninstall all versions of 'LO' that you got from some freeware site 
and do an antivirus scan?  Did you download the 3.5.6 or 3.6.something LO from 
the official site and install as advised?  

Is there any chance of giving us a screen-shot?

Also, just out of curiosity, have you used Win7 on any machine other than your 
own?  Has anyone else used your machine that might have some familiarity with 
Win7 when it's properly installed?  Did you install Win7 or was it already on 
the machine when you bought it?  

Btw Abiword can save files in MS formats but you have to do
File - Save As ...
You can't set it to default to MS formats.  I tried nagging them about it but 
gave up.  The native format it uses is the OpenDocument Format, same as LO, 
same as almost every other word-processing program except MS and even they 
purport to support it as a non-native format.  So, people using MS Office 
'should' be able to open your documents created in AbiWord.  I did mention all 
this when i made some suggestions about what other free word-processors were 
out there although not in as much detail.  

Regards from
Tom :)  






 From: Lostsoul joyseyh...@yahoo.com
To: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 5:04
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x
 
Ok whats going on now when i move my mouse about a blank page i get 5 lines to 
the right of the i line which is the pointer hope that makes sense; how do i 
end that ? 

--- On Sun, 10/14/12, Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013298...@n3.nabble.com wrote:


From: Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013298...@n3.nabble.com
Subject: Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Date: Sunday, October 14, 2012, 3:15 PM


Hi :) 
To get back to factory defaults and 'switch off' all Extensions just rename 
your User Profile.  Larry gave a link to help with that.  Here is another link 
that will one day be merged with the one Larry gave 
http://wiki.documentfoundation.org/Documentation/UserProfile

Factory defaults are possibly a bit less tweaked than whatever you had 
installed so it may look a little different and may remove some weirdnesses.  
It's a good thing to try whenever you find weird things going on.  It usually 
beats a reinstall assuming you have now installed a proper version of LO.  

Regards from 
Tom :)  


--- On Sun, 14/10/12, Lostsoul [hidden email] wrote: 

From: Lostsoul [hidden email] 
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x 
To: [hidden email] 
Date: Sunday, 14 October, 2012, 9:37 

 Haha very funny that know one can tell me why word problems hate windows 
7 never had any word programs hate vista so explain if you dare; you'd be the 
first why the word programs hate win 7 and why no one but no one has a fix; 
this i got to hear. 
  
How do i turn off file extensions in windows 7 64 bit   -  later . .  

--- On Sun, 10/14/12, Andreas Säger [via Document Foundation Mail Archive] 
[hidden email] wrote: 


From: Andreas Säger [via Document Foundation Mail Archive] [hidden email] 
Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 4:28 AM 


Am 14.10.2012 10:10, Lostsoul wrote: 
      Ok now what the crap; why are abiword documents being saved as adobi 
 docs how do i fix that can t get anything right crap .   -  later 
 

I strongly recommend some computer crash curse. File name associations 
are free.  There is nothing hard wired to the system. You can open any 
file with any program you want. You can tell your desktop environment 
which programs can open which types of files and which single program is 
the preferred one to be used on double-click. 
First of all, any user who is forced to use MS Windows should turn off 
the option to hide known file name extensions. Since Windows '95 this is 
the major obstacle which prevents people from understanding their system. 


-- 
View this message in context: 
http://nabble.documentfoundation.org/Auto-and-Manual-Spell-do-not-work-tp4012609p4013346.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] From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot

2012-10-15 Thread Tom Davies
Hi :)
Probably is.  Even so i think it's best to berate them for their poor 
implementation and keep hassling them to be better at their implementation of 
ODF.  Like using the more up-to-date version (1.2) that everyone else is using 
instead of the ancient 1.1.  
Regards from
Tom :)  






 From: Gordon Burgess-Parker gbpli...@gmail.com
To: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 12:23
Subject: Re: [libreoffice-users] From MS Word to Writer: keeping my styles, 
macros, toolbars from Normal.dot
 
On 15/10/12 12:16, Tom Davies wrote:
 Even MS Office is starting to pretend to allow people to use OpenDocument 
 Formats although their implementation is a bit broken (what else would you 
 expect from MS right?).
 
 
Interestingly when you start a new installation of Word 2010 it asks you 
whether you want it to use OOXML or ODF as the default...
I hope that's not the slippery slope of embrace and extinguish

-- 
Registered Linux User no 240308
GBP's alternative computing:http://gbplinuxfoss.blogspot.com/  Say No to 
OOXMLhttp://www.linuxjournal.com/article/9594#mpart8
I only accept odf or pdf documents by 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



Re: [libreoffice-users] Re: how to delete an entire heading

2012-10-15 Thread Tom Davies
Hi :)
I couldn't get this to work either way around either (ie not with headings 
(although mine are probably stuffed-up somehow) and not with the header (which 
i know i stuff-up).  I think i would have to read up documentation about it
http://wiki.documentfoundation.org/Documentation/Publications

It looks like something that would be hugely useful if you already knew how to 
use it but i don't so i would stick with the 
Shiftclick 
method that works in almost all other apps even non-LO ones.
Regards from
Tom :)  






 From: rost52 bugquestcon...@online.de
To: Steve Edmonds steve.edmo...@ptglobal.com 
Cc: users@global.libreoffice.org users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 4:26
Subject: Re: [libreoffice-users] Re: how to delete an entire heading
 
Steve, Thanks for pointing this out. I immediately tested also on the header 
(at the top of each page to be precise) and there too I could not apply Tink's 
suggestion.
Let's see what will come later the day.

On 15.10.2012 11:36, Steve Edmonds wrote:
 Hi.
 I think there may be a crossed wire between header (at the top of the page) 
 and heading (at the top of a paragraph).
 Steve
 
 On 2012-10-15 15:14, rost52 wrote:
 Tink, thanks for the hint but it doesn't work.
 I clicked in the header line.
 Right click menu opens but doesn't show a menu item: Remove (or similar)
 Is there a basic setting needed?
 
 Tom, could you successfully apply this method?
 
 
 On 15.10.2012 03:20, Tinkerer wrote:
 Put the cursor in the Header then right click, from the menu, choose, 
 Remove
 Header.
 You then have a choice, Delete header, Delete Header and Text.
 
 Tink.
 
 
 
 -- View this message in context: 
 http://nabble.documentfoundation.org/how-to-delete-an-entire-heading-tp4013210p4013288.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] Re: Auto and Manual Spell do not work x

2012-10-15 Thread Robert Burns
   Not using libre from free sites because they are 28 or 125 mb in size so i 
deleted those now using the full version 220 mb version  3.6.6. but thinking of 
trying 3.5.4 since some think that s the best version to try with windows 7 
but trying abiword and I B M lotus and 
Kingsoft  maybe they won t throw fits at windows 7 so no hurry to reset w7; 
libre needs fixing not windows 7 .
 
Windows 7 came with the lap top; when i use save as i have 7 choices so which 
is the best to use; save as with libre and can i get a save doc format switched 
over to saved as; and would libre stop having win7 fits i wonder .
 
And a screen shot of what ? ?   Whew  later .  .  .
 

--- On Mon, 10/15/12, Tom Davies tomdavie...@yahoo.co.uk wrote:


From: Tom Davies tomdavie...@yahoo.co.uk
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com, users@global.libreoffice.org 
users@global.libreoffice.org
Date: Monday, October 15, 2012, 8:15 AM




Hi :)
Did you uninstall all versions of 'LO' that you got from some freeware site 
and do an antivirus scan?  Did you download the 3.5.6 or 3.6.something LO from 
the official site and install as advised?  

Is there any chance of giving us a screen-shot?

Also, just out of curiosity, have you used Win7 on any machine other than your 
own?  Has anyone else used your machine that might have some familiarity with 
Win7 when it's properly installed?  Did you install Win7 or was it already on 
the machine when you bought it?  

Btw Abiword can save files in MS formats but you have to do
File - Save As ...
You can't set it to default to MS formats.  I tried nagging them about it but 
gave up.  The native format it uses is the OpenDocument Format, same as LO, 
same as almost every other word-processing program except MS and even they 
purport to support it as a non-native format.  So, people using MS Office 
'should' be able to open your documents created in AbiWord.  I did mention all 
this when i made some suggestions about what other free word-processors were 
out there although not in as much detail.  

Regards from
Tom :)  










From: Lostsoul joyseyh...@yahoo.com
To: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 5:04
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x

Ok whats going on now when i move my mouse about a blank page i get 5 lines to 
the right of the i line which is the pointer hope that makes sense; how do i 
end that ? 

--- On Sun, 10/14/12, Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013298...@n3.nabble.com wrote:


From: Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013298...@n3.nabble.com
Subject: Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Date: Sunday, October 14, 2012, 3:15 PM


Hi :) 
To get back to factory defaults and 'switch off' all Extensions just rename 
your User Profile.  Larry gave a link to help with that.  Here is another link 
that will one day be merged with the one Larry gave 
http://wiki.documentfoundation.org/Documentation/UserProfile

Factory defaults are possibly a bit less tweaked than whatever you had 
installed so it may look a little different and may remove some weirdnesses.  
It's a good thing to try whenever you find weird things going on.  It usually 
beats a reinstall assuming you have now installed a proper version of LO.  

Regards from 
Tom :)  


--- On Sun, 14/10/12, Lostsoul [hidden email] wrote: 

From: Lostsoul [hidden email] 
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x 
To: [hidden email] 
Date: Sunday, 14 October, 2012, 9:37 

 Haha very funny that know one can tell me why word problems hate windows 7 
never had any word programs hate vista so explain if you dare; you'd be the 
first why the word programs hate win 7 and why no one but no one has a fix; 
this i got to hear. 
  
How do i turn off file extensions in windows 7 64 bit   -  later . .  

--- On Sun, 10/14/12, Andreas Säger [via Document Foundation Mail Archive] 
[hidden email] wrote: 


From: Andreas Säger [via Document Foundation Mail Archive] [hidden email] 
Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 4:28 AM 


Am 14.10.2012 10:10, Lostsoul wrote: 
      Ok now what the crap; why are abiword documents being saved as adobi 
 docs how do i fix that can t get anything right crap .   -  later 
 

I strongly recommend some computer crash curse. File name associations 
are free.  There is nothing hard wired to the system. You can open any 
file with any program you want. You can tell your desktop environment 
which programs can open which types of files and which single program is 
the preferred one to be used on double-click. 
First of all, any user who is forced to use MS Windows should turn off 
the option to hide known file name extensions. Since Windows '95 this is 
the major obstacle which prevents people from 

[libreoffice-users] Re: Fwd: Re: Re: BASIC script how to read/write system files, like /dev/null in Linux

2012-10-15 Thread Andreas Säger
Am 15.10.2012 13:31, Tom Davies wrote:
 Hi :)
 No-one is suggesting dropping Star Basic!  That would be a huge nightmare for 
 many people i'm sure.
 
 I was just curious what might be better.  A quick look at what languages can 
 be used for macros in LO reveals 4 choices;  LO Basic, Python, BeanShell, or 
 JavaScript.  I was just wondering which was 'best'.  Are all 4 really well 
 implemented in LO?  I guess LO Basic is the Star Basic being referred to in 
 this thread?  
 
 I think Andreas was just suggesting that choosing to use Star Basic is not 
 the best choice.  However one of the great things about OpenSource is that 
 you do get choices.  We can all disagree about almost everything and still 
 end up co-operating with each other even if we didn't want to.  
 
 Outside of IT choice is usually seen as a good thing.  Many countries see 
 democracy as good and ostensibly give a choice of who you can vote for to 
 rule.  In shops people would be outraged if there was nothing else to buy 
 except baked beans.  People expect to be able to buy a wide range of diferent 
 products from different companies and for it all to work together well 
 enough.  Somehow IT seems to demand dictatorships and freedom FROM choice 
 rather than freedom OF choice.  We don't all do the same things and even if 
 we did we probably wouldn't do them the same way so it's fairly insane to 
 expect 1 product and 1 company to be the only thing worth using.
 
 I was just curious about other people's choices to help me understand more 
 about a subject i know little about.  
 Regards from
 Tom :)

StarBasic is a separate lingo implemented to call the API of this
particular software only. It can not do anything outside the scope of
the office. It comes with a few convenience features related to this
particular API and the code is easier to be stored within office
documents. It does not include any math library beyond triangular
functions and basic arithmetics. It handles arrays in the most
complicated ways, it does not know any hashes, it has far too many bugs
and short comings, it is extremely complex and awkward (Null, Nothing,
Empty, Missing are different types of the same).
Basic is a 100% procedural lingo talking to an strictly object oriented
API which is the reason why you can not write any extensions in Basic.
MS Office and this office are the last resorts of this extinct lingo of
the MS dominated 90ies.
The alternatives are full featured, popular and mature programming
languages with dozends of modules to program anything you want.
A little bit of glue code makes them UNO compatible, callable from
within the office suite (ToolsMacros), from the command line and as UNO
components as well. Plain souce code files are much easier to maintain
and a programmer can use whatever source code editor he wants (the Basic
editor is no more than a cheap plastic toy).
All the object oriented languages can be used to write seamlessly
integrated extensions.


-- 
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: LibreOffice in MacWorld Australia

2012-10-15 Thread Tom Davies
Hi :)
I really don't mind if people disagree with me or even if it's not that strong, 
just a possible uncertainty about something i said.  The important thing imo is 
to get enough good answers out there that the op can pick and choose or get 
inspired by one or more in order to solve the problem and move on.  The 
important bit is getting questions solved.  

Blind obediance is what got us into this mess with MS, Adobe, Oracle and the 
rest in the first place.  It's passionately disagreeing with each other that 
helps us develop good choices.  

Diversity breeds serendipity!  If we were all the same it would be really 
boring!  :)

Regards from
Tom :)  






 From: Dr. R. O Stapf reinh...@stapf-online.com
To: anne-ology lagin...@gmail.com 
Cc: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 3:00
Subject: Re: [libreoffice-users] Re: LibreOffice in MacWorld Australia
 
I did not want to express it that explicitly what you wrote is
    perfectly right.I am often wondering why some members of this forum 
complain so much
    about LO instead of exchanging information in
    non-inflicting-feelings-of-others words, which help other users to
    solve their problems and/or help to move LO's development forward.On 
15.10.2012 07:48, anne-ology wrote:
MSFT does not list their bugs; they deny them;-(On Sat, Oct 13, 2012 at 10:28 
PM, Dr. R.
        O Stapfreinhold@stapf-online.comwrote:I have my
          still my doubts on graphics, but all the other remarks of Tom
          I fully agree.By the way is there a list of MSO bugs we can have a 
look at?
          I doubt!On 14.10.2012 10:39, anne-ology wrote:same here.On Thu, Oct 
11, 2012 at 8:27 PM, Tom daviestomdavie...@yahoo.co.ukwrote:Hi :)I prefer LO 
on Windows even though i have a choice of
                  MSO 2007 and 2010 onthe same machine.All 3 installed but LO 
handles
                  graphics better.Plus itdoesn't keep changing styles, 
languages, indentations,
                  size ofbullet-points and it keeps track of numbers better in
                  numbered lists.Alsobetter compatibility.Each version of MSO 
stuffs up
                  documents created bythe other.If i write in LO then save as 
doc then
                  both versions of MSOdisplay the file the same way.I find the 
menus
                  easier although somethings are just as easy on both.Regards 
fromTom :)From: Andreas 
sgerville...@t-online.deto:users@global.libreoffice.orgSent: Thursday, 11 
October 2012, 23:48Subject: [libreoffice-users] Re: LibreOffice in
                    MacWorld AustraliaAm 11.10.2012 20:46, 
webmaster-Kracked_P_P wrote:It is nice to see that MacWorld Australia states
                      that LibreOffice is amust have app/package. I wonder 
if the MacWorld
                      for the USA and Europewould have the same statement.Be 
nice to have LO listed in the must have
                      category in the variousWindows magazines. We could use 
more Windows
                      users, and freeadvertisements towards Windows users, as 
we can
                      get.It would be nice to have a booth in a Windows
                      version of the bigsoftware shows that happen for Linux 
and Mac. But
                      those booths may bevery expensive to rent for such an 
event.Windows users can run MS Office easily and for
                    little money (if any).Why should they use LibreOffice if 
all they want is
                    cheap MS Office?Idealism? Masochism?




-- 
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: Integer part of a number

2012-10-15 Thread Andreas Säger
Am 15.10.2012 09:49, Pertti Rönnberg wrote:

 if value in cell c3 is /_less than_/ '1' then d3 shall be '0', else (--
 if c3 is '1' or bigger then -- ) use the integer of value in c3)
 

=MIN(0;INT(C3))



-- 
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: Auto and Manual Spell do not work x . .

2012-10-15 Thread Lostsoul
 Ohh getting some weird lines that floats next to the arrow or its more 
like an oversized i whats that about and how do i get rid of it ?   -   later . 
. .

--- On Mon, 10/15/12, Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013421...@n3.nabble.com wrote:


From: Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013421...@n3.nabble.com
Subject: Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Date: Monday, October 15, 2012, 8:16 AM


Hi :) 
Did you uninstall all versions of 'LO' that you got from some freeware site 
and do an antivirus scan?  Did you download the 3.5.6 or 3.6.something LO from 
the official site and install as advised?  

Is there any chance of giving us a screen-shot? 

Also, just out of curiosity, have you used Win7 on any machine other than your 
own?  Has anyone else used your machine that might have some familiarity with 
Win7 when it's properly installed?  Did you install Win7 or was it already on 
the machine when you bought it?  

Btw Abiword can save files in MS formats but you have to do 
File - Save As ... 
You can't set it to default to MS formats.  I tried nagging them about it but 
gave up.  The native format it uses is the OpenDocument Format, same as LO, 
same as almost every other word-processing program except MS and even they 
purport to support it as a non-native format.  So, people using MS Office 
'should' be able to open your documents created in AbiWord.  I did mention all 
this when i made some suggestions about what other free word-processors were 
out there although not in as much detail.  

Regards from 
Tom :)  






 
 From: Lostsoul [hidden email] 
To: [hidden email] 
Sent: Monday, 15 October 2012, 5:04 
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x 
 
Ok whats going on now when i move my mouse about a blank page i get 5 lines to 
the right of the i line which is the pointer hope that makes sense; how do i 
end that ?  
 
--- On Sun, 10/14/12, Tom [via Document Foundation Mail Archive] [hidden 
email] wrote: 
 
 
From: Tom [via Document Foundation Mail Archive] [hidden email] 
Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 3:15 PM 
 
 
Hi :) 
To get back to factory defaults and 'switch off' all Extensions just rename 
your User Profile.  Larry gave a link to help with that.  Here is another link 
that will one day be merged with the one Larry gave 
http://wiki.documentfoundation.org/Documentation/UserProfile
 
Factory defaults are possibly a bit less tweaked than whatever you had 
installed so it may look a little different and may remove some weirdnesses.  
It's a good thing to try whenever you find weird things going on.  It usually 
beats a reinstall assuming you have now installed a proper version of LO.  
 
Regards from 
Tom :)  
 
 
--- On Sun, 14/10/12, Lostsoul [hidden email] wrote: 
 
From: Lostsoul [hidden email] 
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x 
To: [hidden email] 
Date: Sunday, 14 October, 2012, 9:37 
 
 Haha very funny that know one can tell me why word problems hate windows 
7 never had any word programs hate vista so explain if you dare; you'd be the 
first why the word programs hate win 7 and why no one but no one has a fix; 
this i got to hear. 
  
How do i turn off file extensions in windows 7 64 bit   -  later . .  
 
--- On Sun, 10/14/12, Andreas Säger [via Document Foundation Mail Archive] 
[hidden email] wrote: 
 
 
From: Andreas Säger [via Document Foundation Mail Archive] [hidden email] 
Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 4:28 AM 
 
 
Am 14.10.2012 10:10, Lostsoul wrote: 
      Ok now what the crap; why are abiword documents being saved as adobi 
 docs how do i fix that can t get anything right crap .   -  later 
 
 
I strongly recommend some computer crash curse. File name associations 
are free.  There is nothing hard wired to the system. You can open any 
file with any program you want. You can tell your desktop environment 
which programs can open which types of files and which single program is 
the preferred one to be used on double-click. 
First of all, any user who is forced to use MS Windows should turn off 
the option to hide known file name extensions. Since Windows '95 this is 
the major obstacle which prevents people from understanding their system. 
 
 
-- 
View this message in context: 
http://nabble.documentfoundation.org/Auto-and-Manual-Spell-do-not-work-tp4012609p4013346.html
Sent from the Users mailing list archive at Nabble.com. 
 -- 
For unsubscribe instructions e-mail to: [hidden email] 
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 

Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . .

2012-10-15 Thread Tom Davies
Hi :)
Any chance of getting some answers to some of the questions people here have 
asked?
Regards from
Tom :)  






 From: Lostsoul joyseyh...@yahoo.com
To: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 13:46
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x . .
 
 Ohh getting some weird lines that floats next to the arrow or its more 
like an oversized i whats that about and how do i get rid of it ?   -   later 
. . .

--- On Mon, 10/15/12, Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013421...@n3.nabble.com wrote:


From: Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013421...@n3.nabble.com
Subject: Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Date: Monday, October 15, 2012, 8:16 AM


Hi :) 
Did you uninstall all versions of 'LO' that you got from some freeware site 
and do an antivirus scan?  Did you download the 3.5.6 or 3.6.something LO from 
the official site and install as advised?  

Is there any chance of giving us a screen-shot? 

Also, just out of curiosity, have you used Win7 on any machine other than your 
own?  Has anyone else used your machine that might have some familiarity with 
Win7 when it's properly installed?  Did you install Win7 or was it already on 
the machine when you bought it?  

Btw Abiword can save files in MS formats but you have to do 
File - Save As ... 
You can't set it to default to MS formats.  I tried nagging them about it but 
gave up.  The native format it uses is the OpenDocument Format, same as LO, 
same as almost every other word-processing program except MS and even they 
purport to support it as a non-native format.  So, people using MS Office 
'should' be able to open your documents created in AbiWord.  I did mention all 
this when i made some suggestions about what other free word-processors were 
out there although not in as much detail.  

Regards from 
Tom :)  






 
 From: Lostsoul [hidden email] 
To: [hidden email] 
Sent: Monday, 15 October 2012, 5:04 
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x 
 
Ok whats going on now when i move my mouse about a blank page i get 5 lines 
to the right of the i line which is the pointer hope that makes sense; how do 
i end that ?  
 
--- On Sun, 10/14/12, Tom [via Document Foundation Mail Archive] [hidden 
email] wrote: 
 
 
From: Tom [via Document Foundation Mail Archive] [hidden email] 
Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 3:15 PM 
 
 
Hi :) 
To get back to factory defaults and 'switch off' all Extensions just rename 
your User Profile.  Larry gave a link to help with that.  Here is another 
link that will one day be merged with the one Larry gave 
http://wiki.documentfoundation.org/Documentation/UserProfile
 
Factory defaults are possibly a bit less tweaked than whatever you had 
installed so it may look a little different and may remove some weirdnesses.  
It's a good thing to try whenever you find weird things going on.  It usually 
beats a reinstall assuming you have now installed a proper version of LO.  
 
Regards from 
Tom :)  
 
 
--- On Sun, 14/10/12, Lostsoul [hidden email] wrote: 
 
From: Lostsoul [hidden email] 
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x 
To: [hidden email] 
Date: Sunday, 14 October, 2012, 9:37 
 
 Haha very funny that know one can tell me why word problems hate windows 
7 never had any word programs hate vista so explain if you dare; you'd be the 
first why the word programs hate win 7 and why no one but no one has a fix; 
this i got to hear. 
  
How do i turn off file extensions in windows 7 64 bit   -  later . .  
 
--- On Sun, 10/14/12, Andreas Säger [via Document Foundation Mail Archive] 
[hidden email] wrote: 
 
 
From: Andreas Säger [via Document Foundation Mail Archive] [hidden email] 
Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 4:28 AM 
 
 
Am 14.10.2012 10:10, Lostsoul wrote: 
      Ok now what the crap; why are abiword documents being saved as adobi 
 docs how do i fix that can t get anything right crap .   -  later 
 
 
I strongly recommend some computer crash curse. File name associations 
are free.  There is nothing hard wired to the system. You can open any 
file with any program you want. You can tell your desktop environment 
which programs can open which types of files and which single program is 
the preferred one to be used on double-click. 
First of all, any user who is forced to use MS Windows should turn off 
the option to hide known file name extensions. Since Windows '95 this is 
the major obstacle which prevents people from understanding their system. 
 
 
-- 
View this message in context: 
http://nabble.documentfoundation.org/Auto-and-Manual-Spell-do-not-work-tp4012609p4013346.html
Sent from the Users 

Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . .

2012-10-15 Thread Robert Burns
 I have you didn t get it should i re sent  ? ?

--- On Mon, 10/15/12, Tom Davies tomdavie...@yahoo.co.uk wrote:


From: Tom Davies tomdavie...@yahoo.co.uk
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . .
To: Lostsoul joyseyh...@yahoo.com, users@global.libreoffice.org 
users@global.libreoffice.org
Date: Monday, October 15, 2012, 8:53 AM




Hi :)
Any chance of getting some answers to some of the questions people here have 
asked?
Regards from
Tom :)  










From: Lostsoul joyseyh...@yahoo.com
To: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 13:46
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x . .

 Ohh getting some weird lines that floats next to the arrow or its more 
like an oversized i whats that about and how do i get rid of it ?   -   later . 
. .

--- On Mon, 10/15/12, Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013421...@n3.nabble.com wrote:


From: Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013421...@n3.nabble.com
Subject: Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Date: Monday, October 15, 2012, 8:16 AM


Hi :) 
Did you uninstall all versions of 'LO' that you got from some freeware site 
and do an antivirus scan?  Did you download the 3.5.6 or 3.6.something LO from 
the official site and install as advised?  

Is there any chance of giving us a screen-shot? 

Also, just out of curiosity, have you used Win7 on any machine other than your 
own?  Has anyone else used your machine that might have some familiarity with 
Win7 when it's properly installed?  Did you install Win7 or was it already on 
the machine when you bought it?  

Btw Abiword can save files in MS formats but you have to do 
File - Save As ... 
You can't set it to default to MS formats.  I tried nagging them about it but 
gave up.  The native format it uses is the OpenDocument Format, same as LO, 
same as almost every other word-processing program except MS and even they 
purport to support it as a non-native format.  So, people using MS Office 
'should' be able to open your documents created in AbiWord.  I did mention all 
this when i made some suggestions about what other free word-processors were 
out there although not in as much detail.  

Regards from 
Tom :)  






 
 From: Lostsoul [hidden email] 
To: [hidden email] 
Sent: Monday, 15 October 2012, 5:04 
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x 
 
Ok whats going on now when i move my mouse about a blank page i get 5 lines to 
the right of the i line which is the pointer hope that makes sense; how do i 
end that ?  
 
--- On Sun, 10/14/12, Tom [via Document Foundation Mail Archive] [hidden 
email] wrote: 
 
 
From: Tom [via Document Foundation Mail Archive] [hidden email] 
Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 3:15 PM 
 
 
Hi :) 
To get back to factory defaults and 'switch off' all Extensions just rename 
your User Profile.  Larry gave a link to help with that.  Here is another link 
that will one day be merged with the one Larry gave 
http://wiki.documentfoundation.org/Documentation/UserProfile
 
Factory defaults are possibly a bit less tweaked than whatever you had 
installed so it may look a little different and may remove some weirdnesses.  
It's a good thing to try whenever you find weird things going on.  It usually 
beats a reinstall assuming you have now installed a proper version of LO.  
 
Regards from 
Tom :)  
 
 
--- On Sun, 14/10/12, Lostsoul [hidden email] wrote: 
 
From: Lostsoul [hidden email] 
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x 
To: [hidden email] 
Date: Sunday, 14 October, 2012, 9:37 
 
 Haha very funny that know one can tell me why word problems hate windows 
7 never had any word programs hate vista so explain if you dare; you'd be the 
first why the word programs hate win 7 and why no one but no one has a fix; 
this i got to hear. 
  
How do i turn off file extensions in windows 7 64 bit   -  later . .  
 
--- On Sun, 10/14/12, Andreas Säger [via Document Foundation Mail Archive] 
[hidden email] wrote: 
 
 
From: Andreas Säger [via Document Foundation Mail Archive] [hidden email] 
Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 4:28 AM 
 
 
Am 14.10.2012 10:10, Lostsoul wrote: 
      Ok now what the crap; why are abiword documents being saved as adobi 
 docs how do i fix that can t get anything right crap .   -  later 
 
 
I strongly recommend some computer crash curse. File name associations 
are free.  There is nothing hard wired to the system. You can open any 
file with any program you want. You can tell your desktop environment 
which programs can open which types of files and which single program is 
the preferred one to be used on double-click. 
First of all, any user who is 

Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . .

2012-10-15 Thread Robert Burns
 H E L L O   should i re post answers to yours and others questions;  are 
did you find it yet i assume others have answer but for some weird reason you 
don t   ? ? ? 

--- On Mon, 10/15/12, Tom Davies tomdavie...@yahoo.co.uk wrote:


From: Tom Davies tomdavie...@yahoo.co.uk
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . .
To: Lostsoul joyseyh...@yahoo.com, users@global.libreoffice.org 
users@global.libreoffice.org
Date: Monday, October 15, 2012, 8:53 AM




Hi :)
Any chance of getting some answers to some of the questions people here have 
asked?
Regards from
Tom :)  










From: Lostsoul joyseyh...@yahoo.com
To: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 13:46
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x . .

 Ohh getting some weird lines that floats next to the arrow or its more 
like an oversized i whats that about and how do i get rid of it ?   -   later . 
. .

--- On Mon, 10/15/12, Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013421...@n3.nabble.com wrote:


From: Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013421...@n3.nabble.com
Subject: Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Date: Monday, October 15, 2012, 8:16 AM


Hi :) 
Did you uninstall all versions of 'LO' that you got from some freeware site 
and do an antivirus scan?  Did you download the 3.5.6 or 3.6.something LO from 
the official site and install as advised?  

Is there any chance of giving us a screen-shot? 

Also, just out of curiosity, have you used Win7 on any machine other than your 
own?  Has anyone else used your machine that might have some familiarity with 
Win7 when it's properly installed?  Did you install Win7 or was it already on 
the machine when you bought it?  

Btw Abiword can save files in MS formats but you have to do 
File - Save As ... 
You can't set it to default to MS formats.  I tried nagging them about it but 
gave up.  The native format it uses is the OpenDocument Format, same as LO, 
same as almost every other word-processing program except MS and even they 
purport to support it as a non-native format.  So, people using MS Office 
'should' be able to open your documents created in AbiWord.  I did mention all 
this when i made some suggestions about what other free word-processors were 
out there although not in as much detail.  

Regards from 
Tom :)  






 
 From: Lostsoul [hidden email] 
To: [hidden email] 
Sent: Monday, 15 October 2012, 5:04 
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x 
 
Ok whats going on now when i move my mouse about a blank page i get 5 lines to 
the right of the i line which is the pointer hope that makes sense; how do i 
end that ?  
 
--- On Sun, 10/14/12, Tom [via Document Foundation Mail Archive] [hidden 
email] wrote: 
 
 
From: Tom [via Document Foundation Mail Archive] [hidden email] 
Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 3:15 PM 
 
 
Hi :) 
To get back to factory defaults and 'switch off' all Extensions just rename 
your User Profile.  Larry gave a link to help with that.  Here is another link 
that will one day be merged with the one Larry gave 
http://wiki.documentfoundation.org/Documentation/UserProfile
 
Factory defaults are possibly a bit less tweaked than whatever you had 
installed so it may look a little different and may remove some weirdnesses.  
It's a good thing to try whenever you find weird things going on.  It usually 
beats a reinstall assuming you have now installed a proper version of LO.  
 
Regards from 
Tom :)  
 
 
--- On Sun, 14/10/12, Lostsoul [hidden email] wrote: 
 
From: Lostsoul [hidden email] 
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x 
To: [hidden email] 
Date: Sunday, 14 October, 2012, 9:37 
 
 Haha very funny that know one can tell me why word problems hate windows 
7 never had any word programs hate vista so explain if you dare; you'd be the 
first why the word programs hate win 7 and why no one but no one has a fix; 
this i got to hear. 
  
How do i turn off file extensions in windows 7 64 bit   -  later . .  
 
--- On Sun, 10/14/12, Andreas Säger [via Document Foundation Mail Archive] 
[hidden email] wrote: 
 
 
From: Andreas Säger [via Document Foundation Mail Archive] [hidden email] 
Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 4:28 AM 
 
 
Am 14.10.2012 10:10, Lostsoul wrote: 
      Ok now what the crap; why are abiword documents being saved as adobi 
 docs how do i fix that can t get anything right crap .   -  later 
 
 
I strongly recommend some computer crash curse. File name associations 
are free.  There is nothing hard wired to the system. You can open any 
file with any program you want. You can tell your desktop environment 
which programs can open which 

Re: [libreoffice-users] Re: Auto and Manual Spell do not work x

2012-10-15 Thread Tom Davies
Hi :)
Thanks :)

Ok, deleting a thing doesn't always uninstall it in Windows.  I think it works 
in Wine but not Windows.  (errr Wine stands for Wine Is Not an Emulator 
because it is a far more sophisticated way of getting Windows programs running 
on non-MS platforms).  So can you open the Add/remove programs thing in 
Win7?  it's a real pain to try to find it.  I tend to stumble onto it by 
accident and then quickly do everything i can that i need to before i lose it 
again.  It might be that when you say you have deleted programs you have been 
using the right tool, especially if you have much experience with Vista (which 
i mostly managed to dodge).  

So, when you say you deleted the programs was that by dragdropping them into 
the wastebin or right-clicking on the program folde and choosing delete or did 
you find some weird gui that looked a bit like a normal folder with odd things 
in it?


Ok, so if Win7 was pre-installed then we can kinda rule that out of the 
equation for now.  The way you were talking about it made it sound like you had 
bought a Win7 Dvd and installed it yourself without having had much experience 
of doing that sort of thing.  It's not as easy as people make out!  So, we can 
definitely rule out needing to install Ubuntu just in order to make sure you 
have a working OS on your machine at this stage!!  


Ok, so when we say to rename the user profile that is only the user profile 
for LO, not for Win7!  Each program tends to have it's own way of storing all 
those settings and configurations.  They all tend to store them separately and 
most have different ideas of what are the best ways of doing it.  Some allow 
users to go in and mess around with stuff but others really freak out and cause 
problems!  

Most OpenSource programs tend to use the same folder to set-up a sub-folder for 
themselves.  Then inside that folder they may only have a little text-file that 
you can read and maybe even edit with Notepad!  LibreOffice tends to have tons 
of stuff in there so they have a number of sub-folders inside their main 
sub-folder = such as one sub-sub-folder to contain all Extensions, another for 
back-ups, another for galleries of images, another for templates and so on.  If 
you rename the main sub-folder and then open LibreOffice again it will 
automatically create a new one with all the default settings.  Of course since 
you only renamed rather than deleted it you can always copy some of those 
sub-sub-folders back to regain settings and see if it was that sub-sub-folder 
that was causing the problem.  Many of us try to create a copy of a working 
sub-folder in order to be able to quickly revert to a working system if one of 
our users has done something crazy
 or had an accident.  

Ok, so navigate to 

C:\Users\user name\AppData\Roaming\config\LibreOffice\3

When you were in the \config part of that you might have noticed other folders 
alongside the LO one.  Programs such as Firefox, hmmm, well Firefox is run by 
the Mozilla Foundation and they have a few programs so they tend to put one 
sub-folder called Mozilla and then create a sub-sub-folder in their each time 
you install one of their other programs.  

My usual prefered way is to rename the 3 folder to todays date written 
backwards.  Some people just rename it to backup or some-such but then they 
don't always know which is the one that caused tons of problems and which is 
their real back-up [shrugs].  So once you have renamed

C:\Users\user name\AppData\Roaming\config\LibreOffice\3

to be

C:\Users\user name\AppData\Roaming\config\LibreOffice\somethingelse

then make sure you have closed any documents and all other open instances of 
LibreOffice and then try opening a document or just open LibreOffice.  
Hopefully problems will have magically vanished but please let us know.  

Regards from
Tom :)  






 From: Robert Burns joyseyh...@yahoo.com
To: users@global.libreoffice.org users@global.libreoffice.org; Tom Davies 
tomdavie...@yahoo.co.uk 
Sent: Monday, 15 October 2012, 13:36
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x
 
   Not using libre from free sites because they are 28 or 125 mb in size so i 
deleted those now using the full version 220 mb version  3.6.6. but thinking 
of trying 3.5.4 since some think that s the best version to try with windows 7 
but trying abiword and I B M lotus and 
Kingsoft  maybe they won t throw fits at windows 7 so no hurry to reset w7; 
libre needs fixing not windows 7 .
 
Windows 7 came with the lap top; when i use save as i have 7 choices so which 
is the best to use; save as with libre and can i get a save doc format 
switched over to saved as; and would libre stop having win7 fits i wonder .
 
And a screen shot of what ? ?   Whew  later .  .  .
 

--- On Mon, 10/15/12, Tom Davies tomdavie...@yahoo.co.uk wrote:


From: Tom Davies tomdavie...@yahoo.co.uk
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell 

Re: [libreoffice-users] Reality Check - Windows Java Accessibility API non-functional for ALL LibreOffice 3.6.x releases to date

2012-10-15 Thread Tom Davies
Hi :)
Is anyone able to post a bug-report about this?  It sounds pretty serious!
Regards from
Tom :)  






 From: V Stuart Foote vstuart.fo...@utsa.edu
To: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 1:11
Subject: [libreoffice-users] Reality Check - Windows Java Accessibility API 
non-functional for ALL LibreOffice 3.6.x releases to date
 

LibreOffice versions 3.6.0 and later have not correctly implemented the Java 
Access Bridge (JAB) modules used to expose the Java Accessibility API roles 
for Windows users.

It took me a little while to work out the testing methods, but the Oracle test 
utilities JavaFerret-32 and JavaMonkey-32 show that LibreOffice is not 
implementing the Java Accessibility API and therefore does not expose 
accessibility roles to Assistive Technologies.

Neither JAB v.2.0.2 or v 2.0.3, nor current JRE version 1.6u35 or 1.7u7 will 
make a difference.

I tested LibreOffice builds 3.6.0.4, 3.6.1.2, 3.6.2.2, and 3.6.3.1 none of 
which are functional.

In addition today I completed testing of ALL builds of LibreOffice from 3.4.5 
to 3.5.7rc2.  With exception of the 3.5.0 build they all correctly map Java 
Accessibility API roles to UNO Accessibility roles. 

The Java Accessibility API is not as comprehensive as the IAccessible2 role 
mappings provided by IBM Lotus Symphony 3.0.1, but it is functional for the 
3.4 and 3.5 releases of LibreOffice.  And, for these versions Windows  
Assistive Technologies will work. For example, the Windows NVDA screen reader 
will function with cursor control and component announcements for the entire 
document tree.

Windows versions of LibreOffice 3.6, including the current build 3.6.3 rc1, 
are NOT USEABLE with Assistive Technologies and they have not been usable with 
Windows Assistive Technologies at any point.

For folks that I've mislead with my insistence that all is well with 
LibreOffice 3.6 and Java Access Bridge and JRE with use of Assistive 
Technologies like NVDA screen reader I was wrong--I apologize.
I've updated the FDO#53474 (http:  bug report 
https://bugs.freedesktop.org/show_bug.cgi?id=53474 ) and would encourage folks 
to vote, i.e. comment on, the enhancement to implement IAccessible2 API  ( 
http://wiki.documentfoundation.org/Vote_for_Enhancement ) for Windows builds 
by incorporating the IBM contributed Symphony code base as a replacement of 
the Java Accessibility API as that is probably the fastest means of bringing 
Windows builds of LibreOffice to the same functional level as Linux builds 
that use the ATK AT-SPI accessibility APIs.

Stuart

-- 
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] Re: LibreOffice in MacWorld Australia

2012-10-15 Thread Fabian Rodriguez

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Le 12-10-11 06:48 PM, Andreas Säger a écrit :
 Am 11.10.2012 20:46, webmaster-Kracked_P_P wrote:

 [...]

 It would be nice to have a booth in a Windows version of the big
 software shows that happen for Linux and Mac. But those booths may be
 very expensive to rent for such an event.


 Windows users can run MS Office easily and for little money (if any).
Why should they use LibreOffice if all they want is cheap MS Office?
Idealism? Masochism?

Mostly, common sense.

F.

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: PGP/Mime available upon request
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iEYEARECAAYFAlB8EqwACgkQfUcTXFrypNWw2gCfT64cYQ08K969kDfpt8NhvjFT
gFkAoIe6tpndxN8sf7XrvVcf35bwrh6B
=uFYb
-END PGP SIGNATURE-


-- 
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: how to delete an entire heading

2012-10-15 Thread rost52
Good to know that you also could not delete a heading with all stuff
below in one shot .This leaves the conclusion that this topic should be put 
forward as
an enhancement request. The request should be the procedure Tink
mentioned earlier and/or deleting the heading incl all things below
in the navigator.Shift-click just selects between the cursor and the 
shift-click
point. A pity but a kind of a temporal solution for the time being.
Thanks for this hint.How to place an enhancement request?On 15.10.2012 
21:34, Tom Davies wrote:
Hi :)I couldn't get this to work either way around either (ie not
with headings (although mine are probably stuffed-up somehow)
and not with the header (which i know i stuff-up).I think i
would have to read up documentation about 
ithttp://wiki.documentfoundation.org/Documentation/PublicationsIt looks like 
something that would be hugely useful if you
already knew how to use it but i don't so i would stick with 
theShiftclickmethod that works in almost all other apps even non-LO 
ones.Regards fromTom :)
From:rost52bugquestcon...@online.deto:Steve 
Edmondssteve.edmonds@ptglobal.comCc:users@global.libreoffice.orgusers@global.libreoffice.orgSent:Monday,
 15 October 2012, 4:26Subject:Re: [libreoffice-users] Re: how to delete an 
entire
heading
Steve, Thanks for pointing this out. I immediately
tested also on the header (at the top of each page to be
precise) and there too I could not apply Tink's
suggestion.Let's see what will come later the day.On 15.10.2012 
11:36, Steve Edmonds wrote:Hi.I think there may be a crossed wire between header
(at the top of the page) and heading (at the top of a
paragraph).SteveOn 2012-10-15 15:14, rost52 wrote:Tink, thanks 
for the hint but it doesn't work.I clicked in the header line.Right click menu 
opens but doesn't show a menu
item: Remove (or similar)Is there a basic setting needed?Tom, 
could you successfully apply this method?On 15.10.2012 03:20, Tinkerer 
wrote:Put the cursor in the Header then right
click, from the menu, choose, RemoveHeader.You then have a 
choice, Delete header,
Delete Header and Text.Tink.-- View this message in 
context:http://nabble.documentfoundation.org/how-to-delete-an-entire-heading-tp4013210p4013288.htmlSent
 from the Users mailing list archive at
Nabble.com.-- For unsubscribe instructions e-mail to: 
users+help@global.libreoffice.orgProblems?http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/Posting
 guidelines + more:http://wiki.documentfoundation.org/NetiquetteList 
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] how to crack a PW in LO?

2012-10-15 Thread rost52
LO files can be protected with PWs when doing save as.
Fighting currently with an xls file and its lost PW, I wonder how LO files can 
be cracked? Can the
MS related PW remover be used for LO as well?
Thanks in advance for comments.


-- 
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: how to delete an entire heading

2012-10-15 Thread Tom Davies
Hi :)
I think this guide might help
http://wiki.documentfoundation.org/Bug_Report

If you can't find a drop-down that has feature request (or even if you can) 
then it might be good to add this into the subject-line
[feature request]
(preferably at the beginning)

Personally i wouldn't bother becasue it's not something i desperately need 
because the shiftclick option is plenty for me.  Also i suspect the reason it 
wont work for me is that i probably stuffed-up in the documents somewhere.  
Regards from
Tom :)  







 From: rost52 bugquestcon...@online.de
To: Tom Davies tomdavie...@yahoo.co.uk 
Cc: Steve Edmonds steve.edmo...@ptglobal.com; users@global.libreoffice.org 
users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 14:44
Subject: Re: [libreoffice-users] Re: how to delete an entire heading
 

Good to know that you also could not delete a heading with all stuff below in 
one shot .

This leaves the conclusion that this topic should be put forward as
an enhancement request. The request should be the procedure Tink
mentioned earlier and/or deleting the heading incl all things below
in the navigator.

Shift-click just selects between the cursor and the shift-click
point. A pity but a kind of a temporal solution for the time being.
Thanks for this hint.

How to place an enhancement request?


On 15.10.2012 21:34, Tom Davies wrote:

Hi :)
I couldn't get this to work either way around either (ie not
with headings (although mine are probably stuffed-up somehow)
and not with the header (which i know i stuff-up).  I think i
would have to read up documentation about it
http://wiki.documentfoundation.org/Documentation/Publications

It looks like something that would be hugely useful if you
already knew how to use it but i don't so i would stick with the 
Shiftclick 
method that works in almost all other apps even non-LO ones.
Regards from
Tom :)  







 From: rost52 bugquestcon...@online.de
To: Steve Edmonds steve.edmo...@ptglobal.com 
Cc: users@global.libreoffice.org users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 4:26
Subject: Re: [libreoffice-users] Re: how to delete an entire heading
 
Steve, Thanks for pointing this out. I immediately
tested also on the header (at the top of each page to be
precise) and there too I could not apply Tink's
suggestion.
Let's see what will come later the day.

On 15.10.2012 11:36, Steve Edmonds wrote:
 Hi.
 I think there may be a crossed wire between header
(at the top of the page) and heading (at the top of a
paragraph).
 Steve
 
 On 2012-10-15 15:14, rost52 wrote:
 Tink, thanks for the hint but it doesn't work.
 I clicked in the header line.
 Right click menu opens but doesn't show a menu
item: Remove (or similar)
 Is there a basic setting needed?
 
 Tom, could you successfully apply this method?
 
 
 On 15.10.2012 03:20, Tinkerer wrote:
 Put the cursor in the Header then right
click, from the menu, choose, Remove
 Header.
 You then have a choice, Delete header,
Delete Header and Text.
 
 Tink.
 
 
 
 -- View this message in context: 
 http://nabble.documentfoundation.org/how-to-delete-an-entire-heading-tp4013210p4013288.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] Re: Auto and Manual Spell do not work x . . .

2012-10-15 Thread Tom Davies
Hi :)
Hmmm, none of those sound even vaguely right.  Hopefully there are some more 
options if ou scroll backwards up the list?  
Regards from
Tom :)   






 From: Robert Burns joyseyh...@yahoo.com
To: anne-ology lagin...@gmail.com 
Cc: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 0:44
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . .
 
 Ok trying saved  as but i see 6 choices so wondering whats the difference 
and which is better and does libre like one format above all ?
 
  RTF /  Text ? Html /  MHT /  WPt  and   WPS  . . .

--- On Sun, 10/14/12, anne-ology lagin...@gmail.com wrote:


From: anne-ology lagin...@gmail.com
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Cc: users@global.libreoffice.org
Date: Sunday, October 14, 2012, 7:17 PM


   When you save the document, click on 'save as' rather than 'save' -
          when you see the boxes come up, choose the suffix desired, then 
choose the folder desired; simple.




On Sun, Oct 14, 2012 at 6:06 PM, Lostsoul joyseyh...@yahoo.com wrote:


 Ok will try that but can i get a save doc switched over to save as and 
then choose a better format or maybe i ll try all saved as formats ? ?



From: anne-ology [via Document Foundation Mail Archive] 
ml-node+s969070n4013327...@n3.nabble.com

Subject: Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Date: Sunday, October 14, 2012, 7:02 PM



       A simple solution is to always use 'save as' rather than 'save' -
           then you merely choose the desired suffix as well as the desired
folder;
       with 'save', the computer does its own thing  ;-)





On Sun, Oct 14, 2012 at 3:27 AM, Andreas Säger [hidden email] wrote:

Am 14.10.2012 10:10, Lostsoul wrote:

       Ok now what the ***; why are abiword documents being saved as adobi
 docs how do i fix that can t get anything right *** .   -  later
 

 I strongly recommend some computer crash course. File name associations
 are free.  There is nothing hard wired to the system. You can open any
 file with any program you want. You can tell your desktop environment
 which programs can open which types of files and which single program is
 the preferred one to be used on double-click.
 First of all, any user who is forced to use MS Windows should turn off
 the option to hide known file name extensions. Since Windows '95 this is
 the major obstacle which prevents people from understanding their system.


-- 
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] Re: Auto and Manual Spell do not work x

2012-10-15 Thread Robert Burns
 
Ok, deleting a thing doesn't always uninstall it in Windows. I think it works 
in Wine but not Windows. (errr Wine stands for Wine Is Not an Emulator 
because it is a far more sophisticated way of getting Windows programs running 
on non-MS platforms). So can you open the Add/remove programs thing in Win7? 
it's a real pain to try to find it. I tend to stumble onto it by accident and 
then quickly do everything i can that i need to before i lose it again. It 
might be that when you say you have deleted programs you have been using the 
right tool, especially if you have much experience with Vista (which i mostly 
managed to dodge). 

So, when you say you deleted the programs was that by dragdropping them into 
the wastebin or right-clicking on the program folde and choosing delete or did 
you find some weird gui that looked a bit like a normal folder with odd things 
in it?

 Ok amazing how you get so bloody off track i deleted the libre versions that 
 are not full size and where do the hell do anything on  normal folders with 
 odd things in it   How dare you be so crazed and bring that up are 
 you on drugs? and i delete from add/delete in the control panel . .
 
Ok, so if Win7 was pre-installed then we can kinda rule that out of the 
equation for now. The way you were talking about it made it sound like you had 
bought a Win7 Dvd and installed it yourself without having had much experience 
of doing that sort of thing. It's not as easy as people make out! So, we can 
definitely rule out needing to install Ubuntu just in order to make sure you 
have a working OS on your machine at this stage!! 

 How can you get so mixed up and so off track amazing very scary .
 
C:\Users\user name\AppData\Roaming\config\LibreOffice\3   i copyed than 
pasted into search and nothing came up; folder not found; used to getting that 
so has to done the hard way but no hurry - whew later . .

 
 
 
 
 
 


--- On Mon, 10/15/12, Tom Davies tomdavie...@yahoo.co.uk wrote:


From: Tom Davies tomdavie...@yahoo.co.uk
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x
To: Robert Burns joyseyh...@yahoo.com, users@global.libreoffice.org 
users@global.libreoffice.org
Date: Monday, October 15, 2012, 9:31 AM




Hi :)
Thanks :)

Ok, deleting a thing doesn't always uninstall it in Windows.  I think it works 
in Wine but not Windows.  (errr Wine stands for Wine Is Not an Emulator 
because it is a far more sophisticated way of getting Windows programs running 
on non-MS platforms).  So can you open the Add/remove programs thing in 
Win7?  it's a real pain to try to find it.  I tend to stumble onto it by 
accident and then quickly do everything i can that i need to before i lose it 
again.  It might be that when you say you have deleted programs you have been 
using the right tool, especially if you have much experience with Vista (which 
i mostly managed to dodge).  

So, when you say you deleted the programs was that by dragdropping them into 
the wastebin or right-clicking on the program folde and choosing delete or did 
you find some weird gui that looked a bit like a normal folder with odd things 
in it?


Ok, so if Win7 was pre-installed then we can kinda rule that out of the 
equation for now.  The way you were talking about it made it sound like you had 
bought a Win7 Dvd and installed it yourself without having had much experience 
of doing that sort of thing.  It's not as easy as people make out!  So, we can 
definitely rule out needing to install Ubuntu just in order to make sure you 
have a working OS on your machine at this stage!!  


Ok, so when we say to rename the user profile that is only the user profile 
for LO, not for Win7!  Each program tends to have it's own way of storing all 
those settings and configurations.  They all tend to store them separately and 
most have different ideas of what are the best ways of doing it.  Some allow 
users to go in and mess around with stuff but others really freak out and cause 
problems!  

Most OpenSource programs tend to use the same folder to set-up a sub-folder for 
themselves.  Then inside that folder they may only have a little text-file that 
you can read and maybe even edit with Notepad!  LibreOffice tends to have tons 
of stuff in there so they have a number of sub-folders inside their main 
sub-folder = such as one sub-sub-folder to contain all Extensions, another for 
back-ups, another for galleries of images, another for templates and so on.  If 
you rename the main sub-folder and then open LibreOffice again it will 
automatically create a new one with all the default settings.  Of course since 
you only renamed rather than deleted it you can always copy some of those 
sub-sub-folders back to regain settings and see if it was that sub-sub-folder 
that was causing the problem.  Many of us try to create a copy of a working 
sub-folder in order to be able to quickly revert to a working system if one of 
our users has done something crazy
 or 

Fw: [libreoffice-users] Re: Auto and Manual Spell do not work _ _

2012-10-15 Thread VA



-Original Message- 
From: VA

Sent: Monday, October 15, 2012 9:55 AM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work _ _

Dear Lost Soul,

I may regret trying to be helpful, but let me share a similar experience I
recently had with Apache OpenOffice.

I have been using OpenOffice since version 1.0 and StarOffice before that.
In December, 2010, I got a Sony Win7 laptop. I never had a problem with
OpenOffice on my Win7 machine.

Then came the great Oracle/TDF schism and LibreOffice was born. I downloaded
LibreOffice and began using it, again without any problems with my Win7
machine.

About a year later, Apache finally came out with its version of OpenOffice.
I downloaded it to my Win7 computer, and that's when my spelling problems
began. Now, remember that I had had previous versions of OpenOffice on my
computer and, when I downloaded the new Apache OpenOffice, I hadn't made any
changes to my user profile. It was the same user profile that dated back to
OpenOffice 3.0.

My spelling problem was different than yours, but I think they might have a
similar cause (but, remember, I'm not a geek, just a user). In my case,
Apache OpenOffice simply refused to recognize the English(USA) dictionary.
It reported every word as being misspelled. It also refused to hyphenate any
word. The program said that the dictionary was in place; it just refused to
apply it.

I tried downloading new English(USA) dictionary files and that didn't work.
So finally, I cursed the Apache folks for offering a defective product, and
uninstalled the program.

Now, when a program is uninstalled, Windows does NOT uninstall local
configuration files. So every time you uninstall/reinstall or upgrade to a
newer version, the new program will simply load on top of the old user
configuration files.

So, as a last ditch attempt, after uninstalling Apache OpenOffice, I decided
to completely delete my configuration folder. On my computer, the OpenOffice
configuration folder was found in:
c:\users\username\appdata\roaming\openoffice.org\3\. (The files for
LibreOffice would be in a similar folder named
c:\users\username\appdata\roaming\libreoffice\3\.

I completely deleted the folder at the openoffice.org level. This meant
the computer deleted the openoffice.org folder, along with the subfolder 3
and all subfolders below that.

I then reinstalled Apache OpenOffice and, since then, I haven't had a
problem with the spell checker. It works just fine.

Now, I run both Apache OpenOffice and LibreOffice. I figure that, over time,
one of the programs will clearly outshine the other in terms of the features
I prefer and then I can use only one. But, for now, I bounce back and forth
between the two. (Sometimes, I'll even use Lotus Symphony, another fork of
OpenOffice. I really like its tabbed interface, and I can't understand why
neither Apache nor Libre have adopted it.)

So, Lost Soul, or anyone else with similar problems, don't forget the user
configuration folders. For me, it worked to delete them entirely and start
over. There may be better solutions; for me, I lost all my templates and
styles, etc., but since I use similar templates and styles in Libre, I was
able to recreate everything fairly easily.

Virgil

-Original Message- 
From: Felmon Davis

Sent: Sunday, October 14, 2012 6:35 AM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work _ _

On Sun, 14 Oct 2012, Lostsoul wrote:

  Ok why have i never had a word problem with vista but since i have 
had win 7 64 bit for 2 months now on a lap top; Asus to be exact i can t 
get any word programs spell / grammer check to work for me yet ?  ?


   Seems like spell check works with one word then a second word but 
can t find four or five mis spelled words in a doc that i close then i 
open some days later and sees no mis spelled words ? ?


  I wonder if spell grammer checkers that come with word programs for win 
7 can t do both that is underline a mis spelled word as you type and 
correct or underline then the user manually corrects it and then i assume 
it should correct mis spelled words after i reopen a saved doc;  i always 
though it could do both but on win 7 can t figure out how to get that to 
happen.
It works both ways on vista but can t get it to work both ways on win 7 
yet; hum wonder if word programs need that red underline for any spell 
checking; and the lines aren t saving for win 7 so that leaves spell check 
clueless on a saved doc?


 How was that a serious question;  Ok  -  Later


no, not at all a serious question; for one thing, you already know you
are over-generalizing since you know not everyone has your problem. I
certainly have no idea how frequent your problem (or problems) are and
you don't seem to know either.

but sorry I brought up the 'serious question' issue. can we have a
sense of where things actually stand? in particular I wonder when you

[libreoffice-users] Re: Integer part of a number

2012-10-15 Thread Andreas Säger
Am 15.10.2012 10:45, Brian Barker wrote:
 At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote:
 On 14.10.2012 12:20, Gilles SICHE wrote:
 could anyone tell me which formula I should use for the integer part
 of a cell to be shown in another cell, ...

 The answer could be:
 =IF(C31;0;INT(C3))
 
 You are overthinking the problem: if C3 is positive, that's no different
 from
 =INT(C3)
 
 Brian Barker
 
 

Reportedly, negative numbers do exist.


-- 
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: Auto and Manual Spell do not work x . . .

2012-10-15 Thread Robert Burns
 Ok  tryed another doc to save as; guess its a different format and these 
formats have been add ed to save as ODI  and  Cxw  and  Stw and 5 types/formats 
of Ms Word  . .

--- On Mon, 10/15/12, Tom Davies tomdavie...@yahoo.co.uk wrote:


From: Tom Davies tomdavie...@yahoo.co.uk
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . .
To: Robert Burns joyseyh...@yahoo.com, anne-ology lagin...@gmail.com
Cc: users@global.libreoffice.org users@global.libreoffice.org
Date: Monday, October 15, 2012, 9:54 AM




Hi :)
Hmmm, none of those sound even vaguely right.  Hopefully there are some more 
options if ou scroll backwards up the list?  
Regards from
Tom :)   









From: Robert Burns joyseyh...@yahoo.com
To: anne-ology lagin...@gmail.com 
Cc: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 0:44
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . .

 Ok trying saved  as but i see 6 choices so wondering whats the difference 
and which is better and does libre like one format above all ?
 
  RTF /  Text ? Html /  MHT /  WPt  and   WPS  . . .

--- On Sun, 10/14/12, anne-ology lagin...@gmail.com wrote:


From: anne-ology lagin...@gmail.com
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Cc: users@global.libreoffice.org
Date: Sunday, October 14, 2012, 7:17 PM


   When you save the document, click on 'save as' rather than 'save' -
          when you see the boxes come up, choose the suffix desired, then 
choose the folder desired; simple.




On Sun, Oct 14, 2012 at 6:06 PM, Lostsoul joyseyh...@yahoo.com wrote:


 Ok will try that but can i get a save doc switched over to save as and 
then choose a better format or maybe i ll try all saved as formats ? ?



From: anne-ology [via Document Foundation Mail Archive] 
ml-node+s969070n4013327...@n3.nabble.com

Subject: Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Date: Sunday, October 14, 2012, 7:02 PM



       A simple solution is to always use 'save as' rather than 'save' -
           then you merely choose the desired suffix as well as the desired
folder;
       with 'save', the computer does its own thing  ;-)





On Sun, Oct 14, 2012 at 3:27 AM, Andreas Säger [hidden email] wrote:

Am 14.10.2012 10:10, Lostsoul wrote:

       Ok now what the ***; why are abiword documents being saved as adobi
 docs how do i fix that can t get anything right *** .   -  later
 

 I strongly recommend some computer crash course. File name associations
 are free.  There is nothing hard wired to the system. You can open any
 file with any program you want. You can tell your desktop environment
 which programs can open which types of files and which single program is
 the preferred one to be used on double-click.
 First of all, any user who is forced to use MS Windows should turn off
 the option to hide known file name extensions. Since Windows '95 this is
 the major obstacle which prevents people from understanding their system.


-- 
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] Re: Integer part of a number

2012-10-15 Thread John Clegg
Indeed. Which is why your last answer is also wrong!

On 15 October 2012 15:08, Andreas Säger ville...@t-online.de wrote:

 Am 15.10.2012 10:45, Brian Barker wrote:
  At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote:
  On 14.10.2012 12:20, Gilles SICHE wrote:
  could anyone tell me which formula I should use for the integer part
  of a cell to be shown in another cell, ...
 
  The answer could be:
  =IF(C31;0;INT(C3))
 
  You are overthinking the problem: if C3 is positive, that's no different
  from
  =INT(C3)
 
  Brian Barker
 
 

 Reportedly, negative numbers do exist.


 --
 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] Re: Auto and Manual Spell do not work x

2012-10-15 Thread Tom Davies
Hi :)
Errr, username would need to be replaced by whatever name it is that you are 
logged in as.  

I'm not completely sure why you are searching for it except that it's the most 
difficult way of trying to find it.  Just go into My Computer, open the C: 
drive and find the Users folder.  Double-click on that and then you will see 
a list of 'Users' although some of them may be just things created by the 
system rather than being real people.  Hopefully one of them will stand out as 
being someone you recognise.  After that it should be fairly easy to navigate 
fairly quickly since folders are probably sorted in alphabetical order by 
default.  

Regards from
Tom :)  






 From: Robert Burns joyseyh...@yahoo.com
To: users@global.libreoffice.org users@global.libreoffice.org; Tom Davies 
tomdavie...@yahoo.co.uk 
Sent: Monday, 15 October 2012, 15:00
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x
 
 
Ok, deleting a thing doesn't always uninstall it in Windows. I think it works 
in Wine but not Windows. (errr Wine stands for Wine Is Not an Emulator 
because it is a far more sophisticated way of getting Windows programs running 
on non-MS platforms). So can you open the Add/remove programs thing in Win7? 
it's a real pain to try to find it. I tend to stumble onto it by accident and 
then quickly do everything i can that i need to before i lose it again. It 
might be that when you say you have deleted programs you have been using the 
right tool, especially if you have much experience with Vista (which i mostly 
managed to dodge). 

So, when you say you deleted the programs was that by dragdropping them into 
the wastebin or right-clicking on the program folde and choosing delete or did 
you find some weird gui that looked a bit like a normal folder with odd things 
in it?

 Ok amazing how you get so bloody off track i deleted the libre versions that 
 are not full size and where do the hell do anything on  normal folders with 
 odd things in it   How dare you be so crazed and bring that up are 
 you on drugs? and i delete from add/delete in the control panel . .
 
Ok, so if Win7 was pre-installed then we can kinda rule that out of the 
equation for now. The way you were talking about it made it sound like you had 
bought a Win7 Dvd and installed it yourself without having had much experience 
of doing that sort of thing. It's not as easy as people make out! So, we can 
definitely rule out needing to install Ubuntu just in order to make sure you 
have a working OS on your machine at this stage!! 

 How can you get so mixed up and so off track amazing very scary .
 
C:\Users\user name\AppData\Roaming\config\LibreOffice\3   i copyed than 
pasted into search and nothing came up; folder not found; used to getting that 
so has to done the hard way but no hurry - whew later . .

 
 
 
 
 
 


--- On Mon, 10/15/12, Tom Davies tomdavie...@yahoo.co.uk wrote:


From: Tom Davies tomdavie...@yahoo.co.uk
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x
To: Robert Burns joyseyh...@yahoo.com, users@global.libreoffice.org 
users@global.libreoffice.org
Date: Monday, October 15, 2012, 9:31 AM




Hi :)
Thanks :)

Ok, deleting a thing doesn't always uninstall it in Windows.  I think it works 
in Wine but not Windows.  (errr Wine stands for Wine Is Not an Emulator 
because it is a far more sophisticated way of getting Windows programs running 
on non-MS platforms).  So can you open the Add/remove programs thing in 
Win7?  it's a real pain to try to find it.  I tend to stumble onto it by 
accident and then quickly do everything i can that i need to before i lose it 
again.  It might be that when you say you have deleted programs you have been 
using the right tool, especially if you have much experience with Vista (which 
i mostly managed to dodge).  

So, when you say you deleted the programs was that by dragdropping them into 
the wastebin or right-clicking on the program folde and choosing delete or did 
you find some weird gui that looked a bit like a normal folder with odd things 
in it?


Ok, so if Win7 was pre-installed then we can kinda rule that out of the 
equation for now.  The way you were talking about it made it sound like you 
had bought a Win7 Dvd and installed it yourself without having had much 
experience of doing that sort of thing.  It's not as easy as people make out!  
So, we can definitely rule out needing to install Ubuntu just in order to make 
sure you have a working OS on your machine at this stage!!  


Ok, so when we say to rename the user profile that is only the user profile 
for LO, not for Win7!  Each program tends to have it's own way of storing all 
those settings and configurations.  They all tend to store them separately and 
most have different ideas of what are the best ways of doing it.  Some allow 
users to go in and mess around with stuff but others really freak out and 
cause problems!  

Most 

[libreoffice-users] Re: how to crack a PW in LO?

2012-10-15 Thread Andreas Säger
Am 15.10.2012 15:49, rost52 wrote:
 LO files can be protected with PWs when doing save as.
 Fighting currently with an xls file and its lost PW, I wonder how LO files 
 can be cracked? Can the
 MS related PW remover be used for LO as well?
 Thanks in advance for comments.
 
 


xls does not encript your document. The only thing that gets encrypted
is the password. Any old version of OpenOffice.org opens a password
protected xls ignoring the password.



-- 
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] Indexing for Search not working?

2012-10-15 Thread teatimest
I've been using v3.4 of LibreOffice. I updated to v3.6.2.2 and now the
contents of documents are not indexed for search. 

I'm using 64-bit Windows 7. The extension odt is checked for the indexing
option. I also checked the Index Properties and File Contents in the
Indexing Option in Windows. 

When I search, doc files and ppt files appears in the result but not odt and
odp.

Is it just me or is this known bug? The same thing happened when I updated
to v3.5 so I went back to v3.4 for the searchability. Is there any
workaround?

Tea



--
View this message in context: 
http://nabble.documentfoundation.org/Indexing-for-Search-not-working-tp4013483.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: Auto and Manual Spell do not work x

2012-10-15 Thread Robert Burns
    whew will keep looking can t find it tired for now this can wait maybe 
other offices would throw fits with win 7  .  .  . 

--- On Mon, 10/15/12, Tom Davies tomdavie...@yahoo.co.uk wrote:


From: Tom Davies tomdavie...@yahoo.co.uk
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x
To: Robert Burns joyseyh...@yahoo.com, users@global.libreoffice.org 
users@global.libreoffice.org
Date: Monday, October 15, 2012, 10:13 AM




Hi :)
Errr, username would need to be replaced by whatever name it is that you are 
logged in as.  

I'm not completely sure why you are searching for it except that it's the most 
difficult way of trying to find it.  Just go into My Computer, open the C: 
drive and find the Users folder.  Double-click on that and then you will see 
a list of 'Users' although some of them may be just things created by the 
system rather than being real people.  Hopefully one of them will stand out as 
being someone you recognise.  After that it should be fairly easy to navigate 
fairly quickly since folders are probably sorted in alphabetical order by 
default.  

Regards from
Tom :)  










From: Robert Burns joyseyh...@yahoo.com
To: users@global.libreoffice.org users@global.libreoffice.org; Tom Davies 
tomdavie...@yahoo.co.uk 
Sent: Monday, 15 October 2012, 15:00
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x

 
Ok, deleting a thing doesn't always uninstall it in Windows. I think it works 
in Wine but not Windows. (errr Wine stands for Wine Is Not an Emulator 
because it is a far more sophisticated way of getting Windows programs running 
on non-MS platforms). So can you open the Add/remove programs thing in Win7? 
it's a real pain to try to find it. I tend to stumble onto it by accident and 
then quickly do everything i can that i need to before i lose it again. It 
might be that when you say you have deleted programs you have been using the 
right tool, especially if you have much experience with Vista (which i mostly 
managed to dodge). 

So, when you say you deleted the programs was that by dragdropping them into 
the wastebin or right-clicking on the program folde and choosing delete or did 
you find some weird gui that looked a bit like a normal folder with odd things 
in it?

 Ok amazing how you get so bloody off track i deleted the libre versions that 
 are not full size and where do the hell do anything on  normal folders with 
 odd things in it   How dare you be so crazed and bring that up are 
 you on drugs? and i delete from add/delete in the control panel . .
 
Ok, so if Win7 was pre-installed then we can kinda rule that out of the 
equation for now. The way you were talking about it made it sound like you had 
bought a Win7 Dvd and installed it yourself without having had much experience 
of doing that sort of thing. It's not as easy as people make out! So, we can 
definitely rule out needing to install Ubuntu just in order to make sure you 
have a working OS on your machine at this stage!! 

 How can you get so mixed up and so off track amazing very scary .
 
C:\Users\user name\AppData\Roaming\config\LibreOffice\3   i copyed than 
pasted into search and nothing came up; folder not found; used to getting that 
so has to done the hard way but no hurry - whew later . .

 
 
 
 
 
 


--- On Mon, 10/15/12, Tom Davies tomdavie...@yahoo.co.uk wrote:


From: Tom Davies tomdavie...@yahoo.co.uk
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x
To: Robert Burns joyseyh...@yahoo.com, users@global.libreoffice.org 
users@global.libreoffice.org
Date: Monday, October 15, 2012, 9:31 AM




Hi :)
Thanks :)

Ok, deleting a thing doesn't always uninstall it in Windows.  I think it works 
in Wine but not Windows.  (errr Wine stands for Wine Is Not an Emulator 
because it is a far more sophisticated way of getting Windows programs running 
on non-MS platforms).  So can you open the Add/remove programs thing in 
Win7?  it's a real pain to try to find it.  I tend to stumble onto it by 
accident and then quickly do everything i can that i need to before i lose it 
again.  It might be that when you say you have deleted programs you have been 
using the right tool, especially if you have much experience with Vista (which 
i mostly managed to dodge).  

So, when you say you deleted the programs was that by dragdropping them into 
the wastebin or right-clicking on the program folde and choosing delete or did 
you find some weird gui that looked a bit like a normal folder with odd things 
in it?


Ok, so if Win7 was pre-installed then we can kinda rule that out of the 
equation for now.  The way you were talking about it made it sound like you had 
bought a Win7 Dvd and installed it yourself without having had much experience 
of doing that sort of thing.  It's not as easy as people make out!  So, we can 
definitely rule out needing to install Ubuntu just in order to make sure you 
have a working OS on your machine at this stage!! 

Re: [libreoffice-users] Re: Integer part of a number

2012-10-15 Thread Brian Barker

At 14:42 15/10/2012 +0200, Andreas Säger wrote:

Am 15.10.2012 09:49, Pertti Rönnberg wrote:
if value in cell c3 is /_less than_/ '1' then 
d3 shall be '0', else (-- if c3 is '1' or 
bigger then -- ) use the integer of value in c3)


=MIN(0;INT(C3))


This is getting sillier!  This formula does not 
match the definition above - and indeed for 
non-negative C3 is identically zero!  Try

=0
instead.

Brian Barker


--
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: Integer part of a number

2012-10-15 Thread Brian Barker

At 16:08 15/10/2012 +0200, Andreas Säger wrote:

Am 15.10.2012 10:45, Brian Barker wrote:

At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote:

 On 14.10.2012 12:20, Gilles SICHE wrote:
could anyone tell me which formula I should 
use for the integer part of a cell to be shown in another cell, ...


 The answer could be:
 =IF(C31;0;INT(C3))


You are overthinking the problem: if C3 is positive, that's no different from
=INT(C3)


Reportedly, negative numbers do exist.


But not, it would seem, in the original 
questioner's election results.  Unless you know how to cast a negative vote ...


Brian Barker


--
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: how to crack a PW in LO?

2012-10-15 Thread Dr. R. O Stapf


On 15.10.2012 23:11, Andreas Säger wrote:

Am 15.10.2012 15:49, rost52 wrote:

LO files can be protected with PWs when doing save as.
Fighting currently with an xls file and its lost PW, I wonder how LO files can 
be cracked? Can the
MS related PW remover be used for LO as well?
Thanks in advance for comments.




xls does not encript your document. The only thing that gets encrypted
is the password. Any old version of OpenOffice.org opens a password
protected xls ignoring the password.
Thanks for the information. It seems that my version of LO 3.5.6.2 is too young to ignore the PW of 
an xls file.


However, my question was how to open an LO file if the PW get forgotten (not 
and MS file)?
Hints are welcome for the future.



--
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: Integer part of a number

2012-10-15 Thread James Knott

Andreas Säger wrote:

Am 15.10.2012 10:45, Brian Barker wrote:

At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote:

On 14.10.2012 12:20, Gilles SICHE wrote:

could anyone tell me which formula I should use for the integer part
of a cell to be shown in another cell, ...

The answer could be:
=IF(C31;0;INT(C3))

You are overthinking the problem: if C3 is positive, that's no different
from
=INT(C3)

Brian Barker



Reportedly, negative numbers do exist.



ABS(INT(C3))

--
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: how to crack a PW in LO?

2012-10-15 Thread Andreas Säger
Am 15.10.2012 16:30, Dr. R. O Stapf wrote:
 
 However, my question was how to open an LO file if the PW get forgotten
 (not and MS file)?
 Hints are welcome for the future.
 
 

There is no way to open encrypted ODF other than a brute force script
working through a list of possible passwords.


-- 
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: how to crack a PW in LO?

2012-10-15 Thread Ledger Consulting
gvfe ..dtnd e eeir2 
Sent from my MetroPCS Android Device

Andreas Säger ville...@t-online.de wrote:

Am 15.10.2012 15:49, rost52 wrote:
 LO files can be protected with PWs when doing save as.
 Fighting currently with an xls file and its lost PW, I wonder how LO files 
 can be cracked? Can the
 MS related PW remover be used for LO as well?
 Thanks in advance for comments.
 
 


xls does not encript your document. The only thing that gets encrypted
is the password. Any old version of OpenOffice.org opens a password
protected xls ignoring the password.



-- 
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: Integer part of a number

2012-10-15 Thread Andreas Säger
Am 15.10.2012 16:20, Brian Barker wrote:
 At 14:42 15/10/2012 +0200, Andreas Säger wrote:
 Am 15.10.2012 09:49, Pertti Rönnberg wrote:
 if value in cell c3 is /_less than_/ '1' then d3 shall be '0', else
 (-- if c3 is '1' or bigger then -- ) use the integer of value in c3)

 =MIN(0;INT(C3))
 
 This is getting sillier!  This formula does not match the definition
 above - and indeed for non-negative C3 is identically zero!  Try
 =0
 instead.
 
 Brian Barker
 
 

Sorry, should be:
=MAX(0;INT(C3))


-- 
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: how to crack a PW in LO?

2012-10-15 Thread Jean-Baptiste Faure
Le 15/10/2012 16:30, Dr. R. O Stapf a écrit :
 [...]

 However, my question was how to open an LO file if the PW get
 forgotten (not and MS file)?
 Hints are welcome for the future.
Buy a super-computer, launch a brute force algorithm and pray that the
password is a short word from the standard English vocabulary.


Best regards.
JBF

-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.


-- 
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: From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot

2012-10-15 Thread anne-ology
   that works for me  ;-)



On Mon, Oct 15, 2012 at 4:54 AM, Tom Davies tomdavie...@yahoo.co.uk wrote:

Hi :)
 Yes, that is the best way to migrate.  Keep whatever MS Office you happen
 to have and install LO.  There's no reason to upgrade the MS Office so you
 still make the saving but you still have access to it when you need it.
 Gradually you find more and more reason to use LO as you learn more about
 how to use it and less reason to be pushed into using MSO.
 Regards from
 Tom :)




 From: anne-ology lagin...@gmail.com
 Subject: Re: [libreoffice-users] Re: From MS Word to Writer: keeping my
 styles, macros, toolbars from Normal.dot
 To: Andreas Säger ville...@t-online.de
 Cc: users@global.libreoffice.org
 Date: Sunday, 14 October, 2012, 23:21

why not just keep both programs on the machine  ;-)



 On Thu, Oct 11, 2012 at 7:27 AM, Andreas Säger 
 ville...@t-online.dehttp://mc/compose?to=ville...@t-online.de
 wrote:

 Am 11.10.2012 11:43, Kyla Robertson wrote:
   Hello,
  
   I'm migrating from MS Word (Office 2002 !) to LibO Writer. In Word, my
   Normal.dot template contains many, many things: about 150 styles, 250
   macros, some auto-insert texts, some custom shortcuts, many toolbars
   and custom buttons.
  
   How can I keep this all to use it with Writer?
  
   In Migration Guide: A guide to ease your migration to OpenOffice.org
   from other office [suites] (2004)
   (
 
 http://www.openoffice.org/documentation/manuals/oooauthors/MigrationGuide.pdf
  ),
   I found a few things:
* AutoText entries: will the built-in method to import them still
   work with LibO 3.6.2?(should I get version 3.6.2 or 3.5.6, btw? I'm
   not sure I understand the difference.)
* AutoCorrect entries: there's a work-around with a macro and the
   editing of a ./user/autocorr/acorr.dat file...
* Custom dictionaries: there was a work-around to import their
   content, but the link to download the macro isn't valid anymore.
  
   Do you know of a more recent migration guide, or a tutorial on the
   Web, or forum post maybe? I couldn't find anything else.
  
   Thanks in advance for your help!
  
 
  This is not a free clone of some other program. All it can do is loading
  .doc files fairly well. Please switch to this software or stay with
  WinWord.
 



-- 
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: MS raised prices so people will now start renting their office products instead

2012-10-15 Thread webmaster-Kracked_P_P

On 10/15/2012 07:48 AM, Wolfgang Keller wrote:

that's the way it is and that's why currently I don't use LO Writer
for anything else than for converting .doc files to .pdf

I might just be something a little bit above a IT moron but using LO
Writer to convert doc into pdf appears to me like using a tractor to
participate in a F1 race or using an F1 race car to plough a field.
Why not installing a pdf-writer SW, there are even free-of-charge
versions available.

The point is that you do not only need a printer driver to generate the
PDF, but also an application that can open those .doc, .ppt etc. files.

Sincerely,

Wolfgang


Wolfgang . . .

I use Writer's Export to PDF and CUPS-PDF [Ubuntu 12.04] both, to 
create PDF prints of my document. CUPS-PDF will print PDFs for any 
package that can print to a physical printer.  I use doPDF for Windows 
systems.


Export to PDF doesgreat, except for some of the real decortive fonts I 
may use.  Then I need to use CUPS-PDF.  The drawback with CUPS-PDF is 
the document is always viewed in portrait mode even if the text is 
aligned in a landscape mode.


To be honest, I even use Writer to create eBooks for my tablet.  For 
some reason, I cannot get my tablet to read my ebooks on the installed 
microSD card.  Kindle for Android does not want to do it. So, after all 
my testing I figured it would be easier to create PDFs that was in the 
print size of a paperback, or at least my 7 inch tablet's screen. 
Right now, I open the .mobi files,or .epub files, and export them to a 
plain text file.  Then I open them in Writer and use the A6 page size 
[4.13 by 5.83 inches] and reduce the margins down to .15 inches.  Then I 
export them to a PDF file.  That process works well.  Actually the only 
way I can get the Kindle reader to read a file on the added microSD card 
is to open a PDF file using the file manager.  This way will not work 
with any other file type forKindle, but it does workwith PDF.  I do not 
have a Kindle tablet, but a $100 Trio Stealth Pro, since that was all I 
could afford at the time.


SO, Writer does a lot of things that a reader/converter app cannot do. 
I cancreate PDF eBooks from free plain text files, or even other file 
formats with a little help.


I now have 3 six-foot high bookshelf units staked 2 and 3 deep with 
paperback books.  I am currently working on getting as many of those 
books in both audio and eBook formats.  Then, if I ever have to reduce 
the number of books, or make room for newones, I will have them still in 
eBook, and maybe audio book, format. Writer helps me take the .epub and 
.mobi books and convert them into something I can use on my tablet.  Of 
course, I could move/copy them over to the internal 4 GB card, but I 
would rather leave them on the removable 32 GB microSD card.



Last year, I would not have imagined that I would use Writer, and some 
helper-apps to make usable eBooks for a tablet.  Last year I did not 
think I would ever buy a table either.


Actually I use Writer for quick posters for people.  If itis a complex 
poster, I use Inkscape, but slowly learning what Draw can do. Actually I 
create anew/revised logo for a non-profit organization that I created 
the original logo for.  I used Draw this time, just to practicewith it.





--
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: LibreOffice in MacWorld Australia

2012-10-15 Thread anne-ology
   Thanks  :-)

  and I agree with the way you think  :-)



On Sun, Oct 14, 2012 at 9:00 PM, Dr. R. O Stapf
reinh...@stapf-online.comwrote:

 I did not want to express it that explicitly what you wrote is
 perfectly right.

 I am often wondering why some members of this forum complain so much about
 LO instead of exchanging information in non-inflicting-feelings-of-others
 words, which help other users to solve their problems and/or help to move
 LO's development forward.



 On 15.10.2012 07:48, anne-ology wrote:

MSFT does not list their bugs; they deny them  ;-(



 On Sat, Oct 13, 2012 at 10:28 PM, Dr. R. O Stapf 
 reinh...@stapf-online.com wrote:

 I have my still my doubts on graphics, but all the other remarks of Tom I
 fully agree.

 By the way is there a list of MSO bugs we can have a look at? I doubt!


 On 14.10.2012 10:39, anne-ology wrote:

 same here.



 On Thu, Oct 11, 2012 at 8:27 PM, Tom Davies tomdavie...@yahoo.co.uk
 wrote:

 Hi :)

 I prefer LO on Windows even though i have a choice of MSO 2007 and 2010
 on
 the same machine.  All 3 installed but LO handles graphics better.
  Plus it
 doesn't keep changing styles, languages, indentations, size of
 bullet-points and it keeps track of numbers better in numbered lists.
  Also
 better compatibility.  Each version of MSO stuffs up documents created
 by
 the other.  If i write in LO then save as doc then both versions of MSO
 display the file the same way.  I find the menus easier although some
 things are just as easy on both.
 Regards from
 Tom :)




  From: Andreas Säger ville...@t-online.de
 To: users@global.libreoffice.org
 Sent: Thursday, 11 October 2012, 23:48
 Subject: [libreoffice-users] Re: LibreOffice in MacWorld Australia

 Am 11.10.2012 20:46, webmaster-Kracked_P_P wrote:

 It is nice to see that MacWorld Australia states that LibreOffice is a
 must have app/package. I wonder if the MacWorld for the USA and
 Europe
 would have the same statement.

 Be nice to have LO listed in the must have category in the various
 Windows magazines. We could use more Windows users, and free
 advertisements towards Windows users, as we can get.

 It would be nice to have a booth in a Windows version of the big
 software shows that happen for Linux and Mac. But those booths may be
 very expensive to rent for such an event.

  Windows users can run MS Office easily and for little money (if any).
 Why should they use LibreOffice if all they want is cheap MS Office?
 Idealism? Masochism?



-- 
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: Integer part of a number

2012-10-15 Thread Brian Barker

At 10:34 15/10/2012 -0400, James Knott wrote:

Andreas Säger wrote:

Am 15.10.2012 10:45, Brian Barker wrote:

At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote:

On 14.10.2012 12:20, Gilles SICHE wrote:
could anyone tell me which formula I should 
use for the integer part of a cell to be shown in another cell, ...


The answer could be:
=IF(C31;0;INT(C3))


You are overthinking the problem: if C3 is 
positive, that's no different from

=INT(C3)


Reportedly, negative numbers do exist.


ABS(INT(C3))


Now you are assuming (1) that negative election 
results are possible, and (2) that they should be 
given equal weight with positive ones.  Perhaps 
you can find me a bank where withdrawals increase 
my balance just as deposits do?


Brian Barker


--
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: Integer part of a number

2012-10-15 Thread Brian Barker

At 16:36 15/10/2012 +0200, Andreas Säger wrote:

Am 15.10.2012 16:20, Brian Barker wrote:

 At 14:42 15/10/2012 +0200, Andreas Säger wrote:

 Am 15.10.2012 09:49, Pertti Rönnberg wrote:
if value in cell c3 is /_less than_/ '1' 
then d3 shall be '0', else (-- if c3 is '1' 
or bigger then -- ) use the integer of value in c3)


=MIN(0;INT(C3))


This is getting sillier!  This formula does not 
match the definition above - and indeed for 
non-negative C3 is identically zero!  Try

=0
instead.


Sorry, should be:
=MAX(0;INT(C3))


Again, for positive C3, that is identical to
=INT(C3)
- which was suggested by someone a long way earlier in this thread!

Brian Barker


--
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] List of Fonts in Use in a Document

2012-10-15 Thread CVAlkan
Hi:

I'm using Writer on two different machines/Operating Systems and have copied
the main fonts I use to both, but every now and then a situation arises
where LibreOffice makes a substitution for a font that I overlooked, causing
subtle (usually, but not always) changes in the document layout.

Is there some way to list all of the fonts (not styles, since I don't want
to wade through each to see what fonts they need) in use in a particular
document?

Thanks for any advice...



--
View this message in context: 
http://nabble.documentfoundation.org/List-of-Fonts-in-Use-in-a-Document-tp4013512.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: Auto and Manual Spell do not work x

2012-10-15 Thread anne-ology
   Thank you for these kind words.



On Sun, Oct 14, 2012 at 8:51 PM, rost52 bugquestcon...@online.de wrote:


 On 15.10.2012 08:09, anne-ology wrote:

  BUT I was turned off by his foul language;


 Well observed and expressed.

 I am sometimes wondering why people do not communicate about facts with
 words not causing bad feelings at others.

 Thus I can understand anne-ology's words if he asks again - and nicely -
 I'll respond to him. 

 A nice for all.



-- 
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: Auto and Manual Spell do not work x

2012-10-15 Thread anne-ology
   Since you're asking nicely, I'll respond;
   have you read Tom's responses to you?, have you clicked on the
URLs he's included?, ...

   Sounds to me as if your machine may have a virus; are your A-V, et.al.
programs up-to-date and functioning?



On Sun, Oct 14, 2012 at 11:04 PM, Lostsoul joyseyh...@yahoo.com wrote:

Ok whats going on now when i move my mouse about a blank page i get 5 lines
 to the right of the i line which is the pointer hope that makes sense; how
 do i end that ?




 From: Tom [via Document Foundation Mail Archive] 
 ml-node+s969070n4013298...@n3.nabble.com
 Subject: Re: Auto and Manual Spell do not work x
 To: Lostsoul joyseyh...@yahoo.com
 Date: Sunday, October 14, 2012, 3:15 PM


 Hi :)
 To get back to factory defaults and 'switch off' all Extensions just
 rename your User Profile.  Larry gave a link to help with that.  Here is
 another link that will one day be merged with the one Larry gave
 http://wiki.documentfoundation.org/Documentation/UserProfile

 Factory defaults are possibly a bit less tweaked than whatever you had
 installed so it may look a little different and may remove some
 weirdnesses.  It's a good thing to try whenever you find weird things going
 on.  It usually beats a reinstall assuming you have now installed a proper
 version of LO.

 Regards from
 Tom :)




 From: Lostsoul [hidden email]
 Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x
 To: [hidden email]
 Date: Sunday, 14 October, 2012, 9:37

  Haha very funny that know one can tell me why word problems hate
 windows 7 never had any word programs hate vista so explain if you dare;
 you'd be the first why the word programs hate win 7 and why no one but no
 one has a fix; this i got to hear.

 How do i turn off file extensions in windows 7 64 bit   -  later . .




 From: Andreas Säger [via Document Foundation Mail Archive] [hidden email]
 Subject: Re: Auto and Manual Spell do not work x
 To: Lostsoul [hidden email]
 Date: Sunday, October 14, 2012, 4:28 AM


 Am 14.10.2012 10:10, Lostsoul wrote:
   Ok now what the crap; why are abiword documents being saved as
 adobi docs how do i fix that can t get anything right crap .   -  later
 

 I strongly recommend some computer crash curse. File name associations
 are free.  There is nothing hard wired to the system. You can open any
 file with any program you want. You can tell your desktop environment
 which programs can open which types of files and which single program is
 the preferred one to be used on double-click.
 First of all, any user who is forced to use MS Windows should turn off
 the option to hide known file name extensions. Since Windows '95 this is
 the major obstacle which prevents people from understanding their system.



-- 
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: Auto and Manual Spell do not work x

2012-10-15 Thread anne-ology
   Do you have both WIN and LO open at the same time?;
if so, then close the one you're not using ... open the one you
wish to use.

   [re. saving a document], when you click on 'file', there are other
save features but the main ones are 'save' vs. 'save as' - ignore the
others since these merely add the suffix for you; the same problems arise
if you click on 'save'.  THEREFORE click on 'save as' then follow the
blocks - choosing the suffix you desire, choosing the folder you desire,
then clicking to save.



On Mon, Oct 15, 2012 at 7:36 AM, Robert Burns joyseyh...@yahoo.com wrote:

   Not using libre from free sites because they are 28 or 125 mb in size so
 i deleted those now using the full version 220 mb version  3.6.6. but
 thinking of trying 3.5.4 since some think that s the best version to try
 with windows 7 but trying abiword and I B M lotus and Kingsoft  maybe they
 won t throw fits at windows 7 so no hurry to reset w7; libre needs fixing
 not windows 7 .

 Windows 7 came with the lap top; when i use save as i have 7 choices so
 which is the best to use; save as with libre and can i get a save doc
 format switched over to saved as; and would libre stop having win7 fits i
 wonder .

 And a screen shot of what ? ?   Whew  later .  .  .




 From: Tom Davies tomdavie...@yahoo.co.uk
 Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x
 To: Lostsoul joyseyh...@yahoo.com, users@global.libreoffice.org 
 users@global.libreoffice.org
 Date: Monday, October 15, 2012, 8:15 AM


 Hi :)
 Did you uninstall all versions of 'LO' that you got from some freeware
 site and do an antivirus scan?  Did you download the 3.5.6 or
 3.6.something LO from the official site and install as advised?

 Is there any chance of giving us a screen-shot?

 Also, just out of curiosity, have you used Win7 on any machine other than
 your own?  Has anyone else used your machine that might have some
 familiarity with Win7 when it's properly installed?  Did you install Win7
 or was it already on the machine when you bought it?

 Btw Abiword can save files in MS formats but you have to do
 File - Save As ...
 You can't set it to default to MS formats.  I tried nagging them about it
 but gave up.  The native format it uses is the OpenDocument Format, same as
 LO, same as almost every other word-processing program except MS and even
 they purport to support it as a non-native format.  So, people using MS
 Office 'should' be able to open your documents created in AbiWord.  I did
 mention all this when i made some suggestions about what other free
 word-processors were out there although not in as much detail.

 Regards from
 Tom :)




 From: Lostsoul joyseyh...@yahoo.com
 To: users@global.libreoffice.org
 Sent: Monday, 15 October 2012, 5:04
 Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x

 Ok whats going on now when i move my mouse about a blank page i get 5
 lines to the right of the i line which is the pointer hope that makes
 sense; how do i end that ?




 From: Tom [via Document Foundation Mail Archive] 
 ml-node+s969070n4013298...@n3.nabble.com
 Subject: Re: Auto and Manual Spell do not work x
 To: Lostsoul joyseyh...@yahoo.com
 Date: Sunday, October 14, 2012, 3:15 PM


 Hi :)
 To get back to factory defaults and 'switch off' all Extensions just
 rename your User Profile.  Larry gave a link to help with that.  Here is
 another link that will one day be merged with the one Larry gave
 http://wiki.documentfoundation.org/Documentation/UserProfile

 Factory defaults are possibly a bit less tweaked than whatever you had
 installed so it may look a little different and may remove some
 weirdnesses.  It's a good thing to try whenever you find weird things going
 on.  It usually beats a reinstall assuming you have now installed a proper
 version of LO.

 Regards from
 Tom :)




 From: Lostsoul [hidden email]
 Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x
 To: [hidden email]
 Date: Sunday, 14 October, 2012, 9:37

  Haha very funny that know one can tell me why word problems hate
 windows 7 never had any word programs hate vista so explain if you dare;
 you'd be the first why the word programs hate win 7 and why no one but no
 one has a fix; this i got to hear.

 How do i turn off file extensions in windows 7 64 bit   -  later . .




 From: Andreas Säger [via Document Foundation Mail Archive] [hidden email]
 Subject: Re: Auto and Manual Spell do not work x
 To: Lostsoul [hidden email]
 Date: Sunday, October 14, 2012, 4:28 AM


 Am 14.10.2012 10:10, Lostsoul wrote:
   Ok now what the crap; why are abiword documents being saved as
 adobi docs how do i fix that can t get anything right crap .   -  later
 

 I strongly recommend some computer crash curse. File name associations
 are free.  There is nothing hard wired to the system. You can open any
 file with any program you want. You can tell your desktop environment
 which programs can open which 

[libreoffice-users] Re: Reality Check - Windows Java Accessibility API non-functional for ALL LibreOffice 3.6.x releases to date

2012-10-15 Thread V Stuart Foote
Had an open bug. Appended to it.

FDO#53474 (http:  bug report
https://bugs.freedesktop.org/show_bug.cgi?id=53474 )

Stuart



--
View this message in context: 
http://nabble.documentfoundation.org/Reality-Check-Windows-Java-Accessibility-API-non-functional-for-ALL-LibreOffice-3-6-x-releases-to-dae-tp4013335p4013521.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] List of Fonts in Use in a Document

2012-10-15 Thread webmaster-Kracked_P_P


There use to be a text font extension that might have done it, but I 
never used it.


For my use, I just took all of the fonts I used on my Windows system and 
made sure they were on my Linux system.  Then I made sure all my fonts 
now on the Linux system was on the Windows one[s].


I keep a font folder with all the fonts I use on both Linux and 
Windows.  That way I know that all my systems have the same font set 
available.  Of course, I have over 400 fonts installed and have access 
to over 14 GB of font files to choose from.


For me, it was just easier to sync all my system to have the same set of 
fonts and not worry about not having a certain font not be on one system 
I am doing any editing on.



On 10/15/2012 11:14 AM, CVAlkan wrote:

Hi:

I'm using Writer on two different machines/Operating Systems and have copied
the main fonts I use to both, but every now and then a situation arises
where LibreOffice makes a substitution for a font that I overlooked, causing
subtle (usually, but not always) changes in the document layout.

Is there some way to list all of the fonts (not styles, since I don't want
to wade through each to see what fonts they need) in use in a particular
document?

Thanks for any advice...



--
View this message in context: 
http://nabble.documentfoundation.org/List-of-Fonts-in-Use-in-a-Document-tp4013512.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] List of Fonts in Use in a Document

2012-10-15 Thread Joel Madero
Could the xml file be useful? Seems like a pain to analyze. Maybe a good
enhancement request on FDO :)

Regards,
Joel

On Mon, Oct 15, 2012 at 8:39 AM, webmaster-Kracked_P_P 
webmas...@krackedpress.com wrote:


 There use to be a text font extension that might have done it, but I
 never used it.

 For my use, I just took all of the fonts I used on my Windows system and
 made sure they were on my Linux system.  Then I made sure all my fonts now
 on the Linux system was on the Windows one[s].

 I keep a font folder with all the fonts I use on both Linux and Windows.
  That way I know that all my systems have the same font set available.  Of
 course, I have over 400 fonts installed and have access to over 14 GB of
 font files to choose from.

 For me, it was just easier to sync all my system to have the same set of
 fonts and not worry about not having a certain font not be on one system I
 am doing any editing on.



 On 10/15/2012 11:14 AM, CVAlkan wrote:

 Hi:

 I'm using Writer on two different machines/Operating Systems and have
 copied
 the main fonts I use to both, but every now and then a situation arises
 where LibreOffice makes a substitution for a font that I overlooked,
 causing
 subtle (usually, but not always) changes in the document layout.

 Is there some way to list all of the fonts (not styles, since I don't want
 to wade through each to see what fonts they need) in use in a particular
 document?

 Thanks for any advice...



 --
 View this message in context: http://nabble.**
 documentfoundation.org/List-**of-Fonts-in-Use-in-a-Document-**
 tp4013512.htmlhttp://nabble.documentfoundation.org/List-of-Fonts-in-Use-in-a-Document-tp4013512.html
 Sent from the Users mailing list archive at Nabble.com.



 --
 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




-- 
*Joel Madero*
LibO QA Volunteer
jmadero@gmail.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] List of Fonts in Use in a Document

2012-10-15 Thread Brian Barker

At 08:14 15/10/2012 -0700, C V Alkan wrote:
I'm using Writer on two different machines/Operating Systems and 
have copied the main fonts I use to both, but every now and then a 
situation arises where LibreOffice makes a substitution for a font 
that I overlooked, causing subtle (usually, but not always) changes 
in the document layout.


Is there some way to list all of the fonts (not styles, since I 
don't want to wade through each to see what fonts they need) in use 
in a particular document?


This is just a guess, but try File | Export as PDF... to create a PDF 
version of your document.  Open this in your favourite PDF reader, 
which should be able to tell you which fonts have been 
embedded.  Does that give you a reliable list?


I trust this helps.

Brian Barker


--
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: Fwd: Re: Re: BASIC script how to read/write system files, like /dev/null in Linux

2012-10-15 Thread Tim Deaton
I haven't tried StarBasic, but in the past did use VBA for Applications 
in Excel and Access.  Personally, because of the danger of malicious 
mischief, I think having something  that can only do things within your 
own product would be a VERY good thing.  If I understood Andreas 
correctly, that's the way StarBasic works. So I'd say fix the bugs and 
don't change its mission.


Then, if you need something that interacts with other things outside of 
LO, use another tool designed for that, and make sure LO safeguards 
adequately protect against the possibility of mischief.


-- Tim
===

On 10/15/2012 8:38 AM, Andreas Säger wrote:

Am 15.10.2012 13:31, Tom Davies wrote:

Hi :)
No-one is suggesting dropping Star Basic!  That would be a huge nightmare for 
many people i'm sure.

I was just curious what might be better.  A quick look at what languages can be used for 
macros in LO reveals 4 choices;  LO Basic, Python, BeanShell, or JavaScript.  I was just 
wondering which was 'best'.  Are all 4 really well implemented in LO?  I guess LO 
Basic is the Star Basic being referred to in this thread?

I think Andreas was just suggesting that choosing to use Star Basic is not the 
best choice.  However one of the great things about OpenSource is that you do 
get choices.  We can all disagree about almost everything and still end up 
co-operating with each other even if we didn't want to.

Outside of IT choice is usually seen as a good thing.  Many countries see 
democracy as good and ostensibly give a choice of who you can vote for to rule. 
 In shops people would be outraged if there was nothing else to buy except 
baked beans.  People expect to be able to buy a wide range of diferent products 
from different companies and for it all to work together well enough.  Somehow 
IT seems to demand dictatorships and freedom FROM choice rather than freedom OF 
choice.  We don't all do the same things and even if we did we probably 
wouldn't do them the same way so it's fairly insane to expect 1 product and 1 
company to be the only thing worth using.

I was just curious about other people's choices to help me understand more 
about a subject i know little about.
Regards from
Tom :)

StarBasic is a separate lingo implemented to call the API of this
particular software only. It can not do anything outside the scope of
the office. It comes with a few convenience features related to this
particular API and the code is easier to be stored within office
documents. It does not include any math library beyond triangular
functions and basic arithmetics. It handles arrays in the most
complicated ways, it does not know any hashes, it has far too many bugs
and short comings, it is extremely complex and awkward (Null, Nothing,
Empty, Missing are different types of the same).
Basic is a 100% procedural lingo talking to an strictly object oriented
API which is the reason why you can not write any extensions in Basic.
MS Office and this office are the last resorts of this extinct lingo of
the MS dominated 90ies.
The alternatives are full featured, popular and mature programming
languages with dozends of modules to program anything you want.
A little bit of glue code makes them UNO compatible, callable from
within the office suite (ToolsMacros), from the command line and as UNO
components as well. Plain souce code files are much easier to maintain
and a programmer can use whatever source code editor he wants (the Basic
editor is no more than a cheap plastic toy).
All the object oriented languages can be used to write seamlessly
integrated extensions.





--
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: Auto and Manual Spell do not work . .

2012-10-15 Thread Dan Hall
Re. Tom Davies  To get back to factory defaults and 'switch off' all
Extensions just rename your User Profile. 

I did this (renamed my User Profile) and now spell check works for me in
LibreOffice (Writer) 3.5.4.2 on Windows 7.

-Original Message-
From: Dan Hall [mailto:dih...@myfairpoint.net] 
Sent: Saturday, October 13, 2012 2:53 PM
To: 'Dan Hall'; 'Lostsoul'; users@global.libreoffice.org
Subject: RE: [libreoffice-users] Re: Auto and Manual Spell do not work . .

I posted here only to answer Lostsoul's question, i.e. does anyone out
their use libre with win 7.  I do not need help per se.  I bought a new
desktop computer in May 2012 and it came with LibreOffice installed.  The
spell checker in LibreOffice did (does) not work so I purchased and
installed MS Office 2003, which I now use.

Note:  I signed on to the LibreOffice-users mailing list back then to see if
I could find any mention of spell checker problems.

-Original Message-
From: Dan Hall [mailto:dih...@myfairpoint.net] 
Sent: Saturday, October 13, 2012 10:03 AM
To: 'Lostsoul'; users@global.libreoffice.org
Subject: RE: [libreoffice-users] Re: Auto and Manual Spell do not work . .

I have LibreOffice 3.5.4.2 on Windows 7 and in Writer the spell check does
not work for spelling errors... it does however correct beginning of
sentence capitalization (automatically) and manual spell check complains of
extra spaces when they exist.

-Original Message-
From: Lostsoul [mailto:joyseyh...@yahoo.com] 
Sent: Friday, October 12, 2012 9:54 PM
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: Auto and Manual Spell do not work . .

 Not thinking of using ubanta was just asking about it ; and does anyone
out their use libre with win 7 so far i would guess its a  huge no and your
throwing out ramdom guess s as fixs.
 
And libre comes in three sizes on various freeware sites; not their home
page 28 mb and 120 mb and their web site has it at 210 mb and 10 mb for
help;  wonder what that is all about will get the biggy next hopefully that
works with win 7 the way it should  -  later   

--- On Fri, 10/12/12, krackedpress [via Document Foundation Mail Archive]
ml-node+s969070n4012954...@n3.nabble.com wrote:


From: krackedpress [via Document Foundation Mail Archive]
ml-node+s969070n4012954...@n3.nabble.com
Subject: Re: Auto and Manual Spell do not work . .
To: Lostsoul joyseyh...@yahoo.com
Date: Friday, October 12, 2012, 12:34 PM



I think there is some other issues going on with this user and Ubuntu 
will not fix the problem.  The person will be a Windows user and not a 
Linux user in the foreseeable future. 

Where is he getting a 28MB or a 108 MB version of LO is my concern.  I 
do not remember Windows LO being that small. 

Then there is the comment of being a use for 3 years.  LO 3.3.0 came out 
in the beginning of last year, so it has not be out for 3 years yet. 

If the person installed a version of LO that is not the proper file 
size, then there will be trouble. 

I think the best thing to do is a complete uninstall of LO and then 
download a fresh copy from the web site and make sure what is downloaded 
matches the file size of the package. 




On 10/12/2012 11:34 AM, Tom Davies wrote: 

 Hi :) 
 I think what i would be tempted to do at this stage, since you have 
 put so much timeeffort in is to resize the Win7 partition to around 
   30-50Gb and then get an Ubuntu Cd and install Ubuntu on however much 
 space you have left (assuming you have over 15Gb to spare).  Ubuntu 
 comes with tons of programs already installed so it very usable right 
 from the start. 
 http://www.ubuntu.com/
 The download button is halfway down the left side, just under the title
Rock Solid. 
 
 
 Windows is a Pita to install.  I think probably a lot of people on this
list share your pain as there are probably a lot us here that have had to
try it too.  With hindsight i think it's usually best to stick with whatever
is already on the machine but just shrink the partition as small as
reasonably possible and then use the rest of the space for the new install
of whatever. 
 
 Win7 is great once it's installed and got all the programs but it sounds
like yours has something wrong with it, or with the LO install or something.
 Like i say it is a total pain to install. 
 
 
 Not that once you have created the Ubuntu Cd you can boot-up straight from
the Cd without even installing it so you can test-drive the lookfeel of
Ubuntu.  We call it a Live Cd session.  You can make a Usb one which is a
lot faster but people often still call it LiveCd even if it's Usb. 
 Regards from 
 Tom :) 
 
 
 
 
 
 
 
  
 From: Lostsoul [hidden email] 
 To: [hidden email] 
 Sent: Friday, 12 October 2012, 16:10 
 Subject: [libreoffice-users] Re: Auto and Manual Spell do not work . . 
 
 OHHH my to much to do wonder if its worth it i miss vista everything
worked like a charm first must re install the newest biggest version; so
much 

Re: [libreoffice-users] List of Fonts in Use in a Document

2012-10-15 Thread webmaster-Kracked_P_P

On 10/15/2012 11:41 AM, Brian Barker wrote:

At 08:14 15/10/2012 -0700, C V Alkan wrote:
I'm using Writer on two different machines/Operating Systems and have 
copied the main fonts I use to both, but every now and then a 
situation arises where LibreOffice makes a substitution for a font 
that I overlooked, causing subtle (usually, but not always) changes 
in the document layout.


Is there some way to list all of the fonts (not styles, since I don't 
want to wade through each to see what fonts they need) in use in a 
particular document?


This is just a guess, but try File | Export as PDF... to create a PDF 
version of your document.  Open this in your favourite PDF reader, 
which should be able to tell you which fonts have been embedded.  Does 
that give you a reliable list?


I trust this helps.

Brian Barker




For Ubuntu 12.04/MATE, I used the default PDF viewer and went to:
File/Properties/Fonts
to display the fonts used in a document.

The only thing I would like to see is the ability to copy/paste the font 
list to a text file to compare the list to another list of fonts.


--
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: Integer part of a number

2012-10-15 Thread James Knott

Brian Barker wrote:

Now you are assuming (1) that negative election results are possible,


Well, with the way Romney's doing...  ;-)


I was just posting in reference to comment about negative numbers and 
not the original post.


--
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: how to crack a PW in LO?

2012-10-15 Thread Dr. R. O Stapf


On 15.10.2012 23:46, Jean-Baptiste Faure wrote:

Le 15/10/2012 16:30, Dr. R. O Stapf a écrit :

[...]

However, my question was how to open an LO file if the PW get
forgotten (not and MS file)?
Hints are welcome for the future.

Buy a super-computer, launch a brute force algorithm and pray that the
password is a short word from the standard English vocabulary.


Best regards.
JBF

Thanks to JBF and Andreas for their hints. As I have a little program which makes brute force 
approach I will run a test to see if this is possible with PW protected LO files.





--
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: how to crack a PW in LO?

2012-10-15 Thread webmaster-Kracked_P_P

On 10/15/2012 12:00 PM, Dr. R. O Stapf wrote:


On 15.10.2012 23:46, Jean-Baptiste Faure wrote:

Le 15/10/2012 16:30, Dr. R. O Stapf a écrit :

[...]

However, my question was how to open an LO file if the PW get
forgotten (not and MS file)?
Hints are welcome for the future.

Buy a super-computer, launch a brute force algorithm and pray that the
password is a short word from the standard English vocabulary.


Best regards.
JBF

Thanks to JBF and Andreas for their hints. As I have a little program 
which makes brute force approach I will run a test to see if this is 
possible with PW protected LO files.




For future reference, if you have to create a password protected 
document [for viewing or editing] make sure you use one that will not be 
forgotten or WRITE IT DOWN somewhere and save it in your filing cabinet.


At one computer center I worked, they taped the needed passwords on the 
back of the keyboard. You needed a door key to get into the place, so 
the passwords were protected, but that way all the personnel will be 
able to access the needed systems and not forget the needed passwords.


I use a list of about a dozen passwords.  So if I forget which one I 
used, I just go down the mental list till I get the one I used for 
that application or document.


--
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: Fwd: Re: Re: BASIC script how to read/write system files, like /dev/null in Linux

2012-10-15 Thread Jay Lozier
On 10/15/2012 11:45 AM, Tim Deaton wrote:
 I haven't tried StarBasic, but in the past did use VBA for
 Applications in Excel and Access.  Personally, because of the danger
 of malicious mischief, I think having something  that can only do
 things within your own product would be a VERY good thing.  If I
 understood Andreas correctly, that's the way StarBasic works. So I'd
 say fix the bugs and don't change its mission.

 Then, if you need something that interacts with other things outside
 of LO, use another tool designed for that, and make sure LO safeguards
 adequately protect against the possibility of mischief.

 -- Tim

The problem with any macro is the possibility of it accessing parts of
the OS that could allow for someone to inject malware into the system.
This issue is actually independent of the macro language. I remember
several VBA macro malware from about 2000 being a major problem; partly
because of MS Office at the time default of executing any macro in a
file and the relative newness of the Internet and email to most users.

How LO and MSO currently protect is to not allowing
unverified/unvalidated/uncertified macros from running by default.

 ===

 On 10/15/2012 8:38 AM, Andreas Säger wrote:
 Am 15.10.2012 13:31, Tom Davies wrote:
 Hi :)
 No-one is suggesting dropping Star Basic!  That would be a huge
 nightmare for many people i'm sure.

 I was just curious what might be better.  A quick look at what
 languages can be used for macros in LO reveals 4 choices;  LO Basic,
 Python, BeanShell, or JavaScript.  I was just wondering which was
 'best'.  Are all 4 really well implemented in LO?  I guess LO
 Basic is the Star Basic being referred to in this thread?

 I think Andreas was just suggesting that choosing to use Star Basic
 is not the best choice.  However one of the great things about
 OpenSource is that you do get choices.  We can all disagree about
 almost everything and still end up co-operating with each other even
 if we didn't want to.

 Outside of IT choice is usually seen as a good thing.  Many
 countries see democracy as good and ostensibly give a choice of who
 you can vote for to rule.  In shops people would be outraged if
 there was nothing else to buy except baked beans.  People expect to
 be able to buy a wide range of diferent products from different
 companies and for it all to work together well enough.  Somehow IT
 seems to demand dictatorships and freedom FROM choice rather than
 freedom OF choice.  We don't all do the same things and even if we
 did we probably wouldn't do them the same way so it's fairly insane
 to expect 1 product and 1 company to be the only thing worth using.

 I was just curious about other people's choices to help me
 understand more about a subject i know little about.
 Regards from
 Tom :)
 StarBasic is a separate lingo implemented to call the API of this
 particular software only. It can not do anything outside the scope of
 the office. It comes with a few convenience features related to this
 particular API and the code is easier to be stored within office
 documents. It does not include any math library beyond triangular
 functions and basic arithmetics. It handles arrays in the most
 complicated ways, it does not know any hashes, it has far too many bugs
 and short comings, it is extremely complex and awkward (Null, Nothing,
 Empty, Missing are different types of the same).
 Basic is a 100% procedural lingo talking to an strictly object oriented
 API which is the reason why you can not write any extensions in Basic.
 MS Office and this office are the last resorts of this extinct lingo of
 the MS dominated 90ies.
 The alternatives are full featured, popular and mature programming
 languages with dozends of modules to program anything you want.
 A little bit of glue code makes them UNO compatible, callable from
 within the office suite (ToolsMacros), from the command line and as UNO
 components as well. Plain souce code files are much easier to maintain
 and a programmer can use whatever source code editor he wants (the Basic
 editor is no more than a cheap plastic toy).
 All the object oriented languages can be used to write seamlessly
 integrated extensions.






-- 
Jay Lozier
jsloz...@gmail.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: how to crack a PW in LO?

2012-10-15 Thread Tom Davies
Hi :)
I apply an algorithm to the name of whatever it is that i am doing and then 
apply a series of standard characters at set locations.  The set of characters 
and their locations depends on which of 3 categories the thing fits into
1.  Something i really don't want to have cracked, such as my bank, in which 
case i try to use the longest relevant 'name'
2.  Something that it would be good not to get cracked but not really too 
fussed about 
3.  Something that i wouldn't care about sharing the password with pretty much 
anyone

LO and most of my work passwords fall into the 3rd.  One at work falls into the 
1st.  So, i don't need to write anything down anywhere but do tend to lose 
track of which sites and stuff i do have passwords for and which i might need 
to register at.  Usually i just try out the password i would use and if i don't 
get in then i try to register (or give up)
Regards from
Tom :) 


--- On Mon, 15/10/12, webmaster-Kracked_P_P webmas...@krackedpress.com wrote:

From: webmaster-Kracked_P_P webmas...@krackedpress.com
Subject: Re: [libreoffice-users] Re: how to crack a PW in LO?
To: users@global.libreoffice.org
Date: Monday, 15 October, 2012, 17:29

On 10/15/2012 12:00 PM, Dr. R. O Stapf wrote:
 
 On 15.10.2012 23:46, Jean-Baptiste Faure wrote:
 Le 15/10/2012 16:30, Dr. R. O Stapf a écrit :
 [...]
 
 However, my question was how to open an LO file if the PW get
 forgotten (not and MS file)?
 Hints are welcome for the future.
 Buy a super-computer, launch a brute force algorithm and pray that the
 password is a short word from the standard English vocabulary.
 
 
 Best regards.
 JBF
 
 Thanks to JBF and Andreas for their hints. As I have a little program which 
 makes brute force approach I will run a test to see if this is possible with 
 PW protected LO files.
 

For future reference, if you have to create a password protected document [for 
viewing or editing] make sure you use one that will not be forgotten or WRITE 
IT DOWN somewhere and save it in your filing cabinet.

At one computer center I worked, they taped the needed passwords on the back of 
the keyboard. You needed a door key to get into the place, so the passwords 
were protected, but that way all the personnel will be able to access the 
needed systems and not forget the needed passwords.

I use a list of about a dozen passwords.  So if I forget which one I used, I 
just go down the mental list till I get the one I used for that application 
or document.

-- 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] Re: how to crack a PW in LO?

2012-10-15 Thread MR ZenWiz
On Mon, Oct 15, 2012 at 7:30 AM, Ledger Consulting
t...@theledgerfirm.com wrote:
 gvfe ..dtnd e eeir2

What?

-- 
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: Integer part of a number

2012-10-15 Thread Steve Edmonds


On 2012-10-16 04:11, Brian Barker wrote:

At 16:36 15/10/2012 +0200, Andreas Säger wrote:

Am 15.10.2012 16:20, Brian Barker wrote:

 At 14:42 15/10/2012 +0200, Andreas Säger wrote:

 Am 15.10.2012 09:49, Pertti Rönnberg wrote:
if value in cell c3 is /_less than_/ '1' then d3 shall be '0', 
else (-- if c3 is '1' or bigger then -- ) use the integer of value 
in c3)


=MIN(0;INT(C3))


This is getting sillier!  This formula does not match the definition 
above - and indeed for non-negative C3 is identically zero!  Try

=0
instead.


Sorry, should be:
=MAX(0;INT(C3))


Again, for positive C3, that is identical to
=INT(C3)
- which was suggested by someone a long way earlier in this thread!

Brian Barker



Were there negative voters, you could use =TRUNC(C3).
This has been an interesting discussion because I have learnt that 
INT(-1.1) is 2 and if I want the integer part of -1.1 I need to use TRUNC.
INT returns the next integer less than or equal to the value. TRUNC 
returns the integer part of the value (in the format I have shown).

steve


--
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: how to crack a PW in LO?

2012-10-15 Thread Jean-Baptiste Faure
Le 15/10/2012 18:00, Dr. R. O Stapf a écrit :

 On 15.10.2012 23:46, Jean-Baptiste Faure wrote:
 Le 15/10/2012 16:30, Dr. R. O Stapf a écrit :
 [...]

 However, my question was how to open an LO file if the PW get
 forgotten (not and MS file)?
 Hints are welcome for the future.
 Buy a super-computer, launch a brute force algorithm and pray that the
 password is a short word from the standard English vocabulary.

 [...]

 Thanks to JBF and Andreas for their hints. As I have a little program
 which makes brute force approach I will run a test to see if this is
 possible with PW protected LO files.
I tried that with a software named password recovery or something like
that. It failed to find a 6 characters password in 8 hours on a standard PC.

Best regards.
JBF

-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.


-- 
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: Indexing for Search not working?

2012-10-15 Thread gruesser
Same here on Mac, OS 10.5.8, Libreoffice 3.6.2.2. Spotlight does not find
odt-documents. Looking into console, I find the message

15.10.12 15:47:43 mdworker[116] Cannot find function pointer
MetadataImporterPluginFactory for factory
A3FCC88D-B9A6-4364-8B93-92123C8A2D18 in CFBundle/CFPlugIn 0x1664c0
/Applications/LibreOffice.app/Contents/Library/Spotlight/OOoSpotlightImporter.mdimporter
(bundle, loaded) 
15.10.12 15:47:43 mdworker[116] (Warning) ImportPluginLoading: Plugin at url
'Spotlight/OOoSpotlightImporter.mdimporter/ --
/Applications/LibreOffice.app/Contents/Library/' cannot be loaded.  It will
not be used.

My fault or a bug in Libreoffice?

Thanks, gruesser



--
View this message in context: 
http://nabble.documentfoundation.org/Indexing-for-Search-not-working-tp4013483p4013560.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: Auto and Manual Spell do not work x

2012-10-15 Thread Tom Davies
Hi :)
+1
Except that i've never seen a virus doing exactly that before, but then i don't 
see the effects of many viruses.  I should try to keep one machine insecure 
deliberately in order to recognise the way these things look.  Also i've not 
heard of a virus affecting LO before.  I've heard of a theoretical possibility 
a couple of times.  The release of the 3.5.0 dealt with the only feasibly 
realistic potential threat (allegedly)
Regards from
Tom :)



--- On Mon, 15/10/12, anne-ology lagin...@gmail.com wrote:

From: anne-ology lagin...@gmail.com
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Cc: users@global.libreoffice.org
Date: Monday, 15 October, 2012, 16:23

       Since you're asking nicely, I'll respond;
           have you read Tom's responses to you?, have you clicked on the
URLs he's included?, ...

       Sounds to me as if your machine may have a virus; are your A-V, et.al.
programs up-to-date and functioning?



On Sun, Oct 14, 2012 at 11:04 PM, Lostsoul joyseyh...@yahoo.com wrote:

Ok whats going on now when i move my mouse about a blank page i get 5 lines
 to the right of the i line which is the pointer hope that makes sense; how
 do i end that ?




 From: Tom [via Document Foundation Mail Archive] 
 ml-node+s969070n4013298...@n3.nabble.com
 Subject: Re: Auto and Manual Spell do not work x
 To: Lostsoul joyseyh...@yahoo.com
 Date: Sunday, October 14, 2012, 3:15 PM


 Hi :)
 To get back to factory defaults and 'switch off' all Extensions just
 rename your User Profile.  Larry gave a link to help with that.  Here is
 another link that will one day be merged with the one Larry gave
 http://wiki.documentfoundation.org/Documentation/UserProfile

 Factory defaults are possibly a bit less tweaked than whatever you had
 installed so it may look a little different and may remove some
 weirdnesses.  It's a good thing to try whenever you find weird things going
 on.  It usually beats a reinstall assuming you have now installed a proper
 version of LO.

 Regards from
 Tom :)




 From: Lostsoul [hidden email]
 Subject: [libreoffice-users] Re: Auto and Manual Spell do not work x
 To: [hidden email]
 Date: Sunday, 14 October, 2012, 9:37

      Haha very funny that know one can tell me why word problems hate
 windows 7 never had any word programs hate vista so explain if you dare;
 you'd be the first why the word programs hate win 7 and why no one but no
 one has a fix; this i got to hear.

 How do i turn off file extensions in windows 7 64 bit   -  later . .




 From: Andreas Säger [via Document Foundation Mail Archive] [hidden email]
 Subject: Re: Auto and Manual Spell do not work x
 To: Lostsoul [hidden email]
 Date: Sunday, October 14, 2012, 4:28 AM


 Am 14.10.2012 10:10, Lostsoul wrote:
       Ok now what the crap; why are abiword documents being saved as
 adobi docs how do i fix that can t get anything right crap .   -  later
 

 I strongly recommend some computer crash curse. File name associations
 are free.  There is nothing hard wired to the system. You can open any
 file with any program you want. You can tell your desktop environment
 which programs can open which types of files and which single program is
 the preferred one to be used on double-click.
 First of all, any user who is forced to use MS Windows should turn off
 the option to hide known file name extensions. Since Windows '95 this is
 the major obstacle which prevents people from understanding their system.



-- 
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



Fwd: Re: [libreoffice-users] Integer part of a number

2012-10-15 Thread Pertti Rönnberg

Hi everybody,
When I tried to give an answer to Gilles' basic question I proposed my 
formula based on the reality that I have never experienced negative voting.
The very interesting (theoretical) discussion this caused shows that 
there may be several correct solutions.


I can imagine that Gilles (and me too) is curious to know what is the 
best answer to his problem.
Even if I did (I admit) some overthinking I cannot see that my answer 
is wrong.


So, what is the best way for Gilles to continue?
Pertti Rönnberg


 Original Message 
Subject:Re: [libreoffice-users] Integer part of a number
Date:   Mon, 15 Oct 2012 10:49:51 +0300
From:   Pertti Rönnberg p...@elisanet.fi
To: users@global.libreoffice.org



Good morning Gilles  others,

Provided that I got your problem right,

I think the answer is:

SumVotes_group1 = 5,78(in Calc e.g. in cellC3)

SumVotes_group2 = 7,34(in C4)

SumVotes_group3= 0,78(in C5)

SumVotes_ group4= 0,99(in C6)

The answer could be:

a write following formula in(e.g.)cellD3 =IF(c31;0;INT(c3))

b copy the formula to d4..d6

The formula translated into english:

if value in cell c3 is /_less than_/ '1' then d3 shall be '0', else (-- 
if c3 is '1' or bigger then -- ) use the integer of value in c3)


I hope this is of help.

Pertti Rönnberg




On 14.10.2012 12:20, Gilles SICHE wrote:

Hello,

could anyone tell me which formula I should use for the integer part of a
cell to be shown in another cell, and for the value of this cell to be
changed, since, for example, 5,77 would become equal to 5?

When finding out who won in an election, if one group or party gets a
result of 5,28, they get 5 seats, if the result is 0,77, they get no seat
at all, I would then want the figure 5 and the figure 0 to appear in a
cell.

But I need the real value to be 5 and 0, not only to be shown as such,
since these values (0 and not 0,77) will be used in another operation (to
know which group gets the last remaining seat).

I hope my question is not too unclear, thank you for your answers anyway,

G. Siche







--
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: how to crack a PW in LO?

2012-10-15 Thread Tom Davies
Hi :)
Cat on the keyboard?  Keys in the pocket?
Regards from
Tom :)  


--- On Mon, 15/10/12, Ledger Consulting t...@theledgerfirm.com wrote:

From: Ledger Consulting t...@theledgerfirm.com
Subject: Re: [libreoffice-users] Re: how to crack a PW in LO?
To: ville...@t-online.de, users@global.libreoffice.org
Date: Monday, 15 October, 2012, 15:30

gvfe ..dtnd e eeir2 
Sent from my MetroPCS Android Device

Andreas Säger ville...@t-online.de wrote:

Am 15.10.2012 15:49, rost52 wrote:
 LO files can be protected with PWs when doing save as.
 Fighting currently with an xls file and its lost PW, I wonder how LO files 
 can be cracked? Can the
 MS related PW remover be used for LO as well?
 Thanks in advance for comments.
 
 


xls does not encript your document. The only thing that gets encrypted
is the password. Any old version of OpenOffice.org opens a password
protected xls ignoring the password.



-- 
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

-- 
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: how to crack a PW in LO?

2012-10-15 Thread Tom Davies
Hi :)  
The trick is to try to remember what you might have been thinking about at the 
time.  If that's even possible for anyone!  

There is no password cracking functionality or Extension for LO it's just the 
inept way MS fails to implement security.  Just double-click on an xls or open 
LO and drop the xls into it or open LO and choose 
File - Open
to navigate to and open the xls.  File opens.  

My company's finance department asked me to add something to one of their 
spreadsheets but 'forgot' to tell me the password.  One of them rushed down to 
give me the password but was somewhat mortified to find i had already made the 
change without having the slightest idea that there even was a password.  There 
was a very cofusing conversation where neither of us had a clue what the other 
was talking about until i figured it out.  

The company still uses Excel and still attempts to 'protect' those spreadsheets 
with passwords that don't work.  Occasionally people give me other files they 
want cracked which gives me a morale dilemma each time.  Usually i just give a 
really half-hearted non-effort and then fob them off.  
Regards from
Tom :)  


--- On Mon, 15/10/12, Dr. R. O Stapf reinh...@stapf-online.com wrote:

From: Dr. R. O Stapf reinh...@stapf-online.com
Subject: Re: [libreoffice-users] Re: how to crack a PW in LO?
To: users@global.libreoffice.org
Date: Monday, 15 October, 2012, 15:30


On 15.10.2012 23:11, Andreas Säger wrote:
 Am 15.10.2012 15:49, rost52 wrote:
 LO files can be protected with PWs when doing save as.
 Fighting currently with an xls file and its lost PW, I wonder how LO files 
 can be cracked? Can the
 MS related PW remover be used for LO as well?
 Thanks in advance for comments.



 xls does not encript your document. The only thing that gets encrypted
 is the password. Any old version of OpenOffice.org opens a password
 protected xls ignoring the password.
Thanks for the information. It seems that my version of LO 3.5.6.2 is too young 
to ignore the PW of 
an xls file.

However, my question was how to open an LO file if the PW get forgotten (not 
and MS file)?
Hints are welcome for the future.



-- 
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] Re: Auto and Manual Spell do not work x . . .

2012-10-15 Thread Tom Davies
Hi :)
One of the MS Word ones is what we were looking for.  Is there one that DOESN'T 
say template and IS for Word 97, 2000, 2003 or Xp?  Hopefully the list might 
show the file-ending as .doc
Regards from
Tom :)  


--- On Mon, 15/10/12, Robert Burns joyseyh...@yahoo.com wrote:

From: Robert Burns joyseyh...@yahoo.com
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . .
To: anne-ology lagin...@gmail.com, Tom Davies tomdavie...@yahoo.co.uk
Cc: users@global.libreoffice.org users@global.libreoffice.org
Date: Monday, 15 October, 2012, 15:13

 Ok  tryed another doc to save as; guess its a different format and these 
formats have been add ed to save as ODI  and  Cxw  and  Stw and 5 types/formats 
of Ms Word  . .

--- On Mon, 10/15/12, Tom Davies tomdavie...@yahoo.co.uk wrote:


From: Tom Davies tomdavie...@yahoo.co.uk
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . .
To: Robert Burns joyseyh...@yahoo.com, anne-ology lagin...@gmail.com
Cc: users@global.libreoffice.org users@global.libreoffice.org
Date: Monday, October 15, 2012, 9:54 AM




Hi :)
Hmmm, none of those sound even vaguely right.  Hopefully there are some more 
options if ou scroll backwards up the list?  
Regards from
Tom :)   









From: Robert Burns joyseyh...@yahoo.com
To: anne-ology lagin...@gmail.com 
Cc: users@global.libreoffice.org 
Sent: Monday, 15 October 2012, 0:44
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . .

 Ok trying saved  as but i see 6 choices so wondering whats the difference 
and which is better and does libre like one format above all ?
 
  RTF /  Text ? Html /  MHT /  WPt  and   WPS  . . .

--- On Sun, 10/14/12, anne-ology lagin...@gmail.com wrote:


From: anne-ology lagin...@gmail.com
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Cc: users@global.libreoffice.org
Date: Sunday, October 14, 2012, 7:17 PM


   When you save the document, click on 'save as' rather than 'save' -
          when you see the boxes come up, choose the suffix desired, then 
choose the folder desired; simple.




On Sun, Oct 14, 2012 at 6:06 PM, Lostsoul joyseyh...@yahoo.com wrote:


 Ok will try that but can i get a save doc switched over to save as and 
then choose a better format or maybe i ll try all saved as formats ? ?



From: anne-ology [via Document Foundation Mail Archive] 
ml-node+s969070n4013327...@n3.nabble.com

Subject: Re: Auto and Manual Spell do not work x
To: Lostsoul joyseyh...@yahoo.com
Date: Sunday, October 14, 2012, 7:02 PM



       A simple solution is to always use 'save as' rather than 'save' -
           then you merely choose the desired suffix as well as the desired
folder;
       with 'save', the computer does its own thing  ;-)





On Sun, Oct 14, 2012 at 3:27 AM, Andreas Säger [hidden email] wrote:

Am 14.10.2012 10:10, Lostsoul wrote:

       Ok now what the ***; why are abiword documents being saved as adobi
 docs how do i fix that can t get anything right *** .   -  later
 

 I strongly recommend some computer crash course. File name associations
 are free.  There is nothing hard wired to the system. You can open any
 file with any program you want. You can tell your desktop environment
 which programs can open which types of files and which single program is
 the preferred one to be used on double-click.
 First of all, any user who is forced to use MS Windows should turn off
 the option to hide known file name extensions. Since Windows '95 this is
 the major obstacle which prevents people from understanding their system.


-- 
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


-- 
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: Indexing for Search not working?

2012-10-15 Thread teatimest
I'm going back to v3.4 for now. I hope this issue is going to be solved
quickly.

Tea



--
View this message in context: 
http://nabble.documentfoundation.org/Indexing-for-Search-not-working-tp4013483p4013591.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: Indexing for Search not working?

2012-10-15 Thread Tom Davies
Hi :)
Have you tried renaming your User Profile to see if that fixes it?
http://wiki.documentfoundation.org/Documentation/UserProfile

Which 3.4.x are you returning to?  Does the indexing work there?  Have you been 
able to post a bug-report about the issue?  I think they want to know roughly 
which version is the earliest one where the problem appeared.  
http://wiki.documentfoundation.org/Bug_Report
Regards from
Tom :)


--- On Mon, 15/10/12, teatimest teatim...@gmail.com wrote:

From: teatimest teatim...@gmail.com
Subject: [libreoffice-users] Re: Indexing for Search not working?
To: users@global.libreoffice.org
Date: Monday, 15 October, 2012, 20:04

I'm going back to v3.4 for now. I hope this issue is going to be solved
quickly.

Tea



--
View this message in context: 
http://nabble.documentfoundation.org/Indexing-for-Search-not-working-tp4013483p4013591.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: how to crack a PW in LO?

2012-10-15 Thread Jay Lozier
On 10/15/2012 02:15 PM, Tom Davies wrote:
 Hi :)
 Cat on the keyboard?  Keys in the pocket?
 Regards from
 Tom :)  
Your cats spell better than mine (LOL)

 --- On Mon, 15/10/12, Ledger Consulting t...@theledgerfirm.com wrote:

 From: Ledger Consulting t...@theledgerfirm.com
 Subject: Re: [libreoffice-users] Re: how to crack a PW in LO?
 To: ville...@t-online.de, users@global.libreoffice.org
 Date: Monday, 15 October, 2012, 15:30

 gvfe ..dtnd e eeir2 
 Sent from my MetroPCS Android Device

 Andreas Säger ville...@t-online.de wrote:

 Am 15.10.2012 15:49, rost52 wrote:
 LO files can be protected with PWs when doing save as.
 Fighting currently with an xls file and its lost PW, I wonder how LO files 
 can be cracked? Can the
 MS related PW remover be used for LO as well?
 Thanks in advance for comments.



 xls does not encript your document. The only thing that gets encrypted
 is the password. Any old version of OpenOffice.org opens a password
 protected xls ignoring the password.



 -- 
 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


-- 
Jay Lozier
jsloz...@gmail.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



[libreoffice-users] Reality Check - Windows Java Accessibility API non-functional for ALL LibreOffice 3.6.x releases to date

2012-10-15 Thread Tom Davies
Hi :)
+1
A huge +1 really.  Just +1 doesn't really get close! 
Definitely impressive work from Stuart there!  Above and beyond gets
closer.  

I tried voting but found that really unclear, and i
have been editing wiki's for a while now.  I was able to add a comment
in support but i'm not sure if it's the type of thing they are looking
for.  

Stuart also gave links to the relevant bug-reports and i
have a feeling it might be easier to post comments there but only if
they help the devs get closer to fixing the problems, such as version
number of LO you are using and which OS (Windows Xp, Ubuntu or whatever)

I think the wiki wanted more conversational type comments but i wasn't sure 
what i should say.  
Regards from
Tom :)  


--- On Mon, 15/10/12, Kevin Cussick
 the.big.white.sheph...@googlemail.com wrote:

From: Kevin Cussick the.big.white.sheph...@googlemail.com
Subject: Re: [libreoffice-accessibility] Reality Check - Windows Java 
Accessibility API non-functional for ALL LibreOffice 3.6.x releases to date
To: V Stuart Foote vstuart.fo...@utsa.edu
Cc: accessibil...@global.libreoffice.org, libreoff...@lists.freedesktop.org, 
us...@glogal.libreoffice.org
Date: Monday, 15 October, 2012, 20:04

Hello,

No apology needed Stuart. You have done more than most and i would like to take 
this opportunity to thank you on list.

I knew the LO was not right but I now am pleased that someone from LO is now 
agreeing with me.  Anyway. moving on, I will take a look at the link to vote on 
the ticket to get accessibleIa2 added
 into the code for LO.  Let 
me once again thank you for all your effort and hard work on this. OK we don't 
have the result we would like but now we know we can maybe try and get a fix 
for it.


On 15/10/2012 01:10, V Stuart Foote wrote:
 LibreOffice versions 3.6.0 and later have not correctly implemented the Java 
 Access Bridge (JAB) modules used to expose the Java Accessibility API roles 
 for Windows users.

 It took me a little while to work out the testing methods, but the Oracle 
 test utilities JavaFerret-32 and JavaMonkey-32 show that LibreOffice is not 
 implementing the Java Accessibility API and therefore does not expose 
 accessibility roles to Assistive Technologies.

 Neither JAB v.2.0.2 or v 2.0.3, nor current JRE version 1.6u35 or 1.7u7 will 
 make a difference.

 I tested LibreOffice builds 3.6.0.4, 3.6.1.2, 3.6.2.2, and 3.6.3.1 none of 
 which are functional.

 In
 addition today I completed testing of ALL builds of LibreOffice from 3.4.5 to 
3.5.7rc2.  With exception of the 3.5.0 build they all correctly map Java 
Accessibility API roles to UNO Accessibility roles.

 The Java Accessibility API is not as comprehensive as the IAccessible2 role 
 mappings provided by IBM Lotus Symphony 3.0.1, but it is functional for the 
 3.4 and 3.5 releases of LibreOffice.  And, for these versions Windows  
 Assistive Technologies will work. For example, the Windows NVDA screen reader 
 will function with cursor control and component announcements for the entire 
 document tree.

 Windows versions of LibreOffice 3.6, including the current build 3.6.3 rc1, 
 are NOT USEABLE with Assistive Technologies and they have not been usable 
 with Windows Assistive Technologies at any point.

 For folks that I've mislead with my insistence that all is well with 
 LibreOffice 3.6 and Java Access Bridge
 and JRE with use of Assistive Technologies like NVDA screen reader I was 
wrong--I apologize.
 I've updated the FDO#53474 (http:  bug report 
 https://bugs.freedesktop.org/show_bug.cgi?id=53474 ) and would encourage 
 folks to vote, i.e. comment on, the enhancement to implement IAccessible2 
 API  ( http://wiki.documentfoundation.org/Vote_for_Enhancement ) for Windows 
 builds by incorporating the IBM contributed Symphony code base as a 
 replacement of the Java Accessibility API as that is probably the fastest 
 means of bringing Windows builds of LibreOffice to the same functional level 
 as Linux builds that use the ATK AT-SPI accessibility APIs.

 Stuart



-- 
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: how to delete an entire heading

2012-10-15 Thread Tinkerer
Alternatively.  try putting the cursor inside the blue drop down which
describes the Header style.
I have a Mac system 10.8.2

Tink.



--
View this message in context: 
http://nabble.documentfoundation.org/how-to-delete-an-entire-heading-tp4013210p4013605.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



[libreoffice-users] Re: Indexing for Search not working?

2012-10-15 Thread teatimest
Hi Tom. Thank you for your suggestion. I went back to the v3.4.6 that I have
the installer. I am rebuilding the search index and try to see if v3.4.6
allows me to search indexed contents again. The indexing worked there, so
I'm hoping this will work.

If not, I will try changing the profile. I tried to find similar bug report
but couldn't find one. Is your indexing working?

Tea



--
View this message in context: 
http://nabble.documentfoundation.org/Indexing-for-Search-not-working-tp4013483p4013610.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: how to crack a PW in LO?

2012-10-15 Thread Dr. R. O Stapf


On 16.10.2012 02:14, MR ZenWiz wrote:

On Mon, Oct 15, 2012 at 7:30 AM, Ledger Consulting
t...@theledgerfirm.com wrote:

gvfe ..dtnd e eeir2


What?


encrypted message - problem is that I cannot understand it.

--
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: how to crack a PW in LO?

2012-10-15 Thread webmaster-Kracked_P_P


When my cat was alive, he use to lay on the keyboard and not move.  He 
wanted the attention I gave the computer, since he was not getting it.  
I am not going to tell you how many time he messed thing up for me when 
he did that.  He use to lay down on, or sit on, the closed laptop just 
to tell me what he thought of it getting all his attention he should be 
getting and was not.


I just has to call my cell phone, a few minutes ago, to find where I put 
it down to.  Of course it was hiding in plain site, and in its new case 
I just got on Saturday.


Sometimes, no matter what we do, we can forget the important or loose 
things in plain site.


The same goes for passwords.  I bet it is something simple you would 
think to use but your mind refuses to remember.  I was thinking about 
needing to remember to web search a TV series title last night just 
after I turned the light out.  I should have written it down, since I 
cannot remember what it was at all this morning and all day today.  When 
I do not want to know what it is, then I MAY remember it, if it is not 
lost forever.


Hopefully you will have more luck than I have with remembering such 
things.  That is why I have a list of passwords I use, with some that I 
just use if there is a need for one but not a need to keep it from 
getting out.  pumpkin is the style of such a password.  Actually I 
love to use characters in stories I use to write when I was in school 
and needed something to relay me.




On 10/15/2012 03:20 PM, Jay Lozier wrote:

On 10/15/2012 02:15 PM, Tom Davies wrote:

Hi :)
Cat on the keyboard?  Keys in the pocket?
Regards from
Tom :)

Your cats spell better than mine (LOL)

--- On Mon, 15/10/12, Ledger Consulting t...@theledgerfirm.com wrote:

From: Ledger Consulting t...@theledgerfirm.com
Subject: Re: [libreoffice-users] Re: how to crack a PW in LO?
To: ville...@t-online.de, users@global.libreoffice.org
Date: Monday, 15 October, 2012, 15:30

gvfe ..dtnd e eeir2
Sent from my MetroPCS Android Device

Andreas Säger ville...@t-online.de wrote:


Am 15.10.2012 15:49, rost52 wrote:

LO files can be protected with PWs when doing save as.
Fighting currently with an xls file and its lost PW, I wonder how LO files can 
be cracked? Can the
MS related PW remover be used for LO as well?
Thanks in advance for comments.



xls does not encript your document. The only thing that gets encrypted
is the password. Any old version of OpenOffice.org opens a password
protected xls ignoring the password.



--
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] Re: how to crack a PW in LO?

2012-10-15 Thread Dr. R. O Stapf





On 16.10.2012 03:32, Tom Davies wrote:

Hi :)
The trick is to try to remember what you might have been thinking about at the 
time.  If that's even possible for anyone!

There is no password cracking functionality or Extension for LO it's just the 
inept way MS fails to implement security.  Just double-click on an xls or open 
LO and drop the xls into it or open LO and choose
File - Open
to navigate to and open the xls.  File opens.

My company's finance department asked me to add something to one of their 
spreadsheets but 'forgot' to tell me the password.  One of them rushed down to 
give me the password but was somewhat mortified to find i had already made the 
change without having the slightest idea that there even was a password.  There 
was a very cofusing conversation where neither of us had a clue what the other 
was talking about until i figured it out.

The company still uses Excel and still attempts to 'protect' those spreadsheets 
with passwords that don't work.  Occasionally people give me other files they 
want cracked which gives me a morale dilemma each time.  Usually i just give a 
really half-hearted non-effort and then fob them off.
Regards from
Tom :)


--- On Mon, 15/10/12, Dr. R. O Stapf reinh...@stapf-online.com wrote:

From: Dr. R. O Stapf reinh...@stapf-online.com
Subject: Re: [libreoffice-users] Re: how to crack a PW in LO?
To: users@global.libreoffice.org
Date: Monday, 15 October, 2012, 15:30


On 15.10.2012 23:11, Andreas Säger wrote:

Am 15.10.2012 15:49, rost52 wrote:

LO files can be protected with PWs when doing save as.
Fighting currently with an xls file and its lost PW, I wonder how LO files can 
be cracked? Can the
MS related PW remover be used for LO as well?
Thanks in advance for comments.



xls does not encript your document. The only thing that gets encrypted
is the password. Any old version of OpenOffice.org opens a password
protected xls ignoring the password.

Thanks for the information. It seems that my version of LO 3.5.6.2 is too young 
to ignore the PW of
an xls file.

However, my question was how to open an LO file if the PW get forgotten (not 
and MS file)?
Hints are welcome for the future.



Thanks to all of you providing me with lots of hints on not to forget passwords or prepare in 
advance for it.
The SW I am using to crack an xls-file runs already for more than 60 h in the background. It's a 
nothing to loose only to win job. 6 or 8 digits alphanumeric no special characters is the PW used.


Thereafter I will make a test cracking an LO file.

The only thing which makes me wonder is that there are PW removing SW commercially availabe which 
run demos and claim within 10 - 30 sec they could remove the PW but open the xls file only when I 
purchase a full license.


Does someone has experience with such a SW?


--
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: how to delete an entire heading

2012-10-15 Thread rost52

Hi Tink, as Steve pointed out there was a misunderstanding.

I was talking about heading in the sense of
1. topic a
1.1 topic b
1.2 topic c

I did not mean the header of the page.
But thanks for your attempt. I will make a bug/enhancement report an propose 
the method you mentioned.


On 16.10.2012 04:31, Tinkerer wrote:

Alternatively.  try putting the cursor inside the blue drop down which
describes the Header style.
I have a Mac system 10.8.2

Tink.



--
View this message in context: 
http://nabble.documentfoundation.org/how-to-delete-an-entire-heading-tp4013210p4013605.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



[libreoffice-users] Re: Auto and Manual Spell do not work x . . .

2012-10-15 Thread Lostsoul
    wow those formats seem so old hum nothing better to save as when i use 
libre ?

--- On Mon, 10/15/12, Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013589...@n3.nabble.com wrote:


From: Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013589...@n3.nabble.com
Subject: Re: Auto and Manual Spell do not work x . . .
To: Lostsoul joyseyh...@yahoo.com
Date: Monday, October 15, 2012, 2:55 PM


Hi :) 
One of the MS Word ones is what we were looking for.  Is there one that DOESN'T 
say template and IS for Word 97, 2000, 2003 or Xp?  Hopefully the list might 
show the file-ending as .doc 
Regards from 
Tom :)  


--- On Mon, 15/10/12, Robert Burns [hidden email] wrote: 

From: Robert Burns [hidden email] 
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . . 
To: anne-ology [hidden email], Tom Davies [hidden email] 
Cc: [hidden email] [hidden email] 
Date: Monday, 15 October, 2012, 15:13 

 Ok  tryed another doc to save as; guess its a different format and these 
formats have been add ed to save as ODI  and  Cxw  and  Stw and 5 types/formats 
of Ms Word  . . 

--- On Mon, 10/15/12, Tom Davies [hidden email] wrote: 


From: Tom Davies [hidden email] 
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . . 
To: Robert Burns [hidden email], anne-ology [hidden email] 
Cc: [hidden email] [hidden email] 
Date: Monday, October 15, 2012, 9:54 AM 




Hi :) 
Hmmm, none of those sound even vaguely right.  Hopefully there are some more 
options if ou scroll backwards up the list?  
Regards from 
Tom :)   









From: Robert Burns [hidden email] 
To: anne-ology [hidden email] 
Cc: [hidden email] 
Sent: Monday, 15 October 2012, 0:44 
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . . 

 Ok trying saved  as but i see 6 choices so wondering whats the difference 
and which is better and does libre like one format above all ? 
  
  RTF /  Text ? Html /  MHT /  WPt  and   WPS  . . . 

--- On Sun, 10/14/12, anne-ology [hidden email] wrote: 


From: anne-ology [hidden email] 
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Cc: [hidden email] 
Date: Sunday, October 14, 2012, 7:17 PM 


   When you save the document, click on 'save as' rather than 'save' - 
          when you see the boxes come up, choose the suffix desired, then 
choose the folder desired; simple. 




On Sun, Oct 14, 2012 at 6:06 PM, Lostsoul [hidden email] wrote: 


 Ok will try that but can i get a save doc switched over to save as and 
then choose a better format or maybe i ll try all saved as formats ? ? 



From: anne-ology [via Document Foundation Mail Archive] [hidden email] 

Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 7:02 PM 



       A simple solution is to always use 'save as' rather than 'save' - 
           then you merely choose the desired suffix as well as the desired 
folder; 
       with 'save', the computer does its own thing  ;-) 





On Sun, Oct 14, 2012 at 3:27 AM, Andreas Säger [hidden email] wrote: 

Am 14.10.2012 10:10, Lostsoul wrote: 


       Ok now what the ***; why are abiword documents being saved as adobi 
 docs how do i fix that can t get anything right *** .   -  later 
  
 
 I strongly recommend some computer crash course. File name associations 
 are free.  There is nothing hard wired to the system. You can open any 
 file with any program you want. You can tell your desktop environment 
 which programs can open which types of files and which single program is 
 the preferred one to be used on double-click. 
 First of all, any user who is forced to use MS Windows should turn off 
 the option to hide known file name extensions. Since Windows '95 this is 
 the major obstacle which prevents people from understanding their system. 
 
-- 
For unsubscribe instructions e-mail to: [hidden email] 
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: [hidden email] 
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: [hidden email] 
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 

Re: [libreoffice-users] Re: how to crack a PW in LO?

2012-10-15 Thread Jean-Louis Oneto

I used the following:
http://www.crackpdf.com/
but not the Pro version which allows to make brute force attack, but 
then, they warn you that it will take _a_long_time_ !!!
To remove simple protections, it was really fast, but they unlock the 
file without retrieving the password (or at least they don't display it)

Reards,
Jean-Louis

On 16/10/2012 00:23, Dr. R. O Stapf wrote:





On 16.10.2012 03:32, Tom Davies wrote:

Hi :)
The trick is to try to remember what you might have been thinking 
about at the time.  If that's even possible for anyone!


There is no password cracking functionality or Extension for LO it's 
just the inept way MS fails to implement security.  Just double-click 
on an xls or open LO and drop the xls into it or open LO and choose

File - Open
to navigate to and open the xls.  File opens.

My company's finance department asked me to add something to one of 
their spreadsheets but 'forgot' to tell me the password.  One of them 
rushed down to give me the password but was somewhat mortified to 
find i had already made the change without having the slightest idea 
that there even was a password.  There was a very cofusing 
conversation where neither of us had a clue what the other was 
talking about until i figured it out.


The company still uses Excel and still attempts to 'protect' those 
spreadsheets with passwords that don't work.  Occasionally people 
give me other files they want cracked which gives me a morale dilemma 
each time.  Usually i just give a really half-hearted non-effort and 
then fob them off.

Regards from
Tom :)


--- On Mon, 15/10/12, Dr. R. O Stapf reinh...@stapf-online.com wrote:

From: Dr. R. O Stapf reinh...@stapf-online.com
Subject: Re: [libreoffice-users] Re: how to crack a PW in LO?
To: users@global.libreoffice.org
Date: Monday, 15 October, 2012, 15:30


On 15.10.2012 23:11, Andreas Säger wrote:

Am 15.10.2012 15:49, rost52 wrote:

LO files can be protected with PWs when doing save as.
Fighting currently with an xls file and its lost PW, I wonder how 
LO files can be cracked? Can the

MS related PW remover be used for LO as well?
Thanks in advance for comments.



xls does not encript your document. The only thing that gets encrypted
is the password. Any old version of OpenOffice.org opens a password
protected xls ignoring the password.
Thanks for the information. It seems that my version of LO 3.5.6.2 is 
too young to ignore the PW of

an xls file.

However, my question was how to open an LO file if the PW get 
forgotten (not and MS file)?

Hints are welcome for the future.



Thanks to all of you providing me with lots of hints on not to forget 
passwords or prepare in advance for it.
The SW I am using to crack an xls-file runs already for more than 60 h 
in the background. It's a nothing to loose only to win job. 6 or 8 
digits alphanumeric no special characters is the PW used.


Thereafter I will make a test cracking an LO file.

The only thing which makes me wonder is that there are PW removing SW 
commercially availabe which run demos and claim within 10 - 30 sec 
they could remove the PW but open the xls file only when I purchase a 
full license.


Does someone has experience with such a SW?




--
Jean-Louis Oneto
email: jl.on...@free.fr


--
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: Auto and Manual Spell do not work x . . .

2012-10-15 Thread Ledger Consulting
Bxww d 
Sent from my MetroPCS Android Device

Lostsoul joyseyh...@yahoo.com wrote:

    wow those formats seem so old hum nothing better to save as when i use 
libre ?

--- On Mon, 10/15/12, Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013589...@n3.nabble.com wrote:


From: Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013589...@n3.nabble.com
Subject: Re: Auto and Manual Spell do not work x . . .
To: Lostsoul joyseyh...@yahoo.com
Date: Monday, October 15, 2012, 2:55 PM


Hi :) 
One of the MS Word ones is what we were looking for.  Is there one that 
DOESN'T say template and IS for Word 97, 2000, 2003 or Xp?  Hopefully the 
list might show the file-ending as .doc 
Regards from 
Tom :)  


--- On Mon, 15/10/12, Robert Burns [hidden email] wrote: 

From: Robert Burns [hidden email] 
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . . 
To: anne-ology [hidden email], Tom Davies [hidden email] 
Cc: [hidden email] [hidden email] 
Date: Monday, 15 October, 2012, 15:13 

 Ok  tryed another doc to save as; guess its a different format and these 
formats have been add ed to save as ODI  and  Cxw  and  Stw and 5 
types/formats of Ms Word  . . 

--- On Mon, 10/15/12, Tom Davies [hidden email] wrote: 


From: Tom Davies [hidden email] 
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . . 
To: Robert Burns [hidden email], anne-ology [hidden email] 
Cc: [hidden email] [hidden email] 
Date: Monday, October 15, 2012, 9:54 AM 




Hi :) 
Hmmm, none of those sound even vaguely right.  Hopefully there are some more 
options if ou scroll backwards up the list?  
Regards from 
Tom :)   









From: Robert Burns [hidden email] 
To: anne-ology [hidden email] 
Cc: [hidden email] 
Sent: Monday, 15 October 2012, 0:44 
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . . 

 Ok trying saved  as but i see 6 choices so wondering whats the difference 
and which is better and does libre like one format above all ? 
  
  RTF /  Text ? Html /  MHT /  WPt  and   WPS  . . . 

--- On Sun, 10/14/12, anne-ology [hidden email] wrote: 


From: anne-ology [hidden email] 
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Cc: [hidden email] 
Date: Sunday, October 14, 2012, 7:17 PM 


   When you save the document, click on 'save as' rather than 'save' - 
          when you see the boxes come up, choose the suffix desired, then 
choose the folder desired; simple. 




On Sun, Oct 14, 2012 at 6:06 PM, Lostsoul [hidden email] wrote: 


 Ok will try that but can i get a save doc switched over to save as and 
then choose a better format or maybe i ll try all saved as formats ? ? 



From: anne-ology [via Document Foundation Mail Archive] [hidden email] 

Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 7:02 PM 



       A simple solution is to always use 'save as' rather than 'save' - 
           then you merely choose the desired suffix as well as the desired 
folder; 
       with 'save', the computer does its own thing  ;-) 





On Sun, Oct 14, 2012 at 3:27 AM, Andreas Säger [hidden email] wrote: 

Am 14.10.2012 10:10, Lostsoul wrote: 


       Ok now what the ***; why are abiword documents being saved as adobi 
 docs how do i fix that can t get anything right *** .   -  later 
  
 
 I strongly recommend some computer crash course. File name associations 
 are free.  There is nothing hard wired to the system. You can open any 
 file with any program you want. You can tell your desktop environment 
 which programs can open which types of files and which single program is 
 the preferred one to be used on double-click. 
 First of all, any user who is forced to use MS Windows should turn off 
 the option to hide known file name extensions. Since Windows '95 this is 
 the major obstacle which prevents people from understanding their system. 
 
-- 
For unsubscribe instructions e-mail to: [hidden email] 
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: [hidden email] 
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: [hidden email] 
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: 

Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . .

2012-10-15 Thread Robert Burns
Weird what are i missing here; no comments included ??? 

--- On Mon, 10/15/12, Ledger Consulting t...@theledgerfirm.com wrote:


From: Ledger Consulting t...@theledgerfirm.com
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . .
To: Lostsoul joyseyh...@yahoo.com, users@global.libreoffice.org
Date: Monday, October 15, 2012, 8:33 PM


Bxww d 
Sent from my MetroPCS Android Device

Lostsoul joyseyh...@yahoo.com wrote:

    wow those formats seem so old hum nothing better to save as when i use 
libre ?

--- On Mon, 10/15/12, Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013589...@n3.nabble.com wrote:


From: Tom [via Document Foundation Mail Archive] 
ml-node+s969070n4013589...@n3.nabble.com
Subject: Re: Auto and Manual Spell do not work x . . .
To: Lostsoul joyseyh...@yahoo.com
Date: Monday, October 15, 2012, 2:55 PM


Hi :) 
One of the MS Word ones is what we were looking for.  Is there one that 
DOESN'T say template and IS for Word 97, 2000, 2003 or Xp?  Hopefully the 
list might show the file-ending as .doc 
Regards from 
Tom :)  


--- On Mon, 15/10/12, Robert Burns [hidden email] wrote: 

From: Robert Burns [hidden email] 
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . . 
To: anne-ology [hidden email], Tom Davies [hidden email] 
Cc: [hidden email] [hidden email] 
Date: Monday, 15 October, 2012, 15:13 

 Ok  tryed another doc to save as; guess its a different format and these 
formats have been add ed to save as ODI  and  Cxw  and  Stw and 5 
types/formats of Ms Word  . . 

--- On Mon, 10/15/12, Tom Davies [hidden email] wrote: 


From: Tom Davies [hidden email] 
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . . 
To: Robert Burns [hidden email], anne-ology [hidden email] 
Cc: [hidden email] [hidden email] 
Date: Monday, October 15, 2012, 9:54 AM 




Hi :) 
Hmmm, none of those sound even vaguely right.  Hopefully there are some more 
options if ou scroll backwards up the list?  
Regards from 
Tom :)   









From: Robert Burns [hidden email] 
To: anne-ology [hidden email] 
Cc: [hidden email] 
Sent: Monday, 15 October 2012, 0:44 
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x . . . 

 Ok trying saved  as but i see 6 choices so wondering whats the difference 
and which is better and does libre like one format above all ? 
  
  RTF /  Text ? Html /  MHT /  WPt  and   WPS  . . . 

--- On Sun, 10/14/12, anne-ology [hidden email] wrote: 


From: anne-ology [hidden email] 
Subject: Re: [libreoffice-users] Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Cc: [hidden email] 
Date: Sunday, October 14, 2012, 7:17 PM 


   When you save the document, click on 'save as' rather than 'save' - 
          when you see the boxes come up, choose the suffix desired, then 
choose the folder desired; simple. 




On Sun, Oct 14, 2012 at 6:06 PM, Lostsoul [hidden email] wrote: 


 Ok will try that but can i get a save doc switched over to save as and 
then choose a better format or maybe i ll try all saved as formats ? ? 



From: anne-ology [via Document Foundation Mail Archive] [hidden email] 

Subject: Re: Auto and Manual Spell do not work x 
To: Lostsoul [hidden email] 
Date: Sunday, October 14, 2012, 7:02 PM 



       A simple solution is to always use 'save as' rather than 'save' - 
           then you merely choose the desired suffix as well as the desired 
folder; 
       with 'save', the computer does its own thing  ;-) 





On Sun, Oct 14, 2012 at 3:27 AM, Andreas Säger [hidden email] wrote: 

Am 14.10.2012 10:10, Lostsoul wrote: 


       Ok now what the ***; why are abiword documents being saved as adobi 
 docs how do i fix that can t get anything right *** .   -  later 
  
 
 I strongly recommend some computer crash course. File name associations 
 are free.  There is nothing hard wired to the system. You can open any 
 file with any program you want. You can tell your desktop environment 
 which programs can open which types of files and which single program is 
 the preferred one to be used on double-click. 
 First of all, any user who is forced to use MS Windows should turn off 
 the option to hide known file name extensions. Since Windows '95 this is 
 the major obstacle which prevents people from understanding their system. 
 
-- 
For unsubscribe instructions e-mail to: [hidden email] 
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: [hidden email] 
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: 

Re: [libreoffice-users] Re: Integer part of a number

2012-10-15 Thread Brian Barker

At 11:56 15/10/2012 -0400, James Knott wrote:

Brian Barker wrote:

Now you are assuming (1) that negative election results are possible,


I was just posting in reference to comment about negative numbers 
and not the original post.


That makes your suggestion (of applying ABS() to the values) even 
more surprising!  If you get a negative value and you are surprised 
by it, you had better determine what has gone wrong - perhaps a 
mistake either in data entry or else in the algorithm used in your 
calculations.  If your deliberations lead you to replace the negative 
value by a positive one, it would be very naive to imagine that the 
equivalent positive value is necessarily any more appropriate than 
any other non-negative value.


If your bank manager reports that you are overdrawn, do you make a 
correcting deposit or do you merely offer the helpful suggestion that 
s/he should use correcting fluid to excise the negative sign from 
your balance?  If you believe there is a valuable mineral deposit ten 
metres under your back garden but you do not fancy digging down to 
it, do you simply build a ten-meter tower instead and expect to 
harvest the deposit up in the air?  If you have three metres of 
string available and need to use five metres of it, does that mean 
you will have two metres left over?


Brian Barker


--
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: Fwd: Re: [libreoffice-users] Integer part of a number

2012-10-15 Thread Brian Barker

At 21:13 15/10/2012 +0300, Pertti Rönnberg wrote:

At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote:

On 14.10.2012 12:20, Gilles SICHE wrote:
could anyone tell me which formula I should 
use for the integer part of a cell to be shown 
in another cell, and for the value of this 
cell to be changed, since, for example, 5,77 would become equal to 5?


The answer could be:
a write following formula in(e.g.)cellD3 =IF(c31;0;INT(c3))


When I tried to give an answer to Gilles' basic 
question I proposed my formula based on the 
reality that I have never experienced negative 
voting.  The very interesting (theoretical) 
discussion this caused shows that there may be several correct solutions.


I can imagine that Gilles (and me too) is 
curious to know what is the best answer to his 
problem.  Even if I did (I admit) some 
overthinking I cannot see that my answer is wrong.


No, your answer was not wrong, but it was 
unnecessarily complicated - like adding zero to 
something: not wrong but pointless and 
confusing.  For non-negative C3, 
=IF(C31;0;INT(C3)) is identical to and no better than =INT(C3).



So, what is the best way for Gilles to continue?


Using INT(), as was suggested in the very first 
reply (before any of my comments).


Brian Barker


--
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: how to crack a PW in LO?

2012-10-15 Thread Dr. R. O Stapf


On 16.10.2012 09:40, Jean-Louis Oneto wrote:

I used the following:
http://www.crackpdf.com/
but not the Pro version which allows to make brute force attack, but then, they warn you that it 
will take _a_long_time_ !!!
To remove simple protections, it was really fast, but they unlock the file without retrieving the 
password (or at least they don't display it)

Reards,
Jean-Louis 


Jean-Louis, thanks for the hint and link!




--
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