Re: [libreoffice-users] compose characters

2019-05-15 Thread Brian Barker
agraph is inserted between the parts. You can see this by toggling on the display of non-printing characters. You can only join tables that are immediately adjacent, of course, so you will need to delete this empty paragraph before you can do so. I trust this helps. Brian Bark

Re: [libreoffice-users] compose characters

2019-05-14 Thread Brian Barker
n perform a global Find & Replace after you have prepared your text, of course. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

Re: [libreoffice-users] Regular Expressions

2019-05-09 Thread Brian Barker
uot;<", any text not including ">", and ">", i.e. everything from "<" up to and including the first ">" thereafter. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Probl

Re: [libreoffice-users] how to reformat this?

2019-04-12 Thread Brian Barker
| AutoCorrect Options | Options. o Select "Combine single line paragraphs if length greater than xx%". o Click Edit ... and change the percentage to a suitably small value: zero might do. o Select the text. o Go to Tools | AutoCorrect | Apply. Voilà! I trust this helps. Br

Re: [libreoffice-users] Calc: moving/sorting rows on Sheet1 don't update formulas on Sheet2 that refer to them

2019-04-09 Thread Brian Barker
I trust this helps. Brian Barker -- 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: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.li

Re: [libreoffice-users] Tabs in selection of text

2019-04-07 Thread Brian Barker
al but it's not possible in my current timeline. It never is, of course. But you should find time in future to understand how they work and save you time. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.

Re: [libreoffice-users] Writer into Calc

2019-03-21 Thread Brian Barker
der exactly what you are trying to do. Would it be better to start with the spreadsheet? I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guid

Re: [libreoffice-users] edit autocorrection options

2019-03-14 Thread Brian Barker
ot;(c)". o Type the next character, stimulating the automatic correction. o Immediately use Crtrl+Z (or Alt+E, U; or Edit | Undo; or click the Undo button in the Standard toolbar) to undo the automatic correction but retain the typing. o Continue typing. I trust this helps. Brian Barker

Re: [libreoffice-users] calc table reduce to list?

2019-02-24 Thread Brian Barker
t is and modify any formulae to achieve the results you need despite this. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guid

Re: [libreoffice-users] disable 2-digit options

2018-12-29 Thread Brian Barker
suspect, as these have been known to change! Why not calculate these in the spreadsheet from the date of birth and the current date? They will update by magic. If you don't have the date of birth, you would at the very least need to save the date on which each age value was har

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Brian Barker
At 20:06 28/12/2018 +0100, Harvey Nimmo wrote: However, I do not have 'Limit decimals for general number format' set to anything. (i.e. No tick) Good-oh! And what about "Precision as shown"? Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Probl

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Brian Barker
s to be based on what you see in a cell instead of the underlying, unrounded value. What happens if you ensure that both of these options are *not* ticked? I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.lib

Re: [libreoffice-users] edit autocorrection options

2018-12-23 Thread Brian Barker
r "Replace" AND "With". For now, that seems to be working. Good-oh! Brian Barker -- 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: https://wiki.document

Re: [libreoffice-users] edit autocorrection options

2018-12-23 Thread Brian Barker
ete. Voilà! When you want to reinstate it: o Select the copyright symbol in your text. o Go to Tools | AutoCorrect Options... | Replace; notice that the symbol is already in the With box. o Type (C) in the Replace box. o Click New. I trust this helps. Brian Barker -- To unsubscribe

Re: [libreoffice-users] Calc week number problem

2018-12-22 Thread Brian Barker
how to use spreadsheets more efficiently than the existing document's author. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + m

Re: [libreoffice-users] Calc week number problem

2018-12-22 Thread Brian Barker
Incidentally, when writing to strangers, please have the courtesy, maturity, and good sense to put your name (just *a* name?) in the real name field of your messages. Some people are called Dot, but no-one's called ".". Thanks. I trust this helps. Brian Barker -- To unsubsc

Re: [libreoffice-users] CountIF in range AND in another range

2018-12-03 Thread Brian Barker
ly if both conditions are true. The sum of all the appropriate 1s is the count you require. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Po

Re: [libreoffice-users] Pasting csv string into Calc

2018-11-11 Thread Brian Barker
w of data appears unchanged in a single cell. Select the column of values and go to Data | Text to Columns... . Select options in the Text to Columns window as in the Text Import one above. Your values will be separated and spread across five columns. I trust this helps. Brian Barker -- To uns

Re: [libreoffice-users] Array has red line surrounding it. How to fix

