Re: [libreoffice-users] Inserting a Trademark Symbol in Label

2019-04-02 Thread Alan B
The following won't help you see/find the symbol. It will however let you type it directly. Put your cursor where you want the symbol to appear then If using Windows (tested with Windows 10 and LibreOffice 6.2.2.2) - Type 2122 then Alt+X If using Linux - Ctrl+Shift+U and release, then 2122,

[libreoffice-users] How to display AutoFilter filter criteria?

2018-05-27 Thread Alan B
When I set up a spreadsheet with AutoFilter I often insert a row at the top to show how many rows are displayed by the current filter, e.g. ="Rows displayed - " & SUBTOTAL(103,A3:A2) Now I'm trying to find a way to display the criteria used by the AutoFilter. e.g. "Rows displayed - " &

Re: [libreoffice-users] Can imported images keep the aspect ratio?

2018-03-12 Thread Alan B
You haven't indicated which app you're using. If using Write, maintaining scale while resizing an image is the default when dragging the handles to resize. At least in version 5.4.5.1 it is. On Sat, Mar 10, 2018 at 8:38 AM, Anne Wilson wrote: > My 200+ entries can now

Re: [libreoffice-users] Help with extra space at bottom of pages.

2016-12-19 Thread Alan B
Hello Leam, I suggest try the following... Open your document then... Ctrl+A This will select *everything* in the document Then right-click to bring up the context menu Click on the "Paragraph..." option In the dialog box that appears click the "Text Flow" tab At the bottom of this tab in

Re: [libreoffice-users] how do i Link to External Data?

2016-03-11 Thread Alan B
On Fri, Mar 11, 2016 at 12:07 PM, Beau Thompson wrote: > Hi All, > I like to use calc to pull data from a web page using Link to External > Data all videos are old > thanks for any help Hi Beau. "Insert > Link to External Data..." works for me. Select this menu option then

Re: [libreoffice-users] Calc as a Flat File Database

2016-03-08 Thread Alan B
On Tue, Mar 8, 2016 at 8:02 AM, Ian Whitfield wrote: > So I was wondering if there is and Add-On or Extension available to give > you a "Form" to overlay the Spreadsheet so that you can view the data one > row at a time?? > Hello Ian - I don't know the particulars but

Re: [libreoffice-users] Re: Database help please

2016-03-05 Thread Alan B
On Fri, Mar 4, 2016 at 3:13 PM, John Montgomery wrote: > Thank you to everyone who replied to my query, A01, A02 etc works, I am > very thankful for that. Now the problem to prevent duplication, I have > tried several ways but obviously what I am doing is incorrect as it

Re: [libreoffice-users] Envelopes print in wrong orientation

2015-12-14 Thread Alan B
On Mon, Dec 14, 2015 at 7:53 AM, Philip Jackson wrote: > When I dropped Windows for linux about 18 months' ago, I moved to > LibreOffice 4.2.8.2 and saw that LO Writer had inherited the same bug > from OO. > > My case involved a standard size European envelope to suit

Re: [libreoffice-users] Envelopes print in wrong orientation

2015-12-13 Thread Alan B
On Sun, Dec 13, 2015 at 7:17 PM, wrote: > Im try to print 6x8 envelopes. The text prints perpendicular > to the > long edge instead of paralleled to it no matter what format I select in > the Insert Envelope wizard. I cant figure out what Im doing > wrong. >

Re: [libreoffice-users] Sorting Calc Sheet in Alphabet orde on names in one Column

2015-10-25 Thread Alan B
On Sun, Oct 25, 2015 at 4:48 PM, ajebay wrote: > I have a calc spreadsheet with many lines of data which include one column > with names for the line. > I want to sort the names from A to Z, top to bottom, and have all the > corresponding data in each line move with the

Re: [libreoffice-users] Digital signatures

2015-10-12 Thread Alan B
On Sun, Oct 11, 2015 at 10:14 PM, Евгений wrote: > No one here used signatures? > No one can help or give some advices to resolve problem? > Sorry Евгений, I have only used self signed and only a few times. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] Show full content of a cell when selected [Calc]

2015-05-15 Thread Alan B
On Fri, May 15, 2015 at 11:07 AM, Alichino smar...@yahoo.co.uk wrote: I have a cell with a large amount of text in it. I don't want to Wrap text automatically because that will expand the cell. Instead I'd like to keep the cell small, and only expand when it is clicked I don't know of a way

