Conversion XLS to PDF > footer problem

[zorro012]

product version : Spire.XLS for .NET Free Edition Version:13.1.1.5046

When saving a file using worksheet1.SaveToPdf(save file name), the footer is different when saving it as a PDF using Excel as shown in the attached image and when saving it as a PDF using worksheet1.SaveToPdf(save file name).
When using worksheet1.SaveToPdf(save file name), the body of the file covers the footer.
Is there a solution?

[Doris.Liu]

Hi,

Thanks for your message.
Since our commercial latest version 14.10.2 contains more fixes and is more stable, I recommend that you use our latest commercial version for testing. If you still encounter issues with the commercial version, please provide the test files for us to further investigate.
Spire.XLS Pack(Hotfix) Version:14.10.2: https://www.e-iceblue.com/Download/down ... t-now.html

Sincerely,
Doris
E-iceblue support team

[zorro012]

The same symptom occurs even when using Spire.XLS Pack (Hotfix) Version:14.10.2 as you replied. I am sending you a test Excel file, so please check it.

[Doris.Liu]

Hi,

Thank you for your sharing.
After investigation, this issue arises due to differences in regional formats. Please add the following code for testing before performing the conversion. After I added it, the conversion effect matched the image on the left.

Code: Select all

Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("ko-KR");

Sincerely,
Doris
E-iceblue support team

[zorro012]

Thank you for your reply.

I have the same problem even after applying the code you sent.

Is there any other solution?

[Doris.Liu]

Hi,

I attached my project and output file for your reference. Please download it and run it directly.
If you still encounter issues during testing, please provide the following information for us to further investigate:

1. Operating System (e.g., Windows 11)
2. Region/Locale Format (e.g., China/Chinese)

[zorro012]

The left side of the attached file is a picture created using the source you sent, and the right side is a file saved as a PDF from Excel.
If you look closely, the left and right margins, column spacing, etc. are subtly different, and
the text on the left side slightly covers the footnote below.

1. Operating System : Windows 11
2. Region/Locale Format : korea/korea

[Doris.Liu]

Thank you for your explanation.

If you'd like to reduce the left and right margins, you can use the following code. I've noticed that the footer in the PDFs converted by our product does tend to be closer to the borders, but I haven't observed the difference in column spacing you mentioned. Could you please provide a screenshot to highlight it?

Code: Select all

wb.ConverterSetting.SheetFitToWidth = true;

Additionally, the results I obtained using Microsoft Excel seem to differ from yours in terms of left and right margins. I converted the file using Microsoft Excel into two different styles and have attached them for your reference.

Sincerely,
Doris
E-iceblue support team