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 trust this
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
u 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 trust thi
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
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 archive
| 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
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+unsubscr
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-mail to: users
n
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.libreoffice.
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
in the 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
(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/
Posting guidelines + more
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 unsubscr
=$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.org
Pro
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.
Br
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 reporting
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 cel
ays:
"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."
Brian Barker
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 this helps.
Brian Bar
.
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/
Posting guideli
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/
Posting
r 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.
I trust this
rsor 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.libreoffice.org/get-help/mailing-l
single 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? https
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
--
To unsubscribe e-mai
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 guidelines + more: https://wiki.doc
, 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+unsubscr
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 to: users+
if 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 + more: h
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: users+unsubscr
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 Guide.
I trust this helps.
Brian
f 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$"()))=1
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to:
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-mail to: user
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 guidelines + more: https
&"-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 archive:
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...@global.l
rs 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.documentfoundati
quot;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.documentfoundati
s 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 Excel format
of 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.libreoffi
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.documentfoundation.org/Netiquette
ace 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-unsubscribe/
Post
o 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 guidelines + more: https://wiki.documen
bly 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://wiki.doc
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 paragraphs
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://www.libreoffice.
value before you
concatenate it with the text "Monday". To do that, use
="Monday "(January.$A5)
Depending on exactly what you need, have you considered using
=TEXT(January.$A5;"D")
instead?
I trust this helps.
Brian Barker
--
To unsubscribe e-mail
, 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 tabular.
I trus
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
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.libreoffice
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-lists/how-to-unsub
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
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
use 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
--
To unsubscri
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)*((M
mber 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...@global.libreoffice.org
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 to B365. The references t
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
lculate |
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: https://wiki.do
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
corresponding 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.org/get-help
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
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
with an 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
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 guidelines + more: https
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: users+unsubscr
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
a
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
y) so that 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.
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 unsubsc
f
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.)
Brian Barker
toCorrect 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.)
I trust
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
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 time values over twent
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 "
;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 unsubscr
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
r 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
List archive:
er 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/Netiquette
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.documentfoundation.org/Netiquette
List archive
to the 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
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.com.
Brian
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.org/get-help
ite 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-to-unsubscribe/
Posting guide
inal 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://wiki.doc
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
ve 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-to-unsubs
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.org
Probl
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 right.
Brian Barker
--
T
f 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
for your result.
I trust this helps.
Brian Barker
tor, 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 Barker
--
To unsubscr
paragraph - 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/
Posting
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.org
Probl
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-
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...@global.libreoffice.org
Problems
te Special with Formulae unticked.
Oh, and by the way, unless something very strange is about to happen,
I'm expecting 2 January 2020 to be a Thursday, not a Wednesday!
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Probl
ll work with page styles first.
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.documentfoundation.org/
possibility of a break of style occurs between every sheet.
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
date from the data entry area.
With this scheme, any mistaken entries can be corrected with the
display table always picking up the corrected values.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.or
values in column B to be one
greater than they are. That's a contradiction. If the value in Bn is
four, you want it to be five. But that means it's no longer four. And
if it's now five, how would any formula know you do not want it to be
six? And so on?
I trust this helps.
Brian Barker
1 - 100 of 1341 matches
Mail list logo