Re: [libreoffice-users] Re: replace normal font with superscript

2013-10-02 Thread Pat Brown
Hi, Seems my previous reply did not reach all users. I wrote: In the "Find and Replace" option type in m2 in the "Find" window, then in the "Replace" window type in m and then, holding down the Alt key, type in 253 then release the Alt key. This places the ASCI code for supercript 2 in the Repl

[libreoffice-users] LO and Coreldraw

2014-02-07 Thread Pat Brown
I had a number of files in CorelDraw format (.cdr) which I had opened and edited in LO. I then saved these as .odg files. This worked fine until I installed LO 4.2. Since then I have not been able to open either CorelDraw files nor LO files converted from CorelDraw. LO tries to open the file and th

[libreoffice-users] Dropdown box in calc, mutliple columns

2014-02-12 Thread Pat Brown
I have two columns in calc. Column A has a list of items while column B has an associated cost. I want to be able to select from column A and have the item entered into a form (say column X) but I also want to automatically select the associated cost and have this entered into column Y, alongside i

[libreoffice-users] LOBase - Hyperlinks in Tables

2014-07-06 Thread Pat Brown
Hi, I am very comfortable with most aspects of LO except Base. I am now starting to use this option and I find it rather daunting compared to MS Access (simply because I have used this for years). I am busy with my first table design and I would like to create two fields as hyperlinks to externa

Re: [libreoffice-users] Re: LOBase - Hyperlinks in Tables

2014-07-08 Thread Pat Brown
Thanks Alex, I had not planned on getting into macros just yet but maybe this is as good a time as any. I will work on it and see how far I get. Paddy On 8 July 2014 21:41, Alexander Thurgood wrote: > Le 06/07/2014 16:36, Pat Brown a écrit : > > Hi Pat, > > > > I do

[libreoffice-users] Problem with "Export as PDF"

2014-07-15 Thread Pat Brown
Hi, I have not tried this previously but wish to do so now. My problem is that I want to export a selection of text in the main document but when I select "Export as PDF" the 'Range' option is greyed out. I cannot select anything and the default is 'All'. Is there a setting somewhere that I am m

Re: [libreoffice-users] Problem with "Export as PDF"

2014-07-16 Thread Pat Brown
gt;> I have tried this on windows (XP) and linux (Fedora) and I can not >> reproduce it. A couple of basic questions: >> >> I am assuming you are talking about a writer document? >> is the document odf, doc, docx? >> >> Cheers >> On 16/07/14 09:51, Pat Bro

Re: [libreoffice-users] Problem with "Export as PDF"

2014-07-16 Thread Pat Brown
07/15/2014 09:06 PM, Tim Lloyd wrote: > >> Hi, >> >> I have tried this on windows (XP) and linux (Fedora) and I can not >> reproduce it. A couple of basic questions: >> >> I am assuming you are talking about a writer document? >> is the document odf, do

Re: [libreoffice-users] Problem with "Export as PDF"

2014-07-16 Thread Pat Brown
Thanks Brian and thanks to everyone else who gave advice. Changing the name of the config folder did the trick. It now works as it should. I appreciate the help. On 16 July 2014 22:42, Pat Brown wrote: > Where do I find the User Config folder on a Windows machine? Just for > inter

[libreoffice-users] Sorting Sheets in Calc

2014-07-28 Thread Pat Brown
Hi, I have a spreadsheet with about 30 tabs (sheets). I want to re-arrange these. Is there a way to display the list and sort them as I wish without having to drag each sheet to a new position? I know that excell has the ability to display the sheets in a list form and one can highlight one of t

[libreoffice-users] Schema in Calc

2014-07-29 Thread Pat Brown
Hi, In a relationall DB there is a facility to display all the tables and this also shows how the tables are related and also which fields are related and how they are related. This is extremely useful to get an overall pcture of how things fit together and, importantly in this case, what the ef

Re: [libreoffice-users] Re: Schema in Calc

2014-08-05 Thread Pat Brown
Thank you, Paul. I have followed the convolutions of the discussion with interest but you have more clearly presented what I tried to say in the beginning. After much of the discussion I now see many of the difficulties involved but I will follow your suggestion and see if I can phrase this clearly

[libreoffice-users] Split cells in Calc

2014-08-10 Thread Pat Brown
Hi Guys, Is there any way to split a primary (one that has not been 'merged' previously) cell? I can't seem to find such an option. If there is no current option then is it technically possible to do so? Paddy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? ht

Re: [libreoffice-users] Split cells in Calc

2014-08-10 Thread Pat Brown
August 2014 13:52, Alan B wrote: > On Sun, Aug 10, 2014 at 7:25 AM, Pat Brown wrote: > >> Hi Guys, >>Is there any way to split a primary (one that has not been 'merged' >> previously) cell? I can't seem to find such an option. If there is no >> c

Re: [libreoffice-users] Re: Split cells in Calc

2014-08-10 Thread Pat Brown
; need to do with these data? > > Nino > > Am 10.08.2014 13:25, schrieb Pat Brown: > > Hi Guys, > >Is there any way to split a primary (one that has not been 'merged' > > previously) cell? I can't seem to find such an option. If there is no &g

[libreoffice-users] New 'tab' system in Calc

2015-03-23 Thread Pat Brown
Just tried the new system and love it. I find it so much easier than fiddling around with increasing/decreasing sliders. I would like to make a feature request regarding the tabs. I would like to be able to scroll the tabs using the mouse wheel. Where can I submit such a request? -- To unsubscrib

[libreoffice-users] Cannot edit Data Ranges in Calc

2015-07-10 Thread Pat Brown
I have a spreadsheet for rainfall data. Each season I have simply copied everything from the previous season and pasted it into a new sheet and then edited the charts to read from the new data. Since installing the previous version of LO I can no longer do this. I double click on the chart and at t

[libreoffice-users] Find & Replace in Calc

2015-10-04 Thread Pat Brown
I have over 2000 records in a sheet. At the beginning of each record there is a series of numerals. I want to do a Find & Replace to remove these numerical values but I cannot seem to find the right formula. The leading numerals are not of consistent length, example 1,1,Guide 1,24,Field 1,225,The M

[libreoffice-users] Cal file not recovering

2016-02-07 Thread Pat Brown
I was sending a cal document to be printed but the print never went through and LO hung. I had to close LO down. When I restarted LO I got the message that there was a file that needed to be recovered. I instructed to start recovery but it went into working mode and never came out. It is not a big

[libreoffice-users] Sorting in Writer

2016-05-31 Thread Pat Brown
I received a document which, essentially is a document of song lyrics. However, they were typed in at random, as they were received. I now want to sort the songs by song title and can't figure a way to do this. The format is the following: The song title, the artist, the lyrics. Each line is essen

[libreoffice-users] Data Range in Calc

2016-07-07 Thread Pat Brown
Every year I open a new sheet in Calc to record data from a new year. The layout remains exactly the same each year, only the data changes. The simplest is to copy the whole of the previous year's sheet and past it into a new sheet. Then delete all the previous year's data and fill in the new data.

[libreoffice-users] Printing selected text to PDF

2017-03-07 Thread Pat Brown
With most documents it is usually not a problem to select the PDF option and have it go straight to the printer. However, in Calc especially, one often wants to only send selected cells to PDF. However there does not seem to be an option to do this in the same way that one has if one selects the Pr

[libreoffice-users] Writer "Recent Files" list problem

2018-07-26 Thread Pat Brown
Hi, I was using LO 6.0.2. After a power outage I lost all items in my Recent Files list in Writer. It started to rebuild the list but got to 2 documents and would not add any more files. It just displayed the same first 2 files every time I opened LO. I decided to install version 6.0.5 but the

