Re: [libreoffice-users] question hyperlinks in Calc.

that if you ascribe a name to the target cell and create the hyperlink to that name instead of to the cell address, you will achieve what you require. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org

Re: [libreoffice-users] help with find

D() itself returns error 519, alias #VALUE, in this case. Try =IF(ISNUMBER(FIND("Nationwide",B1)),1,2) or =IF(ISERROR(FIND("Nationwide",B1)),2,1) I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://w

Re: [libreoffice-users] help with find

e first, second, third, and so on. Try: =FIND("Nationwide",B1,1) or just: =FIND("Nationwide",B1) 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] Dictionaries.

, and the ideal spelling dictionary should be the right size, not simply as large as possible. As you increase its size, you decrease the number of false positives whilst at the same time increasing the number of false negatives. False positives are dealt with by review, but false negative

Re: [libreoffice-users] Resizing Document

d print it from there scaled up to fit (at 141%). Any editing you needed to make could be made to the original version, before the export. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mai

Re: [libreoffice-users] calc

d even if an exact match does not exist - which I'm guessing you wouldn't want. Row 4, column A matches one of the rows 1-3... You may want to look into the detail of how to handle cases where the value in A4 either does not appear in the list or even appears more than once. I

Re: [libreoffice-users] Using '+' as text only in tables

cognition. 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://lis

Re: [libreoffice-users] stripping crlf

you have here. What can I use to replace the line break with a space? Just "$" (no quotes), it seems. Another thought: consider using Paste Special (instead of ordinary Paste) and "Unformatted text" when inserting text from elsewhere. This avoids some problems. I trus

Re: [libreoffice-users] Tab Settings

ing Pages: Advanced", of the Writer Guide. 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 archi

Re: [libreoffice-users] Tab Settings

that you would readily think of as a table. 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 ar

Re: [libreoffice-users] Scalc I cannot merge cells, also I selected and unprotected them

| Track Changes > | Record selected? Toggle it off. 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: ht

Re: [libreoffice-users] Odd find and replace problem

At 12:35 09/06/2023 -0400 Dotty Peter wrote: I'm trying to replace this- UT1 with this- GMT However, when using Find and Replace I get this- UT1GMT How can I fix this? Turn off Track Changes. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+uns

Re: [libreoffice-users] Adding Time in hours

thing similar. That's a clock time, not a time interval. And three and a quarter hours after a quarter to midnight is indeed three a.m. I need the sum total hours no matter if it's beyond 24. Try [HH]:MM (or similar) instead. I trust this helps. Brian Barker -- To unsubscribe e

Re: [libreoffice-users] Is there a way to have cell format remain with an external link??

es. In another column, make copies of the values using the "=" technique. Format this new column as you wish. If preferred, hide the original column. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreof

Re: [libreoffice-users] does this work for you?

dates (just like numbers, which is what they really are) are by default right-justified in the cell. 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

Re: [libreoffice-users] does this work for you?

format you wish to see; indeed, in this case, you must not, since that is not one of the formats that LibreOffice will recognise. Just re-enter the date in A1 in such a format (e.g. 1/3/24 in your locale) and everything will spring to life as you wish. I trust this helps. Brian Barker

Re: [libreoffice-users] Possible improvement for review?

created, use Edit | Undo (or Ctrl+Z). This will undo the automatic correction but retain the typed text. 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] Possible formatting but in calc.

his. If I enter =002+003, the formula is edited to =2+3. If what is entered is pretending to be a formula but is actually nonsense, is it so surprising or worrying that the edited result is equal (but slightly different) nonsense, also masquerading as a formula? Brian Barker -- To unsubs

Re: [libreoffice-users] Possible formatting but in calc.

=$B$21) AND (G22<>$B$21),10,20) I'm not sure why you would want this in a cell, as it makes no sense. Do you perhaps need =IF(AND(F22=$B$21,G22<>$B$21),10,20) instead? I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.or

Re: [libreoffice-users] How to copy text INCLUDING format settings but WITHOUT the header and background settings

