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.

Thu Feb 23, 2023 12:42 pm

We have a problem with the attached excel (test.zip) we also tried using the live demo.
The problem is the X in red, which appears displaced downwards within the image. (File IssueX attached)

Could you check the reason?
Attachments
IssueX.png
Left Side Orinial, Right Converted
IssueX.png (393.36 KiB) Viewed 2568 times
test.zip
Original File
(298.86 KiB) Downloaded 388 times

meneghette
 
Posts: 42
Joined: Tue Mar 08, 2022 12:10 pm

Fri Feb 24, 2023 2:17 am

Hi,

Thanks for your feedback.
I did a test and reproduced your issue, I have logged this issue into our bug tracking system with the ticket number SPIREXLS-4490, our developers will investigate and fix it, sorry for the inconvenience caused. Once the issue is fixed, I will inform you asap.

Sincerely,
Triste
E-iceblue support team
User avatar

Triste.Dai
 
Posts: 1000
Joined: Tue Nov 15, 2022 3:59 am

Fri Mar 24, 2023 9:16 am

Hi,

Thanks for your patience!
Glad to inform you that we just released Spire. Office for Java 8.3.6 for Java which fixes the issue with SPIREXLS-4490.
Please download the new version from the following link to test.
Website download link: https://www.e-iceblue.com/Download/office-for-java.html
Install from Maven Repository:
Code: Select all
<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.office</artifactId>
        <version>8.3.6</version>
    </dependency>
</dependencies>



Sincerely,
Triste
E-iceblue support team
User avatar

Triste.Dai
 
Posts: 1000
Joined: Tue Nov 15, 2022 3:59 am

Tue Mar 28, 2023 12:35 pm

We performed the test and attached is the result, on the left side the original file and the converted one on the right, the same file sent in the ticket was used
Horizontal is centered, but vertical is not, it is on the line , The square around the X, it is shifted up a little

Could you verify?

Test performed on JDK17 and Windows 11
Attachments
converted.png
converted.png (28.94 KiB) Viewed 2494 times

meneghette
 
Posts: 42
Joined: Tue Mar 08, 2022 12:10 pm

Wed Mar 29, 2023 4:13 am

Hi,

Thanks for your feedback.
Kindly note that our Spire.XLS follows the rules of MS Excel, the effect of converting your Excel file to image is basically the same as converting to pdf. The following image is a screenshot of converting your excel file to pdf format in MS Excel manually.
In Adobe Reader.png
In Adobe Reader.png (44.82 KiB) Viewed 2464 times

You can see that there also are some deviations. As for this issue, I have communicated with our developers, they informed that our product at present also cannot make more optimization. Thanks for your understanding.

Best regards,
Triste
E-iceblue support team
User avatar

Triste.Dai
 
Posts: 1000
Joined: Tue Nov 15, 2022 3:59 am

Return to Spire.XLS