Re: [libreoffice-users] Calc default font size

2023-05-22 Thread Philip Jackson 

Hi Mike,

On 22/05/2023 14:10, Mike Flannigan wrote:


Go to Tools > Options > LibreOffice > Fonts and change it there.

Does that work?


I looked there but it seems to be basically a font replacement table informing 
LibreOffice what font to substitute when a document uses a font which is not 
available on the computer. This table only sets the font face and not the size.

Secondly, there is a specification for font for html, sql,  and Basic sources.  
In any case it calls Hack at 15pt which never happens in the spreadsheet. 
Doesn't seem to apply to my case.

Calc always gives me the fontface I want/specify in the Default.ots template 
(Liberation Sans).  My modified template always provides 4 sheets with the font 
size set at the 12pt which I specified. The problem which I have to correct 
manually each time, occurs when I create a new sheet. The font face is correct 
but the size reverts to 10pt on the new sheet.

The same goes if a create a new spreadsheet using File > New > Spreadsheet 
without passing by my Default.ots template. The new spreadsheet has the correct 
number of sheets with the correct font face but all set at 10pt.

So I conclude that LibreOffice has some setting deeper within its structure 
that specifies 10pt.  I would like to understand where that setting is and I'm 
hoping someone can point me to it.

Philip


On 5/22/23 03:08, users+h...@global.libreoffice.org wrote:

Subject:
[libreoffice-users] Calc default font size
From:
Philip Jackson 
Date:
5/21/23, 12:53

To:
LibreOffice 


Using LO 7.3.7.2 in UbuntuStudio 22.04

These days, I need a minimum of  12pt font size in Calc. Creation of a new file via File > 
New > Spreadsheet opens always with settings at 10pt.  I have edited a Default template in 
the .config/libreoffice/ directory with 12pt font size and creating a new file via File > 
New > Templates > Default  does get me a new spreadsheet with settings at 12 pt for the 
first 4 sheets but any extra sheets I create are set at 10pt.

In Tools > Options > LibreOffice Calc > Defaults, there is only an option to specify the 
number of sheets in a new spreadsheet. I've searched under Tools > Options > LibreOffice > 
Advanced > Open Expert Configuration looking for a default font size setting but without success.

Can anyone advise how and where I can adjust the settings so that by default I always 
get new sheets set to 12pt, and preferably by default at the File > New > 
Spreadsheet without having to pass via the template ?

Thanks,
Philip





--
--
   author of "The Circle of Fifths" for improvising 
musicians
  Get it here https://www.books2read.com/u/bWnRM4

  auteur : "Le Cycle des Quintes" pour musiciens improvisateurs
  disponibilité : https://www.books2read.com/u/bw8rv9
--

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive:

Re: [libreoffice-users] MariaDB Connector Question

2023-05-22 Thread Robert Großkopf 

Hi LAP,


However, only the JDBC connector will connect to the specified
database.  The ODBC and C connectors will connect to _all_ the
databases that are present in the MariaDB database directory, i.e.
all tables from all databases are shown.


Not all databases. All the data you are allowed (from your MariaDB) to 
connect to.




Why does only the JDBC connector actually connect to the specified
database?


When connecting here with org.mariadb.jdbc.Driver there are also shown 
all databases I am allowed to read data. Tested with 
mariadb-java-client-3.1.3.jar, LO 7.5.3.2 on OpenSUSE 15.4 64bit rpm Linux.


Go to Tools → Table Filter… and deactivate the databases you do not want 
to see. Go to View  → Refresh Tables and the databases won't be shown 
any more.


Is this normal behavior or is this a bug?


Why should this be a bug. You could connect to different databases with 
this connection. Some people use this to copy data from one database to 
another, to switch during one connection …


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] MariaDB Connector Question

2023-05-22 Thread LAP 
LibreOffice Base can connect to a MariaDB database using one
of three connectors:

JDBC
ODBC
C connector

Setting up a connection using any of the above requires
specifying the name of MariaDB database with which to connect.

However, only the JDBC connector will connect to the specified
database.  The ODBC and C connectors will connect to _all_ the
databases that are present in the MariaDB database directory, i.e.
all tables from all databases are shown.

Why does only the JDBC connector actually connect to the specified
database?

Is this normal behavior or is this a bug?

My system is GNU/Linux with the latest LO.



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Calc default font size

2023-05-22 Thread Mike Flannigan 


Go to Tools > Options > LibreOffice > Fonts and change it there.

Does that work?


On 5/22/23 03:08, users+h...@global.libreoffice.org wrote:

Subject:
[libreoffice-users] Calc default font size
From:
Philip Jackson 
Date:
5/21/23, 12:53

To:
LibreOffice 


Using LO 7.3.7.2 in UbuntuStudio 22.04

These days, I need a minimum of  12pt font size in Calc. Creation of a 
new file via File > New > Spreadsheet opens always with settings at 
10pt.  I have edited a Default template in the .config/libreoffice/ 
directory with 12pt font size and creating a new file via File > New > 
Templates > Default  does get me a new spreadsheet with settings at 12 
pt for the first 4 sheets but any extra sheets I create are set at 10pt.


In Tools > Options > LibreOffice Calc > Defaults, there is only an 
option to specify the number of sheets in a new spreadsheet. I've 
searched under Tools > Options > LibreOffice > Advanced > Open Expert 
Configuration looking for a default font size setting but without 
success.


Can anyone advise how and where I can adjust the settings so that by 
default I always get new sheets set to 12pt, and preferably by default 
at the File > New > Spreadsheet without having to pass via the template ?


Thanks,
Philip



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy