[Solved] Copy trendline equation as plain text

Discuss the spreadsheet application

[Solved] Copy trendline equation as plain text

Postby Entreee » Tue Jul 30, 2013 12:17 am

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
Entreee
 
Posts: 4
Joined: Tue Apr 23, 2013 11:39 pm

Re: copy trendline equation as plain text

Postby acknak » Tue Jul 30, 2013 12:53 am

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
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

Postby Entreee » Tue Jul 30, 2013 1:02 am

That works fine. Thank you, acknak.
Open Office 3.4.1 on Windows 7
Entreee
 
Posts: 4
Joined: Tue Apr 23, 2013 11:39 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests