Re: [libreoffice-users] Writer Callout Style settings

2021-07-23 Thread Steve Edmonds

Thanks John and Regina for the help.
I have found an efficient way to inset multiple formatted callouts.
Insert and format the first one then copy/paste and edit the text for 
subsequent callouts.

Steve

On 24/07/2021 12:30, Regina Henschel wrote:

Hi Steve,

Steve Edmonds schrieb am 18.07.2021 um 23:05:

Hi.
Is it possible to set Writer callout text paragraph style (or default 
settings, if so where please.
This is to avoid having to change the font and left hand offset in 
every line callout one at a time.


No, it is not possible. Using the legacy callouts or the custom shape 
callouts makes no difference. You get always a shape and in Writer 
neither for the shape itself nor for the text in the shape styles are 
possible. You can only use direct formatting in Writer.


Kind regards
Regina




--
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] Writer Callout Style settings

2021-07-23 Thread Regina Henschel

Hi Steve,

Steve Edmonds schrieb am 18.07.2021 um 23:05:

Hi.
Is it possible to set Writer callout text paragraph style (or default 
settings, if so where please.
This is to avoid having to change the font and left hand offset in every 
line callout one at a time.


No, it is not possible. Using the legacy callouts or the custom shape 
callouts makes no difference. You get always a shape and in Writer 
neither for the shape itself nor for the text in the shape styles are 
possible. You can only use direct formatting in Writer.


Kind regards
Regina

--
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] Connect to .accdb files

2021-07-23 Thread dboland9
I read that LO Base can open the Access 2007/2010 files. The instructions say 
to select the Access 2007 connection. Well, there are no Access connections. 
Only JDBC, Thunderbird, spreadsheet, dBase, Firebird, Text, MySQL, ODBC, 
PostgreSQL, and Writer. Any ideas?

Thanks,
Dave

Sent with [ProtonMail](https://protonmail.com/) Secure Email.
-- 
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] Writer Callout Style settings

2021-07-23 Thread John Kaufmann

OK, Steve.
So:

I have View>Toolbars>Drawing enabled. In that I have 2 callout options, a 
speech bubble and a rectangular text callout. ...


That answers my two questions:
(1) You don't use a Callouts toolbar [contra the Help, confirming a bug there].
(2) Instead, from the Drawing toolbar [which is where I found them] you use 
these callout commands:





But [as I noted earlier] there /is/ a "Callouts" toolbar listed among the 
toolbars in:
View => Toolbars => Customize...
=> Toolbars tab => Target
I would love to know what that is about, and how to make that Callouts toolbar 
visible to use.

In the same vein [and I will bet related], there is also a callouts command 
that is *not* visible on the Drawing toolbar (though I suspect, if you check 
the Customize options, it is enabled and so should be visible):

   


IOW, if I had to guess, I suspect that callouts are not a completely 
implemented function, though they are a good beginning to extend text boxes 
into a special use case that will be very valuable when it is more functional. 
That would explain some things:
 *** the Help bug (probably had to be written before they really knew how it 
will turn out);
 *** a lack of style support that you expected (or requested) in your OP;
 *** a labelled but still unimplemented "Vertical Callouts" command;
 *** anomalies you have found, reflecting sparse user feedback. [Bugs can exist 
with lots of user feedback.]

That said, when I was trying to understand your OP, and callouts generally, my 
search led to this page -
"Callout Sidebars on LibreOffice"


- which uses a slightly different (but related) definition of "callout", presenting how 
to do /its/ callout function in LO without any special LO callout commands.  Both functions are 
useful, but it can only cause confusion to call both functions "callouts".

John


On 2021-07-23 16:58, Steve Edmonds wrote:

Thanks for the reply.
I have View>Toolbars>Drawing enabled. In that I have 2 callout options, a 
speech bubble and a rectangular text callout. Your icon set may differ.
I am using the callouts to annotate some images for reference in my explanation 
text.

If I add a rectangular text callout I can right click and edit some 
characteristics. With the callout selected, I can use the menu Format>Text Box 
and Shape.
Possibly callouts are still "in development" as, although my document units are 
cm and last week the callout properties were in cm, today callout properties are in 
inches.

There is also a funny quirk where callouts become invisible (but still there) 
when the anchor is not in an appropriate place.

Steve

On 24/07/2021 08:18, John Kaufmann wrote:

On 2021-07-18 17:05, Steve Edmonds wrote:


Is it possible to set Writer callout text paragraph style (or default settings, 
if so where please.
This is to avoid having to change the font and left hand offset in every line 
callout one at a time.


When I first saw this question, I had no clue what you were asking (having never used 
callouts), so looked forward to an answer, to at least help understand the question.  
When no answer came, I tried the LibreOffice 7.1 Help on "callout" -- and found 
it unhelpful:


"Opens the Callouts toolbar from which you can insert graphics into your 
document."


But that leaves these problems:
(1) It's not clear WHAT "Opens the Callouts toolbar" [apparent bug in the 
Help], and IAC:
(2) As installed (that is, in the default configuration), View=>Toolbars shows *no* 
"Callouts toolbar".

As for (1): *WHAT* opens the Callouts toolbar?

As for (2): The lack of a toolbar, which is supposed to exist, led me to:
View => Toolbars => Customize...
In the Toolbars tab, with , the  box shows 
"Callouts" among the possible tool bars, but gives no control (that I can see) for how to make 
it appear in the View=>Toolbars menu.

Further, after much searching, I found that the Drawing toolbar has these three 
apparently-relevant commands:
    "Callout Shapes"
    "Callouts"
    "Vertical Callouts"
(The command categories were found in a subsequent command search on "callout".)

But none of that gets any closer to /using/ these commands.  So, at the most 
basic level of use: How do you /invoke/ callouts? - via a Callouts toolbar or 
the Drawing toolbar? If you use a Callouts toolbar, how do you make it appear?

John



--
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] Connect to .accdb files

2021-07-23 Thread Regina Henschel

Hi Dave,

which operating system do you use?

Kind regards
Regina

dboland9 schrieb am 23.07.2021 um 22:08:

I read that LO Base can open the Access 2007/2010 files. The instructions say 
to select the Access 2007 connection. Well, there are no Access connections. 
Only JDBC, Thunderbird, spreadsheet, dBase, Firebird, Text, MySQL, ODBC, 
PostgreSQL, and Writer. Any ideas?


--
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] Writer Callout Style settings

2021-07-23 Thread Steve Edmonds

Thanks for the reply.
I have View>Toolbars>Drawing enabled. In that I have 2 callout options, 
a speech bubble and a rectangular text callout. Your icon set may differ.
I am using the callouts to annotate some images for reference in my 
explanation text.


If I add a rectangular text callout I can right click and edit some 
characteristics. With the callout selected, I can use the menu 
Format>Text Box and Shape.
Possibly callouts are still "in development" as, although my document 
units are cm and last week the callout properties were in cm, today 
callout properties are in inches.


There is also a funny quirk where callouts become invisible (but still 
there) when the anchor is not in an appropriate place.


Steve

On 24/07/2021 08:18, John Kaufmann wrote:

On 2021-07-18 17:05, Steve Edmonds wrote:

Is it possible to set Writer callout text paragraph style (or default 
settings, if so where please.
This is to avoid having to change the font and left hand offset in 
every line callout one at a time.


When I first saw this question, I had no clue what you were asking 
(having never used callouts), so looked forward to an answer, to at 
least help understand the question.  When no answer came, I tried the 
LibreOffice 7.1 Help on "callout" -- and found it unhelpful:


"Opens the Callouts toolbar from which you can insert graphics into 
your document."


But that leaves these problems:
(1) It's not clear WHAT "Opens the Callouts toolbar" [apparent bug in 
the Help], and IAC:
(2) As installed (that is, in the default configuration), 
View=>Toolbars shows *no* "Callouts toolbar".


As for (1): *WHAT* opens the Callouts toolbar?

As for (2): The lack of a toolbar, which is supposed to exist, led me to:
View => Toolbars => Customize...
In the Toolbars tab, with , the  box 
shows "Callouts" among the possible tool bars, but gives no control 
(that I can see) for how to make it appear in the View=>Toolbars menu.


Further, after much searching, I found that the Drawing toolbar has 
these three apparently-relevant commands:

    "Callout Shapes"
    "Callouts"
    "Vertical Callouts"
(The command categories were found in a subsequent command search on 
"callout".)


But none of that gets any closer to /using/ these commands.  So, at 
the most basic level of use: How do you /invoke/ callouts? - via a 
Callouts toolbar or the Drawing toolbar? If you use a Callouts 
toolbar, how do you make it appear?


John




--
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] Writer Callout Style settings

2021-07-23 Thread John Kaufmann

On 2021-07-18 17:05, Steve Edmonds wrote:


Is it possible to set Writer callout text paragraph style (or default settings, 
if so where please.
This is to avoid having to change the font and left hand offset in every line 
callout one at a time.


When I first saw this question, I had no clue what you were asking (having never used 
callouts), so looked forward to an answer, to at least help understand the question.  
When no answer came, I tried the LibreOffice 7.1 Help on "callout" -- and found 
it unhelpful:


"Opens the Callouts toolbar from which you can insert graphics into your 
document."


But that leaves these problems:
(1) It's not clear WHAT "Opens the Callouts toolbar" [apparent bug in the 
Help], and IAC:
(2) As installed (that is, in the default configuration), View=>Toolbars shows *no* 
"Callouts toolbar".

As for (1): *WHAT* opens the Callouts toolbar?

As for (2): The lack of a toolbar, which is supposed to exist, led me to:
View => Toolbars => Customize...
In the Toolbars tab, with , the  box shows 
"Callouts" among the possible tool bars, but gives no control (that I can see) for how to make 
it appear in the View=>Toolbars menu.

Further, after much searching, I found that the Drawing toolbar has these three 
apparently-relevant commands:
"Callout Shapes"
"Callouts"
"Vertical Callouts"
(The command categories were found in a subsequent command search on "callout".)

But none of that gets any closer to /using/ these commands.  So, at the most 
basic level of use: How do you /invoke/ callouts? - via a Callouts toolbar or 
the Drawing toolbar? If you use a Callouts toolbar, how do you make it appear?

John

--
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] Cannot send document via email from LO 7.1.4.2 Flatpak

2021-07-23 Thread Tony Arnold
Hi,

I'm running LO 7.1.4.2 Flatpak edition and I am unable to send the
current document via email. When I try the email dialogue comes up, but
there is no document attached. When I click on send, the recipient gets
an email with no attachment.

My email client is Evolution version 3.36.5-0ubuntu1

All running on Ubuntu  20.04.2 LTS and Gnome 3.36.8.
I'm not sure if this is an LO bug, consequence of using Flatpak,
Evolution problem and a configuration issue!

Any ideas on where the issue lies and how I might go about fixing it?

Many thanks.

Regards,
Tony.
-- 
Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT 
Services | Office 1, Kilburn Building | The University of Manchester | 
Manchester M13 9PL | T: +44 161 275 6093 | M: +44 773 330 0039

-- 
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] Nabble users list down?

2021-07-23 Thread sophi
Hi all,
Le 23/07/2021 à 16:11, jerr...@gmx.com a écrit :
> Well, it looks like its still up and running at the moment, but the future 
> looks questionable. I was asking bacause I havent been able to access the 
> users@global.libreoffice.org nabble forum lately. Just wondering if TDF 
> pulled out early.

Until very recently, we were not aware of the situation unfortunately.
For those using Nabble, we are putting a Discourse forum in place in a
first step to replace the Ask instance, see my message here:
https://listarchives.libreoffice.org/global/website/2021/msg00096.html
The migration of Ask archives will take place on the July 31.

Once everything is migrated and working well for contributors and users,
we will see how to bridge the mailing lists with another Discourse
instance as a replacement of Nabble services. Note: this is not to
replace mailing lists, but to bridge them.
This will be communicated mostly on the website mailing list, but don't
hesitate to ping me if you have questions.

Kind regards
Sophie

-- 
Sophie Gautier so...@libreoffice.org
GSM: +33683901545
IRC: soph
Foundation coordinator
The Document Foundation

-- 
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] Nabble users list down?

2021-07-23 Thread jerryvb
Well, it looks like its still up and running at the moment, but the future 
looks questionable. I was asking bacause I havent been able to access the 
users@global.libreoffice.org nabble forum lately. Just wondering if TDF pulled 
out early.




--JESUS is Lord!
Sent:Friday, July 23, 2021 at 6:31 AMFrom:Mike 
Flanniganmflan@mflan.comTo:users@global.libreoffice.orgCc:jerryvb@gmx.comSubject:Re:
 [libreoffice-users] Nabble users list down?
I just read that nabble is going to be history.Lets see - here you 
go:https://support.nabble.com/The-Future-of-Nabble-td7605923.htmlMikeOn 7/22/21 
3:06 AM,users+help@global.libreoffice.orgwrote:
Subject:
[libreoffice-users] Nabble users list down?From:
jerryvb@gmx.comDate:
7/21/21, 4:53 PMTo:
users@global.libreoffice.orgDoes anyone know what has happened to the 
DocumentFoundation forum on nabble.com? I havent been able to access it for the 
past several days.




Just asking.




-- 
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] DATEADD function in HSQLDB

2021-07-23 Thread Dan Lewis
   I have am using Base to connect to HSQLDB 2.60 so I can use 
functions like this one. I have this query which calculates my account 
balances for the last day of the present month.


    SELECT "Data"."Account" "Account", SUM( "Data"."Amount" ) 
"Account Balance", SUM( "Data"."Budget" ) "Budget" FROM "Data", 
"Transactions" WHERE "Data"."Transactions_ID" = 
"Transactions"."Transactions_ID" AND "Transactions"."Date" <= LAST_DAY( 
CURRENT_DATE ) GROUP BY "Data"."Account" HAVING SUM( "Data"."Amount" ) 
<> 0 ORDER BY "Account" ASC


   What I want to do is to calculate these values for the last day of 
the previous month. I thought using DATEADD to calculate them. Even 
though I select the sql button (run sql directly), Base does not 
recognize the function. Specifically, I have tried to put the DATEADD 
functions within LAST_DAY.


    LAST_DAY(DATEADD('mm', 1, CURRENT_DATE)) ought to product the 
last day of the next month; a -1 should produce the last day of the 
previous month.


 Help will be much appreciated.

Dan


--
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] Nabble users list down?

2021-07-23 Thread Mike Flannigan


I just read that nabble is going to be history.
Lets see - here you go:
https://support.nabble.com/The-Future-of-Nabble-td7605923.html


Mike


On 7/22/21 3:06 AM, users+h...@global.libreoffice.org wrote:

Subject:
[libreoffice-users] Nabble users list down?
From:
jerr...@gmx.com
Date:
7/21/21, 4:53 PM

To:
users@global.libreoffice.org


Does anyone know what has happened to the DocumentFoundation forum on 
nabble.com? I havent been able to access it for the past several days.


Just asking.



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