When the cell length is insufficient, Excel to PDF still displays the data but truncates some of it, resulting in the appearance of incorrect data
For financial statements, inaccurate data can be fatal
Is it the same as Excel and converted HTML, displaying incomplete information as ####### instead of using this truncation method to maintain consistency
in office：
image.png (9.9 KB)
html：
image.png (9.3 KB)
pdf：
image.png (19.7 KB)
this is my excel：
this is my code：
EPPR_95137.zip (31.8 KB)
Can you please provide more details about the specific issue you are facing with the Excel to PDF conversion? Are you looking for a solution to prevent data truncation, or do you need help with a specific part of your code?
@xhaixia
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSJAVA-46215
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
Is there any way to avoid the problem of truncated PDF exports
@xhaixia ,
Please share us some time to evaluate your issue first, we will be back once we have an update.
@xhaixia
As a temporary solution, please use the following example code to automatically adjust column width before exporting file to PDF format. Please refer to the attachment. out_java.pdf (23.5 KB)
Workbook book = new Workbook(filePath + "EPPR_95137.xlsx");
book.getWorksheets().get(0).autoFitColumns();
book.save(filePath + "out_java.pdf");
Hope helps a bit.
But this method will cause a change in the width of my entire table, especially when there are cells with long text
@xhaixia
If you open your sample file in Excel, we find that the data is still displayed with #. Please refer to the attachment. result.png (25.3 KB)
If exporting the file directly to PDF, displaying the data with # is the expected result.
What I hope is that the exported PDF and Excel will have the same effect. If they are not fully displayed, they will be displayed####
The current issue is that the exported PDF does not display #######, but rather displays incomplete data
image.png (18.7 KB)
@xhaixia
Thank you for your feedback. We have taken note of your issue. We are already evaluating your issue. Once there is an update, we will notify you promptly.
We are pleased to inform you that your issue (Ticket ID: “CELLSJAVA-46215”) has been resolved. The fix/enhancement will be included in the next release (Aspose.Cells v25.1) scheduled to be released before this week. We will notify you when the new version is released.
Currently, there are many projects on our end that have reported this issue. The aspose cell Java version we are currently using is 20.12
A large number of user reports have been upgraded from lower versions of ASPose
Setting the cell format of low versions of ASPose to numerical values does not result in this space occupying space. Upgrading to higher versions such as version 20.12, which we are currently using, has caused width issues due to the presence of extra spaces occupying space
The transition from version 20.12 to the latest version is quite extensive. We have previously upgraded from version 18 to 20 and received feedback on hundreds of inconsistent details. Therefore, we will not upgrade ASPose to the latest version in the short term
But the current export problem is that the data is not displayed as # # #, but truncated in these reports, which are basically financial reports. We will encounter this problem in upgrading a large number of reports here now and next year
Therefore, I would like to inquire if it is possible to fix this issue based on the 20.12 version we are currently using, or if you can provide us with a code enhanced fix package, etc. If a fee is required, it can also be considered
We are sorry but we cannot include fixes to older versions, as the fixes are based on the latest API set only. Apparently, there is no workaround except upgrading to newer versions to cope with it. But we will still check if there is any workaround to be adopted so you can cope with it or do something in the file manually. We will get back to you soon.
May I ask if there is any progress currently
@xhaixia
We will release v25.1 this week. Once the version v25.1 is released, we will notify you promptly.
The issues you have found earlier (filed as CELLSJAVA-46215) have been fixed in Aspose.Cells for Java 25.1.
May I inquire about the cause of this issue? Is it due to the influence of spaces after the cell format, or is it possible for this phenomenon to occur in extreme column widths regardless of whether the cell format is set or not
@xhaixia ,
The issue occurs when place holder is used in cell format. e.g. the last space in your case.