Spreadsheet shared region and cell permissions

A method for spreadsheet region and cell sharing permissions comprising:

• receiving a request to display a subset of a spreadsheet document, wherein the subset includes a formula, the formula referencing a cell outside the subset;
• determining, using a processor, whether to enable display access to the cell outside the subset of the spreadsheet document based at least in part on a set of user access descriptors for the cell outside the subset;
• in response to a determination that display access is enabled, providing data associated with the cell outside the subset of the spreadsheet document for display, wherein data associated with the cell outside the subset is displayed using a canonical name within the formula;
• and
• in response to a determination that display access is not enabled, providing an indication of access denial for display, comprising:
• determining that a shared user does not have access to the data associated with the cell outside the subset;
• and
• providing an opaque identifier for display within the formula for the data associated with the cell outside the subset, wherein the opaque identifier, based on a mapping of opaque identifiers and canonical names, is determined using the canonical name.

A computer program product for spreadsheet region and cell sharing permissions, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for:

• receiving a request to display a subset of a spreadsheet document, wherein the subset includes a formula, the formula referencing a cell outside the subset;
• determining, using a processor, whether to enable display access to the cell outside the subset of the spreadsheet document based at least in part on a set of user access descriptors for the cell outside the subset;
• in response to a determination that display access is enabled, providing data associated with the cell outside the subset of the spreadsheet document for display, wherein data associated with the cell outside the subset is displayed using a canonical name within the formula;
• and
• in response to a determination that display access is not enabled, providing an indication of access denial for display, comprising:
• determining that a shared user does not have access to the data associated with the cell outside the subset;
• and
• providing an opaque identifier for display within the formula for the data associated with the cell outside the subset, wherein the opaque identifier, based on a mapping of opaque identifiers and canonical names, is determined using the canonical name.