Re: [libreoffice-users] Help with conditional formatting (Calc)

[Paul Goyette]

On Sat, 25 May 2024, Rob Jasper wrote:


Paul,

Yes, you should use a formula as condition.
To use a formula as condition:

Go to Format -> Conditional -> condition -> More rules -> formula:

$C$3=$Sheet1.$A$14
And use A5:J10 as range (if you select the range before defining the 
conditional formatting LO sets it automatically).

Succes


I could've sworn that I had tried that, but I guess not.

It works - thanks!




Op 25 mei 2024, om 14:20 heeft Paul Goyette  het volgende 
geschreven:

I've read the docs, and tried several ways, but I cannot seem to
get it right.

I'd like to apply conditional formatting to a group of cells, based
on the value of one cell in the group.  Something like

In cell range a5:j10, if the row-N column-C entry is equal
to "sheet.$row$column", apply format to the entire range
a-N:j-N

Is this possible?


+-+--+--+
| Paul Goyette (.sig) | PGP Key fingerprint: | E-mail addresses:|
| (Retired)   | 1B11 1849 721C 56C8 F63A | p...@whooppee.com|
| Software Developer  | 6E2E 05FD 15CE 9F2D 5102 | pgoye...@netbsd.org  |
| & Network Engineer  |  | pgoyett...@gmail.com |
+-+--+--+

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




!DSPAM:6651f84817981359412487!




+-+--+--+
| Paul Goyette (.sig) | PGP Key fingerprint: | E-mail addresses:|
| (Retired)   | 1B11 1849 721C 56C8 F63A | p...@whooppee.com|
| Software Developer  | 6E2E 05FD 15CE 9F2D 5102 | pgoye...@netbsd.org  |
| & Network Engineer  |  | pgoyett...@gmail.com |
+-+--+--+

--
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 with conditional formatting (Calc)

[Rob Jasper]

Paul,

Yes, you should use a formula as condition. 
To use a formula as condition:

Go to Format -> Conditional -> condition -> More rules -> formula:

$C$3=$Sheet1.$A$14
And use A5:J10 as range (if you select the range before defining the 
conditional formatting LO sets it automatically).

Succes

> Op 25 mei 2024, om 14:20 heeft Paul Goyette  het volgende 
> geschreven:
> 
> I've read the docs, and tried several ways, but I cannot seem to
> get it right.
> 
> I'd like to apply conditional formatting to a group of cells, based
> on the value of one cell in the group.  Something like
> 
>   In cell range a5:j10, if the row-N column-C entry is equal
>   to "sheet.$row$column", apply format to the entire range
>   a-N:j-N
> 
> Is this possible?
>  
> 
> +-+--+--+
> | Paul Goyette (.sig) | PGP Key fingerprint: | E-mail addresses:|
> | (Retired)   | 1B11 1849 721C 56C8 F63A | p...@whooppee.com|
> | Software Developer  | 6E2E 05FD 15CE 9F2D 5102 | pgoye...@netbsd.org  |
> | & Network Engineer  |  | pgoyett...@gmail.com |
> +-+--+--+
> 
> -- 
> 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] 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] Help for Libreoffice portable

[ady]

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


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] Help - how to get rid of 'administrator'

[Alan B]

Emily,

The following presumes you use Windows.

This is a test to attempt to isolate the problem...
* Use a thumb drive (USB drive) ,
* create and save a file to the thumb drive (use Write, Calc, or whichever
program you use most)
* close the program used to create the file
* eject the thumb drive
* right click the drive and pick the "Eject" option
* wait for the safe to remove message (this must be done to prevent
file corruption)
* remove the drive
* open the program again
* insert the thumb drive
* open the file and test if you can edit and save or not

If it is possible to edit and save the file on the thumb drive then the
problem is most likely the security settings for the location the files are
being saved to on the computer.

BUT even if files on the thumb drive can be edited and saved with
LibreOffice while those on the computer cannot be, there is still another
bit of info that's needed. Using other programs is it possible to
create/edit/save files to the same place on the computer as the LibreOffice
files?

If other files also can not be created/edited/saved to the same place with
other programs (the same problem as with LibreOffice) then the culprit is
nearly certainly the computer's security settings for that location.

If only the LibreOffice files can not be created/edited/saved then more
investigation into the files and LibreOffice installation will be needed.

If you try the above, please provide an update so we know if it is only
LibreOffice doing this (so likely an LO problem to work out) or other
programs do it too (so likely a computer security problem).

Knowing the above will help with troubleshooting and resolving the problem.

On Wed, Mar 6, 2024 at 5:00 PM Emily Scharf 
wrote:

> I have used Libreoffice for years. But recently I downloaded it and -
> mistakenly - responded to an option for greater security.  This turns out
> to be 'administrator' which continually blocks me from anything but
> read-only documents.
>
> How do I turn off the 'administrator'?  I even tried to uninstall and
> download again and it is still happening with my documents..
>
> If I cannot stop the 'administrator' I will be forced to use another
> programme (though I have used LibreOffice for years)
>
> Thank you for your help.
>
> Emily from London
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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 - how to get rid of 'administrator'

[John]

FYI, on Fedora Linux using Libre Office 7.5.9.2 there is a "Restart in Safe 
Mode" function on the
"help" pop down menu.  About halfway down the menu.  If you clicked this is may 
have a "leave safe
mode" or equivalent in the same place because I don't have the "Start in Test 
Mode" function on this
menu.

Hope that may be of some asistance.

John
==
On Wed, 2024-03-06 at 23:40 +0100, aguador wrote:
> 
> 
> El mié, 06-03-2024 a las 23:16 +0100, Philip Jackson escribió:
> > Are you sure this isn't a Windows' problem? Typically it's Windows
> > that has stuff blocked and restricted to those with administrator
> > privileges.
> > Philip
> > 
> > On 06/03/2024 22:56, Emily Scharf wrote:
> > > I have used Libreoffice for years. But recently I downloaded it and
> > > -
> > > mistakenly - responded to an option for greater security.  This
> > > turns out
> > > to be 'administrator' which continually blocks me from anything but
> > > read-only documents.
> > > 
> > > How do I turn off the 'administrator'?  I even tried to uninstall
> > > and
> > > download again and it is still happening with my documents..
> > > 
> > > If I cannot stop the 'administrator' I will be forced to use
> > > another
> > > programme (though I have used LibreOffice for years)
> > > 
> > > Thank you for your help.
> > > 
> > > Emily from London
> 
> Hi Emily,
> 
> I am not on LO 24 yet, but I suspect there is a way to do it from with
> the program. Lacking that knowledge, the first thing that occurs to me
> is to try with a new profile. Your profile remains even you re-install
> or update and that is where your settings are saved.
> 
> You can test this by going to Help and choosing Start in Test Mode.
> That will ignore your profile and, if it works, you can find your
> LibreOffice profile folder and rename it. When you restart you will
> have to redo your settings, although you can very likely copy most of
> the components from your old folder.
> 
> Wish I could be more specific, but without knowing the OS or the latest
> LO you're using, its a bit harder.
> 
> Hope this helps a bit,
> Roy
> 


-- 
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 - how to get rid of 'administrator'

[aguador]

El mié, 06-03-2024 a las 23:16 +0100, Philip Jackson escribió:
> Are you sure this isn't a Windows' problem? Typically it's Windows
> that has stuff blocked and restricted to those with administrator
> privileges.
> Philip
> 
> On 06/03/2024 22:56, Emily Scharf wrote:
> > I have used Libreoffice for years. But recently I downloaded it and
> > -
> > mistakenly - responded to an option for greater security.  This
> > turns out
> > to be 'administrator' which continually blocks me from anything but
> > read-only documents.
> > 
> > How do I turn off the 'administrator'?  I even tried to uninstall
> > and
> > download again and it is still happening with my documents..
> > 
> > If I cannot stop the 'administrator' I will be forced to use
> > another
> > programme (though I have used LibreOffice for years)
> > 
> > Thank you for your help.
> > 
> > Emily from London

Hi Emily,

I am not on LO 24 yet, but I suspect there is a way to do it from with
the program. Lacking that knowledge, the first thing that occurs to me
is to try with a new profile. Your profile remains even you re-install
or update and that is where your settings are saved.

You can test this by going to Help and choosing Start in Test Mode.
That will ignore your profile and, if it works, you can find your
LibreOffice profile folder and rename it. When you restart you will
have to redo your settings, although you can very likely copy most of
the components from your old folder.

Wish I could be more specific, but without knowing the OS or the latest
LO you're using, its a bit harder.

Hope this helps a bit,
Roy

-- 
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 - how to get rid of 'administrator'

[Philip Jackson]

Are you sure this isn't a Windows' problem? Typically it's Windows that has 
stuff blocked and restricted to those with administrator privileges.
Philip

On 06/03/2024 22:56, Emily Scharf wrote:

I have used Libreoffice for years. But recently I downloaded it and -
mistakenly - responded to an option for greater security.  This turns out
to be 'administrator' which continually blocks me from anything but
read-only documents.

How do I turn off the 'administrator'?  I even tried to uninstall and
download again and it is still happening with my documents..

If I cannot stop the 'administrator' I will be forced to use another
programme (though I have used LibreOffice for years)

Thank you for your help.

Emily from London

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

[Madhu Patel]

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: 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-";
> >
> > 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?

Aguador, can you please link me the API documentation to convert 5 pages of PDF 
to PNG, one by one, or together in one go.

Given 5 pages of PDF, LibreOffice API converts only first page to PNG. 
LibreOffice API, do not have any Page Exacter or indexer where [i]th page of 
one file containing 5 pages of PDF can be extracted.




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

Re: [libreoffice-users] Help: Convert a Multi-Page Text/word file to PNG using LibreOffice API in JAVA

[Madhu Patel]

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-";
> >
> > 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?

Aguador, can you please link me the API documentation to convert 5 pages of PDF 
to PNG, one by one, or together in one go.

Given 5 pages of PDF, LibreOffice API converts only first page to PNG. 
LibreOffice API, do not have any Page Exacter or indexer where [i]th page of 
one file containing 5 pages of PDF can be extracted.


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

Dave, Aguador: CC’ing the person who responded with a textual workaround which 
seems to be inefficient and is non documented in LibreOffice API for further 
explanation or a link to API endpoint.

Dave: Can you please link me to LibreOffice API documentation to convert a 
multi-page text file to single page or multi-page PNG. If it’s not possible, do 
you think there should be proper documentation for the same.

Devs, maintainers: One workaround to convert a multi-page text file to PNG is 
to extract each page text and store into buffer streams (JAVA programming 
language concept) and then write that text as PNG. For a huge file, or a 
on-the-fly stream of files, say, 10KB to 100KB, this process, would be highly 
inefficient, if not done by LibreOffice API using machines Syste

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

[Madhu Patel]

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



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.libreoffice.org%2Fget-help%2Fmailing-lists%2Fhow-to-unsubscribe%2F=05%7C01%7Cmadhup%40adobe.com%7C6c3c47f211c04cc0f2a308dbbe71bebe%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638313167966025522%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=AnsTWngAlUyYeK%2BhKCz3WtwY96oL2%2BcCi%2FqxwJINSEA%3D=0<https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.documentfoundation.org%2FNetiquette=05%7C01%7Cmadhup%40adobe.com%7C6c3c47f211c04cc0f2a308dbbe71bebe%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638313167966025522%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=lNVKvaXVE%2FozM0xzPnAxB9DD8%2BccfQcrsFKbOhHGmfw%3D=0<https://wiki.documentfoundation.org/Netiquette>
List archive: 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flistarchives.libreoffice.org%2Fglobal%2Fusers%2F=05%7C01%7Cmadhup%40adobe.com%7C6c3c47f211c04cc0f2a308dbbe71bebe%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638313167966025522%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=a9bt9MndrW8AutLAGveoh34t4i2W9LIp25t0hKhlLco%3D=0<https://listarchives.libreoffice.org/global/users/>
Privacy Policy: 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.documentfoundation.org%2Fprivacy=05%7C01%7Cmadhup%40adobe.com%7C6c3c47f211c04cc0f2a308dbbe71bebe%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638313167966025522%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=oPNevqpp%2BLTismqTC0QP0kNTdtc8xXkfA1PnYBWSRW8%3D=0<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] Help: Convert a Multi-Page Text/word file to PNG using LibreOffice API in JAVA

[aguador]

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



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

[Brad Rogers]

On Fri, 7 Jul 2023 12:40:08 +0100
Dave Howorth  wrote:

Hello Dave,

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

Pages can be displayed separate sheets, side by side, or where each page
is displayed as if they were in an open book.  That is, evens on the
left, odds on the right of a landscape oriented piece of paper.

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

Good point - one others, myself included, neglected to mention.

-- 
 Regards  _   "Valid sig separator is {dash}{dash}{space}"
 / )  "The blindingly obvious is never immediately apparent"
/ _)rad   "Is it only me that has a working delete key?"
Every single one of us
Devil Inside - INXS

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

[Budge]

Hi Regina,
You have it exactly.  Now I have what I want so very many thanks.

Thanks also to all who helped.
All good for now thanks.
Budge.

On 06/07/2023 21:20, Regina Henschel wrote:

Hi Budge,

Budge schrieb am 06.07.2023 um 17:15:

I have downloaded a document from the VistitBritain/VisitEngland website which 
is in which is in a Windows 2007 .docx format.
When I open the document it LibreOffice Writer it opens to show 7 pages all at 
once and showing in the same window.

How may I break this down into individual pages within the document please so I 
may work on each page and then page down?


You can decide, whether to show bottom/top margins and a little distance between 
the pager or to show a continues text without bottom/top margins. That setting is 
in menu View > item Whitespace.

Further have a look at the right side of the status bar. There are the icons "Single page view", 
"Multi-page view" and "Book view". They determine how the pages are arranged in the 
working area.

When you click on the percent value of the zoom field in the status bar a dialog opens. 
There you can select between often used presets, e.g. "Fit width and height".

In all cases you come to the next page by scrolling of you use the PgUp and 
PgDn keys. If you want to jump to a specific page you can enter the page number 
in the Navigator in the side bar or use the shortcut Strg+G and enter the 
target page name there.

The text is a continues text and page breaks are calculated dynamically. 
Microsoft Word works the same way. That makes office suites different from 
desktop publishing applications.



Hope somebody can help me with this as I have never seen this format before!


I hope when you play around with the settings you can solve your problem. If 
not, please make a screenshot available. You cannot attach it to the mail. 
Attachments are automatically removed for this mailing list.

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

[Alan B]

With the link, thank you, I see that opening the document always shows me a
full screen view with thumbnails of all seven pages. If that is what you
mean by "it opens to show 7 pages all at once and showing in the same
window" then...

Use the "View > Zoom" menu and select a page view that works for you.

On Thu, Jul 6, 2023 at 11:15 AM Budge  wrote:

> I have downloaded a document from the VistitBritain/VisitEngland website
> which is in which is in a Windows 2007 .docx format.
> When I open the document it LibreOffice Writer it opens to show 7 pages
> all at once and showing in the same window.
>
> How may I break this down into individual pages within the document please
> so I may work on each page and then page down?
>
> Hope somebody can help me with this as I have never seen this format
> before!
> Budge
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

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

[Regina Henschel]

Hi Budge,

Budge schrieb am 06.07.2023 um 17:15:
I have downloaded a document from the VistitBritain/VisitEngland website 
which is in which is in a Windows 2007 .docx format.
When I open the document it LibreOffice Writer it opens to show 7 pages 
all at once and showing in the same window.


How may I break this down into individual pages within the document 
please so I may work on each page and then page down?


You can decide, whether to show bottom/top margins and a little distance 
between the pager or to show a continues text without bottom/top 
margins. That setting is in menu View > item Whitespace.


Further have a look at the right side of the status bar. There are the 
icons "Single page view", "Multi-page view" and "Book view". They 
determine how the pages are arranged in the working area.


When you click on the percent value of the zoom field in the status bar 
a dialog opens. There you can select between often used presets, e.g. 
"Fit width and height".


In all cases you come to the next page by scrolling of you use the PgUp 
and PgDn keys. If you want to jump to a specific page you can enter the 
page number in the Navigator in the side bar or use the shortcut Strg+G 
and enter the target page name there.


The text is a continues text and page breaks are calculated dynamically. 
Microsoft Word works the same way. That makes office suites different 
from desktop publishing applications.




