topic How to copy formatted notebook output to the clipboard ? in Data Engineering

How to copy formatted notebook output to the clipboard ?

ramonsuarez — Thu, 04 Jan 2024 15:15:13 GMT

Hi,

I'm having trouble copy-pasting for my documentation.

When I have content that cannot be downloaded as a file via the menu on top of the output cell, I copy it to the clibpoard, but when I paste it none of the formatting is respected and I end up with a mess.

E.g.: I print out multiple dataframes with .show() within the same code cell and then I try to copy and paste the results.

As I'm having more than a single dataframe in the output cell, there's no download option.

I do this a lot when debugging, and it is not workable to add a new cell after every few lines.

If I could save the result to a file in my local computer it could be helpful too.

I've tried both with Windows and Linux computers and on multiple browsers (also Edge).

Thanks for your help 🙂

Re: How to copy formatted notebook output to the clipboard ?

Anonymous — Fri, 05 Jan 2024 05:28:51 GMT

Hi ramonsuarez ,

Thanks for using Fabric Community.

As I understand you are looking for option to download the dataframe.
Can you try using below function:

display(df)

Hope this is helpful. Please let me know incase of further queries.

Re: How to copy formatted notebook output to the clipboard ?

Anonymous — Mon, 08 Jan 2024 07:20:17 GMT

Hi ramonsuarez ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
Otherwise, will respond back with the more details and we will try to help .

Re: How to copy formatted notebook output to the clipboard ?

ramonsuarez — Mon, 08 Jan 2024 13:47:46 GMT

No, I'm not looking for an option to download the dataframe. I know how to do that.

The issue is when I want to copy and paste results that are not single dataframes.

Examples:

* Result of a query with the schemas of multiple tables of my lakehouse

* Anything diplayed as one or more tables that does not use display().

Re: How to copy formatted notebook output to the clipboard ?

Anonymous — Tue, 09 Jan 2024 12:08:06 GMT

Hi ramonsuarez ,

When I tried to display to two tables using .show(), I was able to drag and copy the dataframes to a notepad without any issue.

In case if your requirment is quite different and it is not supported in Fabric Notebooks.

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Hope this helps. Please let me know if you have any further queries.

Re: How to copy formatted notebook output to the clipboard ?

ramonsuarez — Tue, 09 Jan 2024 13:05:55 GMT

Thanks for the work around, but the issue persists with Word, Obsidian, and Google Docs.

With this extra step the format is preserved when copying and pasting from Notepad.

Re: How to copy formatted notebook output to the clipboard ?

Anonymous — Tue, 09 Jan 2024 14:02:03 GMT

Hi ramonsuarez ,

Now I can understand your issue more clearly.
This issue looks like Word, Obsidian, and Google Docs are not supporting this format.
We didn't find any issue when we copied it to notepad.
Currently we only support this format only, apologies for that.

Appreciate if you could share the feedback on our feedback channel for feature request like copy clipboard option. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Hope this is helpful. Please let me know if you have any further queries.

Re: How to copy formatted notebook output to the clipboard ?

ramonsuarez — Tue, 09 Jan 2024 19:44:08 GMT

Thanks, here's the feedback requesting a fix on the Fabric Ideas platform.