[libreoffice-users] autofill in calc

2014-09-16 Thread Gary Collins
Hello, I've been using autofill and noted some things, not so much bugs but queries about the way it works and if it could be better. 1) I enter (e.g.) 2, 4 and 6 into cells B1-B3 2) I then highlight these cells and use autofill to extend to B4-B9, and I get 8,10,12,14,16,18 in these cells -

Re: [libreoffice-users] CANNOT INSTALL LIBRE OFFICE SUITES

2014-09-18 Thread Gary Collins
Hi, yes, it can be hard to find file extensions. That's one of the first things I set up on any new computer. Here's how to do it (windows7; Win 8 is probably similar): 1) in a windows explore window, click 'organize' and choose 'folder and search options.' 2) in the 'folder options' dialog

Re: [libreoffice-users] autofill in calc

2014-09-18 Thread Gary Collins
sometime, it sounds interesting. Thanks again /Gary From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Tuesday, 16 September 2014, 13:04 Subject: Re: [libreoffice-users] autofill in calc At 12:25 16/09/2014 +0100, Gary Collins

[libreoffice-users] leading zeroes

2014-09-18 Thread Gary Collins
Hi, Wikipedia defines leading zero as follows: A leading zero is any 0 digit that comes before the first nonzero digit in a number string in positional notation.[1] For example, James Bond's famous identifier, 007, has two leading zeros. However, if I put '7' in a cell and select format 2

[libreoffice-users] Installing LO versions to run in parallel on the same computer

2014-10-30 Thread Gary Collins
   Hi, I've tried installing the secfix version of LO to run in parallel with the version I generally use (on Windows 7). The instructions in the link were unclear (or just plain wrong), but I did finally manage to get the installer to complete, apparently successfully, i.e. the installer

[libreoffice-users] customise character order for comparisons?

2014-11-13 Thread Gary Collins
Hi,this is a bit of an unusual request , I know, but I'm wondering if it is possible to define a custom order for characters when comparing strings. I'm studying some ancient languages where the transcription alphabets use a mixture of standard English characters (but not necessarily in the

Re: [libreoffice-users] customise character order for comparisons?

2014-11-13 Thread Gary Collins
expect them to). /G.   From: Sophie gautier.sop...@gmail.com To: users@global.libreoffice.org Sent: Thursday, 13 November 2014, 10:48 Subject: Re: [libreoffice-users] customise character order for comparisons? Hi Gary, Le 13/11/2014 11:00, Gary Collins a écrit : Hi,this is a bit

Re: [libreoffice-users] customise character order for comparisons?

2014-11-13 Thread Gary Collins
No, it's right as I had it: h before H and A before a, as per the order in the alphabet below/G.   From: Tom Davies tomc...@gmail.com To: Gary Collins gcatl...@yahoo.co.uk Cc: Sophie gautier.sop...@gmail.com; users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 13

Re: [libreoffice-users] customise character order for comparisons?

2014-11-13 Thread Gary Collins
13/11/2014 +, Gary Collins wrote: ... I'm wondering if it is possible to define a custom order for characters when comparing strings. [...] I'd like to create a dictionary list, probably in calc in the first instance with words and synonyms, and be able to sort either on the English column

[libreoffice-users] vector graphics from raster

2014-12-26 Thread Gary Collins
Hi, I'm wondering if it's possible to generate vector images from raster. I have a set of plans as bitmapped images and would like to produce vector graphics from them; is it possible to do this automatically (or semi-automatically) in Draw? Thanks, /Gary -- To unsubscribe e-mail to:

[libreoffice-users] vector graphics from raster

2014-12-26 Thread Gary Collins
Hi, I'm wondering if it's possible to generate vector images from raster. I have a set of plans as bitmapped images and would like to produce vector graphics from them; is it possible to do this automatically (or semi-automatically) in Draw? Thanks, /Gary -- To unsubscribe e-mail to:

[libreoffice-users] vector graphics from raster

2014-12-26 Thread Gary Collins
Hi, I'm wondering if it's possible to generate vector images from raster. I have a set of plans as bitmapped images and would like to produce vector graphics from them; is it possible to do this automatically (or semi-automatically) in Draw? Thanks, /Gary -- To unsubscribe e-mail to:

Re: [libreoffice-users] vector graphics from raster

2014-12-29 Thread Gary Collins
: Hi Gary, Gary Collins schrieb: Hi, I'm wondering if it's possible to generate vector images from raster. I have a set of plans as bitmapped images and would like to produce vector graphics from them; is it possible to do this automatically (or semi-automatically) in Draw

Re: [libreoffice-users] LO (writer, esp.) and alternative keyboard layouts

2015-02-06 Thread Gary Collins
between paragraph? Regards from Tom :) On 6 February 2015 at 10:11, Gary Collins gcatl...@yahoo.co.uk wrote: Hi, I've been having some trouble lately using in Writer especially when using alternative keyboard mappings (Windows 7). Yesterday, for example, I was using a mapping

[libreoffice-users] Writer: when ruler stops working

2015-02-06 Thread Gary Collins
Hi,I was using Writer yesterday, I can't recall every step that led up to this, but I had a line with a tab in it, and went to the ruler to set the tab stop, but the ruler was unresponsive, I couldn't add a tab stop to it.Double clicking on it opened a dialog where, under one of the tabs, I was

[libreoffice-users] LO (writer, esp.) and alternative keyboard layouts

2015-02-06 Thread Gary Collins
Hi,I've been having some trouble lately using in Writer especially when using alternative keyboard mappings (Windows 7). Yesterday, for example, I was using a mapping that was basically English but which included macron vowels (that's vowels with a bar over the top, used, e.g., to indicate a

[libreoffice-users] Writer: how to turn off auto-generated lists?

2015-02-12 Thread Gary Collins
Hi, Hopefully an easy question for someone :-) How to I turn off auto-generation of list entries (preferably without altering any other settings? I generally tend to find this feature a pain in the proverbials, and would much rather apply list formatting, etc using styles, after a document

Re: [libreoffice-users] LO (writer, esp.) and alternative keyboard layouts

2015-02-12 Thread Gary Collins
like to be able to get to the bottom of this somehow. Best,/Gary   From: Simos Xenitellis simos.li...@googlemail.com To: Gary Collins gcatl...@yahoo.co.uk Cc: Tom Davies tomc...@gmail.com; users@global.libreoffice.org users@global.libreoffice.org Sent: Monday, 9 February 2015, 8:24

Re: [libreoffice-users] Writer: how to turn off auto-generated lists?

2015-02-12 Thread Gary Collins
Subject: Re: [libreoffice-users] Writer: how to turn off auto-generated lists? Hi Gary, Le 12/02/2015 11:33, Gary Collins a écrit : Hi, Hopefully an easy question for someone :-) How to I turn off auto-generation of list entries (preferably without altering any other settings? I generally

Re: [libreoffice-users] Writer: how to turn off auto-generated lists?

2015-02-12 Thread Gary Collins
Hi Tom,     A lot of people seem to open an old document and then use that to create new documents [sometimes that's the easiest way in windows]  but that way tons of hidden formatting codes and stuff seem to lurk and sometimes do some really odd things.  [I'd have thought that selecting all

Re: [libreoffice-users] Writer: how to turn off auto-generated lists?

2015-02-12 Thread Gary Collins
From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Thursday, 12 February 2015, 13:12 Subject: Re: [libreoffice-users] Writer: how to turn off auto-generated lists? At 10:33 12/02/2015 +, Gary Collins wrote: Hopefully an easy question for someone

Re: [libreoffice-users] Writer: how to turn off auto-generated lists?

2015-02-12 Thread Gary Collins
version very soon, so I'll see how that behaves!! Thanks,/G.   From: Tom Davies tomc...@gmail.com To: Gary Collins gcatl...@yahoo.co.uk Cc: Sophie gautier.sop...@gmail.com; users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 12 February 2015, 13:30 Subject: Re

[libreoffice-users] captions and headings

2015-01-04 Thread Gary Collins
Hi I'm working on a document that has chapters+sections 00-01, 00-02, ... 01-01, 01-02, ... etc. I'd like the figures to be numbered just using the first part, ie figure 00:01, figure 00:02, etc. With numbering running consecutively through all the 00-xx sections; but i can't figure (excuse

Re: [libreoffice-users] captions and headings

2015-01-08 Thread Gary Collins
just choose Figure under Selection. Karl On 04.01.2015 22:36, Gary Collins wrote: Hi I'm working on a document that has chapters+sections 00-01, 00-02, ... 01-01, 01-02, ... etc. I'd like the figures to be numbered just using the first part, ie figure 00:01, figure 00:02, etc

Re: [libreoffice-users] Re: LibreOffice Sort Bug ?

2015-03-27 Thread Gary Collins
opinion FWIW: I tend to use sort on an entire sheet (using datasort), and I nearly always have a column headings row at the top; I get narked when, coming to repeat a sort on a sheet, I find that LO has forgotten that I have previously checked the has headings box and ends up sorting the

Re: [libreoffice-users] Font versus Character Substitution

2015-04-21 Thread Gary Collins
...@btinternet.com To: users@global.libreoffice.org Sent: Friday, 17 April 2015, 18:26 Subject: Re: [libreoffice-users] Font versus Character Substitution At 13:24 17/04/2015 +, Gary Collins wrote: What I was saying is this: When I change input language, I change it using the keyboard/language

Re: [libreoffice-users] how to make formulas permanently case sensitive?

2015-05-12 Thread Gary Collins
To make a formula that is case sensitive, you should be able to use the string functions (I think) to convert to a known case before performing the comparison, e.g. if(UPPER(A1) = X;...) /Gary   From: hw h...@gartencenter-vaehning.de To: users@global.libreoffice.org Sent: Tuesday, 12 May

Re: [libreoffice-users] how to make formulas permanently case sensitive?

2015-05-12 Thread Gary Collins
 They seem to be case sensitive by default. I've just tried if (B1 = x;5;3)and it returns 5 when B1 = x and 3 when B1 = X.  To make a formula that is NOT case sensitive, you should be able to use the string functions (I think) to convert to a known case before performing the comparison,

Re: [libreoffice-users] how to make formulas permanently case sensitive?

2015-05-12 Thread Gary Collins
Sorry, that's to make a formula NOT case sensitive./G.   From: Gary Collins gcatl...@yahoo.co.uk To: hw h...@gartencenter-vaehning.de; users@global.libreoffice.org users@global.libreoffice.org Sent: Tuesday, 12 May 2015, 12:16 Subject: Re: [libreoffice-users] how to make formulas

Re: [libreoffice-users] Font versus Character Substitution

2015-04-16 Thread Gary Collins
Hi,thanks for this, I hadn't noticed it before (or, at least, I hadn't realised that the input language could be changed here). However, I'm using windows 7 and I have Russian and Greek Polytonic keyboards enabled, as well as some custom variants of English to use for transcriptions from

Re: [libreoffice-users] Please confirm Calc bug - discontiguous selection of rows, right-click is very slow

2015-04-17 Thread Gary Collins
Sorry - I must have had a blind spot.  Just tried with rows, and yes, it does indeed seem to take increasing time as the number of discontiguous rows increases.   From: Tanstaafl tansta...@libertytrek.org To: Gary Collins gcatl...@yahoo.co.uk; Alex McMurchy mcmurchy1917-libreoff

Re: [libreoffice-users] Font versus Character Substitution

2015-04-17 Thread Gary Collins
April 2015, 2:38 Subject: Re: [libreoffice-users] Font versus Character Substitution On April 16, 2015 4:44:11 AM PDT, Gary Collins wote: transcriptions from ancient language scripts. If those languages are not listed in Settings Fonts CTL, or Settings Fonts Western, as appropriate, LibO

Re: [libreoffice-users] Please confirm Calc bug - discontiguous selection of rows, right-click is very slow

2015-04-17 Thread Gary Collins
I've just tried this with a new empty sheet in LO 4.3.2.2 and haven't noticed anything - right-click seems to respond quite instantly. I have 7  non-contiguous columns selected - is that enough? Or perhaps it makes a difference if a fully populated sheet is used. I don't think I've got one handy

Re: [libreoffice-users] Calc: How to concat CTRL+ENTER to a string?

2015-04-09 Thread Gary Collins
Hi,try: =CONCATENATE(Target Balance  CHAR(10) Assuming  E2*100 % Growth)   /Gary From: William Drago wdr...@suffolk.lib.ny.us To: LibreOffice List users@global.libreoffice.org Sent: Thursday, 9 April 2015, 12:17 Subject: [libreoffice-users] Calc: How to concat CTRL+ENTER to a string?

Re: [libreoffice-users] LibreOffice's documentation (pdf and online)

2015-06-25 Thread Gary Collins
Hi David, 1) Yes, I have used the pdf documentation from time to time, but don't often have need to. Normally, only if I have a problem, which might occur when I'm trying something new and unfamiliar; but most of the time I am just using LO for the old and familiar! My first action in such a

Re: [libreoffice-users] Auto-hiding toolbars

2015-05-22 Thread Gary Collins
Hi, It's extremely useful when you want to view two (or more) documents side-by-side (something I do quite a lot). Or have two (or more) different applications in parallel. I'd usually much rather have them simultaneously visible than keep switching between them on the task bar. We use the

Re: [libreoffice-users] One more question on Drawing Object styles

2015-06-30 Thread Gary Collins
I use this to obscure parts of other objects. It's been extremely useful./Gary   From: Kevin O'Brien zwiln...@gmail.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, 28 June 2015, 17:20 Subject: [libreoffice-users] One more question on Drawing Object styles

Re: [libreoffice-users] table with offset between rows

2015-07-30 Thread Gary Collins
experiencing there is that cell size and formatting don't seem to be preserved when pasting the row. I don't really mind how  I achieve it, as long as it's not too tedious! Thanks, /Gary   From: Piet van Oostrum pie...@pietvanoostrum.com To: Gary Collins gcatl...@yahoo.co.uk Cc: users

Re: [libreoffice-users] table with offset between rows

2015-08-04 Thread Gary Collins
Thanks, that seems to work well! /Gary   From: Piet van Oostrum pie...@pietvanoostrum.com To: Gary Collins gcatl...@yahoo.co.uk Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 30 July 2015, 20:07 Subject: Re: [libreoffice-users] table with offset between

[libreoffice-users] LO Draw to PS shapes

2015-07-28 Thread Gary Collins
Hi,Does anyone know of a free app that can convert vector graphics from Draw into Photoshop Custom Shape format (.csh)? Draw doesn't export .csh directly; I did a quick web search but couldn't find anything useful. /Gary -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] LO Draw to PS shapes

2015-07-30 Thread Gary Collins
to find some alternative if at all possible. I checked inkscape, but that doesn't give the .csh format either. /G.   From: Tom Davies tomc...@gmail.com To: Gary Collins gcatl...@yahoo.co.uk Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Tuesday, 28 July 2015, 14:28 Subject

Re: [libreoffice-users] Question about LO Writer and complex documents

2015-07-31 Thread Gary Collins
I think that register is an important consideration. Colloquial language tends to be in a state of flux and dictionaries will always lag behind. Formal language tends to be far more conservative, and that, I think, is where proper is likely to be a more important consideration. Is either more

[libreoffice-users] table with offset between rows

2015-07-30 Thread Gary Collins
Hi, I'm needing to create a kind of table, consisting of two rows, where the bottom row is offset by half a cell from the top row. I'm not sure what would be the best way to achieve this - any suggestions would be most welcome! /Gary -- To unsubscribe e-mail to:

[libreoffice-users] Can't start up LO5 any more

2015-08-07 Thread Gary Collins
Hi, I'm experiencing some problems; installed LO5 yesterday (windows) and it was working fine; earlier this morning I had some docs open and it still seemed fine. All documents have now been closed, but I can't seem to start up LO5 any more.I've tried: double clicking a file in windows explorer

[libreoffice-users] Re: Can't start up LO5 any more

2015-08-07 Thread Gary Collins
the majority of those processes in the TM. I suspect this is something that shouldn't happen, but I'm not sure how I arrived at this state. /Gary   From: Gary Collins gcatl...@yahoo.co.uk To: users@global.libreoffice.org users@global.libreoffice.org Sent: Friday, 7 August 2015, 11:00 Subject

Re: [libreoffice-users] Re: Can't start up LO5 any more

2015-08-07 Thread Gary Collins
Thanks for the tip, I'll remember that! /G.   From: Tanstaafl tansta...@libertytrek.org To: users@global.libreoffice.org Sent: Friday, 7 August 2015, 12:58 Subject: Re: [libreoffice-users] Re: Can't start up LO5 any more Yeah, this happens sometimes, it is not new to 5... You got a

Re: [libreoffice-users] [OT] Operating Environment Survey

2015-07-23 Thread Gary Collins
/2015 04:40 AM, Gary Collins wrote: We didn't have computers at all at school We didn't either.  I had a FORTRAN class in grade 12 and filled in pencil mark cards, which the teacher took to the board office, to run on the computer there. -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] [OT] Operating Environment Survey

