Hi Team, we are using Aspose word java LINQ Engine syntax (version : 24.1) for our use case and using JSON as a Data source but its not working as expected against some Numeric values like : (11.09,9.11 and etc) which matches with date certain numeric values in our json and our json mixed of string and numeric values. So Assist us on that
Attaching few testing template,json file and error message for your reference
test-dcouments.zip (37.2 KB)
@anupkrsinha
Applying of a numeric format to all values - some of which are not numbers - is not possible. LINQ Reporting Engine correctly recognizes this situation and raises an error. This is expected behavior rather than a bug.
The best way to fix the issue would be getting rid of mixed-typed object properties. If this is not possible, please share your expected output document for the JSON file provided.
@anupkrsinha Thank you for additional information. We will check the issue and get back to you soon.
@anupkrsinha
Please check modified_template.docx (14.4 KB).
Please also note that disabling of date-time parsing is required in this case. This can be done as follows:
ArrayList<String> formats = new ArrayList();
JsonDataLoadOptions options = new JsonDataLoadOptions();
options.setExactDateTimeParseFormats(formats);
JsonDataSource dataSource = new JsonDataSource(..., options);
See Accessing JSON Data for more information.