[libreoffice-users] How do I switch off auto html on Libre Office spreadsheets

2012-04-30 Thread Custfold
It is infuriating to have e-mail addresses on a spreadsheet, or other 
documents for that matter - automatically going into html format, so 
that every time you just touch a cell with an e-mail address you 
generate a blank e-mail to that address.


I managed to kill it with MS - how do I do this with Libre Office?

Dave

--
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 do I switch off auto html on Libre Office spreadsheets

2012-04-30 Thread Brian Barker

At 09:23 30/04/2012 +0100, Custfold wrote:
It is infuriating to have e-mail addresses on a spreadsheet, or 
other documents for that matter - automatically going into html 
format, so that every time you just touch a cell with an e-mail 
address you generate a blank e-mail to that address.  I managed to 
kill it with MS - how do I do this with Libre Office?


Remove the tick from Tools | AutoCorrect Options... | Options | URL 
Recognition.


I trust this helps.

Brian Barker


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



Re: [libreoffice-users] How do I switch off auto html on Libre Office spreadsheets

2012-04-30 Thread Tom Davies
Hi :)
Brilliant!!  Thanks :)  I had always assumed i was stuck with that behaviour!  
Now i just need to find how to do the equivalent on a stupid Access database!  
(or maybe just leave it so that it annoys everyone else to).  Fungames.
Regards from
Tom :)

--- On Mon, 30/4/12, Brian Barker b.m.bar...@btinternet.com wrote:

From: Brian Barker b.m.bar...@btinternet.com
Subject: Re: [libreoffice-users] How do I switch off auto html on Libre Office 
spreadsheets
To: users@global.libreoffice.org
Date: Monday, 30 April, 2012, 10:41

At 09:23 30/04/2012 +0100, Custfold wrote:
 It is infuriating to have e-mail addresses on a spreadsheet, or other 
 documents for that matter - automatically going into html format, so that 
 every time you just touch a cell with an e-mail address you generate a blank 
 e-mail to that address.  I managed to kill it with MS - how do I do this with 
 Libre Office?

Remove the tick from Tools | AutoCorrect Options... | Options | URL Recognition.

I trust this helps.

Brian Barker


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


-- 
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] Impress full screen question

2012-04-30 Thread Renaud (Ron) Olgiati
 I have created a presentation, and want to display as a slide show in full
 screen (projector) without the window border or title bar or meny bar
 showing.

 I suspect Impress can do it, since that is how it displays the .pps
 presentations I get by email; how do I get Impress to do this for MY
 presentation ?
 
Finally, the only way I found to display my presentation in full-screen, 
without any window border, title bat or menu bar is as follows:

Save the presentation as a .pps file

Boot up Windows,

Show .pps using (free) MS Powerpoint Viewer.

A bit sad it cannot be done with L.O. under Linux  ;-3(

Cheers,
 
Ron.
-- 
  Personne n'aime les missionnaires armés;
 et le premier conseil que donnent la nature et la prudence,
  c'est de les repousser comme des ennemis.
   -- Maximilien Robespierre

   -- http://www.olgiati-in-paraguay.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] Impress full screen question

2012-04-30 Thread Didier Spaier

To open a presentation in full screen in LO, I just hit F5 or choose Slideshow 
(Diaporama, in French) in the menu.

So where is the problem?

Didier


On 30/04/2012 15:59, Renaud (Ron) Olgiati wrote:

I have created a presentation, and want to display as a slide show in full
screen (projector) without the window border or title bar or meny bar
showing.



I suspect Impress can do it, since that is how it displays the .pps
presentations I get by email; how do I get Impress to do this for MY
presentation ?


Finally, the only way I found to display my presentation in full-screen,
without any window border, title bat or menu bar is as follows:

Save the presentation as a .pps file

Boot up Windows,

Show .pps using (free) MS Powerpoint Viewer.

A bit sad it cannot be done with L.O. under Linux  ;-3(

Cheers,

Ron.



--
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] Impress full screen question

2012-04-30 Thread Renaud (Ron) Olgiati
On Monday 30 Apr 2012 10:20 my mailbox was graced by a message from Didier 
Spaier who wrote:
 To open a presentation in full screen in LO, I just hit F5 or choose
 Slideshow (Diaporama, in French) in the menu.
 So where is the problem?

The problem is that it is not full screen: It still displays the borders, 
title bar and menu bar of the window.

There is the problem.
 
Cheers,
 
Ron.
-- 
Government's first duty is to protect the people, not run their lives.
  -- Ronald Reagan

   -- http://www.olgiati-in-paraguay.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] Impress full screen question

2012-04-30 Thread Didier Spaier

On 30/04/2012 17:21, Renaud (Ron) Olgiati wrote:

On Monday 30 Apr 2012 10:20 my mailbox was graced by a message from Didier
Spaier who wrote:

To open a presentation in full screen in LO, I just hit F5 or choose
Slideshow (Diaporama, in French) in the menu.
So where is the problem?


The problem is that it is not full screen: It still displays the borders,
title bar and menu bar of the window.

There is the problem.

Cheers,

Ron.

I use Impress extensively and do not encounter this problem with Slackware 
13.37, under Fluxbox or XFCE.

So my guess is that this in related to your desktop or windows manager.

So, could you please tell us what is your distribution, and the desktop or 
windows manager you use?

Cheers,

Didier




--
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] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread Tom Davies
Hi :)
The 3.4.6 seems to have had the least problems out of any of the releases so 
far.  All what problems in Xp?
Regards from
Tom :)


--- On Mon, 30/4/12, Ant a...@zimage.com wrote:

From: Ant a...@zimage.com
Subject: Re: [libreoffice-users] Unable to start my newly installed LibreOffice 
v3.5.2 programs.
To: users@global.libreoffice.org
Date: Monday, 30 April, 2012, 15:41

