date:20220425


Dave Barton schrieb am 25.04.2022 um 20:07:

On 25/04/2022 17:18, lo.harald.ber...@t-online.de wrote:

Hi Dave, Regina, John,

see below, as already mentioned in my last e-mail:

Am 25.04.2022 um 17:18 schrieb Dave Barton:

[...snip...]
the PNG graphic cannot be directly edited from within LO.

Right-click on the inserted object (bracket) and then select "Break".
The text can now be edited.

Kind regards
Harald

[...snip...]

Kind Regards

Dave


Look into the source code and you will see that the gallery flowcharts
in Writer are PNG bitmaps and in Draw they are metafile vectors, which
is the reason break works in  Draw (a vector graphics module), but does
not in Writer.



I have tested it with version 7.3.2 and version 7.4, both on Windows. 
The items "left brace" and "right brace" are surely shapes. Drag them 
from the Gallery to a Writer document. You can even use their handles.


What version of LO do you use? Might it be, that a Linux distributor 
packs a different version of the Gallery theme?


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] changing currency in a spreadsheet

2022-04-25 Thread Johnny Rosenberg

Den sön 24 apr. 2022 kl 23:35 skrev Dave Howorth :

>
> I have a financial spreadsheet that was designed in the USA but I live
> in the UK. Is there any way in LO to change all the cells that are
> formatted as numeric $ amounts to be the same format but using the
> equivalent numeric £ format instead?
>
> I don't think there's any logic in the spreadsheet that depends on the
> currency, it's just doing numerical calculations on the values. But it
> would be easier to look at if it was in £ rather than $ everywhere!
>
> Cheers, Dave
>

If you are lucky (probably not, but let's give it a go, at least), your
spreadsheet was done properly to begin with. That means that styles were
used properly, so in every cell where a currency is used, they used the
same style. If so, then just find out which style that is and change the
currency format in that style, and BAM, all of your currency cells are
corrected at once!

THIS is why you should use styles. If you don't, start doing it now. It's
maybe a bit slower in the beginning, but you don't have to setup your
styles that thoroughly immediately, you can do that later, just make sure
that every cell that is formatted differently is using a style for that.
Then you can always modify that style later and affect thousands of cells
spread over a whole lot of sheets (within that file, of course) at once.
Very, very useful, I can't stress that enough.

So, let's say that the creator of your document didn't care about styles,
which probably is the case. Then highlight all cells with currency (you can
highlight whole columns with just one click and you can highlight more than
one column at a time using the shift key while clicking a column and so
on), hit Ctrl+m to strip all those cells from any kind of formatting
(except conditional formatting, I think, but not sure about that) and then
apply a style to them. Don't forget to name that style properly if you
create a new one, making it easier for you in the future to figure out what
the heck you were doing all those years ago.

Then you can easily modify that style as you wish and you can play with
that forever if you want to. Maybe tomorrow you want all currencies to be
in a smaller font. Well, edit that style again, pick a smaller font, and
BAM, thousands of cells are immediately affected. If you want to apply that
style to more cells, just select those cells and click that style.


Kind regards

Johnny Rosenberg


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

-- 
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] Using the Gallery - removing the descriptive text


Hi Dave,

Dave Barton schrieb am 25.04.2022 um 17:18:

On 25/04/2022 09:25, Regina Henschel wrote:
Hi Regina,

I think the two PNG graphics in the Writer Gallery John is referring to
are left and right curly braces.


Left and right curly braces are no PNG graphics but true shapes. Only 
'Insert' from the context menu in the Gallery inserts it as image. If 
you drag&drop it from the Gallery to your document you get it as shape 
with editable text.


"Writer Gallery"
The Gallery is not specific to a module, but common to all modules.

 Both have the word "Callout" ("attached

descriptive text") drawn within the bitmap image, not editable text.


See above. It seems the difference needs to be added to "Inserting 
Objects From the Gallery" to the help.




The F2 text addition facility you describe works for the Draw Gallery,
but not for the Writer Gallery and in both cases the word "Callout" in
the PNG graphic cannot be directly edited from within LO.


F2 is one of the method to set a shape into edit mode. It is a tool on 
the already inserted shape, not a tool of the Gallery.

Double-click is the other method to set a shape into edit mode.

But it would indeed be good to have "Edit shape text" in the context 
menu. Neither F2 nor double-click is known to users, which come from MS 
Office. There it is single-click on the text or 'Edit text' in the 
context menu.




If I have understood John's original request correctly, "Insert -> Shape
-> Symbol Shapes" -> "Left Brace" or "Right Brace", then anchor,
position and size should satisfy his requirements.


It is the same kind of shape in the Gallery and in the toolbar. Only 
that the Gallery gives a hint to the user, that it is possible to add 
text to the shape.


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] Using the Gallery - removing the descriptive text


Hi John,

John Kaufmann schrieb am 25.04.2022 um 17:37:

I'm sure there's a lot of history behind why those two approaches 
coexist, apparently independently.


An ancestor of LibreOffice is StarOffice from about 1997, which has 
already a Gallery. So indeed, it has a long history.


 Are they in fact independent?

The dependencies have decreased significantly, but there are still 
pieces of code that use the Gallery. There are parts in the Gallery, 
which are hidden from the user as long as you do not set a special 
environment variable, but used by the code.


 Is this
a case where one would prune/rationalize the tools to a common base 
(maybe with multiple entry points in the user interface) if time 
allowed, or is there a positive benefit from maintaining both the Shapes 
menu and the Gallery as separate graphics libraries?


You need both, the Gallery and the shapes in the Drawing toolbar.

The Gallery is a kind of library. One purpose of the Gallery was to 
provide clip-arts, background images and sound. That was necessary in 
times where you cannot get such things free or with suitable licenses 
from the Web.


The Gallery allows the user to collect personal shapes, images and other 
media. The gallery is a convenient way to make drawing objects created 
with Draw available to the other modules and retain them for a longer 
period of time, independent of a particular document. That has always 
been a purpose of the Gallery.


A second aspect is, that you can get a lot of ready-to-use Gallery 
themes for special interests. And we hope that users share their shape 
collections. See for example

https://extensions.libreoffice.org/?Tags[]=49

The shapes in the Drawing toolbar are special because they have code 
associated, which can convert them to other file formats. Import/Export 
with binary MS Office formats (doc, ppt) works well. Exchange with OOXML 
formats (pptx, docx) works well for those shapes, which have a directly 
corresponding shape in the OOXML standard. Most of the shapes in the 
Drawing toolbar are of that kind.


 If the latter, how

do you decide where to add a new graphic or collection of graphics?


If special code is associated, they are in the Drawing toolbar. Shapes 
were Design-team think they are useful for lot of users go to the 
Gallery. The content of the Gallery has changed over time. The content 
is subject to fashion. But you can still get older Gallery themes, in 
case you miss something which exists in earlier versions.


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] Using the Gallery - removing the descriptive text

2022-04-25 Thread Dave Barton

On 25/04/2022 17:18, lo.harald.ber...@t-online.de wrote:
> Hi Dave, Regina, John,
> 
> see below, as already mentioned in my last e-mail:
> 
> Am 25.04.2022 um 17:18 schrieb Dave Barton:
>> [...snip...]
>> the PNG graphic cannot be directly edited from within LO.
> Right-click on the inserted object (bracket) and then select "Break".
> The text can now be edited.
> 
> Kind regards
> Harald
>> [...snip...]
> Kind Regards
>> Dave

Look into the source code and you will see that the gallery flowcharts
in Writer are PNG bitmaps and in Draw they are metafile vectors, which
is the reason break works in  Draw (a vector graphics module), but does
not in Writer.

I was trying to be brief in my description, so I wrote "PNG graphic
cannot be directly edited from within LO." when I should have been much
more pedantically specific by writing "PNG graphic cannot be directly
edited from within *_WRITER_*."

Bye


-- 
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] Using the Gallery - removing the descriptive text


Hi John,

thank you for your reply and the beautiful story about languages in 
general and from your experience.


For me it becomes more and more mysterious.

To Writer:

Is somehow different for me, is it because of the version?

If I right click on the callout in the gallery and select "Paste", it is 
inserted as an image and cannot be edited at all.


After Regina's hint I did the following: Right-click on the callout and 
choose "Copy". Then paste with Ctrl+V.

Then I can double-click on the text without F2 and edit the text.

With me:
Version: 7.3.2.2 (x64) / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; 
VCL: win

Locale: de-DE (de_DE); UI: de-DE
Calc: CL

Maybe it will help someone else.

Kind regards
Harald

PS: Regina is also a developer, we have a lot to thank her for.
Thanks Regina!


Am 25.04.2022 um 18:42 schrieb John Kaufmann:

Thank you, Harald.

[I should also begin with a note on language: I am always humbly 
grateful for those who are willing to speak and write in my native 
language. (I once worked in a multi-national engineering office in 
Brussels. There were about a dozen client languages, and office 
business was conducted mostly in French and English. Americans and 
Brits were generally regarded as the least capable linguistically.) My 
lesson from cross-language experience was that it is easier to receive 
than to give, so we might best be served by everyone speaking and 
writing natively, but I am grateful for those who go beyond that -- 
and especially grateful that English is the world's default second 
language. ;-) ]


I hope you saw that Regina (who may be more knowledgeable about LO 
than anyone) provided a full and simple answer in the same vein as 
your approach - but she showed how to edit directly in Writer, without 
resort to Draw: just F2. I will be looking at 
bugs.documentfoundation.org to see if I should file a request to have 
that added to the context menu.


You have helped my success. I hope someday to return the favor.

Kind regards,
John


On 2022-04-25 03:01, lo.harald.ber...@t-online.de wrote:

Supplement:

There also seems to be another bug in Draw.
To be able to edit the text in a flow chart object, you must first 
right-click on the object and select "Break".


Kind regards,
Harald


Dear John,

first of all, thank you very much for your feedback.
This has led me to probe a little deeper into the theme.

Well I am not a developer but also just a user like you.
Therefore, as a user, you can only ever tell about experiences.

It is also possible that I did not understand your question 
correctly. Sorry, English is not my native language.


But now to the point. I'm glad you are familiar with frames, because 
they are a powerful tool in Writer.


There is also what I hope is a pleasing development for you.
You can use and change the flowchart graphics.
However, this only works in Draw.

I think it is a mistake that this does not work in Writer.
In this respect it would be appropriate to write a bug report.

Now for the differences, which I found out thanks to your feedback.

-- Flow charts in Writer. --

When you insert a flowchart object into Writer, you can't actually 
change it (as I said, probably a bug).

In this example I used the graphic object "Process".
Right-click the object and select Properties from the context menu.
The dialog shows you that it is an image and this is therefore not 
editable.


-- Flow charts in Draw. --

In Draw, add again the flow chart object "Process".
If you now double-click on the text, the cursor will appear for 
editing. (Heureka)


Try right-clicking on the object.
With "Break" you can learn that it is a composite object. Use the 
navigator to see the individual sub-objects.


-- Workaround - my proposal --

Create flowchart objects for your purposes in Draw and copy them to 
Writer.


I wish you much success.

Kind regards,
Harald


Am 25.04.2022 um 01:28 schrieb John Kaufmann:
Thanks, Harald. That article is about using frames (including linked 
frames) to layout a DTP project; it does not address the Gallery, or 
even the inclusion of graphics generally.  FWIW, I'm familiar with 
frames (and even use them in this document), but don't see how they 
relate to the question of included graphics, from the Gallery or 
elsewhere.


Most of the Gallery contents seem to be traditional clip-art 
(graphical symbols), including those collected in the "Flow chart" 
category. How do those flowchart symbols differ from others? [The 
Gallery has three other categories - "BPMN", "Diagrams", "Shapes" - 
that also contain descriptive text with graphics; my original 
question would also apply in those cases.]  Is your point that I 
should forget the Gallery and make my own graphics (from Draw or 
elsewhere)? (If so, what is the purpose of the Gallery?)


Kind regards,
John


On 2022-04-24 09:30, lo.harald.ber...@t-online.de wrote:

IMHO, t

Re: (resolved) Re: [libreoffice-users] libreoffice grabs network port

2022-04-25 Thread Dave Howorth

On Mon, 25 Apr 2022 17:05:12 +0100
Mike Scott  wrote:

[snip]
 
> All's well that end's well, I guess. Mojolicious has a steep learning 
> curve, but is much easier and cleaner to use than php for this job.
> LO works, albeit slowly -- ~20 seconds to do the .odt->.doc
> conversion on a pi4.
> 
> Again, thanks.

Glad to hear it's been solved :) Yes, all the MVC templating systems
have bits of weirdness that have to be learned the hard way :(
Mojolicious is not one I ever used.

-- 
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] Using the Gallery - removing the descriptive text

Thank you, Harald.

[I should also begin with a note on language: I am always humbly grateful for
those who are willing to speak and write in my native language. (I once worked
in a multi-national engineering office in Brussels. There were about a dozen
client languages, and office business was conducted mostly in French and
English. Americans and Brits were generally regarded as the least capable
linguistically.) My lesson from cross-language experience was that it is easier
to receive than to give, so we might best be served by everyone speaking and
writing natively, but I am grateful for those who go beyond that -- and
especially grateful that English is the world's default second language. ;-) ]

I hope you saw that Regina (who may be more knowledgeable about LO than anyone)
provided a full and simple answer in the same vein as your approach - but she
showed how to edit directly in Writer, without resort to Draw: just F2. I will
be looking at bugs.documentfoundation.org to see if I should file a request to
have that added to the context menu.

You have helped my success. I hope someday to return the favor.

Kind regards,
John

On 2022-04-25 03:01, lo.harald.ber...@t-online.de wrote:

Supplement:

There also seems to be another bug in Draw.
To be able to edit the text in a flow chart object, you must first right-click on the
object and select "Break".

Kind regards,
Harald

Dear John,

first of all, thank you very much for your feedback.
This has led me to probe a little deeper into the theme.

Well I am not a developer but also just a user like you.
Therefore, as a user, you can only ever tell about experiences.

It is also possible that I did not understand your question correctly. Sorry,
English is not my native language.

But now to the point. I'm glad you are familiar with frames, because they are a
powerful tool in Writer.

There is also what I hope is a pleasing development for you.
You can use and change the flowchart graphics.
However, this only works in Draw.

I think it is a mistake that this does not work in Writer.
In this respect it would be appropriate to write a bug report.

Now for the differences, which I found out thanks to your feedback.

-- Flow charts in Writer. --

When you insert a flowchart object into Writer, you can't actually change it
(as I said, probably a bug).
In this example I used the graphic object "Process".
Right-click the object and select Properties from the context menu.
The dialog shows you that it is an image and this is therefore not editable.

-- Flow charts in Draw. --

In Draw, add again the flow chart object "Process".
If you now double-click on the text, the cursor will appear for editing.
(Heureka)

Try right-clicking on the object.
With "Break" you can learn that it is a composite object. Use the navigator to
see the individual sub-objects.

-- Workaround - my proposal --

Create flowchart objects for your purposes in Draw and copy them to Writer.

I wish you much success.

Kind regards,
Harald

Am 25.04.2022 um 01:28 schrieb John Kaufmann:

Thanks, Harald. That article is about using frames (including linked frames) to
layout a DTP project; it does not address the Gallery, or even the inclusion of
graphics generally. FWIW, I'm familiar with frames (and even use them in this
document), but don't see how they relate to the question of included graphics,
from the Gallery or elsewhere.

Most of the Gallery contents seem to be traditional clip-art (graphical symbols), including those collected in the
"Flow chart" category. How do those flowchart symbols differ from others? [The Gallery has three other
categories - "BPMN", "Diagrams", "Shapes" - that also contain descriptive text with
graphics; my original question would also apply in those cases.] Is your point that I should forget the Gallery and
make my own graphics (from Draw or elsewhere)? (If so, what is the purpose of the Gallery?)

Kind regards,
John

On 2022-04-24 09:30, lo.harald.ber...@t-online.de wrote:

IMHO, the flowchart symbols are not suitable for your purposes.
For graphical symbols that should contain text, text boxes, drawing symbols or
frames are suitable.
Please have a look if this article helps you:
https://wiki.documentfoundation.org/Videos/Layout_in_Writer

Harald

Am 24.04.2022 um 14:52 schrieb John Kaufmann:

In years of using OO/LO (now @ 7.1.4.2), I have never been interested in the
Gallery of multimedia objects. Now I have an application for it, and can't see
how to execute a simple inclusion of a graphic without its attached descriptive
text.

Specifically: in Writer I have a 4-page booklet/pamphlet in which the two facing inner pages have related
content: The left side (page 2) has a list of summarized thoughts (each a few lines), two of which are
expanded on the right side (page 3). To help the reader make the connection, it seems helpful in both cases
to point from the condensed version to its expansion. The Gallery has a set of "Flow

Re: [libreoffice-users] Using the Gallery - removing the descriptive text


Hi Dave, Regina, John,

see below, as already mentioned in my last e-mail:

Am 25.04.2022 um 17:18 schrieb Dave Barton:

[...snip...]
the PNG graphic cannot be directly edited from within LO.
Right-click on the inserted object (bracket) and then select "Break". 
The text can now be edited.


Kind regards
Harald

[...snip...]

Kind Regards

Dave




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

(resolved) Re: [libreoffice-users] libreoffice grabs network port

2022-04-25 Thread Mike Scott


On 22/04/2022 15:38, Dave Howorth wrote:



What investigation have you done? Why do you think the problem is with
LO rather than with mojolicious or somewhere in between?

Also, what is runcmd()?


Sorry, should have said it's a wrapper for perl's open3() (itself a 
wrapper for system() ) which runs the given command. But see below.

.


Steps I would be thinking of trying:
(1) add debugging prints to the mojolicious code so you can see exactly
what arguments are passed on each occasion
(2) for some case where the problem occurs run LO directly from the
command line with the same arguments and see if the problem occurs



Thanks for the reply. I've been banging my head against a wall, because 
all of mojolicious, perl's IPC and LO are to varying degrees unfamiliar. 
I certainly mis-understood what I was seeing, processes running LO and 
with the web network port listening: it's actually correct and harmless.


The problem is now resolved, and at the root was related to running the 
program detached as a daemon. I had a web server running LO internally, 
which ran correctly from a terminal; ran correctly when detached with 
magic using () and shell redirects; but which failed when run "properly" 
with freebsd's 'daemon' command.


Obvious in hindsight, the issue was that the daemon, running as user 
www, didn't have access to a writeable home directory, so LO couldn't 
run because it needs a rather large file tree there. That was compounded 
with my misunderstanding of perl's open3() error handling.


I'm now using the -env:UserInstallation=XX option to give LO a 
temporary place to put its bits and bobs, and all - finally - seems to 
function. At least, LO runs and does the conversions. I do wonder why 
there's an oosplash process started when I'm using --nologo and 
--headless though! It also creates more soffice.bin processes than I'd 
expect, but they seem to tidy themselves away eventually.


I'm not sure why I had so much trouble here, compared to a couple of 
years ago, when I was running LO from apache/php without particular bother.


All's well that end's well, I guess. Mojolicious has a steep learning 
curve, but is much easier and cleaner to use than php for this job. LO 
works, albeit slowly -- ~20 seconds to do the .odt->.doc conversion on a 
pi4.


Again, thanks.




--
Mike Scott
Harlow, Essex, England

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] Using the Gallery - removing the descriptive text

Hi Regina,

On 2022-04-25 04:25, Regina Henschel wrote:

John Kaufmann schrieb am 24.04.2022 um 14:52:

Do you mean the text, which is included in shapes of theme "Flow chart"? Insert
the object and mark it. Then press key F2 to enter edit mode. Now you can delete the text
with backspace key.

That's it!

Some of the objects in the "Flow chart" gallery theme are groups. In that case
you first need to enter the group (see item in context menu) and then you can select the
object, which actually has the text.

I assumed it was a group, but did not find the key to un-group it. (I was looking for options like
"Ungroup" or "Edit" or "Properties".) I should remember F2, but seldom use it;
now I will do so more often. Still, it would probably be nice if the context menu included that. I should
check bugs.documentfoundation.org to see if someone has filed such request.

As I said to Dave, in the context of the wealth of tools LO offers: every day is a
school day, and I like that. But this episode has raised a sometimes-recurring
question about how those tools are coordinated. Dave suggested to forget the
Gallery (at least for this purpose) and use Insert>Shape to the same end. That
worked fine, but left me wondering about use of the Gallery. You pointed out that
the Gallery is fine for this purpose (in fact, I prefer the equivalent graphic,
which is different from the brace in the Shapes library), for an even better
result.

I'm sure there's a lot of history behind why those two approaches coexist,
apparently independently. Are they in fact independent? Is this a case where
one would prune/rationalize the tools to a common base (maybe with multiple
entry points in the user interface) if time allowed, or is there a positive
benefit from maintaining both the Shapes menu and the Gallery as separate
graphics libraries? If the latter, how do you decide where to add a new graphic
or collection of graphics?

Thanks so much for your insight.

Kind regards,
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] changing currency in a spreadsheet


Hi Dave,

On 2022-04-24 17:26, Dave Howorth wrote:


I have a financial spreadsheet that was designed in the USA but I live
in the UK. Is there any way in LO to change all the cells that are
formatted as numeric $ amounts to be the same format but using the
equivalent numeric £ format instead?


When you do "Format Cells" (Ctrl+1) and select "Currency", do you not get a drop-down "Format" 
menu that allows designation of the currency of choice? (In fact, if you select a "Language" different from your 
default language {Tools > Options > Language Settings > Languages}, it should allow you to select from two different 
currencies at the same time.)

Kind regards,
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] Using the Gallery - removing the descriptive text


Dear John,

first of all, thank you very much for your feedback.
This has led me to probe a little deeper into the theme.

Well I am not a developer but also just a user like you.
Therefore, as a user, you can only ever tell about experiences.

It is also possible that I did not understand your question correctly. 
Sorry, English is not my native language.


But now to the point. I'm glad you are familiar with frames, because 
they are a powerful tool in Writer.


There is also what I hope is a pleasing development for you.
You can use and change the flowchart graphics.
However, this only works in Draw.

I think it is a mistake that this does not work in Writer.
In this respect it would be appropriate to write a bug report.

Now for the differences, which I found out thanks to your feedback.

-- Flow charts in Writer. --

When you insert a flowchart object into Writer, you can't actually 
change it (as I said, probably a bug).

In this example I used the graphic object "Process".
Right-click the object and select Properties from the context menu.
The dialog shows you that it is an image and this is therefore not editable.

-- Flow charts in Draw. --

In Draw, add again the flow chart object "Process".
If you now double-click on the text, the cursor will appear for editing. 
(Heureka)


Try right-clicking on the object.
With "Break" you can learn that it is a composite object. Use the 
navigator to see the individual sub-objects.


-- Workaround - my proposal --

Create flowchart objects for your purposes in Draw and copy them to Writer.

I wish you much success.

Kind regards,
Harald


Am 25.04.2022 um 01:28 schrieb John Kaufmann:
Thanks, Harald. That article is about using frames (including linked 
frames) to layout a DTP project; it does not address the Gallery, or 
even the inclusion of graphics generally.  FWIW, I'm familiar with 
frames (and even use them in this document), but don't see how they 
relate to the question of included graphics, from the Gallery or 
elsewhere.


Most of the Gallery contents seem to be traditional clip-art 
(graphical symbols), including those collected in the "Flow chart" 
category. How do those flowchart symbols differ from others? [The 
Gallery has three other categories - "BPMN", "Diagrams", "Shapes" - 
that also contain descriptive text with graphics; my original question 
would also apply in those cases.]  Is your point that I should forget 
the Gallery and make my own graphics (from Draw or elsewhere)? (If so, 
what is the purpose of the Gallery?)


Kind regards,
John


On 2022-04-24 09:30, lo.harald.ber...@t-online.de wrote:

IMHO, the flowchart symbols are not suitable for your purposes.
For graphical symbols that should contain text, text boxes, drawing 
symbols or frames are suitable.

Please have a look if this article helps you:
https://wiki.documentfoundation.org/Videos/Layout_in_Writer

Harald

Am 24.04.2022 um 14:52 schrieb John Kaufmann:
In years of using OO/LO (now @ 7.1.4.2), I have never been 
interested in the Gallery of multimedia objects. Now I have an 
application for it, and can't see how to execute a simple inclusion 
of a graphic without its attached descriptive text.


Specifically: in Writer I have a 4-page booklet/pamphlet in which 
the two facing inner pages have related content: The left side (page 
2) has a list of summarized thoughts (each a few lines), two of 
which are expanded on the right side (page 3). To help the reader 
make the connection, it seems helpful in both cases to point from 
the condensed version to its expansion.  The Gallery has a set of 
"Flow chart" graphics, including braces and brackets designed to 
serve the function of grouping a few lines and pointing to a 
conclusion. Unfortunately, all come with the description "Callout" 
which is inserted along with the graphic -- kind of like clip-art 
that includes a message "This is clip-art" (as part of the clip-art 
display). This can't be right, can it? - yet I have searched in vain 
(including the Help and Guides) for how to turn off that descriptive 
text. What am I missing?


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] Using the Gallery - removing the descriptive text

2022-04-25 Thread Dave Barton

On 25/04/2022 09:25, Regina Henschel wrote:
> Hi John,
> 
> John Kaufmann schrieb am 24.04.2022 um 14:52:
>> In years of using OO/LO (now @ 7.1.4.2), I have never been interested
>> in the Gallery of multimedia objects. Now I have an application for
>> it, and can't see how to execute a simple inclusion of a graphic
>> without its attached descriptive text.
> 
> Do you mean the text, which is included in shapes of theme "Flow chart"?
> Insert the object and mark it. Then press key F2 to enter edit mode. Now
> you can delete the text with backspace key. Some of the objects in the
> "Flow chart" gallery theme are groups. In that case you first need to
> enter the group (see item in context menu) and then you can select the
> object, which actually has the text.
> 
> If you do not mean the above, please describe in more detail, what you
> mean with "attached descriptive text".
> 
> Kind regards,
> Regina

Hi Regina,

I think the two PNG graphics in the Writer Gallery John is referring to
are left and right curly braces. Both have the word "Callout" ("attached
descriptive text") drawn within the bitmap image, not editable text.

The F2 text addition facility you describe works for the Draw Gallery,
but not for the Writer Gallery and in both cases the word "Callout" in
the PNG graphic cannot be directly edited from within LO.

If I have understood John's original request correctly, "Insert -> Shape
-> Symbol Shapes" -> "Left Brace" or "Right Brace", then anchor,
position and size should satisfy his requirements.

Kind Regards
Dave

-- 
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] Using the Gallery - removing the descriptive text


Thanks, Dave! That did the job nicely.  It's easy to forget how many tools LO 
offers. [For some (like the Gallery) I still have not figured out a use. ;-)]

Every day is a school day,
John
 


On 2022-04-25 02:04, Dave Barton wrote:

I believe Harald was trying to give a more complete answer than the
simple option you were looking for.

Yes, forget the bitmap images in the Gallery Flowchart set, where the
name of the flowchart symbols have the name embedded in them and are
intended to be used in a different situation than you wish to use.


From Writer's main menu select "Insert -> Shape -> Symbol Shapes", then

choose either "Left Brace" or "Right Brace" as required. Once the shape
is drawn and inserted you can freely position and size it to your
requirements.


On 25/04/2022 00:28, John Kaufmann wrote:

Thanks, Harald. That article is about using frames (including linked
frames) to layout a DTP project; it does not address the Gallery, or
even the inclusion of graphics generally.  FWIW, I'm familiar with
frames (and even use them in this document), but don't see how they
relate to the question of included graphics, from the Gallery or elsewhere.

Most of the Gallery contents seem to be traditional clip-art (graphical
symbols), including those collected in the "Flow chart" category. How do
those flowchart symbols differ from others? [The Gallery has three other
categories - "BPMN", "Diagrams", "Shapes" - that also contain
descriptive text with graphics; my original question would also apply in
those cases.]  Is your point that I should forget the Gallery and make
my own graphics (from Draw or elsewhere)? (If so, what is the purpose of
the Gallery?)

Kind regards,
John


On 2022-04-24 09:30, lo.harald.ber...@t-online.de wrote:

IMHO, the flowchart symbols are not suitable for your purposes.
For graphical symbols that should contain text, text boxes, drawing
symbols or frames are suitable.
Please have a look if this article helps you:
https://wiki.documentfoundation.org/Videos/Layout_in_Writer

Harald

Am 24.04.2022 um 14:52 schrieb John Kaufmann:

In years of using OO/LO (now @ 7.1.4.2), I have never been interested
in the Gallery of multimedia objects. Now I have an application for
it, and can't see how to execute a simple inclusion of a graphic
without its attached descriptive text.

Specifically: in Writer I have a 4-page booklet/pamphlet in which the
two facing inner pages have related content: The left side (page 2)
has a list of summarized thoughts (each a few lines), two of which
are expanded on the right side (page 3). To help the reader make the
connection, it seems helpful in both cases to point from the
condensed version to its expansion.  The Gallery has a set of "Flow
chart" graphics, including braces and brackets designed to serve the
function of grouping a few lines and pointing to a conclusion.
Unfortunately, all come with the description "Callout" which is
inserted along with the graphic -- kind of like clip-art that
includes a message "This is clip-art" (as part of the clip-art
display). This can't be right, can it? - yet I have searched in vain
(including the Help and Guides) for how to turn off that descriptive
text. What am I missing?

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] changing currency in a spreadsheet

2022-04-25 Thread Ian Bertram

How are the cells displaying the $ sign formatted? I’m guessing they use the 
currency format. There’s probably a way to automatically select currency cells 
and change the currency, but that’s outside my expertise. Failing that you 
could simply edit the $ settings to use the £ symbol in the correct place with 
the appropriate comma and decimal point settings. That’s a bit clunky though.

If by any chance they are not formatted as currency, but something else, you 
can probably edit that setting to switch the currency symbols. That seems 
unlikely though since you say this is a financial spreadsheet.

Sent fromMailfor Windows

From:Dave HoworthSent:25 April 2022 15:07To:LibreOffice UsersSubject:Re: 
[libreoffice-users] changing currency in a spreadsheet

On Sun, 24 Apr 2022 20:15:15 -0400

Fred James  wrote:

> Dave Howorth wrote:

> > I have a financial spreadsheet that was designed in the USA but I

> > live in the UK. Is there any way in LO to change all the cells that

> > are formatted as numeric $ amounts to be the same format but using

> > the equivalent numeric £ format instead?

> >
> > I don't think there's any logic in the spreadsheet that depends on

> > the currency, it's just doing numerical calculations on the values.

> > But it would be easier to look at if it was in £ rather than $

> > everywhere!

> >

> > Cheers, Dave 

> The $ to £ is merely formatting ...

> -> Format -> Cells -> and then under Numbers, and under Category

> select Currency ... under Format select "GBP £ English (UK)" ... that

> should do it. Unless I am wrong the £ is divided into 100 parts just

> like the $, so there shouldn't be any need to alter calculations

I don't think that does what I want. I would have to select 
every cell

that has a $ amount, and no other cells, and apply the £ currency. But

that also might change the other format aspects - commas and number of

figures after the decimal point and so forth.

What I'm looking for is something that I can apply to the whole sheet,

and that just changes $ to £ wherever it occurs.

> The exchange rate is another matter, of course, if you need to do

> that.

No, it's purely the appearance I'm interested in.

> Regards

> Fred James

PS Please reply to the list, not to me.

--

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

-- 
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] What's with LO 7.3?

2022-04-25 Thread Dan Lewis



On 4/24/22 2:24 PM, MR wrote:

I know, pretty general subject...

I run Xubuntu 21.10 currently on my desktop and I've tried out LO 7.3
because I generally like to run the latest and greatest bleeding edge
available. I'm planning to upgrade to 22.04, but I see that 7.3.2 is the
default with Xubuntu 22.04, and that concerns me.


 All of the Linux distributions have an earlier version that what 
is available on the LibreOffice website. This is because they make some 
changes in the program before adding it to the latest version. Also 
consider that there is a cutoff date for each program included in a 
given version. Generally speaking that date is before the latest version 
of the LibreOffice website comes out.


 When I was working in the documentation project, I would regularly 
download the pre-release versions at this website. Right now I am using 
7.3.3.1 (April 13,2022) for Ubuntu which is Debian based. I think 
Xubuntu is also. I periodically check it for the latest updates. Since 
the version, that does not seem to have any more bad bugs in it, is used 
as the final release, I will be using the final release perhaps a month 
before the website  releases it to everyone.


https://dev-builds.libreoffice.org/pre-releases/deb/x86_64/

Dan



In Writer, the last worked position no longer matches correctly when I
reopen a doc I was working on before and closed. It seems to come up at a
random position somewhere near but not exactly where I was. This not
happened since 7.2 was fixed for this, somewhere around 7.2.2 IIRC. Even
when I was at the end of the doc, it reopens somewhere above that. This one
is easy to recover, not so much of it's supposed to be at a different
position where I actually was last editing.

Calc does not have this problem, but the newish 'recall last similar entry'
feature only partially matches the actual most recent, and it's not clear
how to accept that part and continue in the same cell. Tab and right arrow
both advance to the next cell, even if there's more to match in the current
cell. How do I accept the partial match and continue in the same cell
without retyping the whole match? That makes the partial match useless.

Any help, comments, suggestions welcome.

Thanks.

Mark



--
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] Using the Gallery - removing the descriptive text


Hi John,

Additions: Inside a group the short F2 might not work to bring the 
object in edit mode. Try double-click on the text.


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] changing currency in a spreadsheet

2022-04-25 Thread Dan Lewis



On 4/24/22 5:26 PM, Dave Howorth wrote:

I have a financial spreadsheet that was designed in the USA but I live
in the UK. Is there any way in LO to change all the cells that are
formatted as numeric $ amounts to be the same format but using the
equivalent numeric £ format instead?

I don't think there's any logic in the spreadsheet that depends on the
currency, it's just doing numerical calculations on the values. But it
would be easier to look at if it was in £ rather than $ everywhere!

Cheers, Dave


 Try this: select the columns that contained the currency amounts. 
Then right click on one of them making sure that all of them are 
selected. Select "Format cells". When the dialog appear, look for the 
language setting. Change it from English(USA) to English(UK). Make sure 
the the Category is what you want it as well as the Format. Click OK, 
and save the spreadsheet.


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] Using the Gallery - removing the descriptive text


Hi John,

John Kaufmann schrieb am 24.04.2022 um 14:52:
In years of using OO/LO (now @ 7.1.4.2), I have never been interested in 
the Gallery of multimedia objects. Now I have an application for it, and 
can't see how to execute a simple inclusion of a graphic without its 
attached descriptive text.


Do you mean the text, which is included in shapes of theme "Flow chart"? 
Insert the object and mark it. Then press key F2 to enter edit mode. Now 
you can delete the text with backspace key. Some of the objects in the 
"Flow chart" gallery theme are groups. In that case you first need to 
enter the group (see item in context menu) and then you can select the 
object, which actually has the text.


If you do not mean the above, please describe in more detail, what you 
mean with "attached descriptive text".


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] Using the Gallery - removing the descriptive text

2022-04-25 Thread Dave Barton

I believe Harald was trying to give a more complete answer than the
simple option you were looking for.

Yes, forget the bitmap images in the Gallery Flowchart set, where the
name of the flowchart symbols have the name embedded in them and are
intended to be used in a different situation than you wish to use.

From Writer's main menu select "Insert -> Shape -> Symbol Shapes", then
choose either "Left Brace" or "Right Brace" as required. Once the shape
is drawn and inserted you can freely position and size it to your
requirements.


On 25/04/2022 00:28, John Kaufmann wrote:
> Thanks, Harald. That article is about using frames (including linked
> frames) to layout a DTP project; it does not address the Gallery, or
> even the inclusion of graphics generally.  FWIW, I'm familiar with
> frames (and even use them in this document), but don't see how they
> relate to the question of included graphics, from the Gallery or elsewhere.
> 
> Most of the Gallery contents seem to be traditional clip-art (graphical
> symbols), including those collected in the "Flow chart" category. How do
> those flowchart symbols differ from others? [The Gallery has three other
> categories - "BPMN", "Diagrams", "Shapes" - that also contain
> descriptive text with graphics; my original question would also apply in
> those cases.]  Is your point that I should forget the Gallery and make
> my own graphics (from Draw or elsewhere)? (If so, what is the purpose of
> the Gallery?)
> 
> Kind regards,
> John
> 
> 
> On 2022-04-24 09:30, lo.harald.ber...@t-online.de wrote:
>> IMHO, the flowchart symbols are not suitable for your purposes.
>> For graphical symbols that should contain text, text boxes, drawing
>> symbols or frames are suitable.
>> Please have a look if this article helps you:
>> https://wiki.documentfoundation.org/Videos/Layout_in_Writer
>>
>> Harald
>>
>> Am 24.04.2022 um 14:52 schrieb John Kaufmann:
>>> In years of using OO/LO (now @ 7.1.4.2), I have never been interested
>>> in the Gallery of multimedia objects. Now I have an application for
>>> it, and can't see how to execute a simple inclusion of a graphic
>>> without its attached descriptive text.
>>>
>>> Specifically: in Writer I have a 4-page booklet/pamphlet in which the
>>> two facing inner pages have related content: The left side (page 2)
>>> has a list of summarized thoughts (each a few lines), two of which
>>> are expanded on the right side (page 3). To help the reader make the
>>> connection, it seems helpful in both cases to point from the
>>> condensed version to its expansion.  The Gallery has a set of "Flow
>>> chart" graphics, including braces and brackets designed to serve the
>>> function of grouping a few lines and pointing to a conclusion.
>>> Unfortunately, all come with the description "Callout" which is
>>> inserted along with the graphic -- kind of like clip-art that
>>> includes a message "This is clip-art" (as part of the clip-art
>>> display). This can't be right, can it? - yet I have searched in vain
>>> (including the Help and Guides) for how to turn off that descriptive
>>> text. What am I missing?
>>>
>>> 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] Using the Gallery - removing the descriptive text