[libreoffice-users] Opening foreign document from LOBase

2018-08-12 Thread Pat Brown
Hi, I am developing an LO database and I want to open a PDF document from a button on a Base Form. I want a button on the form that will open a specific, different PDF document for each record. I want it to open the document in the default PDF reader? I have not been able to find anything to hel

[libreoffice-users] LO dictionaries

2019-10-17 Thread Pat Brown
Hi, I have changed my settings to use only the English UK dictionary but when I open a document it shows the English USA dictionary at the bottom of the page. How can I change this so that it never uses the USA dictionary? In fact, how can I delete the USA dictionary so that it is not even avail

Re: [libreoffice-users] LO dictionaries

2019-10-18 Thread Pat Brown
Thank you! On Fri, 18 Oct 2019, 05:18 Brian Barker, wrote: > At 23:45 17/10/2019 +0200, Pat Brown wrote: > >I have changed my settings to use only the English UK dictionary ... > > I don't think you have! Language is a property of various parts of > text within a docume

[libreoffice-users] Splitting columns in Calc

2020-04-20 Thread Pat Brown
I have a spreadsheet that includes a column consisting if people's names. I want to split this into two columns. I want one column with the given names and the other with their family names. This requires taking the last word in the column and creating a new column with this word. Is there a way to

[libreoffice-users] Default folder for PDF export

2020-06-06 Thread Pat Brown
Hi, Currently, if I select Export as PDF, the default folder is my "documents" folder on the C: drive. This is annoying as I keep having to change it to the folder I need. Is there any way to set it up so that it automatically selects the last folder used? Thanks, Paddy -- To unsubscribe e-mail

[libreoffice-users] Sorting in Writer

2021-04-23 Thread Pat Brown
Hi, I have a number of rows of text that I want to sort by row. My problem is that some of the rows are also hyperlinks and when I run the sort it puts all the hyperlink rows sorted and then the non-hyperlink rows. Is there any way to get the sort to ignore the hyperlink code? Thanks, Paddy

[libreoffice-users] LO 7.6.2 cross-ref problem

2023-10-03 Thread Pat Brown
Hi, I have just installed the latest version of LO but when I opened an .odt document none of my cross-references work. None of them are greyed out to indicate they are cross-references. When I hover the cursor over them they change colour to indicate they are cross-references but when I click on

[libreoffice-users] Cross ref problem

2023-11-18 Thread Pat Brown
Hi, I have just installed the latest version of LO but when I opened an .odt document none of my cross-references work. None of them are greyed out to indicate they are cross-references. When I hover the cursor over them they change colour to indicate they are cross-references but when I click on

[libreoffice-users] LO 7.6 and Win7pro

2023-11-18 Thread Pat Brown
Are there any issues with running the latest version of LO on a Win 7 machine? -- 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/Neti

[libreoffice-users] Moving single cell in Calc

2025-03-02 Thread Pat Brown
This is frustrating me no end. I have tried the "Ctrl-Click, Alt-Click" method, the "Select Cell then move cursor till hand appears", "Click and hold mouse on cell then drag". None if these work. Is there maybe something in settings that I need to change? This is only for single cells, multiple cel

[libreoffice-users] LO won't start

2025-05-02 Thread Pat Brown
I was able to run LO a few days ago without any problems. Today I tried to run it and absolutely nothing happened. I am using Windows 11. I was running LO 25.2.1, which was working fine and then it broke. I tried checking the Task Manager to see if any LO modules were still running in the bacground

Re: [libreoffice-users] LO won't start

2025-05-02 Thread Pat Brown
Thanks Gabriele. After trying a number of the options in Safe Mode I eventually fixed the problem by doing a factory reset, completely uninstalling LO, rebooting my PC then installing the latest version On Fri, 02 May 2025, 17:27 Gabriele Bertolucci, < gabriele.bertolu...@protonmail.com> wrote: >