2015-07-23 Thread Gary Collins
Sorry, that should have been The Four Yorkshiremen (I must have miscounted :-) )   From: Gary Collins gcatl...@yahoo.co.uk To: Gordon Burgess-Parker gordo...@mail.com; users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 23 July 2015, 12:45 Subject: Re: [libreoffice

Re: [libreoffice-users] [OT] Operating Environment Survey

2015-07-23 Thread Gary Collins
, Gary Collins wrote: We didn't have computers at all at school, neither did welog tables and slide rule! -- 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

Re: [libreoffice-users] [OT] Operating Environment Survey

2015-07-23 Thread Gary Collins
From: James Knott james.kn...@rogers.com To: users@global.libreoffice.org Sent: Tuesday, 21 July 2015, 22:38 Subject: Re: [libreoffice-users] [OT] Operating Environment Survey On 07/21/2015 07:15 AM, Gary Collins wrote: My first home computer was a BBC micro (anyone remember those

Re: [libreoffice-users] [OT] Operating Environment Survey

2015-07-23 Thread Gary Collins
; Gary Collins gcatl...@yahoo.co.uk Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Wednesday, 22 July 2015, 5:19 Subject: Re: [libreoffice-users] [OT] Operating Environment Survey Hi :)  PDP11s look interesting!  A short article that claims the default OS was Multics

Re: [libreoffice-users] [OT] Operating Environment Survey

2015-07-21 Thread Gary Collins
      On 07/18/2015 09:25 PM, James E Lang wrote: The big discussion of Linux over the past 24+ hours has me wondering: What operating environment(s) do other members of this list use at home and at work? What factors influence the choice? My first home computer was a BBC micro

[libreoffice-users] Inconveniences of time format

2015-10-31 Thread Gary Collins
Hi I've got a column in calc 4.3.2.2 to contain the length of video clips; it's formatted to Time>876613:37:46. The first inconvenience is that, when using autoincrement the times are incremented not by 1 second but by 24 hours. Whilst i understand that this is due to the way

Re: [libreoffice-users] copying text with formatting from a web page

2015-10-16 Thread Gary Collins
ince found a workaround which is not the most convenient but will at least allow me to get done what I need to get done. best,/Gary   From: Tom Davies <tomc...@gmail.com> To: Gary Collins <gcatl...@yahoo.co.uk> Cc: "users@global.libreoffice.org" <users@global.libreoffice.org&

Re: [libreoffice-users] copying text with formatting from a web page

2015-10-20 Thread Gary Collins
jrodrigue...@cpcecr.com> Cc: Gary Collins <gcatl...@yahoo.co.uk>; "users@global.libreoffice.org" <users@global.libreoffice.org> Sent: Friday, 16 October 2015, 21:51 Subject: Re: [libreoffice-users] copying text with formatting from a web page Hi :)  I've just see

[libreoffice-users] copying text with formatting from a web page

2015-10-09 Thread Gary Collins
Hi, I'm copying some text from a web page (windows explorer) into a Writer doc; the text copies OK, but I can't seem to preserve superscripting. I've tried normal, HTML format and formatted text [RTF] as paste options; I can get attributes such as colour pasted, but can't seem to get that

Re: [libreoffice-users] copying text with formatting from a web page

2015-10-09 Thread Gary Collins
Should've said, I'm using 4.4.3.2/G.   From: Gary Collins <gcatl...@yahoo.co.uk> To: "users@global.libreoffice.org" <users@global.libreoffice.org> Sent: Friday, 9 October 2015, 15:33 Subject: [libreoffice-users] copying text with formatting from a web page Hi,

Re: [libreoffice-users] copy cell format

2015-09-18 Thread Gary Collins
I think the problem being experienced is that the column widths are not copied or adjusted to fit the contents. The best I can think of is to paste the data, then select it and use Format>Column>optimal width. This may not be quite what is required, but it may at least help a bit. /Gary

Re: [libreoffice-users] Re: How to find out which fonts are used in an Open Document?

2016-02-09 Thread Gary Collins
I have a vague recollection of this, or something very like it, cropping up before. If it is not already an area marked for development, I think it should certainly be. I think that if a font is being replaced, the reader of the document should be given the ability to easily ascertain that this

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

2016-01-28 Thread Gary Collins
Phil,you wrote: Just observation - you believe in sky fairies - Albert Einstein, Erwin Schrodinger, Paul Dirac, Antony Flew, all believed in a God; as do Richard Swinburne, Francis Collins, William Lane Craig, to name just a few. you also wrote. Well if you weren't clueless (which is

[libreoffice-users] strip footnotes

2017-01-20 Thread Gary Collins
Hello, I would like to either 1) copy text without the footnotes but retaining formatting Or 2) strip all footnotes from text after pasting. Is this possible in writer? Thanks Gary -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Marginal references