Re: [libreoffice-users] Unzipped opendoc files

2015-05-12 Thread Alan B
On Tue, May 12, 2015 at 5:43 AM, Michel Kapel mkir...@gmail.com wrote: I seem to remember ... a long long time ago. It was possible to use an unzipped open-doc file (a directory) as a zipped one. So it was somehow possible to start-up open/libreoffice using as starting point one of the files

Re: Re: [libreoffice-users] first step forward

2015-03-06 Thread Alan B
On Wed, Mar 4, 2015 at 5:49 AM, anddos an...@neostrada.pl wrote: I work for medicine, to be precise, as an engineer active in the human ecosystem personal care. It makes me very satisfied, but I have to deal with quite a range of technological problems. That, explains maybe that I'd rather

Re: [libreoffice-users] database2spreadsheet

2015-03-04 Thread Alan B
On Wed, Mar 4, 2015 at 4:59 AM, hw h...@gartencenter-vaehning.de wrote: how would I create a spreadsheet from a table in a database? I know I can copy and paste, and I want to avoid that. Basically, users should be able to click an icon in LO (or on their desktop) and be presented with a

Re: [libreoffice-users] first step forward

2015-03-03 Thread Alan B
On Tue, Mar 3, 2015 at 8:24 AM, an...@neostrada.pl wrote: Thank you, Allan for the prompt reply, ... The sample is simply enough, I belive, so the point is how to proceed it to get output in several seperate SS or database tables, preserving the sequention in row position. Unfortunately I

Re: [libreoffice-users] Can the most up-to-date LO import and print pdfs?

2015-02-26 Thread Alan B
On Thu, Feb 26, 2015 at 7:24 AM, Tom Davies tomc...@gmail.com wrote: Hi :) +1 I agree that dedicated programs that do 1 single task tend to be better for that task. I seldom have a problem with LO's rendering of Pdfs but that could easily just be luck. Perhaps not so much on luck as on

Re: [libreoffice-users] Sorting ranges with merged cells

2015-02-26 Thread Alan B
On Thu, Feb 26, 2015 at 1:27 AM, Brian Barker b.m.bar...@btinternet.com wrote: At 18:45 25/02/2015 -0500, Alan Bonly wrote: On Wed, Feb 25, 2015 at 10:47 AM, Lera Goncharuk wrote: «Ranges containing merged cells can only be sorted without formats». This message implies that such ranges can

Re: [libreoffice-users] Large Database

2015-02-26 Thread Alan B
On Thu, Feb 26, 2015 at 9:06 AM, Patrick pkh5...@comcast.net wrote: ok i am hours new to Libreoffice so hopefully i dont sound too off here.so i use a large database in access that has several tables that have 80-100k lines in them. iam looking for a way to have access to this database while

Re: [libreoffice-users] Can the most up-to-date LO import and print pdfs?

2015-02-25 Thread Alan B
On Wed, Feb 25, 2015 at 10:42 AM, Lisi Reisz lisi.re...@gmail.com wrote: Can the most up-to-date LO import and print pdfs? Lisi - as suggested by V Stuart Foote using LO to print PDF may not provide the most accurate rendering. You don't say if you need to edit the documents. If editing is

Re: [libreoffice-users] Sortting ranges with merged cells

2015-02-25 Thread Alan B
On Wed, Feb 25, 2015 at 10:47 AM, Lera Goncharuk lera.goncha...@gmail.com wrote: «Ranges containing merged cells can only be sorted without formats». This message implies that such ranges can be sorted without splitting cells. Lera - I believe this is a poorly worded information message. I

Re: [libreoffice-users] Re: And while I'm here, data extraction

2015-02-05 Thread Alan B
On Thu, Feb 5, 2015 at 1:40 AM, CA Säger saege...@t-online.de wrote: Download this artbitrary database document with an embedded HSQLDB: https://forum.openoffice.org/en/forum/download/file.php?id=22304 Run this: SELECT * INTO TEXT exportTable1 FROM Table1 which creates exportTable1.csv

Re: [libreoffice-users] Re: And while I'm here, data extraction

2015-02-04 Thread Alan B
On Wed, Feb 4, 2015 at 6:20 PM, Andreas Säger saege...@t-online.de wrote: Am 04.02.2015 um 01:26 schrieb Alan B: select * into text newfile' from Sheet1; Well, it's obvious. Isn't it? :-) when you put it that way. Gave me hope for a moment it was my error. Unfortunately I must have made

Re: [libreoffice-users] And while I'm here, data extraction

2015-02-03 Thread Alan B
On Tue, Feb 3, 2015 at 6:55 AM, Mark Stanton m...@vowleyfarm.co.uk wrote: Having said all of that, is it ideal that the only way to get a data output from Base is C'n'P? No it isn't, not at all. Having used dBase, FoxPro, Paradox and Access and others I can attest that all had multiple result

Re: [libreoffice-users] Support options

2015-01-16 Thread Alan B
On Thu, Jan 15, 2015 at 1:07 PM, dave boland dbola...@fastmail.fm wrote: What is easy and convenient? I thought I answered that. Quick to do, no reistration, no passwords, able to see the appends in a thred like Yes, you did say that before. I'm not familiar with a forum like that (esp the

Re: [libreoffice-users] Support options

2015-01-14 Thread Alan B
On Wed, Jan 14, 2015 at 4:49 PM, dave boland dbola...@fastmail.fm wrote: I'm more than a little frustrated/angry at the support options for LO. Can't we find a way to offer support that is easy and convenient? I get Dave, I think easy and convenient is pretty much in the eye of the

Re: [libreoffice-users] Base Help Anyone

2014-11-18 Thread Alan B
On Tue, Nov 18, 2014 at 6:35 AM, Alan Pedder alanped...@hotmail.co.uk wrote: I have been using Base to provide a database for my paintings via a simple form. I recorded 200 records and then added the facility to include a photograph .jpg file and this is when the gremlins started to

Re: [libreoffice-users] Base Help Anyone

2014-11-18 Thread Alan B
On Tue, Nov 18, 2014 at 8:19 AM, Alan Pedder alanped...@hotmail.co.uk wrote: *Really appreciate your reply but unfortunately a lot of what you wrote is a bit over my level of knowledge and whilst I understand the terminology it did raise several questions i.e.1. Storing binaries refers

Re: [libreoffice-users] LO Writer, how to insert horizontal line

2014-11-16 Thread Alan B
On Sat, Nov 15, 2014 at 12:11 PM, Brian Barker b.m.bar...@btinternet.com wrote: At 11:45 15/11/2014 -0500, Alan Bonly wrote: Method 2 [Select Format|Paragraph, then the Borders tab, pick a top or bottom border, ...] suffers the same disadvantage if the border is specified as a bottom border.

Re: [libreoffice-users] LO Writer, how to insert horizontal line

2014-11-15 Thread Alan B
On Sat, Nov 15, 2014 at 10:57 AM, William Drago wdr...@suffolk.lib.ny.us wrote: I'm trying to insert a horizontal line into my LO document. The help says: 1. Click in the document where you want to insert the line. 2. Choose *Insert - Horizontal Rule* Well, there's no Horizontal Rule under

Re: [libreoffice-users] MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)

2014-10-02 Thread Alan B
On Wed, Oct 1, 2014 at 10:22 PM, Dan Lewis elderdanle...@gmail.com wrote: I understand your problem. Accidentally, both links were to the same 32 bit connector because I became confused by the naming Nabble used for the two files. (I uploaded teh same file twice.) Here is the 32

Re: [libreoffice-users]

2014-07-31 Thread Alan B
On Wed, Jul 30, 2014 at 10:34 PM, Wanda Moore justme...@gmail.com wrote: I have tried to email questions, but they have never been responded to. I have been getting everyone else's emails, which is in the hundreds. I don't know why I haven't gotten through about my questions . . . . Please

Re: [libreoffice-users] How to ensure all new text entered into a document is different font, without changing the old font settings of the document?

2014-06-07 Thread Alan B
On Sat, Jun 7, 2014 at 9:54 AM, quickbooks office quickbooks.off...@gmail.com wrote: How to ensure all new text entered into a document is different font, without changing the old font settings of the document? That is the document has questions in it, with lets say Times New Roman. When I

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-06-01 Thread Alan B
On Sat, May 31, 2014 at 7:34 PM, Oogie McGuire oog...@desertweyr.com wrote: I'm tearing my hair out here. I have a spreadsheet and the data was originally entered as 4 digits. I need to pass it to a database system that requires 6 digits. I've tried formatting with 2 leading zeros but I

