Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Comments vs Notes #381

Open
dgappc opened this issue Jan 15, 2024 · 2 comments
Open

Comments vs Notes #381

dgappc opened this issue Jan 15, 2024 · 2 comments

Comments

@dgappc
Copy link

dgappc commented Jan 15, 2024

MS Excel has a new feature called Notes which are similar to Comments. In the new excel you can choose whether text attached to cells appears as the old Comments (visible as rectangular box on click) or as Notes (visible as an image with a weird arrow)

When we use the fastexcel call for comments as below:
ws.comment(rownum, cellnum, "comment text");

The comments sometimes (at random) appears as a Note instead of a Comment (which is what we want). See attached file.

Does anybody know why this happens and is there a way to always force it to be Comment and never a Note.

Export to Excel notes format.xlsx

@meiMingle
Copy link
Collaborator

Sorry, the attachment you provided does not seem to be generated by fastexcel. I cannot reproduce this problem.

@GuopingYe
Copy link

GuopingYe commented Apr 8, 2024

Sorry, the attachment you provided does not seem to be generated by fastexcel. I cannot reproduce this problem.

@meiMingle Hi meiMingle, I encountered into the same issue, you can reproduce it by

  1. Generating a excel file with comment via fastexcel
  2. Open this excel file(I'm using MS Excel 365), the comment looks normal
  3. Save this excel as another file, I tested save as .xlsx only
  4. Open the new saved excel, the arrow appears

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants