[libreoffice-users] LO 7.6 and Win7pro

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? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

[libreoffice-users] Cross ref problem

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.2 cross-ref problem

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

[libreoffice-users] Sorting in Writer

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] Default folder for PDF export

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

[libreoffice-users] Splitting columns in Calc

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

Re: [libreoffice-users] LO dictionaries

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 document

[libreoffice-users] LO dictionaries

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

[libreoffice-users] Opening foreign document from LOBase

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

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

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] Printing selected text to PDF

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

[libreoffice-users] Data Range in Calc

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

[libreoffice-users] Sorting in Writer

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

[libreoffice-users] Find & Replace in Calc

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

[libreoffice-users] Cannot edit Data Ranges in Calc

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

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

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

[libreoffice-users] Split cells in Calc

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?

Re: [libreoffice-users] Split cells in Calc

August 2014 13:52, Alan B abo...@gmail.com wrote: On Sun, Aug 10, 2014 at 7:25 AM, Pat Brown mistyha...@gmail.com 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 current option

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

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 current option then is it technically possible to do so

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

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

[libreoffice-users] Schema in Calc

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

[libreoffice-users] Sorting Sheets in Calc

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

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

? is the document odf, doc, docx? Cheers On 16/07/14 09:51, Pat Brown wrote: 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

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

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

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

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 mistyha...@gmail.com wrote: Where do I find the User Config folder on a Windows machine? Just

[libreoffice-users] Problem with Export as PDF

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

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

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 alex.thurg...@gmail.com wrote: Le 06/07/2014 16:36, Pat Brown a écrit : Hi Pat, I do not see

[libreoffice-users] LOBase - Hyperlinks in Tables

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

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

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

[libreoffice-users] LO and Coreldraw

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

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

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 Replace