Hope somebody can help me with this as I have never seen this format 
before!


I hope when you play around with the settings you can solve your 
problem. If not, please make a screenshot available. You cannot attach 
it to the mail. Attachments are automatically removed for this mailing list.


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

[Brad Rogers]

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

-- 
 Regards  _   "Valid sig separator is {dash}{dash}{space}"
 / )  "The blindingly obvious is never immediately apparent"
/ _)rad   "Is it only me that has a working delete key?"
I can't do a thing 'cause I can't relax
Independence Day - Comsat Angels

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

[Alan B]

Which website? There are visitbritain . com and . org

And what file name or document title?

With the above info, others can attempt to open it and solve the problem.

I've tried opening several .docx downloaded from the . org site. All opened
with no issue in LO 6.4.x


On Thu, Jul 6, 2023 at 11:15 AM Budge  wrote:

> I have downloaded a document from the VistitBritain/VisitEngland website
> which is in which is in a Windows 2007 .docx format.
> When I open the document it LibreOffice Writer it opens to show 7 pages
> all at once and showing in the same window.
>
> How may I break this down into individual pages within the document please
> so I may work on each page and then page down?
>
> Hope somebody can help me with this as I have never seen this format
> before!
> Budge
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

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

[John Kaufmann]

On 2023-07-06 15:39, Budge wrote:

I see the screenshot didn't copy.  Is this a settings thing here or rule for 
the site?


The list works in plain text, not HTML, and does not take attachments. If you 
want to show a screenshot, best to use a sharing service like Dropbox and cite 
the URL.

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

[Budge]

I see the screenshot didn't copy.  Is this a settings thing here or rule for 
the site?

On 06/07/2023 20:37, Budge wrote:

Hi all,
Sorry I was distracted earlier.
Here is the link:-

https://www.visitbritain.org/sites/default/files/vb-corporate/business-hub/resources/visitengland_fire_risk_assessment_template_for_tourism_businesses_march2023.docx

opened it in another machine and it opened slightly differently in that the 
pages are in a column.  See screenshot:-



Hope this does the same for you or I am stuck on how to solve it.

On 06/07/2023 20:25, Dave Howorth wrote:

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

Re: [libreoffice-users] Help please with multipage document.

[Budge]

Hi all,
Sorry I was distracted earlier.
Here is the link:-

https://www.visitbritain.org/sites/default/files/vb-corporate/business-hub/resources/visitengland_fire_risk_assessment_template_for_tourism_businesses_march2023.docx

opened it in another machine and it opened slightly differently in that the 
pages are in a column.  See screenshot:-



Hope this does the same for you or I am stuck on how to solve it.

On 06/07/2023 20:25, Dave Howorth wrote:

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

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

Re: [libreoffice-users] Help please with multipage document.

[Steve Edmonds]

Brad is doing better than me, may be include the link to be sure we are 
on the same page, so to speak.

steve

On 7/07/23 03:15, Budge wrote:
I have downloaded a document from the VistitBritain/VisitEngland 
website which is in which is in a Windows 2007 .docx format.
When I open the document it LibreOffice Writer it opens to show 7 
pages all at once and showing in the same window.


How may I break this down into individual pages within the document 
please so I may work on each page and then page down?


Hope somebody can help me with this as I have never seen this format 
before!

Budge




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

[Brad Rogers]

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.

-- 
 Regards  _   "Valid sig separator is {dash}{dash}{space}"
 / )  "The blindingly obvious is never immediately apparent"
/ _)rad   "Is it only me that has a working delete key?"
The deadbeats and the dispossessed, the seekers of unlikeliness
Street Of Dreams - The Damned

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

[Thomas Cameron]

On 6/6/23 2:50 AM, 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.

Thank you,
Angeline

Sent from my iPhone


I don't know if it helps, but usually, when I choose File/Open, in LO, 
it opens the last place I saved. Also, if you go to File/Recent 
Documents, do you see your doc there?


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

[James Knott]

On 2023-06-06 11:26, Tom wrote:
This is a long shot but maybe use your operating system's file 
manager/explorer and sort various folders where you save documents 
(Desktop, Documents, etc) by date and see if you can locate the file 
that way?


On Linux, you could probably use the find command.


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

[Tom]

This is a long shot but maybe use your operating system's file 
manager/explorer and sort various folders where you save documents 
(Desktop, Documents, etc) by date and see if you can locate the file 
that way?


Peace...

Tom

On 6/6/23 2:50 AM, 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.

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] Help with Impress

[Harald Berger]

Hi Greg,

Am 18.11.2022 um 16:19 schrieb Gregory Forster:

Hi Herald,

I checked your references, but I did not see any profile.

What I did with both computers, I totally deleted LibreOffice, 
deleted  all references to LibreOffice including the entire folders 
C:\Program Files\LibreOffice, 
C:\Users\Greg\AppData\Roaming\LibreOffice. I  then  ran CCleaner, 
including running  the registry cleaner, I then ran Privazer, then 
rebooted.


I then did a clean, new download of LibreOffice, the Help file and 
documentations in pdf format. I had to re-enter all my preferences. I 
have java on my laptop, but not on the desktop. I was  able to 
download java a few weeks ago. The java web site now would not let me 
download java on either computer using Windows Edge, or Firefox. I 
kept getting a 503 error.  Do  I really need java, other than the 
database?

https://wiki.documentfoundation.org/Faq/General/015

Best Regards
Harald


I don't know if Impress will work yet, I haven't tried it yet. I 
completed the original presentation project, despite it's continual 
crashing. I have to figure out a new project to try.


Thank you for responding.

Greg

On 11/11/2022 2:40 PM, lo.harald.ber...@t-online.de wrote:

Hi Gregory,

it's a pity that it doesn't work properly for you.

Please have a look at the points in the following link:
https://wiki.documentfoundation.org/QA/FirstSteps

Test steps 3 and 2 from there, in that order, to see if it brings 
improvement.


If this is not helpful, I would ask you to upload your Impress file 
somewhere in the cloud and post the link here.


So that someone can look at the file, test and investigate whether 
there are also problems. Thank you.


Best Regards
Harald

Am 11.11.2022 um 18:34 schrieb Gregory Forster:

Hi

    Recently, I volunteered to teach computer classes at a senior 
center.  I'm teaching Excel, Word, Power Point, etc. I'm trying to 
promote LibreOffice.  I use LibreOffice at home. However, I am 
having an extremely difficult time with LibreOffice Impress. After 
saving after every new slide, LibreOffice crashes on me.   I send 
the crash report, restore the program, then I have to reposition the 
last slide (What was slide 13, is now slide 12). My presentation is 
only 15 slides. In other words, LibreOffice crashed 15 times!


    I am using LibreOffice vs 7.4.2.3 on a Windows 10 vs 10.0.19044 
laptop.


    I want to do a presentation on LibreOffice using Impress, but 
not with that nonsense.









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

[LO . Harald . Berger]

Hi Greg,

Am 18.11.2022 um 16:19 schrieb Gregory Forster:

Hi Herald,

I checked your references, but I did not see any profile.

What I did with both computers, I totally deleted LibreOffice, 
deleted  all references to LibreOffice including the entire folders 
C:\Program Files\LibreOffice, 
C:\Users\Greg\AppData\Roaming\LibreOffice. I  then  ran CCleaner, 
including running  the registry cleaner, I then ran Privazer, then 
rebooted.


I then did a clean, new download of LibreOffice, the Help file and 
documentations in pdf format. I had to re-enter all my preferences. I 
have java on my laptop, but not on the desktop. I was  able to 
download java a few weeks ago. The java web site now would not let me 
download java on either computer using Windows Edge, or Firefox. I 
kept getting a 503 error.  Do  I really need java, other than the 
database?

https://wiki.documentfoundation.org/Faq/General/015

Best Regards
Harald


I don't know if Impress will work yet, I haven't tried it yet. I 
completed the original presentation project, despite it's continual 
crashing. I have to figure out a new project to try.


Thank you for responding.

Greg

On 11/11/2022 2:40 PM, lo.harald.ber...@t-online.de wrote:

Hi Gregory,

it's a pity that it doesn't work properly for you.

Please have a look at the points in the following link:
https://wiki.documentfoundation.org/QA/FirstSteps

Test steps 3 and 2 from there, in that order, to see if it brings 
improvement.


If this is not helpful, I would ask you to upload your Impress file 
somewhere in the cloud and post the link here.


So that someone can look at the file, test and investigate whether 
there are also problems. Thank you.


Best Regards
Harald

Am 11.11.2022 um 18:34 schrieb Gregory Forster:

Hi

    Recently, I volunteered to teach computer classes at a senior 
center.  I'm teaching Excel, Word, Power Point, etc. I'm trying to 
promote LibreOffice.  I use LibreOffice at home. However, I am 
having an extremely difficult time with LibreOffice Impress. After 
saving after every new slide, LibreOffice crashes on me.   I send 
the crash report, restore the program, then I have to reposition the 
last slide (What was slide 13, is now slide 12). My presentation is 
only 15 slides. In other words, LibreOffice crashed 15 times!


    I am using LibreOffice vs 7.4.2.3 on a Windows 10 vs 10.0.19044 
laptop.


    I want to do a presentation on LibreOffice using Impress, but 
not with that nonsense.










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

[Paul D. Mirowsky]

By any chance, did you start by importing a Power Point?

On 11/11/22 12:34, Gregory Forster wrote:

Hi

    Recently, I volunteered to teach computer classes at a senior 
center.  I'm teaching Excel, Word, Power Point, etc. I'm trying to 
promote LibreOffice.  I use LibreOffice at home.  However, I am having 
an extremely difficult time with LibreOffice Impress. After saving 
after every new slide, LibreOffice crashes on me.   I send the crash 
report, restore the program, then I have to reposition the last slide 
(What was slide 13, is now slide 12). My presentation is only 15 
slides.  In other words, LibreOffice crashed 15 times!


    I am using LibreOffice vs 7.4.2.3 on a Windows 10 vs 10.0.19044 
laptop.


    I want to do a presentation on LibreOffice using Impress, but not 
with that nonsense.




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

[Ade Malsasa Akbar]

Hello Gregory,

I teach LibreOffice class with many students and now they use Impress
7.4 too. All succeeded  doing presentations with 20-50 slides without
any crash. However, they all use GNU/Linux. So I can confirm at least
Impress 7.4 works normally on GNU/Linux.

Firstly, could you send your presentation file here? It might help
others to examine and reproduce the issues.

Secondly, as a suggestion, you might consider to try several different
versions of LibreOffice on Windows 10 and see which one works normally
for you and use the working one (I always do this). Experience told me
the latest version is not always the best.

Sincerely yours,

Ade Malsasa Akbar

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

[LO . Harald . Berger]

Hi Gregory,

it's a pity that it doesn't work properly for you.

Please have a look at the points in the following link:
https://wiki.documentfoundation.org/QA/FirstSteps

Test steps 3 and 2 from there, in that order, to see if it brings 
improvement.


If this is not helpful, I would ask you to upload your Impress file 
somewhere in the cloud and post the link here.


So that someone can look at the file, test and investigate whether there 
are also problems. Thank you.


Best Regards
Harald

Am 11.11.2022 um 18:34 schrieb Gregory Forster:

Hi

    Recently, I volunteered to teach computer classes at a senior 
center.  I'm teaching Excel, Word, Power Point, etc. I'm trying to 
promote LibreOffice.  I use LibreOffice at home.  However, I am having 
an extremely difficult time with LibreOffice Impress. After saving 
after every new slide, LibreOffice crashes on me.   I send the crash 
report, restore the program, then I have to reposition the last slide 
(What was slide 13, is now slide 12). My presentation is only 15 
slides.  In other words, LibreOffice crashed 15 times!


    I am using LibreOffice vs 7.4.2.3 on a Windows 10 vs 10.0.19044 
laptop.


    I want to do a presentation on LibreOffice using Impress, but not 
with that nonsense.






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

[Steve Edmonds]

What version of LO and what operating system do you have.

On 01/09/2022 03:14, Bids BR HVAC wrote:

Why is my LibreOffice Calc doing this?
The dropdown bars are all blacked out.
The number column is all janky. The numbers are stacked on top of each
other and gets worse when I scroll down.
When I open Calc there is a big section of the page that turns pink, but
not in any specific spot. It is totally random and goes away once I scroll.
I would take a screenshot to show what I mean, but I cannot read the
dropdowns to get me to that point due to them being blacked out.
WHAT AM I TO DO?




--
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 with find & replace. [SOLVED]

[Michael D. Setzer II]

On 17 Mar 2022 at 9:49, Dave Barton wrote:

Subject:Re: [libreoffice-users] Help with find & 
replace. [SOLVED]
To: users@global.libreoffice.org
From:   Dave Barton 
Date sent:  Thu, 17 Mar 2022 09:49:41 +

> On 16/03/2022 16:29, Dave Barton wrote:
> > I am looking for a find & replace solution in Writer, where there is a
> > blank space as the last character of a paragraph
> > (eg. last word ).
> 
> Thanks to all who replied.
> 

No problem. That is what support lists are suppose to do. 
Glad you got a solution.


> 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


++
 Michael D. Setzer II - Computer Science Instructor 
(Retired) 
 mailto:mi...@guam.net
 mailto:msetze...@gmail.com
 Guam - Where America's Day Begins
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
++




-- 
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 with find & replace. [SOLVED]

[Dave Barton]

On 16/03/2022 16:29, Dave Barton wrote:
> I am looking for a find & replace solution in Writer, where there is a
> blank space as the last character of a paragraph
> (eg. last word ).

Thanks to all who replied.

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] Help with find & replace.

[V Stuart Foote]

Dave, *

LibreOffice uses the ICU Regular Expression libraries. Full documentation is 
here:

https://unicode-org.github.io/icu/userguide/strings/regexp.html

While the projects documentation for its use is here:

https://help.libreoffice.org/7.3/en-US/text/shared/01/0211.html

https://help.libreoffice.org/latest/bs/text/swriter/guide/search_regexp.html

There have been a number of tweaks for handling new line/end of para that you 
can track in Bugzilla.

Stuart


From: Dave Barton 
Sent: Wednesday, March 16, 2022 5:21 PM
To: users@global.libreoffice.org 
Subject: [EXTERNAL] Re: [libreoffice-users] Help with find & replace.

  **EXTERNAL EMAIL**
  This email originated outside of The University of Texas at San Antonio.
  Please exercise caution when clicking on links or opening attachments.



Hi jomali,

Would you care to elaborate and provide links?

Dave

On 16/03/2022 22:04, jomali wrote:
> I just looked at LibreOffice help, searched for Regular Expressions,
> selected the list of regular expressions, and found all of the info you are
> looking for..
>
> On Wed, Mar 16, 2022 at 5:55 PM Dave Barton  wrote:
>
>>
>> Fantastic, but why does the LO project *_NOT_* inform it's users about
>> this *_HIDDEN_* option?
>>
>> Please provide links to the the TDF/LO Help/Documentation files that
>> provide this information to our 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] Help with find & replace.

[Dave Barton]

Hi jomali,

Would you care to elaborate and provide links?

Dave

