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

2024-05-25 Thread 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

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

2024-05-25 Thread 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

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

2024-05-25 Thread Paul Goyette
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

Re: [libreoffice-users] Help for Libreoffice portable

2024-05-15 Thread 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

Re: [libreoffice-users] Help for Libreoffice portable

2024-05-15 Thread 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

[libreoffice-users] Help for Libreoffice portable

2024-05-15 Thread Jarek Krcmar
Greetings to the group, I would like to get help for LibreOffice portable in Czech. Is it somewhere to download it, please? Best regards -- Jarek -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Help - how to get rid of 'administrator'

2024-03-06 Thread 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

Re: [libreoffice-users] Help - how to get rid of 'administrator'

2024-03-06 Thread 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

Re: [libreoffice-users] Help - how to get rid of 'administrator'

2024-03-06 Thread 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

Re: [libreoffice-users] Help - how to get rid of 'administrator'

2024-03-06 Thread 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

[libreoffice-users] Help - how to get rid of 'administrator'

2024-03-06 Thread Emily Scharf
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

[libreoffice-users] Help with Formulas

2024-03-05 Thread Elad Magdasi
Dear LibreOffice team, Thank you so much for developing this amazing tool. I am using Python to dynamically write formulas in my LibreOffice file. However, I am noticing when LibreOffice opens the file, it adds an extra ")" at the end of the formula which results in a bad formula: Here is my

[libreoffice-users] Help

2023-11-08 Thread mynameisblueorange
An error popped up it says, BASIC runtime error. Property or method not found: CellAddress I don't know what to do -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

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

2023-10-30 Thread Dave Howorth
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

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

2023-10-30 Thread Madhu Patel
...@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

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

2023-09-30 Thread 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

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

2023-09-27 Thread Dave Howorth
e. > > 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 a

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

2023-09-26 Thread Madhu Patel
-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

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

2023-09-26 Thread 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

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

2023-09-24 Thread Madhu Patel
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

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

2023-07-07 Thread 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

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

2023-07-07 Thread 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,

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

2023-07-06 Thread 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

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

2023-07-06 Thread 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

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

2023-07-06 Thread 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.

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

2023-07-06 Thread 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

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

2023-07-06 Thread 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

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

2023-07-06 Thread 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. --

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

2023-07-06 Thread 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:-

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

2023-07-06 Thread 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

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

2023-07-06 Thread 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

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

2023-07-06 Thread 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

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

2023-07-06 Thread 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

[libreoffice-users] Help please with multipage document.

2023-07-06 Thread Budge
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

Re: [libreoffice-users] Help finding the last piece of writing

2023-06-06 Thread 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

Re: [libreoffice-users] Help finding the last piece of writing

2023-06-06 Thread 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

Re: [libreoffice-users] Help finding the last piece of writing

2023-06-06 Thread 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.

Re: [libreoffice-users] Help finding the last piece of writing

2023-06-06 Thread 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

[libreoffice-users] Help finding the last piece of writing

2023-06-06 Thread Angeline Ball
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

Re: [libreoffice-users] Help with Impress

2022-11-18 Thread 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,

Re: [libreoffice-users] Help with Impress

2022-11-18 Thread 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,

Re: [libreoffice-users] Help with Impress

2022-11-16 Thread 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. 

Re: [libreoffice-users] Help with Impress

2022-11-11 Thread 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

Re: [libreoffice-users] Help with Impress

2022-11-11 Thread 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

[libreoffice-users] Help with Impress

2022-11-11 Thread 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

Re: [libreoffice-users] HELP

2022-08-31 Thread 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

[libreoffice-users] HELP

2022-08-31 Thread Bids BR HVAC
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

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

2022-03-17 Thread 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/202

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

2022-03-17 Thread 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

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

2022-03-16 Thread V Stuart Foote
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 l

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

2022-03-16 Thread Dave Barton
sers. >> >> 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. >

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

2022-03-16 Thread jomali
3 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:

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

2022-03-16 Thread Dave Barton
] 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:

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

2022-03-16 Thread 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

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

2022-03-16 Thread 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

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

2022-03-16 Thread 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

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

2022-03-16 Thread 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/

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

2022-03-16 Thread 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

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

2022-03-16 Thread 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

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

2022-03-16 Thread 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

[libreoffice-users] Help with find & replace.

2022-03-16 Thread 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 ). 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

Re: [libreoffice-users] Help needed

2021-04-14 Thread 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

[libreoffice-users] Help needed

2021-04-14 Thread STEPHEN COLEMAN
Hi -- I need your help. We successfully downloaded LO 7.1.2.2 and am trying to use it to open an .ODS file received from UK Inland Revenue that is labelled 'gift_aid_schedule_libre_.ods' however while it opens up the LibreOffice 7.1 Document Recovery and pulls up the document file with the

Re: [libreoffice-users] Help installation via flatpak

2020-05-15 Thread 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

Re: [libreoffice-users] Help installation via flatpak

2020-05-14 Thread 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.

[libreoffice-users] Help installation via flatpak

2020-05-14 Thread asbaeza65
Hello. 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? Thanks in advice. -- Sent from:

Re: [libreoffice-users] Help please to delete an unwanted character.

2019-12-05 Thread 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.

[libreoffice-users] Help please to delete an unwanted character.

2019-12-05 Thread Budge
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

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

2019-07-13 Thread 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

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

2019-07-12 Thread 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

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

2019-07-12 Thread 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'

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

2019-07-12 Thread 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.

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

2019-07-12 Thread 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 >

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

2019-07-11 Thread 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: > > > >

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

2019-07-11 Thread 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

[libreoffice-users] Help with formula - number conversion

2019-07-11 Thread Tanstaafl
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

Re: [libreoffice-users] Help needed with Excel spreadsheet

2019-03-09 Thread 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

Re: [libreoffice-users] Help needed with Excel spreadsheet

2019-03-06 Thread 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

Re: [libreoffice-users] Help needed with Excel spreadsheet

2019-03-06 Thread 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

Re: [libreoffice-users] Help needed with Excel spreadsheet

2019-03-06 Thread 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.

Re: [libreoffice-users] Help needed with Excel spreadsheet

2019-03-06 Thread 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

Re: [libreoffice-users] Help files bad link

2019-03-06 Thread 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

Re: [libreoffice-users] Help needed with Excel spreadsheet

2019-03-06 Thread 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

[libreoffice-users] Help needed with Excel spreadsheet

2019-03-06 Thread Tom Williams
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

Re: [libreoffice-users] Help files bad link

2019-03-06 Thread 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

Re: [libreoffice-users] Help files bad link

2019-03-05 Thread 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

Re: [libreoffice-users] Help files bad link

2019-03-05 Thread 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

Re: [libreoffice-users] Help files bad link

2019-03-05 Thread 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

Re: [libreoffice-users] Help files bad link

2019-03-05 Thread 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

Re: [libreoffice-users] Help files bad link

2019-03-05 Thread 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

[libreoffice-users] Help files bad link

2019-03-01 Thread Paul D. Mirowsky
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". 

Re: [libreoffice-users] Help regarding LibOfficeBase/Firebird

2019-01-12 Thread 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 >

[libreoffice-users] Help regarding LibOfficeBase/Firebird

2019-01-12 Thread Pertti Rönnberg
Good evening, and a successful new year 2019 to all of you! And thanks for the gone interesting years with LibreOffice! (even if not always quite satisfying) My LibreOffice version on Windows10 now is 6.1.4.2 and I hope that LO-Base (finally) can meet my needs and intentions. I have some old

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

2018-10-15 Thread 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

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

2018-10-15 Thread 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 :

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

2018-10-15 Thread 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

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

2018-10-15 Thread John Jason Jordan
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

[libreoffice-users] Help creating a locale xml file for Nigeria

2018-08-27 Thread Speedbaron
Dear Madam/Sir. LibreOffice Calc does not have the Nigeria Naira symbol. I have been studying the Ghanaian XML file, en_GH.xml. Line 54, " ", seem to throw me off. Where did the Unicode 637 come from?  How was it calculated? The Ghanaian currency symbol is Unicode is µ+20B5. The Nigerian

Re: [libreoffice-users] Help Please with VLOOKUP

2018-08-01 Thread 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

Re: [libreoffice-users] Help Please with VLOOKUP

2018-08-01 Thread 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

  1   2   3   4   5   >