Converted MS Offiice in the page does not display Korean letter at all.

[kimkk]

Dear Confluence support team,

I had added an excel file, where inlcudes Korean letters by drag and drop in a confluence page.

The contents Page itself display Korean letters correctly. However, the contents of  excel file contents is not displayed properly.  All Korean letters in the excel in the page are displayed as rectangle.

Original Excel file snapshot is as follows:

excel_test.png

However, it is displayed like as follows:

excel_test_snapshot.png

For your Information,

• Browser: IE 11.0.9600.18282
• Confluence Server Host machine: Linux 64 bit (Ubuntu 14.04)
• Confluence version 5.9.12 (installed via 64 bit linux installer)
• Korean fonts are located at /opt/atlassian/confluence/jre/lib/fonts/fallback

The start message of confluence as follows:

$ sudo ./start-confluence.sh

To run Confluence in the foreground, start the server with start-confluence.sh -fg
executing using dedicated user: confluence
If you encounter issues starting up Confluence, please see the Installation guide at http://confluence.atlassian.com/display/DOC/Confluence+Installation+Guide

Server startup logs are located in /opt/atlassian/confluence/logs/catalina.out
./catalina.sh: 54: /opt/atlassian/confluence/bin/setenv.sh: confluence.document.conversion.fontpath=/usr/share/fonts/truetype/msttcorefonts: not found
Using CATALINA_BASE: /opt/atlassian/confluence
Using CATALINA_HOME: /opt/atlassian/confluence
Using CATALINA_TMPDIR: /opt/atlassian/confluence/temp
Using JRE_HOME: /opt/atlassian/confluence/jre/
Using CLASSPATH: /opt/atlassian/confluence/bin/bootstrap.jar:/opt/atlassian/confluence/bin/tomcat-juli.jar
Using CATALINA_PID: /opt/atlassian/confluence/work/catalina.pid
Tomcat started.

The contents of /opt/atlassian/confluence/bin/setenv.sh are

# See the CATALINA_OPTS below for tuning the JVM arguments used to start Confluence.

echo "If you encounter issues starting up Confluence, please see the Installation guide at http://confluence.atlassian.com/display/DOC/Conflu

# set the location of the pid file
if [ -z "$CATALINA_PID" ] ; then
if [ -n "$CATALINA_BASE" ] ; then
CATALINA_PID="$CATALINA_BASE"/work/catalina.pid
elif [ -n "$CATALINA_HOME" ] ; then
CATALINA_PID="$CATALINA_HOME"/work/catalina.pid
fi
fi
export CATALINA_PID

PRGDIR=`dirname "$0"`
if [ -z "$CATALINA_BASE" ]; then
if [ -z "$CATALINA_HOME" ]; then
LOGBASE=$PRGDIR
LOGTAIL=..
else
LOGBASE=$CATALINA_HOME
LOGTAIL=.
fi
else
LOGBASE=$CATALINA_BASE
LOGTAIL=.
fi

PUSHED_DIR=`pwd`
cd $LOGBASE
cd $LOGTAIL
LOGBASEABS=`pwd`
cd $PUSHED_DIR

echo ""
echo "Server startup logs are located in $LOGBASEABS/logs/catalina.out"

# Set the JVM arguments used to start Confluence. For a description of the options, see
# http://www.oracle.com/technetwork/java/javase/tech/vmoptions-jsp-140102.html
CATALINA_OPTS="-XX:-PrintGCDetails -XX:+PrintGCTimeStamps -XX:-PrintTenuringDistribution ${CATALINA_OPTS}"
CATALINA_OPTS="-Xloggc:$LOGBASEABS/logs/gc-`date +%F_%H-%M-%S`.log -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=5 -XX:GCLogFileSize=2M ${
CATALINA_OPTS="-Djava.awt.headless=true ${CATALINA_OPTS}"
CATALINA_OPTS="-Datlassian.plugins.enable.wait=300 ${CATALINA_OPTS}"
CATALINA_OPTS="-Xms1024m -Xmx1024m -XX:+UseG1GC ${CATALINA_OPTS}"

export CATALINA_OPTS

JRE_HOME="/opt/atlassian/confluence/jre/"; export JRE_HOME

# added by kimkk

# ref: https://confluence.atlassian.com/confkb/the-text-in-a-powerpoint-excel-or-word-document-looks-different-when-using-the-viewfile-macro-200213562.html

confluence.document.conversion.fontpath="/usr/share/fonts/truetype/msttcorefonts"

[Stephen Deutsch · Accepted solution]

Taking a look at this issue:

https://jira.atlassian.com/browse/CONF-36557

It seems like you may have to install the fonts in /usr/share/fonts.

잘 되었으면 좋겠어요...

[kimkk]

Dear Stephen Deutsch,

Thanks for your hint.

My mistake was in setting of setenve.sh

confluence.document.conversion.fontpath="/usr/share/fonts/truetype/msttcorefonts"

It is modified as follows:

CATALINA_OPTS="-Dconfluence.document.conversion.fontpath=/opt/atlassian/confluence/jre/lib/fonts/fallback ${CATALINA_OPTS}"

Thanks again for your interest and help.

BR