Ask Your Question

Stray Text Indelibly Embedded in Chart

asked 2019-07-17 07:21:51 +0200

randress gravatar image

Several times while working with a chart (xy scatter) I have looked up to find some unwanted text on the chart. This time it is a lower case 't'. I have tried all I could think of to reveal, grab, and delete it, but nothing I tried has worked.

I have attached a jpg showing the 't' at the center, in the chart.(letter-t-in-the-center.jpg) I have also attached a jpg showing that if I shrink the actual plot, the 't' remains in the center of the 'canvas'. (letter-t-on-canvas.jpg) Finally, I have attached a skeleton calc file: what's left after deleting most of the content.(LibreOffice-Example-letter-t.ods)

C:\fakepath\letter-t-in-the-center.jpg C:\fakepath\letter-t-on-canvas.jpg C:\fakepath\LibreOffice-Example-letter-t.ods

Any suggestions? -Randal

edit retag flag offensive close merge delete


Neither on LO 6242 nor on OpenOffice 416 I could find the unwanted character. Even after altering some values in cells. Could you rename your office profile - probably a corrupt profile can cause such weird results...

Grantler gravatar imageGrantler ( 2019-07-17 07:56:20 +0200 )edit

Grantlier, thanks for the suggestion. However, renaming the .../4/user folder to force the creation of a new profile did not rid me of the 't'. -Randal

randress gravatar imagerandress ( 2019-07-17 16:24:29 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-07-17 17:53:17 +0200

erAck gravatar image

Loading the document in any version I do see the t character at the position of about E79:E80 in the centre of the draw object. I found it to be the draw object's text anchor. I don't know why it is displayed here but not on a freshly created chart. However, seeing that you used LibreOffice 6.1.3 to store the file you can move it out of sight by right clicking on the chart object and from the context menu select Text... and then pick another Text Anchor position, but I can't get rid of it. Later versions don't offer the Text menu entry there anymore, and it also doesn't make sense because the chart frame isn't a text frame object, but maybe that's the reason the anchor position is displayed at all for this object created using 6.1.3.

edit flag offensive delete link more

answered 2019-07-17 20:20:40 +0200

randress gravatar image

erAck, Thanks identifying this 't' as a responding to Text properties. I can now remove the 't' by doing the following 1) Left-click on the chart area, 2) Left-click on the "Insert Text Box" button, 3) mouse over the 't' and the cursor turns to a vertical bar (text editing bar), 4) Left-click to position the bar after the 't', and finally 5) enter "backspace" to delete it!. Thanks, again for your response, -Randal

edit flag offensive delete link more


Oh it was actual text? I didn't try that, lol :-)

erAck gravatar imageerAck ( 2019-07-18 20:44:36 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-17 07:21:51 +0200

Seen: 22 times

Last updated: Jul 17