On 16/03/2022 22:04, jomali wrote:
> I just looked at LibreOffice help, searched for Regular Expressions,
> selected the list of regular expressions, and found all of the info you are
> looking for..
> 
> On Wed, Mar 16, 2022 at 5:55 PM Dave Barton  wrote:
> 
>>
>> Fantastic, but why does the LO project *_NOT_* inform it's users about
>> this *_HIDDEN_* option?
>>
>> Please provide links to the the TDF/LO Help/Documentation files that
>> provide this information to our users.
>>
>>  Original Message 
>> From: Michael D. Setzer II [mailto:msetze...@gmail.com]
>> Sent: Wednesday, March 16, 2022, 20:53 UTC
>> To: Dave Barton; users@global.libreoffice.org
>> Subject: [libreoffice-users] Help with find & replace.
>>
>>> On 16 Mar 2022 at 20:41, Dave Barton wrote:
>>>
>>> Subject:  Re: [libreoffice-users] Help with find &
>>> replace.
>>> To:   users@global.libreoffice.org
>>> From: Dave Barton 
>>> Date sent:Wed, 16 Mar 2022 20:41:43 +
>>>
>>>> On 16/03/2022 20:01, Steve Edmonds wrote:
>>>>>
>>>>>
>>>>> On 17/03/2022 08:34, Dave Barton wrote:
>>>>>> On 16/03/2022 18:27, Brian Barker wrote:
>>>>>>> At 16:29 16/03/2022 +, Dave Barton wrote:
>>>>>>>> I am looking for a find & replace solution in Writer, where there
>> is a
>>>>>>>> blank space as the last character of a paragraph (eg. last word
>>>>>>>> ). In the original OOo and most of the text editors I
>>>>>>>> use the simple solution that worked/works perfectly is: Find =
>>>>>>>> $ Replace = $ (Note: I use  here to represent a single
>>>>>>>> space character). This does not work in LO Writer, so I am forced to
>>>>>>>> fiddle around copying from LO and pasting into AOO, running F in
>>>>>>>> AOO, then copy/paste back again. Any pointers would be welcome.
>>>>>>> I'm surprised that exactly what you say works in OpenOffice. Don't
>> you
>>>>>>> need to find space-dollar, just as you describe, but to replace with
>>>>>>> nothing? Replacing with dollar will surely insert an unwanted dollar
>>>>>>> character?
>>>>>>>
>>>>>>> Or have you forgotten to click "Other options" in the Find and
>> Replace
>>>>>>> dialogue and to tick "Regular expressions"?
>>>>>>>
>>>>>>> I trust this helps.
>>>>>>>
>>>>>>> Brian Barker
>>>>>> Hi Brian,
>>>>>>
>>>>>> After 22 Years of you and I being involved in this project, I
>> genuinely
>>>>>> bow to your superior knowledge in this area. However, I do assure you
>>>>>> that the convoluted LO->AOO->LO� nonsense works for me, exactly as it
>>>>>> did in the days of OOo.
>>>>>>
>>>>>> No, I have not forgotten to click "Other options in the Find and
>> Replace
>>>>>> dialogue and to tick "Regular expressions", please see my screen
>> capture:
>>>>>> https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
>>>>>>
>>>>>> Here is a very simplistic file illustrating the 
>>>>>> paragraph endings:
>>>>>> https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
>>>>>>
>>>>>> Version: 7.3.1.3 (x64) / LibreOffice Community
>>>>>> Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
>>>>>> CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL:
>>>>>> win
>>>>>> Locale: es-ES (en_IE); UI: en-US
>>>>>> Calc: threaded
>>>>>>
>>>>>> If you can please show me where I am going wrong, I would be extremely
>>>>>> grateful.
>>>>>>
>>>>>> Dave Barton
>>>>>>
>>>>>>
>>>>> May be this is sorted and I have received the emails out of order, but
>>>>> assuming you just want to remove the trailing space from each line,
>> both
>>>>> Johnny's and Michael's methods work for me on y

Re: [libreoffice-users] Help with find & replace.

[jomali]

I just looked at LibreOffice help, searched for Regular Expressions,
selected the list of regular expressions, and found all of the info you are
looking for..

On Wed, Mar 16, 2022 at 5:55 PM Dave Barton  wrote:

>
> Fantastic, but why does the LO project *_NOT_* inform it's users about
> this *_HIDDEN_* option?
>
> Please provide links to the the TDF/LO Help/Documentation files that
> provide this information to our users.
>
>  Original Message 
> From: Michael D. Setzer II [mailto:msetze...@gmail.com]
> Sent: Wednesday, March 16, 2022, 20:53 UTC
> To: Dave Barton; users@global.libreoffice.org
> Subject: [libreoffice-users] Help with find & replace.
>
> > On 16 Mar 2022 at 20:41, Dave Barton wrote:
> >
> > Subject:  Re: [libreoffice-users] Help with find &
> > replace.
> > To:   users@global.libreoffice.org
> > From: Dave Barton 
> > Date sent:Wed, 16 Mar 2022 20:41:43 +
> >
> >> On 16/03/2022 20:01, Steve Edmonds wrote:
> >>>
> >>>
> >>> On 17/03/2022 08:34, Dave Barton wrote:
> >>>> On 16/03/2022 18:27, Brian Barker wrote:
> >>>>> At 16:29 16/03/2022 +, Dave Barton wrote:
> >>>>>> I am looking for a find & replace solution in Writer, where there
> is a
> >>>>>> blank space as the last character of a paragraph (eg. last word
> >>>>>> ). In the original OOo and most of the text editors I
> >>>>>> use the simple solution that worked/works perfectly is: Find =
> >>>>>> $ Replace = $ (Note: I use  here to represent a single
> >>>>>> space character). This does not work in LO Writer, so I am forced to
> >>>>>> fiddle around copying from LO and pasting into AOO, running F in
> >>>>>> AOO, then copy/paste back again. Any pointers would be welcome.
> >>>>> I'm surprised that exactly what you say works in OpenOffice. Don't
> you
> >>>>> need to find space-dollar, just as you describe, but to replace with
> >>>>> nothing? Replacing with dollar will surely insert an unwanted dollar
> >>>>> character?
> >>>>>
> >>>>> Or have you forgotten to click "Other options" in the Find and
> Replace
> >>>>> dialogue and to tick "Regular expressions"?
> >>>>>
> >>>>> I trust this helps.
> >>>>>
> >>>>> Brian Barker
> >>>> Hi Brian,
> >>>>
> >>>> After 22 Years of you and I being involved in this project, I
> genuinely
> >>>> bow to your superior knowledge in this area. However, I do assure you
> >>>> that the convoluted LO->AOO->LO� nonsense works for me, exactly as it
> >>>> did in the days of OOo.
> >>>>
> >>>> No, I have not forgotten to click "Other options in the Find and
> Replace
> >>>> dialogue and to tick "Regular expressions", please see my screen
> capture:
> >>>> https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
> >>>>
> >>>> Here is a very simplistic file illustrating the 
> >>>> paragraph endings:
> >>>> https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
> >>>>
> >>>> Version: 7.3.1.3 (x64) / LibreOffice Community
> >>>> Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
> >>>> CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL:
> >>>> win
> >>>> Locale: es-ES (en_IE); UI: en-US
> >>>> Calc: threaded
> >>>>
> >>>> If you can please show me where I am going wrong, I would be extremely
> >>>> grateful.
> >>>>
> >>>> Dave Barton
> >>>>
> >>>>
> >>> May be this is sorted and I have received the emails out of order, but
> >>> assuming you just want to remove the trailing space from each line,
> both
> >>> Johnny's and Michael's methods work for me on your sample file.
> >>>
> >>> Find= [:space:]{1,}$
> >>> Replace= empty
> >>>
> >>> Find= $
> >>> Replace= empty
> >>>
> >>> Use regular expression= checked
> >>> Steve
> >>
> >>
> >> Thanks Steve, but no it's NOT sorted.
> >>
> >> You have &qu

Re: [libreoffice-users] Help with find & replace.

[Dave Barton]

Fantastic, but why does the LO project *_NOT_* inform it's users about
this *_HIDDEN_* option?

Please provide links to the the TDF/LO Help/Documentation files that
provide this information to our users.

 Original Message 
From: Michael D. Setzer II [mailto:msetze...@gmail.com]
Sent: Wednesday, March 16, 2022, 20:53 UTC
To: Dave Barton; users@global.libreoffice.org
Subject: [libreoffice-users] Help with find & replace.

> On 16 Mar 2022 at 20:41, Dave Barton wrote:
> 
> Subject:      Re: [libreoffice-users] Help with find & 
> replace.
> To:   users@global.libreoffice.org
> From: Dave Barton 
> Date sent:Wed, 16 Mar 2022 20:41:43 +
> 
>> On 16/03/2022 20:01, Steve Edmonds wrote:
>>>
>>>
>>> On 17/03/2022 08:34, Dave Barton wrote:
>>>> On 16/03/2022 18:27, Brian Barker wrote:
>>>>> At 16:29 16/03/2022 +, Dave Barton wrote:
>>>>>> I am looking for a find & replace solution in Writer, where there is a
>>>>>> blank space as the last character of a paragraph (eg. last word
>>>>>> ). In the original OOo and most of the text editors I
>>>>>> use the simple solution that worked/works perfectly is: Find =
>>>>>> $ Replace = $ (Note: I use  here to represent a single
>>>>>> space character). This does not work in LO Writer, so I am forced to
>>>>>> fiddle around copying from LO and pasting into AOO, running F in
>>>>>> AOO, then copy/paste back again. Any pointers would be welcome.
>>>>> I'm surprised that exactly what you say works in OpenOffice. Don't you
>>>>> need to find space-dollar, just as you describe, but to replace with
>>>>> nothing? Replacing with dollar will surely insert an unwanted dollar
>>>>> character?
>>>>>
>>>>> Or have you forgotten to click "Other options" in the Find and Replace
>>>>> dialogue and to tick "Regular expressions"?
>>>>>
>>>>> I trust this helps.
>>>>>
>>>>> Brian Barker
>>>> Hi Brian,
>>>>
>>>> After 22 Years of you and I being involved in this project, I genuinely
>>>> bow to your superior knowledge in this area. However, I do assure you
>>>> that the convoluted LO->AOO->LO� nonsense works for me, exactly as it
>>>> did in the days of OOo.
>>>>
>>>> No, I have not forgotten to click "Other options in the Find and Replace
>>>> dialogue and to tick "Regular expressions", please see my screen capture:
>>>> https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
>>>>
>>>> Here is a very simplistic file illustrating the 
>>>> paragraph endings:
>>>> https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
>>>>
>>>> Version: 7.3.1.3 (x64) / LibreOffice Community
>>>> Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
>>>> CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL:
>>>> win
>>>> Locale: es-ES (en_IE); UI: en-US
>>>> Calc: threaded
>>>>
>>>> If you can please show me where I am going wrong, I would be extremely
>>>> grateful.
>>>>
>>>> Dave Barton
>>>>
>>>>
>>> May be this is sorted and I have received the emails out of order, but
>>> assuming you just want to remove the trailing space from each line, both
>>> Johnny's and Michael's methods work for me on your sample file.
>>>
>>> Find= [:space:]{1,}$
>>> Replace= empty
>>>
>>> Find= $
>>> Replace= empty
>>>
>>> Use regular expression= checked
>>> Steve
>>
>>
>> Thanks Steve, but no it's NOT sorted.
>>
>> You have "Kinda" given me 1/2 a clue.
>>
>> What does {.1.} mean?
> file:///opt/libreoffice7.3/help/en-US/text/shared/01/0211.html?=WRITER
> 
> {N}
> 
> The post-fix repetition operator that specifies an exact 
> number of occurrences ("N") of the regular expression 
> term immediately preceding it must be present for a 
> match to occur. For example, "tre{2}" matches "tree".  
> 
> {N,M} 
>  The post-fix repetition operator that specifies a range 
> (minimum of "N" to a maximum of "M") of occurrences of 
> the regular expression term immediately preceding it 
> that can 

Re: [libreoffice-users] Help with find & replace.

[Johnny Rosenberg]

Den ons 16 mars 2022 kl 21:44 skrev Dave Barton :

> On 16/03/2022 20:01, Steve Edmonds wrote:
> >
> >
> > On 17/03/2022 08:34, Dave Barton wrote:
> >> On 16/03/2022 18:27, Brian Barker wrote:
> >>> At 16:29 16/03/2022 +, Dave Barton wrote:
>  I am looking for a find & replace solution in Writer, where there is a
>  blank space as the last character of a paragraph (eg. last word
>  ). In the original OOo and most of the text editors I
>  use the simple solution that worked/works perfectly is: Find =
>  $ Replace = $ (Note: I use  here to represent a single
>  space character). This does not work in LO Writer, so I am forced to
>  fiddle around copying from LO and pasting into AOO, running F in
>  AOO, then copy/paste back again. Any pointers would be welcome.
> >>> I'm surprised that exactly what you say works in OpenOffice. Don't you
> >>> need to find space-dollar, just as you describe, but to replace with
> >>> nothing? Replacing with dollar will surely insert an unwanted dollar
> >>> character?
> >>>
> >>> Or have you forgotten to click "Other options" in the Find and Replace
> >>> dialogue and to tick "Regular expressions"?
> >>>
> >>> I trust this helps.
> >>>
> >>> Brian Barker
> >> Hi Brian,
> >>
> >> After 22 Years of you and I being involved in this project, I genuinely
> >> bow to your superior knowledge in this area. However, I do assure you
> >> that the convoluted LO->AOO->LO  nonsense works for me, exactly as it
> >> did in the days of OOo.
> >>
> >> No, I have not forgotten to click "Other options in the Find and Replace
> >> dialogue and to tick "Regular expressions", please see my screen
> capture:
> >> https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
> >>
> >> Here is a very simplistic file illustrating the 
> >> paragraph endings:
> >> https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
> >>
> >> Version: 7.3.1.3 (x64) / LibreOffice Community
> >> Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
> >> CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL:
> >> win
> >> Locale: es-ES (en_IE); UI: en-US
> >> Calc: threaded
> >>
> >> If you can please show me where I am going wrong, I would be extremely
> >> grateful.
> >>
> >> Dave Barton
> >>
> >>
> > May be this is sorted and I have received the emails out of order, but
> > assuming you just want to remove the trailing space from each line, both
> > Johnny's and Michael's methods work for me on your sample file.
> >
> > Find= [:space:]{1,}$
> > Replace= empty
> >
> > Find= $
> > Replace= empty
> >
> > Use regular expression= checked
> > Steve
>
>
> Thanks Steve, but no it's NOT sorted.
>
> You have "Kinda" given me 1/2 a clue.
>
> What does {.1.} mean?
>

It means ”one or more of the previous character”. Well, it's {1,}, not
{.1.}.
You can also specify a maximum value, like this: {1,5}. This means ”at
least one and not more than 5 of the previous character.
For instance:
[0-9]{3,5}
This means at least three and not more than 5 numerical characters.


Kind regards

Johnny Rosenberg


>
> In all my researching of regular expressions, I have never encountered
> this option. The wonderful thing about *_STANDARDS_* is that there are
> such a wide variety of different ones to randomly chose and use.
>
> 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
>

-- 
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 with find & replace.

[Michael D. Setzer II]

On 16 Mar 2022 at 20:41, Dave Barton wrote:

Subject:Re: [libreoffice-users] Help with find & 
replace.
To: users@global.libreoffice.org
From:   Dave Barton 
Date sent:  Wed, 16 Mar 2022 20:41:43 +

> On 16/03/2022 20:01, Steve Edmonds wrote:
> > 
> > 
> > On 17/03/2022 08:34, Dave Barton wrote:
> >> On 16/03/2022 18:27, Brian Barker wrote:
> >>> At 16:29 16/03/2022 +, Dave Barton wrote:
> >>>> I am looking for a find & replace solution in Writer, where there is a
> >>>> blank space as the last character of a paragraph (eg. last word
> >>>> ). In the original OOo and most of the text editors I
> >>>> use the simple solution that worked/works perfectly is: Find =
> >>>> $ Replace = $ (Note: I use  here to represent a single
> >>>> space character). This does not work in LO Writer, so I am forced to
> >>>> fiddle around copying from LO and pasting into AOO, running F in
> >>>> AOO, then copy/paste back again. Any pointers would be welcome.
> >>> I'm surprised that exactly what you say works in OpenOffice. Don't you
> >>> need to find space-dollar, just as you describe, but to replace with
> >>> nothing? Replacing with dollar will surely insert an unwanted dollar
> >>> character?
> >>>
> >>> Or have you forgotten to click "Other options" in the Find and Replace
> >>> dialogue and to tick "Regular expressions"?
> >>>
> >>> I trust this helps.
> >>>
> >>> Brian Barker
> >> Hi Brian,
> >>
> >> After 22 Years of you and I being involved in this project, I genuinely
> >> bow to your superior knowledge in this area. However, I do assure you
> >> that the convoluted LO->AOO->LO  nonsense works for me, exactly as it
> >> did in the days of OOo.
> >>
> >> No, I have not forgotten to click "Other options in the Find and Replace
> >> dialogue and to tick "Regular expressions", please see my screen capture:
> >> https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
> >>
> >> Here is a very simplistic file illustrating the 
> >> paragraph endings:
> >> https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
> >>
> >> Version: 7.3.1.3 (x64) / LibreOffice Community
> >> Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
> >> CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL:
> >> win
> >> Locale: es-ES (en_IE); UI: en-US
> >> Calc: threaded
> >>
> >> If you can please show me where I am going wrong, I would be extremely
> >> grateful.
> >>
> >> Dave Barton
> >>
> >>
> > May be this is sorted and I have received the emails out of order, but
> > assuming you just want to remove the trailing space from each line, both
> > Johnny's and Michael's methods work for me on your sample file.
> > 
> > Find= [:space:]{1,}$
> > Replace= empty
> > 
> > Find= $
> > Replace= empty
> > 
> > Use regular expression= checked
> > Steve
> 
> 
> Thanks Steve, but no it's NOT sorted.
> 
> You have "Kinda" given me 1/2 a clue.
> 
> What does {.1.} mean?
file:///opt/libreoffice7.3/help/en-US/text/shared/01/0211.html?=WRITER