2018-10-09 Thread Brian Barker
to be frustrated by and delete! If you get a rash you can cover it up with hand cream. Or you can visit the doctor. Take your pick. ... the array still does not work! I don't think anyone can guess why without knowing your "[]other calculation formula". I trust this helps. B

Re: [libreoffice-users] Looking up value, finding substitution and entering

2018-10-05 Thread Brian Barker
P() search. By "copy", I mean a dynamic one using formulae, of course, not just a dump of the current values of the data. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-list

Re: [libreoffice-users] insert unicode char in writer

2018-10-03 Thread Brian Barker
that includes them. This is where PDFs come in, since they are different, incorporating subsets of required fonts. That's one of the facets that makes them "P" (for "Portable"). I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice

[libreoffice-users] paste from calc to writer table

2018-10-01 Thread Brian Barker
able. You can easily delete the temporary table, of course. I trust this helps. Brian Barker -- 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: https://wiki.documentfound

[libreoffice-users] side by side tables

2018-09-26 Thread Brian Barker
dicial merging of table cells - in this case cells within the one column of the table but not others, or differently in different columns. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mai

[libreoffice-users] strange problem with text flow

2018-09-26 Thread Brian Barker
... (or Ctrl+Shift+V) instead of ordinary Paste, selecting "Unformatted text" in the Paste Special dialogue. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-u

Re: [libreoffice-users] Protecting Calc formats

2018-09-19 Thread Brian Barker
. The unprotected area for data entry could be elsewhere on the same sheet or on another sheet if preferred. You could use print ranges to make your real area print but not the entry area. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

2018-09-13 Thread Brian Barker
) where you would otherwise use Xn to extract real numbers from your text values as necessary in formulae. Brian Barker -- 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

Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

2018-09-12 Thread Brian Barker
om another spreadsheet cell into a text-formatted cell, this may change the format of the cell - which you won't want. To avoid that, use Paste Special... instead of ordinary Paste and remove the tick from Formats. I trust this helps. Brian Barker -- To unsubscribe e-mail to: user

Re: [libreoffice-users] Libre Calc – Excel corrected?

2018-09-04 Thread Brian Barker
At 18:01 04/09/2018 +0100, Brian Barker wrote: At 12:04 04/09/2018 -0400, Charles Meyer wrote: [...] Can you toggle among case sizes in Libre Calc? Not that I know of. I don't know why I wrote that. You have what you need at Format | Change Case >, of course. Apologies. Brian Bar

Re: [libreoffice-users] Libre Calc – Excel corrected?

2018-09-04 Thread Brian Barker
t document as HTML you should see a table. That way, you can handle arbitrary ranges in one go, not just individual cells. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing

Re: [libreoffice-users] Add column values according to part of date value

2018-08-24 Thread Brian Barker
to data You might prefer to enter your dates as real dates, which could be formatted the way you have them using "MMDD" as the format string. Then you could extract year and month using the YEAR() and MONTH() functions: =SUMPRODUCT(YEAR(A3:A30)=2018;MONTH(A3:A30)=9;D3:D30) Br

Re: [libreoffice-users] Add column values according to part of date value

2018-08-24 Thread Brian Barker
ember 2018 values will be included but others not. Note: although SUMPRODUCT() handles arrays it returns a single value, so it is not necessary to enter it as an array function. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Probl

Re: [libreoffice-users] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

2018-08-08 Thread Brian Barker
image from video. At 11:21 08/08/2018 -0400, James Knott wrote: I see the same thing. So why does it work for me - in Firefox under Windows 10? Are you missing the underlying functionality required to display the video? Should you install Windows? ;^) Brian Barker -- To unsubscribe e-mail

Re: [libreoffice-users] Underlined unformatted text

2018-07-22 Thread Brian Barker
ect for existing marked text, right-click and select Accept Change, or use Edit | Changes > | Accept or Reject... Do you think I need to uninstall and reinstall? No. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] date, day number, week number in one cell

2018-07-12 Thread Brian Barker
, =DAYS then Err:510 appears in the cell. I'm not surprised: you concatenate references or expressions in a formula, not multiple formulae. What's that extra equals sign doing there? That's like writing =A1+=B2 instead of =A1+B2. Any ideas? Yes: excise that superfluous equals sign. Brian

[SUSPECT] Re: [libreoffice-users] date, day number, week number in one cell

2018-07-12 Thread Brian Barker
the answers are buried somewhere in the existing template. The functions WEEKNUM(), WEEKNUMADD(), and DAYS() may help. You can read the existing formulae in your template by selecting relevant cells and looking in the Input Line for each, of course. I trust this helps. Brian Barker -- To unsubscribe e-

Re: [libreoffice-users] Writer: Sorting in a Table

2018-07-07 Thread Brian Barker
At 21:15 07/07/2018 +, Ted Zimmer wrote: Your suggestions have solved my problem. Good-oh! I was preparing to say more, but no need now. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Writer: Sorting in a Table

2018-07-07 Thread Brian Barker
n a number of aspects you had not specified. Brian Barker -- 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: https://wiki.documentfoundation.org/Netiquette List arch

Re: [libreoffice-users] Writer: Sorting in a Table

2018-07-07 Thread Brian Barker
according to what data your table cells contain. Something should work. I trust this helps. Brian Barker -- 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: https

Re: [libreoffice-users] scalc: =MAX(SUM(F12:I12),1)

2018-07-04 Thread Brian Barker
:I12),1) instead? I trust this helps. Brian Barker -- 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: https://wiki.documentfoundation.org/Netiquette List archive: https

Re: [libreoffice-users] Can't edit array

2018-06-27 Thread Brian Barker
to create the array formula in the first place.(The green Accept tick is also no use here.) As you probably know, you cannot simply add the required braces by typing them yourself; you need to use Ctrl+Shift+Enter. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] copy function not working

2018-06-06 Thread Brian Barker
are not overly competent with computers! (I've met some.) But - for the avoidance of doubt - I was and am in no way suspecting that of you. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] copy function not working

2018-06-06 Thread Brian Barker
At 19:45 06/06/2018 +0900, Thomas Blasejewicz wrote: On 2018/06/03 17:09, Brian Barker wrote: At 20:50 29/05/2018 +, Virgil Arrington wrote: I am starting to experience more copy/paste issues similar to those described by Thomas. [...] I do not want to be awkward, ... You are not being

Re: [libreoffice-users] copy function not working

2018-06-03 Thread Brian Barker
termittent. Again, this is all consistent with a hardware problem. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + m

Re: [libreoffice-users] Two formulas in one cell?

2018-06-02 Thread Brian Barker
eal name field of your mail messages: it's an elementary courtesy to those offering to help you. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Post

Re: [libreoffice-users] Re: difference in hours between two times

2018-05-24 Thread Brian Barker
s: =INT(A14-A13) For the residual hours, remember that date and time values are stored in the unit of days, so you simply need to multiply by 24 to get hours: =(A14+B14-(A13+B13)-D14)*24 or: =(A14-A13-D14)*24 I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+

Re: [libreoffice-users] Insert current date

2018-05-21 Thread Brian Barker
others to copy your example. Brian Barker -- 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: https://wiki.documentfoundation.org/Netiquette List archive: https

Re: [libreoffice-users] copy function not working

2018-05-11 Thread Brian Barker
little smarter that can be done? Get someone to watch you work and see exactly what is happening. Can you reproduce the problem under such conditions? I trust this helps. Brian Barker (who happens just today to have needed to replace the batteries in his keyboard) -- To unsubscribe e-mai

Re: [libreoffice-users] How many of you deal with the Linux Users Group [Facebook]?

2018-04-29 Thread Brian Barker
est to act in this matter, surely you are a good enough teacher to bring your pupils up to your standard of use? You do them a disservice by allowing them only a poorer technique than your own. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Probl

Re: [libreoffice-users] How many of you deal with the Linux Users Group [Facebook]?

2018-04-29 Thread Brian Barker
onverting to and fro into and out of formats foreign to LibreOffice - as is the case if you save in Microsoft's formats - is a recipe for document instability. What you see when you reopen a document may not be what you saw before you saved it. Brian Barker -- To unsubscribe e-mai

Re: [libreoffice-users] Calc: Calculate number of days until yesterday IE TODAY-1 to assist in array determination for COUNTIF?

2018-04-27 Thread Brian Barker
y's row number, but this has evidently been added manually and also must be updated so. It should be fairly easy to establish this automatically, and even to embed any such calculation in any formula. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? h

Re: [libreoffice-users] Special Character Hunting - Libre Writer

2018-04-04 Thread Brian Barker
rst font I try. I trust this helps. Brian Barker -- 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: https://wiki.documentfoundation.org/Netiquette List

Re: [libreoffice-users] [Copying slides from one presentation to another]

2018-04-04 Thread Brian Barker
At 18:48 03/04/2018 -0500, Anne Noname wrote: Thank you for responding, ... No probs! ... but I'm still confused, still inserted below my continued reply, From: Brian Barker Date: Sat, Mar 31, 2018 at 4:30 PM At 14:46 31/03/2018 -0500, you wrote: ... am re-sending because I really would

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

2018-04-04 Thread Brian Barker
At 16:52 03/04/2018 -0700, Dave Stevens wrote: On Tue, 3 Apr 2018 18:48:19 -0500 anne-ology <lagin...@gmail.com> wrote: > Brian Barker - *privately* not very Indeed! But I did send my message privately in an attempt to help the questioner to express her query better - t

Re: [libreoffice-users] how to get copy paste to copy table data in pdf to calc column data:

2018-03-29 Thread Brian Barker
technique. I trust this helps. Brian Barker -- 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: https://wiki.documentfoundation.org/Netiquette List archive: https://listarch

Re: [libreoffice-users] Question about document/template interaction

2018-03-26 Thread Brian Barker
- in this case from your existing document to a new document intended to become your template - using the Load Styles facility, accessible from the drop-down menu from the New Style from Selection button in the Styles and Formatting window. I trust this helps. Brian Barker -- To unsubscribe e

Re: [libreoffice-users] Problem with the sumif function

2018-03-19 Thread Brian Barker
, the function will match only the text interpreted as a single fourteen-character string. I'm guessing, but do you have this option disabled? I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/ma

Re: [libreoffice-users] need some help with custom number format code

2018-03-19 Thread Brian Barker
ntents. If - as you indicated - you want single digit numbers to have a preceding zero, change this to "AB-"00"/2018" . Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsub

Re: [libreoffice-users] need some help with custom number format code

2018-03-19 Thread Brian Barker
uot;AB-"MM/. Once again, you will need to enter your first two dates (1 January and 1 February 2018) into the first two cells, select both, and then drag the fill handle so as to create dates one month apart, not one day apart, as would happen if you try to fill from a single prototype.

Re: [libreoffice-users] override automatic fraction

2018-03-04 Thread Brian Barker
trust this helps. Brian Barker -- 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: https://wiki.documentfoundation.org/Netiquette List archive: https

Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet

2018-03-03 Thread Brian Barker
ld need to re-create at most eight formulae, not nearly 3000. Constructing spreadsheets this way instead of piecemeal is essential if you aspire to reliability. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-he

Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet

2018-03-02 Thread Brian Barker
At 21:45 02/03/2018 -0500, Bonly "Art" Bonly wrote: I did the complete duplicate on a new sheet ... That sounds as if you copied and pasted "on a new sheet". Have you also tried copying the sheet using the technique I described - creating the new sheet in the proces

Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet

2018-03-02 Thread Brian Barker
At 13:38 02/03/2018 -0800, Girvin Herr wrote: On 03/02/2018 01:26 PM, Brian Barker wrote: o Copy and paste using Paste Special, as you suggest, but tick the > Link option in the Paste Special dialogue. [...] o Make a complete copy of the original sheet: right-click the sheet > tab and

Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet

2018-03-02 Thread Brian Barker
this helps. Brian Barker -- 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: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/gl

Re: [libreoffice-users] writer vs calc behaviour in LO 6.0.1.1

2018-02-24 Thread Brian Barker
nother system or you (or others) make any change. I trust this helps. Brian Barker -- 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: https://wiki.documentfoundation

[libreoffice-users] Need to select large diapason

2018-02-12 Thread Brian Barker
C$150240" (without the quotation marks). Click OK. Your required range now has a name. To select the range, click the down-arrow to the right of the Name box (at the left of the Input Line) and select your new name from the drop-down menu. I trust this helps. Brian Barker

Re: [libreoffice-users] Missing bullet points in Notes view on Impress 6.x - How do I get them back?

2018-02-05 Thread Brian Barker
y to White, not Automatic. You will find this setting on the Customise tab of the Bullets and Numbering dialogue. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscrib

Re: [libreoffice-users] doing something idiotic but what?

2018-01-30 Thread Brian Barker
operation of the program, for example in scrolling. I trust this helps. Brian Barker -- 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: https://wiki.documentfoundation.org/

Re: Fwd: [libreoffice-users] macro to only change month

2018-01-28 Thread Brian Barker
At 12:40 28/01/2018 +0100, Johnny Rosenberg wrote: 2018-01-28 9:04 GMT+01:00 Brian Barker: Does =DATE(2017;13;59) not give 2018-02-28 for you? Yes, it does. I was referring to the Basic function DateSerial ... Whoops: sorry! Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: Fwd: [libreoffice-users] macro to only change month

2018-01-28 Thread Brian Barker
that… Does =DATE(2017;13;59) not give 2018-02-28 for you? Brian Barker -- 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: https://wiki.documentfoundation.org/Netiquette List

Re: [libreoffice-users] macro to only change month

2018-01-27 Thread Brian Barker
as an exercise for the reader! I trust this helps. Brian Barker -- 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: https://wiki.documentfoundation.org/Netiquette List archive: https

Re: [libreoffice-users] Remove redline markings and strikeout text

2018-01-06 Thread Brian Barker
s PDF before accepting the changes. I trust this helps. Brian Barker -- 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: https://wiki.documentfoundation.org/Netiquette L

Re: [libreoffice-users] Search-and-add in Calc

2018-01-01 Thread Brian Barker
d string and the semicolon is the character you want added. I trust this helps. Brian Barker -- 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: https://wiki.docum

Re: [libreoffice-users] Formula and text in same cell?

2017-11-20 Thread Brian Barker
The square root of 3+1 is 2. I trust this helps. Brian Barker -- 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: https://wiki.documentfoundat

Re: [libreoffice-users] Re: Calc: Autofilter sorting fails to expand selection when a column has empty cells at the bottom

2017-11-06 Thread Brian Barker
empty cell to arrange what you need. Brian Barker -- 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: https://wiki.documentfoundation.org/Netiquette List archive

Re: [libreoffice-users] Calc: Autofilter sorting fails to expand selection when a column has empty cells at the bottom

2017-11-05 Thread Brian Barker
f it were before, a sort on an entire column (as we know you can do) would banish all significant data to rows starting back from row 1,048,576 ! I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/m

Re: [libreoffice-users] Re: search for text + paragraph Style

2017-10-17 Thread Brian Barker
nsion, you can press find next and it will select only the text with the par styles + all next occurrences one at a time! Indeed so - which is why I prefixed my original suggestion by saying that this was "something of the sort". Brian Barker -- To unsubscribe e-mail to: users+unsubscr.

Re: [libreoffice-users] Re: search for text + paragraph Style

2017-10-17 Thread Brian Barker
the styled text, and without disturbing the (multiple) selection, searching for text (but no longer for styles) with the "Current selection only" option ticked has to work. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffi

Re: [libreoffice-users] search for text + paragraph Style

2017-10-16 Thread Brian Barker
for the required paragraph style but click Find All. This selects all text with that paragraph style. o With the results still selected, now search for the required text but with the "Current selection only" option ticked. I trust this helps. Brian Barker -- To unsubscribe e-mail

Re: [libreoffice-users] calc: vlookup not behaving in one spreadsheet

2017-10-06 Thread Brian Barker
our newer one. Note that, although this appears to be a setting in the application, it is actually saved in each document. With the tick in place, ".*" means zero or more of any character (which is what you mean), whereas with no tick it means just the two characters d

Re: [libreoffice-users] Recalculate doesn't work [not!]

2017-09-28 Thread Brian Barker
no sense to attempt to deny the facts! Those text values *do* have trailing spaces. But that's irrelevant, as it is not the problem. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-list

Re: [libreoffice-users] printing envelopes

2017-09-24 Thread Brian Barker
cility to do this, and LibreOffice is no exception. The process is called "mail merge" and is covered in Chapter 11 of the Writer Guide "Using Mail Merge - Form Letters, Mailing Labels, and Envelopes" - specifically in the section "Printing envelopes". It's not trivi

Re: [libreoffice-users] frames

2017-09-20 Thread Brian Barker
need there. The new image will occupy the same space. I trust this helps. Brian Barker -- 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] Creating a table with equal sized rows

2017-09-18 Thread Brian Barker
the rogue empty paragraph. I trust this helps. Brian Barker -- 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 archive: http

Re: [libreoffice-users] Calc CountIf Alternative/Work Around

2017-09-09 Thread Brian Barker
will work, but not ">A1", since that "A1" will not be seen as a cell reference. If you need to incorporate a cell reference, you need to concatenate the ">" sign with the value in the cell, which will automatically be converted to text because of the conte

Re: [libreoffice-users] How can apply changes to a style throughout a mixed-style document

2017-08-31 Thread Brian Barker
style's settings. I want to change the style and apply it to all paragraphs that are already in that style. How so? Remove local formatting and change the paragraph style - in either order. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] Mac Writer Stuck Printing in Landscape

2017-08-31 Thread Brian Barker
or Letter or whatever. I trust this helps. Brian Barker -- 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 arc

Re: [libreoffice-users] To make a graph

2017-08-30 Thread Brian Barker
At 11:33 30/08/2017 -0600, Jorge Rodríguez wrote: Thank you Brain, ... I may be bright, but there is no need to call me that! I could do it now well and got the same result : 9126 Good-oh! Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] To make a graph

2017-08-30 Thread Brian Barker
in my calculation. Would you please, tell me what would I do wrong ? You seem to have calculated 14000 * ( 1 - U ) / 1.31 instead of 14000 * ( 1 - U / 1.31 ) - which means 14000 * ( 1 - ( U / 1.31 ) ), of course. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] To make a graph

2017-08-29 Thread Brian Barker
=0.456. I trust this helps. Brian Barker -- 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 arc

Re: [libreoffice-users] To make a graph

2017-08-28 Thread Brian Barker
put the data in some orders but I can get the graph. That's because - with only one point in each set of data - there is no graph to get. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] left adjusted last lines in 'd justified paragraphs?

2017-08-27 Thread Brian Barker
trust this helps. Brian Barker -- 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 archive: http

Re: [libreoffice-users] Search and Replace: Line Breaks

2017-08-22 Thread Brian Barker
using Find All (and ignoring the "Replace with" field). o Paste. I trust this helps. Brian Barker -- 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://wik

Re: [libreoffice-users] How to turn a paragraph into a cross-reference/link

2017-08-20 Thread Brian Barker
At 15:18 20/08/2017 +0200, Dennis Heuer wrote: On Sun, 20 Aug 2017 04:47:30 +0100 Brian Barker wrote: You are welcome to give up, but I haven't. You said originally that you wanted to include images, and a way to do that - as someone has already suggested - is to create identical hyperlinks

Re: [libreoffice-users] How to turn a paragraph into a cross-reference/link

2017-08-19 Thread Brian Barker
At 01:27 20/08/2017 +0200, Dennis Heuer wrote: On Sat, 19 Aug 2017 17:25:36 +0100 Brian Barker <b.m.bar...@btinternet.com> wrote: The hyperlink dialog expects a name for the hyperlink that substitutes the original text block. How can I do it different? Try not giving it

Re: [libreoffice-users] How to turn a paragraph into a cross-reference/link

2017-08-19 Thread Brian Barker
At 13:18 19/08/2017 +0200, Dennis Heuer wrote: On Sat, 19 Aug 2017 06:16:10 +0100 Brian Barker <b.m.bar...@btinternet.com> wrote: At 16:21 18/08/2017 +0200, Dennis Heuer wrote: I seek for a way to mark a text block (including indentations, images and what is in there) and turn it into a

Re: [libreoffice-users] How to turn a paragraph into a cross-reference/link

2017-08-18 Thread Brian Barker
-reference but a hyperlink. You will see that a hyperlink can be to a different part of the same document or another document, not just to a web address. You can link to tables, frames, graphics, OLE objects, sections, headings, or bookmarks. I trust this helps. Brian Barker -- To unsubscribe e

Re: [libreoffice-users] Simple way to draw graphs ?

2017-08-16 Thread Brian Barker
dealing exceptions in most copyright laws. But simply citing sources does not give you the right to reuse copyright material. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] Simple way to draw graphs ?

2017-08-15 Thread Brian Barker
in the USA (is it?), but a few seconds of web searching shows this certainly not to be so in all jurisdictions. (The text on the original chart was in French and the original enquirer wrote from a French e-mail address.) Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Simple way to draw graphs ?

2017-08-14 Thread Brian Barker
At 08:09 14/08/2017 -0700, Tom Cloyd wrote: Re-using graphs directly scanned from a book, without permission of the copyright owner, would also be a violation of international copyright law. Surely reconstituting such a graph - as is being suggested - might well be so too? Brian Barker

Re: [libreoffice-users] Re: Problem with numbered lists greater than 10

2017-08-13 Thread Brian Barker
want your lists to appear, if you have formatted them using a list style you can save that style in a template or else very easily import it from an existing document to a new one. This saves you attempting to repeat the work for each new document. Brian Barker -- To unsubscribe e-mail

  1   2   3   4   5   6   7   8   9   10   >