Re: [libreoffice-users] Help for Libreoffice portable

[Dave Howorth]

On Wed, 15 May 2024 16:14:31 -0300
ady  wrote:

> > I would like to get help for LibreOffice
> > portable in Czech. Is it somewhere to download it, please? Best
> > regards  
> 
> For the (Windows) portable package, the offline help is available in
> English only.
> 
> In the LibreOffice download site, you could select to download a Help
> package to _install_, but I am not sure how it would work with your
> _portable_ version. I guess you really need to know what you are doing
> in order to mix these 2 packages. Generally speaking, I wouldn't
> recommend it.
> 
> Since you are using the portable package, I guess that the simplest
> way to read the help content in Czech would be to read it on-line:
> 
> For LO 7.6:
> 

FWIW that link is unusable for me. As are each of the others below. They
all take me to
https://help.libreoffice.org/latest/en-US/text/swriter/main.html

which sits there apparently constantly reloading the page. This is
using FF 115.11.0esr with the NoScript add-on that is set to disable
scripting on 'new' sites such as this one is to my browser.

wget appears to fetch and save the correct new_help.html but I haven't
investigated to see what FF finds so objectionable.

> For LO 24.2:
> 
> 
> For the "latest" version (a moving target):
> 
> 
> HTH,
> Ady.

-- 
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] Window size.

[Dave Howorth]

On Fri, 1 Mar 2024 12:10:32 -0500
Ami Sigall  wrote:

> Hi.
> 
> 
> Ubuntu linux 23.04
> 
> LibreOffice 7.6.4.1 but earlier as well
> 
> 
> I've seen this come up from time to time. It's pretty rare for me.
> Once in a great (thankfully) while, when I open a Writer document (I
> keep mine in DOCX), the Writer icon on the dashboards says Writer
> fired up and is running, but I don't see the window. Turns out, the
> window is there, it's just very small, like a few pixels wide and few
> longer long. It's so small I didn't even see it at first. I had to
> start minimizing windows until I ran across this little line at the
> top of the screen which responded by display the double headed arrow
> for size altering when I moused over it.
> 
> Up until just a few minutes ago, I thought this was restricted to LO 
> Writer.
> 
> Apparently not. The same problem just occurred with my Thunderbird
> mailer.
> 
> Was there ever a resolution to this issue?

Ami/Chris

If the problem occurs with Thunderbird as well as with LibreOffice then
the problem is not with LO, but most likely in your desktop
environment. So you need to take your problem to your distro's mailing
list or forum rather than an LO mailing list.

-- 
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] failed update attempts

[Dave Howorth]

On Sun, 25 Feb 2024 23:55:41 +
Peter Hillier-Brook  wrote:

> On 25/02/2024 15:17, Graeme Eldridge wrote:
> > Hello,
> > 
> > I am running your version 7.6.0.3 quite successfully but thinking I 
> > really should update to 7.6.4 or better just as a matter of best 
> > practice.  That fails because the installer cannot remove version 
> > 7.4.7!  This is logical only in the sense that version 7.4.7 isn't
> > there and has never been there.  Trying to simply uninstall 7.6.03
> > fails exactly the same way as does hiding the Libre Office folder
> > and attempting a "clean" install.
> > 
> > How do I fix this without buying a new machine (64 bit Windows 10)?
> > 
> > Thank you,
> > 
> > Graeme
> > 
> > PS.  Trying to install version 26.2 fails similarly
> >   
> Why don't you do the obvious and remove all previous versions prior
> to installing the required update?

Because a previous version works, and they don't want to leave
themselves without a working system?

-- 
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] Account no longer works

[Dave Howorth]

On Sun, 11 Feb 2024 11:46:45 +
SpuzPSO  wrote:

> Hello, I am trying to log into my account today but I am told it is
> the wrong credentials so I attempt to reset password and it says my
> username and password are not recognised
> 
> My username is Spuz which has a profile as shown here:
> https://ask.libreoffice.org/u/spuz/summary My email is this one.

Given that you haven't logged in since 2021 it seems likely that you
need to reset your password.
 
> Kind Regards,
> 
> Samuel Young
> 
> 


-- 
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] How did y DOCX become read only?

[Dave Howorth]

On Tue, 31 Oct 2023 11:31:16 -0400
"Chris J."  wrote:

> Running LO 7.5.7.1 on  Ubuntu 23.04.
> 
> The goal here is to submit a DOCX to my editor who will do
> corrections etc to the document and put in margin comments. Said DOCX
> has to be read/write to do this. I've been assembling the DOCX by
> hand chapter by chapter, which is a pain in the butt. Enter the ODM.
> 
> It makes sense to me that the ODM would b read-only. It's really just
> a collection of links. To get the the DOCX I did the following Save
> as... and exports, ODM -> ODT -> DOCX.
> 
> The Read-Only attribute of the ODM has propagated through to the
> DOCX. Is there any way to remove this and make the DOCX read/write?
> I've tried a number of things, no joy.  TY.

https://ask.libreoffice.org/t/can-i-save-a-master-document-in-a-docx-format/63593
 ?

-- 
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] Help: Convert a Multi-Page Text/word file to PNG using LibreOffice API in JAVA

[Dave Howorth]

On Sun, 29 Oct 2023 17:17:48 +
Madhu Patel  wrote:

> Hi folks,
> 
> It would be great if I can get an official response and/or update in
> the documentation, so that we can forward the dependency proceedings
> internally.

Please don't send individual copies of any replies to me. I read the
list. And please don't top post. And why have you stillnot explained
what was wrong with the previous suggested workaround?

If you want professional support, you might like to look at
https://www.libreoffice.org/get-help/professional-support/

> Thanks
> 
> From: Madhu Patel 
> Date: Monday, 9 October 2023 at 3:03 PM
> To: Dave Howorth , users@global.libreoffice.org
> , documentfoundat...@maxired.fr
> , aguador 
> Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word
> file to PNG using LibreOffice API in JAVA Hi folks,
> 
> It would be great if I can get an official response and/or update in
> the documentation, so that we can forward the dependency proceedings
> internally.
> 
> Thanks
> 
> From: Madhu Patel 
> Date: Saturday, 30 September 2023 at 8:50 PM
> To: Dave Howorth , users@global.libreoffice.org
> , documentfoundat...@maxired.fr
> , aguador 
> Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word
> file to PNG using LibreOffice API in JAVA From: Dave Howorth
>  Date: Thursday, 28 September 2023 at 1:47 AM
> To: users@global.libreoffice.org 
> Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word
> file to PNG using LibreOffice API in JAVA EXTERNAL: Use caution when
> clicking on links or opening attachments.
> 
> 
> On Tue, 26 Sep 2023 14:46:07 +
> Madhu Patel  wrote:
> 
> > Can someone please direct me to the documentation about conversion
> > of Multi-page of Text file to PNG using LibreOffice API.
> >
> > Bug link-
> > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.documentfoundation.org%2Fshow_bug.cgi%3Fid%3D157425=05%7C01%7Cmadhup%40adobe.com%7C615113b640074ca7e1f908dbbf96ba8f%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638314426344958861%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=2I2ntKjnoH5u3ufEGZI0YyOMjeVpGboOuAaVRFEJo90%3D=0<https://bugs.documentfoundation.org/show_bug.cgi?id=157425>
> >
> > Ref:-
> > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FLibreOffice%2FUNOHelper%2Fissues%2F41%23issuecomment-1732949888=05%7C01%7Cmadhup%40adobe.com%7C615113b640074ca7e1f908dbbf96ba8f%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638314426344958861%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=aRi2sjMa9E51OIYAGLyu9ntjr0suF%2Fg9ZssPNZzzYWE%3D=0<https://github.com/LibreOffice/UNOHelper/issues/41#issuecomment-1732949888>
> >
> >
> > If it is not possible to convert a Multi-page text file to PNG using
> > LibreOffice, where it is mentioned in the documentation.  Should I
> > send a PR for this, if it is not.
> >
> > Thanks for your time.
> >
> > From: aguador 
> > Date: Tuesday, 26 September 2023 at 2:49 PM
> > To: users@global.libreoffice.org 
> > Subject: Re: [libreoffice-users] Help: Convert a Multi-Page
> > Text/word file to PNG using LibreOffice API in JAVA EXTERNAL: Use
> > caution when clicking on links or opening attachments.
> >
> >
> > El lun, 25-09-2023 a las 04:20 +, Madhu Patel escribió:  
> > > Hey folks!
> > >
> > > How to convert a Multi-Page Text file to PNG, for example:- I
> > > have a Text document of 5 pages and I want to convert that into
> > > PNG. By default, it's giving a PNG of only 1st page. How to get
> > > the PNG file for ith page using LibreOffice.
> > > I used the PageRange filter like this, but it does not work, it's
> > > also giving the PNG only for 1st page.
> > > Also, I'm not able to generate multiple PNGs for multi-page word
> > > files using the LibreOffice Application
> > > CLI:-
> > > soffice --convert-to
> > > 'png:writer_png_Export:{"PageRange":{"type":"string","value":"2-"}}'
> > > test.odt
> > >
> > > JAVA:-
> > > conversionProperties[0] = new com.sun.star.beans.PropertyValue();
> > > conversionProperties[0].Name = "FilterName";
> > > conversionProperties[0].Value ="writer_png_Export";
> > >
> > > conversionProperties[1] = new com.sun.star.beans.PropertyValue();
> > > conversionProperties[1].Name = "PageRange";
> > > conversionProperties[1].Value ="2-";
> > >

Re: [libreoffice-users] MailMerge Bug Report

[Dave Howorth]

On Tue, 24 Oct 2023 08:22:17 +1300
Steve Edmonds  wrote:

> Hi. What do you call a large list.

Did you look at the bug report?

> On 24/10/2023 06:40, Reinhard Klapproth wrote:
> > Hi,
> >
> > I've reported a bug on bugzilla concerning Libreoffice Writer 
> > MailMerge on Oct. 10:
> >
> > https://bugs.documentfoundation.org/show_bug.cgi?id=157691
> >
> > MailMerge ist bloating pdf files when mailing to a large list of 
> > recipients. No one has yet confirmed the bug. That might be
> > difficult, because the error only occurs when mailing to a large
> > list. Has anyone an idea what can be done about the bug?
> >
> > Reinhard
> >  
> 
> 


-- 
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] Help: Convert a Multi-Page Text/word file to PNG using LibreOffice API in JAVA

[Dave Howorth]

On Tue, 26 Sep 2023 14:46:07 +
Madhu Patel  wrote:

> Can someone please direct me to the documentation about conversion of
> Multi-page of Text file to PNG using LibreOffice API.
> 
> Bug link- https://bugs.documentfoundation.org/show_bug.cgi?id=157425
> 
> Ref:-
> https://github.com/LibreOffice/UNOHelper/issues/41#issuecomment-1732949888
> 
> 
> If it is not possible to convert a Multi-page text file to PNG using
> LibreOffice, where it is mentioned in the documentation.  Should I
> send a PR for this, if it is not.
> 
> Thanks for your time.
> 
> From: aguador 
> Date: Tuesday, 26 September 2023 at 2:49 PM
> To: users@global.libreoffice.org 
> Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word
> file to PNG using LibreOffice API in JAVA EXTERNAL: Use caution when
> clicking on links or opening attachments.
> 
> 
> El lun, 25-09-2023 a las 04:20 +, Madhu Patel escribió:
> > Hey folks!
> >
> > How to convert a Multi-Page Text file to PNG, for example:- I have a
> > Text document of 5 pages and I want to convert that into PNG. By
> > default, it's giving a PNG of only 1st page. How to get the PNG file
> > for ith page using LibreOffice.
> > I used the PageRange filter like this, but it does not work, it's
> > also giving the PNG only for 1st page.
> > Also, I'm not able to generate multiple PNGs for multi-page word
> > files using the LibreOffice Application
> > CLI:-
> > soffice --convert-to
> > 'png:writer_png_Export:{"PageRange":{"type":"string","value":"2-"}}'
> > test.odt
> >
> > JAVA:-
> > conversionProperties[0] = new com.sun.star.beans.PropertyValue();
> > conversionProperties[0].Name = "FilterName";
> > conversionProperties[0].Value ="writer_png_Export";
> >
> > conversionProperties[1] = new com.sun.star.beans.PropertyValue();
> > conversionProperties[1].Name = "PageRange";
> > conversionProperties[1].Value ="2-";
> >
> > thanks!
> >  
> This does not really solve the direct conversion problem, but given
> that the document is short, why no export pdfs of each page and then
> convert them to png?
> 
> Best,
> aguador

Why are you top-posting a new post instead of responding to what
aguador wrote? Please learn email etiquette (and bug reporting
etiquette!)

And why are you ignoring the suggestion, given that is what is already
posted as a workaround in the bug report you linked to? If it won't
work for you, you need to explain why.

-- 
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] optimal width always

[Dave Howorth]

On Wed, 12 Jul 2023 11:41:16 +0100
Brad Rogers  wrote:

> On Wed, 12 Jul 2023 12:09:29 +0200
> hw  wrote:
 
> >It is actually the most-used functionality when working with  
> 
> By you.  I never use it.  It's something that's usually done once per
> sheet, IME, if at all.  "Fit and forget", if you will.  

Indeed, I wasn't even aware that the concept existed  until I read this
thread. I just tested the feature and it gave a completely unusable
spreadsheet layout as a result, so I'll now forget it exists :)

-- 
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] Help please with multipage document.

[Dave Howorth]

On Thu, 6 Jul 2023 21:19:51 +0100
Brad Rogers  wrote:

> On Thu, 6 Jul 2023 20:39:41 +0100
> Budge  wrote:
> 
> Hello Budge,
> 
> >I see the screenshot didn't copy.  Is this a settings thing here or
> >rule for the site?  
> 
> _All_ attachments are stripped.
> 
> Document opened fine here.  Yes, it opened as a single column, but you
> can change that by selecting one of the other two layout icons in the
> bottom toolbar (assuming default layout of LO).

It's an 8-page document and opens exactly as I would expect with each
page shown above the next page. I'm not sure how else to expect a
document to be shown?

If you can see the whole document, it sounds like you need to adjust
the zoom level (View Menu/Zoom) and choose Entire Page or somesuch.

-- 
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] Help please with multipage document.

[Dave Howorth]

On Thu, 6 Jul 2023 16:42:26 +0100
Brad Rogers  wrote:

> On Thu, 6 Jul 2023 16:15:34 +0100
> Budge  wrote:
> 
> Hello Budge,
> 
> >How may I break this down into individual pages within the document
> >please so I may work on each page and then page down?  
> 
> I could only find one .docx file there and it opened fine.

I found one 5 pages long at visitengland and one 3 pages long at
visitbritain :( They both opened fine :)

As Steve suggests, posting the URL of the failing document would be
helpful.

-- 
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] how to remove wasted space on a graph

[Dave Howorth]

I'm trying to draw a graph in LO calc for the first time. It's a time
series so very wide and not too high. I've managed to draw a graph that
is roughly what I want but there's a lot of wasted space at the left
and right ends (before and after the data). The data covers a fortnight
(i.e. 14 days) but the graph shows two blank days before the graph and
another two days after it. How can I reduce or eliminate that wasted
space?

(There's a lot of wasted space above and below the graph too but that's
not so important)

Also, is it possible to make the graph wider than the screen so that it
needs a horizontal scroll bar, as a separate feature to scrolling the
whole spreadsheet window?

TIA, 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] Image Anchor Selection

[Dave Howorth]

On Tue, 13 Jun 2023 12:58:07 +
"W. Robert J. Funnell, Prof."  wrote:

> Mike -
> 
> That's not a bad idea, but it might be messy to implement. An easier
> alternative would be to just change 'To page' to 'To page
> (deprecated)' or 'To page (avoid using)'.

Easier yes but a lot less helpful. It doesn't help anybody understand
why the change was made nor how to find the 'deprecated' facility which
will continue to exist in fact.

> - Robert
> 
> From: Mike Scott 
> Sent: June 12, 2023 12:05
> To: users@global.libreoffice.org 
> Subject: Re: [libreoffice-users] Image Anchor Selection
> 
> A thought in passing - it would seem the OP's issue is that the UI has
> changed, but he had no (ready) way of knowing in what way. In this
> case a context menu item has been moved to the depths of a dialogue
> box.
> 
> Might it be a good idea, when this is done, to leave the original menu
> entry in place, but have it just show an information box saying where
> the item can be found and maybe give a pointer to [a web page with]
> some hints on the matter? And leave that in place for several
> releases.
> 
> 


-- 
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] Help finding the last piece of writing

[Dave Howorth]

On Tue, 6 Jun 2023 10:50:47 +0100
Angeline Ball  wrote:

> Hi there,
> I am in a blind panic.
> I am trying to find a writing document I am working on.
> I have saved it at various times but really wanted the last one I
> worked on. I always save it but can’t seem to find it at the moment.
> It usually appears in my desktop I put all of them into a file but
> when I open libre it’s not showing the most recent version I worked
> on. Can anyone please help me.

In addition to all the other good suggestions, you might want to check
whether there is a backup of it. On my computer everything is under
~/.config/libreoffice and there are many files in a backup directory a
couple of levels down from there. You can check whether backups are
enabled using the Tools/Options/'Load/Save'/General menu/dialog and you
can check the exact place in Tools/Options/Libreoffice/Paths

> Thank you,
> Angeline 
> 
> Sent from my iPhone


-- 
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] Fw: Potential bug printing blank Writer tables

[Dave Howorth]

On Fri, 05 May 2023 19:36:40 +
dboland9  wrote:

> The version is 7.5.2.
> 
> Normally, when I post a question,  get a copy of my post.  That did
> not happen, so I assumed something went wrong.
> 
> Dave,

Instead of assuming, it's usually best to check whether your posting is
in the archives, as listed in every email:

List archive: https://listarchives.libreoffice.org/global/users/

-- 
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] blood pressure readings template

[Dave Howorth]

On Tue, 18 Apr 2023 18:56:56 +
dboland9  wrote:

> A template really isn't needed.  All you need are:
> - A title in one of the cells on the first row.  For example "My
> Blood Pressure Readings".
> - Leave a row space for readability.
> - On row three, add these column headings starting with column 1:
>   "Date", "Time", "Systolic", "Diastolic", "Pulse", "Notes"
> - You may want to make the column headings bold for readability.
> - Start recording the readings in the spreadsheet.
> 
> Once you have a few readings, you can highlight the range and create
> a chart that will show you how the blood pressure is varying by day
> or time, and any other special situation noted in Notes column.
> 
> Very easy actually.
> 
> Dave,

In addition to what everybody else has already offered I'd ask why you
think you need a template? Has the GP asked for some particular format
of spreadsheet? How will they use the information after you submit it?

> --- Original Message ---
> On Tuesday, April 18th, 2023 at 1:31 PM, V Stuart Foote
>  wrote:
> 
> 
> > [libreoffice-users]
> > Serena Clooney
> > Tue, 18 Apr 2023 18:01:50 +0100
> > Hi
> >
> > I wonder if you could please help me.
> >
> > We have been asked to record my 92 yr old mum's blood pressure
> > readings at
> > home and to present the results in spreadsheet form to our GP.
> >
> > Can anyone help with a Libreoffice template to help record these
> > daily readings,please?
> >
> > Many thanks
> > Srena
> >
> > --
> >
> > Have a look at these templates, either might work for you.
> >
> > https://extensions.libreoffice.org/en/extensions/show/blood-pressure-weight-body-mass-index-tracking
> >
> > or
> >
> > https://extensions.libreoffice.org/en/extensions/show/body-parameters-monitor
> >
> > --
> > V Stuart Foote
> >
> > --
> > 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] Combining vertical text direction of page with ‘right-to-left’ text direction of a table

[Dave Howorth]

On Mon, 10 Apr 2023 18:38:18 +0200
Regina Henschel  wrote:

> Hi all,
> 
> I’m on working to specify the property “style:writing-mode” for ODF. 
> That property is called “text direction” in the UI of LibreOffice.
> 
> A page in a text document has the setting “Text direction” in section 
> “Paper Format” on tab “Page” of the “Page Style” dialog. Possible
> values are Left-to-right (horizontal)
> Right-to-left (horizontal)
> Right-to-left (vertical)
> Left-to-right (vertical)

That doesn't sound very sensible. What if I'm writing a document that
includes text in an L-R language as well as text in an R-L language?
(both horizontal). Maybe one included as a quote in the other?

> A table has the setting “Text direction” in section “Properties” on
> tab “Table” in “Table Properties” dialog. Possible values are
> Left-to-right (LTR)
> Right-to-left (RTL)
> Use superordinate object settings
> 
> LibreOffice can combine a vertical text direction at the page with
> RTL text direction of the table.
> 
> Are such combinations actually used in documents?
> Does LibreOffice render the texts in the way users need it?
> What is the intended behavior of such combinations?
> 
> 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] Actual bug report.

[Dave Howorth]

On Mon, 10 Apr 2023 10:47:56 -0400
Michael Tiernan  wrote:

> When attempting to muddle about with some data from a google form.
> 
> First, the version info is:
> 
> Version: 7.5.2.2 (X86_64) / LibreOffice Community Build ID: 
> 53bb9681a964705cf672590721dbc85eb4d0c3a2 CPU threads: 8; OS: Mac OS X 
> 13.3; UI render: default; VCL: osx Locale: en-US (en_US.UTF-8); UI: 
> en-US Calc: threaded
> 
> I have ~104 "Fields" from a long google form. They look like this:
> 
> Timestamp
> Email Address
> Respondent's Name: (Last, First)
> Respondent's preferred pronoun:
> Respondent's Title:
> Respondent's Email:
> Respondent's Phone Number:
> Full/Proper name for your group:
> What do you use for an abbreviation for your group?
> Choose Section Please:
> Choose Principle Investigator to edit
> Principle Investigator #1 Name: (Last, First)
> Principle Investigator #1 Title:
> Principle Investigator #1 Phone:
> Principle Investigator #1 Email:
> Mailing list membership for PI#1 [xxx Announce]
> Mailing list membership for PI#1 [xxx Alarm]
> Add another?
> Principle Investigator #2: Name: (Last, First)
> Principle Investigator #2: Title:
> ...
> 
> (I get what I was handed.)
> 
> So, now, I try to create a DB with it.
> 
> I open the "Create DB" dialog and begin to work my way through it.
> 
> I get this screen: (As expected.)
> 
> https://www.dropbox.com/s/g913wtewb7gandc/MCT_Screenshot_20230410_084718-P1.png?dl=0

For some reason that comes up completely blank when I try to display it.

> So, trying to use almost all the fields execept for a couple. So, I
> do the ">>" thing to move them all over so I can go delete the ones I
> don't want. That gives us this screen:
> 
> https://www.dropbox.com/s/bi3ec5snrf2shht/MCT_Screenshot_20230410_084805_P2.png?dl=0
> 
> On this screen, I tried to resize the "Query Wizard" screen to be
> wider so that I can read the field names and I can't.

Use the scroll bar to slide them over to display a more useful portion
of the name?

> That's the bug.
 
https://wiki.documentfoundation.org/QA/BugReport

-- 
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] Basic Macros with Base

[Dave Howorth]

On Tue, 24 Jan 2023 20:32:18 +0100
Harvey Nimmo  wrote:

> Where can I find the syntax of the DoCmd.RunSQL command to be used
> with a LOBase Macro in Basic?

I've never heard of the command, but google suggests

https://docs.libreoffice.org/wizards/html/classaccess2base_1_1DoCmd.html#a3c1b223e5e4024f2a8b955b2df3b6f92

I've no idea whether it is correct/relevant.

> My assumption was 
> X = "SQL string"
> DoCmD.RunSQL X

-- 
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] Islamic Calendar Dates

[Dave Howorth]

On Wed, 7 Dec 2022 21:34:37 -0500
John Kaufmann  wrote:

> On 2022-12-07 19:57, Toki wrote:
> > All:
> > 
> > When LibreOffice converts Gregorian to/from Islamic Calendar dates,
> > when does it assume that the new Islamic day begins:
> > * Sunset;
> > * Midnight;
> > * Sunrise;
> > 
> > When LibreOffice converts Gregorian to/from Islamic Calendar dates,
> > when does it assume that the first of the Islamic month begins:
> > * Sunset;
> > * Midnight;
> > * Sunrise;  
> 
> I'm completely ignorant in this area but find the questions
> interesting. However, doesn't the second (on first principles) follow
> from the first?

I'm completely ignorant too. A quick search leads to the further
question: which islamic calendar?

-- 
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] Weird line-wrap problem in Writer

[Dave Howorth]

On Mon, 28 Nov 2022 02:08:04 -0500
John Kaufmann  wrote:

> On 2022-11-27 18:45, RealNameTBA wrote:
> > ... [The problem is] this (as illustrated in the small attached
> > screenshot fragment): ...  
> The first thing to be noted is that by now you are aware that the
> attachment did not make it to this list. Sorry, that's just the state
> of things, so it's necessary to be as descriptive as possible. To
> that end:

Or paste the image online somewhere. e.g. pastebin

-- 
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] Position references

[Dave Howorth]

On Tue, 25 Oct 2022 19:26:25 +0200
lo.harald.ber...@t-online.de wrote:

> Hi Susanne,
> 
> the topic of anchoring can also be found separately here:
> 
> https://wiki.documentfoundation.org/Videos/Anchorage_of_objects
> https://wiki.documentfoundation.org/Videos/Anchorage_of_objects/de

FWIW, in English the phrase 'Anchorage_of_objects' doesn't exist. It
should be 'Anchoring_of_objects'. I believe. 

> Best regards
> Harald


-- 
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 Calc, limits(?)

[Dave Howorth]

On Fri, 2 Sep 2022 20:52:13 +0200
Johnny Rosenberg  wrote:

> Den fre 2 sep. 2022 kl 17:33 skrev Chris J.
> :
> 
> > Hi.
> >
> > Hi!  
> >
> > Is there some practical limit to the number of rows specifically,
> > but columns too, that an LO Calc spreadsheet can have?
> >  
> 
> Yes. Maximum for rows is 2²⁰ rows, that is 1048576 rows.
> I'm not sure about columns, but the newest version is supposed to
> support more columns than previous versions.
> Seems like the last column is AMJ. If in R1C1-mode it's 1024, so 1024
> columns in LibreOffice 7.2.7.2.
> >
> > I've run into this before with my checkbook. The spreadsheet is
> > arranged such that down is back in time, the current amount is at
> > the top. There's a formula in one column that calculates the
> > current amount in the account. This is where the problem happens. I
> > added some deposits this morning and in the new rows at the top in
> > the column which should calculate the amount in the account I get
> > the literal #VALUE.
> >
> > The column with the formula worked perfectly up to this point. The
> > sheet has 2540 rows. I get there error gong from 2536 to 2537.
> 
> Without knowing anything about those formulas it's impossible to
> answer this question, but 2500 rows should never be a problem. I have
> a spreadsheet open right now in LibreOffice Calc that is 5064 rows
> right now (adding one row each day) and I have no problems with it.
> I'd guess some cell is corrupt or something is wrong with one of your
> formulas, but since I don't have a clue what your formulas look like
> I can't say anything more than that.
> 
> Kind regards
> 
> Johnny Rosenberg

As Johnny says, we probably need more information to help. #VALUE
normally means that the number is too big to fit in the space it is
allowed. You should be able to see the value by selecting the cell and
looking at the contents in the display above the top of the sheet. Or
make the cell bigger, or reduce the font size :)

-- 
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] libreoffice, armhf, compiling, bugs

[Dave Howorth]

On Fri, 10 Jun 2022 17:04:49 + (UTC)
agyaana...@yahoo.com wrote:

> hello lo users & devs,
> 
> specs:
> userland(1) on android
> debian bullseye
> # dpkg --print-architecture
> "armhf"
> 
> from lo wiki(2) is clear about bigs are prioritised for still
> version. found a little bit about bugs on "how to debug"(3).

There seem to be some problems with typos, or perhaps language
problems. I assume (always dangerous!) that 'bigs' means 'bugs' but
what does 'still version' mean? Also, in the reference (2) (BTW it is
usual to use [] for references rather than ()) there's no mention of
bugs apart from a link to another page, so I have no idea what is meant.
 
> status:
> * upgrading to sid will result in fresh version
> * stable has 7.0.4-4
> * no armhf appimage(4)
> 
> dilemnas:
> * compile and install my own latest still version
> * how far it is useful to confirm or provide mising info on bugzilla
> (strace, logs, etc..)
> * my other os optiobs: alpine, arch (install nightmare as beginner
> for me). not feasible: kali (seems to be specialised) and ubuntu
> (personally dislike past exp).: which is better: alpine or arch ?
> * what about libreoffice-writer-nogui ?

Given the apparent language problems, it is perhaps better to spell
things out in more detail rather than choose the shortest possible
words and heavy abbreviation.

> links:
> (1) https://github.com/CypherpunkArmory/UserLAnd/
> (2) https://wiki.documentfoundation.org
> (3) https://wiki.documentfoundation.org/Development/How_to_debug
> (4) https://www.libreoffice.org/download/appimage/
> 
> regards,
> agyaan
> 


-- 
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] Agenda 2030 SDGs logos and posters file formats

[Dave Howorth]

On Thu, 12 May 2022 12:38:42 +0200
"Carlo Strata (tiscali.it)"  wrote:

> Hi Everyone!
> 
> Peace and love. Not war, never war from now on.
> 
> I was looking with my School Students the UN's Agenda 2030 and we are 
> using and spreading its logos, values and planning active actions.
> 
> You can download related materials in your language from here:
> https://unric.org/en/sdgs-in-your-language/
> 
> We massive use LibreOffice, Inkscape, Gimp, Scribus, Krita, MyPaint, 
> Shotcut/OpenShot, Meshroom CL (open source photogrammetry software), 
> Meshlab and Blender with my Students.
> 
> In the programming courses we also use and write code in: C/C++, PHP 
> (HTML/CSS/Javascript) and Python.
> 
> The Agenda 2030 logos are delivered from the UN site above in:
> 
> a) vector format --> EPS
> 
> b) bitmap format --> JPEG (425 x 425 pixels, 70 kbyte average file
> size)
> 
> What's the question?
> 
> The question are two:
> 
> 1) in total and full coherence with Agenda 2030 values themselves (at 
> least 1, 4, 8, 10 and 17), format have to be open (I mean SVG and
> PNG)! Could you help us to ask UN for that? May be useful to open a
> petition on change.org or similar site as well as to directly write
> to UN itself? We are doing that in next days...
> 
> 2) LibreOffice (7.3.3.2 both Windows and Linux versions) doesn't 
> correctly opens that EPS images, it shows only an image placeholder
> in which it writes that the file are built from Adobe Illustrator(R) 
> 22.0... (UN: :-( ); I simply open them with Inkscape and save them in 
> SVG format (and to a 3445 x 3445 pixels PNG file only 4 times file
> size larger than 64 times pixels smaller JPEG). The results seem
> perfect! Are LibreOffice EPS import filter improvable or bug affected?
> 
> What do you think about these troubles?

I think it would be helpful if you posted the URLs of the actual
downloads that cause trouble.

> Have a sunny day,
> 
> Carlo
> 
> 


-- 
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: (resolved) Re: [libreoffice-users] libreoffice grabs network port

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

[Dave Howorth]

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

[libreoffice-users] changing currency in a spreadsheet

[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

-- 
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] libreoffice grabs network port

[Dave Howorth]

On Fri, 22 Apr 2022 15:05:53 +0100
Mike Scott  wrote:

> Hi all. A bit of a saga for me.
> 
> I'm using LO headless from within a web server.
> 
> The server is the perl-based mojolicious, and calls LO do do some
> file conversions from .odt to .doc and pdf.
> 
> LO is called like:
> runcmd( 'soffice', '--headless', '--convert-to', $filter, '--outdir', 
> $outdir, $odtfile );
> 
> followed by a call to mojo's render() stuff to pass the file to the
> user.
> 
> Which often works.
> 
> But (with varying frequency) LO seems to grab the web server's port 
> somehow and sets up its own listen on it. This somewhat damages the
> web link :-| I've seen multiple copies of soffice and oosplash
> listening on the same port (a high-numbered, obscure one). I can't
> even see how this is possible
> 
> The question is, why does it do this, and how do I stop it?

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()?

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

> TIA.
>
> Linux mint, btw, ooo 6.4.7.2

-- 
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] Vulnerability report

[Dave Howorth]

On Thu, 21 Apr 2022 20:46:12 +0200
Robert Großkopf  wrote:

> Hi Min Di,
> 
> > I found a vulnerability and I want to know if I should send you the
> > vulnerability report through the website or through a special bug
> > bounty platform?  
> 
> I would prefer to write a bug description at
> https://bugs.documentfoundation.org/

Obviously it wouldn't be a good idea to expose an unpatched
vulnerability on a public bug reporting site. If that is what is being
reported? Details of vulnerabilities need to be reported through some
private channel.

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

Re: [libreoffice-users] How to print a section of a SS

[Dave Howorth]

On Tue, 19 Oct 2021 19:15:18 +0100
Brian Barker  wrote:

> At 17:45 19/10/2021 +0100, Dave Howorth wrote:
> >On Tue, 19 Oct 2021 13:05:10 +0100 Brian Barker wrote:  
> >>At 11:53 19/10/2021 +0100, Dave Howorth wrote:  
> >>>On Mon, 18 Oct 2021 20:51:19 -0400 Alan Bonly wrote:  
> >>>>It hasn't been mentioned if the OP is printing to PDF, and my bad 
> >>>>for never reporting the bug, but using LibreOffice File>Export as 
> >>>>PDF or  the Export Directly as PDF icon causes EVERYTHING on all 
> >>>>tabs to print to the PDF no matter what print range might be 
> >>>>specified, no matter if the print ranges are deleted then 
> >>>>selected anew. EVERYTHING  gets dumped into a PDF.  
> >>>
> >>>I don't think that's a bug. [...]  
> >>
> >>The documentation thinks it is a bug. Under "Using print ranges", 
> >>it says: "You can define which range of cells on a spreadsheet are 
> >>to be printed or exported to a PDF. The cells on the sheet that are 
> >>not part of the defined print range are not printed or exported. 
> >>Also, any sheets without a defined print range are not printed or
> >>exported."  
> >
> >The documentation thinks what's a bug, exactly? Alan claimed that if 
> >you try to print as a PDF then everything gets printed, without any 
> >choice. You appear to be stating that the documentation coincides 
> >with reality, which is exactly the opposite and what I said. Thus 
> >what Alan claimed is a bug is NOT a bug. Or are we somehow at cross
> >purposes?  
> 
> I think you do misunderstand me; perhaps I was a little brief. The 
> original claim was that exporting to PDF takes no account of defined 
> print ranges and exports the entire document. (I didn't check that or 
> experiment with it.)

Well that's the absolute basis of the whole conversation, so that's
absolutely the first thing I did!

> We are not talking about the separate facility, 
> in the print and export dialogues, to print or export the currently 
> selected range, are we?

Don't care. They all behave the same or similar.

> You suggested that it was not a bug: in other 
> words, that you expected export as PDF should disregard defined print 
> ranges, as we were told it did.

No I suggested it was not a bug and that it did work exactly as
everybody else expected it would and as documented apparently (I didn't
check the documentation :)  You needed to actually read what I wrote
after that one sentence and try to understand the whole message.

> But the documentation about print 
> ranges makes clear that they are supposed to apply equally to 
> printing and exporting, in other words that exporting to PDF should 
> export only material within any defined print ranges and not other
> material.
> 
> Brian Barker  

-- 
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] How to print a section of a SS

[Dave Howorth]

On Tue, 19 Oct 2021 13:05:10 +0100
Brian Barker  wrote:

> At 11:53 19/10/2021 +0100, Dave Howorth wrote:
> >On Mon, 18 Oct 2021 20:51:19 -0400 Alan Bonly wrote:  
> >>It hasn't been mentioned if the OP is printing to PDF, and my bad 
> >>for never reporting the bug, but using LibreOffice File>Export as 
> >>PDF or  the Export Directly as PDF icon causes EVERYTHING on all 
> >>tabs to  print to the PDF no matter what print range might be 
> >>specified, no matter if the print ranges are deleted then selected 
> >>anew. EVERYTHING  gets dumped into a PDF.  
> >
> >I don't think that's a bug. [...]  
> 
> The documentation thinks it is a bug. Under "Using print ranges", it
> says: "You can define which range of cells on a spreadsheet are to be 
> printed or exported to a PDF. The cells on the sheet that are not 
> part of the defined print range are not printed or exported. Also, 
> any sheets without a defined print range are not printed or exported."

The documentation thinks what's a bug, exactly? Alan claimed that if
you try to print as a PDF then everything gets printed, without any
choice. You appear to be stating that the documentation coincides with
reality, which is exactly the ooposite and what I said. Thus what Alan
claimed is a bug is NOT a bug. Or are we somehow at cross purposes?

-- 
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] How to print a section of a SS

[Dave Howorth]

On Mon, 18 Oct 2021 20:51:19 -0400
Alan B  wrote:

> I hasn't been mentioned if the OP is printing to PDF, and my bad for
> never reporting the bug, but using LibreOffice File>Export as PDF or
> the Export Directly as PDF icon causes EVERYTHING on all tabs to
> print to the PDF no matter what print range might be specified, no
> matter if the print ranges are deleted then selected anew. EVERYTHING
> gets dumped into a PDF.

I don't think that's a bug. If you select Export as PDF, you are shown
a dialog box that offers a choice of exporting the whole spreadsheet or
a selected region etc. Similarly you can Print to File if you want
another way to print just part of a spreadsheet to a PDF file.

> Need to be certain the OP isn't using the PDF feature. If they are,
> that is the source of the problem.
> 
> On Mon, Oct 18, 2021 at 8:38 PM Steve Edmonds
>  wrote:
> 
> > Hi John.
> > What version of Libreoffice are you on.
> > When you say you want to print a section of a sheet, is that a
> > single section on just one sheet or sections of multiple sheets.
> >
> > For me on a single sheet, sometimes the print range has some history
> > from previous activity.
> > I go Format>Print Ranges>Clear to start.
> > Then I highlight the range to print with the mouse and go
> > Format>Print  
> > Ranges>Define.  
> >
> > Then I go to File>Print Preview to see how many pages that selected
> > range will print on, and if necessary adjust the top -/+ slider or
> > page format to suit my needs.
> > Steve
> >
> > On 18/10/2021 16:12, John R. Sowden wrote:  
> > > In an "office" program, I made the foolish assumption that people
> > > would understand that SS means Spread Sheet.  I apologize to
> > > those who did not grasp that.
> > >
> > > The version of Thunderbird is 13.0 (32 bit).  Again I assumed
> > > that the instructions for a common function, that of printing a
> > > section of a SS (see reference above) would not change from
> > > version to version. Again, I apologize to those who were confused
> > > about the stability of user interfaces.
> > >
> > > Humbly,
> > > John
> > >
> > >
> > > On 10/16/21 8:07 AM, Dan Lewis wrote:  
> > >>
> > >> On 10/15/21 8:25 PM, John R. Sowden wrote:  
> > >>> I went to Format->Print Range--> define.  Failed
> > >>> Went to Help (when all else fails) read, follow instructions,
> > >>> blank screen (no examples)
> > >>>
> > >>> Help?,
> > >>>
> > >>> John  
> > >>
> > >> What do you mean by SS? Which component of LibreOffice are you
> > >> using? What version of LibreOffice are you using?
> > >>
> > >> 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 
> 
> 


-- 
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] Windows friendly web builders

[Dave Howorth]

On Fri, 16 Jul 2021 14:00:11 -0400
charles meyer  wrote:

> I'm trying to help our "Friends of the Library" NPO create, manage
> and have hosted a fairly simple Web site.
> 
> All their experience is in Windows.
> 
> They are great people but not tech oriented (nor interested in
> becoming so)  so I've narrowed down their web site builder and
> hosting choices as follows:
> 
> 1 Wix

As a regular user, I hate wix-based sites. Too many domains need to be
authorised; lots of stuff (garbage?) loaded etc etc

> 2 SquareSpace
> 3 Go Daddy
> 4 Wordpress.com

Of those three, the only one I regularly see and that doesn't cause me
grief as a user is wordpress.

Just my 2c

> Have you developed any Web sites or helped others with their Web
> sites?
> 
> If so, might you please share any checklist for features, functions,
> factors to consider in choosing a Web site builder/host?
> 
> Ex. How much bandwidth - storage space needed? Has SSL certificate?
> 
> I've Googled this and there doesn't seem to be any "vetting"
> organization which shares checklists of what to look for in a web
> site builder/hosting co.
> 
> I found "reviews" but each reviewer seems to have a leaning - e.g.
> WordPress preferences, Wix choice, etc. so the reviews seeme a tad
> skewed.
> 
> On the Wix site, I've clicked on Start here for Customer Care several
> times and it never connects to anything.
> 
> I'm wondering how I can find both satisfied and unsatisfied customers
> with articulated reasons why they like/don't like their web builder
> choice?
> 
> Thank you.
> 
> Charles.
> 


-- 
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] Regular expressions

[Dave Howorth]

On Thu, 8 Jul 2021 22:38:49 +0100
David Lynch  wrote:

> The documentation 
> 
> for COUNTIF gives the following examples, among others:
> 
> =COUNTIF(A1:A10;">=2006")  
> =COUNTIF(A1:A10;"<")
> =COUNTIF(A1:A10;C2)
> =COUNTIF(A1:A10;"<0")
>   and these do indeed work.
> 
>   However the list of regular expressions linked from the COUNTIF
> page
> 
> does not include the use of > and < as operators.
> 
> Neither does the "full list of supported metacharacters and syntax" 
> 
> linked from the help page in the previous paragraph.
> 
> Neither does the page
>  linked from the
> REGEX help page
> 
> 
> Please, is there anywhere that tells me what regular expressions are 
> supported?
> 
> David Lynch
> 
> Version: 7.1.4.2 (x64) / LibreOffice Community
> Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
> CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; 
> VCL: win
> Locale: en-GB (en_GB); UI: en-GB
> Calc: threaded

I don't believe that '>'and '<' used as operators are regular
expressions. They are parts of more general 'criteria', which the
documentation

implies are 'wild cards'. But searching the documentation doesn't reveal
any definition or even explanation of what a wild card is :(

So I think the answer to your question is that the definition of
regexes supported is indeed
 but
that the particular criterion you are interested in is not a regex and
thus not documented there. Perhaps somebody else knows where such
criteria ARE documented?

-- 
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] Updating Data in Calc

[Dave Howorth]

On Mon, 14 Jun 2021 21:35:49 +0200
"Hylton Conacher (ZR1HPC)"  wrote:

> It has often puzzled me why when knowledgeable members of mailing
> lists such as this, find fault in what someone, less qualified than 
> themselves, suggests. It is not taken via private mail but splashed
> on the mailing list.

Don't take it personally. It's just a quirk of list netiquette. It's
considered rude to post a private message to somebody as a result of a
list postings, unless specifically invited. Plus by posting it to the
list Brian makes sure that any other people who were also in any doubt
about what had gone before also have the same new information to
clarify their thinking. So there's no criticism of you intended.

He perhaps could have chosen slightly better phrasing to avoid
irritating you, but such events are part of life on a mailing list,
where not everybody has perfect skills in written English plus a
considerate personality.

HTH, 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] videos in impress

[Dave Howorth]

On Thu, 13 May 2021 17:14:26 +0200
Italo Vignoli  wrote:

> On 5/13/21 4:59 PM, Mike Scott wrote:
> 
> > Sorry for following up my own post, but the laptop results were 
> > unexpected. Either drag-and-drop or using menu Insert gave the same 
> > results - both produced an object showing the blue 'film' icon, in
> > the design mode, and at the video start when running a slide show.
> > It's a recent low-end Dell pentium laptop, Intel integrated
> > graphics. It's running the same version of LO/Mint as the desktop I
> > normally use.  
> 
> I have the same consistent behaviour on the Linux Mint desktop and 
> laptop, and on the Windows 10 laptop (all based on Intel
> architectures). I also have the same behaviour on my Intel based
> MacBook. I don't think I have ever seen a different behaviour, but my
> memory may fail here.
> 
> Actually, I have been repeating the process - video with superimposed 
> text - since September 2013, when I have used it for the first time
> at LibreOffice Conference in Milan. Since then, I have changed at
> least three MacBooks and three Linux PCs. So, really weird.

Maybe it is worth posting a sample presentation that works for you
somewhere so that Mike could test it? And maybe Mike could do the same
so you could test his presentation to see whether it works or not for
you?

-- 
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] Language setting in Calc

[Dave Howorth]

On Sun, 21 Feb 2021 00:40:56 +
Brian Barker  wrote:

> At 15:09 20/02/2021 -0800, Nobody Noname wrote:
> >On Sat, Feb 20, 2021 at 8:27 AM Thomas Blasejewicz wrote:  
> >>The (Excel) file is the draft for the preparation of a 
> >>questionnaire - to be translated into several languages (although 
> >>the one I am currently working on has only 3 languages). Means: I 
> >>want certain columns ONLY to be set to German, while others next to 
> >>it are set to English and Japanese. Applying the language to the 
> >>entire document does not do this trick.  
> >
> >I did a little test and was able to reproduce your problem with the 
> >Column > Format Cells > Font > Polish (which is just the test 
> >language I used). I could reproduce the problem when working with 
> >the document as an .xlsx or .xls file, but the problem does NOT 
> >exist when I used a .ods file. So the issue seems to be specific to 
> >LibreOffice operating with Excel files. You might want to report it 
> >as a bug: https://wiki.documentfoundation.org/QA/BugReport  
> 
> Sorry, but you are assuming that this is a problem with LibreOffice's 
> ability to save in a Microsoft Excel format, and that the fault is 
> therefore LibreOffice's. But do we know that it is possible to save a 
> spreadsheet document in Excel format with different columns marked as 
> being in different languages? That's the same question, effectively, 
> as "Can you set different languages for different parts of a 
> spreadsheet in Microsoft Excel itself?" I don't know that you can. If 
> not, the deficiency is with Microsoft's formats, and the bug report 
> should probably go to them instead.
> 
> Brian Barker  

Apparently it is possible,since the OP originally stated:

"The original file is so formatted that there are font settings for 
English and Japanese.
When I work at home (right now) I select the relevant columns and
change the language setting to German."

For that to be the case, the original file must encode the language for
individual columns.

-- 
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] How to ask a question on Ask LibreOffice?

[Dave Howorth]

On Wed, 17 Feb 2021 17:03:24 -0500
John Kaufmann  wrote:

> On 2021-02-17 16:07, Dave Howorth wrote:
> > On Wed, 17 Feb 2021 11:36:34 -0500 John Kaufmann wrote:
> > ...  
> >> ... It sounds like you know Discourse and find the mailing list
> >> side wanting. But if Discourse is an attempt to serve in a single
> >> forum users comfortable in both media, it may at least /become/ a
> >> solution to the problem of a fragmented user knowledge base.  
> > 
> > In my experience it becomes a way of forcing the email users to use
> > the web forum instead. The only purpose the email interface serves
> > in practice is notifying of web posts.  
> 
> AskLibO already gives us that. I have to believe (and certainly hope)
> Discourse offers something more.
> 
> > Even a bridge as Sophie suggests is likely to kill the mailing list
> > IMHO.  
> 
> If "kill" means changing the list address,

Why on earth would you think 'kill' might mean changing a list address?

It means reducing the number of users of it to zero. i.e. the number of
users who use the mailing list and do not use the forum. The mailing
list will cease to exist as an entity. It will fall off its perch.

> that may be a price worth
> paying for a larger user base. (FTM, I wonder how the larger user
> base on AskLibO will react/adapt to Discourse.) If it means losing
> anyone now on the mailing list, I can only hope that is incorrect.


-- 
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] How to ask a question on Ask LibreOffice?

[Dave Howorth]

On Wed, 17 Feb 2021 11:36:34 -0500
John Kaufmann  wrote:

> On 2021-02-17 10:22, Dave Howorth wrote:
> > On Wed, 17 Feb 2021 09:03:41 -0500 John Kaufmann wrote:  
> >> On 2021-02-17 04:06, sophi wrote:
> >>  
> >>> Just to let you know, we, at TDF, are working on replacing the Ask
> >>> forum by Discourse. We have had a test period with the members
> >>> regularly answering on Ask. If Discourse is not fully replacing a
> >>> Q forum, it is the most appropriate at the moment and we can
> >>> extend it to serve other purposes on the future. ...  
> >>
> >> Looks interesting, and seems to have potential to subsume also the
> >> mailing list system. (It needs to be integrated with a MTA, which
> >> it does not provide, but merging web and mailing list forums seems
> >> to be an explicit objective.) If so, that could solve the problem
> >> of which forum (AskLibO or mailing list) to use for a question. Is
> >> the intent to also migrate the mailing lists to Discourse?  
> > 
> > I seriously hope not! Discourse works OK as a forum but the mailing
> > list side is very much a poor cousin. Far easier and better to use a
> > plain mailing list IME & IMHO.  
> 
> I sympathize, Dave; I also like a mailing list or newsgroup. It
> sounds like you know Discourse and find the mailing list side
> wanting. But if Discourse is an attempt to serve in a single forum
> users comfortable in both media, it may at least /become/ a solution
> to the problem of a fragmented user knowledge base.

In my experience it becomes a way of forcing the email users to use the
web forum instead. The only purpose the email interface serves in
practice is notifying of web posts.

Even a bridge as Sophie suggests is likely to kill the mailing list
IMHO.

> I'm hopeful,
> -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] How to ask a question on Ask LibreOffice?

[Dave Howorth]

On Wed, 17 Feb 2021 09:03:41 -0500
John Kaufmann  wrote:

> On 2021-02-17 04:06, sophi wrote:
> 
> > Just to let you know, we, at TDF, are working on replacing the Ask
> > forum by Discourse. We have had a test period with the members
> > regularly answering on Ask. If Discourse is not fully replacing a
> > Q forum, it is the most appropriate at the moment and we can
> > extend it to serve other purposes on the future.
> > The difficulty is currently to migrate the Ask archive to
> > Discourse, but that will be worked out by our infra team on the
> > next months.  
> 
> Looks interesting, and seems to have potential to subsume also the
> mailing list system. (It needs to be integrated with a MTA, which it
> does not provide, but merging web and mailing list forums seems to be
> an explicit objective.) If so, that could solve the problem of which
> forum (AskLibO or mailing list) to use for a question. Is the intent
> to also migrate the mailing lists to Discourse?

I seriously hope not! Discourse works OK as a forum but the mailing
list side is very much a poor cousin. Far easier and better to use a
plain mailing list IME & IMHO.

> BTW, it was amusing to learn that not everyone is a fan. The
> Wikipedia description is the third hit on a search "discourse forum"
> in both DuckDuckGo and Google, but they summarize it differently:
> Google: "Discourse is an open source Internet forum and mailing
> list management software application ..." DuckDuckGo: "Discourse is
> an awful open source Internet forum and mailing list management
> software application ..." :-) FWIW, I look forward to seeing it, -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] Hyphenation Error Message

[Dave Howorth]

On Sat, 30 Jan 2021 20:03:47 +
Dave Barton  wrote:

> Hi Marco,
> 
> I never thought for one moment that your dictionaries were responsible
> for this issue. I did try your latest version, but got the same error
> message.
> 
> It's getting late here, so I will test this document with some
> alternative options (eg. Linux, AOO, other LO versions, etc.) and
> report back tomorrow.
> 
> Best Regards
> Dave
> 
> 
> On 30/01/2021 19:26, Marco A.G. Pinto wrote:
> > I haven't changed anything while committing to Gerrit except the
> > versions and .dic, .aff and readme files.
> > 
> > I have been doing it for several years already, so I don't know what
> > happened.
> > 
> > Could you try with the latest version?:
> > https://extensions.libreoffice.org/extensions/english-dictionaries
> > (still pending moderation)
> > https://github.com/marcoagpinto/aoo-mozilla-en-dict
> > 
> > But, of course, if there is an issue with LibreOffice built-in, we
> > need to know what is happening.
> > 
> > Thanks!
> > 
> > Kind regards,
> >    >Marco A.G.Pinto (English Dictionaries extension maintainer)
> >   --
> > 
> > 
> > 
> > On 30/01/2021 17:34, Dave Barton wrote:  
> >> Version: 7.0.4.2 (x64)
> >> Build ID: dcf040e67528d9187c66b2379df5ea4407429775
> >> CPU threads: 8
> >> OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
> >> Locale: en-US (en_US); UI: en-US
> >> Calc: threaded
> >>
> >> My installed (bundled) dictionary, contributed by Marco A. G.
> >> Pintp is: English spelling dictionaries, hyphenation rules,
> >> thesaurus, and grammar checker 2020.05.01
> >> English dictionaries for OpenOffice/LibreOffice 4.0+.
> >> It includes:
> >> -    en_AU (Australian) (updated: 2019-10-06)
> >> -    en_CA (Canadian) (updated: 2019-10-06)
> >> -    en_G8 (British) (updated: 2020-05-01)
> >> -    en.US (American) (updated: 2019-10-06)
> >> -    en.ZA (South African) (updated: 2012-07-10)
> >>
> >> Upon opening a Writer document with the language set to en-US I
> >> get this information bar error message:
> >>
> >> Missing hyphenation data Please install the hyphenation package
> >> for locale “en“.

Sorry, I haven't really been following, but is the distinction between
an 'en' locale and an 'en.US' locale important; and why do some
dictionary locales use '_' as a separator and others use '.'?

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

Re: [libreoffice-users] If-exist condition for conditional text or section

[Dave Howorth]

On Fri, 1 Jan 2021 14:46:59 -0600
Michael H  wrote:

> To follow up on the conditions aren't really conditional, but static
> states: I got as far as page 613 of the ODF 1.2 specification.
> (which used to be free from OASIS, but now costs chf198 from ISO.org.)

FWIW, the 1.2 spec is still available free from
https://docs.oasis-open.org/office/v1.2/

I don't know if the words are everywhere identical with the ISO
version * but certainly the words you quote are the same.

* Does anybody know whether they are the same? The Oasis document has a
  section at the begininning prohibiting changes to the document and
  prohibiting removal of that section, so I would hope so!

The ISO version is also publically available from
https://standards.iso.org/ittf/PubliclyAvailableStandards/index.html

I suppose you must be talking about the cost of a paper copy from ISO.
I expect you're free to print a downloaded copy if you wish.

-- 
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] Epson XP-820 paper size setup

[Dave Howorth]

On Mon, 14 Dec 2020 13:49:03 -0500
"Paul D. Mirowsky"  wrote:

> Which operating system are you using?
> 
> On 12/9/20 1:13 PM, Gary Dale wrote:
> > I'm running Debian/Bullseye

!!

-- 
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] Suggestion: 3D spreadsheets

[Dave Howorth]

On Tue, 24 Nov 2020 07:45:52 -0700 (MST)
PaddleS  wrote:

> Something new an that would be really great is to add implementation
> for 3 (and potentially more) dimensional spreadsheets.
> What it would look like : 
> Basically the same as a 2D spreadsheet. But by holding Alt+scrolling
> with the mouse, you could change the third dimension, showing the 2D
> spreadsheet of that third index.
> 
> For instance let's say the third dimensions use greek characters.
> Then by default you see the "α" 2D spreadsheet showing the numbers
> and letters grid at that value "α".
> You hold Alt and scroll once and it changes to "β" 2D spreadsheet.
> And so on.
> 
> Also it would require a way to select the X and Y axis in order to
> visualize the data. So for instance you could change the X axis to
> display the greek letters dimension and show the numbers on Y axis.
> 
> This could be really powerful. What do you think? 

Maybe some examples of how it would be useful versus alternatives and
ideally some idea showing how easy to use it is?

-- 
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] Question on value command and Err:502

[Dave Howorth]

You'd probably get more help if you made your emails understandable!

Below is what I see from you ...
(with some > quote marks on the left hand side)
I can't even tell what you wrote in addition to what Brian wrote, let
alone begin to interpret what you're asking. 

On Wed, 25 Nov 2020 00:02:04 +1000
"Michael D. Setzer II"  wrote:

> =On 24 Nov 2020 at 13:05, Brian Barker wrote:
> 
> 
> Date sent:60;Tue, 24 Nov 2020 13:05:46 +
> To:;=users@global.libreoffice.org
> From:60;Brian Barker;b.m.bar...@btinternet.com
> Subject:;Re: [libreoffice-users] Question on value command 
> and Err:502
> 
> 
> At 14:48 24/11/2020 +1000, Michael D. Setzer II wrote:
> Put a more complex question, and got no responses yet.
> 
> 
> You have to admit that your description and layout were pretty foggy!
> Did anyone understand it?
> 
> 
> So, here it is in simplest form
> =value(1+1) converts the 1+1 to 2
> But =value( ) fails with Err:502 if text1+1is used or if a cell
> containing the text 1+1 is used??
> I've looked thru command, and this seems to be the one to convert a
> text string to a value?
> 
> 
> It is. But the text string1+1is not a value expressed as text but
> a numerical expression in text form. And VALUE() does not undertake
> to evaluate such expressions.
> 
> 
> Is there another command, ...;
> 
> 
> What you need instead is the EVALUATE() function. (PS: It doesn't
> exist!)
> 
> 
> I think the fact that VALUE(1+1) entered as part of a formula does
> what it does is a lucky side effect. Clearly in this case LibreOffice
> is doing something similar to the automatic editing that is done when
> any material is entered into a spreadsheet cell. I'm talking about
> this sort of thing: when you type=+02(no quotes) into a cell
> formatted as Number, you see just 2. The1+1in this case is being
> entered into a cell (as part of a formula), not arising as the result
> of some calculation.
> 
> 
> As you mention, and as I found the evaluate command is what other 
> spreadsheets have that would seem to handle this, but libreoffice
> calc doesn't??
> 
> 
> Have just been playing with that GPS to Decimal problem, and was 
> trying to get a simplier process to do it.
> 
> 
> Have made a number of macros, that can do it just fine, but they have 
> long formulas. Was looking to do it with a set of regex commands.
> Commands did what I wanted, but can't get it to calculate the result..
> 
> 
> Best I've gotten So Far.
> Raw Data in column A
> 0315'090E
> Have a Macro that puts formula in column
> B=REGEX(REGEX(REGEX(REGEX(REGEX(INDIRECT(ADDRESS(ROW(),COLUMN()-1)),,+),',/60+ot;),CHAR(34),/3600),[EN],),[OSW],*(-1))
> That creates the Forumula 03+15/60+090/3600
> But value in macro fails if put around it, and using value on the
> cell, or even a cell, where the data is copied fails. So, it is not
> being seen as a formula. Seems Value only works on a string that only
> contains digits and nothing else?? And as you said. LibreOffice
> doesn't have evaluate as others do.So, macro does what I want, but no
> way I've found to automatically get it to convert to the value. I can
> do the following steps to get the result I want. After running the
> macro I can manually do the following: F2,F9,CR,HOME,=,CR
> That puts the cell in edit mode, then F9 calculates it to the text
> formula and enter, the Home to go to the beginning, insert an = to
> convert it from a text cell to an actual format, and then enter to
> get the final result as digit values.
> 
> 
> But again, LibreOffice doesn't have the keypress option to add that.
> Other methods work fine, just was trying something different.
> Just thought there would be some kind of command to do it..
> 
> 
> Additionally, it probable is a flux that value(1+1) worked, probable
> does calculation first, and then sees nothing to convert. When it see
> as string, it probable checks for non-digits, and thus fails
> automatically..
> 
> 
> Thought there might be something else. Not an issue that effects me,
> but thought it would be interesting to figure out..
> 
> 
> Have a nice day and be safe..
> 
> 
> 
> 
> I trust this helps.
> 
> Brian Barker
> 
> 
> 
> 
> --
> 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] Re: [Calc] Convert GPS coords from DMS to decimals?

[Dave Howorth]

On Mon, 23 Nov 2020 07:18:48 +1000
"Michael D. Setzer II"  wrote:

> Time format is definitely the simplist option.

But semantically is entirely incorrect. It's [something more than] a
coincidence that spatial coordinates use the same notation as time
coordinates, but no more than that.

-- 
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] Static vs. dynamic time

[Dave Howorth]

On Fri, 2 Oct 2020 21:27:30 +0200
Johnny Rosenberg  wrote:

> In Google Spreadsheets

What does this have to do with 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] Static vs. dynamic maximum

[Dave Howorth]

On Fri, 2 Oct 2020 06:41:27 -0700 (MST)
Chimel  wrote:

> Hi,
> 
> I must be of a conservative mind today, because after the message
> about static NOW(), I am also stuck with extracting the maximum value
> of one given cell.

What do you mean by 'the maximum value' of a cell?

It sounds like you think cells have a history of their contents?
That's not the case. A cell has a value. If you then enter a different
value in the cell, it has the new value. It does not 'remember' the old
value. (Notwithstanding the ability of the UI to 'undo' editing -
that's something completely different).

So the entire notion of the 'maximum' value of a cell is meaningless.

> For instance, A1 contains variable numbers, and I want to store the
> maximal value of this cell in B1.
> The trouble is that MAX() compares 2 different cells, whereas I want
> the maximal value of one cell.
> A recursive formula such as =MAX(A1;B1) would probably not work, and
> returns an error 523 indeed.
> 
> Is there a way to store the maximal value of a cell using a formula,
> preferably?
> 
> Thanks,
> Chimel.

-- 
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] Can you please associate my extension to me?

[Dave Howorth]

On Thu, 1 Oct 2020 15:59:01 +0200
Heiko Tietze  wrote:

> Publishing is only possible for admins. We consider to make this
> available in future. I pushed the button now...

Page not found

> On 01.10.20 14:37, Andrew Pitonyak wrote:
> > 
> > I think that I am missing something obvious. How do I change the
> > latest version from DRAFT to published so that people can download
> > it? 
> > 
> > On Thursday, October 01, 2020 02:12 EDT, Heiko Tietze
> >  wrote: Done, you are now the
> > maintainer of this extension.
> > 
> > Many thanks for your contribution,
> > Heiko
> > 
> > On 30.09.20 21:16, Andrew Douglas Pitonyak wrote:  
> >>
> >> Is anyone able to associate this extension to me:
> >>
> >> https://extensions.libreoffice.org/en/extensions/show/code-colorizer-formatter
> >>
> >>
> >> If you cannot associate the extension to "and...@pitonyak.org",
> >> can I email the latest version for upload.
> >>
> >>
> >>  
> > 
> > --
> > Dr. Heiko Tietze, UX-Designer and UX-Mentor
> > Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org
> > The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE
> > Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
> > Legal details: https://www.documentfoundation.org/imprint
> > 
> > 
> > --
> > 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] Links in documents

[Dave Howorth]

On Wed, 30 Sep 2020 19:33:13 +0200
Wiebe van der Worp  wrote:

> On 27-09-2020 17:42, Wiebe van der Worp wrote:
> 
> >> Thing is that links break when mailing or moving and that is a
> >> serious flaw.
> >>
> >> For example, I would expect a template name without path in a
> >> document xml, result in a search for that template in:
> >>
> >>   * the designated template folder
> >>   * the home folder
> >>   * the folder where the document lives
> >>
> >> Apparently this does not work, not even one folder is consulted.
> >>
> >> Is there some sort of a search path available? A policy? It would 
> >> really be helpful if this subject is discussed and I would love to
> >> see a contribution.  
> 
> The lack of response is probably a confirmation that there is no 
> mechanism to keep links to various external sources up to date.

Which suggests that this is probably the wrong forum to discuss it.
Either a bug report or another mailing list would seem appropriate,
though I don't know which of
https://www.libreoffice.org/get-help/mailing-lists/ is appropriate. :(

> It is probably save to state that if you want to repair a link
> lacking an interface element, then unzipping, editng xml and zipping
> is the only way.
> 
> Odd but okay.
> 


-- 
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] Keyboard shortcut to delete current row when focus on one of its cells?

[Dave Howorth]

On Tue, 22 Sep 2020 15:18:18 +0100
DaveB  wrote:

> On 22/09/2020 14:17, Philip Jackson wrote:
> > On 21/09/2020 22:48, Dave Howorth wrote:  
> >> Well the diagram in the book also has the buttons at the bottom in
> >> a different order. Either they used a different version of the
> >> software, or maybe a different desktop environment. The joy of
> >> linux:)
> >>
> >> But no, there are no underlines on the selections in [my] real
> >> life.  
> > 
> > Nor mine -  on 6.4.5.2
> > 
> > Philip  
> 
> That suggests you are running Linux.
> 
> The image Dave is referring to was taken from a Windows 7 install of
> the Calc Guide 6.2. We (The Documentation Team) always take captures
> of the guide we are writing about. As much as we would like to, we
> cannot cover every possible visual difference between each operating
> system.
> 
> The conclusion to this thread is that Ctrl+- opens the dialog in both
> Linux and Windows (cannot speak for macOS), but the D key only
> functions as described by Brian under Windows, which is why Linux
> users don't see the underline. Although less convenient, Linux users
> can use the up and down arrow keys can be used to select the required
> option.

Since I believe such underlines were implemented on Unix/Linux before
Windows, it's disappointing to me that the functionality isn't there in
the Linux implementation.

And in this case where there's a functional difference rather than a
visual difference, it would be nice to see that documented.

But thanks for explaining the situation. PS I think you mean R key
rather than D key.

> 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] [Calc] Keyboard shortcut to delete current row when focus on one of its cells?

[Dave Howorth]

On Mon, 21 Sep 2020 21:21:33 +0100
Brian Barker  wrote:

> At 20:19 21/09/2020 +0100, Dave Howorth wrote:
> >On Mon, 21 Sep 2020 14:13:51 +0100 Brian Barker wrote:  
> >>At 06:00 21/09/2020 -0700, Gilles Noname wrote:  
> >>>I need a keyboard shortcut to delete the 
> >>>current row. CTRL+- only works when 1) 
> >>>reaching for the mouse and 2) clicking on its 
> >>>ID number on the left-most column (1,2,3, ie. 
> >>>the "grey part")… which beats the point of keyboard shortcuts.  
> >>
> >>Ctrl+hyphen, R, Enter?  
> >
> >FWIW, on my system, CTRL+hyphen pops up a Delete 
> >Cells dialog, R does nothing and Enter causes 
> >the dialog to close while executing the first 
> >action - Shift cells up. LO 6.2.7.1  
> 
> That's odd. Figure 36 in the Calc Guide 6.2 shows 
> the Delete cells dialogue with the first letter 
> of "rows" in "Delete entire row(s)" underlined. 
> This means that pressing "R" *should* move the 
> selection to this option. (Figure 16 in Calc Guide 6.4 shows the
> same.)

Well the diagram in the book also has the buttons at the bottom in a
different order. Either they used a different version of the software,
or maybe a different desktop environment. The joy of linux :)

But no, there are no underlines on the selections in [my] real life.

> Brian Barker 

-- 
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] Keyboard shortcut to delete current row when focus on one of its cells?

[Dave Howorth]

On Mon, 21 Sep 2020 14:13:51 +0100
Brian Barker  wrote:

> At 06:00 21/09/2020 -0700, Gilles Noname wrote:
> >I need a keyboard shortcut to delete the current 
> >row. CTRL+- only works when 1) reaching for the 
> >mouse and 2) clicking on its ID number on the 
> >left-most column (1,2,3, ie. the "grey part")… 
> >which beats the point of keyboard shortcuts.  
> 
> Ctrl+hyphen, R, Enter?

FWIW, on my system, CTRL+hyphen pops up a Delete Cells dialog, R does
nothing and Enter causes the dialog to close while executing the first
action - Shift cells up. LO 6.2.7.1

> I trust this helps.
> 
> Brian Barker
> 
> 


-- 
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] Re: LO 7.0 fails to start with --nologo

[Dave Howorth]

On Thu, 03 Sep 2020 13:43:39 -0500
Mauricio Baeza  wrote:

> On Thu, 2020-09-03 at 10:49 -0700, MR wrote:
> > Thank you, but that tells me nothing of use.
> > 
> > I'm not switching to a new distro for one issue.
> 
> I can't reproduce this error in virtual machine with Xubuntu 18.04
> 
> mau@xubuntu $ soffice --calc --nologo
> 
> Fresh install
> 
> Please, always reply to list

Well whatever he was replying to isn't on list either, so is the pot
calling the kettle black? And why didn't you quote what he was replying
to?

-- 
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] Re: OTM documents

[Dave Howorth]

On Wed, 19 Aug 2020 11:05:56 +0100
Office User  wrote:

> On 19/08/2020 10:12, Dave Howorth wrote:
> > On Tue, 18 Aug 2020 19:57:53 -0700 (MST)
> > V Stuart Foote  wrote:
> >   
> >> toki wrote  
> >>> How does one construct an .OTM document?
> >>> ...
> >>>
> >>> At this stage, I'd settle for a sample.otm.
> >>
> >> Jonathon,
> >>
> >> Just assemble one. It works as expected, if you need help perhaps
> >> see Byfield's "Designing with LibreOffice"
> >> <https://designingwithlibreoffice.com/download-buy/>pgs. 324 -
> >> 342  
> > 
> > I'm confused 'otm' does not appear in that book? (Whatever a .OTM
> > is) 
> >> Stuart  
> 
> See page 334 "Using master documents".
> OTM = OpenDocument Text Master

I think that page 334 describes master documents (suffix .odm) rather
than master templates (suffix .otm), which I see appear in the save
dialog as an option, so I'm still confused (or at least I was until I
read Regina's answer).

-- 
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] Re: OTM documents

[Dave Howorth]

On Tue, 18 Aug 2020 19:57:53 -0700 (MST)
V Stuart Foote  wrote:

> toki wrote
> > How does one construct an .OTM document?
> > ...
> > 
> > At this stage, I'd settle for a sample.otm.  
> 
> Jonathon,
> 
> Just assemble one. It works as expected, if you need help perhaps see
> Byfield's "Designing with LibreOffice"
> pgs. 324 - 342

I'm confused 'otm' does not appear in that book? (Whatever a .OTM is)

> Stuart

-- 
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] Underline Color different than Characters color

[Dave Howorth]

On Sat, 15 Aug 2020 16:56:38 -0400
charles meyer  wrote:

> I've Googled this to no avail.
> 
> If I Right-Click the U on the toolbar for underlining I can then
> underline but it provides the same color as the text I've written.
> 
> I want the text to appear white but the underline to be red.
> 
> I right clicked U and then chose Edit and then Color but it changed
> the lettering (word) to red so both the underline and the word became
> red.

If you want an underline, as opposed to a border, then if you edit the
style and choose Font Effects then the colour of the underline can be
chosen immediately to the right of the underline style.

> Thank you.
> 


-- 
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] Thin Line under Heading - Border Line?

[Dave Howorth]

On Sat, 15 Aug 2020 16:25:26 -0400
Dan Lewis  wrote:

> You are working with the wrong style. You need to change the style
> for the title heading. This style should have several Tabs which
> include Font Effects which is where you need. There look for the
> title underlining. The drop down list to its right contains the type
> of underlining, and the next drop down list contains the possible
> colors that can be used.

The underlining only underlines the text itself. To 'underline' the
whole row, you need to set a border.

> Dan
> 
> On 8/15/20 3:43 PM, charles meyer wrote:
> > I'm trying to recreate that thin grey line which appears below a
> > title heading on Wikipedia pages.
> >
> > ex. https://en.wikipedia.org/wiki/Book
> >
> > Is that considered a Border Line in Libre Writer?
> >
> > If so, I tried to create one following these steps
> > https://help.libreoffice.org/Common/Defining_Borders_for_Tables_and_Table_Cells
> >
> > But, after I highlight my heading and the click Table, the
> > Properties under that is all grayed out.
> >
> > Thank you.
> >  
> 


-- 
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] Thin Line under Heading - Border Line?

[Dave Howorth]

On Sat, 15 Aug 2020 15:43:47 -0400
charles meyer  wrote:

> I'm trying to recreate that thin grey line which appears below a title
> heading on Wikipedia pages.
> 
> ex. https://en.wikipedia.org/wiki/Book
> 
> Is that considered a Border Line in Libre Writer?
> 
> If so, I tried to create one following these steps
> https://help.libreoffice.org/Common/Defining_Borders_for_Tables_and_Table_Cells
> 
> But, after I highlight my heading and the click Table, the Properties
> under that is all grayed out.

Why would you expect the formatting for a Header to be within a Table
properties?

Why didn't you select the header then styles/edit and then choose
an appropriate border? That appears to work as you wish.

> Thank you.


-- 
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] Add a bookmark to TOC

[Dave Howorth]

On Sun, 2 Aug 2020 15:23:57 -0400
John Kaufmann  wrote:

> On 2020-08-02 12:46, Office User wrote:
> > On 02/08/2020 15:34, Luuk wrote:  
> >> On 2-8-2020 13:06, User wrote:  
> >>> ...
> >>> Unfortunately, I wasn't able to view your document, because the
> >>> Google dictatorship would not allow me to see it without creating
> >>> one of their malware accounts. ...  
> >>
> >> Malware is something COMPLETELY different ...
> >>
> >> If you create such an account (i do not say you have to ), you
> >> still have the possibility to only use it under 'special'
> >> circumstances.
> >>
> >> Malware is something which gets used without permission(s)  
> > 
> > Luuk,
> > 
> > Under no circumstances whatsoever will you ever lecture me about
> > whatever terminology I choose to use.
> > 
> > You obviously lack the intellect to comprehend what was meant by my
> > reference to Google.
> > 
> > Your commentary is both unnecessary, unwelcome.
> > 
> > I ask that you never again respond to anything I post to this list
> > and any attempt at private contact will be ignored.
> > 
> > Please let this be an end to this thread.  
> 
> Sorry, Dave, but it should not end there: AFAICS (and if you see
> differently, please say how), Luuk has done nothing but try to help.
> He gave a solution to your problem (maybe not quite optimal, but one
> that you adopted in the end) and tried to show you how to access
> Michael's Google Drive file (which as inadvertently posted without
> public read privilege; as it happens, even if you had a Google
> account, you would have still needed to request to see the file).
> 
> OK, I get it: you don't like Google. That is your right. FWIW, I use
> my account rarely (never mail from it, and all mail to it forwards
> directly my regular email account), but the account is occasionally
> useful for taking advantage of Google services like collaboration
> tools (when initiated by others) or correcting Google browsing tag
> errors. That's all Luuk was trying to say: you don't have to let
> Google into your life to make use of some handy tools they offer. As
> he put it:
> 
> >> If you create such an account (i do not say you have to ), you
> >> still have the possibility to only use it under 'special'
> >> circumstances.  
> 
> Does that helpful hint warrant the kind of abuse you just delivered
> -- especially after he helped solve your problem?

+1 I support John's position. On the face of it, it is Dave (OP/OU) who
is being unreasonable.

> 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] Date acceptance patterns and date/time fields

[Dave Howorth]

On Fri, 31 Jul 2020 23:28:54 +0200
Johnny Rosenberg  wrote:

> Den fre 31 juli 2020 kl 20:57 skrev John Kaufmann :
> 
> > For many years my filing has used a kind of 'modified-ISO' 12-digit
> > date/time pattern: -MMDD-HHmm. Advantages are that it is
> > compact, easily read, sorts and is a valid filename string in all
> > OS.
> >
> > Writer has very flexible field formats, giving the option to
> > format Date fields as -MMDD, Time fields as HHmm, and either
> > Date or Time fields as -MMDD-HHmm -- so it has everything I
> > want, with complete flexibility to format as needed.
> >
> > Calc appears to be not flexible, but seems to use strict ISO
> > formatting for Date (-MM-DD) and Time (HH:mm:ss) fields. /Within
> > cells/, of course, there is flexibility to format Date and Time as
> > desired.
> >
> > Draw also appears to be not flexible, but uses /different/
> > formatting for Date (MM/DD/) and Time (HH:mm:ss AM|PM). This
> > seems to be the worst of all possible choices, because the formats
> > are neither strict ISO nor as I would like.
> >  
> 
> Which language settings do you have? I'm Swedish and in draw I can
> choose between the following date formats when inserting a date field:
> -DD-MM (default)
> DD  
> YY-DD-MM
> DD MMM 
> NN "den" D MMM YY
> D  
> 
> When inserting a time field I have the following options:
> HH:mm:ss (default)
> HH:mm
> HH:mm:ss,00
> HH:mm AM/PM
> HH:mm:ss AM/PM
> HH:mm:ss,00 AM/PM
> 
> It's not total freedom, but at least the ISO formats are there.
> 
> I agree though that it's strange that fields don't work the same over
> the whole suite. Seems like someone unnecessarily re-invented the
> wheel, and did that more than once…

I agree with those sentiments. I'm in the UK and Draw doesn't offer me
any choices I'm interested in, so I simply won't use it - it's not fit
for purpose IMHO. Why can't I use the same formats as you?

I've heard, but not experienced, that a Danish locale may be quite
useful, if the urge to use the program is stronger than common sense.

-- 
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] Re: Font in Basic IDE

[Dave Howorth]

On Fri, 26 Jun 2020 18:38:03 +0200
Johnny Rosenberg  wrote:

> Den fre 26 juni 2020 kl 18:20 skrev Johnny Rosenberg
>  >:  
> 
> > Today when I opened the Basic IDE for macro editing, I noticed that
> > the font changed. I'm not sure which one it is now, but maybe
> > FreeSans or something, but it used to be one of those mono fonts,
> > and I want my old font back. How do I change font in the Basic IDE?
> >  
> 
> I found it in the Tools → Options dialogue.  It was set to Automatic
> and to only include mono type fonts, but in spite of that, a non mono
> type font was selected. I just selected a mono type font (Droid Sans
> Mono), which is the only one I found so far that is true Sans Serif.
> Many Sans Serif fonts have a serif in the ones (1), for some strange
> reason, which I find inconsistent and ugly. Anyway, my problem is
> solved now and I'm happy with the Droid Sans mono until I find an
> even better one. Just strange that a non momo type font was selected
> when set to Automatic, I don't have a clue why that happened.

Traditionally monospace fonts have serifs becuase it makes it easier to
balance the spacing of the letters and so make the text easier to read.

Decoration of the digit 1 and the letter lower-case l is to avoid the
confusion between the two. Much as the various features used to
distinguish between the digit 0 and the letter upper-case O.

My copy of LO under Tools/Options/LibreOffice/Fonts has a dropdown for
Automatic or a particular font, and it has a check box for
Non-proportional fonts that is set, and which I assume it is using to
populate the dropdown, since I see only monospaced fonts in the list.

If you have these settings and it has selected a font that is not
'Non-proportional' then I suggest you investigate to determine whether:

- some proportional font has an incorrect attribute, causing it to be
  included in the list, or

- LO is ignoring your setting

In both cases a bug report would seem to be appropriate, but where it
goes depends on the diagnosis.

> 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

Re: [libreoffice-users] Base/HSQL table with more than two dimensions?

[Dave Howorth]

On Wed, 24 Jun 2020 02:28:45 -0400
John Kaufmann  wrote:

> A lectionary is an ordered set of readings, typically using a cycle
> of three or more years, to cover the Bible. In a four-year cycle the
> years are simply designated {A,B,C,D}, and for each day in a year
> readings are prescribed from different parts of the Bible. For any
> year, storing the readings in a database table is straightforward in
> two dimensions [fields (readings) x records (days)], and it is simple
> to SELECT the set of readings (usually from four different fields)
> for any day.
> 
> Obviously it is possible to do this in one table per year (say, four
> tables for four years), but since the pattern of records and fields
> is the same for all years, that is clumsy and should be unnecessary.
> It should be possible to do a table of three dimensions, of which the
> third dimension is the year {A,B,C,D} in the cycle, so that one could
> compare the readings for any given day across all years. But I don't
> see how to extend tables into three (as in this case) or more
> dimensions. Can someone point me in the right direction?  [It seems
> like this kind of database design issue should be common to a lot of
> domains.]

Every extra field added to a record creates another dimension in data
space. So you just need to add a column called, say, year that can take
each of the values 'A', 'B', 'C' or 'D' and then add that field to your
SELECT statement.

> Thanks,
> 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] Lost messages [was: Getting a Red-box around Cell entries or Selected Areas]

[Dave Howorth]

On Fri, 29 May 2020 18:17:05 +0100
Brian Barker  wrote:

> At 18:08 29/05/2020 +0100, I wrote:
> >... I suspect that this message from me will also appear in the 
> >archive but not be received by *some* mailing list subscribers, 
> >whose mail providers simply obey the standards and reject my 
> >messages as forwarded by the list.  
> 
> Aha! I'm delighted to find that I was wrong. My btinternet.com mail 
> has been provided for some time by Yahoo, but was changed a few days 
> ago and is no longer. My new mail arrangements no longer show the 
> problem. But M. Gauthier is still out of luck - and it's the fault of 
> the LibreOffice Users list, not his yahoo.com.

Sorry, I don't know very much about this subject, but AFAICT you are
blaming an innocent party here. The DMARC standard is, AIUI, an
ill-thought out disaster as far as mailing lists are concerned and the
blame should therefore be attached to mail providers such as Yahoo who
apply such a flawed standard without due consideration.

To me, it's more an indication to avoid Yahoo and its ilk than any
criticism of this or any other list experiencing such problems.

> Brian Barker

-- 
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] Range names

[Dave Howorth]

On Tue, 5 May 2020 21:20:24 +0200
Johnny Rosenberg  wrote:

> Den tis 5 maj 2020 kl 08:38 skrev Luuk :
> 
> >
> > On 4-5-2020 09:43, Brian Barker wrote:  
> > > At 09:35 03/05/2020 +0200, Johnny Rosenberg wrote:  
> > >> Let's say I have a spreadsheet (I actually have several…) with a
> > >> lot of cells and ranges already filled with data and formulas.
> > >> One day I discover the range naming feature, so I name a few
> > >> cell ranges. Shouldn't there be some easy way to replace every
> > >> occurrence of those cell ranges in all my formulas?  
> > >
> > > I don't think any automatic system could do exactly what you
> > > probably want.  
> >  
> 
> What I probably want doesn't have anything to do with me. That's
> rather a matter of other peoples guesses about me and not relevant
> for anything.
> 
> >  
> > > Say your range is A1:B5 on Sheet1 and suppose you name this as
> > > Name. You may think that "Name" is now synonymous with "A1:B5",
> > > but no: instead it is shorthand for "$Sheet1.$A$1:$B$5".  
> 
> 
> Great, that's exactly what I want.
> 
> There are thirty-two
> > > variations on "Sheet1.A1:B5" you may have in your spreadsheet,
> > > each including a different combination of those dollar signs. As
> > > you will know, each version behaves differently if you fill
> > > ranges from a cell with a formula containing it, or if you copy
> > > and paste from such a cell. So the differences are important. By
> > > including "Name" in a formula, you are choosing to imply the
> > > anchored or absolute version of the range.  
> >  
> 
> I can't see any problems with that. Maybe I don't follow.
> 
> >  
> 
> > In order to preserve the precise meaning and behaviour of your  
> > > existing formulae, any automatic system should replace a
> > > spelled-out reference only when it includes all five dollar
> > > signs.  
> 
> 
> Yes, why would it do anything else than that?
> 
> 
> > But in practice  
> > > one may rarely add all those dollar signs in formulae, instead
> > > using only as many are necessary for the filling or copying that
> > > one is expecting to need.  
> 
> 
> Oh, I don't know anything about that. I only know I wouldn't, and if
> I did, it would be my fault only. I'm not expecting Calc to do the
> thinking for me.
> 
> 
> > I suspect you wouldn't be impressed if an automatic  
> > > system failed to replace "A1:B5" or "A$1:B$5" with your newly
> > > defined "Name".  
> 
> 
> No, I'm rarely impressed when things just work as expected. They just
> should.
> 
> 
> > But if it did, it would corrupt some spreadsheets that you or  
> > > others might compose.
> > >  
> > >> And when I say easy, I mean easier than doing search and replace
> > >> on each one of them one by one. I can't find such a feature. Is
> > >> there an extension for it?  
> > >
> > > When you do this, you would need to determine in each case
> > > whether the replacement by the range name would be appropriate.
> > > And an automatic system could not do that for you.  
> >  
> 
> No, that's just wrong. Only absolute references (those with $-signs
> everywhere) will be searched for, nothing else. Don't over complicate
> this now.
> 
> >  
> > >> I'm going to write a macro for it, ...  
> > >
> > > Which of the thirty-two variations will it replace?  
> >  
> 
> The one that Calc itself associates with the name, that is those with
> $-signs everywhere. I actually finished my macro instead of making up
> a lot of problems.
> It proved to be quite easy, actually:
> You can easily get any used name and its corresponding reference (or
> ”address”) by index with:
> lNameCount=ThisComponent.NamedRanges.getCount()
> For lNameIndex=0 To lNameCount-1
>  sName=ThisComponent.NamedRanges.getByIndex(lNameIndex).getName()
>  sAddress=ThisComponent.NamedRanges.getByIndex(lNameIndex).getContent()
>  ⁝
>  ⁝
> Next lNameIndex
> 
> sAddress in this case always looks something like $SomeSheet.$A1:$B75.

Why isn't it: $SomeSheet.$A$1:$B$75 ?

> Inside that loop I have another loop, that loops through all sheets.
> When searching the same sheet as the Name is located, I also search
> for $A1:$B75 kind of reference.
> 
> It works great as far as I can tell, so far. Maybe I will run into
> something in the future, who knows?
> The only problem I saw so far is that at one point there was a
> reference like this: $SomeSheet$A$1:$SomeSheet$B$75, that is with the
> sheet name on both sides of the colon. I'm not sure how that could
> happen. I'm pretty sure I didn't type that and so far I found no way
> to make Calc doing that, so I'm not sure what went wrong there. Maybe
> it was me after all. The macro seems to be very fast anyway, so I
> guess I could make it take care of that kind of reference as well
> with reasonable speed.
> 
> 
> Kind regards
> 
> Johnny Rosenberg
> 
> 
> 
> > If every combination has a unique (range-)name,  who cares?
> >
> > A1:B5 ==> range1
> >  
> 
> I tried to assign a name to such a reference, but Calc didn't like
> that 

Re: [libreoffice-users] Can Libreoffice Compress a PNG file?

[Dave Howorth]

On Fri, 24 Apr 2020 17:38:14 +0200
M Henri Day  wrote:

> Den fre 24 apr. 2020 kl 17:17 skrev Luuk :
> 
> >
> > On 24-4-2020 15:11, M Henri Day wrote:  
> > > Den fre 24 apr. 2020 kl 08:22 skrev Luuk  > > >:
> > >
> > >
> > > On 23-4-2020 06:06, Musical Neptunian wrote:  
> > > > I  make Twitch emotes in GIMP. They cannot be more than 25
> > > > Mb or  
> > > Twitch  
> > > > rejects them. I found a tutorial somewhere that said that  
> > > Libreoffice has a  
> > > > png compression tool. But when I put my png into
> > > > LibreOffice I  
> > > got a whole  
> > > > load of symbol junk. So instead I used a free online tool
> > > > that  
> > > reduced my  
> > > > png from 30 Kb to 7 Kb with no quality change. But could I
> > > > have  
> > used  
> > > > anything in Libreoffice to do this?  
> > >
> > >
> > > I would never use LibreOffice for compressing images.
> > >
> > > use any tool found on the internet, like:
> > >
> > >  
> > https://stackoverflow.com/questions/19153122/image-compression-tools-via-command-line
> >   
> > >
> > >
> > > Luuk, perhaps you could explain just why you would never use a
> > > LibreOffice too for compressing images. Doesn't the one suggested
> > > by Philip perform satisfactorily ?...
> > >
> > > Henri  
> >
> > Just because LibreOffice is not an image-editor. It's about creating
> > document, or spreadsheets.
> >
> > Ik will also no use my bicycle to transport loads of goods, that's
> > what trucks are for 
> >  
> I was inquiring about *specific* problems you had encountered with the
> image-compression tool in LibreOffice.

If he never uses LO for that purpose, clearly he will never have
encountered any specific problems doing so! He never said he did. He
just stated his own views.

> I regularly transport goods on
> my bicycle, if doing so suits my needs 

Just as you state yours. Good for you, BTW. I do too sometimes but not
as often as I should.

> Henri

-- 
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] Splitting columns in Calc

[Dave Howorth]

On Tue, 21 Apr 2020 02:37:33 +0200
Pat Brown  wrote:

> I have a spreadsheet that includes a column consisting if people's
> names. I want to split this into two columns. I want one column with
> the given names and the other with their family names. This requires
> taking the last word in the column and creating a new column with
> this word. Is there a way to do this in Calc?

Note that the family name may not always be the last word. There are
various cultures where the family name comes at a different position in
the order, and even in English culture the family name may consist of
more than one word.

> Thanks,
> 
> Paddy


-- 
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] Adding a / (forward slash)

[Dave Howorth]

On Sat, 04 Apr 2020 13:45:38 +0100
Brian Barker  wrote:

> At 07:50 04/04/2020 -0400, Peter Dutton wrote:
> >Thanks- the "/" works perfectly.  
> 
> Good-oh!
> 
> >Nothing's easy in this world.  
> 
> Many things are.
> 
> >What has been created in the calc sheet is the day number of the 
> >year which is followed by the "/".  In the cell beside the result is 
> >the remaining number of days in the year. Here's an example of what 
> >I'd like to see for this date (February 10, 2020)
> >41 / 325
> >
> >In this case 325 is the remaining number of days in the year 2020 
> >from the date Feb. 10. The cell in which the formula used to obtain 
> >the figure of 325 is-
> >=365-S4+1
> >
> >"S4" is the cell where the day number of the year is located 
> >returned by the formula, as mentioned below-
> >=DATEDIF($Begin_Here.$E$76,R4,"d")" / "  
> 
> I still don't think this is the clearest or best formula for what you 
> need. (And you've lost the ampersand, though I suspect that's a 
> "feature" of your mail system.)
> 
> >What happens to the remaining days number in cell S4 the dreaded 
> >error - #VALUE! is returned. I suspect this has something to do with 
> >the formatting of the cell but can't figure it out.  
> 
> It's nothing to do with formatting: it's to do with, er, values. It's 
> hardly surprising, since - as I made clear - what you have now put in 
> S4 is not the number 41 but the *string* "41 / ", and that is not a 
> number. You cannot calculate with strings (unless they happen to 
> represent numbers in a simple way). What do you expect if you try to 
> divide "three" by "two"? "one point five"?!
> 
> >Any ideas?  
> 
> Yes. Take the concatenated slash off your formula so that it creates 
> the number 41 in S4, as before. Then use
> =S4&" / "&366-S4
> for your result.

Or keep the two numbers in separate columns as before, but insert
another column just containing '/' in between them. It depends what the
result is to be used for.

> I trust this helps.
> 
> Brian Barker
> 
> 


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

Fw: [libreoffice-users] Re: Unable to subscribe to users@global.libreoffice.org

[Dave Howorth]

Sorry, there's been some correspondence offlist. Mea culpa; I didn't
check the reply-to address.

Begin forwarded message:

From: Dave Howorth
On Fri, 3 Apr 2020 15:47:16 -0400
Robert Steinmetz  wrote:

> I have and they aren't there.  

But you obviously got my mail, so you are getting some at least?

(and of course, that was offlist, so do you see this?)

> On 4/3/20 3:31 PM, Dave Howorth wrote:  
> > On Fri, 3 Apr 2020 12:35:05 -0400
> > Robert Steinmetz  wrote:
> >
> >> I am apparently subscribed but have not been receiving
> >> messages.
> > Have you checked your spam directory/mechanisms?
> >   
> >> On 4/3/20 12:27 PM, users+h...@global.libreoffice.org wrote:
> >>> Hi, this is the Mlmmj program managing the
> >>>  mailing list.
> >>>
> >>> You were unable to be subscribed to the list because you are
> >>> already subscribed.
> 
>   


-- 
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] Re: Unable to subscribe to users@global.libreoffice.org

[Dave Howorth]

On Fri, 3 Apr 2020 12:35:05 -0400
Robert Steinmetz  wrote:

> I am apparently subscribed but have not been receiving messages.

Have you checked your spam directory/mechanisms?
 
> On 4/3/20 12:27 PM, users+h...@global.libreoffice.org wrote:
> > Hi, this is the Mlmmj program managing the
> >  mailing list.
> >
> > You were unable to be subscribed to the list because you are already
> > subscribed.

-- 
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] Windows - using Writer and VLC Media Player to as text to an attachment

[Dave Howorth]

On Sun, 15 Mar 2020 14:57:06 -0400
charles meyer  wrote:

> Hi All,
> 
> I've got a refurbished laptop running W10 Pro and installed the
> latest VLC Media Player.

Sorry but what has a VLC problem got to do with libreoffice?

> On W7, I could Add a video file downloaded from YouTube and then
> select Convert and it allowed me to browse to where I want to
> convert/save it to (e.g. hard drive, flash drive, etc.) and to choose
> which format to convert to/save as (e.g. .flac, .mp3).
> 
> But, VLC doesn't seem to do that now.
> 
> I've read I need to make modifications in  the "Sapnner" button.
> 
> I never had to do that with older VLC Media Player.
> 
> I've Googled this and looked at 3 pages of results but none show me
> what that Spanner button likes like, where to find it nor what
> settings I need to set to enable Convert (in older version a
> drop-down menu would appear in the down arrow offering many formats
> to convert to including .flac, .mp3, etc.)
> 
> I anyone has a url link to graphic images which show you what you
> need to now re: the Spanner button or if you could share the url to
> any site which details that I;d appreciate your help.
> 
> Thank you.
> 


-- 
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] Error Message trying to run LO Calc

[Dave Howorth]

On Wed, 11 Mar 2020 14:34:36 +0300
Patrick Kariuki  wrote:

> Will share the details privately since the file might be proprietary
> information (just to be on the safe side)

Thanks.
(a) please don't send private copies of your replies to me - I am
subscribed to the list
(b) I doubt I'll be able to help you but as I said I doubt anybody will
be able to help unless you state the actual error message you're seeing.

PS personally I'm not going to click on a link and enable javascript
to download a file, let alone load the downloaded file into LO and
enable macros. I can be just as paranoid as you :)

FWIW, in private email you said "Click Next or move to the Last tab
then Validate, that's where the error pop ups." That suggests to me
that the error is in macro code that runs when you click Validate. You
might want to extract that code and look for problems, but unless you
tell us the error message as well as post that code, nobody can help
you.

> On 3/11/20, Dave Howorth  wrote:
> > On Wed, 11 Mar 2020 12:24:03 +0300
> > Patrick Kariuki  wrote:
> >  
> >> Our revenue service provides us with a .ODS file to file our
> >> returns for those running Linux or open-source spreadsheet
> >> software. It always generates an error when it has to finally
> >> generate a n uploadable file.
> >>
> >> Is there a developer here who can assist troubleshoot the issue?  
> >
> > Maybe if you stated which revenue service it is, and exactly what
> > the error message is it might provide enough information to get
> > started helping you? Later, copies of the actual data files might
> > well be helpful.

-- 
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] Error Message trying to run LO Calc

[Dave Howorth]

On Wed, 11 Mar 2020 12:24:03 +0300
Patrick Kariuki  wrote:

> Our revenue service provides us with a .ODS file to file our returns
> for those running Linux or open-source spreadsheet software. It always
> generates an error when it has to finally generate a n uploadable
> file.
> 
> Is there a developer here who can assist troubleshoot the issue?

Maybe if you stated which revenue service it is, and exactly what the
error message is it might provide enough information to get started
helping you? Later, copies of the actual data files might well be
helpful.

-- 
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] Word counting in LO Writer

[Dave Howorth]

On Wed, 18 Dec 2019 20:57:55 +0100
Krunose  wrote:

> Hi,
> 
> is it ok for LO to find five words in 'This is < a word.' as

I'd have thought the answer was either 4 or 6 depending on whether you
ignore '<' or pronounce 'less than'. :)

> https://www.countofwords.com/
> 
> finds only four. Don't know how that reflects on this like 'This is 4
> words' and not sur so on. It's hard to anticipate every possible
> variant
> - is that the reason?
> 
> Is there more information about this?
> 
> Thanks,
> 
> Kruno
> 
> 


-- 
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] confused about hidden cells

[Dave Howorth]

On Sat, 2 Nov 2019 20:46:40 +
Dave Howorth  wrote:

> I have received a spreadsheet, which I've opened as a .xlsx and then
> saved as a .ods. It has some hidden rows that I'd like to be able to
> see. So I selected the entire sheet and went to the Format/Rows menu
> but the Show menu item is greyed out. How can I unhide the hidden
> rows?
> 
> I note that a lot of the spreadsheet is protected cells. Does that
> have something to do with it? (and if so what? :)
> 
> I'm running LO 6.2.6.2 on openSUSE Leap 15.0
> 
> TIA, Dave
> 

Ah never mind. Immediately after writing this, I discovered
Tools/Protect Sheet and it was checked! After unchecking it, I'm fine.

-- 
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] confused about hidden cells

[Dave Howorth]

I have received a spreadsheet, which I've opened as a .xlsx and then
saved as a .ods. It has some hidden rows that I'd like to be able to
see. So I selected the entire sheet and went to the Format/Rows menu
but the Show menu item is greyed out. How can I unhide the hidden rows?

I note that a lot of the spreadsheet is protected cells. Does that have
something to do with it? (and if so what? :)

I'm running LO 6.2.6.2 on openSUSE Leap 15.0

TIA, 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] Zotero toolbar doesn't show in Libreoffice

[Dave Howorth]

On Wed, 23 Oct 2019 08:08:13 -0700 (MST)
Sebastian  wrote:

> Hi!
> 
> I am having problems installing Zotero in Libre Office. The Zotero
> toolbar simply doesn't show. I am thankful for any assistance!
> 
> Below, I will (I) explain the procedures so far, (II) put my
> question(s).
> 
> (I)
> 
> - I have downloaded the latest version of Zotero and updated
> LibreOffice on my Mac.
> - In Zotero > Tools > Add-Ons > Extensions, "Zotero LibreOffice
> Integration" is installed and enabled.
> - In LibreOffice > Preferences > Advanced, "Use a Java runtime
> environment" is checked.
> - When I check the System and click Java, it says that Java is
> installed and up to date.
> 
> BUT:
> 
> - There is no Zotero toolbar in LibreOffice under View > Toolbars.
> - When I go to Zotero > Cite > Word Processors, it says that the
> LibreOffice Add-On is not installed, and when I click Install, the
> following message shows:
> 
> 
>  
> 
> It says, the PlugIn requires the "Java Development Kit".
> 
> (II)
> 
> So, from the above, Java seems to be the problem. But (from the
> above) I have Java. Or not? Or do I need some special Java-thingy?
> Could someone perhaps please post a link with or describe exactly
> what needs to be done.
> 
> I am not computer-savvy, so please use a language for dummies!

Java is a computer language. If you want to run programs written in it
on a computer you need at least the Java Runtime Environment (JRE). If
you want to write programs in it, you need extra files and must install
the Java Development Kit (JDK) instead (it contains the JRE).

To complicate matters, some programs need the JDK instead of the JRE to
run. It seems that the PlugIn is one such. It may be that you have the
JRE installed on your computer and that the computer is reporting this
as having 'Java' installed in order to simplify things for ordinary
people. If so, you need to find and install the JDK instead. (and
whoever decided that saying 'Java' instead of 'Java Runtime
Environment' was simpler and better needs shooting in the head :)

I'm afraid I can't tell you how to do that because I'm not familiar
with Macs.

> Best wishes,
> Sebastian

-- 
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] Libreoffice, task manager bar and the running application icon

[Dave Howorth]

On Thu, 10 Oct 2019 20:08:17 +0200
aguador  wrote:

> BTW your message seems to imply that you have both the GTK XFCE and
> the QT Plasma DEs installed together, which is unusual. There might
> be a chance that has something to do with the problem you are having.
> So again, I would check with your distro.

There's nothing strange about having multiple desktops installed. Most
login managers allow you to choose which you want when you log in.

-- 
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] Unable to use LibreOffice in Collabora Online Development Edition (CODE)

[Dave Howorth]

On Wed, 11 Sep 2019 15:46:34 +0100
João Jerónimo  wrote:

> Hello,
> 
> I downloaded the Collabora Online Development Edition (CODE) virtual 
> appliance for VirtualBox from 
> https://www.univention.com/products/univention-app-center/collabora-online-development-edition-with-owncloud/
> 
> The in-app documentation says that I need to install CODE and owCloud 
> from the app center that exists inside the running appliance, and I
> did so. Actually, both apps come already installed when the appliance
> is launched.
> 
> However, when I logged in at the owncloud app, using the default 
> "owncloud" username and password, the CODE module does not appear in
> the Settings->Admin->Apps menu. As you can see in the attached
> screenshots.
> 
> What am I doing wrong?

I expect you need to ask the support people for the product you are
using. i.e. Univention GmbH

> Thanks in advance.
> 
> João Jerónimo
> 
> 
> 


-- 
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] List down?

[Dave Howorth]

On Thu, 15 Aug 2019 19:44:27 +0900
Thomas Blasejewicz  wrote:

> Good evening
> Is the list down?
> I have not received a single message in almost a week.
> 
> Thomas

You can check the archive to see if you've missed anything. The address
is listed at the bottom of every message. I've copied your address as
well, in case you aren't getting anything from the list and wouldn't
see this.

-- 
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] Re: insert non-breaking semi-space

[Dave Howorth]

On Sun, 16 Jun 2019 22:09:12 +0200
Luuk  wrote:

> But, to /me and i am only talking about Windows here, as long as the
> key in mentioned here 
> (https://support.microsoft.com/en-ca/help/12445/windows-keyboard-shortcuts) 
> than i call it universal 

Well, as I never use Windoze, I don't call it universal :)

So it seems you're suggesting a different menu structure under
different operating systems? I'm not sure that's a desirable goal.

-- 
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] Re: AltGr functionality

[Dave Howorth]

On Sun, 16 Jun 2019 17:18:19 +0200
Johnny Rosenberg  wrote:

> Den sön 16 juni 2019 kl 16:19 skrev Peter Maunder
>  >:  
> 
> > I suggest you check your system/keyboard settings to sort out the
> > default system settings.  
> 
> 
> I already know that it works with my default settings. It's only with
> my own layout it doesn't work. The main reason for that is probably
> that my own layout is the only one that use those keys for typing
> characters (with AltGr).
> 
> 
> > How you do this will depend on your system first not LibO
> > and the actual keyboard, language and brand. What operating system
> > and language are you using, and what keyboard setting is defined?
> >  
> 
> Manjaro and I use a standard Swedish keyboard.
> 
> 
> > AltGr is controlled by your system KEYBOARD setting. Technically
> > they are called LEVEL 3 and LEVEL 4 (AltGr and SHIFT-ALtGr). Level
> > 1 and 2 are Lowercase and Shift. The settings depend on your
> > keyboard, language and the use of Keyboard-OPTIONS. The keyboard
> > input is then handed over to the application, in this case
> > LibreOffice. 
> 
> Yes, but can you then explain why it works in most other
> applications? It works perfectly in all of the text editors I tried
> so far, for instance. There are some difficulties with some web
> browsers, though. Firefox is the one that works best in this aspect.
> 
> >
> > For example on my Keyboard set to English (UK) international, many
> > of the European accents, are set using the AltGr, for example ç é á
> > Ç É Á and € (the latter is dependant on the option settings).
> >  
> 
> Yes, but you can't type with your arrow keys. I can. Except not in
> LibreOffice. Here are what's on AltGr+ and
> AltGr+Shift+ keys>: ←↑↓→ ⬄↹↔⇨  
> When using AltGr+ up|page
> down>, LibreOffice seems to ignore AltGr completely, but not when
> down>using for  
> instance AltGr+c which types a ℃ character.
> 
> So if the problem is in my system, why does it work in some
> applications? It shouldn't work at all then, should it?
> As I said, it SEEMS like LibreOffice ignores AltGr if it's not
> combined with a key that normally types some kind of character.

Ah, this is the first time that you made it clear that the problematic
behaviour is specific to LO and not to the same keys in other
applications. (at least, the first time you made it clear enough for me
to understand).

What output does xev give when you press those keys with the various
shift configurations?

> > I also have American-International,  Irish, German(Switzerland) as
> > alternative keyboard settings to test different settings for LibO,
> > oh and French(French).  They are controlled by the system.
>
> Then I would appreciate very much if somebody would help me finding
> out what's wrong with my layout. I'll share my configurations to
> everyone who asks for it. Not asking anyone to help with that, just
> saying I would appreciate it.
> Thanks for replying. ☺
> 
> 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

Re: [libreoffice-users] Re: insert non-breaking semi-space

[Dave Howorth]

On Sun, 16 Jun 2019 08:41:42 +0200
Luuk  wrote:

> On 16-6-2019 05:59, V Stuart Foote wrote:
> > Luuk wrote  
> >> Why did this option not get a 'reserverd place in the menu' ?
> >> together with the shortcut-key reference (
> >> 
> >> +X) ?
> >>
> >> An option like
> >> 
> >> +C is only known to all people (more than 75 % ??),
> >> because the shortcut key is next to it in the menu!  
> > Hmm, interesting question.  The BZ tdf#73691 sheds no light, and I
> > can't remember any discussion of adding it to a menu. But it was
> > prominently advertised in the release notes for 5.1
> > 
> >
> > The actual .uno:UnicodeNotationToggle command is available to
> > assign in Customization receiving default en-US name in
> > Customization of "Toggle Unicode Notation" and can be added to
> > Menu, Toolbars, and Context menu. It shows for LibreOffice globally
> > as +x -- Command Name and the keyboard shortcut are localized
> > and configured by os.
> >
> >   I could possibly see it assigned to the Standard toolbar,
> > adjacent to the Special character dialog button.
> > But, I'm not sure how it could be ussed from menu, and which menu
> > -- Insert, Format or even Tools -- would hold it. Checked, and it
> > does _not_ appear on any MS Office menus.
> >
> > So kind of seems the enhancement of the BZ issue was fully
> > implemented--with no functional reason to add it to a menu just to
> > expose the shortcut.
> >
> > Stuart
> >  
> Thanks for the explanation.
> 
> There are other function which are useless in the menu, like i.e. 
> CTRL+C. Most (read 'all') users will use their keyboard.

Not true. Copy does not have a universal accelerator unfortunately,
sometimes it is Shift+Ctrl+C or other things. So I sometimes use the
menu in applications that I'm not completely familiar with.

> About the position of 'ToglleUnicodeNotation' in the menu (if that
> ever becomes an issue ),  the 'edit' menu is a better place,
> because it's not inserting something.
> 
> 
> Luuk
> 
> 
> 


-- 
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] Tabs in selection of text

[Dave Howorth]

On Mon, 8 Apr 2019 14:32:05 +1200
Steve Edmonds  wrote:

> Hi.
> What version of LO do you have.
> Just as a test, can you click into just 1 line and then add a tab stop
> to the ruler.
> Steve

Also what OS?

In addition, can you post an example of the text/document that you
cannot format tabs for somewhere? Perhaps it is a data-dependent
problem, since tab stops work as you expect for other people including
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

Re: [libreoffice-users] Inserting a Trademark Symbol in Label

[Dave Howorth]

On Wed, 3 Apr 2019 11:43:34 +0200
Philip Jackson  wrote:

> On 03/04/2019 07:29, Michael H wrote:
> > :tm: is in the LibreOffice autocorrect database. colon-tm-colon
> > (lower case matters.) should produce a TM logo if you have
> > autocorrect enabled. 
> In my LO Writer (6.0.7.3), the autocorrect option is (tm) using
> parentheses and not colons.

In mine (6.1.3.2) either works :)

But I get an unusable window to choose characters from if I follow
Budge's instructions. All the characters, and the window itself are far
too large and overlap horizontally. Vertically the window is taller
than my screen and not resizable.

If that occurs with a current version, I'd think a bug report was
appropriate. It's a surprisingly glaring bug.

-- 
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] Concatenate Function inCalc

[Dave Howorth]

On Tue, 2 Apr 2019 23:27:16 +0200
Regina Henschel  wrote:

> Hi Michael,
> 
> Michael H schrieb am 02-Apr-19 um 13:03:
> > CONCATENATE must either fail to accept ranges (with an error), or
> > accept them and provide the combination that acceptance suggests.
> > It is a bug that it accepts ranges, but returns something else.
> >   
> 
> Because CONCATENATE expects a list of simple references, it performs
> an "implicit intersection", if instead of a simple reference a range
> is given.
> http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#ImpliedIntersection
> 
> That is the reason, that sometimes you get the content of a single
> cell as result and sometimes an error.

That's a crazy idea that will lead to all kinds of obscure errors. Far
better to unconditionally return an error, IMHO.

> 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] edit autocorrection options

[Dave Howorth]

On Sat, 16 Mar 2019 19:40:52 +0100
Johnny Rosenberg  wrote:
> > > First of all, sorry for mailing you privately. This mailing lists
> > > doesn't behave like any of the other lists I'm subscribed to, so I
> > > often forget to hit ”reply to all”…  
> >
> > On my mailer (claws) I just hit reply and it all works.
> 
> I don't use a ”mailer” (whatever that is), I use Gmail's web
> interface.

Well, what I am saying then is that it is gmail's interface that is
wrong, not the mailing list. My MUA handles it correctly.
 
> > > I'm not sure why you can't find your (c) entries, I find mine
> > > easily on my system, and I know for sure I didn't add them myself
> > > (since I have the © character included in my own keyboard layout
> > > anyway – Shift+AltGr+c).  
> >
> > FWIW, on my keyboard it is AltGr-Shift-c. Order matters and
> > Shift-AltGr-c does not work.
> 
> What do you mean ”order matters”? You hit Ctrl and AltGr at the same
> time and keep them down while pressing c, don't you?

No I don't because order matters.

> I'll it right now:
> First pressing Shift, keeping it down, then also pressing AltGr and
> keeping both down while pressing c: ©

Nope, no character results.

> Now, pressing AltGr, keeping it down, then also pressing Shift and
> keeping both down while pressing c: ©

©  QED

> Doesn't matter on my computer anyway.

Does matter on mine. And on every other computer I remember using.

So I believe it was worth pointing out to the OP in case his system
behaves like mine.

> This was tested with my own keyboard layout (Swedish ̣– Johnny
> Rosenberg). Now I'll test it with the standard Swedish layout:
> Shift Shift+AltGr Shift+AltGr+c: ©
> AltGr AltGr+Shift AltGr+Shift+c: ©
> Works perfectly (on my computer, operating system=Manjaro Linux,
> desktop environment=XFCE).