{N}

The post-fix repetition operator that specifies an exact 
number of occurrences ("N") of the regular expression 
term immediately preceding it must be present for a 
match to occur. For example, "tre{2}" matches "tree".  

{N,M}   
 The post-fix repetition operator that specifies a range 
(minimum of "N" to a maximum of "M") of occurrences of 
the regular expression term immediately preceding it 
that can be present for a match to occur. For example, 
"tre{1,2}" matches "tre" and "tree".  

{N,}

The post-fix repetition operator that specifies a range 
(minimum "N" to an unspecified maximum) of 
occurrences of the regular expression term immediately 
preceding it that can be present for a match to occur. 
(The maximum number of occurrences is limited only by 
the size of the document). For example, "tre{2,}" 
matches "tree", "treee", and "tre".  

So, [:space:]{1,}$ matches one or more spaces at end of 
line.
{1,}$ does the same with  actually 
being a single space.
> 
> In all my researching of regular expressions, I have never encountered
> this option. The wonderf

Re: [libreoffice-users] Help with find & replace.

[Dave Barton]

On 16/03/2022 20:01, Steve Edmonds wrote:
> 
> 
> On 17/03/2022 08:34, Dave Barton wrote:
>> On 16/03/2022 18:27, Brian Barker wrote:
>>> At 16:29 16/03/2022 +, Dave Barton wrote:
 I am looking for a find & replace solution in Writer, where there is a
 blank space as the last character of a paragraph (eg. last word
 ). In the original OOo and most of the text editors I
 use the simple solution that worked/works perfectly is: Find =
 $ Replace = $ (Note: I use  here to represent a single
 space character). This does not work in LO Writer, so I am forced to
 fiddle around copying from LO and pasting into AOO, running F in
 AOO, then copy/paste back again. Any pointers would be welcome.
>>> I'm surprised that exactly what you say works in OpenOffice. Don't you
>>> need to find space-dollar, just as you describe, but to replace with
>>> nothing? Replacing with dollar will surely insert an unwanted dollar
>>> character?
>>>
>>> Or have you forgotten to click "Other options" in the Find and Replace
>>> dialogue and to tick "Regular expressions"?
>>>
>>> I trust this helps.
>>>
>>> Brian Barker
>> Hi Brian,
>>
>> After 22 Years of you and I being involved in this project, I genuinely
>> bow to your superior knowledge in this area. However, I do assure you
>> that the convoluted LO->AOO->LO  nonsense works for me, exactly as it
>> did in the days of OOo.
>>
>> No, I have not forgotten to click "Other options in the Find and Replace
>> dialogue and to tick "Regular expressions", please see my screen capture:
>> https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
>>
>> Here is a very simplistic file illustrating the 
>> paragraph endings:
>> https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
>>
>> Version: 7.3.1.3 (x64) / LibreOffice Community
>> Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
>> CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL:
>> win
>> Locale: es-ES (en_IE); UI: en-US
>> Calc: threaded
>>
>> If you can please show me where I am going wrong, I would be extremely
>> grateful.
>>
>> Dave Barton
>>
>>
> May be this is sorted and I have received the emails out of order, but
> assuming you just want to remove the trailing space from each line, both
> Johnny's and Michael's methods work for me on your sample file.
> 
> Find= [:space:]{1,}$
> Replace= empty
> 
> Find= $
> Replace= empty
> 
> Use regular expression= checked
> Steve


Thanks Steve, but no it's NOT sorted.

You have "Kinda" given me 1/2 a clue.

What does {.1.} mean?

In all my researching of regular expressions, I have never encountered
this option. The wonderful thing about *_STANDARDS_* is that there are
such a wide variety of different ones to randomly chose and use.

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] Help with find & replace.

[Michael D. Setzer II]

On 17 Mar 2022 at 9:01, Steve Edmonds wrote:

Date sent:  Thu, 17 Mar 2022 09:01:42 +1300
Subject:Re: [libreoffice-users] Help with find & 
replace.
To: users@global.libreoffice.org
From:   Steve Edmonds 


> 
> 
> On 17/03/2022 08:34, Dave Barton wrote:
> > On 16/03/2022 18:27, Brian Barker wrote:
> >> At 16:29 16/03/2022 +, Dave Barton wrote:
> >>> I am looking for a find & replace solution in Writer, where there is a
> >>> blank space as the last character of a paragraph (eg. last word
> >>> ). In the original OOo and most of the text editors I
> >>> use the simple solution that worked/works perfectly is: Find =
> >>> $ Replace = $ (Note: I use  here to represent a single
> >>> space character). This does not work in LO Writer, so I am forced to
> >>> fiddle around copying from LO and pasting into AOO, running F in
> >>> AOO, then copy/paste back again. Any pointers would be welcome.
> >> I'm surprised that exactly what you say works in OpenOffice. Don't you
> >> need to find space-dollar, just as you describe, but to replace with
> >> nothing? Replacing with dollar will surely insert an unwanted dollar
> >> character?
> >>
> >> Or have you forgotten to click "Other options" in the Find and Replace
> >> dialogue and to tick "Regular expressions"?
> >>
> >> I trust this helps.
> >>
> >> Brian Barker
> > Hi Brian,
> >
> > After 22 Years of you and I being involved in this project, I genuinely
> > bow to your superior knowledge in this area. However, I do assure you
> > that the convoluted LO->AOO->LO  nonsense works for me, exactly as it
> > did in the days of OOo.
> >
> > No, I have not forgotten to click "Other options in the Find and Replace
> > dialogue and to tick "Regular expressions", please see my screen capture:
> > https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
> >
> > Here is a very simplistic file illustrating the 
> > paragraph endings:
> > https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
> >
> > Version: 7.3.1.3 (x64) / LibreOffice Community
> > Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
> > CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
> > Locale: es-ES (en_IE); UI: en-US
> > Calc: threaded
> >
> > If you can please show me where I am going wrong, I would be extremely
> > grateful.
> >
> > Dave Barton
> >
> >
> May be this is sorted and I have received the emails out of order, but 
> assuming you just want to remove the trailing space from each line, both 
> Johnny's and Michael's methods work for me on your sample file.
> 
> Find= [:space:]{1,}$
> Replace= empty
> 
> Find= $
> Replace= empty
> 
> Use regular expression= checked
> Steve

Just to make sure it is clear $ will only remove 1 
space at end of line {1,}$ or [:space:]{1,}$ will 
remove all spaces 1 to whatever.



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


++
 Michael D. Setzer II - Computer Science Instructor 
(Retired) 
 mailto:mi...@guam.net
 mailto:msetze...@gmail.com
 Guam - Where America's Day Begins
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
++




-- 
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 with find & replace.

[Dave Barton]

On 16/03/2022 18:27, Brian Barker wrote:
> At 16:29 16/03/2022 +, Dave Barton wrote:
>> I am looking for a find & replace solution in Writer, where there is a
>> blank space as the last character of a paragraph (eg. last word
>> ). In the original OOo and most of the text editors I
>> use the simple solution that worked/works perfectly is: Find =
>> $ Replace = $ (Note: I use  here to represent a single
>> space character). This does not work in LO Writer, so I am forced to
>> fiddle around copying from LO and pasting into AOO, running F in
>> AOO, then copy/paste back again. Any pointers would be welcome.
> 
> I'm surprised that exactly what you say works in OpenOffice. Don't you
> need to find space-dollar, just as you describe, but to replace with
> nothing? Replacing with dollar will surely insert an unwanted dollar
> character?
> 
> Or have you forgotten to click "Other options" in the Find and Replace
> dialogue and to tick "Regular expressions"?
> 
> I trust this helps.
> 
> Brian Barker

Hi Brian,

After 22 Years of you and I being involved in this project, I genuinely
bow to your superior knowledge in this area. However, I do assure you
that the convoluted LO->AOO->LO  nonsense works for me, exactly as it
did in the days of OOo.

No, I have not forgotten to click "Other options in the Find and Replace
dialogue and to tick "Regular expressions", please see my screen capture:
https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file

Here is a very simplistic file illustrating the 
paragraph endings:
https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file

Version: 7.3.1.3 (x64) / LibreOffice Community
Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: es-ES (en_IE); UI: en-US
Calc: threaded

If you can please show me where I am going wrong, I would be extremely
grateful.

Dave Barton


-- 
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 with find & replace.

[Michael D. Setzer II]

[:space:]{1,}$ Seemed to work for me in find option and 
left replace completely blank. Than replace all.

On 16 Mar 2022 at 16:29, Dave Barton wrote:

To: LibreOffice Users 

From:   Dave Barton 
Subject:[libreoffice-users] Help with find & replace.
Date sent:  Wed, 16 Mar 2022 16:29:34 +

> I am looking for a find & replace solution in Writer, where there is a
> blank space as the last character of a paragraph
> (eg. last word ).
> 
> In the original OOo and most of the text editors I use the simple
> solution that worked/works perfectly is:
> Find = $ Replace = $
> (Note: I use  here to represent a single space character).
> 
> This does not work in LO Writer, so I am forced to fiddle around copying
> from LO and pasting into AOO, running F in AOO, then copy/paste back
> again.
> 
> Any pointers would be welcome.
> 
> 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


++
 Michael D. Setzer II - Computer Science Instructor 
(Retired) 
 mailto:mi...@guam.net
 mailto:msetze...@gmail.com
 Guam - Where America's Day Begins
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
++




-- 
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 with find & replace.

[Johnny Rosenberg]

Den ons 16 mars 2022 kl 17:56 skrev Dave Barton :

> I am looking for a find & replace solution in Writer, where there is a
> blank space as the last character of a paragraph
> (eg. last word ).
>

I think ␊␍ is Windows only, but maybe that doesn't matter in this case.


> In the original OOo and most of the text editors I use the simple
> solution that worked/works perfectly is:
> Find = $ Replace = $
> (Note: I use  here to represent a single space character).
>
> This does not work in LO Writer, so I am forced to fiddle around copying
> from LO and pasting into AOO, running F in AOO, then copy/paste back
> again.
>

It works perfectly for me. It replaces the space with a $ character, just
like expected (make sure ”☒ Regular expressions” is checked). If you don't
want the $ character, then just leave the Replace field empty.
I tried it a few seconds ago with LibreOffice 7.1.8.1 and it worked
perfectly. I suspect it works just as well with newer versions as well as
most older versions too.

In LibreOffice, the $ character doesn't mean a ”new line character”, it
doesn't work quite like that. A paragraph is kind of an object which
contains the actual text and all the properties of that paragraph (as far
as I understand it), so $ doesn't really mean ”a space followed by a
newline character”, it rather means ”a space at the end of a paragraph”. It
just specifies where to look for the space, nothing more. So you are not
replacing two characters with one, you are replacing one character with
nothing and you are doing it at the end of a paragraph.

At least that's the easiest way I can explain it.

I hope this helps.

Are you sure that replacing with $ actually worked in Apache OpenOffice?
I'm not sure, but it shouldn't, should it? Because Apache OpenOffice works
the same way as LibreOffice in this matter, working with objects and all
that. As I no longer have Apache OpenOffice installed I can't test it, so I
can't say for sure.


Kind regards

Johnny Rosenberg


>
> Any pointers would be welcome.
>
> 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
>

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

[Italo Vignoli]

Hi Stephen,

On 4/14/21 3:20 PM, STEPHEN COLEMAN wrote:


   Fault Module Name: ucrtbase.DLL


The issue is related to ucrtbase.dll, which is a Windows module.

The gift_aid_schedule_libre_.ods file, which is easy to download from 
the UK Gov website, opens without any issue if that module is not faulty 
(I have just checked with Linux, macOS and Windows).


First, you should check if you LibreOffice installation conflicts with 
the faulty module by launching LibreOffice (double click on the program 
icon), without opening any file. If the software crashes, then there is 
a conflict, if the software opens, then there is a file specific conflict.


While you have to investigate with a Windows expert why your module is 
faulty, you can try one of the following workarounds:


1. Download the Excel version of the same file, which is available from 
the same page, and try to open it with LibreOffice (which is fully 
compatible with MS Office files).


2. Install the portable version of LibreOffice from the following page: 
https://www.libreoffice.org/download/portable-versions/. That version is 
not accessing system resources, so it should opeen the file without issues.


3. Uninstall LibreOffice 7.1.2 and reinstall LibreOffice 7.0.5 (the 
fourth digit is the release candidate version, so is not significant).


I hope one of these workaround works. Best regards.
--
Italo Vignoli - it...@vignoli.org
mobile/signal +39.348.5653829
GPG Key ID - 0xAAB8D5C0
DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0


--
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 installation via flatpak

[Stephan Bergmann]

On 14/05/2020 15:42, Stephan Bergmann wrote:

On 14/05/2020 13:24, asbaeza65 wrote:
Since a little while I sole to install/update libreoffice using 
flatpak. It
works just great, but it does not install the help system. Is there 
any way

to do that using flatpak?


You explicitly need to install the
org.libreoffice.LibreOffice.Help extension.

(See also the commit message of 
 
"Enable --help=html for flatpak".  That extension contains all 
localizations, so is rather larger.)


(I added some information to 
 now.)



--
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 installation via flatpak

[Stephan Bergmann]

On 14/05/2020 13:24, asbaeza65 wrote:

Since a little while I sole to install/update libreoffice using flatpak. It
works just great, but it does not install the help system. Is there any way
to do that using flatpak?


You explicitly need to install the
org.libreoffice.LibreOffice.Help extension.

(See also the commit message of 
 
"Enable --help=html for flatpak".  That extension contains all 
localizations, so is rather larger.)



--
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 to delete an unwanted character.

[Budge]

On 05/12/2019 14:05, Budge wrote:

I have just started to try and learn about templates and I read that to
open the templates manager I should use Ctrl+Shift+E.

Well nothing happened but when I then opened writer for a new document
there was a lower case e underlined at the start of the letter.  I could
not delete it and what is even more strange is that this same underlined
lower case e appears in as the starting character in my To: field in
Thunderbird.

Clearly I have turned on something I do not understand but would
appreciate and suggestions.



Please forgive my rush to print.  Had to re-boot and that seems to have fixed 
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

Re: [libreoffice-users] Help with formula - number conversion

[libreoffice-ml . mbourne]

sc...@valuedinsights.com wrote:

I have unsubscribed numerous times. Stop sending me your junk!


Most of us receiving mail from this list are just other users, like you, 
and have no ability to remove you from the list. You should be able to 
remove yourself by sending an email to 
. Make sure you send the email 
from the address which is subscribed to the list. You should receive an 
email asking you to confirm that you want to unsubscribe, to which you 
need to reply to complete the unsubscribe. If you don't receive that 
message, check if it's ended up in your junk/spam folder.


If you still can't unsubscribe, there are further troubleshooting steps at:


--
Mark


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

RE: [libreoffice-users] Help with formula - number conversion

[scott]

I have unsubscribed numerous times. Stop sending me your junk!

-Original Message-
From: Harvey Nimmo  
Sent: Thursday, July 11, 2019 1:55 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Help with formula - number conversion

On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl wrote:
> Hi everyone,
> 
> I need some help with converting a number (in a text field) to a 
> different type.
> 
> The type of number is time, and it is in the form of:
> 
> hh:mm:ss
> 
> I need to convert this to just minutes, rounded up, so if ss is more 
> than 30 it adds another minute.
> 
> I'm at a loss as to how to even start (I'm not a spreadsheet guy)...
> 
> I would appreciate any pointers on how to get this done...
> 
> Thanks!

You might like to try the following.
Given that your value is in field A1 in the form hh:mm:ss then you can do the 
conversion by entering the following in another field
=(HOUR(A1)*60)+MINUTE(A1)+ROUND(SEC(A1/60),0)