2016-11-14 Thread Gary Collins
Hi, I'm wanting to prepare a document in writer with a main text body(justified) and marginal references on the right (and possibly also different ones on the left). Each paragraph will have at least one reference. The references need to be tied to their relevant paragraphs. If a subsequent

Re: [libreoffice-users] Marginal references

2016-11-15 Thread Gary Collins
Thanks for your replies; I think youve hit the nail on the head, Brian - helpful as ever. Seems so obvious now, shouldve thought of it myself - duh!! -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Strange things happening with page count

2016-12-14 Thread Gary Collins
Hi, I have a long document (writer 5.2.2.2, x64; win7) which was fine until i changed some of the defined colours (tools>options>color ; changed rgb settings for some colours with modify). After OK the document went 'jittery;' i saved and quit. When i reopened, all my footnotes seem to have

[libreoffice-users] Remove applied character style

2016-12-13 Thread Gary Collins
Hi, My question: is it possible to remove an applied character style from a text selection without changing anything else? Situation: i have a character style which i apply to individual words and phrases in footnotes. If i apply this style to the last word in the footnote (quite frequent),

Re: [libreoffice-users] Remove applied character style

2016-12-14 Thread Gary Collins
Thanks Ricardo, ill try that the next time the situation arises G. -- 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/Netiquette List

Re: [libreoffice-users] Style from selection

2016-12-16 Thread Gary Collins
Thanks for reply, Dave. I just tried this and it doesnt seem to work for me. A new style with the name is created but it doesnt have the attributes of the selected text, in particular font size, font colour. These attributes were apparently set as direct formatting in the original doc, which i

[libreoffice-users] Style from selection

2016-12-15 Thread Gary Collins
Hi, A rather basic question: how do i create a new style from selection (lo 5.2.2.2 x64)? The guide i have says to click the new style from selection icon in the styles and formatting window. Trouble is, i can't seem to find it. I have a new style icon with a dropdown but that doesn't have a

Re: [libreoffice-users] Style from selection

2016-12-17 Thread Gary Collins
Update It is working now. I guess i must have been doing something wrong before, though goodness knows what, its a simple enough procedure. Thanks for your help, G. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] 'Accumulating' styles

2016-12-19 Thread Gary Collins
Hi, Is it possible to accumulate character styles? By which i mean, i have, eg a char style for a coloured background, applied to certain text selections. I have another char style for small caps, applied to certain words in the text. Now if one of those words also occurs in one of the

Re: [libreoffice-users] vlookup case

2017-03-10 Thread Gary Collins
guess i'll probably have to get into macros. Thanks G. On Thu, 9/3/17, Brian Barker <b.m.bar...@btinternet.com> wrote: Subject: Re: [libreoffice-users] vlookup case To: users@global.libreoffice.org Cc: "Gary Collins" <gcatl...

Re: [libreoffice-users] Re: sorting in calc

2017-03-10 Thread Gary Collins
rg Cc: "Gary Collins" <gcatl...@yahoo.co.uk> Date: Thursday, 9 March, 2017, 23:17 At 18:59 08/03/2017 +, Gary Collins wrote: >Is there a character i can enter into a cell >that will come *before* numbers in the sort >order? I mean, before other cells that act

[libreoffice-users] named data ranges

2017-03-09 Thread Gary Collins
Hello again I appear to be experiencing a problem with named data ranges lo 5.2.2.2 x64 win 7. Q. Is it possible and permissible to define overlapping data ranges? I want a range named mdec which will be A1:B25 and another xlit B1:C25 (the col B values are common) to use in lookups. I have

Re: [libreoffice-users] sorting in calc

2017-03-09 Thread Gary Collins
olumns B,C,D in that order. Perhaps there might have been an easier way to do it, but it works and thats what counts Gary -------- On Thu, 9/3/17, Gary Collins <gcatl...@yahoo.co.uk> wrote: Subject: Re: [libreoffice-users] sorting in calc To: "Gary Collins&

[libreoffice-users] sorting in calc

2017-03-08 Thread Gary Collins
Hello, Is there a character i can enter into a cell that will come *before* numbers in the sort order? I mean, before other cells that actually contain numbers rather than numerical strings Thanks Gary -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] sorting in calc

2017-03-09 Thread Gary Collins
pears* to change in that the numbers become left justified like strings but istext (cell) still returns false /G. On Thu, 9/3/17, Dries Feys <dries.f...@tvh.com> wrote: Subject: Re: [libreoffice-users] sorting in calc To: "Gary Collins" &l