Wow, what is with all the problems with v3.4.6 in old Windows XP Pro. 
SP3? I am surprised the issues haven't been fixed with the latest v3.5.x 
versions for this long. :(


On Mon, Apr 30, 2012 at 10:32:56AM -0400, webmaster-Kracked_P_P wrote:
 
 Personally, for XP, I would start with LO 3.4.6.
 
 This is the most stable version of LO and I KNOW is works on XP,
 since that is what I am running on an old XP/pro laptop.
 
 Please try it.  Here is the English download page for 3.4.6.
 http://www.libreoffice.org/download/?type=win-x86〈=en-USversion=3.4.6 
 http://www.libreoffice.org/download/?type=win-x86〈=en-USversion=3.4.6
 
 Too many people are having problems with the 3.5.x line so for a
 first time user, I would stick with 3.4.6.
 
 
 http://www.libreoffice.org/download/?type=win-x86〈=en-USversion=3.4.6
 On 04/29/2012 08:54 PM, Ant wrote:
 On Mon, Apr 30, 2012 at 01:10:39AM +0100, Tom Davies wrote:
 Hi :)
 Please can you try renaming you User Profile
 http://wiki.documentfoundation.org/Documentation/UserProfile
 Nope. remember this is my first LibreOffice installation since I wanted
 to replace the outdated OpenOffice. I deleted C:\Documents and
 Settings\UserName\Application Data\LibreOffice\ and retried to get the
 same results.
 
 
 that seems to fix most weird problems.  Crashing might be something to
 do with an Extension/Add-on.  Java sometimes causes crashes so do you
 happen to know which version of java you have got installed? Regards
 I am using the latest Oracle Java (JRE) v6 update 31. :)
 
 
 --- On Mon, 30/4/12, Anta...@zimage.com  wrote:
 From: Anta...@zimage.com
 Subject: [libreoffice-users] Unable to start my newly installed LibreOffice 
 v3.5.2 programs.
 To: users@global.libreoffice.org
 Date: Monday, 30 April, 2012, 0:53
 
 Hello.
 
 I just uninstalled old OpenOffice (OO) v3.3.0 and then installed a new
 LibreOffice v3.5.2 into my old, updated Windows XP Pro. SP3 machine.
 However, none of its programs will start. I see the splash screen and
 then it (soffice.bin) exits. No errors I saw. What's the problem? OO was
 working fine right before I uninstalled it.
-- 
Quote of the Week: Bother, said Winnie the Pooh, as the ants devoured him.
  /\___/\          Ant(Dude) @ http://antfarm.ma.cx (Personal Web Site)
 / /\ /\ \                 Ant's Quality Foraged Links: http://aqfl.net
| |o   o| |                 E-mail: phi...@earthlink.net/a...@zimage.com
   \ _ /              If crediting, then please kindly use Ant nickname
    ( )                                              and AQFL URL/link.

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


-- 
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] Question about CALC

2012-04-30 Thread alex sato
Can anyone tell me why when making a freezeable (not sure if this word
really exist  :-) ) operation in one CALC windows, like saving a
large/complex spreadsheet, freeze (while operation is running) all openned
CALC windows?

Thanks

Alex Mitsio Sato

-- 
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] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread Ant
Interesting. I will try uninstalling and installing v3.4.6 later. Is 
there a newer stable version of v3.5.2 soon? I assume v3.5.2 has no 
problem in 64-bit W7 HPE that I plan to do the same (uninstall OO and 
then install LO).

On Mon, Apr 30, 2012 at 05:36:18PM +0100, Tom Davies wrote:
 Hi :)
 The 3.4.6 seems to have had the least problems out of any of the releases so 
 far.  All what problems in Xp?
 Regards from
 Tom :)
 
 
 --- On Mon, 30/4/12, Ant a...@zimage.com wrote:
 
 From: Ant a...@zimage.com
 Subject: Re: [libreoffice-users] Unable to start my newly installed 
 LibreOffice v3.5.2 programs.
 To: users@global.libreoffice.org
 Date: Monday, 30 April, 2012, 15:41
 
 Wow, what is with all the problems with v3.4.6 in old Windows XP Pro. 
 SP3? I am surprised the issues haven't been fixed with the latest v3.5.x 
 versions for this long. :(
 
 
 On Mon, Apr 30, 2012 at 10:32:56AM -0400, webmaster-Kracked_P_P wrote:
  
  Personally, for XP, I would start with LO 3.4.6.
  
  This is the most stable version of LO and I KNOW is works on XP,
  since that is what I am running on an old XP/pro laptop.
  
  Please try it.  Here is the English download page for 3.4.6.
  http://www.libreoffice.org/download/?type=win-x86〈=en-USversion=3.4.6 
  http://www.libreoffice.org/download/?type=win-x86〈=en-USversion=3.4.6
  
  Too many people are having problems with the 3.5.x line so for a
  first time user, I would stick with 3.4.6.
  
  
  http://www.libreoffice.org/download/?type=win-x86〈=en-USversion=3.4.6
  On 04/29/2012 08:54 PM, Ant wrote:
  On Mon, Apr 30, 2012 at 01:10:39AM +0100, Tom Davies wrote:
  Hi :)
  Please can you try renaming you User Profile
  http://wiki.documentfoundation.org/Documentation/UserProfile
  Nope. remember this is my first LibreOffice installation since I wanted
  to replace the outdated OpenOffice. I deleted C:\Documents and
  Settings\UserName\Application Data\LibreOffice\ and retried to get the
  same results.
  
  
  that seems to fix most weird problems.  Crashing might be something to
  do with an Extension/Add-on.  Java sometimes causes crashes so do you
  happen to know which version of java you have got installed? Regards
  I am using the latest Oracle Java (JRE) v6 update 31. :)
  
  
  --- On Mon, 30/4/12, Anta...@zimage.com  wrote:
  From: Anta...@zimage.com
  Subject: [libreoffice-users] Unable to start my newly installed 
  LibreOffice v3.5.2 programs.
  To: users@global.libreoffice.org
  Date: Monday, 30 April, 2012, 0:53
  
  Hello.
  
  I just uninstalled old OpenOffice (OO) v3.3.0 and then installed a new
  LibreOffice v3.5.2 into my old, updated Windows XP Pro. SP3 machine.
  However, none of its programs will start. I see the splash screen and
  then it (soffice.bin) exits. No errors I saw. What's the problem? OO was
  working fine right before I uninstalled it.

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


Re: [libreoffice-users] Impress full screen question

2012-04-30 Thread Dan Lewis
On Mon, 2012-04-30 at 17:52 +0200, Didier Spaier wrote:
 On 30/04/2012 17:21, Renaud (Ron) Olgiati wrote:
  On Monday 30 Apr 2012 10:20 my mailbox was graced by a message from Didier
  Spaier who wrote:
  To open a presentation in full screen in LO, I just hit F5 or choose
  Slideshow (Diaporama, in French) in the menu.
  So where is the problem?
 
  The problem is that it is not full screen: It still displays the borders,
  title bar and menu bar of the window.
 
  There is the problem.
 
  Cheers,
 
  Ron.
 I use Impress extensively and do not encounter this problem with Slackware 
 13.37, under Fluxbox or XFCE.
 
 So my guess is that this in related to your desktop or windows manager.
 
 So, could you please tell us what is your distribution, and the desktop or 
 windows manager you use?
 
 Cheers,
 
 Didier

 This does seem strange. My MacBook has two partitions (Mac, and
Ubuntu (32 bit) 12.04LST). The make uses the entire screen for the
presentation, but Ubuntu does not. It shows the title and menu bars. (I
should mention that I use the Gnome desktop rather than Unity.)
 I also have a tower running Ubuntu 11.10 64-bit also using Gnome
