Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

Document Management in the Spreadsheet

The Spreadsheet control always contains a document. When you open a document, the control loads it to storage in the web server’s memory (RAM). This storage is a static dictionary inaccessible to developers.

The Spreadsheet uses unique strings to identify documents in the storage. The way a document gets its identifier depends on the document source:

  • When you open a document from a file system, the control uses the physical path to this document as the identifier.
  • When you open a document from a byte array or stream, you pass an identifier as a method parameter.
  • A new document has an empty identifier. Generate a unique string identifier for the new document to be able to save pending changes.

The document remains in server memory until one of the following events:

  • Your code closes the document.
  • The server is restarted. Until this event, the document takes up memory even if this document is not being used for a long time.
  • The DocumentManager hibernates the document. Enable document hibernation to reduce server memory consumption and prevent the loss of unsaved changes when the server is restarted.