Excel Export - Gap Missing when using arrays of string in template

Aspose.Cells Product Family
1

While working with arrays, we are facing an issue in excel where the gap between different elements is maintained correctly for an array of objects, but not for an array of strings.
When using an array of objects, the template preserves the gap as expected. However, when using an array of strings, the gap defined in template is not being maintained.
Since it is working correctly with an array of Object, then expectation is that it should behave the same way for an array of string.

Have added example having scenario for that &=$node.VariableArray does not work like &=node.books.id in attached.
Attached:
Sample template file
Input Json
Generated output

Issue.zip (16.9 KB)

2

@geetha123,

Thanks for the sample Excel files and JSON data file.

I noticed the issue as you talked about. Could you please also share your sample (runnable) code that you are using. We will check it thoroughly and assist you soon.

3

@geetha123
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): CELLSNET-58685

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

Issue.zip (16.9 KB)

5

@geetha123
Thank you for your feedback. Sorry, the compressed file you uploaded is the same as the attachment you uploaded when creating the issue post. However, we have already created a ticket CELLSNET-5685, and we will notify you promptly once there are any updates. If you could upload the runnable test code again, it would be very helpful for us to fix and test issues.

6

@geetha123
test_template1.zip (15.7 KB)
Please check attached files which are generated by inner hot fix with the following codes:

 Workbook workbook = new Workbook(dir + "test_template1.xlsx");
 WorkbookDesigner workbookDesigner = new WorkbookDesigner(workbook);
 //workbookDesigner.ContainsVariables = true;
 workbookDesigner.SetJsonDataSource("node", File.ReadAllText(dir + "test_template-001-data.json"));
 workbookDesigner.Process();

 workbook.Save(dir + "dest.xlsx");
7

The output looks good. Could you please help me with the details on when this feature will be released and made available?

8

@geetha123,

Thank you for your feedback. The enhancement is planned for Aspose.Cells v25.7, expected around July 10-15, 2025. We’ll notify you upon release.