[SOLVED] GrapeCity SpreadJS Integration

Answered Closed

Good day,

I am trying to integrate SpreadJS of GrapeCity, I was able to run it but there is a problem when I tried to print, export, save, I think it has to do with the error in script during loading, I am attaching a sample project to demonstrate the issue, I tried to create a simple html file, everything is working, but when I embed it using widget, there is an issue.

Thanks.

Attachment

Error in SpreadJS and wisej.png

General

Glenn Gonzales asked Sep 13, 2019 - 3:24 pm
last edited Nov 22, 2019 - 2:42 am

You must login to post comments

Answers (6)

Best Answer

Glenn,

I checked your code. What data is intended to be loaded into the grid ?
This line in your Init function does not make sense to me, so I uncommented it:

// spread.fromJSON(dataSource);

The grid then opens empty, you can type in some value and to export them,
simply change your exportpdf function (see at the end of this message).

Here you can simple reuse the reference this._spread that you are setting in the Init function.
Hope that gets you started into the right direction and helps you to figure out the other functionality.

Best regards
Frank

.fctbNone{ color:#000000; }
.fctbStyle0{ color:#2e75b6; }
.fctbStyle1{ color:#a31515; }
 this._spread.savePDF(
            function (blob) {
                console.log(blob);
                saveAs(blob, 'download.pdf');
            },
            console.log,
            {
                title: 'Test Title',
                author: 'Test Author',
                subject: 'Test Subject',
                keywords: 'Test Keywords',
                creator: 'test Creator'
            });

Frank (ITG) answered Sep 18, 2019 - 11:12 am

- Glenn Gonzales
- Sep 28, 2019 - 1:02 am
Hi, Frank, I was able to run based on your recommendation, but I have noticed I cannot type space let say I will input “Sample word” it will be displayed as “Sampleword” that sample project has a sample index.html, if you run that and type “Sample word”, it will be displayed exactly as you typed. Thanks.

You must login to post comments

Yes, I have checked that, and I was able to run the grid, but only got the problem when I want to export, or print, or even convert to JSON. There was an error during load, which I already attached, and I also attached the sample project.