Skip to content

data_editor prevents Excel copying & pasting #6811

@xinyu-dev

Description

@xinyu-dev

Checklist

  • I have searched the existing issues for similar issues.
  • I added a very descriptive title to this issue.
  • I have provided sufficient information below to help reproduce this issue.

Summary

This issue is related to v1.23.0 streamlit editable dataframe
When deployed locally you can copy from Excel and paste into editable dataframe. However, when using the deployed on the network (e.g. using the network url), that feature is no longer supported.

Reproducible Code Example

No response

Steps To Reproduce

A simple example is to head over here: https://docs.streamlit.io/library/api-reference/data/st.data_editor
Try copying a few cells from Excel into the table there. You have to click into an individual and then paste it. You can’t paste the multiple cells at once.

I think this might be related to issue #6810 and https://discuss.streamlit.io/t/about-the-copy-and-paste-function-of-st-experimental-data-editor/42562/8 on the forum as well. This is probably related to " As with many new APIs, the Clipboard API is only supported for pages served over HTTPS. If your connection is not HTTPS or localhost, then the copy &paste won’t work. See Copy dataframe to clipboard - #14 by MesumRaza

Expected Behavior

No response

Current Behavior

No response

Is this a regression?

  • Yes, this used to work in a previous version.

Debug info

  • Streamlit version: 1.23.0 and 1.23.1
  • Python version: 3.10
  • Operating System: MacOS, Ubuntu
  • Browser: Chrome
  • Virtual environment:

Additional Information

No response

Are you willing to submit a PR?

  • Yes, I am willing to submit a PR!

Metadata

Metadata

Assignees

Labels

feature:st.data_editorRelated to the `st.data_editor` widgetstatus:confirmedBug has been confirmed by the Streamlit teamtype:bugSomething isn't working as expectedtype:docsRequests for changes to docs (will be rerouted to docs repo)

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions