Re: [libreoffice-users] Base - No SDBC driver found!!

[Ian Whitfield]

On 27/01/2012 19:36, drew wrote:
This is a 650Meg file using the embedded db engine, right. The file is 
usable on other machines, but not on the Mint based machine you need 
it on and this stopped working after the most recent update of the OS 
(to version 12) - do I have that correct? If so one quick question - 
can you run any other Base files using an embedded db on that machine, 
since the upgrade? Thanks //drew Actually one more - Do you have skype? 


Hi Drew

Thanks for the reply.

I originally developed my DB in OO about 6 years back and have been 
using it in OO since then. I've always used the embedded engine. When LO 
'forked' away from OO I tried that but could never get my Database to 
run - it would just crash Base whereas it was still working in OO. As 
each version of LO came out I gave it another try always with the same 
results. About a month or two back with some suggestions from the Forum 
I moved my DB to LO and re-developed my front-end Form and it worked!! 
But I ran into another problem which escapes me right now so moved back 
to OO.


With my latest upgrade to Mint 12 KDE I had a problem that LO would not 
even start. So I installed OO again and it ran OK BUT I had problems 
with it not saving data. So I removed OO and re-installed LO (from the 
LO WebSite) and this is where I sit now with the "No SDBC driver found" 
error.


I have no other DB to try but yesterday I found an old backup of my 
Database from about a year ago and tried to open that and got the same 
SDBC error. I can however create a new database in LO with no problems. 
My file is 640Mb in size and if I look at it with an un-zip program I 
can "see" all the contents.


Yes - I am on skype - 'ianzs6cdx' (But only Keyboard-to-Keyboard as I 
have not had a chance to get my microphone working in Mint 12 yet!!)


Thanks a lot.
--
Ian Sig






*/_Ian Whitfield_/*
ZS6CDX

*Pretoria, South Afric*a
*Tel* - +27 (0)12 817 2001
*Cell* -+27 (0)82 573 9142
*FAX* - +27 (0)86 651 4844
*Skype* - ianzs6cdx, also on Facebook
*SnailMail* - Box 72226, Lynnwood Ridge 0040, South Africa
/
(No trees were harmed in the production of this message, however a
large number of re-cycled electrons were temporarily inconvenienced) /

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] LWP documents

[soumalya ray]

i was just wondering-there are so many file formats in this world.if this
is the case now,what was the picture 5-10 years back!!its a total chaos.

On 28 January 2012 12:40, Jay Lozier  wrote:
>
> Can you post the file on nabble? A brief check indicates that *.lwp files
> should open in LO/OOo.
>
> --
> Jay Lozier
> jsloz...@gmail.com
>
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette 
> List archive: 
> http://listarchives.**libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>


-- 
Dr soumalya ray   
MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine)
Skype: som3776 | Twitter: @docbkp 

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] LWP documents

[Jay Lozier]

On 01/26/2012 06:30 PM, Gregory Forster wrote:
How do I open LotusWord Pro documents?  When I click on the document 
in Windows Explorer, I get a blank screen.  When I enter LibreOffice 
and open the document, I get a blank screen. In LibreOffice, I 
File/Open, change the file selection to Lotus WordPro document 
(*.lwp), select the file and still get a blank screen.


Greg

Can you post the file on nabble? A brief check indicates that *.lwp 
files should open in LO/OOo.


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


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

Re: [libreoffice-users] capitalization

[Jay Lozier]

On 01/27/2012 06:39 PM, lee wrote:

Hi,

why does LO change words I type to begin with a capital letter instead
of the small letter I typed, and how do I prevent that? It´s a bug that
needs to be fixed ...

AFAIK the normal capitalization is determined by the language settings. 
To reset the options go to Tool>>AutoCorrection Options>>Options.


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

[lee]

Hi,

why does LO change words I type to begin with a capital letter instead
of the small letter I typed, and how do I prevent that? It´s a bug that
needs to be fixed ...

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] LWP documents

[Gregory Forster]

How do I open LotusWord Pro documents?  When I click on the document in 
Windows Explorer, I get a blank screen.  When I enter LibreOffice and 
open the document, I get a blank screen. In LibreOffice, I File/Open, 
change the file selection to Lotus WordPro document (*.lwp), select the 
file and still get a blank screen.


Greg

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: what is the alternative of countifs function in libreoffice?

[soumalya ray]

its really time consuming.is there any other way to achieve this?
regards,

On 27 January 2012 23:57, Andreas Säger  wrote:

>
> Create a calculated field with nothing but a reference to the field you
> need twice.
>
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette 
> List archive: 
> http://listarchives.**libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>



-- 
Dr soumalya ray   
MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine)
Skype: som3776 | Twitter: @docbkp 

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

[sonic]

HI,
i'm facing a problem which doing mailmerge without using BASE to registered
to the data source.
i did successfully do it with base but now i do not wan to using base to
registered the data from spreadsheet table librecalc  because i wan to edit
the spreadsheet data table easily for me to remove or del or update new
data...
may i know is there any solutions TQ
i have try using file -> wizard-> address data souirce-> other external data
source  -> no SDBC driver found 

--
View this message in context: 
http://nabble.documentfoundation.org/create-mailmerge-with-spreadsheet-librecalc-without-using-libre-base-pls-help-how-to-do-it-TQ-tp3695185p3695185.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] displaying the result of pageNum + 1

[Dan Lewis]

On Fri, 2012-01-27 at 10:31 -0500, william drescher wrote:
> In the footer of a faxed document I want to display:
> 
> This fax continues on page x
> 
> where x is to be the current page number + 1
> 
> Can I do this, how ?
> 
> Thanks in advance,
> 
> bill
> 
> 

In the footer, enter the text you want: "This fax continues on page "
without the quotes. Please note that there is a space after the word
"page". Then use the Control+F2 key combination to open the Fields
dialog. Click the Document tab. Click "Page" in the Type list. Then
click "Page numbers" in the Select list. Select "Arabic (1 2 3)". Now
enter the number 1 in the Offset box. Click Insert, and then click
Close.

--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] LO Base - calculating dates

[cbeckmore]

Hi,

I'm a very basic Base user.  Can't seem to find any info on having Base
calculate a date in a Table.  I want to enter the date of a Lease Agreement;
follow up is required at 6 months and 12 months, it would be nice to have
these dates automatically calculated

I'm hoping I can set this up directly in the Table; or do I need to make a
query?

If I need to make a query, how do I enter it into the form?  Currently these
dates are part of a subform in datasheet format.

Thanks in advance for your help,

CB

--
View this message in context: 
http://nabble.documentfoundation.org/LO-Base-calculating-dates-tp3694844p3694844.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] displaying the result of pageNum + 1

[william drescher]

In the footer of a faxed document I want to display:

This fax continues on page x

where x is to be the current page number + 1

Can I do this, how ?

Thanks in advance,

bill


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

Re: [libreoffice-users] Re: LibreOffice Calc: Update External Link Question

[Thomas Damratowski]

Links work correctly for me.
Running
Windows 7 Ultimate
LibreOffice 3.4.5

On Fri, Jan 27, 2012 at 4:29 PM, Steve Smith  wrote:

> Understand linking, I think.  My question is updating the link.
>
> If the source spreadsheet is not opened when a link to external file is
> updated (Edit -> Links... -> Update), I receive a #REF! error.
>
> Thanks!
>
> -Original Message-
> >From: Andreas Säger 
> >Sent: Jan 27, 2012 2:56 PM
> >To: users@global.libreoffice.org
> >Subject: [libreoffice-users] Re: LibreOffice Calc: Update External Link
> Question
> >
> >Am 27.01.2012 21:02, Steve Smith wrote:
> >> I have a series of spreadsheets with external links to other
> spreadsheets.  The link will not update unless the spreadsheet the link
> references is open.
> >>
> >> Is that the expected/desired response of the developers?
> >>
> >>
> >>
> >There are 5 different ways to link spreadsheet files.
> >
> >
> >--
> >For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> >Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> >Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> >List archive: http://listarchives.libreoffice.org/global/users/
> >All messages sent to this list will be publicly archived and cannot be
> deleted
>
>
> Steven H. Smith
> 913.290.1163
>
> "Is there, in all republics, this inherent and fatal weakness?
> Must a government, of necessity, be too strong for the liberties
> of its own people, or too weak to maintain its own existence?"
>
> Abraham Lincoln
> Message to Congress in Special Session
> July 4, 1861
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: LibreOffice Calc: Update External Link Question

[Steve Smith]

Understand linking, I think.  My question is updating the link. 

If the source spreadsheet is not opened when a link to external file is updated 
(Edit -> Links... -> Update), I receive a #REF! error.

Thanks!

-Original Message-
>From: Andreas Säger 
>Sent: Jan 27, 2012 2:56 PM
>To: users@global.libreoffice.org
>Subject: [libreoffice-users] Re: LibreOffice Calc: Update External Link 
>Question
>
>Am 27.01.2012 21:02, Steve Smith wrote:
>> I have a series of spreadsheets with external links to other spreadsheets.  
>> The link will not update unless the spreadsheet the link references is open.
>>
>> Is that the expected/desired response of the developers?
>>
>>
>>
>There are 5 different ways to link spreadsheet files.
>
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted


Steven H. Smith
913.290.1163

"Is there, in all republics, this inherent and fatal weakness?
Must a government, of necessity, be too strong for the liberties 
of its own people, or too weak to maintain its own existence?"

Abraham Lincoln
Message to Congress in Special Session
July 4, 1861

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 Calc: Update External Link Question

[Andreas Säger]

Am 27.01.2012 21:02, Steve Smith wrote:

I have a series of spreadsheets with external links to other spreadsheets.  The 
link will not update unless the spreadsheet the link references is open.

Is that the expected/desired response of the developers?




There are 5 different ways to link spreadsheet files.


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

[libreoffice-users] Re: Problem printing an .xls file

[Tinkerer]

It prints fine on my iMac using LO 3.5rc, with a Canon 4700 printer.
All the lines are present and there is a 17mm margin on both sides.

Tink.

--
View this message in context: 
http://nabble.documentfoundation.org/Problem-printing-an-xls-file-tp3693933p3694406.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] LibreOffice Calc: Update External Link Question

[Steve Smith]

I have a series of spreadsheets with external links to other spreadsheets.  The 
link will not update unless the spreadsheet the link references is open.

Is that the expected/desired response of the developers?



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Window focus bug when importing a file into Calc

[Fabian Rodriguez]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi

Before reporting this as a bug I wanted to know if Mac and Gnu/Linux
users can reproduce it

The problem: When importing a text file into Calc (eg. CSV), the import
dialog does not steal focus as expected

This only happend when LibO is already open in the background with
another document. As a result, on a busy desktop, the window does not
show up and it can be interpreted as if nothing happened.

Steps to reproduce in Windows Libo 3.5rc2:

1) Open any valid document with LibO, move it to background/non visible
screen (when in multiple screen setup)
2) Create a text file with anything in it
3) While having the explorer on top of all application, "Open With.."
the newly created file with Calc
4) A window asking questions to finish the import will show up *under*
the current file explorer window

Thanks for any confirmations.

F.


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

iEYEARECAAYFAk8i/AYACgkQfUcTXFrypNVKaQCg4io1+EWJiJSOqLFbxx8aso9h
KcwAoPFDQrSecfCIJt76SGrAJY//FA/N
=F/7p
-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: Problem printing an .xls file

[Thomas Damratowski]

Yes, the right most vertical line is missing. Sorry about that.

2012/1/27 Don C. Myers 

> I'm sorry! Ubuntu 11.10 with LibreOffice 3.4.5 downloaded from LibreOffice.
>
> On 01/27/2012 01:28 PM, Maurice Batey wrote:
> > On Fri, 27 Jan 2012 13:01:18 -0500, Don C. Myers wrote:
> >
> >>  it prints fine except there is no left hand margin.
> >   Windows, Linux, Don?
> >
>
> --
>
> *~~*
> Don C. Myers
> e-PRO Certified by the National Association of Realtors
> Manager, Farm and Rural Property Division
> *Coldwell Banker University Realty
> *126 East Foster Avenue, State College, PA 16801
> Office Phone: 814-237-6543 Fax: 814-237-6502
> Home Phone: 814-422-8111 Cell Phone: 814-571-9518
> Visit the Farm and Rural Property Division Web Site at
> _www.cbur-ruralproperty.com 
> _View Don's Farm Web Site at www.myersfarm.com 
> *~~*
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: [libreoffice-users] Re: Problem printing an .xls file

[Don C. Myers]

I'm sorry! Ubuntu 11.10 with LibreOffice 3.4.5 downloaded from LibreOffice.

On 01/27/2012 01:28 PM, Maurice Batey wrote:
> On Fri, 27 Jan 2012 13:01:18 -0500, Don C. Myers wrote:
>
>>  it prints fine except there is no left hand margin.
>   Windows, Linux, Don?
>

-- 

*~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Office Phone: 814-237-6543 Fax: 814-237-6502
Home Phone: 814-422-8111 Cell Phone: 814-571-9518
Visit the Farm and Rural Property Division Web Site at
_www.cbur-ruralproperty.com 
_View Don's Farm Web Site at www.myersfarm.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: Problem printing an .xls file

[Maurice Batey]

On Fri, 27 Jan 2012 13:01:18 -0500, Don C. Myers wrote:

>  it prints fine except there is no left hand margin.

  Windows, Linux, Don?

-- 
/\/\aurice 



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: what is the alternative of countifs function in libreoffice?

[Andreas Säger]

Am 27.01.2012 19:04, soumalya ray wrote:

sorry;could not understand the meaning of 'duplicate the field'.could you
explain a bit more please?
regards,



Create a calculated field with nothing but a reference to the field you 
need twice.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Problem printing an .xls file

[Maurice Batey]

On Fri, 27 Jan 2012 13:02:01 -0500, Thomas Damratowski wrote:

> the rightmost horizontal line is missing.

   Not rightmost *vertical* line?

-- 
/\/\aurice 



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: what is the alternative of countifs function in libreoffice?

[soumalya ray]

sorry;could not understand the meaning of 'duplicate the field'.could you
explain a bit more please?
regards,

On 27 January 2012 17:05, Andreas Säger  wrote:

> Am 27.01.2012 11:23, Pedro wrote:
>
>  I'm almost sure that you can't do that in the LibreOffice Pivot Tables
>> (unless there are some undocumented features that I'm not aware of? )
>>
>>
> You can select multiple functions for the same data field. The function
> selector is a multi-select list box.
> Indeed, you can not add the same function twice this way. The work-around
> for this is a duplicate of the original field in the source table.
>
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette 
> List archive: 
> http://listarchives.**libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>


-- 
Dr soumalya ray   
MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine)
Skype: som3776 | Twitter: @docbkp 

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Problem printing an .xls file

[Thomas Damratowski]

Worked fine for me, except that the rightmost horizontal line is missing.
Running
Windows 7 Ultimate
LO 3.4.5
HP Officejet 6500A Plus Printer

2012/1/27 Maurice Batey 

> The file referenced below prints correctly under OpenOffice Writer
> 3.2.1, but not with LO 3.4.5.
>  (Tried on 2 different PC's, two different printers.)
>
> Under LO 3.4.5, although a Print Preview is complete, the actual printed
> page is missing several inches of text on the right.
>  (The rightmost column that is correctly printed has the header
> "H.C. Points".
>All that appears to the right of that are continuations of the
> horizontal rulings, and the "Exp and (below) "We" text of the rest of
> the document.)
>
> Before I raise this in a Bug report, could someone here confirm that
> they have the same problem, please?
>
>   http://dl.dropbox.com/u/10969499/scorecard.xls
>
> --
> /\/\aurice
>(Retired in Surrey, UK) Registered Linux User #487649
>  Linux Mandriva 2010.2 32-bit  PowerPack (i686 kernel)
>  KDE 4.5.2  Virtualbox 4.0.6   Firefox 4.0   KMail 1.13.5
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.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] Problem printing an .xls file

[Don C. Myers]

Hi Maurice,

When I print it on a Samsung ML-1710 laser, it prints fine except there
is no left hand margin. The cells in Column A are right against the left
edge of the paper. I saved it in ods format, and had the same thing.
Then I inserted a new column A, so that all of the other columns moved 1
column to the right. I made the new column .49 inches wide, and it
printed fine.

Don

On 01/27/2012 12:25 PM, Maurice Batey wrote:
> The file referenced below prints correctly under OpenOffice Writer
> 3.2.1, but not with LO 3.4.5.   
>   (Tried on 2 different PC's, two different printers.)
>
> Under LO 3.4.5, although a Print Preview is complete, the actual printed
> page is missing several inches of text on the right.
>   (The rightmost column that is correctly printed has the header 
> "H.C. Points". 
> All that appears to the right of that are continuations of the
> horizontal rulings, and the "Exp and (below) "We" text of the rest of
> the document.)
>
> Before I raise this in a Bug report, could someone here confirm that
> they have the same problem, please?
>
>http://dl.dropbox.com/u/10969499/scorecard.xls
>

-- 


**


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: off-list Re: Re: Re: How to migrate OpenOfficec Writer settings into LinbreOffice Writer

[Maurice Batey]

On Fri, 27 Jan 2012 14:30:39 +, Tom Davies wrote:

> Did you manage to solve the problem in the end?
> Did you get any good answers from the LO mailing list?
> Was the UserProfile page any help?

  Yes, yes, yes - thanks to all!

-- 
/\/\aurice 



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Base - No SDBC driver found!!

[drew]

On Fri, 2012-01-27 at 14:16 +0200, Ian Whitfield wrote:
> OK!!! I've cracked the permissions problem!!!
> 
> By using Dolphin>Root Actions>Change Permissions I've been able to make 
> the file "open" again. (I wonder why this works but nothing else???)
> 
> *BUT* - That leaves me back with my original problem. When I try to open 
> my Database I get the error "No SDBC driver found".
> 
> This is now urgent and I must get an answer to this.
> 
> Thanks guys
> 
Hi Ian

Sorry but I need to catch up.

This is a 650Meg file using the embedded db engine, right.
The file is usable on other machines, but not on the Mint based machine
you need it on and this stopped working after the most recent update of
the OS (to version 12) - do I have that correct?

If so one quick question - can you run any other Base files using an
embedded db on that machine, since the upgrade?

Thanks

//drew

Actually one more - Do you have skype?






-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Problem pasting spreadsheet cells into Impress

[Tanstaafl]

On 2012-01-26 5:05 PM, Cor Nouws  wrote:

Hi,
Tanstaafl wrote (13-01-12 22:17)


Whenever I try to copy some cells from a spreadsheet and paste the into
an Impress Presentation Libreoffice (and Openoffice used to do the same
thing) totally locks up goes into never-never land, and I have to kill
it.


No problem for me in 3.5.0rc1 (only I tested now).
So please give more details, as others to help finding where the problem
might be.


Any chance you could try in a stable version?

We are using 3.4.3, 3.4.4 and 3.4.5 (haven't updated all yet)...

this was also a problem in older version going all the way back to 
Openoffice days...


A simple 'paste' (or Ctrl-V) results in the problem, but 'Paste Special' 
and clicking OK (keeping the default selection of calc8) works fine...


I really don't know what other details I can give... these are all 
standard installs, on Windows XP Pro sp3 fully patched (I thought I 
already gave those details though - if not, my bad)...


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 printing an .xls file

[Maurice Batey]

The file referenced below prints correctly under OpenOffice Writer
3.2.1, but not with LO 3.4.5.   
  (Tried on 2 different PC's, two different printers.)

Under LO 3.4.5, although a Print Preview is complete, the actual printed
page is missing several inches of text on the right.
  (The rightmost column that is correctly printed has the header 
"H.C. Points". 
All that appears to the right of that are continuations of the
horizontal rulings, and the "Exp and (below) "We" text of the rest of
the document.)

Before I raise this in a Bug report, could someone here confirm that
they have the same problem, please?

   http://dl.dropbox.com/u/10969499/scorecard.xls

-- 
/\/\aurice 
(Retired in Surrey, UK) Registered Linux User #487649
  Linux Mandriva 2010.2 32-bit  PowerPack (i686 kernel) 
  KDE 4.5.2  Virtualbox 4.0.6   Firefox 4.0   KMail 1.13.5


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Base - No SDBC driver found!!

[Heinrich Stoellinger]

My Linux-Mint is 32-bit...
Will try your suggestions. Thanks a lot
Regards from Salzburg (all snowed in!)
H

On Fri, 27 Jan 2012 17:39:55 +0100, Alexander Thurgood 
 wrote:


Le 27/01/12 16:51, Heinrich Stoellinger a écrit :

Hi Heinrich,


I have LO 3.3 installed on Windows/Vista and Linux-Mint-Lisa. The native
MySQL-Connector
worked flawlessly - at least for what I use it. As a "fall-back" I still
use the Vista-
System. But, when going to 3.5.0-RC2 today, I saw that - as I had
already noticed earlier
on, the connector cannot be activated. ODBC works - well, kind of!


Is your Linux Mint 64bit or 32bit ?
If it is 32bit, then try the Linux connector here :

http://extensions.libreoffice.org/

but it seems to be down at the moment or not responding (overloaded ??)

It is better to remove the old connector from your 3.5 configuration
first (if it was either copied over automatically or you installed it
yourself).




I have never built anything from source in LO. Could you point me in the
right direction,
please? Maybe I find the time to have a go.


If you have a 64bit Mint then you will need a 64bit connector which
means compiling from scratch.

The same goes for Windows, except you will also need to download the
mysql C connector library (32bit) from the mysql web site and put it
somewhere where the local git repository for the LO source code can
acess it.

The best place to start is the Developer wiki page :

http://www.libreoffice.org/get-involved/developers/

This will get you started with the basic setup of your development
environment. You can not build the mysql connector without having the
complete LO source as a local git repository on the machine that does
the building.

My personal experience was one of pain on MacOSX, and it still gets
broken rather easily on that, and yet one of ease on Linux, which is
hardly surprising since that is the OS of choice for most of the
developers involved in the project.


Alex





--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Mail Merge print from Query instead of table.

[Mark Stanton]

> I thought it was better practice to use Queries than Tables to build
> report/forms/mail-merge from and then print the result?

That's his whole point.  Mailmerge doesn't appear to be able to use queries.

Mark Stanton
One small step for mankind...



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Not printing Base fields

[Mark Stanton]

> Hidden fields are the answer.

Ah, yes.  But that then puts me in your boat, not being able to mailmerge 
from a query.

I suppose, if the view things turns out not to work, a 
function/produced/thing could be written that ran the query, exported the 
results to a csv file with a name that had already been registered for the 
mailmerge wizard, and then run the mailmerge.

Bit of a long way round :-(

Mark Stanton
One small step for mankind...



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Base - No SDBC driver found!!

[Alexander Thurgood]

Le 27/01/12 16:51, Heinrich Stoellinger a écrit :

Hi Heinrich,

> I have LO 3.3 installed on Windows/Vista and Linux-Mint-Lisa. The native
> MySQL-Connector
> worked flawlessly - at least for what I use it. As a "fall-back" I still
> use the Vista-
> System. But, when going to 3.5.0-RC2 today, I saw that - as I had
> already noticed earlier
> on, the connector cannot be activated. ODBC works - well, kind of!

The old connector has been reported as working again on Windows with
3.5RC2, see the bug report :

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


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: Base - No SDBC driver found!!

[Alexander Thurgood]

Le 27/01/12 16:51, Heinrich Stoellinger a écrit :

Hi Heinrich,

> I have LO 3.3 installed on Windows/Vista and Linux-Mint-Lisa. The native
> MySQL-Connector
> worked flawlessly - at least for what I use it. As a "fall-back" I still
> use the Vista-
> System. But, when going to 3.5.0-RC2 today, I saw that - as I had
> already noticed earlier
> on, the connector cannot be activated. ODBC works - well, kind of!

Is your Linux Mint 64bit or 32bit ?
If it is 32bit, then try the Linux connector here :

http://extensions.libreoffice.org/

but it seems to be down at the moment or not responding (overloaded ??)

It is better to remove the old connector from your 3.5 configuration
first (if it was either copied over automatically or you installed it
yourself).



> I have never built anything from source in LO. Could you point me in the
> right direction,
> please? Maybe I find the time to have a go.

If you have a 64bit Mint then you will need a 64bit connector which
means compiling from scratch.

The same goes for Windows, except you will also need to download the
mysql C connector library (32bit) from the mysql web site and put it
somewhere where the local git repository for the LO source code can
acess it.

The best place to start is the Developer wiki page :

http://www.libreoffice.org/get-involved/developers/

This will get you started with the basic setup of your development
environment. You can not build the mysql connector without having the
complete LO source as a local git repository on the machine that does
the building.

My personal experience was one of pain on MacOSX, and it still gets
broken rather easily on that, and yet one of ease on Linux, which is
hardly surprising since that is the OS of choice for most of the
developers involved in the project.


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

Re: [libreoffice-users] Re: Base - No SDBC driver found!!

[Heinrich Stoellinger]

Hi Alex,
I have LO 3.3 installed on Windows/Vista and Linux-Mint-Lisa. The native 
MySQL-Connector
worked flawlessly - at least for what I use it. As a "fall-back" I still use 
the Vista-
System. But, when going to 3.5.0-RC2 today, I saw that - as I had already 
noticed earlier
on, the connector cannot be activated. ODBC works - well, kind of!
I have never built anything from source in LO. Could you point me in the right 
direction,
please? Maybe I find the time to have a go.
Regards
H

On Fri, 27 Jan 2012 15:53:15 +0100, Alexander Thurgood 
 wrote:


Le 27/01/12 14:52, Heinrich Stoellinger a écrit :

Hi Heinrich,


I can only agree with you. The only connector that works really well is the
native one. Using ODBC is "buggy" and the Java-Connector is (for the
Java state
of affairs!) so slow!


The old mysql connector versions (i.e. the Oracle ones) should now work
again on Windows, at least in 3.5RC2 (if Fridrich Strba's changes have
been integrated, which they should have been by now).

I am not building on Windows, and so I won't be providing a mysql
connector based on current master code source. I only provide for Mac
and (Ubuntu) Linux 32bit from master (and not from previous versions of LO).

But I don't get what all this has to do with HSQLDB, which was Ian's
initial problem ?


Alex







--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Not printing Base fields

[Oldlace]

Hi
Hidden fields are the answer.

See http://www.freesoftwaremagazine.com/articles/mail_merge_openoffice_org
and the section about hidden fields is adjacent to Figure 2 in the text

Peter Lacey


On 27 January 2012 15:20, Mark Stanton  wrote:

> I *want* to omit empty fields from my report.
>
> I'm using the report writer to print address labels (sheets really,
> but it's largely the same thing).
>
> I want to print name, company, address lines 1, 2 & 3, &tc.
> If there's no company name I want the whole line omitted.  I don't
> mean don't print any text, I mean omit the whole line, so there is no
> space between name and the first address line.  Is this possible with
> LO Base?
>
> Mark Stanton
>
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.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: Mysterious spacing problem

[Jay Lozier]

On 01/27/2012 05:21 AM, Séamas Ó Brógáin wrote:

Jay wrote:


Is this a screen resolution or a printing problem. Could you specify
which font(s) are troublesome?
Also, I forgot - what OS are you using?


GNU/Linux (Ubuntu 11.10).

Various fonts, including Plantin, but mostly my own (work in progress).
In all of them I have verified the character widths in Fontforge.

The fault appears on screen, and I must confess that I had not thought
of printing a test. In doing so now, however, I think I have discovered
where the problem lies. In what I use as normal editing mode (what Open
Office and Libre Office mysteriously call “web layout”) the problem
occurs; when I change to “print layout” it disappears. Likewise, when I
print a file the problem is not there.
Good catch, web and print layouts are different. Web layout assumes the 
primary/only viewing will be on screen not on paper. Thus the spacing is 
different to make it easier to read on screen, at least that is the theory.


Personally I have not found print layout to be difficult to read on 
screen with a large monitor.


Thanks to your question I now know where the problem lies, and indeed it
is not such a serious one if I know of a way around it, and can be sure
that texts will print properly.







--
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: Mail Merge print from Query instead of table.

[oldlace]

Thanks folks for your replies.

Am now going down the views route as on a very quick test it seems to
resolve the problem.

It is these strange "quirks" that can have you scratching your head for much
longer than they deserve.

--
View this message in context: 
http://nabble.documentfoundation.org/Mail-Merge-print-from-Query-instead-of-table-tp3690941p3693564.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] Not printing Base fields

[Mark Stanton]

I *want* to omit empty fields from my report.

I'm using the report writer to print address labels (sheets really, 
but it's largely the same thing).

I want to print name, company, address lines 1, 2 & 3, &tc.
If there's no company name I want the whole line omitted.  I don't 
mean don't print any text, I mean omit the whole line, so there is no 
space between name and the first address line.  Is this possible with 
LO Base? 

Mark Stanton



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Base question - report exception on faultless query

[Fernand Vanrie]

On 27/01/2012 14:45, Mark Stanton wrote:

Mark,

google for "parametered" query's in Openoffice they open with a input dialog

LO -OO likes to uses unddercase  for Tablenames and uppercase for 
Fieldnames (avoid to use "" and or '')


Greetz

Fernand

Hi Dan,

Ok, here's the query.

SELECT  CONCAT(people.Title, ' ', LTRIM(people.Firstname), ' ',
LTRIM(people.Surname)) AS PersonName,
 people.PersonId, issues.iId AS iiID, issues.Issue,
people.LastIssue,
 subscription.iId AS subiId, subscription.Type,
subscription.AdType,
 subscription.Delivery, subscription.Issues,
subscription.StartingAt,
 address.Company, Address1, Address2, Address3, City,
Area, Country, PostalCode,
 sent.iId AS SendId, sent.NumberSent,
 textvalues.Text
FROMpeople
JOIN subscription   ON people.iId   = subscription.iPeopleId
JOIN sent   ON sent.iSubId  = subscription.iId
JOIN issues ON sent.iIssueId= issues.iId
JOIN addressON people.iId   = address.iaParentId
JOIN textvalues ON textvalues.Id= subscription.Type
WHERE issues.Issue = '70' AND textvalues.Field = 'CBOSUBTYPE'
ORDER BYFirstName, Surname

It's producing an address list of subscribers to the next (here
hard-coded as '70', until I find out how to pass a parameter to a
query from a report, or at least in conjunction with a report) to
print address sheets.  It's originally from my own (Visual FoxPro)
application that runs our magazine subscriptions.  It's now "in
transition" to LO :-)

Regards
Mark Stanton
One small step for mankind...






--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Base - No SDBC driver found!!

[Don C. Myers]

Hi,

Has this database been registered with LibreOffice? go to 
Tools>Options>LibreOffice Base>Databases


Don

On 01/27/2012 08:37 AM, Ian Whitfield wrote:

OK - I've been doing some Googling on this problem.

It seems to be known about and is listed as 'Bug 32948'.

Does anyone know what the current status of this bug is? Or seen as 
Alex Thurgood's name comes up a lot in the Bug Report does anyone have 
his eMail address so that we can get an update on this??


If it has NOT been fixed it makes Libre Office a NO-GO for anyone 
using Base on a regular basis (like me)!!!


Thanks guys.




--


**


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Mail Merge print from Query instead of table.

[Fernand Vanrie]

Query's are not working , Views (who are a kind of query's) are by LO 
seen as tables and act like that in mailmerge

Have provided a temporary work around for myself by creating temporary tables
from my Query and using these for my mail merge. However it would be much
less of a convoluted method if I was able to work directly with the query.
Any suggestions would be much appreciated.

--
View this message in context: 
http://nabble.documentfoundation.org/Mail-Merge-print-from-Query-instead-of-table-tp3690941p3693251.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: Mail Merge print from Query instead of table.

[Alexander Thurgood]

Le 26/01/12 17:54, oldlace a écrit :

Hi,

> If I print a mail merge form that is created from a* table*, then in the
> print dialogue the correct table is selected. This is what I expect to
> happen.
> However a mail merge form that is created from a valid *query* (that is
> based on multiple tables)  requires me to select the query to be used  when
> in the Print dialogue.


How about using a View (haven't tried it, so please don't flame me if it
doesn't work) ?

I seem to recall that there were some known bugs with mailmerge from
various db sources (CSV, Excel, Calc sheets for example, but perhaps
queries also fall within the same lame boat).

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: Base - No SDBC driver found!!

[Alexander Thurgood]

Le 27/01/12 14:52, Heinrich Stoellinger a écrit :

Hi Heinrich,

> I can only agree with you. The only connector that works really well is the
> native one. Using ODBC is "buggy" and the Java-Connector is (for the
> Java state
> of affairs!) so slow!

The old mysql connector versions (i.e. the Oracle ones) should now work
again on Windows, at least in 3.5RC2 (if Fridrich Strba's changes have
been integrated, which they should have been by now).

I am not building on Windows, and so I won't be providing a mysql
connector based on current master code source. I only provide for Mac
and (Ubuntu) Linux 32bit from master (and not from previous versions of LO).

But I don't get what all this has to do with HSQLDB, which was Ian's
initial problem ?


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: Base - No SDBC driver found!!

[Alexander Thurgood]

Le 27/01/12 14:37, Ian Whitfield a écrit :

Hi Ian,

> It seems to be known about and is listed as 'Bug 32948'.
> 

This bug is related to the Address Datasource wizard, not HSQLDB ?

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: Base - No SDBC driver found!!

[Alexander Thurgood]

Le 27/01/12 14:37, Ian Whitfield a écrit :

Hi Ian,

> OK - I've been doing some Googling on this problem.
> 
> It seems to be known about and is listed as 'Bug 32948'.
> 
> Does anyone know what the current status of this bug is? Or seen as Alex
> Thurgood's name comes up a lot in the Bug Report does anyone have his
> eMail address so that we can get an update on this??

That would be me, and you already have my e-mail address, since we have
previously exchanged comms on another db problem.

As I have just reported on the bug issue 32948, the Address Book
Datasource Wizard works for me with my most recent build of LO source
from master.


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

Re: [libreoffice-users] Base - No SDBC driver found!!

[Tom Davies]

Hi :)
It is going to take more than 1 more person to sort out Base.  We need to find 
a way of getting a whole load of people involved.  The BoD has decided to just 
sit&wait and is happy to leave it to chance and natural progression (ie waiting 
for devs to move beyond Writer and Calc towards the more interesting challenges 
presented by Base).  There is a bit more activity in OpenOffice.org so perhaps 
we should just wait and see if we can use whatever happens there!  LibreOffice 
has higher priorities than sorting out Base as Base is fine for most people 
most of the time apparently.  
Regards from
Tom :)


--- On Fri, 27/1/12, Heinrich Stoellinger  wrote:

From: Heinrich Stoellinger 
Subject: Re: [libreoffice-users] Base - No SDBC driver found!!
To: users@global.libreoffice.org
Date: Friday, 27 January, 2012, 14:23

Hi Tom,
I would if I could (ie. had the time...)
Regards H

On Fri, 27 Jan 2012 15:06:21 +0100, Tom Davies  wrote:

> Hi :)
> +1
> Attracting more devs to Base would be fantastic.Regards from
> Tom :)
>
>
>
> --- On Fri, 27/1/12, Heinrich Stoellinger  wrote:
>
> From: Heinrich Stoellinger 
> Subject: Re: [libreoffice-users] Base - No SDBC driver found!!
> To: users@global.libreoffice.org
> Date: Friday, 27 January, 2012, 13:52
>
> Hi,
> I can only agree with you. The only connector that works really well is the
> native one. Using ODBC is "buggy" and the Java-Connector is (for the Java 
> state
> of affairs!) so slow!
> It would be good to step up the priority of the connector (and Base as a 
> whole,
> ofcourse!)
> Regards
> Heinrich
>
> On Fri, 27 Jan 2012 14:37:34 +0100, Ian Whitfield  
> wrote:
>
>> OK - I've been doing some Googling on this problem.
>>
>> It seems to be known about and is listed as 'Bug 32948'.
>>
>> Does anyone know what the current status of this bug is? Or seen as Alex
>> Thurgood's name comes up a lot in the Bug Report does anyone have his
>> eMail address so that we can get an update on this??
>>
>> If it has NOT been fixed it makes Libre Office a NO-GO for anyone using
>> Base on a regular basis (like me)!!!
>>
>> Thanks guys.
>>
>>
>
>


-- 
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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

off-list Re: [libreoffice-users] Re: Re: How to migrate OpenOfficec Writer settings into LinbreOffice Writer

[Tom Davies]

Hi :)
Did you manage to solve the problem in the end?  Did you get any good answers 
from the LO mailing list?  Was the UserProfile page any help?
http://wiki.documentfoundation.org/Documentation/UserProfile
Regards from
Tom :)


--- On Mon, 23/1/12, Fridolin Gansheimer  
wrote:

From: Fridolin Gansheimer 
Subject: Re: [libreoffice-users] Re: Re: How to migrate OpenOfficec Writer 
settings into LinbreOffice Writer
To: users@global.libreoffice.org, "Maurice Batey" 
Date: Monday, 23 January, 2012, 14:56

?

On January 23, 2012 5:29:48 AM PST, Maurice Batey wrote:
> On Sun, 22 Jan 2012 15:38:21 -0500, webmaster for Kracked Press
> Productions wrote:
> 
> > Kompozer ... I use it to, and no where do I know will it allow me to
> > set it as the default package for displaying HTM/HTML files.
> 
>   Here in Mandriva KDE land: 
> 
> System Settings|File Associations|Text|Html|Add
> 
> -- 
> /\/\aurice 
>     
> 
> 
> -- 
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted

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

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

Re: [libreoffice-users] Base - No SDBC driver found!!

[Heinrich Stoellinger]

Hi Tom,
I would if I could (ie. had the time...)
Regards H

On Fri, 27 Jan 2012 15:06:21 +0100, Tom Davies  wrote:


Hi :)
+1
Attracting more devs to Base would be fantastic.Regards from
Tom :)



--- On Fri, 27/1/12, Heinrich Stoellinger  wrote:

From: Heinrich Stoellinger 
Subject: Re: [libreoffice-users] Base - No SDBC driver found!!
To: users@global.libreoffice.org
Date: Friday, 27 January, 2012, 13:52

Hi,
I can only agree with you. The only connector that works really well is the
native one. Using ODBC is "buggy" and the Java-Connector is (for the Java state
of affairs!) so slow!
It would be good to step up the priority of the connector (and Base as a whole,
ofcourse!)
Regards
Heinrich

On Fri, 27 Jan 2012 14:37:34 +0100, Ian Whitfield  
wrote:


OK - I've been doing some Googling on this problem.

It seems to be known about and is listed as 'Bug 32948'.

Does anyone know what the current status of this bug is? Or seen as Alex
Thurgood's name comes up a lot in the Bug Report does anyone have his
eMail address so that we can get an update on this??

If it has NOT been fixed it makes Libre Office a NO-GO for anyone using
Base on a regular basis (like me)!!!

Thanks guys.








--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Base - No SDBC driver found!!

[Tom Davies]

Hi :)
+1
Attracting more devs to Base would be fantastic.  
Regards from
Tom :)



--- On Fri, 27/1/12, Heinrich Stoellinger  wrote:

From: Heinrich Stoellinger 
Subject: Re: [libreoffice-users] Base - No SDBC driver found!!
To: users@global.libreoffice.org
Date: Friday, 27 January, 2012, 13:52

Hi,
I can only agree with you. The only connector that works really well is the
native one. Using ODBC is "buggy" and the Java-Connector is (for the Java state
of affairs!) so slow!
It would be good to step up the priority of the connector (and Base as a whole,
ofcourse!)
Regards
Heinrich

On Fri, 27 Jan 2012 14:37:34 +0100, Ian Whitfield  
wrote:

> OK - I've been doing some Googling on this problem.
>
> It seems to be known about and is listed as 'Bug 32948'.
>
> Does anyone know what the current status of this bug is? Or seen as Alex
> Thurgood's name comes up a lot in the Bug Report does anyone have his
> eMail address so that we can get an update on this??
>
> If it has NOT been fixed it makes Libre Office a NO-GO for anyone using
> Base on a regular basis (like me)!!!
>
> Thanks guys.
>
>


-- 
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Mail Merge print from Query instead of table.

[Tom]

Hi :)
I thought it was better practice to use Queries than Tables to build
report/forms/mail-merge from and then print the result?

I don't know if anyone has an answer to all this?
Regards from
Tom :)

--
View this message in context: 
http://nabble.documentfoundation.org/Mail-Merge-print-from-Query-instead-of-table-tp3690941p3693341.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] Base - No SDBC driver found!!

[Heinrich Stoellinger]

Hi,
I can only agree with you. The only connector that works really well is the
native one. Using ODBC is "buggy" and the Java-Connector is (for the Java state
of affairs!) so slow!
It would be good to step up the priority of the connector (and Base as a whole,
ofcourse!)
Regards
Heinrich

On Fri, 27 Jan 2012 14:37:34 +0100, Ian Whitfield  
wrote:


OK - I've been doing some Googling on this problem.

It seems to be known about and is listed as 'Bug 32948'.

Does anyone know what the current status of this bug is? Or seen as Alex
Thurgood's name comes up a lot in the Bug Report does anyone have his
eMail address so that we can get an update on this??

If it has NOT been fixed it makes Libre Office a NO-GO for anyone using
Base on a regular basis (like me)!!!

Thanks guys.





--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Base question - report exception on faultless query

[Mark Stanton]

Hi Dan,

Ok, here's the query.

SELECT  CONCAT(people.Title, ' ', LTRIM(people.Firstname), ' ', 
LTRIM(people.Surname)) AS PersonName, 
people.PersonId, issues.iId AS iiID, issues.Issue, 
people.LastIssue,
subscription.iId AS subiId, subscription.Type, 
subscription.AdType,
subscription.Delivery, subscription.Issues, 
subscription.StartingAt,
address.Company, Address1, Address2, Address3, City, 
Area, Country, PostalCode,
sent.iId AS SendId, sent.NumberSent,
textvalues.Text 
FROMpeople 
JOIN subscription   ON people.iId   = subscription.iPeopleId 
JOIN sent   ON sent.iSubId  = subscription.iId 
JOIN issues ON sent.iIssueId= issues.iId 
JOIN addressON people.iId   = address.iaParentId 
JOIN textvalues ON textvalues.Id= subscription.Type 
WHERE issues.Issue = '70' AND textvalues.Field = 'CBOSUBTYPE' 
ORDER BYFirstName, Surname

It's producing an address list of subscribers to the next (here 
hard-coded as '70', until I find out how to pass a parameter to a 
query from a report, or at least in conjunction with a report) to 
print address sheets.  It's originally from my own (Visual FoxPro) 
application that runs our magazine subscriptions.  It's now "in 
transition" to LO :-)

Regards
Mark Stanton
One small step for mankind...



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Base - No SDBC driver found!!

[Ian Whitfield]

OK - I've been doing some Googling on this problem.

It seems to be known about and is listed as 'Bug 32948'.

Does anyone know what the current status of this bug is? Or seen as Alex 
Thurgood's name comes up a lot in the Bug Report does anyone have his 
eMail address so that we can get an update on this??


If it has NOT been fixed it makes Libre Office a NO-GO for anyone using 
Base on a regular basis (like me)!!!


Thanks guys.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Mail Merge print from Query instead of table.

[oldlace]

Have provided a temporary work around for myself by creating temporary tables
from my Query and using these for my mail merge. However it would be much
less of a convoluted method if I was able to work directly with the query.
Any suggestions would be much appreciated.

--
View this message in context: 
http://nabble.documentfoundation.org/Mail-Merge-print-from-Query-instead-of-table-tp3690941p3693251.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] [Solved] Re: Windows parallel install

[Tom]

Hi :)
Ahh, fantastic!  Good work chaps :)
Thanks and regards from
Tom :)

--
View this message in context: 
http://nabble.documentfoundation.org/Windows-parallel-install-tp3692947p3693170.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: Windows parallel install

[Pedro]

Hi Tom


Tom wrote
> 
> Errr, which version of java is LibreOffice trying to use?  Is it trying to
> use something newer than java 6u24?
> 

It has nothing to do with Java. Manfred's suggestion solved it. It was a
Windows error (not reported by the RC installer though)

Thank you for your help, though ;)

Best regards,
Pedro

--
View this message in context: 
http://nabble.documentfoundation.org/Windows-parallel-install-tp3692947p3693144.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] Windows parallel install

[Manfred J. Krause]

Hi Tom,

On Fri, Jan 27, 2012 at 1:36 PM, Tom Davies wrote:
> HI :)
> Errr, which version of java is LibreOffice trying to use?  Is it trying to 
> use something newer than java 6u24?
> Regards from
> Tom :)
>
>
> --- On Fri, 27/1/12, Manfred J. Krause 
> googlemail.com> wrote:
>
> 
>
>> When i tried to run the program it is excruciatingly slow...
>>
>
> 

Not that I remember.
Maybe Pedro?
;)

mjk

-- 
Release Notes 3.5
http://wiki.documentfoundation.org/ReleaseNotes/3.5

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Windows parallel install

[Pedro]

Hi Manfred


Manfred J. Krause wrote
> 
> Maybe → http://support.microsoft.com/kb/324852/en-us
> 

Excellent suggestion! My bad for not looking it up before posting. That
error message sure does provide a tip (which is unusual in Windows :) )
This means that there is a problem with the RC installer since it didn't
provide the same error.


Manfred J. Krause wrote
> 
>> Does anybody use parallel instals in Windows?
> Yes.
> 

I know how to use it :) I was just curious if other people actually used
this :)

I have changed the permissions in Drive D: I have no idea what changed them
but then again, this is Windows...

It is working as expected now.

Thank you very much!

Best regards,
Pedro

--
View this message in context: 
http://nabble.documentfoundation.org/Windows-parallel-install-tp3692947p3693140.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: Windows parallel install

[Pedro]

Hi Tom ;)

Does this guide help at all?
> http://wiki.documentfoundation.org/Installing_in_parallel#Windows
> I think it needs a bit of work for the Windows part so if there is
> anything you can add that would be great!
>

TBH No :)
I have already fixed some of it (the instructions for Windows had some
"bugs")

Thanks anyway ;)

Regards,
Pedro


--
View this message in context: 
http://nabble.documentfoundation.org/Windows-parallel-install-tp3692947p3693117.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] Windows parallel install

[Tom Davies]

HI :)
Errr, which version of java is LibreOffice trying to use?  Is it trying to use 
something newer than java 6u24?
Regards from
Tom :)


--- On Fri, 27/1/12, Manfred J. Krause  
wrote:



> When i tried to run the program it is excruciatingly slow...
>



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] solution to hungarian crash on launch writer

[Tom Davies]

Hi :)
Do you know which version of Java 6?  Was it the 6u21 or a more recent version?

I think you mean in Windows?  If so you can check what versions of java are 
installed on the machine through the machine's Control Panel but you could also 
see through LibreOffice menus

Tools - Options - LibreOffice - Java

That route should work on most Operating Systems, not just Windows
Regards from
Tom :)


--- On Fri, 27/1/12, Tim Hatton  wrote:

From: Tim Hatton 
Subject: [libreoffice-users] solution to hungarian crash on launch writer
To: users@global.libreoffice.org
Date: Friday, 27 January, 2012, 10:57

This is my attempt to give something back

I dont know how to get this solution into the offical bug reporting libreoffice 
system  so could you please forward this solution to someone who does
thanks
Tim

on XP SP3

HUNGARIAN CRASH ???   INSTALL JAVA 6   SIX is a must.. this is a reproducible 
error, if you only have JAVA 7  , the install seems ok but on first launch of 
writer crash at Hungarian,,, if you do custom install with no Hungarian, then 
it crashes further into the launch process,,..  leave other JAVAS on your 
machine, just install JAVA 6 as well
and the problem will be solved..
PS if you know how to put this into the official bug reporting system please do 
so , as i dont know how..

remember when office shipped with JAVA included, , well now it doesn't , and it 
doesn't check successfully for version 6 which it needs to launch !.

-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Windows parallel install

[Manfred J. Krause]

Hi Pedro,

On Fri, Jan 27, 2012 at 12:20 PM, Pedro wrote:
> Hi all
>
> I'm trying to do a parallel install of LO 3.5.0RC2 under Windows XP Pro x86
>
> After unpacking (using msiexec /a) to folder D:\LO350 I can't save the edits
> to file Bootstrap.ini.
> i get "Error saving... Access is denied."
>
> I also had the same problem with RC1.
>
> The only solution i found is to reboot the PC, enter in Safe Mode, take
> ownership of the folder, remove the Read-Only attribute and then it is
> fixed...
>
> When i tried to run the program it is excruciatingly slow...
>
> Today i tried a parallel install of the latest daily 3.5 (from
> libreoffice-3-5~2012-01-25_20.47.58_LibO-Dev_3.5.1rc0_Win_x86_install_en-US.msi)
> and it won't even finish. It stops with the following error message
> "Internal error 2203, -2147287035
>
> Has this happened to any of you?

No.
Maybe → http://support.microsoft.com/kb/324852/en-us

> Does anybody use parallel instals in Windows?

Yes.

Last installing:
(1) via Console: msiexec /a
libreoffice-3-5~2012-01-23_22.09.27_LibO-Dev_3.5.0rc1_Win_x86_install_en-US.msi
(2) Continuation via UI

mjk

-- 
LibO 3.5.0 · Different Encryption Algorithm
http://wiki.documentfoundation.org/ReleaseNotes/3.5#.3D_Different_Encryption_Algorithm

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Base - No SDBC driver found!!

[Ian Whitfield]

OK!!! I've cracked the permissions problem!!!

By using Dolphin>Root Actions>Change Permissions I've been able to make 
the file "open" again. (I wonder why this works but nothing else???)


*BUT* - That leaves me back with my original problem. When I try to open 
my Database I get the error "No SDBC driver found".


This is now urgent and I must get an answer to this.

Thanks guys

Ian Whitfield
Pretoria


//

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Windows parallel install

[Tom Davies]

Hi :)
Does this guide help at all?
http://wiki.documentfoundation.org/Installing_in_parallel#Windows
I think it needs a bit of work for the Windows part so if there is anything you 
can add that would be great!
Regards from
Tom :)


--- On Fri, 27/1/12, Pedro  wrote:

From: Pedro 
Subject: [libreoffice-users] Windows parallel install
To: users@global.libreoffice.org
Date: Friday, 27 January, 2012, 11:20

Hi all

I'm trying to do a parallel install of LO 3.5.0RC2 under Windows XP Pro x86

After unpacking (using msiexec /a) to folder D:\LO350 I can't save the edits
to file Bootstrap.ini.
i get "Error saving... Access is denied."

I also had the same problem with RC1.

The only solution i found is to reboot the PC, enter in Safe Mode, take
ownership of the folder, remove the Read-Only attribute and then it is
fixed...

When i tried to run the program it is excruciatingly slow...

Today i tried a parallel install of the latest daily 3.5 (from
libreoffice-3-5~2012-01-25_20.47.58_LibO-Dev_3.5.1rc0_Win_x86_install_en-US.msi)
and it won't even finish. It stops with the following error message
"Internal error 2203, -2147287035 

Has this happened to any of you?
Does anybody use parallel instals in Windows?

Regards,
Pedro

--
View this message in context: 
http://nabble.documentfoundation.org/Windows-parallel-install-tp3692947p3692947.html
Sent from the Users mailing list archive at Nabble.com.

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


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

Re: [libreoffice-users] Base - No SDBC driver found!!

[Tom Davies]

Hi :)
Would something like 

ps aux | grep name-of-backend

show if somehow the database thinks it is doing a process?  Is it possible to 
see what the permissions of a file are set as?  I assume the back-end is 
created by the user that is using the back-end rather than created by 
RootUser/SuperUser/Admin?  If so can other users access and update the database 
or how are the permissions set to allow that?

Sorry i'm just throwing in some stupid thoughts as i really don't know how all 
that is supposed to work.  I guess the Base guide's first couple of chapters 
have not been able to help?
http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide

Regards from
Tom :)


--- On Fri, 27/1/12, Ian Whitfield  wrote:

From: Ian Whitfield 
Subject: Re: [libreoffice-users] Base - No SDBC driver found!!
To: users@global.libreoffice.org
Date: Friday, 27 January, 2012, 11:50

On 26/01/2012 18:15, Fernand Vanrie wrote:
> make sure nobody is connected or has opened the odb
> 
> or make a copy with a new name and open this copy then everiting must been 
> editable

Not working Fernand

I've made a new copy of the file but permissions are still grayed out!! I tried 
changing them with Dolphin, Dolphin as root and using chmod but they still 
remain greyed out.

Any other ideas??


-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Base - No SDBC driver found!!

[Ian Whitfield]

On 26/01/2012 18:15, Fernand Vanrie wrote:

make sure nobody is connected or has opened the odb

or make a copy with a new name and open this copy then everiting must 
been editable


Not working Fernand

I've made a new copy of the file but permissions are still grayed out!! 
I tried changing them with Dolphin, Dolphin as root and using chmod but 
they still remain greyed out.


Any other ideas??


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: what is the alternative of countifs function in libreoffice?

[Andreas Säger]

Am 27.01.2012 11:23, Pedro wrote:


I'm almost sure that you can't do that in the LibreOffice Pivot Tables
(unless there are some undocumented features that I'm not aware of? )



You can select multiple functions for the same data field. The function 
selector is a multi-select list box.
Indeed, you can not add the same function twice this way. The 
work-around for this is a duplicate of the original field in the source 
table.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Windows parallel install

[Pedro]

Hi all

I'm trying to do a parallel install of LO 3.5.0RC2 under Windows XP Pro x86

After unpacking (using msiexec /a) to folder D:\LO350 I can't save the edits
to file Bootstrap.ini.
i get "Error saving... Access is denied."

I also had the same problem with RC1.

The only solution i found is to reboot the PC, enter in Safe Mode, take
ownership of the folder, remove the Read-Only attribute and then it is
fixed...

When i tried to run the program it is excruciatingly slow...

Today i tried a parallel install of the latest daily 3.5 (from
libreoffice-3-5~2012-01-25_20.47.58_LibO-Dev_3.5.1rc0_Win_x86_install_en-US.msi)
and it won't even finish. It stops with the following error message
"Internal error 2203, -2147287035 

Has this happened to any of you?
Does anybody use parallel instals in Windows?

Regards,
Pedro

--
View this message in context: 
http://nabble.documentfoundation.org/Windows-parallel-install-tp3692947p3692947.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] solution to hungarian crash on launch writer

[Tim Hatton]

This is my attempt to give something back

I dont know how to get this solution into the offical bug reporting 
libreoffice system  so could you please forward this solution to someone 
who does

thanks
Tim

on XP SP3

HUNGARIAN CRASH ???   INSTALL JAVA 6   SIX is a must.. this is a 
reproducible error, if you only have JAVA 7  , the install seems ok but 
on first launch of writer crash at Hungarian,,, if you do custom install 
with no Hungarian, then it crashes further into the launch process,,..  
leave other JAVAS on your machine, just install JAVA 6 as well

and the problem will be solved..
PS if you know how to put this into the official bug reporting system 
please do so , as i dont know how..


remember when office shipped with JAVA included, , well now it doesn't , 
and it doesn't check successfully for version 6 which it needs to launch !.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: what is the alternative of countifs function in libreoffice?

[Pedro]

soumalya ray wrote
> 
> now i am trying to include the row/column percentage into the data pilot
> result directly along with the absolute count.so far, no luck!!
> 

I guess you just bumped into the LO Pivot Table limitations (compared to MS
Office)
In MS Office you would just add again the same data field Count and choose
to display results as a percentage or add the totals as percentage.

I'm almost sure that you can't do that in the LibreOffice Pivot Tables
(unless there are some undocumented features that I'm not aware of? )

--
View this message in context: 
http://nabble.documentfoundation.org/what-is-the-alternative-of-countifs-function-in-libreoffice-tp3688120p3692834.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: Mysterious spacing problem

[Séamas Ó Brógáin]

Jay wrote:

> Is this a screen resolution or a printing problem. Could you specify 
> which font(s) are troublesome?

> Also, I forgot - what OS are you using?
> 
GNU/Linux (Ubuntu 11.10).

Various fonts, including Plantin, but mostly my own (work in progress).
In all of them I have verified the character widths in Fontforge.

The fault appears on screen, and I must confess that I had not thought
of printing a test. In doing so now, however, I think I have discovered
where the problem lies. In what I use as normal editing mode (what Open
Office and Libre Office mysteriously call “web layout”) the problem
occurs; when I change to “print layout” it disappears. Likewise, when I
print a file the problem is not there.

Thanks to your question I now know where the problem lies, and indeed it
is not such a serious one if I know of a way around it, and can be sure
that texts will print properly.




-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Base question - report exception on faultless query

[Mark Stanton]

Hi Dan,

Thanks for your reply.  Yes, it was a bit short on details, but I 
thought there were enough, obviously not.

I had the query set for "Do not analyze", which I thought would stop 
Base from inspecting the SQL, but apparently not.

I'm using MySQL via the jDBC... Thingy.
In fact the piece it was complaining about was where I was using 
CAST, incorrectly, to match a text field containing numbers to a 
numeric field.  Funnily enough MySQL by itself was able to cope with 
this and execute the query correctly, but Base decided to interfere.

It also fails to understand the MySQL TRIM function, although LTRIM 
is recognised.  Again this is with "Analyze" set to "NO".  This seems 
incorrect to me.  However, this has resolved the issue for me and I 
can now get it to work.

Regards
Mark Stanton
One small step for mankind...



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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

[Cor Nouws]

Hi Greg,

Gregory Forster wrote (27-01-12 01:02)


First, I highlight First Name in the box on the left. Then I click the >
between the two boxes to move the First Name to the box on the right.
[...]
That format gives me the proper address labeling for letters, labels,
etc. However, when I exit the Insert Database Columns popup, the
formatting disappears in LibreOffice. However, in OpenOffice, that
formatting would stay intact. Grant it, that formatting would have to be
initialized for each address book database used.

I hope that helps.


Sorry, it does not. Anyway, it's beyond my imagination. And you do not 
answer my questions.
If there's no one else with a proper idea, I would suggest that you make 
some screenshots and such.

Thanks,

--
 - Cor
 - http://nl.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