Re: [libreoffice-users] 5.2 64bit DEB will not allow paper size selection

2016-09-22 Thread Girvin Herr

On 09/21/2016 05:03 AM, Tim---Kracked_P_P---webmaster wrote:

On 09/17/2016 02:06 PM, Girvin Herr wrote:

On 09/17/2016 03:30 AM, Jean-Baptiste Faure wrote:

Le 16/09/2016 à 21:43, Tim---Kracked_P_P---webmaster a écrit :

Today, I was working on a 11x17 inch tabloid paper poster.  I am using
Ubuntu 16.04 MATE 64bit running LO 5.2.0.4.  The paper size of the
document was the tabloid size.  When I went to print the document 
to my
HP printer [13x19 inch max] the paper size drop down menu was 
grayed out

and set for US Letter size.

Did you try to check the third option in the Option tab of the print
dialog : "Use only paper size from printer preferences" ?

Best regards.
JBF



Yes.  That worked.

However, it does not seem to be a global setting.  It appears one 
must set this option for each print, or at least for each document if 
the setting is embedded in the document. I have not tested that. A 
global setting option does not seem to be in the Tools > Options > 
Print menu.  How does one set this as the default?


BTW, On my LO 5.0.6.3, it is the 4th option down.  My 3rd option is 
"Use only paper _tray_ from printer preferences".


Regards.
Girvin Herr




OK, to answer several posts . . .

I do not have the HP printer set for tabloid in the Ubuntu printer 
driver settings - set for Letter, even though it has tabloid paper in 
the tray.


NO I do not have any settings stating to use only the loaded printer 
paper size.


One quirk is, now that I exported to PDF as a tabloid paper size, now 
the paper size box that is grayed out shows 11x17 inch [tabloid] size 
paper, not letter size, for the tabloid sized document.  NOW, the 
grayed out paper size is showing Letter size for the letter size 
document.  SO, it looks like there is some quirky bug somewhere, 
either in LO or in the Ubuntu printer drivers.





Are you using CUPS as your printer driver?
I had a problem with an app that did not allow me to configure the 
printer options in its print dialog, which was critical to selecting the 
11x17 size I wanted from a normally letter size by default printer.  I 
solved my problem by creating a logical printer in CUPS which I 
configured to default to 11x17 paper for this printer.  So now, whenever 
I want to print an 11x17 size in an app that doesn't allow or implement 
11x17 selection, I just select the 11x17 logical printer in the list of 
printers.  That works fine in my case.  It may be your workaround 
solution.  If your ubuntu is not using CUPS, then YMMV.


HTH.

Girvin Herr



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

2016-09-22 Thread Alexander Thurgood
Le 22/09/2016 à 06:41, Michael Manning a écrit :

Hi Michael,

> After installing the various packages, I am not able to run
> 
>> sudo ODBCConfig
> 


Try installing ODBCManageDataSourcesQ4 and its co-application
ODBCCreateDataSourceQ4. These are QT4 apps, but they worked for me on
LinuxMint 18.

Alternatively, you can configure the odbcinst.ini and odbc.ini files by
hand and put them in the appropriate places.

You might also want to bear in mind that not all datatypes available in
sqlite are correctly supported/interpreted by LibreOffice, even over
ODBC. This stems from the weak typing of sqlite, which LibreOffice
doesn't necessarily know how to interpret correctly.


Alex


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