Open sdementen opened 5 months ago
Thanks for the request. The proposed behavior here seems intuitive to me, I'm supportive of this as long as the implementation is reasonable.
cc @attack68 for thoughts.
One difficulty I've encountered in the past is getting the comment size correct. If you do not set the size of a long comment (at least, using xlsxwriter), the comment is very difficult to read without resizing in Excel.
I think the implementation would not be too complicated.
The Styler Tooltips
object contains a DataFrame
of strings that would serve as the data to the written excel cells.
I expect that xlswriter procedure could check for the existence of a Tooltips
object. If none
writing to excel is unchanged and performance identical. If it exists then the yielded excel cells would have an extended routine to write the comment as provided by the tooltips string.
Not sure that Tooltips
is a widely used feature, however, but if someone was willing to explore this implementation I would help review.
Hi, this seems like an interesting issue that me and my colleague @diogomsmiranda would like to tackle. If we have any doubt about it we'll reply on this thread
take
take
Feature Type
[X] Adding new functionality to pandas
[ ] Changing existing functionality in pandas
[ ] Removing existing functionality in pandas
Problem Description
I wish I could use set_tooltips in the styler to generate notes in an excel workbook (via the to_excel)
Feature Description
No real API change, but have the ExcelFormatter use the information set by styler.set_tooltips to create not on the cells with a tooltip
Alternative Solutions
No idea for an alternative except the statu quo...
Additional Context
No response