"horizontal" parameter is not working as per expectation

Aspose.Cells Product Family
,
1

Hi, we wanted to populate data horizontally for a specific array. So we used a horizontal parameter, but it is not working as expected. Please check the attachment. Thanks
horizontal.zip (15.8 KB)

2

@pgcentric

It seems you’re experiencing issues with populating data horizontally in your Excel worksheet using Aspose.Cells. To assist you effectively, please ensure that you are correctly implementing the logic for setting data horizontally in your code.

Here’s a basic example of how to populate data horizontally in a worksheet:

using Aspose.Cells;

public void PopulateDataHorizontally(Workbook workbook, string[] data)
{
    Worksheet worksheet = workbook.Worksheets[0];
    for (int i = 0; i < data.Length; i++)
    {
        worksheet.Cells[0, i].PutValue(data[i]); // Populate data in the first row
    }
}

Ensure that the data array is correctly populated and that you are referencing the correct worksheet. If the issue persists, please provide more details about how you are using the horizontal parameter, and I can help troubleshoot further.

Feel free to share any specific code snippets or error messages for more targeted assistance!

3

@pgcentric,

Thanks for the template Excel file and JSON data.

I tested your scenario/case and I reproduced the issue as you mentioned by using your template Excel file with JSON file. I found “horizontal” parameter of Smart Markers is not working as per expectation when using with specific array in JSON data. If we remove the parameter, it works fine.

Workbook workbook = new Workbook("d:\\files\\horizontal\\matrix_placement1.xlsx");
WorkbookDesigner workbookDesigner = new WorkbookDesigner(workbook);
String jsonData = new String(Files.readAllBytes(Paths.get("d:\\files\\horizontal\\matrix-placement.json")));
workbookDesigner.setJsonDataSource("node", jsonData);
workbookDesigner.process();

workbook.save("d:\\files\\horizontal\\out1.xlsx");

We require thorough evaluation of the issue. 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-46503

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.

4

@pgcentric,

We are pleased to inform you that your issue (Ticket ID: “CELLSJAVA-46503”) has been resolved. The fix/enhancement will be included in the upcoming release (Aspose.Cells v25.10) that we plan to release in the first half of October 2025. You will be notified in this thread once the new version is published.