SpreadJS Out Of Memory Exception (Spread.Sheets Library 11.2.4) + Angular 6

Posted by: venkat on 22 April 2019, 4:40 pm EST

venkat
- Post Options:
- Link
  Copy
Posted 22 April 2019, 4:40 pm EST
We have using SpreadJS 11.2.4 with Angular 6 version , we have huge data bind to spread it includes near about 20+ sheets(rows: 200+, columns : 50+ ) and formatting like background color, font bold Italic etc…

We are saving this spreadjs JSON data in compressed format in our DB and fetching this data and binding to spread by using fromJSON method.

while binding JSON data to spread we observed memory usage of RAM increased by 500-600 MB.

if we bind spread again then memory not released and again 500-600 MB memory of RAM used.

When memory increased up to 2GB+ that time browser crashed and out of memory message got.

OS: Windows 7, 8, 10

RAM : 4GB, 8GB

Browser :Chrome (latest version).

Because of these issues our clients not able to use application. Can you please suggest solution for this case.

Regards,

Umesh
sharad.tomer
- Post Options:
- Link
  Copy
Posted 24 April 2019, 4:27 pm EST - Updated 3 October 2022, 1:50 am EST

Hi,

We are sorry but we are unable to replicate the issue at our end. In our test on the initial import memory usage is increased to ~90M to ~110M and thereafter on each successive import of the same file memory usage remains to be constant around ~110M. I have attached a recording of the result during our test. Please refer to it and let us know if you would like us to test with some other sheet. If the issue persists please share a small sample replicating the issue so that we could investigate the issue.

Regards
venkat
- Post Options:
- Link
  Copy
Posted 24 April 2019, 5:34 pm EST
Hi Sharad,

Thanks for your reply , please try with

20+ sheets ,rows: 200+, columns : 50+

having numbers in each cell and formulas

having formatting like background color, font bold Italic , background image etc…

Let me know in case of any other info.

Regards,

Umesh
sharad.tomer
- Post Options:
- Link
  Copy
Posted 25 April 2019, 11:33 pm EST

Hi Umesh,

Thanks for the additional info. We are able to replicate the issue at our end and hence we have forwarded it to the concerned team for further investigation. We will let you know about any updates regarding the issue.

Regards
venkat
- Post Options:
- Link
  Copy
Posted 28 April 2019, 5:01 pm EST

Hi Sharad,

Thanks for your reply , we are eagerly waiting for solution for above issue. Please update us as soon as possible.

Regards,

Umesh
sharad.tomer
- Post Options:
- Link
  Copy
Posted 28 April 2019, 5:54 pm EST

Hi,

The internal tracking ID for the issue is #272119.

Regards
venkat
- Post Options:
- Link
  Copy
Posted 5 May 2019, 9:50 pm EST

Hello Sharad,

Till the time you guys resolve issue and release, can you suggest where to catch this error in some function so that we will at least warn or show message to user.

Waiting for reply.
sharad.tomer
- Post Options:
- Link
  Copy
Posted 6 May 2019, 4:44 pm EST

Hi Umesh,

DevTeam has identified that the memory leakage is due to the use of removeSheet() method. It removes the sheet from the workbook but doesn’t dispose the sheet so that it could be added again(if required).

Could you please confirm if the issue resolves for you if you don’t use the removeSheet() method? Also, if it resolves the issue could you please let us know your requirement with the use of removeSheet() method so that we could try to find a workaround till the devTeam fixes the issue.
venkat
- Post Options:
- Link
  Copy
Posted 9 May 2019, 12:16 am EST

Hello Sharad,

Thanks for your reply, i think your team used removeSheet() internally while rebinding spread , our issue is when we binding JSON data to spread memory usage increasing , that time we have not used removeSheet() method. Also in our application we are not using removesheet() method explicitly on any button click. If your internal logic is based on removeSheet() method then you need to handle this issue and give us new version of spread.

Let me know if you want any extra things. I don’t thing this work around will help us.

Regards,

Umesh
sharad.tomer
- Post Options:
- Link
  Copy
Posted 9 May 2019, 8:43 pm EST

Hi Umesh,

DevTeam has fixed the issue in the internal build. Fix will be included in the next stable release.

Regards
venkat
- Post Options:
- Link
  Copy
Posted 15 May 2019, 5:32 pm EST

Hi Sharad,

We are waiting for your next stable release, let us know when it will release?

Regards,

Umesh
sharad.tomer
- Post Options:
- Link
  Copy
Posted 21 May 2019, 11:15 pm EST

Hi Umesh,

Spread v12.1.1 has been released which includes the fix for the issue. Please update to the latest version and let us know if the issue still persists for you.

You may download the latest build(12.1.1) from the following link:

http://cdn.grapecity.com/spreadjs/12.1.1/Files/SpreadJS.Release.12.1.1.zip

Regards

venkat

Post Options:
Link
Copy

Posted 28 May 2019, 1:43 am EST

Hi Sharad,

We tried latest version 12.1.1 in our angular 7 project by using following commands in our existing project,

npm install @grapecity/spread-sheets@latest

npm install @grapecity/spread-sheets-angular@latest

but got error while running project.

vendor.js:57516 ERROR Error: Uncaught (in promise): TypeError: Cannot read property 'zR' of undefined
TypeError: Cannot read property 'zR' of undefined
    at oa.dispose (:4200/core-core-module.js:146925)
    at Function.a.ao (:4200/core-core-module.js:146903)
    at oa.no (:4200/core-core-module.js:146908)
    at Z (:4200/core-core-module.js:146904)
    at M (:4200/core-core-module.js:146904)
    at :4200/core-core-module.js:146904
    at a (:4200/core-core-module.js:146904)
    at d (:4200/core-core-module.js:146904)
    at oa.i.Worksheet.ad (:4200/core-core-module.js:146904)
    at new oa (:4200/core-core-module.js:146907)
    at resolvePromise (polyfills.js:3153)
    at resolvePromise (polyfills.js:3110)
    at polyfills.js:3214
    at ZoneDelegate.push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invokeTask (polyfills.js:2745)
    at Object.onInvokeTask (vendor.js:59082)
    at ZoneDelegate.push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invokeTask (polyfills.js:2744)
    at Zone.push../node_modules/zone.js/dist/zone.js.Zone.runTask (polyfills.js:2517)
    at drainMicroTaskQueue (polyfills.js:2923)
defaultErrorLogger @ vendor.js:57516

Can you please help how to solve this error. Let me know what is missing, waiting for your reply.

sharad.tomer
- Post Options:
- Link
  Copy
Posted 28 May 2019, 6:02 pm EST

Hi Umesh,

We are sorry but we are unable to replicate the issue at our end. Here are our implementation steps:

• Create a sample angular app using angular CLI

• Install spread-sheets and spread-sheets-angular

• Import SpreadSheetsModule into our main module

• Add a sample gc-spread-sheets component and some data and chart to the sheet

• start the app using ‘npm strart’ command.

Please let us know if there are any additional steps to replicate the issue. You may also share a sample replicating the issue for us to investigate.
venkat
- Post Options:
- Link
  Copy
Posted 30 May 2019, 12:05 am EST - Updated 3 October 2022, 1:50 am EST

Hi Sharad,

We tried latest version 12.1.1 in our angular 7 project by using following commands in our existing project,

npm install @grapecity/spread-sheets@latest

npm install @grapecity/spread-sheets-angular@latest

got this error : “Invalid license key.” Please check attached error image.

Can you please help how to solve this error. Let me know what is missing, waiting for your reply.

1366×584 11.5 KB
sharad.tomer
- Post Options:
- Link
  Copy
Posted 30 May 2019, 4:05 pm EST

The issue arises when we enter an invalid license key. Please make sure that the licence key you are using is a valid one.

If the issue persists, please create a support ticket on our private support portal https://supportone.componentone.com/ and share the licence key that you are using so that we could further investigate the issue.

Please login to reply to thread

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels

ComponentOne

Forums for all current editions of the ComponentOne .NET UI control product line, including ComponentOne Studio and ComponentOne Studio for Xamarin.
ActiveReports

Forums for all versions of ActiveReports and ActiveReports Server
Spread

Forums for all current versions of Spread .NET spreadsheets, SpreadJS JavaScript spreadsheets, and SpreadCOM spreadsheets.
Wijmo

Forums for all Wijmo products, including Wijmo Core, FinancialChart, FlexSheet, MultiRow, OLAP, and ReportViewer
- General Discussion
Document Solutions

Forums for all Document Solutions products, including Document Solutions for PDF, Word, Excel (.NET and Java), and Imaging.