[libreoffice-users] vlookup case

2017-03-09 Thread Gary Collins
Hello, Is it possible to make the search performed by vlookup to be case sensitive? I need to be able to distinguish between eg 'd' and 'D' but at the moment i cant work out how to do it (if its possible) Thanks Gary -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

[libreoffice-users] regular expression for calc

2017-03-11 Thread Gary Collins
Hello, I have a column each row of which contains a sequence of one or more codes separated by a space. In case it will make a difference each code consists of a letter (ooccasionally 2 letters) followed by a number of up to 3 digits (and occasionally ends with a letter) eg X1 Aa12 D7a etc. I

Re: [libreoffice-users] vlookup case

2017-03-11 Thread Gary Collins
in fact located on a different sheet); but it does what i need and thats all i demand of it! Best Gary On Fri, 10/3/17, Michael D. Setzer II <mi...@kuentos.guam.net> wrote: Subject: Re: [libreoffice-users] vlookup case To: "Ga

[libreoffice-users] regular expression for calc

2017-03-11 Thread Gary Collins
Apologies if this appears twice; im not sure if there was a problem with sending... Hello, I have a column each row of which contains a sequence of one or more codes separated by a space. In case it will make a difference each code consists of a letter (ooccasionally 2 letters) followed by a

[libreoffice-users] sort order

2017-03-11 Thread Gary Collins
Hello Id like to know if there is a character, preferably some sort of discreet punctuation mark, that will come *after* z in the sort order when using natural sort. My problem is that i have some codes beginning Aa which really speaking should come after Z. As a number of up to 3 digits

Re: [libreoffice-users] regular expression for calc

2017-03-12 Thread Gary Collins
and im using 64bit windows 7. G. On Sun, 12/3/17, Brian Barker <b.m.bar...@btinternet.com> wrote: Subject: Re: [libreoffice-users] regular expression for calc To: users@global.libreoffice.org Date: Sunday, 12 March, 2017, 5:51 At 15:45 11/03/2017 +, Gary Collins wrote: >

Re: [libreoffice-users] sort order

2017-03-12 Thread Gary Collins
. On Sun, 12/3/17, Brian Barker <b.m.bar...@btinternet.com> wrote: Subject: Re: [libreoffice-users] sort order To: users@global.libreoffice.org Date: Sunday, 12 March, 2017, 5:51 At 17:58 11/03/2017 +, Gary Collins wrote: >I'd lik

Re: [libreoffice-users] sort order

2017-03-12 Thread Gary Collins
e. Thanks Gary On Sun, 12/3/17, Brian Barker <b.m.bar...@btinternet.com> wrote: Subject: Re: [libreoffice-users] sort order To: users@global.libreoffice.org Date: Sunday, 12 March, 2017, 5:51 At 17:58 11/03/2017 +, Gary Collins wrot

Re: [libreoffice-users] sort order

2017-03-12 Thread Gary Collins
to change according to the language. Je la 12/03/2017 18:50, Gary Collins skribis : > Thank you, yes it does. I got it to work with Greek iota which is about the least obtrusive. Strangely (to my mind) some less obtrusive characters with higher unicode *dont* work. Its a bit of a my

Re: [libreoffice-users] sort order

2017-03-13 Thread Gary Collins
to change according to the language. Je la 12/03/2017 18:50, Gary Collins skribis : > Thank you, yes it does. I got it to work with Greek iota which is about the least obtrusive. Strangely (to my mind) some less obtrusive characters with higher unicode *dont* work. Its a bit of a my

Re: [libreoffice-users] sort order

2017-03-13 Thread Gary Collins
users@global.libreoffice.org, "leleu" <robert.le...@ovh.fr>, "Gary Collins" <gcatl...@yahoo.co.uk> Date: Monday, 13 March, 2017, 5:00 ftp://fedora9gcc.dyndns.org/gary.zip Has 3 little spreadsheets.    8969  03-12-2017 03:27   FINDCODE.ods     14959  03-12-2017 0

Re: [libreoffice-users] regular expression for calc

2017-03-13 Thread Gary Collins
users@global.libreoffice.org Date: Sunday, 12 March, 2017, 17:50 Hi Gary, find the option "Search criteria = and <> must apply to whole cells" in Tools > Options > Calc > Calculate. Try it with disabled option. Kind regards Regina Gary Collins schrieb: > Hi Brian

[libreoffice-users] calc macro selected range

2017-09-17 Thread Gary Collins
Hi Im writing a macro to replace a number of characters with corresponding alternative chars wherever they occur in strings in a selected cell range. To accomplish this im currently calling uno:executeSearch multiple times - once for each character that needs to be changed. Problem is, when

[libreoffice-users] frames

2017-09-19 Thread Gary Collins
LO 5.2.2.2 ubuntu 16.10 Hello I have an arrangement of frames on a page which i would like to exactly replicate on all successive pages of the document. How do i go about this? Ive tried saving as a template but a) i dont know if thats right for this and b) even if it is i dont knoe how to

Re: [libreoffice-users] frames

2017-09-20 Thread Gary Collins
the image ratio correct. G. On Wed, 20/9/17, Brian Barker <b.m.bar...@btinternet.com> wrote: Subject: Re: [libreoffice-users] frames To: users@global.libreoffice.org Cc: "Gary Collins" <gcatl...@yahoo.co.uk> Date: Wednesday, 20

Re: [libreoffice-users] frames

2017-09-20 Thread Gary Collins
users@global.libreoffice.org Cc: "Gary Collins" <gcatl...@yahoo.co.uk> Date: Wednesday, 20 September, 2017, 12:42 At 18:29 19/09/2017 +, Gary Collins wrote: >I have an arrangement of frames on a page which i would like to >exactly replicate on all successive pag

Re: [libreoffice-users] frames

2017-09-20 Thread Gary Collins
thought it would? G. On Wed, 20/9/17, Brian Barker <b.m.bar...@btinternet.com> wrote: Subject: Re: [libreoffice-users] frames To: users@global.libreoffice.org Cc: "Gary Collins" <gcatl...@yahoo.co.uk> Date: Wednesday, 20 September

[libreoffice-users] calc autofill

2017-09-10 Thread Gary Collins
Hi Ive noticed what appears to be an anomaly when using autofill (hope thats the right word) in calc 5.2.2.2 in ubuntu 16.10 To illustrate, open a new spreadsheet and enter 1 in A1 and in C1, and "A1" in D1 and F1. Select range A1:F1 and fill down to row 2. Then A2, C2 contain 2 and D2, F2

[libreoffice-users] calc autofill

2017-09-10 Thread Gary Collins
Hi Ive noticed what appears to be an anomaly when using autofill (hope thats the right word) in calc 5.2.2.2 in ubuntu 16.10 To illustrate, open a new spreadsheet and enter 1 in A1 and in C1, and "A1" in D1 and F1. Select range A1:F1 and fill down to row 2. Then A2, C2 contain 2 and D2, F2

[libreoffice-users] cant find main menu in ubuntu window

2017-08-28 Thread Gary Collins
Hi Ive just installed ubuntu 16.10 from magazine disc. It comes of course with LO bundled (or parts of it anyhow) But ive just found when i wanted to change properties that it doesnt have the main menu across the top of the window and i cant seem to find it anywhere. This is the first time ive

[libreoffice-users] cant find main menu in ubuntu 16.10

2017-08-28 Thread Gary Collins
Hi Apologies if this is a repeat but it seems something may have gone wrong last time i tried to send. Ive just installed ubuntu 16.10 from magazine disc. It comes of course with LO bundled  (or parts of it anyhow) But ive just found when i wanted to change properties that it doesnt have the

Re: [libreoffice-users] cant find main menu in ubuntu window

2017-09-02 Thread Gary Collins
tes. I have seen this shown as a solution elsewhere if you feel confident. HTH On 28/08/17 23:40, Gary Collins wrote: > Hi > Ive just installed ubuntu 16.10 from magazine disc. It comes of course with LO bundled  (or parts of it anyhow) > But ive just found when i wa

[libreoffice-users] table from calc to writer?

2017-11-24 Thread Gary Collins
Hi,my intuition tells me that it ought to be possible to copy a block of cells from calc and paste as (or into) a table in writer; but I haven't been able thus far to do it. Is it possible? I'm using LO 5.2.2.2 on Ubuntu. thanks, /Gary -- To unsubscribe e-mail to:

Re: [libreoffice-users] table from calc to writer?

2017-11-25 Thread Gary Collins
ay, 24 November 2017, 18:08 Subject: Re: [libreoffice-users] table from calc to writer? Bonjour, Le 24/11/2017 à 15:35, Gary Collins a écrit : > Hi,my intuition tells me that it ought to be possible to copy a block of > cells from calc and paste as (or into) a table in writer; but I

  1   2   >