GridJsWorkbook.ExportToJson produces invalid json

Aspose.Cells Product Family
1

It seems that GridJsWorkbook.ExportToJson fails to escape activex shape contents properly, resulting in json like "rg":"C:\path\to\file". Even though we don’t care about activex shapes, such json cannot then be parsed.

Sample code

        GridJsWorkbook jsWorkbook = new GridJsWorkbook();
        jsWorkbook.ImportExcelFile(documentId, workbook);
        json = jsWorkbook.ExportToJson();
        JObject root = JObject.Parse(json); // <-- exception here
2

I’m happy to attach a sample file, but the ui won’t let me. “Sorry, the file you are trying to upload is not authorized (authorized extensions: jpg, jpeg, png, gif, zip, pdf, docx, 7z).”

3

@nikitar
We need the file for investigation, please zip it first, then you can upload it.
Please have a try.
Thanks.

4

A small reproducible example (contains a single activex shape and nothing else)
test3.xlsx.zip (10.3 KB)

5

@nikitar
Thanks.
We can reproduce this issue. We will fix it soon. 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): CELLSGRIDJS-1283

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.

6

The issues you have found earlier (filed as CELLSGRIDJS-1283) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi