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

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

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

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

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

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

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

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

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

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

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

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.

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.

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

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

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

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 >

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

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

Re: [libreoffice-users] Help hopeless

2017-12-23 Thread 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

Re: [libreoffice-users] Help hopeless

2017-12-23 Thread 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 ->

Re: [libreoffice-users] Help with Mail Merge

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

Re: [libreoffice-users] Help with Mail Merge

2017-08-30 Thread 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

Re: [libreoffice-users] HELP !!!

2017-08-21 Thread 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

Re: [libreoffice-users] help note icons broken

2017-08-02 Thread 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.

Re: [libreoffice-users] Help with VLOOKUP requested

2017-07-22 Thread 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

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

2017-07-21 Thread 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

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

2017-02-24 Thread 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.:

Re: [libreoffice-users] Help with LO Forms

2017-02-17 Thread 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

Re: [libreoffice-users] Help with LO Forms

2017-02-16 Thread 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

Re: [libreoffice-users] Help with LO Forms

2017-02-16 Thread 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*

Re: [libreoffice-users] Help with LO Forms

2017-02-16 Thread 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

Re: [libreoffice-users] Help with LO Forms

2017-02-16 Thread 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

Re: [libreoffice-users] Help with LO Forms

2017-02-16 Thread 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.

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

2017-02-13 Thread 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

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

2017-02-13 Thread 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 . >

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

2017-02-10 Thread 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

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

2017-02-09 Thread 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

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

2017-02-09 Thread 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

  1   2   3   4   >