date:20130211

Hi :)
You can get completed chapters in advance from
https://wiki.documentfoundation.org/Documentation/Publications

Errr, that page also has old archived versions.  Normally the guides wouldn't 
have come out until around the 4.0.4 so to see the Getting Started Guide is 
almost complete already is quite amazing!
Regards from
Tom :)  






 From: Caesar cae...@hiwaay.net
To: Libre Office List Server users@global.libreoffice.org 
Sent: Monday, 11 February 2013, 8:35
Subject: [libreoffice-users] LO 4 documentation
 
Does anyone know when the documentation at 

http://www.libreoffice.org/get-help/documentation/

is scheduled to be updated to v4.x?

The LO v4.x templates creation and handling seems to have changed
quite a bit from v3.x. Note: I am using the Windows portable version
of LO 4 so the I don't have access to the installed version of the LO
4 documentation.

Can someone tell me if the Windows installed documentation has been
updated?

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




-- 
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] Page count does not match visible pages

Hello!


In that case, I think there should be an enhancement request, e.g. 

Page 1 / 2   1 / 3
Page 2 / 2   3 / 3

The page count should display both cases. This will certainly be less confusing.

At present, the page count is:

Page 1 / 3

Page 1  3 / 3



I agree that the PDF option
Export automatically inserted blank pages

makes the three pages.

Regards,

C. H. D. 


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












 寄件人︰ Brian Barker b.m.bar...@btinternet.com
收件人︰ users@global.libreoffice.org 
傳送日期︰ 2013年02月11日 (週一) 3:27 PM
主題︰ Re: [libreoffice-users] Page count does not match visible pages
 
At 08:39 11/02/2013 +0800, Conly Honly Donly wrote:
 2013/02/10 10:42 PM, Brian Barker:
 At 21:36 10/02/2013 +0800, Conly Honly Donly wrote:
 I think I have found a bug.
 
 I'm not so sure.
 
 This potential bug may affect printing, e.g. producing blank pages because 
 the page count does not look correct.
 
 In double-sided printing, odd-numbered pages need to be rectos, or 
 right-hand pages, and even ones versos, or left-hand pages. Your second page 
 is numbered 1, so LibreOffice expects to print it on the front of a second 
 leaf, not on the reverse of the first leaf. So you have three pages: the 
 first page, the blank reverse, and your second page, numbered 1. Go to 
 File | Page Preview to see the extra page.
 
 If you want to print single-sided, go to Tools | Options... | LibreOffice 
 Writer | Print | Other, and remove the tick from Print automatically 
 inserted blank pages. Then you won't get a blank sheet. You can make the 
 same selection on the fly through the Options... button in the Print 
 dialogue.
 
 I have tried: (both checking and unchecking)
 
 Tools | Options... | LibreOffice Writer | Print | Other | Print 
 automatically inserted blank pages
 
 The page count still appears as 3/3. It seems that this option is not 
 relevant, I am afraid.

Sorry, but you misunderstand me. What I am saying is that everything you see is 
by design, and will not be seen as a bug: Writer still sees three pages, even 
if you choose to print only two of these.

 Consider File - Export as PDF. In both cases, only two pages are visible in 
 each PDF file.

That's because the same option is controlled separately for exporting to PDF. 
The PDF Options dialogue, which you see when you use File | Export as PDF..., 
has, at the foot of the General tab, a separate Export automatically inserted 
blank pages tick box. Yours must currently be unticked. Writer thinks that if 
you print that exported PDF document double-sided, you will need that extra 
page - to ensure that your second significant page prints on the front of the 
second sheet, not on the reverse of the first.

I suppose that there is no simple answer to this which takes account of both 
single- and double-sided printing in an intuitive fashion.  But there's no bug, 
I think.

Brian Barker


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

Re: [libreoffice-users] Version 4.0 - Enjoying it?

2013-02-11 Thread M Henri Day

2013/2/11 Joel Madero jmadero@gmail.com

 Hi All,

 I hope you're all enjoying the new release of LibreOffice 4! For those of
 you who are finding LibreOffice to be a great productivity suite I
 encourage you to head over to http://donate.libreoffice.org/ and donate a
 few dollars to allow our great team of developers to continue improving on
 an already incredible product. LibreOffice is free and open but for many,
 it allows us to rid ourselves from other software which can be hundreds of
 dollars, even $5 helps a ton to maintain our infrastructure and to promote
 LibreOffice worldwide.

 I hope all of you will consider.

 Thanks for reading!

 Best Regards,
 Joel


Haven't yet had the opportunity to test it extensively, but one thing I
have noticed is that the new suite seems to launch significantly more
quickly than any previous versions (I've been around since OOo 1.1). Kudos
to the developers !...

Henri

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

[libreoffice-users] How can I create a certificate border?

2013-02-11 Thread Fabian Rodriguez


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi

Is there a way to create an elaborate border in LibreOffice/Draw? I'd
like to create a certficate. I tried searching for freely-licensed
templates for this and didn't find any.

Thanks in advance for any help with this.

F.

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

iEYEARECAAYFAlEZDLwACgkQfUcTXFrypNVRQACghURCCQqc/vIQ92rFH1GqanaB
WEEAoIl35koXuPtRL4EzrZSgeLbYqQoS
=OJrw
-END PGP SIGNATURE-


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

Re: [libreoffice-users] [Writer] Current page value?



Hello!

I am one of the many users. I have made a video (less than two minutes). If you 
turn on the captions in the video, you will see the steps in words.

Show or hide page number (footer) on last page in LibreOffice 4

http://youtu.be/FAbtRoIP8-o 

The feature of Page Styles helps me to customize the last page in less than 
two minutes. I do not know if this works for you. I do not know a faster way to 
do the things you described, i.e. to be continued to be printed on all pages 
except the last one.

For your information:

https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Video_Tutorials

Regards, 
C. H. D.






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












 寄件人︰ Jean-Francois Nifenecker jean-francois.nifenec...@laposte.net
收件人︰ users@global.libreoffice.org 
傳送日期︰ 2013年02月10日 (週日) 10:50 PM
主題︰ [libreoffice-users] [Writer] Current page value?
 
Hello,

does anyone know if it is possible to retrieve the current page number in a 
pre-defined variable in Writer?

The page count is available through the PAGE var, but I can't find anywhere (or 
do I have missed smthg?) a way to test against the current page num.

The aim is to have some text in the footer of any page, but the last one (eg 
to be cont'd) without regard to the pages styles.

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


`
On 02/11/2013 09:18 AM, Uwe Brauer wrote:

Hello

(It seems that my message did not pass to the gmane newserver, that is
why I resend this message)

I am using Kubuntu 10.04 and installed the latest LO 4.0 (the problem
occurs also in 3.6, and in OO 3.3).

I set up the intrinsic (hsql) data base. I created two tables using the
templates: one is Task (from business) the other Accounts (from
personal). All the field values are the default ones.  I use an existing
field as a primary key (autovalue on), namely TaskId (numeric) and
AccountId (numeric). I insert some data and save them.


I then set up a relation between the two tables, where I relate the
fields corresponding to the primary keys. (TaskId--AccountId) I save
the relation and reopen it.

Now I want to edit the relation and I am offered the possibility to add
more fields. So I select the notes file in either table but I receive
the following error.

  Primary or unique constraint required on main table.
  Accounts in statement [ALTER TABLE Tasks
   ADD FOREIGN KEY (TaskId,Notes) REFERENCE Accounts(AccountI,Notes)]
  
I am puzzled, in the intrinsic database only relations between primary

keys are possible?? Is this a property of the intrinsic database, or is it a
bug? I am thinking of submitting a bug report.

Any help would be appreciated

Uwe Brauer
 How do you define an intrinsic database? I do not understand the 
term.
 Primary-foreign key pairs are created when a table is normalized. 
(There several levels of normalized tables.) These pairs are based upon 
the relationships between the fields of the original table.
 So, you probably should put all the fields of the two tables into 
a single table with the exception of any fields that belong to both 
tables. For example the single table contains only one primary key 
(ID) and one field named Notes. Then look for any fields (other than 
ID) that determine the values of other fields. (In other words, begin 
to normalize the table.) Without knowing all of the fields that you are 
using, it would be difficult to know what fields these might be.
 FYI, very seldom will two tables have a 1:1 relationship (linking 
the primary keys of the two tables). Very likely, yours doesn't either. 
Most often, these relationships involve a primary key of one table and a 
foreign key of the other.


--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] How can I create a certificate border?


On 02/11/2013 10:22 AM, Fabian Rodriguez wrote:

Hi

Is there a way to create an elaborate border in LibreOffice/Draw? I'd
like to create a certficate. I tried searching for freely-licensed
templates for this and didn't find any.

Thanks in advance for any help with this.

F.



Fabian

Not finding certificate borders is weird.  Last year I need some and I 
found a lot.


This one has a few template background images.
http://all-free-download.com/free-vector/free-certificate-template.html

Some will require you to print to  PDF file and then use Draw to import 
it to create a JPG background image.  But there are solutions.


I also have found some in places like OpenClipart.org and other sites.  
Sometimes there are listed under borders.


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

Wow, I can't imagine that it is that difficult to install LibreOffice on
.deb or, for that matter, on any other package (.rpm) on Linux.

I am like Tim with his suggestions below. I am on Mageia Linux rpm.
Except I just don't like typing anything for installs in anything,
especially in console, except for passwords.

So, here is how I do my LibreOffice installs (in 4 steps), and, I am
pretty sure this is possible on a .deb install and on the majority of
Linux distros. Here is my KDE routine (I am pretty sure that the Gnome
routine would be the same and on most Linux window managers):

* uninstall the older version of LibreOffice (all of it) by using your
package manager. The only thing you have to type is the root password.
And yes, everything related to the 3.x.x.x or 4.x.x.x version that you
are replacing -- *the only thing to type is the root password*

* Download the LibreOffice.org download file(s) into a file folder. So,
for example, I created a file folder called v.3.0.0.3 and downloaded the
.tar.gz file there. No need to rename anything -- *there is nothing to
type*

* unpack the .tar.gz by right clicking on the file(s). If there are 2
.tar.gz files or more, you can even select all of them, the, right-click
and choose extract archive here -- *there is nothing to type*

* once unpacked, there will be a folder. Browse into the folder, pick
all of the .rpm files, then, right-click and choose Open
with-Software Installer. The package manager installer window opens
and asks you for the root password -- *the only thing to type is the
root password*

* \o/ done -- OK, I added this step just for fun

Linux has come a long way in user friendliness. There is no need to go
through all of these hoops to install a piece of software. If I were a
Windows user, this kind of thread would scare me away from using Linux
as it makes it sound so difficult to install. It is not that complicated
and there is really no need to make it this complicated -- if it were
this complicated to install LibreOffice, even I would consider moving to
another OS.

Phew, OK, I feel better now that I got this off my chest. Now where did
I put those blood pressure pills ... [*smile*]

Cheers,

Marc

Le 2013-02-10 22:27, webmaster-Kracked_P_P a écrit :

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. I also do not use the desktop as the
storage place fore the unarchived folder[s].

I keep forgetting the remove command so I use the package manager to
remove the LO packages from the previous version that was installed.
Works well for me.

Also, I tend to use the cd command to go to the proper folder[s] where
the dpkg command is needed. Long ago, in my mainframe days, I was
taught to go to the folder[s] where my files are to run them. That is
what I try to do. The only time I do not is when I have a launcher icon
to work with on my desktop. I prefer to use the GUI more than the
terminal anyways. Easier on my fingers and my typing skills after 3
strokes. So I do things as easy as I can, or easy as I can remember to
do/use.

On 02/10/2013 01:06 PM, Don Myers wrote:

Tom,

I used the following instructions to upgrade to LibreOffice 4.0.0.3 on
three machines with Ubuntu 12.10. It has worked really well so far. No
issues installing or using it. The bug that made some functions in
Base run unacceptably slow have been fixed!!!

*Instructions for the 64 Bit Debian Version:*
Download LibreOffice_4.0.0.3 to the desktop.
Right click on it and extract it to the desktop. This will give you
the folder LibreOffice_4.0.0.3_Linux_x86-64_deb
Run the following terminal commands to install it:
1. sudo apt-get remove libreoffice*.*
2. sudo dpkg -i ~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS/*.deb
3. sudo dpkg -i
~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS/desktop-integration/libreoffice4.0-debian-menus_4.0.0-103_all.deb

4. If using Unity, Open Dash, type Libre and you will see the
different components (Writer, Calc, etc.). Simply drag the icons for
them over to where you wish to have them in the launcher bar.

If you install it in this manner using the official Document
Foundation version, and you type libreoffice in the command line, I
get the following:

The program 'libreoffice' is currently not installed. You can install
it by typing:
sudo apt-get install libreoffice-common

An install as shown above does not have any repository from which it
originated. Therefore there aren't any updates, which I understand. If
it showed up as an installed program, Ubuntu would try to update the
LibreOffice with its own version which would lead to a royal

[libreoffice-users] Re: LO 4 documentation


Hi Caesar

Le 2013-02-11 06:54, Tom Davies a écrit :

Hi :)
You can get completed chapters in advance from
https://wiki.documentfoundation.org/Documentation/Publications

Errr, that page also has old archived versions.  Normally the guides wouldn't 
have come out until around the 4.0.4 so to see the Getting Started Guide is 
almost complete already is quite amazing!
Regards from
Tom :)



There is a way to get them quicker. You could join the docs team and 
help complete the chapters that you are interested in. That way, you 
know that they will come out quicker and the chapters that you want 
completed  are the ones that you care about. I don't think you will hear 
anyone complaining about you wanting to work only on the chapters that 
you want to work on.


Join up and help! Who knows, you may have so much fun that you will want 
to help finish another chapter that some other user hopes to have come 
out soon too! :-)


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

Hi :)
You don't need to do all that typing anyway.  Just press the tab key a few 
times and the terminal cleverly works out what you are aiming for.  It takes a 
bit of working out how it works at first but it's a real boon once you get used 
to it.  Renaming is not a bad idea though as it clarifies exactly what is what.

I thnk it inspired those old mobile phones that had predictive texting wy 
before smart-phones arrived.  Hmmm, thinking about it i wonder what OS they 
were running! ;)  Unfortunately the phones version of predictive text was quite 
a bit different and a bit of a pita for a lot of people.  Dunno how often my 
phone called my best buddy a cow!  

This has beena  great thread!  Thanks all :)  It's given me a lot to try out.
Regards from
Tom :)  






 From: webmaster-Kracked_P_P webmas...@krackedpress.com
To: users@global.libreoffice.org 
Sent: Monday, 11 February 2013, 3:27
Subject: Re: [libreoffice-users] Re: Installing the Deb
 


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.  I also do not use the desktop as the storage place fore the 
unarchived folder[s].

I keep forgetting the remove command so I use the package manager to remove 
the LO packages from the previous version that was installed.  Works well for 
me.

Also, I tend to use the cd command to go to the proper folder[s] where the 
dpkg command is needed.  Long ago, in my mainframe days, I was taught to go 
to the folder[s] where my files are to run them.  That is what I try to do.  
The only time I do not is when I have a launcher icon to work with on my 
desktop.  I prefer to use the GUI more than the terminal anyways.  Easier on 
my fingers and my typing skills after 3 strokes.  So I do things as easy as I 
can, or easy as I can remember to do/use.




On 02/10/2013 01:06 PM, Don Myers wrote:
 Tom,
 
 I used the following instructions to upgrade to LibreOffice 4.0.0.3 on three 
 machines with Ubuntu 12.10. It has worked really well so far. No issues 
 installing or using it. The bug that made some functions in Base run 
 unacceptably slow have been fixed!!!
 
 *Instructions for the 64 Bit Debian Version:*
 Download LibreOffice_4.0.0.3 to the desktop.
 Right click on it and extract it to the desktop. This will give you the 
 folder LibreOffice_4.0.0.3_Linux_x86-64_deb
 Run the following terminal commands to install it:
 1. sudo apt-get remove libreoffice*.*
 2. sudo dpkg -i ~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS/*.deb
 3. sudo dpkg -i 
 ~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS/desktop-integration/libreoffice4.0-debian-menus_4.0.0-103_all.deb
 4. If using Unity, Open Dash, type Libre and you will see the different 
 components (Writer, Calc, etc.). Simply drag the icons for them over to 
 where you wish to have them in the launcher bar.
 
 If you install it in this manner using the official Document Foundation 
 version, and you type libreoffice in the command line, I get the following:
 The program 'libreoffice' is currently not installed. You can install it by 
 typing:
 sudo apt-get install libreoffice-common
 An install as shown above does not have any repository from which it 
 originated. Therefore there aren't any updates, which I understand. If it 
 showed up as an installed program, Ubuntu would try to update the 
 LibreOffice with its own version which would lead to a royal mess!! I 
 did not get a message saying there is a missing package like you did.
 
 Don
 
 
 On 02/10/2013 09:59 AM, webmaster-Kracked_P_P wrote:
 
 Tom
 I ram the install on Linux Mint 14 and had no troubles with it.
 
 
 On 02/09/2013 03:07 PM, Tom Davies wrote:
 Hi :)
 I downloaded the .Deb for Ubuntu (and others) twice yday and tried
 installing it as per instructions but when i tried running LibreOffice
 from the command-line by typing in
 
 libreoffice
 
 I got an error message saying that LibreOffice couldn't run because i was 
 missing a package called something like
 
 
 libreoffice-common
 
 when i looked through all the packages in the Deb and desktop integration
 folders i found there was one!  I'm sure it's been there in previous
 releases?!  However when i double-click on a docX or odt or anything
 then LibreOffice 4 does successfully open it.
 
 
 So, it's a bit weird but doesn't seem to be problem unless i try that odd
 way of opening LO in a way that i would never normally have tried unless i 
 wanted to try to collect error reports and stuff (ie never).
 
 Regards from
 Tom :)
 
 
 


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

Re: [libreoffice-users] Re: Installing the Deb



The only typing I do is the

cd Lib
cd DEBS
sudo dpkg -i *.deb
cd desktop-integration
sudo dpkg -i *.deb[using up arrow till I get to that command]

No long folder or file names if you unpack the folder/files via the GUI 
file manager and archive package, then rename the folder to Lib.


I do the same thing for the help packs.

I do as little typing as I can.




On 02/11/2013 12:00 PM, Tom Davies wrote:

Hi :)
You don't need to do all that typing anyway.  Just press the tab key a few 
times and the terminal cleverly works out what you are aiming for.  It takes a 
bit of working out how it works at first but it's a real boon once you get used 
to it.  Renaming is not a bad idea though as it clarifies exactly what is what.

I thnk it inspired those old mobile phones that had predictive texting wy 
before smart-phones arrived.  Hmmm, thinking about it i wonder what OS they were running! 
;)  Unfortunately the phones version of predictive text was quite a bit different and a 
bit of a pita for a lot of people.  Dunno how often my phone called my best buddy a cow!

This has beena  great thread!  Thanks all :)  It's given me a lot to try out.
Regards from
Tom :)







From: webmaster-Kracked_P_P webmas...@krackedpress.com
To: users@global.libreoffice.org
Sent: Monday, 11 February 2013, 3:27
Subject: Re: [libreoffice-users] Re: Installing the Deb



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.  I also do not 
use the desktop as the storage place fore the unarchived folder[s].

I keep forgetting the remove command so I use the package manager to remove 
the LO packages from the previous version that was installed.  Works well for me.

Also, I tend to use the cd command to go to the proper folder[s] where the 
dpkg command is needed.  Long ago, in my mainframe days, I was taught to go to the 
folder[s] where my files are to run them.  That is what I try to do.  The only time I do not is 
when I have a launcher icon to work with on my desktop.  I prefer to use the GUI more than the 
terminal anyways.  Easier on my fingers and my typing skills after 3 strokes.  So I do things as 
easy as I can, or easy as I can remember to do/use.




On 02/10/2013 01:06 PM, Don Myers wrote:

Tom,

I used the following instructions to upgrade to LibreOffice 4.0.0.3 on three 
machines with Ubuntu 12.10. It has worked really well so far. No issues 
installing or using it. The bug that made some functions in Base run 
unacceptably slow have been fixed!!!

*Instructions for the 64 Bit Debian Version:*
Download LibreOffice_4.0.0.3 to the desktop.
Right click on it and extract it to the desktop. This will give you the folder 
LibreOffice_4.0.0.3_Linux_x86-64_deb
Run the following terminal commands to install it:
1. sudo apt-get remove libreoffice*.*
2. sudo dpkg -i ~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS/*.deb
3. sudo dpkg -i 
~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS/desktop-integration/libreoffice4.0-debian-menus_4.0.0-103_all.deb
4. If using Unity, Open Dash, type Libre and you will see the different 
components (Writer, Calc, etc.). Simply drag the icons for them over to where 
you wish to have them in the launcher bar.

If you install it in this manner using the official Document Foundation 
version, and you type libreoffice in the command line, I get the following:

The program 'libreoffice' is currently not installed. You can install it by 
typing:
sudo apt-get install libreoffice-common

An install as shown above does not have any repository from which it 
originated. Therefore there aren't any updates, which I understand. If it 
showed up as an installed program, Ubuntu would try to update the LibreOffice 
with its own version which would lead to a royal mess!! I did not get a 
message saying there is a missing package like you did.

Don


On 02/10/2013 09:59 AM, webmaster-Kracked_P_P wrote:

Tom
I ram the install on Linux Mint 14 and had no troubles with it.


On 02/09/2013 03:07 PM, Tom Davies wrote:

Hi :)
I downloaded the .Deb for Ubuntu (and others) twice yday and tried
installing it as per instructions but when i tried running LibreOffice
from the command-line by typing in

libreoffice

I got an error message saying that LibreOffice couldn't run because i was 
missing a package called something like


libreoffice-common

when i looked through all the packages in the Deb and desktop integration
folders i found there was one!  I'm sure it's been there in previous
releases?!  However when i double-click on a docX or odt or anything
then LibreOffice 4 does successfully open it.


So, it's a bit weird but doesn't seem to be problem unless i try that odd
way of opening LO in a way that i would never normally have tried unless i

[libreoffice-users] Re: How can I create a certificate border?


Bonjour Fabian,

Sure, there are some templates that you can use on the AOO website 
templates[1]. You can download some  of these and then either use them 
or use them as a base to mod your own.


If you wonder how to download them, do the following:



* click on the Use it! button, this will lead you to a download 
webpage which will lead to a black rendering page of the .ott file.




* take into note the number and the name of the file in the URL



* Cut the URL of that page back to the aoo-templates/ section and do a 
return to surf to the sourceforge.net page.




* you will now be on the sourceforge.net page. Browse DOWN to the number 
and file name




* right-click on the file name and save it



* once save, just locate the file in your system and right-click on it 
and say open (with LibreOffice)




* done!




Cheers

Marc

[1] http://templates.services.openoffice.org/en/search/node/certificate

Le 2013-02-11 10:22, Fabian Rodriguez a écrit :


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi

Is there a way to create an elaborate border in LibreOffice/Draw? I'd
like to create a certficate. I tried searching for freely-licensed
templates for this and didn't find any.

Thanks in advance for any help with this.

F.

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

iEYEARECAAYFAlEZDLwACgkQfUcTXFrypNVRQACghURCCQqc/vIQ92rFH1GqanaB
WEEAoIl35koXuPtRL4EzrZSgeLbYqQoS
=OJrw
-END PGP SIGNATURE-





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

Hi :)
When you get to the s in desktop-integration try pressing the tab key and watch 
the rest of the line get put in for you ;)  

I agree with Marc and feel compelled to point out that normally installing 
stuff is much easier on GnuLinux, and safer.  It's because we are all trying 
to do something unusual, something that we wouldn't normally do, that it's 
getting complicated.  

Normally i wouldn't even have to download anything from a website using a 
web-browser or visit sites i could never entirely be certain of or trust 
friends or a shop that might not know everything to watch out for.  Normally i 
just open my Package Manager instead of a web-browser.  Then i tell it 
roughly what i want.  Even if i don't know a name it gives a bunch of choices.  
I click on one or more of the choices and click the Install button.  From 
then on the package manager looks after updating it for me and making sure it 
doesn't break or get corrupted or anything.  It just does the whole job of 
downloading, installing and updating.  

Regards from
Tom :)  






 From: webmaster-Kracked_P_P webmas...@krackedpress.com
To: users@global.libreoffice.org 
Sent: Monday, 11 February 2013, 17:13
Subject: Re: [libreoffice-users] Re: Installing the Deb
 

The only typing I do is the

cd Lib
cd DEBS
sudo dpkg -i *.deb
cd desktop-integration
sudo dpkg -i *.deb    [using up arrow till I get to that command]

No long folder or file names if you unpack the folder/files via the GUI 
file manager and archive package, then rename the folder to Lib.

I do the same thing for the help packs.

I do as little typing as I can.




On 02/11/2013 12:00 PM, Tom Davies wrote:
 Hi :)
 You don't need to do all that typing anyway.  Just press the tab key a few 
 times and the terminal cleverly works out what you are aiming for.  It takes 
 a bit of working out how it works at first but it's a real boon once you get 
 used to it.  Renaming is not a bad idea though as it clarifies exactly what 
 is what.

 I thnk it inspired those old mobile phones that had predictive texting 
 wy before smart-phones arrived.  Hmmm, thinking about it i wonder what 
 OS they were running! ;)  Unfortunately the phones version of predictive 
 text was quite a bit different and a bit of a pita for a lot of people.  
 Dunno how often my phone called my best buddy a cow!

 This has beena  great thread!  Thanks all :)  It's given me a lot to try out.
 Regards from
 Tom :)





 
 From: webmaster-Kracked_P_P webmas...@krackedpress.com
 To: users@global.libreoffice.org
 Sent: Monday, 11 February 2013, 3:27
 Subject: Re: [libreoffice-users] Re: Installing the Deb



 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.  I also do not use the desktop as the storage place 
 fore the unarchived folder[s].

 I keep forgetting the remove command so I use the package manager to 
 remove the LO packages from the previous version that was installed.  Works 
 well for me.

 Also, I tend to use the cd command to go to the proper folder[s] where 
 the dpkg command is needed.  Long ago, in my mainframe days, I was taught 
 to go to the folder[s] where my files are to run them.  That is what I try 
 to do.  The only time I do not is when I have a launcher icon to work with 
 on my desktop.  I prefer to use the GUI more than the terminal anyways.  
 Easier on my fingers and my typing skills after 3 strokes.  So I do things 
 as easy as I can, or easy as I can remember to do/use.




 On 02/10/2013 01:06 PM, Don Myers wrote:
 Tom,

 I used the following instructions to upgrade to LibreOffice 4.0.0.3 on 
 three machines with Ubuntu 12.10. It has worked really well so far. No 
 issues installing or using it. The bug that made some functions in Base 
 run unacceptably slow have been fixed!!!

 *Instructions for the 64 Bit Debian Version:*
 Download LibreOffice_4.0.0.3 to the desktop.
 Right click on it and extract it to the desktop. This will give you the 
 folder LibreOffice_4.0.0.3_Linux_x86-64_deb
 Run the following terminal commands to install it:
 1. sudo apt-get remove libreoffice*.*
 2. sudo dpkg -i ~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS/*.deb
 3. sudo dpkg -i 
 ~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS/desktop-integration/libreoffice4.0-debian-menus_4.0.0-103_all.deb
 4. If using Unity, Open Dash, type Libre and you will see the different 
 components (Writer, Calc, etc.). Simply drag the icons for them over to 
 where you wish to have them in the launcher bar.

 If you install it in this manner using the official Document Foundation 
 version, and you type libreoffice in the command line, I get the following:
 The program 'libreoffice' is currently not installed.

[libreoffice-users] Making local help copy?

2013-02-11 Thread Kolbjørn Stuestøl

Is there a (simple) way to build, assemble, or make a local copy of the 
.po help files?


I am translating the LO Pootle po files and it would help me a lot if I 
was able to control my work from time to time instead of waiting weeks 
or months.

By the way, how often is the build-in help system updated?

I am also translating GIMP which uses HTML for its help files. The 
clever developers of the documentation team has created a little program 
creating the help files from the command make html-xx where xx is the 
language code. So simple. (Yes, I know LO is using a quite different 
help system).


Kolbjoern

--
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-11 Thread Don C. Myers


Hi All,

A simple copy and paste works really well!! No typing necessary. 
Just make sure you have the file saved as a .txt that you open with GEdit.


When I was new to Linux (Ubuntu) and didn't understand anything about 
what the system was really doing or about the file structure, OpenOffice 
was updated, and it wasn't going to be included for Ubuntu users until 
the next update, which was three or 4 months down the road. I ran across 
this method as a way to update my OpenOffice without waiting. The same 
thing took place with the next OpenOffice release. Again I found the 
updated instructions on the Internet. I still use this as it is easy to 
update computers. I've installed Ubuntu on about 23 or so. It is also 
easy for a new person to Ubuntu since they don't have to understand 
changing directories, etc. Simple extract the download to the desktop, 
and then copy and paste the three commands into the terminal.


Don


On 02/11/2013 12:00 PM, Tom Davies wrote:

Hi :)
You don't need to do all that typing anyway.  Just press the tab key a few 
times and the terminal cleverly works out what you are aiming for.  It takes a 
bit of working out how it works at first but it's a real boon once you get used 
to it.  Renaming is not a bad idea though as it clarifies exactly what is what.

I thnk it inspired those old mobile phones that had predictive texting wy 
before smart-phones arrived.  Hmmm, thinking about it i wonder what OS they were running! 
;)  Unfortunately the phones version of predictive text was quite a bit different and a 
bit of a pita for a lot of people.  Dunno how often my phone called my best buddy a cow!

This has beena  great thread!  Thanks all :)  It's given me a lot to try out.
Regards from
Tom :)







From: webmaster-Kracked_P_P webmas...@krackedpress.com
To: users@global.libreoffice.org
Sent: Monday, 11 February 2013, 3:27
Subject: Re: [libreoffice-users] Re: Installing the Deb



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.  I also do not 
use the desktop as the storage place fore the unarchived folder[s].

I keep forgetting the remove command so I use the package manager to remove 
the LO packages from the previous version that was installed.  Works well for me.

Also, I tend to use the cd command to go to the proper folder[s] where the 
dpkg command is needed.  Long ago, in my mainframe days, I was taught to go to the 
folder[s] where my files are to run them.  That is what I try to do.  The only time I do not is 
when I have a launcher icon to work with on my desktop.  I prefer to use the GUI more than the 
terminal anyways.  Easier on my fingers and my typing skills after 3 strokes.  So I do things as 
easy as I can, or easy as I can remember to do/use.




On 02/10/2013 01:06 PM, Don Myers wrote:

Tom,

I used the following instructions to upgrade to LibreOffice 4.0.0.3 on three 
machines with Ubuntu 12.10. It has worked really well so far. No issues 
installing or using it. The bug that made some functions in Base run 
unacceptably slow have been fixed!!!

*Instructions for the 64 Bit Debian Version:*
Download LibreOffice_4.0.0.3 to the desktop.
Right click on it and extract it to the desktop. This will give you the folder 
LibreOffice_4.0.0.3_Linux_x86-64_deb
Run the following terminal commands to install it:
1. sudo apt-get remove libreoffice*.*
2. sudo dpkg -i ~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS/*.deb
3. sudo dpkg -i 
~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS/desktop-integration/libreoffice4.0-debian-menus_4.0.0-103_all.deb
4. If using Unity, Open Dash, type Libre and you will see the different 
components (Writer, Calc, etc.). Simply drag the icons for them over to where 
you wish to have them in the launcher bar.

If you install it in this manner using the official Document Foundation 
version, and you type libreoffice in the command line, I get the following:

The program 'libreoffice' is currently not installed. You can install it by 
typing:
sudo apt-get install libreoffice-common

An install as shown above does not have any repository from which it 
originated. Therefore there aren't any updates, which I understand. If it 
showed up as an installed program, Ubuntu would try to update the LibreOffice 
with its own version which would lead to a royal mess!! I did not get a 
message saying there is a missing package like you did.

Don


On 02/10/2013 09:59 AM, webmaster-Kracked_P_P wrote:

Tom
I ram the install on Linux Mint 14 and had no troubles with it.


On 02/09/2013 03:07 PM, Tom Davies wrote:

Hi :)
I downloaded the .Deb for Ubuntu (and others) twice yday and tried
installing it as per instructions but when i tried running LibreOffice
from the command-line

Re: [libreoffice-users] Re: Installing the Deb

2013-02-11 Thread doug

On 02/11/2013 12:30 PM, Tom Davies wrote:

Hi :)
When you get to the s in desktop-integration try pressing the tab key and watch
the rest of the line get put in for you ;)

I agree with Marc and feel compelled to point out that normally installing stuff is
much easier on GnuLinux, and safer. It's because we are all trying to do
something unusual, something that we wouldn't normally do, that it's getting
complicated.

Normally i wouldn't even have to download anything from a website using a web-browser or visit
sites i could never entirely be certain of or trust friends or a shop that might not know
everything to watch out for. Normally i just open my Package Manager instead of a
web-browser. Then i tell it roughly what i want. Even if i don't know a name it gives a bunch of
choices. I click on one or more of the choices and click the Install button. From
then on the package manager looks after updating it for me and making sure it doesn't break or get
corrupted or anything. It just does the whole job of downloading, installing and updating.

Regards from
Tom :)

/snip/

This is the Microsoft/Apple/Ubuntu attitude. If you want a nanny, use
one of those. What do you do when you need something
that's NOT in your repo? LightScribe, frinstance? You'd better learn
how to use either rpm or deb, whichever your system
uses, or you will be smothered by those four walls you have allowed some
distro to erect around you!

--doug

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

2013-02-11 Thread Todd E. Moore

Trying to determine where
  best to request help.A file sent to me includes VB macros created in MS 
Excel.The
  macro handler in LibreOffice (both 3.6 and 4.0) end up in an
  exception loop which cannot be stopped unless I kill the process
  from the system command line.Is there a specific way to address the 
Subject line or a different
  forum/mailing list I should use for requesting help?I wanted to make sure 
I send to the correct place before
  cluttering up folks' Inbox with a hefty file.
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Installing the Deb


On 02/11/2013 11:53 AM, Marc Paré wrote:
Wow, I can't imagine that it is that difficult to install LibreOffice 
on .deb or, for that matter, on any other package (.rpm) on Linux.


I am like Tim with his suggestions below. I am on Mageia Linux rpm. 
Except I just don't like typing anything for installs in anything, 
especially in console, except for passwords.


So, here is how I do my LibreOffice installs (in 4 steps), and, I am 
pretty sure this is possible on a .deb install and on the majority of 
Linux distros. Here is my KDE routine (I am pretty sure that the Gnome 
routine would be the same and on most Linux window managers):


=

* uninstall the older version of LibreOffice (all of it) by using your 
package manager. The only thing you have to type is the root password. 
And yes, everything related to the 3.x.x.x or 4.x.x.x version that you 
are replacing -- *the only thing to type is the root password*


=

* Download the LibreOffice.org download file(s) into a file folder. 
So, for example, I created a file folder called v.3.0.0.3 and 
downloaded the  .tar.gz file there. No need to rename anything -- 
*there is nothing to type*


=

* unpack the .tar.gz by right clicking on the file(s). If there are 2 
.tar.gz files or more, you can even select all of them, the, 
right-click and choose extract archive here -- *there is nothing to 
type*


=

* once unpacked, there will be a folder. Browse into the folder, pick 
all of the .rpm files, then, right-click and choose Open 
with-Software Installer. The package manager installer window 
opens and asks you for the root password -- *the only thing to type is 
the root password*


=

* \o/ done  -- OK, I added this step just for fun

=

Linux has come a long way in user friendliness. There is no need to go 
through all of these hoops to install a piece of software. If I were a 
Windows user, this kind of thread would scare me away from using Linux 
as it makes it sound so difficult to install. It is not that 
complicated and there is really no need to make it this complicated -- 
if it were this complicated to install LibreOffice, even I would 
consider moving to another OS.


Phew, OK, I feel better now that I got this off my chest. Now where 
did I put those blood pressure pills ... [*smile*]


Cheers,

Marc
 There are a variety of ways to install LO for Debian OS's. Some 
are harder than others, and some are easier.
 What no one has mentioned is the use of script files. They will do 
much of the work for you. Planning how to install the Deb files is 
important.
If you have LO from your OS, you need to use Synaptic (Step#1 
mentioned above.) But this is the only time you need to do this. dpkg 
(installs the Deb files) writes the new files over the existing files. 
There is no need to remove them.
Extract the installation folder and always place it in the same 
location. (This is important for the contents of the script file.)


 Example of the script file:
  #!/bin/sh
  cd 
/home/dan/Downloads/LO/LibO_3.6.5.2_Linux_x86-64_install-deb_en-US/DEBS/

  sudo dpkg -i *.deb
  cd desktop-integration
  sudo dpkg -i *.deb
This looks like a lot of typing, but it is not really. Besides much of 
it is used over and over again. The third line is the longest. cd 
/home/dan/Downloads/LO/ is the location for the installation folder 
that you extracted. LibO_3.6.5.2_Linux_x86-64_install-deb_en-US is the 
name of that folder.
 I do not like to type long names like the name of the installation 
folder, so I look for a short cut. I use the file browser (Nautilus) to 
go to this folder's location, I can right click on the folder and select 
Properties. There at the top is the folder's name highlighted. Ctrl+C 
copies the name, and I paste it into the third line. I also erase the 
name of the previous folder. Another method: erase the number of the 
previous LO version and type in the new number. In this case, replace 
3.6.5.2 with 4.0.0.3.

 What this does: installs the Deb files and desktop integration items.
 The script file needs to be executable when it was first created. 
To do this right click the script file, select Properties -  
Permissions. Click the box labelled Allow executing the file as a program.

 The location of the script file might be important also.
 So actual steps to install 4.0.0.3:
1) Download the file to /home/dan/Downloads/LO/.
2) Extract the downloaded file to the same location.
3) Update the third line of the script file using either method using gedit.
4) In the file browser, double click the script file.
5) Click the button Run in Terminal.
6) Type your password.
7) Close the terminal.
 The first two steps involve only clicks. Step 3 can involve only 
using the mouse, or typing 4 digits and 3 periods. Only step 6 involves 
typing with the rest

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

2013-02-11 Thread Tom

Hi :)
This is the correct place. There are a few different ways of viewing the
emails sent to the list. Nabble is the method that has the prettiest gui.

Normals attachments to the list get stripped of to prevent exactly the
problem you are worrying about there. However, you can upload files to
Nabble by clicking the More button just above where you type your message.
The top-option there is to upload file. That then puts a link to the
upload in the message in a way that looks a lot like an html link. So that
everyone gets the link whichever method they use to view emails to the list.
People can then choose to click on that link or not.

When you open the file that contains a macro you should be given a choice of
ignoring the macro or allowing it. Macros can be pretty nasty things and
can easily be corrupted by clever malware so it's best to avoid using them.
LibreOffice offers a choice of languages to write macros in and even the one
closest to MS Office's tends to be a lot safer.

Regards from
Tom :)

--
View this message in context:
http://nabble.documentfoundation.org/MS-Excel-file-macros-cause-infinite-loop-of-errors-tp4036471p4036477.html
Sent from the Users mailing list archive at Nabble.com.

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

2013-02-11 Thread Jay Lozier


On 02/11/2013 12:52 PM, Todd E. Moore wrote:

Trying to determine where
   best to request help.A file sent to me includes VB macros created in MS 
Excel.The
   macro handler in LibreOffice (both 3.6 and 4.0) end up in an
   exception loop which cannot be stopped unless I kill the process
   from the system command line.Is there a specific way to address the 
Subject line or a different
   forum/mailing list I should use for requesting help?I wanted to make 
sure I send to the correct place before
   cluttering up folks' Inbox with a hefty file.

Todd

Either upload the file to Nabble or post the file some and provide a link.

I am not expert on macros but infinite loops are caused by a serious 
logic error - not providing a loop exit condition that tests correctly. 
I would expect the problem to in a WHILE/DO loop where there most be an 
exit condition that terminates the loop.


For example

i = 10
While i   1 do
loop body
i = i + 1

This above will always test TRUE and never exit. I have explicitly shown 
i incrementing.


But the following will exit because the loop condition will eventually 
evaluate to false:


i = 10
While i   1000 do
loop body
i = i + 1

Another error is for the above examples is to forget to increment i

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

2013-02-11 Thread Alexander Thurgood

Le 11/02/13 15:18, Uwe Brauer a écrit :

Hi Uwe,

 Now I want to edit the relation and I am offered the possibility to add
 more fields. So I select the notes file in either table but I receive
 the following error.
 
  Primary or unique constraint required on main table.
  Accounts in statement [ALTER TABLE Tasks
   ADD FOREIGN KEY (TaskId,Notes) REFERENCE Accounts(AccountI,Notes)]
  
 I am puzzled, in the intrinsic database only relations between primary
 keys are possible?? Is this a property of the intrinsic database, or is it a
 bug? I am thinking of submitting a bug report.
 

The following possibilities occur to me :

(a) you might need to drop your previously configured constraint  before
you can set up a new one via the GUI. From what I recall, this might
only be possible manually, i.e. by issuing a SQL command (menu Tools 
SQL) to DROP the CONSTRAINT from the tables, then shutting down the db
file, closing LO completely and re-opening.

(b) you might not be able to set combined constraints on more than one
field in both tables simultaneously via the GUI - again you may find
that you have to do this manually (although it may actually turn out to
be a limitation of hsqldb 1.8, I haven't checked)


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


Le 2013-02-11 12:50, Don C. Myers a écrit :

Hi All,

A simple copy and paste works really well!! No typing necessary.
Just make sure you have the file saved as a .txt that you open with GEdit.

When I was new to Linux (Ubuntu) and didn't understand anything about
what the system was really doing or about the file structure, OpenOffice
was updated, and it wasn't going to be included for Ubuntu users until
the next update, which was three or 4 months down the road. I ran across
this method as a way to update my OpenOffice without waiting. The same
thing took place with the next OpenOffice release. Again I found the
updated instructions on the Internet. I still use this as it is easy to
update computers. I've installed Ubuntu on about 23 or so. It is also
easy for a new person to Ubuntu since they don't have to understand
changing directories, etc. Simple extract the download to the desktop,
and then copy and paste the three commands into the terminal.

Don



This I also agree with as well. If the scripts fit for everyone. 
However, there is no sense making installing LibreOffice (the downloaded 
files) sound so complicated for Linux. You don't really need to know 
much about installing .deb's or .rpm's other than to right-click and 
the files and picking the right choices. That's all.


In fact, if you are just installing one .deb or .rpm, on most systems, 
you just have to double-click on the .deb or .rpm file and it will call 
up the distro's installer. It's just that simple. Just like it is done 
on Windows.


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



I now have the terminal commands in a text document.  I keep forgetting 
the remove command's text.  So I just use the package manager to 
remove the previous version.


Maybe there could be a sh libre-update.run type of command made and 
placed in the archived folder one level up from the DEBS folder.  Then 
all someone needs to so is run one command in the terminal that would do 
everything else.  Make it generic so it would not need changing for 
every version.  Do the same for the RPM installs.


How easy would it be then?  run one command that will do everything for 
you so it would not take any other typing, except your password, to get 
the Linux versions installed.  Windows users get one double clicking of 
the file, plus the custom install options, to install LO.  Have a 
simple single line command to remove the old version of LO and install 
the new one would be really nice.


Still, some Linux users would not like that.  It would make my life 
easier sometimes.



On 02/11/2013 12:50 PM, Don C. Myers wrote:

Hi All,

A simple copy and paste works really well!! No typing necessary. 
Just make sure you have the file saved as a .txt that you open with 
GEdit.


When I was new to Linux (Ubuntu) and didn't understand anything about 
what the system was really doing or about the file structure, 
OpenOffice was updated, and it wasn't going to be included for Ubuntu 
users until the next update, which was three or 4 months down the 
road. I ran across this method as a way to update my OpenOffice 
without waiting. The same thing took place with the next OpenOffice 
release. Again I found the updated instructions on the Internet. I 
still use this as it is easy to update computers. I've installed 
Ubuntu on about 23 or so. It is also easy for a new person to Ubuntu 
since they don't have to understand changing directories, etc. Simple 
extract the download to the desktop, and then copy and paste the three 
commands into the terminal.


Don


On 02/11/2013 12:00 PM, Tom Davies wrote:

Hi :)
You don't need to do all that typing anyway.  Just press the tab key 
a few times and the terminal cleverly works out what you are aiming 
for.  It takes a bit of working out how it works at first but it's a 
real boon once you get used to it.  Renaming is not a bad idea though 
as it clarifies exactly what is what.


I thnk it inspired those old mobile phones that had predictive 
texting wy before smart-phones arrived.  Hmmm, thinking about it 
i wonder what OS they were running! ;)  Unfortunately the phones 
version of predictive text was quite a bit different and a bit of a 
pita for a lot of people.  Dunno how often my phone called my best 
buddy a cow!


This has beena  great thread!  Thanks all :)  It's given me a lot to 
try out.

Regards from
Tom :)







From: webmaster-Kracked_P_P webmas...@krackedpress.com
To: users@global.libreoffice.org
Sent: Monday, 11 February 2013, 3:27
Subject: Re: [libreoffice-users] Re: Installing the Deb



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.  I also do not use 
the desktop as the storage place fore the unarchived folder[s].


I keep forgetting the remove command so I use the package manager 
to remove the LO packages from the previous version that was 
installed.  Works well for me.


Also, I tend to use the cd command to go to the proper folder[s] 
where the dpkg command is needed.  Long ago, in my mainframe days, 
I was taught to go to the folder[s] where my files are to run them.  
That is what I try to do.  The only time I do not is when I have a 
launcher icon to work with on my desktop.  I prefer to use the GUI 
more than the terminal anyways.  Easier on my fingers and my typing 
skills after 3 strokes.  So I do things as easy as I can, or easy as 
I can remember to do/use.





On 02/10/2013 01:06 PM, Don Myers wrote:

Tom,

I used the following instructions to upgrade to LibreOffice 4.0.0.3 
on three machines with Ubuntu 12.10. It has worked really well so 
far. No issues installing or using it. The bug that made some 
functions in Base run unacceptably slow have been fixed!!!


*Instructions for the 64 Bit Debian Version:*
Download LibreOffice_4.0.0.3 to the desktop.
Right click on it and extract it to the desktop. This will give you 
the folder LibreOffice_4.0.0.3_Linux_x86-64_deb

Run the following terminal commands to install it:
1. sudo apt-get remove libreoffice*.*
2. sudo dpkg -i 
~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS/*.deb
3. sudo dpkg -i 
~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS/desktop-integration/libreoffice4.0-debian-menus_4.0.0-103_all.deb
4. If using Unity, Open Dash, type Libre and you will see the 
different components (Writer, Calc, etc.). Simply

[libreoffice-users] Re: Installing the Deb

2013-02-11 Thread Tom

Hi :)
Tractor's method worked really well for me.  For clarity i think i would add
a step in order to be able to reduce the critical 2 lines

1.  sudo apt-get remove libreoffice*.*
2.  cd ~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS
Except that i didn't download to the Desktop.  I downloaded to Downloads and
then did
  right-click - Extract to here
So, my version of this step was
cd ~/Downloads/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS
At around the D or o of Downloads i pressed the Tab key to complete that
word.  Then pressed Tab again at the L or i of the next bit to complete that
long bit and then Tab 3rd time just after typing in a capital D to save
myself the effort of typing in the 3 remaining letters there.  
3.  sudo dpkg -i *.deb
4.  cd desktop-integration
Again Tab just after typing in the d at the beginning of desktop there
saved me the hassle of typing the rest which helps me avoid the inevitable
tpyos.  
5.  sudo dpkg -i *.deb
Errr, again i cheated here by just pressing the keyboard's up arrow twice in
order to get back to the 2nd-to-last command i typed in.  (one that i did
entirely type in myself for once (well copypasted it with the mouse but
same same (oddly keyboard paste doesn't work but mouse paste is always
good)))
6. If using Unity, Open Dash, type Libre and you will see the different
components (Writer, Calc, etc.). Simply drag the icons for them over to
where you wish to have them in the launcher bar. 

All worked really nicely and meant i could keep doing ls or dir to see what
was in the folder i was about to do stuff with.  Boiling those instructions
down i got  

1.  sudo apt-get remove libreoffice*.*
2.  cd ~/Desktop/LibreOffice_4.0.0.3_Linux_x86-64_deb/DEBS
3.  sudo dpkg -i *.deb
4.  cd desktop-integration
5.  sudo dpkg -i *.deb

6. If using Unity, Open Dash, type Libre and you will see the different
components (Writer, Calc, etc.). Simply drag the icons for them over to
where you wish to have them in the launcher bar. 

After doing the cd commands i do a dir or ls to see a list of files in the
folder.  Note that steps 3 and 5 were exactly the same command but just done
in different folders.  Up arrow cycles through as many old commands as i
could count.  Step 2 was the one that people might find is a little
different depending on exactly where you put things.  Tab was a real boon in
step 2 but Tim's method of renaming the folder works well too.   Dan's idea
of writing a script is a bit too advanced for me but looks well worth giving
a try because it looks like it might well work next time i want to upgrade. 
Just double-clicking the script would beat all that messing around.  

So, many thanks to all!
Regards from
Tom :)  



--
View this message in context: 
http://nabble.documentfoundation.org/Re-Installing-the-Deb-tp4035905p4036490.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Re: Installing the Deb


Le 2013-02-11 13:05, Dan Lewis a écrit :


There are a variety of ways to install LO for Debian OS's. Some are
harder than others, and some are easier.
What no one has mentioned is the use of script files. They will do much
of the work for you. Planning how to install the Deb files is important.
If you have LO from your OS, you need to use Synaptic (Step#1 mentioned
above.) But this is the only time you need to do this. dpkg (installs
the Deb files) writes the new files over the existing files. There is no
need to remove them.
Extract the installation folder and always place it in the same
location. (This is important for the contents of the script file.)

Example of the script file:
#!/bin/sh
cd /home/dan/Downloads/LO/LibO_3.6.5.2_Linux_x86-64_install-deb_en-US/DEBS/
sudo dpkg -i *.deb
cd desktop-integration
sudo dpkg -i *.deb
This looks like a lot of typing, but it is not really. Besides much of
it is used over and over again. The third line is the longest. cd
/home/dan/Downloads/LO/ is the location for the installation folder
that you extracted. LibO_3.6.5.2_Linux_x86-64_install-deb_en-US is the
name of that folder.
I do not like to type long names like the name of the installation
folder, so I look for a short cut. I use the file browser (Nautilus) to
go to this folder's location, I can right click on the folder and select
Properties. There at the top is the folder's name highlighted. Ctrl+C
copies the name, and I paste it into the third line. I also erase the
name of the previous folder. Another method: erase the number of the
previous LO version and type in the new number. In this case, replace
3.6.5.2 with 4.0.0.3.
What this does: installs the Deb files and desktop integration items.
The script file needs to be executable when it was first created. To do
this right click the script file, select Properties - Permissions.
Click the box labelled Allow executing the file as a program.
The location of the script file might be important also.
So actual steps to install 4.0.0.3:
1) Download the file to /home/dan/Downloads/LO/.
2) Extract the downloaded file to the same location.
3) Update the third line of the script file using either method using
gedit.
4) In the file browser, double click the script file.
5) Click the button Run in Terminal.
6) Type your password.
7) Close the terminal.
The first two steps involve only clicks. Step 3 can involve only using
the mouse, or typing 4 digits and 3 periods. Only step 6 involves typing
with the rest done by mouse clicks.

--Dan



Yes, but a newcomer to Linux who wished to install LibreOffice on 
her/his distro would not know this, and hopefully, would just do what 
most people would do and unpack the compressed files and double-click 
the .deb's or .rpm's ... or select all of them - right-click and choose 
to open with the file manager.


I don't believe we are doing our users any service by suggesting all of 
these convoluted ways of installing. Let's promote the easy and straight 
forward. it really simple.


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


On 02/11/2013 01:43 PM, Marc Paré wrote:

Le 2013-02-11 12:50, Don C. Myers a écrit :

Hi All,

A simple copy and paste works really well!! No typing necessary.
Just make sure you have the file saved as a .txt that you open with 
GEdit.


When I was new to Linux (Ubuntu) and didn't understand anything about
what the system was really doing or about the file structure, OpenOffice
was updated, and it wasn't going to be included for Ubuntu users until
the next update, which was three or 4 months down the road. I ran across
this method as a way to update my OpenOffice without waiting. The same
thing took place with the next OpenOffice release. Again I found the
updated instructions on the Internet. I still use this as it is easy to
update computers. I've installed Ubuntu on about 23 or so. It is also
easy for a new person to Ubuntu since they don't have to understand
changing directories, etc. Simple extract the download to the desktop,
and then copy and paste the three commands into the terminal.

Don



This I also agree with as well. If the scripts fit for everyone. 
However, there is no sense making installing LibreOffice (the 
downloaded files) sound so complicated for Linux. You don't really 
need to know much about installing .deb's or .rpm's other than to 
right-click and the files and picking the right choices. That's all.


In fact, if you are just installing one .deb or .rpm, on most systems, 
you just have to double-click on the .deb or .rpm file and it will 
call up the distro's installer. It's just that simple. Just like it is 
done on Windows.


Cheers,

Marc


The only reason you cannot double click any of the .deb files in the 
install's DEBS folder is the fact that you need to make sure they are 
all run due to the file dependency issues.  They have to be run in a 
certain order, sort of.


It would be nice to have a double-click script that could be run that 
way that will run all of the .deb file in the folder, but it is not as 
easy as that, or that single double-clicking file/script might have been 
created by now.


So far, needing the terminal to install packages [not all] is a problem 
for some users who want to switch from Windows.  Also, sometimes the 
double-clicked package installs do not even make a menu or desktop 
launcher icon, so you have to go into the bin or other folder and 
create your own launcher icon.  I had to do that for the Canon Scanning 
package.  It was /usr/bin/scangearmp and how many new users to Linux 
would know how to create a launcher or where the command was stored?


More people might move over to Linux if package were easier to install 
on Ubuntu, Mint, and others.  We all got spoiled on doing a double-click 
on the install file [.exe or .msi] and it will place the package icon in 
the menu system [Start] and place a launch icon on the desktop for ease 
of use.  Yes, we got spoiled, but it was easier.  I do not know how to 
add the Canon Scan Gear package to the Ubuntu Applications menu.  Wish I 
did.





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

2013-02-11 Thread Dennis E. Hamilton

There's also the ever-popular testing for an exact floating-point value
[;).

The OP mentions there being an *exception* loop, so it sounds like LO is
throwing a script error exception message and somehow there is no way out of
it.  

It looks like two things are needed:

 1. The complete, exact exception message about what is wrong.

 2. Opening the document with macros disabled (if that is possible when
conversion from .xls is happening) and extracting the resulting script.

(An alternative is to open the document in Excel, which should allow macro
disabling, and extract the original VBA there.)

Speculating further, it may well be that the VBA has a dependency that can't
be resolved on the users system from LO.  Either way, the script
error/failure behavior of LO needs to be looked into.

 - Dennis

-Original Message-
From: Jay Lozier [mailto:jsloz...@gmail.com] 
Sent: Monday, February 11, 2013 10:15
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] MS Excel file macros cause infinite loop of
errors

On 02/11/2013 12:52 PM, Todd E. Moore wrote:
 Trying to determine where
best to request help.A file sent to me includes VB macros created
in MS Excel.The
macro handler in LibreOffice (both 3.6 and 4.0) end up in an
exception loop which cannot be stopped unless I kill the process
from the system command line.Is there a specific way to address the
Subject line or a different
forum/mailing list I should use for requesting help?I wanted to
make sure I send to the correct place before
cluttering up folks' Inbox with a hefty file.
Todd

Either upload the file to Nabble or post the file some and provide a link.

I am not expert on macros but infinite loops are caused by a serious 
logic error - not providing a loop exit condition that tests correctly. 
I would expect the problem to in a WHILE/DO loop where there most be an 
exit condition that terminates the loop.

For example

i = 10
While i   1 do
 loop body
 i = i + 1

This above will always test TRUE and never exit. I have explicitly shown 
i incrementing.

But the following will exit because the loop condition will eventually 
evaluate to false:

i = 10
While i   1000 do
 loop body
 i = i + 1

Another error is for the above examples is to forget to increment i

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

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

2013-02-11 Thread todd.e.moore

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

--
View this message in context:
http://nabble.documentfoundation.org/MS-Excel-file-macros-cause-infinite-loop-of-errors-tp4036471p4036499.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Installing the Deb

Hi :)
But that is kinda one of the points i was making earlier.  The package manager 
usually does all the installing and maintenance of programs for you.  Heck, 
mostly there are plenty enough programs to do anything you might want right 
from the get go.  It's only when we want to be awkward and try weird things 
that it can get tricky and that is true of any OS, including Windows.  

This thread was not about your cannon printer.  Perhaps start a new thread 
about that as i have a few ideas that would be very off-topic in this thread.   
 
Regards from
Tom :)  







 From: webmaster-Kracked_P_P webmas...@krackedpress.com
To: users@global.libreoffice.org 
Sent: Monday, 11 February 2013, 19:04
Subject: Re: [libreoffice-users] Re: Installing the Deb
 
On 02/11/2013 01:43 PM, Marc Paré wrote:
 Le 2013-02-11 12:50, Don C. Myers a écrit :
 Hi All,
 
 A simple copy and paste works really well!! No typing necessary.
 Just make sure you have the file saved as a .txt that you open with GEdit.
 
 When I was new to Linux (Ubuntu) and didn't understand anything about
 what the system was really doing or about the file structure, OpenOffice
 was updated, and it wasn't going to be included for Ubuntu users until
 the next update, which was three or 4 months down the road. I ran across
 this method as a way to update my OpenOffice without waiting. The same
 thing took place with the next OpenOffice release. Again I found the
 updated instructions on the Internet. I still use this as it is easy to
 update computers. I've installed Ubuntu on about 23 or so. It is also
 easy for a new person to Ubuntu since they don't have to understand
 changing directories, etc. Simple extract the download to the desktop,
 and then copy and paste the three commands into the terminal.
 
 Don
 
 
 This I also agree with as well. If the scripts fit for everyone. However, 
 there is no sense making installing LibreOffice (the downloaded files) sound 
 so complicated for Linux. You don't really need to know much about 
 installing .deb's or .rpm's other than to right-click and the files and 
 picking the right choices. That's all.
 
 In fact, if you are just installing one .deb or .rpm, on most systems, you 
 just have to double-click on the .deb or .rpm file and it will call up the 
 distro's installer. It's just that simple. Just like it is done on Windows.
 
 Cheers,
 
 Marc

The only reason you cannot double click any of the .deb files in the install's 
DEBS folder is the fact that you need to make sure they are all run due to the 
file dependency issues.  They have to be run in a certain order, sort of.

It would be nice to have a double-click script that could be run that way that 
will run all of the .deb file in the folder, but it is not as easy as that, or 
that single double-clicking file/script might have been created by now.

So far, needing the terminal to install packages [not all] is a problem for 
some users who want to switch from Windows.  Also, sometimes the 
double-clicked package installs do not even make a menu or desktop launcher 
icon, so you have to go into the bin or other folder and create your own 
launcher icon.  I had to do that for the Canon Scanning package.  It was 
/usr/bin/scangearmp and how many new users to Linux would know how to create 
a launcher or where the command was stored?

More people might move over to Linux if package were easier to install on 
Ubuntu, Mint, and others.  We all got spoiled on doing a double-click on the 
install file [.exe or .msi] and it will place the package icon in the menu 
system [Start] and place a launch icon on the desktop for ease of use.  Yes, 
we got spoiled, but it was easier.  I do not know how to add the Canon Scan 
Gear package to the Ubuntu Applications menu.  Wish I did.



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

Hi :)
With most GnuLinux's LibreOffice is installed by default so you don't need to 
install anything unless you really want to make life tricky and go for the 
cutting-edge.  Some have OpenOffice instead but that is still fairly similar 
and can edit pretty much all the same file formats.  (LO added a few extra ones 
recently).  A few have Gnome Office or KOffice/Caligra but again they use the 
same formats.  

So, this thread is really only about getting the cutting-edge 4.0.0
Regards from
Tom :)  






 From: Marc Paré m...@marcpare.com
To: users@global.libreoffice.org 
Sent: Monday, 11 February 2013, 18:48
Subject: [libreoffice-users] Re: Installing the Deb
 
Le 2013-02-11 13:05, Dan Lewis a écrit :

 There are a variety of ways to install LO for Debian OS's. Some are
 harder than others, and some are easier.
 What no one has mentioned is the use of script files. They will do much
 of the work for you. Planning how to install the Deb files is important.
 If you have LO from your OS, you need to use Synaptic (Step#1 mentioned
 above.) But this is the only time you need to do this. dpkg (installs
 the Deb files) writes the new files over the existing files. There is no
 need to remove them.
 Extract the installation folder and always place it in the same
 location. (This is important for the contents of the script file.)
 
 Example of the script file:
 #!/bin/sh
 cd /home/dan/Downloads/LO/LibO_3.6.5.2_Linux_x86-64_install-deb_en-US/DEBS/
 sudo dpkg -i *.deb
 cd desktop-integration
 sudo dpkg -i *.deb
 This looks like a lot of typing, but it is not really. Besides much of
 it is used over and over again. The third line is the longest. cd
 /home/dan/Downloads/LO/ is the location for the installation folder
 that you extracted. LibO_3.6.5.2_Linux_x86-64_install-deb_en-US is the
 name of that folder.
 I do not like to type long names like the name of the installation
 folder, so I look for a short cut. I use the file browser (Nautilus) to
 go to this folder's location, I can right click on the folder and select
 Properties. There at the top is the folder's name highlighted. Ctrl+C
 copies the name, and I paste it into the third line. I also erase the
 name of the previous folder. Another method: erase the number of the
 previous LO version and type in the new number. In this case, replace
 3.6.5.2 with 4.0.0.3.
 What this does: installs the Deb files and desktop integration items.
 The script file needs to be executable when it was first created. To do
 this right click the script file, select Properties - Permissions.
 Click the box labelled Allow executing the file as a program.
 The location of the script file might be important also.
 So actual steps to install 4.0.0.3:
 1) Download the file to /home/dan/Downloads/LO/.
 2) Extract the downloaded file to the same location.
 3) Update the third line of the script file using either method using
 gedit.
 4) In the file browser, double click the script file.
 5) Click the button Run in Terminal.
 6) Type your password.
 7) Close the terminal.
 The first two steps involve only clicks. Step 3 can involve only using
 the mouse, or typing 4 digits and 3 periods. Only step 6 involves typing
 with the rest done by mouse clicks.
 
 --Dan
 

Yes, but a newcomer to Linux who wished to install LibreOffice on her/his 
distro would not know this, and hopefully, would just do what most people 
would do and unpack the compressed files and double-click the .deb's or .rpm's 
... or select all of them - right-click and choose to open with the file 
manager.

I don't believe we are doing our users any service by suggesting all of these 
convoluted ways of installing. Let's promote the easy and straight forward. it 
really simple.

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




-- 
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] Making local help copy?

Hi :)
I have forwarded your question to the global translators list in the hope that 
they can help you.  I really think you need to contact the dev's lists if you 
want to find out how to build LO from scratch.  It is quite far outside of the 
type of thing the Users List can help with but it was good to ask here first so 
we can try to signpost you to the best places to get the answer from.  

Apols and regards from
Tom :)  






 From: Kolbjørn Stuestøl kolbjo...@stuestoel.no
To: LibreOffice brukargruppe users@global.libreoffice.org 
Sent: Monday, 11 February 2013, 17:42
Subject: [libreoffice-users] Making local help copy?
 
Is there a (simple) way to build, assemble, or make a local copy of the .po 
help files?

I am translating the LO Pootle po files and it would help me a lot if I was 
able to control my work from time to time instead of waiting weeks or months.
By the way, how often is the build-in help system updated?

I am also translating GIMP which uses HTML for its help files. The clever 
developers of the documentation team has created a little program creating the 
help files from the command make html-xx where xx is the language code. So 
simple. (Yes, I know LO is using a quite different help system).

Kolbjoern


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

Hi :)
That went really wrong for me when i tried with 4.0.0 but opened fine in 
'OpenOffice.org 3.2'.  Hmmm the OOo 3.2 says it was made by RedHat based on OOo 
from Sun so that probably really means it was Go-oo rather than OOo and Go-oo 
merged into LibreOffice really early on.  I'm currently on a really ancient 
version of Fedora rather than my usual Ubuntu.  RedHat use Fedora to test out 
new ideas without risking the stability of their main OS. It's quite good fun 
to use sometimes :)  Many people find it stable enough to run as their main OS. 
 Anyway, point is that the file opens in 3.2 and that probably means 
LibreOffice 3.2
Regards from
Tom :)  






 From: todd.e.moore todd.e.mo...@gmail.com
To: users@global.libreoffice.org 
Sent: Monday, 11 February 2013, 19:07
Subject: [libreoffice-users] Re: MS Excel file macros cause infinite loop of 
errors
 
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  



--
View this message in context: 
http://nabble.documentfoundation.org/MS-Excel-file-macros-cause-infinite-loop-of-errors-tp4036471p4036499.html
Sent from the Users mailing list archive at Nabble.com.
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted




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

[libreoffice-users] Can someone verify this writer bug?

2013-02-11 Thread Joel Madero

Hi All,

Can someone take a look at this one, try to reproduce, if you can
reproduce, mind leaving a comment on it?

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

60154 https://bugs.freedesktop.org/show_bug.cgi?id=60154LibreOffWriter
libreoffice-b...@lists.free...unco---Option Display of Fields: Hidden
Paragraphs changes vertical alignment in
tableshttps://bugs.freedesktop.org/show_bug.cgi?id=60154
2013-02-01


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] Can someone verify this writer bug?

Hi :)
Just tried in Fedora 13 (ancient i know) using 'OpenOffice 3.2 but i think 
it's really LibreOffice.  It's really confusing.  The version number doesn't 
make any sense!  

One time when i tried to open it i saw the word test written at both the top 
and the bottom of the box.  Pressing enter obscured the top one.  Another time 
i tried seeing if the bottom one was just invisible so tried changing it's font 
colour.  It did seem to be there but changing the bottom ones font to black 
made the top one vanish!  All very weird
Regards from
Tom :)  







 From: Joel Madero jmadero@gmail.com
To: users@global.libreoffice.org users@global.libreoffice.org 
Sent: Monday, 11 February 2013, 21:15
Subject: [libreoffice-users] Can someone verify this writer bug?
 
Hi All,

Can someone take a look at this one, try to reproduce, if you can
reproduce, mind leaving a comment on it?

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

60154 https://bugs.freedesktop.org/show_bug.cgi?id=60154LibreOffWriter
libreoffice-b...@lists.free...unco---Option Display of Fields: Hidden
Paragraphs changes vertical alignment in
tableshttps://bugs.freedesktop.org/show_bug.cgi?id=60154
2013-02-01


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




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

2013-02-11 Thread todd.e.moore

I found v3.3 in the OO archives download area.  It opens the file, but none
of the macros work.  Bummer.

With this particular file, I run into problems even with MS Office 2003 and
we're loathe to invest the money into upgrading licenses because of a single
file.  Unfortunately, it's looking more and more likely that will be the
route we'll end up travelling.

Thanks for the assist.  Maybe developers can reference this file when they
next revisit the macro engine.



--
View this message in context: 
http://nabble.documentfoundation.org/MS-Excel-file-macros-cause-infinite-loop-of-errors-tp4036471p4036526.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] Re: Installing the Deb


On 02/11/2013 01:48 PM, Marc Paré wrote:

Le 2013-02-11 13:05, Dan Lewis a écrit :


There are a variety of ways to install LO for Debian OS's. Some are
harder than others, and some are easier.
What no one has mentioned is the use of script files. They will do much
of the work for you. Planning how to install the Deb files is important.
If you have LO from your OS, you need to use Synaptic (Step#1 mentioned
above.) But this is the only time you need to do this. dpkg (installs
the Deb files) writes the new files over the existing files. There is no
need to remove them.
Extract the installation folder and always place it in the same
location. (This is important for the contents of the script file.)

Example of the script file:
#!/bin/sh
cd 
/home/dan/Downloads/LO/LibO_3.6.5.2_Linux_x86-64_install-deb_en-US/DEBS/

sudo dpkg -i *.deb
cd desktop-integration
sudo dpkg -i *.deb
This looks like a lot of typing, but it is not really. Besides much of
it is used over and over again. The third line is the longest. cd
/home/dan/Downloads/LO/ is the location for the installation folder
that you extracted. LibO_3.6.5.2_Linux_x86-64_install-deb_en-US is the
name of that folder.
I do not like to type long names like the name of the installation
folder, so I look for a short cut. I use the file browser (Nautilus) to
go to this folder's location, I can right click on the folder and select
Properties. There at the top is the folder's name highlighted. Ctrl+C
copies the name, and I paste it into the third line. I also erase the
name of the previous folder. Another method: erase the number of the
previous LO version and type in the new number. In this case, replace
3.6.5.2 with 4.0.0.3.
What this does: installs the Deb files and desktop integration items.
The script file needs to be executable when it was first created. To do
this right click the script file, select Properties - Permissions.
Click the box labelled Allow executing the file as a program.
The location of the script file might be important also.
So actual steps to install 4.0.0.3:
1) Download the file to /home/dan/Downloads/LO/.
2) Extract the downloaded file to the same location.
3) Update the third line of the script file using either method using
gedit.
4) In the file browser, double click the script file.
5) Click the button Run in Terminal.
6) Type your password.
7) Close the terminal.
The first two steps involve only clicks. Step 3 can involve only using
the mouse, or typing 4 digits and 3 periods. Only step 6 involves typing
with the rest done by mouse clicks.

--Dan



Yes, but a newcomer to Linux who wished to install LibreOffice on 
her/his distro would not know this, and hopefully, would just do what 
most people would do and unpack the compressed files and double-click 
the .deb's or .rpm's ... or select all of them - right-click and 
choose to open with the file manager.


I don't believe we are doing our users any service by suggesting all 
of these convoluted ways of installing. Let's promote the easy and 
straight forward. it really simple.


Cheers,

Marc
  All well and good, but the simple way that you suggest will 
present problems for the newcomer on Debian OS's. The 
desktop-integration file will not install if the LO that came with the 
OS install CD remains: it must be removed. Without doing this, you can 
not right click on a file and select a LO version to open the file.
 We used to use Synaptic to remove an installed program or install 
a program from the Ubuntu repositories. A few years ago Ubuntu no longer 
included this package manager when it went to using the Unity desktop. 
(Synaptic was a part of the gnome desktop package.) In its place, Ubuntu 
introduced the Ubuntu Software Center. It appears that programs can also 
be removed using it, but only if they came from the Ubuntu repositories. 
Right now I have LO 3.6.5.2 and 4.0.0.3 installed from the website. 
Neither of these are listed in Ubuntu Software Center, so it can not be 
used to remove them.
 I just checked out your first paragraph. What you wrote does not 
work for installing LO in Ubuntu. (It probably will not work for any of 
the Debian OS's, but I only have Ubuntu and can not check the others.) 
The only thing that works is to think about the specific steps that must 
be followed and determine how to do them either on the command line or 
using a script. You may want to call these convoluted, but at least they 
work.


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

[libreoffice-users] Problem with comments

2013-02-11 Thread John R. Sowden

For the last several versions of LO, and I believe back to OO, I am 
having a data entry/display issue re: comments.  On a calc sheet with 
frozen cells, if I am putting a comment in a cell at the top of the 
unfrozen area, I have a problem with data entry.  It seems that the 
mouse cursor must be in the comment area, even though I have clicked in 
that area and the text cursor is in that area.  And i cannot always 
enter data.  after I enter about 3 characters, the cursor does not 
increment to the next space, so no further characters can be entered.  
If I back up then retry, it usually works.  If I attempt to display the 
comment, it won't display above/onto the frozen area.


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

 Not quite right, Tom. This is about installing LibreOffice on 
Ubuntu that is downloaded from
http://www.libreoffice.org/download/ or installing Apache OpenOffice (or 
earlier versions of OO.o) downloading from its website. It is also about 
including either of these programs present in the Menu or Dash.


--Dan

On 02/11/2013 03:41 PM, Tom Davies wrote:

Hi :)
With most GnuLinux's LibreOffice is installed by default so you don't need to 
install anything unless you really want to make life tricky and go for the 
cutting-edge.  Some have OpenOffice instead but that is still fairly similar and 
can edit pretty much all the same file formats.  (LO added a few extra ones 
recently).  A few have Gnome Office or KOffice/Caligra but again they use the same 
formats.

So, this thread is really only about getting the cutting-edge 4.0.0
Regards from
Tom :)







From: Marc Paré m...@marcpare.com
To: users@global.libreoffice.org
Sent: Monday, 11 February 2013, 18:48
Subject: [libreoffice-users] Re: Installing the Deb

Le 2013-02-11 13:05, Dan Lewis a écrit :


There are a variety of ways to install LO for Debian OS's. Some are
harder than others, and some are easier.
What no one has mentioned is the use of script files. They will do much
of the work for you. Planning how to install the Deb files is important.
If you have LO from your OS, you need to use Synaptic (Step#1 mentioned
above.) But this is the only time you need to do this. dpkg (installs
the Deb files) writes the new files over the existing files. There is no
need to remove them.
Extract the installation folder and always place it in the same
location. (This is important for the contents of the script file.)

Example of the script file:
#!/bin/sh
cd /home/dan/Downloads/LO/LibO_3.6.5.2_Linux_x86-64_install-deb_en-US/DEBS/
sudo dpkg -i *.deb
cd desktop-integration
sudo dpkg -i *.deb
This looks like a lot of typing, but it is not really. Besides much of
it is used over and over again. The third line is the longest. cd
/home/dan/Downloads/LO/ is the location for the installation folder
that you extracted. LibO_3.6.5.2_Linux_x86-64_install-deb_en-US is the
name of that folder.
I do not like to type long names like the name of the installation
folder, so I look for a short cut. I use the file browser (Nautilus) to
go to this folder's location, I can right click on the folder and select
Properties. There at the top is the folder's name highlighted. Ctrl+C
copies the name, and I paste it into the third line. I also erase the
name of the previous folder. Another method: erase the number of the
previous LO version and type in the new number. In this case, replace
3.6.5.2 with 4.0.0.3.
What this does: installs the Deb files and desktop integration items.
The script file needs to be executable when it was first created. To do
this right click the script file, select Properties - Permissions.
Click the box labelled Allow executing the file as a program.
The location of the script file might be important also.
So actual steps to install 4.0.0.3:
1) Download the file to /home/dan/Downloads/LO/.
2) Extract the downloaded file to the same location.
3) Update the third line of the script file using either method using
gedit.
4) In the file browser, double click the script file.
5) Click the button Run in Terminal.
6) Type your password.
7) Close the terminal.
The first two steps involve only clicks. Step 3 can involve only using
the mouse, or typing 4 digits and 3 periods. Only step 6 involves typing
with the rest done by mouse clicks.

--Dan


Yes, but a newcomer to Linux who wished to install LibreOffice on her/his 
distro would not know this, and hopefully, would just do what most people would 
do and unpack the compressed files and double-click the .deb's or .rpm's ... or 
select all of them - right-click and choose to open with the file manager.

I don't believe we are doing our users any service by suggesting all of these 
convoluted ways of installing. Let's promote the easy and straight forward. it 
really simple.

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


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

Re: [libreoffice-users] Re: LO 4 documentation

2013-02-11 Thread Caesar

On Mon, 11 Feb 2013 11:58:45 -0500, Marc Paré m...@marcpare.com
wrote Re [libreoffice-users] Re: LO 4 documentation:

Hi Caesar

Le 2013-02-11 06:54, Tom Davies a écrit :
 Hi :)
 You can get completed chapters in advance from
 https://wiki.documentfoundation.org/Documentation/Publications

 Errr, that page also has old archived versions.  Normally the guides 
 wouldn't have come out until around the 4.0.4 so to see the Getting Started 
 Guide is almost complete already is quite amazing!
 Regards from
 Tom :)


There is a way to get them quicker. You could join the docs team and 
help complete the chapters that you are interested in. That way, you 
know that they will come out quicker and the chapters that you want 
completed  are the ones that you care about. I don't think you will hear 
anyone complaining about you wanting to work only on the chapters that 
you want to work on.

Join up and help! Who knows, you may have so much fun that you will want 
to help finish another chapter that some other user hopes to have come 
out soon too! :-)

Cheers,

Marc

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.

-- 
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] Making local help copy?

2013-02-11 Thread Kolbjørn Stuestøl


Den 11.02.2013 21:50, skreiv Tom Davies:

Hi :)
I have forwarded your question to the global translators list in the 
hope that they can help you.  I really think you need to contact the 
dev's lists if you want to find out how to build LO from scratch.  It 
is quite far outside of the type of thing the Users List can help with 
but it was good to ask here first so we can try to signpost you to the 
best places to get the answer from.

Apols and regards from
Tom :)
Thank you, Tom. It looks like a a great job to build it but I can always 
hope there is a clever way doing it. I am not a programmer, just a 
translator.

Kolbjoern




*From:* Kolbjørn Stuestøl kolbjo...@stuestoel.no
*To:* LibreOffice brukargruppe users@global.libreoffice.org
*Sent:* Monday, 11 February 2013, 17:42
*Subject:* [libreoffice-users] Making local help copy?

Is there a (simple) way to build, assemble, or make a local copy
of the .po help files?

I am translating the LO Pootle po files and it would help me a lot
if I was able to control my work from time to time instead of
waiting weeks or months.
By the way, how often is the build-in help system updated?

I am also translating GIMP which uses HTML for its help files. The
clever developers of the documentation team has created a little
program creating the help files from the command make html-xx
where xx is the language code. So simple. (Yes, I know LO is using
a quite different help system).

Kolbjoern




--
Kolbjørn Stuestøl, Stuestøl, 4580 Lyngdal
Telefon: (47) 38 34 78 62,  (47) 917 81 125
Stuestøl heimesider: http://www.stuestoel.no
Sjå også
Lyngdal hagelag: http://www.stuestoel.no/hagelag/hagelag.php
Mandal og Lister pyntegrøntlag: http://www.mlpynt.no
GIMP på norsk: http://www.gimp.no


--
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-11 Thread Uwe Brauer


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

`
On 02/11/2013 09:18 AM, Uwe Brauer wrote:

Uwe Brauer
 How do you define an intrinsic database? I do not understand
 the term.

Well in my understanding there are two possibilities, 

-  either Base can connect to an external database such as mysql via
   a number of drivers or

-  it uses a database it ships (I think it is based in
   hsql). Because of a lack of a word I denoted this as intrinsic.

 Primary-foreign key pairs are created when a table is
normalized. (There several levels of normalized tables.) These pairs
are based upon the relationships between the fields of the original
table.
 So, you probably should put all the fields of the two tables into
a single table with the exception of any fields that belong to both
tables. For example the single table contains only one primary key
(ID) and one field named Notes. Then look for any fields (other
than ID) that determine the values of other fields. (In other words,
begin to normalize the table.) Without knowing all of the fields that
you are using, it would be difficult to know what fields these might
be.
 FYI, very seldom will two tables have a 1:1 relationship (linking
the primary keys of the two tables). Very likely, yours doesn't
either. Most often, these relationships involve a primary key of one
table and a foreign key of the other.


I am not entirely sure I understand: I set up a new base, no the primary
keys are not any existing field of the table (autovalue is On)


My tables are the following (they are just toy models in order to
understand the relation ship concept)

Task:
Name Type
Id   (generated by OO as a primary key)
Task Id Integer
Description Memo Longchar
Notes Memo Longchar


Authors 
Name Type
Id (generated by OO as a primary key)
Author Id Integer 
FirstName Memo Longchar
Nationality Notes Memo Longchar

Now I try to make a relation between the two tables, and in the GUI I
select the field Task Id and Author id in the other table, since both
fields have the same type.

I receive  the following error:


SQL Status: 23000
Error code: -177

Integrity constraint violation - no parent 1, table: Authors in
statement [ALTER TABLE Authors ADD  FOREIGN KEY (AuthorID)
REFERENCES Tasks (ID)] 

Now the gui allow me to add more fields so I add both primary keys, gain
an error:
SQL Status: S0011
Error code: -170

Primary or unique constraint required on main table: Tasks in
statement [ALTER TABLE Authors ADD FOREIGN KEY (AuthorID,ID)
REFERENCES Tasks (TaskID,ID)]

The only one which works, using the GUI is between the primaries keys!!!

Did you try it out your self and you are able to set more relations
between the tables?

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

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-11 Thread Uwe Brauer


 Alexander == Alexander Thurgood alex.thurg...@gmail.com writes:

Le 11/02/13 15:18, Uwe Brauer a écrit :
Hi Uwe,

Now I want to edit the relation and I am offered the possibility to add
more fields. So I select the notes file in either table but I receive
the following error.

Primary or unique constraint required on main table.  Accounts
in statement [ALTER TABLE Tasks ADD FOREIGN KEY
(TaskId,Notes) REFERENCE Accounts(AccountI,Notes)]

I am puzzled, in the intrinsic database only relations between
primary keys are possible?? Is this a property of the intrinsic
database, or is it a bug? I am thinking of submitting a bug
report.


The following possibilities occur to me :

(a) you might need to drop your previously configured constraint
before you can set up a new one via the GUI. From what I recall,
this might only be possible manually, i.e. by issuing a SQL command
(menu Tools  SQL) to DROP the CONSTRAINT from the tables, then
shutting down the db file, closing LO completely and re-opening.

(b) you might not be able to set combined constraints on more than one
field in both tables simultaneously via the GUI - again you may
find that you have to do this manually (although it may actually
turn out to be a limitation of hsqldb 1.8, I haven't checked)

This is my impression. Even when I generate for the first time a
relation ship via the GUI, I can only have the primary keys, if I put
more field in the relation it fails. 

And if I just set it up for the primary keys and later edit, same
result.

I think it is time for a bug report.

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


Hi Tim,

Le 2013-02-11 14:04, webmaster-Kracked_P_P a écrit :

So far, needing the terminal to install packages [not all] is a problem
for some users who want to switch from Windows.  Also, sometimes the
double-clicked package installs do not even make a menu or desktop
launcher icon, so you have to go into the bin or other folder and
create your own launcher icon.  I had to do that for the Canon Scanning
package.  It was /usr/bin/scangearmp and how many new users to Linux
would know how to create a launcher or where the command was stored?


Not sure about the other deb software, but we do supply this in our 
packages, it's in the main packagage-desktop integration 
-libreoffice4.0-freedesktop-menus-4.0.0-103.noarch. I am not sure if 
the Ubuntu's Unity adheres to the standard, but Gnome and KDE do.


As for getting it on your desktop, grab it and drop on your desktop, you 
normally get prompted if you want a copy, link.


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

[libreoffice-users] Re: Installing the Deb


Le 2013-02-11 17:01, Dan Lewis a écrit :


All well and good, but the simple way that you suggest will present
problems for the newcomer on Debian OS's. The desktop-integration file
will not install if the LO that came with the OS install CD remains: it
must be removed. Without doing this, you can not right click on a file
and select a LO version to open the file.



We used to use Synaptic to remove an installed program or install a
program from the Ubuntu repositories. A few years ago Ubuntu no longer
included this package manager when it went to using the Unity desktop.
(Synaptic was a part of the gnome desktop package.) In its place, Ubuntu
introduced the Ubuntu Software Center. It appears that programs can also
be removed using it, but only if they came from the Ubuntu repositories.
Right now I have LO 3.6.5.2 and 4.0.0.3 installed from the website.
Neither of these are listed in Ubuntu Software Center, so it can not be
used to remove them.



I just checked out your first paragraph. What you wrote does not work
for installing LO in Ubuntu. (It probably will not work for any of the
Debian OS's, but I only have Ubuntu and can not check the others.) The
only thing that works is to think about the specific steps that must be
followed and determine how to do them either on the command line or
using a script. You may want to call these convoluted, but at least they
work.

--Dan



Thanks for the information Dan. I will install Ubuntu on a spare box and 
test these out. I for one am for simplifying the notes on the .rpm 
section and adding a more simplified intallation routine of the 4 steps 
which do work for users who install the most used default managers as 
Gnome or KDE managers.


We should also try to find a visual installation routine for our Ubuntu 
users. The vast majority of users are just interested in using the 
software. Is some wish to install the latest and the bleeding edge 
versions, we need to make it an easy install.


We are looking for more contributors in all of our teams and especially 
QA. IMO, we should try to get our betas/rc's into the hands of users 
interested in QA who actually use LibreOffice in a productive way. The 
installation barrier should not become such a burden that such users 
would cringe at the very thought of installing these pre-release 
versions. When doing QA, users are often installing newer version of 
LibreOffice in a very short order of time.


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


On 02/11/2013 05:59 PM, Marc Paré wrote:

Hi Tim,

Le 2013-02-11 14:04, webmaster-Kracked_P_P a écrit :

So far, needing the terminal to install packages [not all] is a problem
for some users who want to switch from Windows.  Also, sometimes the
double-clicked package installs do not even make a menu or desktop
launcher icon, so you have to go into the bin or other folder and
create your own launcher icon.  I had to do that for the Canon Scanning
package.  It was /usr/bin/scangearmp and how many new users to Linux
would know how to create a launcher or where the command was stored?


Not sure about the other deb software, but we do supply this in our 
packages, it's in the main packagage-desktop integration 
-libreoffice4.0-freedesktop-menus-4.0.0-103.noarch. I am not sure if 
the Ubuntu's Unity adheres to the standard, but Gnome and KDE do.


As for getting it on your desktop, grab it and drop on your desktop, 
you normally get prompted if you want a copy, link.


Cheers,

Marc


The one that is in Ubuntu is named - 
libreoffice4.0-debian-menus_4.0.0-103_all.deb


This is the menu guide I think for Debian desktop-integration.

?package(libreoffice-writer):needs=X11 section=Apps/Editors\
  title=LibreOffice 4.0 Writer command=libreoffice4.0 -writer\
  hints=Word Processors\
  kderemove=y\
icon=/usr/share/icons/hicolor/32x32/apps/libreoffice4.0-writer.png\
icon16x16=/usr/share/icons/hicolor/16x16/apps/libreoffice4.0-writer.png


This is for the RPM version you have.  There are 3 different ones in the 
RPM desktop-integration package.


?package(libreoffice4.0-writer): needs=x11 
section=Office/Wordprocessors icon=libreoffice4.0-writer.png 
title=LibreOffice 4.0 Writer longtitle=LibreOffice 4.0 Word 
Processing Component command=libreoffice4.0 -writer 
mimetypes=application/vnd.oasis.opendocument.text,application/vnd.oasis.opendocument.text-template,application/vnd.oasis.opendocument.text-web,application/vnd.oasis.opendocument.text-master,application/vnd.sun.xml.writer,application/vnd.sun.xml.writer.template,application/vnd.sun.xml.writer.global,application/vnd.stardivision.writer,application/msword,application/vnd.ms-word,application/x-doc,application/rtf 
kde_opt=InitialPreference=100 startup_notify=true









The problem is not getting it on my desktop or panel, but to get a 
listing in the Applications menu when the package does not list the 
package in say Applications/Office where it should be listed, but 
not.  I know how to make a launcher icon on the desktop for my Canon 
Scanner package, but not how to get it in the /Office menu or the 
/Graphics menu where it should belong.  The Canon scanning system will 
not work with XSane, like my Epson scanner does [since I went to Ubuntu 
12.04/12.10].





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

Hi :)
Actually the Docs Team always needs new people that don't already know how to 
do much in order to help proof-read chapters and make sure they make sense to 
newcomers.  Unfortunately every time someone does join they quickly become 
quite adept with LibreOffice once they have worked so thoroughly through just a 
few chapters.  

That's not to say you should join but just to let people here know they don't 
need to be shy about lacking knowledge because even that can be a useful asset. 
 For this particular thread the most important bit was the link to the wiki imo.
Good luck and regards from
Tom :)  






 From: Caesar cae...@hiwaay.net
To: Libre Office List Server users@global.libreoffice.org 
Sent: Monday, 11 February 2013, 22:17
Subject: Re: [libreoffice-users] Re: LO 4 documentation
 
On Mon, 11 Feb 2013 11:58:45 -0500, Marc Paré m...@marcpare.com
wrote Re [libreoffice-users] Re: LO 4 documentation:

Hi Caesar

Le 2013-02-11 06:54, Tom Davies a écrit :
 Hi :)
 You can get completed chapters in advance from
 https://wiki.documentfoundation.org/Documentation/Publications

 Errr, that page also has old archived versions.  Normally the guides 
 wouldn't have come out until around the 4.0.4 so to see the Getting Started 
 Guide is almost complete already is quite amazing!
 Regards from
 Tom :)


There is a way to get them quicker. You could join the docs team and 
help complete the chapters that you are interested in. That way, you 
know that they will come out quicker and the chapters that you want 
completed  are the ones that you care about. I don't think you will hear 
anyone complaining about you wanting to work only on the chapters that 
you want to work on.

Join up and help! Who knows, you may have so much fun that you will want 
to help finish another chapter that some other user hopes to have come 
out soon too! :-)

Cheers,

Marc

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.

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


On 02/11/2013 06:14 PM, Marc Paré wrote:

Le 2013-02-11 17:01, Dan Lewis a écrit :


All well and good, but the simple way that you suggest will present
problems for the newcomer on Debian OS's. The desktop-integration file
will not install if the LO that came with the OS install CD remains: it
must be removed. Without doing this, you can not right click on a file
and select a LO version to open the file.



We used to use Synaptic to remove an installed program or install a
program from the Ubuntu repositories. A few years ago Ubuntu no longer
included this package manager when it went to using the Unity desktop.
(Synaptic was a part of the gnome desktop package.) In its place, Ubuntu
introduced the Ubuntu Software Center. It appears that programs can also
be removed using it, but only if they came from the Ubuntu repositories.
Right now I have LO 3.6.5.2 and 4.0.0.3 installed from the website.
Neither of these are listed in Ubuntu Software Center, so it can not be
used to remove them.



I just checked out your first paragraph. What you wrote does not work
for installing LO in Ubuntu. (It probably will not work for any of the
Debian OS's, but I only have Ubuntu and can not check the others.) The
only thing that works is to think about the specific steps that must be
followed and determine how to do them either on the command line or
using a script. You may want to call these convoluted, but at least they
work.

--Dan



Thanks for the information Dan. I will install Ubuntu on a spare box 
and test these out. I for one am for simplifying the notes on the .rpm 
section and adding a more simplified intallation routine of the 4 
steps which do work for users who install the most used default 
managers as Gnome or KDE managers.


We should also try to find a visual installation routine for our 
Ubuntu users. The vast majority of users are just interested in using 
the software. Is some wish to install the latest and the bleeding edge 
versions, we need to make it an easy install.


We are looking for more contributors in all of our teams and 
especially QA. IMO, we should try to get our betas/rc's into the hands 
of users interested in QA who actually use LibreOffice in a productive 
way. The installation barrier should not become such a burden that 
such users would cringe at the very thought of installing these 
pre-release versions. When doing QA, users are often installing newer 
version of LibreOffice in a very short order of time.


Cheers,

Marc





I think we need to make it as easy as possible for our users [ 
Windows/Mac/Linux ] to install the newest version of LO to replace the 
older ones.


I really think it is not Windows vs. Linux, but how we can make it easy 
for all users, no matter what OS they use.  MS has an installer build 
into the .msi package.  We need to do something like that for Linux.


HP has a package like sh hplip-3.11.3a.run that is run in the terminal 
that walks you through the install process for the Linux printing.


There are a lot of complex things going on, including a make option in 
there.  How easy would it be to create something like that?








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

Hi :)
Is it a file that everyone needs access to at their own desks?  Is it possible 
to just have 1 desktop with MSO on it and then people update the file from 
there?  

If the other organisation is not Oracle then they might well be willing to 
re-write the code or have it re-written or allow it to be re-written for 
improved security and to allow it to be used with Free Software.  A lot of 
people start off with both MS Office and LibreOffice/OpenOffice on their 
machines at the beginning of a migration or just to be able to deal with a 
wider variety of clients.  Perhaps the organisation that needs this spreadsheet 
filled in might be willing to install LibreOffice on their machines rather than 
forcing you to buy a lot of licenses for something you wouldn't otherwise need.

It seems you have some leverage there.  There are probably people on this list 
that wouldn't mind being paid a little to translate the macros and at far less 
than the cost of a lot of MSO licenses.  I'm no good with macros btw, jic you 
were wondering.    
Regards from
Tom :)  






 From: todd.e.moore todd.e.mo...@gmail.com
To: users@global.libreoffice.org 
Sent: Monday, 11 February 2013, 21:56
Subject: [libreoffice-users] Re: MS Excel file macros cause infinite loop of 
errors
 
I found v3.3 in the OO archives download area.  It opens the file, but none
of the macros work.  Bummer.

With this particular file, I run into problems even with MS Office 2003 and
we're loathe to invest the money into upgrading licenses because of a single
file.  Unfortunately, it's looking more and more likely that will be the
route we'll end up travelling.

Thanks for the assist.  Maybe developers can reference this file when they
next revisit the macro engine.



--
View this message in context: 
http://nabble.documentfoundation.org/MS-Excel-file-macros-cause-infinite-loop-of-errors-tp4036471p4036526.html
Sent from the Users mailing list archive at Nabble.com.

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




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

Re: Fwd: [libreoffice-users] Value and Date function in Macro

2013-02-11 Thread Joel Madero

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




-- 
*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] How can I create a certificate border?

2013-02-11 Thread Fabian Rodriguez


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Le 13-02-11 11:46 AM, webmaster-Kracked_P_P a ?crit :
 On 02/11/2013 10:22 AM, Fabian Rodriguez wrote:
 Hi

 Is there a way to create an elaborate border in LibreOffice/Draw? I'd
 like to create a certficate. I tried searching for freely-licensed
 templates for this and didn't find any.

 Thanks in advance for any help with this.

 F.


 Fabian

 Not finding certificate borders is weird. Last year I need some and
I found a lot.

 This one has a few template background images.
 http://all-free-download.com/free-vector/free-certificate-template.html

That one indicated:
All of the resources are gathered by users and public sources on the
internet.
Not all of the resources are allowed for commercial use please contact
the author for detail
If resources have violated your copyright, please through feedback to us
so that we can delete a timely manner to protect you!
Copyright ? 2012 www.all-free-download.com

There are TONS w/o any licensing information, that's the point.


 Some will require you to print to PDF file and then use Draw to import
it to create a JPG background image. But there are solutions.

 I also have found some in places like OpenClipart.org and other sites.
Sometimes there are listed under borders.


Hadn't thought of OpenClipArt, thanks!

Le 13-02-11 12:22 PM, Marc Par? a ?crit :
 Bonjour Fabian,

 Sure, there are some templates that you can use on the AOO website
templates[1]. You can download some of these and then either use them or
use them as a base to mod your own.

 If you wonder how to download them, do the following:
[...]

Thanks for the details.
 [1] http://templates.services.openoffice.org/en/search/node/certificate

It's still weird that such borders can't actually be *created* within
LibreOffice. I was certain this was possible.

Cheers,

F.


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

iEYEARECAAYFAlEZg2cACgkQfUcTXFrypNW8GQCguepe1e5F7IwS5rb0ugOcyAFr
jmEAn33+3piEris8MJ1yKFybawSEoNzz
=luFr
-END PGP SIGNATURE-


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

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

2013-02-11 Thread Jay Lozier

On 02/11/2013 04:56 PM, todd.e.moore wrote:

I found v3.3 in the OO archives download area. It opens the file, but none
of the macros work. Bummer.

With this particular file, I run into problems even with MS Office 2003 and
we're loathe to invest the money into upgrading licenses because of a single
file. Unfortunately, it's looking more and more likely that will be the
route we'll end up travelling.
It would not run correctly on MSO 2003? To me this implies is/are bug(s)
in the macro code. And if it is buggy code upgrading your license will
not help. Since the file is an *.xls file this implies the macro was
intended to run on Excel 2003 and possibly even 2000 as well as later
versions.

Thanks for the assist. Maybe developers can reference this file when they
next revisit the macro engine.

--
View this message in context:
http://nabble.documentfoundation.org/MS-Excel-file-macros-cause-infinite-loop-of-errors-tp4036471p4036526.html
Sent from the Users mailing list archive at Nabble.com.

I was able to look at the VBA code for the macro in LO 4.0 so if one
know the correct Basic dialect it could be (theoretically) converted but
I have no idea how easy or difficult this would be. Hopefully, one the
macro gurus can take a look at the code. On some of the code I did get a
syntax error but I am not sure if the error is generic (occurs in VBA
and LO Basic) or only specific to LO Basic.

I did not notice any documentation or comments that explained the code
in the section I was looking at (bangs head on desk). Also, I did not
see any copyright notice or license in the modules I looked at.

--
Jay Lozier
jsloz...@gmail.com

Re: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?


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

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

 `
 On 02/11/2013 09:18 AM, Uwe Brauer wrote:

 Uwe Brauer
  How do you define an intrinsic database? I do not understand
  the term.

Well in my understanding there are two possibilities,

 -  either Base can connect to an external database such as mysql via
a number of drivers or

 -  it uses a database it ships (I think it is based in
hsql). Because of a lack of a word I denoted this as intrinsic.

  Primary-foreign key pairs are created when a table is
 normalized. (There several levels of normalized tables.) These pairs
 are based upon the relationships between the fields of the original
 table.
  So, you probably should put all the fields of the two tables into
 a single table with the exception of any fields that belong to both
 tables. For example the single table contains only one primary key
 (ID) and one field named Notes. Then look for any fields (other
 than ID) that determine the values of other fields. (In other words,
 begin to normalize the table.) Without knowing all of the fields that
 you are using, it would be difficult to know what fields these might
 be.
  FYI, very seldom will two tables have a 1:1 relationship (linking
 the primary keys of the two tables). Very likely, yours doesn't
 either. Most often, these relationships involve a primary key of one
 table and a foreign key of the other.


I am not entirely sure I understand: I set up a new base, no the primary
keys are not any existing field of the table (autovalue is On)


My tables are the following (they are just toy models in order to
understand the relation ship concept)

Task:
Name Type
Id   (generated by OO as a primary key)
Task Id Integer
Description Memo Longchar
Notes Memo Longchar


Authors
Name Type
Id (generated by OO as a primary key)
Author Id Integer
FirstName Memo Longchar
Nationality Notes Memo Longchar

Now I try to make a relation between the two tables, and in the GUI I
select the field Task Id and Author id in the other table, since both
fields have the same type.

I receive  the following error:


SQL Status: 23000
Error code: -177

Integrity constraint violation - no parent 1, table: Authors in
statement [ALTER TABLE Authors ADD  FOREIGN KEY (AuthorID)
REFERENCES Tasks (ID)]

Now the gui allow me to add more fields so I add both primary keys, gain
an error:
SQL Status: S0011
Error code: -170

Primary or unique constraint required on main table: Tasks in
statement [ALTER TABLE Authors ADD FOREIGN KEY (AuthorID,ID)
REFERENCES Tasks (TaskID,ID)]

The only one which works, using the GUI is between the primaries keys!!!

Did you try it out your self and you are able to set more relations
between the tables?

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

Uwe
 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.)
 I am a little curious. Your email address implies you may live in 
Spain. 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. Tom might 
be able to tell you from where to download it on the LibreOffice wiki if 
that would help.
 As far as MySQL problems, I think I tried to modify fields in a 
table while using MySQL. They were not saved either.


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

[libreoffice-users] Re: [libreoffice-documentation] Uninstall

2013-02-11 Thread Tim Lloyd

I'll bounce this onto the users list for more exposure
- Original Message -
From: Bob Keeley
Sent: 02/12/13 10:04 AM
To: documentat...@global.libreoffice.org
Subject: [libreoffice-documentation] Uninstall

Just did an uninstall of 3.5 and checked my Programs Folder. Libreoffice leaves 
behind 40 files... Then looked at the 3.5 PDF Documentation and uninstall 
isn't even listed. Where are the Uninstall install instructions? -- Unsubscribe 
instructions: E-mail to documentation+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/documentation/ 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] Bug 60710 - EDITING: Cannot save particular untitled document containing comments



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

Re: [libreoffice-users] Can someone verify this writer bug?

2013-02-11 Thread Andrew Douglas Pitonyak


Tested and seen in 3.6.

On 02/11/2013 04:15 PM, Joel Madero wrote:

Hi All,

Can someone take a look at this one, try to reproduce, if you can
reproduce, mind leaving a comment on it?

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

60154 https://bugs.freedesktop.org/show_bug.cgi?id=60154LibreOffWriter
libreoffice-b...@lists.free...unco---Option Display of Fields: Hidden
Paragraphs changes vertical alignment in
tableshttps://bugs.freedesktop.org/show_bug.cgi?id=60154
2013-02-01


Best Regards,
Joel


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

2013-02-11 Thread Andrew Douglas Pitonyak



LO is not macro compatible with MS Office products. If it is a VBA macro 
meant for use with Excel, the macro is not expected to work with LO. In 
some trivial cases, it may just happen to work, but that is the 
exception (in my experience), not the rule.




On 02/11/2013 12:52 PM, Todd E. Moore wrote:

Trying to determine where
   best to request help.A file sent to me includes VB macros created in MS 
Excel.The
   macro handler in LibreOffice (both 3.6 and 4.0) end up in an
   exception loop which cannot be stopped unless I kill the process
   from the system command line.Is there a specific way to address the 
Subject line or a different
   forum/mailing list I should use for requesting help?I wanted to make 
sure I send to the correct place before
   cluttering up folks' Inbox with a hefty file.


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

2013-02-11 Thread e-letter

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?

-- 
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-11 Thread e-letter

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? 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] Find out a name of inserted image in Impress

2013-02-11 Thread e-letter

On 10/02/2013, v...@ukr.net v...@ukr.net wrote:

   So, I do not remember which slide contained which image or video. How
 can I find out the name of the inserted image or video file?


Use the navigator function. Select the option to view all shapes. In
future, give each inserted image a unique name.

-- 
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-11 Thread Alex Thurgood

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 ?

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.


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

2013-02-11 Thread culann

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

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