12

I have designed a schedule in Google Sheets that uses emoji to indicate the character of each days activities. They display perfectly in Google Sheets. I want to physically print the sheet but when I try to export to PDF they disappear leaving behind the dreaded crossed boxes. I have also tried to export to HTML and then print the resulting page. This does preserve the emoji but badly breaks the layout on print.

My question is this-- can it be done? Can I print emoji from google sheets or will I have to redo my work in a different program.

Improve this question
1
  • Hey, seems like an encoding issue, not sure what can be done. Try maybe some picture instead of emojis ? here's an example. You can check for corresponding image at emojipedia.org
    – pjmg
    Aug 6, 2019 at 20:58

5 Answers 5

Reset to default
3

Try using image instead of emojis?

here's a sample 

=IMAGE("https://s3.amazonaws.com/pix.iemoji.com/images/emoji/apple/ios-12/256/face-with-tears-of-joy.png")

Links of images come from emojipedia.

Improve this answer
4

I exported the document to excel and it shows the emojis and then they print from there.

Improve this answer
1
  • This doesn't work in my old version of Excel 2007, but perhaps it does in more recent versions.
    – Simon East
    Oct 7, 2022 at 10:08
2
+500

Solution

As I explained in this Answer

  • Export your Sheet as Web page (.Html)

enter image description here

  • Open with a browser and save as a PDF
  • Open the PDF with a PDF editor or Illustrator and delet columns and rows grids

enter image description here

Improve this answer
2

I've reported this as an issue here: https://issuetracker.google.com/issues/241147770

Please vote the issue if you want Google to solve it.

Note: when I use fonr Noto Emoji emojis are printed, but they are not colored.

enter image description here

To use this font select 'More Fonts' option.

Improve this answer
1

if you don't have to choose exact font, emoji containing cells that are formatted with "Inconsolata" or "Sawarabi Mincho" are perfectly exported to PDF.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.