We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

David.Cheshire's profile - activity

2021-05-18 13:17:16 +0200 received badge  Popular Question (source)
2021-05-08 11:37:51 +0200 commented question Writer: Endnote link pointer disappeared

Thanks. Actually there are no figures at all in the original document, the only things other than text are the endnotes,

2021-05-08 11:13:48 +0200 commented question Writer: Endnote link pointer disappeared

Yes, I have 7.0.3.1 on my laptop and the cursor does change to hand when hovering over note anchor or note number. Bug 1

2021-05-08 10:53:07 +0200 commented question Writer: Endnote link pointer disappeared

Yes, I have 7.0.3.1 on my laptop and the cursor does change to hand when hovering over note anchor or note number. I'll

2021-05-08 10:49:18 +0200 received badge  Enthusiast
2021-05-07 15:37:16 +0200 commented question Writer: Endnote link pointer disappeared

I am using 7.1.3.2 (x64) and it definitely behaves as I describe, but you say that with 7.0.5.2 the example document tha

2021-05-07 13:05:15 +0200 asked a question Writer: Endnote link pointer disappeared

Endnote link pointer disappeared I edited the style of the Endnote Anchor to make it easier to see, but now the cursor d

2021-04-22 13:45:39 +0200 marked best answer Endnote format lost in .docx

I wrote an article in .odt format with a lot of references as endnotes, with the style "Endnote". When I save this document in .docx format, the endnote style changes to "Endnote Symbol" and the indention of some, but not all of the endnotes is lost. Viewing the style "Endnote Symbol", the indention is all zero.

The style "Endnote" that existed when the document was in .odt format no longer appears in the drop down list of styles, so I cannot apply that to the endnotes.

2020-12-02 01:15:49 +0200 received badge  Famous Question (source)
2020-12-02 01:15:49 +0200 received badge  Notable Question (source)
2020-12-02 01:15:49 +0200 received badge  Popular Question (source)
2020-11-03 12:31:11 +0200 received badge  Notable Question (source)
2020-11-02 20:31:30 +0200 commented answer Version 7.0.2.2 Autocalculate Not Working

Thanks, that certainly helps. This really worried me when I saw it, so I was relieved to know that it is a actually a re

2020-11-02 20:28:08 +0200 received badge  Popular Question (source)
2020-11-02 16:44:28 +0200 asked a question Version 7.0.2.2 Autocalculate Not Working

Version 7.0.2.2 Autocalculate Not Working Using version 7.0.2.2 (x64) on Windows 10 Build 19041 Attached sheet shows pr

2020-10-19 03:30:34 +0200 marked best answer Can Calc use Math to show Formulas?

When I edit a formula in Writer it shows the equation graphically in the document, which helps to identify errors.

When I edit the same equation in Calc it shows the operators and cell references like this:

=(1+C$3*$B10)*(1-C$5*$B10)/SQRT((1+C$4*$B10)^3*(1-C$6*$B10-C$7*$B10^2))

It is not so easy to spot errors in this. It would be useful if Calc were able to display the formula graphically in equation form like Writer does.

The page www.libreoffice.org/discover/math/ says "Math is LibreOffice's formula editor, and can be invoked in your text documents, spreadsheets, presentations and drawings, " and I know that Math can be linked into Calc to enter graphical formulas into the sheet as illustrations rather than working equations.

Can Math be used to graphically display a formula already entered into a Calc cell?

2020-09-12 22:17:24 +0200 marked best answer Use Calc to plot a line on an image of a chart?

I have an image of a chart showing Young's modulus of iron plotted against temperature. There are several sets of data from different studies shown on the chart as curves and I would like to be able to overlay onto this a line that is a reasonable fit amongst these curves.

I tried to do this by generating a chart in Calc and setting the background to 100% transparent. I hoped that when I exported this to a .png file the transparency would remain so that I could overlay this chart on the image and the image would still be visible beneath the chart, but the exported .png chart has an opaque white background.

Any suggestions as to how I can use Calc to plot a line on an existing image of a chart would be welcomed.

2020-09-12 22:16:52 +0200 received badge  Famous Question (source)
2020-09-12 22:16:52 +0200 received badge  Notable Question (source)
2020-09-12 22:16:52 +0200 received badge  Popular Question (source)
2020-05-09 04:59:22 +0200 received badge  Notable Question (source)
2020-05-09 04:59:22 +0200 received badge  Famous Question (source)
2020-04-29 13:56:25 +0200 commented answer Calc: Display Text Labels on X-Axis

Perfect, thank you so much.

2020-04-29 13:56:07 +0200 marked best answer Calc: Display Text Labels on X-Axis

I have three columns of data which I am plotting an x/y chart. I wish to have the x-axis labels taken from the first column. This does not happen automatically, the x-axis is labelled 0 - 10 even though the correct range for the x-axis labels is shown when the chart is being created.

Previous questions and the LibreOffice Help implies that this can be corrected by editing the chart, right clicking on the x-axis, choosing "Format Axis" and in the "Scale" tab choose "Text" from a combo box. But in the scale tab I don't see such a combo box.

image description

I would be grateful if somebody would explain what I am doing wrong. I attach the example sheet: C:\fakepath\Untitled 1.ods

2020-04-29 13:56:07 +0200 received badge  Scholar (source)
2020-04-29 12:29:47 +0200 asked a question Calc: Display Text Labels on X-Axis

Calc: Display Text Labels on X-Axis I have three columns of data which I am plotting an x/y chart. I wish to have the x-

2019-12-29 16:44:14 +0200 received badge  Notable Question (source)
2019-12-29 16:44:14 +0200 received badge  Famous Question (source)
2019-08-25 14:25:07 +0200 received badge  Famous Question (source)
2019-08-25 14:25:07 +0200 received badge  Notable Question (source)
2019-08-25 14:25:07 +0200 received badge  Popular Question (source)
2018-12-18 15:39:54 +0200 received badge  Popular Question (source)
2018-12-17 11:59:11 +0200 received badge  Famous Question (source)
2018-12-17 11:49:01 +0200 commented question Icons: Laptop vs Desktop

Thanks, good to know that it's not something stupid that I have done!

2018-12-17 11:38:12 +0200 asked a question Icons: Laptop vs Desktop

Icons: Laptop vs Desktop The icons on my laptop different from those on my desktop. The images show first the laptop the

2018-08-01 16:36:46 +0200 received badge  Popular Question (source)
2018-08-01 15:07:50 +0200 received badge  Commentator
2018-08-01 15:07:50 +0200 commented answer Highlight Endnote Reference in Text

Ah, I hadn't spotted that there are predefined character styles as well as paragraph style. Your suggestion worked perfe

2018-08-01 13:57:43 +0200 asked a question Highlight Endnote Reference in Text

Highlight Endnote Reference in Text I would like to highlight endnote references in the body of the text to make proof r

2018-08-01 13:48:38 +0200 commented answer Align Zeros on Primary and Secondary Y Axes?

Thanks for your suggestions. Unfortunately I had already tried them without success.

2018-08-01 13:46:52 +0200 received badge  Popular Question (source)
2018-07-16 18:35:34 +0200 asked a question Align Zeros on Primary and Secondary Y Axes?

Align Zeros on Primary and Secondary Y Axes? I have created this chart in Calc with two curves that align to different Y

2018-06-02 11:08:33 +0200 received badge  Famous Question (source)
2018-03-16 17:41:46 +0200 commented answer Change notebook layout back to default?

Same thing happened to me. I thought I would try the Notebookbar to see if it was as useless as it is in MS Word, and it

2018-03-04 12:42:39 +0200 answered a question Endnote format lost in .docx

The problem appears to arise because Word uses separate styles for the endnote symbol and endnote text, but Writer uses

2018-03-04 12:42:14 +0200 edited question Endnote format lost in .docx

Endnote format lost in .docx I wrote an article in .odt format with a lot of references as endnotes, with the style "End

2018-03-04 12:41:25 +0200 edited question Endnote format lost in .docx

Endnote format lost in .docx I wrote an article in .odt format with a lot of references as endnotes, with the style "End