It doesn't seem to matter if the value in A1 is in time format or text format.

I'm sure there are buffs out there who could offer a more elegant solution, but 
the above seems to work all right for the cases I tried.

Cheers
Harvey




--
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] Help with formula - number conversion

[Harvey Nimmo]

On Fri, 2019-07-12 at 13:00 -0400, Tanstaafl wrote:
> On Thu Jul 11 2019 15:12:05 GMT-0400 (Eastern Standard Time), Harvey
> Nimmo  wrote:
> > Sorry, Tanstaafl! 
> > 
> > There is a slight error in the above. The formula should read
> > =HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0)
> > 
> > 'SEC' is the secant function. Also 'MIN' would also be wrong since
> > it
> > calculates the minimum of a set of values.
> 
> awesome! Thanks very much Harvey! Worked like a charm...

You're welcome. But Brian Barker's suggestion is both more elegant and
simpler, because it considers takes account of times greater than 24
hours.

Say your time is in cell A1 in text format (e.g. '25:01:50)

Then adding the formula to another cell 
=ROUND(a1*1440,0) or just ROUND(a1*1440) gives the right answer (1502),
whereas my previous formula would wrongly return 1 (hour) instead of
25, giving total 62.

Cheers
Harvey






-- 
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 with formula - number conversion

[Brian Barker]

At 14:05 11/07/2019 -0400, Charles Marcus wrote:
I need some help with converting a number (in a text field) to a 
different type. The type of number is time, and it is in the form 
of: hh:mm:ss I need to convert this to just minutes, rounded up, so 
if ss is more than 30 it adds another minute.


At 20:55 11/07/2019 +0200, and at 21:12 11/07/2019 +0200, Harvey Nimmo wrote:
You might like to try the following. Given that your value is in 
field A1 in the form hh:mm:ss then you can do the conversion by 
entering the following in another field

=HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0)
It doesn't seem to matter if the value in A1 is in time format or 
text format. I'm sure there are buffs out there who could offer a 
more elegant solution, but the above seems to work all right for the 
cases I tried.


I'm not sure if it is more elegant, but there is a simpler solution. 
Time values are represented internally as numbers and fractions of 
days, so it is unnecessary to unpack the separate hour, minute, and 
second values. If you just multiply by 1440, the number of minutes in 
a day, you will have the total number of minutes in the period:

=Xn*1440

Your rounding request is ambiguous.

o "Rounding up" would mean that any number of seconds other than zero 
would cause another whole minute to be indicated. For that, choose:

=ROUNDUP(Xn*1440)

o If you want the extra minute only when the seconds value is more 
than half a minute, normal rounding is appropriate:

=ROUND(Xn*1440)

o But note that normal rounding - as provided by the ROUND() function 
- will round 30 seconds up to the next minute, as well as values over 
30. If you really want exactly thirty seconds to be rounded down - a 
non-standard type of rounding - you will have to work around this 
yourself. But I guess that you probably don't mean that.


Incidentally, by mentioning the time format hh:mm:ss you imply that 
what you are handling are times of day, but when you convert these to 
minutes, they have the feel of time intervals, not times per se. 
After all, no-one specifies times of day just in minutes. If you have 
a period of time more than twenty-four hours, the hh:mm:ss format 
will display the time as it would appear in a later day. So 25 hours, 
for example, will appear as 01:00, or 1 a.m. the following day. You 
can display such time intervals using the alternative format code [HH]:MM:SS.


This produces a difference between the unpacking method and simple 
multiplication. If your time interval is 25 hours - 25:00:00 - the 
HOUR() function will return this as 1 hour - meaning one o'clock - 
whereas the multiplication method will respect the full 25 hours. 
Only you can know which you need or if this matters.


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] Help with formula - number conversion

[Tanstaafl]

On Thu Jul 11 2019 15:12:05 GMT-0400 (Eastern Standard Time), Harvey
Nimmo  wrote:
> Sorry, Tanstaafl! 
> 
> There is a slight error in the above. The formula should read
> =HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0)
> 
> 'SEC' is the secant function. Also 'MIN' would also be wrong since it
> calculates the minimum of a set of values.

awesome! Thanks very much Harvey! Worked like a charm...

-- 
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 with formula - number conversion

[Harvey Nimmo]

On Thu, 2019-07-11 at 20:55 +0200, Harvey Nimmo wrote:
> On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl wrote:
> > Hi everyone,
> > 
> > I need some help with converting a number (in a text field) to a
> > different type.
> > 
> > The type of number is time, and it is in the form of:
> > 
> > hh:mm:ss
> > 
> > I need to convert this to just minutes, rounded up, so if ss is
> > more
> > than 30 it adds another minute.
> > 
> > I'm at a loss as to how to even start (I'm not a spreadsheet
> > guy)...
> > 
> > I would appreciate any pointers on how to get this done...
> > 
> > Thanks!
> 
> You might like to try the following.
> Given that your value is in field A1 in the form hh:mm:ss
> then you can do the conversion by entering the following in another
> field
> =(HOUR(A1)*60)+MINUTE(A1)+ROUND(SEC(A1/60),0)
> 
> It doesn't seem to matter if the value in A1 is in time format or
> text
> format.
> 
> I'm sure there are buffs out there who could offer a more elegant
> solution, but the above seems to work all right for the cases I
> tried.
> 
> Cheers
> Harvey

Sorry, Tanstaafl! 

There is a slight error in the above. The formula should read
=HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0)

'SEC' is the secant function. Also 'MIN' would also be wrong since it
calculates the minimum of a set of values.

Cheers
Harvey



-- 
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 with formula - number conversion

[Harvey Nimmo]

On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl wrote:
> Hi everyone,
> 
> I need some help with converting a number (in a text field) to a
> different type.
> 
> The type of number is time, and it is in the form of:
> 
> hh:mm:ss
> 
> I need to convert this to just minutes, rounded up, so if ss is more
> than 30 it adds another minute.
> 
> I'm at a loss as to how to even start (I'm not a spreadsheet guy)...
> 
> I would appreciate any pointers on how to get this done...
> 
> Thanks!

You might like to try the following.
Given that your value is in field A1 in the form hh:mm:ss
then you can do the conversion by entering the following in another
field
=(HOUR(A1)*60)+MINUTE(A1)+ROUND(SEC(A1/60),0)

It doesn't seem to matter if the value in A1 is in time format or text
format.

I'm sure there are buffs out there who could offer a more elegant
solution, but the above seems to work all right for the cases I tried.

Cheers
Harvey




-- 
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 needed with Excel spreadsheet

[Luuk]

On 6-3-2019 17:48, Tom Williams wrote:

On 3/6/19 8:26 AM, Tom Williams wrote:

I know it's odd to ask for Excel help in this mailing list but I need
help locating a LibreOffice Calc function/feature in Excel.  :)

I'm helping a friend create a billing invoice and since I'm a Linux
user, I'm using Calc to build the template.  So far, it's working well
and given I'm not an Excel user, I find myself struggling some in
getting Excel to "behave".  Anyway, I recently discovered the "/Expand
reference when new rows are inserted/" in Calc.  It does exactly what I
needed.   When I add/remove a row in/from the spreadsheet, my total
"SUM()" formula is updated automagically.

Does the equivalent feature exist in Excel?  What I've found is, when
adding rows *after* the last row in my SUM() formula, the new row is
excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
Once I add row 28, I need the SUM() formula to be updated to
"=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
reference when new rows are inserted/" feature does this work for me.

I did some web searching and found this article:

https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html

but I hope to find an easier and more flexible way to accomplish what I
need.  Or is that approach what I really should use?

Thanks in advance!

Peace...

"The Other" Tom



Nevermind!  I found this:

https://bettersolutions.com/excel/formulas/automatic-expansion.htm

That should do what I need!

Thanks anyway!  :)

Peace...

"The Other" Tom


In EXCEL you can do this:

A   B   C
1   2   3
=A2+3   =B2+3   =C2+3

(I used CTRL+T to show formulas, you should see the values 4,5,6)

When you select A1:C3, and choose 'Insert'/'Table'

After this, typing the value 7 in cell 'A4', en pressing 'Enter' results 
in the fields B4 and C4 being updated with the same formula as in row 3.


How can this be achieved in LibreOffice 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] Help needed with Excel spreadsheet

[Tom Williams]

On 3/6/19 5:42 PM, Tom Davies wrote:
> Hi :)
> Sounds like a perfect time to suggest they install LO too.
>
> If an Excel person hadn't immediately found what they were looking for in
> Calc they would have immediately claimed that Calc couldn't do the task.
>
> There are loads of articles about LO that have such posts in the comments
> section.  It can be fun to refute them in as few words as possible.
> Regards from a Tom :)


You know, I'm about ready to do that.   After doing some experimentation
with Excel today, I found it just doesn't want to "play nice" with what
I'm trying to do.  I want to have an image as the spreadsheet header and
have the basic formulas update when I add/remove rows.  I'm sure with
enough time, I could get Excel to behave but I've been able to get what
I needed working far more easily with Calc.

I haven't given up, just yet, but I'm really surprised at how stubborn
Excel is, when it comes to the things I'm trying to do with it.  :(

Peace...

"The Other" Tom

>
>
> On Wed, 6 Mar 2019 18:21 Luuk 
>> On 6-3-2019 17:48, Tom Williams wrote:
>>> On 3/6/19 8:26 AM, Tom Williams wrote:
 I know it's odd to ask for Excel help in this mailing list but I need
 help locating a LibreOffice Calc function/feature in Excel.  :)

 I'm helping a friend create a billing invoice and since I'm a Linux
 user, I'm using Calc to build the template.  So far, it's working well
 and given I'm not an Excel user, I find myself struggling some in
 getting Excel to "behave".  Anyway, I recently discovered the "/Expand
 reference when new rows are inserted/" in Calc.  It does exactly what I
 needed.   When I add/remove a row in/from the spreadsheet, my total
 "SUM()" formula is updated automagically.

 Does the equivalent feature exist in Excel?  What I've found is, when
 adding rows *after* the last row in my SUM() formula, the new row is
 excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
 Once I add row 28, I need the SUM() formula to be updated to
 "=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
 formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
 reference when new rows are inserted/" feature does this work for me.

 I did some web searching and found this article:


>> https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html
 but I hope to find an easier and more flexible way to accomplish what I
 need.  Or is that approach what I really should use?

 Thanks in advance!

 Peace...

 "The Other" Tom


>>> Nevermind!  I found this:
>>>
>>> https://bettersolutions.com/excel/formulas/automatic-expansion.htm
>>>
>>> That should do what I need!
>>>
>>> Thanks anyway!  :)
>>>
>>> Peace...
>>>
>>> "The Other" Tom
>>>
>> When i was reading above, i thought you were search for subtotals.
>>
>> Excel has also a function named SUBTOTAL()
>>
>>
>> https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939
>>
>>
>>
>>
>> --
>> 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
>>

-- 
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

-- 
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 needed with Excel spreadsheet

[Tom Williams]

On 3/6/19 10:18 AM, Luuk wrote:
>
> On 6-3-2019 17:48, Tom Williams wrote:
>> On 3/6/19 8:26 AM, Tom Williams wrote:
>>> I know it's odd to ask for Excel help in this mailing list but I need
>>> help locating a LibreOffice Calc function/feature in Excel.  :)
>>>
>>> I'm helping a friend create a billing invoice and since I'm a Linux
>>> user, I'm using Calc to build the template.  So far, it's working well
>>> and given I'm not an Excel user, I find myself struggling some in
>>> getting Excel to "behave".  Anyway, I recently discovered the "/Expand
>>> reference when new rows are inserted/" in Calc.  It does exactly what I
>>> needed.   When I add/remove a row in/from the spreadsheet, my total
>>> "SUM()" formula is updated automagically.
>>>
>>> Does the equivalent feature exist in Excel?  What I've found is, when
>>> adding rows *after* the last row in my SUM() formula, the new row is
>>> excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
>>> Once I add row 28, I need the SUM() formula to be updated to
>>> "=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
>>> formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
>>> reference when new rows are inserted/" feature does this work for me.
>>>
>>> I did some web searching and found this article:
>>>
>>> https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html
>>>
>>>
>>> but I hope to find an easier and more flexible way to accomplish what I
>>> need.  Or is that approach what I really should use?
>>>
>>> Thanks in advance!
>>>
>>> Peace...
>>>
>>> "The Other" Tom
>>>
>>>
>> Nevermind!  I found this:
>>
>> https://bettersolutions.com/excel/formulas/automatic-expansion.htm
>>
>> That should do what I need!
>>
>> Thanks anyway!  :)
>>
>> Peace...
>>
>> "The Other" Tom
>>
> When i was reading above, i thought you were search for subtotals.
>
> Excel has also a function named SUBTOTAL()
>
> https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939
>
>
>
>
>
Thanks for the info!  Sorry I wasn't more clear.  :(   I just needed the
SUM formulas to update as I added/deleted rows.  :)

Peace...

"The Other" Tom

-- 
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

-- 
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 needed with Excel spreadsheet

[Tom Davies]

Hi :)
Sounds like a perfect time to suggest they install LO too.

If an Excel person hadn't immediately found what they were looking for in
Calc they would have immediately claimed that Calc couldn't do the task.

There are loads of articles about LO that have such posts in the comments
section.  It can be fun to refute them in as few words as possible.
Regards from a Tom :)


On Wed, 6 Mar 2019 18:21 Luuk 
> On 6-3-2019 17:48, Tom Williams wrote:
> > On 3/6/19 8:26 AM, Tom Williams wrote:
> >> I know it's odd to ask for Excel help in this mailing list but I need
> >> help locating a LibreOffice Calc function/feature in Excel.  :)
> >>
> >> I'm helping a friend create a billing invoice and since I'm a Linux
> >> user, I'm using Calc to build the template.  So far, it's working well
> >> and given I'm not an Excel user, I find myself struggling some in
> >> getting Excel to "behave".  Anyway, I recently discovered the "/Expand
> >> reference when new rows are inserted/" in Calc.  It does exactly what I
> >> needed.   When I add/remove a row in/from the spreadsheet, my total
> >> "SUM()" formula is updated automagically.
> >>
> >> Does the equivalent feature exist in Excel?  What I've found is, when
> >> adding rows *after* the last row in my SUM() formula, the new row is
> >> excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
> >> Once I add row 28, I need the SUM() formula to be updated to
> >> "=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
> >> formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
> >> reference when new rows are inserted/" feature does this work for me.
> >>
> >> I did some web searching and found this article:
> >>
> >>
> https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html
> >>
> >> but I hope to find an easier and more flexible way to accomplish what I
> >> need.  Or is that approach what I really should use?
> >>
> >> Thanks in advance!
> >>
> >> Peace...
> >>
> >> "The Other" Tom
> >>
> >>
> > Nevermind!  I found this:
> >
> > https://bettersolutions.com/excel/formulas/automatic-expansion.htm
> >
> > That should do what I need!
> >
> > Thanks anyway!  :)
> >
> > Peace...
> >
> > "The Other" Tom
> >
> When i was reading above, i thought you were search for subtotals.
>
> Excel has also a function named SUBTOTAL()
>
>
> https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939
>
>
>
>
> --
> 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] Help needed with Excel spreadsheet

[Luuk]

On 6-3-2019 17:48, Tom Williams wrote:

On 3/6/19 8:26 AM, Tom Williams wrote:

I know it's odd to ask for Excel help in this mailing list but I need
help locating a LibreOffice Calc function/feature in Excel.  :)

I'm helping a friend create a billing invoice and since I'm a Linux
user, I'm using Calc to build the template.  So far, it's working well
and given I'm not an Excel user, I find myself struggling some in
getting Excel to "behave".  Anyway, I recently discovered the "/Expand
reference when new rows are inserted/" in Calc.  It does exactly what I
needed.   When I add/remove a row in/from the spreadsheet, my total
"SUM()" formula is updated automagically.

Does the equivalent feature exist in Excel?  What I've found is, when
adding rows *after* the last row in my SUM() formula, the new row is
excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
Once I add row 28, I need the SUM() formula to be updated to
"=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
reference when new rows are inserted/" feature does this work for me.

I did some web searching and found this article:

https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html

but I hope to find an easier and more flexible way to accomplish what I
need.  Or is that approach what I really should use?

Thanks in advance!

Peace...

"The Other" Tom



Nevermind!  I found this:

https://bettersolutions.com/excel/formulas/automatic-expansion.htm

That should do what I need!

Thanks anyway!  :)

Peace...

"The Other" Tom


When i was reading above, i thought you were search for subtotals.

Excel has also a function named SUBTOTAL()

https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939




--
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 files bad link

[Paul D. Mirowsky]

Sorry about that.

Windows 7 Professional Service Pack 1 (64 Bit)

There are files in:

    C:\Program Files\LibreOffice" which are the default for 64 bit 
programs.


    and

    C:\Program Files\LibreOffice\help\en-US


In 

    LibreOffice 6.1.5.2

    LibreOffice 6.1 Help Pack (English (United States))



On 3/6/2019 8:51 AM, Tanstaafl wrote:

That didn't answer the question...

Do you have the 32bit or 64bit version of the application and/or Help
installed?

Look in the Programs and Features control panel to see what versions are
installed.

On Tue Mar 05 2019 10:50:22 GMT-0500 (Eastern Standard Time), Paul D.
Mirowsky  wrote:

Sort of.

      C:\Program Files (x86)\LibreOffice 4

      C:\Program Files (x86)\LibreOffice 5

          Are both empty.

C:\Program Files\LibreOffice\help

          Is not and "C:\Program
Files\LibreOffice\help\en-US\text\swriter" has HTML files.

When  on "main.html" results on Firefox URL
"file:///C:/Program%20Files/LibreOffice/help/en-US/text/swriter/main.html"
and displays correctly in browser.

Paul




--
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 needed with Excel spreadsheet

[Tom Williams]

On 3/6/19 8:26 AM, Tom Williams wrote:
> I know it's odd to ask for Excel help in this mailing list but I need
> help locating a LibreOffice Calc function/feature in Excel.  :)
>
> I'm helping a friend create a billing invoice and since I'm a Linux
> user, I'm using Calc to build the template.  So far, it's working well
> and given I'm not an Excel user, I find myself struggling some in
> getting Excel to "behave".  Anyway, I recently discovered the "/Expand
> reference when new rows are inserted/" in Calc.  It does exactly what I
> needed.   When I add/remove a row in/from the spreadsheet, my total
> "SUM()" formula is updated automagically.
>
> Does the equivalent feature exist in Excel?  What I've found is, when
> adding rows *after* the last row in my SUM() formula, the new row is
> excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)". 
> Once I add row 28, I need the SUM() formula to be updated to
> "=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
> formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
> reference when new rows are inserted/" feature does this work for me.
>
> I did some web searching and found this article:
>
> https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html
>
> but I hope to find an easier and more flexible way to accomplish what I
> need.  Or is that approach what I really should use?
>
> Thanks in advance!
>
> Peace...
>
> "The Other" Tom
>
>
Nevermind!  I found this: 

https://bettersolutions.com/excel/formulas/automatic-expansion.htm

That should do what I need!  

Thanks anyway!  :)

Peace...

"The Other" Tom

-- 
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

-- 
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 files bad link

[Tanstaafl]

That didn't answer the question...

Do you have the 32bit or 64bit version of the application and/or Help
installed?

Look in the Programs and Features control panel to see what versions are
installed.

On Tue Mar 05 2019 10:50:22 GMT-0500 (Eastern Standard Time), Paul D.
Mirowsky  wrote:
> Sort of.
> 
>      C:\Program Files (x86)\LibreOffice 4
> 
>      C:\Program Files (x86)\LibreOffice 5
> 
>          Are both empty.
> 
> C:\Program Files\LibreOffice\help
> 
>          Is not and "C:\Program 
> Files\LibreOffice\help\en-US\text\swriter" has HTML files.
> 
> When  on "main.html" results on Firefox URL 
> "file:///C:/Program%20Files/LibreOffice/help/en-US/text/swriter/main.html"
>  
> and displays correctly in browser.
> 
> Paul


-- 
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 files bad link

[Paul D. Mirowsky]

I checked this and all fields seem appropriate.

I used the [Reset] button, but still results in Browser at 
"file:///C:/Users/paul/AppData/Local/Temp/lu109605km9jx.tmp/NewHelp1.html".


Paul

On 3/5/2019 10:46 AM, Graham Luffrum wrote:

Some years ago I had the same problem as you using LibreOffice on Windows.
It was solved by checking that the user interface language (Tools ->
Language settings -> User interface) was the same of that of the Help file
that you installed.

As an aside this problem doesn't arise under Linux as both the user
interface and the help are installed separately and will automatically have
the same language.  This is not the case with the Windows version and hence
someone not in the know can install LibreOffice in say the UK and
automatically have the user interface set to UK English.  If then the help
file for say US English is installed it will not be available.

Graham


On Tue, 5 Mar 2019 at 16:05, Paul D. Mirowsky 
wrote:


Have now tried...



[Toolbars]Search "Help" which results in

 Get Help Online
 Helplines While Moving
 LibreOffice Help

Selecting "LibreOffice Help"

Selecting {Defaults} and said {Yes}.

Results in Firefox tab with text "Help Page Redirection" at URL
"file:///C:/Users/paul/AppData/Local/Temp/lu78445i2amn.tmp/NewHelp1.html"

I'm am not sure of the context of the {Defaults} button, but am assuming
it does not mean correcting the URL because it doesn't.

Bueller?,   Bueller?, Bueller?,   Bueller?



On 3/1/2019 11:39 AM, Paul D. Mirowsky wrote:

I have removed and re-installed
"LibreOffice_6.1.5_Win_x64_helppack_en-US.msi".

But when I use  , it sends me to my browser at


"file:///C:/Users/paul/AppData/Local/Temp/lu791214dve3.tmp/NewHelp2.html".

Any ideas on how to fix this.

Help does not show up in "Options - LibreOffice - Paths".  Maybe it
should.

Thanks

Paul




--
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] Help files bad link

[Paul D. Mirowsky]

Sort of.

    C:\Program Files (x86)\LibreOffice 4

    C:\Program Files (x86)\LibreOffice 5

        Are both empty.

C:\Program Files\LibreOffice\help

        Is not and "C:\Program 
Files\LibreOffice\help\en-US\text\swriter" has HTML files.


When  on "main.html" results on Firefox URL 
"file:///C:/Program%20Files/LibreOffice/help/en-US/text/swriter/main.html" 
and displays correctly in browser.


Paul


On 3/5/2019 10:36 AM, Tanstaafl wrote:

Is it possible you have mix of 64 bit application and 32 bit Help (or
vice versa)?

On Tue Mar 05 2019 10:03:45 GMT-0500 (Eastern Standard Time), Paul D.
Mirowsky  wrote:

Have now tried...



[Toolbars]        Search "Help" which results in

 Get Help Online
 Helplines While Moving
 LibreOffice Help

Selecting "LibreOffice Help"

Selecting {Defaults} and said {Yes}.

Results in Firefox tab with text "Help Page Redirection" at URL
"file:///C:/Users/paul/AppData/Local/Temp/lu78445i2amn.tmp/NewHelp1.html"

I'm am not sure of the context of the {Defaults} button, but am assuming
it does not mean correcting the URL because it doesn't.

Bueller?,   Bueller?, Bueller?,   Bueller?



On 3/1/2019 11:39 AM, Paul D. Mirowsky wrote:

I have removed and re-installed
"LibreOffice_6.1.5_Win_x64_helppack_en-US.msi".

But when I use  , it sends me to my browser at
"file:///C:/Users/paul/AppData/Local/Temp/lu791214dve3.tmp/NewHelp2.html".

Any ideas on how to fix this.

Help does not show up in "Options - LibreOffice - Paths".  Maybe it
should.

Thanks

Paul







--
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 files bad link

[Graham Luffrum]

Some years ago I had the same problem as you using LibreOffice on Windows.
It was solved by checking that the user interface language (Tools ->
Language settings -> User interface) was the same of that of the Help file
that you installed.

As an aside this problem doesn't arise under Linux as both the user
interface and the help are installed separately and will automatically have
the same language.  This is not the case with the Windows version and hence
someone not in the know can install LibreOffice in say the UK and
automatically have the user interface set to UK English.  If then the help
file for say US English is installed it will not be available.

Graham


On Tue, 5 Mar 2019 at 16:05, Paul D. Mirowsky 
wrote:

> Have now tried...
>
> 
>
> [Toolbars]Search "Help" which results in
>
> Get Help Online
> Helplines While Moving
> LibreOffice Help
>
> Selecting "LibreOffice Help"
>
> Selecting {Defaults} and said {Yes}.
>
> Results in Firefox tab with text "Help Page Redirection" at URL
> "file:///C:/Users/paul/AppData/Local/Temp/lu78445i2amn.tmp/NewHelp1.html"
>
> I'm am not sure of the context of the {Defaults} button, but am assuming
> it does not mean correcting the URL because it doesn't.
>
> Bueller?,   Bueller?, Bueller?,   Bueller?
>
>
>
> On 3/1/2019 11:39 AM, Paul D. Mirowsky wrote:
> > I have removed and re-installed
> > "LibreOffice_6.1.5_Win_x64_helppack_en-US.msi".
> >
> > But when I use  , it sends me to my browser at
> >
> "file:///C:/Users/paul/AppData/Local/Temp/lu791214dve3.tmp/NewHelp2.html".
> >
> > Any ideas on how to fix this.
> >
> > Help does not show up in "Options - LibreOffice - Paths".  Maybe it
> > should.
> >
> > Thanks
> >
> > Paul
> >
> >
> >
>
> --
> 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] Help files bad link

[Tanstaafl]

Is it possible you have mix of 64 bit application and 32 bit Help (or
vice versa)?

On Tue Mar 05 2019 10:03:45 GMT-0500 (Eastern Standard Time), Paul D.
Mirowsky  wrote:
> Have now tried...
>
> 
>
> [Toolbars]        Search "Help" which results in
>
> Get Help Online
> Helplines While Moving
> LibreOffice Help
>
> Selecting "LibreOffice Help"
>
> Selecting {Defaults} and said {Yes}.
>
> Results in Firefox tab with text "Help Page Redirection" at URL 
> "file:///C:/Users/paul/AppData/Local/Temp/lu78445i2amn.tmp/NewHelp1.html"
>
> I'm am not sure of the context of the {Defaults} button, but am assuming 
> it does not mean correcting the URL because it doesn't.
>
> Bueller?,   Bueller?, Bueller?,   Bueller?
>
>
>
> On 3/1/2019 11:39 AM, Paul D. Mirowsky wrote:
>> I have removed and re-installed 
>> "LibreOffice_6.1.5_Win_x64_helppack_en-US.msi".
>>
>> But when I use  , it sends me to my browser at 
>> "file:///C:/Users/paul/AppData/Local/Temp/lu791214dve3.tmp/NewHelp2.html".
>>
>> Any ideas on how to fix this.
>>
>> Help does not show up in "Options - LibreOffice - Paths".  Maybe it 
>> should.
>>
>> Thanks
>>
>> Paul
>>
>>
>>


-- 
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 files bad link

[Paul D. Mirowsky]

Have now tried...



[Toolbars]        Search "Help" which results in

   Get Help Online
   Helplines While Moving
   LibreOffice Help

Selecting "LibreOffice Help"

Selecting {Defaults} and said {Yes}.

Results in Firefox tab with text "Help Page Redirection" at URL 
"file:///C:/Users/paul/AppData/Local/Temp/lu78445i2amn.tmp/NewHelp1.html"


I'm am not sure of the context of the {Defaults} button, but am assuming 
it does not mean correcting the URL because it doesn't.


Bueller?,   Bueller?, Bueller?,   Bueller?



On 3/1/2019 11:39 AM, Paul D. Mirowsky wrote:
I have removed and re-installed 
"LibreOffice_6.1.5_Win_x64_helppack_en-US.msi".


But when I use  , it sends me to my browser at 
"file:///C:/Users/paul/AppData/Local/Temp/lu791214dve3.tmp/NewHelp2.html".


Any ideas on how to fix this.

Help does not show up in "Options - LibreOffice - Paths".  Maybe it 
should.


Thanks

Paul





--
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 regarding LibOfficeBase/Firebird

[Robert Großkopf]

Hi Pertti,

> 
> I have some old database-projects that I (very nicely) have built on
> MSAccess2003 and want now to rebuild them onto LO-Base.
> One of them has three tables (a main form and two subforms with about a
> hundred records by 15-25 cols each) that I now have successfully
> ‘transformed’ via MSExcel to LO-Calc files.
> My goal now is to get these 400 records to three LOBase tables with a
> maximum of ease (the new registered database has been created – but no
> tables yet!).

You don't need to register a database if you want to use the database
standalone, for example without using form-letters.
> 
> Now some questions to a LO-Base expert out there somewhere (I think the
> answers can be of interest to other LOBase-dummies like me!)
> 1 >>I have noticed that the embedded engine HSQLDB has been replaced
> with Firebird
>     >>can I still work with LOBase as a frontend the same way as before?

There is no problem to create a new database as internal HSQLDB or
internal Firebird database. HSQLDB will be replaced in the future, but
there is a migration wizard that should do most of work here.

I would start with a Firebird database at this moment, because a
Firebird database will be the standard in future, offers some
interisting functions and doesn't need so much memory than a
HSQLDB-database.
> If not, why not?
>     >>which are the main differences to be considered (e.g. regarding
> form- and report properties like with list-/comboboxes, reports etc)

Forms and reports will work the same way with both engines. I have just
migrated an example-database for the Base-Handbook. Works the same way,
but I had to change some queries before converting, because HSQLDB uses
some functions with different labels. For example: Firebird can't use
IFNULL, but HSQLDB and Firebird both work with COALESCE, which will work
the same way.
>                 with Firebird vs HSQLDB
>     >>where can I find fresh instructions (or tutorial) for LOBase (and
> if available for LOBase/Firebird)

I have written a Base-Handbook in German. At this moment it will be
translated into English.
The German developement-version for LO 6.2 you could find here:
http://robert.familiegrosskopf.de/index.php
Older translations in English I have uploaded here:
http://robert.familiegrosskopf.de/lo_hb_en/
but the translation for each chapter hasn't been finished ...

> 2 >>as said the MSAccess table’s data are now saved as LOCalc-files.
> I have learned how to export a LOBase table to a LOCalc file
> (registered) – but I can not find how to do the reverse:
>     >>how do I import a LOCalc file’s data to a (registered) LOBase
> table, or in other words, get the data (with or not it’s structures)
> from a LOCalc file into                 a LOBase table?

You could copy the content of one table and paste it in Base. The
table-wizard will help you to get a table with the content. Note: Tables
must have a primary-key. If you have 3 tables, which have been
connected, you will have a primary-key. It is a little bit hidden in the
wizard where to mark the field for the primary-key. The screenshots in
the Handbook will help here.

> 3 >>        (Brian please, once more) what is the formula to calculate
> (now in a LOBase/Firebird form or query) a person's age out of her birth
> date?

DATEDIFF('year', "birthdate", CURRENT_DATE)
will be the version for HSQLDB.
DATEDIFF(year, "birthdate", CURRENT_DATE)
will be the version for Firebird.
But note: This isn't the right age for every person. Will be only right
at the last day of December. So the code must be changed. This is also
written down in the Handbook, chapter 8 (Tasks).

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


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

Congrats!! Re: [libreoffice-users] Help! Can't delete floating frame!

[Tom Davies]

Hi :)
Congrats!!  Nicely done! :)))

You don't need to add a floating frame, or any frame at all.  Just drag the
image onto the page and position it.  If you right-click on the image you
get choices such as;
* add border
* add caption
* anchor to paragraph or
* anchor to page
along with various "wrap" options to make the writing flow around the
image, or through the image, or give it a lot of space.

Sorry this is so late!
Good luck, congrats and regards from
a Tom :)




On Tue, 16 Oct 2018 at 00:15, John Jason Jordan  wrote:

> On Mon, 15 Oct 2018 15:44:09 -0700
> John Jason Jordan  dijo:
>
> >And the paper I'm working on is due tomorrow!
> >
> >I wanted to add a picture (it's a .png file) so I selected Insert >
> >Floating Frame, gave it a name, and there it was. Then I added my .png
> >file to it, whereupon I realized that I needed to edit the .png file
> >first, plus the floating frame was in the wrong location. I have spent
> >the past hour trying to delete the floating frame, but can't figure out
> >how. It is completely grayed out and I can't figure out how to select
> >it.
>
> Never mind. I stumbled on the answer - you can only select it by
> clicking precisely on the edge, and I mean *precisely*.
>
> --
> 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] Help! Can't delete floating frame!

[Remy Gauthier]

Hi,

n the Drwing toolbar, there is a select tool (white arrow). Select that
and draw a selection area around your floating frame (click-drag). This
should select the frame; at that point, hit "Delete".

I hope this helps.

Rémy.
Le lundi 15 octobre 2018 à 15:44 -0700, John Jason Jordan a écrit :
> And the paper I'm working on is due tomorrow!
> 
> I wanted to add a picture (it's a .png file) so I selected Insert >
> Floating Frame, gave it a name, and there it was. Then I added my .png
> file to it, whereupon I realized that I needed to edit the .png file
> first, plus the floating frame was in the wrong location. I have spent
> the past hour trying to delete the floating frame, but can't figure out
> how. It is completely grayed out and I can't figure out how to select
> it. 
> 
> Oh, this is LO Writer 5.1.6.2 on Ubuntu 16.04, all updates applied.
> 
-- 
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! Can't delete floating frame!

[John Jason Jordan]

On Mon, 15 Oct 2018 15:44:09 -0700
John Jason Jordan  dijo:

>And the paper I'm working on is due tomorrow!
>
>I wanted to add a picture (it's a .png file) so I selected Insert >
>Floating Frame, gave it a name, and there it was. Then I added my .png
>file to it, whereupon I realized that I needed to edit the .png file
>first, plus the floating frame was in the wrong location. I have spent
>the past hour trying to delete the floating frame, but can't figure out
>how. It is completely grayed out and I can't figure out how to select
>it. 

Never mind. I stumbled on the answer - you can only select it by
clicking precisely on the edge, and I mean *precisely*. 

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

[John R. Sowden]

Hope this helps:

I have a general Ledger spreadsheet.  1 of the pages is a chart of accounts:

COL A   COL B

1234 (Account Number) Rent (Account Name)

Another page is cash account data entry:

Account _ Data entry (must match the entry in the chart page)

ACCT NAME (formula below)

=if(M39="","",VLOOKUP(M39,$CHART.$A$9:$B114,2))

the if function checks to see if there is an entry in the acct number 
cell.  if not, the acct name stays blank


the lookup checks the data entry cell, then looks on the CHART page from 
A1 to B114 (both columns)


I have 114 GL accounts.

John



On 08/01/2018 04:45 AM, Budge wrote:

On 01/08/2018 12:37, Budge wrote:

Ashamed to ask but cannot get VLOOKUP to work.

I am trying to look up the value in column A in sheet 1 in sheet 2 
column 1 and insert the value found in column 10 in sheet 1. Neither 
sheets are sorted.


=VLOOKUP(A2,'Bookings_Between_Apr_to Jun_2018_data'.$A2:$L64,10,0)

As I understand things 'Bookings_Between_Apr_to 
Jun_2018_data'.$A2:$L64 is supposed to define the array in which to 
search and I thought the $ signs fixed the range but no, when I copy 
the formula down the page the array changes.


Where am I going wrong please?
Budge



I think I have it.  Should have been:-

=VLOOKUP(A2,'Bookings_Between_Apr_to Jun_2018_data'.$A$2:$L$64,10,0)

Please forgive false alarm
Budge.

---
This email has been checked for viruses by AVG.
https://www.avg.com





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

[Budge]

On 01/08/2018 12:37, Budge wrote:

Ashamed to ask but cannot get VLOOKUP to work.

I am trying to look up the value in column A in sheet 1 in sheet 2 
column 1 and insert the value found in column 10 in sheet 1.  Neither 
sheets are sorted.


=VLOOKUP(A2,'Bookings_Between_Apr_to Jun_2018_data'.$A2:$L64,10,0)

As I understand things 'Bookings_Between_Apr_to Jun_2018_data'.$A2:$L64 
is supposed to define the array in which to search and I thought the $ 
signs fixed the range but no, when I copy the formula down the page the 
array changes.


Where am I going wrong please?
Budge



I think I have it.  Should have been:-

=VLOOKUP(A2,'Bookings_Between_Apr_to Jun_2018_data'.$A$2:$L$64,10,0)

Please forgive false alarm
Budge.

---
This email has been checked for viruses by AVG.
https://www.avg.com


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

[MR ZenWiz]

On Sat, Dec 23, 2017 at 3:07 PM, Tim-L  wrote:
:
> Try Format > Page > Area > Bitmap.
>
> You have to add your background image to the list of bitmaps shown on the
> left side.  The only problem, for me, is getting the image options the way I
> want it to look on the page. I use this a lot for making posters for events
> - both Letter size, Tabloid [11"x17"] size paper printed "in-house".
>
> Does this help?
>
I found it.  It's not hard to find.

My complaint is about the help function not having the right information.

What kind of help is that?  (Big hint: NOT.)

Thanks.

MR

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help hopeless

[Tim-L]

On 12/23/2017 05:54 PM, MR ZenWiz wrote:

I've noticed over the last several releases that the help provided via
the main menu bar is hopelessly inaccurate.

E.g., today I wanted to set up a document with an image as the
background.  The help search returned a section of backgrounds ->
colors/images and it says to click on Format -> Page and select the
Backgrounds tab.  There isn't one.  There is a Colors tab, but it's
not clear what that really means.

There have been other such inaccuracies I've seen in the past, though
in my haste I've never documented them but just plowed ahead and
blundered through.

In a professional production, help menus should match the actual
features of the application.  LibreOffice can (and should) do better.

MR


Try Format > Page > Area > Bitmap.

You have to add your background image to the list of bitmaps shown on 
the left side.  The only problem, for me, is getting the image options 
the way I want it to look on the page. I use this a lot for making 
posters for events - both Letter size, Tabloid [11"x17"] size paper 
printed "in-house".


Does this help?


--
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with Mail Merge

[Luca Daghino @ Libero]

Il 29/08/2017 10:10, alice.gio ha scritto:

Hi everybody!

I have a problem with mail merge on Libre office 5.3 installed on Ubuntu
16.04.

Once I inserted every field, the function I can't perform Merge Mail on a
selected record. I tried on other PC and it appear the option .
I disinstalled and reinstalled all the Libre Office package but the same
problems persist.

Thanks for help
Alice



--
View this message in context: 
http://nabble.documentfoundation.org/Help-with-Mail-Merge-tp4221646.html
Sent from the Users mailing list archive at Nabble.com.


Hello Alice,

Maybe you could try using a different version of 5.3; right today the 
5.3.6 has been released.


If that doesn't work... could you describe better your problem? Is there 
a non active button?


And... supposing you're italian... there's also an italian users' 
support list that you can subscribe to:


https://wiki.documentfoundation.org/Local_Mailing_Lists#Italian

Byebye Luca


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with Mail Merge

[Remy Gauthier]

Hello,

Sorry for the long response time, I only really saw your message today.
When I do mail merges, I use the "Data Sources" available from the View
menu (Ctrl+Shift+F4) to select my data source and filter what I want to
use for the merge, and then to activate the mailing wizard (the button
looks like 3 stacked envelopes and is the third one from the right). Is
this what you are trying to use or is it something else?

Maybe it's the button for the basic mail merge that is missing in that
version? Then you can add it from the Tools -> Customize -> Add a
command, and then you can find the Mailing Button in the category
"Document". One you have the button, you can place it on a tool bar and
use it from there. Not sure anymore what the differences are between
the two, but I remember trying both and finding the one available via
the Data Sources to be more flexible and perhaps easier to use.

I hope this helps.

Regards,

Rémy Gauthier.

Le mardi 29 août 2017 à 01:10 -0700, alice.gio a écrit :
> Hi everybody!
> 
> > I have a problem with mail merge on Libre office 5.3 installed on
Ubuntu
> 16.04.
> 
> > Once I inserted every field, the function I can't perform Merge Mail
on a
> selected record. I tried on other PC and it appear the option .
> > I disinstalled and reinstalled all the Libre Office package but the
same
> problems persist.
> 
> Thanks for help 
> Alice
> 
> 
> 
> --
> > View this message in context: http://nabble.documentfoundation.org/He
lp-with-Mail-Merge-tp4221646.html
> Sent from the Users mailing list archive at Nabble.com.
> 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] HELP !!!

[Regina Henschel]

Hi Sergio,

Sergio Gutierrez schrieb:

Can anybody please how can I unsubscribe from this newslwtter (Libre
Office)?
I have tried just about everything I know, but it keeps coming.
Any help appreciated.



The footer of every mail contains the information. Here for you, in case 
you cannot view the footer:


To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? 
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be 
deleted


Kind regards
Regina

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] help note icons broken

[Regina Henschel]

Hi Carlo,

Carlo Strata, tiscali.it schrieb:

Ho Everyone,

I just install LibreOffice 5.3.5.2 win64 - from the usual prerelases directory  
- with the associated italian help pack and I see that the note icons in the 
help pages are all broken.

I don't know if it is a problem of all platform.


In LO 6 I get the icons.



What do you think about?



In the help click on the placeholder so that is gets green handles. Copy 
it to clipboard by shortcut key Ctrl+C. Paste it in a Writer document. 
Open its property dialog and look at the tab "Image", what you see in 
the field "Link". For me it is 
vnd.libreoffice.image://helpimg/media/helpimg/note.png


That means, that LO is looking for the image in a file images_helpimg.zip.

For an older version it might be
vnd.libreoffice.image://tango/res/helpimg/note.png

Then LO would look for the icon in a images_tango.zip file.

Then goto the installation folder, then to subfolder "share" and therein 
subfolder "config". Do you see such file? If it is not there, then there 
has been an error in packing and you should write a bug report.


Images, which are only used in the help, were removed from the 
icon-themes and put into its own file.


To get your icons, download a developer version, which has language 
support, install it and copy the file into your productive LO version.


Or..  The file is only 575KB. So if you drop me a note, I can email you 
the file directly.


Kind regards
Regina






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with VLOOKUP requested

[Jean-Francois Nifenecker]

Budge,

Le 21/07/2017 à 12:15, Budge a écrit :

I have a formula VLOOKUP(E2,Sheet2.A2:B690,2,0) in cell J2 which fills
in J2 with the value corresponding to the number in E2 which is looked
up from a table in sheet2.

My problem is that when I copy this formula down column J the E2 changes
to E3 which is correct, but the table defined by Sheet2.A2:B690, which
should be fixed, has the addresses changed also.

How may I fix the lookup table when I copy the file down a column please?


Add "$" symbols where it pertains.

In your case, your formula should look like:
VLOOKUP(E2,Sheet2.$A$2:$B$690,2,0)

Note that, when entering a formula, the F4 key (newer versions of LO) or 
Shift+F4 combination (older versions) could help.


HTH,
--
Jean-Francois Nifenecker, Bordeaux


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help please with VLOOKUP formula

[Budge]

On 21/07/17 11:32, Budge wrote:
I am using a formula to fill in a cell.  The formula is in cell J2 
=VLOOKUP(E2,Sheet2.A2:B690,2,0).


This is looks up the value from E2 in the column 1 of the table on sheet 
2 defined by corners A2:B690, takes the corresponding value from column 
2 of the table and enters it into cell J2.


I want to repeat this formula down the column J but when I copy, not 
only does the reference cell change ie E2 becomes E3 which is correct, 
but the table cell definition also changes, which is not correct.


How should I write the formula to have the table fixed whilst lookup 
cell changes please?



Sorry, I have it now.  Forgot the .
Duh.

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] HELP ME!!!

[Mark LaPierre]

On 02/21/17 13:33, Bernardo Santos wrote:
>  
> 
> I have many documents, i need to know how i make block this document.
> Because when I save to TYPE: DOCUMENT TEXT (.ODT), I do modification so the
> Security isnt works.
> 
> 
> Bernardo De Js Santos J.
> 
> T.I -  Development 
> 
> Tel.: 809-226- ext. 352, 3004
> 
>   sant...@banfondesa.net
> 
>   www.banfondesa.com.do
> 

Hey Bernardo,

I don't understand what your problem is.  Please explain further.

Are you trying to rename a batch of files?

Are you trying to save a series of files using similar names?

Are you trying to make a file read only so that you don't overwrite it?

What operation system are you using on your computer?


-- 
_
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with LO Forms

[Robert Großkopf]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Ian,
> 
> But I'm confused. The Handbook says Calc can be used as the
> datasource for a Form in Writer.

Don't know which Handbook you mean. The Handbook Base says:

- -
Calc or Excel spreadsheets can also be used as the table source for
databases. If, however, a Calc spreadsheet is used, no editing of the
table data will be possible.
- -

Could be the translation from German to English isn't clear enough,
but I haven't written anywhere in German Base-Handbuch you could use a
spreadsheet for data-input in Base or by a form in Writer.
> 
> Everyone else wants me to use Base but I'm NOT interested in this
> at all as I battled with it for 7 years and could never get a
> stable set-up. It crashed frequently and usually took all the data
> with it or 'gabbled' the data - so you spend more time with back
> ups and patching damaged data records. I can not let the end user
> have such an unstable program to work with. I hoped the Calc/Writer
> Form would prove more reliable.

I have created many databases, also with the internal HSQLDB. While
creating reports I got some troubles, but the users seem to have no
troubles for a long time with these databases.

For professional use I would prefer an external database like MySQL,
connected with Base.

You could use an external database also. If a spreadsheet will save
the data you need, a dBase-file will do this also.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJYp/xAAAoJELDKYwaoS9AIf2gQAJee+AvureGqHCUTuf3dSimV
JihXMdpl5JIAR1AGZpxr2WY9M1BbUdK7CvrqLVDdeT73U31McDvS7xwJx10AVomb
TOoVcP3w/WWrb3TgyLB/jARtl9u4H6PCwilYN/UgiDN4xi/0cs9hvfiffdyoaDBl
B75CL4eFE1xR6HlHmpwiUUXgmKy+6yCUjFRldwYemyky9M80QZrHglBCbBopUDmF
FKVSdvuNvMzvk3rcy5NlnEcpsY8CNI3L4HKV/vqZStFuwhjME2JuEcm7LUx0ZYP0
WGoWRP5pFGRifEKx3Wu6ZFZkKorBWkYaryfPLs+y4Gzi1k7n5QJnEjoUFn88IFXC
/8yK6lshY8pGvlyg4N4rqEKonpZLmgLZ09PSvFPbvNHxAzkL81LgtWnRwfZ2g9T/
8KlGls1piGD6EKRblQjTEIILNhbWZ/oA0pGjKM+RzOwWsbfweTghdgGZYM4kFr9V
Kh73XiqT6wlKJb13HO5OnBfm97k4zb64NZvt7ejeVhbK5YaYeciBGCIYOiTrV6cA
CW9TK5avKghaEI2mqA3mib+kqkU3kiOhMVtPeY8ezRl3HMf7I8Jf3/4ra/G55vWY
3Whp0PUdSeo+A1sac2UBza9RzDUqFE3HFGiNe3ij5otP/eKanUPZ/aBWp5603BX5
Jg8o6TU3A5e0h7aYXw8W
=OzvV
-END PGP SIGNATURE-

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with LO Forms

[Ian Whitfield]

Thanks Guys - Appreciated!!

But I'm confused. The Handbook says Calc can be used as the datasource 
for a Form in Writer.
But even Alexander's method still gives me no option to select the 
Registered Spreadsheet (The options box remains empty)!!


The other replies tell me Calc can _NOT_ do this (But the Handbook says 
it can!!??)


Everyone else wants me to use Base but I'm NOT interested in this at all 
as I battled with it for 7 years and could never get a stable set-up. It 
crashed frequently and usually took all the data with it or 'gabbled' 
the data - so you spend more time with back ups and patching damaged 
data records. I can not let the end user have such an unstable program 
to work with. I hoped the Calc/Writer Form would prove more reliable.


So if this can not work I'll have to move to Kexi which is rock solid,

With best regards

IanW
Pretoria RSA




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with LO Forms

[Paul D. Mirowsky]

Sorry, I wasn't being clear.

On the webpage at: 
https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base 
you  will find:


*Importing data to Base*
*You can import* text files, *spreadsheet files*, and your system 
address book in read-only mode only.
*When you import from a* text or*spreadsheet file, the file must have a 
first row of header information. The second row of the file is the first 
valid data row. The format of every field in the second row determines 
the format for the entire column. Any format information from a 
spreadsheet file gets lost when importing to Base.*
 For example, to ensure the first column has a text format, you 
must make sure that the first field of the first valid data row contains 
text. If a field in the first valid data row contains a number, the 
whole column is set to number format, and only numbers, no text, will be 
shown in that column.


*Open a Base file of the database type that you want.*
Either create a new Base file using the Database Wizard, or open 
any existing Base file that is not read-only.
*Open the Calc file that contains the data to be imported to Base*. You 
can open a *.dbf dBASE file or many other file types.

*Select the data to be copied to Base*.
You can enter a range reference like A1:X500 in the Name Box if you 
don't want to scroll.
If you copy a dBASE sheet, include the top row that contains the 
header data.

*Choose Edit - Copy*.
*In the Base window, click Tables to view the tables.**
**In the Base window, choose Edit - Paste.*
*You see the Copy Table dialog. Most databases need a primary key, so 
you may want to check the Create primary key box.**

*
On Windows systems, you can also use drag-and-drop instead of Copy 
and Paste. Also, for registered databases, you can open the datasource 
browser (press F4) instead of opening the Base window.




On 2/16/2017 12:00 PM, Paul D. Mirowsky wrote:
See 
https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base 
to do this.



On 2/16/2017 11:52 AM, Robert Großkopf wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Ian,

I have a Spreadsheet of Data and I have prepared a Form in Writer
to display and edit this information.

This won't work. You can't use a a table in Calc as a database and
edit this data in a form of the database or in a form of wirter.
Tables of a spreadsheet aren't editable in Base, You could only search
througt that data, filter them but can't change them.

Regards

Robert
- -- Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJYpdizAAoJELDKYwaoS9AIRwMP/0OTzyPPWqhhDGIMN14MSDCo
XdxFFXAfmA3SN8RjYLSRHKFqs3ldPO/Qv27Ui2B5+87638r7ZpQ93NpysS8u7Kmx
vmkAbADxUqJoe+6T1Cx10D20yhp5pVimLTYEJZlqrAEK/KkwIRef8hnalhKNNLOa
rrGWuXNaKug5R8EUjChkgdA8lOUNhLiZ59IjSmDsU6mULU6zildQqVxzfd5Am2TO
EaNXrIseTe7v3v93oDnQK1GrN9bPldMp112PxYySB0Qgpqh26S7Qus0QLp4K4EED
4soMG1A2L1FQXTpNdHO856WUaN8qnXPxdJ0mNBT9AeiK330XtHuEvczQ7sFwfVv4
B4yebHHPWXVuKPQbzCiZ7A1IrJdjmn1UW+ejTemLy4P4j3APEHObGxnC8c8ZfGvv
AqK63Ji59lZDQxBJEOnT3Woskk6kNuGOQWIjYwfDn0rtAqvt7Z3rq09VYLAEuO4G
Eg69LLYSC/h9aoUPdURC5w+/qXBTbw0jK+GC+NtX8UaGKpxwtj6S1HBRZ2aRioeV
oAdNFQEKRumtkoSAzPQbzHoAWd5Z+ZwoYcIo1j23v1p/QP1nEGwPks01LJiK7aO0
adAVjtn9k5oH4d4gtiJfAzk0pT2KaV/qlUoIgV0Im4lbAIgQrSUo8jdSDk/obZ0Y
spqFaDe4xoQWOv26EuFf
=EjGI
-END PGP SIGNATURE-







--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with LO Forms

[Robert Großkopf]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Paul,

Am 16.02.2017 um 18:00 schrieb Paul D. Mirowsky:
> See 
> https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Ba
se
>
> 
to do this.

This won't help. The Calc-file is the content of the database. Data
haven't been exported into Base or something else (Firebird ...). So
Ian has first to export the data- and I don't know if he doesn't need
the contact to Calc for the data any more.
> 
> 
> On 2/16/2017 11:52 AM, Robert Großkopf wrote: Hi Ian,
 I have a Spreadsheet of Data and I have prepared a Form in
 Writer to display and edit this information.
> This won't work. You can't use a a table in Calc as a database and 
> edit this data in a form of the database or in a form of wirter. 
> Tables of a spreadsheet aren't editable in Base, You could only
> search througt that data, filter them but can't change them.
> 
Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJYpd3WAAoJELDKYwaoS9AI9AIP/AygaL/668nXqJj/Oh74wlt+
J/5d9G106GcZODoWMxpP0HWhtvM1H0r29zEl1K666s4f2iXYWOoETpnVFzKSk0a6
UoLwe7cHkHtJxrderqja1I8mPTr/R8hoEvFz4MVgLgLyF5DT5DJk21pFBA0qUOmY
p/ARVjDnuIxBOZ51OMKB3SkJOHA3Jnpl2UkeUXcOdbxNkcr1EaaNQztfgtc5EqR5
Ec6a2Nic39iMApJa2e0gl4SiLnS+CbAchmNTfws0uvyWJ1K1tzVUWW9jZbvIUmBS
SHdPF3r4UvNC7pFdzRzWVtyneh2idh7nRa+BIMyTClBClr188S6i0bLpjlijqL/c
NNgC72KmqroFZpcNmas+3Sb84jZ9UQS4jYxJwsVY+1NxtLlW43elE2OYDqSPdQil
a7sQWzHQ9A2qpecTBIM2IEpZ7gP66IgF+RbK4H+B2WeJnerK8Ijhm9aY8CB11zCn
24HQlOUmNhX+OV7HybHlCZEBpmt4Qlg1oDM1KQ7neXIgfq/AcX827OQ2g0n3G1lR
eyNcFU5PMypDcCdPkX29CzzEHTRtcK7kkrzwrrWj1JVYLoKTr3ZipEqYG0jjlw5O
q8mXDFZpStDIMc4vMIf1ZzjdU93HrUc8bIfppr+oSMoa0kzeUKniyQdiW5ZVpRkK
jI0QvxU42K3cNxSPxjm7
=PlEm
-END PGP SIGNATURE-

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with LO Forms

[Paul D. Mirowsky]

See 
https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base 
to do this.



On 2/16/2017 11:52 AM, Robert Großkopf wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Ian,

I have a Spreadsheet of Data and I have prepared a Form in Writer
to display and edit this information.

This won't work. You can't use a a table in Calc as a database and
edit this data in a form of the database or in a form of wirter.
Tables of a spreadsheet aren't editable in Base, You could only search
througt that data, filter them but can't change them.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de

LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJYpdizAAoJELDKYwaoS9AIRwMP/0OTzyPPWqhhDGIMN14MSDCo
XdxFFXAfmA3SN8RjYLSRHKFqs3ldPO/Qv27Ui2B5+87638r7ZpQ93NpysS8u7Kmx
vmkAbADxUqJoe+6T1Cx10D20yhp5pVimLTYEJZlqrAEK/KkwIRef8hnalhKNNLOa
rrGWuXNaKug5R8EUjChkgdA8lOUNhLiZ59IjSmDsU6mULU6zildQqVxzfd5Am2TO
EaNXrIseTe7v3v93oDnQK1GrN9bPldMp112PxYySB0Qgpqh26S7Qus0QLp4K4EED
4soMG1A2L1FQXTpNdHO856WUaN8qnXPxdJ0mNBT9AeiK330XtHuEvczQ7sFwfVv4
B4yebHHPWXVuKPQbzCiZ7A1IrJdjmn1UW+ejTemLy4P4j3APEHObGxnC8c8ZfGvv
AqK63Ji59lZDQxBJEOnT3Woskk6kNuGOQWIjYwfDn0rtAqvt7Z3rq09VYLAEuO4G
Eg69LLYSC/h9aoUPdURC5w+/qXBTbw0jK+GC+NtX8UaGKpxwtj6S1HBRZ2aRioeV
oAdNFQEKRumtkoSAzPQbzHoAWd5Z+ZwoYcIo1j23v1p/QP1nEGwPks01LJiK7aO0
adAVjtn9k5oH4d4gtiJfAzk0pT2KaV/qlUoIgV0Im4lbAIgQrSUo8jdSDk/obZ0Y
spqFaDe4xoQWOv26EuFf
=EjGI
-END PGP SIGNATURE-




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with LO Forms

[Robert Großkopf]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Ian,
> 
> I have a Spreadsheet of Data and I have prepared a Form in Writer
> to display and edit this information.

This won't work. You can't use a a table in Calc as a database and
edit this data in a form of the database or in a form of wirter.
Tables of a spreadsheet aren't editable in Base, You could only search
througt that data, filter them but can't change them.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJYpdizAAoJELDKYwaoS9AIRwMP/0OTzyPPWqhhDGIMN14MSDCo
XdxFFXAfmA3SN8RjYLSRHKFqs3ldPO/Qv27Ui2B5+87638r7ZpQ93NpysS8u7Kmx
vmkAbADxUqJoe+6T1Cx10D20yhp5pVimLTYEJZlqrAEK/KkwIRef8hnalhKNNLOa
rrGWuXNaKug5R8EUjChkgdA8lOUNhLiZ59IjSmDsU6mULU6zildQqVxzfd5Am2TO
EaNXrIseTe7v3v93oDnQK1GrN9bPldMp112PxYySB0Qgpqh26S7Qus0QLp4K4EED
4soMG1A2L1FQXTpNdHO856WUaN8qnXPxdJ0mNBT9AeiK330XtHuEvczQ7sFwfVv4
B4yebHHPWXVuKPQbzCiZ7A1IrJdjmn1UW+ejTemLy4P4j3APEHObGxnC8c8ZfGvv
AqK63Ji59lZDQxBJEOnT3Woskk6kNuGOQWIjYwfDn0rtAqvt7Z3rq09VYLAEuO4G
Eg69LLYSC/h9aoUPdURC5w+/qXBTbw0jK+GC+NtX8UaGKpxwtj6S1HBRZ2aRioeV
oAdNFQEKRumtkoSAzPQbzHoAWd5Z+ZwoYcIo1j23v1p/QP1nEGwPks01LJiK7aO0
adAVjtn9k5oH4d4gtiJfAzk0pT2KaV/qlUoIgV0Im4lbAIgQrSUo8jdSDk/obZ0Y
spqFaDe4xoQWOv26EuFf
=EjGI
-END PGP SIGNATURE-

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] help with standard.soc file color defining

[toki]

On 02/13/2017 10:40 AM, hdv  wrote:

> You are correct concerning ase palettes. 
> However, the feature is not complete yet, because you have to add the
palettes by hand at the moment.

I just dumped my ASE palettes into /opt/Libreoffice5/share/palettes,
then tested it, by opening a file to change the colour of font.  It worked!

> See https://bugs.documentfoundation.org/show_bug.cgi?id=92354

Assuming permission to distribute can be obtained, it might
easier/simpler to distribute them using an extension --- perhaps the
same one as proposed for the .soc etc. files.

The "hard" part is knowing where that appropriate place is.

jonathon

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] help with standard.soc file color defining

[hdv]

On 2017-02-10 04:24, toki wrote:
> On 02/09/2017 07:49 PM, Tim---Kracked_P_P---webmaster wrote:
> 
>> I am having trouble adding the Resene color palette to the
>> "standard.soc" file.
> 
> Two different Resene Palettes can be found at
> https://groups.io/g/ODF_Templates/files/ColourPalettes .
> 
> 
> For some reason, I'm under the impression that LibO can utilize adobe
> *.ase palettes, but a quick search on the LibO site doesn't confirm it.
> I've got 45 *.ase palettes from Resene,

Hai Jonathon,

You are correct concerning ase palettes. Chris Laplante added this feature on
request of Philipp Weissenbacher about one and a half years ago (I sponsored
this feature through freedomsponsors.org back then). However, the feature is not
complete yet, because you have to add the palettes by hand at the moment.

See https://bugs.documentfoundation.org/show_bug.cgi?id=92354

Hopefully this can be finished sometime in the (near?) future.

Grx HdV


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] help with standard.soc file color defining

[Tim---Kracked_P_P---webmaster]

On 02/09/2017 10:24 PM, toki wrote:

On 02/09/2017 07:49 PM, Tim---Kracked_P_P---webmaster wrote:


I am having trouble adding the Resene color palette to the
"standard.soc" file.

Two different Resene Palettes can be found at
https://groups.io/g/ODF_Templates/files/ColourPalettes .


For some reason, I'm under the impression that LibO can utilize adobe
*.ase palettes, but a quick search on the LibO site doesn't confirm it.
I've got 45 *.ase palettes from Resene,

jonathon


I found the Resene color palette from a site that discussed color 
palettes.  Here is the site's URL.


http://people.csail.mit.edu/jaffer/Color/CSDR

The site has several different PDF files for the different color sorting 
options.


The link you provided at the "groups.io" requires a user/password to 
access the site.  So I do not know what they offer. The .soc file[s] I 
want to create will be offered at the LO Extension site as a .soc file.  
If someone knows how to create an extension that automatically installs 
the file in the proper config folder, please let me know.  Since I use 
Linux, I know where the the .soc files are located. It would be better 
to have extension do the work for you.


For those who look at the link I provided here, there are over 1300 
colors in the Renese palette.  There are other versions of there 
palette.  Renese colors is a paint palette.  I have an older PDF file 
that has a MIT.edu link to a Renese-2010 PDF file. The link I provided 
to the MIT side has several Renese files that are color sorted by 
different methods.  I like the following version.


http://swiss.csail.mit.edu/~jaffer/CSDR/resene-s.pdf

Thanks to Rémy Gauthier, I now have the Renese text file RGB color list 
to one that is a HEX version.  Now I just need to finish the needed 
parts of the .soc file, including the Renese copyright that must 
included with the color coding to make the .soc file.  After that, I 
will upload it to a folder and provide the link so others can test it on 
their systems.  Then, hopefully, I will place the .soc file with the LO 
Extension site.





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] help with standard.soc file color defining

[toki]

On 02/09/2017 07:49 PM, Tim---Kracked_P_P---webmaster wrote:

> I am having trouble adding the Resene color palette to the
> "standard.soc" file.

Two different Resene Palettes can be found at
https://groups.io/g/ODF_Templates/files/ColourPalettes .


For some reason, I'm under the impression that LibO can utilize adobe
*.ase palettes, but a quick search on the LibO site doesn't confirm it.
I've got 45 *.ase palettes from Resene,

jonathon


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] help with standard.soc file color defining

[Tim---Kracked_P_P---webmaster]

Does not help much.  There are over 1500 named colors in the text file.  
Actually Renese colors are actually their line of paint colors.  It was 
nice of Renese to share their colors as long as you add their copyright 
text in the .soc file "somewhere".




If anyone has a C++ or Python script that would do this, it would be 
nice.  I just do not remember how to do this in either language anymore.



On 02/09/2017 04:00 PM, Remy Gauthier wrote:

Hello,

You can use the "BASE" function of CALC to convert the numbers to
hexadecimal notation. The syntax is BASE(number, base, #digits); for
instance, converting the 44 of the zydeco color would be someting like
=BASE(44,16,2) which gives 2C.

And if you want, you can use a combination of CONCATENATE and BASE to
re-create the XML of the colors which you could then easily cut/paste
to the destination file.

I hope this helps.

Rémy Gauthier.
Le jeudi 09 février 2017 à 14:49 -0500, Tim---Kracked_P_P---webmaster a
écrit :

I am having trouble adding the Resene color palette to the
"standard.soc" file.

The colors in that file are listed in HEX - #FF

but the Resene list is in the RGB decimal format - RGB(255,255,255)


The Renese "people" will allow the use of their color names, as long

as

you include the copyright info.


My problem is the .soc files I have are all in HEX format, and when

I

add a color in RGB format, that color and the next HEX color are

skipped

and the color's space shows single White space/box.

I really want to use their palette for a additional palette called

"Renese.soc" with the basic and LO colors in the palette as the

first

colors seen.


So can any one help me with this issue?  Below is the first few

colors

in the default palette.  After that is the first colors in the

Renese

list [downloaded as a text file]

Can I replace the 'draw:color="#008000"/>' with
'draw:color="rgb(0,128,0)"/>'









"R" "G" "B""Colour Name"

1  54  28cardingreen
9  54  36bottlegreen
2  64  44sherwoodgreen
2  64  44zydeco
7  58  80tarawera





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted