Unable to convert FONT COLOR in Excel file to PDF correctly

Phatchanee Srikumporn 1 Reputation point
2021-03-05T10:09:07.36+00:00

I formatted font color in excel file, but when convert to PDF the font color all goes BLACK only.
I've tried converting excel file to pdf via save as, print and export to pdf, but same result for all method, font are black color only.

Another point I can observed is it's not happen with EN font, if all are type in EN, the font color converted are fine, but not with Thai font
I'm also ask my colleague do convert and it came out alright, correct color formatted font.

Please advice anything I can do, any setting wrong?

MS Office: 365 Apps for enterprise
OS: Window10 version 1903 (OS Build 18362. 1256)

Example:
74813-askms-convertexcelpdfnocolor.jpg

Windows 10 Setup
Windows 10 Setup
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
1,898 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,638 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 Reputation points
    2021-03-08T10:24:26.223+00:00

    @Phatchanee Srikumporn
    Based on your description, I have some questions below.

    • Does this issue occure with all workbooks (.xls file, .xlsx file)? Or does this issue just occur with specific workbooks?
      If the issue just exists on specific files, you can copy all the contents to a new workbook to have a check.
    • Is your colleague using the same version and version number of Office as yours?
      Please go to File > Account > Product Information > About Excel, check the version number.
    • Do Thai fonts lost color in Print Preview?
      If yes, you may go to PageLayout tab > Page Setup group > click Expanding Arrow in the lower right corner > Sheet tab, please make sure the checkbox of "Black and White" is not ticked.
      75338-capture22.png

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Phatchanee Srikumporn 1 Reputation point
    2021-03-08T12:57:37.507+00:00

    @Emily Hua-MSFT @Emily Hua-MSFT Thank you so much EmilyHua for your response. More information are as follows:-

    • Does this issue occurs with all workbooks (.xls file, .xlsx file)?
      >> Yes they're occurs with all workbook, even I create new workbook. The sentence with Thai font will not be convert with correct font color, so does the mixed EN-TH sentence, but the only EN sentence able to be converted correctly.
    • Is your colleague using the same version and version number of Office as yours? >>we use same version as attached.
    • Do Thai fonts lost color in Print Preview? >> No, for print preview the thai font color is perfect. And i've done checked "the black and white" box is not ticked. 75430-excelversion-nan.jpg