Re: [libreoffice-users] calc chart problems

[Brian Barker]

At 19:18 18/01/2021 -0500, Marianne Keating wrote:
I am using 4.4.7.2, under Windows 7, because it 
seems more than adequate for my purposes, and I 
am somewhat dismayed by the number of 
regressions noted for later versions in the comments here.


It's probably unwise to use any out-of-date 
software, which will not have been patched for 
security flaws and so on. Try a later version, notwithstanding regressions.


Calc chart legends. What could be simpler, yet 
more impossible? I have cracked this at sometime 
in the past, as I have just one spreadsheet with 
my own chart legend text in my choice of fonts, 
but can see no way of regaining that control for 
other charts in my armamentarium. If I 
right-click a chart, I am presented with 15 options.


First, what you see in the context menu depends 
on the current state of selection of the chart. 
What you are describing is the context menu seen 
when the chart is simply selected - so that it 
shows the eight coloured handles.


One is marked “Text”, which seems promising, but 
apparently deals with *positioning*, not content.


That's right: this deals with positioning of items generally.

The thing which it definitely lacks is any 
ability to control the legend text contents, or font.


To do that, you need to select the chart first.


If I double left-click ...


And that's how you select the chart - so that it shows a grey border.

... and then right-click, I now have 9 options, 
including one which will delete a legend, 
(leaving me unsure of what happens if the chart has more than one legend).


No problem: the legend is what labels the various 
data ranges, so charts have only one legend.


But, in any case, no control, beyond excision, 
over the legend text or its font.


To format the legend, first select the legend - 
so that *it* shows the eight coloured handles - 
and then use Format Legend... from the context menu.


When I double left-click, I get an interesting 
collection of mostly-graphic symbols at the bottom of my screen, ...


That's the Drawing toolbar.

One of these is a capital T in a dotted-line 
box, which, when hovered-over, reads: “Text 
Box”. Sounds promising, but what does it do, ...


It creates a (by default invisible) rectangular box to contain text.


... and how does one invoke whatever its action may be?


Click the "T" ("A" in the more recent version you 
should be using!). Note that the cursor (when in 
the chart) changes appearance. Drag the cursor to define the desired box.


None of these symbols can be dragged onto the 
chart, and clicking them – single or double, 
left or right – produces no obvious result of any kind.


First click; then drag in (not into) the chart.

They have interesting titles, and, if they did 
anything, might be quite useful.


You give the distinct impression that you have 
not read any of the documentation. Everything is 
in "Adding drawing objects to charts" in Chapter 
3, "Creating Charts and Graphs" of the Calc Guide.


My first question, then, is: /how do I gain 
control over chart legend text & font?/


See above. (Though I think you may be asking not 
about the chart legend but instead axis titles, or even a chart title.)



And a subsidiary wonderment: /why is it so hard to find this answer?/


It's not. Again it's all in "Legends" and 
"Titles, subtitles, and axis names" in Chapter 3, 
"Creating Charts and Graphs", of the Calc Guide.



From the on-line manual:


Two points here:
o I find it easier not to use on-line facilities 
but instead to download the guides. If you choose 
the PDF versions, you can display them locally 
and easily search for what you require.
o I'm not at all sure why you choose to copy lots 
of material from documentation in your message. 
Surely this is what *you* should be reading, not anyone offering to help you?



To edit a chart legend:
1. Double-click on the chart. A gray border 
appears around the chart and the menu bar now 
contains commands for editing the objects in the chart.
2. Choose Format - Legend or double-click on the 
legend. This opens the Legend dialog.

3. Choose from the available tabs to make modifications, then click OK.
This is no help, as the “available tabs” do 
*not* allow editing the text or font.


You can change the font on the Font tab. You can 
change the text by changing the contents of the 
spreadsheet cells that you originally included 
for this purpose. Alternatively you can use Data 
Ranges... from the context menu to allow you to 
change which cells are referenced.



From the on-line edition of the 4.1 Calc Guide we have, at ppg 88-89:
To add a legend to your chart:
[...]
To remove a legend from your chart:
[...]
Again, the user can add or remove, but not edit.


Well, just as advertised, then?!


Another dead-end source illuminates another Calc problem:
https://ask.libreoffice.org/en/question/...


There is no guarantee that answers on any forum - 
or indeed here on the Users mailing list - will be valuable or 

Re: [libreoffice-users] what's included in file properties record

[Philip Jackson]

On 21/01/2021 09:35, Ian Graham wrote:

I set up a new computer in December, on which I'm in 6.0.7.3.

I have imported various dox originally created in earlier versions on
other computers. In one of those, the Statistics tab includes eg the
date originally created, and date modified. But looking in the same
place re a file created on this machine in 6.0.7.3, those categories
don't even appear as blanks.


The date created and date modified are under the General tab of Properties

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

[libreoffice-users] Re: [libreoffice-documentation] Metadata Loss LO 7.1.0.2

[Dave Barton]

On 21/01/2021 12:59, Ilmari Lauhakangas wrote:
> On 21.1.2021 14.50, Dave Barton wrote:
>> Version: 7.1.0.2 (x64) / LibreOffice Community
>> Build ID: 53d68d29d90fd16448721a60aad68c28ff0809f5
>> CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster;
>> VCL: win
>> Locale: en-US (en_US); UI-Language: en-US
>> Calc: threaded
>>
>> Before raising a bug report I would like to know if anyone else is
>> seeing this issue:
>>
>> * Normally when a new document is created in Writer the Document
>> Properties Title field is automatically filled with the name of the
>> template (eg. Default) upon which the document is based.
>>
>> * Changing the Document Properties Title field in a new or existing
>> document blanks the field in the saved file.
>>
>> * Opening the saved file in any other version of LO restores the field
>> lost in version 7.1.0.2
> 
> Are you sure you are getting "Default" in the title? I only get a
> pre-filled title with some template like Modern business letter. Works
> fine with 7.2 at least.
> 
> Ilmari

Yes I get "Default" in the title field with 7.0.4.2 (x64) and all 6.x
versions, but that is down to my profile, otherwise I get the same as you.

The real issue is that 7.1.0.2 anything entered in the title field of a
new or existing document is lost (more accurately disappears) on save.

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

[libreoffice-users] Metadata Loss LO 7.1.0.2

[Dave Barton]

Version: 7.1.0.2 (x64) / LibreOffice Community
Build ID: 53d68d29d90fd16448721a60aad68c28ff0809f5
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster;
VCL: win
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

Before raising a bug report I would like to know if anyone else is
seeing this issue:

* Normally when a new document is created in Writer the Document
Properties Title field is automatically filled with the name of the
template (eg. Default) upon which the document is based.

* Changing the Document Properties Title field in a new or existing
document blanks the field in the saved file.

* Opening the saved file in any other version of LO restores the field
lost in version 7.1.0.2

Thanks
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

[libreoffice-users] [libreoffice-documentation] Metadata Loss LO 7.1.0.2

[Dave Barton]

Version: 7.1.0.2 (x64) / LibreOffice Community
Build ID: 53d68d29d90fd16448721a60aad68c28ff0809f5
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster;
VCL: win
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

Before raising a bug report I would like to know if anyone else is
seeing this issue:

* Normally when a new document is created in Writer the Document
Properties Title field is automatically filled with the name of the
template (eg. Default) upon which the document is based.

* Changing the Document Properties Title field in a new or existing
document blanks the field in the saved file.

* Opening the saved file in any other version of LO restores the field
lost in version 7.1.0.2

Thanks
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

[libreoffice-users] what's included in file properties record

[Ian Graham]

Good morning, everyone. 

I would be grateful for some help and info re what appears in the
various tabs of the Properties of a file, particularly in Writer.

I set up a new computer in December, on which I'm in 6.0.7.3.

I have imported various dox originally created in earlier versions on
other computers. In one of those, the Statistics tab includes eg the
date originally created, and date modified. But looking in the same
place re a file created on this machine in 6.0.7.3, those categories
don't even appear as blanks.

Can I configure this ? I've found nothing relevant in 'Help'.

Sincerely

Ian Graham



-- 
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] Con50: Quarantine errors

[Hylton Conacher (ZR1HPC)]

Hi Lizel,

Please add the following addresses onto the back-end of FortiMail.








Thanks
Hylton

--
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] LO help communities

[Dave Howorth]

On Thu, 21 Jan 2021 03:17:38 -0500
John Kaufmann  wrote:

> This is a meta-question about help for LibreOffice questions.
> 
> (1) LibreOffice has a comprehensive array of mailing lists

[snip]

> (2) There is another great resource, the AskLibO system
> .

[snip]

> (a) With that context, here is my question, essentially comparing the
> communities in the mailing list  and
> the AskLibO forum : There are some
> really thoughtful people in both communities, but [with notable
> exceptions] most do not seem to mix from one to the other, though
> both communities cover the same scope of questions. It makes sense
> that people are not active in both places: there are limited hours in
> the day. But I'm never sure where is the best place to ask a use
> question, and at the same time would like to pay back something in
> the form of information to whichever community I use. How do others
> handle that issue?

I can only speak for myself, although I suspect others also think
similarly. I prefer the medium of mailing lists to that of forums in
general. It may be to do with previous experience and age in general.
So I use mailing lists whenever they are available, and forums only if
I must. Hence I subscribe to this list, and ask questions here when I
need to and otherwise use a search engine to find relevant pages on the
web, which might include hits on the forums.

[snip]

-- 
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] LO help communities

[John Kaufmann]

This is a meta-question about help for LibreOffice questions.

(1) LibreOffice has a comprehensive array of mailing lists 
 @global.libreoffice.org, each of which 
seems to be reflected and archived in Nabble 
. 
(This list  is one of those lists.) That combination is a 
wonderful resource.

In addition to global lists @global.libreoffice.org (all in English), there 
are dozens of local/regional/national lists @.libreoffice.org, which vary 
in scope and quality and lack the Nabble archive.

Finally, there are global lists @documentfoundation.org, and a set of 
development and QA lists at freedesktop.org. These are all beyond the scope of 
my question here.

(2) There is another great resource, the AskLibO system 
. It is less comprehensive in scope than the mailing 
list system @global.libreoffice.org, essentially covering the scope of this users list. It 
does so in 15 languages, but English has by far the most traffic, so is roughly equivalent 
to this list .


(a) With that context, here is my question, essentially comparing the communities in the 
mailing list  and the AskLibO forum 
: There are some really thoughtful people in both 
communities, but [with notable exceptions] most do not seem to mix from one to the other, 
though both communities cover the same scope of questions. It makes sense that people are 
not active in both places: there are limited hours in the day. But I'm never sure where is 
the best place to ask a use question, and at the same time would like to pay back something 
in the form of information to whichever community I use. How do others handle that issue?

(b) Having asked that question, I offer my own (incomplete) take on it: Because 
time is limited, a mailing list (or newsgroup) has an inherent push advantage 
over a web forum; you don't have to check into the forum to see questions. 
That's why AskLibO pushes a daily list of questions by mail, and you then 
follow the links in the mail. OTOH, the web forum is its own archive, which has 
advantages. Am I missing anything in the advantages of each?

(c) Having said that AskLibO pushes a daily list of questions/links, there is 
one additional fillip: When you contribute an answer to a question, you become 
part of a mailing list group for that question. When there is an update due to 
one or more new contributions, you get mail with a digest of the issue and a 
link to return to the question page -- which seems fair enough, except that the 
digest can contain comments that never make it onto the question page! So you 
can have someone answer a follow-up question or comment in the mailed digest, 
but only the answer, and not the question, is recorded on the question page! 
The result can be disorienting (hard to follow the thread), and of course gives 
an incomplete record of the discussion. Unfortunately, I don't even know who or 
how to ask about that (including how user comments or questions even get into 
the digest if they are not on the page!) in AskLibO. If anyone knows how that 
works, I would love some direction.

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