Re: [libreoffice-users] Re: [Sclug] (no subject)

2014-05-05 Thread Alan B
On Sat, May 3, 2014 at 2:38 AM, David Lang da...@lang.hm wrote: googling for grub2 windows parition finds several pages that look promising http://askubuntu.com/questions/110698/add-windows-to-my-boot-menu suggests running update-grub and it should detect the windows partition. On Fri,

Re: [libreoffice-users] Re: Getting back to the Start screen

2014-04-11 Thread Alan B
On Fri, Apr 11, 2014 at 11:29 AM, dollyp da...@lochnevis.com wrote: What I am talking about is the start screen that appears when I start LO, the one with a graphic representation of recently opened files and access to templates and creating new documents etc. I tend to use a few files This

Re: [libreoffice-users] Getting back to the Start screen

2014-04-10 Thread Alan B
On Thu, Apr 10, 2014 at 2:25 PM, dollyp da...@lochnevis.com wrote: Is it possible to have a button on my toolbar that will bring back to start screen? If by start screen you mean you mean all program windows minimized so the desktop is shown just as it appears after logging on to the computer

Re: [libreoffice-users] Calc worksheet stalls when opening

2014-03-11 Thread Alan B
On Tue, Mar 11, 2014 at 9:21 PM, William Drago wdr...@suffolk.lib.ny.uswrote: I have a spreadsheet that stalls when I try to open it and when I try to save it. It does eventually open after a very long time. I Just looking for confirmation the issue is with only one particular spreadsheet?

Re: [libreoffice-users] same calc sheet in 2 windows?

2014-03-06 Thread Alan B
On Thu, Mar 6, 2014 at 4:20 PM, John R. Sowden jsow...@americansentry.netwrote: I have a calc sheet about 600 lines long with data at the top that I would like to see while I an using the data at, say line 400. Is it possible to open a second window showing the data at the top while editing

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-25 Thread Alan B
On Tue, Feb 25, 2014 at 1:45 PM, Paul D. Mirowsky p_mirow...@bentaxna.comwrote: Please download and install http://extensions.libreoffice.org/extension-center/numbertext-1 Very nice. I've installed it. If I could change the extension (maybe I will try) I would make optional or remove the

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-25 Thread Alan B
On Tue, Feb 25, 2014 at 8:09 PM, James E Lang jim+...@lang.hm wrote: I believe the traditional way to write this on a check is, Thirty-five and 50/100 dollars Good point. That's certainly the way I've done it. And the word dollars is preprinted on the checks I've used so the program output

Re: [libreoffice-users] Application of Speadsheet

2014-02-24 Thread Alan B
Not sure you've gotten answers to your questions and whether the auction has come and gone and any answer is moot. If you still wish answers here are some suggestions I hope you might find helpful. On Fri, Feb 21, 2014 at 3:05 PM, Pikov Andropov piko...@gmail.com wrote: Attendees' names and

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-24 Thread Alan B
Dennis, It looks to me that you're asking how to convert a number to the words that are spoken to say that number. You've asked how to convert a number ... to text. People familiar with programming/macros and data types will read that and think of something different than creating the words to

Re: [libreoffice-users] Application of Speadsheet

2014-02-21 Thread Alan B
On Fri, Feb 21, 2014 at 3:05 PM, Pikov Andropov piko...@gmail.com wrote: Third phase is checkout. I was thinking of copying the spreadsheet as it existed after phase 2 to a second laptop so that people could checkout with last-names-A-through-M going to laptop 1 and N-Z, to laptop 2. The

Re: [libreoffice-users] Document Recovery window appears

2014-02-19 Thread Alan B
On Feb 19, 2014 9:18 AM, Tom Davies tomc...@gmail.com wrote: Hi :) I thought he just meant the Escape key on the keyboard. It does about the same as the Cancel button within the dialogue-box itself I did mean the Esc key. And, at least on my system, it did make the always appearing Document

Re: [libreoffice-users] Calc - sort in to columns

2014-02-19 Thread Alan B
On Wed, Feb 19, 2014 at 7:04 PM, IGraham gra...@lovatt.co.uk wrote: How do I sort out from a mixed list of membership types the email addressers into separate columns without gaps or 'false' or '0' appearing http://nabble.documentfoundation.org/file/n4098035/test2.ods I'm guessing from your

Re: [libreoffice-users] Document Recovery window appears

2014-02-18 Thread Alan B
On Tue, Feb 18, 2014 at 4:46 PM, Muriel Parker rspn...@gmail.com wrote: The Document Recovery window comes up every time I open LO. When I Start Recovery Recovery failed comes up. Closing out window I can continue with LO. I have uninstalled and reinstalled LO, but it is still happening.

Re: [libreoffice-users] Writer record changes feature

2014-02-14 Thread Alan B
On Thu, Feb 13, 2014 at 10:55 PM, Jonathon toki.kant...@gmail.com wrote: On February 13, 2014 5:18:58 PM PST, Alan wrote: Is there a way to display the changed document, as if all edits are accepted, *without* accepting the changes?? IOW, show changed document. Probably not the way you

Re: [libreoffice-users] Writer record changes feature

2014-02-14 Thread Alan B
On Thu, Feb 13, 2014 at 10:54 PM, Brian Barker b.m.bar...@btinternet.comwrote: The option that is indeed present in (recent versions of?) Microsoft Word but missing in LibreOffice is the display of the original, unedited version of the document. But you kept a separate copy of that, didn't

[libreoffice-users] Writer record changes feature

2014-02-13 Thread Alan B
With the record changes feature turned on and the show changes feature enabled any changes made to a Writer document are clearly seen. If the show changes feature is disabled the original document is displayed. The changes are not lost and the document with edits can be displayed by once again

Re: [libreoffice-users] Writer record changes feature

2014-02-13 Thread Alan B
Thanks for the thought. It's not quite as KISS as I'd like though. I haven't used MS Word for a while, when I did, this was available. It was possible to see a document in it's original form, with all edits displayed, or as if all edits are accepted. That function, or a close approximation, is

Re: [libreoffice-users] Writer record changes feature

2014-02-13 Thread Alan B
On Thu, Feb 13, 2014 at 9:57 PM, Dale Rebgetz dale.rebg...@setec.com.auwrote: The way it works for me is if show changes is de-selected (after the changes have been made), then what I see is what you are asking for - the CHANGED document, not the original. Dale. Made me look Dale, you're

Re: [libreoffice-users] Writer record changes feature

2014-02-13 Thread Alan B
The way it works for me is if show changes is de-selected (after the changes have been made), then what I see is what you are asking for - the CHANGED document, not the original. Dale. ...and p.s. sorry to get folks off on the wrong track. I was hurrying through an unfamiliar document and

Re: [libreoffice-users] Additional KSSS for an Auction Question

2014-01-27 Thread Alan B
On Fri, Jan 24, 2014 at 12:46 PM, Pikov Andropov piko...@gmail.com wrote: We would like the Kingsoft Spreadsheet (KSSS) to have the following columns: A. Name B. Amount of winning bid C. Code for item purchased D. Description of item purchased E. Starting bid We realize that D and E can

Re: Re: [libreoffice-users] Calc question

2014-01-25 Thread Alan B
On Fri, Jan 24, 2014 at 7:51 AM, Carl Paulsen carlpaul...@comcast.netwrote: Dang, I hate the new list behavior of replying to the sender instead of the list. C +1 there. I spammed Carl trying to reply and ask for feedback on alternatives suggested to OP Now from computer instead of phone

Re: [libreoffice-users] Calc question

2014-01-23 Thread Alan B
On Thu, Jan 23, 2014 at 9:28 PM, Pikov Andropov piko...@gmail.com wrote: Next to each buyer will be a price. How do I total the amount of a buyer's purchase on the fly, so-to-speak? Have labels at the top of each column such as Buyer and Price. Once you're ready to get your totals by buyer

Re: [libreoffice-users] Query

2014-01-19 Thread Alan B
On Sun, Jan 19, 2014 at 6:15 AM, Ernest Dale ernest.dal...@gmail.comwrote: ... I appear to have succeeded but the result is what looks like a spreadsheet and I cannot find a way to display one record at a time. As already suggested filtering can limit the number of rows that are displayed.

Re: [libreoffice-users] Help with libre

2014-01-11 Thread Alan B
On Thu, Jan 9, 2014 at 4:58 PM, Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: Some how when I was doing a lot of work on libre office, I landed up with some solid lines running across my page, which I cannot delete or remove? Why? How can I remove them? That sounds like