[Solved] Copy trendline equation as plain text

Discuss the spreadsheet application
Post Reply
Entreee
Posts: 4
Joined: Tue Apr 23, 2013 11:39 pm

[Solved] Copy trendline equation as plain text

Post by Entreee »

Hi, I can copy the formula and then paste it into another Calc cell. But how can I copy/paste it as plain text so that I can just paste that into Notepad? I tried pasting it into Writer and then saving as a *.txt file, but then the formula just disappears and doesn't appear in the output file.Thanks.
Last edited by Entreee on Tue Jul 30, 2013 1:06 am, edited 1 time in total.
Open Office 3.4.1 on Windows 7
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: copy trendline equation as plain text

Post by acknak »

Here's one way:

Copy the equation in the chart to clipboard.

Start a new OO Draw window: File > New > Drawing

Paste the equation

Select the equation and right-click > Break

Now you can click into the text and copy/paste it as plain text anywhere you like.

Sorry, it's not very convenient. Maybe someone else has an easier way?
AOO4/LO5 • Linux • Fedora 23
Entreee
Posts: 4
Joined: Tue Apr 23, 2013 11:39 pm

Re: copy trendline equation as plain text

Post by Entreee »

That works fine. Thank you, acknak.
Open Office 3.4.1 on Windows 7
Post Reply