search

dhatim / fastexcel

Generate and read big Excel files quickly
Other
677 stars 122 forks source link

Comments vs Notes #381

Open dgappc opened 8 months ago

dgappc commented 8 months ago

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 commented 8 months ago

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

GuopingYe commented 5 months ago

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