Cannot read properties of null (reading openSettings)

[Serhii Olishevskyi]

Hello,

From time to time I get this error message:

Uncaught runtime errors:

×

ERROR

Cannot read properties of null (reading 'openSettings')

TypeError: Cannot read properties of null (reading 'openSettings')

at https://document.e-contentum.com/static/js/bundle.js:569508:91

The error occurs when loading a file into the editor. There is no particular order in which it occurs. Excel files also cause this error in different ways.

Information from the browser console:

at open.js:109:1

Promise.catch

node_modules\@syncfusion\ej2-spreadsheet\src\workbook\integrations\open.js

Attachment: image_e91e8525.zip

[Babu Periyasamy]

Hi Serhii Olishevskyi,

We have validated your query based on the details you provided. The issue "Cannot read properties of null (reading 'openSettings')" occurs only when openSettings is null. However, in our Spreadsheet, the openSettings property is set to an empty object by default. For reference, please find the below screenshot.

To further investigate your issue, we need additional information. Please provide the following details:

1. Explain how you are importing the file into the Spreadsheet, whether you are using the Open option in the File menu or using the open method.
2. If you have applied any customizations before opening the Excel file, please share those details along with the relevant code snippets.
3. Provide the complete Spreadsheet rendering code snippet, including any customizations.
4. If the issue occurs with a specific Excel file, please share the file with dummy data.
5. List the features used in the imported file, such as cell formatting, freeze panes, filtering, data validation, conditional formatting, etc. This will help us recreate the file on our end and verify the issue.
6. If possible, share a video demonstration of the issue.

Please share the above requested details from your end. Based on that, we will validate and update you with further details.

Regards,

Babu.

[Serhii Olishevskyi]

Hi,

The error message only appears in development mode. When the React application is launched in production mode, there is no error.

The error that I showed on the screen earlier can be caused by refreshing the bookmark in the browser several times in a row. Any browser.

Attachment: excel_d86b7d3e.zip

[Deira Raj Rajkumar]

Hi Serhii Olishevskyi,

We have reviewed your query and attempted to replicate the issue on our end. However, we were unable to reproduce it. We used your code snippet to render the spreadsheet and substituted default code where necessary (in cases where your intent was unclear). Despite this, the issue did not occur.

In your query, you mentioned that you are facing this issue in development mode. We suspect that the issue occurs on the client side while initiating the open process. In our latest release, we introduced a new property, openSettings, and the error you encountered appears to be due to this property being missing. By default, it should have an empty object as its value. However, during the initial rendering, this property was not properly initialized.

To resolve this issue, we recommend setting the openSettings property to an empty object.

For your reference, we have attached the sample we used to replicate the issue on our end, along with a video demonstration showing that the issue does not occur on our side.

Code snippet:

      <SpreadsheetComponent

          OpenSettings={}

        }}>

      </SpreadsheetComponent>

If you are still facing this issue kindly share the client-side package version you are using on your end. This would allow us to investigate and provide the solution ASAP.

Please get back to us if you have any other concerns.

With regards,

Deira Raj Rajkumar.

Attachment: Forum_c6f3cb20.zip