ad of normal Paste, and choose "Unformatted text" from the options in the Paste Special dialogue. Alternatively, you can use Ctrl+Alt+Shift+V, which pastes unformatted text directly. The text you paste will inherit the formatting of surrounding material. I trust this helps. Brian

Re: [libreoffice-users] How to print a section of a SS

At 17:45 19/10/2021 +0100, Dave Howorth wrote: On Tue, 19 Oct 2021 13:05:10 +0100 Brian Barker wrote: At 11:53 19/10/2021 +0100, Dave Howorth wrote: On Mon, 18 Oct 2021 20:51:19 -0400 Alan Bonly wrote: It hasn't been mentioned if the OP is printing to PDF, and my bad for never reportin

Re: [libreoffice-users] How to print a section of a SS

At 18:20 19/10/2021 +0200, Philip Jackson wrote: On 19/10/2021 14:05, Brian Barker wrote: The documentation thinks it is a bug. Under "Using print ranges", it says: "You can define which range of cells on a spreadsheet are to be printed or exported to a PDF. The cells on the she

Re: [libreoffice-users] How to print a section of a SS

ges", it says: "You can define which range of cells on a spreadsheet are to be printed or exported to a PDF. The cells on the sheet that are not part of the defined print range are not printed or exported. Also, any sheets without a defined print range are not printed or exported."

Re: [libreoffice-users] Question [not!] on INDIRECT()

general fashion. If, as you suggest, the operator is always "+", you could use =IF(ISNUMBER(A1);A1;LEFT(A1;FIND("+";A1)-1)+MID(A1;FIND("+";A1)+1;99)) You could make this simpler if you knew that the numbers in the expressions were always of two digits. I trust thi

Re: [libreoffice-users] unwanted red lines on spreadsheet and info boxes

em vanish. To suppress the recording (and display) of changes, toggle off Edit | Track Changes > | Record. 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] extracting cell values

other sheet. You could use Print Ranges to suppress printing of whichever values you did not want to see. 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] Consolidating values from multiple sheets

in your new sheet. o Click the tab of your source sheet to display it. o Click the source cell. o Press Enter (or click the Accept green tick icon in the Input Line). You can now drag the cell's fill handle in the target sheet to expand the area referenced to a row, a column, or another range.

Re: [libreoffice-users] Better approach for formatting

. That would be easy: o Put the cursor into the first row of the table. o Insert two additional rows, using the Before option. o Merge the cells of the new second row. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www

Re: [libreoffice-users] Quote marks

gle and double quotes for the straight quote marks". Surely you just remove the ticks from the Replace boxes to disable this form of correction - no "setting" involved? I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] calc charting issue

oesn't give you what you require by default. If not, right-click on one of the points in a relevant line in the chart and select Format Data Series... | Options | Plot Options. Set "Plot missing values" to "Leave gap" (or as preferred). I trust this helps. Brian Barker

Re: [libreoffice-users] Start Date

result to show as meaningful dates. PS: You are too late to start those service B processes! 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 guide

Re: [libreoffice-users] Updating Data in Calc

alues, generating a single value as its result. You then pass this single value to the SUM() function. What do you expect that function do with a single value? The sum of two and two is four; what do you think is the sum of just two? Brian Barker -- To unsubscribe e-mail to: users+uns

Re: [libreoffice-users] Updating Data in Calc

hether you need =SUM(M1:M99) or =MAX(M1:M99) or =VLOOKUP(M4,X1:Y10,2,FALSE) or =IF(SUM(M1:M99)>0,"Hooray: I'm solvent!","Shucks, I'm bankrupt.") or one of a thousand other possibilities we can only guess. I trust this helps. Brian Barker -- To unsubscribe e-mail

Re: [libreoffice-users] Multiple references to footnote?

it is some elaboration or explanation of the footnoted text. It doesn't mean "ditto". 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 + mo

Re: [libreoffice-users] adjust image automatically

ing a text document, which can easily contain your images. No-one can help you fully whilst you keep your purpose a secret. Zince you talk ablut writer, it doezn't help me at all On the contrary, it *may* have been just the help you need. Brian Barker -- To unsubscribe e-mail to:

Re: [libreoffice-users] adjust image automatically

, which achieves just what you require. Note that table borders can be adjusted so that they either show or not in different places; the table structure does not need to show at all in your finished document, if that is what you prefer. Tables are described in Chapter 13 of the Writer Guid

Re: [libreoffice-users] conditional formatting based on day of week

for Sunday. Instead it gives 1 if Type is 1 or omitted and anything else you want between 1 and 7 depending on Type, but never 0. o The containing parentheses are unnecessary and probably confusing. Try something like: WEEKDAY(INDIRECT("$B$"&ROW()))=1 I trust this helps. B

Re: [libreoffice-users] auto edit youtube transcript?

this works whether your original "lines" are separated by line breaks or are actually separate paragraphs. You can copy and paste the material in column B back into a text document for further formatting as required, of course. I trust this helps. Brian Barker -- To unsubscribe e-mai

Re: [libreoffice-users] cells don’t auto-wrap

row height to enable Calc to expand the row sufficiently to accept all your text. 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] days since beginning of year

AY())&"-1-1")+1 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 arc

Re: [libreoffice-users] Counting cells

ends on how resilient you want your spreadsheet to be to rogue or erroneous cell contents as a result of later errors on your part (we all make them) or on the part of others who may use the spreadsheet. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@glo

Re: [libreoffice-users] Re: File Explorer – Day-week-month search for Libre files

a few hours ago (before I wrote) and it wouldn't show; now it does! Weird. 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.d

Re: [libreoffice-users] File Explorer – Day-week-month search for Libre files

: Today, "This month", "Last year", etc. 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.docume

Re: [libreoffice-users] Language setting in Calc

szetts and all. So the fonts are OK. But what he would like is to keep the *language* settings for English and German applied to different columns - presumably so that the German text doesn't get marked as English misspellings! That works in LibreOffice, but gets lost when resaved into an Ex

Re: [libreoffice-users] Language setting in Calc

f course, is if someone can find instructions for doing this *in Microsoft Excel itself* or can find or produce a document file in Excel format which shows different language settings. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libr

Re: [libreoffice-users] Language setting in Calc

t's formats, and the bug report should probably go to them instead. 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.documentf

Re: [libreoffice-users] LO 6.4.7.2 Calc: Where is a cell referenced elsewhere in s file?

> | Trace Dependents (or Shift+F5). ...or should I raise a feature enhancement and if so where? Probably not. 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-unsubsc

Re: [libreoffice-users] calc chart problems

onsult the documentation and then to spend some time familiarising yourself with all the options. 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] Re: Fit last column in spreadsheet to print

probably illegible! (Er, sorry, but maximum columns per sheet is 1024.) 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://wik

Re: [libreoffice-users] regex help

At 07:29 04/01/2021 -0500, Bill Drescher wrote: On 1/3/2021 4:09 PM, Brian Barker wrote: At 14:19 03/01/2021 -0500, Bill Drescher wrote: I have a script that mysteriously became double spaced. I want to search for 2 end of paragraph marks and replace them with one. So it's the parag

Re: [libreoffice-users] regex help

for locking to the start of a paragraph is the caret, "^", so the pattern you should search for is "^$" (no quotes, of course) - replacing with nothing. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https:/

Re: [libreoffice-users] Date number has 5 digits

he date value before you concatenate it with the text "Monday". To do that, use ="Monday "&DAY(January.$A5) Depending on exactly what you need, have you considered using =TEXT(January.$A5;"D") instead? I trust this helps. Brian Barker -- To unsub

Re: [libreoffice-users] Superscript and Subscript Character Buttons in Writer :::----> Calc

t document, choosing possibly HTML or "Formatted text" in the Paste Special dialogue, a table will be created for you. Note that text tables are worth knowing about: they are frequently useful for formatting material in a text document that doesn't immediately appear to be ta

Re: [libreoffice-users] bug in LARGE function?

largest before you get to the first occurrence (of two) of 322, and then the tenth to twenty-fifth largest are all 320. 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

Re: [libreoffice-users] Suggestion: 3D spreadsheets

a] 2D spreadsheet. And so on. How does this differ from multiple sheets labelled "alpha", "beta", and so on? This could be really powerful. What do you think? I think you should write the code. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreo

Re: [libreoffice-users] Question on value command and Err:502

+1" in this case is being entered into a cell (as part of a formula), not arising as the result of some calculation. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lis

Re: [libreoffice-users] Re: [Calc] Convert GPS coords from DMS to decimals?

At 10:02 22/11/2020 -0700, Gilles Noname wrote: Brian Barker wrote Yes, if your locale needs semicolons as separators commas will not do. That is definitely what error 509 will be signalling. Odd that the locale would change the sign used in functions. Odd, maybe, but true. Sorry that my

Re: [libreoffice-users] Re: [Calc] Convert GPS coords from DMS to decimals?

At 07:40 22/11/2020 -0700, Gilles Noname wrote: Problem solved by [...] running a regex to prepend a minus sign. Not proud of this, but it got the job done. Just reinstate the original (correct) "E" instead! I trust this helps. Brian Barker -- To unsubscribe e-mail to: user

Re: [libreoffice-users] Re: [Calc] Convert GPS coords from DMS to decimals?

That is because you have - weirdly - chosen to mess up my formula, changing my "E" (for east) into "O" (for west). So *of course* the longitude signs are now reversed. Reinstate my "E" and everything will work. I trust this helps. Brian Barker

Re: [libreoffice-users] Re: [Calc] Convert GPS coords from DMS to decimals?

At 05:20 22/11/2020 -0700, Gilles Noname wrote: Brian Barker wrote If 00°05'12"O 42°59'12"N is in A1, then =(MID(A1,12,2)+(MID(A1,15,2)+MID(A1,18,2)/60)/60)*((RIGHT(A1,1)="N")*2-1) will deliver 42.986667, and =(LEFT(A1,2)+(MID(A1,4,2)+MID(A1,7,2)/60)/60)

Re: [libreoffice-users] [Calc] Convert GPS coords from DMS to decimals?

culated value by this number to attach the appropriate sign. This means that these formulae will also work for positions east and south of the origin - so your trip to the southern hemisphere will be covered. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr..

Re: [libreoffice-users] use calc 7 IF command to change some column values?

ely because that is a literal piece of text and not a reference. Also, in the example, A1:A13 is a range of cells, but that is not what you need here. Instead, enter in B1 the formula =IF(A1>28,0,A1) and "fill" it down column B - by dragging the "fill handle" down the column

Re: [libreoffice-users] Static vs. dynamic time

y workaround, however: before typing your new value into A1, just press Delete to empty A1 (B1 will now be empty too) and then enter your new value (B1 becomes the new time). So far, I am forced to type or insert the time manually each time. No longer! I trust this helps. Brian Barker

Re: [libreoffice-users] Static vs. dynamic maximum

ffice Calc | Calculate | Iterative References | Iterations. Then your formula works. 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:

Re: [libreoffice-users] Exponential Power and Square Root Notations in Calc Formulae

ed of some asterisks) to be the argument of the arcsine function? 3. Square Root of n See "square root" in the built-in help text. Or perhaps search https://help.libreoffice.org/6.2/en-GB/text/scalc/main.html . Or possibly see the answer to 1. Brian Barker -- To unsubscr

Re: [libreoffice-users] total newbie has Calc question

esponding value in the second column. If there is no match, it returns the error "Value Not Available", which appears as "#N/A". I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.or

Re: [libreoffice-users] [Calc] Keyboard shortcut to delete current row when focus on one of its cells?

At 20:19 21/09/2020 +0100, Dave Howorth wrote: On Mon, 21 Sep 2020 14:13:51 +0100 Brian Barker wrote: At 06:00 21/09/2020 -0700, Gilles Noname wrote: I need a keyboard shortcut to delete the current row. CTRL+- only works when 1) reaching for the mouse and 2) clicking on its ID number on the

Re: [libreoffice-users] [Calc] Keyboard shortcut to delete current row when focus on one of its cells?

ts. Ctrl+hyphen, R, Enter? 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 arch

Re: [libreoffice-users] Calc: how do I?

appropriate number of sheets. o Paste. o Repeat for other tables and other sheets. 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] LO 6.4.6.2 CALC : Appropriate formula?

7;t see why not. It might well be that reorganising your data in some way is the right solution. 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

Re: [libreoffice-users] Find all within brackets

d the change of language. Then search for [|] (meaning open bracket or close bracket) and again Find All to select all brackets. Now undo italics and (if it matters) reset the language for the brackets themselves. I trust this helps. Brian Barker -- To unsubscribe e-mail to:

Re: [libreoffice-users] Find all within brackets

At 18:42 10/09/2020 +0100, Séamas Ó Brógáin wrote: Some time ago Brian Barker provided a brilliant formula for finding all text between less-than and greater-than signs, namely <[^>]*> I've been trying to adapt it to finding text within brackets [thus], but without success

Re: [libreoffice-users] Problem: Generating a Table in LO Base from a LO Calc Spreadsheet

change in your spreadsheet if you wish. A workaround may be to use Table Format... to change the Underlining style to something other than "(Without)" and then back again. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Proble

Re: [libreoffice-users] Problem: Generating a Table in LO Base from a LO Calc Spreadsheet

hat the headings are no longer in white text. Create the database table anew. o In the database Tables panel, use Edit | Paste Special... (or right-click | Paste Special...) instead of ordinary Paste and select an alternative option - perhaps "Formatted text [RTF]"? I trust this helps.

Re: [libreoffice-users] Multiple newlines

a paragraph is defined not by how it will be represented in any saved file but by its properties in the window - in other words, what you can do with it and how you do it. And the answer to that is simply a "paragraph break" and a "line break". Brian Barker -- To un

Re: [libreoffice-users] Multiple newlines

use of AutoCorrect, I went back to the Writer Guide and still don't find it. In suspect you are right. Then remove empty paragraphs: [...] Again I like your pedagogical approach, matching the action with the reasoning. Good-oh! You should be a teacher. (Er, I was one.) Bria

Re: [libreoffice-users] Multiple newlines

phs in AutoCorrect Options - possibly to 0%.) Then remove empty paragraphs: o Search for "^$" (no quotes) and replace with nothing. ("^" anchors your pattern to the start of a paragraph and "$" to the end. So "^$" matches a paragraph with nothing in it.)

Re: [libreoffice-users] Compare Two Calc Files in WIN10

g and Reviewing Spreadsheets", of the Calc Guide: o Open the edited document that you want to compare with the original document. o Select Edit | Track Changes | Compare Document. o An open document dialog appears. Select the original document and click Open. I trust this helps. Brian Barker

Re: [libreoffice-users] [Calc] Good way to turn hours+minutes into minutes?

At 15:50 17/07/2020 +0200, Luuk Noname wrote: if A2 = "01h14" Then the formula: =TIMEVALUE(REPLACE(A2;3;1;":"))*24*60 Will return: 74 Basically first replace 'h' for an ':' timevalue returns the minutes since midnight. Except that this fails for ti

Re: [libreoffice-users] Re: [Calc] Good way to turn hours+minutes into minutes?

At 06:54 17/07/2020 -0700, Gilles Noname wrote: Brian Barker wrote I'm guessing that you have text values. If so, use =LEFT(Xn;2)*60+RIGHT(Xn;2) That was the easiest solution: =LEFT(F3;2)*60+RIGHT(F3;2) Next, copy the cell (formula), select all the cells below, and paste. Or use the

Re: [libreoffice-users] [Calc] Good way to turn hours+minutes into minutes?

*60+MID(Xn;4;2) or =LEFT(Xn;2)*60+RIGHT(TRIM(Xn);2) Note that the LEFT() and RIGHT() functions return text values, but these are implicitly converted to numerical values on the fly by the need to apply the "+" operator in the formulae. I trust this helps. Brian Barker -- To u

Re: [libreoffice-users] Inverting a whole column

m. 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:

Re: [libreoffice-users] remove duplicate rows in calc?

nd paste back or elsewhere as desired. 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

Re: [libreoffice-users] Tab stops

stioner is having difficulty with? No harm in trying, though ... 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/Netiqu

Re: [libreoffice-users] Repeat a footnote

and the relevant footnote under Selection. o Click Insert and Close. 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.d

Re: [libreoffice-users] Edit contour not working

Wrap tab of the Image dialogue (Format | Image | Properties | Wrap or right-click | Properties | Wrap), do you not see Spacing? Increase Right to some suitable positive value. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems

Re: [libreoffice-users] Lost messages [was: Getting a Red-box around Cell entries or Selected Areas]

that I was wrong. My btinternet.com mail has been provided for some time by Yahoo, but was changed a few days ago and is no longer. My new mail arrangements no longer show the problem. But M. Gauthier is still out of luck - and it's the fault of the LibreOffice Users list, not his yahoo.co

Re: [libreoffice-users] Lost messages [was: Getting a Red-box around Cell entries or Selected Areas]

y the standards and reject my messages as forwarded by the list. (So I'm copying this to you privately.) The current situation at the list s tedious and unsupportable. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.or

Re: [libreoffice-users] Range names

r you. I'm going to write a macro for it, ... Which of the thirty-two variations will it replace? 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

Re: [libreoffice-users] Splitting columns in Calc

your original column A (so that the new columns now become columns A and B). 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] Calc- find & replace with specific formatting

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.libre

Re: [libreoffice-users] Re-flow text in Writer

indeed have line breaks, \n will match them. But paragraph breaks are not line breaks, and \n will not match paragraph breaks. 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

Re: [libreoffice-users] Open .csv by specifying column widths on command line

ck cell A1 or select all (as above). o Paste, but using Edit | Paste Special (or Ctrl+Shift+V) instead of normal Paste. In the Paste Special dialogue, ensure that Formats is *not* ticked. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice

Re: [libreoffice-users] Re: Bouncing messages from users@global.libreoffice.org

o about this as long ago as 1 May 2018, but my suggestion for action was rejected, on the ground that "none of the workarounds [are] satisfactory for everyone". Thus the problem continues. The present arrangement is unsupportable. You or others could start a campaign to have it put righ

Re: [libreoffice-users] Adding a / (forward slash)

ent numbers in a simple way). What do you expect if you try to divide "three" by "two"? "one point five"?! Any ideas? Yes. Take the concatenated slash off your formula so that it creates the number 41 in S4, as before. Then use =S4&" / "&366-S4 fo

Re: [libreoffice-users] Adding a / (forward slash)

ot;&" operator, so just put &"/" after any of these formulae, such as =R4-DATE(YEAR(R4)-1;12;31)&"/" The numerical value 41 is implicitly converted to a string and concatenated with the slash to create the *string* 41/ . I trust this helps. Brian Bar

Re: [libreoffice-users] cannot find and replace paragraph break in writer

aragraph - and it is this that you need to delete. Just search for ^$ (caret - dollar) and replace with nothing. 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] cannot find and replace paragraph break in writer

of a paragraph. The replace string replaces whatever that character is and adds a tab character. Then: o Search for $ (dollar). o Replace with nothing. There may be more elegant solutions ... I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice

Re: [libreoffice-users] Changing the case of first letter of every paragraph

ed for "Match case".) o With the cursor in the Replace box, click Format... . o On the Font Effects tab, for Effects select Capitals. o Replace All. o Voilà! Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-

Re: [libreoffice-users] Re : Bouncing messages from users@global.libreoffice.org

ist providers do this. I wrote to about this as long ago as 1 May 2018, but my suggestion for action was rejected, on the ground that "none of the workarounds [are] satisfactory for everyone". Thus the problem continues ... Brian Barker -- To unsubscribe e-mail to: users+unsubscr...

  1   2   3   4   5   6   7   8   9   10   >