openSUSE Leap 15.0 with UK keyboard and XFCE.

> Kind regards

Equally 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] edit autocorrection options

[Dave Howorth]

On Fri, 15 Mar 2019 22:58:51 +0100
Johnny Rosenberg  wrote:

> Den fre 15 mars 2019 kl 02:35 skrev Thomas Blasejewicz
> :
> 
> > On 2019/03/15 2:04, Johnny Rosenberg wrote:  
> > > Den tors 14 mars 2019 kl 16:57 skrev Thomas Blasejewicz
> > > mailto:ny...@hb.tp1.jp>>:
> > >
> > > On 2018/12/24 16:46, Brian Barker wrote:  
> > > > At 15:55 24/12/2018 +0900, Thomas Blasejewicz wrote:
> > > >  
> > > >> The problem: there *** IS NO *** (c) in the replacement
> > > >> list.  
> > > (only  
> > > >> (R)) I have looked at least twice. In all three languages
> > > >> I use.  
> > > >
> > > > As you will have seen, V Stuart Foote finds ".*(C)" there.
> > > >  
> > > >> I just entered (c) under "Replace" AND "With". For now,
> > > >> that  
> > > seems to  
> > > >> be working.  
> > > >  
> > > Since I am struggling with the autocorrect options again ...
> > > I remember that entering (c) once worked .. but not any more.
> > > (c) IS listed under exceptions, but nevertheless it is ALWAYS
> > > converted
> > > to the copyright symbol, regardless of what I do.
> > >
> > > What I CAN do is: type "(c " followed by some other text and
> > > LATER add
> > > the right-sided bracket.
> > > But that is a rather inconvenient procedure.
> > >
> > > Any way out of this?  
> >  
> 
> 
> First of all, sorry for mailing you privately. This mailing lists
> doesn't behave like any of the other lists I'm subscribed to, so I
> often forget to hit ”reply to all”…

On my mailer (claws) I just hit reply and it all works.

> I'm not sure why you can't find your (c) entries, I find mine easily
> on my system, and I know for sure I didn't add them myself (since I
> have the © character included in my own keyboard layout anyway –
> Shift+AltGr+c).

FWIW, on my keyboard it is AltGr-Shift-c. Order matters and
Shift-AltGr-c does not work.

> Did you notice that when you select your language,
> the first option is something like ”all languages”? Maybe you can
> find it there?
> 
> Another thought is that maybe you use some other software such as
> AutoKey or AutoHotKey that does approximately the same thing at a
> more global level? If you don't know what those are, you are probably
> don't have them installed, though.
> 
> 
> Kind regards
> 
> Johnny Rosenberg
> 
> >  
> > >
> > > Probably, but if you can't find one, just define a new line in the
> > > list that converts something (for instance ”ccc” or something else
> > > that's easy to type fast) to (c).
> > >
> > > I guess you could also remove (c) entirely from the list.
> > >
> > > Also, I'm not sure why you have this problem; I don't. When I
> > > type (C) it converts to ©, but (c) doesn't.
> > >
> > >  
> > Thank you.
> > * When I type (C) nothing happens, whereas (c) is converted to
> > "copyright". Exact opposite behavior to the one in your computer. Is
> > there a setting for this?
> > * Adding a new item -> tried ccc -> nothing happens.
> > * Deleting (c) -> I cannot find it in any list (for English, German
> > and Japanese). There does not seem to be such an entry.
> >  Or is there a trick to find it?
> > * The Ctrl+z trick works, but I believe, there should be something
> > more rational.
> >
> > This may be an unimportant matter, but it is nevertheless  very
> > annoying. Thank you
> > Thomas
> >  
> 


-- 
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 the best way to make charts of spreadsheet data

[Dave Howorth]

On Sat, 5 Jan 2019 10:50:42 +0100
Luuk  wrote:

> On 4-1-2019 18:54, Regina Henschel wrote:
> > Hi Dave,
> >
> > Dave Howorth schrieb am 02-Jan-19 um 18:12:  
> >> [..]
> >>
> >> My spreadsheet data is in columns. Column A is the dates and
> >> column B is the times. Then ten columns of humidity data and
> >> eleven columns of temperature data. There are currently just over
> >> 5000 rows of samples.
> >>
> >> Making the chart was extremely slow. Every time I changed the Name
> >> of a line of the chart I had to wait whilst it cycled through
> >> several steps to make the change. Initially when I removed some
> >> empty columns from the data range, it took an age to do so. etc.  
> >
> > Each data item produces an object, which is selectable in edit mode
> > of the chart. Your data produce 5000*(10+11)=105000 objects. That
> > cannot be fast.
> >
> > What is the purpose of the chart? You do not need 105000 objects to 
> > illustrate something.
> >
> > With 5000 items in x-direction a lot of them will be on top of
> > others. My screen has only 1920 dots width and yours?
> >  
> The fact that a screen has only (a limited) number of pixels, has 
> NOTHING to do with how many items are used, or can be used,  in a
> graph.

You're clearly not a programmer.

> Maybe the user has a A0-plotter to print this graph?

In which case the resolution of the output device is greater.

> This should still be possible with software like LibreOffice, or the 
> should kill the option to create graph's

> just 2 cents

My 2p

-- 
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 the best way to make charts of spreadsheet data

[Dave Howorth]

On Fri, 4 Jan 2019 18:54:47 +0100
Regina Henschel  wrote:

> Hi Dave,
> 
> Dave Howorth schrieb am 02-Jan-19 um 18:12:
> >[..]
> > 
> > My spreadsheet data is in columns. Column A is the dates and column
> > B is the times. Then ten columns of humidity data and eleven
> > columns of temperature data. There are currently just over 5000
> > rows of samples.
> >
> > Making the chart was extremely slow. Every time I changed the Name
> > of a line of the chart I had to wait whilst it cycled through
> > several steps to make the change. Initially when I removed some
> > empty columns from the data range, it took an age to do so. etc.  
> 
> Each data item produces an object, which is selectable in edit mode
> of the chart. Your data produce 5000*(10+11)=105000 objects. That
> cannot be fast.
>
> What is the purpose of the chart? You do not need 105000 objects to 
> illustrate something.
> 
> With 5000 items in x-direction a lot of them will be on top of
> others. My screen has only 1920 dots width and yours?

Thanks, but this answers itself. If my screen or window has less
pixels, then why create more objects and try to represent them? The
chart software should be sampling the data appropriately to the
resolution.

And sure if I want to explore the detail, then I should be able to
expand a section of the X-axis. I'm thinking of something like the
graph module in emoncms, which handles this task with reasonable speed.

> > Now I've created the chart and got some reasonable lines across it,
> > but what I hope are the dates and times along the X axis are just a
> > mess and I've no idea how to make them display usefully.  
> 
> I guess you have used a line chart. That x-axis cannot display time 
> units, the smallest unit is day.
> A line chart shows an axis label for each data item. That is likely
> not suitable for your chart.

Correct, I'm using a line chart (i.e. the data I have are a number of
time series). Thanks for the info about how it behaves.

> You should try using an XY-chart.

Thanks. Yes, that seems to work better. It's a lot faster as well :)

> In case you need different positions inside one day, you should make
> a separate column with added date and time values. Then use this
> column for your x-axis.

Yes, I'd created the column and will use it.

> > The Y-axis is reasonable from 0 to 120, although it would be nice to
> > trim the blank space at the top a bit, since the data can't exceed
> > 100.
> > 
> > I haven't found any way to select individual points on the chart to
> > display the detailed value of that point or all the values at that
> > time.  
> 
> Access to single points is only available in edit mode of the chart.
> The information of the point is shown as tooltip.

I don't see any tooltips?

> You can display the value of data points as data label. Enable it in 
> edit mode in menu Insert > Data Label, or for a distinct point in its 
> context menu "Insert Single Data Label".
> 
> In case you use an XY-chart you can generate a text column for labels 
> Such are called 'category' in the dialogs. But there is only one text 
> per row possible.
> 
>   Nor do I see a way to temporarily hide individual data lines to
> > more clearly see other particular lines, for example.  
> 
> You can hide the associated column, then the line is removed from the 
> chart. When you show the column, the line is drawn again.

OK, thanks. That works but is a bit laborious.

> > If there's any way to do these things with an LO chart, and to
> > speed it up, I'd be grateful for any pointers. Or if there are
> > better options out there that can read .ods or .csv and display
> > charts, that would also be interesting.  
> 
> It seems you want to explore your data. Some people have pointed to
> the R-project. But I have never used it. Or you might find suitable
> tools with search term 'data mining'.

Thanks, I'll have a look. I might import the data into my emoncms
system.

> 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] what's the best way to make charts of spreadsheet data

[Dave Howorth]

On Wed, 2 Jan 2019 21:31:02 +0100
Luuk  wrote:

> On 2-1-2019 18:12, Dave Howorth wrote:
> > The Y-axis is reasonable from 0 to 120, although it would be nice to
> > trim the blank space at the top a bit, since the data can't exceed
> > 100.  
> 
> Right click on the Y-Axis, and choose 'Format Axis'
> 
> A popup will be schown where you can set Minimum- and Maximum value
> for the Axis (and more)

Thanks for that. It works well. Sadly the same operation apparently
does nothing to improve the X-axis legibility, which is a much worse
problem.

-- 
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 the best way to make charts of spreadsheet data

[Dave Howorth]

I just made a chart of some data in LibreOffice Calc and was
disappointed both by the process (very slow) and by the results
(apparent lack of ability to modify the view).

I've used spreadsheets and LO Calc specifically sporadically over the
years to make calculations but wouldn't call myself an expert. I can't
remember the last time I tried to make a chart.

So I'm wondering if I've missed something in LO that would help me have
a better experience with this chart, or if there are better tools to
use to draw charts from spreadsheet data.

I'm running Version 6.1.3.2 of LibreOffice (actually the openSUSE
build for Leap 15.0). I'm running a machine with an i5-4460 CPU @
3.20GHz and 8 GB main memory. It's normally fast enough for whatever I
want to do.

My spreadsheet data is in columns. Column A is the dates and column B
is the times. Then ten columns of humidity data and eleven columns of
temperature data. There are currently just over 5000 rows of samples.

Making the chart was extremely slow. Every time I changed the Name of a
line of the chart I had to wait whilst it cycled through several steps
to make the change. Initially when I removed some empty columns from
the data range, it took an age to do so. etc.

Now I've created the chart and got some reasonable lines across it, but
what I hope are the dates and times along the X axis are just a mess and
I've no idea how to make them display usefully.

The Y-axis is reasonable from 0 to 120, although it would be nice to
trim the blank space at the top a bit, since the data can't exceed 100.

I haven't found any way to select individual points on the chart to
display the detailed value of that point or all the values at that
time. Nor do I see a way to temporarily hide individual data lines to
more clearly see other particular lines, for example.

If there's any way to do these things with an LO chart, and to speed it
up, I'd be grateful for any pointers. Or if there are better options
out there that can read .ods or .csv and display charts, that would also
be interesting.

TIA, 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] Lost all my spread sheets

[Dave Howorth]

On Thu, 20 Dec 2018 19:51:39 +
Tholan Haynes  wrote:

> Sent from Mail for
> Windows 10
> 
> 

and your question is?

-- 
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] Re: Adding keyboard shortcut

[Dave Howorth]

On Sun, 9 Dec 2018 01:19:15 +
Tom Davies  wrote:

> Hi :)
> The crucial part is at the end of Stuart's email.  Apparently you can
> modify the action of "backspace" by following his advice.
> Regards from
> a Tom :)

Rich doesn't want to modify Backspace; he doesn't want to do anything
with backspace.

He doesn't want to modify Delete either; he simply wants to assign an
additional key to have the same action (i.e. Delete, *not* Backspace)

> On Fri, 7 Dec 2018 00:19 Rich Shepard, 
> wrote:
> 
> > On Thu, 6 Dec 2018, V Stuart Foote wrote:
> >  
> > > The *delete* you want is assigned in LibreOffice via the
> > > "Backspace" function, aka a *rubout*.  
> >
> >Not quite. The backspace key deletes the character to the left
> > of the cursor's position while the Del key deletes the character to
> > the right of the cursor's position. I want to make ctrl-d function
> > like the Del key.
> >
> > Thanks,
> >
> > Rich
> >
> > --
> > 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] libsdlo.so - SliTaz GNU/Linux - avahi

[Dave Howorth]

On Thu, 11 Oct 2018 21:54:27 +0200
Cédric Radosavljevic  wrote:

> Hello,
> 
> My OS is SliTaz GNU/Linux (rolling - 32 bits) and my laptop is an old
> Asus Eee PC 900.
> 
> I installed LibreOffice 6.1 (Package manager ==> get-LibreOffice ==>
> Terminal ==> get-LibreOffice).
> 
> Installation OK (after 40 min).
> 
> No problems with LibreOffice Writer, Calc, Math, Base.
> 
> But 2 problems:
> 
> 1/
> LibreOffice Impress doesn't start (and no error message).
> 
> 2/
> Error message for LibreOffice Draw:
 
> Here I found an explication for this problem:
> https://bugs.documentfoundation.org/show_bug.cgi?id=119408
> 
> There is a dependency to 'avahi' on recent LibreOffice versions but no
> package 'avahi' available on SliTaz.
> 
> Anyone a solution?

I hate things like that! :( Adding your support for option 1 or option 2
on the bug seems like a good idea.

-- 
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] Summing currency fields in base

[Dave Howorth]

On Thu, 11 Oct 2018 13:52:15 -0500
Wade Smart  wrote:

> If A1 is fee1
> fee2 is B1
> then in
> c1 you type
> =A1+B1

You do realize the question is about base, not calc?

-- 
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] can't prevent Calc from modifying the number I type into a column

[Dave Howorth]

On Wed, 12 Sep 2018 02:44:26 -0400
Art  wrote:
> It seems that the software is ignoring zeros to the right of the
> decimal point. I'm listing frequencies in Megahertz, so the zeros to
> the right of the decimal point are significant. I wish I could post
> my spreadsheet somewhere, I do know better than to send it to the
> list members::>

As far as I can tell the problem is fairly fundamental. LibreOffice
uses a definition of 'significant figure' that is different to that
usually used in the scientific world. Specifically, they don't regard a
0 after a decimal point as significant :(

See https://help.libreoffice.org/Common/Number_Format_Codes

I'd suggest you have two easy options:
(1) use a 0.000 format and search using the formatted display option
(2) Display the frequencies in kHz so they are all whole numbers

Note that you could display the numbers twice in two columns. Once in a
column that's easy for you to read, and again in a column that's
formatted to be searched. The search column could be hidden.

PS I was going to suggest:
(3) Use scientific format to specify the significant digits
(e.g. ##0.000E+00)

but apparently you can't search 127.700E+00 for 127.7 :(

-- 
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] Prompt On Replace

[Dave Howorth]

On Sat, 08 Sep 2018 10:15:13 +0100
Ianseeks  wrote:

> On Saturday, 8 September 2018 01:14:35 BST Remy Gauthier wrote:
> > Hello,
> > 
> > I am not sure I understand your question. However, when you open the
> > Find and Replace panel, there are a "Find Next", "Find Previous" and
> > "Replace" buttons that enable you to locate the next instance of the
> > string to replace (or the previous); if you hit "Replace" at that
> > point, the replace operation will be performed and you will be
> > taken to the next instance of the string to replace. At that point,
> > the operation will pause, waiting for your input.
> > 
> > I hope this helps.
> > 
> > Rémy.  
> 
> He wants LO to prompt the user to Replace/Ignore for every occurrence
> of a find rather replace everything without a choice.

That's what Remy just described, and what LO offers.

> > Le vendredi 07 septembre 2018 à 10:02 -0700, arakish a écrit :  
> > > In the "Find and Replace" dialogue box, why is there no option
> > > for "Prompt On Replace" as there is in all other word processor
> > > programs?

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