Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Nov 04, 2020 1:36 pm

Hello, i have a program uses spire xsl to read 30 xsl files with hebrew text
text = "שלום לכולם מה קורה"
converting to pdf:
val workbook: Workbook = Workbook()

workbook.loadFromFile("$f_name.xlsx")
workbook.isRightToLeft(true)

workbook.activeSheet.cells.forEach {
it.style.shrinkToFit = true
// if (second)
// it.text = it.text.split(" ").reversed().joinToString("_")
}

workbook.converterSetting.setSheetFitToPage(true)
val file = File("$f_name.pdf")
val fos = FileOutputStream(file)

workbook.saveToStream(fos, FileFormat.PDF)
fos.close()

the first xsl is converted ok.
all the others are flipped text
for example
output pdf have text: "קורה מה כולם שלום"
reverse as it was in the first cell of the xsl.

thanks

yotamkima
 
Posts: 2
Joined: Mon Nov 02, 2020 11:15 pm

Thu Nov 05, 2020 5:53 am

Hello,

Thanks for your inquiry.
Are you using our Spire.XLS for Java? According to your description, I simulated an Excel file and then tested with the latest Spire.XLS for Java Version:3.9.3, and indeed found that the text in the generated PDF was flipped.
I have posted this issue to our Dev team with the ticket SPIREXLS-2911 for further investigation. We will keep you informed if there is any progress. Sorry for the inconvenience caused.

Sincerely,
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Thu Nov 05, 2020 7:44 am

yes i am using the latest spire.xsl for java. are you going to update me here about it?

yotamkima
 
Posts: 2
Joined: Mon Nov 02, 2020 11:15 pm

Thu Nov 05, 2020 9:16 am

Yes, we will update you on the progress of this issue here.

Sincerely,
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Wed Nov 11, 2020 1:51 am

Hello,

Hope you are doing well.
After further investigation, we found that this issue may be related to fonts. We have verified that after installing the font "Arial Unicode MS", the generated PDF content is correct.
Please confirm whether this font is installed on your computer, if not, please install it and test again.
If the issue persists, please share your source Excel file to help us investigate further. Thanks in advance.

Sincerely,
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Thu Dec 10, 2020 9:41 am

Hello,

Hope you are doing well.
Regarding the issue SPIREXLS-2911, our Dev team has adjusted the internal code and no longer requires to install the font "Arial Unicode MS". Welcome to download the newly released Spire.XLS for Java Version:3.12.3 from the following links and test.
Our website: https://www.e-iceblue.com/Download/xls-for-java.html
Maven: http://repo.e-iceblue.com/nexus/content ... ls/3.12.3/

Sincerely,
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Return to Spire.XLS