Ask Your Question

bwechner's profile - activity

2019-10-15 01:02:35 +0200 commented answer If function returns number, use the number, else 0

Thanks kindly! Works a charm! Indeed, trapping errors suffices for me.

2019-10-15 01:01:56 +0200 commented answer If function returns number, use the number, else 0

Thanks kindly! Works a charm!

2019-10-15 00:58:43 +0200 marked best answer If function returns number, use the number, else 0

I find the canonical way of doing this repeats the function and can be VERY long-winded if the function has a load of arguments looking like:

=IF(ISNUMBER(F(x)); F(x); 0)

Is there some way of writing this generically with only one reference to F(x)? Akin to:

= VALUE(F(x), 0)

This would make for much more elegant formulae.

2019-10-14 17:31:27 +0200 received badge  Notable Question (source)
2019-10-14 11:04:39 +0200 received badge  Popular Question (source)
2019-10-14 03:16:11 +0200 asked a question If function returns number, use the number, else 0

If function returns number, use the number, else 0 I find the canonical way of doing this repeats the function and can b

2018-09-03 10:32:24 +0200 commented answer Use horizontal ruler to shift left indent but leave first line in place?

I'd upvote this but lack the karma ;-).

2018-09-03 10:31:07 +0200 marked best answer Use horizontal ruler to shift left indent but leave first line in place?

I find myself wanting to do this a LOT. I want to alter the left indent of the paragraph but leave the first line in place. There are three markers on the horizontal ruler:

  • first line
  • left indent
  • right indent

which map to the paragraph formats:

  • Indent, First line
  • Indent, Before text
  • Indent, After text

Alas moving (dragging) them has these affects:

  • first line marker - dragging it moves just that marker
  • right indent marker - dragging it moves just that marker
  • left indent marker - dragging it moves just that marker AND the first line marker

This last behaviour is very irritating! I would like to be able to move the left indent marker WITHOUT moving the first line marker. But I find no way to do it, not by dragging with SHIFT, or CTRL, or ALT held down nor any combination of them while dragging helps. Grrrrr.

Is there no way to do this? And if not, can we turn this into a feature request?

2018-09-03 10:31:07 +0200 received badge  Scholar (source)
2018-09-02 14:54:03 +0200 received badge  Famous Question (source)
2018-08-31 07:04:40 +0200 answered a question Use horizontal ruler to shift left indent but leave first line in place?

Turns out the answer is: It's not possible. But a feature request is filed here: https://bugs.documentfoundation.org/sh

2018-08-31 04:55:45 +0200 received badge  Notable Question (source)
2018-08-31 04:55:45 +0200 received badge  Famous Question (source)
2018-08-30 09:51:36 +0200 commented question Use horizontal ruler to shift left indent but leave first line in place?

To be honest, I prefer solutions to a stated problem that don't involve preaching on methodology. I filed it here: https

2018-08-17 07:32:53 +0200 received badge  Enthusiast
2018-08-07 03:11:22 +0200 received badge  Notable Question (source)
2018-08-03 06:16:01 +0200 commented question Use horizontal ruler to shift left indent but leave first line in place?

"One or two pagers shouldn't be a pain," - Unless you're doing a lot of them ... not that one persons view of pain need

2018-08-02 07:14:37 +0200 commented question Use horizontal ruler to shift left indent but leave first line in place?

Point fully taken, but all the same correctly offered as comments not an answer. Because the reality is, while I concur

2018-08-01 14:47:43 +0200 received badge  Popular Question (source)
2018-08-01 05:51:34 +0200 asked a question Use horizontal ruler to shift left indent but leave first line in place?

Use horizontal ruler to shift left indent but leave first line in place? I find myself wanting to do this a LOT. I want

2017-09-06 06:09:06 +0200 commented question After inserting a textbox, the keyboard cursor disappears

Ditto. Frustrating behaviour. Happens to me after adding a Math Equation.

2017-09-06 06:08:42 +0200 answered a question After inserting a textbox, the keyboard cursor disappears

Ditto. Frustrating behaviour. Happens to me after adding a Math Equation.

2017-03-22 12:43:50 +0200 received badge  Popular Question (source)
2016-12-01 11:59:34 +0200 asked a question How do I diagnose a Draw crash on opening a PDF?

Am a bit stuck. I have to machines, both with Linux Mint 18, and the latest LibreOffice. Reported as:

Version: 5.1.4.2
Build ID: 1:5.1.4-0ubuntu1
CPU Threads: 8; OS Version: Linux 4.4; UI Render: default; 
Locale: en-AU (en_AU.UTF-8)

on both machines.

Now I want to edit a PDF with Draw, something I've been doing for a long time on Windows at work. Works a dream and my tool of choice.

Yet, if I open a PDF on one machine Draw crashes, and immediately opens the recovery window, and if I try to recover it crashes, in an endless cycle until I delete the recovery info. Any PDF produces this result.

On the other machine, same PDF opens fine. As does any PDF.

So something on machine 1 is causing Draw a hernia.

How can I diagnose what? Can I run Draw in debug mode, find log files somewhere?

2012-10-29 11:00:00 +0200 answered a question LibreOffice 3.6 issues

Same problem here. Had me pzuzled till I googled it and saw others had it. What bamboozles me is that software CAN break jumplists, I'd have thought it was handled entirely by Windows. But there you go.

2012-10-29 10:59:39 +0200 answered a question LibreOffice 3.6 issues

Same problem here. Had me pzuzled till I googled it and saw others had it. What bamboozles me is that software CAN break jumplists, I'd have thought it was handled entirely by Windows. But there you go.