setHtmlString in 24 Aspose version

Aspose.Cells Product Family
1

Hi Team,

We are using Cell.setHtmlString function to set values inside a cell which contains html bold tag.

The below snippet of code

public static void main(String[] args) {
 // Instantiate a new workbook
    Workbook workbook = new Workbook();

    // Get the first worksheet
    Worksheet worksheet = workbook.getWorksheets().get(0);

    // Insert a string value to a cell
    worksheet.getCells().get("C2").setHtmlString("View by<b> Product </b>");

    // Save the Excel file
    try {
      workbook.save("C:\\Downloads\\setCell-NewAspose.xlsx");
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }

  }

Aspose cell version - 23.12 generates the excel like below

image.png (5.9 KB)

But When I use the latest aspose cells which is 24.6

the space between by and Product is not seen.

image.png (3.8 KB)

So, could you please check and confirm if this is a bug with 24.6 Aspose cells java ?

Thanks,
Thilak Babu

2

@Thilakbabu
By testing with sample code on the latest version v24.8, we can reproduce the issue. Found space loss when using Cell.setHtmlString function to set values.

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-46090

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.

3

@Thilakbabu ,

We are pleased to inform you that your issue has been resolved. The fix will be included in an upcoming release (Aspose.Cells v24.9) that we plan to release in the first half of September 2024. You will be notified when the next version is released.
Attached is the fixed result for your reference:
output.zip (6.0 KB)

1 Like
4

The issues you have found earlier (filed as CELLSJAVA-46090) have been fixed in Aspose.Cells for Java 24.9.