desktop. Presentations use the entire screen (no borders, menu bar, nor
title bar.

--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] Impress full screen question

2012-04-30 Thread Renaud (Ron) Olgiati
On Monday 30 Apr 2012 11:52 my mailbox was graced by a message from Didier 
Spaier who wrote:
  To open a presentation in full screen in LO, I just hit F5 or choose
  Slideshow (Diaporama, in French) in the menu.
  So where is the problem?

  The problem is that it is not full screen: It still displays the borders,
  title bar and menu bar of the window.

 I use Impress extensively and do not encounter this problem with Slackware
 13.37, under Fluxbox or XFCE.
 So my guess is that this in related to your desktop or windows manager.
 So, could you please tell us what is your distribution, and the desktop or
 windows manager you use?

I have the problem under both these configurations:

Mageia 1, KDE 4.6.5 and LO 3.4.4 
and
Mageia 1, LXDE and LO 3.4.4 .
 
Cannot try a more recent version of LO, no upgrade for Mageia 1, and Mageia 2 
is not out yet..

Cheers,
 
Ron.
-- 
   Security is a superstition: it does not exist in nature.
 Avoiding danger is no safer in the long run than outright exposure.
 -- Helen Keller

   -- http://www.olgiati-in-paraguay.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] How do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?

2012-04-30 Thread Richard Quadling
Hi.

I'm on a Mac and trying to replicate a process I'm very familiar with
on Windows using MS Excel.

I have a database (a MySQL database) and I want to create a
spreadsheet that will allow users to quickly query the database and
get reports/counts/etc.

In Windows, I create views on the database and use MS Query / ODBC to
link between Excel and the database. All works exactly as you'd
expect. No drama, hassle or anything.

I'm no longer working in a Windows environment and I'm struggling with
what seems to be a fairly obvious use case.

I've been recommend LibreOffice, and for the bits and pieces I've used
so far, I'm impressed.

I've managed to create a database link and I can create views and
store them and, on the surface, it looks OK.

When I look at the spreadsheet, I can see no way to link to the
database. When I open the Navigator, I can see Database Ranges - but
that's not what it seems.

Now, I know I can cut'n'paste the data. This is NOT what I want.

The use case is it allow a user to open the spreadsheet and either
automatically or manually update the data from the database. No
complex cut'n'paste or 20 click madness.

Any real help would be greatly appreciated.

Thanks in advance.

Regards,

Richard.

-- 
Richard Quadling
Twitter : EE : Zend : Fantasy Shopper
@RQuadling : http://e-e.com/M_248814.html : http://bit.ly/9O8vFY :
http://fan.sh/106/5tw

-- 
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] Impress full screen question

2012-04-30 Thread Don C. Myers


On 04/30/2012 01:03 PM, Dan Lewis wrote:

On Mon, 2012-04-30 at 17:52 +0200, Didier Spaier wrote:

On 30/04/2012 17:21, Renaud (Ron) Olgiati wrote:

On Monday 30 Apr 2012 10:20 my mailbox was graced by a message from Didier
Spaier who wrote:

To open a presentation in full screen in LO, I just hit F5 or choose
Slideshow (Diaporama, in French) in the menu.
So where is the problem?

The problem is that it is not full screen: It still displays the borders,
title bar and menu bar of the window.

There is the problem.

Cheers,

Ron.

I use Impress extensively and do not encounter this problem with Slackware 
13.37, under Fluxbox or XFCE.

So my guess is that this in related to your desktop or windows manager.

So, could you please tell us what is your distribution, and the desktop or 
windows manager you use?

Cheers,

Didier

  This does seem strange. My MacBook has two partitions (Mac, and
Ubuntu (32 bit) 12.04LST). The make uses the entire screen for the
presentation, but Ubuntu does not. It shows the title and menu bars. (I
should mention that I use the Gnome desktop rather than Unity.)
  I also have a tower running Ubuntu 11.10 64-bit also using Gnome
desktop. Presentations use the entire screen (no borders, menu bar, nor
title bar.

--Dan





Hi,

I'm running Ubuntu 12.04 and LibreOffice 3.5.2. When viewing a slide 
show, I have a full screen without the title bar or the Unity launcher 
bar showing.


Don
--


**


--
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] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread Tom Davies
Hi :)
You might find the graphic near the top of this link interesting
http://wiki.documentfoundation.org/ReleasePlan

Basically LibreOffice tends to have 2 branches being developed alongside each 
other.  The later releases of a branch become more stable and add fewer new 
features.  Each branch seems to become stable by about .4, so 3.5.4 will 
hopefully be stable but by then there will probably be a new branch, the 3.6.x 
packed full of new features.  So it's always a question of whether you want to 
have greater stability or more functionality, or have both installed alongside 
each other. 

I run a 32bit OS and programs even tho i have a 64bit processor.  The first few 
times i tried 64bit OSes i found only small speed increases but loads of 
additional problems and instabilities.  I'm really only a pointclick user so i 
went back to 32bit to make things easier.  That was a good few years ago so i 
guess i really should try a 64bit OS soon!  I thought LibreOffice only released 
32bit versions? (which should be fine on a 64bit OS)
Regards from
Tom :)


--- On Mon, 30/4/12, Ant a...@zimage.com wrote:

From: Ant a...@zimage.com
Subject: Re: [libreoffice-users] Unable to start my newly installed LibreOffice 
v3.5.2 programs.
To: users@global.libreoffice.org
Date: Monday, 30 April, 2012, 18:03

Interesting. I will try uninstalling and installing v3.4.6 later. Is 
there a newer stable version of v3.5.2 soon? I assume v3.5.2 has no 
problem in 64-bit W7 HPE that I plan to do the same (uninstall OO and 
then install LO).

