Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular document

2013-02-12 Thread Tom Davies
Hi :)
Doc is the older MS format and it is generally possible to open in pretty much 
any office program.  It's rare but possible to find the odd one or 2 rare cases 
that don't open fairly perfectly.  Those rare cases probably open slightly 
differently in different office programs so try AbiWord, google-docs, 
KOffice/Caligra or anything else.  Of course MS had to move away from that 
format for various reasons, perhaps such as 
1.  security issues had been widely reported over the years
2.  why would people pay to upgrade to the newer version of their office 
program if there current one or free ones worked?  
Any MS format is likely to suffer from interoperability issues because of that 
2nd alleged reason.  Remember Rtf and the infamous court case?  

DocX is the newer MS format and even MS Office has troubles with it.  A 
document written in MSO 2007 is unlikely to look quite right in MSO 2010 or 
2013 or 365 and vice-versa.  You are kinda pushed into finding out what most 
other people are using and then buying that version.  It gets worse.  According 
to the MS installer for MSO 2010 a document created in MSO 2010 on Xp will 
probably look different in MSO 2010 on Win7.  

So, if you want to share documents or archive them to read some day in the 
future then the best bet for most people right now is to save in the older MS 
format.  The one that has been  known to have security problems over the years. 
 

However, Odt is being used more and more often.  MSO 2010 used the older 
version despite everyone else using the newer one so documents didn't always 
look quite right.  MSO 2013 has promised to use the 1.2 version that everyone 
else has been using for years.  It's more reliable because it's not dependant 
on the whims of just 1 company and many companies get together to agree on it.  

MS is unlikely to go bankrupt any time soon.  The greater danger is that they 
keep 'accidentally' not quite implementing formats in they way that they 
promise through their ISO standards agreements or documentation.  It's 
allegedly why Rtf failed according to the court case.  

The other inevitable problem is that any editable document will look diffeent 
on different machines anyway.  Different default printers, different 
paper-sizes, perhaps screen-resolution (unlikely) and a whole slew of other 
variables all affect the way text flows on a document.  

The standard answer is to send a Pdf along with the editable version.  

Btw the English phrase I'm afraid should only be used sparingly and never by 
a fearless user of OpenSource.  Stay smug and aloof.  Let people continue to 
use whatever cr#$£*p they are determined to use but just sometimes let them 
know when their documents are likely to or already have failed.  If you can 
install LibreOffice without them being unhappy and without it potentially 
getting you in trouble then do.  

Once the programs that can handle ODF are out there then it's easier to get 
people to use the format.  
Regards from
Tom :)  






 From: C. H. D. webofht-libreoffice...@yahoo.com.hk
To: LibreOffice User Support Mailing List users@global.libreoffice.org 
Sent: Tuesday, 12 February 2013, 7:27
Subject: Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular 
document
 
Hello!

 
Yes, my Microsoft Office is legal. (Just happened that many other people use 
it.)


I think it is an interoperability issue.

I searched the Internet and looked for documents randomly to test if 
LibreOffice can open them. This is the authentic test.


I cannot contact the author since the document was downloaded randomly.


If Microsoft Office opens the .doc files correctly, LibreOffice should also 
open them correctly.


If Microsoft went bankrupt, what office suite would be able to handle 
thousands of .doc files?

Then, the data in the .doc files would be lost if no other office suite was 
able to open them, I am afraid.

Not many people like converting .doc files into .odt files, I am afraid.


Regards,

C. H. D. 


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 












寄件人︰ e-letter inp...@gmail.com
收件人︰ C. H. D. webofht-libreoffice...@yahoo.com.hk 
副本(CC)︰ LibreOffice User Support Mailing List users@global.libreoffice.org 
傳送日期︰ 2013年02月12日 (週二) 2:37 PM
主題︰ Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular 
document

On 11/02/2013, C. H. D. webofht-libreoffice...@yahoo.com.hk wrote:


 Hello!


 I cannot open a particular file in LibreOffice, but I can open it in
 Microsoft Office.


Good for you; your copy of m$ is legal?

 I would appreciate it if you take a look.


 https://bugs.freedesktop.org/show_bug.cgi?id=60390


Not a bug, unless the original document was created in odf. Did you
contact the author and explain that the document cannot be opened in
LO? What did the author say?
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? 

Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular document

2013-02-12 Thread e-letter
On 12/02/2013, C. H. D. webofht-libreoffice...@yahoo.com.hk wrote:
 Hello!


 Yes, my Microsoft Office is legal. (Just happened that many other people use
 it.)


 I think it is an interoperability issue.


If you are very concerned about interoperability, you should be
contacting m$ and ask them why they cannot open odf documents created
using LO. Have you done this?

 I searched the Internet and looked for documents randomly to test if
 LibreOffice can open them. This is the authentic test.


No, a more authentic test is to search for odf documents and compare
of LO and m$ opens these types of documents.


 If Microsoft Office opens the .doc files correctly, LibreOffice should also
 open them correctly.


No, LO is not a m$-clone. If LO opens the odt document correctly, m$
should also. Have you tested this?


 If Microsoft went bankrupt, what office suite would be able to handle
 thousands of .doc files?


Unlikely, but that is the fault entirely of the user that creates the
document in the m$ file format!!!

If LO, or any other odf-compliant software disappears, you can find
another. That is why you should be testing interoperability with odf
and not m$ formats.

 Then, the data in the .doc files would be lost if no other office suite was
 able to open them, I am afraid.


I hope that happens (but a small possibility).

 Not many people like converting .doc files into .odt files, I am afraid.


That is their choice. Start creating documents in odf!

-- 
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: LO 4 documentation

2013-02-12 Thread Marc Paré

Hi Caesar,

Le 2013-02-11 17:17, Caesar a écrit :



Thank you Marc for the invitation, but I just started using LO 3.6.4 a
few months ago, and LO 4.0.0 a week or so ago, so I really don't know
much about how it works.  I'm definitely at the start of the learning
curve.   I can't imagine I would be of much help, except by making
donations, which I have already done a couple of times.

Until I learn more, I believe that is how I can be most helpful.



Many thanks for your contribution which are well appreciated. Your 
donations will be put to good use.


If you ever feel like contributing with more hands on rather than 
donations, feel free to ask here on the list or write me and I can help 
with some suggestions. We have a need for help for all kinds of talented 
people on the project, no matter what level. The amount of time our 
volunteers contribute is a little as approximately 15 minutes a week to 
x-hours; the time factor is really not an issue with the project 
volunteer-contributors.


Hope you enjoy the suite!

Cheers,

Marc


--
Marc Paré
m...@marcpare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org


--
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] Libre Office 4

2013-02-12 Thread Tom Davies
Hi :)
It would be nice if you could post a bug-report about the issue
https://wiki.documentfoundation.org/BugReport

as doing so increases the chances of people working on the issue.  In the 
process of filing the bug-report it hopefully shows a list of similat items so 
you might find someone else has alreay reported it.  If you do find someone has 
then just add a comment to try to help the devs pinpoint the problem faster.  

If you don't have time to post a bug report it might still get dealt with but 
it might take longer before people find that it's a problem.
Regards from 
Tom :)  






 From: cul...@earthlink.net cul...@earthlink.net
To: users@global.libreoffice.org 
Sent: Tuesday, 12 February 2013, 7:00
Subject: [libreoffice-users] Libre Office 4
 
I was using 3.6+. Have been using Libre Office since it began. I downloaded 
and installed 4 ran into a problem: the spreadsheet module does not link to 
other software as 3.6 does. One of the the things I use the spreadsheet for is 
to analyze certain stock market items which (in 3.6) are properly linked to an 
investment program I use via Dynamic Data Exchange (DDE) plug-ins.

Everything worked with 3.6 so I had to uninstall 4 and reinstall 3.6 in order 
for things to properly function. Anyone know if this has been or will be 
addressed? Thanks


--/* Phil */

--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] Bug 60390 - FILEOPEN: Cannot open particular document

2013-02-12 Thread Mirosław Zalewski
On 12/02/2013 at 10:53, e-letter inp...@gmail.com wrote:

 If LO, or any other odf-compliant software disappears, you can find
 another. 

Yeah, especially since LO default saving format incorporates number of non-
standard extensions that other ODF-compliant software will just ignore.

Don't get me wrong - I appreciate many of these extensions, as they give me 
ability to use great features not covered by ODF spec.

But I am also worried by the fact, that over thirty years after introducing 
first word processor software, we are still at a stage where documents can be 
freely exchanged only by users of the same software in the same version.
-- 
Best regards
Mirosław Zalewski

-- 
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] Bug 60390 - FILEOPEN: Cannot open particular document

2013-02-12 Thread pasqual milvaques pons
in situations like this, independently of the work to be done to make 
libreoffice capable of opening those files you can use a version of 
microsoft office which supports odf to convert the file to odt. this can 
be an effective workaround


I attach you the converted file (using microsoft office 2013). you can 
use these software to do the conversion from a shell:

http://code.officeshots.org/trac/officeshots/browser/trunk/OfficeConvert

I attach also a bat file which can help to automatize the conversion process

best regards


Al 12/02/2013 13:29, En/na C. H. D. ha escrit:

Hello!

Do I support LibreOffice? Yes, I do.

Let me show some positive numbers:

When I downloaded 400 .doc files, I opened 399 files in LibreOffice.

Only 1 could not be opened.

All 400 files were smaller than or equal to 692.5 KB. I started the testing 
from the smallest file to the largest file. It happened to be that I could not 
open that one file which was 692.5 KB.

I am not a Maths expert. 399/400 = 99.75%

Congratulations! This is excellent! Well done.

To make a rough conclusion, I claim in a reasonable way that LibreOffice can 
open 99.75% of the .doc files I may come across in future if these files are 
smaller than 700KB.

I do not know if these numbers are scientific enough. However, such information 
definitely helps me to say that LibreOffice 4 is really good!

Microsoft Office is not my area of interest, by the way. It is just that 
someone uses it. There were cases when Word could not open .doc files in the 
past. These cases are not my area of interest.

Regards,

C. H. D.


  





_ _ _ _ _ _ _ _ _ _ _ _ _ _ _












  寄件人︰ e-letterinp...@gmail.com
收件人︰ C. H. D.webofht-libreoffice...@yahoo.com.hk  
副本(CC)︰ LibreOffice User Support Mailing Listusers@global.libreoffice.org  
傳送日期︰ 2013年02月12日 (週二) 5:53 PM

主題︰ Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular 
document
  
On 12/02/2013, C. H. D.webofht-libreoffice...@yahoo.com.hk  wrote:

Hello!


Yes, my Microsoft Office is legal. (Just happened that many other people use
it.)


I think it is an interoperability issue.


If you are very concerned about interoperability, you should be
contacting m$ and ask them why they cannot open odf documents created
using LO. Have you done this?


I searched the Internet and looked for documents randomly to test if
LibreOffice can open them. This is the authentic test.


No, a more authentic test is to search for odf documents and compare
of LO and m$ opens these types of documents.


If Microsoft Office opens the .doc files correctly, LibreOffice should also
open them correctly.


No, LO is not a m$-clone. If LO opens the odt document correctly, m$
should also. Have you tested this?


If Microsoft went bankrupt, what office suite would be able to handle
thousands of .doc files?


Unlikely, but that is the fault entirely of the user that creates the
document in the m$ file format!!!

If LO, or any other odf-compliant software disappears, you can find
another. That is why you should be testing interoperability with odf
and not m$ formats.


Then, the data in the .doc files would be lost if no other office suite was
able to open them, I am afraid.


I hope that happens (but a small possibility).


Not many people like converting .doc files into .odt files, I am afraid.


That is their choice. Start creating documents in odf!




--
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] Bug 60390 - FILEOPEN: Cannot open particular document

2013-02-12 Thread pasqual milvaques pons

this mailing like doesn't like attachments, you can download it from there:
convertidor_odf.7z (320 KB)
https://mega.co.nz/#!o8IXHa7Q!JgsZ0xKsAagxtkHxy-c2lnacVUdN6zPJRcCGyJ_oRbo

best regards


Al 12/02/2013 13:58, En/na pasqual milvaques pons ha escrit:
in situations like this, independently of the work to be done to make 
libreoffice capable of opening those files you can use a version of 
microsoft office which supports odf to convert the file to odt. this 
can be an effective workaround


I attach you the converted file (using microsoft office 2013). you can 
use these software to do the conversion from a shell:

http://code.officeshots.org/trac/officeshots/browser/trunk/OfficeConvert

I attach also a bat file which can help to automatize the conversion 
process


best regards


Al 12/02/2013 13:29, En/na C. H. D. ha escrit:

Hello!

Do I support LibreOffice? Yes, I do.

Let me show some positive numbers:

When I downloaded 400 .doc files, I opened 399 files in LibreOffice.

Only 1 could not be opened.

All 400 files were smaller than or equal to 692.5 KB. I started the 
testing from the smallest file to the largest file. It happened to be 
that I could not open that one file which was 692.5 KB.


I am not a Maths expert. 399/400 = 99.75%

Congratulations! This is excellent! Well done.

To make a rough conclusion, I claim in a reasonable way that 
LibreOffice can open 99.75% of the .doc files I may come across in 
future if these files are smaller than 700KB.


I do not know if these numbers are scientific enough. However, such 
information definitely helps me to say that LibreOffice 4 is really 
good!


Microsoft Office is not my area of interest, by the way. It is just 
that someone uses it. There were cases when Word could not open .doc 
files in the past. These cases are not my area of interest.


Regards,

C. H. D.






_ _ _ _ _ _ _ _ _ _ _ _ _ _ _












  寄件人︰ e-letterinp...@gmail.com
收件人︰ C. H. D.webofht-libreoffice...@yahoo.com.hk 副本(CC)︰ 
LibreOffice User Support Mailing Listusers@global.libreoffice.org  
傳送日期︰ 2013年02月12日 (週二) 5:53 PM
主題︰ Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open 
particular document

  On 12/02/2013, C. H. D.webofht-libreoffice...@yahoo.com.hk  wrote:

Hello!


Yes, my Microsoft Office is legal. (Just happened that many other 
people use

it.)


I think it is an interoperability issue.


If you are very concerned about interoperability, you should be
contacting m$ and ask them why they cannot open odf documents created
using LO. Have you done this?


I searched the Internet and looked for documents randomly to test if
LibreOffice can open them. This is the authentic test.


No, a more authentic test is to search for odf documents and compare
of LO and m$ opens these types of documents.

If Microsoft Office opens the .doc files correctly, LibreOffice 
should also

open them correctly.


No, LO is not a m$-clone. If LO opens the odt document correctly, m$
should also. Have you tested this?


If Microsoft went bankrupt, what office suite would be able to handle
thousands of .doc files?


Unlikely, but that is the fault entirely of the user that creates the
document in the m$ file format!!!

If LO, or any other odf-compliant software disappears, you can find
another. That is why you should be testing interoperability with odf
and not m$ formats.

Then, the data in the .doc files would be lost if no other office 
suite was

able to open them, I am afraid.


I hope that happens (but a small possibility).

Not many people like converting .doc files into .odt files, I am 
afraid.



That is their choice. Start creating documents in odf!








--
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] Bug 60390 - FILEOPEN: Cannot open particular document

2013-02-12 Thread C. H. D.


 
Thanks for the idea.

I would say that the development team responded very quickly. When I submitted 
a bug regarding not being able to open an OpenDocument file, the development 
team figured out the issue and made a patch in three days! Amazingly fast!

I test that OpenDocument file and it will open in LibreOffice 4 (current 
version). Great!

I think the development team will work it out soon. 


LibreOffice is good because the development team responds quickly.


Regards,

C. H. D.


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 












 寄件人︰ pasqual milvaques pons milvaques_...@gva.es
收件人︰ pasqual milvaques pons milvaques_...@gva.es 
副本(CC)︰ LibreOffice User Support Mailing List users@global.libreoffice.org 
傳送日期︰ 2013年02月12日 (週二) 9:14 PM
主題︰ Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular 
document
 
this mailing like doesn't like attachments, you can download it from there:
convertidor_odf.7z (320 KB)
https://mega.co.nz/#!o8IXHa7Q!JgsZ0xKsAagxtkHxy-c2lnacVUdN6zPJRcCGyJ_oRbo

best regards


Al 12/02/2013 13:58, En/na pasqual milvaques pons ha escrit:
 in situations like this, independently of the work to be done to make 
 libreoffice capable of opening those files you can use a version of microsoft 
 office which supports odf to convert the file to odt. this can be an 
 effective workaround
 
 I attach you the converted file (using microsoft office 2013). you can use 
 these software to do the conversion from a shell:
 http://code.officeshots.org/trac/officeshots/browser/trunk/OfficeConvert
 
 I attach also a bat file which can help to automatize the conversion process
 
 best regards
 
 
 Al 12/02/2013 13:29, En/na C. H. D. ha escrit:
 Hello!
 
 Do I support LibreOffice? Yes, I do.
 
 Let me show some positive numbers:
 
 When I downloaded 400 .doc files, I opened 399 files in LibreOffice.
 
 Only 1 could not be opened.
 
 All 400 files were smaller than or equal to 692.5 KB. I started the testing 
 from the smallest file to the largest file. It happened to be that I could 
 not open that one file which was 692.5 KB.
 
 I am not a Maths expert. 399/400 = 99.75%
 
 Congratulations! This is excellent! Well done.
 
 To make a rough conclusion, I claim in a reasonable way that LibreOffice can 
 open 99.75% of the .doc files I may come across in future if these files are 
 smaller than 700KB.
 
 I do not know if these numbers are scientific enough. However, such 
 information definitely helps me to say that LibreOffice 4 is really good!
 
 Microsoft Office is not my area of interest, by the way. It is just that 
 someone uses it. There were cases when Word could not open .doc files in the 
 past. These cases are not my area of interest.
 
 Regards,
 
 C. H. D.
 
 
 
 
 
 
 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
 
 
 
 
 
 
 
 
 
 
 
 
   寄件人︰ e-letterinp...@gmail.com
 收件人︰ C. H. D.webofht-libreoffice...@yahoo.com.hk 副本(CC)︰ LibreOffice User 
 Support Mailing Listusers@global.libreoffice.org  傳送日期︰ 2013年02月12日 (週二) 
 5:53 PM
 主題︰ Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular 
 document
   On 12/02/2013, C. H. D.webofht-libreoffice...@yahoo.com.hk  wrote:
 Hello!
 
 
 Yes, my Microsoft Office is legal. (Just happened that many other people use
 it.)
 
 
 I think it is an interoperability issue.
 
 If you are very concerned about interoperability, you should be
 contacting m$ and ask them why they cannot open odf documents created
 using LO. Have you done this?
 
 I searched the Internet and looked for documents randomly to test if
 LibreOffice can open them. This is the authentic test.
 
 No, a more authentic test is to search for odf documents and compare
 of LO and m$ opens these types of documents.
 
 If Microsoft Office opens the .doc files correctly, LibreOffice should also
 open them correctly.
 
 No, LO is not a m$-clone. If LO opens the odt document correctly, m$
 should also. Have you tested this?
 
 If Microsoft went bankrupt, what office suite would be able to handle
 thousands of .doc files?
 
 Unlikely, but that is the fault entirely of the user that creates the
 document in the m$ file format!!!
 
 If LO, or any other odf-compliant software disappears, you can find
 another. That is why you should be testing interoperability with odf
 and not m$ formats.
 
 Then, the data in the .doc files would be lost if no other office suite was
 able to open them, I am afraid.
 
 I hope that happens (but a small possibility).
 
 Not many people like converting .doc files into .odt files, I am afraid.
 
 That is their choice. Start creating documents in odf!
 
 
 



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

Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular document

2013-02-12 Thread Jay Lozier

On 02/12/2013 04:53 AM, e-letter wrote:

On 12/02/2013, C. H. D. webofht-libreoffice...@yahoo.com.hk wrote:

Hello!


Yes, my Microsoft Office is legal. (Just happened that many other people use
it.)


I think it is an interoperability issue.


If you are very concerned about interoperability, you should be
contacting m$ and ask them why they cannot open odf documents created
using LO. Have you done this?


I searched the Internet and looked for documents randomly to test if
LibreOffice can open them. This is the authentic test.


No, a more authentic test is to search for odf documents and compare
of LO and m$ opens these types of documents.


If Microsoft Office opens the .doc files correctly, LibreOffice should also
open them correctly.


No, LO is not a m$-clone. If LO opens the odt document correctly, m$
should also. Have you tested this?


If Microsoft went bankrupt, what office suite would be able to handle
thousands of .doc files?


Unlikely, but that is the fault entirely of the user that creates the
document in the m$ file format!!!

If LO, or any other odf-compliant software disappears, you can find
another. That is why you should be testing interoperability with odf
and not m$ formats.


Then, the data in the .doc files would be lost if no other office suite was
able to open them, I am afraid.


I hope that happens (but a small possibility).


Not many people like converting .doc files into .odt files, I am afraid.


That is their choice. Start creating documents in odf!

If you bother to read the comments, the document is from a website and 
contacting the author will be difficult. The problem is likely that the 
author did some strange formatting that confuses many programs that 
normally open *.doc format files. The real issue is why a *.doc file 
instead of a *.pdf file on the web.


I would follow Tom's suggestion and try several other options and see if 
one them works. Also, if the document is opened, even if the it looks 
wacky, try saving as odt or html if odt does not work.


--
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: MS Excel file macros cause infinite loop of errors

2013-02-12 Thread Jay Lozier

On 02/12/2013 01:34 AM, e-letter wrote:

On 11/02/2013, todd.e.moore todd.e.mo...@gmail.com wrote:

Originally I posted under my todd.mo...@dynamicsystemsinc.com
account.Unfortunately, I need the macros enabled.  The spreadsheet is
developed by another company and includes features/functions that we must
use to properly submit requests.The behavior I observe is that after
changing security settings to allow the macros to run, I receive a macro
execution error that pops up on the screen.  Clicking on the equivalent of
ok, ignore, cancel just displays another error message.  This
continues for what seems about 30 clicks.  Then the boxes no longer appear.

Trying to do anything in the UI, even closing the file, starts the error
message deluge again.I noticed the issue in v3.x.x and hoped that with
v4.0.0 there may have been changes that would cope with the macros in this
file.  Unfortunately, the problems persist.Attaching file (1MB zip file
containing a single MS Excel ) that causes this issue to occur.
File_with_Bad_Macro.zip
http://nabble.documentfoundation.org/file/n4036499/File_with_Bad_Macro.zip


Amazed that a private company receives a proprietary file from another
private company and asks the libre software community to solve a
proprietary problem.

LO is not an m$ clone. A business that can't afford to pay m$
licences, most probably shouldn't be in business.

How does odf benefit from LO being used to solve your problem?

Have you contacted the source of the document and asked them to
re-format the document to ods?

What did they say? ;)

Have you contacted m$ and asked them to make their software easier to
use with non-m$ products? Did you get a reply ? ;)

How much company time have you wasted, compared to the cost of buying
a legitimate copy of m$? Is your MD aware?


e-letter

The issue is macro conversion which is tricky at best. As budgets 
tighten many are looking for less expensive or free options for software 
and these issues are important to address in a polite manner not snide 
comments about the validity of their license or how they should use MSO. 
MS does not by their choice have versions of MSO for all OSes so 
depending on your OS you may not even have an option to use MSO.


In previous post, it was noted that the macro may be buggy because it 
apparently does not always run correctly in Excel (2003). So there may 
have two independent problems: a buggy macro and macro 
conversion/interoperability.


Macros are the hardest area to convert because of differences in the 
APIs between MSO and LO.


--
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] Bug 60390 - FILEOPEN: Cannot open particular document

2013-02-12 Thread Tom Davies
Hi :)
Brilliant! :)  Nicely done!  


It did bother me a little that the macros didn't even work in MS Office.  
At my workplace we only have 1 set of documents that 'need' macros and 
they are all in the finance department.  They were written for MSO 2010 
and don't work in MSO 2007 and i'm guessing they wont work in MSO 2013 
either.  If the person writing the macros had not told us which version 
they were written for then we would have assumed they just don't work.  
As it is we had to buy MSO 2010 just a few months before 2013 was 
released.  We only really needed it for 1 machine but ended up getting 
it for almost all machines.  


CHD is the chap that produced quite a few How-To videos and even managed to get 
them listed on the Documentation wiki.  At the moment that is on
https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources
but i'm just creating a separate page for videos
https://wiki.documentfoundation.org/Documentation/Publications/Videos
and created a redirect for people that forget the Publications bit (ie such 
as myself in a few months).  


Now that i see he was doing research and has collected stats about it his whole 
mission there suddenly becomes more obvious and good to know about.  It wasn't 
a paid-for bit of research with pre-planning and defined methodology and is not 
yet written up as a research paper and published anywhere except on this list 
so it's good to get the early results before it's all hidden behind fancy 
language!  It's actually a little higher than i expected which is also good 
news :)   99.75% of documents being compatible is quite astounding!

Thanks and regards from
Tom :)  







 From: pasqual milvaques pons milvaques_...@gva.es
To: pasqual milvaques pons milvaques_...@gva.es 
Cc: LibreOffice User Support Mailing List users@global.libreoffice.org 
Sent: Tuesday, 12 February 2013, 13:14
Subject: Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular 
document
 
this mailing like doesn't like attachments, you can download it from there:
convertidor_odf.7z (320 KB)
https://mega.co.nz/#!o8IXHa7Q!JgsZ0xKsAagxtkHxy-c2lnacVUdN6zPJRcCGyJ_oRbo

best regards


Al 12/02/2013 13:58, En/na pasqual milvaques pons ha escrit:
 in situations like this, independently of the work to be done to make 
 libreoffice capable of opening those files you can use a version of 
 microsoft office which supports odf to convert the file to odt. this can be 
 an effective workaround
 
 I attach you the converted file (using microsoft office 2013). you can use 
 these software to do the conversion from a shell:
 http://code.officeshots.org/trac/officeshots/browser/trunk/OfficeConvert
 
 I attach also a bat file which can help to automatize the conversion process
 
 best regards
 
 
 Al 12/02/2013 13:29, En/na C. H. D. ha escrit:
 Hello!
 
 Do I support LibreOffice? Yes, I do.
 
 Let me show some positive numbers:
 
 When I downloaded 400 .doc files, I opened 399 files in LibreOffice.
 
 Only 1 could not be opened.
 
 All 400 files were smaller than or equal to 692.5 KB. I started the testing 
 from the smallest file to the largest file. It happened to be that I could 
 not open that one file which was 692.5 KB.
 
 I am not a Maths expert. 399/400 = 99.75%
 
 Congratulations! This is excellent! Well done.
 
 To make a rough conclusion, I claim in a reasonable way that LibreOffice 
 can open 99.75% of the .doc files I may come across in future if these 
 files are smaller than 700KB.
 
 I do not know if these numbers are scientific enough. However, such 
 information definitely helps me to say that LibreOffice 4 is really good!
 
 Microsoft Office is not my area of interest, by the way. It is just that 
 someone uses it. There were cases when Word could not open .doc files in 
 the past. These cases are not my area of interest.
 
 Regards,
 
 C. H. D.
 
 
 
 
 
 
 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
 
 
 
 
 
 
 
 
 
 
 
 
   寄件人︰ e-letterinp...@gmail.com
 收件人︰ C. H. D.webofht-libreoffice...@yahoo.com.hk 副本(CC)︰ LibreOffice User 
 Support Mailing Listusers@global.libreoffice.org  傳送日期︰ 2013年02月12日 (週二) 
 5:53 PM
 主題︰ Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular 
 document
   On 12/02/2013, C. H. D.webofht-libreoffice...@yahoo.com.hk  wrote:
 Hello!
 
 
 Yes, my Microsoft Office is legal. (Just happened that many other people 
 use
 it.)
 
 
 I think it is an interoperability issue.
 
 If you are very concerned about interoperability, you should be
 contacting m$ and ask them why they cannot open odf documents created
 using LO. Have you done this?
 
 I searched the Internet and looked for documents randomly to test if
 LibreOffice can open them. This is the authentic test.
 
 No, a more authentic test is to search for odf documents and compare
 of LO and m$ opens these types of documents.
 
 If Microsoft Office opens the .doc files correctly, LibreOffice should also
 

Re: [libreoffice-users] Re: MS Excel file macros cause infinite loop of errors

2013-02-12 Thread Tom Davies
Hi :)
+1 
to all of Jay's various points there.  I totally agree.  

The another private company, the one that sent the offending spreadsheet, 
appears to be Oracle.  So, 
1.  it's extremely unlikely that they will re-write the macros for LibreOffice 
or even for OpenOffice (same macro languages)  
2.  that fact the macros seem horribly broken is not a surprise either and they 
probably wont fix them
3.  If we could fix them and send to the original poster so that he could send 
the results to the another company  in an ODF document then that would be a 
bit of a triumph for all of us.  

Yes, it would be nice if someone here got paid for the work but that is 
unlikely to happen.  Ideally i would like someone here to get paid perhaps 
somewhat less than the cost of new MSO licenses for the op's machines.  Perhaps 
Andrew Pitonyak, Alex, Jay, Dan(?) or someone else that knows macro coding well 
enough to get it done quite quickly.  

At the moment the company that approached us doesn't have any versions of MSO 
(apart fromt he old 2003 lurking somewhere) and it's only being forced into 
buying MSO by this 1 document from Oracle!!  It's outrageous that Oracle would 
do such a thing but again, no surprise!  So, even if no-one got paid it would 
still be a good result for us.  

Regards from
Tom :)  






 From: Jay Lozier jsloz...@gmail.com
To: users@global.libreoffice.org 
Sent: Tuesday, 12 February 2013, 14:21
Subject: Re: [libreoffice-users] Re: MS Excel file macros cause infinite loop 
of errors
 
On 02/12/2013 01:34 AM, e-letter wrote:
 On 11/02/2013, todd.e.moore todd.e.mo...@gmail.com wrote:
 Originally I posted under my todd.mo...@dynamicsystemsinc.com
 account.Unfortunately, I need the macros enabled.  The spreadsheet is
 developed by another company and includes features/functions that we must
 use to properly submit requests.The behavior I observe is that after
 changing security settings to allow the macros to run, I receive a macro
 execution error that pops up on the screen.  Clicking on the equivalent of
 ok, ignore, cancel just displays another error message.  This
 continues for what seems about 30 clicks.  Then the boxes no longer appear.
 
 Trying to do anything in the UI, even closing the file, starts the error
 message deluge again.I noticed the issue in v3.x.x and hoped that with
 v4.0.0 there may have been changes that would cope with the macros in this
 file.  Unfortunately, the problems persist.Attaching file (1MB zip file
 containing a single MS Excel ) that causes this issue to occur.
 File_with_Bad_Macro.zip
 http://nabble.documentfoundation.org/file/n4036499/File_with_Bad_Macro.zip
 
 Amazed that a private company receives a proprietary file from another
 private company and asks the libre software community to solve a
 proprietary problem.
 
 LO is not an m$ clone. A business that can't afford to pay m$
 licences, most probably shouldn't be in business.
 
 How does odf benefit from LO being used to solve your problem?
 
 Have you contacted the source of the document and asked them to
 re-format the document to ods?
 
 What did they say? ;)
 
 Have you contacted m$ and asked them to make their software easier to
 use with non-m$ products? Did you get a reply ? ;)
 
 How much company time have you wasted, compared to the cost of buying
 a legitimate copy of m$? Is your MD aware?
 
e-letter

The issue is macro conversion which is tricky at best. As budgets tighten many 
are looking for less expensive or free options for software and these issues 
are important to address in a polite manner not snide comments about the 
validity of their license or how they should use MSO. MS does not by their 
choice have versions of MSO for all OSes so depending on your OS you may not 
even have an option to use MSO.

In previous post, it was noted that the macro may be buggy because it 
apparently does not always run correctly in Excel (2003). So there may have 
two independent problems: a buggy macro and macro conversion/interoperability.

Macros are the hardest area to convert because of differences in the APIs 
between MSO and LO.

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




-- 
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 Excel file macros cause infinite loop of errors

2013-02-12 Thread Todd E. Moore
My original objective in submitting to the forum was to determine if an 
LO/OO bug or limitation was being exposed by the macros found in the 
sample file rather than having folks in the development team or 
community expend the effort to fix the offending file.  To me, the issue 
is now closed.




On 2/12/13 9:52 AM, Tom Davies wrote:

Hi :)
+1
to all of Jay's various points there.  I totally agree.

The another private company, the one that sent the offending spreadsheet, 
appears to be Oracle.  So,
1.  it's extremely unlikely that they will re-write the macros for LibreOffice 
or even for OpenOffice (same macro languages)
2.  that fact the macros seem horribly broken is not a surprise either and they 
probably wont fix them
3.  If we could fix them and send to the original poster so that he could send the 
results to the another company  in an ODF document then that would be a bit 
of a triumph for all of us.

Yes, it would be nice if someone here got paid for the work but that is 
unlikely to happen.  Ideally i would like someone here to get paid perhaps 
somewhat less than the cost of new MSO licenses for the op's machines.  Perhaps 
Andrew Pitonyak, Alex, Jay, Dan(?) or someone else that knows macro coding well 
enough to get it done quite quickly.

At the moment the company that approached us doesn't have any versions of MSO 
(apart fromt he old 2003 lurking somewhere) and it's only being forced into 
buying MSO by this 1 document from Oracle!!  It's outrageous that Oracle would 
do such a thing but again, no surprise!  So, even if no-one got paid it would 
still be a good result for us.

Regards from
Tom :)







From: Jay Lozier jsloz...@gmail.com
To: users@global.libreoffice.org
Sent: Tuesday, 12 February 2013, 14:21
Subject: Re: [libreoffice-users] Re: MS Excel file macros cause infinite loop 
of errors

On 02/12/2013 01:34 AM, e-letter wrote:

On 11/02/2013, todd.e.moore todd.e.mo...@gmail.com wrote:

Originally I posted under my todd.mo...@dynamicsystemsinc.com
account.Unfortunately, I need the macros enabled.  The spreadsheet is
developed by another company and includes features/functions that we must
use to properly submit requests.The behavior I observe is that after
changing security settings to allow the macros to run, I receive a macro
execution error that pops up on the screen.  Clicking on the equivalent of
ok, ignore, cancel just displays another error message.  This
continues for what seems about 30 clicks.  Then the boxes no longer appear.

Trying to do anything in the UI, even closing the file, starts the error
message deluge again.I noticed the issue in v3.x.x and hoped that with
v4.0.0 there may have been changes that would cope with the macros in this
file.  Unfortunately, the problems persist.Attaching file (1MB zip file
containing a single MS Excel ) that causes this issue to occur.
File_with_Bad_Macro.zip
http://nabble.documentfoundation.org/file/n4036499/File_with_Bad_Macro.zip


Amazed that a private company receives a proprietary file from another
private company and asks the libre software community to solve a
proprietary problem.

LO is not an m$ clone. A business that can't afford to pay m$
licences, most probably shouldn't be in business.

How does odf benefit from LO being used to solve your problem?

Have you contacted the source of the document and asked them to
re-format the document to ods?

What did they say? ;)

Have you contacted m$ and asked them to make their software easier to
use with non-m$ products? Did you get a reply ? ;)

How much company time have you wasted, compared to the cost of buying
a legitimate copy of m$? Is your MD aware?


e-letter

The issue is macro conversion which is tricky at best. As budgets tighten many 
are looking for less expensive or free options for software and these issues 
are important to address in a polite manner not snide comments about the 
validity of their license or how they should use MSO. MS does not by their 
choice have versions of MSO for all OSes so depending on your OS you may not 
even have an option to use MSO.

In previous post, it was noted that the macro may be buggy because it 
apparently does not always run correctly in Excel (2003). So there may have two 
independent problems: a buggy macro and macro conversion/interoperability.

Macros are the hardest area to convert because of differences in the APIs 
between MSO and LO.

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







--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? 

Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular document

2013-02-12 Thread Tom Davies
Hi :)
The situation is improving now that people are moving to ODF more and more.  
Relying on a single companies whims has of course left a lingering problem but 
ODF is defined by a large group of companies most of which produce software 
that is designed to read the formats.  

So, if you stick with MS formats then you are still relying on a situation that 
hasn't changed in 30years.  If you have moved to ODF then things are a lot more 
stable and reliable because there are a lot of products that can read ODF 
sucessfully.
Regards from
Tom :)  






 From: Mirosław Zalewski mini...@poczta.onet.pl
To: users@global.libreoffice.org 
Sent: Tuesday, 12 February 2013, 12:49
Subject: Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular 
document
 
On 12/02/2013 at 10:53, e-letter inp...@gmail.com wrote:

 If LO, or any other odf-compliant software disappears, you can find
 another. 

Yeah, especially since LO default saving format incorporates number of non-
standard extensions that other ODF-compliant software will just ignore.

Don't get me wrong - I appreciate many of these extensions, as they give me 
ability to use great features not covered by ODF spec.

But I am also worried by the fact, that over thirty years after introducing 
first word processor software, we are still at a stage where documents can be 
freely exchanged only by users of the same software in the same version.
-- 
Best regards
Mirosław Zalewski

-- 
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] Bug 60710 - EDITING: Cannot save particular untitled document containing comments

2013-02-12 Thread Joel Madero
I reproduced it once and now for the life of me I can't.very strange.
Trying a few more times


Best Regards,
Joel


On Mon, Feb 11, 2013 at 8:14 PM, C. H. D. 
webofht-libreoffice...@yahoo.com.hk wrote:



 Hello!

 In my use case, I cannot save a particular untitled document.


 https://bugs.freedesktop.org/show_bug.cgi?id=60710

 I should be grateful if you have a look.

 The video is here:
 http://youtu.be/9ImnaTY65gA



 Regards,

 C. H. D.


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




-- 
*Joel Madero*
LibreOffice 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] Re: Installing the Deb

2013-02-12 Thread Tanstaafl

On 2013-02-10 10:27 PM, webmaster-Kracked_P_P wrote:

I do not like all that typing.

What I do is use the default file manager and double click the archived
file and unarchive it.  Then I take the folder that is created and
rename it to Lib or LibO.  That way you do not need to type all of the
characters of the folder's name.


Never heard of 'tab-completion'?

Try hitting the tab key after typing one or two characters of the folder 
name and see what happens...


--
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: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-12 Thread Uwe Brauer
 Alex == Alex Thurgood alex.thurg...@gmail.com writes:

On 02/11/2013 11:31 PM, Uwe Brauer wrote:
Hi Uwe,

As I said, in another mail,  when I connect the data base to mysql via
ODBC then I can set more relations, but they are not saved..


I take it that you are using InnoDB engine in your mysql db ?


Aha, good question.

Well show engines;
showed  

InnoDB | YES | Supports transactions | YES  | YES  | YES

So I presume the answer is yes.

Otherwise, e.g. if you are using myisam or heap as the default engine,
relations are not supported by mysql, i.e. they are not enforced
(although they can be stored as a textual reference).

This is true whether you are using ODBC, JDBC or the native mysql
connector to reach your tables from within LO.
A question, can you set various relations between tables, using mysql
and they are saved?

Uwe 

-- 
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: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-12 Thread Uwe Brauer
 Dan == Dan Lewis elderdanle...@gmail.com writes:


 Perhaps you need to learn more about primary keys, foreign keys,
and the relationship that must exist between them. Another topic that
would help is normalizing tables. Still another topic is constraints
that must be applied to either type of keys. (This one really goes to
the error message you got. (I make these suggestions because it is
what I had to do to understand tables in a relational database.)
Yes of course, I desperately need to learn more.  But the issue is that
the GUI seems only to set and save relations between primaries keys. Did
you try it out via the GUI, what is your experience?

 I am a little curious. Your email address implies you may live in
Spain. 

Yes, I do.

Your name looks German to me. If you are German, then there is
a Base Handbook written in German that you might be able to use. 

Yes again, I am German.
Tom might be able to tell you from where to download it on the
LibreOffice wiki if that would help.
That would be extremely helpful. I googled around of course but mostly
found old material (2007/08).

 As far as MySQL problems, I think I tried to modify fields in a
table while using MySQL. They were not saved either.

Aha so there is a problem?!

Uwe 


-- 
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: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-12 Thread Alex Thurgood
On 02/12/2013 05:59 PM, Uwe Brauer wrote:

Hi Uwe,


 Well show engines;
 showed  
 
 InnoDB | YES | Supports transactions | YES  | YES  | YES
 
 So I presume the answer is yes.
 

In theory, yes, but you might want to check each table to see whether it
does actually use the InnoDB engine and has not defaulted to myisam.


 This is true whether you are using ODBC, JDBC or the native mysql
 connector to reach your tables from within LO.
 A question, can you set various relations between tables, using mysql
 and they are saved?

Yes, but I don't use LO for this, I either code it by hand from the
mysql command line interface or when I'm feeling lazy use phpmysqladmin
or MySQL Workbench.

The reason : LO, and previously OOo, did not always make a very good job
of defining my table fields the way I wanted them.

Alex


Alex






-- 
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: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-12 Thread Alex Thurgood
On 02/12/2013 06:03 PM, Uwe Brauer wrote:

Hi Uwe,

Robert Grosskopf wrote a handbook in German that should be available on
the German LO wiki somewhere.


  As far as MySQL problems, I think I tried to modify fields in a
 table while using MySQL. They were not saved either.

You might be right, I haven't tried this recently. I gave up using LO or
even OOo to define my fields in mysql because it used to mess them up
somewhat, so I took to doing things via the command line interface. It
was hard going (and sometimes still is with mysql's rather unhelpful
obscure error messages), but at least I learnt more that way.

Alex



-- 
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] Feature Request

2013-02-12 Thread John R. Sowden
I know this is a bad time, since 4.0 was just released, but improvement 
is an ongoing process.


For the 'recent documents' menu selection under 'file', it would be nice to:
1) allow us to set the number of recent documents, under tools/options.
2) allow us, in the recent menu, to right click and set certain files to 
'permanent' so
they will not fifo off the stack.  An asterisk (blue?) could act as 
a visual flag.


John


--
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] Feature Request

2013-02-12 Thread Joel Madero
On Tue, Feb 12, 2013 at 11:04 AM, John R. Sowden jsow...@americansentry.net
 wrote:

 I know this is a bad time, since 4.0 was just released, but improvement is
 an ongoing process.

 For the 'recent documents' menu selection under 'file', it would be nice
 to:
 1) allow us to set the number of recent documents, under tools/options.
 2) allow us, in the recent menu, to right click and set certain files to
 'permanent' so
 they will not fifo off the stack.  An asterisk (blue?) could act as a
 visual flag.


Feature requests should be made through our bug tracker, most devs don't
follow the user mailing list (they already have way too much on their
plates).

https://wiki.documentfoundation.org/BugReport_Details


Best Regards,
Joel
-- 
*Joel Madero*
LibreOffice 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] Feature Request

2013-02-12 Thread John R. Sowden
I went to the site that you recommended.  I could not find any feature 
request link.  I searched for 'feature', no luck.  I also could not find 
a reference to 'recent', as my 'feature request' might be interpreted to 
mean that it is a 'bug'.  I searched the entire page.


John






On 02/12/2013 11:33 AM, Joel Madero wrote:




On Tue, Feb 12, 2013 at 11:04 AM, John R. Sowden 
jsow...@americansentry.net mailto:jsow...@americansentry.net wrote:


I know this is a bad time, since 4.0 was just released, but
improvement is an ongoing process.

For the 'recent documents' menu selection under 'file', it would
be nice to:
1) allow us to set the number of recent documents, under
tools/options.
2) allow us, in the recent menu, to right click and set certain
files to 'permanent' so
they will not fifo off the stack.  An asterisk (blue?) could
act as a visual flag.


Feature requests should be made through our bug tracker, most devs 
don't follow the user mailing list (they already have way too much on 
their plates).


https://wiki.documentfoundation.org/BugReport_Details


Best Regards,
Joel
--
*Joel Madero*
LibreOffice QA Volunteer
jmadero@gmail.com mailto: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] Re: Installing the Deb

2013-02-12 Thread webmaster-Kracked_P_P

On 02/12/2013 11:10 AM, Tanstaafl wrote:

On 2013-02-10 10:27 PM, webmaster-Kracked_P_P wrote:

I do not like all that typing.

What I do is use the default file manager and double click the archived
file and unarchive it.  Then I take the folder that is created and
rename it to Lib or LibO.  That way you do not need to type all of the
characters of the folder's name.


Never heard of 'tab-completion'?

Try hitting the tab key after typing one or two characters of the 
folder name and see what happens...




Never heard of this.  Never know of the Tab completion in the Terminal.

Does it work with the Terminal that is in GNOME, MATE, Unity, KDE?  How 
about the one that comes with openSUSE and other non-Ubuntu systems.  I 
have been told that Debian and Ubuntu is growing apart so some distros 
are showing both Ubuntu-based and Debian-based versions.


What happens when you have two folders that are similar characters, 
except some difference?

 LibreOffice-4.0-installsvs. LibreOffice-3.6-installs?
You would have to make sure you go out till the difference?

I tend to unarchive all of the downloaded file for my version at the 
same time.  For me, that is just the main install and the help pack.


   /To be honest, I never really got into doing all that much with the
   terminal.  I prefer to use a GUI to do the work. There are a very
   large amount of things that the terminal can do that I do not know
   of, or how to do those things that might help me once and a while. 
   I just never bought or download and GOODand easy to understand

   reference to what you can do in the terminal.  Of course, there are
   different ways to do things in a Ubuntu/Debian system than you would
   do the same thing in a openSUSE or RPM system.  Different commands
   and such. //
   //
   //I have tried things that others say work for the, but does not
   work in my install of Ubuntu. That is one reason I have a laptop
   that has a partition that I use to test new versions of Ubuntu and
   desktop environments.  I do not want to upgrade my 5 TB production
   desktop and then find that something is not right.  I did the
   upgrading from 10.04 to 12.04 on the laptop and it worked fine, but
   totally crashed on my desktop causing me to need to wipe the system
   and do a fresh install.  I really did not want to have to reinstall
   all of the packages over again, but in the end I had no choice to do
   so and move my data files from my external backup drive.  That took
   days to complete./


SO
I do not experiment with things on the Terminal, or almost never.

I would love to experiment and see about creating a script that would 
automate the install of LO from an earlier versionusing something like 
sh libre-update.run and then have it do the removal of the older 
version and install the newer one.  I could place it in the folderthat 
contains the DEBS folder so it will be version independent. But, if I 
do something wrong, how bad will it go wrong? So right now I am not 
going toexperiment that way.




--
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] Feature Request

2013-02-12 Thread webmaster-Kracked_P_P

On 02/12/2013 02:04 PM, John R. Sowden wrote:
I know this is a bad time, since 4.0 was just released, but 
improvement is an ongoing process.


For the 'recent documents' menu selection under 'file', it would be 
nice to:

1) allow us to set the number of recent documents, under tools/options.
2) allow us, in the recent menu, to right click and set certain files 
to 'permanent' so
they will not fifo off the stack.  An asterisk (blue?) could act 
as a visual flag.


John




I remember seeing some packages that allow you to define the number of 
recent documents are kept in the queue.  I never seen the permanent 
one, but that would be an interesting thing to have.  That way, if you 
are actively working on editing and updating documents on a regular 
basis, you do not have them removed from the recent list because you 
were required to do some other more pressing and time sensitive work. I 
wonder how it might be done.


Also, it would be nice to be able to clear the list from time to time to 
keep other users of a shared system from snooping into what work you 
are doing for others.  I knows this might dealt with only using user 
accounts that point to user only folders, but I have worked at places 
where you did not have that ability of keeping your work away from the 
other users of the system.  Even if you used thumbdrives to store the 
data files, the other users could access the list of files you worked 
on.  Wiping work history would be a good thing for some.


--
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] Feature Request

2013-02-12 Thread Kieran Peckett
Don't worry, just file it as a bug, and explain that it is a feature
request. The devs will understand.

On Tuesday, 12 February 2013, John R. Sowden wrote:

 I went to the site that you recommended.  I could not find any feature
 request link.  I searched for 'feature', no luck.  I also could not find a
 reference to 'recent', as my 'feature request' might be interpreted to mean
 that it is a 'bug'.  I searched the entire page.

 John






 On 02/12/2013 11:33 AM, Joel Madero wrote:




 On Tue, Feb 12, 2013 at 11:04 AM, John R. Sowden 
 jsow...@americansentry.net mailto:jsow...@americansentry.net wrote:

 I know this is a bad time, since 4.0 was just released, but
 improvement is an ongoing process.

 For the 'recent documents' menu selection under 'file', it would
 be nice to:
 1) allow us to set the number of recent documents, under
 tools/options.
 2) allow us, in the recent menu, to right click and set certain
 files to 'permanent' so
 they will not fifo off the stack.  An asterisk (blue?) could
 act as a visual flag.


 Feature requests should be made through our bug tracker, most devs don't
 follow the user mailing list (they already have way too much on their
 plates).

 https://wiki.**documentfoundation.org/**BugReport_Detailshttps://wiki.documentfoundation.org/BugReport_Details


 Best Regards,
 Joel
 --
 *Joel Madero*
 LibreOffice QA Volunteer
 jmadero@gmail.com mailto: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/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



-- 
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] Feature Request

2013-02-12 Thread John R. Sowden
I will follow your advice, although I think that this process needs 
review.  I feel that it is disrespectful to the people that are creating 
this great program to say that since My Idea (emphasis added) is not 
there, then it is a bug.  Secondly, good improvements from actual users 
might not be suggested because of the above and the fact that it is not 
clear where to request them.


John





On 02/12/2013 11:51 AM, Joel Madero wrote:


On Tue, Feb 12, 2013 at 11:50 AM, John R. Sowden 
jsow...@americansentry.net mailto:jsow...@americansentry.net wrote:


I went to the site that you recommended.  I could not find any
feature request link.  I searched for 'feature', no luck.  I also
could not find a reference to 'recent', as my 'feature request'
might be interpreted to mean that it is a 'bug'.  I searched the
entire page.


My mistake, should have clarified, report it as if it's a bug, then it 
can be changed to Enhancement by QA team :-D



--
*Joel Madero*
LibreOffice QA Volunteer
jmadero@gmail.com mailto: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] Re: Installing the Deb

2013-02-12 Thread Tom Davies
Hi :)
Tab complete is what i was trying to describe in this thread the other day, 
possibly yday although it's already nearly tomorrow here so possibly the day 
before yday.  

Works on any unix-based platform so that includes Bsd although possibly not 
Mac.  I've not seen a command-line on a Mac.  Also works on the Grub 
command-line although i try to avoid that even more than the regular 
command-line as i'm even more clueless there.  Pointclick rules!  (unless you 
are showing off)
Regards from
Tom :)  






 From: webmaster-Kracked_P_P webmas...@krackedpress.com
To: users@global.libreoffice.org 
Sent: Tuesday, 12 February 2013, 19:52
Subject: Re: [libreoffice-users] Re: Installing the Deb
 
On 02/12/2013 11:10 AM, Tanstaafl wrote:
 On 2013-02-10 10:27 PM, webmaster-Kracked_P_P wrote:
 I do not like all that typing.
 
 What I do is use the default file manager and double click the archived
 file and unarchive it.  Then I take the folder that is created and
 rename it to Lib or LibO.  That way you do not need to type all of the
 characters of the folder's name.
 
 Never heard of 'tab-completion'?
 
 Try hitting the tab key after typing one or two characters of the folder 
 name and see what happens...
 

Never heard of this.  Never know of the Tab completion in the Terminal.

Does it work with the Terminal that is in GNOME, MATE, Unity, KDE?  How about 
the one that comes with openSUSE and other non-Ubuntu systems.  I have been 
told that Debian and Ubuntu is growing apart so some distros are showing 
both Ubuntu-based and Debian-based versions.

What happens when you have two folders that are similar characters, except 
some difference?
     LibreOffice-4.0-installsvs. LibreOffice-3.6-installs?
You would have to make sure you go out till the difference?

I tend to unarchive all of the downloaded file for my version at the same 
time.  For me, that is just the main install and the help pack.

   /To be honest, I never really got into doing all that much with the
   terminal.  I prefer to use a GUI to do the work. There are a very
   large amount of things that the terminal can do that I do not know
   of, or how to do those things that might help me once and a while.    I 
just never bought or download and GOODand easy to understand
   reference to what you can do in the terminal.  Of course, there are
   different ways to do things in a Ubuntu/Debian system than you would
   do the same thing in a openSUSE or RPM system.  Different commands
   and such. //
   //
   //I have tried things that others say work for the, but does not
   work in my install of Ubuntu. That is one reason I have a laptop
   that has a partition that I use to test new versions of Ubuntu and
   desktop environments.  I do not want to upgrade my 5 TB production
   desktop and then find that something is not right.  I did the
   upgrading from 10.04 to 12.04 on the laptop and it worked fine, but
   totally crashed on my desktop causing me to need to wipe the system
   and do a fresh install.  I really did not want to have to reinstall
   all of the packages over again, but in the end I had no choice to do
   so and move my data files from my external backup drive.  That took
   days to complete./


SO
I do not experiment with things on the Terminal, or almost never.

I would love to experiment and see about creating a script that would 
automate the install of LO from an earlier versionusing something like sh 
libre-update.run and then have it do the removal of the older version and 
install the newer one.  I could place it in the folderthat contains the DEBS 
folder so it will be version independent. But, if I do something wrong, how 
bad will it go wrong? So right now I am not going toexperiment that way.



-- 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: Installing the Deb

2013-02-12 Thread Tom Davies
Hi :)
Ok, so how about running a Virtual Machine? Perhaps acquire an old hard-drive 
that you don't care about too much and physically unplug all your 5Tb and then 
plug in the experimental one.  

Btw on a command-line if 2 pathnames or file-names are quite close to each 
other then when you press Tab it will show the 2 or more options and then give 
you a new prompt with all the stuff you had already typed already on it.  
Sounds complicated but try it and you'll soon work it out.  
Regards from
Tom :)  






 From: webmaster-Kracked_P_P webmas...@krackedpress.com
To: users@global.libreoffice.org 
Sent: Tuesday, 12 February 2013, 19:52
Subject: Re: [libreoffice-users] Re: Installing the Deb
 
On 02/12/2013 11:10 AM, Tanstaafl wrote:
 On 2013-02-10 10:27 PM, webmaster-Kracked_P_P wrote:
 I do not like all that typing.
 
 What I do is use the default file manager and double click the archived
 file and unarchive it.  Then I take the folder that is created and
 rename it to Lib or LibO.  That way you do not need to type all of the
 characters of the folder's name.
 
 Never heard of 'tab-completion'?
 
 Try hitting the tab key after typing one or two characters of the folder 
 name and see what happens...
 

Never heard of this.  Never know of the Tab completion in the Terminal.

Does it work with the Terminal that is in GNOME, MATE, Unity, KDE?  How about 
the one that comes with openSUSE and other non-Ubuntu systems.  I have been 
told that Debian and Ubuntu is growing apart so some distros are showing 
both Ubuntu-based and Debian-based versions.

What happens when you have two folders that are similar characters, except 
some difference?
     LibreOffice-4.0-installsvs. LibreOffice-3.6-installs?
You would have to make sure you go out till the difference?

I tend to unarchive all of the downloaded file for my version at the same 
time.  For me, that is just the main install and the help pack.

   /To be honest, I never really got into doing all that much with the
   terminal.  I prefer to use a GUI to do the work. There are a very
   large amount of things that the terminal can do that I do not know
   of, or how to do those things that might help me once and a while.    I 
just never bought or download and GOODand easy to understand
   reference to what you can do in the terminal.  Of course, there are
   different ways to do things in a Ubuntu/Debian system than you would
   do the same thing in a openSUSE or RPM system.  Different commands
   and such. //
   //
   //I have tried things that others say work for the, but does not
   work in my install of Ubuntu. That is one reason I have a laptop
   that has a partition that I use to test new versions of Ubuntu and
   desktop environments.  I do not want to upgrade my 5 TB production
   desktop and then find that something is not right.  I did the
   upgrading from 10.04 to 12.04 on the laptop and it worked fine, but
   totally crashed on my desktop causing me to need to wipe the system
   and do a fresh install.  I really did not want to have to reinstall
   all of the packages over again, but in the end I had no choice to do
   so and move my data files from my external backup drive.  That took
   days to complete./


SO
I do not experiment with things on the Terminal, or almost never.

I would love to experiment and see about creating a script that would 
automate the install of LO from an earlier versionusing something like sh 
libre-update.run and then have it do the removal of the older version and 
install the newer one.  I could place it in the folderthat contains the DEBS 
folder so it will be version independent. But, if I do something wrong, how 
bad will it go wrong? So right now I am not going toexperiment that way.



-- 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] Changing the LibreOffice icons (Linux)

2013-02-12 Thread IBBoard
I don't know if this is the best place (I couldn't see a developer
mailing list outside the internal-focused ones) but here goes.

I use LibreOffice on openSUSE Linux. I've got a custom icon set that
replaces the application icons for LibreOffice. This works fine for
launcher icons, but once the program is running (e.g. I'm editing a file
in LO Writer) then the current app icon and the Alt-Tab app switcher
use the original icons (upscaled horribly from about 24x24 to 64x64).

As best as I can tell, Gnome is honouring the _NET_WM_ICON property of
the window, which does show the old style icons when you query it with
xprop.

I'm not talking about the toolbar icons, which I know there are multiple
themes that I can select from, but the actual launcher icon, and the one
that Gnome Shell uses to show you which app is running.

Is it possible to either a) get LibreOffice to use my theme's icons for
_NET_WM_ICON or b) replace some files pre-build, and if so, which ones?

I've got an account that already has some repackaged software on the
openSUSE Build Service (OBS), so I'm not afraid of patching packages, if
that is the only option :)

Thanks.


-- 
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] Feature Request

2013-02-12 Thread Dan Lewis

On 02/12/2013 03:01 PM, webmaster-Kracked_P_P wrote:

On 02/12/2013 02:04 PM, John R. Sowden wrote:
I know this is a bad time, since 4.0 was just released, but 
improvement is an ongoing process.


For the 'recent documents' menu selection under 'file', it would be 
nice to:

1) allow us to set the number of recent documents, under tools/options.
2) allow us, in the recent menu, to right click and set certain files 
to 'permanent' so
they will not fifo off the stack.  An asterisk (blue?) could act 
as a visual flag.


John




I remember seeing some packages that allow you to define the number of 
recent documents are kept in the queue.  I never seen the 
permanent one, but that would be an interesting thing to have.  That 
way, if you are actively working on editing and updating documents on 
a regular basis, you do not have them removed from the recent list 
because you were required to do some other more pressing and time 
sensitive work. I wonder how it might be done.


Also, it would be nice to be able to clear the list from time to time 
to keep other users of a shared system from snooping into what 
work you are doing for others.  I knows this might dealt with only 
using user accounts that point to user only folders, but I have 
worked at places where you did not have that ability of keeping your 
work away from the other users of the system.  Even if you used 
thumbdrives to store the data files, the other users could access the 
list of files you worked on.  Wiping work history would be a good 
thing for some.
 This was mentioned on this mailing list probably the latter part 
of last year. An extension was first created for OpenOffice.org  before 
Sun was bought by Oracle. The name is History Maker. It will work for LO 
as well. You can get it here:

http://extensions.services.openoffice.org/en/project/HistoryMaster.
 It only changes the number of documents kept on the recent 
document list.


--Dan


--
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] Feature Request

2013-02-12 Thread Tom Davies
Hi :)
The QA team and bug-triagers are pretty smart so they can sort it out for you 
(or others).  There are a lot of drop-downs on the page and it's a little 
tricky to find the right one but when you know where it is then you could help 
the bug-triagers by just doing that for a whole load of 'bug-reports' where the 
poster grumbles that they couldn't find the option.  There's all sorts of 
simple, dumb, easy things that can be quite a significant help and can help you 
learn your way in to doing more and more complex stuff.  
Regards from
Tom :)  






 From: John R. Sowden jsow...@americansentry.net
To: users@global.libreoffice.org 
Sent: Tuesday, 12 February 2013, 20:11
Subject: Re: [libreoffice-users] Feature Request
 
I will follow your advice, although I think that this process needs review.  I 
feel that it is disrespectful to the people that are creating this great 
program to say that since My Idea (emphasis added) is not there, then it is a 
bug.  Secondly, good improvements from actual users might not be suggested 
because of the above and the fact that it is not clear where to request them.

John





On 02/12/2013 11:51 AM, Joel Madero wrote:
 
 On Tue, Feb 12, 2013 at 11:50 AM, John R. Sowden jsow...@americansentry.net 
 mailto:jsow...@americansentry.net wrote:
 
     I went to the site that you recommended.  I could not find any
     feature request link.  I searched for 'feature', no luck.  I also
     could not find a reference to 'recent', as my 'feature request'
     might be interpreted to mean that it is a 'bug'.  I searched the
     entire page.
 
 
 My mistake, should have clarified, report it as if it's a bug, then it can 
 be changed to Enhancement by QA team :-D
 
 
 -- *Joel Madero*
 LibreOffice QA Volunteer
 jmadero@gmail.com mailto: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




-- 
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] Feature Request

2013-02-12 Thread Jay Lozier

On 02/12/2013 03:11 PM, John R. Sowden wrote:
I will follow your advice, although I think that this process needs 
review.  I feel that it is disrespectful to the people that are 
creating this great program to say that since My Idea (emphasis added) 
is not there, then it is a bug.  Secondly, good improvements from 
actual users might not be suggested because of the above and the fact 
that it is not clear where to request them.


John



John,

Using the bug tracking system and flagging it as feature request puts 
all the issues for the devs and QA team in one central spot. 
Unfortunately the use of bug tracking is sometimes a little misleading .


Jay




On 02/12/2013 11:51 AM, Joel Madero wrote:


On Tue, Feb 12, 2013 at 11:50 AM, John R. Sowden 
jsow...@americansentry.net mailto:jsow...@americansentry.net wrote:


I went to the site that you recommended.  I could not find any
feature request link.  I searched for 'feature', no luck.  I also
could not find a reference to 'recent', as my 'feature request'
might be interpreted to mean that it is a 'bug'.  I searched the
entire page.


My mistake, should have clarified, report it as if it's a bug, then 
it can be changed to Enhancement by QA team :-D



--
*Joel Madero*
LibreOffice QA Volunteer
jmadero@gmail.com mailto:jmadero@gmail.com







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

2013-02-12 Thread Malcolm Moore
Is there anywhere that does different icon sets .. sorry, but
I think the ones that come with opensuse are a bit boring


Ta


M  

-- 
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] Changing the LibreOffice icons (Linux)

2013-02-12 Thread webmaster-Kracked_P_P

On 02/12/2013 03:29 PM, IBBoard wrote:

I don't know if this is the best place (I couldn't see a developer
mailing list outside the internal-focused ones) but here goes.

I use LibreOffice on openSUSE Linux. I've got a custom icon set that
replaces the application icons for LibreOffice. This works fine for
launcher icons, but once the program is running (e.g. I'm editing a file
in LO Writer) then the current app icon and the Alt-Tab app switcher
use the original icons (upscaled horribly from about 24x24 to 64x64).

As best as I can tell, Gnome is honouring the _NET_WM_ICON property of
the window, which does show the old style icons when you query it with
xprop.

I'm not talking about the toolbar icons, which I know there are multiple
themes that I can select from, but the actual launcher icon, and the one
that Gnome Shell uses to show you which app is running.

Is it possible to either a) get LibreOffice to use my theme's icons for
_NET_WM_ICON or b) replace some files pre-build, and if so, which ones?

I've got an account that already has some repackaged software on the
openSUSE Build Service (OBS), so I'm not afraid of patching packages, if
that is the only option :)

Thanks.


Maybe the solution is to include other icon sizes, like 24x24 and 64x64, 
or maybe larger ones, for those systems that might need or use them.  
Small, medium, large, and extra-large, icons might work for those who 
are on systems where you can change the icon size. I think Win7 has only 
two icon sizes to choose from.  I do not remember seeing that option in 
my Ubuntu/MATE install, though.  It could be there and I never seen 
where the option resides.


So, maybe there might be a need for icon sizes other than the two being 
used already.


Debian install[s] show
icon=/usr/share/icons/hicolor/32x32/apps/libreoffice4.0-writer.png\
icon16x16=/usr/share/icons/hicolor/16x16/apps/libreoffice4.0-writer.png

Could there be an icon24x24 and icon64x64 added to the 
desktop-integration system?

How many systems would work with more than just the default two sizes?


--
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] Feature Request

2013-02-12 Thread Joel Madero
I am one of the QA members and I assure you, no developer is offended that
a feature request is reported as a bug. It is our (QA) job to ensure that
they are categorized correctly after the request/bug is confirmed.

@Tom - thanks for the compliment :-D

Best Regards,
Joel


On Tue, Feb 12, 2013 at 12:30 PM, Tom Davies tomdavie...@yahoo.co.ukwrote:

 Hi :)
 The QA team and bug-triagers are pretty smart so they can sort it out for
 you (or others).  There are a lot of drop-downs on the page and it's a
 little tricky to find the right one but when you know where it is then you
 could help the bug-triagers by just doing that for a whole load of
 'bug-reports' where the poster grumbles that they couldn't find the
 option.  There's all sorts of simple, dumb, easy things that can be quite a
 significant help and can help you learn your way in to doing more and more
 complex stuff.
 Regards from
 Tom :)





 
  From: John R. Sowden jsow...@americansentry.net
 To: users@global.libreoffice.org
 Sent: Tuesday, 12 February 2013, 20:11
 Subject: Re: [libreoffice-users] Feature Request
 
 I will follow your advice, although I think that this process needs
 review.  I feel that it is disrespectful to the people that are creating
 this great program to say that since My Idea (emphasis added) is not there,
 then it is a bug.  Secondly, good improvements from actual users might not
 be suggested because of the above and the fact that it is not clear where
 to request them.
 
 John
 
 
 
 
 
 On 02/12/2013 11:51 AM, Joel Madero wrote:
 
  On Tue, Feb 12, 2013 at 11:50 AM, John R. Sowden 
 jsow...@americansentry.net mailto:jsow...@americansentry.net wrote:
 
  I went to the site that you recommended.  I could not find any
  feature request link.  I searched for 'feature', no luck.  I also
  could not find a reference to 'recent', as my 'feature request'
  might be interpreted to mean that it is a 'bug'.  I searched the
  entire page.
 
 
  My mistake, should have clarified, report it as if it's a bug, then it
 can be changed to Enhancement by QA team :-D
 
 
  -- *Joel Madero*
  LibreOffice QA Volunteer
  jmadero@gmail.com mailto: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
 
 
 
 
 --
 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




-- 
*Joel Madero*
LibreOffice 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] Feature Request

2013-02-12 Thread Tanstaafl

On 2013-02-12 3:11 PM, John R. Sowden jsow...@americansentry.net wrote:

I will follow your advice, although I think that this process needs
review.  I feel that it is disrespectful to the people that are creating
this great program to say that since My Idea (emphasis added) is not
there, then it is a bug.


Hi John,

You must be new to the world of open source software. Virtually *all* 
open source software projects track Feature Requests in their bug 
trackers... usually you just flag it as an enhancement request, but it 
is still in the big tracker.


It is just a convenience thing, no disrespect intended...

--
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: Installing the Deb

2013-02-12 Thread Tanstaafl
On 2013-02-12 2:52 PM, webmaster-Kracked_P_P 
webmas...@krackedpress.com wrote:

On 02/12/2013 11:10 AM, Tanstaafl wrote:

On 2013-02-10 10:27 PM, webmaster-Kracked_P_P wrote:

I do not like all that typing.

What I do is use the default file manager and double click the archived
file and unarchive it.  Then I take the folder that is created and
rename it to Lib or LibO.  That way you do not need to type all of the
characters of the folder's name.


Never heard of 'tab-completion'?

Try hitting the tab key after typing one or two characters of the
folder name and see what happens...



Never heard of this.  Never know of the Tab completion in the Terminal.

Does it work with the Terminal that is in GNOME, MATE, Unity, KDE?  How
about the one that comes with openSUSE and other non-Ubuntu systems.  I
have been told that Debian and Ubuntu is growing apart so some distros
are showing both Ubuntu-based and Debian-based versions.


It works in virtually all *nix that I'm aware of, and DOS and Windows 
Command Prompt terminals, and has for as long long time...


http://en.wikipedia.org/wiki/Command-line_completion

--
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] Fwd:

2013-02-12 Thread Drew Jensen
http://lasvegassuites.org/downrightawesome.com/nanw54.php?s=ot


-- 
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] Fwd:

2013-02-12 Thread Tom Davies

Hi :)
Ooops.  A bit of accidental spam from Drew of all people.  I 
risked the link in GnuLinux and it's just a weight-loss thing from 
Foxx.  Probably best not to risk it in Windows jic but it seemed 
harmless
Regards from
Tom :)




 From: Drew Jensen drewjensen.in...@gmail.com
To: users@global.libreoffice.org 
Sent: Tuesday, 12 February 2013, 20:56
Subject: [libreoffice-users] Fwd:
 
http://lasvegassuites.org/downrightawesome.com/nanw54.php?s=ot


-- 
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] Changing the LibreOffice icons (Linux)

2013-02-12 Thread IBBoard
The Linux icons can be a variety of sizes - Chromium supplies a 64x64 icon
in the xprop reported icon set (or possibly bigger) as well as the two
sizes that LibreOffice shows.

Does Libreoffice actually load its app icons from /usr/share/icons/hicolor?
I've tried replacing those icons with symlinks to my icons (an ugly bodge,
but potentially workable) and rebuilt the icon caches, but nothing seemed
to change so I assumed there was another source that they were read from or
that the icons were built in at compile-time.