On Mon, Apr 30, 2012 at 05:36:18PM +0100, Tom Davies wrote:
 Hi :)
 The 3.4.6 seems to have had the least problems out of any of the releases so 
 far.  All what problems in Xp?
 Regards from
 Tom :)
 
 
 --- On Mon, 30/4/12, Ant a...@zimage.com wrote:
 
 From: Ant a...@zimage.com
 Subject: Re: [libreoffice-users] Unable to start my newly installed 
 LibreOffice v3.5.2 programs.
 To: users@global.libreoffice.org
 Date: Monday, 30 April, 2012, 15:41
 
 Wow, what is with all the problems with v3.4.6 in old Windows XP Pro. 
 SP3? I am surprised the issues haven't been fixed with the latest v3.5.x 
 versions for this long. :(
 
 
 On Mon, Apr 30, 2012 at 10:32:56AM -0400, webmaster-Kracked_P_P wrote:
  
  Personally, for XP, I would start with LO 3.4.6.
  
  This is the most stable version of LO and I KNOW is works on XP,
  since that is what I am running on an old XP/pro laptop.
  
  Please try it.  Here is the English download page for 3.4.6.
  http://www.libreoffice.org/download/?type=win-x86〈=en-USversion=3.4.6 
  http://www.libreoffice.org/download/?type=win-x86〈=en-USversion=3.4.6
  
  Too many people are having problems with the 3.5.x line so for a
  first time user, I would stick with 3.4.6.
  
  
  http://www.libreoffice.org/download/?type=win-x86〈=en-USversion=3.4.6
  On 04/29/2012 08:54 PM, Ant wrote:
  On Mon, Apr 30, 2012 at 01:10:39AM +0100, Tom Davies wrote:
  Hi :)
  Please can you try renaming you User Profile
  http://wiki.documentfoundation.org/Documentation/UserProfile
  Nope. remember this is my first LibreOffice installation since I wanted
  to replace the outdated OpenOffice. I deleted C:\Documents and
  Settings\UserName\Application Data\LibreOffice\ and retried to get the
  same results.
  
  
  that seems to fix most weird problems.  Crashing might be something to
  do with an Extension/Add-on.  Java sometimes causes crashes so do you
  happen to know which version of java you have got installed? Regards
  I am using the latest Oracle Java (JRE) v6 update 31. :)
  
  
  --- On Mon, 30/4/12, Anta...@zimage.com  wrote:
  From: Anta...@zimage.com
  Subject: [libreoffice-users] Unable to start my newly installed 
  LibreOffice v3.5.2 programs.
  To: users@global.libreoffice.org
  Date: Monday, 30 April, 2012, 0:53
  
  Hello.
  
  I just uninstalled old OpenOffice (OO) v3.3.0 and then installed a new
  LibreOffice v3.5.2 into my old, updated Windows XP Pro. SP3 machine.
  However, none of its programs will start. I see the splash screen and
  then it (soffice.bin) exits. No errors I saw. What's the problem? OO was
  working fine right before I uninstalled it.

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

-- 
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 do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?

2012-04-30 Thread Tom Davies
Hi :)
Hopefully other people will have better answers later but it might be worth 
having a quick flick through likely chapters in the official documentation on
http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide
Good luck and regards from
Tom :)


--- On Mon, 30/4/12, Richard Quadling rquadl...@gmail.com wrote:

From: Richard Quadling rquadl...@gmail.com
Subject: [libreoffice-users] How do I link data from a LibreOffice Database 
(linked to a MySQL Server) to a LibreOffice Spreadsheet?
To: users@global.libreoffice.org
Date: Monday, 30 April, 2012, 19:25

Hi.

I'm on a Mac and trying to replicate a process I'm very familiar with
on Windows using MS Excel.

I have a database (a MySQL database) and I want to create a
spreadsheet that will allow users to quickly query the database and
get reports/counts/etc.

In Windows, I create views on the database and use MS Query / ODBC to
link between Excel and the database. All works exactly as you'd
expect. No drama, hassle or anything.

I'm no longer working in a Windows environment and I'm struggling with
what seems to be a fairly obvious use case.

I've been recommend LibreOffice, and for the bits and pieces I've used
so far, I'm impressed.

I've managed to create a database link and I can create views and
store them and, on the surface, it looks OK.

When I look at the spreadsheet, I can see no way to link to the
database. When I open the Navigator, I can see Database Ranges - but
that's not what it seems.

Now, I know I can cut'n'paste the data. This is NOT what I want.

The use case is it allow a user to open the spreadsheet and either
automatically or manually update the data from the database. No
complex cut'n'paste or 20 click madness.

Any real help would be greatly appreciated.

Thanks in advance.

Regards,

Richard.

-- 
Richard Quadling
Twitter : EE : Zend : Fantasy Shopper
@RQuadling : http://e-e.com/M_248814.html : http://bit.ly/9O8vFY :
http://fan.sh/106/5tw

-- 
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] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread Ant
On Mon, Apr 30, 2012 at 08:07:56PM +0100, Tom Davies wrote:

 You might find the graphic near the top of this link interesting
 http://wiki.documentfoundation.org/ReleasePlan

Thanks. Still a lot of v3.5.x versions to release left.


 Basically LibreOffice tends to have 2 branches being developed 
 alongside each other.  The later releases of a branch become more 
 stable and add fewer new features.  Each branch seems to become stable 
 by about .4, so 3.5.4 will hopefully be stable but by then there will 
 probably be a new branch, the 3.6.x packed full of new features.  So 
 it's always a question of whether you want to have greater stability 
 or more functionality, or have both installed alongside each other.

Ah, I will try v3.4 later. I tend to get the latest stable versions. Are 
there any bug reports about the Windows XP issues like my startup 
crashes?

 
 I run a 32bit OS and programs even tho i have a 64bit processor.  The 
 first few times i tried 64bit OSes i found only small speed increases 
 but loads of additional problems and instabilities.  I'm really only a 
 pointclick user so i went back to 32bit to make things easier.  That 
 was a good few years ago so i guess i really should try a 64bit OS 
 soon!  I thought LibreOffice only released 32bit versions? (which 
 should be fine on a 64bit OS) Regards from

I didn't even notice it was a 32-bit LO. I also don't even see a 64-bit 
one, but if it is worse than 32-bit then I don't want it. BTW, 32-bit 
v3.5.2 LO on my 64-bit W7 HPE worked fine so far. :)

Now, I just need to get it working on my old Windows XP Pro. SP3 
machine!

-- 
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] Starting a set of styles from scratch in LO Writer?

2012-04-30 Thread Jean-Francois Nifenecker

Le 29/04/2012 15:00, Mirosław Zalewski a écrit :

On 29/04/2012 at 08:23, Jean-Francois Nifeneckerjean-
francois.nifenec...@laposte.net  wrote:


-- any user opening you docs will be able to have their own style
settings which will automagically adapt your docs to their taste.

eg: you setup the Text Body paragraph style to use Liberation Sans font
fo your document. If you pass it over to me, where I have the same style
with the Liberation Serif font setup, I can read *your* document with
*my* settings.


Are you sure about it? I would consider it rather bug than a feature.


Well, YMMV.

If I copy and paste a given document (using stock styles) into my own 
template, I get the doc with the settings I like. I find this to be neat 
and useful ;)




If I set my document to use 8pt MS Comic Sans as a default text body font,
then I want my document to be mostly 8pt MS Comic Sans. If I send this
document to my friend, I want him to see that absurd font setting (if only he
has MS Comic Sans installed). In electronic documents (as ODT) this is very
important to preserve any formatting applied by author.


Sorry, no, I don't think so. In fact there are two situations, as you 
mention below:

(1) the author wants his/her work to remain untouched - PDFs
(2) s-he doesn't mind, or s-he respects the user's preferences - ODFs



Or maybe your comment applies only to documents created on base of default
Writer template? I have switched to my own default template years ago.


Yes.

--
Jean-Francois Nifenecker, Bordeaux

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


Re: [libreoffice-users] Re: Starting a set of styles from scratch in LO Writer?

2012-04-30 Thread Jean-Francois Nifenecker

Le 29/04/2012 14:43, Tom Davies a écrit :

Yes, the Writer's Guide does use it's own custom set of names
but it seems to cause problems and the list has discussed changing to
the proper ones.


Yes. I had mentioned that... err... feature some months ago. I 
consider this example to be the worst thing in documents that are 
precisely there to show what good practices are. And, for the reasons 
explained above, this is a very bad one. Reading avamk message is all 
grist for my mill.



Sadly they don't have much time to deal with stuff
like that and need to focus on just getting the guides out there.


Yes, that's for sure: fixing such extensive stylisation is a very 
time-consuming task.


--
Jean-Francois Nifenecker, Bordeaux

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



Re: [libreoffice-users] Impress full screen question

2012-04-30 Thread Dan Lewis
On Mon, 2012-04-30 at 14:26 -0400, Don C. Myers wrote:
 On 04/30/2012 01:03 PM, Dan Lewis wrote:
  On Mon, 2012-04-30 at 17:52 +0200, Didier Spaier wrote:
  On 30/04/2012 17:21, Renaud (Ron) Olgiati wrote:
  On Monday 30 Apr 2012 10:20 my mailbox was graced by a message from Didier
  Spaier who wrote:
  To open a presentation in full screen in LO, I just hit F5 or choose
  Slideshow (Diaporama, in French) in the menu.
  So where is the problem?
  The problem is that it is not full screen: It still displays the borders,
  title bar and menu bar of the window.
 
  There is the problem.
 
  Cheers,
 
  Ron.
  I use Impress extensively and do not encounter this problem with Slackware 
  13.37, under Fluxbox or XFCE.
 
  So my guess is that this in related to your desktop or windows manager.
 
  So, could you please tell us what is your distribution, and the desktop or 
  windows manager you use?
 
  Cheers,
 
  Didier
This does seem strange. My MacBook has two partitions (Mac, and
  Ubuntu (32 bit) 12.04LST). The make uses the entire screen for the
  presentation, but Ubuntu does not. It shows the title and menu bars. (I
  should mention that I use the Gnome desktop rather than Unity.)
I also have a tower running Ubuntu 11.10 64-bit also using Gnome
  desktop. Presentations use the entire screen (no borders, menu bar, nor
  title bar.
 
  --Dan
 
 Hi,
 
 I'm running Ubuntu 12.04 and LibreOffice 3.5.2. When viewing a slide 
 show, I have a full screen without the title bar or the Unity launcher 
 bar showing.
 
 Don

Is your computer 32 bit or 64 bit though?

--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 do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?

2012-04-30 Thread Nino Novak
Hi,

On Monday 30 April 2012, 19:25:38 Richard Quadling wrote:

 Any real help would be greatly appreciated.

Did you have a look at 
http://user.services.openoffice.org/en/forum/viewtopic.php?f=75t=18511
?

Regards, 
Nino

-- 
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] Impress full screen question

2012-04-30 Thread Renaud (Ron) Olgiati
On Monday 30 Apr 2012 16:37 my mailbox was graced by a message from Dan Lewis 
who wrote:
  Is your computer 32 bit or 64 bit though?

The KDE is 64, the LXDE is 32
 
Cheers,
 
Ron.
-- 
   Questions are never indiscreet,
answers sometimes are.
-- Oscar Wilde

   -- http://www.olgiati-in-paraguay.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] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread Tom Davies
Hi :)
I'm not sure why you're Xp one is crashing.  Did you use the same installer 
that you used for the Win7 machine?  If not then it might be worth trying that 
one or just check that the download didn't go wrong.  Can you check the md5sum 
or sha or whatever?  

Even a new install will pick up on an old config folder such as your old 
configs for OpenOffice.org.  Sometimes the config folder can be a bit wonky on 
a fresh release (although it's about a year since someone last mentioned 
experiencing that) so renaming the user profile can be a good idea even on a 
fresh new install if things seems a bit wrong.  

You can find a list of fixes and things from the main wiki-page
http://wiki.documentfoundation.org/Main_Page
but they just tend to be from 1 minor point-release to the next.  I couldn't 
find the release notes.  

It is very early days for the 3.5.x branch.  I guess that goes up to 3.5.6 too 
right?

Btw 32bit apps should be fine on 64bit OSes.  64bit OSes wont install on a 
32bit machine so obviously your machine is a 64bit machine.  
Regards from
Tom :)


--- On Mon, 30/4/12, Ant a...@zimage.com wrote:

From: Ant a...@zimage.com
Subject: Re: [libreoffice-users] Unable to start my newly installed LibreOffice 
v3.5.2 programs.
To: users@global.libreoffice.org
Date: Monday, 30 April, 2012, 20:22

On Mon, Apr 30, 2012 at 08:07:56PM +0100, Tom Davies wrote:

 You might find the graphic near the top of this link interesting
 http://wiki.documentfoundation.org/ReleasePlan

Thanks. Still a lot of v3.5.x versions to release left.


 Basically LibreOffice tends to have 2 branches being developed 
 alongside each other.  The later releases of a branch become more 
 stable and add fewer new features.  Each branch seems to become stable 
 by about .4, so 3.5.4 will hopefully be stable but by then there will 
 probably be a new branch, the 3.6.x packed full of new features.  So 
 it's always a question of whether you want to have greater stability 
 or more functionality, or have both installed alongside each other.

Ah, I will try v3.4 later. I tend to get the latest stable versions. Are 
there any bug reports about the Windows XP issues like my startup 
crashes?

 
 I run a 32bit OS and programs even tho i have a 64bit processor.  The 
 first few times i tried 64bit OSes i found only small speed increases 
 but loads of additional problems and instabilities.  I'm really only a 
 pointclick user so i went back to 32bit to make things easier.  That 
 was a good few years ago so i guess i really should try a 64bit OS 
 soon!  I thought LibreOffice only released 32bit versions? (which 
 should be fine on a 64bit OS) Regards from

I didn't even notice it was a 32-bit LO. I also don't even see a 64-bit 
one, but if it is worse than 32-bit then I don't want it. BTW, 32-bit 
v3.5.2 LO on my 64-bit W7 HPE worked fine so far. :)

Now, I just need to get it working on my old Windows XP Pro. SP3 
machine!

-- 
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] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread Ant
On Mon, Apr 30, 2012 at 10:40:14PM +0100, Tom Davies wrote:
 Hi :)

 I'm not sure why you're Xp one is crashing.  Did you use the same 
 installer that you used for the Win7 machine?  If not then it might be 
 worth trying that one or just check that the download didn't go 
 wrong.  Can you check the md5sum or sha or whatever? 

No, it was a new download. If the one at home was bad, then it wouldn't 
finish/fail installation, right? I will check its MD5sum. What's the 
correct one?

 
 Even a new install will pick up on an old config folder such as your old 
 configs for OpenOffice.org.  Sometimes the config folder can be a bit wonky 
 on a fresh release (although it's about a year since someone last mentioned 
 experiencing that) so renaming the user profile can be a good idea even on a 
 fresh new install if things seems a bit wrong.  

Which configs? OpenOffice's? Remember, this is my first LibreOffice 
install.

 
 You can find a list of fixes and things from the main wiki-page
 http://wiki.documentfoundation.org/Main_Page
 but they just tend to be from 1 minor point-release to the next.  I couldn't 
 find the release notes.  

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



[libreoffice-users] Re: How do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?

2012-04-30 Thread Andreas Säger

Am 30.04.2012 21:20, Tom Davies wrote:

Hi :)
Hopefully other people will have better answers later but it might be worth 
having a quick flick through likely chapters in the official documentation on
http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide
Good luck and regards from
Tom :)


Tom,
Please shut up if you don't know any answer other than a hyperlink to 
the (awful) LibreOffice documentation.
You spam this list with your MariaDB announcements but you can not 
answer the question how to connect a database to this office suite.



--
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] Impress full screen question

2012-04-30 Thread Don C. Myers



On 04/30/2012 04:37 PM, Dan Lewis wrote:

On Mon, 2012-04-30 at 14:26 -0400, Don C. Myers wrote:

On 04/30/2012 01:03 PM, Dan Lewis wrote:

On Mon, 2012-04-30 at 17:52 +0200, Didier Spaier wrote:

On 30/04/2012 17:21, Renaud (Ron) Olgiati wrote:

On Monday 30 Apr 2012 10:20 my mailbox was graced by a message from Didier
Spaier who wrote:

To open a presentation in full screen in LO, I just hit F5 or choose
Slideshow (Diaporama, in French) in the menu.
So where is the problem?

The problem is that it is not full screen: It still displays the borders,
title bar and menu bar of the window.

There is the problem.

Cheers,

Ron.

I use Impress extensively and do not encounter this problem with Slackware 
13.37, under Fluxbox or XFCE.

So my guess is that this in related to your desktop or windows manager.

So, could you please tell us what is your distribution, and the desktop or 
windows manager you use?

Cheers,

Didier

   This does seem strange. My MacBook has two partitions (Mac, and
Ubuntu (32 bit) 12.04LST). The make uses the entire screen for the
presentation, but Ubuntu does not. It shows the title and menu bars. (I
should mention that I use the Gnome desktop rather than Unity.)
   I also have a tower running Ubuntu 11.10 64-bit also using Gnome
desktop. Presentations use the entire screen (no borders, menu bar, nor
title bar.

--Dan


Hi,

I'm running Ubuntu 12.04 and LibreOffice 3.5.2. When viewing a slide
show, I have a full screen without the title bar or the Unity launcher
bar showing.

Don

 Is your computer 32 bit or 64 bit though?

--Dan




I'm running 64 bit.

Don
--


**


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


[libreoffice-users] Re: How do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?

2012-04-30 Thread Andreas Säger

Am 01.05.2012 00:35, Richard Quadling wrote:


Perfect. At least now I can get data into a spreadsheet.

Next I need to work out calling stored procedures and passing user
parameters to the SP as well as automated updating (on open and on
parameter changing).

These are probably macro based rather than UI.

Hopefully.


Thank you for your reply though. Very useful.



I know at least 3 methods.

1) Simple method:
 Add a parameter query to the Base document:
SELECT * FROM Table WHERE A = :param_A AND Date BETWEEN :From_Date 
AND :Until_Date


Named parameters are unquoted alphanumeric and start with a colon.
Drag that query into your sheet.
When you access/refresh the parameter query you will be prompted for 
substitution.


2) Add a small filter table to the database, add a criteria input form 
to the spreadsheet and bind it to one particular record of the filter 
table.
The user enters the criteria into the form and refreshes the import 
range which is bound to:
SELECT D.* FROM Data AS D, FilterAS F WHERE Filter.RowID=0 
AND D.A = F.INT_A AND D.Date BETWEEN F.D1 AND F.D2



3) A generic macro of mine which binds an import range to a changing SQL 
string (not possible in the GUI). For simplicity and better 
customization the macro reads the SQL from a named cell.

http://user.services.openoffice.org/en/forum/viewtopic.php?t=1645p=6847#p6847


--
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] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread Tom Davies
Hi :)
You can get the md5sum and sha hashes from
http://download.documentfoundation.org/libreoffice/stable/3.5.2/rpm/x86/LibO_3.5.2_Linux_x86_install-rpm_en-US.tar.gz.mirrorlist
(from the downloads page click on info carefully hidden in the Download 
'button')  

I guess it would be OpenOffice's config.  By configs i mean the whole 
user-profile
http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12426
but i think it might be better to install LibreOffice as though it was a 
parallel installation alongside your existing OOo
http://wiki.documentfoundation.org/Installing_in_parallel

I just have a feeling that your fresh new LO might be reading your old OOo 
profile and there might be an Extension/Add-on in there that disagrees with 
LO.  
Regards from
Tom :)


--- On Mon, 30/4/12, Ant a...@zimage.com wrote:

From: Ant a...@zimage.com
Subject: Re: [libreoffice-users] Unable to start my newly installed LibreOffice 
v3.5.2 programs.
To: users@global.libreoffice.org
Date: Monday, 30 April, 2012, 22:44

On Mon, Apr 30, 2012 at 10:40:14PM +0100, Tom Davies wrote:
 Hi :)

 I'm not sure why you're Xp one is crashing.  Did you use the same 
 installer that you used for the Win7 machine?  If not then it might be 
 worth trying that one or just check that the download didn't go 
 wrong.  Can you check the md5sum or sha or whatever? 

No, it was a new download. If the one at home was bad, then it wouldn't 
finish/fail installation, right? I will check its MD5sum. What's the 
correct one?

 
 Even a new install will pick up on an old config folder such as your old 
 configs for OpenOffice.org.  Sometimes the config folder can be a bit wonky 
 on a fresh release (although it's about a year since someone last mentioned 
 experiencing that) so renaming the user profile can be a good idea even on a 
 fresh new install if things seems a bit wrong.  

Which configs? OpenOffice's? Remember, this is my first LibreOffice 
install.

 
 You can find a list of fixes and things from the main wiki-page
 http://wiki.documentfoundation.org/Main_Page
 but they just tend to be from 1 minor point-release to the next.  I couldn't 
 find the release notes.  

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] Re: How do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?

2012-04-30 Thread Tom Davies
Hi :)
If you feel you could produce good guides then i'm sure the docs team would be 
glad to welcome you in.  
Regards from
Tom :)


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

From: Andreas Säger ville...@t-online.de
Subject: [libreoffice-users] Re: How do I link data from a LibreOffice Database 
(linked to a MySQL Server) to a LibreOffice Spreadsheet?
To: users@global.libreoffice.org
Date: Monday, 30 April, 2012, 23:09

Am 30.04.2012 21:20, Tom Davies wrote:
 Hi :)
 Hopefully other people will have better answers later but it might be worth 
 having a quick flick through likely chapters in the official documentation on
 http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide
 Good luck and regards from
 Tom :)

Tom,
Please shut up if you don't know any answer other than a hyperlink to the 
(awful) LibreOffice documentation.
You spam this list with your MariaDB announcements but you can not answer the 
question how to connect a database to this office suite.


-- 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] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread Ant
On Tue, May 01, 2012 at 12:32:11AM +0100, Tom Davies wrote:
 Hi :)
 You can get the md5sum and sha hashes from
 http://download.documentfoundation.org/libreoffice/stable/3.5.2/rpm/x86/LibO_3.5.2_Linux_x86_install-rpm_en-US.tar.gz.mirrorlist
 (from the downloads page click on info carefully hidden in the Download 
 'button')  

Ah, found it in 
http://download.documentfoundation.org/libreoffice/stable/3.5.2/win/x86/LibO_3.5.2_Win_x86_install_multi.msi.mirrorlist
 
... I will check my local XP machine later (not at it right now).

 
 I guess it would be OpenOffice's config.  By configs i mean the whole 
 user-profile
 http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12426

Yea, I deleted my C:\Documents and Settings\user name\Application 
Data\OpenOffice.org\ since I didn't have OO installed anymore.


 but i think it might be better to install LibreOffice as though it was a 
 parallel installation alongside your existing OOo
 http://wiki.documentfoundation.org/Installing_in_parallel

Too late now. OO is old anyways! :)

 
 I just have a feeling that your fresh new LO might be reading your old 
 OOo profile and there might be an Extension/Add-on in there that 
 disagrees with LO. 

Where are those extensions/addons stored? I do remember installing some 
for OO long time ago.

-- 
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] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread Tom Davies
Hi :)
The Extensions/Add-ons are stored inside your UserProfile :) lol.  The idea is 
that you can doa  fresh install without losing yoru Extensions (and other 
settings)

Dohhh!  I hadn't noticed the rpm bit in the url i gave you!  It's good to see 
you found the right one for Windows!  (rpm is one of the GnuLinux methods of 
installing things of course)
Regards from
Tom :)


--- On Tue, 1/5/12, Ant a...@zimage.com wrote:

From: Ant a...@zimage.com
Subject: Re: [libreoffice-users] Unable to start my newly installed LibreOffice 
v3.5.2 programs.
To: users@global.libreoffice.org
Date: Tuesday, 1 May, 2012, 0:47

On Tue, May 01, 2012 at 12:32:11AM +0100, Tom Davies wrote:
 Hi :)
 You can get the md5sum and sha hashes from
 http://download.documentfoundation.org/libreoffice/stable/3.5.2/rpm/x86/LibO_3.5.2_Linux_x86_install-rpm_en-US.tar.gz.mirrorlist
 (from the downloads page click on info carefully hidden in the Download 
 'button')  

Ah, found it in 
http://download.documentfoundation.org/libreoffice/stable/3.5.2/win/x86/LibO_3.5.2_Win_x86_install_multi.msi.mirrorlist
 
... I will check my local XP machine later (not at it right now).

 
 I guess it would be OpenOffice's config.  By configs i mean the whole 
 user-profile
 http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12426

Yea, I deleted my C:\Documents and Settings\user name\Application 
Data\OpenOffice.org\ since I didn't have OO installed anymore.


 but i think it might be better to install LibreOffice as though it was a 
 parallel installation alongside your existing OOo
 http://wiki.documentfoundation.org/Installing_in_parallel

Too late now. OO is old anyways! :)

 
 I just have a feeling that your fresh new LO might be reading your old 
 OOo profile and there might be an Extension/Add-on in there that 
 disagrees with LO. 

Where are those extensions/addons stored? I do remember installing some 
for OO long time ago.

-- 
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] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread Ant
Ah OK. Weird. I will still have to try v3.4.x Does the LO's crashes keep 
any records/logs somewhere?


On Tue, May 01, 2012 at 12:52:57AM +0100, Tom Davies wrote:
 Hi :)
 The Extensions/Add-ons are stored inside your UserProfile :) lol.  The idea 
 is that you can doa  fresh install without losing yoru Extensions (and other 
 settings)
 
 Dohhh!  I hadn't noticed the rpm bit in the url i gave you!  It's good to 
 see you found the right one for Windows!  (rpm is one of the GnuLinux 
 methods of installing things of course)
 Regards from
 Tom :)
 
 
 --- On Tue, 1/5/12, Ant a...@zimage.com wrote:
 
 From: Ant a...@zimage.com
 Subject: Re: [libreoffice-users] Unable to start my newly installed 
 LibreOffice v3.5.2 programs.
 To: users@global.libreoffice.org
 Date: Tuesday, 1 May, 2012, 0:47
 
 On Tue, May 01, 2012 at 12:32:11AM +0100, Tom Davies wrote:
  Hi :)
  You can get the md5sum and sha hashes from
  http://download.documentfoundation.org/libreoffice/stable/3.5.2/rpm/x86/LibO_3.5.2_Linux_x86_install-rpm_en-US.tar.gz.mirrorlist
  (from the downloads page click on info carefully hidden in the Download 
  'button')  
 
 Ah, found it in 
 http://download.documentfoundation.org/libreoffice/stable/3.5.2/win/x86/LibO_3.5.2_Win_x86_install_multi.msi.mirrorlist
  
 ... I will check my local XP machine later (not at it right now).
 
  
  I guess it would be OpenOffice's config.  By configs i mean the whole 
  user-profile
  http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12426
 
 Yea, I deleted my C:\Documents and Settings\user name\Application 
 Data\OpenOffice.org\ since I didn't have OO installed anymore.
 
 
  but i think it might be better to install LibreOffice as though it was a 
  parallel installation alongside your existing OOo
  http://wiki.documentfoundation.org/Installing_in_parallel
 
 Too late now. OO is old anyways! :)
 
  
  I just have a feeling that your fresh new LO might be reading your old 
  OOo profile and there might be an Extension/Add-on in there that 
  disagrees with LO. 
 
 Where are those extensions/addons stored? I do remember installing some 
 for OO long time ago.

-- 
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] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread webmaster-Kracked_P_P


I just remembered something with the last clean install for XP and 
LO.  This was for 3.4.1[or 3.4.2?] and XP.


I had to install LO twice in a row, WITH NO uninstall in between.  I do 
not know why that happened, but it happened to me twice.  BUT, the last 
time I installed 3.4.4, or was it 3.4.5, on XP/pro I did not have any 
issues.  There was just something in the XP system[s] I was dealing with 
that had issues and not all of what was to be installed was installed 
properly.  The second install, which was a repair finished the install 
properly.  I do not know if it was a problem for XP or for LO or a 
combination of both, but the second install [without an uninstall] fixed 
the problem and it worked great from there on and the installing for the 
next version[s] worked fine.


I really prefer people try the most stable version of LO, which 
currently is 3.4.6, before they go to the most cutting edge version, 
which currently is 3.5.2.


I have found that 3.4.6 works very well for me on Win XP/pro, Vista, and 
Ubuntu 10.04/12.04.  There are some issues in 3.5.x that is in their bug 
list that need to be fixed before I go to 3.5.x over 3.4.6..


AS FOR not installing if the install file was bad or incomplete, that is 
not true.  I have had both type of issues try to install and then fail 
somewhere along the way.  Usually it fails so bad that I have to do a 
lot of cleaning up my system after the failure.


Right now, I have a HP Pavilion zv6123 laptop running XP/pro [32-bit] 
and it has LO 3.4.6 running on it. I have to check what service pack is 
on it, but the package installed fine.

.

On 04/30/2012 07:32 PM, Tom Davies wrote:

Hi :)
You can get the md5sum and sha hashes from
http://download.documentfoundation.org/libreoffice/stable/3.5.2/rpm/x86/LibO_3.5.2_Linux_x86_install-rpm_en-US.tar.gz.mirrorlist
(from the downloads page click on info carefully hidden in the Download 'button') 


I guess it would be OpenOffice's config.  By configs i mean the whole 
user-profile
http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12426
but i think it might be better to install LibreOffice as though it was a 
parallel installation alongside your existing OOo
http://wiki.documentfoundation.org/Installing_in_parallel

I just have a feeling that your fresh new LO might be reading your old OOo profile and there might be an Extension/Add-on in there that disagrees with LO. 
Regards from

Tom :)


--- On Mon, 30/4/12, Anta...@zimage.com  wrote:

From: Anta...@zimage.com
Subject: Re: [libreoffice-users] Unable to start my newly installed LibreOffice 
v3.5.2 programs.
To: users@global.libreoffice.org
Date: Monday, 30 April, 2012, 22:44

On Mon, Apr 30, 2012 at 10:40:14PM +0100, Tom Davies wrote:

Hi :)
I'm not sure why you're Xp one is crashing.  Did you use the same
installer that you used for the Win7 machine?  If not then it might be
worth trying that one or just check that the download didn't go
wrong.  Can you check the md5sum or sha or whatever?

No, it was a new download. If the one at home was bad, then it wouldn't
finish/fail installation, right? I will check its MD5sum. What's the
correct one?


Even a new install will pick up on an old config folder such as your old 
configs for OpenOffice.org.  Sometimes the config folder can be a bit wonky on 
a fresh release (although it's about a year since someone last mentioned 
experiencing that) so renaming the user profile can be a good idea even on a 
fresh new install if things seems a bit wrong.

Which configs? OpenOffice's? Remember, this is my first LibreOffice
install.


You can find a list of fixes and things from the main wiki-page
http://wiki.documentfoundation.org/Main_Page
but they just tend to be from 1 minor point-release to the next.  I couldn't 
find the release notes.

Thanks.




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



Re: [libreoffice-users] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread Ant
On Mon, Apr 30, 2012 at 07:56:58PM -0400, webmaster-Kracked_P_P wrote:
 
 I just remembered something with the last clean install for XP and
 LO.  This was for 3.4.1[or 3.4.2?] and XP.
 
 I had to install LO twice in a row, WITH NO uninstall in between.  I
 do not know why that happened, but it happened to me twice.  BUT,
 the last time I installed 3.4.4, or was it 3.4.5, on XP/pro I did
 not have any issues.  There was just something in the XP system[s] I
 was dealing with that had issues and not all of what was to be
 installed was installed properly.  The second install, which was a
 repair finished the install properly.  I do not know if it was a
 problem for XP or for LO or a combination of both, but the second
 install [without an uninstall] fixed the problem and it worked great
 from there on and the installing for the next version[s] worked
 fine.
 
 I really prefer people try the most stable version of LO, which
 currently is 3.4.6, before they go to the most cutting edge version,
 which currently is 3.5.2.

OK, why did LO's web site pick v3.5.2 on 
http://www.libreoffice.org/download/ then? 
http://www.libreoffice.org/download/?type=win-x86lang=en-US says v3.5.2 
is recommened. I thought this was the stable latest version! Ugh.

-- 
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] Unable to start my newly installed LibreOffice v3.5.2 programs.

2012-04-30 Thread webmaster-Kracked_P_P

On 04/30/2012 08:03 PM, Ant wrote:

On Mon, Apr 30, 2012 at 07:56:58PM -0400, webmaster-Kracked_P_P wrote:

I just remembered something with the last clean install for XP and
LO.  This was for 3.4.1[or 3.4.2?] and XP.

I had to install LO twice in a row, WITH NO uninstall in between.  I
do not know why that happened, but it happened to me twice.  BUT,
the last time I installed 3.4.4, or was it 3.4.5, on XP/pro I did
not have any issues.  There was just something in the XP system[s] I
was dealing with that had issues and not all of what was to be
installed was installed properly.  The second install, which was a
repair finished the install properly.  I do not know if it was a
problem for XP or for LO or a combination of both, but the second
install [without an uninstall] fixed the problem and it worked great
from there on and the installing for the next version[s] worked
fine.

I really prefer people try the most stable version of LO, which
currently is 3.4.6, before they go to the most cutting edge version,
which currently is 3.5.2.

OK, why did LO's web site pick v3.5.2 on
http://www.libreoffice.org/download/ then?
http://www.libreoffice.org/download/?type=win-x86lang=en-US says v3.5.2
is recommened. I thought this was the stable latest version! Ugh.


That is a question many of us wonder.

It is not ready for business, but if a business user sees this, he/she 
might download it and try it instead of looking closer for the other 
possible downloads and such.


Many of us do not like the new download system that decides for you 
which version is displayed for you to download, and how much work it is 
to download any other version.


But I am not on that list of people who decide such things.



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