Thanks.
On Feb 12, 2013 9:34 PM, webmaster-Kracked_P_P webmas...@krackedpress.com
wrote:

 On 02/12/2013 03:29 PM, IBBoard wrote:

 I don't know if this is the best place (I couldn't see a developer
 mailing list outside the internal-focused ones) but here goes.

 I use LibreOffice on openSUSE Linux. I've got a custom icon set that
 replaces the application icons for LibreOffice. This works fine for
 launcher icons, but once the program is running (e.g. I'm editing a file
 in LO Writer) then the current app icon and the Alt-Tab app switcher
 use the original icons (upscaled horribly from about 24x24 to 64x64).

 As best as I can tell, Gnome is honouring the _NET_WM_ICON property of
 the window, which does show the old style icons when you query it with
 xprop.

 I'm not talking about the toolbar icons, which I know there are multiple
 themes that I can select from, but the actual launcher icon, and the one
 that Gnome Shell uses to show you which app is running.

 Is it possible to either a) get LibreOffice to use my theme's icons for
 _NET_WM_ICON or b) replace some files pre-build, and if so, which ones?

 I've got an account that already has some repackaged software on the
 openSUSE Build Service (OBS), so I'm not afraid of patching packages, if
 that is the only option :)

 Thanks.


  Maybe the solution is to include other icon sizes, like 24x24 and 64x64,
 or maybe larger ones, for those systems that might need or use them.
  Small, medium, large, and extra-large, icons might work for those who are
 on systems where you can change the icon size. I think Win7 has only two
 icon sizes to choose from.  I do not remember seeing that option in my
 Ubuntu/MATE install, though.  It could be there and I never seen where the
 option resides.

 So, maybe there might be a need for icon sizes other than the two being
 used already.

 Debian install[s] show
 icon=/usr/share/icons/**hicolor/32x32/apps/**libreoffice4.0-writer.png\
 icon16x16=/usr/share/icons/**hicolor/16x16/apps/**
 libreoffice4.0-writer.png

 Could there be an icon24x24 and icon64x64 added to the
 desktop-integration system?
 How many systems would work with more than just the default two sizes?


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


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

2013-02-12 Thread Malcolm Moore
The tool bar icons. OpenSuse include about 4 ... I love LO
I just think the ones you get with openSuse are a bit dated


Ta


M

  _  
From: IBBoard [mailto:ibbo...@gmail.com]
To: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info]
Cc: users@global.libreoffice.org
Sent: Tue, 12 Feb 2013 22:34:52 +
Subject: Re: [libreoffice-users] icons

Which icons? The launcher icons or the toolbar icons?

I'm not on my opensuse machine now, but I think they package some of the
toolbar icon themes separately.

There are also launcher icons in some sets on sites like gnome-look, but as
I'm just finding then they don't seem to be applied once the app opens.
On Feb 12, 2013 9:19 PM, Malcolm Moore st-malcolm.mo...@whsg.info wrote:

 Is there anywhere that does different icon sets .. sorry, but
 I think the ones that come with opensuse are a bit boring


 Ta


 M

 --
 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: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-12 Thread Tom Davies
Hi :)
Robert Großkopf on the Docs Team's amiling list gave me this link  
http://de.libreoffice.org/hilfe-kontakt/handbuecher/

Hope it helps!
Good luck and happy hunting ;)
Regards from
Tom :) 






 From: Uwe Brauer o...@mat.ucm.es
To: users@global.libreoffice.org 
Sent: Tuesday, 12 February 2013, 17:03
Subject: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only 
between primaries keys?
 
 Dan == Dan Lewis elderdanle...@gmail.com writes:


         Perhaps you need to learn more about primary keys, foreign keys,
    and the relationship that must exist between them. Another topic that
    would help is normalizing tables. Still another topic is constraints
    that must be applied to either type of keys. (This one really goes to
    the error message you got. (I make these suggestions because it is
    what I had to do to understand tables in a relational database.)
Yes of course, I desperately need to learn more.  But the issue is that
the GUI seems only to set and save relations between primaries keys. Did
you try it out via the GUI, what is your experience?

         I am a little curious. Your email address implies you may live in
    Spain. 

Yes, I do.

    Your name looks German to me. If you are German, then there is
    a Base Handbook written in German that you might be able to use. 

Yes again, I am German.
    Tom might be able to tell you from where to download it on the
    LibreOffice wiki if that would help.
That would be extremely helpful. I googled around of course but mostly
found old material (2007/08).

         As far as MySQL problems, I think I tried to modify fields in a
    table while using MySQL. They were not saved either.

Aha so there is a problem?!

Uwe 


-- 
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: Fwd: [libreoffice-users] Value and Date function in Macro

2013-02-12 Thread Andrew Douglas Pitonyak


Can you post your code here?

You may send me a copy of the document, but I have much on my plate at 
the moment.


On 02/11/2013 06:41 PM, Joel Madero wrote:

So I came out with a really micky mouse way that works but I don't like it.
I'm hoping one of you (or someone else or both of you) will help me with
the entire code so that I can clean it up. I'm not a programmer by
profession (no formal training) so I know the code has issues - but it
works!

Any way that we can take this off the thread and I'll send the template
your way?

I know this is asking a lot so no worries if not possible. I'm not asking
someone to do it for me, more like tutor me when you have time to get the
code up to snuff.


Thanks for everyone's help up to date, much help.


Best Regards,
Joel


On Sun, Feb 10, 2013 at 9:02 PM, Andrew Douglas Pitonyak 
and...@pitonyak.org wrote:


On 02/10/2013 04:49 AM, Johnny Rosenberg wrote:


Oh no, I did it again! I sent yet another reply directly to the
original poster.


I feel your pain! :-)


--
Andrew Pitonyak
My Macro Document: 
http://www.pitonyak.org/**AndrewMacro.odthttp://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


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






--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
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: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-12 Thread Dan Lewis

On 02/12/2013 12:03 PM, Uwe Brauer wrote:

Dan == Dan Lewis elderdanle...@gmail.com writes:


  Perhaps you need to learn more about primary keys, foreign keys,
 and the relationship that must exist between them. Another topic that
 would help is normalizing tables. Still another topic is constraints
 that must be applied to either type of keys. (This one really goes to
 the error message you got. (I make these suggestions because it is
 what I had to do to understand tables in a relational database.)
Yes of course, I desperately need to learn more.  But the issue is that
the GUI seems only to set and save relations between primaries keys. Did
you try it out via the GUI, what is your experience?

  I am a little curious. Your email address implies you may live in
 Spain.

Yes, I do.

 Your name looks German to me. If you are German, then there is
 a Base Handbook written in German that you might be able to use.

Yes again, I am German.
 Tom might be able to tell you from where to download it on the
 LibreOffice wiki if that would help.
That would be extremely helpful. I googled around of course but mostly
found old material (2007/08).

  As far as MySQL problems, I think I tried to modify fields in a
 table while using MySQL. They were not saved either.

Aha so there is a problem?!

Uwe
 At the time I thought there was a problem, but after writing about 
MySQL, I tried again. This time I was able to modify a field and later 
when editing that table,  I saw that the changes had been saved.
 If you saw this link: 
http://de.libreoffice.org/hilfe-kontakt/handbuecher/, this should 
explain what you need to know in a language that you better understand 
than English.


--Dan

--
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] Bug 60710 - EDITING: Cannot save particular untitled document containing comments

2013-02-12 Thread C. H. D.


Hi! I got it. To reproduce, see the video:

http://youtu.be/_XotQrTvGJM 


Add random comments. Delete one of them.

I reproduced this issue three times.


Regards,
C. H. D.

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 












 寄件人︰ Joel Madero jmadero@gmail.com
收件人︰ C. H. D. webofht-libreoffice...@yahoo.com.hk 
副本(CC)︰ LibreOffice User Support Mailing List users@global.libreoffice.org 
傳送日期︰ 2013年02月12日 (週二) 11:55 PM
主題︰ Re: [libreoffice-users] Bug 60710 - EDITING: Cannot save particular 
untitled document containing comments
 
I reproduced it once and now for the life of me I can't.very strange.
Trying a few more times


Best Regards,
Joel


On Mon, Feb 11, 2013 at 8:14 PM, C. H. D. 
webofht-libreoffice...@yahoo.com.hk wrote:



 Hello!

 In my use case, I cannot save a particular untitled document.


 https://bugs.freedesktop.org/show_bug.cgi?id=60710

 I should be grateful if you have a look.

 The video is here:
 http://youtu.be/9ImnaTY65gA



 Regards,

 C. H. D.


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




-- 
*Joel Madero*
LibreOffice 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
-- 
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] Bug 60710 - EDITING: Cannot save particular untitled document containing comments

2013-02-12 Thread C. H. D.


 
Someone else got the same issue:

http://ask.libreoffice.org/en/question/12015/cannot-save-file-error-in-writing-sub-document/


Perhaps, this issue is quite common. 


(Not being able to save the file could be very inconvenient.)

Regards,
C. H. D. 



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 












 寄件人︰ C. H. D. webofht-libreoffice...@yahoo.com.hk
收件人︰ LibreOffice User Support Mailing List users@global.libreoffice.org 
傳送日期︰ 2013年02月13日 (週三) 11:27 AM
主題︰ Re: [libreoffice-users] Bug 60710 - EDITING: Cannot save particular 
untitled document containing comments
 


Hi! I got it. To reproduce, see the video:

http://youtu.be/_XotQrTvGJM 


Add random comments. Delete one of them.

I reproduced this issue three times.


Regards,
C. H. D.

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 












寄件人︰ Joel Madero jmadero@gmail.com
收件人︰ C. H. D. webofht-libreoffice...@yahoo.com.hk 
副本(CC)︰ LibreOffice User Support Mailing List users@global.libreoffice.org 
傳送日期︰ 2013年02月12日 (週二) 11:55 PM
主題︰ Re: [libreoffice-users] Bug 60710 - EDITING: Cannot save particular 
untitled document containing comments

I reproduced it once and now for the life of me I can't.very strange.
Trying a few more times


Best Regards,
Joel


On Mon, Feb 11, 2013 at 8:14 PM, C. H. D. 
webofht-libreoffice...@yahoo.com.hk wrote:



 Hello!

 In my use case, I cannot save a particular untitled document.


 https://bugs.freedesktop.org/show_bug.cgi?id=60710

 I should be grateful if you have a look.

 The video is here:
 http://youtu.be/9ImnaTY65gA



 Regards,

 C. H. D.


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




-- 
*Joel Madero*
LibreOffice 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
-- 
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] irritating problem 4.0

2013-02-12 Thread Tim Lloyd
Hi, created a FAQ for myself in Fedora 16 using LO3.6. When I upgraded to 
Fedora 18 I was also using 3.6. I really can't remember but I would say the 
version of LO came from the Fedora repository (it isn't installed by default in 
F18).

The FAQ is a very basic ODT file. I created an index at the front using the 
defaults provided so index is based on defaults - Heading1 is position 1, 
Heading2 is position 2  Heading3 is position3, etc. Anyway, all good, the 
document grew as I grabbed more information. Mostly I just added lines to the 
end, in some cases I added a new heading which went into the index.

Yesterday I downloaded the latest LO version from the official site. removed 
3.6 and installed 4.0.

Today, I updated the FAQ with some GIT information. So I created a new heading1 
for GIT with a heading2 underneath. And a few lines of information along the 
way (in the format text body). When I updated the index, all lines I had typed 
in were added to the index. Plus a few from the page before and the page after. 
But not all pages!

So I reinstalled 3.6 and updated the index but the same problem persists.

I have read the writer guide often enough recently to have a pretty good idea 
how this works but I am stumped. Any thoughts on how to sort out the index?

Cheers

-- 
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] Feature Request

2013-02-12 Thread Brian Barker

At 11:04 12/02/2013 -0800, John R. Sowden wrote:
For the 'recent documents' menu selection under 'file', it would be 
nice to: 1) allow us to set the number of recent documents, under 
tools/options.


I know this is not quite what you are asking for, but in the absence 
of exactly what you want, you may like to try customising the 
Standard toolbar to display the Load URL command.  (Click the 
down-arrow at the right of the toolbar and select Customize 
Toolbar... .)  This gives a much longer list of recent files.  Note 
that the customisation needs to be made separately for each 
LibreOffice component that you wish to display this, but the list 
itself is common to all of them.


At 15:01 12/02/2013 -0500, Tim Lungstrom wrote:
I remember seeing some packages that allow you to define the number 
of recent documents are kept in the queue.  I never seen the 
permanent one, ...


Earlier versions of (close your eyes if these are dirty words for 
you) Microsoft Word (at least) had a Work menu which allowed you to 
create your own list of frequently used documents - which would not 
evaporate until you wanted them to; later versions of Microsoft 
Office have dropped this idea but allow you to pin items already on 
the recent files menu so that they do not drop off.


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] irritating problem 4.0

2013-02-12 Thread Jean-Francois Nifenecker

Hi,

Le 13/02/2013 07:16, Tim Lloyd a écrit :


Today, I updated the FAQ with some GIT information. So I created a
new heading1 for GIT with a heading2 underneath. And a few lines of
information along the way (in the format text body). When I updated
the index, all lines I had typed in were added to the index. Plus a
few from the page before and the page after. But not all pages!



Have look at those paragraphs that inappropriately go to the index and 
check their outline level. I guess this level is set to some value other 
than Text body.


In this case, using the Ctrl+M key combination (Format / Default) should 
set them back to the default Text body level value.


Apart from some manual setting, I can't see why this paragraph setting 
would have changed on its own.


HTH,
--
Jean-Francois Nifenecker, Bordeaux

--
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] irritating problem 4.0

2013-02-12 Thread Jean-Francois Nifenecker

Le 13/02/2013 08:44, Jean-Francois Nifenecker a écrit :


Have look at those paragraphs that inappropriately go to the index and
check their outline level. I guess this level is set to some value other
than Text body.



This might be caused by the previous paragraph style setting Next 
style. Check that also.


--
Jean-Francois Nifenecker, Bordeaux

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